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
TPA TPA-528622026-02-21T09:05:32ZBARBARA····LYNCH1958-02-01—•••-••-8536—N/A8824 MAPLE AVEAUSTINTexas78742UNKNOWNSELECT-EPO
TPATPA-618562026-07-02T13:29:38ZVincent—King14-08-1948N/A-N/AUNKNOWN5963 Valley View DriveTucsonAZ85712NULLSELECT-EPO
TPATPA-532952026-05-29T20:09:22ZDENNIS—SANTOS1998-09-18N/A—UNKNOWNnull2748 Sage Court #382TucsonAZ85743N/ACHOICE-PLUS-PPO
TPATPA-555162026-04-18T08:35:51ZJanetN.Mason1993-12-07—•••-••-1273292-493-9532UNKNOWN—N/A——--··
TPATPA-554572026-02-13T19:46:46ZWEI—DUNN1980-05-05——UNKNOWNUNKNOWN8050 JEFFERSON AVENUEChandler·AZ85220UNKNOWN··
TPATPA-643652026-08-28T02:07:24ZAmanda—BennettJan 8, 2004-—14827629839—·6065 Union StColumbusOH43251—UNKNOWN
TPATPA-605582026-06-12T06:27:39ZKelly—Fox01/15/96NULLN/ANULLUNKNOWN4171 River RoadPlanoTX75013NULL··-
TPATPA-573982026-09-15T08:28:50ZBOBBYASIILVA2007-01-07UNKNOWN•••-••-8169N/A—5119 Hillcrest RdHOUSTONTX77093GRP-4090N/A
TPATPA-638382026-02-03T23:04:06ZDorothy—Sandoval5/25/1994··UHC-73203-21-—NULL1738 MOUNTAIN VIEW DRSeattleWA98108nullnull
TPATPA-533912026-10-11T14:22:41ZJENNIFER—MARTINEZ1975-04-05UHC-86220-05——-3815 Highland AveNashvilleTN37279UNKNOWNMEDICARE-ADV-B
TPATPA-516732026-07-13T02:29:43ZMei—Rogers1954-02-16··•••-••-7004——4173 Pine DriveSan AntonioTexas78273··MEDICARE-ADV-A
TPATPA-532472026-01-18T11:56:10ZKatherine—James2001-09-14—•••-••-5880—katherine.james82@outlook.com6636 Highland AveMiamiFL33180UNKNOWN—
TPATPA-575262026-10-02T05:09:25Z Christina··KFox08/23/1971——(820) 754-4180··NULL8318 Central Ave Apt 3·DallasTX··75209GRP-5139—
TPATPA-554452026-05-04T14:06:18ZJNAICE··HANSON12/14/66——850.714.3700N/A5303 Willow CourtTempeArizona85271N/A-
TPATPA-590212026-06-11T07:36:40ZDenise—Ramos19601210—•••-••-3774NULLdenise.ramos@icloud.com899 FOREST AVE··DenverCO80256GRP-6240navigate-hmo
TPATPA-637982026-03-20T20:52:54ZSophia—Daniels06-05-1983null—NULLNULL9788 JEFFERSON AVEDENVERco80275GRP-3411UNKNOWN
TPATPA-516472026-01-06T17:59:17ZTIMOTHY—BURKE1988-05-14UNKNOWN—7362722708timothy.burke@icloud.com—··——NULL-
TPATPA-517422026-05-10T22:55:33ZBrenda—Dominguez09/27/1938——+1 977 437 3997-2854 MAPLE AVEMiamiFL33120GRP-4546—
TPATPA-558302026-10-14T03:33:52ZThomas—Mendoza2007-04-23··NULLN/A+1 863 993 6816N/A4060 GRAND AVENUEEden PrairieMN55393UNKNOWNNULL
TPATPA-509012026-04-13T04:15:09ZRAY—SCOTT1988-07-05N/A•••-••-55692233122221—7866 Lincoln WayDenverCO80228-4616—UNKNOWN
TPA TPA-526172026-04-29T22:58:31Z ·jose—ellitt2004-11-26null———1677 OAK STSan DiegoCA92172-CHOICE-PLUS-PPO
TPATPA-540152026-03-19T14:29:03ZFRANCEST.SIMPSON2006-12-03—•••-••-17523447894435—4657 Forest AvenuePlanoTX75084NULL—
TPATPA-534472026-10-14T03:37:09ZEmily—Ellis2001-01-27UHC-19306-54—931.595.9115—321 Sage CtAustinTX78748N/AN/A
TPATPA-605972026-06-10T11:40:04ZChristopher—Willis·1980-03-14——767.914.2678null788 WILLOW CTLas VegasNV89153-7711GRP-6631NULL
TPATPA-530162026-02-08T19:11:59ZEdwards, Susan——1977-01-25——null—1215 Ridge RdOrlandoFlorida32867—UNKNOWN
TPATPA-63884 2026-08-07T15:19:21ZDenise—Pena2001-09-06UHC-12515-52--UNKNOWN5007 PINE DRMIAMIFL33107N/AN/A··
TPATPA-574772026-03-10T11:50:17ZELIJAH—RICHARDSON4/2/1951UHC-63367-57•••-••-8489··—3875 PARK PLACEOrlandoFL·32864GRP-8781SELECT-EPO
TPATPA-551702026-06-07T00:08:51ZMelissaJ.JordanOct 21, 1981—-UNKNOWNN/A1628 Central AveMesaArizona85235GRP-4732OPTIONS-PPO
TPATPA-517952026-02-12T15:47:44ZAMBER—COLEMMAN7/20/1948null--AMBER.COLEMAN96@PROTON.ME··1524 MARKET STREETDALLASTX75203nullNULL
TPATPA-50160 2026-10-08T11:47:10ZEthan—BurtonJul 6, 1962-N/A7365372560····UNKNOWN—NULLN/A··nullUNKNOWN
TPATPA-544112026-04-18T09:18:31ZSims, Julie——Feb 25, 1980—··512-694-4707julie.sims86@yahoo.com4819 Valley View DrSan AntonioTX78220——
TPATPA-504792026-10-02T16:31:55ZJANET—SANCHEZ2007-08-22—•••-••-2732——3187 HILLCREST RDTucsonAZNULL-N/A
TPATPA-612672026-09-25T23:53:40ZCharlotte··—Nichols5/19/1970····NULL8148244059N/A3495 Market StreetCOLUMBUSOH43209NULLMEDICARE-ADV-A
TPATPA-63965 2026-01-09T05:14:25ZKathleen··—Duncan1977-11-23null-—UNKNOWN8069 UNION STREETTempeAZ85237—SELECT-EPO
TPATPA-504962026-05-06T10:43:27ZEMMA—ESPINOZA1997-02-19-•••-••-4506(616) 345-0128emma.espinoza27@icloud.com··4704 Desert Sky BoulevardTucsonAZ85742-7912NULL··
TPATPA-591312026-08-27T13:16:57ZSEAN—GARRETT1996-12-05NULL—··UNKNOWNUNKNOWN··—null—-—
TPATPA-633302026-04-27T05:48:58ZJennifer··—Ross1955-10-05UHC-16794-05·null17053257982—N/AnullUNKNOWN—nullnull
TPATPA-635682026-06-07T17:37:45ZLaurenVPeterson2006-01-26null•••-••-4124NULL—3468 CHURCH ST·FresnoCA93784—MEDICARE-ADV-A
TPATPA-62212 2026-07-14T12:28:50ZJustin—Barnes1967-11-25N/AN/A17253477336null7470 Valley View Dr·SeattleWA98115GRP-9912·UNKNOWN
TPATPA-56649 2026-09-27T16:08:19ZSTEPHANIE—MORGAN1958-01-03UHC-25527-15—728-210-8827—338 Valley View DriveTempe·AZ85252-2801··N/Anull
TPATPA-572942026-03-05T07:09:35ZZACHARY—BAKERJul 16, 1988——····N/A6101 Desert Sky BoulevardOrlandoFlorida32814··N/A··
TPATPA-52344 2026-02-09T20:07:30ZLUISWHILLOct 27, 1942N/A•••-••-7985NULL—7828 Meadow LaneGILBERTAZ·85271GRP-6338—
TPATPA-620592026-01-18T18:17:44ZSAMUELF.WEAVER··10-11-1995N/ANULL5384415522—7528 Central AveMESAAZ85233—N/A
TPATPA-511252026-09-19T10:32:56ZJULIE····WILSON07-03-1938·null•••-••-9365—NULL5092 Park PlaceTEMPEAZ85291NULLnull
TPATPA-633792026-06-16T21:17:50Z·pamela—wallace1988-03-20-··•••-••-1069-—8337 BAYSHORE DRTEMPEAZ85298null—
TPATPA-634852026-07-18T17:05:00ZJordan, Wei——1988-12-16-——-5392 UNION STNashvilleTennessee37240null—
TPATPA-589302026-02-12T04:51:08Zsandra—kelley··1960-02-27UNKNOWN—3683386402null6943 Lincoln WayTucsonAZ85705-8439—UNKNOWN
TPATPA-621412026-08-31T10:30:51ZMargaret—GonzalesNULLUHC-59119-32•••-••-0145nullMARGARET.GONZALES75@OUTLOOK.COM6102 VALLEY VIEW DRORLANDO·FL32807·N/Anull
TPATPA-606942026-04-23T02:40:28ZLawrence—Carpenter··19480425UNKNOWN•••-••-2945—N/A132 Valley View DrColumbusOH43281GRP-0862—
TPATPA-623702026-03-21T16:56:35ZEmily····Sullivan··08/05/40NULL—445-763-2597emily.sullivan84@yahoo.com5479 BAYSHORE DRSeattleWA98181GRP-7829NULL
14,474 rows, page 125 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.078Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty