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-1176402026-09-09T03:43:19ZAMBERPWEAVER1948-04-09UHC-51563-55•••-••-2629969-256-5825NULL9210 Mountain View DriveGLENDALEAZ85340GRP-8608·NAVIGATE-HMO
ENRENR-1083142026-04-14T23:39:35ZGonzales, AngelaX—2007-10-14UHC-43571-53•••-••-76216109320115angela.gonzales8@aol.com7833 Sage CtTampaFL33670···GRP-2627CHOICE-PLUS-PPO
ENRENR-1189522026-06-12T22:04:56ZVincentHChen1963-03-09UHC-42867-23•••-••-1551nullUNKNOWN9867 Ridge RdEden PrairieMN55343GRP-5062·MEDICARE-ADV-B
ENRENR-1193302026-10-14T21:56:59ZeugeneXbaker1971-09-16UHC-10971-56•••-••-1726(692) 490-3266EUGENE.BAKER@AOL.COM1833 Meadow LnMesaArizona85291GRP-6153OPTIONS-PPO
ENRENR-1236642026-04-11T03:15:54ZchristineC.delgado8/20/1941UHC-74487-51UNKNOWN420-912-5213NULL6732 ELM STREETJacksonvilleFL32237GRP-6176OPTIONS-PPO
ENRENR-1167612026-02-06T09:18:57ZWayne—Bell1972-01-26UHC-89231-52—8789631639wayne.bell@hotmail.com8916 Main StHoustonTexas·77089GRP-9582CORE-HMO
ENRENR-116682 2026-03-10T01:09:58ZDylan—Hunt09/25/41UHC-06624-53•••-••-54218346267586dylan.hunt96@aol.com2655 UNION STChandlerAZ85247GRP-4312··SELECT-EPO
ENRENR-1401232026-09-16T10:48:43ZKathleenUArnold1967-02-03UHC-42875-96•••-••-5525—kathleen.arnold70@yahoo.com5324 Willow CtMinneapolisMN55496GRP-1295OPTIONS-PPO
ENRENR-1106152026-06-23T12:36:03ZKathleenW·CarterOct 28, 2004UHC-09188-64•••-••-1834(832) 688-2961kathleen.carter@aol.com2278 Pine DriveMiami··FL33160GRP-3907CHOICE-PLUS-PPO
ENRENR-1374652026-06-22T01:44:49ZEugene—Mendez11/24/1942·UHC-68273-18•••-••-8210911-630-4699eugene.mendez52@icloud.com1937 Meadow LnChandlerAZ85244GRP-8210SELECT-EPO
ENRENR-1290342026-07-09T17:38:05ZDanielle—Gutierrez1939-05-01uhc-79211-66-16052483731··danielle.gutierrez75@outlook.com·487 FOREST AVETampaFLUNKNOWNGRP-6419MEDICARE-ADV-B
ENRENR-1015682026-09-24T10:51:17ZETHAN—MALDONADO1970-10-25·UHC-81823-63•••-••-0416(567) 737-8172null2378 Sunset Blvd··Phoenix··Arizona85028GRP-6721MEDICARE-ADV-B
ENRENR-1304452026-03-23T21:45:25Z Nicholas··—Jordan1977-09-21UHC-29419-58N/A4803346486nicholas.jordan28@icloud.com1304 HILLCREST ROADPHOENIXAZ85082GRP-9675navigate-hmo
ENRENR-1105152026-06-13T22:24:49ZSandraD.Cunningham·02/24/60UHC4310881•••-••-9632(248) 374-8310·sandra.cunningham@outlook.com6712 Pine Drive··CharlotteNC··28226GRP-8166MEDICARE-ADV-B
ENRENR-1370092026-02-20T19:23:48ZRachel··Murphy1950-12-22UHC-95286-42•••-••-9907(531) 565-0119RACHEL.MURPHY2@AOL.COM9310 Mesa DrAustin··TX78706GRP-8840SELECT-EPO
ENRENR-1160842026-09-19T06:10:29Z Katherine—Howell2006-04-08UHC-24751-04•••-••-98927366408835KATHERINE.HOWELL@AOL.COM6115 Indian School RoadLos Angelesca90004GRP-7537···CORE-HMO
ENRENR-1361722026-01-28T09:37:51ZSantiago—Mooreno1987-05-16UHC-69964-04•••-••-5636+1 825 759 1822santiago.moreno@outlook.com4391 BroadwaySacramentoCA95863GRP-2992navigate-hmo
ENRENR-1161882026-01-08T20:42:04ZTheresa—Larson1967-11-03UHC-75355-53•••-••-0954+1 626 642 5939-5031 CHURCH STDALLASTX75296GRP-8159MEDICARE-ADV-A
ENRENR-108315 2026-06-01T23:35:06ZANN—ROSE1941-12-19UHC3585997•••-••-79523732873228ANN.ROSE97@OUTLOOK.COM7264 Sunset BoulevardSeattleWAN/AGRP-4192CHOICE-PLUS-PPO
ENRENR-1100742026-06-02T09:09:44ZJanet—FoxJul 5, 1995UHC6996818•••-••-9945(484) 509-9574-9667 Mesa Drive·Columbusoh43263GRP-8391CHOICE-PLUS-PPO
ENRENR-1255312026-06-02T20:09:08ZCatherine—Hart··09/20/63UHC-18151-19•••-••-1178(239) 706-6541catherine.hart16@icloud.comnullUNKNOWN—UNKNOWN···GRP-3663MEDICARE-ADV-A··
ENRENR-1296622026-07-28T08:13:58ZdeborahW·willis1975-02-17UHC-78282-13•••-••-907912116727261deborah.willis@aol.com·2399 HARBOR BLVDMiamiFlorida33157GRP-6619MEDICARE-ADV-B
ENRENR-1208942026-03-31T06:26:19ZAmber····Jones10/18/98UHC6700665•••-••-4409—amber.jones49@aol.com8598 Sage CtNashvilleTN37223GRP-5371CORE-HMO
ENRENR-1115832026-02-20T02:04:26ZRUSSELL—DELGADO··1982-08-10UHC-11581-57•••-••-8218+1 369 711 1327null8347 Harbor BoulevardATLANTAGA30379GRP-6509OPTIONS-PPO··
ENRENR-1217562026-07-14T15:42:50ZTimothy—Hunt1994-11-04UHC-38560-77··•••-••-3285(815) 520-2705TIMOTHY.HUNT@PROTON.ME·6853 Meadow LnGilbertAZ85274·GRP-9689OPTIONS-PPO
ENRENR-1252882026-03-29T09:37:46Z·BENJAMINKROGERS2002-02-03UHC3419645•••-••-083818713699659—8980 Bayshore DriveLos Angeles·CA90050GRP-4186SELECT-EPO
ENRENR-1243182026-04-08T00:09:38ZJack—Foster1972-09-24UHC-66216-51•••-••-366919614004710jack.foster@yahoo.com··2914 Elm StOrlando··fl32886GRP-7060SELECT-EPO
ENRENR-1016272026-02-26T11:09:30ZSandra—Montgomery1962-10-01UHC-06730-33•••-••-7603468.770.5268SANDRA.MONTGOMERY@GMAIL.COM38 Highland AvenueNASHVILLETN37281GRP-5718NAVIGATE-HMO··
ENRENR-1069542026-04-15T05:23:14ZJesseKTucker10/26/1956UHC-78551-20•••-••-1847·977-700-3172jesse.tucker@proton.me8484 Lincoln WayMesaAZ85208GRP-5397CORE-HMO
ENRENR-1175462026-08-14T23:25:29ZGonzales, LoganY—1986-07-13UHC-19729-25•••-••-6064NULLLOGAN.GONZALES@ICLOUD.COM6025 RIVER ROADOrlandoFlorida32899GRP-9814CORE-HMO
ENRENR-1176562026-09-24T06:41:45Z CAROL····HAMILTON2006-11-17UHC-47996-65•••-••-2879+1 619 374 2093carol.hamilton@yahoo.com9822 APACHE BOULEVARDFresnoCA93733·GRP-1119MEDICARE-ADV-A
ENR ENR-1316672026-06-14T21:24:53ZmargaretL···jacobs05/10/46UHC3253076•••-••-3595+1 849 970 0999MARGARET.JACOBS9@OUTLOOK.COM1750 Market StreetLos AngelesCalifornia90036GRP-6987CORE-HMO
ENR ENR-1126852026-04-15T01:23:21Z·Welch, TimothyJ.—19400608UHC-70708-35null805-208-3227null9298 LAKE VIEW RDTempeAZ·85293GRP-7297NAVIGATE-HMO
ENRENR-1130132026-07-03T08:39:13ZJason—Guerreo1949-07-19UHC-14738-35•••-••-3908·938-393-6989—1164 Indian School RdSeattleWA98130GRP-3440OPTIONS-PPO
ENRENR-105882 2026-02-26T01:53:11ZJoyceSOBrien1984-07-24UHC-99792-74•••-••-935712032506673JOYCE.OBRIEN1@YAHOO.COM1865 Desert Sky BlvdLos AngelesCA90017GRP-6208MEDICARE-ADV-B
ENRENR-1190422026-08-05T08:40:00ZCarolynIHerrera19650704UHC-83872-65•••-••-6416375-706-2283UNKNOWN7974 Washington StreetGILBERTArizona85261GRP-6691CHOICE-PLUS-PPO
ENRENR-110701 2026-01-24T05:47:56ZSarah—Mershall1941-06-20UHC-65902-14•••-••-08735417891031··SARAH.MARSHALL@GMAIL.COM4580 River Rd Apt 37TucsonAZ85708··GRP-1922MEDICARE-ADV-B
ENRENR-1096262026-03-27T00:38:40ZNicholas··Romero12/26/78UHC-10303-10•••-••-1537(687) 446-7699NICHOLAS.ROMERO@GMAIL.COM5771 Harbor BlvdDenver·CO80215GRP-5800MEDICARE-ADV-A
ENRENR-1168202026-04-10T13:41:20ZWei··—Johnson··0408-91-82UHC1825597NULL··794-503-4955—8648 Spring St Apt 24MiamiFL33183GRP-2312·CORE-HMO
ENRENR-1250332026-06-18T12:05:56ZRyanA.Gonzalez1945-02-20UHC-77717-80•••-••-55999038917608··ryan.gonzalez83@outlook.com7455 Ridge RdDallas···TX75209GRP-1072OPTIONS-PPO
ENRENR-1142732026-01-22T14:47:13ZJulieBPerry11/10/1941··UHC-61280-68··•••-••-3043(602) 467-8671N/A7330 CANYON ROADSAN DIEGOCA92139GRP-3004NAVIGATE-HMO
ENRENR-1238472026-01-19T10:07:43ZAlexis—·Ortega·10/25/1967UHC-70156-56•••-••-9617572.947.8817alexis.ortega22@proton.me8143 Palm DrSAN DIEGOCA···92152GRP-1742CORE-HMO
ENRENR-1289082026-08-23T06:41:23ZPRIYA—ALLEN1991-02-12UHC-44110-15•••-••-2179575.279.6999PRIYA.ALLEN5@HOTMAIL.COM4591 Maple AvenueTAMPAFL33688GRP-5964CORE-HMO
ENRENR-1210732026-02-24T17:01:57ZMeyer, TerryT··—1989-09-11UHC-08100-59•••-••-4810(659) 994-4418-8620 Ridge RdEden PrairieMinnesota·55361GRP-3806MEDICARE-ADV-B
ENRENR-1036032026-04-17T18:44:51ZWilson, Timothy——03/24/1995UHC-70158-96•••-••-6750+1 607 371 2460TIMOTHY.WILSON@AOL.COM9453 Central AveOrlandoFL32816-5475GRP-6843MEDICARE-ADV-A
ENRENR-1369622026-01-23T16:58:15Zmatthew—sandoval01-02-1956UHC-42875-42•••-••-2940(806) 563-3752UNKNOWN7835 Cedar Ln Apt 18AustinTX78786·GRP-6562MEDICARE-ADV-B
ENRENR-1175642026-07-09T03:35:02ZElijah—Boyd2000-09-03·UHC-80648-57•••-••-6568666.395.8132··elijah.boyd@yahoo.com5611 Hillcrest RdSan DiegoCA92156GRP-6218NAVIGATE-HMO
ENRENR-1303822026-05-10T09:58:26ZJeremyC.Hanson·Jul 21, 1950UHC-08296-83•••-••-5496987-823-1090jeremy.hanson@gmail.com7782 Meadow LnColumbus·OH43278GRP-5089CORE-HMO··
ENRENR-1210172026-02-03T09:16:44ZGerald—Watson1948-07-13UHC-46897-26•••-••-2715813-723-5944GERALD.WATSON@ICLOUD.COM··2674 Harbor BlvdScottsdaleAZ85218GRP-4612·OPTIONS-PPO
ENR ENR-1378902026-07-02T05:51:14ZRachelXSilva1984-10-03UHC-68698-25•••-••-4457(829) 539-2191RACHEL.SILVA11@OUTLOOK.COM8470 Cedar LnHoustonTX77091GRP-1168MEDICARE-ADV-B
43,101 rows, page 48 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.680Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty