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-1011212026-07-31T05:38:43ZJoshua—Boyd1942-10-13UHC-44465-98•••-••-197216659110609-7685 Mesa DrJacksonvilleFL32212GRP-4958MEDICARE-ADV-B
ENRENR-1014382026-03-21T04:00:12ZthomasJwalker10/5/1989UHC-43323-39•••-••-185114109704364·-6661 Grand AvenueTempeAZ85277GRP-8997CORE-HMO
ENRENR-1030852026-04-07T04:41:50ZCarter, Patrick——1986-11-22UHC-68722-56•••-••-8707593.378.6815patrick.carter11@icloud.com9383 Washington St Apt 4SAN DIEGOCA92101GRP-8900MEDICARE-ADV-B
ENRENR-108360 2026-10-18T15:40:40ZNICOLE—SANTIAGO13-07-1969··UHC-39042-85•••-••-5860(953) 996-5306nicole.santiago44@aol.com9805 BroadwayMinneapolisMN55440GRP-8504medicare-adv-b
ENRENR-1045572026-08-12T00:58:23ZTheresaSReedDec 22, 1961UHC5293536··•••-••-6474934-421-8578UNKNOWN4038 Oak StPhoenixAZ85067GRP-2621NAVIGATE-HMO
ENRENR-1225852026-09-04T16:20:26ZJacob—Reyes28-07-1998UHC3935180•••-••-9103+1 653 772 3905JACOB.REYES83@GMAIL.COM2180 River RoadTucsonAZ85764-4066GRP-3899··OPTIONS-PPO
ENRENR-1026702026-08-16T11:39:46ZSandraF.Wong10/17/91UHC6482908•••-••-4338—sandra.wong@gmail.com2833 Ocean AvenueOrlando·FL32845·GRP-9500SELECT-EPO··
ENRENR-1155622026-07-25T21:13:02ZANDY—EVANS10/25/88UHC-10411-09UNKNOWN(907) 774-4026andrew.evans@proton.me4471 Desert Sky BoulevardNashvilleTN37243GRP-0809NAVIGATE-HMO
ENRENR-1264012026-02-04T00:01:53ZEvelyn··—Delgado10/05/61UHC-46372-43•••-••-4585(354) 368-6826NULL495 Church StPlanoTXUNKNOWN··GRP-4662CORE-HMO
ENRENR-1057912026-01-11T01:28:16ZJOYCEQRYAN2008-06-13·UHC-02549-23•••-••-8196(357) 864-1578JOYCE.RYAN@OUTLOOK.COM4345 Pine DrTampaFL33652GRP-2734CHOICE-PLUS-PPO
ENRENR-1235262026-09-04T00:23:16ZLucas, Paul——06/15/46UHC-80625-58··•••-••-05487796597606PAUL.LUCAS@AOL.COM3616 Camelback Rd··JACKSONVILLEFL32262GRP-1550NAVIGATE-HMO
ENRENR-1149372026-04-03T17:19:21ZMARIANABEDWARDS05/15/62UHC-92193-98•••-••-2140(619) 370-0629mariana.edwards@hotmail.com5454 Camelback RoadJacksonvillefl32242GRP-4488CHOICE-PLUS-PPO··
ENRENR-1251902026-04-13T10:55:34ZCrawford, SarahI—7/11/1975UHC-51995-26•••-••-7387-null··1056 FOREST AVENUETEMPE··az85252GRP-1993NAVIGATE-HMO
ENRENR-1225722026-02-15T11:49:38ZSott G—Jensen1954-05-20··uhc-67218-05•••-••-2414+1 358 528 8149scott.jensen25@outlook.com1537 SAGE COURTNashvilleTN37267GRP-0499MEDICARE-ADV-B
ENRENR-1214992026-07-22T00:31:30Z Simmons, WilliamF.—1940-08-12UHC-29547-53•••-••-2129UNKNOWNwilliam.simmons@hotmail.com3201 APACHE BLVDNashvilleTN37224-1800GRP-6072·NAVIGATE-HMO
ENRENR-1161332026-02-13T16:09:17ZJORDANDWHEELER1954-09-25··UHC-10993-15•••-••-7777(850) 778-6892jordan.wheeler@aol.com9746 Mesa DrMESAAZ85258GRP-0169MEDICARE-ADV-A
ENRENR-1260392026-05-30T23:00:34ZHenry—NelsonJan 14, 2001UHC-21083-67•••-••-3007988-891-1125—1059 Central AveDallasTX75260GRP-7859MEDICARE-ADV-A··
ENR ENR-1191922026-09-12T19:19:50ZSantiagoMWoods1999-07-20UHC-32440-04•••-••-1829+1 657 893 5566N/A1535 HILLCREST ROADSEATTLE··wa98113GRP-3762CHOICE-PLUS-PPO
ENRENR-1303252026-06-27T03:27:24ZloganTrivera16-08-1943UHC-59528-38—(584) 696-1880logan.rivera2@hotmail.com1232 SAGE CTSan AntonioTX78226·GRP-2854SELECT-EPO
ENRENR-1079242026-05-26T12:07:51ZMarilyn—Alexander06-02-1940UHC-20423-25-(794) 635-4986MARILYN.ALEXANDER@AOL.COM9678 Indian School RoadATLANTAGA30397GRP-4101CHOICE-PLUS-PPO
ENRENR-1323262026-09-14T23:35:22ZPaul—Harper1964-03-14UHC-17112-43•••-••-6444·6246930955·paul.harper1@proton.me7744 Ridge RdScottsdaleArizona85209GRP-4930SELECT-EPO
ENRENR-1393802026-06-26T09:03:42Z·OliviaSJackson08/05/1939UHC-00850-94•••-••-6840562-669-8509olivia.jackson46@hotmail.com8395 Highland Avenue #437DallasTX75286-9542GRP-4477CORE-HMO
ENRENR-1063632026-10-16T07:27:05ZLAURENQJAMES19650405UHC-45123-42UNKNOWN3897590217lauren.james84@icloud.com9798 Main StreetTucsonAZ85732GRP-4312CORE-HMO
ENRENR-121751 2026-02-15T12:38:46ZShirley····Diaz1960-11-11UHC-24783-79•••-••-03927149270807-6942 SAGE CT Apt 15AustinTX78743GRP-9468CHOICE-PLUS-PPO
ENRENR-1047052026-01-24T19:06:39ZJEFFREY··BBUTLER4/9/1961UHC-23786-41•••-••-1849520-660-9486·jeffrey.butler@icloud.com689 CHURCH STFresnoCA93765-7781GRP-5738CORE-HMO
ENRENR-1219782026-05-05T17:40:43ZJosephGStephens1976-06-10UHC-41715-69··•••-••-2967456.226.9095—4627 Lake View Road Apt 16Dallas···TX75250GRP-7660MEDICARE-ADV-B
ENRENR-1051712026-02-11T04:23:45ZAMY—WAGNER··1956-09-09UHC-05819-84•••-••-6537+1 611 286 7706null1324 Bayshore DriveCOLUMBUSOH43269GRP-1053MEDICARE-ADV-B
ENRENR-1089722026-08-17T03:41:37ZJose—Hart1969-06-25UHC-94161-65•••-••-5230—null3185 PINE DRIVEJacksonvilleFL32299GRP-7084CORE-HMO
ENRENR-1205672026-04-07T02:48:49ZRONALD—HOFFMAN8/16/1958UHC-16807-53•••-••-3748(989) 219-9266ronald.hoffman69@outlook.com··8607 OCEAN AVENUETucsonAZ-GRP-7685NAVIGATE-HMO
ENRENR-1240632026-01-17T22:42:55ZLindaA··OBrien·1962-06-07UHC-16985-12•••-••-4414(392) 249-9740linda.obrien@gmail.com7746 Palm DrDALLASTX75211GRP-6122CHOICE-PLUS-PPO
ENRENR-1338202026-07-21T23:53:33ZBobbyU.Schultz19410226UHC-04795-68•••-••-95104404742418BOBBY.SCHULTZ82@OUTLOOK.COM2048 River RdChandlerAZ85289GRP-4604MEDICARE-ADV-A
ENRENR-1393602026-06-03T08:56:18ZJanetV.Brooks1947-06-20UHC-85481-76•••-••-6381353-344-1545janet.brooks13@proton.me1910 Lake View Rd··AUSTINtx78797GRP-5788SELECT-EPO
ENRENR-1390022026-04-19T09:44:12ZAMANDA—AGUILAR12/09/1969UHC-80419-53•••-••-4222(516) 484-7329··amanda.aguilar@outlook.com-null····nullGRP-4881OPTIONS-PPO
ENRENR-1159102026-06-09T07:55:50ZPammela··Hunt1955-10-25UHC-33974-06•••-••-73799553073739—8769 MEADOW LNDallasTX75298GRP-6001OPTIONS-PPO
ENRENR-1015942026-04-18T01:59:53ZJordaanGCruz01/23/2008UHC-28356-94•••-••-5966972.455.2637—4114 SPRING STPlanoTX75047GRP-6230MEDICARE-ADV-A
ENRENR-1422252026-03-29T23:48:49ZJeffrey—Bishop1982-07-25UHC-69223-22•••-••-5416—jeffrey.bishop@outlook.com1751 Desert Sky BlvdScottsdaleArizona85205GRP-3460OPTIONS-PPO
ENRENR-1124522026-09-21T08:13:05ZAnna—Knight04/28/65UHC-63812-96•••-••-8561261-933-2749anna.knight@gmail.com8390 Oak StTempeAZ85206GRP-9388MEDICARE-ADV-A
ENRENR-1246172026-09-07T04:31:00ZChrsitianA.Estrada19920302··UHC-18584-05•••-••-24378767803639-2599 Main StSan DiegoCA92116GRP-2830MEDICARE-ADV-B
ENRENR-1258652026-05-19T18:56:05Z weberDjudy1951-08-07UHC-42362-55•••-••-3988696.453.7777UNKNOWN4384 SPRING STREETLos Angelesca90081GRP-0693CORE-HMO
ENRENR-1104072026-05-10T07:56:17ZDENNIS—HART1994-12-15UHC-52556-86•••-••-39254162975677···DENNIS.HART@ICLOUD.COM4934 JEFFERSON AVENUEJacksonvilleFL32207-7920GRP-5396··SELECT-EPO
ENRENR-1249812026-01-14T17:40:10ZANN—MARTINEZ2006-09-21UHC-19690-85··UNKNOWN2039082871ann.martinez53@yahoo.com3769 HIGHLAND AVE Apt 39HoustonTX·77030GRP-5736medicare-adv-b
ENRENR-1218742026-07-21T18:17:41ZCatherine—Larson9/11/1982UHC-72733-44•••-••-0671430-938-4532·CATHERINE.LARSON@ICLOUD.COM3061 Highland AveDallasTX75226GRP-0769··SELECT-EPO
ENRENR-1234102026-09-02T17:48:50ZJake—Schmidt1969-03-25UHC-25356-26—5413923289jacob.schmidt@proton.me7946 Oak StreetColumbusOhio43211GRP-8489MEDICARE-ADV-B
ENRENR-1014912026-01-24T08:51:43ZShirley··Griffin19971019UHC-13733-19•••-••-3122638-994-1304—6768 Main StTucsonAZ85760GRP-9344medicare-adv-a
ENRENR-1315142026-10-12T18:32:22ZThomas—Lee8/16/1944UHC-50821-71•••-••-0752(596) 211-1858thomas.lee@outlook.com1963 Sunset BlvdAustinTX78757GRP-6972CHOICE-PLUS-PPO
ENRENR-1064632026-07-14T23:53:29ZJohn—·Howard1961-10-80UHC-27071-31•••-••-3438345-479-7241john.howard@aol.com7836 Ridge RoadPhoenixAZ85031GRP-9422·MEDICARE-ADV-B
ENRENR-1068782026-06-09T03:54:32Z Teresa····Grant2004-01-23UHC-34244-99··•••-••-36964019309706teresa.grant@yahoo.com7586 Elm StreetHoustonTexas77023·GRP-8126OPTIONS-PPO
ENRENR-1296862026-07-03T12:36:45ZJAMESE.SANDOVAL2003-01-26UHC-22538-54•••-••-6499852-929-5995james.sandoval@aol.com3485 Desert Sky Blvd Apt 29AtlantaGA30388··GRP-6454select-epo
ENRENR-1374722026-03-24T11:44:47ZOliviaB·Jenkins09-09-1989UHC-31191-56NULL973.668.5211olivia.jenkins52@hotmail.com1921 MESA DR··DallasTX75256GRP-1909··SELECT-EPO
ENRENR-100793 2026-06-29T01:00:44ZKATHERINE—SANDERS1987-01-25··UHC-96221-61•••-••-8173437-402-5859KATHERINE.SANDERS32@YAHOO.COM7744 Sage Ct··Los AngelesCA90044GRP-8929CORE-HMO··
43,101 rows, page 183 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:40.319Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty