Skip to content
Find file
Fetching contributors…
Cannot retrieve contributors at this time
62 lines (61 sloc) 1.52 KB
-- PCT22. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct22 (
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,
pct022001 INTEGER,
pct022001_2000 INTEGER,
pct022002 INTEGER,
pct022002_2000 INTEGER,
pct022003 INTEGER,
pct022003_2000 INTEGER,
pct022004 INTEGER,
pct022004_2000 INTEGER,
pct022005 INTEGER,
pct022005_2000 INTEGER,
pct022006 INTEGER,
pct022006_2000 INTEGER,
pct022007 INTEGER,
pct022007_2000 INTEGER,
pct022008 INTEGER,
pct022008_2000 INTEGER,
pct022009 INTEGER,
pct022009_2000 INTEGER,
pct022010 INTEGER,
pct022010_2000 INTEGER,
pct022011 INTEGER,
pct022011_2000 INTEGER,
pct022012 INTEGER,
pct022012_2000 INTEGER,
pct022013 INTEGER,
pct022013_2000 INTEGER,
pct022014 INTEGER,
pct022014_2000 INTEGER,
pct022015 INTEGER,
pct022015_2000 INTEGER,
pct022016 INTEGER,
pct022016_2000 INTEGER,
pct022017 INTEGER,
pct022017_2000 INTEGER,
pct022018 INTEGER,
pct022018_2000 INTEGER,
pct022019 INTEGER,
pct022019_2000 INTEGER,
pct022020 INTEGER,
pct022020_2000 INTEGER,
pct022021 INTEGER,
pct022021_2000 INTEGER,
PRIMARY KEY (geoid)
);
Something went wrong with that request. Please try again.