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
TPATPA-624342026-05-26T19:27:42ZLOGAN—YOUNG1946-04-22—null(288) 359-6938—602 Mesa DriveSan AntonioTX·78222·nullmedicare-adv-a
TPATPA-546162026-07-13T21:21:40ZPerkins, Bradley——2003-08-26UNKNOWN—(405) 590-1924·bradley.perkins@outlook.com616 Lincoln WaySacramentoCA95898GRP-2294null
ENRENR-1223512026-03-23T18:01:53ZDIANER.MALDONADO07/17/1965UHC-17511-15•••-••-15796149673335DIANE.MALDONADO@YAHOO.COM3768 Cedar LnGilbertAZ—GRP-2700NAVIGATE-HMO
ENRENR-1415262026-04-05T00:01:29ZFerguson, SharonI—1959-06-22UHC-64402-07null(835) 688-6134·NULL4479 OCEAN AVECOLUMBUSOH43204·GRP-2882navigate-hmo
ENRENR-1151622026-04-11T08:16:49ZJose—Barnes7/16/1979··UHC-53140-13•••-••-48364606618jose.barnes30@proton.me7290 Cedar LaneAustinTexas78722GRP-6060OPTIONS-PPO
TPATPA-604122026-02-18T09:14:27Zhelen—woods1975-06-19UNKNOWNUNKNOWN832-957-6026—·9455 CANYON RDAtlantaGA30336··——
TPATPA-585632026-10-18T21:10:36ZKatherine····Jordan1993-09-24nullNULL(851) 234-1751N/A3416 Hillcrest RdMiamiFL33162GRP-0749—
CLMCLM-4178862026-05-04T07:58:05Z MEI—GEORGE19431207UHC-37000-03•••-••-5354(611) 331-9020-6041 Lincoln WayMiamiFL33159GRP-2076CORE-HMO
CLMCLM-4049442026-10-10T07:19:46ZRussell—MoralesFeb 22, 1969UHC-05073-10null+1 254 322 8009—4402 Desert Sky BoulevardTucsonaz85744GRP-2270UNKNOWN
TPATPA-551852026-07-19T07:28:20ZStephanie—Flores1990-11-05—NULL937-605-8985-—N/AUNKNOWN—GRP-2647—
CLMCLM-4143962026-02-07T03:51:42Zsantiago—miller··1969-04-28null•••-••-51133279644892-3679 Meadow LaneMesaaz85216GRP-3924—
ENRENR-1056302026-08-12T03:08:23ZBENJAMINDRICHARDSON17-04-1958NULL•••-••-7061(560) 644-6879—6480 Indian School RoadDALLASTX75277-6724··GRP-1567MEDICARE-ADV-B
ENRENR-1201592026-08-26T04:56:50ZJack—Jordan1948-03-11UHC-62945-41-+1 736 852 1414jack.jordan14@icloud.com622 Mountain View Drive #656GilbertAZ85264GRP-6837CHOICE-PLUS-PPO
ENRENR-1072442026-04-06T02:25:48ZAHMEDBBILEYMay 10, 1978UHC-12383-43•••-••-38092294154N/A5091 BroadwayAtlantaGA—GRP-4770·CORE-HMO
CLMCLM-4042722026-05-07T12:30:06ZGary—Welch1940-12-20UHC-29174-76•••-••-5313—UNKNOWN1042 Church StreetTampaFL33621-3727-NULL
PRVPRV-253642026-02-10T20:07:38ZEric—HayesnullUNKNOWNUNKNOWN—-4894 Spring Street #773JacksonvilleFL32264-—
ENRENR-1356802026-01-21T23:01:43ZAshleyMBowmanJul 27, 1954UHC-55178-78UNKNOWN(427) 780-1336ashley.bowman50@icloud.com5161 MEADOW LANESan Antonio··TX78219GRP-6238NAVIGATE-HMO
ENRENR-1116042026-09-23T01:11:00ZAnnaO.Bell04/12/1938UHC-14422-58null·919.213.7331—957 Baseline RoadDallasTX75259-0399GRP-1882CHOICE-PLUS-PPO
PRVPRV-287962026-08-27T02:09:41ZGaryP.Chapman1980-12-12—UNKNOWN6247951058null8674 Lake View RoadSan DiegoCA92145——
CLMCLM-431140 2026-05-27T21:19:39Z·Franklin, Roger———NULL•••-••-3618—-—UNKNOWN-null··NAVIGATE-HMO
CLMCLM-4201552026-06-04T13:18:49ZTheresa—Tucker1972-03-03UHC-63388-86•••-••-0148—UNKNOWN884 Maple AvenueSAN DIEGOCA92197UNKNOWNMEDICARE-ADV-B
CLMCLM-409456 2026-09-02T22:19:52ZMARK—KELLEY08/22/88UHC-28980-76•••-••-8372N/AN/A2938 Spring StMiamiFL33105··GRP-4030CHOICE-PLUS-PPO
ENRENR-1028872026-09-24T19:27:16ZMARGARETXREED1963-05-01UHC-06116-42•••-••-86462727099084MARGARET.REED70@GMAIL.COM8171 Ocean AveLas VegasNV89167GRP-1998select-epo
ENR ENR-1386992026-01-23T01:00:37ZLittle, Cheryl——1992-09-28UHC-89021-43•••-••-7305(521) 609-3799CHERYL.LITTLE32@HOTMAIL.COM4835 Hillcrest Rd Apt 33Eden PrairieMN55390GRP-7057NAVIGATE-HMO
ENR ENR-1033362026-07-22T20:07:06Zlarry··—vaquez2003-04-24UHC-17161-28•••-••-8194+1 450 964 6317—5326 Lincoln WayJacksonvilleFL32248··GRP-4457CHOICE-PLUS-PPO
ENRENR-1346932026-10-15T12:02:10ZHenry—Rios07/25/1989UHC-91003-95•••-••-9179611-930-7857henry.rios23@aol.com··2185 Palm Drive Apt 24SAN ANTONIOTX—GRP-2533CORE-HMO
ENRENR-1256932026-02-15T14:20:36ZAndrew··LFreeman1985-08-02UHC-76276-79•••-••-35784145201517··—8606 CHURCH STDenverCO80221GRP-0888SELECT-EPO
PRVPRV-239802026-08-05T05:38:43ZSnyder, Adam——1964-09-27UHC-25891-48—·5934629771·-9660 Market Street Apt 28·DenverCO—null·-
ENRENR-1191282026-09-05T07:08:37ZNicoleAMyers··0122-19-97UHC-92949-48•••-••-118617088366593NICOLE.MYERS@YAHOO.COM1400 Union StEDEN PRAIRIEMN55355GRP-7334OPTIONS-PPO
ENRENR-1429352026-02-09T17:32:16ZDonaldGKennedyAug 24, 1959uhc-80692-79•••-••-3560609-552-9694DONALD.KENNEDY@HOTMAIL.COM7544 CANYON ROADJacksonville·FL32293GRP-7003SELECT-EPO
ENRENR-1302682026-05-16T11:24:33Z·JeffreyP.Delgado1978-01-06··—•••-••-511119054808362jeffrey.delgado28@gmail.com1110 Washington StreetDenverCONULLGRP-0178OPTIONS-PPO
CLMCLM-4110252026-09-05T03:00:24ZAndrews, Sara——11/2/1961UHC-45537-10—6398433N/ANULL—N/AN/AnullN/A
ENRENR-1221392026-05-05T08:01:14ZJEANZ··COLLINS1971-03-07UHC-75899-09··•••-••-7695(341) 552-8863jean.collins@hotmail.com4646 Main StTucsonArizona85755GRP-3550··NAVIGATE-HMO
CLMCLM-4040602026-01-10T07:28:16Z·LAUREN—WONG1955-10-13null-5612442592-7046 Lincoln WayEden Prairie·MN55329GRP-5710CORE-HMO
CLMCLM-4004752026-03-15T19:56:26ZrobertQwelch1985-02-09-UNKNOWN463-689-2094-NULLNULLUNKNOWNN/AGRP-0247null
PRVPRV-222442026-01-18T18:10:48ZALBBERT—MURRAY1998-02-28UNKNOWNnullUNKNOWNN/A—null—nullN/A—
CLMCLM-4324462026-03-07T18:24:44ZKEVIN E.—MILLER1950-07-07UHC-85557-90null6526712237—nullnull-NULLGRP-7595NAVIGATE-HMO
CLMCLM-4084422026-10-09T23:05:48ZLarryF·Willis1967-01-25——6269209877··-427 Maple AveSeattleWA98126nullMEDICARE-ADV-B
TPATPA-537262026-07-23T22:46:34ZDonald—Fields1981-05-24NULLnull3747885-··7784 BroadwayHOUSTONTX77076UNKNOWNUNKNOWN
CLMCLM-4233752026-02-07T04:46:10ZericFtaylor3/16/1965··UHC-85425-75•••-••-0644-NULLN/A—UNKNOWNNULL——
ENRENR-1404492026-07-22T03:54:44ZJASON··NMEJIA1973-01-28UHC-68953-11··•••-••-9499481-296-0187JASON.MEJIA99@YAHOO.COM4774 RIVER RDDALLAS·TX75261·GRP-9562CORE-HMO
CLMCLM-4204372026-06-20T16:24:30ZEllis, Ronald——2007-01-06—•••-••-4100UNKNOWNRONALD.ELLIS@GMAIL.COM1443 APACHE BLVDDENVERCO80260-3245GRP-7923N/A
ENRENR-1109682026-01-31T17:22:14ZJESSICAYHOFFMAN1993-06-01UHC-38803-96•••-••-47894853525434JESSICA.HOFFMAN@AOL.COM3037 Palm DrJACKSONVILLEFL32243GRP-8503MEDICARE-ADV-A
ENRENR-1271832026-01-31T21:34:36Zpatrick—murphy1956-03-05UHC-80947-87•••-••-79564739219594PATRICK.MURPHY10@PROTON.ME1182 DESERT SKY BOULEVARD···HoustonTX77009GRP-6755MEDICARE-ADV-A
TPATPA-567272026-01-23T16:28:46ZBRADLEY—JACKSON8/27/1949—•••-••-0324—bradley.jackson@gmail.com—UNKNOWNNULLNULLNULL—
ENRENR-1186852026-07-28T05:12:10ZJEFFREYIPAYNE··1985-09-28uhc-22064-20•••-••-7528N/A—1553 Palm DriveHoustonTX77090GRP-3989MEDICARE-ADV-A
CLMCLM-4261542026-09-12T13:29:29ZTyler··DWebb1969-11-25UHC-69644-36—582.724.3067··9487 RIVER RDMESAAZ85212GRP-3296CORE-HMO
ENRENR-1346082026-07-07T05:56:30ZWillieY.··Murray2008-06-04-•••-••-89298744417259··willie.murray@yahoo.com5493 Sage CourtSan AntonioTX78287GRP-1834CORE-HMO
TPATPA-595502026-04-22T04:18:05ZHELEN—SANTIAGO1959-06-06N/A•••-••-6496NULLUNKNOWN·9467 SPRING STREETHoustonTX77085—SELECT-EPO··
ENRENR-1301732026-06-01T07:03:22ZRALPH···WASHINGTON1977-07-06—•••-••-8321(450) 891-3008UNKNOWN3498 Meadow LanePlanoTX75077GRP-5453CORE-HMO
100,000 rows, page 79 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.795Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty