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

Third-party administrator only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
TPATPA-590912026-07-01T11:06:47ZJohnston, Kelly——1938-07-09null•••-••-7735—NULLnullUNKNOWNNULLUNKNOWN—-··
TPATPA-529802026-01-02T20:51:51ZBurke, Jacqueline——1994-12-08NULL-—jacqueline.burke75@proton.me904 Baseline Rd Apt 33TucsonAZ85702-6184N/AMEDICARE-ADV-B
TPATPA-602112026-03-24T00:46:21ZJEREMY··—HANSON1950-07-21--UNKNOWNN/A7782 Meadow LaneColumbusOH43278——
TPATPA-512362026-08-10T19:59:51ZJamesAPierce2/16/1954—N/A——1034 BroadwaySCOTTSDALEAZ85215—NAVIGATE-HMO
TPA TPA-640082026-09-14T16:03:03ZANNJESPINOZA1943-08-06··N/A—(480) 790-5379—nullN/AUNKNOWN——-
TPATPA-539542026-05-26T00:36:51Zdiane—phillips01/16/07——NULL-6808 WILLOW CT·FresnoCA·93747UNKNOWNNULL
TPATPA-605942026-04-22T13:10:03ZCARL—BENNETT11/07/1968—NULL·(217) 309-1566null··9430 Sage CourtSan Antoniotx78267-NULL··
TPATPA-527612026-07-12T03:10:48ZTimothy—Berry1976-03-12UHC-17139-84···N/A—null422 Meadow LaneMinneapolisMinnesota55414GRP-9771·CORE-HMO
TPATPA-606682026-02-14T19:39:33ZluciaL.baker04/25/08N/A-NULL-6471 Cedar LnDallasTexas75216GRP-6986NULL
TPATPA-626882026-03-19T16:34:16ZISABELLA—WAANG8/6/1990UNKNOWN·null-isabella.wang@icloud.com600 Church St #193MINNEAPOLISMN55433-7430GRP-6254··
TPATPA-532612026-02-14T20:46:46ZGloria—Fowler1964-09-07N/A··-——·6908 Sage CourtTucsonAZ85753-3952——
TPATPA-558032026-08-01T15:08:19ZChristian—Rogers1938-09-13NULL—19252559574christian.rogers63@aol.com5617 Mesa DrTampaFL33610nullUNKNOWN··
TPATPA-578042026-07-24T05:04:17ZFisher, Jennifer····—1960-11-02UHC-08664-81•••-••-9921····—4602 SPRING STDallas··tx75286-—
TPATPA-601592026-05-09T11:33:00ZAanda—Cole2005-10-28N/Anull—-593 CEDAR LNSeattleWA98142NULLnull
TPATPA-518332026-08-15T15:21:20ZDaniel—Matthews1943-11-06-NULL—-6458 Washington St Apt 22Miami·fl33190N/AUNKNOWN
TPATPA-557252026-05-08T08:40:58ZJUAN—GUERRERO·1963-05-04UHC-70320-01—N/A—7648 BroadwayAtlantaGA30300GRP-5227null··
TPATPA-508242026-01-31T00:23:21ZDennis G—Spencer11/06/2008—•••-••-3479UNKNOWNDENNIS.SPENCER72@GMAIL.COM2302 PALM DRIVEScottsdaleAZ85206··GRP-0791CORE-HMO
TPATPA-510432026-05-27T01:15:38ZBEVERLY—MILLER1938-01-27N/AUNKNOWN773-241-2702··-7645 CENTRAL AVESan DiegoCA··92180GRP-5515CHOICE-PLUS-PPO··
TPATPA-575682026-06-11T08:56:20ZHaroldC·Simmons07/21/1948UHC-09892-81—UNKNOWN—1157 Desert Sky BlvdGilbertAZ85227GRP-9120-
TPATPA-516292026-08-13T09:29:28ZArjun—Knight1956-03-05···UHC-04978-07•••-••-47029668557643arjun.knight@proton.me2859 Ridge RoadMinneapolisMN55498-6878—N/A
TPATPA-604552026-05-25T15:31:00ZGilbert, Luis——2002-05-27-··—UNKNOWNNULL2140 Lake View RdColumbusOH43250UNKNOWNN/A
TPATPA-617302026-01-23T13:11:05ZADAMT.··SINGH02/03/48NULL•••-••-0352UNKNOWNN/A·1814 BroadwayTucsonAZ85761GRP-3523null
TPATPA-562222026-07-25T13:33:28ZFATIMA—NUNEZ·1947-06-14UHC-68443-71UNKNOWN-—9002 Maple Avenue·GlendaleAZ85307··——
TPATPA-624352026-02-11T19:19:22ZChristopher—Reyes··1955-06-23-——NULL3907 River RdColumbusOH43214NULLNULL
TPATPA-609072026-02-08T14:25:05ZSanders, Joyce——19440123NULLUNKNOWN8209621459—9492 OCEAN AVENUESan AntonioTX78278——
TPATPA-593302026-02-07T03:58:28ZSteven—Price19390116null··•••-••-3034UNKNOWNsteven.price@aol.com2043 Grand AveHoustonTexas77062GRP-3400OPTIONS-PPO
TPATPA-503302026-08-01T12:43:50ZCarolyn—Sanders1990-12-05-UNKNOWN16767404860··8763 Camelback RdColumbusOH··43264UNKNOWNCHOICE-PLUS-PPO
TPATPA-634892026-08-10T23:02:25ZBEVERLY—·CRUZ1993-01-11null—N/AUNKNOWN5450 MOUNTAIN VIEW DRHoustonTX77089NULLUNKNOWN
TPATPA-514552026-07-20T23:22:51Z Barb··—Ramirez1957-12-20UHC-70365-52N/A-barbara.ramirez@gmail.com1878 Main StPlanoTX75069GRP-5228NULL
TPATPA-616772026-05-03T03:57:26ZJeremyOBoyd12/10/97—•••-••-2781—UNKNOWN9081 Lake View RoadMiamiFLNULLN/AMEDICARE-ADV-A
TPATPA-530982026-01-01T06:36:29ZReed, Kelly——21-06-1981N/AUNKNOWN··UNKNOWN640 WASHINGTON STREETPHOENIX·AZUNKNOWNnullMEDICARE-ADV-B
TPATPA-551412026-04-18T05:37:49ZADAM—ALVARADO1941-02-23··N/ANULL593-899-6010-———UNKNOWNUNKNOWNnull
TPATPA-554972026-02-11T21:50:48ZMateo—Turrner1939-03-07UHC-46506-14—·375.820.1513—8032 Mesa DriveSCOTTSDALEAZ85224—null
TPATPA-582502026-10-15T02:02:53ZChristian—Jamees10/8/1977——N/Achristian.james@aol.com9378 Oak StTempeAZ85242··—-
TPATPA-574872026-10-04T17:36:52ZCunningham, Judith——1999-05-20UHC-01302-60———2252 Mesa DriveMinneapolisMN55436nullMEDICARE-ADV-A
TPATPA-624492026-06-22T18:19:35ZMatthews, Kevin··—08/15/1965—N/ANULL—N/AN/A—UNKNOWNGRP-1871—
TPATPA-632582026-02-17T13:33:02ZBilly—Adams2006-06-17UHC-87978-84N/AN/A—N/A-——nullCORE-HMO
TPATPA-57872 2026-08-04T11:54:05ZWALTR—DOMINGUEZ1944-11-03-—nullWALTER.DOMINGUEZ@PROTON.ME7860 Palm Drive·AtlantaGA30304GRP-8567····
TPATPA-624222026-04-11T11:03:14ZJAMESVHUNT25-06-1968————9300 BroadwayEden Prairie··MN55394N/A—
TPATPA-589692026-06-28T14:08:24Z·AbigailF·Jordan26-10-1997··-•••-••-5497—N/A——NULL-GRP-2442MEDICARE-ADV-B
TPATPA-536412026-01-16T19:12:02ZDeborah—Alvarado-N/A———5707 Oak St··NASHVILLETN37245nullN/A
TPATPA-62836 2026-08-19T12:11:04ZKYLE—HOWELL12/25/1986N/A—null—274 HIGHLAND AVEMiamiFlorida33152N/AN/A
TPATPA-524552026-01-07T19:21:08ZAARONFCRUZ1996-11-03··—····6938838610aaron.cruz5@yahoo.com4625 Spring StreetLas VegasNV89151N/ACHOICE-PLUS-PPO
TPATPA-515202026-04-08T04:24:41ZMichael—Kelly1984-04-40—NULLnullUNKNOWN9662 WILLOW COURT··DallasTX75200null—
TPATPA-507462026-09-03T00:13:30ZJacob—Diaz1951-10-15-N/A262-935-7695—37 Camelback RdGlendaleAZ85327nullCORE-HMO
TPATPA-617132026-05-27T13:19:13ZAlbert—Gonzales1966-12-11UHC-71509-22—·nullnull——UNKNOWN—GRP-5774—
TPATPA-581072026-03-08T06:34:38ZPatel, Jerry——1894-07-01—•••-••-7272N/AJERRY.PATEL80@GMAIL.COM8468 Lake View RdMINNEAPOLISMN55427GRP-8182UNKNOWN
TPATPA-585622026-03-18T21:32:28ZPATRICK—ANDREWS2001-03-04N/AUNKNOWN·(643) 569-3627patrick.andrews60@yahoo.com4763 Church StreetPlanoTX75068··—
TPATPA-619102026-06-13T18:11:00ZJoan—Sanders11/07/2008N/A•••-••-793618307096442··3502 Forest AvenueChandlerAZ85239GRP-0873··-
TPATPA-514892026-03-28T14:13:59Zcarlos—hanson1971-09-03——434-488-1217-4864 Indian School RoadHoustonTX77037GRP-7273—
14,474 rows, page 82 of 290PreviousNext

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:40.621Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty