About this Dataset

Characterization Of Human Uses And The Socioeconomic Dimensions, California North Coast MPA Baseline Study, 1992 To 2014

The primary goal of this project was to inform long-term marine protected area (MPA) monitoring efforts by gathering up-to-date socioeconomic information to illustrate historical trends, establish a post MPA baseline, and assess initial changes since MPA implementation for the commercial fishing fleet in the North Coast region of California. To accomplish this goal our research team conducted extensive community outreach and engagement in the region and conducted in-person interviewed CPFV operators to gather post MPA baseline socioeconomic data and spatial fishing data for the year 2013. Additional to the interview data gathered, we summarized CPFV logbook data from 1992 to 2014 obtained from the California Department of Fish and Wildlife (CDFW) to explore historical economic trends and initial changes in North Coast fisheries. This data package include the CPFV logbook data from 1992-20142 provided by California Department of Fish and Wildlife summarized to the port and region level; select summarized survey data from CPFV operator interviews about their operations in the 2013 calendar year, and samples of the spatial data available on the post MPA (2013) fishing grounds at region-fishery and port-fishery scales.
Organization: State of California
Last updated: 2021-09-08T16:17:45.053047
Tags: 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, baseline, biota, california, california-ocean-protection-council, commercial-fishing, consumptive-uses, ecological-data, environmental, fisheries, human-uses-data, maps, marine-protected-area, monitoring, mpa, north-coast, oceans, recreational-fishing, socioeconomic

Tables

California Fisheries Data Explorer - Gear Grouping

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.california_fisheries_data_explorer_gear_grouping

27.06 kB
4,512 rows
10 columns

CREATE TABLE california_fisheries_data_explorer_gear_grouping (
  "project_short_code" VARCHAR,
  "species_code" BIGINT,
  "species_name" VARCHAR,
  "commercial_species_group" VARCHAR,
  "gear_code" BIGINT,
  "gear_description" VARCHAR,
  "gear_group" VARCHAR,
  "commercial_data_viewer" VARCHAR,
  "cpfv_species_group" VARCHAR,
  "cpfv_data_viewer" VARCHAR
);

California Fisheries Data Explorer - Gear Grouping - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.california_fisheries_data_explorer_gear_grouping_metadata

15.71 kB
11 rows
20 columns

CREATE TABLE california_fisheries_data_explorer_gear_grouping_metadata (
  "table_name_ca_state_fishery_gear_groupings_table_csv" VARCHAR  -- Table Name: CA State Fishery Gear Groupings Table.csv,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19
);

California Fisheries Data Explorer - Port Grouping

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.california_fisheries_data_explorer_port_grouping

9.75 kB
102 rows
7 columns

CREATE TABLE california_fisheries_data_explorer_port_grouping (
  "project_short_code" VARCHAR,
  "port_name" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "port_group" VARCHAR,
  "california_region" VARCHAR,
  "port_code" BIGINT
);

California Fisheries Data Explorer - Port Grouping - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.california_fisheries_data_explorer_port_grouping_metadata

10.83 kB
11 rows
14 columns

CREATE TABLE california_fisheries_data_explorer_port_grouping_metadata (
  "n__name_ca_state_port_groupings_and_locations_lookup_table" VARCHAR  -- Table Name: CA State Port Groupings And Locations Lookup Table.csv,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13
);

California Fisheries Data Explorer - Species Lookup Table

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.california_fisheries_data_explorer_species_lookup_table

23.42 kB
398 rows
10 columns

CREATE TABLE california_fisheries_data_explorer_species_lookup_table (
  "project_short_code" VARCHAR,
  "market_code" BIGINT,
  "species_common_name" VARCHAR,
  "kingdom" VARCHAR,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR
);

California Fisheries Data Explorer - Species Lookup Table - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.california_fisheries_explorer_species_lookup_metadata

14.38 kB
11 rows
20 columns

CREATE TABLE california_fisheries_explorer_species_lookup_metadata (
  "table_name_ca_state_port_groupings_table_csv" VARCHAR  -- Table Name: CA State Port Groupings Table.csv,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19
);

Commercial Fishing - All Fisheries Summary - 1992 - 2014

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_all_fisheries_summary_1992_2014

5.22 kB
23 rows
5 columns

CREATE TABLE commercial_fishing_all_fisheries_summary_1992_2014 (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "count_of_fishermen" BIGINT,
  "ex_vessel_revenue" VARCHAR,
  "pounds" DOUBLE
);

Commercial Fishing - All Fisheries Summary - 1992 - 2014 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_all_fisheries_summary_1992_2014_metadata

8.24 kB
11 rows
10 columns

CREATE TABLE commercial_fishing_all_fisheries_summary_1992_2014_metadata (
  "table_name_nc_region_comm_summary_1992_2014_csv" VARCHAR  -- Table Name: NC Region Comm Summary 1992–2014.csv,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

Commercial Fishing - Fisheries Of Interest Port Summaries - 1992 - 2014

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_fisheries_of_interest_port_summarie_4409e351

24.28 kB
1,242 rows
10 columns

CREATE TABLE commercial_fishing_fisheries_of_interest_port_summarie_4409e351 (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "port_group" VARCHAR,
  "fishery" VARCHAR,
  "gear" VARCHAR,
  "condition" VARCHAR,
  "count_of_fishermen" VARCHAR,
  "pounds" VARCHAR,
  "ex_vessel_revenue" VARCHAR,
  "average_price_lbs" VARCHAR
);

Commercial Fishing - Fisheries Of Interest Port Summaries - 1992 - 2014 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_fisheries_of_interest_port_summarie_c02520fc

15.42 kB
11 rows
20 columns

CREATE TABLE commercial_fishing_fisheries_of_interest_port_summarie_c02520fc (
  "n__name_nc_port_comm_fisheriesofinterest_summary_1992_2014" VARCHAR  -- Table Name: NC Port Comm FisheriesofInterest Summary 1992–2014.csv,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19
);

Commercial Fishing - Fisheries Of Interest Regional Summary - 1992 - 2014 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_fisheries_of_interest_regional_summ_1a061e91

14.13 kB
11 rows
18 columns

CREATE TABLE commercial_fishing_fisheries_of_interest_regional_summ_1a061e91 (
  "n__name_nc_region_comm_fisheriesofinterest_summary_1992_2014" VARCHAR  -- Table Name: NC Region Comm FisheriesofInterest Summary 1992–2014.csv,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17
);

Commercial Fishing - Fisheries Of Interest Regional Summary - 1992 - 2014

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_fisheries_of_interest_regional_summ_5795dffe

13.09 kB
207 rows
9 columns

CREATE TABLE commercial_fishing_fisheries_of_interest_regional_summ_5795dffe (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "fishery" VARCHAR,
  "gear" VARCHAR,
  "condition" VARCHAR,
  "count_of_fishermen" VARCHAR,
  "pounds" VARCHAR,
  "ex_vessel_revenue" VARCHAR,
  "average_price_lbs" VARCHAR
);

Commercial Fishing - Spatial Change Maps - Pre And Post MPA - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_spatial_change_maps_pre_and_post_mp_e2e304fb

2.32 kB
3 rows
1 column

CREATE TABLE commercial_fishing_spatial_change_maps_pre_and_post_mp_e2e304fb (
  "file_name_nc_comm_maps_2013_pdf" VARCHAR  -- File Name: NC Comm Maps 2013.pdf
);

Commercial Fishing - Species Lookup Table

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_species_lookup_table

17.07 kB
398 rows
4 columns

CREATE TABLE commercial_fishing_species_lookup_table (
  "project_short_code" VARCHAR,
  "market_code" BIGINT,
  "species_common_name" VARCHAR,
  "name_scientific" VARCHAR
);

Commercial Fishing - Species Lookup Table - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_species_lookup_table_metadata

7.05 kB
11 rows
8 columns

CREATE TABLE commercial_fishing_species_lookup_table_metadata (
  "table_name_ca_state_port_groupings_table_csv" VARCHAR  -- Table Name: CA State Port Groupings Table.csv,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7
);

Commercial Fishing - Summarized Survey Data 2013

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_summarized_survey_data_2013

6.21 kB
80 rows
6 columns

CREATE TABLE commercial_fishing_summarized_survey_data_2013 (
  "project_short_code" VARCHAR,
  "q_number" BIGINT,
  "question" VARCHAR,
  "fishery" VARCHAR,
  "summarized_data" VARCHAR,
  "sample_size" VARCHAR
);

Commercial Fishing - Summarized Survey Data 2013 - Metatadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.commercial_fishing_summarized_survey_data_2013_metatadata

9.86 kB
11 rows
12 columns

CREATE TABLE commercial_fishing_summarized_survey_data_2013_metatadata (
  "table_name_nc_comm_fisheries_summarized_survey_data_2013_csv" VARCHAR  -- Table Name: NC Comm Fisheries Summarized Survey Data 2013.csv,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11
);

CPFV - Fishery Effort By Port 1992 - 2014

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_fishery_effort_by_port_1992_2014

11.02 kB
1,332 rows
7 columns

CREATE TABLE cpfv_fishery_effort_by_port_1992_2014 (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "port" VARCHAR,
  "target_fishery" VARCHAR,
  "number_of_vessels" VARCHAR,
  "number_of_trips" VARCHAR,
  "number_of_anglers" VARCHAR
);

CPFV - Fishery Effort By Port 1992 - 2014 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_fishery_effort_by_port_1992_2014_metadata

12.88 kB
31 rows
17 columns

CREATE TABLE cpfv_fishery_effort_by_port_1992_2014_metadata (
  "n__name_nc_cpfv_port_fishery_vessels_anglers_trips_1992_2014" VARCHAR  -- Table Name: NC CPFV Port Fishery Vessels Anglers Trips 1992–2014.csv,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16
);

CPFV - Fishery Effort By Region 1992 - 2014

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_fishery_effort_by_region_1992_2014

7.23 kB
276 rows
6 columns

CREATE TABLE cpfv_fishery_effort_by_region_1992_2014 (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "target_fishery" VARCHAR,
  "number_of_vessels" BIGINT,
  "number_of_anglers" BIGINT,
  "number_of_trips" BIGINT
);

CPFV - Fishery Effort By Region 1992 - 2014 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_fishery_effort_by_region_1992_2014_metadata

11.63 kB
31 rows
15 columns

CREATE TABLE cpfv_fishery_effort_by_region_1992_2014_metadata (
  "n__name_nc_cpfv_region_fishery_vessels_anglers_trips_1992_2014" VARCHAR  -- Table Name: NC CPFV Region Fishery Vessels Anglers Trips 1992–2014.csv,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14
);

CPFV Logbook Records - Effort By Port 1995 - 2014

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_logbook_records_effort_by_port_1995_2014

29.76 kB
2,478 rows
7 columns

CREATE TABLE cpfv_logbook_records_effort_by_port_1995_2014 (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "port_group" VARCHAR,
  "target_fishery" VARCHAR,
  "number_of_vessels" VARCHAR,
  "number_of_anglers" VARCHAR,
  "number_of_trips" VARCHAR
);

CPFV Logbook Records - Effort By Port 1995 - 2014 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_logbook_records_effort_by_port_1995_2014_metadata

11.75 kB
31 rows
15 columns

CREATE TABLE cpfv_logbook_records_effort_by_port_1995_2014_metadata (
  "n__name_ca_state_cpfv_port_fishery_vessels_anglers_tri_d064e165" VARCHAR  -- Table Name: CA State CPFV Port Fishery Vessels Anglers Trips 1995–2014.csv,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14
);

CPFV Logbook Records - Fish Caught By Port 1992 - 2014

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_logbook_records_fish_caught_by_port_1992_2014

34.78 kB
6,667 rows
5 columns

CREATE TABLE cpfv_logbook_records_fish_caught_by_port_1992_2014 (
  "project_short_code" VARCHAR,
  "year" BIGINT,
  "port_group" VARCHAR,
  "species" VARCHAR,
  "number_caught" VARCHAR
);

CPFV Logbook Records - Fish Caught By Port 1992 - 2014 - Metadata

@usgov.ca_gov_characterization_of_human_uses_and_the_socioeco_8964a828.cpfv_logbook_records_fish_caught_by_port_1992_2014_metadata

8.14 kB
11 rows
10 columns

CREATE TABLE cpfv_logbook_records_fish_caught_by_port_1992_2014_metadata (
  "table_name_ca_state_cpfv_port_fish_kept_1992_2014_csv" VARCHAR  -- Table Name: CA State CPFV Port Fish Kept 1992–2014.csv,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);