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-1190362026-02-26T17:45:06Z·LUCIAC.RUSSELL01/23/69UHC-13987-43•••-••-58732614470—8135 Jefferson AvenueFresnoCA93767GRP-1118SELECT-EPO
PRVPRV-237492026-08-23T07:14:31ZJENNIFEREWATTSON2000-45-07——890-714-0389jennifer.watson@aol.com·9725 Harbor BoulevardTucsonAZ85783—MEDICARE-ADV-A
CLMCLM-4232602026-05-12T03:06:32Zstephen—gonzalesMay 6, 1985UHC-33555-92NULL—NULL789 Highland AvenueTUCSONAZ85780—MEDICARE-ADV-A··
CLMCLM-4304012026-09-21T12:45:19ZRuth—Rice4/9/1957—UNKNOWNnull—8970 Elm StCOLUMBUSOhio43234N/AMEDICARE-ADV-A
ENRENR-1080322026-08-05T02:58:00ZLUISIPORTER2006-06-17UHC-75154-53null665-857-8571LUIS.PORTER@YAHOO.COM2013 Lake View Rd·JacksonvilleFL··32286GRP-5201SELECT-EPO
CLMCLM-4026222026-08-21T22:45:52ZLUIS—VEGA1938-07-28·-UNKNOWN898-425-9619NULL2560 OCEAN AVENUE··MinneapolisMinnesota55458··-NAVIGATE-HMO··
TPATPA-633272026-06-29T01:14:17ZBrian—Evnas1955-01-05-•••-••-3077(397) 422-0095—7147 Cedar LaneNashvilleTN—GRP-9425SELECT-EPO
ENRENR-1049082026-08-28T09:17:42Zraymond—vasquez10/5/1997UHC-16882-10•••-••-9268546-967-8576raymond.vasquez19@hotmail.com2095 CEDAR LANETampaFL33669GRP-6512CHOICE-PLUS-PPO
CLMCLM-4236232026-06-05T07:09:11ZAna—Arnold2000-05-21-UNKNOWN······UNKNOWN3439 Spring StFRESNOCA93754·GRP-8427OPTIONS-PPO
ENRENR-1391942026-09-27T16:10:28ZJeremyS.Stevens··1963-04-25UHC-14258-31··•••-••-87358314021809··—5943 Harbor Blvd Apt 18HoustonTX—GRP-1205CORE-HMO
CLMCLM-4194302026-03-30T12:39:21ZchristineWstevens19830613UHC-87437-98nullNULLchristine.stevens@icloud.com9540 BroadwaySan AntonioTX78215··GRP-2838MEDICARE-ADV-A
ENRENR-1316762026-06-23T22:34:16ZyukiCramos13-07-1959UHC-80469-73•••-••-0856(482) 719-1739—6994 OAK ST·HOUSTONTX77057GRP-3087NAVIGATE-HMO
CLMCLM-4223202026-02-10T05:23:08Z·Deborah··RobinsonUNKNOWNUHC8432714•••-••-2905+1 384 706 3063—UNKNOWNNULL·N/A——NULL
ENRENR-1168762026-02-13T11:23:19ZSamanthaQ··Medina1993-01-09uhc-02306-10•••-••-7314(921) 300-5051samantha.medina@yahoo.com6921 BASELINE RDSacramentoCANULLGRP-9189CHOICE-PLUS-PPO
TPATPA-610752026-08-12T10:31:06ZMarcus—Wallace1954-02-11UNKNOWN•••-••-7655—UNKNOWN5894 Bayshore DriveMIAMIFL33162-8793·GRP-5795NULL
ENR ENR-1139082026-09-03T08:45:01ZJanet—CarrollDec 9, 1979UHC-24627-62•••-••-821413865808267JANET.CARROLL@ICLOUD.COM2629 SAGE CTDenverCO80226-1591GRP-4040CHOICE-PLUS-PPO··
ENR ENR-1091962026-01-02T16:52:05ZDennisJBaker·1967-07-16UHC-24430-47•••-••-35786542482250DENNIS.BAKER@AOL.COM4332 Jefferson AvenueOrlandoFL32882GRP-1399CORE-HMO
CLMCLM-4264632026-01-12T19:52:33Zmartha—soto··21-07-1987·UHC-39559-98nullnull—1011 LINCOLN WAYGlendaleAZ··85337UNKNOWNOPTIONS-PPO
ENRENR-1219062026-03-13T21:35:07ZKAYLA—MURRAY19880907UHC-48642-30•••-••-02819564426103kayla.murray@proton.me6435 Palm DriveMESAAZ85295GRP-5142MEDICARE-ADV-A
ENRENR-1210042026-04-23T13:48:07ZjosephX.sandoval1955-12-11UHC-40500-84•••-••-5356(987) 629-3003joseph.sandoval98@icloud.com1355 Lincoln WayLos AngelesCA90050GRP-0674··MEDICARE-ADV-B
CLMCLM-4149492026-05-21T01:56:19ZRandy—Singh1989-05-12··UHC-68184-37•••-••-1705UNKNOWN-·9754 Central AvePhoenixAZ85000-3588——
TPATPA-641822026-03-15T15:53:40ZJERRY—DAY··1966-12-18—NULL(767) 767-4930··-—NULL—UNKNOWNGRP-9749N/A
CLMCLM-4263662026-08-21T00:44:13ZMaryZFord1986-07-04null-null—278 Broadway··GilbertAZ85251UNKNOWNNAVIGATE-HMO
TPATPA-578522026-01-08T11:19:17ZAaron—Jensen1969-05-08N/AN/A-UNKNOWN5197 BASELINE RDScottsdaleAZ85227GRP-8687-
CLMCLM-4007542026-10-08T20:17:46ZCamila—·Munoz1992-07-04—•••-••-9829—-9042 Canyon RdTampaFlorida33697GRP-6691·-
TPATPA-631802026-08-21T01:44:29ZAISHA—SALAZAR11/10/1953—null2307272N/A2129 Jefferson AvenueNashvilleTN37292—MEDICARE-ADV-A
TPATPA-604162026-08-01T18:58:16ZScott—Smith1976-11-03UHC-03157-35•••-••-12816786618333scott.smith96@hotmail.comN/AN/AUNKNOWN·-UNKNOWNOPTIONS-PPO
ENRENR-1180232026-04-06T18:12:25ZJen—Smith1152-20-00UHC-75273-23NULL——1879 Bayshore DriveJacksonvilleFL32298GRP-7374OPTIONS-PPO
TPATPA-621212026-04-09T10:26:19ZCampbell, Martha——1970-12-14null—4176077919N/A3970 Harbor BoulevardGilbertAZ85201GRP-7158UNKNOWN
ENRENR-1112682026-04-26T20:28:31ZAlice—Thomas1982-12-07UHC-39620-83•••-••-2415614.338.9310ALICE.THOMAS38@HOTMAIL.COM1048 Sunset BoulevardCharlotteNC28299GRP-8732NAVIGATE-HMO
PRVPRV-227902026-02-07T09:38:35ZRoy—Crawford1991-07-27——N/A—6673 OAK STSeattleWA98175·nullUNKNOWN
ENRENR-1375402026-06-06T02:46:40ZBaker, AdamZ.—1998-11-08UHC-26096-08•••-••-4283N/Aadam.baker@outlook.com1209 PARK PLEden PrairieMN55324GRP-7238NAVIGATE-HMO
CLMCLM-4206372026-01-10T01:56:50ZGRACCE—NUNEZ1978-02-13—•••-••-55953572996240UNKNOWN7396 Forest AveNashvilleTN37265UNKNOWNCHOICE-PLUS-PPO
ENRENR-1057592026-04-18T02:39:24ZJaet—Harris19580417UHC-34545-51•••-••-2733886.440.1179JANET.HARRIS@GMAIL.COM8158 Highland AvenueTucsonaz85726GRP-5685CHOICE-PLUS-PPO
PRVPRV-291052026-08-03T15:11:05ZKaren—Holmes1997-05-28N/A··•••-••-3046930-840-1468—7304 SAGE COURTSan Diegoca92157N/AUNKNOWN
CLMCLM-4021572026-08-22T04:16:24ZLuis—Sullivan1943-02-09NULL•••-••-5202(282) 634-0299UNKNOWN2265 Maple AveLos AngelesCalifornia·90010GRP-4098—
TPATPA-609412026-05-04T02:37:32Z Ethan—Wlch1941-06-23UHC6119641-——9226 Lake View Road #443MINNEAPOLISMN55409GRP-8880-
PRVPRV-256782026-06-13T22:16:23ZSAMUEL—SALAZAR·1980-09-13nullnullUNKNOWN··N/A8284 HARBOR BLVDSacramentoCA95851nullN/A
TPATPA-607022026-06-27T09:17:29ZDeborah—Vargas06/26/44NULL•••-••-3169·null—-N/A-—N/AMEDICARE-ADV-A
CLMCLM-4313102026-09-09T05:52:52ZDANAL.RAMOS1986-05-16UHC-53674-02•••-••-9748(428) 257-0259null3376 Sunset Boulevard·Los AngelesCA90058-6901GRP-5061CORE-HMO
PRVPRV-274392026-08-20T12:31:24ZJudith—Larson1990-08-18·N/A-15634462235—7789 Sunset BlvdSAN DIEGOCA-—UNKNOWN
CLMCLM-4217772026-02-05T00:14:57ZDennisYMorris··1990-23-10··UHC-83204-10•••-••-0785+1 509 342 9408N/A1592 CEDAR LANESeattleWA·98162NULLNAVIGATE-HMO
CLMCLM-4206962026-03-26T02:11:53ZSarah—Hill1954-06-20—null(753) 500-1484—9678 MARKET STCharlotteNC28281-0957GRP-5825NULL
ENRENR-1091512026-05-09T16:24:37Zgregory—campbell19431006UHC-08567-09•••-••-6571UNKNOWN—5886 Forest Ave··CHARLOTTENC28287GRP-5464SELECT-EPO
ENRENR-1230432026-08-26T05:25:31ZNicck—Garrett1950-08-02UHC-62777-97N/A7185612477—9125 Sage CourtMesaAZ85280GRP-3843CORE-HMO
CLM CLM-4059672026-05-17T05:26:07ZAdam—Riley11/05/1942null———8342 Church St··FresnoCA·93744——
ENRENR-1259992026-05-30T23:49:33Z·GERALD··MALDONADO04/17/46-•••-••-44299844676267gerald.maldonado81@aol.com·336 BroadwayCHANDLERAZ85223GRP-5947CHOICE-PLUS-PPO
TPATPA-626132026-04-19T01:05:54ZPerkins, HarooldO—2007-02-14—····816-228-8594—nullnullnullUNKNOWNNULL—
CLM CLM-4105682026-01-08T15:40:34Z MARILYNIPATTERSON05-01-1997UHC4347166null15688744256N/A9305 Meadow LaneORLANDOFL32888GRP-5805MEDICARE-ADV-A
CLMCLM-4259762026-08-08T06:47:15ZSmith, George—····2008-06-25UHC-87014-69—nullnull8472 CEDAR LANEFresnoCA·93783··CORE-HMO
100,000 rows, page 169 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.708Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty