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-1423972026-08-01T19:47:30ZAmberD.Ruiz1947-11-07UHC7060168•••-••-5084(828) 841-8858amber.ruiz@hotmail.com·9109 Union StreetScottsdaleAZ85281GRP-0230MEDICARE-ADV-B
ENRENR-125014 2026-05-02T07:25:11ZSophia—Rogers4/17/1999UHC-44369-43•••-••-0432nullsophia.rogers58@yahoo.com1710 Hillcrest RdAustinTexas78795GRP-5292CHOICE-PLUS-PPO
ENRENR-1120742026-08-30T20:59:43Z·ZACHARYO.NICHOLS09/11/1973UHC-39053-23•••-••-5525(634) 494-2060zachary.nichols92@aol.com7771 HARBOR BOULEVARDAtlantaga·30378-7502GRP-6806SELECT-EPO
ENRENR-1109142026-09-26T12:32:32ZMATTHEWI.HAMILTON05-09-1992UHC-62583-91•••-••-94905527562708null7984 Main StColumbusOH—GRP-6318navigate-hmo
ENRENR-1173672026-06-01T00:47:32ZHarold—Matthews19780224UHC-67154-41•••-••-3745330.526.8321harold.matthews87@icloud.com176 Union StreetMesaAZ85278GRP-3763CORE-HMO
ENRENR-1049812026-04-23T08:07:38ZFrank—Bailey7/8/1960UHC9930417•••-••-9299+1 819 437 8034frank.bailey59@outlook.com6013 Central AveAustin··TX78787-4296GRP-7493SELECT-EPO
ENRENR-1322202026-07-15T00:27:54Z·angela—schmidt1954-10-27UHC-44104-53•••-••-74185445080270N/A7539 Canyon RdTEMPEAZ··85245GRP-0666MEDICARE-ADV-B
ENRENR-1021932026-04-23T16:28:14ZDanielleXTurner15-07-1993UHC7723439•••-••-6872—danielle.turner20@gmail.com1754 Market Street·TucsonAZ85738GRP-9979CHOICE-PLUS-PPO
ENRENR-1336812026-04-25T17:25:03ZGarza, NicholasZ—1984-11-25·UHC-27340-32—475-527-6839-2807 Grand AveLos Angelesca90035GRP-3591MEDICARE-ADV-A
ENRENR-1333482026-03-31T11:23:14ZROGERZ.GRANT1976-09-03UHC-53202-79•••-••-0881·(958) 647-0976ROGER.GRANT@AOL.COM1253 Forest AveAUSTINTX78773GRP-3615CHOICE-PLUS-PPO
ENRENR-136649 2026-04-22T20:18:30Z·Youung, ChristineI.—1978-10-04UHC-29927-75•••-••-5071+1 696 390 5112CHRISTINE.YOUNG@AOL.COM6594 Sunset BoulevardOrlandofl32870GRP-6504CHOICE-PLUS-PPO
ENRENR-1191632026-08-03T03:27:58ZMARIAANACROBERTS5/14/1964UHC-24113-38··•••-••-452918964119895-8309 LINCOLN WAYScottsdaleaz85268GRP-0217MEDICARE-ADV-B
ENRENR-1335082026-04-10T18:18:46ZOMAR—VALDEZ1961-04-21·UHC-08703-94•••-••-72657395475822OMAR.VALDEZ36@YAHOO.COM6802 Highland AveScottsdaleAZ85215GRP-0347CORE-HMO
ENRENR-1090572026-06-27T03:09:33ZCharlotte—·Dominguez1956-06-30UHC-94279-14null+1 828 302 5672charlotte.dominguez18@gmail.com2235 Sunset BlvdSacramentoCA95856GRP-5384MEDICARE-ADV-B
ENRENR-1235032026-02-20T17:41:09ZTylerDDunn05-08-1994UHC-82908-10•••-••-5073(689) 343-3204null948 BroadwaySan DiegoCA··N/AGRP-1484CHOICE-PLUS-PPO
ENRENR-1174792026-02-19T21:17:40ZTerry··Stephens1946-12-02UHC-30868-70•••-••-25455136081terry.stephens@outlook.com·156 Indian School RoadFRESNOCANULLGRP-4151CHOICE-PLUS-PPO
ENRENR-1156152026-07-25T15:35:07ZRamos, Isabella——04/02/44UHC-87503-44N/A906.690.1206NULL6189 LAKE VIEW RDPHOENIXArizona85084GRP-6940MEDICARE-ADV-B
ENRENR-1082382026-03-20T09:12:21ZVincent—Rodriguez5/23/1950UHC-00309-05•••-••-0006(663) 627-7464UNKNOWN6259 Oak StreetTucsonAZ85753-2698GRP-3814MEDICARE-ADV-B
ENRENR-1121702026-10-13T06:29:23ZHannahN.Oliver7/8/1951UHC-60027-75•••-••-1382(255) 802-0399hannah.oliver@proton.me—·NULL—NULLGRP-3558SELECT-EPO··
ENRENR-1239612026-03-18T21:06:04ZCarolyn—·Daniels2004-07-04UHC6680989•••-••-2506515.498.6964—2466 MEADOW LANEAtlantaGeorgia30367GRP-6159OPTIONS-PPO
ENRENR-1392652026-01-31T05:58:20ZAnnV.Davis11/05/63UHC-52157-17•••-••-9555nullann.davis56@proton.me1149 Apache Blvd·HoustonTX77067··GRP-5256···OPTIONS-PPO
ENRENR-1423282026-05-09T22:32:14ZRonaldR.Ford1963-10-11UHC-97301-31•••-••-21013682391657RONALD.FORD94@GMAIL.COM137 Hillcrest RdAtlantaGA30351GRP-7807CHOICE-PLUS-PPO
ENRENR-1141682026-08-21T06:29:28ZCRISTIANQ.KENNEDY··1986-12-09UHC-57080-27•••-••-3212329-892-1453CHRISTIAN.KENNEDY49@ICLOUD.COM2667 Meadow LnCharlotteNC28298GRP-9950CHOICE-PLUS-PPO
ENRENR-1314812026-03-16T16:48:57ZPatricia—Gibson2002-06-06UHC-43497-48—3894389925·patricia.gibson79@aol.com·9178 Cedar LaneDenverCO··80281GRP-7209·medicare-adv-a
ENRENR-1044642026-02-03T06:49:39ZCAROL—PAYNE1992-05-27UHC-26841-91•••-••-58562176357001CAROL.PAYNE@HOTMAIL.COM678 Lincoln WayJacksonvilleFL32236GRP-7390CORE-HMO
ENRENR-1044882026-04-29T13:45:52ZLORI—HOWELLJun 5, 1980UHC-61801-30•••-••-2448577-209-5440lori.howell80@hotmail.com8241 Harbor BoulevardPhoenixAZ85056GRP-3574MEDICARE-ADV-A
ENRENR-1154962026-03-28T21:33:26ZJESSICAVJONES1796-11-17UHC-61731-01•••-••-3039(594) 532-1428-371 MEADOW LANEGLENDALEAZ85346GRP-1604MEDICARE-ADV-A
ENRENR-1050562026-03-12T21:41:48ZRomero, Eugene——07/19/1943UHC-60321-13•••-••-39472473534734—6759 Lake View Rd·OrlandoFL32857GRP-3052MEDICARE-ADV-B
ENRENR-1253622026-07-06T11:05:08Zvincent—reyes10/23/2006UHC-96719-08··•••-••-71126833492357vincent.reyes16@outlook.com8555 Park PlacePlanoTX75016GRP-7587OPTIONS-PPO
ENR ENR-1417842026-04-22T20:08:38ZJeffreyCWong1974-01-07UHC-21929-40N/A(694) 705-9492—1203 Elm StreetJacksonvilleFL32218GRP-8926MEDICARE-ADV-A
ENR ENR-1350792026-08-04T16:37:26ZDANIELTPOWELL1981-10-07UHC-81002-41•••-••-1406214-327-6638DANIEL.POWELL@YAHOO.COM8638 Highland Ave··GlendaleAZ85365GRP-1471MEDICARE-ADV-A
ENRENR-1237802026-04-25T04:35:01ZDouglas—TorresnullUHC2414265•••-••-3867405-588-4518NULL5494 Sage CourtFresnoCA93731GRP-5622MEDICARE-ADV-B
ENRENR-1341302026-02-23T17:32:53ZCharles·NTucker02/23/1961UHC-91411-90•••-••-87432409215406charles.tucker@icloud.com6126 Indian School RoadMesaAZ85219GRP-0564navigate-hmo
ENRENR-1141102026-01-25T10:55:01Z Estrada, WeiU—1987-08-21uhc-45426-98•••-••-8501357.426.9615N/A5179 Pine DrLOS ANGELESca90075GRP-4420OPTIONS-PPO
ENRENR-1276392026-05-18T03:54:55ZMorrison, Sofia——1940-06-09UHC-81614-18•••-••-5259NULLsofia.morrison99@outlook.com2934 Canyon RoadGilbertAZ85286GRP-3067OPTIONS-PPO
ENRENR-1174462026-02-16T01:38:32ZERICSBARNES03/02/1982UHC-25921-67•••-••-4450+1 761 441 2740UNKNOWN927 PALM DRIVE #906CharlotteNC28260GRP-0767OPTIONS-PPO
ENRENR-1083282026-08-09T15:17:12ZVIRGINIA·G.CARTER·1958-06-24UHC-07463-33•••-••-9692+1 841 898 4941··virginia.carter83@hotmail.com·9246 LAKE VIEW RDMINNEAPOLISMN·55485GRP-2355CORE-HMO
ENRENR-1257202026-07-25T08:12:15ZJackXVazquez09/18/2006UHC-72930-75··—723-743-7229—7549 BroadwaySan AntonioTX78282-1935GRP-2673MEDICARE-ADV-B
ENRENR-1225472026-06-27T11:28:56ZBENJAMIN—LEE04/22/57uhc-90262-12•••-••-91479726391636benjamin.lee35@yahoo.com·7616 LAKE VIEW ROADPlanoTX75006GRP-8182CHOICE-PLUS-PPO
ENRENR-1215602026-09-23T01:52:04ZScott—Lopez1953-08-14UHC5451693NULL9158117scott.lopez14@icloud.com7734 HILLCREST ROADTucsonArizona85738GRP-4640MEDICARE-ADV-A
ENRENR-1095742026-03-20T00:03:28ZBRYAN—CAMPBELL··19471203UHC-92636-35•••-••-97739889904699bryan.campbell@hotmail.com321 WILLOW COURT··TucsonAZ85706··GRP-6565··CHOICE-PLUS-PPO
ENR ENR-1373212026-08-22T09:29:30ZMICHAEL—·HOLMES1999-05-15UHC-66752-04•••-••-4471(472) 628-6045MICHAEL.HOLMES32@HOTMAIL.COM6651 BroadwayDallasTX75263GRP-6598SELECT-EPO
ENRENR-1033122026-04-01T00:21:26ZStephanieT.Garcia02/21/40uhc-63671-83•••-••-60179407001839·stephanie.garcia@outlook.com8820 Central Avenue #550SacramentoCA95857GRP-2830MEDICARE-ADV-B
ENRENR-1312522026-06-20T11:42:31ZJACOBECASTRO1939-02-15UHC-77925-48•••-••-90983185904625jacob.castro43@hotmail.com·5178 Ridge RdAustinTX78782GRP-8601MEDICARE-ADV-B
ENRENR-1403532026-02-23T05:05:12ZMateoWMejiaJul 18, 1973UHC-54113-80•••-••-455019359640967MATEO.MEJIA@PROTON.ME6275 Mesa DrNashvilletn37283GRP-9910NAVIGATE-HMO
ENRENR-1019782026-10-16T12:33:13ZDonald—OrtegaJan 16, 1993UHC-91896-80··•••-••-209215273284197donald.ortega88@yahoo.com1958 WASHINGTON STREETCHARLOTTENC28263GRP-9760MEDICARE-ADV-A
ENRENR-1196762026-07-25T05:40:04ZMychaelSWagner1948-10-09UHC-90968-48•••-••-5451(816) 964-7551MICHAEL.WAGNER@AOL.COM4408 Ridge RoadEden PrairieMN55304GRP-7945SELECT-EPO
ENRENR-1160122026-08-23T23:36:06ZEvelynJ.Ortiz2000-03-11UHC-86501-72•••-••-9152(712) 511-2272EVELYN.ORTIZ@PROTON.ME5848 SAGE COURTPLANOTX75025GRP-8464SELECT-EPO
ENRENR-1303712026-08-18T20:31:45ZJoyce··—Ray09/04/42UHC-03509-93•••-••-5497(916) 291-4096N/A4023 Central AveMesaAZ85232GRP-1452OPTIONS-PPO
ENRENR-1160362026-07-14T03:48:41Z·EMMAZ.SIMMONS2000-06-02UHC-69392-65•••-••-5100(652) 360-1649EMMA.SIMMONS@AOL.COM1515 Cedar LaneAUSTINTX78781GRP-1940CHOICE-PLUS-PPO
43,101 rows, page 233 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.613Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty