Dataset: Salmon Dataset

About this Dataset

Salmon Dataset

Age, sex and length (ASL) data provide population dynamics information that can indicate how population trends occur and may be changing. This data can help researchers estimate population growth rates, age-class distribution, and population demographics. Knowing population demographics, growth rates and trends is particularly valuable to fisheries managers who must perform population assessments to inform management decisions. This data is therefore important in valuable fisheries like the salmon fisheries of Alaska.

Source: https://knb.ecoinformatics.org/view/doi:10.5063/F1707ZTM

Tables

Asl Master

@kaggle.michaelbryantds_salmon_dataset.asl_master

32.84 MB
14347461 rows
27 columns


CREATE TABLE asl_master (
  "species" VARCHAR,
  "length_measurement_type" VARCHAR,
  "sampleyear" DOUBLE,
  "aslprojecttype" VARCHAR,
  "locationid" VARCHAR,
  "sampledate" TIMESTAMP,
  "length" DOUBLE,
  "weight" DOUBLE,
  "sex" VARCHAR,
  "salt_water_age" DOUBLE,
  "datasource" VARCHAR,
  "cardno" VARCHAR,
  "fishnum" VARCHAR,
  "age_error" VARCHAR,
  "fresh_water_age" DOUBLE,
  "sex_determination_method" VARCHAR,
  "subsystem" VARCHAR,
  "flag" VARCHAR,
  "gear" VARCHAR,
  "sasap_region" VARCHAR,
  "locationunique" VARCHAR,
  "districtid" DOUBLE,
  "sub_districtid" DOUBLE,
  "stat_area" DOUBLE,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "awc_code" VARCHAR
);