Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
branch: master
Fetching contributors…

Cannot retrieve contributors at this time

52 lines (51 sloc) 1.263 kb
-- P28G. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (TWO OR MORE RACES HOUSEHOLDER)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p28g (
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,
p028g001 INTEGER,
p028g001_2000 INTEGER,
p028g002 INTEGER,
p028g002_2000 INTEGER,
p028g003 INTEGER,
p028g003_2000 INTEGER,
p028g004 INTEGER,
p028g004_2000 INTEGER,
p028g005 INTEGER,
p028g005_2000 INTEGER,
p028g006 INTEGER,
p028g006_2000 INTEGER,
p028g007 INTEGER,
p028g007_2000 INTEGER,
p028g008 INTEGER,
p028g008_2000 INTEGER,
p028g009 INTEGER,
p028g009_2000 INTEGER,
p028g010 INTEGER,
p028g010_2000 INTEGER,
p028g011 INTEGER,
p028g011_2000 INTEGER,
p028g012 INTEGER,
p028g012_2000 INTEGER,
p028g013 INTEGER,
p028g013_2000 INTEGER,
p028g014 INTEGER,
p028g014_2000 INTEGER,
p028g015 INTEGER,
p028g015_2000 INTEGER,
p028g016 INTEGER,
p028g016_2000 INTEGER,
PRIMARY KEY (geoid)
);
Jump to Line
Something went wrong with that request. Please try again.