WDFW-Hatchery Adult Salmon Returns

This dataset are records of Adult Salmon that have returned to hatchery facilities. The events are separated into categories which include the number of fish handled. Event categories include Adult Receive, Trap Estimate, Adult Plant, Adult Ship, Adult Mortality, Adult Surplus, Eggtake, and Parent Spawn.

Adult events are recorded by date and include counts of adults and jacks, where applicable. Event details include species, run, brood year, sex of fish, and mark and tag information.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"wa-gov/wdfwhatchery-adult-salmon-returns-9q4e-xhag\".\"wdfwhatchery_adult_salmon_returns\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.