Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
98 lines (97 sloc) 2.33 KB
-- PCO10. GROUP QUARTERS POPULATION IN OTHER NONINSTITUTIONAL FACILITIES 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_pco10 (
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,
pco010001 INTEGER,
pco010001_2000 INTEGER,
pco010002 INTEGER,
pco010002_2000 INTEGER,
pco010003 INTEGER,
pco010003_2000 INTEGER,
pco010004 INTEGER,
pco010004_2000 INTEGER,
pco010005 INTEGER,
pco010005_2000 INTEGER,
pco010006 INTEGER,
pco010006_2000 INTEGER,
pco010007 INTEGER,
pco010007_2000 INTEGER,
pco010008 INTEGER,
pco010008_2000 INTEGER,
pco010009 INTEGER,
pco010009_2000 INTEGER,
pco010010 INTEGER,
pco010010_2000 INTEGER,
pco010011 INTEGER,
pco010011_2000 INTEGER,
pco010012 INTEGER,
pco010012_2000 INTEGER,
pco010013 INTEGER,
pco010013_2000 INTEGER,
pco010014 INTEGER,
pco010014_2000 INTEGER,
pco010015 INTEGER,
pco010015_2000 INTEGER,
pco010016 INTEGER,
pco010016_2000 INTEGER,
pco010017 INTEGER,
pco010017_2000 INTEGER,
pco010018 INTEGER,
pco010018_2000 INTEGER,
pco010019 INTEGER,
pco010019_2000 INTEGER,
pco010020 INTEGER,
pco010020_2000 INTEGER,
pco010021 INTEGER,
pco010021_2000 INTEGER,
pco010022 INTEGER,
pco010022_2000 INTEGER,
pco010023 INTEGER,
pco010023_2000 INTEGER,
pco010024 INTEGER,
pco010024_2000 INTEGER,
pco010025 INTEGER,
pco010025_2000 INTEGER,
pco010026 INTEGER,
pco010026_2000 INTEGER,
pco010027 INTEGER,
pco010027_2000 INTEGER,
pco010028 INTEGER,
pco010028_2000 INTEGER,
pco010029 INTEGER,
pco010029_2000 INTEGER,
pco010030 INTEGER,
pco010030_2000 INTEGER,
pco010031 INTEGER,
pco010031_2000 INTEGER,
pco010032 INTEGER,
pco010032_2000 INTEGER,
pco010033 INTEGER,
pco010033_2000 INTEGER,
pco010034 INTEGER,
pco010034_2000 INTEGER,
pco010035 INTEGER,
pco010035_2000 INTEGER,
pco010036 INTEGER,
pco010036_2000 INTEGER,
pco010037 INTEGER,
pco010037_2000 INTEGER,
pco010038 INTEGER,
pco010038_2000 INTEGER,
pco010039 INTEGER,
pco010039_2000 INTEGER,
PRIMARY KEY (geoid)
);