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-616132026-05-26T20:21:53ZDiane—Cox19470526UHC-99365-35NULLN/A·NULL4429 HARBOR BLVDPhoenixAZ85031GRP-6817null
TPATPA-511232026-08-18T16:44:39ZCAROLYNFFULLER1949-04-24—NULL——4866 CHURCH STSan DiegoCA·92120—null
TPATPA-569932026-04-16T15:52:48ZRyan—Carlson11-06-1942—-5463401984—4516 HARBOR BOULEVARDEden PrairieMN·55326GRP-2829null
TPATPA-561322026-07-17T14:32:50ZrogerHdean02/17/1940NULL•••-••-6948UNKNOWN—3984 CEDAR LNGLENDALEAZ85356GRP-3032MEDICARE-ADV-B
TPATPA-632022026-08-11T14:02:54ZBarbaraCCarrollJan 23, 1966NULLNULLUNKNOWN··7998 HARBOR BLVDSan DiegoCalifornia92116-5852GRP-8001OPTIONS-PPO
TPATPA-591272026-09-25T05:50:30ZAngela··—Cle5/24/1959—NULL—-8885 Lincoln WayLas VegasNV89158—-
TPATPA-618872026-02-11T11:58:28Zalexis—henry1961-09-27UNKNOWN•••-••-2417·NULLN/A··9695 Harbor BoulevardTucsonAZ85779—NAVIGATE-HMO
TPATPA-55532 2026-01-23T21:26:43Zryan—martin08-09-2008—····nullUNKNOWN678 PALM DRIVEMIAMIFL33187GRP-1224··null
TPATPA-626072026-06-17T05:10:40ZJohnston, Michael——08/25/94····——MICHAEL.JOHNSTON@YAHOO.COM9651 OCEAN AVECharlotteNC28251—MEDICARE-ADV-B
TPATPA-521682026-10-09T20:38:23ZGloria··Rojsa1972-06-07null——null·9153 Ocean AvenueSeattleWA98132GRP-7953null··
TPATPA-626552026-10-12T03:45:39ZDavis, Martha——1983-01-03—•••-••-4082723-732-5112·null1368 Harbor BlvdSan AntonioTX78271GRP-9133CORE-HMO
TPATPA-539932026-06-07T03:35:27ZDENISE—MORRIS1992-06-21·null•••-••-6996207-676-5350—5438 Mesa DrSacramentoCalifornia95818——
TPATPA-623752026-06-19T01:23:56ZHamilton, Kenneth——19851018nullUNKNOWN··UNKNOWNkenneth.hamilton@proton.me4095 Lake View RoadSacramento·CA95883N/ANULL
TPATPA-536192026-05-30T18:05:02ZJERRY—MYERS12/14/1953UNKNOWN····nullNULL7557 Union StreetNashvilleTN37227GRP-0786OPTIONS-PPO
TPATPA-506792026-06-10T12:11:21Z Christine—Jacobs1969-02-18UHC-30563-75N/A(525) 662-3509NULL6688 Hillcrest RdJACKSONVILLEfl32268GRP-4561MEDICARE-ADV-B
TPATPA-572282026-06-28T19:02:43Zrussell—arnold··02/25/2002-N/A—NULL2167 Sage CtScottsdaleArizona85233UNKNOWN-
TPATPA-569812026-07-13T16:38:13Znoah····castro1985-09-07—N/A—N/A5592 APACHE BOULEVARDTempeAZ85266N/A···CHOICE-PLUS-PPO
TPATPA-625182026-07-10T22:19:42ZMegan··Maldonado15-02-1998N/A·nullNULLUNKNOWN—N/A-UNKNOWNN/A-
TPATPA-611462026-06-03T14:32:57Z·Ethan····Sims05/08/1969—-613-938-0739null6288 Elm StreetPlanoTX——··
TPATPA-577672026-05-13T21:08:27Z·MATEO—WILLIS2002-03-22UNKNOWN•••-••-7444—N/A9421 MESA DRIVEAtlantaga30300—CORE-HMO
TPATPA-588452026-01-08T22:18:40ZEvns, Jacqueline——02/19/1967N/A•••-••-4690—UNKNOWN·9777 Elm StreetTUCSONArizona85706-MEDICARE-ADV-B
TPATPA-528112026-07-19T04:20:33ZGlorria—Elliott··1962-09-06N/A—null—9566 Hillcrest RoadHoustonTX77008UNKNOWN—
TPATPA-535192026-06-19T10:53:52ZBRIAN····SCHMIDT19581015UHC-76529-82—UNKNOWN—1569 Sunset BlvdTEMPEAZ85296N/AN/A
TPATPA-609442026-02-19T23:25:08ZLIZ—NUNEZ08/01/08——406-871-8195elizabeth.nunez59@aol.com5625 WASHINGTON STSacramentoCA95832··-null
TPATPA-516782026-08-12T01:53:34ZSoto, Scott——Apr 19, 1974UHC7207666··N/A··—scott.soto@aol.com9872 HILLCREST ROADPlanoTX75085--
TPATPA-59896 2026-07-19T15:37:44Zmargaret—·griffin1947-10-20·UHC-40806-56—-NULL3342 RIVER ROADSan DiegoCA92158-1920N/ANULL
TPATPA-505302026-05-12T12:12:48Z ·Danielle—Young06/21/1954··NULL··6733814339UNKNOWN3852 Market StScottsdaleAZ85229UNKNOWNNULL
TPATPA-52172 2026-03-29T04:26:57Zrandy—bell1971-03-18—•••-••-7106——6325 MEADOW LNSan DiegoCA92190GRP-3015CORE-HMO
TPATPA-514762026-05-26T11:07:05ZBRIAN—ALLEN1951-05-13null•••-••-496112622348559—9215 LINCOLN WAYAustinTX78736N/A-
TPATPA-641012026-06-08T15:31:43ZALBERT—HERRERA5/20/1941·null•••-••-80178202511168UNKNOWN5804 Lake View RoadPlanoTX75063GRP-1413—
TPA TPA-619162026-04-30T00:01:22ZFRANK—TAYLOR04/27/1954··—UNKNOWN(778) 496-3230N/A5678 Desert Sky Boulevard #327··JacksonvilleFL32211-··—
TPATPA-631612026-07-28T10:22:58ZAshley—Fowler1962-02-21··N/A-N/Aashley.fowler84@gmail.com827 Washington StreetFresnoCA93789-MEDICARE-ADV-A
TPATPA-533222026-05-26T05:14:08ZClark, Hannah——1981-05-15·UHC-95602-29—681-992-6218-2713 Jefferson AvenueFRESNOCA93737nullN/A
TPA TPA-637782026-03-07T14:34:51ZSTEPHEN—ROBERTSON26-04-1974·nullNULL6807791144-··4568 CANYON ROADFresnoCA93735-—
TPATPA-551552026-01-30T22:42:31ZCAROLYN—FISHER19510524—•••-••-2522(515) 331-0641—7001 BASELINE ROADEden PrairieMN55378GRP-5002OPTIONS-PPO
TPATPA-533922026-02-03T17:16:45ZCarlos—Hamilton·Jan 21, 1955UHC-99654-35··•••-••-7681N/A-7313 Desert Sky BlvdTampaFL33635NULLCORE-HMO
TPATPA-57768 2026-02-05T22:07:28ZFATIMA—DANIELS2007-06-08UNKNOWN•••-••-4428——500 Desert Sky BlvdPlanoTX75014··——
TPATPA-611052026-04-28T21:53:20ZBRANDON—RODRIGUEZ1958-02-15——····UNKNOWN2098 MOUNTAIN VIEW DRDallasTX75234-0509UNKNOWNMEDICARE-ADV-B
TPATPA-598712026-03-16T12:23:49ZALEXIS··—ROSS2001-04-24—•••-••-6669N/A—2335 BASELINE ROADAtlantaGA30386GRP-9434OPTIONS-PPO
TPATPA-581602026-10-12T23:53:00ZMason—Fowler28-01-1940—N/A(424) 793-4688mason.fowler@yahoo.com606 PALM DRGlendaleAZ85310GRP-1872MEDICARE-ADV-B
TPATPA-579642026-03-11T05:23:00ZTURNER—KAYLA1972-08-22N/A··nullN/Anull2610 Sunset BlvdMinneapolisMinnesotaNULL—N/A
TPATPA-536162026-01-13T21:27:51ZSandraB.Andersn2000-01-17N/A··•••-••-1853-N/A4692 Sunset BlvdSeattleWA·98176-8907-—
TPATPA-584712026-07-25T11:21:13ZKaren··PKim1993-01-13NULLnullUNKNOWNNULL8068 MOUNTAIN VIEW DRDallasTX—GRP-2189·SELECT-EPO
TPATPA-577282026-01-06T10:06:34Z·Willie—Castillo2001-08-10NULL—UNKNOWNUNKNOWN1942 Washington St·LAS VEGASNV89164NULL·N/A
TPATPA-527982026-03-20T12:22:32Z Lynch, Lucia——1968-04-09-UNKNOWN5604861546lucia.lynch81@icloud.com8941 Forest Avenue··ATLANTAGA30302nullNULL
TPATPA-562112026-09-27T20:09:56ZJoshua—Griffin1983-10-16··—null(749) 725-0019NULLnull—null—GRP-6412NULL··
TPATPA-611952026-03-06T23:53:21ZEvelyn—Medina1964-03-05N/A———9638 Baseline RoadOrlandoFL32814··GRP-1005NULL··
TPATPA-502032026-07-26T11:42:58ZJOHN—CONTRERAS1974-04-23·UHC-74466-79·UNKNOWN462-708-2531-5777 BAYSHORE DRDenverCO80279NULL—
TPATPA-549502026-04-18T01:26:14Zjerry—greene·01/26/68——349-929-3563N/A6098 SUNSET BOULEVARDTempeAZ85202-3649nullNAVIGATE-HMO··
TPATPA-600862026-01-01T22:24:23ZBradley—Bryant12/16/1990—····(203) 421-1154bradley.bryant@hotmail.com··3422 LAKE VIEW RD··AtlantaGeorgia30370·NULLN/A
14,474 rows, page 100 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:43.454Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty