Skip to content
This repository
branch: master
Fetching contributors…

Cannot retrieve contributors at this time

file 53 lines (53 sloc) 1.237 kb
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53
-- H14. TENURE BY RACE OF HOUSEHOLDER
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_h14 (
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,
h014001 INTEGER,
h014001_2000 INTEGER,
h014002 INTEGER,
h014002_2000 INTEGER,
h014003 INTEGER,
h014003_2000 INTEGER,
h014004 INTEGER,
h014004_2000 INTEGER,
h014005 INTEGER,
h014005_2000 INTEGER,
h014006 INTEGER,
h014006_2000 INTEGER,
h014007 INTEGER,
h014007_2000 INTEGER,
h014008 INTEGER,
h014008_2000 INTEGER,
h014009 INTEGER,
h014009_2000 INTEGER,
h014010 INTEGER,
h014010_2000 INTEGER,
h014011 INTEGER,
h014011_2000 INTEGER,
h014012 INTEGER,
h014012_2000 INTEGER,
h014013 INTEGER,
h014013_2000 INTEGER,
h014014 INTEGER,
h014014_2000 INTEGER,
h014015 INTEGER,
h014015_2000 INTEGER,
h014016 INTEGER,
h014016_2000 INTEGER,
h014017 INTEGER,
h014017_2000 INTEGER,
PRIMARY KEY (geoid)
);
Something went wrong with that request. Please try again.