Find file
Fetching contributors…
Cannot retrieve contributors at this time
64 lines (63 sloc) 1.51 KB
-- P34D. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (ASIAN ALONE)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p34d (
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,
p034d001 INTEGER,
p034d001_2000 INTEGER,
p034d002 INTEGER,
p034d002_2000 INTEGER,
p034d003 INTEGER,
p034d003_2000 INTEGER,
p034d004 INTEGER,
p034d004_2000 INTEGER,
p034d005 INTEGER,
p034d005_2000 INTEGER,
p034d006 INTEGER,
p034d006_2000 INTEGER,
p034d007 INTEGER,
p034d007_2000 INTEGER,
p034d008 INTEGER,
p034d008_2000 INTEGER,
p034d009 INTEGER,
p034d009_2000 INTEGER,
p034d010 INTEGER,
p034d010_2000 INTEGER,
p034d011 INTEGER,
p034d011_2000 INTEGER,
p034d012 INTEGER,
p034d012_2000 INTEGER,
p034d013 INTEGER,
p034d013_2000 INTEGER,
p034d014 INTEGER,
p034d014_2000 INTEGER,
p034d015 INTEGER,
p034d015_2000 INTEGER,
p034d016 INTEGER,
p034d016_2000 INTEGER,
p034d017 INTEGER,
p034d017_2000 INTEGER,
p034d018 INTEGER,
p034d018_2000 INTEGER,
p034d019 INTEGER,
p034d019_2000 INTEGER,
p034d020 INTEGER,
p034d020_2000 INTEGER,
p034d021 INTEGER,
p034d021_2000 INTEGER,
p034d022 INTEGER,
p034d022_2000 INTEGER,
PRIMARY KEY (geoid)
);