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-616482026-02-22T05:28:22Z carlos—cllark12/08/1975NULL—+1 691 746 5857N/A3497 Church StreetMIAMI·FL33184UNKNOWNNAVIGATE-HMO
TPATPA-516392026-09-07T17:13:07ZSRAH—SNYDER01/02/44——293-858-3248-8118 CANYON ROADSan Diegoca··-—MEDICARE-ADV-B
TPATPA-622482026-04-07T21:48:28ZGabriel—Weber5/1/2004-—NULLUNKNOWN3435 Desert Sky BoulevardSan AntonioTX——MEDICARE-ADV-B
TPATPA-516522026-06-04T22:00:48Z brittanyJvargas5/22/2002—•••-••-9237—null·2068 Union StPlanoTX75088-6022GRP-8073—
TPATPA-502462026-08-19T13:28:02ZTylerL.Moreno1994-11-12null•••-••-6801N/Anull1312 RIDGE ROADSeattlewa98120—MEDICARE-ADV-A
TPATPA-62712 2026-09-06T12:19:06ZGeorgeCHicks·1998-07-23nullN/AN/ANULL2519 Forest AveSacramentoca95868-8533nullUNKNOWN
TPATPA-503222026-07-29T04:34:43ZKAREN—ROJASMay 21, 1996··-•••-••-0393903.838.4737··karen.rojas@icloud.com6039 Sage Ct·MiamiFlorida33184—-
TPATPA-58375 2026-04-16T02:59:55ZEthanT.··Mitchell1954-08-17nullnull—NULL4533 VALLEY VIEW DR Apt 13Atlanta··GA30372—NULL
TPATPA-575852026-09-03T00:40:11ZMAK—HAWKINS02/22/73NULL·NULL——1648 MAIN STREETTempeAZ85289-7407—CHOICE-PLUS-PPO
TPATPA-635142026-08-26T15:18:30ZDenise—Thomas·Mar 3, 2003——(210) 845-9799denise.thomas@outlook.com983 Palm Drive·AtlantaGA30301—null
TPATPA-512472026-01-04T15:38:28ZRoy—Tucker1946-01-17UNKNOWN———7341 OAK STAtlantaGA30300-3232·N/AOPTIONS-PPO
TPATPA-516612026-01-16T08:05:38ZROBERT—·WELLS10-10-1957—•••-••-9839—NULL3675 Mountain View DriveSan AntonioTX78234GRP-3751CORE-HMO··
TPATPA-578032026-05-19T01:43:48ZWILLIAM—TUCKER3/14/1940—•••-••-7165-—136 ELM STMinneapolisMN55480N/AMEDICARE-ADV-A
TPATPA-557432026-04-26T03:31:46ZANTHONY—LEWIS1952-08-09N/A•••-••-3035—UNKNOWN7328 Union StreetHoustonTX77058N/AMEDICARE-ADV-B
TPA TPA-564222026-06-04T12:20:23ZRobertson, Christopher——1969-07-26UNKNOWNNULL661-402-7020-2940 Valley View DriveOrlandoFL32822GRP-9342null
TPA TPA-510672026-08-15T08:47:14Zjulia——09/26/1999nullUNKNOWNUNKNOWNNULL9413 Jefferson AveDenverCO80281UNKNOWN—
TPATPA-613522026-10-10T05:02:06ZKimberly—Bell02/18/38——5787019905—9241 Elm StMesaaz85270N/Anull
TPATPA-505512026-05-09T22:53:23ZAustinV··Rice1961-08-09··UNKNOWN-·16339088309—UNKNOWNN/Anull-—MEDICARE-ADV-A
TPATPA-617902026-01-05T14:56:07ZanthonyS··jordan1979-03-14—UNKNOWN709-697-4630··6601 Willow CtMesaAZ85284GRP-1264—
TPATPA-529322026-06-06T00:30:30ZBRADLEY—RODRIGUEZ01/01/59nullNULL9741414bradley.rodriguez@aol.com682 Pine DrLas VegasNevada89194N/ANAVIGATE-HMO
TPA TPA-576132026-05-27T18:46:39ZBrandon—Johnson1990-06-21UNKNOWN······-NULL8128 Washington StreetDenverCO80289-N/A
TPATPA-611062026-03-11T22:07:34ZWEI—KNIGHT13-01-2003··UNKNOWN•••-••-5796—wei.knight@yahoo.com5983 HARBOR BLVDMinneapolisMN·55440-CHOICE-PLUS-PPO
TPA TPA-605402026-02-28T11:55:23Z Roger—Harrison1981-01-09—N/A—N/A778 Harbor BoulevardGLENDALEAZ·85345N/ANULL
TPATPA-507622026-07-05T17:43:33ZYUKI····BROWN19681015NULL-—N/A6134 Canyon RoadAustinTX78708nullN/A
TPATPA-507382026-02-11T09:10:12ZSean··—Nunez10/03/1997null—442.515.0403—4431 Forest AvenueFRESNOCA93704—N/A
TPATPA-626192026-04-10T10:43:17ZNathan—Bryant12/05/62··—8089364UNKNOWN6883 Main StreetJacksonville··FL32216-1612—MEDICARE-ADV-B
TPATPA-50663 2026-03-10T11:00:40ZRalh—Gonzalez16-03-1994nullnull-ralph.gonzalez73@aol.com7003 Jefferson AveLas VegasNV89189—NULL
TPATPA-535752026-08-12T13:32:55ZWagner, Yuki——1980-05-17UHC-11396-96NULL6375562087—123 Sage Ct·NashvilleTN37205-9351·GRP-0364—
TPATPA-511532026-08-17T20:58:24ZDEB—JOHNSON1978-06-01—-(533) 956-4622UNKNOWN··2676 Grand AvenueTampa··Florida33681nullUNKNOWN
TPATPA-563812026-04-23T08:58:38ZEugene—Washington1980-11-20NULLUNKNOWNUNKNOWN-9165 Lake View RoadHOUSTONTX77099—MEDICARE-ADV-B
TPATPA-505732026-01-23T01:24:59ZADAM—SANDERS1998-12-16-——-·8671 Valley View DriveFRESNOCA93713NULLSELECT-EPO
TPATPA-598322026-07-10T10:46:51ZTheresa—Cooper2008-05-17—N/A6768441646nullNULL——-—-
TPATPA-558322026-04-19T23:40:42ZTOM—MENDOZA2007-04-23-N/AN/A-4060 Grand AveEden PrairieMN55393N/Amedicare-adv-a
TPATPA-518392026-02-22T14:57:10ZCHRISTINE—COLEMAN07/15/88-—-·-·NULL-UNKNOWN—UNKNOWNN/A
TPATPA-564952026-02-21T16:16:46Z MaryBYoung1996-07-16UNKNOWN•••-••-5419-··—9853 SAGE CTMesaArizona85260GRP-4220-
TPATPA-606092026-07-09T15:57:26ZGrace—Armstrong1986-04-08-—15378844765NULL——nullUNKNOWN-—
TPA TPA-638062026-03-28T17:05:39ZJoshua—Gonzales3/6/2001·N/A•••-••-7577·NULL-··4712 SUNSET BOULEVARD #359PhoenixArizonanull·GRP-5868N/A
TPATPA-615672026-05-19T08:35:51ZBARBARA—DUNN01/04/2007—null··4253954487-8620 CEDAR LNMiamiFL··33198·GRP-4968N/A
TPATPA-534432026-01-06T01:01:02ZJudy—Little2002-04-17---—1140 Cedar Lane Apt 35·ColumbusOH43292—·-
TPATPA-614682026-10-05T23:14:19ZBrandonUHart1982-04-10-•••-••-4144—N/A2303 INDIAN SCHOOL ROADColumbusOH43218—SELECT-EPO
TPATPA-542262026-08-07T18:07:24ZLogan—Lewis1969-06-02··UHC-66714-96—(575) 792-6798logan.lewis40@hotmail.com5160 Church StDallasTX75205GRP-4452··
TPATPA-583672026-10-14T15:33:35ZJoseph—·Webb20080115NULL—N/AUNKNOWN838 Washington StreetMinneapolisMN55477—NAVIGATE-HMO
TPATPA-552742026-03-04T18:05:15ZVega, Julia——1950-73-13UNKNOWN•••-••-7101UNKNOWNnull8225 Highland Ave··ScottsdaleAZ85229GRP-5738MEDICARE-ADV-B
TPATPA-594562026-05-26T16:16:28ZWAYNE—MARSHAL1983-10-09··nullnull13912203085··—6085 Church StreetSan AntonioTXNULL—NAVIGATE-HMO
TPATPA-643772026-03-27T00:13:34ZEvelyn··Hughes1999-02-26null•••-••-7709597-261-7796null1327 SAGE CTLas VegasNV89154-—
TPATPA-628532026-02-21T13:05:02ZDiana··Hunter8/4/1979N/A-UNKNOWNN/A5523 Central AveTampaFL33646NULLUNKNOWN
TPATPA-515152026-05-09T16:41:11Zwillie—torres1979-07-09-•••-••-9280N/A—3439 VALLEY VIEW DRIVETAMPA··FL33603UNKNOWN····
TPATPA-600662026-05-21T00:30:29ZJoe—Rivera1497-04-27··————8364 Camelback RdGILBERTAZ85259nullnull
TPATPA-616392026-09-15T19:22:38ZAhmed—Carter10/01/80—•••-••-9138(812) 325-6993—·6189 VALLEY VIEW DRATLANTAGeorgia30331··—N/A··
TPATPA-567682026-01-25T23:53:29ZGarza, Joan—····12/12/74null•••-••-6195——5331 Willow Ct Apt 17CHARLOTTENC28232-0208·NULLCHOICE-PLUS-PPO
14,474 rows, page 170 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.231Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty