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-597832026-02-16T23:34:09ZHenry—Burtn11-07-1978null-+1 645 843 5996UNKNOWN1268 Cedar LaneCHARLOTTE··nc28206UNKNOWNCORE-HMO
TPATPA-525142026-06-16T23:13:34ZSantiago··Mendoza10/25/1939··UNKNOWN———NULLnullNULLnull—CHOICE-PLUS-PPO
TPATPA-592022026-10-13T04:35:08ZRomero, Jessica—····02-11-1959N/A•••-••-58526048115514null··2273 LINCOLN WAY··NashvilleTN37264N/Anull··
TPATPA-596122026-09-13T03:59:30ZPaul—Welch1951-06-06——355-476-8150—1850 PARK PLPhoenixAZ85071··GRP-4623MEDICARE-ADV-B··
TPATPA-535072026-03-29T23:47:05ZEmily—Peters··Jan 4, 1998··——N/ANULL8187 MARKET ST Apt 17TucsonAZ85767N/A-
TPATPA-507772026-04-29T12:45:34ZDavid—Turner1940-04-17nullN/Anulldavid.turner@outlook.com9519 Jefferson AveCharlotteNCUNKNOWN—OPTIONS-PPO
TPATPA-615952026-07-19T02:33:09ZJack··Brooks1981-01-26-··null—N/A····UNKNOWN-··—
TPATPA-506602026-05-29T02:21:13ZJoeW.Olson1974-08-05UHC-29037-70NULLUNKNOWNN/A··1289 Lake View RdAtlantaGA30353-—
TPATPA-642852026-04-04T02:27:14ZJose—Banks1997-11-05UNKNOWN—UNKNOWNjose.banks@icloud.com5571 Main StDALLASTX75275—-
TPA TPA-600092026-06-03T16:00:03ZSHIRLEY—HUNTER1958-03-17UNKNOWNUNKNOWN834-466-2722shirley.hunter64@outlook.com4214 Spring StreetSan DiegoCA92173NULLNULL
TPATPA-635592026-08-13T23:15:55ZKatherine—Black1997-07-25—•••-••-8075(232) 267-7319····45 Palm DriveTUCSONAZ85765null—
TPATPA-532652026-08-31T02:17:09ZVincent—Meyer2005-07-25N/A··——7588 CAMELBACK ROADDallasTX75251GRP-3339OPTIONS-PPO
TPATPA-601762026-07-10T04:51:45Z·Ryan—Soto2002-11-11-UNKNOWN—RYAN.SOTO48@YAHOO.COM8891 Union Street #361TEMPEArizona85233—··
TPATPA-627752026-04-24T19:04:26ZSUSANZBARNES1999-01-17NULL—2894137118-9887 LINCOLN WAYSeattleWA98149GRP-2443UNKNOWN
TPATPA-512972026-04-23T07:01:02ZBrittany—Kim1958-12-16—•••-••-2714NULLN/A6440 Central AveHoustonTX77010-9070GRP-2039·UNKNOWN
TPA TPA-63016 2026-01-21T22:31:01ZJACK··SMITH1974-06-11··—-8054337199UNKNOWN-—UNKNOWNUNKNOWNGRP-2568null
TPATPA-600542026-01-26T15:20:15ZDorothyC.·Price2007-01-05null•••-••-2914N/A—1418 SUNSET BOULEVARDSan DiegoCalifornia92153-8953—UNKNOWN
TPATPA-515362026-07-02T20:47:24Zjakc—gibson09/24/1939UHC-51781-73UNKNOWNNULLnull·8712 Apache BlvdScottsdaleAZ85235GRP-6325UNKNOWN
TPATPA-618782026-08-11T10:59:11Z·ALEX—ESTRADA2004-12-02-—-null2506 Indian School RdHoustonTX77036UNKNOWNMEDICARE-ADV-A
TPATPA-519592026-09-14T20:06:27ZJonathan—·Cunningham15-01-1988NULL•••-••-8456null-8972 Union StreetMinneapolisMN··55470—null
TPATPA-643012026-07-26T18:36:28ZJass—Butler··1961-06-06nullNULL——1637 SAGE COURTPLANO··Texas75050GRP-0838-
TPATPA-633022026-02-09T08:21:50ZAdam—VegaDec 27, 1974·N/A•••-••-7820(537) 246-7498—3130 Cedar LaneSAN DIEGOCA92181-4218NULLN/A··
TPATPA-61078 2026-04-30T01:48:11Zmadison—black19950309N/AUNKNOWN5917094—5866 Sunset BlvdTucsonAZ85747—null
TPATPA-614542026-03-31T02:20:59ZJULIE—MOORE2003-01-20UHC-75274-21•••-••-0174·206.724.1656julie.moore@proton.meNULL··—····-nullNULL
TPATPA-541762026-10-16T13:59:17Zryan—evans2/7/1974N/A•••-••-9491—-null-——GRP-2487UNKNOWN
TPA TPA-524442026-05-06T23:38:23ZMaria—Nguyen02-04-2003—•••-••-2381·N/Amaria.nguyen@gmail.com4081 Willow CtPhoenixAZ85030—NULL
TPATPA-575292026-06-20T17:40:54ZBrian····Gutierrez1995-03-11—··15662238308brian.gutierrez@aol.com2323 River RdPhoenixAZ85080GRP-5123—
TPATPA-558832026-01-02T20:28:05ZPatrick····Jordan1964-07-10—N/A5423530470N/A9666 BROADWAYGlendaleAZ85340null—
TPATPA-583132026-03-02T20:02:12ZSean—Reynolds·1989-10-25UNKNOWN····578.288.1671—7232 Broadway Apt 17··CharlotteNorth Carolina28298GRP-2540—
TPATPA-572292026-02-02T06:06:31ZSantos, Raymond——02/12/1959—-(894) 610-0025NULL1830 Spring Street·AtlantaGA30311——
TPATPA-623302026-02-13T12:08:16ZKEVIN··—FERNANDEZ1971-05-07NULL—UNKNOWN·NULL1111 River Road··TEMPEaz85222GRP-4469OPTIONS-PPO
TPATPA-617282026-04-12T04:29:31ZRalph—Armstrong1957-02-11··N/A····N/A7059 Desert Sky BoulevardGlendaleaz··85367GRP-8168··
TPATPA-594932026-03-02T12:03:02ZAustin—·Bishop9151-03-06N/A-·-austin.bishop@yahoo.com3168 Central AvePhoenixAZ85014——
TPATPA-506292026-05-23T13:33:59ZMeyer, Victoria——1996-05-01—-——5344 Indian School RdLas VegasNV89195N/AMEDICARE-ADV-B
TPATPA-641772026-06-16T01:17:11ZPatricia—Watson·19390816-•••-••-54516788158135null5752 DESERT SKY BOULEVARDEden PrairieMN55352——
TPATPA-602512026-08-21T09:25:50ZTurner, Nathan——1987-05-06N/AN/A··null—528 Market StreetGilbertAZ85275-1898nullnull
TPATPA-591262026-08-23T03:53:24ZMASON—STEVENS2005-09-23UHC8994835··•••-••-9745null··-2997 Mountain View Drive·MinneapolisMN55418GRP-3396····
TPATPA-518372026-01-28T01:08:00ZWells—Jonathan1997-04-19·UNKNOWN•••-••-3593NULL—9341 Church StreetSeattleWA98160UNKNOWN·MEDICARE-ADV-B
TPATPA-529522026-03-05T11:03:51ZEMMA—SNYDER1987-01-06UHC-72226-83nullN/A-9645 WASHINGTON STREETCHANDLERAZ85242GRP-1990UNKNOWN
TPATPA-639442026-08-17T01:40:55ZHELEN—DAVIS19420226··—UNKNOWN—helen.davis@proton.me9545 APACHE BOULEVARDDALLASTexas75240null··—
TPATPA-521752026-08-14T13:17:41Zjanice—tran1977-08-21·UNKNOWN•••-••-64047909389444N/A4477 BROADWAYSan AntonioTX78281—MEDICARE-ADV-B
TPATPA-578292026-06-05T00:44:47Zgracce··—romero··1978-08-24null—6328209186NULL6656 Lincoln WayNASHVILLETN37237nullnull
TPATPA-517202026-02-21T11:18:32ZBRYAN—MORENO0721-89-78null•••-••-3696—N/A212 WASHINGTON STREETSan DiegoCalifornia··92115-NULL
TPATPA-620002026-03-09T16:00:35ZHicks—Amy1960-03-21—•••-••-3007N/A—6886 Palm DrGilbertAZ85277—-
TPATPA-579902026-04-25T21:18:27ZEMILY—CHENMar 7, 1949UHC-23290-49—662.385.9741EMILY.CHEN@GMAIL.COM8476 Palm DrGlendaleArizona85381nullCHOICE-PLUS-PPO
TPATPA-51399 2026-04-21T14:28:03Z———05-07-1992NULLUNKNOWN(837) 637-2772—3824 Harbor BoulevardJacksonvilleFL32263GRP-4733—
TPATPA-639742026-04-14T07:34:55ZChristianD.Wells7/26/1946·UNKNOWN•••-••-6984(374) 546-6544N/A·null·null—NULLGRP-2250NULL
TPATPA-530272026-10-13T23:32:37ZGace—Vargas19540526NULL•••-••-7896+1 590 528 9339NULL955 OCEAN AVENUE #337Minneapolis·MN—GRP-4538—
TPATPA-552552026-05-23T03:47:24ZWILLIAM—DELGADO1946-03-23UHC3316180null14068171785null9138 SUNSET BOULEVARDFresnoCA93734-··CORE-HMO
TPATPA-524912026-02-21T06:07:11ZRay—Patel1947-12-18UNKNOWN··•••-••-5174··-5334 Meadow LaneDenverCO80292—UNKNOWN··
14,474 rows, page 37 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:37.749Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty