Skip to content
Find file
Fetching contributors…
Cannot retrieve contributors at this time
84 lines (83 sloc) 2.1 KB
-- PCT20E. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct20e (
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,
pct020e001 INTEGER,
pct020e001_2000 INTEGER,
pct020e002 INTEGER,
pct020e002_2000 INTEGER,
pct020e003 INTEGER,
pct020e003_2000 INTEGER,
pct020e004 INTEGER,
pct020e004_2000 INTEGER,
pct020e005 INTEGER,
pct020e005_2000 INTEGER,
pct020e006 INTEGER,
pct020e006_2000 INTEGER,
pct020e007 INTEGER,
pct020e007_2000 INTEGER,
pct020e008 INTEGER,
pct020e008_2000 INTEGER,
pct020e009 INTEGER,
pct020e009_2000 INTEGER,
pct020e010 INTEGER,
pct020e010_2000 INTEGER,
pct020e011 INTEGER,
pct020e011_2000 INTEGER,
pct020e012 INTEGER,
pct020e012_2000 INTEGER,
pct020e013 INTEGER,
pct020e013_2000 INTEGER,
pct020e014 INTEGER,
pct020e014_2000 INTEGER,
pct020e015 INTEGER,
pct020e015_2000 INTEGER,
pct020e016 INTEGER,
pct020e016_2000 INTEGER,
pct020e017 INTEGER,
pct020e017_2000 INTEGER,
pct020e018 INTEGER,
pct020e018_2000 INTEGER,
pct020e019 INTEGER,
pct020e019_2000 INTEGER,
pct020e020 INTEGER,
pct020e020_2000 INTEGER,
pct020e021 INTEGER,
pct020e021_2000 INTEGER,
pct020e022 INTEGER,
pct020e022_2000 INTEGER,
pct020e023 INTEGER,
pct020e023_2000 INTEGER,
pct020e024 INTEGER,
pct020e024_2000 INTEGER,
pct020e025 INTEGER,
pct020e025_2000 INTEGER,
pct020e026 INTEGER,
pct020e026_2000 INTEGER,
pct020e027 INTEGER,
pct020e027_2000 INTEGER,
pct020e028 INTEGER,
pct020e028_2000 INTEGER,
pct020e029 INTEGER,
pct020e029_2000 INTEGER,
pct020e030 INTEGER,
pct020e030_2000 INTEGER,
pct020e031 INTEGER,
pct020e031_2000 INTEGER,
pct020e032 INTEGER,
pct020e032_2000 INTEGER,
PRIMARY KEY (geoid)
);
Jump to Line
Something went wrong with that request. Please try again.