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-4317622026-05-10T19:12:37ZEspinoza, Rebecca——19541227UHC9195897•••-••-3574N/ANULL—NULLNULLN/AGRP-6325MEDICARE-ADV-A
CLMCLM-4054152026-01-11T02:55:23ZEric—Ortiz5/10/1941nullNULL-N/A8668 DESERT SKY BLVDMIAMIFL33121NULLCORE-HMO
TPATPA-638622026-02-11T22:34:47ZALBERT P—HOWARD11-09-2004UNKNOWN—242-643-8010·····6203 Park PlaceGilbertAZN/A——
CLMCLM-4175652026-06-29T01:00:19ZMARIANA—FREEMAN1968-12-20UHC-39956-01N/A8975461539UNKNOWN7185 Valley View DriveLas VegasNevada89109··GRP-1851N/A
ENRENR-1145392026-03-14T22:14:40ZSarah—Carlzon··Oct 24, 1989UHC-35766-45•••-••-8650842-401-3054SARAH.CARLSON@YAHOO.COM·1651 Sunset BlvdLas VegasNVNULLGRP-8325CHOICE-PLUS-PPO
ENRENR-1366592026-07-05T16:58:32ZRalph—Harper2008-03-13UHC-54586-42•••-••-75616028804067RALPH.HARPER3@OUTLOOK.COM1648 CANYON RDDallasTX75283GRP-3520··MEDICARE-ADV-B
CLMCLM-4173462026-07-19T15:34:25ZKelly—Morris1994-11-22·UHC-78551-07—-—6358 SAGE COURTOrlando··FL32856GRP-8848OPTIONS-PPO
CLMCLM-4227132026-07-03T05:38:01ZDaniels, Larry·····9189-04-04NULL-—null5621 MARKET STGlendaleAZ·85343GRP-8343—
CLMCLM-4010492026-02-08T02:54:12ZChristina—Singh1972-07-12··UHC-36281-66NULL——1049 Harbor BlvdTempe··ArizonaNULL——
CLMCLM-4002782026-01-04T18:12:05ZAmber—Soto2010-06-04N/A•••-••-8208N/A—1088 Hillcrest RdDENVERCO—GRP-4627N/A
CLMCLM-4243442026-09-20T02:25:22Zheather—vazquez14-05-1956UHC-60010-83•••-••-6293(687) 609-4958-·1445 CENTRAL AVEGlendale··AZ85399—SELECT-EPO··
ENRENR-1309032026-06-29T09:54:44Z Dvaid—Coleman1961-05-27UHC-19416-38•••-••-2701333-262-0984david.coleman16@proton.me8553 Hillcrest RdMESAAZ85295GRP-3025NAVIGATE-HMO
ENRENR-1254952026-07-24T00:33:56ZCARLOS—HOWARD05/04/59UHC-62694-54•••-••-2442(979) 703-7808—3073 SAGE COURTFresnoCA····GRP-6163NAVIGATE-HMO
ENRENR-1380242026-01-27T07:46:56ZVirginia—Johnstoon09/20/1978UHC-69226-82•••-••-9281(852) 367-5057—6385 RIDGE RDNashvilleTN37271GRP-2811·SELECT-EPO
ENRENR-1113432026-08-21T20:34:51ZMunoz, Sephen——04/11/71UHC-44645-89•••-••-8173(583) 855-6176NULL4303 Maple AveScottsdaleAZ85280GRP-6726MEDICARE-ADV-B
PRVPRV-211432026-07-28T23:31:44ZBobby—Waang1951-08-03NULL-238-665-0626—167 Harbor BlvdSACRAMENTOCA95888——
CLMCLM-4043392026-05-21T07:42:35ZMadisonLArmstrong10/11/1973-··UNKNOWN—6205 Grand AvePlanoTX75071GRP-8620NULL
CLMCLM-4285722026-05-13T17:04:13ZKayla—Knight1977-10-25UHC-89655-06—NULL—8687 Bayshore DrSacramentoCA95827NULL·CHOICE-PLUS-PPO
CLMCLM-4226452026-02-11T04:13:14ZTim—Rios19740318UHC6827284NULL··UNKNOWNNULL8728 Sage Ct··MiamiFL33123GRP-0521····
ENRENR-1080982026-05-11T03:49:57ZJanVFord1961-06-01UHC-81103-79UNKNOWN·18266112575joan.ford85@aol.com1232 Sage CourtTucsonAZ85756GRP-6280MEDICARE-ADV-B
ENRENR-1166762026-03-11T14:08:29Z CARL··V.··PEA19910322UHC-76006-41null(412) 885-1476carl.pena79@hotmail.com2590 Church StLas VegasNVN/AGRP-3888CORE-HMO
ENRENR-1292032026-05-17T14:00:29ZBENJAMINE.SANTOS1967-09-27UHC-77350-11—5217342562NULL6844 Main StreetTampaFL33656GRP-1673SELECT-EPO
ENRENR-1020372026-06-22T22:16:48ZJohn—Graham1982-06-14UHC-03219-23•••-••-22383267854971john.graham79@gmail.com719 Central AveTampaFL33657··GRP-2838CHOICE-PLUS-PPO
PRVPRV-270222026-01-16T20:02:02ZJustin—Ryan1975-11-04——12153826228justin.ryan@proton.me1898 Camelback RoadPlanoTX—-MEDICARE-ADV-A
TPATPA-535222026-08-24T10:17:51Zwillie—henry14-05-2000·null—321-797-2302UNKNOWNnullnullN/A-NULLN/A
CLMCLM-4305822026-07-18T12:21:58ZNancyOCarpenter19800607UHC-82726-77—nullN/A7629 OCEAN AVE #431DallasTX75246GRP-8129··—
TPATPA-629222026-07-13T06:26:17ZJimenez, Thomas—·····1993-09-18N/A··UNKNOWNNULL7889 Forest Avenue #726GilbertAZ85267GRP-5640-
PRVPRV-208102026-04-18T15:16:17ZGerald P—Li1954-12-24UNKNOWNnull(791) 321-3625NULL7477 River RoadJacksonvilleFL—·nullnull
PRV PRV-238092026-01-12T23:22:28Z·Ronald—Daniels1943-03-18UHC-95529-06-630-457-4545UNKNOWN2498 OAK STPlano·TX75033NULL—
CLMCLM-4110532026-07-07T19:27:35ZCollins, Bob··—·11-01-1952UHC-33675-90——ROBERT.COLLINS@OUTLOOK.COM626 Spring StSacramentoCA95859nullUNKNOWN
CLMCLM-4214112026-05-15T07:41:43ZPHILIP—RODRIGUEZ1939-08-18UHC-28391-78•••-••-3633(271) 779-1205N/A4856 Desert Sky Blvd Apt 18AtlantaGA·30334GRP-8466—
ENRENR-1308272026-09-07T05:13:59ZharoldU··marquez19430927N/A•••-••-2536727-881-3823harold.marquez@hotmail.com1701 Lake View RoadTEMPE··AZ85241··GRP-2147MEDICARE-ADV-B
CLMCLM-4010842026-03-22T14:45:27ZThomas—West1961-12-16UHC-63916-28—UNKNOWNN/A-UNKNOWN—nullGRP-2599CORE-HMO
CLMCLM-4108082026-01-12T23:56:16ZNicoleNRichardson2008-09-22UHC-06257-82UNKNOWN725-707-6485—·2529 Canyon RoadHouston··TX77064GRP-4475MEDICARE-ADV-A
ENR ENR-1093022026-09-09T08:31:15ZSAMANTHA—FREEMAN1977-05-08UHC-78622-78•••-••-5424(755) 511-5205samantha.freeman98@aol.com1512 Camelback RdScottsdale·AZ85243GRP-1739CORE-HMO
ENRENR-1281952026-03-12T15:46:34ZGREGORYMWILLIS1952-09-13UHC-20155-17•••-••-5051—GREGORY.WILLIS3@ICLOUD.COM6901 Pine Drive··AtlantaGA·30391GRP-2079OPTIONS-PPO
TPATPA-603812026-06-19T08:10:08ZOliviaF.Day1963-05-16UHC-80025-41NULLN/A—·9042 Pine Drive·TampaFL··33628GRP-5467····
TPATPA-500652026-04-07T12:11:24Z Jennifer—Cole··1962-10-12N/A—····N/A··—N/A—-—
CLMCLM-4024492026-05-07T04:34:19ZBetsyVFreeman1945-09-03—•••-••-10106615399—3288 Valley View DriveDenverColorado··80200GRP-7881—
CLMCLM-4245432026-01-11T14:41:03ZJudyX.Walker1964-12-08—NULL617.575.5014N/A1921 Grand AveFresnoCA93728GRP-2954NAVIGATE-HMO
CLMCLM-4313092026-01-02T06:21:29ZKeith—Herrera1976-08-18—•••-••-1393563-624-9105N/A740 BroadwayLOS ANGELESCalifornia·90052-6078GRP-6454OPTIONS-PPO
CLMCLM-4078752026-03-23T21:59:07Z·Arnold, Mari——19860313UHC-85249-31•••-••-6371——UNKNOWNNULLUNKNOWN—nullNAVIGATE-HMO
PRVPRV-270502026-02-24T20:00:44ZRyan—Myers06/28/51UHC-22890-68-5225174293-3563 River Rd Apt 30·PlanoTX75031····
CLMCLM-4088272026-09-09T22:11:39ZJUAN—ELLIS1996-07-02-—6793189275-·-——·NULLGRP-9939—
CLMCLM-4053202026-09-03T02:13:31ZAMY—WASHINGTON1964-07-27UHC-41659-76N/A-NULL8281 Mountain View DriveFresnoCA·93710-4353N/A—
ENRENR-1027082026-02-01T03:40:53ZJOYCESCUNNINGHAM1953-08-27—•••-••-77354667893731joyce.cunningham@aol.com6191 Baseline RdDallasTX75242GRP-0938MEDICARE-ADV-B
ENRENR-1385492026-03-30T03:52:22ZJoyceSWalsh··2005-05-05UHC-32807-99•••-••-78348707354629-3039 Ocean AveTampaFlorida33641GRP-1372SELECT-EPO
CLMCLM-4262832026-10-03T20:51:12ZNathan—Crawford06/03/02uhc-83107-81··nullNULL—·null———GRP-1457MEDICARE-ADV-A··
CLMCLM-411596 2026-03-23T03:28:02Zaustin—morales08-04-1992UHC-73946-07NULL3978119293N/A898 BroadwayCharlotteNC28266-3176GRP-9564N/A
CLMCLM-4221392026-02-06T07:39:35Z danielle—price1967-09-04UNKNOWN—+1 868 523 7340UNKNOWN—null-nullGRP-1869CORE-HMO
100,000 rows, page 154 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.701Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty