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-613392026-04-20T16:07:15ZMei—Maldonado1945-11-02-··•••-••-9797——7457 PARK PL·HoustonTX77082-NULL
TPATPA-50109 2026-01-08T21:42:25Zjeremy—adams04-07-1971-•••-••-5028NULL··—4817 OAK STREETAustinTX78775-0078—NULL
TPATPA-545562026-08-09T09:15:18Z christian—griffni2008-04-24N/A·N/A985-350-3859christian.griffin97@yahoo.com3553 HIGHLAND AVENUEGlendaleAZ85351—NULL
TPATPA-527752026-03-04T02:29:06ZNicole··RoodriguezMay 7, 2008null•••-••-7223985-984-2278N/A9401 OCEAN AVETempeAZ85221GRP-5701null
TPATPA-543952026-09-23T16:42:48Zzachary—bryant4/7/1962—•••-••-5915880-588-4220zachary.bryant@proton.me1554 Lincoln WayFRESNOCA93768—-
TPATPA-507492026-09-05T01:59:19ZANDREA—HOLMES1965-05-05——N/AN/A1113 River RoadAtlantaGA30336—MEDICARE-ADV-B··
TPATPA-583322026-02-09T10:36:52Z·ARTHUR—MORGAN1960-10-08UNKNOWN———166 BroadwayHoustonTX··77045nullN/A
TPATPA-558292026-09-22T15:57:31ZRonald·J.Snyder07/20/1957UNKNOWNNULLnullNULL1398 HARBOR BOULEVARDTampaFlorida··33605-1040—-
TPATPA-597062026-09-04T23:43:05ZJeffrey—Dominguez05/18/1962—•••-••-5938null-6186 BASELINE RDSacramentoCA95851null—
TPATPA-593932026-05-08T05:07:32ZRobert······MartinezSep 5, 1988—null287-345-0791robert.martinez87@aol.com3358 Cedar LaneHoustonTX77053—UNKNOWN
TPATPA-502022026-04-02T22:09:18ZJohn—Contreras1974-04-23nullnull—N/A5777 BAYSHORE DRIVEDenverCO80279GRP-7634MEDICARE-ADV-B··
TPATPA-537682026-05-10T02:52:16ZLawson, Jerry——1992-06-03UNKNOWN—559-620-5988··null——-N/AGRP-0775CHOICE-PLUS-PPO
TPATPA-606852026-07-05T03:06:45ZKATHERINEIHART1992-03-19UNKNOWNN/A18145279302—····—UNKNOWN······NULL-
TPATPA-642742026-10-03T00:57:21ZRussell—Mitchell13-05-1992N/A-nullUNKNOWN5643 Washington StreetChandler·AZN/AGRP-1176N/A
TPATPA-581192026-04-19T01:36:55Zmichelle—kennedy1949-05-17····null·-michelle.kennedy78@aol.comN/ANULLnull·NULLUNKNOWNMEDICARE-ADV-A··
TPATPA-596282026-06-02T00:13:13ZWells, Robert—··1998-08-26····UNKNOWN-robert.wells73@yahoo.com6881 OCEAN AVENashville··TN37279GRP-2743null··
TPATPA-554132026-04-01T20:33:54ZSAMUEL—·HOFFMAN0802-16-95-UNKNOWN+1 363 624 3972N/A4480 SUNSET BLVDSan AntonioTX·78279·UNKNOWNNULL
TPATPA-502502026-07-24T10:26:59ZVINCENT—SPENCER·Mar 28, 1964UHC-64486-33UNKNOWN—·····4532 Sunset BlvdHouston··TX—nullN/A
TPATPA-559152026-03-15T16:17:34ZSteve—Dixon1996-11-03·N/AUNKNOWNnullnull8339 Meadow LaneDallasTX75222GRP-9512UNKNOWN
TPATPA-509902026-10-01T21:40:38ZANA—SINGH6/17/1964N/A•••-••-4849282-557-2922ANA.SINGH@HOTMAIL.COM1586 PARK PLACESacramentoCA95875GRP-2618SELECT-EPO
TPATPA-622712026-02-27T04:03:13ZJoan—Clark1944-05-16null··-405-533-7590—1521 Lake View Rd··ColumbusOhio43206·GRP-6688SELECT-EPO
TPATPA-575892026-05-26T00:59:15ZRUSSELL—LUCAS1973-06-11-•••-••-2006—NULL8307 INDIAN SCHOOL RDSEATTLEWA··98174-··MEDICARE-ADV-B
TPATPA-594632026-10-03T17:45:44ZMARIA—·GARCIA1981-09-10UHC2687243N/A16287714238N/A3787 Mountain View DrHoustonTX77048—····
TPATPA-546922026-08-12T08:44:49ZANNA—OLIVER1950-05-12null•••-••-8515UNKNOWNNULL··4879 Main StLos AngelesCA90038-2692GRP-5485CORE-HMO
TPATPA-614532026-03-05T02:50:02ZEMMA—ROBERTS1991-08-21UHC-03591-23——NULL5631 Mesa DrFresnoCA93740nullnavigate-hmo
TPATPA-601542026-01-14T23:47:28ZJudy—Welch··Jun 8, 1968null•••-••-8948UNKNOWN-4253 Lake View RoadGilbertAZ85255—NULL
TPATPA-611792026-03-06T02:15:56ZAna—·Warren1963-01-25null—898-527-2346—4132 Hillcrest RdChandlerAZ85225—··
TPATPA-520262026-07-18T19:59:39ZSean—Torres··19390418—•••-••-0543NULL··NULL··1225 Park PlaceLAS VEGASNV89121GRP-7491NAVIGATE-HMO
TPATPA-537612026-07-06T20:26:47ZSanchez, JoshuaO—1998-09-25N/A—394-490-2554UNKNOWN7066 Lincoln WayDallasTexas75282UNKNOWN—
TPATPA-606412026-08-05T15:36:42ZSue—Contreras1964-09-27--(461) 214-0376SUSAN.CONTRERAS32@YAHOO.COM1830 Maple AvenueSan DiegoCA92196-OPTIONS-PPO
TPATPA-53225 2026-03-27T12:59:36ZPAUUL—HAMILTON19790427null•••-••-2116—NULL3908 Maple AveLos AngelesCA90064null··NULL
TPATPA-629282026-07-07T13:28:26ZArjun—Meyer24-05-2006··UNKNOWNN/Anull—3470 Jefferson Ave··PhoenixAZ85009—choice-plus-ppo
TPATPA-514412026-07-23T07:23:36ZTran, Teresa——1997-11-01—NULLN/AUNKNOWN9048 Grand AvenueCHARLOTTENC28221UNKNOWN-
TPATPA-542182026-03-08T12:04:54Z·LAWRENCE—BANKS1978-09-08—null5354229068null8422 Jefferson AveColumbus··OHUNKNOWNnull—
TPATPA-526092026-02-06T17:49:00ZMADISON—GRAY01/25/78UNKNOWN····+1 283 979 7952madison.gray@outlook.com1612 Baseline RoadSAN ANTONIOTexas··UNKNOWNNULLSELECT-EPO
TPATPA-602292026-03-07T07:54:06ZMichelle—Medez1967-12-20·nullN/A(600) 238-0164N/A1553 HILLCREST RD #913Sacramento··CA·95820GRP-8762—
TPATPA-525382026-08-15T04:00:29ZELIJAH—SIMS05/19/1991N/A-335-466-8249—2636 HIGHLAND AVESacramentoCA95889—MEDICARE-ADV-A
TPATPA-607432026-01-14T14:01:50ZJacqueline—Lewis1979-05-16—•••-••-3063—null9882 SAGE CTSan DiegoCAUNKNOWN-UNKNOWN
TPATPA-531772026-03-21T03:03:26ZFrankO·Sanchez1941-11-17UNKNOWNN/A(823) 393-9383frank.sanchez75@hotmail.com2748 Sage CourtSEATTLEWA98163·GRP-0376null
TPATPA-574362026-08-16T20:23:58ZMIKE—BARNES1951-12-12··UNKNOWNUNKNOWN288-378-9898-8521 Desert Sky Boulevard Apt 9JacksonvilleFL32220——
TPATPA-604702026-04-19T01:33:27ZALEXIS—EDWARDS2002-05-11N/A—NULLalexis.edwards32@yahoo.com2299 CEDAR LNAtlantaGA30320GRP-7672·-
TPATPA-638312026-07-22T11:50:57Zmarcus—valdezFeb 25, 1964··——UNKNOWN—7713 RIDGE RDSCOTTSDALEAZ··85264NULLNULL
TPATPA-524212026-03-15T18:16:25ZPowell, Thomas——1965-12-19N/AUNKNOWN(426) 474-9031UNKNOWN1837 Palm DrAtlantaGA30397N/A··NAVIGATE-HMO
TPATPA-56108 2026-04-12T06:39:13ZHenryCReynolds1964-10-26UHC-48672-91—499-248-4591henry.reynolds38@hotmail.com3404 Central AveFresnoCA93797GRP-5359—
TPATPA-633032026-08-19T00:39:42ZJUSTIN—WARRENJan 18, 2007—•••-••-4417352-905-2564—9861 Harbor BlvdAtlantaGAUNKNOWNGRP-8124MEDICARE-ADV-A
TPATPA-511512026-03-21T05:15:06ZJUAN—WHEELER··1984-09-25··nullNULL——1189 Ocean AvenueScottsdale··AZ85274GRP-3189UNKNOWN
TPATPA-642072026-06-23T04:24:04Zlaura—pierce04/09/05—•••-••-1107(704) 309-1944NULLnullNULLUNKNOWN—N/A—
TPATPA-620892026-06-19T15:02:10ZStephanie—Bnnett1990-02-04nullN/AUNKNOWNnull9669 Maple AvenueGlendaleAZ85301N/A—
TPATPA-519352026-08-22T12:15:05ZBENJAMIN—BOWMAN19920521null——-8468 Willow Court··COLUMBUSOH43269GRP-5892—
TPATPA-500062026-10-06T08:59:17ZNOAH—ESTRADA10-02-1992-•••-••-3478-—6313 Desert Sky BoulevardEDEN PRAIRIEMN·55315····MEDICARE-ADV-B
14,474 rows, page 151 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:49.099Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty