Name: WDFW-Coded Wire Tag Fish Recoveries
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

WDFW-Coded Wire Tag Fish Recoveries

New data (unverified) within this dataset is preliminary and subject to change per the verification process.
Organization: State of Washington
Last updated: 2020-11-10T17:20:15.531950
Tags: cwt, salmon, wdfw

Tables

Table 1

@usgov.state_of_washington_wdfw_coded_wire_tag_fish_recoveries.table_1

2.75 MB
100,000 rows
44 columns

CREATE TABLE table_1 (
  "return_year" BIGINT,
  "verified_date" VARCHAR,
  "species" VARCHAR,
  "run" VARCHAR,
  "location_name" VARCHAR,
  "psc_code" VARCHAR,
  "location_code" VARCHAR,
  "process_project" VARCHAR,
  "recovery_gear_type" VARCHAR,
  "psnet_recovery_gear_type" VARCHAR,
  "bag_label" VARCHAR,
  "head_number" BIGINT,
  "recovery_date" TIMESTAMP,
  "sample_type" VARCHAR,
  "tag_result" VARCHAR,
  "tag_code" VARCHAR,
  "fork_length_cm" DOUBLE  -- Fork Length (cm),
  "sex" VARCHAR,
  "fisher_type" VARCHAR,
  "maturity" VARCHAR,
  "mark" VARCHAR,
  "project_fish_number" VARCHAR,
  "sample_card_number" VARCHAR,
  "sample_card_record_number" VARCHAR,
  "scale_card_number" VARCHAR,
  "scale_card_line_number" VARCHAR,
  "otolith_number" VARCHAR,
  "brood_year" DOUBLE,
  "first_release_date" TIMESTAMP,
  "last_release_date" TIMESTAMP,
  "release_site" VARCHAR,
  "rearing_hatchery" VARCHAR,
  "stock_name" VARCHAR,
  "release_run" VARCHAR,
  "release_agency" VARCHAR,
  "bag_label_comments" VARCHAR,
  "fish_comments" VARCHAR,
  "release_comments" VARCHAR,
  "released_tag_adclip_count" DOUBLE,
  "released_tag_no_adclip_count" DOUBLE,
  "released_untag_adclip_count" DOUBLE,
  "released_untag_no_adclip_count" DOUBLE,
  "internalid" BIGINT,
  "lastupdatedate" VARCHAR
);