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

118 lines (117 sloc) 2.947 kB
-- PCT13G. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (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_pct13g (
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,
pct013g001 INTEGER,
pct013g001_2000 INTEGER,
pct013g002 INTEGER,
pct013g002_2000 INTEGER,
pct013g003 INTEGER,
pct013g003_2000 INTEGER,
pct013g004 INTEGER,
pct013g004_2000 INTEGER,
pct013g005 INTEGER,
pct013g005_2000 INTEGER,
pct013g006 INTEGER,
pct013g006_2000 INTEGER,
pct013g007 INTEGER,
pct013g007_2000 INTEGER,
pct013g008 INTEGER,
pct013g008_2000 INTEGER,
pct013g009 INTEGER,
pct013g009_2000 INTEGER,
pct013g010 INTEGER,
pct013g010_2000 INTEGER,
pct013g011 INTEGER,
pct013g011_2000 INTEGER,
pct013g012 INTEGER,
pct013g012_2000 INTEGER,
pct013g013 INTEGER,
pct013g013_2000 INTEGER,
pct013g014 INTEGER,
pct013g014_2000 INTEGER,
pct013g015 INTEGER,
pct013g015_2000 INTEGER,
pct013g016 INTEGER,
pct013g016_2000 INTEGER,
pct013g017 INTEGER,
pct013g017_2000 INTEGER,
pct013g018 INTEGER,
pct013g018_2000 INTEGER,
pct013g019 INTEGER,
pct013g019_2000 INTEGER,
pct013g020 INTEGER,
pct013g020_2000 INTEGER,
pct013g021 INTEGER,
pct013g021_2000 INTEGER,
pct013g022 INTEGER,
pct013g022_2000 INTEGER,
pct013g023 INTEGER,
pct013g023_2000 INTEGER,
pct013g024 INTEGER,
pct013g024_2000 INTEGER,
pct013g025 INTEGER,
pct013g025_2000 INTEGER,
pct013g026 INTEGER,
pct013g026_2000 INTEGER,
pct013g027 INTEGER,
pct013g027_2000 INTEGER,
pct013g028 INTEGER,
pct013g028_2000 INTEGER,
pct013g029 INTEGER,
pct013g029_2000 INTEGER,
pct013g030 INTEGER,
pct013g030_2000 INTEGER,
pct013g031 INTEGER,
pct013g031_2000 INTEGER,
pct013g032 INTEGER,
pct013g032_2000 INTEGER,
pct013g033 INTEGER,
pct013g033_2000 INTEGER,
pct013g034 INTEGER,
pct013g034_2000 INTEGER,
pct013g035 INTEGER,
pct013g035_2000 INTEGER,
pct013g036 INTEGER,
pct013g036_2000 INTEGER,
pct013g037 INTEGER,
pct013g037_2000 INTEGER,
pct013g038 INTEGER,
pct013g038_2000 INTEGER,
pct013g039 INTEGER,
pct013g039_2000 INTEGER,
pct013g040 INTEGER,
pct013g040_2000 INTEGER,
pct013g041 INTEGER,
pct013g041_2000 INTEGER,
pct013g042 INTEGER,
pct013g042_2000 INTEGER,
pct013g043 INTEGER,
pct013g043_2000 INTEGER,
pct013g044 INTEGER,
pct013g044_2000 INTEGER,
pct013g045 INTEGER,
pct013g045_2000 INTEGER,
pct013g046 INTEGER,
pct013g046_2000 INTEGER,
pct013g047 INTEGER,
pct013g047_2000 INTEGER,
pct013g048 INTEGER,
pct013g048_2000 INTEGER,
pct013g049 INTEGER,
pct013g049_2000 INTEGER,
PRIMARY KEY (geoid)
);
Jump to Line
Something went wrong with that request. Please try again.