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.49 kB
-- P34. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p34 (
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,
p034001 INTEGER,
p034001_2000 INTEGER,
p034002 INTEGER,
p034002_2000 INTEGER,
p034003 INTEGER,
p034003_2000 INTEGER,
p034004 INTEGER,
p034004_2000 INTEGER,
p034005 INTEGER,
p034005_2000 INTEGER,
p034006 INTEGER,
p034006_2000 INTEGER,
p034007 INTEGER,
p034007_2000 INTEGER,
p034008 INTEGER,
p034008_2000 INTEGER,
p034009 INTEGER,
p034009_2000 INTEGER,
p034010 INTEGER,
p034010_2000 INTEGER,
p034011 INTEGER,
p034011_2000 INTEGER,
p034012 INTEGER,
p034012_2000 INTEGER,
p034013 INTEGER,
p034013_2000 INTEGER,
p034014 INTEGER,
p034014_2000 INTEGER,
p034015 INTEGER,
p034015_2000 INTEGER,
p034016 INTEGER,
p034016_2000 INTEGER,
p034017 INTEGER,
p034017_2000 INTEGER,
p034018 INTEGER,
p034018_2000 INTEGER,
p034019 INTEGER,
p034019_2000 INTEGER,
p034020 INTEGER,
p034020_2000 INTEGER,
p034021 INTEGER,
p034021_2000 INTEGER,
p034022 INTEGER,
p034022_2000 INTEGER,
PRIMARY KEY (geoid)
);
Jump to Line
Something went wrong with that request. Please try again.