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-1403492026-04-03T16:46:22ZJudyTKnight—uhc-66791-46·null·621.349.8511judy.knight93@hotmail.com1771 RIDGE ROAD·SCOTTSDALEAZ85284GRP-3235SELECT-EPO
ENRENR-1416812026-09-04T21:51:28ZJOE—MATTHEWS22-06-1967UHC-59785-40null-null7710 BroadwayATLANTAGA—GRP-9036MEDICARE-ADV-A
ENRENR-1365562026-03-10T02:11:34Z·AnaYBarnes1983-04-19UHC-47145-41•••-••-6267N/AANA.BARNES@HOTMAIL.COM4649 PINE DR Apt 10··ColumbusOH43286·GRP-4899MEDICARE-ADV-B··
ENRENR-1219392026-05-03T12:36:53ZCamila—Romero04/20/41··UHC-45685-14•••-••-6707(396) 804-7708camila.romero45@aol.com6264 Forest AveTampaFlorida33674··GRP-3049CORE-HMO
ENRENR-1257072026-02-14T10:42:05ZGABRIELZ.WARD·1943-02-02UHC-91327-36•••-••-5431330-701-3173gabriel.ward62@outlook.com998 Pine DrSan AntonioTX78250GRP-0276NAVIGATE-HMO
ENRENR-1304162026-03-09T12:44:07ZDonnaSRice1949-11-17UHC-89345-39•••-••-5065839-773-7615NULL7748 BASELINE ROAD·GLENDALEaz85314GRP-6516SELECT-EPO
ENRENR-1093482026-01-05T12:37:17Z·RYANM··DUNCAN20021120UHC-30657-74N/A··500-236-3668ryan.duncan@yahoo.com8674 Willow Ct··PlanoTX-GRP-3170CHOICE-PLUS-PPO
ENR ENR-1197742026-03-02T06:19:36ZRobertson, JoyceN—1968-07-26UHC-92098-81··•••-••-5631(663) 767-3916N/A174 CANYON RDCharlotteNC28208GRP-3418CHOICE-PLUS-PPO
ENRENR-1348422026-10-18T13:08:49ZAlanP.Holmes—UHC3203580•••-••-79345982509524alan.holmes@icloud.com4324 Baseline RoadMesaAZ85275GRP-5011MEDICARE-ADV-A
ENRENR-1008832026-07-16T13:29:47ZJUDITTH—CLARK2005-08-21UHC-45844-31-8234827-1289 Elm StJACKSONVILLEFL32201GRP-7581NAVIGATE-HMO
ENRENR-1018492026-10-12T19:40:42ZMurphy, Stephen——11/09/92UHC-54490-83•••-••-4779234-538-4671stephen.murphy32@hotmail.com2604 River RdEden PrairieMN·-GRP-9148CHOICE-PLUS-PPO
ENRENR-1374702026-07-27T02:41:22ZMATTHEWD.SHWA-UHC-20965-71··•••-••-83916278473968MATTHEW.SHAW@AOL.COM1303 OCEAN AVEFresnoCA93793··GRP-3370OPTIONS-PPO
ENRENR-1153212026-06-25T18:42:53ZSusanEColeman1952-10-13UHC-57625-86•••-••-2138348-477-0801—355 Mountain View Dr·TempeAZ85208GRP-0741CHOICE-PLUS-PPO
ENRENR-1394792026-09-25T11:26:48ZJason—Smmith1972-06-13UHC-71718-91•••-••-0774255-509-5294JASON.SMITH@GMAIL.COM6480 River RoadGlendaleAZ85315GRP-3630NAVIGATE-HMO
ENRENR-1382152026-01-11T13:34:04Z CamilaNRios1963-11-18UHC-12493-59··•••-••-37342228906829·CAMILA.RIOS@PROTON.ME3286 Indian School RoadTempeAZ85295GRP-1346core-hmo
ENRENR-1317432026-02-23T17:02:43ZSalazar, William——1969-07-12UHC-91974-52•••-••-9878225-924-8488william.salazar87@outlook.com4437 Valley View DriveNashville··Tennessee—GRP-8327CORE-HMO
ENRENR-1353862026-09-03T22:47:25ZMarthaP.Jenkins19870115·UHC-38108-73•••-••-3312294-476-9082MARTHA.JENKINS55@ICLOUD.COM8650 Apache BlvdSacramentoCA95821GRP-5107CORE-HMO
ENRENR-1346232026-06-03T17:47:08ZAnnaFMurray8/4/1999·UHC-80172-35•••-••-2701571.906.0986UNKNOWN7304 Highland AveATLANTAGeorgia30376GRP-8638MEDICARE-ADV-A
ENRENR-1247282026-01-12T13:08:06ZdonaldH.burton··1973-02-10UHC-51875-33•••-••-5247UNKNOWNdonald.burton@aol.com8911 Sunset Boulevard·Houston·tx77089GRP-1337SELECT-EPO
ENR ENR-1209392026-09-22T16:10:55Z DENISEMCOX19771017UHC-00474-84•••-••-4113(944) 240-3137null5177 VALLEY VIEW DRIVELas VegasNV89165GRP-4069MEDICARE-ADV-A
ENRENR-1328342026-03-14T07:22:55ZLOGAND.DAVIS12/05/1975UHC-19058-33•••-••-07399412123448NULL5042 Main St·DallasTX··75236GRP-9985CORE-HMO
ENRENR-1376612026-08-15T19:57:05ZBettyUMendoza20080514UHC-11236-54•••-••-2254+1 868 740 8613N/A4088 Grand Avenue #517SacramentoCA95876GRP-1475NAVIGATE-HMO
ENRENR-1133702026-03-23T09:39:03ZHoffman, PatrickJ.—Nov 21, 1960UHC-10829-67•••-••-5351(315) 352-8761patrick.hoffman@aol.com2406 Forest AvenueSAN DIEGOCA92106GRP-4261CORE-HMO··
ENRENR-1393492026-09-28T11:55:55ZJULIAZNELSON11-06-1997UHC-55618-44•••-••-7296(814) 213-5020julia.nelson75@aol.com6787 Maple AvenueTucsonAZ85792··GRP-9185CHOICE-PLUS-PPO
ENRENR-1318312026-04-27T12:57:35ZKeith—·FisherJun 18, 1963UHC-31886-13UNKNOWN743-911-3686keith.fisher72@outlook.comnull·nullUNKNOWNUNKNOWNGRP-8393navigate-hmo
ENRENR-1045872026-08-30T16:08:21ZBECKY—WEST1951-05-23UHC-32690-49····(271) 363-4673rebecca.west92@yahoo.com1859 MAPLE AVENUE·CharlotteNC28290GRP-2170CORE-HMO
ENRENR-1140492026-06-14T18:24:19ZDanielle—Parker1983-08-19UHC9214117•••-••-5838+1 784 689 9027danielle.parker@proton.me3347 Maple AveSan DiegoCA92176··GRP-6266OPTIONS-PPO
ENRENR-1151232026-08-16T05:35:46ZFrancesP.Meyer·1996-08-21UHC-29846-75•••-••-9249+1 517 773 0037frances.meyer@gmail.com4125 Apache BlvdTempeAZ85272GRP-0644MEDICARE-ADV-B
ENRENR-1027392026-04-03T13:46:51ZLINDALHARRIS19830320UHC-22013-65•••-••-2005·(975) 761-7358LINDA.HARRIS@HOTMAIL.COM5910 Mountain View DriveDenverCO80276GRP-4707CORE-HMO
ENRENR-1309172026-02-03T16:17:52ZAnthonyP.Median12-02-1995UHC-86103-32•••-••-8655+1 820 397 5478anthony.medina@hotmail.com7982 Park PlOrlandoFL32864-1787GRP-5334MEDICARE-ADV-A
ENRENR-1207762026-04-07T10:37:04ZHiroshiLMcDonald07/08/1991UHC-32228-83UNKNOWN9036515984UNKNOWN8785 Harbor Boulevard·CharlotteNC28219GRP-7493SELECT-EPO
ENRENR-1092732026-01-02T18:33:49ZOmar—Oliver10/01/08UHC-32622-59•••-••-4537886-288-1687OMAR.OLIVER58@AOL.COM7149 Market StreetSAN DIEGOCA92147GRP-3984NAVIGATE-HMO··
ENRENR-1343762026-02-20T21:51:02ZWei—Jemes1987-05-16UHC-53568-22•••-••-8989(892) 808-0751WEI.JAMES@PROTON.ME7550 SAGE COURTOrlandoFL32822···GRP-6004CORE-HMO
ENRENR-1284412026-05-26T09:48:08ZMasonSGarrett2005-06-06UHC-88787-58•••-••-23818725199267mason.garrett@yahoo.com6530 BAYSHORE DRIVENashvilleTN37281GRP-2573OPTIONS-PPO
ENRENR-1071322026-07-23T18:42:12ZSophia—Nunez·05/12/1963UHC-17485-17•••-••-3293477.392.5452sophia.nunez@aol.com9531 Cedar Ln··AUSTINTexas··78766·GRP-1185MEDICARE-ADV-B
ENRENR-1331142026-08-10T19:33:54ZCarl—Hunter1998-06-16UHC8871227•••-••-2000813-751-1527CARL.HUNTER51@GMAIL.COM734 Maple AveColumbusOH—GRP-2643SELECT-EPO
ENRENR-1070032026-08-19T23:27:06ZStevens, Bryen——25-08-1967UHC-54937-27•••-••-3854(642) 492-4703NULL7061 CHURCH STGilbertAZ85210GRP-9560MEDICARE-ADV-A
ENRENR-1161642026-03-29T22:41:15Zaustin—nelson1976-04-26UHC-17625-45•••-••-32202050949austin.nelson@proton.me2549 Cedar LaneColumbusOH··43243GRP-5145CHOICE-PLUS-PPO
ENRENR-1143832026-06-04T02:11:38ZRICHARDK.FERGUSON·12/18/1949UHC-78818-78•••-••-7447568-867-9799N/A·4772 CENTRAL AVE·Tucson·AZ—GRP-7468SELECT-EPO
ENRENR-1270502026-08-13T09:21:30ZNatalieF.Moore5/27/1956UHC-21260-01—-natalie.moore@aol.com1111 Baseline RdColumbusOH43248GRP-1752MEDICARE-ADV-B
ENRENR-1176372026-09-19T05:44:55ZHelen··K.Jenkins·Aug 25, 1977·uhc-05577-58•••-••-9942607.612.2856UNKNOWN8398 Lincoln WaySan AntonioTX78249GRP-0813CORE-HMO
ENRENR-1000102026-02-06T12:52:11ZCAROLYNOBURNSnullUHC6438722•••-••-4084(864) 714-3924·carolyn.burns@yahoo.com7945 Forest AveJacksonvilleFL32288·GRP-3627CHOICE-PLUS-PPO
ENRENR-1120942026-02-05T02:38:37ZNICOLEQCARTER1978-02-06UHC-16666-12··N/Anull-5698 Grand AveHoustonTexas··77048GRP-2105MEDICARE-ADV-A
ENRENR-1074942026-06-05T10:00:40ZFrank—Alvarado··1968-11-17··UHC-72561-53-4707390frank.alvarado60@outlook.com9413 CENTRAL AVEGlendale·Arizona85378GRP-8667MEDICARE-ADV-A
ENRENR-124626 2026-08-06T01:09:33ZDylan—Graham4/20/1991UHC-38198-66··•••-••-8619+1 633 211 6626dylan.graham13@yahoo.com5316 Harbor Boulevard··Chandler·AZ85237GRP-9807MEDICARE-ADV-A
ENRENR-1117512026-02-28T22:39:27ZSOFIAUVAZQUEZ5/3/1971UHC9524652•••-••-0464457-540-5160—6152 Apache BoulevardSeattleWashington98197GRP-4293OPTIONS-PPO
ENRENR-1424122026-08-13T17:25:03ZLaura··Dunn12/16/1946UHC-26938-12•••-••-9013(649) 987-1583—·8726 Apache Blvd Apt 20PlanoTX75092GRP-1591MEDICARE-ADV-B
ENRENR-119879 2026-10-01T04:44:37ZTERESAV.HARRISON2007-01-27UHC-56572-05—(975) 304-9752teresa.harrison@proton.me1781 HARBOR BOULEVARDSan AntonioTX78294·GRP-6674NAVIGATE-HMO
ENRENR-1170382026-01-14T22:59:43ZAmy—Robinson1967-09-23UHC-32707-46•••-••-93108938407867-3052 UNION STHoustonTexas77003··GRP-9787CORE-HMO
ENRENR-1166592026-10-13T15:12:01ZKahyJMorales1949-06-28UHC-69962-70•••-••-9633(709) 921-5098katherine.morales@outlook.com9500 Sunset BoulevardLos AngelesCA90008GRP-7350MEDICARE-ADV-A
43,101 rows, page 1 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
    line_no records each row's position in the source file, so a value can be located in the original extract.
  • Load timestamp
    loaded_at marks when the row landed in the lakehouse; this batch landed 2026-10-21T12:37:53.958Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty