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-1176512026-03-07T17:32:28ZSantiago—Tran11/27/83UHC3806624•••-••-6915300-728-9467SANTIAGO.TRAN43@YAHOO.COM549 River RdAustinTX—GRP-3023MEDICARE-ADV-A
ENRENR-1000812026-02-14T14:56:08Zeric—wang2002-09-19UHC-31239-67•••-••-5164—ERIC.WANG@PROTON.MEnullN/AN/A—GRP-5481CHOICE-PLUS-PPO
ENRENR-1351612026-03-26T14:15:22ZDonald—Parkeer1999-01-04·UHC-85652-33•••-••-3029(329) 664-7222donald.parker@icloud.com··8777 LINCOLN WAYChandlerAZ85225GRP-2396NAVIGATE-HMO
ENRENR-1269802026-10-07T22:11:25ZDiaz, Keith——19961113UHC-14729-92··18696037650-2922 Park PlaceMinneapolismn55455GRP-4082select-epo
ENRENR-1365382026-01-18T15:54:55Zjuan—bell2003-01-91UHC-85192-55•••-••-8012(807) 310-5821juan.bell73@proton.me2193 Lake View RoadSacramentoCA95804GRP-1102MEDICARE-ADV-A
ENR ENR-1159552026-04-08T01:30:31ZJenkins, Christopher——1982-09-18·UHC-46541-04•••-••-47182285506725christopher.jenkins@yahoo.com9681 Forest AvenueDallasTX75238GRP-0743NAVIGATE-HMO
ENRENR-1427512026-09-26T03:35:37ZMADISON····RAMUS2002-07-03UHC0059188•••-••-5694299-470-8267MADISON.RAMOS69@PROTON.ME5080 BAYSHORE DRLas VegasNV89195GRP-6097OPTIONS-PPO
ENRENR-1243012026-09-16T17:39:02ZEvelyn—Richards19690324UHC-80129-65•••-••-2287281-988-2790—·8799 Park PlaceMinneapolisMN55452GRP-1335CORE-HMO
ENRENR-1155602026-03-07T23:11:54ZFrances—·Ford03/03/45UHC-10680-74•••-••-3794612-511-4279frances.ford@yahoo.com9796 Market StLas Vegas·NV89161GRP-2599OPTIONS-PPO
ENRENR-1339222026-01-17T23:02:21ZAbigailPLuna12/16/1954·UHC-36079-65•••-••-3615(714) 854-9085abigail.luna@icloud.com··8942 HILLCREST RDDallasTX75230GRP-1312MEDICARE-ADV-A··
ENRENR-1197252026-01-16T20:27:46ZLori I—Wellch2004-08-27UHC-23895-82•••-••-70074515900976lori.welch33@yahoo.com3609 Main StSan AntonioTX··78239GRP-1237CHOICE-PLUS-PPO
ENRENR-1262142026-08-03T20:54:06ZSUSANX·BRADLEY1940-04-18UHC-02823-72•••-••-2309399-912-2715—9805 Bayshore DrAtlantaGA30356GRP-4025OPTIONS-PPO
ENR ENR-1420112026-09-29T04:20:18Z DORIS··—NUNEZ··Jun 20, 1959UHC-49736-25•••-••-4596N/AN/A4509 Jefferson AveMiamiFL33147GRP-7033NAVIGATE-HMO
ENRENR-1258882026-03-24T11:31:08ZLISAI.VARGAS02/28/1939UHC-03351-44•••-••-22778653572287··LISA.VARGAS@YAHOO.COM3295 Meadow LaneAtlantaGA30367GRP-8902·MEDICARE-ADV-A
ENRENR-1381622026-07-25T04:24:02ZBenntt, Priya—··3/24/1974·UHC-29512-27•••-••-8101534-675-3236priya.bennett64@aol.com3279 Mesa Dr·HOUSTONTX77002··GRP-9390CORE-HMO
ENRENR-1202942026-10-10T06:32:39ZElizabethECookFeb 25, 1961UHC-99501-62•••-••-4206808-489-2852··elizabeth.cook42@aol.com3697 WILLOW CTLas Vegasnv··89113GRP-5861MEDICARE-ADV-B
ENRENR-1173982026-03-28T08:04:38ZLisaJMendez1949-07-05UHC-55575-93•••-••-54257866453113—105 Cedar Ln Apt 11TucsonAZ85702GRP-8297MEDICARE-ADV-B
ENRENR-1224642026-01-20T13:59:05ZLAUREN—SIMPSONSep 17, 1998UHC-92848-17•••-••-47523607510966lauren.simpson27@aol.com6552 Maple AveGlendale··AZ85354GRP-7197CORE-HMO
ENRENR-1301452026-02-23T17:36:23ZLindaT.Bishop1982-07-25·UHC-08118-73•••-••-7655363-850-1549linda.bishop28@proton.me8313 CANYON ROAD·ScottsdaleAZ85238GRP-4031CHOICE-PLUS-PPO
ENRENR-1317662026-01-20T06:33:17ZemmaFwright1978-08-21UHC-77052-30•••-••-39958372116674emma.wright8@proton.me4449 Jefferson AvenueChandlerAZ85228GRP-8370OPTIONS-PPO
ENRENR-1392962026-02-18T06:53:00Z·AlexisE.Duncan1970-08-12UHC7929381N/A3037285635ALEXIS.DUNCAN96@PROTON.ME··9398 Maple AvenueGILBERT··Arizona85284GRP-0271NAVIGATE-HMO
ENRENR-1412362026-04-29T10:25:07ZROGER··—REID2002-09-26UHC-55937-60•••-••-27044228573147null5295 Main StMesaAZ·85241GRP-4491··SELECT-EPO
ENRENR-1068572026-09-03T05:12:27ZJoe—Robinson2002-05-01UHC-75946-67null-JOE.ROBINSON@GMAIL.COM9723 Highland AvenueChandlerAZ85244GRP-9508MEDICARE-ADV-B
ENRENR-1376642026-03-20T09:08:49ZHeather—Torres1946-10-08UHC-95435-80··N/A525-738-4012heather.torres@proton.me645 Ridge RoadColumbusOH·43267GRP-9467SELECT-EPO
ENRENR-1269712026-04-26T01:53:22Z Hunter, KennethR.—1975-08-15uhc-91822-44•••-••-9058491-296-5898NULL6735 BROADWAYMiami·FL33130-9362··GRP-3779MEDICARE-ADV-B
ENRENR-1368572026-06-07T21:40:41ZZacharyXScott·Jul 2, 1995UHC-11981-05•••-••-8904702-314-2597zachary.scott@aol.com2531 CANYON ROAD··NashvilleTN37281GRP-6589NAVIGATE-HMO
ENRENR-1374972026-09-07T06:45:47ZKENNETHP.VALDEZ28-10-1947UHC-39425-26•••-••-3083(369) 994-5930KENNETH.VALDEZ@PROTON.ME9128 RIDGE ROADSacramentoCA95804GRP-2317NAVIGATE-HMO
ENRENR-1062512026-02-04T03:40:55Z Gabriel—Moreno04-03-1963UHC-78406-35•••-••-5335·18767701307gabriel.moreno@hotmail.com492 Pine DrLOS ANGELESCalifornia90049GRP-9081CORE-HMO
ENRENR-1380942026-10-05T02:12:03ZBillyFWheeler19711203UHC-54406-84•••-••-3416-billy.wheeler76@gmail.com7819 Willow CourtAUSTINTX78713GRP-2897MEDICARE-ADV-A··
ENRENR-1097092026-01-16T23:49:08ZGibson, Barbara C.——2001-09-07UHC-31992-36—(249) 247-0431—2335 WILLOW COURTGILBERTAZ··85288GRP-5007CORE-HMO
ENRENR-1277812026-08-03T14:36:05Z·MATEORLI04/08/1966UHC-06395-11•••-••-8365(316) 588-0588null1074 Union StFresnoCANULLGRP-2308CORE-HMO
ENRENR-1359592026-05-16T01:41:05ZJULIENGARRETT1940-06-04UHC7916492•••-••-00172333135139julie.garrett57@hotmail.com5021 PINE DRSAN ANTONIOTX78221GRP-9499·CORE-HMO
ENRENR-1423482026-04-27T19:53:56ZBrandon—·Santiago1970-11-04UHC-64971-04null405-863-9114···BRANDON.SANTIAGO@GMAIL.COM9606 Spring StPHOENIXaz85076GRP-4935MEDICARE-ADV-A
ENRENR-1277182026-05-10T02:25:21ZNoahPCooper2007-08-28··UHC-58248-66•••-••-3615327-869-7876····3408 Grand AvenueTempeAZ85254GRP-6302··CORE-HMO
ENRENR-1203622026-04-25T19:54:27ZGrza, JoyceM—9194-10-27UHC-98079-58•••-••-375417889027235joyce.garza@proton.me—··-NULLGRP-9845MEDICARE-ADV-A
ENRENR-1030362026-09-28T19:48:43ZKevin··Murphy1970-08-06UHC-09691-17•••-••-34169033890627kevin.murphy73@hotmail.com2755 Sage CourtHoustonTX77049GRP-8088OPTIONS-PPO
ENRENR-1030912026-01-21T13:55:06ZDEBRA—ROMERO1946-06-10UHC-12831-60•••-••-476719009946349debra.romero@yahoo.com1512 Central AveSan AntonioTX·NULLGRP-2074CORE-HMO
ENRENR-1220892026-08-18T04:07:07ZCATHERINE··UANDREWS6/8/1946UHC-95338-32•••-••-3288370-990-0809CATHERINE.ANDREWS@YAHOO.COM·8340 Lincoln WayAtlantaGA··30383GRP-2650NAVIGATE-HMO
ENRENR-1088322026-02-28T15:53:07ZALEXISIFERNANDEZ1944-09-25UHC-19671-72•••-••-0008+1 832 942 1719alexis.fernandez99@icloud.com4367 Valley View DrScottsdaleAZ85267GRP-4825MEDICARE-ADV-A
ENRENR-1259372026-09-15T10:03:49ZHELENX.GREEN1999-08-15UHC-50605-47•••-••-4024590.958.1699·helen.green@gmail.com7403 Valley View DrChandlerAZ·85296GRP-6115MEDICARE-ADV-B
ENRENR-1176922026-08-06T05:33:25ZSadra—Murphy1982-09-27·UHC-50635-15•••-••-21772742103081null2648 Mesa Dr··MinneapolisMN55424GRP-7005MEDICARE-ADV-B
ENRENR-1098422026-04-20T18:20:18Z·EVELYN····AGUILAR07/13/1950UHC-87143-55•••-••-1015(783) 586-5413evelyn.aguilar@aol.com2316 RIDGE RD·TAMPAFlorida33637GRP-2254MEDICARE-ADV-B··
ENRENR-1085482026-09-18T14:39:40ZJoanC.EstradaSep 22, 1989··UHC-34172-38•••-••-3301(726) 445-1391N/A·5173 Highland AvenueNashvilleTN37298GRP-8660CORE-HMO
ENRENR-1024912026-08-31T10:57:39ZARTHUR Z—FORD04-11-1951UHC9493450•••-••-2467769-603-9290arthur.ford@hotmail.com784 Meadow Ln Apt 18TucsonAZ85780GRP-2209MEDICARE-ADV-A
ENRENR-1398572026-07-26T14:27:08ZBRADLEYZDUNCAN1981-05-03UHC-07915-53•••-••-6788358-504-7916N/A9484 Lake View RdPhoenixArizona85010GRP-3244··OPTIONS-PPO
ENRENR-1423932026-03-30T11:29:06ZCHERYLXJOHNSON02/07/1973UHC-75959-53•••-••-9037335-315-0878CHERYL.JOHNSON73@PROTON.ME101 Palm DriveSacramentoCA95821··GRP-2300MEDICARE-ADV-B
ENRENR-1307642026-04-12T07:37:22ZRobertMReyes1966-09-26UHC-25967-93•••-••-2867591.826.7556robert.reyes2@outlook.com8816 Bayshore DriveHoustonTX77030GRP-6375MEDICARE-ADV-B
ENRENR-1161742026-08-30T16:00:04ZSue—Rojas10/28/1975UHC-53235-16•••-••-8590(851) 654-6290N/A·5079 Main StDallasTX·75224GRP-5355CHOICE-PLUS-PPO
ENRENR-1271992026-06-10T14:52:43ZWei—Weebb1964-11-19UHC-25774-97•••-••-9590—wei.webb41@outlook.com—nullNULL—GRP-5657MEDICARE-ADV-B
ENR ENR-1019402026-06-20T22:42:31ZBruce—Morris12/27/48UHC0663580•••-••-0284+1 216 865 4803bruce.morris4@outlook.com5113 Baseline RoadTucsonAZ85757GRP-5184··OPTIONS-PPO
43,101 rows, page 201 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.340Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty