Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
50 lines (49 sloc) 1.16 KB
-- H9. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDERS BY TOTAL RACES TALLIED
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_h9 (
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,
h009001 INTEGER,
h009001_2000 INTEGER,
h009002 INTEGER,
h009002_2000 INTEGER,
h009003 INTEGER,
h009003_2000 INTEGER,
h009004 INTEGER,
h009004_2000 INTEGER,
h009005 INTEGER,
h009005_2000 INTEGER,
h009006 INTEGER,
h009006_2000 INTEGER,
h009007 INTEGER,
h009007_2000 INTEGER,
h009008 INTEGER,
h009008_2000 INTEGER,
h009009 INTEGER,
h009009_2000 INTEGER,
h009010 INTEGER,
h009010_2000 INTEGER,
h009011 INTEGER,
h009011_2000 INTEGER,
h009012 INTEGER,
h009012_2000 INTEGER,
h009013 INTEGER,
h009013_2000 INTEGER,
h009014 INTEGER,
h009014_2000 INTEGER,
h009015 INTEGER,
h009015_2000 INTEGER,
PRIMARY KEY (geoid)
);