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-589282026-03-27T05:19:14ZTyler—Mendez1984-07-19·N/A—3425592286—8168 CHURCH STTAMPAFL33604GRP-0208NULL
TPATPA-62658 2026-07-02T05:55:33Z·Lisa—Burton··19451117UHC-23382-54····NULLUNKNOWN913 Lake View RoadSan DiegoCA92145NULL—
TPATPA-629902026-05-14T22:02:52ZEric—Harper2002-10-26·UHC1885516—7293908233ERIC.HARPER@HOTMAIL.COM8687 Ocean AveSan DiegoCA92145-3037—OPTIONS-PPO
TPATPA-555332026-07-27T11:11:26ZRUTH—PEREZ20011201-N/AN/A··4458 Cedar LaneSan AntonioTX78257GRP-9874NAVIGATE-HMO
TPATPA-638372026-02-03T14:24:56Zrachel—nichols06-07-1970——null·nullN/A·nullN/A——core-hmo
TPATPA-644042026-01-25T01:05:47ZBrian—Hughes08/27/1940———·NULL6137 Valley View DriveCharlotteNorth Carolina28235GRP-2396—
TPATPA-543542026-04-04T17:15:36ZKLE··TAYLOR20060528N/A-7039513758-8390 Market StTampaFL33671—medicare-adv-b
TPATPA-622092026-01-25T16:24:06ZALAN··—EVANS3/7/1941UNKNOWN•••-••-7795UNKNOWNN/A···7622 WASHINGTON STSACRAMENTOCA—NULL—
TPATPA-616512026-10-15T06:50:55ZHannah····Nguyen1939-07-28UHC-93448-83-+1 945 831 4352hannah.nguyen@proton.me8600 Lincoln Way··Los AngelesCA90071GRP-7070—
TPATPA-587552026-08-25T02:17:46ZKelly—Vasquez—UNKNOWN•••-••-7070836-826-8136—2110 Church Street Apt 30MesaAZ85274-4784·-—
TPATPA-640632026-08-18T02:37:23Z·Wang, Danielle——Aug 26, 1941UNKNOWN•••-••-4285UNKNOWN-NULL—UNKNOWN——SELECT-EPO
TPATPA-543522026-01-18T01:39:59ZHayes, Teresa—····19580709uhc-65208-35—·(264) 397-7486——N/AnullNULL—-
TPATPA-570172026-04-08T08:34:44ZBrandon—Bennett1969-08-17—•••-••-7116(679) 374-5089··-3055 Park PlEden PrairieMN55384——
TPATPA-599242026-04-23T12:28:14ZjohnChughes1947-09-08——3283352963-1769 Mesa DriveTEMPEAZ85216··—·N/A
TPATPA-594202026-01-28T12:34:28ZYuki—Contreras01-03-1997—•••-••-4006—yuki.contreras@icloud.com4549 BroadwayPhoenixAZ85046-N/A
TPA TPA-521382026-01-16T13:37:13ZSimmons, Jacqueline—····2004-06-06UNKNOWN-NULLUNKNOWN917 Spring StreetTempeAZ85249-UNKNOWN
TPATPA-580622026-06-24T14:21:03Z·jacob··vazquez1972-07-14—•••-••-9148·559-864-8846UNKNOWN2247 Park Place Apt 30GLENDALEAZ85351NULLSELECT-EPO
TPATPA-507292026-08-30T18:35:07ZJoe··—·Lynch05/17/39null····null··joe.lynch@proton.me3000 Lake View RoadFresnoCA93719null·null
TPATPA-582212026-07-11T19:08:42ZAshley—Mitchell1994-09-14null•••-••-0492nullUNKNOWN181 Grand AvenuePhoenixAZ-NULL···N/A
TPATPA-560072026-05-16T09:06:10Z·Madison··Fields12/28/1987NULL·NULL(248) 459-5850NULL1394 Willow CourtCharlotteNC28278GRP-7520··null
TPATPA-617762026-10-01T18:37:07ZDenise··—Carroll1969-10-11null•••-••-98715527330564NULLN/A··UNKNOWN———
TPATPA-560022026-08-16T10:38:43Z·Jean—LucasApr 9, 1978null-583-511-1157—9228 Central AvenueJacksonvilleFlorida32284-0673—CORE-HMO
TPATPA-55382 2026-02-09T15:37:03Z·WAYNE·TGREENE5/20/1964null•••-••-5030(478) 547-9922—5071 CEDAR LANE·NashvilleTN37279-2981··UNKNOWNNULL
TPATPA-523962026-08-29T19:28:32ZAndew—Braldey··24-09-1942UHC-76594-50····nullN/A··3975 Sunset Blvd·FresnoCA93792-OPTIONS-PPO
TPATPA-523322026-06-23T13:17:17Zsophia—schultz1979-05-28—•••-••-21112338750924—2062 Jefferson AvenuePhoenixaz85019N/A····
TPATPA-507792026-05-12T18:39:58ZROSS····EDWARD02/20/1956-•••-••-5524(221) 870-2828edward.ross@yahoo.com784 Ocean AveLas Vegas··NV··89100··-navigate-hmo
TPATPA-551212026-05-05T06:09:15ZKimberly—Webb2001-10-11··UNKNOWN—UNKNOWN—1437 GRAND AVENashvilleTN37292GRP-9621—
TPATPA-613502026-08-04T21:59:48Z·ELIZABETH—SOTO2003-08-26NULL•••-••-8531——2261 BAYSHORE DRIVEAtlanta·GA30303-5502GRP-2230—
TPATPA-553412026-05-21T08:37:33ZDanielle—Diaz2008-08-10NULL—NULLnull———-GRP-2102SELECT-EPO
TPATPA-611692026-09-08T23:49:21ZROY—SPENCER1981-07-16—•••-••-3293—·NULL7299 Main StreetFresnoCA93758—CORE-HMO
TPATPA-506622026-07-27T20:55:31ZDenise—Peters··1980-10-22UHC-28393-22—UNKNOWN·DENISE.PETERS66@GMAIL.COM9572 Mesa Dr Apt 10SAN ANTONIOTX78291——
TPATPA-526502026-07-25T22:11:31Z Don—MartinJan 17, 1980null·-(756) 466-8641—4944 Sage CourtGilbertAZ85249GRP-7914NAVIGATE-HMO
TPATPA-556642026-09-21T01:43:42ZEmily··—Bell··1948-10-28-•••-••-90019203351045NULLUNKNOWNnullUNKNOWNN/A—NULL
TPATPA-542722026-10-06T23:05:58ZMATTHEW—JONES2002-04-11-—--9898 Valley View DriveLOS ANGELESCA·90044GRP-3681··—
TPATPA-529912026-09-07T21:04:08ZPAT—HART1974-05-14——N/A·null—null--GRP-9259N/A
TPATPA-630202026-09-07T16:46:13ZHerrera, Patrick——·1997-08-03UNKNOWNnull··720-485-0317··—1704 Forest AvenuePlanoTX75060··NULL—
TPATPA-540842026-08-26T13:28:19ZBobby—Edwardds2004-07-11--NULLROBERT.EDWARDS@OUTLOOK.COM3734 Desert Sky BoulevardAustinTX78732——
TPATPA-553742026-08-08T20:48:07ZEDWARD—NICHOLS1997-04-26NULL•••-••-2046923-914-2340edward.nichols@aol.com4601 RIDGE ROADDallasTX75216·GRP-5696N/A
TPA TPA-549822026-08-19T18:36:00ZCEROL—LEWIS1949-07-22UNKNOWN—12803486927nullUNKNOWNNULL-·nullGRP-1307UNKNOWN··
TPATPA-544662026-08-03T11:42:42ZGloria—Fisher1976-08-13———UNKNOWN·3183 MESA DRTampaFL33644—N/A
TPATPA-602952026-10-07T06:14:18Z·HIROSHI A—GREENE1999-03-25N/AN/A——2623 Maple AvenueLas VegasNV89176GRP-5014·CORE-HMO
TPATPA-608582026-05-07T16:42:35ZJerry—Perkins1960-02-18—•••-••-0692·UNKNOWNjerry.perkins20@outlook.com··1106 Mesa DriveNashvilleTN37212—N/A
TPATPA-60093 2026-01-23T06:50:32ZMelissa—OwensMar 18, 1972UNKNOWN·NULL-NULL7251 SUNSET BLVDSan AntonioTexas78222-—
TPATPA-570202026-05-30T18:29:52ZEugene—Hall1955-04-30—•••-••-1892383-913-5842UNKNOWN8430 Palm DriveOrlandoFL32868GRP-4948NAVIGATE-HMO
TPATPA-600432026-06-10T05:36:03ZAnderson, Eugene——1963-08-20—UNKNOWNnullnull——-null·NULLOPTIONS-PPO
TPATPA-615612026-09-22T20:41:57ZDonald—·Kennedy08/27/05UNKNOWN··UNKNOWN—N/A2438 Grand Ave Apt 28AustinTX78758NULLMEDICARE-ADV-A
TPATPA-569502026-01-19T09:48:46ZBryan—Ramos1942-01-24—•••-••-0645—N/A9069 Ridge RoadGILBERTAZ·85216—CHOICE-PLUS-PPO··
TPATPA-544172026-04-30T14:33:46Z priya—aguilar2000-10-24——665-230-4159NULL6298 Pine DriveSan DiegoCA·92143UNKNOWNCHOICE-PLUS-PPO
TPATPA-595712026-04-28T20:46:56Zisabella··P.santos02-12-1985N/A•••-••-3917····—--UNKNOWN-NULL··
TPATPA-552102026-09-03T23:15:30ZWillie—Black·09/22/2001UHC-22972-70—541-483-1637null··4399 Sunset Blvd·TucsonAZ85789-6802·GRP-6265NAVIGATE-HMO
14,474 rows, page 243 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:43:00.229Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty