Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
52 lines (51 sloc) 1.26 KB
-- P28E. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p28e (
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,
p028e001 INTEGER,
p028e001_2000 INTEGER,
p028e002 INTEGER,
p028e002_2000 INTEGER,
p028e003 INTEGER,
p028e003_2000 INTEGER,
p028e004 INTEGER,
p028e004_2000 INTEGER,
p028e005 INTEGER,
p028e005_2000 INTEGER,
p028e006 INTEGER,
p028e006_2000 INTEGER,
p028e007 INTEGER,
p028e007_2000 INTEGER,
p028e008 INTEGER,
p028e008_2000 INTEGER,
p028e009 INTEGER,
p028e009_2000 INTEGER,
p028e010 INTEGER,
p028e010_2000 INTEGER,
p028e011 INTEGER,
p028e011_2000 INTEGER,
p028e012 INTEGER,
p028e012_2000 INTEGER,
p028e013 INTEGER,
p028e013_2000 INTEGER,
p028e014 INTEGER,
p028e014_2000 INTEGER,
p028e015 INTEGER,
p028e015_2000 INTEGER,
p028e016 INTEGER,
p028e016_2000 INTEGER,
PRIMARY KEY (geoid)
);