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-1156732026-09-18T23:41:53ZRoyK.·Vargas02/27/1995UHC-80446-31•••-••-8310609-834-5869roy.vargas@hotmail.com8851 Maple AveLos AngelesCA90066GRP-8642OPTIONS-PPO
ENRENR-1082442026-02-15T16:48:48ZDONALDVGOMEZ14-06-1983UHC-35536-58··•••-••-7594(600) 266-0350DONALD.GOMEZ48@AOL.COM4436 Harbor BlvdLas VegasNV89102GRP-6464MEDICARE-ADV-A
ENRENR-1258632026-07-10T14:46:33ZBETSYU.MROENO12/24/65UHC-58804-83•••-••-0736774.765.0251-··1996 Park PlaceSeattleWA98130GRP-1695NAVIGATE-HMO
ENRENR-1232192026-07-30T16:22:00ZJULIEXMURPHY1984-05-04UHC-68695-89•••-••-11619393807920julie.murphy9@icloud.com2688 Desert Sky BoulevardAtlantaGA30351-7978GRP-0238CHOICE-PLUS-PPO··
ENRENR-1283572026-05-19T21:11:06ZKATHLEEN—LYNCH1979-09-21UHC-39030-53•••-••-3382(228) 909-8244kathleen.lynch@proton.me7652 Sage CtAustinTXNULL··GRP-7285·CHOICE-PLUS-PPO
ENRENR-1178012026-02-23T22:42:23ZjasonT.phillips19860811·UHC-16875-64•••-••-8501·7629575NULL6367 MAPLE AVENUEHoustonTX·77051GRP-7944CHOICE-PLUS-PPO
ENRENR-1410312026-05-26T13:19:41ZRaymondCFreeman19530123UHC-96816-88•••-••-9299482-364-8363RAYMOND.FREEMAN@ICLOUD.COM3667 Valley View DriveTEMPEAZ—GRP-6197··navigate-hmo
ENRENR-1304512026-02-27T18:24:43ZRacehl—Lawson1956-02-21UHC-01050-47•••-••-1728(521) 220-6979RACHEL.LAWSON@PROTON.ME9092 OCEAN AVEHoustonTX77023-6739GRP-2699CHOICE-PLUS-PPO
ENRENR-1008582026-08-19T04:02:35Z·Billy—Jacobs1959-06-28UHC-33970-88•••-••-0217491.322.9878··billy.jacobs@yahoo.com8915 Willow CtTampa·Florida33614-8592GRP-5294CHOICE-PLUS-PPO
ENRENR-1343352026-09-16T05:46:40ZCATHERINE—WOODS1948-01-17UHC-08489-54•••-••-09879826169750—412 Baseline RdTempeAZN/AGRP-6984CORE-HMO
ENRENR-109152 2026-06-07T23:28:10ZMasonZ.Estrada1981-02-13UHC-38100-59··•••-••-02269649497306—1609 SUNSET BLVDTampaFLN/AGRP-0177MEDICARE-ADV-A
ENRENR-1110662026-04-13T15:19:19ZKaren····Wells1989-06-21·UHC1591351•••-••-8418730-664-7348karen.wells@outlook.com3908 SUNSET BLVDNashvilleTN37236GRP-6397NAVIGATE-HMO
ENR ENR-1058852026-10-16T23:27:40ZSANDRA—PORTER10/1/1942UHC-18433-35•••-••-1807N/Asandra.porter@outlook.com2639 CHURCH ST··LOS ANGELESCA90016GRP-2611medicare-adv-a
ENRENR-1045852026-08-11T06:04:40Z·BrandonT·Bradley1978-06-01UHC-42690-22•••-••-18575649801067·brandon.bradley53@icloud.com2583 Desert Sky BlvdOrlandoFL32819GRP-4930SELECT-EPO
ENRENR-1256882026-02-26T02:15:13ZAshleyNBaker2005-06-11UHC-00076-33•••-••-5402(779) 450-6156N/A8221 FOREST AVESAN DIEGOCA—GRP-3009OPTIONS-PPO
ENRENR-1408202026-07-04T23:00:10ZGeorge—Jones2006-12-09UHC-24975-70•••-••-5648888-878-2530george.jones8@aol.com3287 LINCOLN WAYAtlantaGA30333GRP-6180CHOICE-PLUS-PPO
ENRENR-1254652026-07-14T21:49:14ZVIRGINIAHHARPER··1980-02-07UHC-83325-61•••-••-4882788.689.4045virginia.harper@gmail.com1549 Mountain View DrEden PrairieMN55316GRP-8936CHOICE-PLUS-PPO
ENRENR-1283022026-02-15T10:07:04ZBrandon—Mason1970-07-13UHC-65028-12•••-••-33696015278105brandon.mason24@aol.com1350 Elm St·ScottsdaleAZ85279GRP-6506MEDICARE-ADV-A
ENRENR-1311452026-09-25T18:28:24ZHooffman, Jack··Y—1972-08-10UHC-84193-50null975-650-5789jack.hoffman20@outlook.com829 Elm StSan AntonioTexas78244GRP-6206CORE-HMO
ENRENR-1123362026-07-20T08:27:51ZOlivia U.—Ortega19610804UHC-35855-04null—-1459 CANYON RDTAMPAFL33669GRP-3086SELECT-EPO
ENRENR-1127202026-04-30T20:36:18ZGraham, AnthonyP—1963-10-09··UHC-93791-07•••-••-43229787531810anthony.graham57@hotmail.com8414 Highland AvenueLAS VEGASNV··89165GRP-4405MEDICARE-ADV-B
ENR ENR-1052422026-04-24T15:56:29ZJudy—Hawkins··19420604UHC-30240-19•••-••-33808484872847judy.hawkins91@icloud.com2248 MOUNTAIN VIEW DRIVESan Antonio·TX78214GRP-3303SELECT-EPO
ENRENR-1357882026-09-24T18:49:38ZDouglas—Edwards1996-02-98UHC-70622-63•••-••-11704089910490N/A1861 Bayshore Dr·SacramentoCA95888GRP-9115CHOICE-PLUS-PPO
ENRENR-1293662026-10-12T01:00:19ZGeorgeXHowell2001-02-10UHC-60841-96•••-••-3422(828) 371-3258george.howell52@aol.com·2930 SUNSET BOULEVARDDenverCO80249·GRP-8089CORE-HMO
ENRENR-1321262026-01-24T02:40:14ZAmy—Collins09/28/70UHC-11297-50•••-••-9707·9135650175amy.collins61@icloud.com4997 Maple AvenueMINNEAPOLISMN55493-5808GRP-1690SELECT-EPO
ENRENR-100398 2026-07-03T07:41:37ZNicoleHRobinson1977-04-04UHC-71613-47•••-••-11893499530748NICOLE.ROBINSON55@ICLOUD.COM3350 Willow CtPlanoTX75063GRP-0493select-epo··
ENRENR-1140962026-08-19T13:28:55ZCarolKBanks·1999-02-17UHC-53162-58•••-••-643016282900092carol.banks57@outlook.com7354 Mesa DrScottsdaleAZ85253GRP-5632MEDICARE-ADV-A
ENRENR-1177902026-04-08T09:48:34ZDANIELLE····MARSHALL1950-02-25UHC-60613-36•••-••-1612(571) 429-7426DANIELLE.MARSHALL@GMAIL.COM5450 CAMELBACK ROADAtlantaGA30328GRP-9833core-hmo
ENRENR-1192742026-08-04T00:56:43ZEVELYN—HAWKINS1945-07-18UHC-71285-92•••-••-00464938122050·evelyn.hawkins23@outlook.com—-—NULLGRP-6415CORE-HMO
ENRENR-1003852026-08-13T06:39:10Z·HeatherF.Foster2000-04-09UHC-18247-46•••-••-03238226072896heather.foster68@icloud.com7943 Central AveMiamiFL··33108GRP-4665OPTIONS-PPO
ENRENR-1181782026-08-18T07:03:25ZJudith·PCooper11/05/87UHC-87105-36—688.730.1195JUDITH.COOPER@GMAIL.COM1575 Pine DrJacksonvilleFL32210GRP-7302MEDICARE-ADV-A
ENRENR-1089032026-06-04T17:31:35ZAlanD.Taylor1964-03-06·UHC-03445-29•••-••-3675UNKNOWN—8573 SUNSET BOULEVARDJacksonvilleFL32236-0666GRP-3635OPTIONS-PPO··
ENRENR-1125552026-09-26T12:15:09ZChristian·V.Willis09-12-1953UHC-11135-63•••-••-17216935820784christian.willis@yahoo.com·4660 Meadow LaneMiamiFL—GRP-9365MEDICARE-ADV-B
ENRENR-1397312026-09-24T02:46:43ZCAROLDTHOMPSON1951-04-11UHC-60178-93-659-943-7112CAROL.THOMPSON62@GMAIL.COM4233 MAIN STREETTucsonAZ85789GRP-8155SELECT-EPO
ENRENR-1376672026-08-03T22:08:16ZJerryIGuerrero1976-01-23UHC-49960-30··•••-••-2561·4603497JERRY.GUERRERO@PROTON.ME9063 Palm DriveSeattleWA98115GRP-5868MEDICARE-ADV-B
ENRENR-1276152026-07-29T02:12:26ZEvelynQMatthews1950-08-19·UHC-50807-12•••-••-266513699550722evelyn.matthews20@proton.me3422 Market StreetCHANDLERAZ85260GRP-0752CHOICE-PLUS-PPO
ENRENR-1097212026-06-11T12:48:34ZAmanda—Walker1981-01-27·UHC-81975-06—nullamanda.walker@yahoo.com—UNKNOWNN/A—GRP-7310MEDICARE-ADV-A
ENRENR-1419792026-05-01T15:45:30Zdoris—olsonJul 21, 1953··UHC-18527-25•••-••-5836(220) 527-3534·doris.olson@yahoo.com2849 Lincoln Way Apt 37PlanoTX75089GRP-8507NAVIGATE-HMO
ENRENR-1313262026-03-01T16:12:44ZdiegoYramos2004-03-13-•••-••-3304407-600-7554null6810 HIGHLAND AVETucsonAZ85725GRP-2954MEDICARE-ADV-A
ENRENR-143076 2026-06-07T01:36:17ZVirginiaRRoss1974-08-24UHC-31380-61•••-••-7003(961) 980-6533—6785 Sunset Boulevard·MinneapolisMN55437GRP-5390SELECT-EPO··
ENRENR-1074282026-07-02T02:49:20ZMARIA—GRIFFIN6/25/1989·UHC-28607-18•••-••-7876(236) 425-2420null8829 BROADWAYSacramentoCA95824GRP-7523··NAVIGATE-HMO
ENRENR-1038012026-03-08T03:21:00Z Gardner, Wei·M—11/12/02UHC-60146-17•••-••-9277848-864-0320NULL9666 CANYON ROADMesaAZ85212GRP-2558CORE-HMO
ENR ENR-1091652026-02-17T06:34:11ZRUTHQWEAVER08-01-1986UHC-27012-03•••-••-5707314-864-4818ruth.weaver69@proton.me7988 MESA DRIVE #261·San AntonioTX78217GRP-4498NAVIGATE-HMO
ENRENR-1396072026-04-28T19:08:40ZCHRISTINA·I.WALSH1945-08-02UHC-66849-34•••-••-8516230.522.8629———-—GRP-6669MEDICARE-ADV-A
ENRENR-1052852026-04-21T13:38:05ZTyler··Wiliams··10/05/03UHC-13381-07•••-••-09428222200695NULL7374 HIGHLAND AVENUESEATTLEWA98198-3763GRP-1800select-epo
ENRENR-1071862026-04-07T08:58:35ZPhilipQ.·Lawrence1991-10-02UHC-27655-89•••-••-167818023222072philip.lawrence@outlook.com1594 RIVER RDChandlerAZ85200GRP-3638CHOICE-PLUS-PPO
ENRENR-1146062026-10-04T11:26:57ZERICTBOWMAN1950-05-23UHC-56333-05•••-••-5945450-930-3605eric.bowman52@yahoo.com8419 CENTRAL AVENUE #287NashvilleTN37296GRP-7577MEDICARE-ADV-B
ENRENR-1335402026-06-23T15:13:59ZSAMANTHALBRYANT1996-10-03UHC-70891-58•••-••-804718625351356SAMANTHA.BRYANT52@YAHOO.COM7358 Indian School RoadSEATTLEWA98163-4840·GRP-0522CORE-HMO··
ENRENR-1082732026-02-10T23:01:44ZNANCYCCARLSON1981-08-13UHC-15272-02•••-••-2975(428) 657-1119nancy.carlson34@icloud.com6960 Maple AvenuePlanoTX75052GRP-0633NAVIGATE-HMO··
ENRENR-1387622026-08-10T02:09:34Zmelissa—delgado07/28/2007UHC-61902-21•••-••-06074735065461melissa.delgado1@hotmail.com2360 HILLCREST ROAD··CharlotteNC28257-9453GRP-2656options-ppo
43,101 rows, page 214 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.357Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty