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-516962026-06-30T14:34:18ZWayne—Marshall2002-05-04··UNKNOWNnull—null·NULL—NULL—MEDICARE-ADV-B
TPATPA-626402026-05-28T08:34:50Zdonald—gomez1938-04-07—-NULLNULL6300 Ocean AvenuePlanoTX75011nullnull
TPATPA-523202026-03-10T21:26:50ZKATHRYN··GARCIA1978-03-16UHC-36279-13NULL——6454 Indian School RdColumbusOH43299-NAVIGATE-HMO
TPATPA-504312026-05-13T09:31:55ZBRANDON—GONZALES1966-05-07—·nullN/A—1764 Ocean Ave·PlanoTX75060GRP-0304—
TPATPA-507262026-03-05T16:03:08ZHart, AhmedK—1960-03-01—nullNULL—·4445 Jefferson AvenueLos AngelesCA90039—··
TPATPA-520752026-07-29T10:53:11ZCAMILA—PEREZ1965-07-28-•••-••-1230N/A-3706 Jefferson AvenueSAN ANTONIOTX78253-OPTIONS-PPO
TPATPA-579722026-08-10T12:09:22Zsusan····murphy1969-07-25NULL··N/A(383) 549-2958—·6103 Meadow LnEden PrairieMN··55316··NULL
TPATPA-586142026-07-18T11:43:35ZLogan—Schmidt05/01/40nullnull·(242) 224-0261logan.schmidt@outlook.com1699 Desert Sky BlvdMesaAZ85237—UNKNOWN
TPATPA-512642026-08-24T00:11:38ZANTHOONY··—GILBERT1968-05-02-——N/AUNKNOWNnullNULL-GRP-5921NULL
TPATPA-532322026-08-11T00:39:46ZLISA—FULLER19490723UNKNOWN•••-••-8171213.210.4337····UNKNOWN——nullUNKNOWN—
TPATPA-597862026-02-24T15:09:01Z·Benjamin—Santos1967-09-27UHC-77350-11NULL521-734-2562UNKNOWN6844 Main StTampaFL33656UNKNOWN—
TPATPA-568252026-02-09T20:00:25Zmelissa—espinoza1983-01-01····—(875) 725-3436-4879 JEFFERSON AVENUETucsonArizona85717—NAVIGATE-HMO
TPATPA-568142026-04-13T10:22:45Z Martinez, Raymond——1964-07-23uhc-76339-68-13256581547N/A5764 Desert Sky BoulevardSCOTTSDALEAZ··85244-—
TPATPA-600472026-04-02T12:12:28ZRuthKAguilar1995-07-04NULLN/A6329985888UNKNOWN·7008 Cedar LaneMesaAZ85207—NULL
TPATPA-562962026-05-13T22:20:20Zjose—lopez01/13/2001UHC-63472-97—(410) 284-7568-1260 ELM STPlanoTX75012GRP-3917—
TPATPA-550192026-04-02T05:49:20ZGardner, Mason——02/01/1957—-(513) 281-6326N/A1165 OAK STREETTUCSONAZ85786UNKNOWNNULL
TPATPA-619302026-03-26T16:27:20ZAaronZ.Murphy1966-01-06-•••-••-6162957-732-7505—-·UNKNOWN——NULLN/A
TPATPA-606322026-03-16T04:17:46ZArthur—Johnston1943-01-08UNKNOWN•••-••-7353—ARTHUR.JOHNSTON60@GMAIL.COM9472 Cedar LanePLANOTX75067··NULL—
TPATPA-614932026-01-24T00:31:09ZSara··—Gordon1942-10-07··UNKNOWN•••-••-3057(357) 316-9412NULL7925 Highland AvenueTAMPAFL33697NULL—
TPATPA-525592026-01-26T04:40:31Zmatthew—ryan1972-02-10UHC8703903NULL——2434 Willow CourtEden PrairieMN55386NULLNAVIGATE-HMO
TPATPA-630342026-02-13T18:10:44ZLucia—Le1959-09-08UHC-53838-39··NULL—NULL7725 PINE DRIVELas VegasNV89168-null
TPATPA-516832026-07-01T03:26:11ZGabril—Fisher··1962-02-02··—UNKNOWNNULLUNKNOWN3157 Baseline RdChandlerAZ85283—-
TPATPA-530262026-02-10T04:21:41Z·RUTH—HOFFMAN1997-04-14-N/A-·NULL1820 Market StreetMESAArizona85244null·-
TPATPA-632822026-01-09T07:19:44ZFrances—Ward1952-09-13UNKNOWN—19484447029UNKNOWN·5381 LINCOLN WAYFresnoCA93702GRP-2117—
TPATPA-603212026-01-24T08:20:32ZPatricia—Coper1938-05-02null—NULLUNKNOWN·3209 Baseline RdFresnoCA93792··N/AMEDICARE-ADV-A
TPATPA-615692026-03-28T16:42:20Z Barbara··E·Dun2007-01-04—•••-••-1077-BARBARA.DUNN31@HOTMAIL.COM8620 Cedar LnMiamiFL33198GRP-4968NULL
TPA TPA-520482026-01-26T10:22:12ZVincent—Contreras05/18/92NULL····nullvincent.contreras@gmail.com5174 Forest AveTucsonAZ85732-3782-MEDICARE-ADV-B
TPA TPA-635032026-06-23T02:41:30Z HEATHER—RAMIREZ1986-12-06····•••-••-01073633602643—8776 Apache BlvdMinneapolis·MN55488—SELECT-EPO
TPATPA-531712026-06-15T20:41:06Zlori··—williamsJul 3, 1984··UHC2978873NULL12018001039—7301 Mountain View DriveTEMPEAZ85213—N/A
TPATPA-569652026-04-09T11:47:30ZBetty—·Hart1993-04-17—•••-••-891419158180225null4852 UNION STREETCharlotteNC——CORE-HMO
TPATPA-524472026-09-15T17:22:41ZCHRISTINE—WARD9199-12-10····——··1291 LINCOLN WAYMesaAZ85216NULLSELECT-EPO
TPATPA-610652026-02-21T16:20:28ZValentina—Alexander7/19/1951··—N/AUNKNOWNN/A2332 Lincoln WayMIAMIFL33131N/AUNKNOWN
TPATPA-538692026-08-29T03:35:40ZBeverly—Wilson·1942-07-05——NULLNULL6056 Forest Ave··JACKSONVILLEFlorida32289GRP-1679N/A
TPATPA-506842026-10-01T17:50:39ZOmar····OBrien11/08/73—····null————N/A—····
TPATPA-530792026-09-24T23:20:08ZDAVID—HENRY5201-19-64N/A•••-••-52814593083073N/A4431 Harbor BoulevardCharlotteNC—nullNULL
TPATPA-520022026-04-24T18:27:22Z·Scott—Richardson0501-69-80N/A—4541600-5331 Highland AveGilbertAZ·85297UNKNOWNNULL
TPATPA-513142026-01-18T16:07:21ZValentina—Banks1954-05-17—····null—7203 Palm DrAtlantaGA30397—null
TPATPA-544672026-04-20T19:29:57ZGloria····Fisher19760813N/AUNKNOWN3936137808gloria.fisher14@icloud.com3183 Mesa DriveTAMPAFL33644N/AMEDICARE-ADV-B
TPATPA-529742026-06-16T00:39:51ZMichael—Olson1956-12-01····—·N/AUNKNOWN7701 Bayshore DriveNashvilleTN37265—NULL
TPATPA-601432026-08-10T13:34:07ZWatkins, Amber——10/16/76NULL——UNKNOWN9383 Baseline RdTempeAZ—GRP-5275—
TPATPA-530252026-04-20T00:50:57ZRutth—Harvey10/13/40UHC-80628-18··•••-••-7466NULL—5958 Main St·GILBERTAZ85225-9648—null
TPATPA-610892026-05-17T02:54:05ZDean, Diana——1970-06-22—NULL515-452-9362·-2271 Indian School RoadOrlandoFL32852-9729NULLmedicare-adv-b
TPATPA-638482026-08-18T00:11:43ZLogan—Pierce1978-12-19UNKNOWN—386-607-7385··7115 Elm StDallas·TX75238NULLCHOICE-PLUS-PPO
TPATPA-576972026-02-02T23:32:34ZHart, Jack——2004-03-07····•••-••-94186623531282—5071 HILLCREST RDPlanoTX75086GRP-3643SELECT-EPO
TPATPA-59503 2026-06-21T06:19:13ZGrahm—Deborah1986-12-05-—--5543 Maple AvenueSan AntonioTX78220GRP-4642null
TPATPA-634382026-01-18T22:50:27ZKELLY··—WATSON1986-04-16·nullN/A-kelly.watson@proton.me7815 Lake View Road Apt 12DallasTX75216GRP-5770NAVIGATE-HMO
TPATPA-601172026-10-04T10:07:44ZRuth—Parker06/02/1984—N/A5613152704NULL6694 Sage CtChandlerAZ·85263——
TPATPA-579132026-02-21T19:58:37Zann—ford01/09/43-····N/AN/A3659 Ridge RoadHoustonTexas77081··CHOICE-PLUS-PPO
TPATPA-614972026-06-19T06:26:43ZDOROTHY—FISHER1990-08-05—UNKNOWN-—9204 APACHE BLVD #379Los AngelesCA-—-
TPATPA-574052026-05-08T15:09:16ZFRANK—WEBERMar 2, 1956UNKNOWN—·(802) 817-0414null··3595 VALLEY VIEW DRIVEGlendaleAZ85311—NULL
14,474 rows, page 118 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:46.053Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty