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

Indian Creek - 2023 - Total

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.indian_creek_2023_total

4.88 kB
25 rows
5 columns

CREATE TABLE indian_creek_2023_total (
  "indian_creek_2023_total_site1_1_5" BIGINT  -- Indian Creek - 2023 - 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 - 2023 - YOY

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.indian_creek_2023_yoy

4.66 kB
7 rows
5 columns

CREATE TABLE indian_creek_2023_yoy (
  "indian_creek_2023_yoy_site1_1_5" BIGINT  -- Indian Creek - 2023 - 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 - 2023 - Adult

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.jakes_creek_2023_adult

5.71 kB
117 rows
5 columns

CREATE TABLE jakes_creek_2023_adult (
  "jakes_creek_2023_adult_site1_0_5_site2_1" BIGINT  -- Jakes Creek - 2023 - Adult - Site1=0.5 Site2=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Jakes Creek - 2023 - Total

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.jakes_creek_2023_total

7.16 kB
146 rows
7 columns

CREATE TABLE jakes_creek_2023_total (
  "jakes_creek_2023_total_site1_0_5_site2_1" BIGINT  -- Jakes Creek - 2023 - Total - Site1=0.5 Site2=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 - 2023 - YOY

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.jakes_creek_2023_yoy

4.84 kB
22 rows
5 columns

CREATE TABLE jakes_creek_2023_yoy (
  "jakes_creek_2023_yoy_site1_0_5_site2_1" BIGINT  -- Jakes Creek - 2023 - YOY - Site1=0.5 Site2=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Kanati Fork - 2023 - Adult

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.kanati_fork_2023_adult

4.79 kB
21 rows
5 columns

CREATE TABLE kanati_fork_2023_adult (
  "kanati_fork_2023_adult_site1_1" BIGINT  -- Kanati Fork - 2023 - 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 - 2023 - Total

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.kanati_fork_2023_total

4.86 kB
31 rows
5 columns

CREATE TABLE kanati_fork_2023_total (
  "kanati_fork_2023_total_site1_1" BIGINT  -- Kanati Fork - 2023 - 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 - 2023 - YOY

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.kanati_fork_2023_yoy

4.64 kB
10 rows
5 columns

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

Le Conte Creek - 2023 - Adult

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.le_conte_creek_2023_adult

6.21 kB
171 rows
5 columns

CREATE TABLE le_conte_creek_2023_adult (
  "le_conte_creek_2023_adult_site1_0_site2_10_site3_24_site4_9" BIGINT  -- Le Conte Creek - 2023 - Adult - Site1=0 Site2=10 Site3=24 Site4=9,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Le Conte Creek - 2023 - Total

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.le_conte_creek_2023_total

8.14 kB
321 rows
7 columns

CREATE TABLE le_conte_creek_2023_total (
  "le_conte_creek_2023_total_site1_0_site2_10_site3_24_site4_9" BIGINT  -- Le Conte Creek - 2023 - Total - Site1=0 Site2=10 Site3=24 Site4=9,
  "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
);

Le Conte Creek - 2023 - YOY

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.le_conte_creek_2023_yoy

5.41 kB
138 rows
5 columns

CREATE TABLE le_conte_creek_2023_yoy (
  "le_conte_creek_2023_yoy_site1_0_site2_10_site3_24_site4_9" BIGINT  -- Le Conte Creek - 2023 - YOY - Site1=0 Site2=10 Site3=24 Site4=9,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

LF Anthony Creek - 2023 - Adult

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.lf_anthony_creek_2023_adult

4.71 kB
9 rows
5 columns

CREATE TABLE lf_anthony_creek_2023_adult (
  "lf_anthony_creek_2023_adult_site1_9" BIGINT  -- LF Anthony Creek - 2023 - Adult - Site1=9,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

LF Anthony Creek - 2023 - Total

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.lf_anthony_creek_2023_total

4.85 kB
25 rows
5 columns

CREATE TABLE lf_anthony_creek_2023_total (
  "lf_anthony_creek_2023_total_site1_9" BIGINT  -- LF Anthony Creek - 2023 - Total - Site1=9,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

LF Anthony Creek - 2023 - YOY

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.lf_anthony_creek_2023_yoy

4.74 kB
16 rows
5 columns

CREATE TABLE lf_anthony_creek_2023_yoy (
  "lf_anthony_creek_2023_yoy_site1_9" BIGINT  -- LF Anthony Creek - 2023 - YOY - Site1=9,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Mill Creek - 2023 - Adult

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.mill_creek_2023_adult

4.68 kB
12 rows
5 columns

CREATE TABLE mill_creek_2023_adult (
  "mill_creek_2023_adult_site1_2" BIGINT  -- Mill Creek - 2023 - 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 - 2023 - Total

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.mill_creek_2023_total

6.14 kB
40 rows
7 columns

CREATE TABLE mill_creek_2023_total (
  "mill_creek_2023_total_site1_2" BIGINT  -- Mill Creek - 2023 - 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 - 2023 - YOY

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.mill_creek_2023_yoy

4.66 kB
15 rows
5 columns

CREATE TABLE mill_creek_2023_yoy (
  "mill_creek_2023_yoy_site1_2" BIGINT  -- Mill Creek - 2023 - 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 - 2023 - Adult

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.moore_springs_branch_2023_adult

5.36 kB
58 rows
5 columns

CREATE TABLE moore_springs_branch_2023_adult (
  "moore_springs_branch_2023_total_site1_0_site2_3_site3_12" BIGINT  -- Moore Springs Branch - 2023 - Total - Site1=0 Site2=3 Site3=12,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Moore Springs Branch - 2023 - Total

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.moore_springs_branch_2023_total

7.16 kB
123 rows
7 columns

CREATE TABLE moore_springs_branch_2023_total (
  "moore_springs_branch_2023_total_site1_0_site2_3_site3_12" BIGINT  -- Moore Springs Branch - 2023 - Total - Site1=0 Site2=3 Site3=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 - 2023 - YOY

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.moore_springs_branch_2023_yoy

5.19 kB
56 rows
5 columns

CREATE TABLE moore_springs_branch_2023_yoy (
  "moore_springs_branch_2023_yoy_site1_0_site2_3_site3_12" BIGINT  -- Moore Springs Branch - 2023 - YOY - Site1=0 Site2=3 Site3=12,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Noland Creek - 2023 - Adult

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.noland_creek_2023_adult

4.9 kB
29 rows
5 columns

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

Noland Creek - 2023 - Total

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.noland_creek_2023_total

6.23 kB
42 rows
7 columns

CREATE TABLE noland_creek_2023_total (
  "noland_creek_2023_total_site1_3" BIGINT  -- Noland Creek - 2023 - Total - Site1=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
);

Noland Creek - 2023 - YOY

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.noland_creek_2023_yoy

4.66 kB
10 rows
5 columns

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

Onion Bed Branch - 2023 - Adult

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.onion_bed_branch_2023_adult

4.95 kB
38 rows
5 columns

CREATE TABLE onion_bed_branch_2023_adult (
  "onion_bed_branch_2023_adult_site1_1" BIGINT  -- Onion Bed 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
);

Onion Bed Branch - 2023 - Total

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.onion_bed_branch_2023_total

5.1 kB
58 rows
5 columns

CREATE TABLE onion_bed_branch_2023_total (
  "onion_bed_branch_2023_total_site1_1" BIGINT  -- Onion Bed 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
);