Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
98 lines (97 sloc) 2.33 KB
-- PCO8. GROUP QUARTERS POPULATION IN COLLEGE/UNIVERSITY STUDENT HOUSING BY SEX BY AGE
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pco8 (
geoid VARCHAR(11) NOT NULL,
sumlev VARCHAR(3) NOT NULL,
state VARCHAR(2) NOT NULL,
county VARCHAR(3),
cbsa VARCHAR(5),
csa VARCHAR(3),
necta VARCHAR(5),
cnecta VARCHAR(3),
name VARCHAR(90) NOT NULL,
pop100 INTEGER NOT NULL,
hu100 INTEGER NOT NULL,
pop100_2000 INTEGER,
hu100_2000 INTEGER,
pco008001 INTEGER,
pco008001_2000 INTEGER,
pco008002 INTEGER,
pco008002_2000 INTEGER,
pco008003 INTEGER,
pco008003_2000 INTEGER,
pco008004 INTEGER,
pco008004_2000 INTEGER,
pco008005 INTEGER,
pco008005_2000 INTEGER,
pco008006 INTEGER,
pco008006_2000 INTEGER,
pco008007 INTEGER,
pco008007_2000 INTEGER,
pco008008 INTEGER,
pco008008_2000 INTEGER,
pco008009 INTEGER,
pco008009_2000 INTEGER,
pco008010 INTEGER,
pco008010_2000 INTEGER,
pco008011 INTEGER,
pco008011_2000 INTEGER,
pco008012 INTEGER,
pco008012_2000 INTEGER,
pco008013 INTEGER,
pco008013_2000 INTEGER,
pco008014 INTEGER,
pco008014_2000 INTEGER,
pco008015 INTEGER,
pco008015_2000 INTEGER,
pco008016 INTEGER,
pco008016_2000 INTEGER,
pco008017 INTEGER,
pco008017_2000 INTEGER,
pco008018 INTEGER,
pco008018_2000 INTEGER,
pco008019 INTEGER,
pco008019_2000 INTEGER,
pco008020 INTEGER,
pco008020_2000 INTEGER,
pco008021 INTEGER,
pco008021_2000 INTEGER,
pco008022 INTEGER,
pco008022_2000 INTEGER,
pco008023 INTEGER,
pco008023_2000 INTEGER,
pco008024 INTEGER,
pco008024_2000 INTEGER,
pco008025 INTEGER,
pco008025_2000 INTEGER,
pco008026 INTEGER,
pco008026_2000 INTEGER,
pco008027 INTEGER,
pco008027_2000 INTEGER,
pco008028 INTEGER,
pco008028_2000 INTEGER,
pco008029 INTEGER,
pco008029_2000 INTEGER,
pco008030 INTEGER,
pco008030_2000 INTEGER,
pco008031 INTEGER,
pco008031_2000 INTEGER,
pco008032 INTEGER,
pco008032_2000 INTEGER,
pco008033 INTEGER,
pco008033_2000 INTEGER,
pco008034 INTEGER,
pco008034_2000 INTEGER,
pco008035 INTEGER,
pco008035_2000 INTEGER,
pco008036 INTEGER,
pco008036_2000 INTEGER,
pco008037 INTEGER,
pco008037_2000 INTEGER,
pco008038 INTEGER,
pco008038_2000 INTEGER,
pco008039 INTEGER,
pco008039_2000 INTEGER,
PRIMARY KEY (geoid)
);