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-572502026-05-05T09:50:19ZJanet—DeanDec 7, 1989N/A——UNKNOWNNULLUNKNOWN··—N/A—SELECT-EPO
TPATPA-569702026-06-06T12:50:34ZVirginiaMMejia1986-09-13NULL—UNKNOWNN/A6665 LAKE VIEW ROADAUSTINTX78706UNKNOWNnull
TPATPA-59446 2026-08-12T13:22:15ZRALPH—ARMSTRONG1981-07-21null—(645) 588-9547UNKNOWN———··UNKNOWNN/A
TPATPA-608642026-10-02T23:08:27ZPaulX.·Evans1972-11-03—-UNKNOWNPAUL.EVANS79@OUTLOOK.COM—·null—-GRP-3770CORE-HMO
TPATPA-593112026-03-20T12:06:53ZALEX—LARSON2005-11-23UHC-49440-40····——8136 ELM STREETSeattle··WA98135——
TPATPA-588142026-07-13T21:00:57ZTerry—·Rodriguez1984-06-25N/A•••-••-19123666159413—7763 MOUNTAIN VIEW DRIVEGILBERT··AZ85264GRP-9646··NAVIGATE-HMO
TPATPA-596872026-07-17T14:40:37ZMorgan, Christina——·12/17/1976·UNKNOWN•••-••-3528null-5685 Cedar LnPhoenixAZ85043N/AN/A
TPATPA-501062026-09-15T02:12:02Zelijjah—pena··07/20/1997··—(637) 428-6005NULL7649 Union StTucsonAZ85794GRP-2846CORE-HMO
TPATPA-561572026-08-22T15:38:29ZJulie—Morgan··1943-06-26N/A-UNKNOWNN/A1606 Baseline RoadGilbertAZ85223GRP-6027OPTIONS-PPO
TPATPA-605732026-09-20T21:28:31ZJeremy—Elliott···1977-09-03UNKNOWNN/A——1576 GRAND AVENUETUCSONAZ85784—SELECT-EPO
TPATPA-522162026-09-27T07:24:09Z·mark··palmer1981-42-25—•••-••-5193+1 530 833 9497NULL1818 Main St Apt 10JACKSONVILLEFL32208——
TPATPA-617012026-08-16T10:55:22ZPatel, Tyler——09-10-1955UHC-72738-99·-UNKNOWNUNKNOWN2695 Hillcrest Rd··DallasTX——MEDICARE-ADV-A
TPATPA-585122026-06-14T02:37:02ZMELISSA—MCDONALD2001-06-20N/A•••-••-4645N/A——nullNULL——null
TPATPA-599072026-10-01T06:50:44ZLarry—Brwon1950-04-06UHC-42189-15•••-••-4916-UNKNOWN9380 MEADOW LANEMiamiFL·33113GRP-0892CHOICE-PLUS-PPO
TPATPA-556702026-07-13T04:16:24ZJOE—RICHARDS19450903UNKNOWN——NULL5655 Ridge RoadMinneapolismn55404··GRP-6122NULL
TPATPA-637472026-01-17T01:33:47ZJesseZ.·Allen1954-12-09—UNKNOWN—NULL··9067 WILLOW COURTSan AntonioTX··78228NULLMEDICARE-ADV-A
TPATPA-557492026-06-29T20:21:40Znatalie—moore1940-10-09·NULLUNKNOWNNULLnatalie.moore@gmail.com4797 Cedar LaneGlendaleAZ85322GRP-9586—
TPA TPA-581472026-08-05T08:26:32Z·bobby—munoz1963-06-04—UNKNOWN780-702-5495null·1341 Palm DriveMIAMIFlorida··33196UNKNOWN—
TPATPA-638022026-01-01T13:47:50ZBruce—Garrett·1962-07-12N/A•••-••-0032·+1 822 330 4412nullUNKNOWN——nullN/AUNKNOWN
TPA TPA-613632026-04-02T18:14:23ZJAMES—LI12/3/2003·UNKNOWN•••-••-7505-NULL823 BAYSHORE DRIVEHoustonTX·77063NULLNULL
TPATPA-521772026-02-09T11:03:18ZMartha····Willis07/20/66—N/AN/A—3212 Bayshore DrGLENDALEAZ85351N/ANULL
TPATPA-590962026-08-01T00:15:07Zandrew—bradley04/22/1951null•••-••-9202—NULL—····NULLUNKNOWNnullUNKNOWN
TPATPA-628562026-08-27T07:06:37Z Olson, AmberZ.—20-06-1965N/A-(660) 244-6586··—-——GRP-4062NULL··
TPATPA-586512026-03-22T08:34:02ZShirley—Rogers·1944-05-12—•••-••-1956-SHIRLEY.ROGERS99@GMAIL.COM6321 Harbor BlvdScottsdaleAZ85292-4127UNKNOWN··MEDICARE-ADV-B
TPATPA-551812026-07-02T12:52:55ZVazquez, Kim··——1959-02-18UNKNOWNnull903-552-7908KIMBERLY.VAZQUEZ7@ICLOUD.COM7007 Church StreetMesaAZ85246-6790nullUNKNOWN
TPATPA-55468 2026-03-02T16:25:37ZShirley····Howard03/21/1995N/A•••-••-9682308.678.2307shirley.howard@proton.meUNKNOWN—UNKNOWNnullGRP-4056SELECT-EPO
TPATPA-583362026-01-21T08:47:47Z·MARIANA—FERGUSON1992-09-24UHC-69580-26N/A(409) 501-0491—3155 Pine DrJacksonvilleFlorida32295UNKNOWNUNKNOWN
TPATPA-563192026-10-04T05:50:48ZELIJAH—STONE1944-04-03——NULL—250 Washington Street #471TempeArizona85206GRP-7294-
TPATPA-597332026-02-19T04:18:02ZBILLY—COLLINS19410606N/A•••-••-0654UNKNOWN—·1834 MOUNTAIN VIEW DR·AustinTX78762——
TPATPA-502892026-03-19T02:24:56Z Logan··—·Ramirez18-05-1944UNKNOWNNULL—UNKNOWN666 Hillcrest RdLos AngelesCA90093GRP-4948-
TPATPA-513562026-09-28T10:41:34Zamanda—fox1992-11-01nullNULL(846) 791-2571—324 HIGHLAND AVENUEEDEN PRAIRIEMN55332GRP-9265—
TPATPA-524952026-07-28T22:32:25ZVictoria—Evans19940326N/AN/A2118074133NULL9661 Forest AveHoustonTexas77068—null
TPA TPA-552452026-02-03T04:53:47ZSarah—Dean09/15/1997UHC-11137-94··•••-••-7785(920) 679-9707··—510 Ocean AvenueFresnoCA93730N/AN/A
TPATPA-61807 2026-07-23T06:02:11ZJason—Wang12/16/1984null--UNKNOWN7758 LINCOLN WAY #350MesaAZ85288NULL—
TPATPA-566692026-03-25T00:54:36ZLisa—Cruz07/10/00null—2583181027N/A6093 Hillcrest Rd #976ScottsdaleAZ85208··—UNKNOWN
TPA TPA-563942026-07-27T21:05:42ZNicole—Perry1952-01-17—•••-••-3514(588) 315-0375·-7253 OCEAN AVENUE Apt 37TampaFL33614GRP-3171··
TPATPA-643942026-03-31T19:47:00Z·Jeremy—GardnerMay 17, 2007UNKNOWNNULLN/A—7452 BASELINE ROADEDEN PRAIRIEMN55347N/A—
TPATPA-577232026-10-17T00:44:38ZCHRISTOPHER—GUERREROAug 4, 1990N/A•••-••-4202—christopher.guerrero61@proton.meN/ANULL——-CORE-HMO
TPATPA-624702026-09-13T09:54:29Zscott—phillips1981-08-18——888-319-0206N/A4082 River Rd Apt 13SacramentoCAN/A--
TPATPA-598482026-06-13T05:57:00ZCarroll, Judy··—··2006-05-42UHC-24401-98—+1 904 829 2620—2492 MOUNTAIN VIEW DRSan DiegoCA92157UNKNOWN—
TPATPA-615022026-09-10T01:21:17ZGibson, Carl—···2005-10-02N/AUNKNOWN··—NULL8206 WILLOW COURTDallasTexas75218nullNAVIGATE-HMO
TPATPA-534722026-02-26T02:40:22ZTyler····Long04/15/81——417-517-7821tyler.long@gmail.com5731 Main StreetSacramentoCA95888—·null
TPATPA-591412026-01-28T04:41:21ZJonathanLVegaMar 24, 1952NULLN/A15986930420····6552 JEFFERSON AVESAN DIEGOCA··92194GRP-5158NULL
TPATPA-596642026-06-16T13:20:50ZDAVID—FORD1991-03-11—-N/A—9634 BASELINE RDColumbusOH43276-MEDICARE-ADV-A
TPATPA-554802026-01-29T20:32:01ZTIMOTHY—WALSH·Jan 6, 1990—•••-••-2196-null1204 Maple AveCharlotte··NC28211GRP-3761CHOICE-PLUS-PPO
TPATPA-559662026-08-22T16:35:23ZSophia—Roerts1977-02-18NULLNULL(616) 253-7893sophia.roberts@icloud.com-—NULL-—····
TPATPA-52390 2026-06-02T06:38:18ZDANIEL—WILLIAMS01-11-1993-UNKNOWN-null8390 Park PlaceMinneapolisMN55408—N/A
TPATPA-533342026-01-07T10:43:13Z·nicole·Tmunoz1973-06-26NULLnull14304153850··—7046 Ocean AvenueLos AngelesCA90027····—
TPATPA-519342026-03-10T08:59:57ZLucia—Wood5/22/1943UNKNOWN—3418749619—8150 PINE DR·FRESNOCA93726—null
TPATPA-623542026-05-23T12:09:46ZKyleE.Wilson··19561022——UNKNOWNUNKNOWNUNKNOWN-—NULL—N/A
14,474 rows, page 247 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:43:00.249Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty