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-1208332026-01-01T14:34:24ZWILLIAM—SCOTT1938-04-20··UHC-86572-89•••-••-5496932-967-0138william.scott42@yahoo.com2049 River RoadDallasTX-GRP-6226MEDICARE-ADV-B
ENRENR-1189232026-08-08T13:11:32ZVALENTINAWBROOKS··15-12-1954UHC-68658-61•••-••-8176(801) 520-4532·valentina.brooks@hotmail.com45 HILLCREST ROADMinneapolisMN55434GRP-5531OPTIONS-PPO
ENRENR-142406 2026-06-02T01:05:06ZPerkins, DianeP—Mar 17, 1983UHC-00538-27•••-••-356315653158527·DIANE.PERKINS14@ICLOUD.COM4580 Hillcrest RoadGlendaleAZUNKNOWNGRP-3888options-ppo
ENRENR-1395232026-06-23T05:47:35ZGrant, Amanda····—1985-09-24UHC-63557-36•••-••-449315774067108amanda.grant@icloud.com6065 Willow CtJacksonvilleFL32277GRP-0257MEDICARE-ADV-A
ENRENR-1418572026-04-26T08:57:22ZCYNTHIADLE1946-09-14UHC-82199-46•••-••-1020(928) 590-1949CYNTHIA.LE@PROTON.ME3532 PINE DRIVEChandlerAZ··85275··GRP-7934CHOICE-PLUS-PPO
ENRENR-115506 2026-04-09T05:21:16ZKnight, Teresa··——10/26/1969null•••-••-41556985405208teresa.knight4@outlook.com9898 Apache BoulevardMESAAZ85208GRP-0124MEDICARE-ADV-B
ENRENR-1119832026-03-30T11:24:03ZDotC.·Ryan1989-05-02·UHC-88157-97•••-••-2701+1 560 643 2005dorothy.ryan@outlook.com7322 Cedar LaneLOS ANGELES·CA90056··GRP-4891CHOICE-PLUS-PPO
ENRENR-1360312026-06-10T21:43:14ZLAURENEHOWELL·1955-11-11·UHC-02859-87N/A·+1 716 401 9163lauren.howell@outlook.com5487 Meadow LaneSacramentoCalifornia95899GRP-9068MEDICARE-ADV-A
ENRENR-1167352026-01-17T08:00:22ZJoseP.Bryant1974-02-01·UHC-24385-05•••-••-6460591-976-5784JOSE.BRYANT59@OUTLOOK.COM··7395 Harbor BlvdSan AntonioTX78238GRP-2401CHOICE-PLUS-PPO
ENRENR-1377492026-09-21T05:09:03Z AARONHROJAS1962-10-06UHC-33961-52•••-••-0118+1 788 291 7186aaron.rojas80@yahoo.com2380 Central AvenueAustin·TX78766GRP-4290SELECT-EPO
ENRENR-1047752026-01-22T12:34:46ZJacquelineC.Walssh··4/12/1977UHC-85901-07•••-••-91682560860UNKNOWN9862 Lincoln WayLOS ANGELESCA·90004GRP-9370SELECT-EPO··
ENRENR-1060262026-01-29T09:56:47ZGrace—Gardner12/10/1961··UHC-54937-30•••-••-139516323031694grace.gardner@icloud.com4389 Mesa DriveEden PrairieMN55324GRP-8120SELECT-EPO
ENRENR-1028532026-08-19T21:25:13ZHeather—Valdez1966-03-06UHC-93047-86null··711-395-1690heather.valdez88@icloud.com8589 Mountain View DriveTampa··Florida33638GRP-2416·SELECT-EPO
ENRENR-1065242026-06-13T19:08:39ZNicoleXRice··3/17/1995UHC-22461-47—(278) 963-1747nicole.rice7@outlook.com8696 CANYON RDFresnoCA93785·GRP-0719MEDICARE-ADV-B
ENRENR-1084772026-01-23T05:12:35Zalexander·Hcrawford19981218··UHC-67276-23•••-••-3843N/AALEXANDER.CRAWFORD@AOL.COM8464 WASHINGTON STMinneapolisMN55472GRP-8834CORE-HMO
ENRENR-1142722026-08-08T21:39:41Zhiroshi—munoz19760614·UHC-47517-65•••-••-42083346043875HIROSHI.MUNOZ@PROTON.ME7710 ELM STTampaFL33620GRP-9924CHOICE-PLUS-PPO
ENRENR-1169682026-01-19T13:27:01ZMARGARET···DUNCAN1950-08-15UHC7835392•••-••-39218348817889margaret.duncan74@gmail.com569 MARKET STREETTampaFL33643GRP-3609SELECT-EPO
ENRENR-1237722026-05-22T11:35:38Z KennethYMarshall1977-11-20UHC-46864-77•••-••-0344394.219.9966—1786 Willow CtColumbusoh43226-9499GRP-6425MEDICARE-ADV-B
ENRENR-1356502026-07-02T13:05:30Zcarol—murray·1697-04-06UHC-75188-27•••-••-90968755683662carol.murray18@icloud.com91 Spring StEDEN PRAIRIEMN55327GRP-8207MEDICARE-ADV-A
ENRENR-1062902026-08-13T10:26:38ZARTHUR—GUTIERREZ1986-02-04UHC-23437-15•••-••-4060+1 665 691 9130·arthur.gutierrez18@proton.me6824 Palm DriveEden PrairieMN55397GRP-5850NAVIGATE-HMO
ENR ENR-1127162026-07-06T14:56:06ZalexanderLwells19630607··UHC-58614-40•••-••-93442883575441alexander.wells62@icloud.com6815 Harbor Boulevard #213SacramentoCA95852GRP-3935MEDICARE-ADV-B
ENRENR-1258802026-02-04T18:08:01ZCarslon, CarolynH—03/23/1963··UHC-63760-02•••-••-4939——4704 Bayshore DriveColumbusOH43214-9802GRP-4795CORE-HMO··
ENRENR-1263282026-06-01T18:50:09ZJoseph—Carroll10/05/1970UHC-92686-44NULL3109269965joseph.carroll@proton.me56 River RdSCOTTSDALE·AZ85218··GRP-3465MEDICARE-ADV-A
ENRENR-1267732026-01-09T03:00:33ZThomas, Mateo——06/21/52UHC-30713-28•••-••-1537633.803.9110··mateo.thomas42@yahoo.com5508 MOUNTAIN VIEW DRIVE Apt 38·AustinTX78763GRP-5742CHOICE-PLUS-PPO
ENRENR-1188962026-06-24T21:17:51ZBarbara··Oliver07/15/76UHC-71536-77•••-••-92762666444··—2343 Sunset Boulevard Apt 6AustinTexas78778GRP-0891MEDICARE-ADV-A··
ENRENR-1014482026-07-03T20:19:04ZCAMILAG.AUSTIN2001-05-25·uhc-06304-18•••-••-5625291.208.7511camila.austin@gmail.com3279 Sage CourtMesaAZ85223GRP-3075MEDICARE-ADV-B··
ENRENR-1197202026-05-08T20:46:29ZMedina, Natalie——24-12-1945UHC-96777-36•••-••-7407948-402-3277—1410 Broadway··TAMPAFL33619GRP-2910MEDICARE-ADV-B
ENRENR-1324842026-04-11T23:09:06ZAlan··WRodriguez1952-06-10uhc-35475-51•••-••-9937659.366.9300alan.rodriguez@yahoo.comnull—N/AnullGRP-3519MEDICARE-ADV-B
ENRENR-1265382026-02-15T20:10:29ZValentina—Nguyen··1947-05-01UHC-34214-65•••-••-58639708424—8410 Sunset BlvdCOLUMBUSOhio43270GRP-8572MEDICARE-ADV-B
ENRENR-1381212026-05-22T02:04:42ZcamilaPandrews1974-03-26UHC-07406-76•••-••-4996(240) 293-4059camila.andrews@icloud.com6437 BroadwayCharlotteNC—GRP-9340CORE-HMO··
ENRENR-1247772026-04-24T17:14:33ZPETER—HARRIS13-02-1960UHC-60151-60•••-••-2412·17044767579PETER.HARRIS85@PROTON.ME4696 APACHE BLVDCOLUMBUS··OH43207-8077GRP-8889MEDICARE-ADV-A
ENRENR-1141832026-09-30T19:38:39ZETHAN··JLOPEZOct 4, 1993·UHC-85031-68•••-••-1001(528) 322-4793ethan.lopez@proton.me2946 Central AveAustintx78750-6032GRP-9937MEDICARE-ADV-B
ENRENR-1058802026-04-16T10:52:07ZBaker, KellyG——UHC-48249-92•••-••-0130278-685-9756—4218 Sunset BoulevardSan DiegoCA92180GRP-3683SELECT-EPO
ENRENR-1339622026-09-26T13:53:00Z·CONTRERAS—PRIYA01/03/1956UHC-09285-97•••-••-61877793479560priya.contreras6@proton.me8915 Sunset BlvdCharlotteNC28201·GRP-5188MEDICARE-ADV-A
ENRENR-1154282026-07-02T10:01:15ZLUCIABHANSON·03/06/2008UHC-46738-43•••-••-23116912609729null4686 Bayshore DrSan DiegoCalifornia92170GRP-4211·CHOICE-PLUS-PPO
ENRENR-102189 2026-06-21T14:57:36Zkenneth—stephens1982-06-15UHC-48984-36•••-••-61816099609859kenneth.stephens43@icloud.com3502 Elm St Apt 18·TucsonAZ85787GRP-1993CHOICE-PLUS-PPO
ENRENR-1072242026-01-11T13:08:14ZSANDRAEOWENS11/16/78UHC-89246-62•••-••-8296(885) 385-6982NULL6957 Bayshore DriveSEATTLEWA·98175GRP-3971NAVIGATE-HMO
ENRENR-1182332026-02-21T20:45:10ZKATHLEENCLEE·12/07/1969UHC-70217-02•••-••-2161723-376-3425kathleen.lee@yahoo.com4961 Lake View RdMesaAZ85219GRP-8207MEDICARE-ADV-A··
ENRENR-1402392026-06-14T06:59:42ZLORIRLAWSON03/11/83··UHC-11019-86•••-••-88305173724329null1146 OAK STREETHoustonTX77031GRP-5923CHOICE-PLUS-PPO
ENRENR-1112302026-08-24T23:12:57ZFRANK—DIAZ1999-40-24UHC-16569-25-·526.834.1032FRANK.DIAZ92@OUTLOOK.COM7982 Sage CtColumbusOH43212GRP-6604SELECT-EPO
ENRENR-1104822026-09-24T00:18:48ZJORDANZ.ISABELLA1953-11-28··UHC-87151-05•••-••-3374(304) 620-6087isabella.jordan6@icloud.com4444 HARBOR BOULEVARDFresnoCANULLGRP-6739MEDICARE-ADV-B
ENRENR-1096302026-09-07T14:25:39Z MarianaN.Wheeler1971-11-21UHC-14508-74—18355094888·MARIANA.WHEELER@HOTMAIL.COM1448 Baseline RdPlanoTX75094GRP-1669MEDICARE-ADV-A
ENRENR-124947 2026-06-18T16:21:29ZHelen—JimenezSep 22, 1975UHC-73267-49•••-••-412214075457816-6644 Mesa DriveFresnoCA93797GRP-9025CHOICE-PLUS-PPO
ENRENR-1125712026-07-06T05:34:48ZANTHONYEWATSON22-04-1950UHC-08394-33•••-••-3068451.546.7061ANTHONY.WATSON33@HOTMAIL.COM2773 Forest AveMesaAZ85278GRP-3727SELECT-EPO
ENRENR-1397732026-06-09T00:15:58ZThompson, JonJ—14-06-1998UHC-64805-11•••-••-279419295160094—1536 Washington StreetSan DiegoCA·92157GRP-5216SELECT-EPO
ENRENR-1268552026-09-25T04:21:09ZJessica··—·Miller02/08/52UHC-28040-04•••-••-20975825465213—·8223 Jefferson AveJacksonvillefl····GRP-1288··MEDICARE-ADV-B
ENRENR-1371232026-01-16T03:32:15ZAlbert—Hawkins2000-08-08UHC-89653-70•••-••-4581(684) 397-5202N/A6537 MESA DRIVEDallasTX75254GRP-1286MEDICARE-ADV-A
ENRENR-1294782026-06-03T09:47:26ZRACHLE—GARZA1978-11-27UHC9707757•••-••-51485313933194rachel.garza13@hotmail.com3933 SUNSET BOULEVARDMinneapolis··MNUNKNOWNGRP-6101MEDICARE-ADV-A
ENRENR-1353182026-01-22T23:10:52ZElijah—Campbell1959-10-22UHC-67267-58•••-••-4721340.967.8447··elijah.campbell90@gmail.com6580 Central Ave #332SacramentoCalifornia95886GRP-5192CORE-HMO
ENRENR-1219762026-04-14T07:19:08ZKathrynI.Henderson19531128UHC-09847-52•••-••-7734312-484-6062—4192 Market StLas Vegas·Nevada89134GRP-6665OPTIONS-PPO
43,101 rows, page 13 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-19T19:54:25.420Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty