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-539282026-04-14T01:09:41ZRobert—Herrera2005-01-17UHC-62324-31—8089175910N/A1636 Washington StJacksonvilleFL32255GRP-5584MEDICARE-ADV-B
TPATPA-55613 2026-03-29T05:37:24ZLogan—Adams1981-05-16NULLNULL6896640097—1792 Maple AveMESAAZ85277——
TPATPA-570382026-10-03T19:38:23ZAlen—Marquez2002-02-16UHC-88620-29NULLNULLNULL2304 Central AvenueFresno·CA·93742····navigate-hmo··
TPATPA-581822026-04-15T23:45:07Z·mei—cunningham1985-07-19NULLnullnull—6528 Meadow LnCharlotteNC28215GRP-0791—
TPATPA-55881 2026-06-02T12:56:38ZAna—Mills·06/13/98UNKNOWNNULL17822849623··ana.mills73@yahoo.com··7015 Union StreetLas VegasNV89176nullOPTIONS-PPO
TPATPA-526872026-08-11T13:16:49ZALEXIS··AGUILAR1956-04-28UHC-02896-34—5295365979UNKNOWN··nullUNKNOWNNULLNULLGRP-6344—
TPA TPA-572222026-05-04T20:39:12ZBRANDON—STEVENS19761118——(634) 346-1500null4843 Palm DrEden PrairieMN55345··--
TPATPA-547352026-10-11T22:05:36ZDANIELLERCLARK1984-08-14NULLnullN/A··UNKNOWN8705 Palm DriveSCOTTSDALEAZ85223GRP-8671CHOICE-PLUS-PPO
TPATPA-556432026-09-22T05:44:08ZEric—Phillips1951-12-09NULL-668-851-6313—8796 RIDGE RDSeattleWA98149——
TPATPA-501102026-08-14T15:56:52ZNOAH··ALVAREZ1953-03-24—N/A——7184 Sunset BoulevardFresnoCA93715GRP-5162CHOICE-PLUS-PPO
TPATPA-62347 2026-08-16T18:36:38ZLauren—Howard20050418N/A———9045 Harbor BlvdMinneapolisMN55437N/A—
TPATPA-570832026-09-14T07:25:21ZASLHEY—JOHNSTON19640924null•••-••-5391nullashley.johnston@gmail.com3722 Maple AveSacramentoCA95854——
TPATPA-602732026-01-13T12:57:31ZNicholas—Bradley2006-03-27NULLNULL-—4519 Palm DrEden PrairieMN55331N/A-
TPATPA-570062026-02-18T01:27:37ZBRYAN—EVANS2007-08-25···NULLN/A509-970-2531null4502 Canyon RdLos AngelesCA90094·GRP-3137····
TPATPA-638282026-04-21T07:51:05ZWAYNE—WALLACE1997-06-12UNKNOWN•••-••-7418—WAYNE.WALLACE31@PROTON.ME919 RIDGE ROADLas VegasNV89125UNKNOWN-
TPATPA-500972026-07-08T20:23:47ZdeborahTmurray2003-04-24-•••-••-5015—deborah.murray@proton.me3737 Baseline RdScottsdaleAZ85253—MEDICARE-ADV-A
TPATPA-612782026-04-02T02:01:36Zjanet—tucker1972-06-26···null—-4988 Indian School RoadMINNEAPOLISMN··55460——
TPATPA-629402026-01-10T00:49:09ZLucia—Ellis9/15/1972··—•••-••-2636—lucia.ellis62@aol.com1316 SAGE CTCHANDLERAZ85252null-
TPATPA-563332026-08-04T16:15:22Z KAYLA—KNIGHT1945-02-22-NULLN/Akayla.knight82@icloud.com3353 Highland AveMesaAZ85246GRP-9793N/A
TPATPA-532222026-03-06T20:43:57ZWillie, Harrison——2004-02-21N/ANULL3058660067—8401 Indian School RoadMesaArizona—UNKNOWNN/A
TPATPA-588542026-04-10T15:29:52ZVICTORIA—SALAZAR13-06-1970N/A•••-••-5751-N/A9172 Lake View RdLos AngelesCA··UNKNOWN—NAVIGATE-HMO
TPATPA-556532026-02-03T20:54:25Z Kathleen—Butler1997-07-03··-•••-••-7814N/A—-N/AN/AUNKNOWNUNKNOWNCORE-HMO
TPATPA-638302026-04-05T20:33:10ZJoshua—·Guerrero09/04/1963··•••-••-337216243763251JOSHUA.GUERRERO@YAHOO.COM7674 BASELINE ROADDallasTX75246N/A··
TPATPA-519602026-03-21T18:39:49ZYKUI—MITCHELL·1976-08-27null—-N/A6923 Main StDenverColorado80255——
TPATPA-586232026-02-25T18:32:25ZSims, Omar··—1975-08-14NULLNULL9295862061OMAR.SIMS8@YAHOO.COM2190 Grand AveDenverCO80232—null
TPATPA-549112026-10-12T02:13:57ZJOHN—GOMEZ3/19/1958N/ANULLUNKNOWN—5201 PARK PLACEOrlandoFL32873NULLMEDICARE-ADV-A
TPA TPA-583722026-08-15T18:26:44ZJEFFREY—MATTHEWS1981-01-03-•••-••-94456698346249null2008 Market StGilbertAZ85290N/AUNKNOWN
TPATPA-619802026-01-22T15:38:14ZHelen—Gray1997-02-18N/AUNKNOWN3418071205—6062 Canyon RoadTucsonAZ85792·nullCORE-HMO
TPATPA-54259 2026-02-12T05:05:00Zjustin—vargas2004-09-15UHC-10790-41•••-••-9180——N/AUNKNOWNN/A-····NULL
TPATPA-543002026-02-14T12:24:39ZChristian····Lynch12/03/48UHC-37248-01·UNKNOWN——8524 Bayshore DrAustinTX78716····CORE-HMO
TPATPA-596652026-01-21T09:02:45ZVALENTINNA—HOWARD1987-04-16—NULLnullvalentina.howard@aol.com9834 Valley View DrSan DiegoCA92155··GRP-9596—
TPATPA-644542026-08-02T13:52:42ZAnna—Evans·1986-01-20—•••-••-8422+1 602 688 7793null-UNKNOWN——nullCORE-HMO
TPATPA-569202026-09-05T05:12:28ZBrandon—Hicks09/03/56NULL•••-••-581415655433767NULL6150 Jefferson AveLos AngelesCA90088UNKNOWN-
TPATPA-555372026-01-17T05:07:57ZHIROSHI—MESON1963-11-06UNKNOWN··8542356009NULL-—N/ANULLGRP-0913CORE-HMO
TPATPA-613342026-05-20T03:24:18ZMadison—Franklin01/01/1943UNKNOWNUNKNOWN+1 233 426 0479··MADISON.FRANKLIN@OUTLOOK.COM1042 Spring StreetLas VegasNV89111GRP-0844··
TPATPA-606792026-08-28T16:22:17Z WAYNEG.MATTHEWSJul 24, 1955-UNKNOWN5382336240NULL3815 Highland AvenueCharlotteNC28263—null
TPATPA-597712026-02-04T21:27:49Zlucia—·wood1946-04-20N/A—·····UNKNOWN2088 INDIAN SCHOOL RDLos AngelesCA90016nullMEDICARE-ADV-B
TPATPA-518642026-07-04T09:52:49ZTeresa··—King1992-12-11—UNKNOWN(572) 685-5878—6187 Hillcrest Rd Apt 40GlendaleAZ85374—N/A
TPATPA-553302026-03-21T18:07:51ZMikeT.MillsNov 5, 1943-UNKNOWNN/A-5667 CENTRAL AVEHouston·TX77050—UNKNOWN
TPATPA-545752026-03-30T09:32:01Z Henry····McDonald·10/15/1973—--—2033 Ocean AveTempeAZ··85207UNKNOWNnull
TPATPA-564682026-09-23T07:48:43ZBrenda—Sullivan·1992-01-01—UNKNOWN984-480-2930NULL··1728 Highland Ave··ORLANDOFL32890nullN/A
TPATPA-624892026-06-06T07:01:30ZOLIVIA—WOODS19710202——338-347-5513—3669 BROADWAYFresnoCalifornia93711··—UNKNOWN
TPATPA-603582026-09-05T03:31:12ZKyle—Marquez05/17/61·NULL—NULLUNKNOWN3116 Main StreetGLENDALEAZ85367··UNKNOWN
TPATPA-62310 2026-01-24T19:50:02ZCheryl—Wagner·1962-03-27--null—7207 SPRING STDallasTX75247NULL—
TPATPA-59410 2026-04-20T02:10:28ZGreen, Santiago····—1998-04-02N/A—813-882-4526··—5914 MAIN STREETSan Antonio·Texas78262-5937—N/A
TPATPA-565222026-05-27T09:16:29ZCynthia—Jensen1959-05-28—-268-596-9803cynthia.jensen@icloud.comUNKNOWN-UNKNOWNNULLN/ACORE-HMO
TPATPA-516062026-07-01T12:06:25Z·Michelle—Lane1940-12-15——····MICHELLE.LANE@GMAIL.COM·7817 Lake View RdPHOENIXArizona·85050N/ACHOICE-PLUS-PPO
TPATPA-546172026-04-02T23:59:37ZFrank····Stephens08-04-1983—N/A+1 362 809 8196null8890 Lincoln WayChandlerAZ85223—CHOICE-PLUS-PPO
TPATPA-595672026-07-21T16:25:20ZHannah—Brooks06-02-1990·N/A•••-••-6969-—····UNKNOWNUNKNOWN—GRP-5107—
TPATPA-540892026-07-07T01:32:25ZFrances—Yangnull——-frances.yang@yahoo.com1650 Forest AveLos AngelesCA90069—OPTIONS-PPO
14,474 rows, page 41 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:37.762Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty