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-59951 2026-06-24T22:33:15ZKathleen—Hill1958-08-25—····NULL—3764 BroadwayLas VegasNV89186····MEDICARE-ADV-A
TPATPA-608792026-09-04T08:34:56Z DONNAJBLACK8/19/1968null-UNKNOWN··-7639 MAPLE AVENUECHANDLERAZ··85224GRP-5600—
TPATPA-603642026-01-02T21:50:02ZSARA—MARSHALL1124-18-95NULL•••-••-9632—N/A4451 Pine DrFresnoca93743——
TPATPA-579482026-09-01T05:27:43ZLisa—Lee1970-07-14-null·5949070880lisa.lee@yahoo.com589 Elm StNashvilleTN37227—CORE-HMO
TPATPA-585392026-09-03T01:08:02ZETHAN—DEAN··1958-02-12-—--8968 Elm StMesaAZ85269UNKNOWNoptions-ppo
TPATPA-551492026-03-16T03:03:42ZvalentinaLburke27-09-1940—NULL-—5368 Elm StGilbertaz-null—
TPATPA-572192026-07-04T05:09:16ZMorgan, VirginiaJ—09/03/1998-—N/AUNKNOWN337 Elm StMesaAZ··85252··—MEDICARE-ADV-A
TPA TPA-544432026-09-20T22:05:08ZIsabella··Le04/14/1954··-N/A9298176639isabella.le@gmail.com7791 DESERT SKY BOULEVARDORLANDOFL32846GRP-1951·NAVIGATE-HMO
TPATPA-633812026-02-09T22:11:55ZBowman, Hannah··—02/18/97··-•••-••-5329N/ANULL3657 Central AvenueCharlotte·NC28227NULL—
TPATPA-553942026-09-27T08:29:09ZKathleen—·Hill1999-03-18—null3858485UNKNOWN8010 OAK STREETFresnoCalifornia93746null—
TPATPA-516082026-07-06T12:05:46ZSAMANTHA—GUZMAN1969-12-26-·N/ANULL-5202 Market Street Apt 14Los AngelesCA90040GRP-6819N/A
TPATPA-635002026-04-11T15:56:08ZRUTH—SANCHEZ14-05-1996UHC-68224-02nullN/ANULL2653 ELM STColumbusOH43298-CORE-HMO
TPATPA-510082026-04-12T10:43:58ZTerryBKelley1963-01-07UNKNOWN—nullterry.kelley6@gmail.com8993 Camelback Road··Tempe·AZ85223—-
TPATPA-537532026-04-13T05:24:07ZStevenns, Linda——2006-10-05UHC-86754-83UNKNOWN9233154263null6800 Maple AveNashvilleTN37260——
TPATPA-635872026-02-27T15:28:58Z Price, RuthB—03/04/65--(730) 505-7393—1483 MAPLE AVEMinneapolisMN55498nullN/A
TPATPA-601372026-08-21T01:34:16Z Frank—Diaz1943-02-03—NULL-frank.diaz@outlook.com396 BroadwayColumbusOH43255nullmedicare-adv-a
TPATPA-53505 2026-08-01T15:56:25Z———1963-09-01UHC-98430-64NULL(774) 645-4505UNKNOWNUNKNOWNN/A····—-N/A
TPATPA-573162026-03-02T22:27:28ZRalphQRuz03-06-1954—NULL·N/Anull777 Lake View RdFRESNOCA·93760GRP-0833—
TPATPA-518402026-09-07T00:38:32Zryan—phillips1972-03-20NULL··——4535 Market StSeattleWA·98182—MEDICARE-ADV-A
TPATPA-622842026-01-20T23:59:14ZTony—Myers1798-05-08——UNKNOWN—4764 Sunset Blvd·Eden PrairieMN55334N/ANULL
TPATPA-599662026-01-16T18:17:19ZKathrynT.·Berry22-05-1945UHC-89770-54———6986 Washington StreetHoustonTX77052NULL—
TPATPA-610092026-06-19T22:03:32ZBARBARA—RUIZ1977-06-24NULL··-4747712—695 Willow CtTempeAZ85228NULLSELECT-EPO
TPATPA-609782026-02-05T14:07:20ZJoe—OBrien0066-19-67null—NULL—7817 Mesa DriveTempeAZ85201GRP-2136options-ppo
TPATPA-596382026-02-18T12:51:07ZNACY··HOWARD1994-02-07UNKNOWN····380.642.2553null1720 WILLOW COURTLas VegasNV89112—SELECT-EPO
TPATPA-543852026-06-30T16:59:06ZHarold···Russell06/04/81UNKNOWNNULL6116906·N/A9253 Palm DriveSACRAMENTOCA95870GRP-1884-
TPATPA-539352026-09-23T21:50:04Z·Brian—Arnold1997-01-20-•••-••-4120·686-427-5908—192 BroadwaySCOTTSDALEAZ85272nullMEDICARE-ADV-B
TPATPA-640392026-04-23T20:15:31Z vincent—fernandez···4/2/1943-•••-••-5758nullNULL6169 Elm StreetDenverCO80211null-
TPATPA-596682026-04-07T07:18:31ZOlivia—Reed0519-91-55N/A—NULLnull9635 Forest AvenueSan AntonioTX78276GRP-8917CORE-HMO
TPATPA-544282026-03-16T19:03:44Zsmantha—weber1989-05-20—•••-••-4301(671) 663-4990UNKNOWN·····-UNKNOWN—GRP-8221N/A
TPATPA-594552026-09-14T10:18:35ZWilliam—Clark1986-07-21null•••-••-6070——7594 CEDAR LANETampaFL33680nullN/A
TPATPA-607862026-03-28T04:46:42ZANAPBURNS2008-04-14—nullNULLNULL5119 Willow CourtDallasTX75272-6491GRP-3950N/A
TPATPA-571652026-05-29T16:08:40ZHiroshi—Sanchez6/15/1999N/A·N/AnullNULL5705 Union StSACRAMENTOca95809—OPTIONS-PPO
TPATPA-572332026-03-21T00:28:42ZBrian—Bell··Jan 6, 1963—UNKNOWN··UNKNOWN784 Camelback RoadSAN DIEGOCA··92192-1265GRP-1457MEDICARE-ADV-B
TPATPA-537102026-02-09T04:32:23ZchristineB.porter1989-09-25UHC-92458-92N/A·UNKNOWN-426 VALLEY VIEW DRAustinTX78752nullNAVIGATE-HMO
TPATPA-545342026-04-13T12:17:53ZAlice—Marshall1988-11-22UHC3439028null6698641806·N/A5036 Bayshore DrPlanoTX75009-7816N/AMEDICARE-ADV-B
TPATPA-554932026-05-04T11:42:17ZDorothy—Padilla2002-12-01N/A··N/AN/A-412 RIVER RDTUCSONAZ85751—NULL
TPATPA-504842026-04-01T05:35:44ZAnthony—Rose·9/22/1996····—-anthony.rose29@proton.me7414 DESERT SKY BLVDSCOTTSDALEAZ85229GRP-4369CHOICE-PLUS-PPO
TPATPA-555002026-07-13T23:10:26ZEdward··Garrett02/20/1941nullN/AUNKNOWN-··4079 HILLCREST RDOrlandoFL32833-NULL
TPATPA-502182026-02-22T11:15:54ZJACOB··—GOMEZ1951-07-05UHC-46357-44··•••-••-2927·503-413-3742jacob.gomez@icloud.com3679 Union StreetSacramentoCA95811N/AN/A
TPATPA-569232026-09-29T03:02:40ZMichelle—Schultz1970-05-14-•••-••-6608745.315.1463michelle.schultz@icloud.com4881 Lincoln WayScottsdaleAZ85245GRP-5103null
TPATPA-501692026-04-10T15:33:49ZMark—Stevens1987-08-18UHC-76775-97·-——3343 Apache BoulevardSacramentoCA95882-4026··—OPTIONS-PPO
TPATPA-575102026-08-23T15:54:53ZPATRICK—PATEL··1985-10-17UNKNOWNUNKNOWN—····2331 APACHE BLVD···HoustonTX77099GRP-9514N/A
TPATPA-501772026-09-12T07:08:23ZAmanda—Jensen1965-12-05—null7802224853null4743 Park PlColumbusOH43220GRP-1940N/A
TPATPA-596002026-04-08T03:37:34ZKellySHolmes1975-12-16UHC-09935-47-··nullNULL3850 Desert Sky Blvd··Las VegasNV89172GRP-4050CHOICE-PLUS-PPO
TPATPA-567942026-03-05T22:43:40ZGabrielN.Davis28-10-1980N/AN/AnullNULL7481 Church StreetTampa··FL33684····MEDICARE-ADV-A
TPATPA-620142026-01-02T18:14:43ZPAT—HOWELL1979-04-14·N/A——null7085 Pine DriveHoustonTX77099UNKNOWN—
TPATPA-526792026-09-21T07:58:20Zphiip—fisher1953-02-10—•••-••-1726NULLN/A2181 JEFFERSON AVENUESeattleWA98180NULL·UNKNOWN
TPATPA-502142026-05-26T04:23:20ZGARY—REYNOLDS··28-07-1964·N/A•••-••-6911N/A—N/A———N/AMEDICARE-ADV-A
TPATPA-500442026-06-02T17:57:40Z OmarRMcCoy1951-12-23—nullNULLUNKNOWN1770 Indian School RdSeattleWA98168GRP-8901··SELECT-EPO
TPATPA-620032026-01-02T02:32:08ZRONALD—BENNETT1988-11-01—UNKNOWN···N/A3179 CAMELBACK ROADFresnoCA93794-3278nullN/A
14,474 rows, page 72 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.352Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty