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-1323572026-01-22T01:06:40ZstephaniePcarroll1982-03-23UHC-24239-35null2367548316stephanie.carroll19@icloud.com8281 SUNSET BLVDNashvilleTN37230GRP-7357CHOICE-PLUS-PPO
ENRENR-1027232026-03-12T18:21:00ZHelen—Muray12/22/1952UHC-97100-19•••-••-882714794401429helen.murray@hotmail.com432 River RoadLos AngelesCalifornia90051GRP-4120MEDICARE-ADV-B
ENRENR-1276372026-03-04T08:18:14ZDanielRJimenez1956-02-18UHC-92103-63•••-••-9952651-243-7620null··4505 Hillcrest RoadSacramentoCA95817GRP-1145CHOICE-PLUS-PPO
ENRENR-143092 2026-08-25T20:42:49ZSarah—Harvey03/07/94UHC-63568-85•••-••-4549—SARAH.HARVEY89@ICLOUD.COM9589 Church StPhoenix··Arizona85073GRP-3807OPTIONS-PPO
ENRENR-1211672026-07-02T09:09:40ZHannah—Simpson1995-01-10UHC-46037-77N/A5683791456·HANNAH.SIMPSON51@YAHOO.COM7540 Camelback Rd #733TucsonAZ85725GRP-7205NAVIGATE-HMO
ENRENR-1352492026-03-16T10:05:25ZFerguson, Jordan——1942-06-09UHC-68665-03•••-••-6251(325) 491-9247jordan.ferguson8@icloud.com6753 Sage CtSEATTLEWAnullGRP-4330MEDICARE-ADV-B
ENRENR-1199802026-10-18T04:55:28ZDANIEL—HUNTER·1990-12-19UHC-08541-87•••-••-6612701-967-2836N/A8524 PINE DRHoustonTX77025GRP-3261OPTIONS-PPO··
ENRENR-1232552026-07-31T08:49:47ZPETER··HOLMES09/19/1992··UHC-13145-65N/A(259) 839-4422··PETER.HOLMES@YAHOO.COM7786 Highland AveSacramentoCA95893GRP-7799MEDICARE-ADV-B
ENRENR-1208952026-09-13T02:52:32ZJENNY—WONG1988-03-02UHC-29328-48•••-••-8197723-562-4918—2502 Sunset BlvdSAN ANTONIOTX78258GRP-1781OPTIONS-PPO
ENRENR-1377422026-03-11T23:27:28ZJohnny—Banks··1954-12-04UHC-23402-48NULL(203) 357-5143john.banks@aol.com6295 Jefferson Ave··HoustonTX77006·GRP-2323OPTIONS-PPO
ENRENR-1419592026-07-31T13:02:48ZRomero, CherylM.··—03/12/81UHC-34011-49•••-••-9807(304) 608-8910cheryl.romero75@aol.com6536 Highland AvenueGlendaleAZ85334GRP-0461NAVIGATE-HMO
ENRENR-1060122026-05-15T06:13:14ZSean—Morreno19890828UHC-94786-19null768-969-9642SEAN.MORENO84@YAHOO.COM8250 Elm Street·San DiegoCA··92188GRP-4938NAVIGATE-HMO
ENRENR-1195562026-04-29T23:02:48ZNicole—Banks1949-11-11·UHC-40533-39•••-••-491313984418821NICOLE.BANKS71@PROTON.ME2501 Apache BlvdTampaFlorida—GRP-2975CHOICE-PLUS-PPO
ENRENR-1015202026-02-28T23:16:59Z·JudyEFord24-07-1982UHC0424246•••-••-86819522956028judy.ford33@hotmail.com··3524 Market StTucsonAZ85793GRP-8018OPTIONS-PPO
ENRENR-1279542026-05-29T08:34:54ZvictoriaGkelley2004-12-11UHC-58308-81—5188705victoria.kelley70@hotmail.com·3826 Washington StreetGlendaleAZ·85321GRP-3526MEDICARE-ADV-B
ENRENR-1294302026-04-15T18:53:07ZShileyUBakerUNKNOWNUHC-45715-13•••-••-5151nullshirley.baker28@icloud.com2489 Lake View RdTucsonAZ85782GRP-1102·MEDICARE-ADV-A
ENRENR-1069632026-09-19T17:44:38ZDANIELLEQ.JACKSON1954-10-11UHC-84944-11•••-••-9249(265) 293-8377DANIELLE.JACKSON14@YAHOO.COM3506 Spring StDENVERCO80238·GRP-9953CHOICE-PLUS-PPO
ENRENR-1119012026-05-20T17:55:44ZAlan·DBukeUNKNOWNUHC-49588-49•••-••-864413868987890alan.burke76@aol.com7703 WILLOW COURTGlendaleAZ85310GRP-8390CHOICE-PLUS-PPO
ENRENR-1349782026-02-01T15:56:24ZAbigailXSantiago1947-05-18UHC-93295-36•••-••-8731492-352-5911NULL2848 Apache Boulevard·ScottsdaleAZ·85222GRP-9945··OPTIONS-PPO
ENRENR-1147222026-02-04T07:10:17Z·ChristinaB.Daniels1977-01-11··UHC-02242-53•••-••-63917742388213CHRISTINA.DANIELS41@GMAIL.COM5640 VALLEY VIEW DRIVESAN DIEGOCA—GRP-6717NAVIGATE-HMO
ENRENR-1375442026-10-04T01:28:45ZHiroshi··JAnderson·1956-12-13UHC2094017N/A6677878937·····8110 Desert Sky BlvdNashvilleTN37282GRP-4970medicare-adv-a
ENRENR-1091492026-08-23T22:47:29ZDeborahZ.Banks1964-01-22UHC-57459-80—9638990368—8093 OAK STREETPHOENIXAZ85022-1186GRP-2283NAVIGATE-HMO
ENR ENR-1299102026-08-02T00:38:38ZJACKH.DUNCAN1956-08-24UHC-24560-59•••-••-9632+1 795 957 4653··1814 CENTRAL AVENUEPhoenixAZ·85021GRP-7029NAVIGATE-HMO
ENRENR-1259532026-04-11T07:26:23ZseanK·morgan·2005-10-24UHC-75819-92N/A+1 643 637 2880sean.morgan@aol.com2936 CANYON ROAD··Las VegasNV89133GRP-5304OPTIONS-PPO
ENRENR-106889 2026-06-09T23:23:22Z·HelenYSimmons27-07-1991UHC-81740-57•••-••-9544—HELEN.SIMMONS47@GMAIL.COM3226 Central AvenuePhoenixAZ··85060GRP-6950MEDICARE-ADV-B··
ENRENR-1424322026-06-08T15:38:27ZSharon—SullivanOct 16, 2003UHC-69191-51•••-••-7429439-854-8119···sharon.sullivan13@proton.me6075 Elm St #439NashvilleTN37275GRP-1564CHOICE-PLUS-PPO
ENRENR-1348732026-06-09T20:17:09ZFisher, SamuelW··12/19/63uhc-86502-09·UNKNOWN221-400-6909samuel.fisher@gmail.com·1226 PALM DRIVEDenverCO80298GRP-1326MEDICARE-ADV-B
ENRENR-1097382026-06-10T19:00:49ZSophiaXBennett1992-02-24UHC-18922-15•••-••-89865229162765sophia.bennett52@gmail.com2822 UNION ST··DallasTX75239-4999GRP-0480CHOICE-PLUS-PPO
ENRENR-1257382026-06-21T18:01:20Z·JustinQ·Murphy91521021UHC-52723-74•••-••-3263374.757.6957justin.murphy56@aol.com8829 Pine DrDallasTX75279GRP-0792CHOICE-PLUS-PPO
ENRENR-1004412026-02-20T19:59:19ZKEITHFCOLLINS11/21/1956uhc-13066-46•••-••-1328—keith.collins@hotmail.com9739 Market StreetNashvilleTN37208GRP-0666CHOICE-PLUS-PPO
ENRENR-1231922026-03-04T09:06:20Z·Frank—SantosOct 25, 1972UHC-87051-08•••-••-74619422313149FRANK.SANTOS60@GMAIL.COM1611 Meadow LnGLENDALEArizona85345GRP-7584NAVIGATE-HMO
ENRENR-1092372026-09-01T01:03:05ZReed—Kelly06/21/81UHC-12779-47•••-••-479513486418768kelly.reed@icloud.com640 Washington Street·PhoenixAZ·85050GRP-8358MEDICARE-ADV-B
ENR ENR-1124282026-07-06T22:58:40ZJoan····Dominguez2006-01-28UHC-90621-19•••-••-4035347-387-3436JOAN.DOMINGUEZ59@YAHOO.COM3534 CANYON RD #389MiamiFlorida33119GRP-1226NAVIGATE-HMO
ENRENR-1316632026-01-15T06:14:22ZKATHRYN—JENKINS··1957-01-17UHC-08226-92null241-336-7945KATHRYN.JENKINS49@PROTON.ME1346 Washington StreetChandlerAZ85262GRP-1493MEDICARE-ADV-A
ENRENR-1328332026-03-03T11:01:22ZHiroshiJCaretr1967-11-03UHC-65778-19•••-••-5450(357) 925-7462hiroshi.carter63@icloud.com5104 Ocean AveDenverCO80296GRP-6919OPTIONS-PPO
ENRENR-1092582026-02-17T02:49:31ZJEREMY K—MITCHELL·2003-04-22UHC-39524-30•••-••-7315229-503-9534··N/A7007 Camelback RoadNashville··TN··37206GRP-3427MEDICARE-ADV-B
ENRENR-1369022026-07-28T13:35:20ZMEILTRAN19981101UHC-37090-48-4997853600mei.tran15@aol.com9864 Hillcrest RdColumbusOH43263GRP-3803··MEDICARE-ADV-B
ENRENR-1365052026-01-23T08:05:51ZBryan—Mitcchell02/03/2000UHC-04861-43•••-••-7760·(664) 705-9422bryan.mitchell37@outlook.com7267 Valley View DrDallas·TX75283GRP-5993OPTIONS-PPO··
ENRENR-1093302026-10-13T13:58:34ZalbertBcastillo19891226UHC-11718-23•••-••-6078(557) 566-3500UNKNOWN—nullNULL—GRP-2687OPTIONS-PPO
ENRENR-1271842026-04-25T02:01:05ZMadison Z··—Daniels—UHC-22765-24•••-••-7949(937) 524-1910null5065 Desert Sky Boulevard··MesaAZ-GRP-5290NAVIGATE-HMO
ENRENR-1233212026-02-06T04:33:06ZJustinVMurphy1954-02-10UHC-77321-35•••-••-4532331-200-6189justin.murphy@gmail.com5061 Park PlGlendaleAZ85344GRP-9904CORE-HMO
ENRENR-1158972026-04-30T04:01:06Z·roger—gilbert1941-04-18UHC-77627-53NULL16597618400roger.gilbert2@outlook.com7000 Desert Sky BlvdTampaFL33684GRP-3594NAVIGATE-HMO
ENRENR-1371962026-05-18T22:25:14ZOliver, BettyM—Sep 12, 1971UHC-97972-62•••-••-9411(632) 238-3388betty.oliver@proton.me7470 Church StreetDenverCO80258GRP-4579·CORE-HMO
ENRENR-104433 2026-05-28T12:31:14ZKeithALawrence01/22/73UHC-56811-34—(340) 470-5848keith.lawrence@proton.me7530 Maple AvenueDenverCO80247GRP-3972OPTIONS-PPO
ENRENR-1097652026-04-06T07:19:23ZKiing, JosephC—1982-12-04UHC-46651-11—703.836.2946N/A9130 Broadway Apt 37JacksonvilleFL—GRP-9640MEDICARE-ADV-B
ENRENR-1190742026-09-12T11:44:02ZMoore, Kyle——Feb 16, 1969UHC-40857-32•••-••-1280672.313.6911KYLE.MOORE@OUTLOOK.COM6882 Camelback RdMinneapolisMN55458GRP-4645CORE-HMO
ENRENR-1386022026-01-18T08:30:32ZGARYMDOMINGUEZ1991-10-24UHC-20825-25•••-••-82947743756327GARY.DOMINGUEZ@YAHOO.COM5896 Camelback RdAustinTX78798GRP-7095MEDICARE-ADV-A
ENRENR-1141562026-09-06T08:37:51ZBryan—West0206-10-02UHC-06733-87•••-••-43609818814683BRYAN.WEST81@GMAIL.COM5578 Main StreetMinneapolisMN55420GRP-2094CHOICE-PLUS-PPO
ENRENR-1264392026-08-15T04:14:22Z ChristineIOlson12/03/1984UHC-78090-69•••-••-3185(826) 481-1734CHRISTINE.OLSON4@YAHOO.COM7619 Pine DriveFRESNOCA93738GRP-7174MEDICARE-ADV-A
ENRENR-1348022026-08-19T08:40:05ZKimUBans14-08-1973uhc-47323-56UNKNOWN2288029057kimberly.banks@aol.com1608 Pine Drive #286MiamiFL33145··GRP-4156CHOICE-PLUS-PPO
43,101 rows, page 277 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:43.434Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty