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-1073442026-04-25T15:59:22ZJOSEPHG.POWELLApr 1, 2004UHC-08796-88•••-••-1406723.774.0184joseph.powell@outlook.com8580 BroadwayTucsonAZ85748GRP-9982NAVIGATE-HMO··
CLMCLM-4115582026-09-12T06:46:37ZGary—King1974-08-05——+1 453 467 1857UNKNOWN6406 Camelback RdColumbusOH43211GRP-6913-
ENR ENR-1230022026-06-30T18:05:29ZJoyceGFord1937-01-02UHC-98667-97•••-••-16694718619953··joyce.ford@proton.me··5908 Central AveGlendaleAZUNKNOWNGRP-1281OPTIONS-PPO
PRVPRV-216832026-03-20T06:51:29ZEMMA····FERNANDEZ15-02-1989UHC0390718UNKNOWN+1 693 966 1786—5873 BAYSHORE DRPhoenixAZ85030NULL—
ENRENR-1053452026-07-23T04:38:32ZKennethL·Rogers1990-07-12··UHC-80661-82•••-••-7628NULLKENNETH.ROGERS@YAHOO.COM7275 Elm StScottsdaleAZ85264GRP-5148OPTIONS-PPO
CLMCLM-4264262026-04-07T18:20:20ZSaar··Kim19611119UHC-68327-33null—N/A4384 MEADOW LNTempe·AZ85239··GRP-3531—
CLM CLM-4298282026-04-24T07:47:27Zkelly—rivera1941-09-27UHC-23051-08N/A+1 355 495 4254—7314 Baseline RoadPhoenixAZnullGRP-4655··NAVIGATE-HMO
CLM CLM-4033032026-04-13T21:24:32ZMurray, Omr——1960-02-04UHC-31124-86NULLN/AN/A8437 River RdDENVERCO80215GRP-6401····
PRVPRV-284392026-01-06T20:09:31Zjoyce—johnson1994-08-04UHC-57438-80NULL··N/A1785 Ridge RoadScottsdaleAZ85209——
ENRENR-1104132026-05-27T19:26:12ZJASON—·FISHER1943-08-05UHC-51837-41NULL(871) 706-4323jason.fisher75@aol.com1012 Camelback RoadAUSTINTX78793GRP-7071NAVIGATE-HMO
CLMCLM-4236302026-01-01T09:13:05ZMartha·RLewis7/20/2005UHC-83453-88•••-••-62987503410732NULL9277 Bayshore Dr #676ColumbusOH43224—·N/A
ENR ENR-1299232026-08-19T07:08:33Zjonathan—kelly1985-10-27UHC-10931-15•••-••-9269—-5606 Washington StreetPhoenixAZ85082GRP-8879SELECT-EPO··
ENR ENR-1320082026-04-03T04:27:07ZYuki—Hunter1969-11-20UHC-02763-80•••-••-0815836-782-0378yuki.hunter@icloud.com820 Bayshore DrCharlotteNC28273··GRP-2610NAVIGATE-HMO
ENRENR-1109222026-01-13T16:17:39ZSHIRLEY—BUTLER·09/06/93uhc-47514-26•••-••-00806140395shirley.butler@proton.me218 Canyon RdPhoenixAZ85006-3855·GRP-4963core-hmo
PRVPRV-238122026-07-17T22:30:13ZAaron—Rojas0811-19-80UNKNOWN•••-••-3086316-435-2379—1140 SPRING ST·Tempeaz85244-MEDICARE-ADV-B
CLMCLM-4243852026-04-03T19:38:34ZOMAR—PEREZ0205-17-96UHC-67246-08null——5497 CANYON ROADLas VegasNV89146GRP-4313··CORE-HMO
CLMCLM-4246812026-05-12T14:59:15ZDanielle—Graham10/18/85UHC-01900-59N/A13775011977nullnull——NULLUNKNOWN—
CLMCLM-4067522026-06-22T01:20:05Zmaria—robinson12/3/1962-•••-••-4498—UNKNOWN·717 Grand AveColumbusOH43281-7751GRP-5506MEDICARE-ADV-A
TPATPA-620252026-08-11T07:41:46Z·Andrew—Carroll19420421UNKNOWN•••-••-3421NULL-8282 BASELINE RDTEMPEAZ85254null—
CLMCLM-4219332026-02-15T17:20:12ZMARIAJ.WELLS2005-07-01UHC-83588-76———2693 Highland AveEden PrairieMN·55364NULLnavigate-hmo
PRVPRV-217752026-08-01T07:47:11Z BradleyG.Carroll1968-11-05UHC-64547-12NULL(764) 650-2640—2490 Market St·GlendaleArizona85383-2819UNKNOWN-
TPATPA-513832026-08-15T18:05:02ZVINCENT—BROOKS11/9/1946NULL•••-••-9493—NULL1195 RIDGE RDEden PrairieMN55300-3388--
CLMCLM-4238012026-10-12T18:41:22ZDorisPKing07/06/76UHC-76651-46NULLnull-1377 Indian School RdTampaFlorida-GRP-4808MEDICARE-ADV-B
TPATPA-596392026-05-24T14:25:41ZDENNY—GARDNER10-04-1974null——UNKNOWN2179 BROADWAYColumbusOH43279-N/A
CLMCLM-4259322026-07-20T06:19:58ZTheresaQ·Ortiz1979-04-04··—•••-••-8626—UNKNOWNnull—N/A—GRP-0230····
TPA TPA-638762026-07-10T08:40:43Zpeter—·roberts2008-09-12··nullNULL····NULL1031 Grand AvenuePlanoTX75042GRP-8244N/A
TPA TPA-530602026-02-16T02:45:11ZAustin··—FloresMar 14, 1945—UNKNOWNUNKNOWNaustin.flores45@outlook.comUNKNOWNnull—UNKNOWN—N/A
PRVPRV-268782026-04-27T22:22:56ZHall, SamuelL.—1988-09-22UHC-61573-06—(212) 730-4833samuel.hall90@yahoo.com6266 MESA DRIVE·ColumbusOH43281—UNKNOWN
ENRENR-102483 2026-06-16T13:21:54ZEmma A—Soto19910625UHC-16810-12•••-••-6619408-650-8334EMMA.SOTO@OUTLOOK.COM7361 WILLOW CT #632TampaFL33665-5000GRP-4432MEDICARE-ADV-A
ENRENR-1137552026-04-18T08:29:37ZCheryl—Moore5/15/1945UHC-22464-21•••-••-845513574828075·cheryl.moore@outlook.com——NULL—GRP-4700NAVIGATE-HMO
ENRENR-1084232026-09-30T13:28:31ZDeborah—Little1947-09-24UHC-55053-59•••-••-4713nulldeborah.little10@hotmail.com·2867 Desert Sky BoulevardSeattleWA98176GRP-2565MEDICARE-ADV-A
CLMCLM-4277372026-05-03T17:15:44ZHuughes, Lucia····1939-07-22UHC-07805-06•••-••-68913725976654UNKNOWN··3294 LAKE VIEW RD·ATLANTAGA30345——
ENRENR-1197302026-09-24T03:14:58ZAnthony·····Wilson06/01/1939·UHC1377669•••-••-4417(982) 814-1368··anthony.wilson89@yahoo.com2727 RIDGE ROADFresnoCA93778-3085GRP-6494OPTIONS-PPO
CLMCLM-4307242026-04-01T17:45:40ZMATEO—SALAZARMay 19, 1965UNKNOWNN/A8103428509UNKNOWN4525 HIGHLAND AVENUE·MesaArizona··85215—··
CLMCLM-4058272026-08-17T16:41:26ZFields—Mayr1988-03-05UHC-83147-55—+1 672 357 1152N/A9296 OAK STGilbertAZ·85248GRP-8234SELECT-EPO
ENRENR-1359912026-08-04T18:39:20ZDOUGLAS—MORGAN1959-03-06UHC-72083-48•••-••-86679145864757—9149 Camelback RdPhoenixAZ85077GRP-7945MEDICARE-ADV-A
PRVPRV-220312026-08-16T19:06:02ZDavis, Gerald——1959-07-13UHC-68736-64——gerald.davis@outlook.com7154 Pine DrTempeAZ85215····NAVIGATE-HMO
TPATPA-558752026-07-13T15:30:38ZAisha—Walker1991-12-23null•••-••-4161575-392-4222-9366 Union StColumbusOH43292-9870··GRP-8731—
CLMCLM-4241732026-10-10T08:11:36ZGREGORY··—PRICE07/24/91UHC-11694-58—UNKNOWN··—3676 Harbor BlvdTampafl33699GRP-5557null
TPATPA-555462026-08-11T19:02:32ZChristopher—Chavez04/25/44—•••-••-4129null-5415 Forest AvenueLos AngelesCA90043·GRP-5182null
CLMCLM-4094592026-03-02T22:35:14ZJustin—Shaw07/27/1985UHC2269454•••-••-7486—NULL861 Ridge RoadDALLASTX—GRP-5284MEDICARE-ADV-B
CLMCLM-4128202026-10-11T16:16:03ZHIROSHI—HARVEY1985-11-11—····5002212954NULL2083 Park PlaceJacksonville·FL—·GRP-5673—
ENRENR-1228762026-06-23T07:40:14ZHENRY—CHEN1983-04-24UHC-49957-77•••-••-43875826446147UNKNOWN3732 Palm DriveTucsonAZ85754-4858GRP-3972NAVIGATE-HMO
TPATPA-632632026-01-21T19:29:50ZChristine—Marquez1941-01-03nullnull—··5341 MEADOW LNTampaFL33627-7881··GRP-3623·NULL
CLMCLM-4000242026-07-22T20:43:41ZBrrandon—Peters1951-06-20··UHC-02094-11•••-••-7807··NULLNULL—null··nullGRP-7824—
ENRENR-1395942026-06-20T23:28:33ZMELISSA··—SIMS02/17/1975UHC-56605-33•••-••-2372—N/A5162 WILLOW COURT·COLUMBUSOH43277GRP-7171medicare-adv-a
CLMCLM-4299862026-01-31T21:24:56ZRaymondP.Wood25-01-1988N/A•••-••-1746N/AN/AN/Anullnull—GRP-5296UNKNOWN
PRVPRV-259012026-05-10T00:39:02ZBryan—Banks1985-07-06····UNKNOWN+1 411 761 6199bryan.banks78@aol.com1805 PALM DRIVEPhoenixaz85090——
ENRENR-1010642026-04-15T23:29:56ZGRACED.RODRIGUEZ1994-03-14UHC-74123-45··•••-••-34167595967642grace.rodriguez@hotmail.com4481 Sage Court Apt 10SAN ANTONIOTX78217GRP-9084OPTIONS-PPO··
CLMCLM-4036332026-05-02T04:38:44ZANNA—FORD2007-09-16UHC-74396-85•••-••-8619-—3069 Cedar LnPhoenixAZ85017nullSELECT-EPO
100,000 rows, page 91 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.801Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty