Raw sources

Raw sources (bronze)

Rows from every feed, stored exactly as received. Normalisation happens in the silver layer, where each change is flagged.

ENREnrollment
43,101
raw rows
Usable
42,871
Flagged
84%
No member ID
2%
Linked
29,405
First seen
2026-01-01
Last seen
2026-10-18
CLMClaims
32,829
raw rows
Usable
32,674
Flagged
74%
No member ID
35%
Linked
30,209
First seen
2026-01-01
Last seen
2026-10-18
TPAThird-party administrator
14,474
raw rows
Usable
14,404
Flagged
77%
No member ID
85%
Linked
11,671
First seen
2026-01-01
Last seen
2026-10-18
PRVProvider network
9,596
raw rows
Usable
9,546
Flagged
80%
No member ID
50%
Linked
8,676
First seen
2026-01-01
Last seen
2026-10-18

Raw events

Enrollment only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1166652026-10-18T05:52:00ZPierce, Jacob——1950-04-11··UHC3929412•••-••-9777·6216545488-3638 HILLCREST RDMesa··AZ85229GRP-6989MEDICARE-ADV-B
ENRENR-1159372026-07-12T23:25:18ZBurke, KevinQ—0077-19-42UHC-90271-70•••-••-2710(736) 374-1120KEVIN.BURKE21@AOL.COM7399 Church StreetDENVERCO80246GRP-7430CORE-HMO
ENRENR-1258692026-04-03T14:30:57Znicole—woods1980-02-02UHC-75934-69•••-••-2162·(895) 211-4696nicole.woods57@hotmail.com·6428 MESA DRChandlerAZ85222GRP-3400OPTIONS-PPO
ENRENR-1019452026-01-05T00:34:23ZAngela—Hawkins1945-03-25UHC-87699-01UNKNOWN+1 572 897 7358N/A6764 Ocean Ave Apt 15Los Angeles·CAN/AGRP-6285OPTIONS-PPO
ENRENR-1377602026-01-20T22:27:18ZMADISON—HALL··11/26/1998UHC-47979-10—+1 584 948 3336madison.hall23@yahoo.com2918 Meadow LnHouston··TX77078GRP-0411SELECT-EPO
ENRENR-1017102026-02-03T00:06:49ZJACK—SNYDER1959-08-22UHC-73245-58•••-••-98852226412889jack.snyder@aol.com5758 GRAND AVEPhoenixAZ85052GRP-3515SELECT-EPO
ENRENR-1237482026-03-02T21:32:20ZALAN—TAYLOR1989-01-21·UHC-11805-29•••-••-4460(264) 728-1586alan.taylor69@hotmail.com8147 FOREST AVECOLUMBUSOHUNKNOWNGRP-4274OPTIONS-PPO
ENR ENR-1107712026-01-08T18:22:15ZCARLOS··TGONZALEZ05/14/1954UHC0555941N/A439-862-9753carlos.gonzalez@yahoo.com7532 Main StSacramentoCA··95809GRP-5204OPTIONS-PPO
ENRENR-1206312026-07-23T19:05:47Z·Chris—Valdez1942-10-24UHC-97505-59—4996053513null220 PINE DRSeattleWashington98107-7444GRP-1188CORE-HMO
ENRENR-1211712026-03-24T02:28:20ZNOAHRPANA1965-08-23UHC-64478-55•••-••-375113585255633NOAH.PENA@AOL.COM783 PALM DRIVETempeaz-GRP-4611CHOICE-PLUS-PPO
ENRENR-1216642026-07-25T10:31:27ZValdez, George——nullUHC-03628-68•••-••-0539(507) 400-6772·null7536 Pine DriveGlendaleAZ85328GRP-9188NAVIGATE-HMO
ENRENR-1421012026-07-06T06:25:01ZRose··—Kren1993-11-16UHC-41271-45——karen.rose@proton.me1976 WILLOW COURTLas VegasNV89101GRP-5524OPTIONS-PPO
ENRENR-1336922026-10-04T15:34:43ZTheresa—Olson1996-07-03UHC-42656-48•••-••-77339369272147THERESA.OLSON@HOTMAIL.COM9830 BROADWAYHoustonTX77004GRP-2612·MEDICARE-ADV-A
ENRENR-1350842026-03-29T14:37:32ZDelgado, Donna——1939-08-03uhc-28789-87•••-••-20055519259954DONNA.DELGADO@AOL.COM8190 Desert Sky Blvd·SeattleWashington98110GRP-9769NAVIGATE-HMO
ENRENR-1061942026-08-10T18:20:59Zjoseph—obrian10-10-1978UHC-03406-45•••-••-4199(674) 927-9236NULL1682 Sage CourtOrlandoFL32897GRP-2985OPTIONS-PPO
ENRENR-1160832026-04-03T11:43:06ZJULIAZ.DUNN1940-03-18UHC-20537-59•••-••-58575809352925julia.dunn@hotmail.com4390 DESERT SKY BLVDMinneapolisMN55489··GRP-9858MEDICARE-ADV-B
ENRENR-1001722026-08-02T23:10:42ZAlexander, JasonA—1980-11-03UHC-25888-14•••-••-6177404-872-7949jason.alexander@outlook.com615 Bayshore DriveSan DiegoCA92167GRP-8108OPTIONS-PPO··
ENRENR-121094 2026-10-01T13:29:54ZJeremy·SKennedy1986-11-06UHC-16281-30•••-••-4954382-568-1304jeremy.kennedy@hotmail.com··1682 Main StMiamiFL33181GRP-5920OPTIONS-PPO
ENRENR-1107782026-02-12T02:47:51ZKelly, KennethE—19660627UHC-11325-94•••-••-44904895881399kenneth.kelly@hotmail.com6640 Indian School RdTucsonAZ85722GRP-3199CHOICE-PLUS-PPO
ENRENR-1321432026-02-27T06:43:19ZPhilip—Maldonado1995-01-07UHC-05637-01UNKNOWN2824773887philip.maldonado@outlook.com7707 Palm DrTEMPEArizona85228GRP-4713CHOICE-PLUS-PPO
ENR ENR-1203802026-09-02T04:16:23Z·MICHAELO.HUDSON1939-09-25UHC-30221-14•••-••-4769N/Anull··6849 River RdLos AngelesCA90039GRP-8912SELECT-EPO
ENRENR-1258292026-01-22T15:04:31ZJess··Stewart··2/8/1938··UHC-88686-03·N/A338-761-0413JESSICA.STEWART@OUTLOOK.COM2862 Mountain View DrColumbusOH43256GRP-3298CHOICE-PLUS-PPO
ENRENR-1200862026-06-28T01:25:34ZJACKIE—HANEN12/04/1978····•••-••-24286564710·JACQUELINE.HANSEN@OUTLOOK.COM9569 Desert Sky BoulevardNASHVILLETN37294GRP-3773SELECT-EPO
ENRENR-1379052026-07-22T08:12:12Zjenniifer—rice08/11/60··UHC-97823-79—883-795-4816jennifer.rice38@hotmail.com4784 Park PlDenverCO80256··GRP-7255MEDICARE-ADV-A
ENRENR-1154652026-07-17T12:54:09Z MelissaCStephens··0043-20-05NULL•••-••-0559632-631-1041—2913 Sunset BoulevardJacksonvilleFL32280··GRP-6950CORE-HMO
ENRENR-1099212026-08-11T04:26:51ZJEREMY··—MUNOZ19940622UHC-03662-51··NULLN/Ajeremy.munoz73@hotmail.com3842 Park PlEDEN PRAIRIEMN55321GRP-6482MEDICARE-ADV-B
ENRENR-1065852026-08-26T15:37:49ZBRUCEMBOWMAN1939-02-28UHC-63573-13•••-••-85237594929949BRUCE.BOWMAN@YAHOO.COM3068 PINE DRIVE·GilbertAZ85240GRP-6969MEDICARE-ADV-A
ENRENR-1022332026-08-01T02:26:33ZjacquelineOtaylor··Oct 27, 1976UHC-96049-80—(762) 728-9069-2794 OAK STHoustonTX77014GRP-6789CHOICE-PLUS-PPO
ENRENR-1124302026-07-12T13:26:35Zbobby—hernandez19740703·UHC-97966-71•••-••-09283022428803-6500 Harbor BoulevardOrlandoFlorida32849-8679··GRP-1472··CORE-HMO
ENRENR-1428832026-10-07T04:52:57ZJacob P—WagnerNov 1, 1939UHC-00451-03•••-••-93993115156824jacob.wagner@yahoo.com·3494 PINE DRIVEMinneapolisMN55406GRP-8750MEDICARE-ADV-A
ENRENR-1395502026-04-08T16:01:38ZBarb—Rodriguez1493-10-05UHC-75032-93•••-••-4816—N/A1117 Ridge RoadPhoenixAZ85068GRP-9978OPTIONS-PPO
ENRENR-1363892026-07-31T14:32:42ZAndreaA.·Wagner·02/15/1940UHC-53110-13•••-••-0536N/Aandrea.wagner71@yahoo.com7893 Cedar LnGLENDALE·AZ85332GRP-6663NAVIGATE-HMO
ENRENR-1179012026-06-29T21:18:42ZYUKI—MOREON19650911UHC-18359-83•••-••-6495UNKNOWN—851 Market StPlanoTXN/AGRP-8418SELECT-EPO
ENRENR-1239602026-06-02T18:24:18ZJasonJMurphy09/21/1996UHC-15372-66•••-••-9353—jason.murphy@gmail.com239 CHURCH STNashvilletn37253-3966GRP-0826OPTIONS-PPO
ENRENR-1170492026-08-24T00:41:29ZkatherineGdixonJul 28, 1989UHC-09672-15•••-••-9689(500) 710-3246·katherine.dixon41@outlook.com9088 Union StSan DiegoCA92189GRP-1423SELECT-EPO
ENRENR-1345932026-07-11T06:27:52ZPAULJESTRADA·1981-06-25UHC-79041-01··•••-••-3355204.447.6395paul.estrada@aol.com6839 VALLEY VIEW DRMesaaz85204GRP-8469··SELECT-EPO
ENRENR-1317632026-07-18T20:07:54ZJohn··Rice2000-08-08UHC-94612-64•••-••-3752—john.rice15@aol.com9658 ELM STOrlandoFL32827GRP-7299MEDICARE-ADV-B
ENRENR-1218292026-02-23T14:38:02ZhelenQramoos1993-04-23UHC-01503-78•••-••-6354527.479.9659HELEN.RAMOS82@GMAIL.COM5362 Grand AvenueSacramentoCA··95836GRP-1542MEDICARE-ADV-B··
ENRENR-1335982026-03-24T09:05:05ZMadisonGFranklin1943-01-01UHC-75922-94•••-••-386612334260479—1042 Spring StLas VegasNV89111GRP-0844·CORE-HMO
ENRENR-1133682026-10-07T09:52:13ZMATTHEW—MASON·1975-11-09UHC3803876•••-••-2014UNKNOWNUNKNOWN1967 Indian School Road·FresnoCalifornia93738GRP-7346CHOICE-PLUS-PPO
ENRENR-1157922026-08-08T14:46:38ZMariaanG··Riley1995-06-25UHC-27492-53•••-••-76282787018958—5620 Valley View Drive #390GilbertArizona85263GRP-3054MEDICARE-ADV-B
ENRENR-1283352026-07-23T07:17:33ZMyers, JanetW—1974-03-13UHC-74387-24··•••-••-5176754.314.4225JANET.MYERS82@AOL.COM2841 Sage Court··GilbertAZ85247GRP-7913CHOICE-PLUS-PPO
ENRENR-1324502026-10-17T21:10:12ZMeyer, Elizabeth··——1961-06-14UHC3379496•••-••-3854—····6250 GRAND AVENUESCOTTSDALEAZ85278GRP-0226NAVIGATE-HMO
ENRENR-1285962026-03-28T13:46:20ZMartha—Morgan6/22/1992UHC-03091-21··•••-••-694818106914930martha.morgan29@hotmail.com9387 ELM STDenver·CO80249GRP-9145MEDICARE-ADV-A
ENRENR-1219552026-08-07T18:56:50ZKELLYVESPINOZA11/27/1999UHC-28597-91•••-••-1613+1 339 870 9158kelly.espinoza@aol.com2936 Canyon Road··SacramentoCA95858-0014GRP-6859CORE-HMO
ENRENR-1245552026-04-01T18:11:29ZSean—Montgomery1939-06-25UHC-97339-65-+1 794 925 3606sean.montgomery@icloud.com284 Jefferson AveCharlotteNC··28298GRP-4664SELECT-EPO
ENRENR-1110122026-05-12T05:10:37ZHolmes, JanetC.—2001-05-05UHC-27263-09•••-••-86027608132571JANET.HOLMES83@HOTMAIL.COM5096 River RdLas VegasNV89148GRP-6877·MEDICARE-ADV-B
ENRENR-1378942026-03-19T11:16:12ZJoeRStephens19790704UHC6620652•••-••-012114637402306joe.stephens@icloud.com2551 Maple Avenue··Tucsonaz85745GRP-9654CORE-HMO
ENRENR-1014162026-05-27T05:06:23ZMurphy, MarthaC—1950-02-01UHC-96988-57•••-••-4635618-776-0369—8376 CAMELBACK ROAD·ScottsdaleArizona85232GRP-2962CORE-HMO
ENRENR-1351882026-01-28T10:51:20ZRichardBNelson··1997-12-14UHC-09848-35•••-••-26484320063richard.nelson@aol.com4440 Jefferson Avenue··ATLANTAGA30327GRP-8132choice-plus-ppo
43,101 rows, page 326 of 863PreviousNext

Bronze layer rules

What is guaranteed for downstream layers

  • As received
    Values are stored exactly as the feed delivered them, including whitespace, inconsistent casing and placeholder tokens such as NULL or N/A.
  • No transformation
    Bronze is never edited in place. Every fix lives in silver and is traceable back here by record ID.
  • Line number preserved
    The line number records each row's position in the source file, so a value can be located in the original extract.
  • Load timestamp
    The load timestamp marks when the row landed in the lakehouse; this batch landed 2026-10-22T12:42:43.621Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty