7331
Table: ZIP_CODE_DATA
ZIP_CODE_DATA
Entity
Published / External
7291
Standardization Of Dealers
Data Set
Completed
comprehensive zip code table, for cross referencing purpose
Loaded by batch 2163, 03-26-2008 16:04
Data Table
Yes
DMS
comprehensive zip code table, for cross referencing purpose
1
CDC
VARCHAR2
1
No
No
Active
Coded Value
VARCHAR2
2
ZIP_CODE
VARCHAR2
5
Yes
No
Active
five digit zip code
VARCHAR2
3
CITY_STATE_KEY
VARCHAR2
6
No
No
Active
Control key For City State Combination
VARCHAR2
4
ZIP_CLASS_CODE
VARCHAR2
1
No
No
Active
Zip Code Class Code
VARCHAR2
5
CITY_STATE_NAME
VARCHAR2
28
No
No
Active
city name
VARCHAR2
6
CITY_STATE_NAME_ABBREV
VARCHAR2
13
No
No
Active
abbreviated city state name
VARCHAR2
7
CTYST_NAME_FACILITY_CODE
VARCHAR2
1
No
No
Active
County State Name Facility Code
VARCHAR2
8
CTYST_MAILING_NAME_IND
VARCHAR2
1
No
No
Active
County State Mailing Name Indicator
VARCHAR2
9
PREFD_LAST_LINE_CTYST_KEY
VARCHAR2
6
No
No
Active
Preffered Last Line County State Key
VARCHAR2
10
PREFD_LAST_LINE_CTYST_NAM
VARCHAR2
28
No
No
Active
Preffered Last Line County State Name
VARCHAR2
11
CTYST_DELVVV_IND
VARCHAR2
1
No
No
Active
Control Column
VARCHAR2
12
CARR_RTE_RATE_SORT_IND
VARCHAR2
1
No
No
Active
Sorting Indicator
VARCHAR2
13
UNIQUE_ZIP_NAME_INC
VARCHAR2
1
No
No
Active
Control Column (often blank)
VARCHAR2
14
FINANCE_NO
VARCHAR2
6
No
No
Active
Finance Number
VARCHAR2
15
STATE_ABBREV
VARCHAR2
2
No
No
Active
state abbreviation
VARCHAR2
16
COUNTY_NO
VARCHAR2
3
No
No
Active
fips county code
VARCHAR2
17
COUNTY_NAME
VARCHAR2
25
No
No
Active
county name
VARCHAR2
18
LOAD_DATE
DATE
7
No
No
Active
FIN specific load date
DATE
gov.noaa.nmfs.inport:7331
Lee Weinberger
2008-03-26T16:04:14
SysAdmin InPortAdmin
2022-08-09T17:11:01
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