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-507372026-10-07T13:26:20ZVirginia—Castillo6/6/1992UHC-00947-15N/A-—6133 Canyon RdLos AngelesCA90090GRP-5217OPTIONS-PPO
TPATPA-584132026-08-02T05:19:05ZSHARONM.ORTEGA1972-05-08—•••-••-9676NULLsharon.ortega@proton.me9011 Willow CtATLANTAGA30306-8010GRP-5646—
TPATPA-559682026-08-28T14:06:09ZMary—·Cox08/03/1990-UNKNOWN(717) 366-8430—8887 Lincoln WayDenverCO80277—OPTIONS-PPO
TPATPA-587232026-08-14T13:44:19ZMargareet—Gutierrez1990-06-05UHC-61468-65NULLNULL—6810 RIDGE ROAD·FresnoCA93792——
TPATPA-598462026-04-14T08:11:10ZJOAN—SIMMONS1939-09-06—NULL19028903731—896 Bayshore Drive··TempeAZ··85298GRP-0205MEDICARE-ADV-A
TPATPA-625562026-03-22T09:36:03Zlauren—·vasquez1960-10-16-NULL422-541-0360·N/A8820 Ridge RoadMINNEAPOLIS··MN55411UNKNOWNUNKNOWN
TPATPA-638982026-04-07T02:28:50ZMegan—Graham1982-03-09—N/AnullN/A·N/AUNKNOWN—UNKNOWN-UNKNOWN
TPATPA-571242026-02-05T00:12:24ZKEITH··HENRY1976-10-20——-keith.henry@yahoo.com1963 Canyon RdGlendaleaz-GRP-0656—
TPATPA-635792026-08-03T06:46:31ZBowman··—Fatima08-06-1989—·-N/A-1185 Apache BlvdDenverCO80219—null
TPATPA-550512026-04-03T19:41:10ZButler, Eric—····7/3/1965—•••-••-4305—-8200 Maple AveSAN ANTONIOTX78217-CHOICE-PLUS-PPO
TPATPA-515302026-10-01T20:34:44Z GARY—RICHARDSON1954-08-03null•••-••-8400·nullnull5154 MOUNTAIN VIEW DRIVEEden Prairiemn55336-MEDICARE-ADV-A
TPATPA-551402026-06-25T17:06:24ZMason··Murphy1956-11-11UNKNOWN······N/Anull3805 Pine DriveEden PrairieMN55300-3929-··
TPATPA-636492026-06-25T10:30:12ZRoss, GabrielK—1980-11-08UHC-60294-05-—UNKNOWN2470 Hillcrest RoadJacksonville··FL32296-9925—MEDICARE-ADV-B
TPA TPA-524202026-04-27T13:24:22ZGRACE—RMAOS19891027UNKNOWNNULL941.277.5238—8508 Maple AveMINNEAPOLISMNUNKNOWNN/A—
TPATPA-577192026-04-22T03:17:37ZDiana—·Moraales1957-12-27nullUNKNOWN16607107124NULLUNKNOWNNULLUNKNOWN—UNKNOWN·OPTIONS-PPO
TPATPA-516792026-05-31T22:35:29ZRaymond—·Ramos2003-12-14UHC-67665-29UNKNOWN574-949-1412NULL2185 CHURCH STREETMinneapolisMN55488-UNKNOWN
TPATPA-502412026-03-15T14:16:12ZMatt—·Lawson1995-05-15N/A——UNKNOWN4892 PINE DRMESAAZUNKNOWN··—
TPA TPA-544142026-04-25T17:26:30ZHenry—Shaaw1940-04-80UHC7533668•••-••-9121(364) 837-9296—6601 Indian School RoadTucsonAZ85703N/AMEDICARE-ADV-B
TPATPA-583202026-02-27T09:13:47Z·Juan—AllenJun 19, 1966UNKNOWN•••-••-6091(907) 422-3152-8205 WASHINGTON STREETTAMPAFL·33688—·CHOICE-PLUS-PPO
TPATPA-518132026-07-13T10:28:24Zmei—mroris1961-01-21UHC-84477-97-723-498-3223UNKNOWN4799 Central AvenueSacramentoCalifornia95860—UNKNOWN
TPATPA-547012026-09-22T12:42:08ZDiana—Reynolds··19-07-1970··-—N/A6536 Lake View Rd #545FresnoCANULLGRP-5677—
TPATPA-627522026-07-12T05:29:46ZLogan··Scott1988-08-15UNKNOWN—5052434196····9396 Cedar LnNashvilleTN37243N/AN/A
TPATPA-586372026-05-04T03:38:15ZPETER—FRANKLIN1976-07-04·UHC-08797-98-NULLNULL———-nullN/A
TPATPA-557812026-03-16T01:23:26ZAaron—Rojas08-11-1980null—316-435-2379—-UNKNOWNUNKNOWN—GRP-2167NULL
TPATPA-629392026-06-16T20:41:06ZHarold····Butler19390828UHC-48098-73——harold.butler@proton.me151 Valley View DriveSEATTLE·WA98145·nullUNKNOWN
TPATPA-575322026-09-17T06:28:36ZGARY—CARR1957-05-06null•••-••-2670——9019 WASHINGTON STScottsdaleAZ85209·nullUNKNOWN··
TPATPA-523872026-07-28T19:28:20ZSOPHIA····RIOS1975-04-07N/A—+1 633 898 4923N/A-——-—NULL
TPATPA-594262026-03-07T04:32:38ZPeter—Ferguson25-03-1948—null—peter.ferguson86@proton.me·1560 CENTRAL AVENUEHoustonTX·77066-—
TPATPA-570412026-08-25T04:44:23ZARJUN··—·HARRIS10/27/53UHC-71965-17··null—·UNKNOWN777 Lake View RdEden PrairieMN55398GRP-9909·N/A
TPATPA-560562026-03-31T14:11:45Z Alice—Baker19520416N/A•••-••-0987——2666 Church StreetGilbertAZ85211—null
TPATPA-619132026-09-04T08:08:28ZJACOBEALVARADO19530216UHC-96879-20——N/A·8878 OCEAN AVENASHVILLETN37269—NAVIGATE-HMO
TPATPA-605352026-02-16T02:32:17ZAaron—Hill1950-31-22nullNULL(920) 476-1283null6660 Willow CourtNashvilleTN37256-MEDICARE-ADV-A
TPATPA-515782026-02-05T12:58:22ZMegan—Little09/25/1998—UNKNOWN··—-2116 Washington Street #340·DallasTX·NULL——
TPATPA-568232026-01-17T05:02:06ZOlivya—Perez1963-04-16null—UNKNOWNUNKNOWN1737 Union Street··TampaFlorida33689GRP-4040medicare-adv-a
TPATPA-616972026-05-26T06:20:03Z·Philip—Brooks07-04-1954——(950) 628-2571·-2349 Central Ave Apt 29Tucsonaz—-—
TPATPA-512072026-07-28T16:59:29ZLAWRENCE—NICHOLS1994-01-19—•••-••-6994—null1338 Union Street Apt 37OrlandoFL32862GRP-3945null
TPATPA-57522 2026-04-11T13:17:04ZThomas—Foster1999-05-26—N/A387-744-4007thomas.foster78@gmail.com·369 OCEAN AVEDENVERCO80260-7847NULLN/A
TPATPA-638932026-07-13T11:34:20ZIsabella—Sims1954-11-28UHC2523477null2386406617-6026 BASELINE ROADDallasTX75260-2406GRP-8112N/A
TPATPA-601282026-03-02T07:29:40ZJoseph—Young1950-05-13-•••-••-5713-joseph.young40@outlook.com8157 Highland AvenueScottsdaleAZ85245—null
TPATPA-550122026-02-15T13:25:17ZEMMA—HARRISON1939-12-13N/A··-··N/A—1925 Mountain View DrMIAMIFL33123-UNKNOWN
TPATPA-637492026-01-10T15:31:28Z JOE—VARGAS1973-02-82—•••-••-2860UNKNOWN—··—nullNULLN/ANULL
TPATPA-575492026-06-09T12:26:42ZAnna—ColemanJun 19, 1971—•••-••-6106N/A—5577 ELM STREETGilbertAZ85238-N/A
TPATPA-603762026-03-14T14:09:57ZHarold—Franklin1980-02-23——870-553-9675-8586 Sage Court #900ScottsdaleAZ·85291nullCORE-HMO
TPATPA-620422026-10-04T22:36:49Z·OLIVIA—LYNCH1991-07-18—-——4811 Central Ave·DALLASTX75243-8580GRP-9992··null
TPATPA-606972026-08-16T08:08:36ZJACCK—BARNES1940-07-25UHC-58851-08•••-••-2377N/AUNKNOWN··5734 Washington StreetAtlantaGA—··NAVIGATE-HMO
TPATPA-521022026-10-04T00:35:44Z·Sean—Hawkins1985-10-16null—-—89 Desert Sky BoulevardNashvilletn37232GRP-2780-
TPATPA-522752026-07-24T18:13:14ZJOE—·COOK1938-06-26—null——8840 Elm StDallasTX75206—-··
TPATPA-501442026-10-18T08:08:08ZElizabeth—Munoz1982-02-13-•••-••-8954497.688.2099—4165 Willow CourtColumbusOHNULLN/ANULL
TPATPA-539692026-09-20T06:32:49ZBilly—Le19400119—null—·NULL5795 Baseline RoadGLENDALEAZ—GRP-6426N/A··
TPATPA-627042026-06-05T17:31:08Zpamela—cooper04/16/93NULL··5995635429null7204 Indian School RdMiamiFL33107GRP-3246UNKNOWN
14,474 rows, page 89 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:43.414Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty