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-62345 2026-10-14T23:32:54ZHenderson, Dot····—19720525····•••-••-0083—dorothy.henderson@yahoo.com894 Apache BoulevardMinneapolisMinnesota55449GRP-1995NULL
TPATPA-564072026-05-21T13:13:30ZNancy—Cole·2002-04-25null-—-8672 Bayshore DriveAtlantaGA30324N/A-
TPATPA-538732026-08-31T15:13:58ZRachel··—Dunan1981-08-16UHC-81108-80··•••-••-8644817.409.3848null2178 APACHE BOULEVARDEDEN PRAIRIEMN55348NULLSELECT-EPO
TPATPA-557742026-02-15T08:39:17ZChristina—Carter1942-10-03·nullUNKNOWN507-630-0680—6427 Pine DriveScottsdale··AZ85266GRP-5422—
TPATPA-565212026-03-12T11:05:35ZJANET··SHW1956-10-23——null-1812 Maple AveGlendaleAZ85306·GRP-5249null
TPATPA-571642026-02-27T04:54:55ZKATHLEEN—JOHNSTON05-01-1964··nullUNKNOWNN/A—1204 Highland AveLOS ANGELESCA·90056—UNKNOWN
TPATPA-513362026-04-08T05:36:19ZRalph—Shaw1955-09-18—·N/A8135007335—————nullNULL
TPATPA-614502026-08-11T06:35:58Z·Jonathan—Rivera19530410NULL—5869724641jonathan.rivera1@gmail.com·8587 River RoadPhoenixAZN/A—NAVIGATE-HMO
TPATPA-617842026-01-16T17:08:05ZPAUL—·COLEMAN9/22/1939—null—paul.coleman@hotmail.com8638 Main StreetMiami··FL33170·GRP-4495UNKNOWN
TPATPA-539592026-08-03T01:24:55ZAmy—Herrera2004-01-16—NULLNULLUNKNOWN2998 Harbor Blvd·NASHVILLETN37293UNKNOWN··—
TPATPA-626302026-08-24T15:38:57ZMelissa—Valdez··1958-04-10—•••-••-6597NULL-1948 Lincoln WayFRESNOCA93740-2627·GRP-6613-
TPATPA-607452026-08-16T20:39:23ZDANIALLE—PATTERSOON1947-08-04—··746-596-3510—·5328 Elm Street Apt 33FresnoCA93768——
TPATPA-544872026-02-23T05:16:54Zjmaes··johnson07/21/1945UHC2293311—nullJAMES.JOHNSON30@OUTLOOK.COM9124 Grand AveTempeAZ-UNKNOWNN/A
TPATPA-543422026-08-24T20:57:51ZJANICE—REID1952-10-16NULLnull3843108382—5596 Spring StreetNashvilleTN37238·NULL-
TPA TPA-624052026-02-16T21:03:24ZKAYLA—JENSEN1992-05-06UNKNOWN•••-••-7783—·null3522 Park PlacePhoenixAZ85045····null
TPATPA-585842026-09-26T18:41:34ZBishop, Joe——1966-10-26UHC-58513-77•••-••-7231UNKNOWN····4106 Elm StTempeAZ85216—-
TPATPA-569222026-08-25T20:09:47Z Davis, WalterT.—11/05/50—•••-••-5563-—5197 Cedar LnLas VegasNV89109nullUNKNOWN
TPATPA-527872026-09-12T19:31:15Z·Ryan—Rioos1977-01-16N/A•••-••-54747605054084ryan.rios37@proton.me4656 Maple AveMiamiFL33173UNKNOWNnull
TPATPA-617862026-03-23T01:19:27Z Carl—Ray1964-08-05-·NULLnull-·1930 Harbor BoulevardMESAAZ85208UNKNOWN—
TPATPA-609092026-02-10T11:01:05ZRANDY—MILLER1997-11-14······null5363072N/A·5877 Sunset BoulevardDallas·TX75286—-
TPATPA-631262026-09-11T18:36:32Zbob—walker1988-05-09UNKNOWNNULLN/ANULL1063 Mesa DrSAN ANTONIOTX78249GRP-4308CORE-HMO
TPATPA-527472026-03-08T03:01:48ZSHIRLEY U.—SANDOVAL1957-12-19nullN/A(247) 351-0207shirley.sandoval61@gmail.com2901 Jefferson AveEden PrairieMN55339N/AN/A
TPATPA-593592026-02-11T13:05:08Z Diego··—Holmes12/1/1973null-777.275.6459··UNKNOWN1427 Palm DriveTempeAZ85241-—
TPATPA-500522026-07-06T18:01:16ZDIANE A.—SCOTT1964-07-16-NULL(506) 679-8842N/A·6799 MAIN STLos AngelesCA90010-2374—OPTIONS-PPO
TPATPA-629072026-04-22T12:26:00Zjeremy—garza2000-07-21N/A•••-••-87629714004437jeremy.garza84@icloud.com6942 Mountain View DriveCharlotteNC28289-4904·nullMEDICARE-ADV-A
TPATPA-577652026-02-06T22:04:25ZHenry—Graham19690404N/A—null-N/A—-N/AUNKNOWNUNKNOWN··
TPATPA-593362026-03-15T23:13:07ZAUSTIN—FRANKLIN19440504N/ANULLUNKNOWNaustin.franklin@outlook.com8689 Bayshore DrTempeArizona85212-6282GRP-6010—
TPATPA-556552026-06-19T18:56:08ZDANIELLE··ZPHILLIPSJun 4, 1992····-7368254868NULL——nullUNKNOWN—NULL
TPATPA-554302026-09-06T05:34:25Zalice··porter1989-06-20UHC-37723-15•••-••-6412—null1574 River RdJACKSONVILLE··FL32201null··
TPATPA-598572026-03-27T02:44:56Zemma—silva1977-06-11null—·13613258723NULL6272 Church StPlanoTX75038UNKNOWNUNKNOWN
TPATPA-594142026-08-28T09:31:48Zaisha—hughes20000826—NULLUNKNOWN—5338 Cedar LaneDenverCO80284NULLMEDICARE-ADV-A
TPATPA-625572026-08-07T06:01:35ZNICHOLAS—SANTOS·1973-05-25NULLNULLN/Anicholas.santos@aol.com6211 Main St Apt 5MesaAZ85237UNKNOWNnull
TPATPA-610662026-06-12T16:21:41ZTeresa—RiveraDec 18, 1967UHC-46808-74•••-••-2773N/A—·9292 FOREST AVENUEFresnoCA93717—CHOICE-PLUS-PPO
TPATPA-541652026-09-20T05:25:39ZTucker, Marilyn——2003-02-22UNKNOWN··•••-••-7514—marilyn.tucker@outlook.com9692 Apache BoulevardTempeAZ85221—-
TPATPA-618262026-03-17T18:24:22ZVirginia··Green1963-10-26—N/A·229-204-7499VIRGINIA.GREEN@ICLOUD.COM·8700 Sunset BlvdSan DiegoCA92126—NULL
TPATPA-633432026-02-17T11:57:39ZKEVIN—COLE19831218N/Anull—KEVIN.COLE33@AOL.COM1759 FOREST AVEPhoenixAZ85030UNKNOWN—
TPATPA-608532026-07-07T23:25:01ZSOFIA—BANKS··1974-10-01—•••-••-4788(225) 635-5737NULL8990 SUNSET BLVD #855GilbertAZ85250-7661nullOPTIONS-PPO
TPATPA-572202026-04-06T02:31:30ZKenneth····Miller1954-07-05—·NULLnullkenneth.miller@yahoo.com9815 Indian School RoadPLANOTexas75043—N/A
TPATPA-569342026-10-06T14:06:50ZCarol—Phillips12/05/77-—(626) 588-2479-··8747 Apache BlvdPLANOTX75076UNKNOWN—
TPATPA-550712026-03-01T20:52:20ZMARY—MARTIN19831015null•••-••-1592nullNULL9709 Union StOrlandoFL32850-2425GRP-5491·UNKNOWN
TPATPA-545242026-07-08T11:43:11ZBrandon—Ortega14-07-2008—-UNKNOWNbrandon.ortega47@gmail.com5578 Pine DriveTempeAZ85298—NULL
TPATPA-513872026-04-30T07:31:36Z·PRIYA—WESTUNKNOWNnull•••-••-570612154121453—7070 Oak StreetCharlotte··NC28252——
TPATPA-506512026-10-04T06:51:17ZKIMBBERLY—RUSSELL1995-05-06—•••-••-8303·(332) 282-3386kimberly.russell@icloud.com—N/AN/AN/AnullCHOICE-PLUS-PPO
TPATPA-599952026-09-18T13:59:48ZBath—Reyes1944-11-12NULLUNKNOWN(341) 721-1908—6171 Spring StreetFresnoCA93733NULL-
TPATPA-637182026-03-18T23:26:51Zrichard—espinoza08-11-1964—•••-••-0640NULL·null2138 Spring StreetSacramentoCA95882GRP-3314N/A
TPATPA-521562026-02-07T14:02:23ZAMY··MCDONALD2508-19-19nullNULL·791-784-7622amy.mcdonald@outlook.com3775 VALLEY VIEW DRIVESacramentoCA95849NULLMEDICARE-ADV-B
TPATPA-598492026-02-13T06:37:06ZLAWRENCE—SOTO1974-08-02—N/A(582) 390-2790lawrence.soto36@icloud.com6232 Willow CtTEMPEArizona85269·NULLCHOICE-PLUS-PPO··
TPA TPA-529992026-06-27T17:33:11ZKEITH—VALDEZ23-04-1972-—(593) 452-5585null9071 Desert Sky BlvdAustintx78743UNKNOWN-
TPATPA-598582026-02-02T17:13:09ZAMANDA—ALEXANDER1398-02-27—N/AUNKNOWN—879 Sunset BlvdHoustonTX——OPTIONS-PPO
TPATPA-513792026-10-18T10:17:05ZWong, Jacob——·10/02/82—•••-••-8565N/AJACOB.WONG5@YAHOO.COM5567 Palm DrHoustonTX77049GRP-7783MEDICARE-ADV-B
14,474 rows, page 95 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:43.435Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty