Table: FIPS_STATE_COUNTY_CODE_XREF
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:36822 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionTable 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
Data Attribute / Type | Description |
---|---|
STATE_ABRV
VARCHAR2 |
The postal abbreviation for the state where catch was purchased. Typically but not always the state where catch was landed. |
STATE_NAME
VARCHAR2 |
The name of the state where the catch was purchased. Typically but not always the state of landing. |
COUNTY_NAME
VARCHAR2 |
The name of the county where catch was purchased. Typically but not always the county of landing. |
STATE
VARCHAR2 |
The FIPS code for the state where catch was purchased. Typically but not always the state of landing. |
COUNTY
VARCHAR2 |
The FIPS code for the county where catch was purchased. Typically but not always the county of landing. |
NMFS_STATE
VARCHAR2 |
The NMFS code for the state catch was purchased. Typically but not always the state of landing. |
NMFS_COUNTY
VARCHAR2 |
THe NMFS code for the county where catch was purchased. Typically but not always the county of landing. |
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. |
COMMENTS
VARCHAR2 |
Comment on individual record |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (SEFSC) for inquiries on this record.
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
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
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
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
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
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
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
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
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
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
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 |