Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
98 lines (97 sloc) 2.33 KB
-- PCO7. GROUP QUARTERS POPULATION IN 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_pco7 (
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,
pco007001 INTEGER,
pco007001_2000 INTEGER,
pco007002 INTEGER,
pco007002_2000 INTEGER,
pco007003 INTEGER,
pco007003_2000 INTEGER,
pco007004 INTEGER,
pco007004_2000 INTEGER,
pco007005 INTEGER,
pco007005_2000 INTEGER,
pco007006 INTEGER,
pco007006_2000 INTEGER,
pco007007 INTEGER,
pco007007_2000 INTEGER,
pco007008 INTEGER,
pco007008_2000 INTEGER,
pco007009 INTEGER,
pco007009_2000 INTEGER,
pco007010 INTEGER,
pco007010_2000 INTEGER,
pco007011 INTEGER,
pco007011_2000 INTEGER,
pco007012 INTEGER,
pco007012_2000 INTEGER,
pco007013 INTEGER,
pco007013_2000 INTEGER,
pco007014 INTEGER,
pco007014_2000 INTEGER,
pco007015 INTEGER,
pco007015_2000 INTEGER,
pco007016 INTEGER,
pco007016_2000 INTEGER,
pco007017 INTEGER,
pco007017_2000 INTEGER,
pco007018 INTEGER,
pco007018_2000 INTEGER,
pco007019 INTEGER,
pco007019_2000 INTEGER,
pco007020 INTEGER,
pco007020_2000 INTEGER,
pco007021 INTEGER,
pco007021_2000 INTEGER,
pco007022 INTEGER,
pco007022_2000 INTEGER,
pco007023 INTEGER,
pco007023_2000 INTEGER,
pco007024 INTEGER,
pco007024_2000 INTEGER,
pco007025 INTEGER,
pco007025_2000 INTEGER,
pco007026 INTEGER,
pco007026_2000 INTEGER,
pco007027 INTEGER,
pco007027_2000 INTEGER,
pco007028 INTEGER,
pco007028_2000 INTEGER,
pco007029 INTEGER,
pco007029_2000 INTEGER,
pco007030 INTEGER,
pco007030_2000 INTEGER,
pco007031 INTEGER,
pco007031_2000 INTEGER,
pco007032 INTEGER,
pco007032_2000 INTEGER,
pco007033 INTEGER,
pco007033_2000 INTEGER,
pco007034 INTEGER,
pco007034_2000 INTEGER,
pco007035 INTEGER,
pco007035_2000 INTEGER,
pco007036 INTEGER,
pco007036_2000 INTEGER,
pco007037 INTEGER,
pco007037_2000 INTEGER,
pco007038 INTEGER,
pco007038_2000 INTEGER,
pco007039 INTEGER,
pco007039_2000 INTEGER,
PRIMARY KEY (geoid)
);