Name: WDFW-Creel Analysis Catch
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

WDFW-Creel Analysis Catch

analysis of catch data
Organization: State of Washington
Last updated: 2021-10-01T22:23:09.047881

Tables

Table 1

@usgov.state_of_washington_wdfw_creel_analysis_catch.table_1

5.81 MB
73868 rows
42 columns


CREATE TABLE table_1 (
  "creel_event_id" VARCHAR,
  "event_date" VARCHAR,
  "water_body" VARCHAR,
  "project_name" VARCHAR,
  "fishery_name" VARCHAR,
  "catch_id" VARCHAR,
  "interview_id" VARCHAR,
  "species" VARCHAR,
  "run" VARCHAR,
  "gear_type" VARCHAR,
  "fate" VARCHAR,
  "life_stage" VARCHAR,
  "fin_mark" VARCHAR,
  "sex" VARCHAR,
  "maturity" VARCHAR,
  "fork_length_cm" DOUBLE,
  "total_length_in" VARCHAR,
  "fish_processing_status" VARCHAR,
  "cwt_detection_status" VARCHAR,
  "pit_detection_status" VARCHAR,
  "fish_count" BIGINT,
  "scale_card_num" VARCHAR,
  "scale_card_pos" DOUBLE,
  "dna_code" VARCHAR,
  "pit_code" VARCHAR,
  "snout_code" VARCHAR,
  "scale_age_code" VARCHAR,
  "scale_pattern" VARCHAR,
  "comments" VARCHAR,
  "cwt_code" VARCHAR,
  "cwt_read_status" VARCHAR,
  "cwt_rearing_location" VARCHAR,
  "cwt_release_site" VARCHAR,
  "cwt_species" VARCHAR,
  "cwt_run" DOUBLE,
  "cwt_brood_year" DOUBLE,
  "hook_location_reported" VARCHAR,
  "hook_location_observed" VARCHAR,
  "other_mark_types" VARCHAR,
  "other_marks" VARCHAR,
  "created_datetime" TIMESTAMP,
  "modified_datetime" TIMESTAMP
);