Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
52 lines (51 sloc) 1.23 KB
-- P28D. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (ASIAN ALONE HOUSEHOLDER)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p28d (
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,
p028d001 INTEGER,
p028d001_2000 INTEGER,
p028d002 INTEGER,
p028d002_2000 INTEGER,
p028d003 INTEGER,
p028d003_2000 INTEGER,
p028d004 INTEGER,
p028d004_2000 INTEGER,
p028d005 INTEGER,
p028d005_2000 INTEGER,
p028d006 INTEGER,
p028d006_2000 INTEGER,
p028d007 INTEGER,
p028d007_2000 INTEGER,
p028d008 INTEGER,
p028d008_2000 INTEGER,
p028d009 INTEGER,
p028d009_2000 INTEGER,
p028d010 INTEGER,
p028d010_2000 INTEGER,
p028d011 INTEGER,
p028d011_2000 INTEGER,
p028d012 INTEGER,
p028d012_2000 INTEGER,
p028d013 INTEGER,
p028d013_2000 INTEGER,
p028d014 INTEGER,
p028d014_2000 INTEGER,
p028d015 INTEGER,
p028d015_2000 INTEGER,
p028d016 INTEGER,
p028d016_2000 INTEGER,
PRIMARY KEY (geoid)
);