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-507562026-07-16T15:32:32ZAlexanderRMarquez1969-06-04—•••-••-7538755-283-7449-5581 Lincoln WayMinneapolisMN—N/A—
TPATPA-61650 2026-03-31T16:05:53ZHANNAH—NGUYAN07/28/39UNKNOWNN/A·(945) 831-4352HANNAH.NGUYEN@PROTON.ME8600 Lincoln WayLos AngelesCA90071—CHOICE-PLUS-PPO
TPATPA-553922026-04-26T03:44:57ZLewis, Julie——1963-03-22NULL—286-288-0696JULIE.LEWIS@ICLOUD.COM·7632 Church StSeattleWashington98167·null—
TPATPA-508102026-09-26T22:12:21ZJAKE—HOLMES1993-04-12N/A—null··NULL9299 APACHE BLVDAustinTX78764GRP-0237N/A
TPATPA-557222026-03-13T00:42:36Zmary—powell9/9/2007N/Anullnullmary.powell@hotmail.com2667 INDIAN SCHOOL ROADAtlantaGeorgia30336-6170-NAVIGATE-HMO
TPATPA-571082026-07-08T02:48:27ZEDWARDS—DONNA7/13/2006UNKNOWN•••-••-4156398-770-2080-7842 Harbor Blvd··Gilbertaz85209——
TPATPA-588132026-06-06T05:19:48ZTerry—Rodriguez06/25/84N/A•••-••-1912nullNULL·7763 Mountain View DriveGilbert··AZ85264—NAVIGATE-HMO
TPATPA-642092026-08-30T06:31:59ZKeith—Rice1991-07-18UNKNOWNnull··NULLUNKNOWN1580 Lake View RdTampaFL33675NULL··—
TPATPA-535622026-02-10T19:32:48Z Bill—Weaver·2005-10-15UHC5023781—526-298-4540null8974 INDIAN SCHOOL ROAD #851AtlantaGA30355N/AUNKNOWN
TPATPA-621172026-03-11T22:10:39ZJERRY—LUNA14-11-1979--·N/AUNKNOWN··9438 Sunset BoulevardAtlantaGeorgia30367—NULL
TPATPA-546452026-01-15T03:25:59Z·MARCUS—PIERCE1944-05-08NULL•••-••-7168—marcus.pierce10@outlook.com7945 PARK PLLOS ANGELESCalifornia90096GRP-6525—
TPATPA-564262026-05-08T23:35:16ZAshley—Alvarado1992-05-17UHC-25866-63UNKNOWNnull—5400 WASHINGTON STREETAtlantaGA30377-5644-null
TPATPA-629562026-06-26T22:46:21ZBruce··Fox9/6/1979UNKNOWNUNKNOWNNULL—4844 CEDAR LANEAustinTX78744-N/A
TPATPA-506382026-04-30T16:42:28ZKAYLA—SIMS·1987-05-14—•••-••-5018+1 327 628 8051null7655 Washington St·AtlantaGA30371-1361N/ACORE-HMO··
TPATPA-54312 2026-05-25T20:56:33ZBruce—Alvraez—UNKNOWNUNKNOWN——8112 MAIN STDallasTX·75291UNKNOWNnull
TPATPA-594212026-09-16T20:13:53ZYuki—Contreras3/1/1997null•••-••-4006441-897-3996—4549 BROADWAYPhoenixArizona85046GRP-3344—
TPATPA-567432026-06-25T00:42:47Z·Patterson, Alice——2007-07-08N/A—+1 397 628 4792—9575 Washington StChandlerAZ85258-—
TPATPA-572302026-09-29T15:29:13ZRtuh—Mills1958-02-08N/A•••-••-7862UNKNOWNN/A6603 Elm StreetNASHVILLETN37205·GRP-6876CHOICE-PLUS-PPO
TPA TPA-562062026-08-18T01:31:19ZLogan—WangFeb 10, 1943-UNKNOWNN/Anull1767 RIVER ROADSacramentoCA95862—NULL
TPATPA-527012026-04-02T14:32:56ZCamila—Silva1938-04-14UHC5356035NULL·NULLcamila.silva46@aol.com489 HIGHLAND AVEAustinTX78778GRP-3486UNKNOWN
TPATPA-626762026-01-21T08:40:33ZADAMPHICKS1979-05-03—•••-••-2146—-5348 Mountain View DrDenverCO··80282-8312UNKNOWN—
TPATPA-642702026-01-12T11:09:39Z·Larry—Fields1966-04-23—•••-••-2259N/A·null7205 BroadwayMIAMIfl33100N/AN/A
TPATPA-514242026-10-01T00:04:20ZOmar······Rios···1987-10-15—--omar.rios@icloud.com5940 CAMELBACK RDNashvilleTN37220-5956·GRP-7862SELECT-EPO
TPATPA-566172026-06-17T19:32:00ZSophia—Maldonado2002-05-12·null•••-••-44232197232830null1306 Ridge RdMIAMIFL33193-7147UNKNOWNNULL
TPATPA-566542026-05-30T22:45:31ZFATIMA—FORD1992-05-16null··•••-••-2145505.218.5478··4477 MAPLE AVESAN DIEGOCA92134—CORE-HMO
TPATPA-624952026-06-22T08:01:02ZBEVERLY—ROSS1960-07-26N/A····UNKNOWNnull8373 Hillcrest RoadEden Prairie··MN55370NULLN/A
TPATPA-609722026-01-09T10:59:12ZWillie—Jensen06/26/1943——··N/A3180 Market StSAN ANTONIOTX78283NULLnull
TPATPA-577972026-04-16T10:50:02ZDanielle—Ferguson1945-04-19··-UNKNOWNnullnull3567 ELM STSan AntonioTX78209—SELECT-EPO
TPATPA-531092026-09-02T04:26:37ZPAMELA—MITCHELLNov 8, 1997—•••-••-1373788-354-1894pamela.mitchell@icloud.comN/ANULL—N/AGRP-4318·UNKNOWN
TPATPA-608092026-03-23T22:54:54ZChristinaD.Fox1962-06-21NULL•••-••-9186NULL-5274 Valley View DriveGILBERT··AZ85235nullSELECT-EPO
TPATPA-552912026-10-07T03:07:35ZLisaOWalker01/24/1960—null4962548510N/A3284 MESA DRIVEAtlantaGA··30361——
TPATPA-603822026-07-08T09:53:38Zchristine—hoffman5/9/2003UHC-38010-16null—christine.hoffman66@icloud.com5855 Spring StPhoenixAZ85022GRP-0848—
TPATPA-619742026-06-03T22:54:54ZJeremy····Howell1981-03-25UNKNOWN—(424) 513-5375—6008 SAGE CTMinneapolisMN55474—-
TPATPA-632592026-05-27T21:34:31ZADAM—BURNS1964-04-28null—6982269928NULL7744 Willow CourtAtlantaGA30395UNKNOWNUNKNOWN
TPATPA-525742026-08-13T04:45:41ZJordan····Munoz1960-08-21null—642.477.7794—5593 Market StreetTUCSONAZ85786··NAVIGATE-HMO
TPATPA-621542026-09-13T18:37:17ZLinda—Smith1960-12-14UHC-42244-14—nulllinda.smith32@outlook.com536 Ocean AveSan DiegoCA92113GRP-7774null
TPATPA-559992026-09-15T12:58:24ZAMBER····DEAN1961-02-19—N/A··NULLUNKNOWNN/AUNKNOWN—NULLNULLN/A
TPATPA-513342026-02-22T22:45:47ZNicholas—Carter23-12-1938N/A•••-••-9425—nicholas.carter@gmail.com8213 APACHE BOULEVARDOrlandofl32843GRP-9202N/A
TPATPA-583462026-02-15T17:39:03ZCAROLYN—PIERCE19901113··UNKNOWNnull-2381 Mountain View DriveJACKSONVILLEFL32296—OPTIONS-PPO
TPATPA-559772026-02-03T01:15:08ZHeather—Ramirez1985-09-07··—N/A·16756695687—3843 MAIN STREETPlano··TX75050null··N/A
TPATPA-535412026-06-16T18:34:36Z Freeman, Deborah——1943-02-20··———·····1889 Market StreetORLANDOFL32832null—
TPATPA-600752026-01-20T10:23:53ZDouglasM.KimJul 9, 1940——null—5295 MARKET STFresnoCA93711-CHOICE-PLUS-PPO
TPATPA-565042026-02-03T22:53:22Z Brenda—Singh1973-12-05N/Anull—-—N/A-—UNKNOWNMEDICARE-ADV-B
TPATPA-621552026-03-10T09:33:59ZSmith, LindaL—12/14/60null-—NULL·6026 INDIAN SCHOOL RDTAMPAFL—GRP-7774NAVIGATE-HMO
TPATPA-589782026-04-25T03:18:12ZHELEN··—DOMINGUEZ2000-05-20-—NULLUNKNOWN320 Pine Dr Apt 2Eden Prairiemn55369—-
TPATPA-602502026-06-28T14:36:55ZAdam—Wood1941-01-05UHC-86873-43··•••-••-2697——8490 Highland AvenueCharlotteNC28251—N/A
TPATPA-519392026-02-19T10:30:34ZRussell—Davis1962-06-08—•••-••-7424-NULL1029 Spring StreetColumbusOH43202··GRP-4228null
TPATPA-535062026-09-12T23:53:13ZRYAN—·HUDSON1952-05-21··UHC-64364-34•••-••-5890836.771.3755NULL1147 UNION STAtlantaGA30375GRP-1852OPTIONS-PPO
TPATPA-510482026-09-10T08:04:16ZPhilip—Marshall19390328·nullN/A541-669-5619··N/A7863 Washington StreetPhoenixAZ·85083······
TPATPA-616172026-03-05T21:16:13ZDaavis, Aaron——1968-09-21··UNKNOWNnull772-783-8164N/A—nullnullN/AGRP-0206UNKNOWN
14,474 rows, page 111 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.622Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty