Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Branch: master
Fetching contributors…

Cannot retrieve contributors at this time

64 lines (63 sloc) 1.574 kB
-- P34I. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (WHITE ALONE, NOT HISPANIC OR LATINO)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p34i (
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,
p034i001 INTEGER,
p034i001_2000 INTEGER,
p034i002 INTEGER,
p034i002_2000 INTEGER,
p034i003 INTEGER,
p034i003_2000 INTEGER,
p034i004 INTEGER,
p034i004_2000 INTEGER,
p034i005 INTEGER,
p034i005_2000 INTEGER,
p034i006 INTEGER,
p034i006_2000 INTEGER,
p034i007 INTEGER,
p034i007_2000 INTEGER,
p034i008 INTEGER,
p034i008_2000 INTEGER,
p034i009 INTEGER,
p034i009_2000 INTEGER,
p034i010 INTEGER,
p034i010_2000 INTEGER,
p034i011 INTEGER,
p034i011_2000 INTEGER,
p034i012 INTEGER,
p034i012_2000 INTEGER,
p034i013 INTEGER,
p034i013_2000 INTEGER,
p034i014 INTEGER,
p034i014_2000 INTEGER,
p034i015 INTEGER,
p034i015_2000 INTEGER,
p034i016 INTEGER,
p034i016_2000 INTEGER,
p034i017 INTEGER,
p034i017_2000 INTEGER,
p034i018 INTEGER,
p034i018_2000 INTEGER,
p034i019 INTEGER,
p034i019_2000 INTEGER,
p034i020 INTEGER,
p034i020_2000 INTEGER,
p034i021 INTEGER,
p034i021_2000 INTEGER,
p034i022 INTEGER,
p034i022_2000 INTEGER,
PRIMARY KEY (geoid)
);
Jump to Line
Something went wrong with that request. Please try again.