Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
52 lines (51 sloc) 1.23 KB
-- P28A. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (WHITE ALONE HOUSEHOLDER)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p28a (
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,
p028a001 INTEGER,
p028a001_2000 INTEGER,
p028a002 INTEGER,
p028a002_2000 INTEGER,
p028a003 INTEGER,
p028a003_2000 INTEGER,
p028a004 INTEGER,
p028a004_2000 INTEGER,
p028a005 INTEGER,
p028a005_2000 INTEGER,
p028a006 INTEGER,
p028a006_2000 INTEGER,
p028a007 INTEGER,
p028a007_2000 INTEGER,
p028a008 INTEGER,
p028a008_2000 INTEGER,
p028a009 INTEGER,
p028a009_2000 INTEGER,
p028a010 INTEGER,
p028a010_2000 INTEGER,
p028a011 INTEGER,
p028a011_2000 INTEGER,
p028a012 INTEGER,
p028a012_2000 INTEGER,
p028a013 INTEGER,
p028a013_2000 INTEGER,
p028a014 INTEGER,
p028a014_2000 INTEGER,
p028a015 INTEGER,
p028a015_2000 INTEGER,
p028a016 INTEGER,
p028a016_2000 INTEGER,
PRIMARY KEY (geoid)
);