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

60 lines (59 sloc) 1.462 kb
-- P39G. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN (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_p39g (
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,
p039g001 INTEGER,
p039g001_2000 INTEGER,
p039g002 INTEGER,
p039g002_2000 INTEGER,
p039g003 INTEGER,
p039g003_2000 INTEGER,
p039g004 INTEGER,
p039g004_2000 INTEGER,
p039g005 INTEGER,
p039g005_2000 INTEGER,
p039g006 INTEGER,
p039g006_2000 INTEGER,
p039g007 INTEGER,
p039g007_2000 INTEGER,
p039g008 INTEGER,
p039g008_2000 INTEGER,
p039g009 INTEGER,
p039g009_2000 INTEGER,
p039g010 INTEGER,
p039g010_2000 INTEGER,
p039g011 INTEGER,
p039g011_2000 INTEGER,
p039g012 INTEGER,
p039g012_2000 INTEGER,
p039g013 INTEGER,
p039g013_2000 INTEGER,
p039g014 INTEGER,
p039g014_2000 INTEGER,
p039g015 INTEGER,
p039g015_2000 INTEGER,
p039g016 INTEGER,
p039g016_2000 INTEGER,
p039g017 INTEGER,
p039g017_2000 INTEGER,
p039g018 INTEGER,
p039g018_2000 INTEGER,
p039g019 INTEGER,
p039g019_2000 INTEGER,
p039g020 INTEGER,
p039g020_2000 INTEGER,
PRIMARY KEY (geoid)
);
Jump to Line
Something went wrong with that request. Please try again.