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-1406122026-07-15T23:27:30Z·BRADLEY—PEREZ02/23/88UHC1247359•••-••-19308529010649BRADLEY.PEREZ@AOL.COM3352 Oak StreetORLANDOFL32837GRP-9288NAVIGATE-HMO
CLMCLM-4114142026-09-05T20:28:14ZStewart, Vincent——1939-04-05——NULL—8497 VALLEY VIEW DRJacksonvilleFL··—GRP-5189CHOICE-PLUS-PPO
TPATPA-609992026-02-16T03:55:14ZWEI—WARD1973-01-21—N/A(879) 989-5704N/A6543 Jefferson AvenueMinneapolisMN·55455GRP-1567MEDICARE-ADV-B
CLMCLM-4301152026-04-19T07:06:29ZGardner, Isabella——9/23/1997--743-845-2183-2017 SUNSET BLVDDALLASTX75208GRP-8335null··
ENRENR-1060472026-06-08T00:48:31ZSera—Grannt·1940-11-27UHC-49131-62•••-••-6167+1 853 673 7571sara.grant18@yahoo.com5360 Spring Street·DENVERCO80288-1375GRP-1334CORE-HMO
PRVPRV-223272026-07-21T22:21:14ZCrawford, BrianX··1992-10-20uhc-01606-11•••-••-6699—-8357 Mountain View DriveNashvilleTN37218NULL—
TPATPA-570672026-03-19T14:44:10ZRomero—Vincent1993-07-13—NULL816.391.6132UNKNOWNNULLN/AN/AUNKNOWNN/A··-
CLM CLM-4066652026-09-03T03:34:33ZELIZABETH—HARRISON1965-09-25UHC-17943-36-423-555-0063nullNULLnullNULL—GRP-6450N/A
ENRENR-1111392026-02-06T21:02:44Z KAYLA·D.ROBINSON1970-05-04UHC-81146-87•••-••-4353·4834625711kayla.robinson@hotmail.com9260 Canyon RoadPlanoTX75064··GRP-3361CORE-HMO
CLMCLM-4106762026-07-21T05:02:50ZGRACE—ROSS1985-12-22UHC-85981-15—(215) 274-7706NULL5740 Sunset BoulevardEden PrairieMN55308GRP-9022—
TPATPA-571352026-02-17T04:07:09ZChristian—Moreno1942-07-05N/A·NULLNULLCHRISTIAN.MORENO@PROTON.MENULL—NULL··UNKNOWNNULLNAVIGATE-HMO
CLMCLM-4006512026-06-17T11:11:07ZARJUN—LUCAS——N/AUNKNOWN——NULL-—nullCHOICE-PLUS-PPO
CLMCLM-4235382026-03-16T07:14:45ZMarquez, KyleU—5/17/1961uhc-33743-82—(689) 891-6313—3116 Main StGlendaleAZ85367—NULL
ENRENR-1093922026-08-26T18:17:49ZlindaKobrien04/01/1944UHC-52970-96•••-••-9747N/Anull3414 Canyon RoadNashvilleTN37292GRP-6426MEDICARE-ADV-A··
CLMCLM-4180672026-05-23T18:48:18ZCollins, DouglasE····19411014UHC-00437-78———446 Baseline RoadTEMPEAZ85211GRP-9653—
CLMCLM-4271092026-10-07T08:41:31Zstephanie—gardnar1959-04-04··UHC-79152-88—-STEPHANIE.GARDNER@HOTMAIL.COMUNKNOWNnullnullnullGRP-5175MEDICARE-ADV-B
ENRENR-1338532026-02-22T17:50:13Zdonna—ellis07/03/65UHC5647817•••-••-76703776934209-4083 Desert Sky BoulevardJacksonvilleFL32293GRP-2424MEDICARE-ADV-B
PRVPRV-24845 2026-01-08T22:57:12Z·ArthurT.Wagner19540618UHC-89496-41-—UNKNOWN·6277 Spring StTempeAZ85224NULLnull
CLMCLM-4062832026-02-23T11:42:01ZEricQReed11/15/1967UHC-30938-27—N/ANULL6945 Ridge RoadAtlantaGAnullGRP-5594CORE-HMO
CLMCLM-4243172026-02-12T23:46:11ZEmily—Ortega1946-07-20—NULL942.578.5381UNKNOWN5771 Grand AvenueLas VegasNV89179-1971GRP-3289null
PRVPRV-207212026-07-18T03:29:11ZKATHLEEN—COLE1991-08-26UHC-27256-01•••-••-0743(584) 507-2561—7611 Central AveFRESNOCA93730-6505UNKNOWN—
ENRENR-1210792026-10-09T15:55:53Zalexander—daniels2003-02-09UHC-29855-22•••-••-1048(488) 413-7338··ALEXANDER.DANIELS87@PROTON.MEN/A-—UNKNOWN···GRP-9764MEDICARE-ADV-B
ENRENR-1030092026-01-14T16:06:58ZAlexander, Ann——1989-06-18UHC-24579-76•••-••-1934(643) 515-5275ann.alexander13@outlook.com8659 OCEAN AVENUEColumbus·OH43267GRP-1404NAVIGATE-HMO
ENR ENR-1041082026-07-15T09:01:27ZVazquez, Alexander——0122-19-72UHC-02231-41N/A983-554-6311alexander.vazquez@gmail.com8271 Meadow LnEden PrairieMN55394··GRP-7396MEDICARE-ADV-A
ENRENR-1147992026-10-18T02:32:17ZJaackV.Guerrero·12/4/1992UHC-47990-80•••-••-6143(394) 500-6227jack.guerrero@gmail.com197 Sage Ct Apt 25ChandlerAZ85226GRP-5489OPTIONS-PPO
ENRENR-1156382026-01-10T00:11:04Z·Gordon, Judy—··1989-01-19UHC-42217-51—(727) 848-1504UNKNOWN3894 BROADWAYAUSTINTX78713GRP-3284NAVIGATE-HMO
ENRENR-1309492026-04-28T23:08:15ZAndrew U—Nunez08/24/59UHC-64434-62•••-••-98782167408191··ANDREW.NUNEZ@OUTLOOK.COM9834 ELM STAUSTINTX··78793-5042GRP-5866NAVIGATE-HMO
ENRENR-1019942026-08-01T03:53:46ZgloriaIperrry1954-11-27uhc-93729-34•••-••-4391·3412876gloria.perry@icloud.com4828 Apache Boulevard··TampaFL33603GRP-3273SELECT-EPO
TPATPA-613082026-01-07T22:51:20ZAhmed—Li05/11/1952N/A—8079369613UNKNOWN9424 PARK PLACEEden PrairieMN55361——
ENRENR-1007762026-03-12T17:29:12ZJESSE—KIM1967-01-14UHC-45304-40•••-••-01053357488814JESSE.KIM70@ICLOUD.COM3377 MARKET STFresnoCalifornia93709GRP-0127MEDICARE-ADV-B
PRVPRV-230942026-07-25T06:06:05ZralphG.burns1962-07-13NULL—(227) 615-7714NULL—nullnullNULL—CHOICE-PLUS-PPO
PRVPRV-253072026-03-19T05:15:05ZMARIANA—RAY14-12-1981——4435063290··NULL5557 HILLCREST ROADMinneapolisMN55417··UNKNOWN
CLMCLM-4195522026-09-13T19:05:28Z William··PerrySep 14, 2005UHC-95896-51•••-••-0313—-·5842 Union StreetSan DiegoCA92161GRP-9407MEDICARE-ADV-B
ENRENR-1369372026-01-30T08:43:47ZJacob—Romero1953-11-04UHC-62450-79•••-••-09293183286700N/A6080 Market Street··San AntonioTexas78241GRP-1663MEDICARE-ADV-A
CLM CLM-4176012026-06-02T22:46:39ZVargas, Arthur——1966-01-23UHC-94619-95—UNKNOWNN/A·null—NULL—N/A—
ENRENR-1068622026-09-05T02:39:02ZJessicaX.Montgomery··1977-07-19UHC-28580-22•••-••-1790(665) 401-9985jessica.montgomery45@yahoo.com4165 Jefferson AveFresnoCalifornia93787·GRP-7026OPTIONS-PPO
CLMCLM-4075042026-03-31T13:38:57Z·Julie—Lee1985-06-28UNKNOWN•••-••-70809624847955-7238 MAIN ST #929TucsonAZ——N/A
CLMCLM-4087142026-02-21T19:02:29ZGordon, Vincent····—1973-01-03NULL•••-••-8781—N/Anull—NULLUNKNOWN—medicare-adv-b
CLMCLM-4168882026-04-09T11:14:19ZHUGHES—JERRY1983-05-26UHC-35049-87•••-••-5123N/A—1707 Hillcrest RoadSeattleWA98147null··-
CLM CLM-4200352026-08-23T13:54:01ZBobby—Butler2008-11-09UHC-08110-05•••-••-5846-BOBBY.BUTLER@AOL.COM7923 Ridge Rd··FRESNO·CANULLGRP-5902SELECT-EPO
PRVPRV-227382026-06-18T04:09:59ZCynthia·I.Diaz·02-12-2002UHC-72241-56··—·858.606.4607—4342 BASELINE ROADDenverColorado80274—SELECT-EPO
CLMCLM-4031012026-05-22T16:57:28ZRuth··Black11/09/62UHC-63053-46———3100 Washington StPlanoTX75023····MEDICARE-ADV-B
ENRENR-1058202026-09-11T01:38:30ZSamantah—Castillo09/18/1972UHC-23757-47•••-••-07274294026965samantha.castillo81@icloud.com398 Meadow LnAtlantaGA30302GRP-3802CHOICE-PLUS-PPO
ENR ENR-1363062026-02-11T16:09:37ZJoanSAlexander08/27/1938UHC-34592-23•••-••-8157300-302-6946joan.alexander35@outlook.com165 Willow CtScottsdaleAZ85248-8593GRP-9832SELECT-EPO
ENRENR-1058082026-05-05T11:20:36ZDiane—Robertson1941-09-08UHC-53879-40•••-••-261015022280116diane.robertson86@outlook.com3234 Union StMinneapolisMN55442··GRP-0666··CORE-HMO
TPATPA-620852026-03-03T03:30:55ZMEI—GRANT19670721null—N/A—8400 Main StreetEDEN PRAIRIEMN55319GRP-1354·UNKNOWN
ENRENR-1292202026-06-10T22:49:57ZCATHERINE—GREENE··23-11-1985UHC-14019-01•••-••-42257135916637CATHERINE.GREENE27@PROTON.ME6073 FOREST AVE·JacksonvilleFL32262··GRP-8819CORE-HMO
ENRENR-1385922026-08-17T23:58:19ZBrandon—Salazar1984-01-01UHC-46520-73•••-••-1110581-778-4026brandon.salazar@outlook.com1111 Main StreetLas VegasNV89166GRP-2046MEDICARE-ADV-A
TPATPA-619312026-05-04T17:33:21ZDean, Madison——12/12/1972N/ANULL(316) 498-7718—NULLNULLNULL-····—
CLM CLM-4212172026-02-08T20:12:24Zrandy—carlson1948-01-28UNKNOWN•••-••-8110(311) 460-0537—9624 Baseline RoadDallasTX75207NULLN/A
100,000 rows, page 232 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:37.738Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty