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-585892026-06-23T03:07:05ZCarolyn—Ortiz19830127—•••-••-4266——·4744 CEDAR LANEMiamiFlorida33179GRP-5600null
TPATPA-510232026-06-11T07:52:26ZEDWARD—ESPINOZAAug 10, 1949-•••-••-1241——NULL-··null-——
TPATPA-624622026-01-09T02:10:11Z·Rebecca—Ortiz19580324null··——UNKNOWN6811 HARBOR BOULEVARDPhoenixAZ85091NULLnull
TPATPA-514152026-09-26T15:17:32ZJackieKAllen1974-05-11—•••-••-0926nullUNKNOWN7384 PALM DRIVEPlanoTX75039GRP-9816MEDICARE-ADV-B
TPA TPA-562262026-02-23T03:52:01Zwalter—hunt1952-06-14—·UNKNOWN9716995800UNKNOWN1006 SAGE CTPhoenixAZ85052——
TPA TPA-588922026-03-10T07:49:50ZRebeccaV.FosterSep 20, 1972-null375-563-8106—2598 OAK STSan Diego·California·92198—N/A
TPATPA-572892026-03-22T01:09:11ZDEBRA—WAGNER1967-06-21UNKNOWNN/A+1 778 547 1930debra.wagner45@hotmail.com—---GRP-1718··—
TPATPA-503432026-07-22T19:54:20ZAdam—Simpson20051007—-UNKNOWNadam.simpson@outlook.com5333 Harbor BlvdPhoenixAZ85000GRP-5978OPTIONS-PPO
TPATPA-543302026-04-30T20:18:28ZKYLEUSANCHEZ1963-05-16··UHC8511493•••-••-92767333637UNKNOWN878 Ridge RdMinneapolisMN··55456NULLNULL
TPATPA-557682026-07-17T03:27:24ZVICTORIA··—FOWLER1982-06-02—•••-••-9377·19239940169-4796 HILLCREST ROADSacramentoCA95879GRP-7183CHOICE-PLUS-PPO
TPATPA-574802026-01-17T09:24:26ZSantiago··—Lnych6/15/1998UHC-94650-08-··—-2281 River RoadLas VegasNV89117UNKNOWNUNKNOWN
TPATPA-615122026-04-05T15:19:40Z Brandon—Hayes1971-06-09—null298-744-5210NULL···UNKNOWN—N/A-·UNKNOWN····
TPATPA-63043 2026-09-25T16:57:10Z———1975-03-16···-•••-••-8937—wayne.payne@proton.me4120 River RoadJacksonvilleFL—GRP-6429CHOICE-PLUS-PPO
TPATPA-542272026-03-05T08:47:40ZAlanVBrown1974-07-24null—nullALAN.BROWN@HOTMAIL.COM7523 Central AvenueTempeAZ85234nullN/A
TPATPA-573232026-03-09T07:24:05ZWhite, Charlotte——2006-10-22null•••-••-52428189387701NULL—null——GRP-2488MEDICARE-ADV-A
TPATPA-576242026-03-30T02:38:27ZAdamPDunn2006-01-93NULLN/AN/A—232 Lincoln WayAtlantaGA30366-6322UNKNOWNN/A
TPATPA-526182026-07-05T03:50:28ZJOSE····ELLIOTT··2004-11-26NULLN/A643-353-9765NULL1677 Oak StSan DiegoCA92172—····
TPATPA-518702026-02-23T01:27:47ZCHARLOTTE—DUNN10/01/1987··UHC-00603-18•••-••-5610587-434-1669-6874 BROADWAYDenverCO80250N/A-
TPATPA-507282026-03-20T08:48:42Z Brian·KSnyder1969-11-19-null—NULL6722 Grand AvenueChandlerAZ85212GRP-7063—
TPATPA-568182026-02-20T18:17:09ZJack—Wallace1988-02-43NULL——UNKNOWN3117 RIVER ROAD Apt 28PlanoTX··75045nullMEDICARE-ADV-B
TPATPA-615382026-06-25T14:47:10ZDOUGLAS····EDWARDS12/22/60-UNKNOWN700-717-0680NULL5647 MAPLE AVEScottsdaleAZ85244UNKNOWNOPTIONS-PPO
TPATPA-571572026-09-04T10:24:18ZEmily—Dunn6/10/2005null——NULL2401 UNION STREETTempeAZ·85251GRP-3706—
TPATPA-610122026-10-07T23:15:46Z·Denise—Alexander19540606·null—(408) 552-0921N/A1316 Sunset BlvdNashvilleTN37233--
TPATPA-639582026-08-07T21:58:34ZYUKI—·PARK2003-04-23null——NULL6274 Camelback RoadTAMPAFlorida33696GRP-1341null
TPATPA-537002026-10-15T06:41:42ZJacqueline—Adams1996-06-09—nullN/A··null5404 SPRING STHOUSTONTX··77067—SELECT-EPO
TPATPA-519372026-09-23T17:40:04Z·Gardner, Wei—··04/01/71UHC-94736-96··UNKNOWNWEI.GARDNER92@YAHOO.COM7039 Apache BlvdCOLUMBUSOH43244null-
TPATPA-594902026-05-14T18:49:56ZBrian Q.··—Hunt··1994-05-23—UNKNOWNN/AN/A1019 Harbor BlvdAustinTX78716—null
TPATPA-544592026-05-03T22:28:21Zcharles—rice··1953-09-09—•••-••-5565N/ANULL·null———nullOPTIONS-PPO
TPATPA-510552026-08-17T10:09:53Zsarah····black2001-07-06N/A··+1 989 590 2102N/A8146 BAYSHORE DRChandlerAZ85243GRP-8092NULL
TPATPA-527512026-03-09T22:41:16ZMICHELLE·J.COLE02/24/1969UHC-87039-26•••-••-4132nullNULL1395 APACHE BLVDTampafl33645NULLMEDICARE-ADV-A
TPATPA-505142026-06-06T18:35:30ZDIEGO—·BISHOP1959-12-25-———6395 Jefferson AvenueEden PrairieMN55345··—OPTIONS-PPO
TPATPA-620402026-07-08T15:47:53ZEdward—Ellis1979-04-10—•••-••-42263896890798—·4385 BroadwayMesaAZ85288—NULL
TPATPA-626112026-04-19T12:07:20Zedward··—shaw02/19/80N/A•••-••-3080+1 533 680 5777—NULLNULL····——OPTIONS-PPO
TPATPA-532082026-03-11T15:27:46ZAnn—Washngton1963-12-28UHC-77404-59—nullN/A5383 Mountain View DriveGilbertArizona85282GRP-3757··
TPATPA-539992026-10-16T01:08:38ZEUGENE I—JONES1966-02-20-•••-••-2628nullnull··1907 BroadwayChandlerAZ85295——
TPATPA-514802026-01-25T12:19:14ZVicky—Hughes·9/21/1949UHC-95800-59•••-••-4978NULLVICTORIA.HUGHES87@AOL.COM267 Willow CtMINNEAPOLISmn··55444N/A—
TPATPA-585492026-05-18T05:03:05ZPAYNE—AMBER··01/05/1974UHC-74098-98•••-••-3068UNKNOWNN/A5347 Central Avenue #905Glendale·az85399—null
TPATPA-592272026-09-13T14:00:10ZANGELA—WILLIAMSON1947-10-26uhc-83917-22——ANGELA.WILLIAMSON@OUTLOOK.COM6565 Baseline RoadPhoenixAZ85072UNKNOWNUNKNOWN
TPATPA-50613 2026-02-10T05:37:14Z·NATHAN—·MEDINA1982-10-28N/AN/A5199147895nathan.medina45@yahoo.com7987 RIDGE RDGlendale··AZ·85362NULLUNKNOWN
TPATPA-603442026-06-09T16:16:06ZADAM—MORGAN12/26/70null—-adam.morgan2@proton.me7848 Bayshore DrCHANDLERArizona85268GRP-7583-
TPATPA-615642026-03-13T11:00:37ZJACOB—MITCHELLMay 3, 2005—····(380) 594-5755····3700 Hillcrest RoadEden PrairieMN55306——
TPATPA-62332 2026-04-03T23:34:16ZSarah—Perkins06/25/49—-—sarah.perkins@aol.com2882 Indian School RoadSACRAMENTOCA95822N/ANULL
TPATPA-629102026-01-07T23:47:01ZLISA—·TAYLOR1983-09-14UHC-20686-86•••-••-6237N/A·null1069 Baseline RdEden PrairieMN55389-OPTIONS-PPO
TPATPA-624422026-03-28T15:26:37ZSimpson, Jeffrey····—1943-04-16UNKNOWNNULL(600) 588-3898—4147 Indian School RoadMIAMIFL33101—null
TPATPA-605932026-10-10T12:59:21ZHenry—Ross1987-12-05-—479-483-9256UNKNOWNnullNULLN/A—nullNULL
TPATPA-552262026-05-29T04:10:12ZChristina—Caarroll1990-07-10———christina.carroll34@hotmail.com4892 Indian School Road·SCOTTSDALEAZ···85284——
TPATPA-621972026-08-25T02:42:13ZRalph—Santos15-02-1963-•••-••-6649NULL-N/A·null—-null—
TPATPA-597672026-10-15T20:35:57ZShultz, Richard——1960-09-04—N/A··6765722649—3637 Union StreetTempeAZ85264-UNKNOWN
TPATPA-605812026-08-11T19:40:46ZJuan—Cooper1950-04-20UNKNOWN•••-••-3908465-807-6511null3666 Sage CourtSan Diego··CA92199··N/A
TPATPA-572162026-02-27T20:35:44ZLee, Benjamin——2006-09-23UNKNOWNnull—null5582 VALLEY VIEW DRIVEHoustonTX77095—UNKNOWN
14,474 rows, page 199 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.724Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty