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-564032026-03-25T11:21:29ZKimberlyZCooper19830912UHC-95289-30—nullN/A9356 CENTRAL AVENUESACRAMENTOCA95865GRP-4509-
TPATPA-586472026-06-17T08:53:40Zcarolyn··gordn1956-11-16UHC-62649-12—N/A-5433 DESERT SKY BOULEVARDScottsdaleAZUNKNOWNGRP-3852UNKNOWN
TPATPA-517922026-04-26T08:06:55ZCamilaDAlvarado··UNKNOWNnull•••-••-4239538-557-9046—2575 PARK PLACECharlotteNC28201nullCORE-HMO··
TPATPA-611892026-06-16T15:22:11ZBetty··—Watkins1994-07-17N/A—NULLbetty.watkins@gmail.com6891 Palm DriveTempeAZ85286·N/ACORE-HMO
TPATPA-607542026-05-27T02:44:15ZDOROTHY····HARVEY8/24/2002UHC-41546-10null313-604-0690DOROTHY.HARVEY@PROTON.ME4150 Apache BlvdGLENDALE··AZ85322GRP-7078—
TPATPA-638342026-02-08T11:14:07Z·Rayymond—Chapman1975-12-27··—202-346-7133—null—-N/AUNKNOWN·N/A
TPA TPA-587142026-01-28T13:28:12ZOlivia··—·Fuller·11/15/00—NULL····—3435 RIDGE ROADPLANOTX75079nullN/A
TPATPA-591622026-04-10T12:57:39ZNoah··—Hall1967-05-02——-null8762 DESERT SKY BLVDTampaFL33644GRP-4915-
TPATPA-510732026-05-23T17:25:02ZBruce—·Myers1997-07-10NULL—9787690—162 RIDGE RD Apt 4San AntonioTX78202-6139··NULLMEDICARE-ADV-B
TPATPA-536142026-02-07T21:41:13ZJacqueline—Moore03/14/95UHC-13379-89—(770) 566-2126—9435 BroadwayHoustonTX··77087-NULL
TPATPA-531082026-02-24T22:24:39Z PAMELA··—MITCHELL1997-11-08··null—UNKNOWN··—5418 River RdPhoenixAZ··85073GRP-4318NAVIGATE-HMO
TPATPA-551462026-04-16T04:20:57ZAnn··Williamson1963-04-10null—-null·402 ELM STMiamiFL33107-—
TPATPA-521492026-09-29T19:01:16ZKeith—Baker09-03-1966—•••-••-8247——3446 Indian School RoadTampaFL33651—null
TPATPA-627502026-08-21T20:39:02Z·logan—·scott1988-08-15-—5052434196—9396 CEDAR LN··NashvilleTN37243·-—
TPATPA-577132026-04-01T16:19:48Z SAMUEL···RODRIGUEZ19571202UNKNOWN—380-201-5276—9608 Meadow LnPlanoTX·75018——
TPATPA-606592026-03-04T18:52:32ZHanson, Donna——1973-09-03UHC-58973-10—N/AUNKNOWN5664 Canyon RdTampaFL33684nullNULL
TPA TPA-618122026-06-18T20:33:52Zvirginia—cox19641225N/A•••-••-1951—·N/A6875 Camelback Road #275HOUSTONTexasN/ANULLCHOICE-PLUS-PPO
TPATPA-566202026-09-16T16:04:16ZKathleen—Mason1960-02-27————8572 VALLEY VIEW DRIVE··TampaFL33620GRP-2373CHOICE-PLUS-PPO
TPATPA-565582026-05-10T05:28:00ZELIZABETH—GEORGE1960-05-24——6874665661elizabeth.george@hotmail.comUNKNOWN—nullNULL··GRP-4558·OPTIONS-PPO
TPATPA-515972026-07-03T23:45:23ZTucker, Ammber··——1973-08-10—UNKNOWN—AMBER.TUCKER@ICLOUD.COM5701 Lake View Road··MINNEAPOLISMN55470—-
TPATPA-628632026-05-21T05:03:13ZCarpenter, Donna—····1983-09-12··—N/A5803238775N/A7395 Cedar LaneChandlerAZ·85225-4345GRP-0747SELECT-EPO
TPATPA-627302026-07-15T20:51:57ZRobert—Cole1997-08-17NULL•••-••-9911N/Anull8349 SAGE CTMinneapolisMN55498N/AN/A··
TPATPA-528102026-08-08T18:08:16ZJudith··—1940-07-01-UNKNOWNNULL—7317 SAGE COURTMINNEAPOLISMN·55427UNKNOWN—
TPATPA-556852026-05-21T07:22:22ZKaren—Snyder1983-11-04—•••-••-6671756.962.1206—·8467 Camelback RoadScottsdaleAZ85237N/ACHOICE-PLUS-PPO
TPATPA-572182026-07-15T15:24:49ZCastro—Priya1001-19-14nullN/A8483256271-1086 Oak StSeattleWA··98156-8577—CORE-HMO
TPATPA-588252026-03-22T15:40:24ZPriya—McDonald——N/A696.636.3485N/A5136 Apache BlvdTempeAZ85277GRP-1694—
TPATPA-582532026-08-26T21:28:47ZPatrikia—Silva·22-12-2005-•••-••-3330397-960-7109-———NULL····NULL··
TPATPA-619812026-04-08T18:34:31ZJORDAND··PADILLA2000-03-12nullNULLUNKNOWN—1639 BASELINE ROADPhoenixAZ85032—NAVIGATE-HMO
TPATPA-590052026-07-18T08:57:43ZPhilip—Ward1953-06-10null--philip.ward32@gmail.com4612 Baseline RoadMIAMI··FL·33199N/A—
TPATPA-578362026-09-04T02:42:53ZGERALDTSANDOVAL9194-01-28UHC-41043-56N/ANULLNULL·1877 Mesa Dr·MesaAZ85212UNKNOWN-
TPATPA-631622026-02-03T10:34:07ZJessica—Hunt27-04-1981UHC-73352-65•••-••-999917764191539JESSICA.HUNT@AOL.COM3711 Valley View DrMiamiFL33171·GRP-8163null
TPATPA-536392026-03-12T14:33:42ZBenjamin—Jensen9/25/1963null•••-••-8057—-8817 Forest AvenueGlendaleAZ——NULL
TPATPA-524432026-08-15T22:43:06ZHeatherQAustin1990-10-11NULL•••-••-4853UNKNOWN—6047 Lincoln WayAustin·TX78774NULL—
TPATPA-550182026-03-09T07:57:06ZBEVERLY—SCHULTZ1980-07-15NULL•••-••-7651N/ANULL9639 Union StNashvilleTN37287·GRP-0453MEDICARE-ADV-A
TPATPA-552382026-04-29T04:39:09ZStephens, Nancy——2005-01-22N/A-—NANCY.STEPHENS@OUTLOOK.COM8008 OCEAN AVENUEScottsdaleAZ85205UNKNOWN····
TPATPA-587122026-03-26T09:24:48Z·Noah—Greene·1950-02-17-—6764416981N/A·1784 RIVER ROADAtlantaGA30300·GRP-2577CHOICE-PLUS-PPO
TPATPA-637442026-03-24T00:03:33Zsandra····richardson03/12/2008NULL•••-••-339119109637712null3793 Canyon RoadScottsdaleArizona85254NULLnull
TPATPA-55586 2026-08-22T22:15:22ZJerry—Alvarez1959-06-05nullNULL—jerry.alvarez@icloud.com7735 Market StreetSeattleWA98115nullNAVIGATE-HMO
TPATPA-500482026-01-28T02:35:35ZWayne—Vazquez02/20/82—N/A(486) 780-5798—149 Lincoln WaySAN DIEGOCA92154··NULL—
TPATPA-533242026-06-18T12:48:01ZJUDITHO·BOYD19680155—-717.809.9671null9713 DESERT SKY BOULEVARDCharlotte·NC28258GRP-8904OPTIONS-PPO
TPATPA-644142026-05-27T16:44:34ZBobby—Myers1956-05-09UHC-26951-75•••-••-5106—·UNKNOWN4441 Mesa Dr #139Phoenix··AZ85041—OPTIONS-PPO
TPATPA-511572026-08-09T08:24:03ZMADISON—JONES19970099UHC-46381-97—2644496707madison.jones@aol.com4925 Palm DriveTucsonAZ85784——
TPATPA-552212026-06-19T22:08:50Z Debra··Lewis1949-12-24N/A—4348089398DEBRA.LEWIS74@HOTMAIL.COM9547 MEADOW LNAustinTX78766UNKNOWNN/A
TPATPA-518942026-07-06T21:37:03ZSantiago—Ferguson·3/12/1966UHC-76518-54··-17278331495—733 Spring StLos AngelesCA90089-2333—UNKNOWN
TPATPA-556772026-08-14T23:02:34Z Susan—·Watson1941-02-08—•••-••-8767——2514 BROADWAYATLANTAGA30335GRP-7375·MEDICARE-ADV-A
TPATPA-570532026-01-14T03:18:24ZMark—Green03/05/1988····NULL—mark.green34@yahoo.com·464 OCEAN AVE·San DiegoCAN/ANULL·NULL
TPATPA-622872026-07-23T05:15:24ZCarolE·Stevens1947-08-14—•••-••-7588—null5527 HIGHLAND AVENUEEden PrairieMN·55321GRP-5828—
TPATPA-529132026-07-25T17:02:48ZKATHLEEN—GRAHAM12/23/2000UNKNOWN•••-••-1494785-558-5868UNKNOWN·8422 Union StFRESNOCalifornia93788NULLN/A
TPATPA-599572026-07-23T07:27:35ZEdward—Duncan6/25/1961null—N/A··-619 Market StDenver·Colorado80280-6086GRP-4683null
TPATPA-589392026-09-14T00:31:28Zcralson—willie1985-10-01UNKNOWN··—924-256-4054NULL9215 Ocean AveMinneapolisMN55427—null
14,474 rows, page 165 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:52.214Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty