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-1350042026-07-01T12:18:46Z·Tyler—Wang1941-12-14UHC-25081-14•••-••-14752755196299tyler.wang38@yahoo.com·2982 Central AveTEMPEAZ85277GRP-0634CHOICE-PLUS-PPO
CLMCLM-4186052026-02-28T23:49:37ZCynthia—Gray1986-06-08UHC-12777-98N/A4514132650····7290 Washington StreetJacksonvilleFLN/AGRP-8709NAVIGATE-HMO
TPATPA-510772026-01-14T03:59:54Zalexis····duncan1974-05-28NULL•••-••-4871(895) 271-0364UNKNOWN7653 Park PlaceScottsdaleAZ85284—MEDICARE-ADV-B
CLMCLM-4124302026-09-03T10:01:02ZWILLIE—HANSEN1941-12-16·UHC4183657•••-••-5653·(338) 623-9076nullnull———N/ANAVIGATE-HMO
TPATPA-576552026-06-10T07:29:07ZJudyZ·Pierce1991-02-15N/A····+1 710 641 0167—2875 Maple AveSan AntonioTX78239-8088GRP-1592options-ppo
ENRENR-1212112026-05-13T10:55:43Z DouglasD·Fox12/20/1960UHC-38814-45•••-••-30454575106923douglas.fox87@icloud.com8330 FOREST AVEColumbusOH43226··GRP-4871OPTIONS-PPO
CLMCLM-4137822026-04-14T13:13:13ZLogan—Wang03/04/2001··UHC-72381-10····—N/AUNKNOWN········NULL··UNKNOWNMEDICARE-ADV-B
CLMCLM-431995 2026-04-01T03:12:35ZKyle—Bishop05-01-1940UHC-06507-66•••-••-9151——····N/AN/A—GRP-0579NULL
ENRENR-1268752026-09-03T06:47:42ZPaulZWangJan 27, 2006UHC-64029-57•••-••-9732(377) 388-4594·PAUL.WANG@OUTLOOK.COM315 Forest AveCharlotteNC28273·GRP-0135MEDICARE-ADV-A
TPATPA-524032026-05-10T20:00:03ZVIRGGINIA—CASTRO1960-04-21UHC-40943-28•••-••-7152—NULL·7068 Sunset BlvdMIAMIFL33146N/A·NULL
ENRENR-1062542026-09-26T13:24:33ZRussellM.ColemanDec 9, 1944UHC-61125-89•••-••-0886·9716680·russell.coleman@gmail.com805 Apache BlvdColumbus·OH43274GRP-2622CHOICE-PLUS-PPO
PRVPRV-289362026-09-14T11:55:22ZARNOLDUKETHLEEN2/3/1967··UHC-42875-96•••-••-552518216902371null··5324 Willow CourtMinneapolis·MN55496—UNKNOWN
ENRENR-1091332026-10-14T20:35:19ZRANXDIAZ1947-08-10UHC9189226•••-••-3699814-374-5111—6942 Union StNashvilleTN··37207GRP-3413CORE-HMO
CLMCLM-4201972026-03-31T20:50:58ZMaria—PettersonDec 26, 1961UHC-50763-19——MARIA.PETERSON55@GMAIL.COM·UNKNOWNNULLUNKNOWN—GRP-7211SELECT-EPO
ENRENR-1087522026-07-29T21:56:00ZLoriOLewis1949-03-09·UHC-65986-60•••-••-0163946-656-5587N/A·6077 Highland AvenueATLANTAGANULLGRP-9659choice-plus-ppo
CLMCLM-4011262026-06-21T20:15:30ZJORDANB.WELLCH2001-11-13UHC-43144-83····-—2704 Maple AvenueDenverCO80226-7399—CORE-HMO
TPA TPA-601732026-03-29T14:19:37ZWILLIE—WASHINGTON1952-03-19-•••-••-53196058602454UNKNOWN893 Sunset BoulevardSeattleWA98147GRP-2533OPTIONS-PPO
CLMCLM-4183532026-01-18T13:17:09ZBobby—Wright1995-04-03UHC-74847-84NULL484-655-6424UNKNOWN8097 Central AvenueEden PrairieMN55323-—
ENRENR-1095762026-05-10T06:39:23ZAnnOJordan1948-60-04UHC-47140-18•••-••-6977269-377-7572N/A8195 Indian School RdDallas·TX75283GRP-1788SELECT-EPO
CLMCLM-4319942026-09-09T08:40:49ZSarahJLong1993-01-20UHC-42321-42··—315.314.3425—6140 Camelback Road #151HoustonTX77063—null
CLMCLM-4074282026-04-22T19:58:03ZKENNETH—CHAVEZ1988-06-19null•••-••-40672329062057—8598 ELM STHoustonTX·77079GRP-3277—
TPA TPA-606602026-01-10T07:34:48ZAlexis—Washington2/18/1988UNKNOWNnull—UNKNOWN4319 Camelback Road Apt 29TampaFL33696NULLN/A
CLMCLM-4148212026-01-18T17:12:18ZSalazar, Jack····—1994-00-71UHC-24125-50N/A-nullnull——····nullN/A
CLMCLM-4042972026-08-09T15:07:31Z———3/12/1965—•••-••-67136817966665olivia.carroll15@hotmail.com9269 Grand AvenueHOUSTONTexas77086··GRP-6193—
PRVPRV-204762026-02-12T18:24:10ZJULIE—WASHINGTON1939-10-25UHC-19375-27—466.201.5517-4718 Union StreetScottsdaleaz85298-3115-NULL
TPATPA-561072026-07-08T05:28:23ZJohn—·Hill07/23/1979—null5987395817—1953 Church StreetOrlando·FL32807GRP-2933UNKNOWN
CLMCLM-4205642026-08-28T00:02:49ZVINCENT··GUTIEERREZ1950-01-08—•••-••-553618202806153N/A5152 Washington StreetOrlandoFL32829UNKNOWNNULL
TPATPA-556202026-02-28T19:40:18ZWells, Jack··P.—1996-07-24—•••-••-7024UNKNOWN··—3646 SUNSET BOULEVARDTempeAZ85249-UNKNOWN
CLMCLM-4144152026-06-28T06:27:58ZLAWRENCE—GARZA1959-12-26UHC-96175-05null8732472729—4747 Palm DriveMinneapolisMN·55423nullNULL
ENRENR-1208962026-07-01T22:55:58ZScott·Q.Cox1940-09-18··UHC-67372-25•••-••-1212(769) 241-4322UNKNOWN1586 FOREST AVEDallasTX75206GRP-5132·CHOICE-PLUS-PPO
CLMCLM-4126142026-09-01T23:09:06ZDiane—Reed09/05/95UHC-16399-94null··574.254.4094-—·-—NULLGRP-3321NULL
ENR ENR-1159472026-07-10T05:33:13ZWALTER—ALVAREZ1944-09-01UHC-34582-19•••-••-0987679.338.3114N/A··1502 Apache BlvdDallasTX75221GRP-9868NAVIGATE-HMO
CLMCLM-4257792026-05-01T04:59:28ZMARK—LONGAug 26, 1976UHC-50062-61•••-••-2521(315) 542-0342mark.long@aol.com365 Camelback Road #468SEATTLE·Washington98171NULLOPTIONS-PPO
ENR ENR-1120832026-02-14T09:41:21Z·BrandonBWilis01/13/1940·UHC-61350-54•••-••-0411(489) 200-3616brandon.willis@hotmail.com2194 Spring StAustinTexas78794GRP-7624NAVIGATE-HMO
PRVPRV-290752026-05-03T17:43:29ZABIGAIL—MOORE3/11/1998N/A·-(510) 362-2691—59 Mountain View DrCharlotteNC28241UNKNOWNNULL
TPATPA-643222026-01-19T14:46:37Zvalentina—mejia16-08-1964N/A····(321) 752-4507NULL7607 Hillcrest RoadEden Prairie··MN55386GRP-1951—
TPATPA-58475 2026-06-21T23:42:56ZBenjaminQRobinson03/16/96-UNKNOWN+1 597 763 0116—625 Park PlTucsonAZ85770GRP-2332····
CLMCLM-4038542026-02-23T07:16:38ZTorres, Margaret··——1995-06-22UHC-34210-05•••-••-9787——1549 Ridge RdJACKSONVILLEFL32292-4726GRP-7073··MEDICARE-ADV-B
CLMCLM-4018792026-09-05T03:10:27ZPatricia—Wood06/24/57nullUNKNOWNnullN/A2526 Meadow LaneJacksonvilleFL32260-NULL
CLMCLM-4326822026-08-19T18:21:39Z·DOUGLAS—BERRY1969-10-11UHC-83888-39—N/AN/A————·GRP-4165MEDICARE-ADV-A
CLMCLM-4151772026-01-13T09:39:29ZPETER—ALEXANDER2/21/1956—•••-••-2104+1 665 459 1094N/A··4354 Spring StreetScottsdale··AZ85259GRP-0242MEDICARE-ADV-B··
ENRENR-1222592026-01-15T15:22:42ZWILLIE··—HARPER··2000-09-13UHC-88343-77•••-••-2305434-850-5661WILLIE.HARPER@PROTON.ME750 Central AveGilbertaz85211GRP-4749medicare-adv-b
ENRENR-1342122026-07-11T09:47:58ZMAYRN.CHEN1952-10-21UHC-42080-36•••-••-482318608569938mary.chen@outlook.com1916 Spring StreetSeattleWA98199GRP-1609MEDICARE-ADV-A
ENRENR-1025682026-01-16T12:39:29Z·Charles—Alvarado1982-06-16UHC-02972-27—9086343767charles.alvarado98@yahoo.com2654 Cedar LnMinneapolisMinnesota··55448GRP-2208CORE-HMO
ENRENR-1172152026-08-16T20:02:43ZCarol—Fowler1995-04-09UHC-12538-47•••-••-98012275168933carol.fowler90@gmail.com7684 Lincoln WaySacramentoCA95821GRP-7734MEDICARE-ADV-A
CLMCLM-4268952026-01-03T17:49:49Zisabella—mendoza27-11-1953UHC-26500-93•••-••-1162·(671) 809-9197N/A·4776 Lake View RoadAustin··TX78715GRP-0283··N/A
TPATPA-508622026-01-20T06:03:15Z·Elizabeth—Hamilton12/01/1950———N/A4500 Maple AveSeattleWA··98196—MEDICARE-ADV-A
TPATPA-531882026-08-27T18:36:58Zrihard—santos1947-06-15··UNKNOWN·UNKNOWNnull—7248 MAIN STREETMesa··Arizona85217-8038·····null
ENRENR-1056822026-09-26T00:11:10ZBRENDA··OKELLEY1939-09-60UHC-29633-02•••-••-8946(237) 601-5830BRENDA.KELLEY61@AOL.COM9588 HILLCREST RD··GLENDALEAZ-GRP-8707SELECT-EPO
ENRENR-1011912026-05-02T20:38:40ZGary··—Valdez1976-01-06·UHC-70464-74•••-••-08393934751100null3151 Ocean AveMesaAZ85255GRP-2354CHOICE-PLUS-PPO
100,000 rows, page 53 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:34.780Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty