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

76 lines (75 sloc) 1.783 kb
-- P29A. HOUSEHOLD TYPE BY RELATIONSHIP (WHITE ALONE)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p29a (
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,
p029a001 INTEGER,
p029a001_2000 INTEGER,
p029a002 INTEGER,
p029a002_2000 INTEGER,
p029a003 INTEGER,
p029a003_2000 INTEGER,
p029a004 INTEGER,
p029a004_2000 INTEGER,
p029a005 INTEGER,
p029a005_2000 INTEGER,
p029a006 INTEGER,
p029a006_2000 INTEGER,
p029a007 INTEGER,
p029a007_2000 INTEGER,
p029a008 INTEGER,
p029a008_2000 INTEGER,
p029a009 INTEGER,
p029a009_2000 INTEGER,
p029a010 INTEGER,
p029a010_2000 INTEGER,
p029a011 INTEGER,
p029a011_2000 INTEGER,
p029a012 INTEGER,
p029a012_2000 INTEGER,
p029a013 INTEGER,
p029a013_2000 INTEGER,
p029a014 INTEGER,
p029a014_2000 INTEGER,
p029a015 INTEGER,
p029a015_2000 INTEGER,
p029a016 INTEGER,
p029a016_2000 INTEGER,
p029a017 INTEGER,
p029a017_2000 INTEGER,
p029a018 INTEGER,
p029a018_2000 INTEGER,
p029a019 INTEGER,
p029a019_2000 INTEGER,
p029a020 INTEGER,
p029a020_2000 INTEGER,
p029a021 INTEGER,
p029a021_2000 INTEGER,
p029a022 INTEGER,
p029a022_2000 INTEGER,
p029a023 INTEGER,
p029a023_2000 INTEGER,
p029a024 INTEGER,
p029a024_2000 INTEGER,
p029a025 INTEGER,
p029a025_2000 INTEGER,
p029a026 INTEGER,
p029a026_2000 INTEGER,
p029a027 INTEGER,
p029a027_2000 INTEGER,
p029a028 INTEGER,
p029a028_2000 INTEGER,
PRIMARY KEY (geoid)
);
Jump to Line
Something went wrong with that request. Please try again.