ACSSF.Geography_File
This file represents different geographical areas at varying levels of detail. It ranges from the US as a whole, down to state, city, zip code, or other jurisdictions. All other ACSSF tables tie to this table to get their location attribution.

Column NameData TypeDescription
FILEIDchar(6) not nullFile Identification 6 Characters
STUSABchar(2) not nullState/U.S.-Abbreviation (USPS) 2 Characters
SUMLEVELchar(3) not nullSummary Level
COMPONENTchar(2) not nullGeographic Component
LOGRECNOchar(7) not nullLogical Record Number 7 Characters
USchar(1) nullUS
REGIONchar(1) nullCensus Region
DIVISIONchar(1) nullCensus Division
STATECEchar(2) nullState (Census Code)
STATEchar(2) nullState (FIPS Code)
COUNTYchar(3) nullCounty of current residence
COUSUBchar(5) nullCounty Subdivision (FIPS)
PLACEchar(5) nullPlace (FIPS Code)
TRACTchar(6) nullCensus Tract
BLKGRPchar(1) nullBlock Group
CONCITchar(5) nullConsolidated City
AIANHHchar(4) nullAmerican Indian Area/Alaska Native Area/ Hawaiian Home Land (Census)
AIANHHFPchar(5) nullAmerican Indian Area/Alaska Native Area/ Hawaiian Home Land (FIPS)
AIHHTLIchar(1) nullAmerican Indian Trust Land/ Hawaiian Home Land Indicator
AITSCEchar(3) nullAmerican Indian Tribal Subdivision (Census)
AITSchar(5) nullAmerican Indian Tribal Subdivision (FIPS)
ANRCchar(5) nullAlaska Native Regional Corporation (FIPS)
CBSAchar(5) nullMetropolitan and Micropolitan Statistical Area
CSAchar(3) nullCombined Statistical Area
METDIVchar(5) nullMetropolitan Statistical AreaMetropolitan Division
MACCchar(1) nullMetropolitan Area Central City 1 89
MEMIchar(1) nullMetropolitan/Micropolitan Indicator Flag
NECTAchar(5) nullNew England City and Town Area
CNECTAchar(3) nullNew England City and Town Combined Statistical Area
NECTADIVchar(5) nullNew England City and Town Area Division
UAchar(5) nullUrban Area 5 104 BLANK
CDCURRchar(2) nullCurrent Congressional District
SLDUchar(3) nullState Legislative District Upper
SLDLchar(3) nullState Legislative District Lower
BLANK_00char(6) nullBLANK
BLANK_01char(3) nullBLANK
ZCTA5char(5) null5-digit ZIP Code Tabulation Area
SUBMCDchar(5) nullSubminor Civil Division (FIPS)
SDELMchar(5) nullState-School District (Elementary)
SDSECchar(5) nullState-School District (Secondary)
SDUNIchar(5) nullState-School District (Unified)
URchar(1) nullUrban/Rural
PCIchar(1) nullPrincipal City Indicator
BLANK_02char(6) nullBLANK
BLANK_03char(5) nullBLANK
PUMA5char(5) nullPublic Use Microdata Area – 5% File
BLANK_04char(5) nullBLANK
GEOIDchar(40) nullGeographic Identifier
NAMEvarchar(1000) nullArea Name
BTTRchar(6)vnullTribal Tract
BTBGchar(1) nullTribal Block Group
BLANK_05char(44) nullBLANK


Constraints:
Constraint ACSSF__Geography_File_PK Primary Key (
FILEID
,STUSAB
,LOGRECNO
)