Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
branch: pl
Fetching contributors…

Cannot retrieve contributors at this time

52 lines (51 sloc) 1.302 kb
-- P31I. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (WHITE ALONE, NOT HISPANIC OR LATINO)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p31i (
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,
p031i001 INTEGER,
p031i001_2000 INTEGER,
p031i002 INTEGER,
p031i002_2000 INTEGER,
p031i003 INTEGER,
p031i003_2000 INTEGER,
p031i004 INTEGER,
p031i004_2000 INTEGER,
p031i005 INTEGER,
p031i005_2000 INTEGER,
p031i006 INTEGER,
p031i006_2000 INTEGER,
p031i007 INTEGER,
p031i007_2000 INTEGER,
p031i008 INTEGER,
p031i008_2000 INTEGER,
p031i009 INTEGER,
p031i009_2000 INTEGER,
p031i010 INTEGER,
p031i010_2000 INTEGER,
p031i011 INTEGER,
p031i011_2000 INTEGER,
p031i012 INTEGER,
p031i012_2000 INTEGER,
p031i013 INTEGER,
p031i013_2000 INTEGER,
p031i014 INTEGER,
p031i014_2000 INTEGER,
p031i015 INTEGER,
p031i015_2000 INTEGER,
p031i016 INTEGER,
p031i016_2000 INTEGER,
PRIMARY KEY (geoid)
);
Jump to Line
Something went wrong with that request. Please try again.