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-1380572026-08-09T01:31:12ZLuisWBlack1993-12-20UHC-95533-43•••-••-9364865-394-1391luis.black@aol.com6457 BroadwayTempeAZ85276GRP-9518CHOICE-PLUS-PPO
ENRENR-1059612026-04-07T18:27:27Z HeatherO.Griffin1987-08-11UHC6065931•••-••-0198(824) 822-9092—8521 PALM DRIVEJacksonvilleFlorida32278-6172GRP-1193SELECT-EPO
ENRENR-1068802026-09-18T18:21:30ZWatkinsMMegan··1997-10-10·UHC-36574-72•••-••-108012086708343megan.watkins39@proton.me2995 Mountain View DrSAN DIEGOCA—GRP-9250MEDICARE-ADV-B
ENRENR-1332652026-08-17T22:34:49ZKATHLEENPRICHARDSON1961-04-10UHC-65298-57N/A(832) 673-4539kathleen.richardson66@proton.me3562 ELM STOrlandoFL32868GRP-6362CHOICE-PLUS-PPO
ENRENR-1029562026-04-20T20:44:22ZAaron—Chapan06/11/68·UHC-88093-65•••-••-54638024873015·aaron.chapman87@outlook.com7379 Grand AveMINNEAPOLISMN55482··GRP-0900CORE-HMO
ENRENR-1079502026-09-04T09:33:21ZGERALDV.SANTOS1975-06-28UHC-52170-31—730-882-6264··GERALD.SANTOS22@AOL.COM·3172 BAYSHORE DRScottsdaleAZ85211-5731GRP-7726MEDICARE-ADV-B
ENRENR-1178312026-03-08T17:55:19ZWalsh, Teresa··H—1949-10-07UHC-14924-54•••-••-31318586571916teresa.walsh7@hotmail.com1450 MEADOW LANELas Vegasnv89156-4242GRP-1653··MEDICARE-ADV-A
ENRENR-1228212026-01-27T16:04:28ZKyle—Sims—UHC-87960-22•••-••-9414723-360-6875kyle.sims42@outlook.com4312 Oak StCharlotteNC··28288-3064GRP-6707MEDICARE-ADV-B
ENRENR-1426202026-03-05T12:58:22ZmichaelY.stewart1989-02-11·UHC-09021-38•••-••-95072963423490-·6202 WASHINGTON STREETSan DiegoCA92163GRP-5540MEDICARE-ADV-B
ENRENR-1186342026-03-20T08:39:51ZFrank—·Patel1793-02-25··UHC-94541-33•••-••-1094521.495.8016frank.patel@outlook.com—NULL——GRP-4126MEDICARE-ADV-B
ENRENR-1274552026-06-08T08:59:10ZDEBBIE—WONGMar 7, 1963UHC-84219-67•••-••-8507640.526.9778deborah.wong@yahoo.com·7735 Main StGlendaleAZ85345GRP-1802CHOICE-PLUS-PPO
ENRENR-1164752026-08-03T09:02:04ZEmilyUFord1944-05-25NULLNULL7799506879emily.ford32@hotmail.com8358 Valley View DrMESAAZ85204GRP-4260NAVIGATE-HMO
ENRENR-1284852026-04-01T00:59:26ZISABELLAB.KENNEDY1951-08-10UHC-97057-97•••-••-60424052366527isabella.kennedy@gmail.com2989 RIDGE RDChandleraz85217GRP-9841MEDICARE-ADV-A
ENRENR-1361192026-02-08T15:07:13ZMichaelBRobertson1983-03-07UHC-50054-48•••-••-9834(361) 784-2407michael.robertson41@hotmail.com5167 Valley View DriveDenverCO80232GRP-1763OPTIONS-PPO
ENRENR-1256002026-08-10T14:22:56Zbrenda—lewis1977-10-20UHC-78243-99•••-••-46539142238628·brenda.lewis51@gmail.com4565 CHURCH STREETLas VegasNVnullGRP-8608·CORE-HMO
ENRENR-1144472026-07-08T14:31:24ZJEFFREY Y.··STEWART··1995-03-24UHC-18721-55•••-••-16832069538887jeffrey.stewart@proton.me6049 Grand AveColumbusOH43289·GRP-7650MEDICARE-ADV-B
ENRENR-1078782026-09-25T11:40:41ZAMBER—VAZQUEZ19731018UHC-91224-37•••-••-9747(424) 826-1496-207 APACHE BLVD·NASHVILLETN··37212GRP-8533SELECT-EPO
ENR ENR-1114432026-07-29T12:56:50ZFreeman, HannahK—01/10/1989UHC-41971-97•••-••-0991+1 795 980 1389hannah.freeman39@icloud.com1191 PALM DROrlandoFLN/AGRP-8852CHOICE-PLUS-PPO
ENRENR-1158402026-02-10T21:16:57ZREBECCA—GREEE5/5/2006UHC-66153-41•••-••-6047nullN/A3070 Palm DriveTampafl33694GRP-7708navigate-hmo
ENRENR-1177622026-10-08T17:16:57ZJANETHVALDEZ04/01/1943··UHC-35323-58•••-••-36395244779931janet.valdez32@icloud.com7016 Ridge RdChandlerAZ85226GRP-3245SELECT-EPO
ENRENR-1305302026-07-07T04:55:44ZGeraldTRuizFeb 10, 1989UHC-14467-45•••-••-2432234-648-1263gerald.ruiz97@aol.com8019 Canyon RoadColumbusOH43251GRP-1659NAVIGATE-HMO
ENRENR-1164922026-06-11T01:40:31ZGutierrez, JasonE.—1971-06-19UHC2653302··•••-••-9220(371) 418-7582JASON.GUTIERREZ47@AOL.COM4563 Mesa DriveGlendaleAZ85302GRP-4271SELECT-EPO
ENRENR-1082152026-04-04T01:07:08ZEugene··PFreeman14-02-1938—•••-••-83532019155824EUGENE.FREEMAN35@YAHOO.COM8811 Sage CourtSCOTTSDALEAZN/AGRP-8496medicare-adv-a
ENRENR-1172342026-06-28T08:18:35ZVictoria—Fowler1982-06-02··UHC-96248-91•••-••-9377+1 923 994 0169·UNKNOWN4796 Hillcrest RdSACRAMENTOCA95879·GRP-7183CHOICE-PLUS-PPO
ENRENR-1310742026-01-18T12:00:16ZBRYYANK.HANSEN1939-12-13UHC-23945-12•••-••-1477NULLBRYAN.HANSEN37@GMAIL.COM161 FOREST AVENUEMinneapolisMN55478GRP-8470SELECT-EPO
ENRENR-1137252026-03-14T06:01:46ZNATHANSSANCHEZ13-11-1949uhc-34921-74•••-••-83289796243503nathan.sanchez@proton.me4029 Pine DrHoustonTX77093GRP-7865MEDICARE-ADV-A
ENRENR-1193262026-02-17T11:28:38ZEVELYN—BURNS17-10-1991UHC-64453-70null4719453EVELYN.BURNS@AOL.COM4461 Spring StreetTampaFL33671GRP-1619options-ppo
ENRENR-1265312026-08-09T05:38:36ZBobbyKVasquez1987-08-27UHC-39236-47•••-••-2409null··bobby.vasquez49@gmail.com776 Sunset BoulevardAtlantaGA30347GRP-6211NAVIGATE-HMO
ENRENR-1271362026-08-25T09:25:42ZTeresa—Meyer1943-03-14UHC-07697-73N/A3503589022TERESA.MEYER46@HOTMAIL.COM2292 Canyon RoadLos Angelesca··90013GRP-7888MEDICARE-ADV-A
ENRENR-1075352026-06-08T07:58:44ZRANDY—FRANKLIN1939-02-21UHC-11089-40•••-••-7051+1 691 924 4328randy.franklin@yahoo.com8402 Canyon RoadScottsdaleAZ85246-6286GRP-3776NAVIGATE-HMO
ENRENR-1287092026-05-10T03:01:34ZKEVINOVALDEZ6/2/1944UHC-74950-66•••-••-8025-kevin.valdez99@proton.me2357 MOUNTAIN VIEW DRIVEJACKSONVILLEFlorida32232GRP-1790CORE-HMO
ENRENR-1331612026-07-27T04:35:35ZKAYLAGSOTO1986-07-27·UHC-21614-94null8602595856kayla.soto@icloud.com·3156 MAIN STREETPhoenixAZ85079GRP-1730MEDICARE-ADV-B
ENRENR-1330522026-05-06T13:32:11Z JACOB—JAMES··1992-08-23UHC-95959-82•••-••-7342(206) 373-0657jacob.james@proton.me757 Spring St·SEATTLEWashington98199GRP-8444···MEDICARE-ADV-B
ENRENR-1105912026-01-16T03:18:24ZJerryMSandoval1950-03-17UHC-94166-85•••-••-0567N/ANULL1736 CENTRAL AVEAustinTX·78705GRP-5547·SELECT-EPO
ENRENR-1285212026-03-27T03:59:23Z·AndrewB.··Hunt2008-11-21UHC-90052-31•••-••-8289756-952-5173·andrew.hunt@gmail.com7960 Meadow LnMesaAZ85209GRP-6691NAVIGATE-HMO
ENRENR-1163592026-03-18T03:26:11ZMATEOOTUCKER·1953-05-13UHC-12070-86•••-••-3830348-510-1636MATEO.TUCKER74@ICLOUD.COM278 Spring StreetAtlantaGA30396GRP-4192MEDICARE-ADV-A
ENRENR-1210542026-05-23T09:03:08Z YukiJKelley6/27/2007uhc-53122-07•••-••-8767·8748814105-4912 HARBOR BLVDColumbusOH43279GRP-9218NAVIGATE-HMO
ENRENR-1295162026-08-17T18:24:34ZKEVINYMARSHALL·04/04/1997UHC-22454-97•••-••-2768(771) 469-0933KEVIN.MARSHALL@HOTMAIL.COM8744 LAKE VIEW ROADGilbertArizona85259-2357GRP-4208SELECT-EPO
ENRENR-1123512026-09-12T04:43:33ZANNAS.CARLSON1992-01-24UHC-22854-38•••-••-17826602947481anna.carlson@outlook.com2529 Sunset BlvdGilbertAZ85252GRP-2034MEDICARE-ADV-B
ENRENR-1229052026-02-12T00:36:40Z·lawrence—russell1981-02-16UHC-68841-12•••-••-4930·(662) 319-4772·UNKNOWN7206 VALLEY VIEW DRIVE··Miamifl33112-5137GRP-5228MEDICARE-ADV-B
ENRENR-1045342026-02-23T22:21:33ZAna··BPeters3/16/1979UHC-03564-03•••-••-9574+1 870 450 6530—6986 Desert Sky BlvdAustinTX78716GRP-4927OPTIONS-PPO
ENRENR-103278 2026-03-23T19:50:38ZJason—Garza2003-03-24UHC-11309-94•••-••-8942-···jason.garza@outlook.com9491 HIGHLAND AVENUEGlendaleAZ85395GRP-5466NAVIGATE-HMO
ENRENR-1131042026-02-14T18:01:31ZBEVERLY—CRAWWFORD2006-09-16NULL•••-••-3106·(529) 896-1910UNKNOWN8793 VALLEY VIEW DRJacksonvilleFL32200GRP-0800CORE-HMO
ENRENR-1052522026-06-18T13:57:05ZHENRYRMILLS07/24/1943··UHC-00734-23•••-••-1401(572) 337-2649N/A4169 CHURCH STREETTempeAZ85222GRP-9043NAVIGATE-HMO
ENRENR-1011992026-05-25T00:45:52ZAngela·JGardner1939-02-11·UHC-38497-83•••-••-3144—angela.gardner@icloud.com1589 JEFFERSON AVEPlanoTX75016GRP-8839OPTIONS-PPO
ENRENR-1216972026-01-13T05:53:17ZSTEVEN—JORDAN··1952-07-11UHC-75588-91•••-••-6945NULLsteven.jordan6@outlook.com1330 BAYSHORE DRIVEMiamiFL33177GRP-2107CHOICE-PLUS-PPO
ENRENR-1105212026-02-16T21:16:30Z CHARLESB·BURTON1975-07-25··UHC-47128-17•••-••-2710256-278-5250charles.burton12@aol.com8927 Spring Street··CHANDLERAZ85234··GRP-2740MEDICARE-ADV-A
ENRENR-1366982026-01-29T06:50:16ZmadisonF·armstrong11/26/1938UHC-15551-67•••-••-68224154165390madison.armstrong77@proton.meNULL--—GRP-8479CHOICE-PLUS-PPO
ENRENR-1147622026-01-12T10:58:20Zcarlos—spencer1952-05-26UHC-03040-35—(572) 281-9371CARLOS.SPENCER@GMAIL.COM1250 SAGE CTMinneapolisMinnesota·55429GRP-4688MEDICARE-ADV-B
ENRENR-1412162026-08-22T19:02:59Z Edwards, MarkE—19561011UHC-45206-33•••-••-10897097737311·mark.edwards47@aol.com7708 Highland AvenueEden Prairie··Minnesota55339-9719GRP-7170MEDICARE-ADV-A
43,101 rows, page 112 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:37.752Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty