Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: FIPS_STATE_COUNTY_CODE_XREF
Short Name: FIPS_STATE_COUNTY_CODE_XREF
Status: Completed
Abstract:

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.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: SEFSC
Description:

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 Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
STATE_ABRV VARCHAR2 The postal abbreviation for the state where catch was purchased. Typically but not always the state where catch was landed.
100
STATE_NAME VARCHAR2 The name of the state where the catch was purchased. Typically but not always the state of landing.
100
COUNTY_NAME VARCHAR2 The name of the county where catch was purchased. Typically but not always the county of landing.
100
STATE VARCHAR2 The FIPS code for the state where catch was purchased. Typically but not always the state of landing.
100
COUNTY VARCHAR2 The FIPS code for the county where catch was purchased. Typically but not always the county of landing.
100
NMFS_STATE VARCHAR2 The NMFS code for the state catch was purchased. Typically but not always the state of landing.
100
NMFS_COUNTY VARCHAR2 THe NMFS code for the county where catch was purchased. Typically but not always the county of landing.
100
REGION VARCHAR2 The region (Coast of Gulf of Mexico, SE US Atlantic Coast. Caribbean, US mid-atlantic coast, Chesapeake Bay waters, and US northern coast.
100
COMMENTS VARCHAR2 Comment on individual record

Attribute Details

STATE_ABRV

CC ID: 381583
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

The postal abbreviation for the state where catch was purchased. Typically but not always the state where catch was landed.

General Data Type: VARCHAR2

STATE_NAME

CC ID: 381584
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 21
Required: No
Primary Key: No
Status: Active
Description:

The name of the state where the catch was purchased. Typically but not always the state of landing.

General Data Type: VARCHAR2

COUNTY_NAME

CC ID: 381585
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 37
Required: No
Primary Key: No
Status: Active
Description:

The name of the county where catch was purchased. Typically but not always the county of landing.

General Data Type: VARCHAR2

STATE

CC ID: 381586
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: No
Status: Active
Description:

The FIPS code for the state where catch was purchased. Typically but not always the state of landing.

General Data Type: VARCHAR2

COUNTY

CC ID: 381587
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 3
Required: Yes
Primary Key: No
Status: Active
Description:

The FIPS code for the county where catch was purchased. Typically but not always the county of landing.

General Data Type: VARCHAR2

NMFS_STATE

CC ID: 381588
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

The NMFS code for the state catch was purchased. Typically but not always the state of landing.

General Data Type: VARCHAR2

NMFS_COUNTY

CC ID: 381589
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

THe NMFS code for the county where catch was purchased. Typically but not always the county of landing.

General Data Type: VARCHAR2

REGION

CC ID: 381590
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

The region (Coast of Gulf of Mexico, SE US Atlantic Coast. Caribbean, US mid-atlantic coast, Chesapeake Bay waters, and US northern coast.

General Data Type: VARCHAR2

COMMENTS

CC ID: 381591
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 300
Required: No
Primary Key: No
Status: Active
Description:

Comment on individual record

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 36822
GUID: gov.noaa.nmfs.inport:36822
Metadata Record Created By: Joshua Bennett
Metadata Record Created: 2017-02-16 10:21+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-06