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
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 |