About this Dataset

2024 Three-Pass Depletion Fish Census Surveys

These data represent fish census surveys in Great Smoky Mountains National Park conducted using the Delury Method of Three-Pass Depletion electrofishing. In 2024, fish were collected, sorted by species, and weighed at 34 unique sites from a total of 22 streams ranging in size from first to third-order waterways. These streams are surveyed on an annual basis to monitor population trends over time.
Organization: Department of the Interior
Last updated: 2025-09-14T17:57:33.393738
Tags: 2024-fish-census, annual-fish-population-data, brook-trout, fish-abundance, fish-biomass, fish-populations, population-estimates, trout

Tables

Indian Creek - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.indian_creek_2024_total

4.9 kB
27 rows
5 columns

CREATE TABLE indian_creek_2024_total (
  "indian_creek_2024_total_site1_1_5" BIGINT  -- Indian Creek - 2024 - Total Site1=1.5,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Indian Creek - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.indian_creek_2024_yoy

4.62 kB
5 rows
5 columns

CREATE TABLE indian_creek_2024_yoy (
  "indian_creek_2024_yoy_site1_1_5" BIGINT  -- Indian Creek - 2024 - YOY Site1=1.5,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Jakes Creek - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.jakes_creek_2024_adult

4.81 kB
24 rows
5 columns

CREATE TABLE jakes_creek_2024_adult (
  "jakes_creek_2024_adult_site1_1" BIGINT  -- Jakes Creek - 2024 - Adult Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Jakes Creek - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.jakes_creek_2024_total

6.04 kB
28 rows
7 columns

CREATE TABLE jakes_creek_2024_total (
  "jakes_creek_2024_total_site1_1" BIGINT  -- Jakes Creek - 2024 - Total Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" DOUBLE  -- Unnamed: 5,
  "unnamed_6" DOUBLE  -- Unnamed: 6
);

Jakes Creek - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.jakes_creek_2024_yoy

4.56 kB
2 rows
5 columns

CREATE TABLE jakes_creek_2024_yoy (
  "jakes_creek_2024_yoy_site1_1" BIGINT  -- Jakes Creek - 2024 - YOY Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Kanati Fork - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.kanati_fork_2024_adult

4.65 kB
8 rows
5 columns

CREATE TABLE kanati_fork_2024_adult (
  "kanati_fork_2024_adult_site1_1" BIGINT  -- Kanati Fork - 2024 - Adult Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Kanati Fork - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.kanati_fork_2024_total

4.71 kB
12 rows
5 columns

CREATE TABLE kanati_fork_2024_total (
  "kanati_fork_2024_total_site1_1" BIGINT  -- Kanati Fork - 2024 - Total Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Kanati Fork - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.kanati_fork_2024_yoy

4.59 kB
4 rows
5 columns

CREATE TABLE kanati_fork_2024_yoy (
  "kanati_fork_2024_yoy_site1_1" BIGINT  -- Kanati Fork - 2024 - YOY Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

LF Anthony Creek - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.lf_anthony_creek_2024_adult

4.82 kB
18 rows
5 columns

CREATE TABLE lf_anthony_creek_2024_adult (
  "lf_anthony_creek_2024_adult_site1_10" BIGINT  -- LF Anthony Creek - 2024 - Adult Site1=10,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

LF Anthony Creek - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.lf_anthony_creek_2024_total

4.96 kB
38 rows
5 columns

CREATE TABLE lf_anthony_creek_2024_total (
  "lf_anthony_creek_2024_total_site1_10" BIGINT  -- LF Anthony Creek - 2024 - Total Site1=10,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

LF Anthony Creek - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.lf_anthony_creek_2024_yoy

4.76 kB
20 rows
5 columns

CREATE TABLE lf_anthony_creek_2024_yoy (
  "lf_anthony_creek_2024_yoy_site1_10" BIGINT  -- LF Anthony Creek - 2024 - YOY Site1=10,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Mill Creek - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.mill_creek_2024_adult

4.7 kB
15 rows
5 columns

CREATE TABLE mill_creek_2024_adult (
  "mill_creek_2024_adult_site1_2" BIGINT  -- Mill Creek - 2024 - Adult Site1=2,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Mill Creek - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.mill_creek_2024_total

6.11 kB
37 rows
7 columns

CREATE TABLE mill_creek_2024_total (
  "mill_creek_2024_total_site1_2" BIGINT  -- Mill Creek - 2024 - Total Site1=2,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" DOUBLE  -- Unnamed: 5,
  "unnamed_6" DOUBLE  -- Unnamed: 6
);

Mill Creek - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.mill_creek_2024_yoy

4.65 kB
15 rows
5 columns

CREATE TABLE mill_creek_2024_yoy (
  "mill_creek_2024_yoy_site1_2" BIGINT  -- Mill Creek - 2024 - YOY Site1=2,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Moore Springs Branch - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.moore_springs_branch_2024_adult

5.12 kB
38 rows
5 columns

CREATE TABLE moore_springs_branch_2024_adult (
  "moore_springs_branch_2024_adult_site1_3_site2_12" BIGINT  -- Moore Springs Branch - 2024 - Adult Site1=3 Site2=12,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Moore Springs Branch - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.moore_springs_branch_2024_total

6.54 kB
59 rows
7 columns

CREATE TABLE moore_springs_branch_2024_total (
  "moore_springs_branch_2024_total_site1_3_site2_12" BIGINT  -- Moore Springs Branch - 2024 - Total Site1=3 Site2=12,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" DOUBLE  -- Unnamed: 5,
  "unnamed_6" DOUBLE  -- Unnamed: 6
);

Moore Springs Branch - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.moore_springs_branch_2024_yoy

4.86 kB
15 rows
5 columns

CREATE TABLE moore_springs_branch_2024_yoy (
  "moore_springs_branch_2024_yoy_site1_3_site2_12" BIGINT  -- Moore Springs Branch - 2024 - YOY Site1=3 Site2=12,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Onion Bed Branch - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.onion_bed_branch_2024_adult

4.95 kB
35 rows
5 columns

CREATE TABLE onion_bed_branch_2024_adult (
  "onion_bed_branch_2024_adult_site1_1" BIGINT  -- Onion Bed Branch - 2024 - Adult Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Onion Bed Branch - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.onion_bed_branch_2024_total

5.01 kB
45 rows
5 columns

CREATE TABLE onion_bed_branch_2024_total (
  "onion_bed_branch_2024_total_site1_1" BIGINT  -- Onion Bed Branch - 2024 - Total Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Onion Bed Branch - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.onion_bed_branch_2024_yoy

4.66 kB
10 rows
5 columns

CREATE TABLE onion_bed_branch_2024_yoy (
  "onion_bed_branch_2024_yoy_site1_1" BIGINT  -- Onion Bed Branch - 2024 - YOY Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Porters Creek - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.porters_creek_2024_adult

5.12 kB
61 rows
5 columns

CREATE TABLE porters_creek_2024_adult (
  "porters_creek_2024_adult_site1_2" BIGINT  -- Porters Creek - 2024 - Adult Site1=2,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Porters Creek - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.porters_creek_2024_total

5.21 kB
70 rows
5 columns

CREATE TABLE porters_creek_2024_total (
  "porters_creek_2024_total_site1_2" BIGINT  -- Porters Creek - 2024 - Total Site1=2,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Porters Creek - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.porters_creek_2024_yoy

4.64 kB
9 rows
5 columns

CREATE TABLE porters_creek_2024_yoy (
  "porters_creek_2024_yoy_site1_2" BIGINT  -- Porters Creek - 2024 - YOY Site1=2,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Pretty Hollow Creek - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.pretty_hollow_creek_2024_adult

5.11 kB
44 rows
5 columns

CREATE TABLE pretty_hollow_creek_2024_adult (
  "pretty_hollow_creek_2024_adult_site1_1" BIGINT  -- Pretty Hollow Creek - 2024 - Adult Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Pretty Hollow Creek - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.pretty_hollow_creek_2024_total

5.47 kB
119 rows
5 columns

CREATE TABLE pretty_hollow_creek_2024_total (
  "pretty_hollow_creek_2024_total_site1_1" BIGINT  -- Pretty Hollow Creek - 2024 - Total Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);