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-641232026-01-29T01:50:04Z·Randy—Parker19521017null—13703645919NULL··5505 GRAND AVEHoustonTX77013GRP-8129UNKNOWN
TPATPA-516162026-01-05T21:06:09ZJESSGRIOS1950-07-04nullNULL(634) 822-1949JESSICA.RIOS@OUTLOOK.COM552 SPRING STREETCharlotteNC28238··GRP-8871—
TPATPA-632722026-05-07T14:02:51ZCHRIS—·PHILLIPS9189-02-18N/A······7283023079—3969 Hillcrest RdGILBERTAZNULL—-
TPATPA-61972 2026-07-18T03:15:50ZCAROLYN—LONG1941-01-20-•••-••-0019null·carolyn.long89@yahoo.com2878 MARKET STREETAustinTexas·78742—N/A
TPATPA-610102026-01-05T11:25:25ZNOAH—MENDOZA·1975-08-12null-13199880516-4158 VALLEY VIEW DRIVEPhoenixAZ—null—
TPATPA-636922026-05-01T16:48:51ZJack··—Morris1944-06-09UNKNOWNN/A——9062 FOREST AVENUESeattleWA98182GRP-0152N/A
TPATPA-562042026-10-02T18:02:31Zelijah—hudson1967-07-17null•••-••-2848··—4748 APACHE BLVDNashvilleTN37226GRP-4547MEDICARE-ADV-A
TPATPA-573642026-03-09T20:28:54ZJORDAN—RAMIREZ28-10-1985N/A•••-••-34424638726516JORDAN.RAMIREZ@ICLOUD.COM·3884 MOUNTAIN VIEW DRTAMPAFL33671GRP-9412SELECT-EPO
TPATPA-622112026-07-12T22:23:45ZJUSTIN—BARNES··1967-11-25—····7253477336-7470 Valley View DriveSeattleWA98115——
TPATPA-584662026-06-18T19:33:28ZLogan······Ward1949-05-04UHC-80647-46-nullN/A2233 Cedar LanePlanoTX75051null—
TPA TPA-579232026-09-16T01:02:59ZAndrew—Simmons1996-11-15-—4038688829UNKNOWN1958 VALLEY VIEW DRIVEDenverCO80241—null
TPATPA-519742026-06-05T01:06:54Zlawrence—ferguson2/9/1995—nullN/A-8245 Canyon RoadDallasTX75289GRP-7789—
TPATPA-640142026-07-08T19:17:07ZLogan—Clark1996-08-06—•••-••-5467—N/A3642 Meadow LnLas Vegasnv89183-·UNKNOWN
TPATPA-556782026-07-04T10:31:45ZBobby··—Long1978-05-14N/A•••-••-0624UNKNOWN—6499 Desert Sky BlvdCharlotteNC28255GRP-6726—
TPATPA-558382026-08-28T05:46:44ZSUSAN·····KINGNov 7, 1980—•••-••-1015UNKNOWNN/A7530 APACHE BOULEVARDScottsdaleAZ85212-9685—UNKNOWN··
TPATPA-526132026-09-08T08:55:14ZJack··Harris01-11-1949null•••-••-5491UNKNOWNjack.harris@aol.com3975 Cedar LanePlanoTX75093····OPTIONS-PPO
TPATPA-586252026-09-07T00:57:36ZEMMA—RUIZ04/02/1990··—•••-••-4257-··null4087 BROADWAY Apt 13AtlantaGA30376····CHOICE-PLUS-PPO
TPATPA-630832026-04-01T02:50:32ZTONY—CUNNINGHAM1940-06-28—NULL13313958903UNKNOWN——N/ANULLGRP-0217-
TPATPA-604852026-08-25T19:48:24ZPhilip—Sanchez2003-06-24NULL—UNKNOWNUNKNOWN8972 Church StGilbertAZ85203GRP-6643UNKNOWN
TPATPA-514362026-01-11T18:36:07ZBeverly—Flores9/2/1948—•••-••-7045nullnull107 PINE DRLas VegasNV89148GRP-0164··null
TPATPA-510132026-08-10T05:51:47ZRANDY—HARRISON1985-11-20—•••-••-4719712-455-2893N/A··5559 SAGE CTChandlerAZ85226GRP-5931N/A
TPATPA-576492026-05-21T10:45:51ZJudith—Castro1946-06-18NULL—····NULL9281 Baseline RoadSan DiegoCA92180——
TPATPA-532392026-07-04T11:01:07ZArthhur—Gilbert1963-09-27N/Anull-NULL3720 Sage CourtFresnoCA93775UNKNOWNUNKNOWN
TPATPA-575192026-09-21T16:56:22ZGreene, Lawrence——01/10/1988—•••-••-9710(290) 919-5527nullUNKNOWNnull····—null—
TPATPA-510392026-02-01T11:56:42ZElizabeth··Freeman9/3/1945··-———3288 Valley View DrDenverCO80200·······OPTIONS-PPO
TPATPA-550372026-03-16T10:24:07ZCharles·····Liittle1951-04-09————2376 Washington StreetFresnoCA93740NULL··
TPATPA-566352026-10-03T18:20:29ZALBERT—HALL1981-10-24nullNULL·NULL··8750 Central AveTAMPAFL33654GRP-9430UNKNOWN
TPATPA-512242026-10-10T10:53:53Z OLIVIA—CHPMAN1/18/1975UNKNOWNNULL—nullN/A—N/A—GRP-0269—
TPATPA-577032026-02-27T03:58:17ZSHIRLEY—LARSON3/1/2002UHC4072843—(377) 789-3684—3209 WASHINGTON STREETColumbusOH43206——
TPATPA-572422026-01-13T08:00:55ZEMMA—PATEL·19761005N/A——NULL5189 River RoadCharlotteNC28284GRP-3296N/A
TPATPA-613892026-06-28T11:50:27ZAUSTIN—ORTIZ1999-03-27—UNKNOWNNULL—null—nullnullN/AN/A
TPATPA-531412026-04-23T16:56:30ZEric—Li1950-05-15-—7388743624ERIC.LI83@GMAIL.COM8657 Ocean AveFresnoCA93773-CHOICE-PLUS-PPO
TPATPA-543292026-01-24T06:55:47Z·Larry—AlvaradoMay 4, 1978——718-776-7150··UNKNOWN3582 Church StGlendaleArizona85361—NULL
TPATPA-558252026-07-28T23:26:52Zdavid····lynch1959-02-27UNKNOWN•••-••-3978NULL—4340 River RdTEMPEAZ85232NULL—
TPATPA-576642026-07-13T02:27:03ZAustin, Charlotte——0630-19-86null····NULLN/A4548 Spring St #115JACKSONVILLEFlorida32269—null
TPATPA-577882026-01-08T12:51:50ZNancy··Williams1983-09-13··—-—-4029 Harbor Blvd Apt 32DALLASTX75225UNKNOWN·OPTIONS-PPO
TPATPA-524132026-07-21T17:07:37ZEstrada, Shirley——1982-10-07NULL——UNKNOWN1380 Mountain View DriveTempeAZ85202—UNKNOWN··
TPATPA-577382026-02-18T21:46:18ZJohn—Romero19900219NULL•••-••-7126NULLnull5768 Lincoln WayPHOENIXAZ—N/AUNKNOWN
TPATPA-611872026-02-17T00:43:37ZVirginiaA.Burns1953-06-27—•••-••-8043N/A··UNKNOWN6890 Hillcrest RdChandlerAZ85241-null
TPATPA-604262026-08-23T08:36:07ZAshley—Wong5/8/1981—•••-••-4232····—3178 Baseline RdHoustonTX77083-7360UNKNOWNSELECT-EPO
TPATPA-612272026-06-12T12:03:33ZLOGAN—HOFFMAN1944-05-19·····UNKNOWN——NULLNULLUNKNOWNUNKNOWN—null
TPATPA-561122026-07-08T05:39:36ZCAROL—CRAWFORDSep 14, 1980··UHC-16231-67-—·UNKNOWN9283 Indian School Road·ScottsdaleAZ85247—N/A
TPATPA-571442026-02-07T03:12:49ZJACOB—JENSEN1944-06-02—•••-••-5963—null3352 Mountain View DriveLas VegasNevadaN/A——
TPATPA-501942026-06-18T09:22:22ZSarah—Patterson2000-04-06····•••-••-9677NULL·-—--———
TPATPA-62624 2026-10-09T15:03:46ZANGELA—BURNS1959-02-14UNKNOWNnull4909447303—·8684 Ridge RoadEDEN PRAIRIEMN55350-8634—·null
TPATPA-587712026-06-17T12:14:46ZELIJAH—ADAMS1968-01-13NULLUNKNOWNnullnull4148 Highland AvenueDenverCO·80274GRP-2262—
TPATPA-609802026-10-13T05:32:32ZHarrt, Isabella·L.—·Mar 17, 1975·UHC-19333-94UNKNOWN··UNKNOWNN/A4604 Jefferson AveGlendaleAZ85372——
TPATPA-522592026-02-11T21:45:37ZCHARLOTTEDPIERCE1952-11-13UNKNOWN—(629) 498-4862N/A6045 MEADOW LANESan AntonioTX78265NULLN/A
TPATPA-644702026-06-24T18:46:11ZWAYNE—SIMMONS—null——null2699 Ocean Avenue Apt 3SeattleWA98148GRP-3816null
TPATPA-54148 2026-02-13T20:21:03Zandrew··O.vargas18-03-2000N/AUNKNOWN···NULLN/A1220 Baseline RoadLos AngelesCA90065——
14,474 rows, page 68 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:40.339Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty