Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
118 lines (117 sloc) 2.88 KB
-- PCT13F. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (SOME OTHER RACE ALONE)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct13f (
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,
pct013f001 INTEGER,
pct013f001_2000 INTEGER,
pct013f002 INTEGER,
pct013f002_2000 INTEGER,
pct013f003 INTEGER,
pct013f003_2000 INTEGER,
pct013f004 INTEGER,
pct013f004_2000 INTEGER,
pct013f005 INTEGER,
pct013f005_2000 INTEGER,
pct013f006 INTEGER,
pct013f006_2000 INTEGER,
pct013f007 INTEGER,
pct013f007_2000 INTEGER,
pct013f008 INTEGER,
pct013f008_2000 INTEGER,
pct013f009 INTEGER,
pct013f009_2000 INTEGER,
pct013f010 INTEGER,
pct013f010_2000 INTEGER,
pct013f011 INTEGER,
pct013f011_2000 INTEGER,
pct013f012 INTEGER,
pct013f012_2000 INTEGER,
pct013f013 INTEGER,
pct013f013_2000 INTEGER,
pct013f014 INTEGER,
pct013f014_2000 INTEGER,
pct013f015 INTEGER,
pct013f015_2000 INTEGER,
pct013f016 INTEGER,
pct013f016_2000 INTEGER,
pct013f017 INTEGER,
pct013f017_2000 INTEGER,
pct013f018 INTEGER,
pct013f018_2000 INTEGER,
pct013f019 INTEGER,
pct013f019_2000 INTEGER,
pct013f020 INTEGER,
pct013f020_2000 INTEGER,
pct013f021 INTEGER,
pct013f021_2000 INTEGER,
pct013f022 INTEGER,
pct013f022_2000 INTEGER,
pct013f023 INTEGER,
pct013f023_2000 INTEGER,
pct013f024 INTEGER,
pct013f024_2000 INTEGER,
pct013f025 INTEGER,
pct013f025_2000 INTEGER,
pct013f026 INTEGER,
pct013f026_2000 INTEGER,
pct013f027 INTEGER,
pct013f027_2000 INTEGER,
pct013f028 INTEGER,
pct013f028_2000 INTEGER,
pct013f029 INTEGER,
pct013f029_2000 INTEGER,
pct013f030 INTEGER,
pct013f030_2000 INTEGER,
pct013f031 INTEGER,
pct013f031_2000 INTEGER,
pct013f032 INTEGER,
pct013f032_2000 INTEGER,
pct013f033 INTEGER,
pct013f033_2000 INTEGER,
pct013f034 INTEGER,
pct013f034_2000 INTEGER,
pct013f035 INTEGER,
pct013f035_2000 INTEGER,
pct013f036 INTEGER,
pct013f036_2000 INTEGER,
pct013f037 INTEGER,
pct013f037_2000 INTEGER,
pct013f038 INTEGER,
pct013f038_2000 INTEGER,
pct013f039 INTEGER,
pct013f039_2000 INTEGER,
pct013f040 INTEGER,
pct013f040_2000 INTEGER,
pct013f041 INTEGER,
pct013f041_2000 INTEGER,
pct013f042 INTEGER,
pct013f042_2000 INTEGER,
pct013f043 INTEGER,
pct013f043_2000 INTEGER,
pct013f044 INTEGER,
pct013f044_2000 INTEGER,
pct013f045 INTEGER,
pct013f045_2000 INTEGER,
pct013f046 INTEGER,
pct013f046_2000 INTEGER,
pct013f047 INTEGER,
pct013f047_2000 INTEGER,
pct013f048 INTEGER,
pct013f048_2000 INTEGER,
pct013f049 INTEGER,
pct013f049_2000 INTEGER,
PRIMARY KEY (geoid)
);