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
ENRENR-1191552026-06-18T14:45:54ZGloriaXBailey02/20/1959UHC-58214-02•••-••-8064546-270-1006gloria.bailey37@gmail.com8919 Indian School RdLOS ANGELESCA90030GRP-4656CHOICE-PLUS-PPO
ENRENR-1022302026-04-02T07:04:11ZDylanCKim··2007-06-24UHC-93308-26•••-••-4344(894) 669-4364dylan.kim20@outlook.com7800 Elm St·DALLASTexas—GRP-5204SELECT-EPO
ENRENR-1258792026-02-08T10:49:28ZByrant, Jack——03/28/1943uhc-24204-39•••-••-6054+1 322 328 2768··—5800 WILLOW CTSacramentoCA95828GRP-1389SELECT-EPO
CLMCLM-4103192026-04-11T21:25:37Z·cheryl—barnes20-12-1967UHC-40226-91•••-••-0403NULLnull··--UNKNOWN—NULLCHOICE-PLUS-PPO
ENR ENR-1355732026-05-12T22:43:01ZJeremy—Chen·5/25/2007UHC-50178-70•••-••-9025(704) 710-5583·jeremy.chen@aol.com2206 SPRING STREET··FresnoCA93730GRP-7926NAVIGATE-HMO
TPATPA-609342026-02-11T03:20:04Z·Daniel—Green1995-11-06—•••-••-1465——4827 Lake View RdOrlandoFlorida32838GRP-0805—
ENR ENR-1211952026-03-15T13:27:37ZBruce—Stevens2003-02-23UHC1925074•••-••-8144+1 865 838 7604null4915 BroadwayTucsonAZN/AGRP-9537CORE-HMO
TPATPA-613432026-05-01T23:05:48Z·IsabellaU.Miller03/22/92UNKNOWN•••-••-7382nullNULL7287 Lincoln WayMesaAZ85294GRP-2851CHOICE-PLUS-PPO
ENRENR-1397612026-09-07T03:58:38Z JEREMY—HUNT12-08-1955··UHC-59297-43•••-••-27356122857965UNKNOWN4716 Sunset BoulevardJACKSONVILLEFL—GRP-9217MEDICARE-ADV-A
TPATPA-605772026-05-27T17:57:41Z·kyle—cruz1947-05-02····N/A-NULL2342 Church StJacksonvilleFL··32226UNKNOWNMEDICARE-ADV-A
CLMCLM-4048962026-01-25T11:58:34ZWayne N—Weaver1954-08-08UHC-84816-21—·284.934.4569NULL8045 Main StreetAustinTX78710GRP-9885SELECT-EPO
ENR ENR-1352082026-09-03T01:30:01Zana—castillo1940-12-03UHC-82322-11NULL·(528) 921-5072ana.castillo48@proton.me8287 Church St··Mesa··AZN/AGRP-3467MEDICARE-ADV-A
TPATPA-509062026-03-09T19:40:38Zruth—mendez2007-11-17nullUNKNOWNNULLNULL7365 SPRING STREETSan AntonioTX78277——
ENRENR-1384162026-10-14T15:23:11ZBENJAMINGWRIGHT1974-05-17UNKNOWN•••-••-69803266584477—9599 Ocean AvenueOrlandoFL32824GRP-8002CHOICE-PLUS-PPO
TPATPA-517022026-09-27T06:22:46Zalbert—patel03/17/1949NULLNULLnull—7524 Forest AvenueFresnoCA—GRP-5218UNKNOWN
ENRENR-1026672026-07-24T09:33:50ZOmar—Holmes03/15/45·UHC-04491-04•••-••-61812992680455omar.holmes@hotmail.com6094 Meadow LnEden PrairieMN55304GRP-6083CORE-HMO
ENRENR-1154482026-02-17T23:23:42ZLoriJOliver02/06/1976UHC-25339-08•••-••-22626043238175lori.oliver@hotmail.com3932 Harbor Blvd·San DiegoCA92144GRP-1746OPTIONS-PPO
PRVPRV-261522026-08-17T15:44:27ZMARIANAU.JACKSON1992-11-20·-•••-••-3344499-631-0529··—8346 PALM DRIVEAustinTX—N/A—
ENRENR-1351012026-03-01T17:41:08ZAndrewX.TaylorFeb 22, 1999UHC-66788-05•••-••-86677355742889NULL1629 Harbor BlvdAtlanta··GA30307GRP-3253MEDICARE-ADV-B
CLMCLM-4179152026-05-15T03:17:42ZJudithHWest1965-07-26N/A•••-••-7460null-9842 BroadwayGilbert···AZ85238UNKNOWNN/A
ENRENR-1011952026-01-29T11:49:26ZAlanPJohnston8/13/1988UHC-44462-04•••-••-7147252-473-8587alan.johnston@proton.me1486 Central AvenueSeattleWA·98192-8568GRP-2084OPTIONS-PPO
ENRENR-1098222026-02-02T22:18:40ZNICOLEH.·WOODS16-05-1966UHC-33636-44NULL18003368493nicole.woods13@proton.me3333 Lake View RdORLANDOFL32897·GRP-3525MEDICARE-ADV-B
CLM CLM-4287642026-07-23T21:02:22Zelizabeth—rose2006-10-22N/A•••-••-2462386-345-7873—4365 BASELINE RDSAN ANTONIOTX78235GRP-2582MEDICARE-ADV-B
ENRENR-1116662026-05-26T03:23:12ZVirginia—Oliver1972-01-15UHC-84406-02··•••-••-40603209596604virginia.oliver95@yahoo.com··7715 Valley View DrPLANOTXUNKNOWNGRP-6296MEDICARE-ADV-B
PRVPRV-254672026-01-08T13:25:26ZDunn, BruceS—11/25/1962UHC-09543-24N/A16733786713—805 Grand AveGilbertAZ85235UNKNOWNnull··
ENRENR-1420912026-08-20T21:28:24ZDAVID—GREEN05/06/62·UHC-37765-37•••-••-2114—david.green35@outlook.com3728 Jefferson AveTucsonArizona85733GRP-0132CORE-HMO
TPATPA-623632026-08-12T00:31:11ZralphO.luna2001-08-04—null—-8713 Main StreetAtlantaGA·30341nullUNKNOWN
TPATPA-505912026-08-22T14:03:12ZDEBORAH—STEPHENS1998-04-13UHC-02721-84—8697199417··——·NULL—UNKNOWNN/ACORE-HMO
CLMCLM-4024422026-07-24T09:33:11ZRICHARD—PATTERSON23-06-1998UHC-63925-81•••-••-6931-NULL2676 Market StreetNashvilleTN37243GRP-5900MEDICARE-ADV-B
TPATPA-503262026-05-21T10:09:47ZMATTHHEW—HAYES1993-02-07-—464-921-9132UNKNOWN5670 River RoadDenverCO80220GRP-0673NAVIGATE-HMO
ENRENR-1367682026-04-23T18:23:14Z·RACHEL—YANG1945-11-12UHC-31551-04•••-••-2360381-736-7496··—2921 PALM DRIVEDenverCO80243GRP-7703··MEDICARE-ADV-B
CLMCLM-4153552026-04-15T07:52:19ZKENNETH—KANNEDY07/03/97UHC-75623-35•••-••-3238·563.866.6962null2830 Valley View DrMinneapolisMN55413GRP-6252-
CLMCLM-4163732026-02-13T02:43:54ZJEFFREY—RICHARDSON2/3/2002nullN/AUNKNOWNjeffrey.richardson@aol.com7932 Union StTempeAZ·85288GRP-9259CORE-HMO
CLM CLM-4113672026-05-25T20:06:07Zjonathan—wheeler·20071020null-UNKNOWNUNKNOWN8429 Hillcrest Road #900ScottsdaleArizona85285GRP-4743—
TPATPA-622812026-01-17T13:59:43Z·CatherineKJunes2003-04-07-•••-••-2208700-495-6362NULL—-··———CORE-HMO
TPATPA-507182026-10-05T14:56:48ZArjun····McCoy··1954-05-11—•••-••-2339UNKNOWN—3672 CAMELBACK ROADOrlandofl32804-CORE-HMO
ENRENR-1375262026-09-29T01:05:02ZBen—Hcks9/17/1968UHC-96945-10UNKNOWN9892746054benjamin.hicks@icloud.com3782 JEFFERSON AVENUETucsonArizona85701GRP-7265options-ppo··
PRVPRV-268222026-05-02T09:50:08ZARTHUR—JIMENEZ02/01/2001UHC-75581-43UNKNOWN7044303301ARTHUR.JIMENEZ@ICLOUD.COM··4586 Lake View RoadEDEN PRAIRIEMinnesota55342··-··
CLMCLM-4188142026-03-02T01:26:14ZMARIANA—FERGUSON1992-09-24UHC-69580-26—409-501-0491NULL3155 Pine DriveJacksonvilleFL32295GRP-6313MEDICARE-ADV-B
CLMCLM-4179132026-07-14T04:53:59ZFernandez, Amy——2005-10-02··-null——8451 Willow CtAustinTX78787GRP-6851—
ENRENR-1104672026-07-02T19:29:48ZDennyLValdez1945-06-25UHC-83311-86——DENNIS.VALDEZ14@PROTON.ME1633 Bayshore DrEDEN PRAIRIEMN55328GRP-2407MEDICARE-ADV-B
TPATPA-626342026-04-02T23:21:20ZANA—·CARR1981-08-17NULL—nullana.carr@hotmail.comN/ANULL——-NAVIGATE-HMO
TPATPA-580702026-03-09T09:38:04Zjanet—sullivanFeb 20, 1962··UHC-73270-99•••-••-5862516-640-3891JANET.SULLIVAN22@AOL.COM·2326 LINCOLN WAYDenverCO80219··N/A····
ENRENR-1190552026-04-08T21:08:01ZDon—Lopeez2007-11-17UHC-90293-76-(506) 835-3985donald.lopez@gmail.com495 Indian School Road··MIAMIFL33135GRP-0151SELECT-EPO
CLMCLM-4248692026-04-12T18:06:08ZNANY—MILLSFeb 27, 1950·N/A-··N/A4406 SUNSET BOULEVARDChandlerAZ85251GRP-5870NULL
CLMCLM-4194082026-06-17T07:16:26ZTorres, Mary······1951-03-26—•••-••-5780NULLnull5562 HIGHLAND AVENUEColumbusOH43298GRP-5496CHOICE-PLUS-PPO
ENRENR-1010582026-04-01T03:46:57Z·ALICEK.·KNIGHT1958-06-21UHC-58125-21•••-••-98168262531alice.knight@icloud.com6465 Pine DriveOrlando··FL32859··GRP-2336MEDICARE-ADV-A
ENRENR-1231182026-01-03T23:58:55ZCAROLYN—BAKER1950-07-15UHC-05286-37•••-••-5268(908) 629-2301··carolyn.baker@proton.me5503 Indian School RdMINNEAPOLISMinnesota55493GRP-1638SELECT-EPO
CLMCLM-4226232026-04-20T15:30:12ZSOFIA··—MITCHELL1023-14-93-•••-••-092114854661548null3017 Meadow LnSAN DIEGOCA92186GRP-6757—
CLMCLM-4323562026-03-15T09:59:02ZRoy—·James·1967-08-14—-——8311 Main StTucsonAZ85778GRP-9873NULL
100,000 rows, page 111 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.681Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty