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-521372026-05-10T19:01:08Zsamantha—gonzalez1939-04-09N/A•••-••-3706—·N/A9765 Meadow LnSan AntonioTX·78275GRP-1012NULL
TPATPA-538032026-07-07T17:46:42ZAlan—Snyder1967-09-24UHC-29214-46null·6249391076N/A2024 Broadway·PhoenixAZ85024UNKNOWN—
TPATPA-526912026-06-04T11:27:31ZHanneh—Green12/16/81NULLN/A-—9332 Camelback RoadDallasTX75293-7218N/AUNKNOWN
TPATPA-553422026-07-16T04:51:25ZCarol—Olson1986-12-03UHC-52007-79•••-••-7846(534) 552-2204NULLNULLUNKNOWNNULL-GRP-1840—
TPATPA-58257 2026-01-02T20:56:53ZAISHA—SNYDER1967-03-11null··8303202486aisha.snyder59@proton.me··7756 Hillcrest RdAtlantaGA30333—CHOICE-PLUS-PPO
TPATPA-580032026-01-02T18:24:25ZShirley··Le2002-03-28——·+1 914 807 7555shirley.le@proton.me7260 Market StMesaAZ85220—N/A··
TPATPA-517892026-02-16T08:11:12ZPRIYA—OWENS·1988-02-28-null—PRIYA.OWENS@GMAIL.COM4814 SAGE COURTSan AntonioTX78278GRP-3939NULL
TPATPA-623572026-01-08T02:16:33ZDanielleW.Jones18-08-1991———null··9088 BASELINE ROADCHANDLERAZ85292GRP-2793OPTIONS-PPO
TPATPA-572682026-01-11T01:47:43ZBrenda—RobinsonNov 23, 1946UNKNOWNNULL(341) 444-4166····8740 Sunset BoulevardNashvilleTN37205GRP-5717OPTIONS-PPO
TPATPA-547582026-08-26T06:23:35ZCAROLYN··—WONG01/09/77····NULL··—null2259 Highland Ave··SacramentoCA95840-2979GRP-1486OPTIONS-PPO
TPATPA-607932026-03-16T00:47:50ZElijah—Jackson08/23/91UNKNOWNN/A680-887-9251····2903 Lake View Road #551Fresno·CA93786GRP-7583-
TPATPA-542452026-04-23T11:18:53ZSamuel—Carr1956-02-23null···-—1920 Ridge RoadDenverCO80245····—
TPATPA-591542026-09-15T20:28:18Z—··—6/8/1971null··—·NULLgloria.hawkins@icloud.com7465 Forest Ave··AustinTX78779GRP-3333··—
TPATPA-621072026-02-14T15:28:18Zgloria—werd09/02/68—N/A-null2598 Hillcrest RoadMiami··FL··33166·GRP-3434—
TPATPA-591002026-02-02T19:56:06ZGilbert, Yuki—··5/10/1979—N/ANULLUNKNOWN··4855 BroadwayAtlantaGA30389GRP-4285null··
TPATPA-615432026-09-11T12:21:22ZDaniels, Aelx——1957-08-17NULL·-—alexander.daniels@gmail.comnullnullUNKNOWN-GRP-2791—
TPATPA-540102026-01-02T12:33:55ZEMMA··—·ROBERTSON1974-03-04NULL•••-••-2869null-····—-UNKNOWN—SELECT-EPO
TPATPA-511652026-07-26T18:27:24Zjennifer—henry06/10/1968UHC-46109-60—NULLNULL4536 Camelback RdORLANDO··Florida32843NULLNULL
TPATPA-642502026-02-05T14:12:41ZAisha··Lawrence1987-04-07UNKNOWN··—(601) 669-3678—2297 ELM STSCOTTSDALE··AZ85236-1325UNKNOWN—
TPATPA-507862026-02-10T18:41:20Z·JAMES—THOMAS1994-11-16UHC-33106-13—2266784450JAMES.THOMAS@AOL.COM8806 DESERT SKY BOULEVARDAtlantaGA30324——
TPATPA-601942026-03-17T20:31:07ZSARAPWALLACE1970-10-27UHC-48359-67—····null298 Ridge RdMinneapolisMN55471—MEDICARE-ADV-A··
TPATPA-582922026-05-01T20:08:09ZETHAN—WEAVER05-06-1967N/A—null-··8731 Washington Street·MesaAZUNKNOWNGRP-6773·null
TPATPA-639332026-09-17T16:57:33ZFreeman, Mary——·1989-10-16NULLN/A—mary.freeman72@yahoo.com2156 HIGHLAND AVENUE Apt 8SacramentoCA95892—MEDICARE-ADV-A
TPA TPA-641652026-01-28T07:17:16ZBrittany—Garrett01/05/70UNKNOWN··UNKNOWNNULLnullnullN/A····-N/A—
TPATPA-58507 2026-09-12T00:54:08Z·Mariana—Munoz1971-04-24nullNULL267-230-4254—8127 Desert Sky BlvdLos AngelesCA90086nullOPTIONS-PPO
TPATPA-637992026-10-04T11:28:40ZSteve··Jones11/19/1946—-NULL—472 Ridge RoadChandlerAZ85219GRP-5034··UNKNOWN
TPATPA-542092026-08-24T08:08:00ZEUGENE—COLEMAN19860120UNKNOWN•••-••-8944UNKNOWN—9066 OCEAN AVEAUSTINTX78748GRP-9985N/A
TPATPA-581842026-04-14T20:38:53ZJean—Wang19650721N/A··+1 795 822 7871—2348 Elm StreetGLENDALEArizona85368-—
TPATPA-525962026-02-21T12:51:47ZYUKI—·HAMILTON09/01/1993····—586-668-2028—9778 BroadwayLas VegasNV89128——
TPATPA-564172026-08-04T07:59:30ZMarilyn··—Martin1996-11-28····NULL—marilyn.martin@yahoo.com2436 INDIAN SCHOOL RDEDEN PRAIRIEMinnesota55376—NULL
TPATPA-535132026-05-16T15:53:21ZSARA—SANDERS19701107·-null(813) 213-3545sara.sanders15@gmail.com·2403 Spring StreetDenverCO80296——
TPATPA-530912026-10-16T20:01:34ZAngela—Cook··1957-11-18UNKNOWN•••-••-12695509711—2908 HIGHLAND AVE #989PlanoTX75000-—
TPA TPA-63015 2026-01-21T22:31:01ZJACK··SMITH1974-06-11··—-8054337199UNKNOWN-—UNKNOWNUNKNOWNGRP-2568null
TPATPA-641452026-05-04T09:52:57Zkevin—hughes··1944-07-02····•••-••-6952206.403.7357UNKNOWN7328 Bayshore DriveGlendaleAZ85319—MEDICARE-ADV-B
TPATPA-601262026-05-16T01:30:14ZGardner, Melissa——1993-09-15····•••-••-4602nullnull8347 Lincoln WayTucson·Arizona85794····CORE-HMO
TPATPA-600592026-10-04T22:51:54ZJohn—Scott1971-12-24null-9572632320·john.scott76@outlook.com8198 Pine DrivePlanoTX75046-NULL
TPATPA-618902026-05-08T22:54:49ZFrankGGarcia1940-07-01—····UNKNOWNUNKNOWN··9059 Market StDenverCO80268-2082—CHOICE-PLUS-PPO
TPATPA-549022026-08-08T18:07:32ZMaldonado, Charles——1949-05-15UHC-76931-42•••-••-7453(385) 773-2832null·4005 GRAND AVENUEMinneapolismn55489GRP-0138SELECT-EPO
TPATPA-61600 2026-10-11T14:48:00ZRuth—DixonnullUNKNOWN——N/A···4358 PARK PLACEGLENDALE··AZ·85349-··
TPATPA-633392026-01-15T00:30:35ZNICHOLAS—CONTRERAS10/03/1994nullNULL——9465 Meadow LanePlanoTX75042GRP-7460SELECT-EPO
TPATPA-571282026-09-14T16:20:50Zjoyce—hanson14-01-1944NULLUNKNOWN····—2684 Grand AvePLANO··Texas75062——
TPATPA-636862026-09-24T04:58:43ZCHRISTIAN—COLEMAN2001-06-07N/A—6378226687christian.coleman@icloud.com1394 PALM DRSan DiegoCA92175-2715NULLOPTIONS-PPO
TPATPA-517372026-02-19T09:21:37ZElijah—Reynolds1951-70-24UNKNOWN•••-••-6076(380) 292-5421····2737 Baseline RdChandlerAZ85285-MEDICARE-ADV-A
TPATPA-544622026-02-14T12:58:31ZSANDRA—TUCKER19620606nullUNKNOWN-—4843 Grand AvenueSan DiegoCA92176N/A··—
TPATPA-582972026-05-07T07:13:25ZAnthony—Taylor2004-02-11UNKNOWN—N/A-1177 Sage CourtSan AntonioTX78208··—UNKNOWN
TPATPA-617322026-08-11T23:00:30ZGrace··—Ray1949-08-27—UNKNOWN8139878801null8858 Baseline RoadTampaFL33686—UNKNOWN
TPATPA-564752026-07-20T17:09:38ZWei—Dunn19460502····•••-••-0386·(375) 612-1702wei.dunn@icloud.com6309 Lincoln WayPlanoTX75041nullnull
TPATPA-594482026-01-05T08:22:38ZCAROL—GARZAOct 2, 1993-•••-••-8196·UNKNOWNCAROL.GARZA24@OUTLOOK.COM2772 Ridge RoadDenver·CO80280—UNKNOWN
TPATPA-610872026-06-11T06:28:46Zchristopher—payne1996-03-28—·UNKNOWNnull—5133 Canyon RdHOUSTONTexasnullGRP-4278SELECT-EPO
TPATPA-627392026-08-28T09:00:40ZLORI—FLULERSep 22, 1985null——null2591 Camelback RdTampaFL··NULL—CHOICE-PLUS-PPO
14,474 rows, page 96 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.438Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty