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-110477 2026-05-18T09:00:26ZDeborah··EBlack1952-07-11UHC-14123-88•••-••-5466+1 272 784 4995DEBORAH.BLACK69@AOL.COM·6026 PALM DRIVE #297SacramentoCA95886GRP-3265NAVIGATE-HMO
ENRENR-109775 2026-09-08T13:14:12ZASHLEY····MITCHELL1899-08-02UHC-16625-75NULL··946-459-7814ashley.mitchell@outlook.com7255 Cedar LnPlanoTX75086GRP-9781CHOICE-PLUS-PPO
PRVPRV-262502026-09-13T06:39:44ZJessica—Guerrero1953-09-21UHC-43793-55··NULL4625519389—747 Canyon RoadGilbertAZ·85223—NAVIGATE-HMO
CLMCLM-423058 2026-04-14T14:29:05ZJanice—Rice2060-06-26NULL—-N/A7691 Forest AvenueGlendaleAZ85325GRP-7509—
ENRENR-1033752026-10-02T01:01:57ZShirley—Simpson1979-12-07UHC-69232-39•••-••-9736+1 499 291 7287UNKNOWN7059 CHURCH STREETScottsdaleAZ85205GRP-9110CORE-HMO
ENRENR-1084272026-05-16T03:29:00ZSamuelKFord19930817UHC-57373-99—398-697-6535samuel.ford19@hotmail.com5737 Apache BlvdMiamiFL33193GRP-3106MEDICARE-ADV-A
CLMCLM-4112312026-08-27T10:08:18ZCamila—Turner1990-05-10—•••-••-6958NULLUNKNOWN9865 MESA DRIVECharlotteNC28218GRP-5273NAVIGATE-HMO
TPATPA-615562026-06-12T11:25:51ZJOE····MILLS1948-12-08····•••-••-7739UNKNOWN-·8341 Market StSEATTLEWA98142N/A—
ENRENR-1380602026-09-09T09:39:43ZAARONDHOWELL08/15/1979··UHC-17844-07•••-••-1459-—347 HILLCREST RDTampaFL33611··GRP-2360MEDICARE-ADV-A
CLMCLM-4133492026-03-09T23:29:01ZFrances—Carpenter07/13/1989··UHC9435346·N/A2789370578N/A1399 MOUNTAIN VIEW DRPlanoTX75046—options-ppo
TPATPA-597262026-04-25T18:58:05Zaisha··mejia1962-08-28——·N/A-··3732 HILLCREST RDJacksonvilleFL32256GRP-3985—
ENRENR-1150732026-03-25T15:53:19ZRUSSELLIGREEN20080602UHC-65551-19•••-••-7246(674) 993-4991russell.green@yahoo.com9666 Mesa DrColumbusOH43217GRP-3175CHOICE-PLUS-PPO
CLMCLM-4114942026-05-16T21:38:43ZKayla—Carr05/19/1964NULL-UNKNOWN—37 Camelback RdPhoenix··AZ··85042-6833N/A—
ENRENR-1203682026-03-16T20:35:50ZJack—Castillo1954-10-23UHC-80141-96—16788955067·UNKNOWN466 Camelback Rd Apt 5MINNEAPOLISMN55400GRP-1966CHOICE-PLUS-PPO
ENRENR-1350222026-05-09T19:48:56ZJORDANBTAYLOR1974-02-22UHC7395394N/A235-932-9202·JORDAN.TAYLOR@AOL.COM7853 Market StAtlantaGA30316GRP-9825SELECT-EPO
PRVPRV-250972026-10-08T05:48:31ZashleyWsnyder1941-10-24UHC-84216-89NULL359-845-7145UNKNOWN3146 SAGE COURT #677NashvilleTN37209—CORE-HMO
TPATPA-551862026-05-21T07:33:47ZJessica—Valdez1954-05-06—•••-••-20788464708695·null4450 PARK PL··MesaAZ··85297··GRP-2392CORE-HMO
CLMCLM-4292672026-05-03T20:51:29ZTerry—Russell1940-06-04·UHC-49834-84UNKNOWN——8387 APACHE BLVD Apt 25CharlotteNC28204-0780UNKNOWNUNKNOWN
ENRENR-1357612026-07-26T22:12:39ZnathanTlynch1954-09-02UHC-03949-82•••-••-0216·(314) 216-8911nathan.lynch@outlook.com9410 Union St··ColumbusOhio43251GRP-1470CORE-HMO··
CLMCLM-4203452026-02-17T04:48:38Zdavid—yang1947-05-10UHC-30445-94--UNKNOWN··1680 Jefferson Ave··NashvilleTN37270GRP-4497··
PRVPRV-295652026-09-24T05:46:00ZMELISSA—PEREZ08/04/1938UHC-17175-25—939-537-7186·UNKNOWN631 Union StreetSacramentoCA95842—UNKNOWN
ENRENR-1330992026-08-15T01:30:43ZBenjaminWNguyen05-11-1972UHC-27270-74•••-••-9945nullBENJAMIN.NGUYEN39@YAHOO.COMN/Anull····—GRP-2846OPTIONS-PPO
ENRENR-1219052026-07-08T11:40:21ZISABELALXLUCAS1/6/2002UHC-37475-61•••-••-6864206-296-1022N/A2093 UNION STREETPlanoTX75084GRP-1985MEDICARE-ADV-A
ENRENR-1286172026-07-11T15:58:46ZDonaaldYFox15-03-1987UHC-97635-92··537-922-3080DONALD.FOX53@YAHOO.COM2962 Market StDallasTX75259GRP-1800··NAVIGATE-HMO
ENRENR-1305892026-02-09T15:04:38ZVICKYGCOOK··1987-07-25UHC-08669-16•••-••-18138377569564VICTORIA.COOK@ICLOUD.COM·2012 Ridge Road Apt 22San Antoniotx78240GRP-1322MEDICARE-ADV-B
CLM CLM-4153192026-03-27T18:58:51ZANDREA—BLACK19970828NULL•••-••-7621null—7581 Mesa DrDallasTX75287—CORE-HMO
ENRENR-1058092026-07-10T18:40:09ZBILLYO.DIAZ1946-11-23UHC-25565-73•••-••-0463——·6602 GRAND AVE·San AntonioTX78237GRP-0454CHOICE-PLUS-PPO
ENRENR-1250192026-08-21T14:08:06ZSOFIA··I.RIOS9192-06-06UHC-21043-75NULL8688752423sofia.rios@yahoo.com5680 Desert Sky BlvdDALLASTX-GRP-9972navigate-hmo
CLMCLM-4026372026-09-11T18:55:28ZJulia—Nguyen1941-11-07UHC-90442-51—nullUNKNOWN5856 RIVER RDPlanoTexas75085UNKNOWN—
ENRENR-1154792026-01-29T13:57:06ZChrisD.Hoffman19460504UHC-47909-72•••-••-6619+1 924 309 0019christopher.hoffman@proton.me6080 Baseline Road·HoustonTX77022-9829GRP-0219MEDICARE-ADV-A
ENRENR-1305622026-03-08T14:42:36Z Carol—Nunez11/08/1974UHC-30090-98•••-••-4814697.591.6085null3632 Hillcrest RoadPlanoTX75076GRP-0584MEDICARE-ADV-A
CLM CLM-4211122026-06-17T02:32:42ZWarren, Douglas——9144-09-25UHC-53814-57•••-••-19627724608··—9292 BroadwayOrlandoFL32808-4877GRP-3700—
TPATPA-585412026-02-07T10:42:28ZAmy—Snyder12/03/84—•••-••-4215·(763) 982-8245UNKNOWN9570 Sunset Boulevard #484··MiamiFL33143—CORE-HMO
CLMCLM-4094502026-08-13T10:00:57ZRachelQ·Walker06-02-1968UNKNOWNN/A——6585 Maple AveChandlerAZ··UNKNOWN—UNKNOWN
CLMCLM-4292972026-10-03T13:10:12Zroger—martin1998-05-15UHC-19292-65—UNKNOWNNULL··NULL—UNKNOWNnullUNKNOWN
CLMCLM-432794 2026-09-12T19:27:56ZStephen—Murray··1962-05-26UHC-92761-01•••-••-2349nullN/A4148 Main StSEATTLEWA—GRP-5620N/A
ENRENR-1206632026-09-28T05:51:19ZJULIAB.MITCHELL1965-11-04UHC-68852-95•••-••-9950·684-906-0488—2886 Valley View DriveDallasTX75209GRP-3945··SELECT-EPO
CLMCLM-4008962026-09-24T22:17:01ZLORIC.DIXON2309-19-93UHC-20645-16··—-—2347 SUNSET BOULEVARDPlano··TX—GRP-3238SELECT-EPO
TPATPA-538882026-06-21T14:53:27ZBruce—Perkins04/02/68—NULL3819597953null7248 Grand AvenueJacksonvillefl32257UNKNOWNmedicare-adv-a
PRVPRV-200432026-08-29T23:04:53ZDORIST.MENDOZA1986-11-26UHC-29920-87•••-••-4666(306) 997-7547null5813 WILLOW COURTCharlotteNC—N/ASELECT-EPO
CLMCLM-4178412026-02-26T17:35:32ZCHARLOTTEXPIERCE09/24/2005UHC-68485-08•••-••-3782581-669-4638CHARLOTTE.PIERCE6@PROTON.ME2069 Valley View Drive Apt 33Sacramento··CA95879——
ENRENR-1316542026-04-12T14:35:17ZPAMELARARNOLDFeb 13, 1958UHC-73899-09•••-••-5317(806) 446-3919pamela.arnold53@icloud.com1866 OAK STFresnoCA93763GRP-2838OPTIONS-PPO
CLMCLM-4325252026-03-13T12:11:17ZSANDRA—GUZMANAug 9, 1945uhc-12290-92-(518) 733-2117—3250 Indian School RdMiamiFL33177·GRP-6503NAVIGATE-HMO
ENRENR-1225012026-08-09T22:43:20ZOmar—Gardner1953-09-05UHC-50030-98•••-••-8558695-217-2052null2622 Sunset BlvdNashvilleTN37271GRP-9648CHOICE-PLUS-PPO
TPATPA-627652026-08-28T03:02:46ZJean—Johsnon1947-06-09—-7638731—6754 CANYON RD··Nashville·TN37277-0391NULL—
ENRENR-1097732026-01-11T19:39:02ZGARY—·BOYD1971-06-20·UHC-06620-65•••-••-692718183047588·GARY.BOYD53@AOL.COM5162 Jefferson Ave··MiamiFL33179GRP-8553OPTIONS-PPO
CLMCLM-4032382026-01-22T05:15:19Z Richard—Luna1986-01-18UHC-69234-20•••-••-7373—N/A2149 Mesa DriveJacksonvilleFL32267NULLnull
ENRENR-1430242026-05-19T20:07:25ZJUAN—·MORALES1995-06-09uhc-08643-27•••-••-5198868-833-4727juan.morales@icloud.com8572 Valley View DrGilbertArizona85253GRP-4425·SELECT-EPO
ENRENR-1359742026-08-20T15:24:35ZKathrynMHart10-01-1947uhc-34576-96•••-••-2997(463) 616-7714kathryn.hart90@outlook.com1306 Pine Dr Apt 24ATLANTAGA—GRP-3191SELECT-EPO
CLMCLM-4128712026-08-17T20:19:19ZNancyLTran5/4/1967UHC-46507-42•••-••-3832NULLnull·3686 UNION STPhoenixAZ85010UNKNOWNNULL
100,000 rows, page 119 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.685Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty