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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENR ENR-1078232026-07-15T13:22:12ZSHARONCAGUYLAR1990-09-19UHC-98678-80•••-••-4890+1 627 962 7998sharon.aguilar@outlook.com4558 Pine DrAtlantaGA·30358GRP-9547CHOICE-PLUS-PPO
ENRENR-1099662026-08-26T22:09:49ZWAYNECWALLACE1967-05-17uhc-45597-20—828-817-0374—4877 Valley View DriveTampa·FL33670··GRP-8820SELECT-EPO
ENRENR-1164992026-05-21T14:40:55ZSOFIA·A.RIOS2005-02-03UHC-29478-20•••-••-0389+1 493 244 4921·SOFIA.RIOS61@AOL.COM9897 UNION ST·SeattleWA98134·GRP-4887navigate-hmo
ENRENR-1412212026-02-08T03:30:44ZStewart, Jesse·M.—Mar 28, 1976UHC-69637-54•••-••-73488625449898jesse.stewart9@yahoo.com540 Oak StLas VegasNV89128GRP-6385CORE-HMO
CLMCLM-4159882026-08-22T04:39:55Z Teresa—Reyes1999-06-10-UNKNOWNnull—·1268 Hillcrest RoadLAS VEGASNV89101GRP-3491CORE-HMO
CLMCLM-4235612026-02-23T11:55:44ZMary—Reed19620505UHC-27530-28-——1552 JEFFERSON AVENUESan DiegoCA92185GRP-1782NAVIGATE-HMO
PRVPRV-208422026-06-23T02:39:28ZMaria—Snyder··1940-07-24N/A—NULL—6204 Ocean Avenue Apt 13PlanoTX75030NULL—
TPATPA-523162026-09-20T18:45:17ZANA—WHITE1980-04-08N/A··•••-••-3297-—7235 Lake View RdNASHVILLE···TN37290NULLCORE-HMO
CLMCLM-4154042026-06-01T16:43:12ZJean—Young1940-05-22UHC-88826-06•••-••-4783(378) 437-4877null8587 Hillcrest Road··Las VegasNV89110null—
ENRENR-1354092026-10-11T18:42:02ZDanielYJensen19740912UHC-77446-05•••-••-4861917-802-2537daniel.jensen54@aol.com3605 Baseline RoadCHANDLERAZ85239-0795GRP-3266MEDICARE-ADV-A
TPATPA-628762026-05-24T10:06:44Zdiego—li1992-02-05N/AnullUNKNOWN—181 Meadow LaneJacksonvilleFLnullnull-
CLMCLM-4086402026-08-31T02:11:39ZEmma—Kennedy08/12/2004UHC-01628-56······+1 855 577 3381emma.kennedy@icloud.com····-—·-····—
CLM CLM-4207482026-08-08T17:51:42Z Walter—Hernandez11/13/2001—•••-••-9997—UNKNOWN2225 RIDGE RDNashvilleTN-—N/A
ENRENR-1224802026-06-04T09:53:57ZSara··TWagner1987-08-20UHC7387597•••-••-6745N/Asara.wagner66@icloud.com841 BROADWAYORLANDOFL—GRP-6989·CHOICE-PLUS-PPO
CLMCLM-4167432026-08-17T22:31:45Z·LISA—REID03/14/75N/AUNKNOWN455-244-8359-··4559 Apache BlvdLas VegasNV89120GRP-1736N/A
TPATPA-559332026-01-12T02:51:29ZCynthia—·Sandoval2002-04-06null•••-••-4776N/Acynthia.sandoval46@proton.me9753 Lake View RoadAustinTX78787GRP-0371UNKNOWN
TPATPA-557192026-03-13T22:37:44ZKELLY—·JIMENEZ·19600509nullnull(867) 235-7828NULL9175 FOREST AVENUEDallasTXUNKNOWNNULLCHOICE-PLUS-PPO
PRVPRV-273442026-08-28T23:58:27ZJulia—Wright5/15/1994UHC-22171-70··UNKNOWN606-845-2677NULL5217 Main StreetDallasTX75241nullCORE-HMO
CLMCLM-4114812026-06-28T03:35:18ZSARAHWOLSON06/19/00UHC-48451-84nullNULLsarah.olson39@outlook.com5496 River RoadSeattleWA-GRP-2182null
ENRENR-1015492026-05-21T02:42:42ZDENISE—WALKER11/4/1955UHC-80410-94•••-••-95878167821DENISE.WALKER93@AOL.COM8205 Baseline RdJACKSONVILLEFL32273GRP-2923··MEDICARE-ADV-B
CLMCLM-4089902026-01-02T20:45:42ZAshley—Hansen2005-06-15··—(917) 211-0365ashley.hansen42@gmail.comN/A—··—GRP-8783UNKNOWN
ENRENR-1038332026-02-20T22:12:32ZLAURENQ.PADILLA19971227UHC-93920-37•••-••-7389265.621.4212·LAUREN.PADILLA@YAHOO.COM1287 SAGE CTAustinTexas78704-9737··GRP-2040NAVIGATE-HMO
PRVPRV-224582026-03-09T04:07:20ZSimmons, Abigail——04-10-1944——12564847168··5286 Cedar LaneEden Prairiemn·55328-NAVIGATE-HMO
ENRENR-1405812026-08-16T00:36:59ZMateo—Nichols1966-11-08UHC-79155-89•••-••-8436—-952 Sunset BoulevardOrlandoFL32864··GRP-7340NAVIGATE-HMO
CLMCLM-4113902026-09-12T22:50:10ZDavid··—Wheeler06/07/2001··UHC-39132-78NULL356-912-3248—2668 Spring StHoustonTX77017··GRP-8785NAVIGATE-HMO
ENRENR-1066472026-01-15T21:54:19Z·diana·Ohrrison1966-08-06UHC0987403•••-••-4458(401) 318-5529diana.harrison99@hotmail.com7744 CENTRAL AVEGILBERTArizona··85264GRP-6854MEDICARE-ADV-A
ENRENR-1167912026-08-31T17:58:04ZMurray, Emiily——2/20/1992·UHC-96474-99null——8357 SPRING STREETCharlotteNC28293GRP-1416CORE-HMO
ENRENR-103198 2026-06-01T00:57:57ZMorris, Sandra··——08/19/76UHC-98911-16NULL·(622) 834-8788sandra.morris29@hotmail.com8039 Valley View DrMinneapolis··MN55428-7154GRP-1916NAVIGATE-HMO
ENR ENR-1103202026-07-03T05:39:46ZJoan····Ellis12/16/2007—•••-••-1103(449) 777-9318—3040 WILLOW COURTAtlantaGA—GRP-0907MEDICARE-ADV-A
ENRENR-1126562026-08-04T14:21:54ZPual—Webb1993-07-12N/A•••-••-5710——·2661 Indian School RdHoustonTX77011GRP-9993OPTIONS-PPO
ENRENR-1169572026-06-20T23:52:41ZAmberEReyes19970234UHC-63044-27•••-••-0286352.551.5883AMBER.REYES27@OUTLOOK.COM6206 RIDGE ROADMinneapolisMN55411GRP-4380··CHOICE-PLUS-PPO
TPATPA-553652026-01-09T17:40:55Z Evelyn—Gonzales19620220——null—942 Valley View DriveSan AntonioTX78274null—
TPATPA-557162026-01-04T06:44:05ZLuca··Young11/09/1942UHC-46362-85-N/A—nullUNKNOWNUNKNOWN-GRP-8761NULL
CLMCLM-4163122026-02-02T10:32:59Zkathleen—johnston1964-01-05—•••-••-6516659.606.9361—1204 Highland AvenueLos AngelesCA—GRP-4008MEDICARE-ADV-B
CLMCLM-4052332026-04-26T21:07:55ZVicturia—Hawkins05/10/73—•••-••-6185—N/A————NULLN/A
ENRENR-121243 2026-03-25T15:10:39ZRayUDixon10-09-1967UHC-48483-58•••-••-8366+1 724 932 6417-7727 Mesa Drive·SeattleWA98115·GRP-0665·OPTIONS-PPO
PRVPRV-236552026-03-05T00:25:37ZKATHYQWRIGHT1949-05-25UHC-81490-13—285.237.9084-4168 OAK STFresnoca93768——
CLMCLM-4025062026-06-19T07:21:22ZWilliam—Simmons1972-06-17UHC-76744-15-NULLNULL-———GRP-7932CORE-HMO
ENRENR-1338582026-02-22T21:05:12Z·JORDAN—LAWRENCE9/13/2002UHC-30417-68•••-••-48598357539084jordan.lawrence@proton.me7239 Ocean AveLos AngelesCA90071GRP-8530MEDICARE-ADV-A
ENRENR-1080502026-09-21T03:41:50ZTYLER··RORTEGA··10/05/77UHC-92950-23•••-••-2822—tyler.ortega6@gmail.com3839 Apache BlvdCharlottenc·28205GRP-3035··NAVIGATE-HMO··
ENRENR-1319532026-06-16T05:08:57ZMichael·NMeson·8/14/1998UHC-26818-97•••-••-681716687235038··NULL4174 Highland AvenueMiamiFL33141GRP-1263OPTIONS-PPO
ENRENR-1305552026-04-03T02:13:47ZYukkiZ.Wright1986-02-22UHC-59968-86•••-••-5612946.683.5588—9017 PINE DRIVEJacksonvilleFL32241GRP-6785SELECT-EPO
ENRENR-1242012026-10-03T11:24:01Zchristine—wilson22-04-1976UHC-06620-20•••-••-8736nullchristine.wilson@proton.me9378 Canyon RdCharlotte·nc—GRP-8285MEDICARE-ADV-A
ENRENR-1244432026-09-02T23:10:09ZsusanZalvarez1965-11-01UHC-58484-22•••-••-68218814367108susan.alvarez@proton.me8399 RIVER RD··San Diegoca92108GRP-1759NAVIGATE-HMO
ENRENR-1127042026-09-29T07:52:51ZCarol—Howell1942-02-16UHC-35472-34•••-••-4766+1 433 593 6242—7900 MESA DRIVEGlendaleAZ—GRP-3984SELECT-EPO
CLMCLM-4135132026-01-23T13:10:45ZSARAN.··MATTHEWSNov 11, 1971UHC-28353-44•••-••-4228N/A-UNKNOWN—·UNKNOWN—GRP-0893-
CLMCLM-4165422026-08-29T04:58:14ZJANET—HENDERSON1976-07-16UHC2922829—NULLjanet.henderson@hotmail.com7039 Mountain View Dr #867HoustonTexas77055GRP-5611CORE-HMO··
PRVPRV-215962026-06-19T22:51:23Zkevin—payne1968-05-07UHC5346333UNKNOWN(820) 936-2751—8737 DESERT SKY BOULEVARDSeattleWA98125null··N/A
TPATPA-583092026-02-06T14:18:42Z Billy—Austin05/22/92——8977240676-UNKNOWN———·UNKNOWNSELECT-EPO
CLMCLM-4123162026-03-13T02:10:12ZJOHNCBURKE··07/17/77—•••-••-5021+1 453 667 1365—UNKNOWN—N/A··GRP-5417OPTIONS-PPO
100,000 rows, page 59 of 2,000PreviousNext

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:34.784Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty