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

54 lines (53 sloc) 1.232 kB
-- H16. TENURE BY HOUSEHOLD SIZE
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_h16 (
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,
h016001 INTEGER,
h016001_2000 INTEGER,
h016002 INTEGER,
h016002_2000 INTEGER,
h016003 INTEGER,
h016003_2000 INTEGER,
h016004 INTEGER,
h016004_2000 INTEGER,
h016005 INTEGER,
h016005_2000 INTEGER,
h016006 INTEGER,
h016006_2000 INTEGER,
h016007 INTEGER,
h016007_2000 INTEGER,
h016008 INTEGER,
h016008_2000 INTEGER,
h016009 INTEGER,
h016009_2000 INTEGER,
h016010 INTEGER,
h016010_2000 INTEGER,
h016011 INTEGER,
h016011_2000 INTEGER,
h016012 INTEGER,
h016012_2000 INTEGER,
h016013 INTEGER,
h016013_2000 INTEGER,
h016014 INTEGER,
h016014_2000 INTEGER,
h016015 INTEGER,
h016015_2000 INTEGER,
h016016 INTEGER,
h016016_2000 INTEGER,
h016017 INTEGER,
h016017_2000 INTEGER,
PRIMARY KEY (geoid)
);
Jump to Line
Something went wrong with that request. Please try again.