Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
84 lines (83 sloc) 2.07 KB
-- PCT20G. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE (TWO OR MORE RACES)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct20g (
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,
pct020g001 INTEGER,
pct020g001_2000 INTEGER,
pct020g002 INTEGER,
pct020g002_2000 INTEGER,
pct020g003 INTEGER,
pct020g003_2000 INTEGER,
pct020g004 INTEGER,
pct020g004_2000 INTEGER,
pct020g005 INTEGER,
pct020g005_2000 INTEGER,
pct020g006 INTEGER,
pct020g006_2000 INTEGER,
pct020g007 INTEGER,
pct020g007_2000 INTEGER,
pct020g008 INTEGER,
pct020g008_2000 INTEGER,
pct020g009 INTEGER,
pct020g009_2000 INTEGER,
pct020g010 INTEGER,
pct020g010_2000 INTEGER,
pct020g011 INTEGER,
pct020g011_2000 INTEGER,
pct020g012 INTEGER,
pct020g012_2000 INTEGER,
pct020g013 INTEGER,
pct020g013_2000 INTEGER,
pct020g014 INTEGER,
pct020g014_2000 INTEGER,
pct020g015 INTEGER,
pct020g015_2000 INTEGER,
pct020g016 INTEGER,
pct020g016_2000 INTEGER,
pct020g017 INTEGER,
pct020g017_2000 INTEGER,
pct020g018 INTEGER,
pct020g018_2000 INTEGER,
pct020g019 INTEGER,
pct020g019_2000 INTEGER,
pct020g020 INTEGER,
pct020g020_2000 INTEGER,
pct020g021 INTEGER,
pct020g021_2000 INTEGER,
pct020g022 INTEGER,
pct020g022_2000 INTEGER,
pct020g023 INTEGER,
pct020g023_2000 INTEGER,
pct020g024 INTEGER,
pct020g024_2000 INTEGER,
pct020g025 INTEGER,
pct020g025_2000 INTEGER,
pct020g026 INTEGER,
pct020g026_2000 INTEGER,
pct020g027 INTEGER,
pct020g027_2000 INTEGER,
pct020g028 INTEGER,
pct020g028_2000 INTEGER,
pct020g029 INTEGER,
pct020g029_2000 INTEGER,
pct020g030 INTEGER,
pct020g030_2000 INTEGER,
pct020g031 INTEGER,
pct020g031_2000 INTEGER,
pct020g032 INTEGER,
pct020g032_2000 INTEGER,
PRIMARY KEY (geoid)
);