Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
64 lines (63 sloc) 1.52 KB
-- P34G. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (TWO OR MORE RACES)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p34g (
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,
p034g001 INTEGER,
p034g001_2000 INTEGER,
p034g002 INTEGER,
p034g002_2000 INTEGER,
p034g003 INTEGER,
p034g003_2000 INTEGER,
p034g004 INTEGER,
p034g004_2000 INTEGER,
p034g005 INTEGER,
p034g005_2000 INTEGER,
p034g006 INTEGER,
p034g006_2000 INTEGER,
p034g007 INTEGER,
p034g007_2000 INTEGER,
p034g008 INTEGER,
p034g008_2000 INTEGER,
p034g009 INTEGER,
p034g009_2000 INTEGER,
p034g010 INTEGER,
p034g010_2000 INTEGER,
p034g011 INTEGER,
p034g011_2000 INTEGER,
p034g012 INTEGER,
p034g012_2000 INTEGER,
p034g013 INTEGER,
p034g013_2000 INTEGER,
p034g014 INTEGER,
p034g014_2000 INTEGER,
p034g015 INTEGER,
p034g015_2000 INTEGER,
p034g016 INTEGER,
p034g016_2000 INTEGER,
p034g017 INTEGER,
p034g017_2000 INTEGER,
p034g018 INTEGER,
p034g018_2000 INTEGER,
p034g019 INTEGER,
p034g019_2000 INTEGER,
p034g020 INTEGER,
p034g020_2000 INTEGER,
p034g021 INTEGER,
p034g021_2000 INTEGER,
p034g022 INTEGER,
p034g022_2000 INTEGER,
PRIMARY KEY (geoid)
);