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

Pretty Hollow Creek - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.pretty_hollow_creek_2024_yoy

5.05 kB
75 rows
5 columns

CREATE TABLE pretty_hollow_creek_2024_yoy (
  "pretty_hollow_creek_2024_yoy_site1_1" BIGINT  -- Pretty Hollow 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
);

Road Prong - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.road_prong_2024_adult

5.69 kB
119 rows
5 columns

CREATE TABLE road_prong_2024_adult (
  "road_prong_2024_adult_site1_2_site2_5" BIGINT  -- Road Prong - 2024 - Adult Site1=2 Site2=5,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Road Prong - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.road_prong_2024_total

5.9 kB
149 rows
5 columns

CREATE TABLE road_prong_2024_total (
  "road_prong_2024_total_site1_2_site2_5" BIGINT  -- Road Prong - 2024 - Total Site1=2 Site2=5,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Road Prong - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.road_prong_2024_yoy

4.84 kB
30 rows
5 columns

CREATE TABLE road_prong_2024_yoy (
  "road_prong_2024_yoy_site1_2_site2_5" BIGINT  -- Road Prong - 2024 - YOY Site1=2 Site2=5,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Rock Creek - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.rock_creek_2024_adult

4.99 kB
34 rows
5 columns

CREATE TABLE rock_creek_2024_adult (
  "rock_creek_2024_adult_site1_3_site2_7" BIGINT  -- Rock Creek - 2024 - Adult Site1=3 Site2=7,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Rock Creek - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.rock_creek_2024_total

6.42 kB
54 rows
7 columns

CREATE TABLE rock_creek_2024_total (
  "rock_creek_2024_total_site1_3_site2_7" BIGINT  -- Rock Creek - 2024 - Total Site1=3 Site2=7,
  "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
);

Rock Creek - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.rock_creek_2024_yoy

4.74 kB
13 rows
5 columns

CREATE TABLE rock_creek_2024_yoy (
  "rock_creek_2024_yoy_site1_3_site2_7" BIGINT  -- Rock Creek - 2024 - YOY Site1=3 Site2=7,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Rough Fork - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.rough_fork_2024_adult

4.94 kB
35 rows
5 columns

CREATE TABLE rough_fork_2024_adult (
  "rough_fork_2024_adult_site1_1" BIGINT  -- Rough 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
);

Rough Fork - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.rough_fork_2024_total

6.72 kB
112 rows
7 columns

CREATE TABLE rough_fork_2024_total (
  "rough_fork_2024_total_site1_1" BIGINT  -- Rough Fork - 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
);

Rough Fork - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.rough_fork_2024_yoy

5.05 kB
72 rows
5 columns

CREATE TABLE rough_fork_2024_yoy (
  "rough_fork_2024_yoy_site1_1" BIGINT  -- Rough 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
);

Walker Camp Prong - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.walker_camp_prong_2024_adult

5.61 kB
103 rows
5 columns

CREATE TABLE walker_camp_prong_2024_adult (
  "walker_camp_prong_2024_adult_site1_1_site2_2" BIGINT  -- Walker Camp Prong - 2024 - Adult Site1=1 Site2=2,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Walker Camp Prong - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.walker_camp_prong_2024_total

5.88 kB
137 rows
5 columns

CREATE TABLE walker_camp_prong_2024_total (
  "walker_camp_prong_2024_total_site1_1_site2_2" BIGINT  -- Walker Camp Prong - 2024 - Total Site1=1 Site2=2,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Walker Camp Prong - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.walker_camp_prong_2024_yoy

4.95 kB
34 rows
5 columns

CREATE TABLE walker_camp_prong_2024_yoy (
  "walker_camp_prong_2024_yoy_site1_1_site2_2" BIGINT  -- Walker Camp Prong - 2024 - YOY Site1=1 Site2=2,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Walkers Creek - 2024 - Adult

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.walkers_creek_2024_adult

4.9 kB
27 rows
5 columns

CREATE TABLE walkers_creek_2024_adult (
  "walkers_creek_2024_adult_site1_1n" BIGINT  -- Walkers Creek - 2024 - Adult Site1=1N,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Walkers Creek - 2024 - Total

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.walkers_creek_2024_total

6.26 kB
46 rows
7 columns

CREATE TABLE walkers_creek_2024_total (
  "walkers_creek_2024_total_site1_1n" BIGINT  -- Walkers Creek - 2024 - Total Site1=1N,
  "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
);

Walkers Creek - 2024 - YOY

@usgov.doi_gov_2024_three_pass_depletion_fish_census_surveys.walkers_creek_2024_yoy

4.75 kB
17 rows
5 columns

CREATE TABLE walkers_creek_2024_yoy (
  "walkers_creek_2024_yoy_site1_1n" BIGINT  -- Walkers Creek - 2024 - YOY Site1=1N,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);