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-558822026-05-29T23:14:05ZCharlotte—Carrroll04/25/1940UHC-85517-38——charlotte.carroll@icloud.com886 BroadwaySan AntonioTX·78207N/A-
TPATPA-515062026-08-13T17:26:24ZJoyce, FreemanW.—1965-06-18null—945.800.6271—N/A··—UNKNOWNNULLNULL—
TPATPA-620462026-08-17T06:25:02ZJensen, MarcusK··—1968-07-11N/ANULL—NULL2794 PINE DRIVESan Antonio··TX···78242GRP-2361N/A
TPATPA-593962026-09-23T08:04:08ZCyntiha—Baker1939-09-16——4547801181—UNKNOWNNULL—·UNKNOWNGRP-1877—
TPATPA-514142026-08-09T00:19:05Z ·JACQUELINE—ALLEN1974-05-11UHC-41153-69•••-••-0926-·null7384 Palm DrPlanoTX75039—MEDICARE-ADV-B
TPATPA-569092026-04-16T17:03:41ZChristina—Pierce19640624UHC-90537-60NULL··-christina.pierce5@outlook.comUNKNOWNNULL----
TPATPA-525022026-03-07T07:24:22Z GraceAKennedy1952-02-07N/A—····—3820 Indian School RdFresnoCA93754-2683NULLMEDICARE-ADV-B
TPATPA-608022026-01-20T05:40:31ZMelissa—White1978-10-14—•••-••-0576—null7238 CANYON RDNashvilleTN37234GRP-5713CHOICE-PLUS-PPO
TPATPA-570572026-06-02T07:37:11ZMarcus—Jenkins05-09-2000null—NULLmarcus.jenkins95@icloud.com1360 Hillcrest RoadTampaFL33623—··
TPATPA-640162026-02-26T07:07:46ZChristian—Rivera1988-10-19·UHC6590662····null—1552 WILLOW CTTucsonAZ85785GRP-4383NULL
TPATPA-575482026-10-09T10:35:40ZASHLEY—FIELDS1986-05-25NULL•••-••-1431UNKNOWN—6344 Forest AveJacksonvilleFL32225GRP-5336CHOICE-PLUS-PPO
TPATPA-625582026-01-07T01:03:19Znicholas—santos1973-05-25UHC-65934-13null(641) 917-1258-6211 MAIN ST Apt 18Mesa··AZ85237GRP-3756·MEDICARE-ADV-A
TPA TPA-586972026-08-19T22:52:00ZGABRIEL—THOMPSON1997-11-23—•••-••-6902(938) 798-2419—4938 Hillcrest RdLos AngelesCA90000—SELECT-EPO
TPATPA-577492026-01-30T16:05:33ZMarilyn—King10/14/70N/AN/A8824665571null7092 PINE DRHoustonTexas·77078nullN/A
TPATPA-571552026-02-05T09:28:34ZGuzman, Steven——1960-11-07——UNKNOWN—1507 Central AveHoustonTX77023GRP-2852OPTIONS-PPO
TPATPA-579222026-09-15T04:23:36ZJohnny··—HicksMar 5, 1965N/A--UNKNOWN5013 Sage CourtMIAMIFL33176GRP-9531N/A
TPATPA-517052026-01-19T20:33:16ZDiegoLPena1993-08-12—NULLN/A·UNKNOWNN/ANULLUNKNOWNN/ANULL··CHOICE-PLUS-PPO
TPATPA-632772026-08-05T03:42:55ZMegan—Young02/28/1952NULL··null—7069 Palm DrMesaAZ85245GRP-9233N/A
TPATPA-640122026-01-12T10:28:59ZPeter····Green·7/18/1992N/A-null-8788 Grand AveLas VegasNV89105GRP-3448N/A
TPATPA-544512026-02-16T19:42:03ZMEI—MURPHY12-01-1956—•••-••-2547nullnull177 Jefferson AveSan AntonioTX78274—NULL
TPATPA-620122026-07-17T21:49:41ZVazquez, Kayla——1948-06-13··UNKNOWN947.713.2638KAYLA.VAZQUEZ64@YAHOO.COM2691 Indian School RdColumbusOH43214N/A—
TPATPA-530282026-08-13T19:50:44ZJONATHAN—JOHNSON2/8/1946NULL-N/A··null2808 BroadwayDALLASTX-GRP-8559MEDICARE-ADV-B
TPATPA-509322026-06-18T14:33:14ZSantiago—Aguilar··01/13/46—N/ANULLUNKNOWN7366 SUNSET BLVDCHARLOTTENC28219··NULL—
TPATPA-599852026-06-02T03:29:09ZEDWARD—JENKINS1970-06-11—•••-••-3536621.443.7611null7960 River RdMinneapolisMNnullnullSELECT-EPO
TPATPA-513322026-06-18T10:39:47ZMEGANK··GORDON2001-04-14-•••-••-82897984445814UNKNOWN5144 MAPLE AVENUETampaFL33663—N/A
TPATPA-558352026-06-17T00:42:26ZKATHERINE—GOMEZ0207-07-28UNKNOWNnullUNKNOWNkatherine.gomez1@gmail.com—····—NULL-—
TPATPA-56289 2026-01-03T14:45:50Z·Ahmed—Marshall05/08/85————4444 Canyon Rd #987SACRAMENTOCA95839nullOPTIONS-PPO
TPATPA-525662026-09-17T04:44:07Zchristina—washington19570302—•••-••-5601-christina.washington18@yahoo.com·6381 PALM DRIVELas VegasNV89126—NULL
TPATPA-540292026-09-01T08:10:31ZJIMMYSRUIZ06/20/1985null··—·nullNULL7055 BAYSHORE DR #520ColumbusOH43266—NULL
TPATPA-624752026-08-08T01:13:07ZBobby—·Morgan20051226null——null5906 MAPLE AVENUEFresnoCA93738—-
TPATPA-615572026-03-07T04:26:36ZJessica····Pierce··1960-03-20—N/AN/A·UNKNOWN1226 JEFFERSON AVELos AngelesCA90020UNKNOWNCHOICE-PLUS-PPO··
TPATPA-575152026-05-27T18:48:52ZJORDAN—HILL·2001-11-11nullN/A(268) 716-1978jordan.hill6@hotmail.com6475 WASHINGTON STREETORLANDOFL··32877—null
TPATPA-628852026-07-25T22:51:17ZMargaret—Freeman2007-05-19UNKNOWN•••-••-09222517431405—N/A··N/A—UNKNOWNNULLOPTIONS-PPO
TPATPA-57283 2026-04-27T11:51:36ZOmar—Castro1938-12-18UHC-52606-73•••-••-6972NULL-6204 Forest AvenueGilbert··AZ—GRP-3026-
TPATPA-584222026-10-18T04:15:54ZHoffman, Joshua——1949-01-03N/Anull-null5706 Desert Sky Boulevard··DenverCOnull——
TPA TPA-519672026-08-05T16:17:15ZCAMILA—PEREZ1974-09-02UNKNOWNN/A·+1 822 421 7416CAMILA.PEREZ76@GMAIL.COM3967 Highland AveLOS ANGELESCA90065GRP-5877NAVIGATE-HMO
TPATPA-534402026-04-07T06:23:02Zelizabeth—stevens1993-01-09null•••-••-6374UNKNOWN—3674 Maple Avenue··MinneapolisMN55409··nullNULL
TPATPA-507922026-10-04T16:13:04ZJANET··JOHNSON1980-02-22··UNKNOWNNULL6088504484UNKNOWN4171 LINCOLN WAYLOS ANGELESCA90036-2128GRP-3122null
TPATPA-572022026-10-06T00:57:09ZRebecca—Armstrong1/17/1941-•••-••-4284——4269 Jefferson AveSan DiegoCA92152-··MEDICARE-ADV-A
TPATPA-579052026-07-26T22:49:58ZBradley··—Herrera02/10/2006NULL··—(792) 580-1384BRADLEY.HERRERA@GMAIL.COM3645 MOUNTAIN VIEW DRScottsdaleAZ85286-1199GRP-0273OPTIONS-PPO··
TPATPA-514482026-09-10T07:16:32ZRob—Mathews2003-08-17NULL•••-••-6382—N/A7243 Ocean AveCharlotteNC28231-0653—OPTIONS-PPO
TPATPA-596412026-10-11T13:34:56ZDIANEW.COLLINS1938-01-18—N/A978-423-5205NULL1129 Lake View RoadScottsdaleAZ85263GRP-4005null··
TPATPA-567152026-10-08T15:02:29ZHiroshi—Bkaer9182-11-19-nullnullN/A—N/A———NULL
TPATPA-602232026-09-12T16:12:18ZMark—Howell2000-10-15—-N/A—8095 Bayshore Drive··SAN DIEGOCA92135GRP-2116NULL
TPA TPA-598762026-08-08T22:03:15ZSHIRLEY—FOWLER1979-06-04—NULLnullUNKNOWN5090 Canyon RdEDEN PRAIRIEMN55390·GRP-2696NAVIGATE-HMO
TPATPA-574512026-04-01T03:56:20ZJulia—Carpenter09/16/1939null——NULL997 Baseline RdMesaAZ85262NULL—
TPA TPA-501272026-07-31T14:45:15ZLUIS—SIMS1995-11-24-•••-••-7400N/ANULL2483 HARBOR BLVDCHANDLERAZ———
TPATPA-538292026-03-10T13:45:15ZBrenda··—Jimenez1946-09-24N/ANULLN/ANULL3317 MOUNTAIN VIEW DRAtlantaGA30315GRP-2091—
TPATPA-633422026-01-27T15:39:46ZDENISE—ROBINSON7/14/1985UNKNOWN•••-••-4257828-326-8484N/AN/Anullnull—UNKNOWN—
TPATPA-538502026-02-09T00:26:00ZBradley—Pierce09/12/1994··—UNKNOWN944-797-6638UNKNOWN—NULL—-N/A··N/A
14,474 rows, page 210 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:56.136Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty