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-1204252026-05-17T05:59:10ZPAMELAXSANTIAGODec 17, 1980UHC1126120•••-••-2173·9189099029pamela.santiago@icloud.com3766 Palm DriveAtlanta·GA30373GRP-1707MEDICARE-ADV-B
ENRENR-1287902026-06-14T08:42:30ZCharlieHAnderson2000-08-09UHC-80354-11—841-259-0730charles.anderson56@icloud.com4353 Baseline RoadPhoenixAZ85057GRP-1446CORE-HMO··
ENRENR-1051522026-05-07T22:45:43ZEmily—Montgomery1940-11-03··UHC-50496-48•••-••-0401(620) 710-0493—8482 BAYSHORE DRIVEDallasTX75212GRP-9319options-ppo
ENRENR-1125772026-08-02T16:04:55ZAustin··PMoore2001-02-07UHC-97161-95•••-••-5035715-603-7257austin.moore62@yahoo.com829 Meadow LnPlanoTX75005GRP-1055choice-plus-ppo
ENRENR-1334462026-02-17T16:11:49ZEric—Moreno19740903UHC-96118-34•••-••-7237(667) 498-6759-··2639 Harbor BoulevardMesaAZ85299GRP-4304SELECT-EPO
ENRENR-1191372026-04-06T01:26:50ZJoiceATran1939-04-24uhc-45030-13•••-••-8326(544) 629-0568N/A3124 Grand Avenue #749MiamiFlorida33162-3227··GRP-2908OPTIONS-PPO
ENRENR-1094262026-05-07T13:53:02ZBillyZBaker03/22/2008UHC-91951-40UNKNOWN(464) 983-5518—7750 SUNSET BOULEVARDSeattleWAUNKNOWN··GRP-0482CORE-HMO
ENRENR-1411962026-05-28T17:40:06ZPriyaNJames1/11/1976UHC-56355-15•••-••-943813105964427priya.james@proton.me1251 Indian School Rd·SeattleWA98170-8323GRP-4590OPTIONS-PPO
ENRENR-1084292026-03-12T06:03:43ZJohnstonV.Ryan11/26/83UHC-51949-51•••-••-1447394-749-2415····3311 Mountain View DriveTampaFL33669GRP-3548CORE-HMO··
ENRENR-1191142026-05-06T22:45:53Zmateo—perez2003-01-14UHC-46817-61•••-••-6138(900) 939-4352mateo.perez@gmail.com2630 Maple AvenueTampa··Florida33636GRP-7687·NAVIGATE-HMO
ENRENR-1220122026-06-10T18:28:35Z BrandonFMorris·1961-09-27UHC-64581-74•••-••-2377+1 582 963 1175brandon.morris50@hotmail.com3009 MAPLE AVETampa··FL33626GRP-3120SELECT-EPO
ENRENR-1101212026-08-21T01:44:10ZMICHELLEO.LUNA2001-07-03UHC-80345-60•••-••-4033N/A·MICHELLE.LUNA1@HOTMAIL.COM2555 Pine Drive··Los Angeles·CA90092GRP-5396CORE-HMO
ENRENR-1339442026-09-12T09:13:02ZstephanieS.collins12/6/1959UHC-83864-87•••-••-56298162159665stephanie.collins@outlook.com195 Main StreetDallasTX75253··GRP-9790CHOICE-PLUS-PPO
ENRENR-1413012026-09-09T06:08:05ZJezse U.—Bennett1940-12-16UHC-57219-23•••-••-09749488340392JESSE.BENNETT@PROTON.ME3288 Forest AveJacksonvilleFL32201GRP-2611SELECT-EPO
ENRENR-1394392026-05-23T14:37:22Zlawrence—hoffman1971-02-10UHC-12016-65··•••-••-0088953-943-2023lawrence.hoffman10@hotmail.com5415 River RoadMinneapolisMinnesota55416-9199GRP-3130SELECT-EPO
ENRENR-1237642026-01-08T17:01:00ZAnaEMorgan11-12-1970UHC-89767-67—9302634432UNKNOWN8899 BroadwaySCOTTSDALEArizona85296GRP-7550CHOICE-PLUS-PPO
ENRENR-1001642026-10-14T08:12:53ZNancy—PatelMay 17, 1982UHC-76230-29•••-••-004313948821622NANCY.PATEL@OUTLOOK.COM5592 Oak StTucsonAZNULLGRP-4884OPTIONS-PPO
ENRENR-1053882026-02-22T05:14:20ZKathryn—Diaz1991-05-13UHC-61746-34•••-••-18465030036·N/A5960 Palm DrGLENDALEAZ85310GRP-7416OPTIONS-PPO
ENRENR-1389422026-09-04T11:02:12Z ARJUN—MARTINEZApr 11, 1977UHC-00639-60•••-••-1967626-365-0166arjun.martinez@icloud.com5901 CENTRAL AVEPhoenixAZ85091GRP-7449··CORE-HMO
ENRENR-1125372026-09-12T18:43:49ZLarson—Jen21-06-1989UHC-10361-83•••-••-2353(265) 533-0194-4725 Elm StPhoenixAZ85048GRP-5773SELECT-EPO
ENRENR-1187212026-01-19T10:05:41ZKEITH—OWENS19951016··UHC-04440-15•••-••-0822(246) 794-0638KEITH.OWENS57@OUTLOOK.COM2171 Baseline Rd·MinneapolisMN55445GRP-2139CHOICE-PLUS-PPO
ENRENR-1237092026-10-04T10:15:55ZAlexis··FHowell2005-09-05UHC-00431-38•••-••-47785859599109··—128 CEDAR LANEFresnoCA93746GRP-5532NAVIGATE-HMO
ENRENR-1430062026-01-22T06:54:05ZMadison A—Taylor1976-11-16UHC-93143-71•••-••-1211698-379-4310-·2393 Canyon RoadGILBERTAZ85235GRP-4542SELECT-EPO
ENRENR-1418382026-09-12T22:39:01ZAnaP··Lewis··1951-03-11—•••-••-4803392-466-9478ana.lewis40@proton.me7077 Palm Drive #323AustinTX78718-7605GRP-8304MEDICARE-ADV-A
ENR ENR-1308822026-01-09T03:52:05ZChalrotte—Chen19780120··UHC-29497-60•••-••-4199758.779.6006charlotte.chen@proton.me5075 Canyon RdSEATTLE·WA98148GRP-5903CORE-HMO
ENRENR-1416142026-03-17T01:08:22ZharoldYalvarado1974-10-05uhc-97987-12-424-762-2889NULL2637 CHURCH STREETSan AntonioTX78216GRP-8855CHOICE-PLUS-PPO
ENRENR-1088892026-06-11T00:18:35ZMarthaS.Walker1980-04-09UHC-95006-84•••-••-0134(669) 943-8139·null5060 BROADWAYLos AngelesCA90067GRP-3008CHOICE-PLUS-PPO
ENRENR-1120452026-06-11T18:56:37ZLogan—Phillips19860417UHC-77399-76•••-••-4503651-221-4377··9755 Bayshore DriveMINNEAPOLISMN55411GRP-0646SELECT-EPO
ENRENR-1202342026-06-18T00:42:06Zpamela··—wilson1942-07-21UHC-01249-68•••-••-8814(967) 834-9119PAMELA.WILSON@AOL.COM·175 CAMELBACK ROADSan AntonioTX78280··GRP-3873··OPTIONS-PPO
ENRENR-1097542026-04-19T11:30:40Zchristopher·X.adams26-06-1956UHC-88794-67•••-••-39373212790christopher.adams@aol.com4764 SPRING STREET·AtlantaGA30333GRP-5259MEDICARE-ADV-B
ENRENR-1274002026-02-25T06:06:01ZBaker, Donald··Z.—01/10/1982UHC-82382-16•••-••-01528504186524donald.baker21@aol.com9253 APACHE BOULEVARD #996SeattleWA98135GRP-9731MEDICARE-ADV-B
ENRENR-140473 2026-08-02T00:18:54ZPamelaBMorrison1982-10-21·UHC-42829-49NULL493-308-6896—3466 DESERT SKY BLVDColumbusOH43274GRP-0856MEDICARE-ADV-B
ENRENR-129213 2026-01-20T00:20:02ZJeremyD·Richads1952-10-11UHC-56171-40•••-••-6437948.784.9432UNKNOWN2676 Highland AveTempeAZ85293GRP-7837MEDICARE-ADV-A
ENRENR-1060542026-09-12T23:56:48ZSTEPHANIE····REED02/26/94UHC-72165-55•••-••-160418794793904—7279 BAYSHORE DRIVESeattleWA98103-8014GRP-1330MEDICARE-ADV-A
ENRENR-121280 2026-06-11T02:05:04ZThomasE··Harvey1977-10-25UHC-55914-02•••-••-6366·(967) 229-3694thomas.harvey14@icloud.com6330 CEDAR LANEPlanoTX75096GRP-6065core-hmo
ENRENR-1313022026-06-30T23:40:13Zethan—wood1961-04-06UHC-73564-91—(381) 922-8901ETHAN.WOOD60@AOL.COM··5108 LINCOLN WAYNashvilleTNnullGRP-3279CHOICE-PLUS-PPO
ENRENR-1278102026-08-12T13:41:01Zalice··Agonzalez1968-02-14UHC-10661-45•••-••-4801(910) 824-8546alice.gonzalez@gmail.com8376 RIDGE RDSeattle·WA98132·GRP-4208CHOICE-PLUS-PPO
ENRENR-1318922026-10-08T05:04:42ZAmyIParker1963-04-23UHC-88714-34•••-••-0161(339) 401-0900—9756 Lincoln WayLos AngelesCA90067-4590·GRP-4891OPTIONS-PPO
ENRENR-1110772026-03-13T03:20:42ZClark, LoganJ—1938-12-28UHC-88925-67•••-••-4218·521-738-8404logan.clark@gmail.com217 Elm StreetGilbertAZ85265-7262GRP-2639MEDICARE-ADV-A
ENRENR-1247152026-08-01T11:09:04ZPHILIPM.DANIELS1954-01-19UHC-38699-45•••-••-0744248.522.7287PHILIP.DANIELS@GMAIL.COM6156 UNION STSacramentoCA95885GRP-6236MEDICARE-ADV-A
ENRENR-1423132026-09-28T04:25:37Z·PRIYAU··BURKE19750215UHC-37641-26•••-••-9131956-665-9500PRIYA.BURKE50@AOL.COM1398 Ridge RoadChandlerAZ—GRP-9306SELECT-EPO
ENRENR-1198192026-01-11T00:58:25Zalbert—·tran2004-12-08NULL—741-842-7978albert.tran@hotmail.com2632 CEDAR LN #907··AustinTX78779GRP-4529CHOICE-PLUS-PPO
ENRENR-1335972026-03-12T13:33:59ZPriyaA.···Sims1966-12-18UHC-97920-34•••-••-6190880-390-2513·priya.sims18@yahoo.com9306 JEFFERSON AVEAustinTX78761GRP-5033CORE-HMO··
ENRENR-1095962026-09-26T22:01:39ZVirginiaWWeber19730404UHC1063506•••-••-6321-virginia.weber1@hotmail.com2954 Oak StreetColumbusOH43204GRP-2307OPTIONS-PPO
ENRENR-1180962026-05-28T21:10:15ZKathryn—Hart1950-12-82UHC8738434•••-••-0556(706) 600-7087kathryn.hart@hotmail.com1571 MAIN STREETScottsdaleAZ85287GRP-3678MEDICARE-ADV-A
ENRENR-1052642026-04-14T03:38:23ZGEORGE—HOFFMAN1962-10-01uhc-52151-87•••-••-3591(559) 311-7743GEORGE.HOFFMAN53@OUTLOOK.COM1238 Palm DrHOUSTONTX77012GRP-8825SELECT-EPO
ENRENR-1010512026-08-02T09:05:01ZChristinaUMurray·1960-08-14UHC-86579-18•••-••-39403178013932christina.murray@hotmail.com1957 Sunset BoulevardMiamiFL33170GRP-0526MEDICARE-ADV-A
ENRENR-1220382026-01-27T11:37:29ZKimberly—Morrison1978-02-03··UHC-53270-68•••-••-74427077390896—·5491 WILLOW CTPlanoTX75030GRP-9407choice-plus-ppo
ENRENR-1398062026-09-14T19:58:32ZOmarIDaniels1928-04-27UHC-69239-50•••-••-0036368-632-9394omar.daniels@aol.com5275 Park PlGILBERTAZ85219GRP-5773NAVIGATE-HMO
ENRENR-1151182026-01-20T09:19:12ZEdward—·Ward08/01/1939UHC-15071-61•••-••-2021(440) 360-0369edward.ward22@gmail.com4128 Washington StreetAtlantaGeorgia30301GRP-0328MEDICARE-ADV-A
43,101 rows, page 57 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.689Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty