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-621112026-09-27T18:54:13ZKAREN—FOLER1990-05-23———KAREN.FOWLER@AOL.COM1888 Forest AvenueTAMPAFL·33646GRP-8864MEDICARE-ADV-B
TPATPA-546582026-06-26T02:38:53ZKEITH—CAMPBELL1962-05-19UHC-28637-30—484-398-8297UNKNOWN5441 Meadow LaneNashvilleTN37234—N/A
TPATPA-524972026-09-25T13:45:13ZJackie—Fowler·12/16/1999UHC-41947-43NULL-NULL1885 Central AveJACKSONVILLEFLNULLGRP-7545options-ppo
TPATPA-602052026-07-02T14:32:24Z william—knightFeb 10, 1941UNKNOWN•••-••-7848(353) 587-9695UNKNOWN267 Grand AvenueLos AngelesCA·90070GRP-7234N/A
TPATPA-534502026-08-23T08:14:46ZmarkD.moore1944-12-06UHC-67771-87•••-••-6926NULL·mark.moore@yahoo.com8179 Ridge RdColumbusOH43210null··MEDICARE-ADV-A
TPATPA-561922026-07-29T23:31:01ZVictoria—Reyes1942-11-19N/AUNKNOWN716-395-6279—8842 Valley View DrJacksonvilleFLUNKNOWNNULL··
TPATPA-554072026-02-07T00:34:45ZGomez, Alice··——1942-11-04UNKNOWN··——····6767 BASELINE RDTempe··AZ85258N/A—
TPATPA-603532026-07-07T09:05:27ZColeman, Raymmond——1973-12-01UNKNOWN•••-••-9312——3854 Elm Street··Charlottenc28227nullMEDICARE-ADV-A
TPATPA-511012026-10-06T07:45:14ZGraham, Janet··A—1/5/1965—•••-••-0341+1 207 564 3692-7239 Lincoln WayPHOENIXAZ85034——
TPATPA-609402026-02-28T19:50:33ZBenjamin—Henry2080-01-09—nullNULL—6289 Desert Sky BoulevardPlanoTX75093nullNAVIGATE-HMO
TPATPA-536422026-04-09T03:06:42ZLISA··—MORRIS··08/12/1996——2968291428——N/A·UNKNOWN——OPTIONS-PPO
TPATPA-549882026-09-25T22:03:52ZNICHOLAS····SANDERS1987-06-19—null(947) 907-0006UNKNOWN··7213 PINE DRIVE Apt 24HoustonTX77036—MEDICARE-ADV-B
TPATPA-576592026-07-31T09:36:11ZRuth—Meyer1986-12-01——8385854963—2426 FOREST AVECHARLOTTENorth Carolina———
TPATPA-548702026-05-26T08:43:17Z·LORI—GARCIA·1993-06-24UHC-39221-56—····N/A988 SAGE CT #598TAMPAFL33691—NULL
TPATPA-510592026-03-22T08:20:29ZDEBORAH··LOPEZ1956-08-23null•••-••-1535——7127 Jefferson AveMiamiFL33123UNKNOWN—
TPATPA-626002026-01-07T07:06:15ZMorris, Abigail··—9170-06-04——N/AnullNULL—null—N/AUNKNOWN
TPATPA-602672026-05-19T09:00:40ZPamela, Grifffin··U—1985-08-14UNKNOWN-(668) 869-1862-8907 Camelback RdTempeAZ85210GRP-8906-
TPATPA-590772026-03-06T14:04:14ZNiccholas—Campbell2004-08-21null•••-••-6739N/ANULL5205 Elm StScottsdaleAZ85202nullCORE-HMO
TPA TPA-562982026-04-13T04:10:24ZJOEY—NUNEZJul 7, 1942null•••-••-7564NULL—219 BroadwaySAN ANTONIOTX78264GRP-8023—
TPATPA-547312026-03-08T00:26:01ZMarilyn—Reyes1964-03-28nullUNKNOWN——8962 Elm StreetHOUSTON·TX77055-N/A
TPATPA-533952026-05-01T06:56:38ZWayne····Matthews04/24/02-—NULLwayne.matthews13@aol.com3219 DESERT SKY BOULEVARDLos AngelesCA90027-··null
TPA TPA-60090 2026-07-16T05:18:34ZWAYNEYWATKINS1997-09-27UNKNOWNNULL—wayne.watkins15@yahoo.com2153 OCEAN AVENUE··SeattleWA98130——
TPATPA-561842026-04-21T07:43:09ZMARK····GARZA19460707UNKNOWN•••-••-65975268755930N/A7320 Washington StreetCharlotteNC28201··——
TPATPA-628872026-04-12T21:24:40ZSusan··—Hanson1982-10-01—•••-••-7303nullnull··4755 Maple AvenueMinneapolisMN55488nullMEDICARE-ADV-B··
TPA TPA-618302026-01-30T09:03:46ZWAYNE—MILLER1938-11-24UNKNOWN•••-••-439015936845565····1462 Union Street··TucsonAZ85749—UNKNOWN
TPATPA-522712026-01-28T09:10:35ZVIRGINIA—ORTIZ03/22/08N/AN/ANULL—8997 BroadwayDenverCO80228UNKNOWNN/A
TPATPA-57925 2026-10-09T12:58:36ZDrewL.Simmons1996-11-15UNKNOWNUNKNOWN—·UNKNOWN1958 Valley View DriveDenverCO80241GRP-4083·UNKNOWN
TPATPA-639272026-01-16T00:56:32ZAhmed····Young1946-04-02—·UNKNOWNNULL—1525 PINE DRSCOTTSDALEAZ85226UNKNOWNN/A
TPATPA-604932026-10-12T18:06:51ZKEVIN—FOWLER01-10-1963null•••-••-3690N/AUNKNOWN5151 Valley View DrCHANDLERAZnullNULLN/A
TPATPA-560222026-01-10T08:34:23ZWillie—·Owens20080907—UNKNOWN-N/A4477 CENTRAL AVENUEColumbusOH43244NULL—
TPATPA-594942026-07-19T03:47:17ZCarpenter, Frank——·19990227—····UNKNOWNN/A1999 Cedar LaneAustin··TX78737—·MEDICARE-ADV-B
TPATPA-627092026-04-25T13:44:46ZPriyaL.Phillips1984-06-03NULLUNKNOWNNULL—1868 HILLCREST ROADMiamiFL33156—UNKNOWN
TPATPA-527662026-10-11T09:52:52Zsophia·Zlynch1967-10-21—•••-••-7048nullsophia.lynch27@hotmail.com--—nullGRP-9630null
TPATPA-527692026-01-22T06:07:25ZLarryKHall1976-01-12·null——larry.hall64@icloud.com2039 MAPLE AVENUETUCSONAZ··85739UNKNOWN—
TPATPA-561202026-10-14T23:21:21ZCHRISTIANF.OWENS1962-06-09N/ANULL-UNKNOWN1675 Sage CtDenverCO80281NULLNULL
TPATPA-585902026-06-23T14:03:47ZLINDA·CSALAZAR7/21/1972··•••-••-1577null··—NULLN/A··—NULL·UNKNOWNN/A
TPATPA-523802026-02-14T23:11:46ZHannah—·Garrett09-01-1993—-+1 605 765 0156null478 Sunset BoulevardMinneapolisMN55493—UNKNOWN
TPATPA-591202026-05-25T03:48:55ZSara—Santiago1996-01-19—null——2345 VALLEY VIEW DR Apt 19DenverCO80251null··CORE-HMO
TPATPA-625932026-06-29T07:39:49Z·philip—red1951-08-10—•••-••-8277NULL··PHILIP.REID@HOTMAIL.COM3340 Palm DriveNASHVILLETN·37237—OPTIONS-PPO
TPATPA-608592026-01-03T22:34:47ZJasun—Ryan1987-10-14UNKNOWN—-··—4329 Lincoln WayPhoenixAZ85029—-
TPATPA-552172026-05-12T12:42:29ZJUAN··—FREEMANFeb 23, 1958UHC-45689-44•••-••-0013null—4017 Forest AveOrlandoFL32823GRP-4376-
TPATPA-61517 2026-02-12T09:09:17ZLAUREN—CONTRERAS15-01-1976null•••-••-1337-—2727 Forest AvenueGilbert··AZ·85257-6481-UNKNOWN
TPATPA-640972026-05-22T09:01:21ZMichaelC.Kim··1981-08-12nullUNKNOWN(900) 970-1989··—351 UNION STAustinTexas78787NULLUNKNOWN
TPATPA-615252026-10-13T21:28:52Zmartha—snyder1990-05-08N/A—NULL·null6526 BroadwayPlanoTX75074NULLNAVIGATE-HMO
TPA TPA-519062026-09-09T23:56:24ZTeresa—George1971-06-02—•••-••-5674498-560-3209—1320 Ridge RoadSan DiegoCalifornia92124NULL—
TPATPA-636892026-06-14T16:09:10ZKaren—Thomas2005-11-05-N/A13516962268·N/AUNKNOWNNULL·-—GRP-7804—
TPATPA-599822026-03-20T14:07:53Z·Bobby—Simpson1980-03-27····null··6924850062bobby.simpson@gmail.com4772 HIGHLAND AVENUETempeAZ85220·NULL—
TPATPA-560182026-10-01T08:28:08ZRYAN—HARVEY1976-06-26UHC-08814-34—N/A··—5411 HARBOR BLVDMesaAZ85272GRP-3500-
TPATPA-522582026-07-01T16:24:43Zsophia—andersonMay 23, 1944NULLN/A-sophia.anderson50@hotmail.com2387 Sage CourtHoustonTX77074UNKNOWN—
TPA TPA-589192026-02-08T04:40:01ZTyller—Li1940-02-08——NULLUNKNOWN3573 Grand AveLAS VEGASNV89111nullNULL
14,474 rows, page 232 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.328Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty