About this Dataset

2023 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 2023, fish were collected, sorted by species, and weighed at 34 unique sites from a total of 21 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-14T21:03:22.816921
Tags: 3-pass-depletion, electrofishing, fish-census, fish-surveys, fisheries, three-pass

Tables

Abrams Creek - 2023 - Adult

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.abrams_creek_2023_adult

5.08 kB
39 rows
5 columns

CREATE TABLE abrams_creek_2023_adult (
  "abrams_creek_2023_adult_site1_3_site2_4" BIGINT  -- Abrams Creek - 2023 - 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 - 2023 - Total

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.abrams_creek_2023_total

7.14 kB
134 rows
7 columns

CREATE TABLE abrams_creek_2023_total (
  "abrams_creek_2023_total_site1_3_site2_4" BIGINT  -- Abrams Creek - 2023 - 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 - 2023 - YOY

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.abrams_creek_2023_yoy

4.96 kB
55 rows
5 columns

CREATE TABLE abrams_creek_2023_yoy (
  "abrams_creek_2023_yoy_site1_3_site2_4" BIGINT  -- Abrams Creek - 2023 - 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
);

Aden Branch - 2023 - Adult

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.aden_branch_2023_adult

4.76 kB
18 rows
5 columns

CREATE TABLE aden_branch_2023_adult (
  "aden_branch_2023_adult_site1_1" BIGINT  -- Aden Branch - 2023 - Adult - Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Aden Branch - 2023 - Total

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.aden_branch_2023_total

4.87 kB
32 rows
5 columns

CREATE TABLE aden_branch_2023_total (
  "aden_branch_2023_total_site1_1" BIGINT  -- Aden Branch - 2023 - Total - Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Aden Branch - 2023 - YOY

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.aden_branch_2023_yoy

4.67 kB
14 rows
5 columns

CREATE TABLE aden_branch_2023_yoy (
  "aden_branch_2023_yoy_site1_1" BIGINT  -- Aden Branch - 2023 - YOY - Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Anthony Creek - 2023 - Adult

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.anthony_creek_2023_adult

4.71 kB
4 rows
5 columns

CREATE TABLE anthony_creek_2023_adult (
  "anthony_creek_2023_adult_site1_14_site2_5" BIGINT  -- Anthony Creek - 2023 - Adult - 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 - 2023 - Total

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.anthony_creek_2023_total

5.18 kB
58 rows
5 columns

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

Anthony Creek - 2023 - YOY

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.anthony_creek_2023_yoy

5.12 kB
54 rows
5 columns

CREATE TABLE anthony_creek_2023_yoy (
  "anthony_creek_2023_yoy_site1_1_site2_14_site3_5" BIGINT  -- Anthony Creek - 2023 - YOY - Site1=1 Site2=14 Site3=5,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Bunches Creek - 2023 - Adult

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.bunches_creek_2023_adult

5.75 kB
141 rows
5 columns

CREATE TABLE bunches_creek_2023_adult (
  "bunches_creek_2023_adult_site1_2_site2_3" BIGINT  -- Bunches Creek - 2023 - Adult - Site1=2 Site2=3,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Bunches Creek - 2023 - Total

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.bunches_creek_2023_total

6.09 kB
215 rows
5 columns

CREATE TABLE bunches_creek_2023_total (
  "bunches_creek_2023_total_site1_2_site2_3" BIGINT  -- Bunches Creek - 2023 - Total - Site1=2 Site2=3,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Bunches Creek - 2023 - YOY

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.bunches_creek_2023_yoy

5.02 kB
74 rows
5 columns

CREATE TABLE bunches_creek_2023_yoy (
  "bunches_creek_2023_yoy_site1_2_site2_3" BIGINT  -- Bunches Creek - 2023 - YOY - Site1=2 Site2=3,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Cannon Creek - 2023 - Adult

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.cannon_creek_2023_adult

4.72 kB
15 rows
5 columns

CREATE TABLE cannon_creek_2023_adult (
  "cannon_creek_2023_adult_site1_1" BIGINT  -- Cannon Creek - 2023 - 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 - 2023 - Total

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.cannon_creek_2023_total

4.91 kB
45 rows
5 columns

CREATE TABLE cannon_creek_2023_total (
  "cannon_creek_2023_total_site1_1" BIGINT  -- Cannon Creek - 2023 - 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 - 2023 - YOY

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.cannon_creek_2023_yoy

4.73 kB
30 rows
5 columns

CREATE TABLE cannon_creek_2023_yoy (
  "cannon_creek_2023_yoy_site1_1" BIGINT  -- Cannon Creek - 2023 - YOY - Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Cosby Creek - 2023 - Adult

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.cosby_creek_2023_adult

5.53 kB
95 rows
5 columns

CREATE TABLE cosby_creek_2023_adult (
  "cosby_creek_2023_adult_site1_1_site2_2" BIGINT  -- Cosby Creek - 2023 - 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
);

Cosby Creek - 2023 - Total

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.cosby_creek_2023_total

7.08 kB
136 rows
7 columns

CREATE TABLE cosby_creek_2023_total (
  "cosby_creek_2023_total_site1_1_site2_2" BIGINT  -- Cosby Creek - 2023 - Total - Site1=1 Site2=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 - 2023 - YOY

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.cosby_creek_2023_yoy

4.89 kB
32 rows
5 columns

CREATE TABLE cosby_creek_2023_yoy (
  "cosby_creek_2023_yoy_site1_1_site2_2" BIGINT  -- Cosby Creek - 2023 - 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
);

Deep Creek - 2023 - Adult

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.deep_creek_2023_adult

5.43 kB
83 rows
5 columns

CREATE TABLE deep_creek_2023_adult (
  "deep_creek_2023_adult_site1_3_site2_aq3" BIGINT  -- Deep Creek - 2023 - 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 - 2023 - Total

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.deep_creek_2023_total

6.92 kB
126 rows
7 columns

CREATE TABLE deep_creek_2023_total (
  "deep_creek_2023_total_site1_3_site2_aq3" BIGINT  -- Deep Creek - 2023 - 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 - 2023 - YOY

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.deep_creek_2023_yoy

4.96 kB
42 rows
5 columns

CREATE TABLE deep_creek_2023_yoy (
  "deep_creek_2023_yoy_site1_3_site2_aq3" BIGINT  -- Deep Creek - 2023 - 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
);

Flat Creek - 2023 - Adult

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.flat_creek_2023_adult

5.35 kB
96 rows
5 columns

CREATE TABLE flat_creek_2023_adult (
  "flat_creek_2023_adult_site1_1" BIGINT  -- Flat Creek - 2023 - Adult Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Flat Creek - 2023 - Total

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.flat_creek_2023_total

5.65 kB
160 rows
5 columns

CREATE TABLE flat_creek_2023_total (
  "flat_creek_2023_total_site1_1" BIGINT  -- Flat Creek - 2023 - Total Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Flat Creek - 2023 - YOY

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.flat_creek_2023_yoy

4.86 kB
64 rows
5 columns

CREATE TABLE flat_creek_2023_yoy (
  "flat_creek_2023_yoy_site1_1" BIGINT  -- Flat Creek - 2023 - YOY Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Indian Creek - 2023 - Adult

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.indian_creek_2023_adult

4.81 kB
18 rows
5 columns

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