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-591122026-04-13T16:36:01ZCAARLOS—DEAN1907-08-04NULL··-+1 211 453 2730carlos.dean60@yahoo.com1314 Grand AveMinneapolisMN55406—SELECT-EPO
TPATPA-61358 2026-01-22T22:12:41ZJordan, Amber——17-02-1985NULL•••-••-1621null-1088 SUNSET BOULEVARDSeattleWA98186··GRP-8941··null
TPATPA-505422026-04-19T23:40:56ZnanccyS·delgado1969-01-08··UNKNOWN—-—·6958 Park PlaceORLANDOFL—GRP-3079null
TPATPA-620112026-07-31T14:46:27ZJacob—Patterson19940920UHC-78868-43—(437) 909-8406··N/A·3426 Maple AvenueDallasTX75278-N/A
TPATPA-523242026-05-22T23:53:56ZronaldHcampbell9/20/2006nullUNKNOWNNULLUNKNOWN4839 Valley View DrOrlandoFlorida32828nullN/A
TPATPA-626182026-02-20T16:25:04Z·Bryant, Nathan——12/05/1962UNKNOWN—16468089364-6883 Main StJacksonvilleFL32216—MEDICARE-ADV-B
TPA TPA-568582026-08-08T13:10:18ZCHERYL—JONES1986-01-65UNKNOWN··—null-701 FOREST AVEOrlandoFL32843-UNKNOWN
TPATPA-628922026-01-09T06:59:01ZLaura—Franklin1946-02-10-•••-••-2638461-515-5629laura.franklin20@outlook.com9639 Cedar LaneLas VegasNV89110GRP-8263MEDICARE-ADV-A
TPATPA-520052026-07-15T08:06:15Zeugene—tucker·1989-07-13null····NULLeugene.tucker63@outlook.com··9002 Maple AveGlendaleAZ85380UNKNOWN—
TPATPA-623892026-06-13T08:22:24Zomar····ramos19791128UHC-36972-06N/Anull··omar.ramos@yahoo.com-—N/A—GRP-1206N/A
TPATPA-591352026-07-18T17:48:17ZSharon—Little1992-10-15N/A-nullN/A8093 Lake View RdSAN DIEGOCA92197GRP-4137··MEDICARE-ADV-B
TPATPA-628822026-07-15T23:08:24Z Lauren—Brown2002-02-20UHC-26064-48NULL544.422.1328-4201 Lincoln Way··GLENDALEaz85315N/Anull
TPATPA-601712026-04-20T22:08:44ZAdams, Bobby··—1972-01-12——2082504797····8522 Spring St Apt 23PLANOTX75070GRP-5295-
TPATPA-569072026-05-01T16:12:17ZOmar··Lawrence1940-02-24——NULL-3227 Spring StreetSan AntonioTX78226UNKNOWN··null
TPATPA-580252026-10-09T08:00:51ZAHMEDIADAMS2001-12-06—N/AN/Aahmed.adams54@yahoo.com3121 Union StLas VegasNV89139UNKNOWNN/A
TPATPA-605332026-01-17T15:06:28Z·Lori—Yang1974-08-09—UNKNOWN··17174754465UNKNOWN5415 Forest AveDallasTX75273-4985—OPTIONS-PPO
TPATPA-53884 2026-02-02T03:24:46ZGREGORY—GUERRERO1985-01-16——····gregory.guerrero20@aol.com7166 Jefferson AvenuePhoenixAZ85075GRP-6337-
TPATPA-593562026-03-06T14:30:20ZElizabeth—Santiago02/24/1974—·NULLNULLnull1713 Ridge RdMESAAZ85274N/AOPTIONS-PPO
TPATPA-596322026-08-15T19:36:38ZTheresa—Henry12/11/91———UNKNOWN8184 MEADOW LNSan DiegoCA92175··GRP-1724··NULL
TPATPA-557612026-02-27T03:28:49Z·ANTHONY—·JOHNSTON·1976-01-26NULL—237-589-9084anthony.johnston35@aol.com6353 Cedar LaneTampaFL·33619nullmedicare-adv-a
TPATPA-518102026-10-18T11:13:14ZRYAN—MENDEZ06/26/1969NULL•••-••-4108·896-599-4565ryan.mendez@yahoo.com2216 Lake View RdFresnoca—nullUNKNOWN
TPATPA-521342026-07-27T17:13:40Z·Julie—Brooks15-01-2000—N/ANULL··null2139 Park PlaceScottsdaleAZ85269-9329null··NAVIGATE-HMO
TPATPA-608352026-03-19T17:05:20ZNatalye—Harper1973-06-13·null•••-••-7444N/ANULL4968 Camelback Road Apt 34AtlantaGA30307GRP-3576N/A··
TPATPA-591332026-07-12T12:57:41ZLAUREN—JOHNSON··1955-02-23UHC-97366-63•••-••-1389254-961-6595LAUREN.JOHNSON@GMAIL.COM8349 Harbor BoulevardMinneapolisMinnesota55440NULLnull
TPATPA-578432026-06-29T04:58:56ZJordna—MitchellJan 13, 1999UNKNOWN•••-••-2341N/AJORDAN.MITCHELL@YAHOO.COM··882 Lake View RdDallas··TX75281NULLOPTIONS-PPO
TPATPA-559742026-05-20T15:58:03Zjacqueline—padilla1984-07-25—•••-••-4981null—8450 Cedar Ln·FresnoCA93782-NAVIGATE-HMO
TPATPA-615792026-07-14T22:54:49Zsamantha—morris·2004-09-22—NULLNULLN/AUNKNOWNnullNULL—····null
TPATPA-610032026-06-14T11:06:50ZAngela—Carpenter1990-07-20NULLNULL+1 868 486 7873NULL4829 Jefferson AveAustinTX78752NULL—
TPATPA-599992026-03-03T10:59:46Zjoe—obrrien1398-06-20UNKNOWN·NULL5953563—832 Oak StreetJacksonvilleFL32288null—
TPATPA-551342026-02-13T04:22:49ZTeresa—Burton1998-07-06·-N/A329-934-5762··9371 Pine Drive·ColumbusOH43224—N/A
TPATPA-546972026-03-20T19:09:35ZSarah—Bowman27-04-1983null—N/AUNKNOWN3180 Apache Boulevard··Los AngelesCA··——null··
TPATPA-632112026-03-28T01:16:36ZFATIMA—KNIGHT19630913—-—UNKNOWN2657 Market StEDEN PRAIRIE·MN55302··GRP-7679···MEDICARE-ADV-B
TPATPA-507582026-05-11T16:21:28ZJuan—Mills12/18/1946··UHC-66910-63•••-••-0270-—8887 Lake View Road Apt 6GilbertAZUNKNOWNGRP-9855—
TPATPA-537592026-03-17T11:28:36Z Diane····Butler1984-02-05nullUNKNOWN407.719.1224DIANE.BUTLER@YAHOO.COM309 Hillcrest RdCharlotteNorth Carolina——UNKNOWN
TPATPA-594132026-08-07T22:20:28ZTyler—Hudson02/12/72-··•••-••-8138NULLNULLUNKNOWN—N/A-—-
TPATPA-608762026-01-16T11:43:25ZVincent—Sullivan1973-06-20—nullUNKNOWN—·8234 Jefferson AveSan AntonioTX78246—SELECT-EPO
TPATPA-520702026-06-20T17:23:44Z·ann—cook2002-01-18UHC-96679-77•••-••-5665NULL—6761 PARK PLFRESNOca93746UNKNOWNN/A
TPATPA-502772026-04-05T06:36:39ZGARY—GUTIERREZ1992-12-06N/A··•••-••-8045381-341-8968—2995 MARKET STREETEden PrairieMN55325GRP-2243—
TPATPA-523982026-07-02T12:59:05ZJacob····McDonald1938-03-26—UNKNOWN-NULL2266 WASHINGTON STREETNashvilleTN37213-6364GRP-0606MEDICARE-ADV-B
TPATPA-562612026-06-10T00:33:30ZLARRY—OLIVER1972-03-28NULL—289-569-5753··—1583 Union StDenverColorado80225-5945GRP-5450UNKNOWN
TPATPA-515632026-04-30T16:02:39ZDaniels, Olivia——1944-04-16—UNKNOWN—N/A6761 Jefferson AvenueLas VegasNV89183nullMEDICARE-ADV-B
TPATPA-530632026-01-15T09:50:57ZRussell—Grant10/09/1961—•••-••-3652274-521-6612—2049 Church StreetGlendaleAZ85306NULL—
TPATPA-515222026-09-12T17:06:43ZTyler—Jackson7/16/1948N/A•••-••-2894(929) 736-3562—7548 Baseline RdAtlantaGA··30326UNKNOWN—
TPATPA-551892026-04-02T12:49:34Z George, Gloria—····1995-08-23NULLnull(316) 666-7497—9610 Jefferson AvenueMinneapolisMN55413——
TPATPA-568152026-03-06T03:02:38Zkathryn—dunn20030117UNKNOWN•••-••-2054758.932.5966-6922 Park PlaceDENVERColorado80261GRP-7919UNKNOWN
TPATPA-634842026-03-14T04:51:59Zjustin—fowler1981-12-21NULL—NULL-··UNKNOWNN/A····——MEDICARE-ADV-B
TPA TPA-583332026-05-13T14:14:24ZHEATHER—WILLIAMSON1954-09-11N/Anull9093592363HEATHER.WILLIAMSON@OUTLOOK.COM3052 VALLEY VIEW DRChandlerAZ·85241GRP-1921N/A
TPATPA-589022026-05-08T13:05:55ZDiego M—Lawrence03/13/2005UHC6854808N/A4465048557NULL1001 Hillcrest Road Apt 36TempeAZ85203GRP-5308OPTIONS-PPO
TPATPA-609182026-09-24T23:11:21ZHANNAH—HOWARD4/28/1944NULLN/A-null2648 River RoadChandlerAZ—GRP-3670—
TPATPA-558442026-06-06T09:44:30ZFord, Teresa——·08/17/2007nullnull····-9494 Market Street··GILBERTAZ··85259——
14,474 rows, page 186 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:53.130Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty