Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
64 lines (63 sloc) 1.52 KB
-- P34H. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (HISPANIC OR LATINO)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p34h (
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,
p034h001 INTEGER,
p034h001_2000 INTEGER,
p034h002 INTEGER,
p034h002_2000 INTEGER,
p034h003 INTEGER,
p034h003_2000 INTEGER,
p034h004 INTEGER,
p034h004_2000 INTEGER,
p034h005 INTEGER,
p034h005_2000 INTEGER,
p034h006 INTEGER,
p034h006_2000 INTEGER,
p034h007 INTEGER,
p034h007_2000 INTEGER,
p034h008 INTEGER,
p034h008_2000 INTEGER,
p034h009 INTEGER,
p034h009_2000 INTEGER,
p034h010 INTEGER,
p034h010_2000 INTEGER,
p034h011 INTEGER,
p034h011_2000 INTEGER,
p034h012 INTEGER,
p034h012_2000 INTEGER,
p034h013 INTEGER,
p034h013_2000 INTEGER,
p034h014 INTEGER,
p034h014_2000 INTEGER,
p034h015 INTEGER,
p034h015_2000 INTEGER,
p034h016 INTEGER,
p034h016_2000 INTEGER,
p034h017 INTEGER,
p034h017_2000 INTEGER,
p034h018 INTEGER,
p034h018_2000 INTEGER,
p034h019 INTEGER,
p034h019_2000 INTEGER,
p034h020 INTEGER,
p034h020_2000 INTEGER,
p034h021 INTEGER,
p034h021_2000 INTEGER,
p034h022 INTEGER,
p034h022_2000 INTEGER,
PRIMARY KEY (geoid)
);