Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
branch: master
Fetching contributors…

Cannot retrieve contributors at this time

62 lines (61 sloc) 1.619 kB
-- PCT22D. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER (ASIAN ALONE)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct22d (
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,
pct022d001 INTEGER,
pct022d001_2000 INTEGER,
pct022d002 INTEGER,
pct022d002_2000 INTEGER,
pct022d003 INTEGER,
pct022d003_2000 INTEGER,
pct022d004 INTEGER,
pct022d004_2000 INTEGER,
pct022d005 INTEGER,
pct022d005_2000 INTEGER,
pct022d006 INTEGER,
pct022d006_2000 INTEGER,
pct022d007 INTEGER,
pct022d007_2000 INTEGER,
pct022d008 INTEGER,
pct022d008_2000 INTEGER,
pct022d009 INTEGER,
pct022d009_2000 INTEGER,
pct022d010 INTEGER,
pct022d010_2000 INTEGER,
pct022d011 INTEGER,
pct022d011_2000 INTEGER,
pct022d012 INTEGER,
pct022d012_2000 INTEGER,
pct022d013 INTEGER,
pct022d013_2000 INTEGER,
pct022d014 INTEGER,
pct022d014_2000 INTEGER,
pct022d015 INTEGER,
pct022d015_2000 INTEGER,
pct022d016 INTEGER,
pct022d016_2000 INTEGER,
pct022d017 INTEGER,
pct022d017_2000 INTEGER,
pct022d018 INTEGER,
pct022d018_2000 INTEGER,
pct022d019 INTEGER,
pct022d019_2000 INTEGER,
pct022d020 INTEGER,
pct022d020_2000 INTEGER,
pct022d021 INTEGER,
pct022d021_2000 INTEGER,
PRIMARY KEY (geoid)
);
Jump to Line
Something went wrong with that request. Please try again.