WDFW-Hatchery Programs by US Government | Demographics and Population Studies

About this Dataset

WDFW-Hatchery Programs

A list of hatchery programs presented in the Salmon Conservation Reporting Engine (SCoRE)
Organization: State of Washington
Last updated: 2020-11-10T17:20:04.947347
Tags: hatcheries, salmon, wdfw

Tables

Table 1

@usgov.state_of_washington_wdfw_hatchery_programs.table_1

55.66 KB
146 rows
49 columns


CREATE TABLE table_1 (
  "facility_name" VARCHAR,
  "hatchery_program_name" VARCHAR,
  "hatchery_program_type" VARCHAR,
  "species" VARCHAR,
  "run" VARCHAR,
  "life_stage" VARCHAR,
  "goal" VARCHAR,
  "production_goal" DOUBLE,
  "pni_year" BIGINT,
  "integrated_pni_rate" DOUBLE,
  "integrated_pni_rate_description" VARCHAR,
  "integrated_pni_goal" DOUBLE,
  "integrated_pni_goal_description" VARCHAR,
  "segrated_phos_rate" DOUBLE,
  "segrated_phos_rate_description" VARCHAR,
  "segrated_phos_goal" DOUBLE,
  "segrated_phos_goal_description" VARCHAR,
  "juvenile_produced" DOUBLE,
  "juvenile_to_smolt_survival_percent" DOUBLE,
  "juvenile_to_smolt_survival_description" VARCHAR,
  "actual_adult_hatchery_produced" DOUBLE,
  "actual_adult_hatchery_produced_description" VARCHAR,
  "adult_returns_to_hatchery_broodstock_total" DOUBLE,
  "adult_returns_to_hatchery_broodstock_description" VARCHAR,
  "adult_returns_to_hatchery_wild_broodstock_percent" DOUBLE,
  "adult_returns_to_hatchery_wild_broodstock_description" VARCHAR,
  "adult_returns_to_hatchery_excess" DOUBLE,
  "adult_returns_to_hatchery_excess_description" VARCHAR,
  "adult_where_returning_fish_go_hatchery_percent" DOUBLE,
  "adult_where_returning_fish_go_hatchery_description" VARCHAR,
  "adult_where_returning_fish_go_harvested_percent" DOUBLE,
  "adult_where_returning_fish_go_harvested_description" VARCHAR,
  "adult_where_returning_fish_go_spawning_grounds_percent" DOUBLE,
  "adult_where_returning_fish_go_spawning_grounds_description" VARCHAR,
  "non_wa_caught_adult" DOUBLE,
  "non_wa_caught_adult_description" VARCHAR,
  "sport_caught_adult" DOUBLE,
  "sport_caught_adult_description" VARCHAR,
  "net_caught_adult" DOUBLE,
  "net_caught_adult_description" VARCHAR,
  "troll_caught_adult" DOUBLE,
  "troll_caught_adult_description" VARCHAR,
  "cost_per_adult" VARCHAR,
  "cost_per_adult_description" VARCHAR,
  "county" VARCHAR,
  "wria" VARCHAR,
  "salmon_recovery_region" VARCHAR,
  "lead_entity" VARCHAR,
  "last_updated" VARCHAR
);