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-535102026-08-13T07:57:51ZNATALIE—PIERCE01/28/1939-•••-••-3972-natalie.pierce56@aol.com9679 WASHINGTON STGlendaleAZ85315GRP-8452OPTIONS-PPO
TPATPA-586312026-02-06T23:53:09ZHANNAH—MORALES2008-03-17··——(636) 316-0943N/A3620 Main StreetAtlantaGA30316GRP-0686··CHOICE-PLUS-PPO
TPATPA-562652026-09-14T13:57:26ZDonna—Howard27-07-1944UHC-14213-46null328-622-2434N/A5111 BAYSHORE DRIVE Apt 37TampaFL33675··—CHOICE-PLUS-PPO
TPATPA-635532026-08-31T09:19:48ZJOSE··HARVEY26-03-1970UHC-69584-36—-N/A8072 Oak StreetHoustonTexas77063N/A-
TPATPA-509372026-02-06T03:27:27ZZachary—Rios1954-01-02N/ANULL3345041391zachary.rios28@aol.com5006 Baseline RoadGilbert··AZ85225NULLOPTIONS-PPO
TPATPA-525612026-01-20T19:04:52ZDORIS—ROBERTSON··1951-03-03N/A-——1581 Canyon RoadHoustonTX77097-1740—N/A
TPATPA-594892026-02-26T04:11:51Z·Terry, Li··—1965-05-07——462-337-7466-8628 Oak StreetSan AntonioTX78245—·NAVIGATE-HMO
TPATPA-582152026-05-31T22:01:09ZDEBORAH—SIMPSON1939-04-23NULL·NULL—N/A5622 Forest AveNashvilleTN—UNKNOWNMEDICARE-ADV-B
TPATPA-590252026-01-07T17:29:53ZDIEGO—JIMENEZ2005-03-07-UNKNOWN-·diego.jimenez@hotmail.com6107 Palm DrHoustonTX77097GRP-1007UNKNOWN
TPATPA-570042026-08-23T12:29:34ZJohnston, Alexander——2006-02-24—-·NULLnullUNKNOWNN/A—-GRP-4198medicare-adv-b
TPATPA-578932026-05-31T21:59:10ZLuucas, Paul——1946-06-15—··UNKNOWNpaul.lucas@aol.com3616 CAMELBACK ROADJacksonvilleFL32262—N/A
TPATPA-616092026-07-15T13:26:17ZVINCENT—WILLIS10/01/2004UHC-89971-40UNKNOWN5769051599·vincent.willis46@gmail.com1003 BAYSHORE DRPlanoTX75006··NULLnull
TPATPA-583532026-04-05T18:52:13Zmartha—boyd20-06-1977N/A•••-••-4618NULLmartha.boyd@proton.me-—··—GRP-8109N/A
TPATPA-575372026-04-18T01:20:11Zcamila—hamilton25-08-1959—UNKNOWN803-936-7556CAMILA.HAMILTON@OUTLOOK.COM-··NULL····N/ANULLNULL
TPATPA-629612026-01-21T18:09:19ZSTEVENS—VALENITNA1943-01-26—····N/AUNKNOWN8592 MOUNTAIN VIEW DRHoustonTX77011N/AN/A
TPATPA-635052026-04-26T05:07:44Z·HAROD—HOWELL01/19/39—•••-••-4093··harold.howell@yahoo.com300 Washington StNASHVILLETN37219—·MEDICARE-ADV-B
TPATPA-602802026-04-26T00:23:22ZJonathan—Peterson1958-09-11—•••-••-1156(370) 210-7906—8169 Sunset BlvdHoustonTX77071NULLNULL
TPATPA-516842026-07-01T03:26:11ZGabril—Fisher··1962-02-02··—UNKNOWNNULLUNKNOWN3157 Baseline RdChandlerAZ85283—-
TPATPA-61869 2026-07-12T19:53:21ZMichael··Santos2003-07-12N/A•••-••-6031·UNKNOWNmichael.santos@icloud.com··7101 SAGE COURTMiamiFL33125—NULL
TPATPA-502092026-06-05T13:19:06ZOrtiz, Judith——1/5/1981N/A—7199290UNKNOWN9287 Camelback RdGilbertAZ85216nullUNKNOWN
TPATPA-514392026-07-07T23:50:05ZKeith—Bennett1990-05-26·NULL——-1922 Ocean AveJacksonvilleFL32227GRP-8816UNKNOWN
TPATPA-533752026-02-25T11:39:23ZEspinoza, Arthur——2003-07-16—-NULLUNKNOWN9292 Indian School RdTampafl··33690GRP-7153null
TPATPA-51507 2026-03-06T14:57:28ZJoyce—Freeman·18-06-1965NULL—9458006271NULL8327 Main StPlanoTX75010GRP-7492MEDICARE-ADV-A
TPATPA-555882026-04-02T16:22:15ZJustin—Wilson·1974-03-27—UNKNOWN19504625876NULL5123 Camelback RoadPlanoTX75001GRP-7095CHOICE-PLUS-PPO
TPATPA-515672026-04-01T16:51:13ZJoseph—Cunningham10-09-1939UNKNOWN•••-••-41339199684150joseph.cunningham16@proton.me979 Bayshore DriveMinneapolisMinnesota55495-4944-OPTIONS-PPO
TPATPA-503092026-09-13T22:41:07ZEvelyn—Brooks03-05-1949NULL··N/AUNKNOWNNULL9160 Forest AvenueScottsdaleAZ85239—null
TPATPA-517392026-06-26T03:29:40ZGomez, Judy——1977-08-18UHC-18172-29·N/A··-8411 Canyon RoadOrlandoFL32840N/A—
TPATPA-618192026-10-10T00:12:19ZMENDOZA—REBECCA03/10/2006··•••-••-1980-—9585 Baseline RoadHOUSTONTX77094—-
TPATPA-580662026-09-13T00:26:21ZDAVID—VARGAS1987-01-14——842.641.3232david.vargas@aol.com8035 Lincoln WaySan AntonioTX78208NULL··CHOICE-PLUS-PPO··
TPATPA-536242026-01-27T13:35:28ZJordan—Richards19500909null··—--8419 WASHINGTON STSacramentoCA95847—null··
TPATPA-612752026-04-14T11:39:00Z Denise—Adams1990-18-09-UNKNOWN863-857-1973UNKNOWN—-—--··NULL··
TPATPA-534322026-09-08T09:37:17ZCarol—Garrett2/27/1971—UNKNOWN··—carol.garrett@proton.me5161 VALLEY VIEW DRFresnoCA93785GRP-5939NAVIGATE-HMO
TPATPA-564142026-06-23T15:34:16ZAnderson, Sofia——1984-01-21NULL—(316) 577-8943—UNKNOWNUNKNOWN—NULLnullN/A
TPATPA-531132026-07-04T04:28:53ZFrankKBowman1976-05-12UHC-05898-40N/A(840) 341-2160FRANK.BOWMAN@ICLOUD.COM····nullNULL——OPTIONS-PPO
TPA TPA-565922026-08-28T05:37:30ZWallace, Eugene——Jun 16, 1942UHC-99190-14-2207335096··-8878 Baseline RdJacksonvilleFlorida32219-MEDICARE-ADV-A
TPATPA-615082026-08-02T07:00:38ZDEBORAH—WEBB14-01-1980—•••-••-3911N/A·N/A305 Desert Sky BlvdEden PrairieMN55336null—
TPATPA-542732026-09-04T23:32:30Z Hiroshi—Rice9004-19-47null—nullnull5783 OAK STJacksonvilleFlorida32271N/A—
TPATPA-503532026-07-26T00:43:15ZPriya—Collins1938-07-18nullnull217-371-3753-2440 Sage CtHOUSTONTX77014N/ACORE-HMO
TPATPA-543832026-10-17T08:33:35Z·CHRISTIANX.BOWMAN2007-09-01··NULL-555.876.7508christian.bowman@hotmail.com9778 Willow Court #486·Las VegasNV89171GRP-6886OPTIONS-PPO
TPATPA-615212026-07-08T18:38:17Z·DENISE··DANIELS1988-07-27UNKNOWN•••-••-9097UNKNOWN··denise.daniels@proton.me6417 BASELINE RDGlendaleAZ85307—UNKNOWN
TPATPA-602752026-05-08T16:04:39ZMADISON—KELLY05/25/52NULLN/A—N/A5238 Sage CtNashvilleTN37275GRP-2691null
TPATPA-526372026-10-07T20:16:57ZMARI—DANIELS1982-10-09N/ANULL-null5183 SUNSET BOULEVARDFresnoCA93783—MEDICARE-ADV-A
TPATPA-561552026-03-14T04:13:10ZFatima—James09/04/88UHC-47242-02——NULL5401 Market StFresnoCA93774—NULL
TPATPA-564772026-08-13T04:10:53ZSteven—George1971-03-07uhc-39607-73··•••-••-8328(816) 534-2757steven.george@proton.me1231 PARK PLLos AngelesCA90067-null
TPATPA-513032026-01-24T14:42:18ZGilbert, Aaron——1981-09-11UNKNOWNnull533-518-7121-UNKNOWNNULL——GRP-6079·SELECT-EPO
TPATPA-548312026-03-06T13:51:49ZDORIS··EYANG1968-12-03UNKNOWNN/A2282448221UNKNOWN——UNKNOWN-GRP-0195·MEDICARE-ADV-A
TPATPA-547652026-10-06T17:00:17ZWillieBGonzales··2008-09-23UHC-76085-13•••-••-1484·UNKNOWNN/A·4425 INDIAN SCHOOL RDAustin·TX78795GRP-8015null
TPATPA-564522026-10-02T19:46:47ZPatrick—Long17-01-1952nullUNKNOWN(628) 905-1336—7892 Ridge RdSan AntonioTexas78231—UNKNOWN
TPATPA-54932 2026-04-02T16:40:45ZZachary—Thmpson2/24/1959nullN/A+1 811 250 5484—320 Washington StTampaFL··33695—CORE-HMO
TPATPA-517612026-02-14T02:57:39ZRYAN—JIMENEZ1955-06-10-—276.509.5753N/A2708 Forest AvenueDenver··Colorado··80294····null
14,474 rows, page 4 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-19T19:54:25.419Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty