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-503992026-02-06T04:19:29ZNICHOLASPCOLEMAN1945-09-10UNKNOWN—+1 554 556 8420—5342 ELM STREETDallasTX75272nullCHOICE-PLUS-PPO
TPATPA-558712026-04-08T04:36:51ZPaul··—Patel1942-11-22UNKNOWNnull(671) 723-3707—8622 Bayshore DriveTUCSONAZnullUNKNOWNNULL
TPATPA-500332026-07-30T22:12:03ZTerry—Reid·1980-07-06-NULL—-3199 Highland AvenueGlendaleAZ85369—N/A
TPATPA-635572026-01-03T00:01:55ZKatherien—Black··07/25/1997null•••-••-807512322677319—45 Palm Dr #211TucsonAZ85765·null—
TPATPA-500762026-03-09T06:59:42Zmason—williams7/17/1994—-—UNKNOWN6790 VALLEY VIEW DREden PrairieMN55389NULL—
TPATPA-57958 2026-03-29T04:28:26ZStephens, Maria··—Sep 24, 1962UNKNOWN-—N/A6297 Washington StreetPlanoTX75044-5849GRP-2380MEDICARE-ADV-A
TPA TPA-560042026-05-01T08:34:18ZWei··Cooper1980-10-26nullnull924-835-8912WEI.COOPER81@GMAIL.COM9846 WASHINGTON STColumbusOH43211NULLMEDICARE-ADV-B
TPATPA-592932026-03-10T17:55:41ZAmber—Larson1493-12-22UHC-72250-82—3707204126N/A··9158 Washington StreetAtlantaGA30379UNKNOWN—
TPATPA-607872026-08-27T06:05:30ZDouglas—Yang91460825UHC-55719-11—NULLDOUGLAS.YANG@PROTON.ME1930 INDIAN SCHOOL ROADEden PrairieMN·55314N/Anull
TPATPA-512482026-01-19T15:20:14ZBenjamin—Greane1994-06-08nullNULLN/AN/A1364 OAK STREETDALLASTX75286GRP-9652MEDICARE-ADV-A
TPATPA-540212026-09-24T02:23:15ZSamantha—·Spencer1959-02-23——NULLN/A1630 Lake View RoadDallasTX··75202——
TPATPA-612582026-01-04T12:54:50ZChristina··Campbell1592-12-12—•••-••-6615——·6439 Apache BlvdMiamiFL33141NULL—
TPATPA-528122026-01-29T01:32:10ZDorothy—Rose1979-11-05null•••-••-0598-—nullN/Anull-··MEDICARE-ADV-A
TPATPA-576352026-08-28T15:43:20ZMichelle—Walker2003-08-05—•••-••-4987·N/AMICHELLE.WALKER90@YAHOO.COM·NULL—··—NULLCHOICE-PLUS-PPO
TPATPA-601502026-02-07T10:13:45ZArthur··—·Jimenez2001-02-01N/A•••-••-5083—N/A4586 LAKE VIEW ROADEden PrairieMN55342nullN/A
TPATPA-607082026-09-20T04:58:25ZOmar—OBrien1953-12-16null•••-••-5301—-8422 Washington Street··San DiegoCA92135-5868··NULL
TPATPA-551032026-10-08T17:38:07ZgabrielT.nguyen04/25/49N/ANULLUNKNOWN-5009 JEFFERSON AVENUE·Chandler·AZ—nullnull
TPATPA-507662026-06-18T21:07:20ZSofia—Hunt28-11-2008nullUNKNOWN—-7726 Lake View RdScottsdaleAZ85228nullOPTIONS-PPO
TPATPA-550412026-01-22T22:07:26ZOlivia····Cooleman1967-06-19UHC8031312•••-••-2249-—1107 OAK STSan AntonioTX78250NULLCHOICE-PLUS-PPO
TPATPA-577772026-07-27T19:06:21ZWatson, Sam··—·1993-05-12NULL•••-••-8359930-577-8331—7942 Pine DrSan AntonioTX78260UNKNOWNUNKNOWN
TPATPA-554852026-04-29T20:48:05ZMarquez, Angela——2001-07-12UNKNOWN•••-••-0398+1 271 658 3170—6514 Harbor Boulevard·AUSTINTX78717-N/A
TPATPA-624292026-08-22T15:46:07Z·Dylan—DayNov 15, 1946—•••-••-4999NULLUNKNOWN8287 Central AveGILBERTAZ85275nullCORE-HMO
TPATPA-516872026-04-25T23:16:32ZDennis—Pierce1953-02-24····•••-••-9760215.920.5000-6540 Harbor BlvdFresnoCA93791—··
TPATPA-524582026-03-21T18:04:57ZMELISSA—·ALEXANDER2002-05-27—•••-••-6201—····6643 BroadwaySCOTTSDALEAZ85233-—
TPATPA-642492026-04-25T00:55:49ZAmber—Ruiz1947-11-07—•••-••-5084(828) 841-8858null9109 Union StSCOTTSDALEAZ85281nullnull
TPATPA-628682026-02-27T02:02:44ZOMAR—GONZALES1974-03-09UNKNOWN•••-••-5711NULL———NULL—GRP-1859—
TPA TPA-607262026-08-14T19:25:08ZCamila—Harvey1982-04-12··•••-••-21089896133611camila.harvey74@aol.comN/A—UNKNOWN—GRP-5700NULL
TPATPA-603942026-04-25T16:25:30ZMEI—CARTER1992-06-24UNKNOWN-NULL··635 Highland Avenue·HoustonTX77055·GRP-3826MEDICARE-ADV-B
TPATPA-593632026-04-28T01:34:33ZHelen—Guerrero19910823UHC-70876-54———3231 Baseline RoadGlendale·AZN/A—null
TPATPA-528042026-02-07T09:56:42ZAlexander··—Yang1993-07-25·UHC-49539-93UNKNOWN—-527 LINCOLN WAYDallasTX75297—····
TPATPA-592942026-10-10T17:43:58ZArthur—Parker1971-03-13··NULL(920) 760-8700null--—--—
TPATPA-553192026-07-09T11:46:22Zgreg—moreno1991-02-06null—210-369-2644—·2887 Apache BlvdFresnoCA93727-7767N/Anull
TPATPA-621872026-09-05T21:47:35ZRandy—Shaw1993-01-05UNKNOWNUNKNOWN····N/A—UNKNOWNNULL——NULL
TPATPA-507422026-05-19T08:01:01ZJacquelie—Taylor1976-10-27N/A•••-••-9777····2794 Oak StHOUSTONTX77014UNKNOWNNULL
TPATPA-505782026-08-07T03:04:55ZVIRGINIA—RUIZ··2002-06-11—UNKNOWN(274) 871-4431——NULL——GRP-6523—
TPATPA-622202026-03-13T15:55:26Z Luis—Wang1957-08-16—•••-••-1481UNKNOWN-2970 Jefferson AvePhoenixAZ85014UNKNOWNnull
TPA TPA-541682026-04-30T12:05:29ZDonaldI··Vazqez1960-05-26-NULLUNKNOWNN/A1869 Mesa DrScottsdaleAZ85210-8393····NAVIGATE-HMO
TPATPA-532732026-04-11T14:38:40ZPalmer, Caarolyn·M—19-08-2004-N/A728-562-9177carolyn.palmer80@aol.com······null—····N/A
TPATPA-522442026-09-09T07:29:50ZCAROLWFISHER1991-11-18N/A•••-••-6530—··5545 Park PlScottsdaleAZ85285GRP-0823N/A
TPATPA-584012026-09-30T08:18:10ZGRACE—MATTHEWS11/13/06—UNKNOWNN/A—-N/A——-··MEDICARE-ADV-B
TPATPA-574322026-04-11T01:24:11ZRobert—Thomas19660315N/A•••-••-5029UNKNOWN-4075 Park Place·NashvilleTN37274UNKNOWNSELECT-EPO
TPATPA-599352026-07-08T14:33:51ZJONATHAN—GARRETT1961-02-22null•••-••-1452N/Ajonathan.garrett@proton.me5631 CHURCH STREETDenverCO80250-·MEDICARE-ADV-A
TPATPA-506312026-01-12T10:05:12ZSamantha··Bailey1999-03-21—•••-••-1935+1 965 444 4216null2283 Lincoln WayPlanoTX··75096··GRP-1441CHOICE-PLUS-PPO
TPATPA-534162026-01-20T05:56:42ZDaniel—Wang1963-08-01null-—daniel.wang@proton.me1901 Valley View DriveDENVER·co·UNKNOWNGRP-8194NULL
TPATPA-571872026-06-25T06:27:13ZCAROL—ROSS1987-03-24N/A•••-••-2559nullCAROL.ROSS@AOL.COM5318 Central Ave·OrlandoFL32845NULLUNKNOWN
TPATPA-504412026-07-05T03:34:34ZRomero, Paul——Feb 23, 1980UHC-06985-27•••-••-3955—NULL3849 Baseline RoadLos AngelesCA90060·NULLNULL
TPATPA-542602026-08-06T02:04:13ZJUSTIN—·VARGAS2004-09-15UHC-10790-41—N/ANULL3263 HILLCREST ROAD·LOS ANGELESCA90035-8588GRP-2589—
TPATPA-584862026-04-30T12:52:55Z—K—03/13/1956—null—deborah.gonzalez93@aol.comN/AnullUNKNOWN—nullNULL
TPATPA-600482026-04-11T02:45:49ZGABRIEL—PRICE·11/11/1959-•••-••-5239(755) 981-8132GABRIEL.PRICE65@AOL.COM9889 Washington StreetMINNEAPOLISMN55445····NAVIGATE-HMO··
TPATPA-610162026-06-28T18:24:36ZLUIS—CRUZ1945-09-05-N/A—N/A8064 PARK PL·OrlandoFlorida32811—NULL
14,474 rows, page 29 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:36.720Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty