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-516092026-09-15T03:51:21ZKEITH—VAZQUEZ··05/23/65—•••-••-1098-—6164 GRAND AVENUEScottsdale·AZ85299NULL—
TPATPA-54297 2026-08-30T16:44:09ZScott—Morris1976-05-10—NULL562-686-8750N/A7172 CENTRAL AVENUEColumbusOH43223—····
TPATPA-558842026-07-27T11:55:04ZRobert—Jordan20060803··-•••-••-8306NULLnull6592 HIGHLAND AVENUEMinneapolisMN55431GRP-8490—
TPATPA-559512026-03-16T19:20:41ZRichard—BoydAug 7, 2001··UNKNOWN•••-••-6752——1939 Willow CourtAustinTX··78742N/A—
TPATPA-581022026-10-12T20:10:22ZRebecca—FullerAug 19, 1939··NULL··NULL—3291 Valley View DrLas VegasNevada89143NULL··UNKNOWN
TPATPA-520882026-08-11T18:59:20ZGriffin, Jack—··1977-02-25UHC-51506-16—(436) 947-6377jack.griffin@outlook.com5316 CANYON ROADMinneapolisMN55474NULLUNKNOWN
TPATPA-611592026-01-22T16:05:44ZHoffman, Ahmed——1979-12-22——··AHMED.HOFFMAN@HOTMAIL.COM1307 PINE DRIVEDallas··TX75200UNKNOWNNULL
TPATPA-571382026-01-28T05:25:47ZEmily—Brown1943-12-10NULL•••-••-5215940.845.4541·UNKNOWN8526 VALLEY VIEW DREden PrairieMN—GRP-4107—
TPATPA-606442026-07-16T10:37:11ZJoe—Reyes··1982-01-09-····UNKNOWNNULL1612 CHURCH STDallasTX75219null-
TPATPA-513572026-07-12T05:20:55ZFox—Amanda19921101—null—null··324 Highland AveEden PrairieMN·55332——
TPATPA-611502026-02-11T08:37:46ZFisher, Amy——1975-05-19··nullUNKNOWN—UNKNOWN653 WASHINGTON STCHANDLERAZ85259-1728N/ACHOICE-PLUS-PPO
TPATPA-561932026-09-23T16:52:43ZBRIANY·ANDERSON·1968-07-14—null(361) 762-3191NULL-—·-NULLGRP-6793NAVIGATE-HMO
TPATPA-511322026-05-27T20:07:04Zcarl—rivera1970-04-01UHC-56976-80•••-••-7387—carl.rivera@outlook.com2998 Canyon Rd #815CHARLOTTENorth Carolina··28212UNKNOWN—
TPATPA-513532026-04-20T16:23:41ZMarcus—Fields·1996-03-03N/A•••-••-1222(613) 307-9537—8621 OAK STNASHVILLETN37241N/ANULL
TPATPA-517762026-08-19T23:14:19ZHannah—Weber16-06-1985—•••-••-4879UNKNOWNnull1040 Ocean AvenueCharlotteNC28222—null
TPA TPA-562952026-09-30T18:55:56ZDANIELLE··—CARROLL01-03-1992—•••-••-2745nulldanielle.carroll82@proton.me1954 Maple AveGilbertAZ85256·UNKNOWNnull
TPATPA-515442026-01-28T14:25:15ZCarool—Carlson1994-06-12UHC-74968-93—nullUNKNOWN841 Central AveDallasTX75220GRP-9934·options-ppo
TPATPA-553072026-07-22T00:15:49ZBeverly—Thompson1943-05-13-UNKNOWN17834378640NULL260 PARK PLACENashvilleTN37280N/AN/A
TPATPA-542672026-08-21T08:10:52ZChristine—Patterson1973-05-17—•••-••-9968729-676-3246—N/A--null··—
TPATPA-574902026-09-14T13:07:34Zpamela—hillApr 20, 1982-—NULL-6733 HILLCREST RDCharlotte·NC28281GRP-8361··NAVIGATE-HMO
TPATPA-625822026-05-16T07:41:43ZJack—James·1957-03-03UNKNOWN•••-••-1330——1297 MAPLE AVENUETampaFL33662GRP-3340—
TPATPA-512782026-10-17T19:39:01ZRyan—Bennett12/04/1983UHC-03938-67—9107426296ryan.bennett@hotmail.com1282 RIDGE RDSEATTLEWA98139nullCORE-HMO
TPATPA-571802026-08-20T18:55:40ZLori—Delgado1974-04-12—-NULLUNKNOWN2102 MAIN STSacramentoCA·95857UNKNOWN··-
TPATPA-558062026-03-06T18:10:37ZAustin—Warren2000-12-22———AUSTIN.WARREN64@GMAIL.COM··917 Indian School RoadScottsdaleAZ85202UNKNOWNUNKNOWN
TPATPA-541742026-04-30T03:33:16Z Cook, William—····1987-08-04null•••-••-3579(286) 579-0529UNKNOWNnullUNKNOWNNULLnull—options-ppo
TPATPA-572602026-09-29T06:49:06ZRussell C—CunninghamSep 3, 1965N/ANULLN/Anull4129 VALLEY VIEW DRMiami··Florida33191N/A—
TPATPA-586602026-03-08T02:43:33Z·Donna—Young1959-04-09null•••-••-8056null—9562 Grand AveTAMPAFL33640—OPTIONS-PPO
TPATPA-506662026-02-04T01:14:40ZDANIEL···WRIGHT1970-12-24null··———1934 VALLEY VIEW DRORLANDOFL32856GRP-4350null
TPATPA-625552026-10-13T18:43:35Znancy—rojas··10/03/2007··N/A———309 Ocean AveAustinTX78700——
TPATPA-591972026-01-09T11:57:26ZDenise—Lucas1997-06-10—UNKNOWN··-nullUNKNOWN——UNKNOWNnull
TPA TPA-592592026-08-04T04:29:32ZMadison—Tucker10/17/63—NULL——5673 River RdColumbus··OH-N/ASELECT-EPO
TPATPA-511092026-09-22T12:49:43ZHowell, Gerald——4/8/1941UHC-70632-75•••-••-8127(718) 403-9371N/A2627 Baseline RoadMinneapolisMN55423GRP-9042NAVIGATE-HMO
TPA TPA-507932026-01-21T01:06:09ZJANET—JOHNSON1980-02-22—•••-••-6706UNKNOWN—4171 LINCOLN WAYLos AngelesCA90036NULLCORE-HMO
TPATPA-611272026-01-08T08:52:14ZSEAN····HARPER1966-04-26UHC-34117-81——sean.harper51@hotmail.com3513 Indian School RoadNashvilleTN37206N/Anull
TPATPA-564342026-08-02T09:24:56ZJonathan—Carter1981-09-14N/A·UNKNOWN(669) 207-4805—7548 Highland AvePlanoTX75021GRP-9354NULL
TPATPA-601112026-07-27T17:18:24ZRndy—Cruz6/22/1939UHC4538796•••-••-60568934782097N/A790 WILLOW CT #472SCOTTSDALEAZ85256GRP-2481MEDICARE-ADV-A
TPATPA-603102026-01-06T21:00:26ZHannah—Vazquez2008-07-21null•••-••-1206(468) 577-5622UNKNOWN5714 RIVER RD··DallasTX75295GRP-9901N/A
TPATPA-500032026-08-03T18:19:05ZjamesK.hunter1960-03-14—UNKNOWN·6357738—6535 BAYSHORE DRORLANDO·Florida32832··GRP-2498null
TPATPA-617182026-05-05T01:11:09ZZACHARY—DELADO1993-04-17—NULL(908) 822-6788·N/A305 Elm StLas VegasNV89168—N/A
TPATPA-55833 2026-05-21T17:52:04ZJamesIOwens··1980-03-02····NULL+1 216 903 5769··-nullNULL—GRP-3418—
TPATPA-531462026-04-08T21:58:24ZKevin—Peters04/17/76—-NULL—2466 BROADWAYColumbusOH·43297NULLNULL
TPATPA-546022026-04-28T19:30:39ZDANYEL—HAWKINNS15-06-2006····null—NULL6882 Harbor BoulevardGilbertAZ85221··——
TPATPA-585952026-03-08T04:28:35ZMason··Jenkins1956-09-19NULL•••-••-0954-null8141 Harbor BlvdGilbertAZ85219——
TPATPA-624812026-08-23T04:25:06ZGeraldL.Parker1970-07-24nullUNKNOWN—·gerald.parker77@icloud.com7751 Mesa DrChandlerArizona85228-null
TPATPA-546742026-10-15T08:11:20ZEvelyn—ColemanNov 13, 1982UNKNOWN•••-••-4707····—5757 Main StTAMPAFL33672NULL—
TPATPA-618312026-01-21T18:17:46ZLinda—Marquez1953-09-16UHC-26316-13——null7510 GRAND AVEDenver··CO80299-—
TPATPA-521852026-01-01T04:09:08Z·DONNA—WARD··1979-11-02UHC-41143-98•••-••-2168——NULL—-NULL·nullMEDICARE-ADV-B
TPATPA-588602026-01-13T08:01:17ZMurphy, Carl····—Aug 3, 1955—N/A5993423243—3504 HARBOR BLVDTucsonAZ-N/AUNKNOWN
TPATPA-581512026-02-19T20:56:47ZJORDAN—GILBERT2000-05-22N/AUNKNOWN-jordan.gilbert36@gmail.com—--··GRP-4134MEDICARE-ADV-B
TPATPA-505502026-03-23T07:12:36ZSHARON—OWENS1946-05-14UNKNOWN•••-••-7354—nullUNKNOWN——nullNULLNULL
14,474 rows, page 94 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.432Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty