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-58720 2026-08-29T15:10:01Zsofia—wood1956-04-13—•••-••-6617443-286-4696—297 OAK STREETSacramentoCA95841NULL-
TPATPA-607312026-04-30T13:52:35ZJulie—Alexander1995-01-22—NULLN/A—6091 Highland AvenueMiamiFL33103nullNULL
TPATPA-532052026-09-09T07:21:58ZLisa······Bryant2/6/1997null•••-••-8829NULL-5893 Meadow LnNashvilleTN37224N/ACORE-HMO
TPATPA-557632026-06-05T01:41:16ZYuki—Ortega5/26/1977UHC-69924-78-UNKNOWNnull9570 Cedar LnLos AngelesCA90089—MEDICARE-ADV-B
TPATPA-552052026-09-06T23:22:52Z Aaron—SandovalApr 13, 2006—·UNKNOWNnullnull8939 Valley View DrJacksonvilleFlorida32220GRP-6730—
TPATPA-632362026-02-05T07:20:18ZTerry—HendersonOct 5, 1940——443-318-2087··null4042 Desert Sky BoulevardLos AngelesCA90091N/A·-
TPATPA-501352026-03-22T09:30:30ZMarc—Mendoza1995-05-19NULL··N/AN/A···marcus.mendoza79@yahoo.com9058 MAPLE AVE·Los AngelesCA90037—null
TPATPA-550982026-09-15T18:14:18Z·Barbara—Pena2005-02-23—•••-••-1841—·UNKNOWN2978 CHURCH STREETAtlantaGA30318·null—
TPATPA-538452026-10-04T00:50:48ZAnnUPatel1977-06-01N/A—NULLNULL7149 Bayshore DriveOrlandoFL32839··——
TPATPA-550722026-03-05T18:59:49ZJuan—Beell01/03/53-•••-••-2546—JUAN.BELL@HOTMAIL.COM8862 HILLCREST RDPhoenixAZ85021·GRP-5579NULL
TPA TPA-508222026-03-09T08:57:05ZRICHARD—MEDINA07/21/1981··—•••-••-2999N/A-635 Washington StPhoenixArizona85084GRP-8694NULL
TPATPA-500892026-06-14T16:35:56ZMIKE—DUNN08/16/2006—·····554-977-3334—7975 CHURCH ST··GLENDALEArizona85329-8888N/A··—
TPATPA-515532026-09-14T22:21:11ZBrittany—Cruz19640222UHC-92434-45UNKNOWNNULL—2650 Market StGilbert··AZ85297··CHOICE-PLUS-PPO
TPATPA-589332026-02-13T10:14:22ZSandra—·Mejia1979-07-28—N/A(926) 440-9875—5213 Valley View DrScottsdale·AZ·-····—
TPATPA-624002026-08-06T10:39:09ZMarcus··—Webb10/21/1954—UNKNOWN+1 831 547 8128-5736 Church StSACRAMENTO·CA95809NULLN/A
TPATPA-587412026-05-25T07:58:59ZSiims, Jordan——18-01-1955—NULL··——9287 Main St Apt 25AustinTX·null-—
TPATPA-509002026-10-11T12:20:49ZDANILE—LAWRENCE1978-07-10NULL•••-••-5064872-669-8499—8162 Spring StreetPlano··TX75004UNKNOWN-
TPATPA-582852026-10-11T05:49:38ZAmanda—McCoy2002-05-06UHC-05467-15null-NULL9338 Jefferson AvenueChandlerArizona85243GRP-6893N/A
TPATPA-629312026-03-23T09:18:23ZSOFIA—ALVAREZ10-01-1970···N/A•••-••-741814097160451N/A—nullUNKNOWN—GRP-9609CHOICE-PLUS-PPO
TPATPA-625022026-06-10T23:20:01ZWayne—Ray2003-12-15N/A—UNKNOWNwayne.ray28@icloud.com1480 JEFFERSON AVEDallasTX75296-3164UNKNOWNCHOICE-PLUS-PPO
TPATPA-574252026-03-24T16:56:43ZJamesUWhite1958-06-21—·-—NULL2410 Canyon RdChandlerAZ85224—NAVIGATE-HMO
TPATPA-557592026-01-03T23:45:23ZSean—Berry1969-09-12-NULL447.395.0926··N/AN/A—·NULL—N/A··CHOICE-PLUS-PPO
TPATPA-586452026-02-02T04:54:34Zrodriguez—emma··20061125-null8395035—894 River RdPhoenix·AZ85000GRP-2536NULL
TPATPA-577152026-04-15T09:29:47ZABIGAIL—ROBERTS06/08/63—•••-••-3005·N/A—·3460 Market StNASHVILLETN37298GRP-6275—
TPATPA-540182026-02-08T11:48:56ZPatricia—Carpenter1953-12-18·uhc-50496-96—N/Anull—UNKNOWN—-N/AUNKNOWN
TPATPA-628182026-03-19T23:06:17Z Jessica—Petersno2006-07-07····null—JESSICA.PETERSON@ICLOUD.COM·8905 INDIAN SCHOOL ROADScottsdaleAZ85296N/A··NULL
TPATPA-577222026-09-19T19:20:45ZHeather—Lawrence1986-03-19——·N/A—9108 Forest AvenueLos Angelesca90092—-
TPATPA-643522026-01-20T01:48:20ZAndrew—Barnes1971-12-07—•••-••-6119-N/A2579 Baseline RoadLos AngelesCA90003·GRP-0152—
TPATPA-567892026-05-04T14:53:41ZJackM··Barnes1979-04-24N/A•••-••-9785766-676-9332jack.barnes@hotmail.com3185 Washington Street·Las VegasNevada89125NULL—
TPA TPA-639892026-06-29T11:54:06ZjasonS.bailey1938-02-16UHC-32640-85—UNKNOWN—4995 HARBOR BLVDMinneapolisMN55463GRP-3135CORE-HMO
TPATPA-547592026-04-04T15:24:02ZCHARLOTTE—KENNDY05/19/08—N/A——1168 Apache BoulevardSan DiegoCA92146null··null
TPA TPA-559712026-03-13T09:03:14ZRoy····Miller16-04-1942UHC-46524-24•••-••-7672——5054 CAMELBACK ROADAustin·TX78715·nullNAVIGATE-HMO
TPATPA-577992026-05-03T00:13:16ZHELEN V—BAILEY1953-03-28—•••-••-9270····helen.bailey@hotmail.com6658 Maple AveSeattleWA98172-5640GRP-1207NULL
TPATPA-638192026-03-31T23:51:21ZMunoz, Teresa——1949-05-17UHC7395480nullUNKNOWN—4514 BROADWAYOrlandoFL32868N/A··CHOICE-PLUS-PPO
TPATPA-543962026-09-03T13:16:36ZJoan—Clark1967-11-09N/A—UNKNOWNN/A3163 Grand Avenue Apt 38Atlantaga30308GRP-5666-··
TPATPA-610302026-02-24T08:49:58ZNicholas··—Cook1946-11-08——NULLNICHOLAS.COOK@GMAIL.COM7035 GRAND AVENUE··ColumbusOH43208GRP-8698OPTIONS-PPO
TPATPA-571432026-07-22T02:47:15ZValdez, Greg——7/20/1940UNKNOWN-——5929 Oak StCHARLOTTENC28211GRP-7638MEDICARE-ADV-B
TPATPA-644512026-02-06T23:25:48ZBilly—·BaileyFeb 27, 1971UNKNOWN··NULL(444) 250-7929N/A2261 PINE DRNashvilleTN37292nulloptions-ppo
TPATPA-595892026-04-22T18:43:37ZASHLEY—WATKINS1991-02-15··UHC-85690-41—N/AASHLEY.WATKINS26@AOL.COM35 CENTRAL AVENUESan Diego··CANULL—·N/A
TPATPA-57800 2026-04-08T19:34:26ZHELEN—BAILEY03/28/53UHC-99440-30null—-6658 Maple AveSeattle··WA98172GRP-1207NAVIGATE-HMO
TPATPA-567452026-01-28T07:47:44ZPRIYA—·BERRY1958-07-07··N/A·N/A·null—NULL·NULL····nullN/AUNKNOWN
TPATPA-563612026-07-21T14:08:59ZGeorgeM.Torres·05/20/64UHC-42020-09—9294162649NULL4804 Market StreetMESAAZ85267-0583—N/A
TPATPA-621702026-01-28T01:03:42ZScott—Kim·19831025UHC-31124-94null(590) 495-7335SCOTT.KIM@AOL.COM-UNKNOWN—UNKNOWNUNKNOWN··—
TPATPA-642862026-10-01T20:15:30ZMartin, Brandon——1/17/2003NULL-nullUNKNOWN2141 Willow CtEden PrairieMN55362GRP-3814-
TPATPA-559932026-08-03T20:02:13ZTheresa—McDonald11/19/1945NULL•••-••-3215722-987-6265N/A—UNKNOWN-N/AGRP-1170MEDICARE-ADV-B
TPATPA-628602026-03-24T16:12:07ZBRENDA····PHILLIPS1961-06-05UNKNOWN•••-••-68048043537023—1876 CENTRAL AVENUEMiamiFL33110··N/AOPTIONS-PPO
TPATPA-625792026-07-31T18:41:09ZBetty··—Shaw1991-09-25—•••-••-3401NULL—8709 Pine DriveScottsdaleAZ·85289UNKNOWNNAVIGATE-HMO
TPATPA-51256 2026-04-25T18:36:25Z·Elijha—Porter0951-19-50UHC-37005-15—UNKNOWNNULL1434 CANYON ROADCOLUMBUSOH43202—null
TPATPA-542072026-06-05T01:32:57ZVincentO.Willis9/12/1996NULL-—NULL7913 Sunset Boulevard #945·Las VegasNV89110-0787GRP-7072—
TPATPA-549102026-10-12T02:13:57ZJOHN—GOMEZ3/19/1958N/ANULLUNKNOWN—5201 PARK PLACEOrlandoFL32873NULLMEDICARE-ADV-A
14,474 rows, page 208 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:56.128Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty