About this Dataset

Stated Preference Data For Salmon Recovery

This is the underlying data used to generate the willingness-to-pay estimates for salmon recovery in the publication "Valuing Wild Salmon and Steelhead Recovery in Oregon’s Most Urbanized Watershed.".

This dataset is associated with the following publication:
Papenfus, M., and M. Weber. Valuing Wild Salmon and Steelhead Recovery in Oregon's Most Urbanized Watershed. ECOLOGICAL ECONOMICS. Elsevier Science Ltd, New York, NY, USA, 236: 108540, (2025).
Organization: U.S. Environmental Protection Agency
Last updated: 2025-08-25T21:08:14.043345
Tags: non-market-valuation, nonuse-value, salmon-conversation, stated-preference, threatened-species

Tables

Salmon Long FinalData2

@usgov.epa_gov_stated_preference_data_for_salmon_recovery.salmon_long_finaldata2

181.87 kB
7,011 rows
49 columns

CREATE TABLE salmon_long_finaldata2 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" BIGINT,
  "alt_label" VARCHAR,
  "sid" BIGINT,
  "choicesid" BIGINT,
  "qid" BIGINT,
  "question" VARCHAR,
  "option" BIGINT,
  "choice" BIGINT,
  "srecovery" BIGINT,
  "time" BIGINT,
  "status" BIGINT,
  "fishpop" BIGINT,
  "cost" BIGINT,
  "fish_low" BIGINT,
  "fish_high" BIGINT,
  "time_short" BIGINT,
  "time_medium" BIGINT,
  "time_long" BIGINT,
  "shortbasic" BIGINT,
  "shorthigh" BIGINT,
  "mediumbasic" BIGINT,
  "mediumhigh" BIGINT,
  "longbasic" BIGINT,
  "longhigh" BIGINT,
  "asc_sq" BIGINT,
  "age" BIGINT,
  "gender" VARCHAR,
  "income" VARCHAR,
  "edu" BIGINT,
  "wbres" BIGINT,
  "county" BIGINT,
  "cost100" DOUBLE,
  "asc_recovery" BIGINT,
  "asc_r1" BIGINT,
  "asc_r2" BIGINT,
  "choicesid_new" BIGINT,
  "idx_choicesid" BIGINT,
  "idx_id" BIGINT,
  "idx_alt_label" VARCHAR,
  "retired" BIGINT,
  "edu_college" BIGINT,
  "edu_college_25" BIGINT,
  "inc" BIGINT,
  "incmidpt" DOUBLE,
  "wbres_asc" BIGINT,
  "edu_asc" BIGINT,
  "retired_asc" BIGINT,
  "inc_asc" DOUBLE
);