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-593422026-06-03T16:58:05ZJudy—Santiago1999-05-13UNKNOWNUNKNOWN——132 Pine Drive··TempeAZ85248GRP-4343—
TPATPA-52145 2026-07-04T00:22:53ZGonzalez, Margaret——7/8/2005-UNKNOWN—UNKNOWN-—nullnullGRP-1619CHOICE-PLUS-PPO
TPATPA-59529 2026-07-08T01:31:20ZBell, Marc··——07/02/1956—•••-••-8400563-559-7414N/A4720 Park PlDallasTX75237N/AUNKNOWN
TPATPA-501492026-09-23T14:22:12Zaisha—henry2005-07-22—UNKNOWN—NULL2707 MARKET ST Apt 36San AntonioTX78268GRP-3915NULL··
TPATPA-53282 2026-07-29T20:38:08ZMASON··—RAMIREZ03-05-1964————3165 SPRING STFresnoCA93769GRP-7674-
TPATPA-623482026-08-13T18:19:19ZElijahGGilbertAug 12, 1998NULL—6958483029····7681 CANYON ROADCharlotteNC28207nullOPTIONS-PPO
TPA TPA-537452026-04-27T17:29:55ZTYLER—THOMAS08/01/48UHC-19916-14•••-••-96347237238977N/A6416 Pine DrSAN ANTONIOTX··78264GRP-5566·null
TPATPA-580422026-08-27T10:52:07ZJanet··Reyyes6/1/1951·null····(203) 952-5882—4791 Bayshore Dr #323·TucsonAZ85701—UNKNOWN
TPATPA-504802026-07-31T05:59:04ZANGELA—MILLSOct 9, 1973UHC-64081-98N/A714-275-6815—3753 Harbor BlvdTucsonAZ85789··GRP-9361OPTIONS-PPO
TPATPA-509662026-06-02T20:15:20ZOLIVIA—HART1976-10-26nullUNKNOWNN/A—9622 HIGHLAND AVENUEHoustonTX77017UNKNOWN—
TPATPA-558002026-08-03T08:41:26ZNATHAN—FERNANDEZ1993-03-22··UNKNOWN-·nullN/AnullUNKNOWN—NULLUNKNOWNNULL
TPATPA-597322026-07-12T05:21:35ZBilly—Collins·06/06/1941··•••-••-0654—NULL—nullnullUNKNOWN··GRP-1665—
TPATPA-617432026-04-27T12:45:57ZJacob—Jimenez1983-11-07··•••-••-5669····jacob.jimenez74@hotmail.com1086 Ocean AveHoustonTX77041—·UNKNOWN
TPATPA-607032026-02-16T21:32:01ZDeborah·EVargas1944-06-26UNKNOWN•••-••-3169NULLnull4953 Apache BoulevardMINNEAPOLISMN55473GRP-4934··N/A
TPATPA-558922026-07-15T14:45:14ZSamuel··OBrien2000-10-08NULLNULLN/ASAMUEL.OBRIEN@OUTLOOK.COM8778 OAK STREETTampaFL33693N/ANAVIGATE-HMO
TPATPA-531542026-07-02T10:41:29ZHenry··—RobertsOct 21, 1969——(685) 607-8523—7955 Sage CourtCHANDLERAZ·NULLN/ASELECT-EPO
TPATPA-511122026-10-15T16:47:56Z EmmaA.Perez1997-09-25UHC-52568-47•••-••-7416N/A—5635 OAK STREETGILBERTAZ85241-6523NULLnull··
TPATPA-642772026-10-10T08:31:15ZCHARLES—NUNEZ19530525UNKNOWN-—charles.nunez@gmail.com1663 MESA DRIVESeattleWA·98179N/Anull
TPATPA-597172026-05-16T21:40:50ZDiego—Hill2001-12-20UNKNOWN•••-••-29806858193077—6895 Willow CtNashvilleTN37201-8497null-
TPATPA-523352026-06-16T08:19:35ZLOGAN—WILLIAMS1942-05-11——9233515901—9681 JEFFERSON AVEFRESNOCA93723null··UNKNOWN
TPATPA-533742026-04-02T21:09:26ZEugeneHKellyJul 7, 1976NULLNULL——1751 Valley View DriveMIAMIFL33148GRP-1415·null
TPATPA-631592026-08-30T09:59:14ZSandraGHart12/16/1957—N/A950.839.7903—9810 Jefferson AveSan DiegoCA92119-5573UNKNOWNNULL
TPATPA-582592026-09-04T23:21:59Z·CYNTHIA—YANG19510603—N/A—N/A4626 Spring StreetChandler·AZ85289GRP-4155null
TPATPA-569162026-04-03T12:02:58ZALBERT—DANIELS1952-03-03NULL•••-••-6035788.222.8939NULL——nullUNKNOWN—NULL
TPATPA-532072026-05-20T19:41:00ZAnn—Washington28-12-1963—·UNKNOWNUNKNOWNUNKNOWNNULLNULL--—CORE-HMO
TPATPA-522342026-04-25T17:12:53ZGreene, Arthur——Jun 20, 2006—N/A—-4014 Cedar Ln··AtlantaGeorgia———
TPATPA-520542026-05-28T23:02:25Zjesse—walker04-05-1941··NULLNULL·-JESSE.WALKER3@YAHOO.COM5667 Camelback RdColumbusoh43286GRP-3543—
TPATPA-603272026-04-12T19:53:22ZThomas—Ana07/19/83UHC7919493—+1 328 491 6761N/A8738 Camelback RoadScottsdaleAZ85228—NAVIGATE-HMO
TPATPA-532032026-01-26T08:47:30ZLisa—Bryant02/06/97UNKNOWN•••-••-8829nullN/A—null··-null——
TPATPA-504332026-03-15T14:43:54ZAmyITorresMay 4, 1959—•••-••-6092——5688 Cedar LaneAustinTX78783-—
TPATPA-517342026-03-31T22:50:31ZAlbert—Sanders19430728UHC-97542-95UNKNOWNUNKNOWN-313 CANYON ROAD·LAS VEGASNV89106nullNULL
TPATPA-636972026-03-31T21:28:40ZWeb, SofiaS.—1960-12-02null•••-••-0631——265 Ridge Rd·Tampafl33645NULLNULL
TPATPA-595192026-10-08T03:49:16ZRichard—Hamilton2001-10-03UNKNOWN•••-••-2363215-605-3528·richard.hamilton@hotmail.com4119 HIGHLAND AVENUE Apt 15ColumbusOH43201·UNKNOWNnull
TPATPA-548682026-09-23T14:40:04ZAishaG.Barnes5/5/1986N/A····+1 208 291 6232null6083 MAIN STREET #373San Diego··CA92163NULLOPTIONS-PPO
TPATPA-592552026-01-29T12:18:27Zsamuel—bennett1946-07-10UHC9961072N/A—samuel.bennett@icloud.com4248 Lincoln WayFRESNOCA93754GRP-5266NULL
TPATPA-598432026-03-16T01:27:57ZdanielZbllack2005-02-09—nullUNKNOWN·null4370 SPRING ST·PHOENIXAZ85078····—
TPATPA-565872026-02-10T21:40:30ZAntthony—Ross1940-11-24UHC-19608-19•••-••-2799-UNKNOWN9648 Highland AveLas VegasNV89142-2685null-··
TPATPA-508402026-09-28T03:35:06Zcarl—young19600205——(889) 755-5220carl.young81@gmail.com6285 Valley View DriveSan DiegoCA92115—null
TPATPA-581002026-02-23T06:38:42Zjoe··—florse19940808NULL•••-••-8182——6068 Sunset BoulevardCharlotteNorth Carolina28283GRP-0341····
TPATPA-62925 2026-06-26T21:04:39ZAMY—BRYANT1959-06-18null•••-••-02315296876883·null-—-····GRP-0380CHOICE-PLUS-PPO··
TPATPA-544982026-03-12T03:31:32ZDonald—·Bennett1977-02-28UHC-07240-34-N/A—2493 Elm StreetFresno··CA93702GRP-2516··null
TPATPA-613482026-05-23T08:17:38Zgerald—mendez1963-01-11··-UNKNOWN4285249639NULL4300 MOUNTAIN VIEW DRNASHVILLETN37210nullnull
TPATPA-535812026-10-11T15:23:44ZELIJAH—ALLEN1943-12-01nullN/A(616) 890-2010null425 Main StreetTucsonAZ85792GRP-3627—
TPATPA-533282026-10-03T15:09:02Z·Beverly—Harris03/03/02—····2919754979-1193 Apache BoulevardScottsdaleaz·85211——
TPATPA-64170 2026-01-08T15:19:24ZBrenda—Black1961-12-20—·N/A979-934-1476null5314 Church StTempeAZ85266-6002—NAVIGATE-HMO
TPATPA-539212026-10-04T03:31:15ZWalter··—Peterson·1965-10-07·-•••-••-6877739-566-1763··—·4110 Spring StSEATTLEWA98144—MEDICARE-ADV-A
TPATPA-506092026-08-26T04:20:00ZNick—Perry·Feb 16, 1972UHC-33463-19null303-549-0621UNKNOWN3968 Sunset Boulevard Apt 30San AntonioTexas78221—choice-plus-ppo
TPATPA-533232026-03-25T00:36:42ZHannah—Clark1981-05-15UNKNOWNnull-UNKNOWN2713 JEFFERSON AVENUEFRESNOCA——NULL
TPATPA-585792026-08-25T06:15:23ZJonathan··SilvaMay 10, 2006—•••-••-5928590.541.4389NULL8190 Cedar LaneFresnoCA93752GRP-5471MEDICARE-ADV-B
TPATPA-518472026-06-15T21:10:45ZMatt····Carroll1999-01-17·null•••-••-0383N/A—223 MARKET STSan DiegoCA92125GRP-6850null
14,474 rows, page 211 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:56.139Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty