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.283 kb
-- P31G. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (TWO OR MORE RACES)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p31g (
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,
p031g001 INTEGER,
p031g001_2000 INTEGER,
p031g002 INTEGER,
p031g002_2000 INTEGER,
p031g003 INTEGER,
p031g003_2000 INTEGER,
p031g004 INTEGER,
p031g004_2000 INTEGER,
p031g005 INTEGER,
p031g005_2000 INTEGER,
p031g006 INTEGER,
p031g006_2000 INTEGER,
p031g007 INTEGER,
p031g007_2000 INTEGER,
p031g008 INTEGER,
p031g008_2000 INTEGER,
p031g009 INTEGER,
p031g009_2000 INTEGER,
p031g010 INTEGER,
p031g010_2000 INTEGER,
p031g011 INTEGER,
p031g011_2000 INTEGER,
p031g012 INTEGER,
p031g012_2000 INTEGER,
p031g013 INTEGER,
p031g013_2000 INTEGER,
p031g014 INTEGER,
p031g014_2000 INTEGER,
p031g015 INTEGER,
p031g015_2000 INTEGER,
p031g016 INTEGER,
p031g016_2000 INTEGER,
PRIMARY KEY (geoid)
);
Jump to Line
Something went wrong with that request. Please try again.