Skip to content
Find file
Fetching contributors…
Cannot retrieve contributors at this time
54 lines (53 sloc) 1.26 KB
-- H16A. TENURE BY HOUSEHOLD SIZE (WHITE ALONE HOUSEHOLDER)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_h16a (
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,
h016a001 INTEGER,
h016a001_2000 INTEGER,
h016a002 INTEGER,
h016a002_2000 INTEGER,
h016a003 INTEGER,
h016a003_2000 INTEGER,
h016a004 INTEGER,
h016a004_2000 INTEGER,
h016a005 INTEGER,
h016a005_2000 INTEGER,
h016a006 INTEGER,
h016a006_2000 INTEGER,
h016a007 INTEGER,
h016a007_2000 INTEGER,
h016a008 INTEGER,
h016a008_2000 INTEGER,
h016a009 INTEGER,
h016a009_2000 INTEGER,
h016a010 INTEGER,
h016a010_2000 INTEGER,
h016a011 INTEGER,
h016a011_2000 INTEGER,
h016a012 INTEGER,
h016a012_2000 INTEGER,
h016a013 INTEGER,
h016a013_2000 INTEGER,
h016a014 INTEGER,
h016a014_2000 INTEGER,
h016a015 INTEGER,
h016a015_2000 INTEGER,
h016a016 INTEGER,
h016a016_2000 INTEGER,
h016a017 INTEGER,
h016a017_2000 INTEGER,
PRIMARY KEY (geoid)
);
Something went wrong with that request. Please try again.