ACSSF.Summary_File_0001

This table contains the raw US Census Bureau's American Community Survey data from summary file 0001.

Column NameData TypeDescription
FILEIDchar(6) not nullFile Identification 6 Characters
FILETYPEchar(6) not nullFile Type 6 Characters
STUSABchar(2) not nullState/U.S.-Abbreviation (USPS) 2 Characters
CHARITERchar(3) not nullCharacter Iteration 3 Characters
SEQUENCEchar(4) not nullSequence Number 4 Characters
LOGRECNOchar(7) not nullLogical Record Number 7 Characters
Unweighted_Sample_Count_Of_The_Populationint nullPopulation Count
Unweighted_Sample_Housing_Unitsint nullHousing Unit Count



Constraints:
Constraint ACSSF__Summary_File_0001_PK Primary Key (
FILEID
,FILETYPE
,STUSAB
,CHARITER
,SEQUENCE
,LOGRECNO
)