Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
64 lines (63 sloc) 1.55 KB
-- P34E. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p34e (
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,
p034e001 INTEGER,
p034e001_2000 INTEGER,
p034e002 INTEGER,
p034e002_2000 INTEGER,
p034e003 INTEGER,
p034e003_2000 INTEGER,
p034e004 INTEGER,
p034e004_2000 INTEGER,
p034e005 INTEGER,
p034e005_2000 INTEGER,
p034e006 INTEGER,
p034e006_2000 INTEGER,
p034e007 INTEGER,
p034e007_2000 INTEGER,
p034e008 INTEGER,
p034e008_2000 INTEGER,
p034e009 INTEGER,
p034e009_2000 INTEGER,
p034e010 INTEGER,
p034e010_2000 INTEGER,
p034e011 INTEGER,
p034e011_2000 INTEGER,
p034e012 INTEGER,
p034e012_2000 INTEGER,
p034e013 INTEGER,
p034e013_2000 INTEGER,
p034e014 INTEGER,
p034e014_2000 INTEGER,
p034e015 INTEGER,
p034e015_2000 INTEGER,
p034e016 INTEGER,
p034e016_2000 INTEGER,
p034e017 INTEGER,
p034e017_2000 INTEGER,
p034e018 INTEGER,
p034e018_2000 INTEGER,
p034e019 INTEGER,
p034e019_2000 INTEGER,
p034e020 INTEGER,
p034e020_2000 INTEGER,
p034e021 INTEGER,
p034e021_2000 INTEGER,
p034e022 INTEGER,
p034e022_2000 INTEGER,
PRIMARY KEY (geoid)
);