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-1346512026-08-17T05:59:03ZARJUN R—LE1990-10-15UHC-80955-18····(572) 342-1302arjun.le54@outlook.com7332 Bayshore DrOrlandoFlorida32837GRP-2696MEDICARE-ADV-A
ENRENR-1352202026-04-25T12:59:12Z·Austin, BrendaP—19520921UHC-54657-53•••-••-16034455042178brenda.austin@aol.com4937 LAKE VIEW ROADGilbertAZ85206·GRP-3485OPTIONS-PPO
ENRENR-1177842026-03-10T03:26:55ZMorgan, CarlosQ—·1953-02-25UHC-42276-59—(722) 797-5482carlos.morgan@aol.com4886 Valley View DrSan DiegoCA92104GRP-3893SELECT-EPO
ENRENR-1057872026-02-20T16:51:49ZGregoryWNicholsDec 14, 1965UHC-53161-34•••-••-6765736-687-2442·gregory.nichols@proton.me6469 Central AvenueMinneapolisMN·55464GRP-8790SELECT-EPO
ENRENR-1373752026-04-20T21:28:34ZAnn—·Castillo2007-02-16UHC-18811-99•••-••-2886+1 228 896 5974ann.castillo49@icloud.com9439 Ridge RdTucsonAZ85715GRP-7694MEDICARE-ADV-B
ENRENR-1110422026-02-01T08:36:42Z·CATHERINEMGOMEZ1998-01-01UHC-43505-08—4822010233·CATHERINE.GOMEZ@ICLOUD.COM2035 Lake View RoadATLANTAGA30395GRP-7918OPTIONS-PPO
ENRENR-1252682026-01-22T06:12:43ZAnthonyU.Wells06/12/55UHC-46535-81•••-••-068318936221346anthony.wells30@outlook.com8883 CENTRAL AVE·GLENDALEAZ85336GRP-8928CHOICE-PLUS-PPO
ENRENR-1364222026-03-24T22:09:12ZShirley—Vasquez08/15/1997UHC-77814-68-701-286-2573shirley.vasquez83@icloud.com7831 Harbor BoulevardLas Vegas·NV89119GRP-5648OPTIONS-PPO
ENRENR-1100882026-05-23T22:58:00ZVALENTINAOROS1972-02-25UHC-56720-56•••-••-2723+1 621 992 1124valentina.ross37@yahoo.com3006 Cedar LaneOrlandofl32807GRP-9018MEDICARE-ADV-B
ENRENR-1319482026-09-25T05:55:47ZSCOTTUCARROLL1982-11-03UHC-62971-04•••-••-0842(562) 336-4329··SCOTT.CARROLL51@OUTLOOK.COM2582 Baseline RdHouston·TX··GRP-9458CORE-HMO
ENRENR-1088062026-02-16T19:17:56Z frankRphillips··1964-06-02UHC-96189-22•••-••-5118(737) 549-5362NULL168 PARK PLACEEden Prairie··MN55380GRP-5278CORE-HMO
ENRENR-1426972026-06-17T06:42:29ZAnaKMurphy1949-09-21UHC-16418-56•••-••-6227695.817.5225—2678 BAYSHORE DRTempeAZ85265GRP-3255MEDICARE-ADV-B
ENRENR-1018012026-03-12T01:13:47ZNATHAN····MEDINA28-10-1982··UHC-13087-98•••-••-3736(519) 914-7895NATHAN.MEDINA45@YAHOO.COM7987 Ridge RdGlendaleAZ85362GRP-3726MEDICARE-ADV-B
ENRENR-1328082026-04-28T17:01:03ZHiroshi··—Greene··Jun 26, 1953UHC2627501•••-••-5842+1 878 462 2437N/A4815 Ridge RoadLos AngelesCA90009GRP-3620···MEDICARE-ADV-B
ENRENR-1035242026-05-25T21:28:42Z TylerZOrtega03/04/94UHC-79593-68•••-••-6147(388) 584-0802tyler.ortega94@outlook.com9415 CHURCH ST #886FRESNOCA93712GRP-6837SELECT-EPO
ENRENR-128935 2026-07-15T13:12:39ZLUCIAN.RICHARDSMay 8, 1945UNKNOWN•••-••-9798(605) 590-7315lucia.richards@outlook.com6167 RIDGE RDSACRAMENTOCA95884GRP-9710·SELECT-EPO
ENRENR-1057322026-07-09T02:47:27ZAlexisLCarlson1986-10-10UHC-24466-11•••-••-35519758568268alexis.carlson87@yahoo.com8114 Apache BlvdEden PrairieMinnesota55394GRP-9528CHOICE-PLUS-PPO··
ENRENR-1026012026-02-07T06:52:45ZKARENF.SMITH·03/15/48UHC-81838-34•••-••-9320576.696.8741karen.smith@yahoo.com1470 Mountain View DriveChandlerAZ85299GRP-4034·SELECT-EPO
ENRENR-1017282026-08-13T05:20:31ZVINCENTOROBERTS1986-05-22UHC-46711-68•••-••-2495414-629-8403vincent.roberts@gmail.com4910 Mountain View DriveSacramentoCA··95852GRP-6478CORE-HMO
ENRENR-1084442026-04-08T12:43:29ZJeanEDavis12/2/1979UHC-95558-74•••-••-4088(712) 382-8977JEAN.DAVIS12@AOL.COM4831 Highland AveNashvilleTN37203··GRP-7024·CORE-HMO
ENRENR-1295002026-02-25T17:27:42ZBRADLEY····HARRIS1955-09-02··UHC-69817-65null16826444591·bradley.harris26@outlook.com·6229 Maple AveATLANTAGA30398GRP-1802CHOICE-PLUS-PPO
ENRENR-1236542026-03-25T23:14:11ZTran, JoshuaW—2003-08-04UHC-48255-08—883-834-3537JOSHUA.TRAN61@OUTLOOK.COM700 Market StSEATTLEWA98101GRP-4854MEDICARE-ADV-A
ENRENR-1264542026-02-27T23:21:25Zvincent—thomas1954-10-26UHC-47963-24•••-••-9084UNKNOWNvincent.thomas66@yahoo.com2815 Market StSacramentoCA·95843GRP-9724MEDICARE-ADV-B
ENRENR-1185942026-07-24T09:38:20Z·BenjaminO.Padilla1974-09-23UHC-34202-68•••-••-9764215.523.0319benjamin.padilla86@hotmail.com6589 Forest AveAustinTexas··78768GRP-5626OPTIONS-PPO
ENRENR-1428162026-06-06T08:07:24ZBrendaTValdez2009-09-01UHC6266749•••-••-0423(448) 485-9853brenda.valdez78@hotmail.com3190 Union StDenverCO80248··GRP-2847··NAVIGATE-HMO
ENRENR-1160162026-07-27T14:48:22ZFrancesL.Robertson1961-08-21·UHC-36293-77•••-••-33197300707frances.robertson50@proton.me4835 CHURCH STTUCSON··AZ85738GRP-5444MEDICARE-ADV-A
ENRENR-1236652026-08-11T05:55:25ZWest, JenniferF.····5/28/1962UHC-32000-97•••-••-0126-JENNIFER.WEST85@AOL.COM9635 CAMELBACK ROADAustinTX··-GRP-4875·CHOICE-PLUS-PPO
ENRENR-1178462026-02-05T15:48:39ZTheresa—McDonald19451119UHC-67029-07•••-••-321517229876265THERESA.MCDONALD69@GMAIL.COM9572 Baseline RoadGlendaleAZ85332GRP-1170MEDICARE-ADV-B
ENRENR-1271812026-02-06T18:51:29Z Parker, BrianS—1976-11-10UHC7236512•••-••-5175null—6467 Camelback RdPlanoTX75098-3654GRP-2131choice-plus-ppo
ENRENR-1201192026-07-15T00:38:04ZOlliver, Edward——4/20/2006UHC-36016-90•••-••-8346·(429) 464-9556edward.oliver96@proton.me2187 SAGE COURTColumbusOH··43206GRP-2703OPTIONS-PPO
ENRENR-1418072026-05-06T16:19:39ZMateo—Ortiz1968-01-20UHC-47672-96-·(710) 405-3784null9079 Grand Avenue Apt 1Austin·TX-·GRP-4250MEDICARE-ADV-B
ENRENR-1178332026-02-02T16:32:11ZAmanda—Spencr1981-09-04·UHC-64608-65•••-••-6774750-450-8448UNKNOWN··3959 MAIN STNASHVILLETN37282GRP-1570SELECT-EPO
ENRENR-1291272026-03-11T23:38:15ZKellyIReid1974-02-13uhc-13788-76•••-••-0848(858) 381-9449kelly.reid@yahoo.com7525 PALM DRIVEFresnoCA93721GRP-8560MEDICARE-ADV-A
ENRENR-1421182026-03-30T19:41:18ZBRUCE—COLLLINS1964-06-23UHC-15097-94•••-••-1230(620) 720-3422bruce.collins@proton.me··8936 Desert Sky BoulevardGilbertAZ85290GRP-6165OPTIONS-PPO
ENR ENR-1329822026-07-22T01:55:33Zbenjamin—martin9/19/1967UHC-36994-11··•••-••-4271655-744-1188·benjamin.martin17@gmail.com6483 Union StTempeArizona85253GRP-3582CORE-HMO
ENRENR-1331202026-10-06T20:55:53ZRyanSRuiz1597-02-17UHC-53770-84•••-••-28476706144707····1962 Central AvenueMinneapolisMN55469GRP-6494SELECT-EPO
ENRENR-1247732026-04-13T23:23:09ZAnna—Roebrts10-07-1991UHC-58410-46•••-••-7100·414.269.5631anna.roberts@icloud.com2391 Park PlTempeAZ85299GRP-0444MEDICARE-ADV-B
ENRENR-1336452026-01-22T19:46:29ZWillie—Richardson·11-11-1974UHC-00108-35•••-••-9060615.242.1262—1339 Cedar LaneAustintx78703-8826GRP-6732SELECT-EPO
ENRENR-1374632026-08-23T12:38:50Z·frances—lee05/01/1957UHC-90770-55•••-••-8397462.797.8086FRANCES.LEE@HOTMAIL.COM2460 Jefferson AveChandlerAZ85252GRP-0673SELECT-EPO
ENRENR-115862 2026-07-27T16:20:32ZMarianaRScott1995-02-26UHC-73872-66•••-••-0522(770) 831-6082mariana.scott@proton.me221 River RoadEden Prairie··MN55310-2325GRP-4270OPTIONS-PPO
ENRENR-1175772026-03-04T04:23:06ZGibson, Nick··—20050525UHC-22877-52··•••-••-4387287-678-4333·nicholas.gibson4@gmail.com8407 Ocean AveAustinTX78718GRP-1287·CORE-HMO
ENR ENR-1028122026-06-23T05:09:20ZWashington, GloriaR····1983-01-25NULL•••-••-98189639894896null9741 Palm DriveSeattleWashington98178GRP-3957NAVIGATE-HMO
ENRENR-1223562026-01-04T15:53:04Z·Willie—Ray02/03/62UHC-57120-48•••-••-7302+1 367 396 8182·WILLIE.RAY41@ICLOUD.COM4022 Grand AvenueDenverCO80234··GRP-2967CORE-HMO··
ENRENR-1185342026-04-10T14:16:11ZNoahJ.Gibson03-07-2006UHC-62288-38•••-••-6842709-664-0489noah.gibson61@yahoo.com7465 Meadow LaneAtlantaGA30395GRP-2258CORE-HMO
ENRENR-1119362026-06-20T14:17:40ZTerryB.Fullr1948-09-06UHC-32663-33•••-••-5341790-962-0221null6172 Canyon RoadAtlantaGA30341GRP-3988options-ppo
ENRENR-1092852026-05-21T15:02:35ZThompson, MadisonM—1995-01-11UHC-19680-93•••-••-2681(310) 350-5993MADISON.THOMPSON@GMAIL.COM9482 Highland AvenueSan Antonio·Texas78249GRP-9957MEDICARE-ADV-B
ENRENR-101251 2026-08-26T18:55:30ZJustin—Shew1971-02-13·UHC3680097UNKNOWN7232522359NULL9091 BASELINE RDEden PrairieMN55301GRP-6561··CORE-HMO
ENRENR-1313682026-05-25T19:36:38ZJoseZBurton1950-11-05UHC-66763-18•••-••-132716878842118null2697 Central AvenueSacramentoCA95870GRP-6882MEDICARE-ADV-A
ENRENR-1065672026-06-10T01:06:10ZEmmaLCarpenter1987-06-28UHC-64160-31•••-••-2014NULLEMMA.CARPENTER62@HOTMAIL.COM286 Market StreetJacksonvilleFL32295GRP-5262MEDICARE-ADV-A
ENRENR-1220562026-05-06T10:00:02ZRyan··KLewis12/14/1976UHC-02742-80•••-••-2062742-817-3851—3829 Maple AvenueOrlandoFL32800GRP-8440OPTIONS-PPO
43,101 rows, page 130 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.772Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty