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-534342026-04-02T05:33:58Zgloria—guerrero15-09-1981UNKNOWN——null8067 APACHE BOULEVARDTucsonAZ85791-5681nullUNKNOWN
TPATPA-615402026-06-14T14:42:33ZHiroshi—Garza2006-11-05-null8065786361··3626 INDIAN SCHOOL ROADPlanoTX75018—null
TPATPA-589902026-06-05T02:30:30Zyuki—elliott2007-03-18—-·2385672-··6045 Oak StAustinTexas78764GRP-7043CHOICE-PLUS-PPO
TPATPA-578092026-06-16T19:09:04ZEugene—·Grahm2004-10-26—•••-••-1531nullNULLN/A——··null-
TPATPA-557892026-04-19T16:28:08ZDiiana··Jacobs07/17/55··—NULL(287) 425-4739diana.jacobs@hotmail.com—UNKNOWN·-N/AN/A—
TPATPA-500072026-08-07T09:30:45ZKathryn—Austin03/27/1955———UNKNOWN4907 SPRING STDENVERCO—GRP-3059N/A
TPATPA-501882026-04-07T22:58:54ZHarold—Cole1946-09-26—•••-••-6624——-——-—N/A
TPATPA-638052026-01-03T17:51:05ZMartha—Rice·1956-08-23null—nullnull6052 Desert Sky BlvdTampaFLnullN/AMEDICARE-ADV-B
TPATPA-609282026-04-24T13:53:54ZFatima—Ford1971-04-08—UNKNOWNUNKNOWNNULL5826 Pine DrMESAAZ85205N/Anull
TPATPA-615932026-10-16T14:54:19ZMARTHA—·MARQUEZ6/5/1964-•••-••-5371(704) 773-8091null2207 CENTRAL AVETempeAZ85266—CHOICE-PLUS-PPO
TPATPA-553852026-01-15T01:52:23ZGABRIEL—GUZMAN09/24/2007··•••-••-7101NULLGABRIEL.GUZMAN@YAHOO.COM6274 LAKE VIEW RDChandlerAZ85276-9716GRP-1377—
TPATPA-520472026-09-29T03:28:59ZVALENTINAYWARD26-11-1990—NULLUNKNOWN—8511 Harbor BoulevardCharlotte··nc28207GRP-9182CORE-HMO
TPATPA-534112026-02-19T23:52:34ZCHARLOTTE—LUCAS04/03/1968-··—763-925-3746—333 Harbor BlvdDallasTX75244··—
TPA TPA-573102026-10-12T17:11:28ZRACHEL—·JOHNSTON08/26/2005UHC-09885-88•••-••-8113—NULL9518 Jefferson AveScottsdaleAZ85278NULL-
TPA TPA-641512026-05-29T18:32:56Z JULIA—HILL1956-09-02—•••-••-6942—N/A8677 Indian School RoadChandlerAZ85259NULLN/A
TPATPA-51773 2026-10-17T18:21:56ZJoshua—Mendoza1954-10-27—•••-••-0760-NULLnullUNKNOWNUNKNOWN—NULL—
TPATPA-598892026-09-23T10:03:44Z TheresaK.··Franklin11/18/1944-NULL—-7509 Willow CourtSeattleWA98149—N/A
TPATPA-526412026-04-22T03:07:41ZPETTER···SIMPSON1980-02-20—nullUNKNOWNN/A2473 Lincoln WayFRESNOca93748GRP-6747-··
TPATPA-547502026-04-11T01:33:30ZLarry—Fuller1978-03-07N/A—19205310869UNKNOWN9464 Forest AveAustinTX78713GRP-7016····
TPATPA-586782026-06-23T05:36:31ZROBERT·EWEBB07/16/1999——UNKNOWN—7762 Mountain View DrLas VegasNV89110···null
TPATPA-513112026-10-03T04:27:58ZCharlotte—Rogers1974-05-26-UNKNOWN6823351138NULL1968 CEDAR LNColumbusOHN/AGRP-3933N/A
TPATPA-567822026-05-05T22:30:18ZPorter, LuciaW—02/23/44-•••-••-1119nullN/A8965 Canyon RoadSan AntonioTX78234N/Anull
TPA TPA-521332026-10-10T00:51:15ZJULIE—BROOKS20000115UNKNOWN-nullnull2139 PARK PLACE·SCOTTSDALE·Arizona·85269NULLnull
TPATPA-577752026-05-02T15:16:57ZMark··FordN/AN/A•••-••-6694null—2379 LAKE VIEW ROADEden PrairieMN55352··GRP-6230—
TPATPA-553062026-07-29T08:22:53ZBECKY··GREENE05-05-2006··-——-3070 Palm DriveTampaFL33694NULL—
TPATPA-559632026-10-04T15:29:22Zstephen····miller1973-09-12—··—NULL800 CENTRAL AVENUESacramentoCA··95811——
TPATPA-501662026-08-21T10:53:32ZCristopher—Pierce19441118-•••-••-5441908.920.3343christopher.pierce@yahoo.com3313 DESERT SKY BLVD·MinneapolisMN55405—·null
TPATPA-61531 2026-07-28T14:09:14ZDANIELLE—SCHULTZ7/1/1941UHC-73966-94N/A(959) 590-6871danielle.schultz12@outlook.com··7494 Union StreetEDEN PRAIRIEMN55302GRP-7366MEDICARE-ADV-B
TPATPA-588392026-05-16T22:33:24Z OLIVIA—CAMPBELL1987-09-15—NULL(417) 878-6273N/A4368 Cedar LaneLos AngelesCA90035GRP-5850—
TPATPA-50922 2026-06-21T21:46:40ZTurner, Ashley····—1982-08-20UHC-15343-73—null—7867 ELM STAtlantaGA30390····-
TPATPA-597372026-08-03T02:10:57ZJanet—Ryan-··—•••-••-3430955-880-6102JANET.RYAN@PROTON.ME1484 MESA DRIVESan AntonioTexas78203····NULL
TPATPA-593192026-08-14T11:04:21ZCAMILA—HUNT··Apr 21, 2001UHC-41725-59•••-••-14645577991174—2756 UNION STTampaFL·33659GRP-5699··UNKNOWN
TPA TPA-629762026-06-22T05:45:19ZChristian··—Lane19770916UHC-80877-08•••-••-8137——4761 Ocean AveScottsdaleAZ85270—MEDICARE-ADV-B
TPATPA-594302026-04-14T22:37:35ZJulie—Vasquez1944-08-01null•••-••-8469··UNKNOWN4713 JEFFERSON AVENUETampaFL33613GRP-4788null
TPATPA-560762026-05-24T10:00:40ZDORIS—DOMINGUEZ12/16/2001—N/ANULL—607 Sage CourtTAMPAFL33656UNKNOWNcore-hmo
TPATPA-611142026-08-27T02:07:06ZMARY····SMITH07/09/1945N/AUNKNOWN569.265.6792—1344 APACHE BLVDAustinTX··78704-NULL
TPA TPA-635222026-09-26T12:31:56ZTimothy—Simmons1970-01-17NULL•••-••-7932N/Atimothy.simmons83@gmail.com1641 Washington StreetGlendaleAZ··85362GRP-6856NULL
TPATPA-536702026-03-25T16:18:26Znicholas—phillips19850603-•••-••-39888929835817NULL·804 Cedar LnMesaAZ85271—·MEDICARE-ADV-A
TPATPA-565852026-03-30T17:03:53Zdouglas—carpenter1945-07-21UHC-55704-92N/A—-3423 Jefferson Avenue #642TampaFL33648GRP-5651··NULL
TPATPA-512172026-05-19T10:33:21ZMaria—Clark1994-08-10——UNKNOWN—6838 Central AvenueTempe···AZnull-—
TPATPA-566232026-04-12T08:34:21Z·Carlos—Estrada05/07/68—•••-••-4780UNKNOWNcarlos.estrada@hotmail.com2063 Hillcrest Road···SAN DIEGOCalifornia92165-3762UNKNOWNNULL
TPATPA-51682 2026-01-24T00:00:17ZAndreaUBrown01/22/77—-13447577223andrea.brown35@aol.com·2828 DESERT SKY BOULEVARDSan DiegoCA92105nullnull
TPATPA-503912026-08-10T22:22:56ZAlbert—Henderson2008-10-03NULL—(755) 796-9806albert.henderson71@outlook.comNULL——N/AUNKNOWN····
TPATPA-519452026-10-12T01:46:19ZDaniel—Carroll09/22/08UNKNOWN•••-••-2636UNKNOWN·UNKNOWN4534 Highland AveCharlotteNC28286GRP-2081null
TPA TPA-572172026-05-08T11:46:55ZRUTH—·PETERSON19590925-·-UNKNOWNruth.peterson28@gmail.com2019 River RdDENVERco80270NULLNAVIGATE-HMO
TPATPA-521672026-03-05T12:59:08ZRob—Craford2006-02-15UHC-52692-57null——4891 MEADOW LANE··SacramentoCalifornia95837-NULL
TPATPA-587322026-05-13T04:27:47ZEmma—Dean1989-04-24—•••-••-034419285827900·null1260 OCEAN AVENUEOrlandoFlorida32827GRP-7242·UNKNOWN
TPATPA-535142026-03-20T07:30:31ZSara—Sanders1970-11-07N/A•••-••-9989N/Anull2403 Spring StDenverCO80296GRP-5245-
TPATPA-541272026-05-17T14:28:14Z ERIC··—FREEMAN05/09/1962NULL•••-••-57543566904311N/Anullnull——UNKNOWNMEDICARE-ADV-A
TPATPA-581872026-07-10T05:09:38ZEIRC——1998-07-10NULL—616-217-0791eric.bailey85@gmail.com··9184 HIGHLAND AVENUETampa··FL33676—null··
14,474 rows, page 238 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:43:00.206Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty