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-4172842026-04-12T16:16:14ZRamos, Aaaron——1994-06-24·UHC5108243·N/A····UNKNOWN1086 DESERT SKY BOULEVARDORLANDOfl32854··GRP-5097MEDICARE-ADV-B
PRVPRV-205202026-10-03T07:56:15ZMATEO··—WARREN1972-02-18—•••-••-46626628564848N/A9718 Elm Street Apt 32SacramentoCA95860——
TPATPA-588322026-04-24T12:39:28ZMARGARET····BAILEY26-01-1954———MARGARET.BAILEY@OUTLOOK.COM-nullNULLUNKNOWNUNKNOWN—
ENRENR-1147152026-09-26T17:20:04ZReynolds, Brian—··1959-05-10UHC-65257-02•••-••-3218327-534-6123brian.reynolds57@yahoo.com3126 Grand AvenueMIAMI·FL33132GRP-8057MEDICARE-ADV-B
CLMCLM-4302282026-03-10T05:03:39ZSOFIAWCOX12/01/1940UHC-15827-26•••-••-6750UNKNOWN—3326 Apache BlvdOrlandofl32877GRP-4444······
ENRENR-1421212026-03-06T11:44:55ZDennisQFerguson09/28/54UHC-37454-80•••-••-3328——3009 Desert Sky BlvdEden PrairieMinnesota··55396GRP-7439MEDICARE-ADV-B··
CLMCLM-4259662026-03-21T03:23:15ZArjun—FernandezApr 22, 1950UHC-20619-13UNKNOWN9013075807··3885 Park PlaceMinneapolisMN55436-2080-N/A
TPATPA-508352026-05-22T13:00:37ZCHRISTOPHER—THOMPSON1978-06-23UHC-09795-33N/ANULLCHRISTOPHER.THOMPSON@PROTON.ME··3057 Bayshore DriveColumbusOH-GRP-5317MEDICARE-ADV-A
CLM CLM-4058832026-01-17T20:17:19ZAndrea—Washington1981-01-01UHC8472416—650-807-1942—912 Palm DrCharlotte·NC28285GRP-5022OPTIONS-PPO
ENRENR-1113752026-06-07T05:18:27ZTHERESA—MUNOZ-UHC-11208-80•••-••-5212+1 878 957 3749THERESA.MUNOZ38@HOTMAIL.COM5154 Harbor Boulevard·TampaFL33671GRP-4811SELECT-EPO
ENRENR-1416012026-08-21T20:40:30ZMADISON—LUCAS12/23/2007UHC-08732-03•••-••-1948685-677-0979madison.lucas16@gmail.com9850 BASELINE ROADAustinTX78796GRP-2230SELECT-EPO
ENRENR-1396832026-06-25T23:36:52ZKathleen—Gonzalez1969-08-15UHC-63009-45•••-••-7390-KATHLEEN.GONZALEZ@YAHOO.COM3746 ELM STLos AngelesCA90034GRP-2314SELECT-EPO
ENRENR-1299912026-08-17T14:20:35ZDonD.Marquez1997-02-09UHC-15493-92•••-••-3246982.697.2447NULL8380 DESERT SKY BOULEVARD Apt 30ORLANDO··Florida··32808-1910GRP-1023SELECT-EPO
CLMCLM-4074792026-07-26T12:10:42ZTYLER—FERNANDEZAug 14, 1978··UHC-64576-92—16672376826tyler.fernandez14@proton.me4638 Mountain View DriveLos AngelesCalifornia90025GRP-9160MEDICARE-ADV-A··
PRVPRV-269662026-07-22T14:28:52ZRandy—Soto07-12-1943UHC-23233-32UNKNOWN8336914874UNKNOWN8000 PINE DRIVEDallasTX75231-—
CLMCLM-4217332026-04-25T15:24:48ZMurray, Mason——1956-08-08UHC-24206-53——null·null——N/A—MEDICARE-ADV-B
ENRENR-1057372026-06-23T02:49:36ZStephen—Vargas1991-11-11UHC-56822-75null(484) 572-6934stephen.vargas@aol.com4580 Central AveScottsdaleAZ85280·GRP-7644CORE-HMO
CLMCLM-4213492026-02-15T18:32:50ZAishaPMorgan12/27/1988UHC-38996-14NULL18469496565—7101 Lincoln Way Apt 21Tempe·AZ85215GRP-3169····
ENRENR-1041802026-08-03T11:27:57ZScottV.Gardner1948-09-22UHC-69159-68•••-••-5755(445) 213-0985SCOTT.GARDNER@HOTMAIL.COM975 Cedar LaneAtlantaGA30380GRP-7270medicare-adv-b
ENR ENR-1032262026-01-23T11:39:32Z·Melissa—Fullre9/12/1986UHC-18904-06•••-••-9387UNKNOWNNULL9543 Cedar LaneHoustonTX77051GRP-0335MEDICARE-ADV-B
PRVPRV-270082026-04-18T11:43:50ZLisaMKennedy10-11-1957-—(651) 934-5047N/A5138 Harbor BoulevardMesaAZ85204N/ANULL
CLMCLM-4118092026-08-25T00:20:16ZGary—Hamilton1963-04-19--——148 RIDGE RDTempeAZ85288··nullUNKNOWN
TPA TPA-585052026-06-20T09:27:37ZSHARON—PERRY1953-02-19—•••-••-0936··—5356 Spring StDenverco80211··GRP-6474navigate-hmo
TPATPA-519182026-05-02T21:52:59Zbradly—marquez··02-05-2003N/A•••-••-00137013052868bradley.marquez89@hotmail.com7375 Lake View RoadChandlerAZ85254UNKNOWNNULL
TPATPA-553752026-05-10T15:11:24ZBoyd, Wayne——1960-05-01—•••-••-2458-———NULL—GRP-8488—
ENRENR-1284182026-06-05T11:11:08ZDIANE··—WASHINGTON9/26/1980UHC-61110-34•••-••-51036663162469DIANE.WASHINGTON77@YAHOO.COM··6865 Desert Sky BlvdMinneapolisMN55462GRP-4502··SELECT-EPO
CLMCLM-4316902026-10-17T15:19:10Zjacqueline—richards2004-09-10null•••-••-83252060718JACQUELINE.RICHARDS8@ICLOUD.COM2754 Main Street·DALLAS·TX75298··NULLN/A
PRVPRV-243872026-01-30T12:19:37ZPRIYAB.RICE1957-12-11UNKNOWNNULL208.433.0337··priya.rice71@icloud.com9320 BAYSHORE DR #865ChandlerAZ85250—null
ENRENR-1135002026-02-20T07:14:17Z·DebraEMejia20041027··UHC-43299-12•••-••-1439(467) 465-9001debra.mejia40@hotmail.com212 SAGE CTDALLASTX—GRP-4247SELECT-EPO
CLMCLM-4304662026-10-02T04:00:34ZJoyke—Sanders1972-01-18····—683-956-7999-566 Union Street #641Las VegasNV89177-1163··GRP-0932N/A
PRVPRV-221622026-07-31T03:52:39ZLISAJBRYANT2/6/1997——19268184628LISA.BRYANT@PROTON.ME5893 Meadow LnNASHVILLETennessee37224··—
ENR ENR-1186712026-05-27T07:49:39ZMichelleWRivera06/02/1989UHC-89576-64—+1 322 573 7826N/A6134 Hillcrest RdTampaFlorida·33667-7462GRP-0715CHOICE-PLUS-PPO
PRVPRV-213832026-09-10T00:28:00ZANGELA—KENNEDY··1998-08-40N/AN/A—NULL890 Forest AveDallasTX75239N/ACHOICE-PLUS-PPO
TPATPA-634692026-02-27T18:45:11Zevelyn—hudson07-06-1989NULL—UNKNOWN—1021 Grand AvenuePlanoTX75034UNKNOWN—
ENRENR-1032692026-10-09T14:39:08ZRussell—Walker1991-03-18UHC-74532-97•••-••-2366(437) 286-5571russell.walker@aol.com3949 Main StORLANDOFL·32835GRP-1845CHOICE-PLUS-PPO
CLMCLM-4281352026-06-29T04:58:32ZHowell, Barbara——1968-03-16·UHC-00518-51•••-••-2906·+1 389 943 8546UNKNOWN6495 Mountain View DriveLos AngelesCA90062GRP-1915—
ENRENR-142779 2026-06-03T18:12:28ZALAN—RIVERA2/27/1953UHC7730166-(701) 234-9690alan.rivera@proton.me838 Highland AvenueEden PrairieMN55311GRP-6109NAVIGATE-HMO
CLMCLM-4166382026-08-25T21:36:13ZCERLOS··FORD··1973-06-22—-NULLnull—N/A-N/A-OPTIONS-PPO
ENRENR-1321142026-07-24T15:25:08ZdennyVruiz1988-12-22UHC-75844-12•••-••-7030430.476.0934··dennis.ruiz@yahoo.com2378 Valley View DriveDallasTexas··75268GRP-7713MEDICARE-ADV-A
ENR ENR-1389592026-09-25T09:59:15ZGABRIELRHOWELL1943-02-05UHC-87332-44•••-••-6060(586) 667-6679—2866 HARBOR BLVDSeattleWA98157GRP-1260NAVIGATE-HMO
CLMCLM-4026162026-01-14T12:50:00ZPAUL—LOPEZ1947-02-01UHC-63875-61··•••-••-9011N/Anull5959 Sage CourtTampaFL33674GRP-4071N/A
CLMCLM-4281402026-01-21T16:54:23ZLogan—Young1946-04-22UHC-61819-10—(288) 359-6938-··602 Mesa DrSan AntonioTX·78222GRP-3269MEDICARE-ADV-A··
ENRENR-1030142026-05-22T02:25:59ZRalph—Woods·26-07-1967UHC-78850-61null-ralph.woods@yahoo.com6887 Spring StTAMPAFL33671GRP-9120MEDICARE-ADV-B
ENRENR-1348792026-08-25T19:49:47ZCHRISTIANU.DAVIS1991-01-06UHC-84270-65•••-••-799216013827625null684 Camelback RoadColumbusOhio43235GRP-1490options-ppo
TPATPA-538642026-01-22T23:01:27ZJOHN——·1998-09-14UNKNOWN—UNKNOWNN/A8543 PINE DRTAMPAFL33642-NULL··
ENRENR-1304282026-02-14T15:15:44ZSCOTTIHUGHES19970124UHC-27255-93•••-••-7701377-366-9542··scott.hughes@icloud.com2208 RIVER RDOrlandoFL32840GRP-6910CHOICE-PLUS-PPO
ENRENR-1086552026-08-25T02:41:57Z JosephRHoward1968-04-25UHC-87595-03•••-••-85932702253222joseph.howard33@gmail.com3549 Palm DrFresnoCA93771GRP-6236CHOICE-PLUS-PPO
ENRENR-1147462026-02-03T21:07:27ZAbigailGWashingtonFeb 27, 2000·UHC-06319-96•••-••-5922(814) 580-9904abigail.washington99@gmail.com7125 Lincoln Way Apt 15Fresno···CA93738GRP-7041MEDICARE-ADV-A
CLMCLM-4236372026-06-15T02:33:18Z·Virginia—Burton1994-09-10nullNULL2067410784virginia.burton16@outlook.com9443 MAPLE AVENUEMiamiFL33144GRP-6318OPTIONS-PPO
TPATPA-60860 2026-06-30T17:33:16ZLarry—Bure3/5/1966UNKNOWNN/A530-352-5883—1576 BROADWAYOrlandoFL32853NULL-
100,000 rows, page 84 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.798Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty