Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
62 lines (61 sloc) 1.45 KB
-- H17F. TENURE BY AGE OF HOUSEHOLDER (SOME OTHER RACE ALONE HOUSEHOLDER)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_h17f (
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,
h017f001 INTEGER,
h017f001_2000 INTEGER,
h017f002 INTEGER,
h017f002_2000 INTEGER,
h017f003 INTEGER,
h017f003_2000 INTEGER,
h017f004 INTEGER,
h017f004_2000 INTEGER,
h017f005 INTEGER,
h017f005_2000 INTEGER,
h017f006 INTEGER,
h017f006_2000 INTEGER,
h017f007 INTEGER,
h017f007_2000 INTEGER,
h017f008 INTEGER,
h017f008_2000 INTEGER,
h017f009 INTEGER,
h017f009_2000 INTEGER,
h017f010 INTEGER,
h017f010_2000 INTEGER,
h017f011 INTEGER,
h017f011_2000 INTEGER,
h017f012 INTEGER,
h017f012_2000 INTEGER,
h017f013 INTEGER,
h017f013_2000 INTEGER,
h017f014 INTEGER,
h017f014_2000 INTEGER,
h017f015 INTEGER,
h017f015_2000 INTEGER,
h017f016 INTEGER,
h017f016_2000 INTEGER,
h017f017 INTEGER,
h017f017_2000 INTEGER,
h017f018 INTEGER,
h017f018_2000 INTEGER,
h017f019 INTEGER,
h017f019_2000 INTEGER,
h017f020 INTEGER,
h017f020_2000 INTEGER,
h017f021 INTEGER,
h017f021_2000 INTEGER,
PRIMARY KEY (geoid)
);