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-643802026-01-26T16:51:53Z Joyce—Collins1941-03-23UHC-33766-76null-··4149 Church StEden Prairie··MN55328—UNKNOWN··
TPATPA-527362026-01-28T09:22:09ZRachel—ScottFeb 8, 1967N/A—null—3334 Grand Ave·GlendaleAZ85394GRP-7570··—
TPATPA-533372026-10-11T09:20:33ZDianaI.OilverMar 10, 2002NULLNULL19045452654NULL7663 MAPLE AVE #921··ColumbusOH43222··OPTIONS-PPO
TPATPA-62028 2026-01-17T09:38:40ZLawrence—Fuller··2000-12-09UNKNOWN•••-••-6711UNKNOWN·NULL6647 Church StreetJacksonvilleFL—N/A-
TPATPA-557822026-03-16T01:23:26ZAaron—Rojas08-11-1980null—316-435-2379—-UNKNOWNUNKNOWN—GRP-2167NULL
TPATPA-597112026-07-29T05:13:33ZEric—Hudosn12/3/2008UHC-87974-59—17305204618··8745 CHURCH STMinneapolisMN55422N/AN/A
TPATPA-619902026-04-15T23:34:39ZSTEVENN.··WELCH2002-11-08UHC-34050-08-—null9598 Mountain View DriveAtlantaGA30368—NULL
TPATPA-626292026-05-04T06:23:34ZPrice, David······1938-01-09NULL—(652) 443-4175DAVID.PRICE@ICLOUD.COM7458 BAYSHORE DRIVEColumbusOH43245—MEDICARE-ADV-B
TPA TPA-626922026-08-16T07:31:45ZPena, Gregory——1944-04-24··——(523) 769-8601UNKNOWNUNKNOWN---null—
TPATPA-523172026-05-19T15:03:27ZANA—WHITE4/8/1980-—UNKNOWN-7235 Lake View RdNashvilleTN37290—-
TPA TPA-568892026-08-16T05:33:10ZJUDTH—·HENRY1942-04-05·N/A•••-••-4451—N/A2027 Central AveCharlotteNorth Carolina28271GRP-4604—
TPATPA-603112026-01-06T21:00:26ZHannah—Vazquez2008-07-21null•••-••-1206(468) 577-5622UNKNOWN5714 RIVER RD··DallasTX75295GRP-9901N/A
TPATPA-583292026-10-04T01:59:17ZKYLE—DOMINGUEZ1991-07-17UHC-67063-37•••-••-4861715-939-2477—8407 BROADWAYSan Diego··CA92189-MEDICARE-ADV-B
TPATPA-614762026-02-02T08:50:56ZAisha—Wilson1964-02-01—•••-••-1608NULLAISHA.WILSON13@HOTMAIL.COM2473 Bayshore DriveNASHVILLETN37229GRP-2349MEDICARE-ADV-A
TPATPA-610832026-04-22T20:27:42ZBRITTANY—ROSE2003-08-03UHC-64681-45NULLUNKNOWN—8817 Canyon RdTucson··AZ85723UNKNOWN-
TPATPA-559262026-09-12T11:11:49ZJoan—Dixon·19790725null•••-••-9226····joan.dixon2@icloud.com··9487 Central Avenue·MiamiFlorida33121—N/A
TPATPA-617392026-03-31T06:24:46ZJoyce—Wells18-11-1988UHC-37536-81•••-••-9545735.741.0579joyce.wells@icloud.com3694 Sage CtDALLASTX75215nullOPTIONS-PPO
TPATPA-636752026-08-02T18:06:21ZKAYLA—FOWLER1995-02-26—····544-594-7687—2690 Willow CtGilbertAZ85284-4045null—
TPATPA-531102026-01-06T13:35:27ZTucker, Emma—···1955-10-18N/A-··(359) 611-6766—4116 Market Street··MesaArizona85245····SELECT-EPO
TPATPA-614692026-09-28T11:45:37Zbrucce—mitchell2007-07-23NULL-(689) 482-5630bruce.mitchell@aol.com5344 RIDGE RD #434AustinTX78745null—
TPATPA-637382026-06-28T17:16:02ZElijah—Owens1953-05-21—··4575761718ELIJAH.OWENS@ICLOUD.COM8030 Cedar LaneMESAAZ85278N/ACORE-HMO
TPATPA-515272026-08-18T01:11:18ZMelissa—Garza1988-03-28UNKNOWN··•••-••-7537-UNKNOWN7408 Washington StreetFresnoCA93749GRP-5129NAVIGATE-HMO
TPATPA-538002026-05-02T08:59:55Zwillie—webb2006-09-24——353.689.7247-2644 Grand AveTempeArizona85211——
TPATPA-565422026-08-22T13:56:59ZDeborah—Gonzalez19451114UHC-20343-70•••-••-8286+1 888 556 3042—7023 Grand AveSan DiegoCA92145GRP-9960··N/A
TPATPA-511672026-07-26T01:29:03ZWallace, Sandra——1943-05-15UNKNOWN·-6383857939UNKNOWN9327 Lincoln WayMesaAZ85228nullMEDICARE-ADV-A
TPATPA-622292026-01-07T16:37:37ZPAMELA—HARVEY·11/17/1953—····null—·5210 RIVER RD Apt 25San AntonioTX78252-NULL
TPATPA-590842026-02-21T07:27:21ZJUAN—HUNTER2000-02-24UNKNOWN•••-••-6515N/AN/A7276 Lake View RoadMesaAZ85266N/A-
TPATPA-593852026-04-29T04:32:59ZBenjamin—Dean1953-07-17NULLUNKNOWN(603) 956-1652—·2589 Church StreetDallasTX75278UNKNOWN··-
TPATPA-540702026-04-15T08:08:04ZWAYNE—BRYANT1958-12-15N/A·-(644) 459-8544UNKNOWN7704 JEFFERSON AVENUEEden PrairieMN55341GRP-8042UNKNOWN
TPATPA-565242026-01-26T16:59:33Z JOHN—HENRY1944-01-19·UNKNOWN-UNKNOWN—9524 DESERT SKY BLVD·ATLANTAGA30391GRP-3561-
TPATPA-603002026-06-15T13:57:08Zmichelle—cuok1991-03-23—NULL435.360.2887MICHELLE.COOK99@AOL.COM7428 Church StMESAaz85202··—N/A
TPATPA-634712026-06-13T18:13:43ZEspinoza, Omar——20060805--NULLNULL··9085 BASELINE RDCHANDLERAZ85253N/A-
TPATPA-570362026-03-19T09:55:50Zlori—george1947-08-05····nullUNKNOWNN/A6812 BROADWAY #590TempeAZnullGRP-5764CHOICE-PLUS-PPO··
TPATPA-601242026-02-12T17:41:54Z Kelly—Silva1965-06-28UNKNOWN•••-••-0537UNKNOWN—5859 Spring StEden PrairieMinnesota55313··GRP-3697—
TPATPA-622192026-01-31T18:08:51ZPat—Cole13-11-1969—-UNKNOWNnull6828 Meadow LaneMinneapolisMN55426—·MEDICARE-ADV-B
TPATPA-600532026-05-19T20:57:36ZANN—LEWISNov 20, 1958UHC-13986-22N/A+1 576 669 4339—9751 Mesa DriveCHANDLERAZ85296GRP-1369NULL
TPATPA-562642026-06-16T13:44:10ZCynthia····Bryant1971-11-16UHC-52549-89··UNKNOWN·NULLcynthia.bryant@yahoo.com5310 Washington StreetLos AngelesCA90011—·UNKNOWN
TPATPA-620332026-03-09T01:21:56Z KEVIN—NGUYEN1977-12-18UHC-97416-97-N/Akevin.nguyen44@proton.me3474 PALM DRTempeAZ85282UNKNOWN·SELECT-EPO
TPATPA-622932026-08-17T19:52:53ZDYLAN—COLEJul 1, 2004UNKNOWN——dylan.cole50@outlook.com——NULLNULL··GRP-8895—
TPATPA-627192026-09-22T15:55:32Z·CHRISTINA—GONZALEZ01/23/1968UHC-26758-34nullN/AUNKNOWN87 Sage CtJacksonvilleFL32218GRP-7985null
TPATPA-642612026-08-22T22:43:54ZJerry—Weber2007-02-02··null(698) 576-9670N/A1357 Union StreetEden PrairieMN55317GRP-3262—
TPATPA-621722026-01-05T13:58:36ZDianePWillis1941-02-08NULL•••-••-9511UNKNOWNN/A4367 Park PlGilbertAZ—NULLCORE-HMO
TPATPA-527202026-09-30T10:38:24ZKYLE—WADR05/14/96UHC-48973-10·N/A(828) 332-2137-131 Canyon RoadColumbusOH43227UNKNOWNCORE-HMO
TPA TPA-518842026-07-28T01:34:11Zwalter—torres1979-09-18—NULL(552) 488-1014—8908 Apache BoulevardDENVERCO80271-NULL
TPATPA-54883 2026-06-03T11:45:31ZMEGAN—BURKE1939-06-11UHC-10284-69•••-••-0604(524) 584-4456N/A5123 CAMELBACK ROADPhoenixAZ85099——
TPATPA-541372026-07-08T16:28:25ZKelly—·WagnerMar 1, 1955UHC-43037-05•••-••-4300nullN/A4324 APACHE BOULEVARD··Eden PrairieMN55352null—
TPA TPA-640072026-02-20T13:29:56Zwilliam—vargas28-12-1981N/Anull—-24 FOREST AVEGilbertAZ85207null··MEDICARE-ADV-B
TPATPA-601572026-08-22T12:58:22ZLucia····Day1980-02-11—•••-••-3956N/ALUCIA.DAY44@OUTLOOK.COM8005 SAGE COURT·JacksonvilleFL32278——
TPATPA-575632026-05-07T23:34:23ZSANTIAGO··—FERGUSON1970-12-15UHC-71174-76UNKNOWNUNKNOWN—2728 Hillcrest RdFRESNO·CA93741nullUNKNOWN
TPATPA-594652026-09-05T12:44:29ZdanielleHweaver04/25/75———NULL2761 Maple AveHoustonTX77011——
14,474 rows, page 134 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:46.421Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty