36822
Table: FIPS_STATE_COUNTY_CODE_XREF
FIPS_STATE_COUNTY_CODE_XREF
Entity
Published / External
6419
Accumulative Landings System Code Tables
Data Set
Completed
Table is a lookup for FIPS state and county codes and a cross-reference from the FIPS to the NMFS state and county codes (where codes exist for NMFS state and county). The NMFS state and county codes typically represent only the coastal or near coastal counties of the various states.
Data Table
Yes
SEFSC
Table is a lookup for FIPS state and county codes and a cross-reference from the FIPS to the NMFS state and county codes (where codes exist for NMFS state and county). The NMFS state and county codes typically represent only the coastal or near coastal counties of the various states.
1
STATE_ABRV
VARCHAR2
2
No
No
Active
The postal abbreviation for the state where catch was purchased. Typically but not always the state where catch was landed.
VARCHAR2
2
STATE_NAME
VARCHAR2
21
No
No
Active
The name of the state where the catch was purchased. Typically but not always the state of landing.
VARCHAR2
3
COUNTY_NAME
VARCHAR2
37
No
No
Active
The name of the county where catch was purchased. Typically but not always the county of landing.
VARCHAR2
4
STATE
VARCHAR2
2
Yes
No
Active
The FIPS code for the state where catch was purchased. Typically but not always the state of landing.
VARCHAR2
5
COUNTY
VARCHAR2
3
Yes
No
Active
The FIPS code for the county where catch was purchased. Typically but not always the county of landing.
VARCHAR2
6
NMFS_STATE
VARCHAR2
2
No
No
Active
The NMFS code for the state catch was purchased. Typically but not always the state of landing.
VARCHAR2
7
NMFS_COUNTY
VARCHAR2
3
No
No
Active
THe NMFS code for the county where catch was purchased. Typically but not always the county of landing.
VARCHAR2
8
REGION
VARCHAR2
1
No
No
Active
The region (Coast of Gulf of Mexico, SE US Atlantic Coast. Caribbean, US mid-atlantic coast, Chesapeake Bay waters, and US northern coast.
VARCHAR2
9
COMMENTS
VARCHAR2
300
No
No
Active
Comment on individual record
VARCHAR2
gov.noaa.nmfs.inport:36822
Joshua Bennett
2017-02-16T10:21:09
SysAdmin InPortAdmin
2022-08-09T17:11:02
2021-05-06
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-06
1 Year
2022-05-06