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-643872026-05-13T23:37:17ZCarolyn—Wright1976-05-19NULL•••-••-6484nullCAROLYN.WRIGHT69@GMAIL.COM3585 Jefferson AveDALLASTX75210GRP-1214MEDICARE-ADV-A
TPATPA-544382026-08-05T03:45:17ZFrances—Ramirez1973-08-18UNKNOWNN/A—NULL··5692 UNION STREETCharlotteNC··28232GRP-9786—
TPATPA-537942026-04-15T11:04:37ZOrtega, Mateo····—01/09/56UHC-99277-69N/A··—UNKNOWN7123 Lincoln WayHoustonTX77027-2328··null-
TPATPA-508792026-01-11T21:06:08ZPerez, Christina F.—··2000-01-20-NULL4557544897NULL9108 Meadow LnGILBERTAZ—····CHOICE-PLUS-PPO
TPATPA-628092026-08-28T14:36:05ZPALMERJANNA1961-01-03—nullNULLN/A3351 River Rd·DenverColorado80239-—
TPATPA-553962026-09-14T08:32:17Z Karen—Young2008-03-15UHC-48759-81N/A290-445-1047—null-—····GRP-4406null
TPATPA-622512026-01-20T01:57:03ZruthSortiz1990-11-22··UHC-29847-48—UNKNOWNNULLnull—N/Anull—NAVIGATE-HMO
TPATPA-512912026-05-10T07:42:20ZTurner, Arjun··——1984-09-08····nullUNKNOWNarjun.turner5@proton.me8735 Valley View DrPhoenixArizona85067NULL-
TPATPA-644592026-08-24T01:55:18Zsantiago—powell20-08-1985·UNKNOWN-·UNKNOWNUNKNOWN6590 Canyon RoadCOLUMBUSOH43254UNKNOWNMEDICARE-ADV-B
TPATPA-509492026-04-18T14:45:03ZLarry—BryantOct 10, 1996UHC-63283-73•••-••-5897——·3207 Camelback RoadLas VegasNV89148——
TPATPA-531892026-01-31T17:42:18ZHarrison, Dylaan——1972-06-11—-·837-840-6476··7916 Park PlaceOrlandoFL32820GRP-3869·NULL
TPATPA-591252026-06-01T07:42:57Z·SantiagoUBishop19690914—null——5634 Bayshore Drive··ATLANTAGA30367GRP-5470—
TPATPA-570092026-05-18T01:14:19Zjordan—baileyJun 28, 1963UHC-61063-87UNKNOWNN/A—7325 Harbor BoulevardEden Prairie··MN55313GRP-6132MEDICARE-ADV-B
TPATPA-538582026-03-25T22:39:03ZAngelaQ.Sanchez1952-05-10N/A•••-••-9492———null--GRP-4643N/A
TPATPA-565602026-01-28T20:39:34ZTimothy—Berry12/24/2007NULLN/AN/Atimothy.berry37@gmail.com1940 Cedar Lane Apt 26PlanoTX75095-7023-—
TPATPA-573532026-08-28T20:15:25ZNATHAN—PENA1944-03-17··-•••-••-7309—-5239 Maple AvenueGLENDALEAZ··85303GRP-9495CHOICE-PLUS-PPO
TPATPA-63001 2026-05-10T19:36:31ZJean—Cole8/7/1968—•••-••-8250——7258 Spring StScottsdaleAZ85234NULLnull
TPATPA-561782026-08-11T01:07:59ZHolmes, Julia——12/28/1974N/A•••-••-3127696-728-9662——null—·-——
TPATPA-614202026-03-29T05:50:31Z Contreras, Ethan——1974-12-03null—N/Anull3510 Grand AvenueDallas·TX75287N/AMEDICARE-ADV-A
TPATPA-577452026-07-07T15:05:59ZKayla—Evans·1943-01-06N/A•••-••-7994+1 492 789 9152NULL3165 BROADWAYAUSTINTX78712··——
TPATPA-508012026-06-02T12:08:02ZCarollyn··—Jimenez02/17/42UNKNOWN•••-••-1560441-822-8348null7201 MEADOW LANEHoustonTX77054··GRP-0135NULL
TPATPA-620912026-06-07T20:12:49ZAhmed—·Nichols·23-11-1998—NULL———UNKNOWN——GRP-1576N/A
TPATPA-624532026-02-18T00:07:13ZSamantha—Riely12/27/1965—•••-••-1325NULLN/A5302 Hillcrest RoadOrlandoFL32828-0448——
TPATPA-563362026-02-23T13:06:40Z Bobby—Stone07/02/54UNKNOWN•••-••-8623·7399530508N/A2672 Grand AvenueScottsdaleAZ85241GRP-4074null
TPATPA-642462026-07-06T02:18:02ZVirginia—Armstrong7/18/1961N/A··845-838-8168NULL2450 Valley View DriveMesa··AZ85204NULLN/A
TPATPA-601872026-03-01T10:42:24ZWatkins, Justin——Apr 17, 1950····•••-••-9601-—2253 Meadow LnSAN ANTONIOTX78202-NAVIGATE-HMO
TPATPA-63329 2026-05-29T21:24:03ZKennedy, Kyle——19940214-•••-••-2231588-790-5978NULL357 Canyon RoadEden PrairieMN55387-1680—N/A
TPATPA-628862026-05-13T18:46:40ZBOBBY—RAMOS1984-08-24—UNKNOWN-NULL8043 Church StEDEN PRAIRIEmn55319··—UNKNOWN
TPATPA-590942026-08-05T08:43:09ZRuth—Hernandez5/15/1955—•••-••-8977259-709-8822ruth.hernandez@aol.com·1617 Lincoln WayMIAMIFlorida33139-9383N/AN/A
TPATPA-618622026-01-15T06:21:20ZOlivia—·Cole2008-08-16-•••-••-0379·+1 718 322 4869olivia.cole@hotmail.com—nullNULLUNKNOWN·-—
TPATPA-566872026-02-14T17:17:20ZPatricia—Cook2000-07-23UHC-83160-56null—UNKNOWN1425 VALLEY VIEW DRSacramentoCA95878——
TPATPA-525212026-01-14T14:15:39ZJean—Sullivan1986-08-24NULL•••-••-1020(635) 239-5516N/A48 Ridge RdAustinTX78733GRP-1444NAVIGATE-HMO
TPATPA-53224 2026-03-27T12:59:36ZPAUUL—HAMILTON19790427null•••-••-2116—NULL3908 Maple AveLos AngelesCA90064null··NULL
TPATPA-612412026-02-15T07:09:22ZcarlN··coleman1970-03-15——(984) 766-9139UNKNOWN3129 CHURCH STSan AntonioTX78288·GRP-2535—
TPATPA-536092026-07-09T20:02:12ZSandra—Ryan1995-12-02null-N/AN/A3076 SPRING STREET··ChandlerAZ85250——
TPATPA-582482026-06-15T12:24:46ZGary—Brown1/24/1950UHC-63458-01-nullN/A5247 Jefferson AveTUCSONArizona85789-—
TPATPA-56901 2026-02-12T21:06:13Z·MASON—CASTRO1957-09-28-—N/A·mason.castro@hotmail.com4926 MAIN STREETAUSTINTX78768-—
TPATPA-512522026-08-28T09:02:06ZJulia····Gomez1999-11-19——4458330045julia.gomez46@hotmail.com8426 Lincoln WaySEATTLEWashington98137NULLOPTIONS-PPO
TPATPA-582302026-08-18T05:55:13ZRandy—Burke1948-05-15—··8847517389-1425 River RdMINNEAPOLISMN55464GRP-8412MEDICARE-ADV-B
TPATPA-539202026-01-08T20:57:53ZPatrick—Lewis1979-06-05N/A•••-••-9612618-423-4663null4359 Forest AveNashvilleTN37277GRP-7617NAVIGATE-HMO
TPATPA-552622026-04-01T00:07:57ZAna—Mejia1990-02-18UNKNOWN•••-••-2196····—N/A—UNKNOWNNULLGRP-7523null
TPATPA-544852026-04-15T04:51:34ZrussellWwong1985-05-08UHC-32502-69—N/AUNKNOWN·6766 DESERT SKY BOULEVARDHOUSTONTX77022——
TPATPA-527782026-08-04T13:43:31ZSanders, Arjun——1916-05-25N/A•••-••-2519null-—··——-null··
TPATPA-519332026-10-02T16:48:08ZJeffrey—Gonazles1985-09-07UNKNOWN—(863) 552-6222—4424 Valley View DrTucsonAZ85777-MEDICARE-ADV-A
TPATPA-524852026-03-14T08:11:31ZDavid····Burns17-09-1963··-•••-••-5278—·····7628 DESERT SKY BOULEVARDSCOTTSDALEAZ85254—OPTIONS-PPO
TPATPA-549562026-08-08T02:59:05ZDonna—JamesJun 8, 2006UHC-73198-99-nullN/A6962 Mesa DriveMIAMI··FL33154NULLNAVIGATE-HMO
TPA TPA-502402026-06-06T02:09:36ZMATTHEW··—LAWSON1995-05-15—UNKNOWN618-707-1093····4892 PINE DRMesaAZ85248-7396GRP-3845OPTIONS-PPO
TPATPA-623312026-10-17T11:15:47ZMarcus····Montgomery07-02-1966UNKNOWN—UNKNOWNN/A1942 Meadow LaneChandlerAZ85203nullN/A
TPATPA-597162026-07-12T04:30:38Zkayla—·lewis1978-06-27-•••-••-7031UNKNOWNKAYLA.LEWIS32@PROTON.ME8719 OCEAN AVENUEGilbertAZ·85269-—
TPATPA-564122026-02-15T19:46:53ZWang, Patricia M.——0184-19-50—•••-••-0568··UNKNOWN8628 Maple AvenuePlanoTX75036··nullN/A
14,474 rows, page 88 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.642Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty