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-572882026-08-18T04:45:26ZHELEN—MEJIA19870120-•••-••-3061——9445 DESERT SKY BLVDEden PrairieMN55352NULL··-
TPATPA-628052026-04-06T03:47:12ZPamela—Gibsson08/17/1956UHC-70252-36———5051 Willow CourtPhoenix·AZ85076-6276GRP-3248CHOICE-PLUS-PPO
TPATPA-586682026-08-03T01:42:07ZCox, DanielleX.—1943-04-12————5635 Spring StreetSacramentocaUNKNOWN—····
TPATPA-502342026-08-26T22:41:50Z·Fatima—Perkins08/13/2002—null··563-341-5264UNKNOWN2090 Park PlLas VegasNV89140——
TPATPA-557112026-02-28T22:39:32Z Jeremy····Castillo19810928NULLUNKNOWNN/A-3847 Grand AvenueTempeAZ85235N/Anull
TPATPA-527242026-02-13T09:49:17ZTyler—Knight27-04-2002null··•••-••-26409055100879—6690 ELM ST·DallasTX··75215-8441GRP-5898CORE-HMO
TPATPA-630522026-09-20T15:00:35ZAisha—Cunningham1948-04-16-—··NULL9144 PINE DRIVETempe·AZ85272··GRP-0231CORE-HMO
TPATPA-517112026-04-11T19:26:27Z BRAYN—SANERS1968-09-27N/A—4757742185-4575 Broadway #865Los AngelesCalifornia90013—····
TPATPA-633112026-07-15T17:47:50ZZACHARY—BLACK2008-07-06UHC-26635-36—775-549-5429—7325 Oak StOrlandoFL32820N/Anull
TPATPA-635152026-08-05T22:33:33ZWILLIE—SIMS05/14/1959UHC-08712-31•••-••-1054—N/A3094 Hillcrest RdPLANOTX··75032—OPTIONS-PPO
TPATPA-641092026-06-29T04:43:33ZRichardson, JeffreyQ—1974-03-06N/A•••-••-6431····null3760 HIGHLAND AVENUEEden PrairieMN55343N/AMEDICARE-ADV-B
TPATPA-541912026-03-02T06:26:27ZVIRGINIA—RICE19421226—•••-••-2105N/ANULL6678 LINCOLN WAYFresno··ca93726GRP-8220NAVIGATE-HMO
TPATPA-614392026-06-11T09:05:19ZRandy—Edwards07-04-1967NULL—-N/A1054 Washington StreetMiami··FL33128N/A—
TPATPA-609562026-04-07T04:40:56ZMARTHABRUSSELL1986-09-26··nullUNKNOWNnullnull8647 DESERT SKY BLVDOrlandoFL32896NULL—
TPATPA-548922026-08-22T15:54:13ZPatrick—Alexander19680809—•••-••-3602·nullN/A1326 RIVER ROAD #958·AustinTX78721-1478N/A—
TPATPA-551472026-03-19T06:03:51ZJOSEPHP.LEE1974-05-25null—N/A—5814 Sage CourtScottsdaleAZ85254-NULL
TPATPA-56131 2026-09-11T19:20:21Zmary—pena1964-10-04-NULL(320) 687-5443—5221 River RdSeattleWA98184GRP-0482—
TPATPA-592912026-09-23T05:43:12Zdenise—riley1990-08-11UHC7659667UNKNOWNN/AN/A4126 Bayshore DriveMinneapolisMN55435GRP-6760—
TPATPA-559382026-02-28T06:49:51ZJENNIFER—AUILAR19380612·UNKNOWN•••-••-4533·N/ANULL1514 Harbor BlvdGilbertArizona85210GRP-5713OPTIONS-PPO
TPATPA-528932026-08-23T19:19:59ZWALTER—MATTHEWS05/04/78UNKNOWNUNKNOWN260-675-4924·-6009 Spring StreetSan AntonioTX·78215—N/A
TPATPA-612192026-06-23T08:12:54ZLawrence··—HowwardAug 21, 1942-•••-••-6111N/AUNKNOWN6413 Union StTempeAZ85221GRP-6417—
TPATPA-593792026-03-14T03:44:05ZLINDA—ELLIS1941-02-05null—-———UNKNOWNnullNULLNAVIGATE-HMO
TPATPA-557792026-10-11T23:54:35ZMarilyn··G.Nguyen·1988-11-23NULLUNKNOWN—UNKNOWN7033 Palm DrDallasTX·75277·GRP-3634null
TPATPA-519502026-07-20T11:06:03ZWILLIE—·BOYD10/16/04UNKNOWNN/A(762) 624-8254—9492 APACHE BLVDFresnoCalifornia93787··-—
TPATPA-623962026-09-10T14:45:43Z CHRISTIAN—KING1952-07-18····null(308) 767-3267—5526 Sunset BlvdTempeAZ85215NULLMEDICARE-ADV-B
TPATPA-606472026-03-27T10:01:49ZTucker, EdwardH—1966-10-13—•••-••-7347NULL-5509 Lake View Rd··FresnoCA93708GRP-0101····
TPATPA-522382026-02-15T05:29:36ZKAREN—SALAZAR11/7/1977UHC-08069-23UNKNOWN(439) 931-9682karen.salazar@gmail.com5885 Jefferson AveColumbusOH43217GRP-8976NULL
TPATPA-554262026-09-04T12:22:08ZGABRIEL—ROMEROJun 22, 1952—•••-••-5437—-·NULL—---····
TPATPA-607102026-01-09T14:17:54ZMichelle—Butler2006-04-03——914-917-0067MICHELLE.BUTLER47@HOTMAIL.COM6798 Union St···DallasTexas75261-9195—N/A
TPATPA-609122026-09-24T20:51:13Zjoseph—·olson01/23/51UHC-17116-81null455.446.2453UNKNOWN8346 Desert Sky BoulevardSan DiegoCA·92115—SELECT-EPO
TPATPA-506002026-08-07T08:38:56Zeric—cole1992-11-06UNKNOWN—(612) 389-1797UNKNOWN360 Apache BlvdTempeAZ85296—SELECT-EPO
TPATPA-561012026-09-26T08:44:13ZAmanda—Johnston1994-09-04N/A•••-••-4665·16613493211null4504 Valley View Dr #504ScottsdaleAZ85253nullN/A
TPATPA-573112026-02-03T16:20:05ZWAYNE—BAILEY07/10/2007··—UNKNOWNNULLN/A8816 Forest AvenuePhoenixAZ85017-9136—N/A
TPATPA-593772026-06-17T18:37:19ZPaul—Payne19490604nullnull381-535-2733null1440 MESA DREden PrairieMNnull—····
TPATPA-641482026-09-09T10:07:53ZBOBYB—BAILEY1943-08-01null-····NULL2275 Baseline Road Apt 37PLANOTX··75032—NULL
TPATPA-511892026-06-30T04:08:46ZJacob—Evans07/14/1971UNKNOWNNULL—NULL2290 SPRING STJacksonville·fl——UNKNOWN
TPATPA-600882026-05-05T14:19:54ZLoggan—Simmons1959-06-11—NULL924.795.1154null8239 Forest AvenueFRESNOCA93786—-
TPATPA-602552026-04-07T22:14:49ZDixon, Janet——10/4/2007-··—UNKNOWNUNKNOWN·2945 Lincoln WayHouston·TX77078GRP-9287CHOICE-PLUS-PPO
TPATPA-545262026-02-16T08:06:05ZCAROLYN—RIVERA1984-02-17·UHC-07452-06•••-••-0053NULLnull·932 Church Street Apt 22DenverCO—NULLUNKNOWN
TPATPA-536812026-04-26T17:35:36ZARJUN—CHAVEZ1958-07-21N/A•••-••-8248(775) 277-7863··-3309 Elm Street #945CharlotteNorth Carolina28276UNKNOWN·MEDICARE-ADV-B
TPA TPA-599432026-02-03T14:01:42ZSofia—Mitchell1943-10-23—•••-••-0921nullN/A—N/ANULL-··—N/A
TPATPA-527482026-08-10T16:08:21ZLuis—Murphy··1965-07-18—•••-••-4444+1 948 894 2399UNKNOWN—UNKNOWNNULL—NULL—
TPATPA-570452026-07-16T00:34:04ZJOAN Q—PADILLA09/01/68UNKNOWN-··UNKNOWNjoan.padilla58@hotmail.comUNKNOWNUNKNOWN-N/AGRP-9441MEDICARE-ADV-B
TPATPA-640192026-03-31T12:29:58ZHiroshi—·Day11/2/1998··———HIROSHI.DAY@AOL.COM9870 Apache Blvd·MesaAZ85278——
TPATPA-563842026-04-10T04:00:31Zdavid—simmons8/6/1959UNKNOWN•••-••-1300nulldavid.simmons90@aol.com1491 Lake View RoadFresnoCA-—-
TPATPA-641562026-07-08T08:01:31ZKaren—Rose1993-11-16—•••-••-90188776486886null1976 Willow Ct··LAS VEGASNV89101——
TPATPA-548822026-09-27T01:22:41Z AUSTIN—PARK··1987-07-24UNKNOWN———8843 Forest AvenueSEATTLEWashington··98131GRP-0393—
TPA TPA-633342026-05-05T04:10:17ZLARRY—MORENO1959-04-27—N/A—null——N/A··—··MEDICARE-ADV-B
TPATPA-592512026-08-20T23:09:12ZGABRIEL—FORD05/10/03null•••-••-8222null-12 Valley View DriveEDEN PRAIRIEMinnesota55320-6215GRP-1757UNKNOWN
TPATPA-515382026-10-09T13:03:26ZMegan····Davis1994-06-27·-NULL-—5918 Union StNashvilleTennessee·37208—UNKNOWN
14,474 rows, page 11 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-19T19:54:25.433Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty