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

52 lines (51 sloc) 1.197 kB
-- P28. HOUSEHOLD TYPE BY HOUSEHOLD SIZE
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p28 (
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,
p028001 INTEGER,
p028001_2000 INTEGER,
p028002 INTEGER,
p028002_2000 INTEGER,
p028003 INTEGER,
p028003_2000 INTEGER,
p028004 INTEGER,
p028004_2000 INTEGER,
p028005 INTEGER,
p028005_2000 INTEGER,
p028006 INTEGER,
p028006_2000 INTEGER,
p028007 INTEGER,
p028007_2000 INTEGER,
p028008 INTEGER,
p028008_2000 INTEGER,
p028009 INTEGER,
p028009_2000 INTEGER,
p028010 INTEGER,
p028010_2000 INTEGER,
p028011 INTEGER,
p028011_2000 INTEGER,
p028012 INTEGER,
p028012_2000 INTEGER,
p028013 INTEGER,
p028013_2000 INTEGER,
p028014 INTEGER,
p028014_2000 INTEGER,
p028015 INTEGER,
p028015_2000 INTEGER,
p028016 INTEGER,
p028016_2000 INTEGER,
PRIMARY KEY (geoid)
);
Jump to Line
Something went wrong with that request. Please try again.