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-624332026-03-24T11:31:15ZJUDITH—ESPIINOZA1987-06-10-null16165697187N/A403 SPRING STREET Apt 22MesaArizona··85249—NAVIGATE-HMO
TPATPA-580282026-04-15T23:33:34Zrachel—maldonado16-09-1992——932-610-9587—7516 Meadow Lane··Scottsdale··AZ85254—null
TPATPA-501012026-03-27T13:09:57Z·Maria—Jenkins19770406UHC-71956-21N/A··925-202-9296NULL9603 Elm StCHANDLERAZN/A·GRP-2841CORE-HMO
TPATPA-557332026-08-14T11:52:04ZDylan—Hicks1950-10-04null•••-••-7729null—4675 WILLOW COURTTempeAZ85277N/A—
TPATPA-540222026-07-09T07:10:17ZSAM—SPENCER02/23/1959—nullUNKNOWNUNKNOWN1630 Lake View RoadDallasTX75202—MEDICARE-ADV-B
TPATPA-556972026-08-21T01:23:54ZSCOTTUJORDAN19650217——-—7935 Desert Sky Blvd Apt 5FresnoCA··93744NULL·-
TPATPA-521792026-03-23T13:23:34ZCHARLES—LANE1953-12-13UNKNOWNNULL832-724-4393-2643 Washington StreetSeattleWA····—NAVIGATE-HMO
TPA TPA-531182026-02-06T13:32:36ZALICE—SENCER··1967-03-01nullNULL——-N/ANULLN/AGRP-1509MEDICARE-ADV-B
TPATPA-625522026-06-02T06:44:06ZJoyce····Murray04/01/1984——(466) 327-3964N/A3758 Jefferson AveTempeAZ85206-null··
TPATPA-571772026-01-10T01:54:07ZWilliamSCarpenter1954-02-11nullnullN/AN/A2934 APACHE BLVDDenverCON/AN/A·NULL
TPATPA-573362026-05-27T18:33:20ZVALENTINAYJOHNSON1952-12-16—-—-9880 Canyon Rd···San DiegoCA92191GRP-9114—
TPATPA-616062026-02-20T19:01:50ZCAMILA····CHEN1977-01-12uhc-66437-32null··416-684-0302·camila.chen38@aol.com130 Harbor Boulevard Apt 23GlendaleAZ85327GRP-4766—
TPATPA-563522026-05-18T06:34:27ZDouglas—Mendez··12/11/47UHC-96845-13N/A—N/A··5921 Washington StMiamiFlorida33188-3109GRP-9992NULL
TPATPA-551082026-06-11T06:17:12ZGabirel—Hunter19600228——6873444—7884 PINE DRIVESan DiegoCA92168N/ACORE-HMO
TPATPA-602322026-03-17T23:18:11Z·Michelle—Mendez12/20/1967nullNULL··—N/A1553 HILLCREST RDSacramentoCA95820GRP-8762NULL
TPATPA-568502026-05-27T09:42:22ZBradley··X.Vazquez·1989-07-07NULLUNKNOWNnullbradley.vazquez@proton.me1527 Cedar Ln Apt 37PlanoTexas75044—····
TPATPA-522052026-01-17T00:18:28ZGABRIEL—SANDOVAL·1948-01-09UNKNOWNUNKNOWN697-693-4152—464 SUNSET BOULEVARD #832PlanoTX75063—null
TPATPA-595472026-06-12T14:04:27ZMASON··—MURRAY1956-08-08———mason.murray@aol.com4142 Meadow LnTucsonAZ85783··—NULL
TPATPA-522072026-06-13T08:48:15ZMartin, Anna——19660502UHC-56138-06•••-••-6430nullanna.martin40@proton.me766 PARK PLACECHANDLERAZ85261GRP-5745CHOICE-PLUS-PPO
TPATPA-559422026-06-08T18:32:49ZWilliam—FowlerAug 11, 1940null•••-••-7045null····9182 Bayshore DriveSan DiegoCA··92186GRP-7211·UNKNOWN
TPATPA-592792026-01-11T03:11:56ZCAROL—LI·7/11/1982NULL—+1 211 693 3662UNKNOWN8392 Elm StreetJacksonvilleFL32262N/ACHOICE-PLUS-PPO
TPATPA-610822026-01-17T19:31:39ZDaniels, Carolyn··——12/25/46N/A—(786) 779-2967—5483 CEDAR LNAustinTX78716··N/ANAVIGATE-HMO··
TPATPA-582052026-05-16T23:39:55ZChuck··James1985-01-01UHC-80457-27—null-6831 DESERT SKY BLVDMiamiFL33107··GRP-0582—
TPATPA-552432026-08-02T17:04:17ZAlbert—Luna1957-11-14NULL•••-••-3206—N/A908 PINE DRIVEColumbusOH43206GRP-0973—
TPATPA-58035 2026-09-15T07:07:17ZPeter—Santiago1962-08-17—····UNKNOWNNULL8587 Valley View DriveEDEN PRAIRIEMN55337UNKNOWNNULL
TPATPA-539342026-08-29T09:40:29ZGomez, MariaO··—20-10-1954····NULL3334758475-6645 APACHE BOULEVARDAtlantaGA30380UNKNOWN—
TPATPA-575972026-02-05T00:44:10ZOmar—Adams1972-10-03N/A•••-••-0966—-··nullUNKNOWN—N/A-
TPATPA-567372026-01-02T03:09:11ZMargaret—Burke13-12-1993————2687 Canyon RdNashvilleTN37222——
TPATPA-504382026-05-02T00:03:57Zpatricia—le01/08/1963—NULL(743) 608-0593—9221 Sunset BoulevardAtlantaGA30367NULLOPTIONS-PPO
TPATPA-623882026-06-03T21:21:33Z·Jimmy—Reed1945-03-19··—•••-••-6251N/AN/A4459 WASHINGTON ST Apt 22·TEMPEArizona85220UNKNOWNSELECT-EPO
TPATPA-632902026-09-08T05:15:54ZAlexis—Weber1980-03-26null—NULLUNKNOWN5247 Market StreetCOLUMBUSOH43208GRP-9991MEDICARE-ADV-B
TPATPA-614842026-08-09T18:54:52ZMark—Padilla28-04-1968UNKNOWN—N/Amark.padilla95@proton.me7838 HARBOR BLVDFresnoCA93748UNKNOWNCORE-HMO
TPATPA-569332026-01-23T23:31:33ZJeremy····Duncan1969-05-17—UNKNOWNNULLN/A6026 Main StreetFRESNO·CA93731-SELECT-EPO
TPATPA-638432026-01-02T09:47:35Zjohn—holmes19831010—•••-••-508313549491986UNKNOWN1760 FOREST AVEDALLASTX75231-1292GRP-8874MEDICARE-ADV-A
TPATPA-604962026-01-18T15:13:47ZHEATHER—FULLER09/04/38-null-UNKNOWN5849 MESA DRMinneapolisMN55478GRP-1643UNKNOWN··
TPATPA-581342026-03-17T06:44:12ZHunter—·Carolyn1944-06-06—N/A3716845-2682 Willow CtJacksonvilleFlorida32284——
TPA TPA-519492026-05-18T02:52:22ZCynthia—Rojas1979-06-02—-UNKNOWN—5677 Mesa DriveCharlottenc28264NULLnull··
TPA TPA-610672026-02-20T02:47:17ZSARAH—JACOBS1957-10-18NULL————nullUNKNOWNUNKNOWNN/A··NAVIGATE-HMO
TPATPA-556002026-05-28T00:45:52ZZACHARY—GONZALEZ03/17/94—•••-••-35379378045143—6204 Hillcrest RoadLas VegasNVnullNULL···MEDICARE-ADV-B
TPATPA-596222026-08-04T10:53:43ZTyler··—Morris1966-01-12—N/A2513403tyler.morris@aol.com133 Washington StreetAtlantaGA30300——
TPATPA-561162026-05-30T23:33:21Zjonathan—evans·1938-10-24——8563434896—null-N/A—GRP-0696CHOICE-PLUS-PPO
TPATPA-522982026-08-12T11:38:22ZKeith····Hernandez1998-11-21——4353518061··UNKNOWN1394 Apache Boulevard #931ScottsdaleAZ85239GRP-1319—
TPATPA-518802026-07-22T07:56:22ZGARALD—ROBERTSON2008-01-73N/A•••-••-2732617-513-8326-4482 Grand Ave #370·San AntonioTX78251··CORE-HMO
TPATPA-567802026-01-20T11:31:09ZJose—Reyes1942-06-27UHC-54323-16•••-••-81137698933572···jose.reyes@outlook.com·5287 Valley View DriveCharlotteNC28250-7925null—
TPATPA-502732026-04-29T01:35:29ZLawwrence, Jacqueline——2007-06-11-•••-••-3590(524) 800-2302null8326 Desert Sky BoulevardEden PrairieMN··55300UNKNOWNMEDICARE-ADV-A
TPATPA-603572026-08-26T20:44:44ZDIANE—PATEL19481001··N/AUNKNOWN-null8529 Mountain View DriveAustinTX78779——
TPATPA-556122026-03-04T13:14:56ZSusanX.Cunningham05/03/1972····UNKNOWNN/Asusan.cunningham5@aol.com1351 Baseline RdGilbert·AZ85266····UNKNOWN
TPATPA-640102026-10-08T00:35:43Z CHARLOTTE—JACOBS1947-07-01—•••-••-6130——2840 Cedar LaneScottsdale·AZ85266GRP-6701—
TPATPA-527832026-02-28T20:18:22ZWalsh, Don W····—1951-05-07N/A•••-••-07398584013690donald.walsh9@aol.com7131 Spring StDenverCO80243GRP-3953—
TPATPA-572002026-01-18T08:07:40ZSantiago—Edwards·2001-03-24N/A•••-••-2423·3697242779UNKNOWN··1283 Main StreetDallasTX75248·····SELECT-EPO
14,474 rows, page 19 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:36.689Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty