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-1069642026-07-20T10:58:49ZJackson, DanielleQ—·Oct 11, 1954UHC-84944-11•••-••-9249+1 265 293 8377danielle.jackson14@yahoo.com3506 Spring Street···DENVERCO80238GRP-9953CHOICE-PLUS-PPO
CLMCLM-4037002026-07-06T02:51:21Zvictoria—bennett1956-05-07UHC-20682-65-··—N/A9161 Maple AvenueTEMPEAZ85265—MEDICARE-ADV-B
ENR ENR-1014852026-02-22T11:11:00ZMARIA—BERRY20-06-1946UHC-38529-44•••-••-1540272.234.4177maria.berry3@proton.me6589 Camelback RoadAtlantaGeorgia30314··GRP-8702···OPTIONS-PPO
ENRENR-1025162026-06-20T02:53:32ZSarhDGrant1/4/1999UHC-93690-53•••-••-8700(354) 323-3551sarah.grant@aol.com4672 CANYON RDMinneapolisMN55413GRP-7053select-epo
CLMCLM-4212192026-02-03T08:59:34ZAustin—Franklin1944-05-04UHC-70952-25-+1 492 895 5754UNKNOWN8689 Bayshore DrTempeAZ85212GRP-6010NULL
CLM CLM-4298002026-02-01T02:49:40ZGRACE—GARZA··2002-11-10UHC-70601-88—UNKNOWNN/A7828 Maple AveChandlerAZ··85281··UNKNOWNNULL··
CLMCLM-4100152026-01-10T05:55:45Z Noah—Estrada·Apr 15, 2005N/A•••-••-67707749860165—6764 HILLCREST RDScottsdaleAZ85266-6001·UNKNOWNN/A
ENRENR-1217062026-09-28T02:35:58ZGraceV·Fisher1971-03-01UHC-44389-91•••-••-75053313736736N/A5229 Church StAustinTX78719GRP-2346CHOICE-PLUS-PPO
CLMCLM-4204262026-10-13T03:41:47ZArjun—Lawrence05/05/84·UHC-29118-42—(514) 718-1288NULL6371 Sage CtSAN ANTONIOtx78294NULL-
CLMCLM-4286492026-09-10T09:35:59ZMAON—ARNOLD1955-06-19—•••-••-8402-··5848 Sage CourtFresnoCA93716N/A—
PRVPRV-213332026-03-09T14:51:18ZSOPHIA—HOWELL1997-04-28null····(492) 467-4792N/A··2377 Apache BlvdSan DiegoCalifornia··92144··N/AN/A
PRVPRV-273942026-06-17T02:00:44ZTheresa—Taylor4/11/1982UHC-55739-27null15392222883—2310 MESA DRIVELos AngelesCA90081NULLnull
CLMCLM-4161042026-03-04T23:42:56Z Edward—Arnold··22-12-1957UHC-58764-26•••-••-2126515-418-2111N/AUNKNOWN-—null····MEDICARE-ADV-B
TPATPA-59680 2026-01-31T05:42:18Zjulie—flores2005-12-02—•••-••-0921·785.752.9815julie.flores69@yahoo.com354 LAKE VIEW RDOrlandoFL32818—NULL
PRVPRV-239662026-03-29T09:39:16ZLisa—Rivera09-10-1938UHC-02876-16•••-••-44266105169168lisa.rivera@hotmail.com··4615 Apache BoulevardMesaAZ85216UNKNOWN-
ENRENR-1128882026-01-04T07:12:01ZJustin—Gibson··2005-01-06UHC-79224-70•••-••-3969—justin.gibson@hotmail.com8984 MAPLE AVENUEColumbusOhio—GRP-1804options-ppo
ENRENR-1198912026-02-27T17:39:25ZMartha—Ortega1980-06-16UHC-68860-37•••-••-3015673.966.3647martha.ortega19@outlook.com9115 Lake View RoadColumbusOhio43222GRP-1133OPTIONS-PPO··
TPATPA-633642026-03-20T13:32:11ZDiana—Ryan1955-01-07null—753-898-5601diana.ryan68@gmail.com8473 Meadow LnGilbertAZ85209NULL—
ENRENR-1224292026-04-29T11:29:39Zjordan—hill2001-11-11UHC-10282-21•••-••-8779(268) 716-1978jordan.hill6@hotmail.com6475 Washington Street··OrlandoFL32877GRP-8271MEDICARE-ADV-B
PRVPRV-270462026-03-10T09:36:37ZBETTY—ROSE1945-03-03—•••-••-7919(600) 356-2475-8135 CENTRAL AVEColumbusOH43210—null
CLMCLM-4045782026-02-09T13:52:50ZAMBER—WHITE1962-10-21UHC-86611-68•••-••-030818209117647UNKNOWN-nullnullnullNULLSELECT-EPO
PRVPRV-292212026-01-08T18:01:12ZJENNIFER—SCHMIDT2003-07-05UHC-29055-65—606.475.0635JENNIFER.SCHMIDT@GMAIL.COM3969 Camelback RoadLOS ANGELESca90096—null
ENRENR-1125262026-02-12T09:57:45ZNicole—Torres1957-03-02UHC-00087-21—UNKNOWN—6740 Pine DrSeattleWA98157GRP-2775NAVIGATE-HMO
ENRENR-1072732026-10-17T05:21:32ZCherlyN.··Munoz··5/5/1946uhc-39247-46•••-••-92328498714888UNKNOWN5559 SAGE CT··MesaAZ85276GRP-0308··CORE-HMO
ENRENR-1255092026-03-31T14:37:54ZBARBARA··CCHAVEZ1984-04-28··UHC-52218-29•••-••-6903(913) 771-2861barbara.chavez25@aol.com6126 Indian School RoadSAN ANTONIOTexas78257GRP-5560CORE-HMO
ENR ENR-1298582026-08-14T01:08:07ZHannah··Q.Morales1981-04-13UHC8434556•••-••-3405-·hannah.morales26@gmail.com1616 MARKET STREETDenverCO-GRP-3010SELECT-EPO
CLMCLM-4028212026-06-17T19:31:34ZAlan—Brown2004-01-08UHC-69982-03•••-••-8397null——UNKNOWN-UNKNOWNNULLOPTIONS-PPO
TPATPA-509482026-07-12T22:49:05ZstephenE·mason1949-01-20UHC-11372-10UNKNOWN—N/A5037 OCEAN AVEColumbus·OH43224GRP-8993—
ENRENR-1359122026-06-14T21:38:12ZKAREN—LNE24-03-1961UHC-82536-31•••-••-3619—NULL2769 River RdNashvilletn37228GRP-9413CHOICE-PLUS-PPO
CLMCLM-4108422026-01-09T22:34:43ZRios, Ann——2030-07-20uhc-55469-74—9004213373—6732 Valley View Dr #284Eden PrairieMinnesota··55331··null—
ENRENR-1148042026-02-28T22:28:33Zgabriel—gray2001-08-25UHC-14318-72•••-••-4186(338) 815-3032··gabriel.gray63@proton.me8384 Lincoln WayGilbertAZ—GRP-8067OPTIONS-PPO
TPATPA-642112026-08-24T10:13:19ZJoe—HerreraNov 14, 1993UHC-92339-35NULL—null9242 Willow CtFresnocanull—-
PRVPRV-249972026-04-21T15:08:27Zelijah—myers12/09/1989null··-··5506243373elijah.myers@icloud.com3062 HIGHLAND AVEDallasTX·75233UNKNOWNCHOICE-PLUS-PPO
ENRENR-1084222026-03-09T20:21:20ZRandy—ParkerAug 23, 1965···UHC8536222•••-••-9552(488) 307-1610RANDY.PARKER@PROTON.ME129 Meadow Ln #701·ChandlerAZ85208-5306GRP-2493MEDICARE-ADV-B
ENRENR-1297802026-01-29T13:29:33ZTHERESATMALDONADO1399-05-08UHC-45767-75N/A+1 806 531 9468THERESA.MALDONADO10@PROTON.ME6139 Elm StreetDallasTX75293GRP-9167NAVIGATE-HMO
ENRENR-1321782026-06-06T12:12:01ZChristianO.Dixon1981-08-13UHC-02015-72•••-••-402312074119575null2166 Ocean AveTampaFL33635GRP-4931·SELECT-EPO
ENRENR-1007652026-05-02T02:44:31ZROGERI.BELLNov 2, 1986·UHC-49797-35•••-••-1403957.875.3466roger.bell4@hotmail.com··7058 Meadow LaneMiami·FL33133GRP-8391MEDICARE-ADV-B··
ENR ENR-1150592026-10-11T04:48:54ZBENDSTONE1987-12-28UHC-41687-73•••-••-60383274549377—7644 Grand AvenueTEMPEAZ85220GRP-6641CHOICE-PLUS-PPO
ENRENR-1193402026-06-26T01:45:08ZANNM.SCHMIDT1977-05-05UHC-80695-60•••-••-7001+1 387 876 0394ANN.SCHMIDT@PROTON.ME9812 Palm DriveSacramentoCA95888GRP-8548NAVIGATE-HMO
ENRENR-1257502026-06-22T21:11:40ZMarianaXKelllyAug 25, 1981UHC-11420-45N/A16816069230··mariana.kelly@proton.me5286 INDIAN SCHOOL RD Apt 40·MiamiFL33119GRP-7670MEDICARE-ADV-A
CLMCLM-4074502026-01-03T13:48:04ZAnnV.Sullivan1992-08-26UHC-58187-57•••-••-4115NULL—5172 JEFFERSON AVEHoustonTX77003··GRP-7101SELECT-EPO
ENRENR-1191482026-09-24T13:43:38Z ·DIANASMENDEZ1998-04-20UHC-96329-81•••-••-6271(351) 819-7282diana.mendez89@hotmail.com9376 Pine DriveJACKSONVILLEFL32260·GRP-0448MEDICARE-ADV-A
ENRENR-1314712026-08-07T05:40:16Z MarcusDThomas28-04-1959UHC-45703-19•••-••-392017384551260·MARCUS.THOMAS@PROTON.ME3707 Ocean AveHoustonTX77043··GRP-1260NAVIGATE-HMO
ENR ENR-1009412026-01-10T06:19:34ZCollins, MarcusX—1946-03-20UHC-00187-28•••-••-8907377.252.4734marcus.collins@icloud.com3486 Harbor BlvdFresnoCA93786GRP-9413OPTIONS-PPO
PRVPRV-202882026-05-27T22:02:45Z GLORIAH.DUNN1982-05-22N/A—(596) 712-5464gloria.dunn@hotmail.com938 Elm StreetAtlantaGA30329—·MEDICARE-ADV-A
ENRENR-1117842026-07-27T11:43:55ZHerrera, JimX—2007-10-15·UHC-91233-31NULL(550) 659-3172·james.herrera@icloud.com3206 Washington StreetLas Vegas·NV·UNKNOWNGRP-7790CHOICE-PLUS-PPO
ENRENR-1362782026-02-09T21:59:57Zmariana—chen1992-11-11UHC-99463-67•••-••-5662(965) 234-5337mariana.chen@icloud.com··5602 Ridge Road Apt 20San DiegoCA92173GRP-2682OPTIONS-PPO
CLMCLM-4168542026-08-15T16:11:31ZJEFFREY—MENDOZA1965-08-12—null637-471-5196—3159 Canyon RoadDallasTX75221GRP-1549CORE-HMO
CLMCLM-4126722026-01-04T19:21:24ZPAMLA—WASHINGTONFeb 15, 1955UHC-44348-23-————nullUNKNOWNGRP-3332NAVIGATE-HMO
PRVPRV-207272026-02-07T13:36:15ZCAMILA—WOODSJan 23, 1994UHC-11477-78UNKNOWN5385908180N/A1429 Lincoln WayJacksonvilleFL32284——
100,000 rows, page 9 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-19T19:54:25.415Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty