Skip to content
Find file
Fetching contributors…
Cannot retrieve contributors at this time
54 lines (53 sloc) 1.24 KB
-- H7. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER 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_h7 (
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,
h007001 INTEGER,
h007001_2000 INTEGER,
h007002 INTEGER,
h007002_2000 INTEGER,
h007003 INTEGER,
h007003_2000 INTEGER,
h007004 INTEGER,
h007004_2000 INTEGER,
h007005 INTEGER,
h007005_2000 INTEGER,
h007006 INTEGER,
h007006_2000 INTEGER,
h007007 INTEGER,
h007007_2000 INTEGER,
h007008 INTEGER,
h007008_2000 INTEGER,
h007009 INTEGER,
h007009_2000 INTEGER,
h007010 INTEGER,
h007010_2000 INTEGER,
h007011 INTEGER,
h007011_2000 INTEGER,
h007012 INTEGER,
h007012_2000 INTEGER,
h007013 INTEGER,
h007013_2000 INTEGER,
h007014 INTEGER,
h007014_2000 INTEGER,
h007015 INTEGER,
h007015_2000 INTEGER,
h007016 INTEGER,
h007016_2000 INTEGER,
h007017 INTEGER,
h007017_2000 INTEGER,
PRIMARY KEY (geoid)
);
Jump to Line
Something went wrong with that request. Please try again.