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-52614 2026-05-10T21:16:55Zdiego—·bradley1980-01-15—UNKNOWN—····6562 Oak StMiamiFL33193GRP-3806UNKNOWN
TPATPA-641522026-04-05T16:41:46ZHelen—Rivera1960-06-28null—+1 924 989 8584—2648 SUNSET BOULEVARDMesaAZ85267GRP-2098MEDICARE-ADV-B
TPATPA-618852026-02-03T07:37:25ZAMANDA—SANTIAGO1951-07-28UNKNOWN··N/AN/AUNKNOWN275 Park Pl··AustinTX78788—MEDICARE-ADV-B··
TPATPA-554492026-07-13T02:41:34ZBerry, Heather··—1949-90-19null·null—-UNKNOWN—-UNKNOWN—UNKNOWN
TPATPA-631922026-02-11T14:57:16ZRALPH—FOWLER1998-08-16———null3163 Oak StMIAMIFL33166——
TPATPA-587262026-06-03T18:04:01ZSean—·Vargas1948-02-26-•••-••-71475224060065SEAN.VARGAS@HOTMAIL.COM2813 Church Street Apt 2Phoenix··Arizona85082GRP-7437UNKNOWN
TPATPA-568812026-05-08T12:33:23ZRonald—Herrera1980-09-14—nullNULL—2219 Canyon Rd·ORLANDOFL32868N/A—
TPATPA-514462026-09-16T15:34:27ZEVELYN····DELGADO19390807——N/A-null—N/AUNKNOWNNULLMEDICARE-ADV-A
TPATPA-538482026-06-27T22:04:10Z ·Andrea—·Bell2007-01-24-•••-••-5393(223) 457-2865-4106 BASELINE ROADAUSTINTX78713—OPTIONS-PPO
TPATPA-553112026-09-02T03:13:54ZNathan··Black1977-10-02—null·5625471952—-nullnull-GRP-9903MEDICARE-ADV-A
TPATPA-511942026-01-13T11:29:28ZJudith—·Ramirez11/2/1964NULLN/AN/A—1023 Canyon RoadMesa··AZ85283—NULL
TPATPA-563442026-06-01T13:35:41ZDIANE—WEAVER1964-05-12—-652.384.9284N/A2791 MAPLE AVEAtlanta··GA30319-0270—null
TPATPA-589972026-01-26T12:54:19ZRomero, Maria——03/15/1964UNKNOWN··-MARIA.ROMERO5@OUTLOOK.COM4347 Willow Court·DallasTX··75275N/ANULL
TPATPA-552572026-04-10T05:59:31ZSophia—Montgomery1947-01-08NULLnull7222811380sophia.montgomery@hotmail.com··2573 OAK STREETAustinTX78708-9244GRP-0647NULL
TPATPA-599422026-09-07T05:03:29ZMaarilyn—Yang11/6/1980null—412-910-6999N/A7292 River RoadCharlotteNC28209N/A—
TPATPA-512152026-01-06T07:11:53ZEUGENE—ESPINOZA1945-12-11—•••-••-1006(759) 292-3712··—4711 MOUNTAIN VIEW DRIVEHoustonTexas-GRP-6346······
TPATPA-615772026-03-29T23:28:08ZWalter··—Reyes19920413UHC-60664-75•••-••-0035UNKNOWNNULL3935 Lake View RoadSeattleWA··98141··GRP-5995UNKNOWN
TPATPA-573082026-07-02T06:44:10ZBEVERLY—·WOODS·26-08-1939——·4206867407UNKNOWN715 Willow CtCHANDLERAZ85277UNKNOWN—
TPATPA-602082026-08-30T18:55:58ZKyle—Carlson2002-02-21-—N/A—7284 Harbor BlvdGlendaleArizona85398—-
TPATPA-563122026-06-30T14:17:01ZMARGARET—RICE03/12/2001N/A——margaret.rice5@proton.me1283 CHURCH STREETEDEN PRAIRIEMN55387··—NAVIGATE-HMO
TPATPA-524802026-03-28T14:45:15ZjeremyOhenryAug 1, 2005NULLNULL(630) 982-2037-5034 Main StreetCharlotteNC28222UNKNOWN··null
TPATPA-608042026-07-14T22:05:41ZMelissa—White1971-80-14N/A—nullnull7238 Canyon RdNashvilleTN37234N/A—
TPATPA-58244 2026-09-07T01:47:00ZMaiaB.Gonzales2104-91-46UNKNOWN•••-••-1501(483) 338-1608·-6725 BAYSHORE DRGlendaleAZ85330——
TPATPA-550142026-02-07T06:37:04ZBillyHAlexander1946-04-05UNKNOWN—481.481.7040—1182 Central Avenue··TAMPAFL33694GRP-9892··—
TPATPA-570862026-06-10T16:21:48ZJanice—Taylor1963-03-26NULL—(319) 875-6413···null3353 CANYON ROAD Apt 4··EDEN PRAIRIEMN55397—null··
TPATPA-545812026-05-25T07:48:52Zcatherine—washington06/24/1944—NULLNULL-386 Forest AveDallasTX75294UNKNOWNN/A
TPA TPA-526652026-02-11T13:47:30Zhelen—olivverJun 11, 1953··UNKNOWN—-null7373 HILLCREST RDSan AntonioTX·78268—NULL
TPATPA-597942026-05-31T00:27:15Zjacob··Canderson19390706null•••-••-4828502-554-7768··—2590 MAPLE AVESEATTLEWA98194·GRP-4532core-hmo
TPATPA-617562026-02-15T21:25:08ZBARBARA—JOHNSTON1973-12-10-N/A··8266139748barbara.johnston98@gmail.com7133 Apache BlvdTampaFlorida33651-NULL
TPATPA-594382026-05-21T18:59:23ZGuerrero, Ronald—··1953-09-22UNKNOWNNULL+1 814 994 9320RONALD.GUERRERO2@HOTMAIL.COM8347 Market Street #779·ScottsdaleAZ85262-2723NULL··UNKNOWN
TPATPA-51860 2026-04-19T19:27:04ZNicholasS.Fuller1983-02-08null—3246093501—4462 Sage CtLas VegasNV89144-—
TPATPA-541502026-03-19T19:09:12ZJacob—Aguilar1969-02-26UNKNOWN—-NULL8043 Palm DrTampaFL33622GRP-1630—
TPATPA-528182026-07-15T02:07:04ZHEATHERN.SINGH1948-01-09—•••-••-3106(424) 433-9075—6811 Elm StreetPlanoTX75098GRP-2204—
TPATPA-509602026-09-03T04:44:07ZChristina—Bradley1958-08-26N/A-9852474058····934 Apache BoulevardPLANOTX75078-CHOICE-PLUS-PPO
TPATPA-529352026-05-14T01:07:42ZLittle, Johnny——May 2, 1968·-—null—1768 Maple AvenueGilbertArizona85254UNKNOWNUNKNOWN··
TPATPA-576762026-02-09T04:19:01ZRachel··—Evans1929-12-22-—NULLUNKNOWN6573 Grand AveEden PrairieMN55380NULLmedicare-adv-b
TPATPA-56796 2026-03-11T09:27:16ZWEI—ANDREWS1953-01-16····•••-••-1720N/AUNKNOWN9640 Baseline RdGlendaleAZ85357-—
TPATPA-569782026-02-20T03:01:19ZOliviaDHunter1948-05-23——12374301747olivia.hunter@hotmail.com785 CEDAR LNSeattleWA98166nullSELECT-EPO
TPATPA-549802026-09-19T15:22:03ZDylan—Deaan04/18/40N/A•••-••-5573(372) 281-3844—3307 Apache BoulevardAtlantaGA———
TPATPA-587282026-02-14T23:37:59ZJustin—Elliott2007-08-16NULL-UNKNOWNnull797 Mountain View DrivePhoenixAZ85043··GRP-3248N/A
TPATPA-501592026-01-16T18:48:50ZHELEN··—LUNA01/13/55UNKNOWN•••-••-7864387-865-3496·NULL6305 Palm DriveDallas··TX75259NULL—
TPATPA-624432026-08-25T17:15:51ZBRUCE—GAARRETT1950-06-24UNKNOWN•••-••-2246nullnull9636 Bayshore DriveCOLUMBUSOH··43299N/A··MEDICARE-ADV-B
TPATPA-587962026-08-11T20:27:18ZRALPH—JACOBS1982-04-19N/A---3178 Lincoln WayJacksonvilleFL32271-3150—SELECT-EPO
TPATPA-580192026-04-09T07:57:34ZMejia, HaroldK—1969-10-17·NULL•••-••-5394(516) 332-0294N/A2037 Desert Sky BlvdLas VegasNV89109NULLNULL
TPATPA-517362026-06-17T09:45:51ZRussell, Diana··——·01/05/99—•••-••-7408—NULL3778 Apache BoulevardTempeAZ85228··GRP-2052-
TPATPA-641392026-07-01T17:54:30ZTimothy—Bennett1940-11-17null··—NULLN/A1538 Harbor BlvdTEMPEAZ·85234GRP-8224—
TPATPA-568552026-09-16T12:28:56ZSusan—Padilla06/25/1952UNKNOWN•••-••-1359404-216-1177NULL7190 SUNSET BLVDGlendaleAZ———
TPATPA-613142026-06-07T06:09:43ZSamantha····Bryant10/3/1996NULLN/A··—-7358 Indian School RdSeattleWA98163··—CORE-HMO
TPA TPA-556752026-07-23T04:30:11ZAmanda—Cook1967-05-04——557-845-2757UNKNOWN802 SAGE COURT·MiamiFL33123null··NULL
TPATPA-583342026-10-08T09:39:44ZJULIA—SNYDER06-02-1951—··552-507-4119-2609 Sunset BlvdGLENDALEAZ85379nullCHOICE-PLUS-PPO
14,474 rows, page 224 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.299Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty