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-1080262026-06-20T15:24:59ZLindaY··Plmer1940-08-17UHC-74204-04•••-••-3687922-563-2591linda.palmer@hotmail.com4786 Sunset Boulevard·DallasTX75228GRP-1097NAVIGATE-HMO
ENRENR-1293702026-08-30T20:58:36ZSarahUKelley1946-09-03UHC-44030-41•••-••-528517053860570sarah.kelley@proton.me9831 MOUNTAIN VIEW DR Apt 13·OrlandoFL32802GRP-2753CORE-HMO
ENRENR-1122142026-08-21T14:58:32ZSamNHarrison1979-07-20UHC-41931-54•••-••-65106039374956·samuel.harrison@proton.me2689 MOUNTAIN VIEW DRIVECharlotteNC28247-9911GRP-3948navigate-hmo
ENRENR-1239362026-04-17T10:47:00ZDylanC.·Reed2005-08-19UHC-39800-75•••-••-5914315-744-9919DYLAN.REED21@HOTMAIL.COM4465 Desert Sky Boulevard #550AustinTexas78735GRP-4858MEDICARE-ADV-A··
ENRENR-1370332026-05-05T17:30:09ZJasonGWoodJun 16, 1961·UHC-43940-86•••-••-3578596-971-8257null8619 Market StreetLos Angeles··CA90031GRP-7234CHOICE-PLUS-PPO
ENRENR-1081202026-05-17T17:01:07ZAmanda—Robertson7/4/1964UHC-15760-50null··—amanda.robertson@aol.com3885 MOUNTAIN VIEW DRFRESNOCA93769GRP-3804SELECT-EPO
ENRENR-1039602026-01-01T10:32:42ZGilbert, AaronI—09/11/1981UHC8091638N/A5335187121aaron.gilbert95@outlook.com1483 Hillcrest RoadNashvilleTN37287GRP-6079SELECT-EPO
ENRENR-1117812026-10-04T21:31:59ZJENNIFERKOLIVER1972-09-17UHC-58266-53•••-••-6693(712) 209-1092NULL8588 Union StreetOrlandoFL32874GRP-1207CHOICE-PLUS-PPO
ENRENR-1386332026-05-03T15:52:08ZJacob—RiceMay 27, 1997UHC6918890•••-••-8979——209 PARK PLACEMiamiFlorida33125GRP-6449CHOICE-PLUS-PPO
ENRENR-1340122026-01-17T23:59:57ZANNAG.HART·May 13, 1988UHC-08766-79•••-••-6096(421) 379-3374anna.hart99@hotmail.com8807 MESA DRIVESan AntonioTX78253GRP-6422MEDICARE-ADV-B
ENRENR-1263012026-03-21T18:11:44ZOMARU.STEVENS19701006UHC-20389-49··•••-••-089617394425307omar.stevens@proton.me1230 Church StreetAtlantaGA30397GRP-5670NAVIGATE-HMO
ENRENR-1083252026-04-21T18:08:18ZYUKI—PERRY12/26/1986UHC-54099-89•••-••-6815(204) 615-2118yuki.perry@outlook.com2416 Indian School RoadSan AntonioTX78299GRP-3578SELECT-EPO
ENRENR-1055812026-03-04T14:04:38ZArjun—Stephens1978-12-06UHC-35562-38•••-••-7685399.944.1594ARJUN.STEPHENS47@YAHOO.COM··7955 Mesa DrAustinTXN/AGRP-7344·OPTIONS-PPO
ENRENR-1402172026-06-21T15:29:01ZDONNA··SALAZAR1978-06-02UHC-40162-83•••-••-5781614.453.0709donna.salazar@icloud.com212 Forest Avenue··OrlandoFL32817GRP-8526MEDICARE-ADV-A
ENRENR-1257822026-02-08T03:25:30ZGeorge N.—Jenkins09/03/1939uhc-33895-29•••-••-9133+1 487 434 6376GEORGE.JENKINS25@AOL.COM9245 Canyon RdMiamiFL33112GRP-2600CORE-HMO
ENRENR-1367662026-07-10T08:10:49ZSTEVEN—CLARK1962-05-22UHC-26298-95•••-••-9837501.400.9902STEVEN.CLARK38@HOTMAIL.COM·8358 Ocean AveSAN DIEGOCA92154GRP-4057OPTIONS-PPO
ENR ENR-1401372026-06-16T22:44:59ZALEXIS—HAWKINS2000-11-03uhc-64557-63•••-••-9192497-736-5840alexis.hawkins64@aol.com9371 Spring StreetTempeArizona85258GRP-5948MEDICARE-ADV-B
ENRENR-130025 2026-08-13T09:32:04ZRuth—Jackson2003-08-16UHC4588335•••-••-09327248121502—8808 CAMELBACK ROADLas VegasNV89110GRP-6729CHOICE-PLUS-PPO
ENRENR-1080032026-01-04T17:57:35ZSTEPHENWMALDONADO06/16/1941UHC-08829-69•••-••-99566146437845stephen.maldonado@proton.me5247 Hillcrest RdSacramentoCA95839GRP-1871·medicare-adv-a
ENRENR-1008442026-03-04T00:46:54ZSpencer, LaurenN—Mar 13, 1956uhc-15892-51•••-••-416612393257247lauren.spencer9@yahoo.com9516 Valley View DrMesaAZ85280GRP-7211MEDICARE-ADV-A
ENRENR-1183052026-01-31T18:14:30ZBrian·SGutierrez8/15/1987UHC-44563-70•••-••-82667560860BRIAN.GUTIERREZ95@AOL.COM9166 UNION STREETFresnoCA93771GRP-9573SELECT-EPO
ENRENR-1285172026-09-06T07:06:03Z·BarrbaraTMartinze··1961-08-20UHC8075639•••-••-2009309-442-8887barbara.martinez@outlook.com3302 Sunset BoulevardFresnoCA93706GRP-9961MEDICARE-ADV-A
ENRENR-1080592026-04-08T12:23:50ZMaldonado, AandaE—1984-08-28UHC-23142-76•••-••-19409667020673amanda.maldonado45@gmail.com—UNKNOWN-—GRP-9621NAVIGATE-HMO
ENRENR-1141822026-10-10T00:56:26ZHarold—Fox1946-07-09UHC-10508-05•••-••-9087697-826-7472HAROLD.FOX@AOL.COM8814 ELM STCOLUMBUSOH43242GRP-3092OPTIONS-PPO
ENRENR-1275522026-01-04T16:53:47ZDorothy—Ross··19941228·UHC-86526-56•••-••-26563168797479dorothy.ross90@proton.me9034 Cedar Lane··Eden PrairieMN55380GRP-4567·OPTIONS-PPO
ENRENR-1079722026-05-17T06:49:32ZJohn—Delgado07/14/90UHC7805381•••-••-2411(647) 835-0126-9808 MARKET ST·SACRAMENTOCA95873GRP-6873OPTIONS-PPO
ENRENR-1064912026-01-04T00:50:23ZCarolHWallace1959-08-03UHC-60601-66•••-••-51789105537carol.wallace@aol.com7950 Market StreetMiami··FL33177GRP-4465CHOICE-PLUS-PPO
ENRENR-140300 2026-05-16T03:42:35ZAustin E—Powell1998-07-26UHC-82867-57null755-491-5489austin.powell@hotmail.com1772 ELM STJacksonvilleFL·32206GRP-9217SELECT-EPO
ENRENR-1383882026-07-19T02:51:25ZAARON—SOTO2/27/1964UHC-37599-88•••-••-7700—AARON.SOTO@PROTON.ME7616 Elm Street··Phoenix··AZ85021GRP-2490NAVIGATE-HMO
ENRENR-1410642026-04-27T22:51:13ZFox, DeniseF—1938-11-17UHC-42854-34•••-••-7000(809) 227-4822denise.fox@aol.com4800 HILLCREST RDMesa·AZ85238GRP-1598MEDICARE-ADV-A
ENRENR-1419622026-04-10T23:59:45Z·DIANAGOLIVER1957-01-21UHC-62327-68•••-••-9653378-230-8589diana.oliver@hotmail.com2549 WASHINGTON STREETSan Diegoca92196GRP-1309MEDICARE-ADV-A
ENRENR-1059652026-08-09T21:51:34ZROGER—LAWRENCE1953-11-17UHC-05657-40•••-••-4453546-279-6789roger.lawrence98@hotmail.com5935 Meadow LaneLAS VEGAS·NV89126GRP-4251CHOICE-PLUS-PPO
ENRENR-1181932026-05-01T07:40:36ZEugene—·Gilbert1990-03-02UHC-96168-79•••-••-6688—EUGENE.GILBERT@YAHOO.COM1104 Harbor BoulevardMiami··FL33136GRP-1383·CORE-HMO
ENRENR-1143952026-09-21T09:28:20ZJeremyT.Guzman05/19/75UHC-42706-41•••-••-1998-jeremy.guzman68@hotmail.com6444 Lincoln WayDallasTX75212-5810··GRP-0543MEDICARE-ADV-B
ENRENR-1327762026-09-23T04:46:52Zjoan··fowler1983-10-14UHC-85183-78•••-••-278217126109526UNKNOWN7025 SAGE CT··FresnoCA93722GRP-7640MEDICARE-ADV-A
ENRENR-1331442026-08-14T14:22:54ZMatt—·Brooks14-08-1971··UHC-65253-69-(935) 608-6949MATTHEW.BROOKS82@ICLOUD.COM2463 MEADOW LANE Apt 9TucsonAZ·85761-3179GRP-8627SELECT-EPO
ENRENR-1325452026-09-13T10:22:26ZMORRISONN.LUCIA1946-10-17UHC-20465-38•••-••-9611-lucia.morrison70@gmail.com889 SAGE CTPlanoTX75065GRP-6971MEDICARE-ADV-B
ENRENR-1186372026-03-04T21:48:07ZDANIELLEVADREWS2006-04-02UHC-00916-15•••-••-8618(588) 832-8982DANIELLE.ANDREWS@AOL.COM621 LINCOLN WAY···ScottsdaleAZ85265GRP-0583OPTIONS-PPO
ENRENR-1196422026-03-01T11:20:06ZALICE—DUNN1951-08-31UHC-54642-58•••-••-2977(662) 484-2981—1060 Ocean AvenueTucsonAZ··GRP-2383MEDICARE-ADV-A
ENRENR-1258602026-07-04T03:04:41ZAndrewWWilson05/24/2007UHC-56200-26•••-••-2414589-369-7622andrew.wilson86@gmail.com9624 Canyon RdChandlerAZ85229GRP-5730·SELECT-EPO
ENRENR-1030492026-08-14T17:53:46ZJacob—Black1992-12-02-•••-••-4783+1 368 780 1602JACOB.BLACK87@ICLOUD.COM8159 Canyon Rd Apt 38SACRAMENTOCA95831GRP-7858NAVIGATE-HMO
ENRENR-1022722026-03-24T11:20:58Z PriyaMBryant1995-09-20UHC-21221-38•••-••-27719698744362··priya.bryant73@aol.com2965 Lake View RdChandlerAZ85288GRP-0538MEDICARE-ADV-A
ENRENR-1060702026-05-24T18:08:44ZHernyRBennett··5/28/1968UHC5026112•••-••-91989874360156···henry.bennett@proton.me4498 Park PlChandlerAZ·85292GRP-9020CHOICE-PLUS-PPO
ENRENR-1172042026-05-19T12:24:44ZSEANWBERRY1968-09-12uhc-17584-75•••-••-022014473950926sean.berry@outlook.com8863 Harbor BoulevardDallastx75213GRP-2009CHOICE-PLUS-PPO
ENRENR-1268952026-10-06T19:36:21ZAmyELnych20070728UHC-95037-78•••-••-4796(783) 920-7817N/A6954 Highland AveChandlerAZ85273-4280GRP-6324MEDICARE-ADV-B
ENRENR-1428892026-02-18T11:21:25ZStephanie—George27-03-1940UHC1743568··•••-••-7749(567) 306-5952STEPHANIE.GEORGE@HOTMAIL.COM1885 Elm Street·TucsonAZ85706GRP-5969MEDICARE-ADV-A
ENRENR-1000502026-04-17T18:12:52ZALEXSIH··HARVEY1978-08-04UHC-80029-82·NULLnullalexis.harvey@proton.me5646 Palm DriveSan AntonioTX78227GRP-4942MEDICARE-ADV-B
ENRENR-1263702026-01-16T11:50:24ZSantiago—Jimenez19840825UHC-19952-85•••-••-71628444390603santiago.jimenez@gmail.com6550 Mesa DrDallasTX75252GRP-8224··MEDICARE-ADV-A
ENRENR-1163222026-04-20T11:21:02ZMei—Nguyen10/13/1952UHC-95381-17NULL+1 787 952 5665MEI.NGUYEN@PROTON.ME642 Sunset BlvdMiamiFL33197GRP-7330NAVIGATE-HMO
ENRENR-1129302026-07-22T01:35:22ZJESSICAM.MILSL3/4/1960UHC-11021-54•••-••-9291—JESSICA.MILLS@YAHOO.COM1750 Harbor BoulevardLas VegasNV·89192GRP-4195OPTIONS-PPO
43,101 rows, page 174 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:38.504Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty