Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
98 lines (97 sloc) 2.33 KB
-- PCO3. GROUP QUARTERS POPULATION IN CORRECTIONAL FACILITIES FOR ADULTS 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_pco3 (
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,
pco003001 INTEGER,
pco003001_2000 INTEGER,
pco003002 INTEGER,
pco003002_2000 INTEGER,
pco003003 INTEGER,
pco003003_2000 INTEGER,
pco003004 INTEGER,
pco003004_2000 INTEGER,
pco003005 INTEGER,
pco003005_2000 INTEGER,
pco003006 INTEGER,
pco003006_2000 INTEGER,
pco003007 INTEGER,
pco003007_2000 INTEGER,
pco003008 INTEGER,
pco003008_2000 INTEGER,
pco003009 INTEGER,
pco003009_2000 INTEGER,
pco003010 INTEGER,
pco003010_2000 INTEGER,
pco003011 INTEGER,
pco003011_2000 INTEGER,
pco003012 INTEGER,
pco003012_2000 INTEGER,
pco003013 INTEGER,
pco003013_2000 INTEGER,
pco003014 INTEGER,
pco003014_2000 INTEGER,
pco003015 INTEGER,
pco003015_2000 INTEGER,
pco003016 INTEGER,
pco003016_2000 INTEGER,
pco003017 INTEGER,
pco003017_2000 INTEGER,
pco003018 INTEGER,
pco003018_2000 INTEGER,
pco003019 INTEGER,
pco003019_2000 INTEGER,
pco003020 INTEGER,
pco003020_2000 INTEGER,
pco003021 INTEGER,
pco003021_2000 INTEGER,
pco003022 INTEGER,
pco003022_2000 INTEGER,
pco003023 INTEGER,
pco003023_2000 INTEGER,
pco003024 INTEGER,
pco003024_2000 INTEGER,
pco003025 INTEGER,
pco003025_2000 INTEGER,
pco003026 INTEGER,
pco003026_2000 INTEGER,
pco003027 INTEGER,
pco003027_2000 INTEGER,
pco003028 INTEGER,
pco003028_2000 INTEGER,
pco003029 INTEGER,
pco003029_2000 INTEGER,
pco003030 INTEGER,
pco003030_2000 INTEGER,
pco003031 INTEGER,
pco003031_2000 INTEGER,
pco003032 INTEGER,
pco003032_2000 INTEGER,
pco003033 INTEGER,
pco003033_2000 INTEGER,
pco003034 INTEGER,
pco003034_2000 INTEGER,
pco003035 INTEGER,
pco003035_2000 INTEGER,
pco003036 INTEGER,
pco003036_2000 INTEGER,
pco003037 INTEGER,
pco003037_2000 INTEGER,
pco003038 INTEGER,
pco003038_2000 INTEGER,
pco003039 INTEGER,
pco003039_2000 INTEGER,
PRIMARY KEY (geoid)
);