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
CLMCLM-4068322026-10-03T12:15:13ZPhilpi—WoodsFeb 24, 2001N/ANULL987.717.7326-8935 VALLEY VIEW DRIVEEden PrairieMN55320-2048GRP-9742CHOICE-PLUS-PPO
PRVPRV-207962026-06-19T19:57:58Z Katherine—Hilll1979-09-20UHC-53855-27—751-694-7971UNKNOWN983 Spring St··Fresnoca93731—null
CLMCLM-4149722026-09-29T22:52:41ZAmanda—Parker02/27/1947UHC-47167-27N/A2938298489—2487 Apache BlvdDenverCO80204-3843UNKNOWNnull
PRVPRV-262232026-04-16T15:16:03Z SCOTT—HANSEN1943-04-11··—null9783314—·212 Meadow LaneMinneapolisMN55401-2251—NAVIGATE-HMO
CLMCLM-4222092026-08-11T18:31:15ZVINCENT—MORGAN·06-08-1986—•••-••-41676019759013NULL6852 Union StPhoenixAZ·85097GRP-1015N/A
TPATPA-556612026-05-14T10:06:31ZRobert—Hall22-03-1946··-null—N/A1833 OAK STREETSacramentoCA95893—NULL
CLMCLM-4321642026-02-24T05:41:01ZRachel··Holmes1982-08-28null····—null9194 Desert Sky Blvd Apt 19Los AngelesCA·90001-9992GRP-4346-
CLMCLM-4008142026-07-05T11:02:08ZJeffSDixon2007-02-12UHC-80198-85•••-••-4942—NULL3804 Hillcrest Rd··MesaAZ85223···N/AN/A
ENRENR-1124552026-04-26T09:13:20ZVALENTINA—ROSS1971-09-17UHC-77756-13··•••-••-4273277-490-7868valentina.ross67@aol.com3317 Mountain View DrSan Diego··CA92126GRP-9784··SELECT-EPO
CLMCLM-4145142026-10-13T13:40:16ZLucia—Harrison1982-05-25UHC-97007-42—--··null—····GRP-8804CHOICE-PLUS-PPO
TPATPA-550992026-06-29T22:11:23ZEvelyn—Martinez1976-09-16NULLN/A+1 914 850 7710N/A1377 Mesa DriveTempeAZ·85276GRP-0983··NULL
CLMCLM-4109992026-05-27T04:27:20Z·James—Watkins08/25/1957·UNKNOWN•••-••-3653895-632-1862null3160 UNION STREET··AustinTX78716··—NAVIGATE-HMO
ENRENR-1321072026-06-06T23:10:36ZJoyce··RBradley1952-04-01UHC-64440-61•••-••-2290·9035654587joyce.bradley@outlook.com6419 Mesa DriveDENVERCO80298GRP-5748MEDICARE-ADV-A
ENRENR-1166112026-06-15T00:43:54ZCarolynCOlivre1997-01-20UHC-77061-53•••-••-9745NULLcarolyn.oliver2@yahoo.com6638 Mountain View DriveCharlotteNC28259GRP-2354CORE-HMO
CLM CLM-4015092026-07-26T11:13:03ZMary—Murray11/5/1979NULLUNKNOWNnullNULL4644 Indian School RoadAtlanta·GA30358-3970—CHOICE-PLUS-PPO
CLMCLM-4224142026-08-14T13:08:20ZGary—Espinoza1942-02-25UHC-09582-44—14234665072NULL8150 Mesa DriveMesaAZnullGRP-3386choice-plus-ppo
CLMCLM-4307722026-08-03T21:03:45ZSandraCYoung09/22/1938UHC-48035-60UNKNOWN2247165422nullN/A··NULL··NULLUNKNOWN-OPTIONS-PPO
CLMCLM-4303172026-03-02T14:34:47ZEthan—PeersJun 14, 1971UHC-28291-35null-—4909 Meadow LaneSEATTLEWA98152GRP-4425CHOICE-PLUS-PPO
TPATPA-551262026-02-07T02:19:39ZANDREAA.ESPINOZA1995-10-20NULL•••-••-8832—null4990 CHURCH STREETEDEN PRAIRIEMN55312—MEDICARE-ADV-B
CLMCLM-4183552026-04-06T05:22:24ZStevenVWets02-04-1968—N/AnullN/A·16 Mesa DrGilbert·Arizona85268NULLUNKNOWN
ENRENR-1312942026-10-03T02:08:28ZAARONFNGUYEN1980-01-03UHC-97529-09··•••-••-02782644934696aaron.nguyen@yahoo.com7123 BASELINE ROADMinneapolisMN55418GRP-6889OPTIONS-PPO
CLMCLM-4027582026-06-12T05:54:09ZJames—Ortiz19650102N/AN/ANULL—78 Willow CourtHOUSTONTX77043GRP-7065UNKNOWN
CLMCLM-4126392026-04-26T14:24:23ZOlivia··Sanchez1947-09-04UHC-66069-07•••-••-4357NULL—94 Cedar LnAtlantaGA·30374NULLMEDICARE-ADV-B
ENRENR-1343772026-02-08T14:52:04ZJames, Wei——1987-05-16UHC-53568-22•••-••-8989892-808-0751wei.james@proton.me7550 Sage Ct Apt 7OrlandoFL32822GRP-6004CORE-HMO
TPATPA-526602026-04-18T03:50:06ZReynolds, Luis——1946-04-03null—(405) 264-5021—·5142 Baseline RoadTucsonAZ85705GRP-3820UNKNOWN
CLMCLM-4194472026-04-22T10:08:49ZSchultz, JoseL—1998-12-25UHC-22544-02··•••-••-7371——NULL—··NULL—-
CLMCLM-4302802026-01-26T20:33:01ZRuth—Baker·12/9/1971nullUNKNOWN—-·UNKNOWNnullNULLNULLGRP-4783—
ENRENR-1247702026-08-18T13:20:10ZGarrett, MarylynP.—1941-06-07UHC-31011-55•••-••-0914239.561.1866marilyn.garrett95@proton.me2901 Cedar LnSan Diegoca92177GRP-4622MEDICARE-ADV-B
ENRENR-1047252026-03-11T14:12:20ZChristopherRJordan01-12-2008UHC0469398•••-••-7852673.264.7571—7179 SPRING STREETAustin··TX78796GRP-2540CORE-HMO
ENRENR-1112222026-06-20T07:53:28ZShirley··Evans··1970-10-24uhc-22690-85•••-••-4132(650) 673-4147N/A286 APACHE BOULEVARDSan DiegoCA92167GRP-6754MEDICARE-ADV-A
ENRENR-1381352026-07-22T17:44:17ZSamantha—Olson1984-12-04UHC-51312-28··•••-••-938218247528999samantha.olson62@icloud.com2488 ELM STJacksonvilleFlorida32227·GRP-9246OPTIONS-PPO
PRVPRV-251142026-07-01T02:33:02ZNANCY····BANKSMar 10, 1955UHC-78948-13NULL2483066386NANCY.BANKS@HOTMAIL.COM3184 Bayshore DrChandlerArizona85233null—
ENRENR-1014312026-03-28T03:59:01ZJANICEZLUNA1976-10-02UHC-02636-28NULL12433521738JANICE.LUNA@HOTMAIL.COM6923 PALM DRIVETUCSONAZ85763GRP-4273NAVIGATE-HMO
ENRENR-1201222026-09-17T11:12:18ZSean····Guzman2002-12-28UHC-71216-47N/A3514030326sean.guzman@hotmail.com3295 Church StreetGLENDALEArizona85352GRP-7193··CHOICE-PLUS-PPO··
ENRENR-1377432026-04-18T10:29:18ZMARK—HARPER1948-01-14·UHC-36602-12-(860) 765-3113MARK.HARPER@GMAIL.COM2277 Lincoln Way Apt 20SeattleWA98189GRP-0948SELECT-EPO
TPATPA-569572026-02-04T00:11:13ZSimpson, Aaron——·2005-05-22UNKNOWN·N/A6439817281—659 Washington StreetMiami··FL33175NULL·-
TPATPA-560732026-10-05T22:10:21ZPamla—Tucker1974-08-08NULLnull··N/A-7360 JEFFERSON AVEAtlantaGA30385GRP-5961N/A
CLMCLM-4107972026-03-05T07:45:46ZthomasGberyr2008-05-13UHC-53888-98———5287 Jefferson AvenueSacramentoca95821GRP-3951OPTIONS-PPO
PRVPRV-251972026-09-29T01:07:00Z ·BILLY··WEAVER06/25/75UHC-25544-03—751-794-6640··billy.weaver@yahoo.com··2855 BAYSHORE DRSCOTTSDALEAZ85267—·select-epo
ENRENR-1008072026-09-03T08:16:05ZHEATHERJ.MORRISON1956-06-01UHC4974686•••-••-9505·(967) 690-7561heather.morrison17@icloud.com6229 River RdNashvilleTN37250··GRP-6332MEDICARE-ADV-A
ENRENR-1271242026-04-07T08:26:03ZDanielle—Vazquez··1948-10-27UHC-84606-92•••-••-3697+1 400 382 7761danielle.vazquez70@outlook.com8681 GRAND AVENUEATLANTA··GA30386GRP-7573SELECT-EPO
ENRENR-1279452026-08-28T23:54:29ZJenniferIWeber05-07-1946UHC-83139-76•••-••-616619197241137JENNIFER.WEBER33@PROTON.ME4569 Jefferson AvenueEden PrairieMinnesota55389GRP-4223··MEDICARE-ADV-B
ENRENR-1175222026-01-06T06:01:43ZBRUCEHMURRAY1993-10-11UHC-95825-79•••-••-5310(289) 307-2986BRUCE.MURRAY70@AOL.COM2873 Highland AveMinneapolisMN55438GRP-4936OPTIONS-PPO
ENRENR-1075622026-02-02T02:54:40ZBrittany—PerkinsJun 1, 2007··UHC-89671-08•••-••-3679753-392-8119BRITTANY.PERKINS53@YAHOO.COM··4631 BroadwaySan DiegoCA92106GRP-5976CHOICE-PLUS-PPO
ENRENR-1156322026-06-29T06:35:40ZNATHAN—FOX26-01-1968UHC-69999-99•••-••-2968·+1 679 775 9415NATHAN.FOX@AOL.COM4909 Mountain View DriveFresno··California93763GRP-4301SELECT-EPO
CLMCLM-4166302026-08-09T21:04:33ZDenise—Schmidt19690502UHC-99733-49•••-••-0645(850) 762-6288—3988 Mesa DriveMESAAZ·85273GRP-0334SELECT-EPO
ENRENR-1085792026-06-20T12:32:37ZStevensIKatherine1952-12-20UHC-93932-26•••-••-9971(428) 875-5375-7115 Apache BlvdJacksonvilleFL32255GRP-9231NAVIGATE-HMO
ENRENR-1130252026-02-03T13:41:14Z·CHRISTYNASSTONE1929-04-11UHC-37469-45•••-••-9145+1 325 957 7841christina.stone@outlook.com100 Lake View RoadColumbus··OH43289GRP-2832MEDICARE-ADV-A
ENRENR-1096792026-02-11T23:12:18ZDinaa—Griffin·0632-19-64UHC-20806-76•••-••-3542—UNKNOWN8389 Valley View DriveFRESNO·CA93727GRP-9431NAVIGATE-HMO
CLMCLM-4020192026-05-14T21:26:44Z·JaniceT.Adams20-10-1960UHC-49605-18—259-893-3633-6917 FOREST AVENUEGILBERTAZ85242-2195GRP-5613N/A
100,000 rows, page 122 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:36.686Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty