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-4317702026-01-15T06:30:36ZjoseQrodriguez1/5/1970-•••-••-795215206882218UNKNOWN··6126 Camelback RdHoustonTX77074GRP-2553—
CLMCLM-4109742026-03-18T03:53:47ZAguilar, Nicholas——1977-02-10—NULL+1 538 467 1894null4295 PARK PLACEAustin·TX78773——
ENRENR-121160 2026-07-24T18:31:48Z·Arjun—Harris1953-10-27UHC-71965-17•••-••-74565147573995arjun.harris@outlook.com··777 Lake View RdEden PrairieMN··-GRP-9909OPTIONS-PPO
ENRENR-1011072026-06-13T23:16:25ZBURKE S····HANNAH2008-11-14UHC-00120-23•••-••-3639+1 261 934 1416—7092 Canyon RoadCHANDLER··Arizona··85257GRP-2277CORE-HMO
CLMCLM-4040042026-06-18T15:43:38ZRYAN—THOMPSON1943-03-11UHC-29740-76··•••-••-3365424.991.3671··2844 Camelback RoadGlendaleAZ85390GRP-5160—
CLMCLM-4286592026-03-29T10:55:26ZKevin—Roas1993-01-19UHC-91709-03NULL443-805-3665—7298 Oak StreetTampaFL33674GRP-2118OPTIONS-PPO··
ENRENR-1036712026-04-24T17:07:01ZRonald—Smith06-07-2003UHC-43052-53•••-••-6218+1 528 411 7287·UNKNOWN9385 Park PlaceAtlantaGeorgia30332GRP-2517CORE-HMO
TPA TPA-643292026-07-26T04:38:46ZCAROLYN—CRAWFORD·7/1/1964UNKNOWN•••-••-3320—null9783 MARKET STGlendaleAZ85377—-
CLMCLM-4262532026-01-30T15:15:14ZWliliamOPrice7/2/1983UHC-84694-30•••-••-7792·448-259-7450—1117 OAK STREETScottsdaleAZ85223GRP-9261N/A
ENRENR-1196472026-04-20T11:09:43Z Eric—Valdez1939-11-25UHC-86362-98•••-••-1488912-637-5845··eric.valdez75@proton.me9341 BROADWAY #258Eden Prairiemn55375GRP-3276NAVIGATE-HMO
ENRENR-1010052026-06-20T22:27:12ZrandyGfranklin04/08/57UHC-63777-51··•••-••-0239(427) 415-5600randy.franklin81@yahoo.com5375 Union StAustinTX78747··GRP-6818NAVIGATE-HMO
CLM CLM-4240152026-03-20T16:18:30ZEthan—Rose1999-07-01N/A··N/A—UNKNOWN3894 Grand AvenueCharlotte··NC28241NULLCORE-HMO
CLMCLM-4306842026-09-02T16:54:08ZSophia—·BlakDec 3, 1995—N/A(802) 207-1998-7519 Mountain View DriveHoustonTX77060··——
CLMCLM-4127132026-04-21T11:27:23ZBRYAN—HICKS04/25/53·UHC-57811-46UNKNOWNnullnull856 Valley View DriveLOS ANGELESCA90013-NULL
ENRENR-1081382026-02-15T03:59:49ZShirley—Sandoval12/19/58UHC-41979-76•••-••-483412473510207SHIRLEY.SANDOVAL61@GMAIL.COM2901 Jefferson AveEden PrairieMN55339GRP-0326CORE-HMO
ENRENR-1045642026-08-10T21:05:25ZBilly—Hughes1980-03-14UHC0906083•••-••-0178788-282-7080BILLY.HUGHES@PROTON.ME2722 Washington StNashvilleTN·37287GRP-3089···MEDICARE-ADV-B
TPATPA-518982026-01-31T15:28:48ZYuki—Carter09/25/1955UHC-07808-75N/A524-979-7747N/A4834 Central Avenue··San DiegoCA92122nullnull
TPATPA-603072026-03-05T20:10:18ZAaron—Dominguez1997-03-20NULL—6032881044AARON.DOMINGUEZ@GMAIL.COM3166 BASELINE ROADLAS VEGASNV89147-4973GRP-4402—
ENRENR-1286432026-03-02T05:20:34ZSAMUELU.RIVERA1944-10-26UHC-03534-32—540.484.2028samuel.rivera97@aol.com5200 Palm Drive #470TucsonAZ85749GRP-5115MEDICARE-ADV-A
ENRENR-1302112026-03-21T05:32:41ZSamuelXArnold1975-06-01UHC-13103-02····487-639-5822—7933 Mountain View DriveColumbusOH43243GRP-7530OPTIONS-PPO
TPATPA-597462026-04-07T17:02:49ZJanet—Knight1956-03-07nullNULL——····N/AN/A—GRP-3746CHOICE-PLUS-PPO
TPATPA-519142026-07-15T21:02:13ZGregory—Nichols1965-12-14—•••-••-67657366872442gregory.nichols@proton.me6469 CENTRAL AVEMINNEAPOLISMN55464-—
TPATPA-541572026-08-12T11:10:54ZValdez, Donald——24-07-1994—UNKNOWN784-926-0706UNKNOWN—-null—GRP-2119NULL
PRVPRV-206812026-07-24T09:28:08ZLawrence, Johnston——10/18/52—NULL(523) 804-1388lawrence.johnston@outlook.com5968 Park PlChandlerAZ85223·nullMEDICARE-ADV-B
ENRENR-1415452026-05-18T23:42:58ZbrandonSflores2001-04-20UHC-22774-26•••-••-8884298-879-5108brandon.flores58@gmail.com9616 Apache BoulevardMesaAZ85232GRP-8727CHOICE-PLUS-PPO
ENRENR-1030042026-05-16T08:05:06ZAlexanderW.Munoz01-07-1998UHC-78751-46•••-••-30354576389669alexander.munoz@hotmail.com626 Maple AvenueAustinTX78742GRP-9126·MEDICARE-ADV-A
CLMCLM-4076202026-04-22T04:31:32ZMATEO—RIVERA09-11-1958UHC-49017-44—813-808-2222··UNKNOWN3705 Spring StreetAtlanta·GA30307GRP-5887··—
ENRENR-1216802026-02-28T06:20:40ZAlvarado, RebeccaK—3/18/1950UHC-43885-93NULL—rebecca.alvarado@proton.me6838 RIVER RDLas VegasNV89112·GRP-5936NAVIGATE-HMO
ENRENR-1422342026-06-10T15:58:18ZGabriel—Estrada1993-02-15UHC-77015-81•••-••-2150788-659-0619GABRIEL.ESTRADA@ICLOUD.COM2383 Palm Drive··Eden PrairieMN55312GRP-8842MEDICARE-ADV-A
ENRENR-1413162026-08-26T04:16:55Zpamela—young9169-05-14UHC-52866-41•••-••-1848·(988) 323-7413pamela.young@yahoo.com3553 RIVER ROAD Apt 38·ColumbusOH43280GRP-5562CORE-HMO
ENRENR-1410032026-03-13T22:19:33ZRebeccaB.Cook·Dec 21, 1939UHC-29707-23—978.872.5489rebecca.cook94@icloud.com4694 MARKET STREETCHARLOTTENC28203GRP-6313MEDICARE-ADV-B
TPATPA-520732026-01-03T11:21:18Z Alvarez, Steven··—01/26/80--9823305099····6128 OAK STREETGILBERTAZ85277GRP-1650MEDICARE-ADV-A
ENRENR-1333662026-06-16T03:54:39ZJulie—Pea1975-02-28UHC-11736-49··•••-••-66694366378174julie.pena7@hotmail.com2236 Maple AveFresnoCalifornia93702GRP-1330CHOICE-PLUS-PPO
TPATPA-554012026-04-15T17:16:19ZJULIA—ESPINOZA19700604UHC-84983-20····N/A—6137 DESERT SKY BOULEVARDChandlerAZ—null—
CLMCLM-4053242026-07-11T04:25:56ZBOBBYIGONZALZ01-05-2007··UHC-49663-87N/AN/A—-—NULL-··GRP-1461MEDICARE-ADV-A
CLM CLM-4309682026-01-11T14:33:44ZJONATHAN—·SIMMONSMay 11, 1988UHC-03464-95NULL791-515-0208-8022 Jefferson AveLas Vegasnv89194-4694GRP-6793-··
CLMCLM-4205322026-07-15T07:22:42Zluis—patterson1974-11-01UHC-74727-19•••-••-1605(531) 484-1352UNKNOWNNULL-nullNULL—SELECT-EPO
ENRENR-1162492026-02-06T19:30:46ZMORALES—ANN1982-03-06UHC-02904-05•••-••-67509266127015ANN.MORALES55@AOL.COM3142 Park PlaceAustinTX78773GRP-8864·MEDICARE-ADV-B
CLMCLM-4013842026-10-03T05:44:16ZDIANA—STEPHENS08/17/1983·UHC-94285-82•••-••-5213NULLUNKNOWN6739 Elm StTempeAZ··85228GRP-0617CHOICE-PLUS-PPO
ENRENR-1427812026-08-09T22:30:01ZchristineQsims1992-06-03UHC-77833-63•••-••-9724808-872-4520christine.sims@aol.com5333 Bayshore DrLos AngelesCalifornia90025GRP-9522OPTIONS-PPO··
ENRENR-1346272026-02-26T01:39:43Zmark—holmes··1985-06-05UHC-10666-98··•••-••-05936576990025MARK.HOLMES@GMAIL.COM9633 River Road Apt 23HoustonTX·77089-0543GRP-1568MEDICARE-ADV-A
ENRENR-1125622026-07-05T14:57:16ZBeverlyHBailey04/20/86UHC-10812-76•••-••-9954+1 456 296 4355N/A5723 Spring StGilbertAZ85222GRP-4970NAVIGATE-HMO
CLMCLM-4287182026-08-11T12:03:49ZAlbert····Cruz1993-09-19UHC-86254-80-(266) 508-2073UNKNOWN1079 LAKE VIEW ROADGilbertAZ85238GRP-8289MEDICARE-ADV-A
PRVPRV-244452026-09-25T23:13:01ZJacob—·Banks1988-07-10UHC-77320-90UNKNOWN4548488407null5849 Cedar LaneMESAAZ-UNKNOWN··
PRVPRV-278242026-02-14T05:10:50ZCatherineU.MedinaSep 7, 1970UHC-50377-75··null·13318657151catherine.medina18@icloud.com4377 Park PlaceHoustonTX77001NULL··MEDICARE-ADV-A
ENRENR-1417482026-06-15T22:01:52Z·MariaDMoreno02/20/1993UHC-55990-89•••-••-6098587-826-9971MARIA.MORENO31@GMAIL.COM4668 Oak StAtlantaGA30397·GRP-2852SELECT-EPO
CLMCLM-4281842026-04-07T06:58:48ZDylanAGreene1964-02-10null———·8214 Mesa DriveGilbertAZ85269GRP-8537··—
CLMCLM-4100822026-08-24T13:55:13ZPriya—Aguilar2000-10-24UHC-54958-14•••-••-8865UNKNOWNNULL6298 Pine DriveSAN DIEGO··CA92143··GRP-6703-
ENRENR-1299762026-07-10T08:48:42ZDIEGONTUCKER1968-05-21UHC-64726-05•••-••-1388311-351-1105diego.tucker66@gmail.com6327 Elm StreetJACKSONVILLEFL32278GRP-0447CHOICE-PLUS-PPO
TPATPA-586832026-04-29T10:30:49ZScott—Burke2004-01-06UNKNOWN•••-••-6023—-1246 Oak St·OrlandoFL32872GRP-2092NULL
100,000 rows, page 239 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.741Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty