Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
52 lines (51 sloc) 1.25 KB
-- P31H. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (HISPANIC OR LATINO)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p31h (
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,
p031h001 INTEGER,
p031h001_2000 INTEGER,
p031h002 INTEGER,
p031h002_2000 INTEGER,
p031h003 INTEGER,
p031h003_2000 INTEGER,
p031h004 INTEGER,
p031h004_2000 INTEGER,
p031h005 INTEGER,
p031h005_2000 INTEGER,
p031h006 INTEGER,
p031h006_2000 INTEGER,
p031h007 INTEGER,
p031h007_2000 INTEGER,
p031h008 INTEGER,
p031h008_2000 INTEGER,
p031h009 INTEGER,
p031h009_2000 INTEGER,
p031h010 INTEGER,
p031h010_2000 INTEGER,
p031h011 INTEGER,
p031h011_2000 INTEGER,
p031h012 INTEGER,
p031h012_2000 INTEGER,
p031h013 INTEGER,
p031h013_2000 INTEGER,
p031h014 INTEGER,
p031h014_2000 INTEGER,
p031h015 INTEGER,
p031h015_2000 INTEGER,
p031h016 INTEGER,
p031h016_2000 INTEGER,
PRIMARY KEY (geoid)
);