Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
62 lines (61 sloc) 1.44 KB
-- H17A. TENURE BY AGE OF HOUSEHOLDER (WHITE ALONE HOUSEHOLDER)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_h17a (
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,
h017a001 INTEGER,
h017a001_2000 INTEGER,
h017a002 INTEGER,
h017a002_2000 INTEGER,
h017a003 INTEGER,
h017a003_2000 INTEGER,
h017a004 INTEGER,
h017a004_2000 INTEGER,
h017a005 INTEGER,
h017a005_2000 INTEGER,
h017a006 INTEGER,
h017a006_2000 INTEGER,
h017a007 INTEGER,
h017a007_2000 INTEGER,
h017a008 INTEGER,
h017a008_2000 INTEGER,
h017a009 INTEGER,
h017a009_2000 INTEGER,
h017a010 INTEGER,
h017a010_2000 INTEGER,
h017a011 INTEGER,
h017a011_2000 INTEGER,
h017a012 INTEGER,
h017a012_2000 INTEGER,
h017a013 INTEGER,
h017a013_2000 INTEGER,
h017a014 INTEGER,
h017a014_2000 INTEGER,
h017a015 INTEGER,
h017a015_2000 INTEGER,
h017a016 INTEGER,
h017a016_2000 INTEGER,
h017a017 INTEGER,
h017a017_2000 INTEGER,
h017a018 INTEGER,
h017a018_2000 INTEGER,
h017a019 INTEGER,
h017a019_2000 INTEGER,
h017a020 INTEGER,
h017a020_2000 INTEGER,
h017a021 INTEGER,
h017a021_2000 INTEGER,
PRIMARY KEY (geoid)
);