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

Abrams Creek - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.abrams_creek_2024_adult

5.1 kB
44 rows
5 columns

CREATE TABLE abrams_creek_2024_adult (
  "abrams_creek_2024_adult_site1_3_site2_4" BIGINT  -- Abrams Creek - 2024 - Adult Site1=3 Site2=4,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Abrams Creek - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.abrams_creek_2024_total

7 kB
107 rows
7 columns

CREATE TABLE abrams_creek_2024_total (
  "abrams_creek_2024_total_site1_3_site2_4" BIGINT  -- Abrams Creek - 2024 - Total Site1=3 Site2=4,
  "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
);

Abrams Creek - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.abrams_creek_2024_yoy

4.85 kB
30 rows
5 columns

CREATE TABLE abrams_creek_2024_yoy (
  "abrams_creek_2024_yoy_site1_3_site2_4" BIGINT  -- Abrams Creek - 2024 - YOY Site1=3 Site2=4,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Anthony Creek - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.anthony_creek_2024_adult

4.89 kB
20 rows
5 columns

CREATE TABLE anthony_creek_2024_adult (
  "anthony_creek_2024_adult_site_1_14_site_2_5" BIGINT  -- Anthony Creek - 2024 - Adult Site 1=14 Site 2=5,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Anthony Creek - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.anthony_creek_2024_total

4.95 kB
26 rows
5 columns

CREATE TABLE anthony_creek_2024_total (
  "anthony_creek_2024_total_site1_14_site2_5" BIGINT  -- Anthony Creek - 2024 - Total Site1=14 Site2=5,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Anthony Creek - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.anthony_creek_2024_yoy

4.73 kB
6 rows
5 columns

CREATE TABLE anthony_creek_2024_yoy (
  "anthony_creek_2024_yoy_site_1_14_site_2_5" BIGINT  -- Anthony Creek - 2024 - YOY Site 1=14 Site 2=5,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Bone Valley Creek - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.bone_valley_creek_2024_adult

4.99 kB
52 rows
5 columns

CREATE TABLE bone_valley_creek_2024_adult (
  "bone_valley_creek_2024_adult_site_1_3" BIGINT  -- Bone Valley Creek - 2024 - Adult Site 1=3,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" BIGINT  -- Unnamed: 4
);

Bone Valley Creek - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.bone_valley_creek_2024_total

6.51 kB
97 rows
7 columns

CREATE TABLE bone_valley_creek_2024_total (
  "bone_valley_creek_2024_total_site_1_3" BIGINT  -- Bone Valley Creek - 2024 - Total Site 1=3,
  "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
);

Bone Valley Creek - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.bone_valley_creek_2024_yoy

4.84 kB
41 rows
5 columns

CREATE TABLE bone_valley_creek_2024_yoy (
  "bone_valley_creek_2024_yoy_site_1_3" BIGINT  -- Bone Valley Creek - 2024 - YOY Site 1=3,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Bunches Creek - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.bunches_creek_2024_adult

5.92 kB
192 rows
5 columns

CREATE TABLE bunches_creek_2024_adult (
  "bunches_creek_2024_adult_site_1_1_site_2_2_site_3_3" BIGINT  -- Bunches Creek - 2024 - Adult Site 1=1 Site 2=2 Site 3=3,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Bunches Creek - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.bunches_creek_2024_total

6.49 kB
316 rows
5 columns

CREATE TABLE bunches_creek_2024_total (
  "bunches_creek_2024_total_site_1_1_site_2_2_site_3_3" BIGINT  -- Bunches Creek - 2024 - Total Site 1=1 Site 2=2 Site 3=3,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Bunches Creek - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.bunches_creek_2024_yoy

5.37 kB
124 rows
5 columns

CREATE TABLE bunches_creek_2024_yoy (
  "bunches_creek_2024_yoy_site_1_1_site_2_2_site_3_3" BIGINT  -- Bunches Creek - 2024 - YOY Site 1=1 Site 2=2 Site 3=3,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Cannon Creek - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.cannon_creek_2024_adult

4.96 kB
39 rows
5 columns

CREATE TABLE cannon_creek_2024_adult (
  "cannon_creek_2024_adult_site1_1" BIGINT  -- Cannon 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
);

Cannon Creek - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.cannon_creek_2024_total

4.99 kB
42 rows
5 columns

CREATE TABLE cannon_creek_2024_total (
  "cannon_creek_2024_total_site1_1" BIGINT  -- Cannon 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
);

Cannon Creek - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.cannon_creek_2024_yoy

4.75 kB
3 rows
5 columns

CREATE TABLE cannon_creek_2024_yoy (
  "cannon_creek_2024_yoy_site_1_1_site_2_2_site_3_3" BIGINT  -- Cannon Creek - 2024 - YOY Site 1=1 Site 2=2 Site 3=3,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Cosby Creek - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.cosby_creek_2024_adult

5.33 kB
64 rows
5 columns

CREATE TABLE cosby_creek_2024_adult (
  "cosby_creek_2024_adult_site_1_1_site_2_2" BIGINT  -- Cosby Creek - 2024 - Adult Site 1=1 Site 2=2,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Cosby Creek - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.cosby_creek_2024_total

6.8 kB
89 rows
7 columns

CREATE TABLE cosby_creek_2024_total (
  "cosby_creek_2024_total_site_1_1_site_2_2" BIGINT  -- Cosby Creek - 2024 - Total Site 1=1 Site 2=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
);

Cosby Creek - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.cosby_creek_2024_yoy

4.79 kB
16 rows
5 columns

CREATE TABLE cosby_creek_2024_yoy (
  "cosby_creek_2024_yoy_site_1_1_site_2_2" BIGINT  -- Cosby Creek - 2024 - YOY Site 1=1 Site 2=2,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Deep Creek - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.deep_creek_2024_adult

5.32 kB
70 rows
5 columns

CREATE TABLE deep_creek_2024_adult (
  "deep_creek_2024_adult_site1_3_site2_aq3" BIGINT  -- Deep Creek - 2024 - Adult Site1=3 Site2=AQ3,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Deep Creek - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.deep_creek_2024_total

6.87 kB
133 rows
7 columns

CREATE TABLE deep_creek_2024_total (
  "deep_creek_2024_total_site1_3_site2_aq3" BIGINT  -- Deep Creek - 2024 - Total Site1=3 Site2=AQ3,
  "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
);

Deep Creek - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.deep_creek_2024_yoy

4.95 kB
62 rows
5 columns

CREATE TABLE deep_creek_2024_yoy (
  "deep_creek_2024_yoy_site1_3_site2_aq3" BIGINT  -- Deep Creek - 2024 - YOY Site1=3 Site2=AQ3,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Hazel Creek - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.hazel_creek_2024_adult

5.41 kB
93 rows
5 columns

CREATE TABLE hazel_creek_2024_adult (
  "hazel_creek_2024_adult_site1_3n_site2_4" BIGINT  -- Hazel Creek - 2024 - Adult Site1=3N Site2=4,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Hazel Creek - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.hazel_creek_2024_total

5.71 kB
146 rows
5 columns

CREATE TABLE hazel_creek_2024_total (
  "hazel_creek_2024_total_site1_3n_site2_4" BIGINT  -- Hazel Creek - 2024 - Total Site1=3N Site2=4,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Hazel Creek - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.hazel_creek_2024_yoy

4.92 kB
53 rows
5 columns

CREATE TABLE hazel_creek_2024_yoy (
  "hazel_creek_2024_yoy_site1_3n_site2_4" BIGINT  -- Hazel Creek - 2024 - YOY Site1=3N Site2=4,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Indian Creek - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.indian_creek_2024_adult

4.84 kB
22 rows
5 columns

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