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
CLM CLM-413636 2026-07-24T12:05:11ZTERESA—WALSH1949-10-07UHC1492454•••-••-3131858-657-1916N/ANULL———GRP-1653MEDICARE-ADV-A
ENRENR-1104292026-10-11T02:05:43ZMegan······Cook·1945-09-09UHC-29364-77··UNKNOWN305-463-5008null4062 Sage CtGlendaleAZ-GRP-5770·MEDICARE-ADV-B
ENRENR-1022752026-09-26T01:11:08ZARJNUPPALMER1989-03-27UHC1346870•••-••-629819487823154N/A8775 Elm StMesaAZnull··GRP-7661SELECT-EPO
ENRENR-1061422026-02-07T09:06:57ZRonaldL.Dean1982-08-11UHC-43191-80•••-••-2864UNKNOWNRONALD.DEAN@GMAIL.COM7414 Meadow LaneJacksonvilleFL32213-9023GRP-6309SELECT-EPO
ENRENR-1046662026-07-04T03:22:45ZBRADLEYHWALLACE1970-04-28uhc-69793-41•••-••-20177449822214-2777 Market StreetMinneapolisMN55419GRP-2063MEDICARE-ADV-B··
ENRENR-1038082026-05-04T02:19:56Z·Joshua—Diaz04/04/1988UHC-17950-82•••-••-4858838-502-8773joshua.diaz@hotmail.com693 Central AveFresnoCA93780·GRP-2926SELECT-EPO··
ENRENR-1286452026-06-19T10:44:27ZJaniceYOwens2001-03-19UHC-35715-39•••-••-6636(802) 721-1123janice.owens@proton.me·2484 CAMELBACK ROADLos AngelesCA90008··GRP-4157CHOICE-PLUS-PPO
ENRENR-1106732026-02-02T01:00:33ZJOANDMORRIS··21-12-2007UHC-13242-98•••-••-33796462704805·joan.morris@yahoo.com7097 Pine DriveSan DiegoCA92140GRP-4316MEDICARE-ADV-A
TPATPA-511052026-03-10T05:02:51ZMARY—JOHNSTON06/19/1950nullN/A263-223-3036··—612 DESERT SKY BLVDNashvilleTN37291NULLSELECT-EPO
CLMCLM-4043082026-06-21T05:17:03ZJerry—Perez1941-01-27UHC-73871-63—710.929.9262JERRY.PEREZ@AOL.COM—··NULL····—NULL··
ENRENR-1010602026-07-01T02:27:36ZRoyG··Fisher·1967-07-02UHC-91505-50•••-••-6868627-745-6138ROY.FISHER19@AOL.COM323 BASELINE ROADTAMPAFL33699GRP-4084CORE-HMO
TPATPA-61894 2026-01-07T16:52:30Zjack—castro03-08-1967NULLNULL(917) 574-3970jack.castro32@outlook.comnull——UNKNOWN·-null
ENRENR-1419642026-08-02T00:54:21ZRonald····Tucker09/15/1956UHC-02202-71•••-••-4359638-871-6847—122 RIDGE RDAustinTX78792GRP-6049CORE-HMO
CLMCLM-4070452026-06-30T01:45:38Zjoseph—peters1973-09-07UHC-30404-02N/A-null6481 BROADWAYNashvilleTN37274GRP-8174OPTIONS-PPO
CLMCLM-4081362026-05-05T23:51:33ZjosephKscottAug 21, 1975UHC-72343-79—UNKNOWN—7502 Desert Sky BlvdAustinTX78761GRP-1972····
PRVPRV-209642026-04-02T16:22:37ZJULIA—DEAN1959-11-20UHC-46436-46UNKNOWN498-414-6658—6505 HIGHLAND AVENUEJacksonvilleFL·32273—null
ENRENR-1378362026-04-20T07:58:50ZGraceE.Rios1940-12-04UHC-55558-64··•••-••-9135(964) 707-1813··GRACE.RIOS46@YAHOO.COM2070 Ridge RoadSeattleWA98122GRP-7138MEDICARE-ADV-A
TPATPA-623012026-01-02T08:34:49ZParker, Timothy··——1997-01-11N/A•••-••-95593266379772··—8235 MARKET STREETEden PrairieMN55368N/ACORE-HMO
PRV PRV-233632026-07-16T20:50:22ZCoper, Melissa——May 15, 1938UHC-12129-19•••-••-2092(888) 535-5416··null2787 BroadwayDenverCO80277NULLNULL
ENRENR-1053682026-01-07T02:31:59ZdorothyMgriffin2003-01-10UHC-42358-35-3283818154dorothy.griffin18@icloud.com1772 Pine DrSan DiegoCA92157·GRP-6939MEDICARE-ADV-A
ENRENR-1146322026-01-17T10:34:02ZRileyLMary1961-03-13·UHC-59201-69•••-••-5588—mary.riley90@gmail.com—N/AN/A—GRP-2214CHOICE-PLUS-PPO
TPATPA-548722026-04-21T13:11:46ZBetty—Watkins1959-10-19UHC-26145-99•••-••-96548705739315—9212 Desert Sky BlvdAtlanta··GA30343UNKNOWN—
ENRENR-1160872026-01-01T17:26:32ZvincentX.vazquez12/02/70UHC-50969-35•••-••-41016068241208VINCENT.VAZQUEZ67@PROTON.ME532 CHURCH STREET·MinneapolisMN55426GRP-6227OPTIONS-PPO
ENR ENR-1090422026-10-13T00:29:10ZColeman, Brenda——1993-09-06UHC-19276-60•••-••-8808517-780-0747brenda.coleman84@hotmail.com8164 Oak StreetTucson·AZ85751GRP-4631CHOICE-PLUS-PPO
PRVPRV-284142026-07-13T15:21:08ZREBECCA—ESTRADA03-01-1998UHC-94735-59•••-••-8069+1 898 388 5406—9541 Jefferson AveAtlantaGA30310—core-hmo
PRVPRV-288032026-08-06T01:51:59ZFreeman, Donald—····2/17/1947UHC-62334-11NULL·(600) 434-2609null1080 Palm DrTUCSONAZ85769··-UNKNOWN
CLMCLM-4216792026-08-08T18:04:29ZYukki—Gonzales1983-06-23——-yuki.gonzales80@icloud.com7979 PINE DRCharlotteNorth Carolina28244—MEDICARE-ADV-A
CLMCLM-4274612026-01-22T13:01:00ZGrace····Thompson1957-11-22UNKNOWN•••-••-4990(866) 984-6590GRACE.THOMPSON87@PROTON.ME—··-—-N/A
CLMCLM-4069302026-06-30T20:36:47ZREBECCA—HARRISONNov 28, 1997··•••-••-7297982-642-4169-—····—NULLGRP-5632SELECT-EPO
ENR ENR-1430732026-05-23T08:02:52ZcharlesMgordon1943-09-21UHC-54101-17•••-••-2814—UNKNOWN·2811 Desert Sky Blvd #641·SacramentoCA··95830GRP-6919MEDICARE-ADV-B
PRVPRV-208022026-04-22T06:06:13ZBrown, Alan——2004-01-08uhc-69982-03•••-••-8397—ALAN.BROWN96@AOL.COM740 CENTRAL AVENUE Apt 13PHOENIXAZ··85077—····
CLMCLM-4048072026-08-26T21:26:09ZCruz, Philip——1950-04-31UHC-16685-19—(811) 333-8351null7326 BroadwayAtlantaGA30313—null
CLMCLM-4322982026-04-23T15:35:24ZDANIELXPENAJan 8, 1971UHC-54987-16UNKNOWN+1 547 894 6677—9716 Maple AveHoustonTX77037——
CLMCLM-4056112026-08-01T10:43:05ZLane, MarianaL····1972-09-10N/Anullnull—3982 Cedar LnDenverCO80254NULLNULL
ENRENR-1103582026-07-15T09:01:17ZHELENRPENA2001-03-27UHC-35565-59•••-••-22257725058446HELEN.PENA64@HOTMAIL.COM6548 Palm Dr·Los AngelesCA90027GRP-9556MEDICARE-ADV-B··
CLMCLM-4224132026-08-13T09:44:32ZWei—Luna··1989-10-07UHC-19490-35•••-••-013717327094122-··——null--N/A··
ENRENR-1117072026-02-20T22:03:28ZgregoryHwebb28-05-1990··UHC-44136-24•••-••-5951815.234.1384gregory.webb44@hotmail.com3507 CAMELBACK ROADSACRAMENTOCA95859GRP-3110CORE-HMO··
PRVPRV-288202026-05-20T02:31:13ZFRANKG.YANG1954-06-13··UNKNOWN6147452696-4140 Jefferson AveNashvilleTN37272N/AUNKNOWN
ENRENR-1219862026-03-03T14:58:51ZAHMED—GIBSON13-03-1976UHC-32423-18•••-••-9263—ahmed.gibson@proton.me8166 Desert Sky Boulevard··OrlandoFL32817GRP-1551MEDICARE-ADV-B
CLMCLM-4269772026-04-28T00:17:35ZPeter·UVegaApr 6, 2002UHC-80214-61•••-••-4843(792) 591-1289-3312 Ridge RdFresnoCA93788GRP-0926MEDICARE-ADV-A··
ENRENR-1342512026-04-19T05:03:18Z·Richard····EspinozaMay 16, 1957UHC-68182-02•••-••-2977516-339-6241richard.espinoza96@outlook.com2683 Mesa DriveSeattle··WA98161GRP-4493MEDICARE-ADV-A
CLMCLM-4138062026-04-02T04:50:24ZWillie··Robinson08/05/67UNKNOWNNULLNULLnull5548 VALLEY VIEW DRIVEJACKSONVILLEFL32295-0973UNKNOWN-··
ENRENR-1109742026-06-16T16:00:32ZAbigail—Simmons1944-10-04UHC-94316-67•••-••-2231(256) 484-7168·abigail.simmons84@proton.me5286 CEDAR LNEden Prairie··MN55328GRP-8138NAVIGATE-HMO
ENRENR-1403572026-07-24T12:26:31ZDiegoL.Weaver1970-08-19UHC-97229-55•••-••-2452——6826 LINCOLN WAYJacksonvilleFL32241GRP-9612core-hmo
CLMCLM-4158562026-06-09T08:53:34Ztyler··—snyder8/19/1964-N/Anull—6743 Lake View RdEden PrairieMN55316-1924—NAVIGATE-HMO
CLMCLM-4125052026-09-18T16:54:30ZDONNA—RIVERA1975-08-12UHC-91295-74N/AnullNULL8277 Camelback RdTEMPEAZ··85237GRP-5780SELECT-EPO
ENRENR-106114 2026-01-12T22:54:53ZlindaL.gomez··Apr 14, 1994uhc-48209-83•••-••-2046526-950-4569UNKNOWN8638 RIVER RDJacksonvilleFL32251GRP-6378OPTIONS-PPO
TPATPA-643472026-07-23T19:32:48ZLewis, Robert——1938-06-12UNKNOWN•••-••-3026UNKNOWNrobert.lewis@proton.me1524 OAK STSacramentoCA95858—NULL
CLMCLM-4239492026-05-09T13:22:39ZRaymond—Woods··12-04-1996null•••-••-6821+1 253 489 7061null2178 WASHINGTON STREETMinneapolisMN55497GRP-4998CHOICE-PLUS-PPO
CLMCLM-4077232026-09-24T23:51:47ZRaymond—Banks2004-07-09UHC-53680-51•••-••-47798823434683—2102 Central AveDenverCO——NAVIGATE-HMO
100,000 rows, page 183 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.714Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty