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-1228232026-05-31T18:24:33ZERICUDANIELS1979-07-24UHC-60880-20··N/A··(956) 735-2427eric.daniels@gmail.com··5333 Indian School RdPlano··TX75088GRP-1709OPTIONS-PPO
ENRENR-1063802026-02-08T07:51:07ZElizabethASimmons1938-07-15UHC-08285-02•••-••-9154(699) 270-4178ELIZABETH.SIMMONS47@YAHOO.COM6495 Harbor Boulevard··HoustonTX77097GRP-3992SELECT-EPO
ENRENR-1189842026-06-15T00:46:33ZEevlyn—Munoz·1971-10-06UHC-08992-37•••-••-2263(789) 612-6352evelyn.munoz@aol.com··6463 Ocean AvenueGlendaleAZ85333-7290GRP-2809SELECT-EPO
ENRENR-1172942026-10-14T07:27:35ZsusanCthompson7/14/1978UHC-86388-83•••-••-94405223831255-3690 Cedar LaneMesa··AZ85291GRP-3156CHOICE-PLUS-PPO
ENRENR-1256052026-03-04T08:30:09ZDANIEL—LARSON1992-07-08UHC-67606-47•••-••-8638(283) 239-5363··—9824 Mesa DriveOrlandoFL32827GRP-7402NAVIGATE-HMO
ENRENR-1250802026-05-11T09:00:41ZCatherine—Fuller1961-02-27UHC-08698-57•••-••-94989046520459··N/A3944 Oak StDENVERCO80224GRP-1990NAVIGATE-HMO
ENRENR-1184842026-03-08T05:18:08ZPhilipDTorres03/28/1950UHC-24210-32•••-••-4896349-343-9532PHILIP.TORRES@ICLOUD.COM8652 Mountain View DrivePlanoTX75066GRP-7316CORE-HMO
ENRENR-1232652026-09-06T16:28:23Zbryan—estrada1969-09-20UHC-71453-78•••-••-5443(499) 273-4241bryan.estrada@aol.com2558 OCEAN AVENUEColumbus··OH43229·GRP-6173MEDICARE-ADV-B
ENRENR-1318232026-08-11T00:17:22ZHEATHER—VAZQUEZ19550514UHC-60010-83•••-••-6293687.609.4958heather.vazquez@proton.me1445 Central Avenue··GlendaleAZ85399GRP-2123SELECT-EPO··
ENRENR-1109482026-07-20T01:10:14ZBenjaminXJensen1963-09-25UHC3248862-(484) 674-0821benjamin.jensen@gmail.com8817 Forest AvenueGlendaleAZ85328GRP-7496MEDICARE-ADV-A
ENRENR-1016192026-01-24T13:34:29Z·CARLSONQ·THOMAS1972-09-24·UHC-84497-79•••-••-1426-··thomas.carlson@gmail.com6404 Camelback RdOrlandoFL··32829GRP-0962CHOICE-PLUS-PPO
ENRENR-1373422026-03-28T22:59:37ZLaura—Hill1975-03-25UHC-22551-06NULL+1 938 821 0323·N/A7256 Union StDenver·CO·80274GRP-3000OPTIONS-PPO··
ENRENR-1388502026-05-18T21:29:15ZHeatherU.·Rodriguez1942-02-16UHC-31342-40•••-••-6883-heather.rodriguez@gmail.com460 WASHINGTON STREETMesaAZ85276GRP-1436medicare-adv-a
ENRENR-1325442026-03-05T15:10:01ZsusanTlane1960-03-01UHC7375654•••-••-1053+1 968 414 8455-2400 Hillcrest RoadSan DiegoCA92144··GRP-8413CHOICE-PLUS-PPO
ENRENR-1193432026-08-21T00:56:14ZLawrence—Grant1939-02-09UHC-09561-66•••-••-3974276-412-5268lawrence.grant@proton.me1732 Pine DriveNashvilleTN37286GRP-0928·MEDICARE-ADV-B
ENRENR-1039142026-02-25T18:05:56Zarjun—turner1984-09-08UHC-29706-22•••-••-8698(769) 671-7981null8735 VALLEY VIEW DRIVEPhoenixAZ85067GRP-9576NAVIGATE-HMO
ENRENR-1223422026-05-16T17:20:52ZBell, Tyler——03-04-1952UHC-15801-13•••-••-6295(929) 834-4689null4712 Forest Ave Apt 17ColumbusOH43291GRP-3716CORE-HMO
ENRENR-1081722026-05-06T03:57:57Z Debra—Baker06/17/1949UHC-87873-97•••-••-9616770.489.0011·-4583 Meadow LnScottsdaleAZ85278GRP-7511OPTIONS-PPO
ENRENR-1196222026-07-08T09:48:04ZAndrea··—Pena20040316uhc-32027-99•••-••-6295605-316-7891··andrea.pena72@gmail.comN/Anull——GRP-9803·options-ppo
ENRENR-1274622026-04-28T13:16:11ZANA—ORTIZ·05/28/59UHC-28766-26null(624) 742-5118—1779 CENTRAL AVEAtlantaGA30336GRP-4605SELECT-EPO··
ENRENR-1102772026-10-16T14:21:24ZJudyXLittle2002-04-17UHC6135344•••-••-1696(363) 943-2651null1140 CEDAR LNCOLUMBUSOH··GRP-7019CHOICE-PLUS-PPO
ENRENR-1009682026-06-17T01:19:25ZDennisPHarris1972-01-02UHC-62668-30•••-••-1188924-568-2766dennis.harris@yahoo.com4701 Sage CtMESAAZ85271GRP-5453··SELECT-EPO
ENRENR-1175232026-01-22T08:27:01ZClark, Kelly··N—1954-10-03UHC-47071-64•••-••-73274859274070kelly.clark@proton.me9516 Market StreetGlendaleAZ85374-3104GRP-7547MEDICARE-ADV-A
ENRENR-1387822026-07-23T00:39:28ZBruce—Alexander25-07-1988UHC-66040-77•••-••-5582nullbruce.alexander@proton.me7801 Apache Blvd··ScottsdaleAZ85275GRP-8479CORE-HMO
ENRENR-1229472026-07-21T16:54:16ZJEAN—RICHARDS1953-01-11UHC-20790-42N/A(872) 957-7133jean.richards96@hotmail.com5491 Indian School RoadMinneapolisMN55400GRP-5079MEDICARE-ADV-B
ENRENR-1150902026-04-23T18:31:51ZGabrielN.·Jensen17-06-1992UHC-05339-10•••-••-881018583217076gabriel.jensen@aol.com·7912 Union StChandlerAZ85239··GRP-0748NAVIGATE-HMO
ENRENR-1200302026-09-06T07:49:17ZSteven—Banks1955-12-09UHC-00252-61•••-••-3587332.608.3247STEVEN.BANKS@YAHOO.COM·190 Ridge RdGilbertAZ85286GRP-8670NAVIGATE-HMO
ENRENR-1230772026-01-10T08:27:37ZRussell—Garcia1989-02-11UHC-64553-99-7436920228russell.garcia@yahoo.com4408 River RdMiamiFL33188GRP-0916MEDICARE-ADV-B
ENRENR-1054972026-03-26T04:52:41ZKyleJWang2003-09-16UHC-46109-50•••-••-5418(403) 756-4755kyle.wang32@gmail.com5399 CANYON ROADTempeAZ85275GRP-3975CHOICE-PLUS-PPO
ENRENR-1067392026-10-12T08:46:07ZRichard—Silva2000-07-04uhc-08142-79•••-••-0900—NULL·1302 Meadow Ln Apt 32San DiegoCA92143GRP-4988medicare-adv-b
ENRENR-1394612026-09-08T22:14:48ZHAROLD—WATKINS1962-09-01UHC-53948-51•••-••-3293(854) 581-8765—9214 Lake View RdSan DiegoCA92105-3364GRP-3831CORE-HMO
ENRENR-1346302026-03-31T13:08:14Zmaria—knight1963-04-14UHC-32949-76•••-••-23858124909486maria.knight@aol.com151 Ridge RdColumbus··oh43233GRP-1307MEDICARE-ADV-A
ENRENR-1195372026-02-15T23:57:29ZDONUGONZALES2006-10-09UHC-12549-84•••-••-3715UNKNOWNdonald.gonzales26@gmail.com179 FOREST AVEJacksonvilleFL······GRP-3461·OPTIONS-PPO
ENRENR-1327382026-09-06T12:52:19ZLynch, Judith——1961-08-17UHC-81000-44··•••-••-2192+1 945 625 3043JUDITH.LYNCH@OUTLOOK.COM2473 PALM DRAtlantaGA30344GRP-1343CHOICE-PLUS-PPO
ENRENR-1114712026-03-27T07:10:15Zevelyn—nguyen2006-09-24UHC7104685•••-••-2749714-846-6990NULL4117 DESERT SKY BOULEVARDSan DiegoCA92192GRP-3978NAVIGATE-HMO
ENRENR-1078932026-05-31T12:46:06ZPeterXSpencer5/3/1970UHC-64808-33•••-••-9749(303) 224-4683peter.spencer73@aol.com5103 Jefferson Ave··MinneapolisMN55448GRP-3689CHOICE-PLUS-PPO
ENRENR-1095882026-09-11T13:09:31ZJordan—Harris1951-12-25UHC-98759-35•••-••-31792596461176null1233 FOREST AVENUELas Vegasnv89120GRP-4869CHOICE-PLUS-PPO
ENRENR-1143142026-09-15T21:47:26ZDIANEH·CLARK19711212UHC-44245-58•••-••-28293389173384··diane.clark30@yahoo.com7626 Main StreetTampaFlorida33659GRP-1533navigate-hmo
ENRENR-1004842026-04-19T21:07:35ZwilliamN.luna1991-02-23—•••-••-2699(264) 583-8162WILLIAM.LUNA@PROTON.ME6111 Indian School RoadMiamiFL33191GRP-7287MEDICARE-ADV-B
ENRENR-1030882026-10-02T15:43:37ZJoshuaASimmons1977-04-09UHC-13424-53•••-••-3034(429) 727-1590··—3358 Hillcrest RoadColumbusOH—GRP-2272NAVIGATE-HMO
ENRENR-1019522026-05-17T12:40:11ZJason··—·Li1970-05-16UHC-97033-03··NULL(247) 840-9639JASON.LI@HOTMAIL.COM8580 LINCOLN WAYPhoenixAZ85041-0752GRP-9524core-hmo··
ENRENR-1085442026-09-23T03:00:30ZLAURA—HALL·1965-01-26UHC-14143-76•••-••-926614598037292laura.hall44@aol.com8930 BroadwaySan DiegoCalifornia··92142GRP-8813MEDICARE-ADV-B
ENRENR-1232762026-03-22T08:56:05ZkimPlittle1952-05-13UHC-78663-14•••-••-0555(273) 683-5590kimberly.little@aol.com3243 Mesa DrSan Diego··CA92102··GRP-7320OPTIONS-PPO
ENRENR-1226582026-06-13T17:54:31ZMarilyn··JFerguson1960-04-08UHC-33529-32•••-••-9292(303) 330-6160·marilyn.ferguson@aol.com5755 PINE DRIVE··MesaAZ85202GRP-9987NAVIGATE-HMO
ENRENR-1290432026-01-23T07:04:26Z·Amber E—Coleman01/06/74UHC-48834-19··•••-••-5648NULLamber.coleman@proton.me6563 Valley View Dr Apt 28JACKSONVILLEFL·32255GRP-4142CORE-HMO
ENRENR-1276632026-05-14T19:09:02ZMASONKORTIZ2008-02-08UHC-43983-84•••-••-1254827-243-2942mason.ortiz@icloud.com··9428 LAKE VIEW RDTempeAZ85262GRP-2209CHOICE-PLUS-PPO
ENRENR-1069302026-03-14T13:23:45Z·ALBERTA.HALL1980-03-18UHC-77367-20•••-••-6109976-373-7258N/A··2761 Forest Ave·ChandlerAZ85231GRP-4038·select-epo
ENRENR-1235612026-06-18T03:39:02Z·Priya··Burton·09/24/85UHC-30034-12•••-••-27447799663579UNKNOWN722 Elm StreetTempeAZ85267GRP-9420·MEDICARE-ADV-B
ENRENR-114196 2026-07-20T02:27:42ZLAURA··H.SCHULTZ19560512UHC-75201-50•••-••-0121·+1 938 445 9423laura.schultz@icloud.com6786 Lincoln WayOrlandofl32849·GRP-8932CORE-HMO
ENRENR-105514 2026-10-12T02:16:19ZJanetBRoss2007-08-11UHC3604421NULL5112243354janet.ross@outlook.com4119 Bayshore DriveCharlotteNC28251GRP-5499NAVIGATE-HMO
43,101 rows, page 66 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:36.699Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty