Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
38 lines (37 sloc) 944 Bytes
-- P18B. HOUSEHOLD TYPE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p18b (
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,
p018b001 INTEGER,
p018b001_2000 INTEGER,
p018b002 INTEGER,
p018b002_2000 INTEGER,
p018b003 INTEGER,
p018b003_2000 INTEGER,
p018b004 INTEGER,
p018b004_2000 INTEGER,
p018b005 INTEGER,
p018b005_2000 INTEGER,
p018b006 INTEGER,
p018b006_2000 INTEGER,
p018b007 INTEGER,
p018b007_2000 INTEGER,
p018b008 INTEGER,
p018b008_2000 INTEGER,
p018b009 INTEGER,
p018b009_2000 INTEGER,
PRIMARY KEY (geoid)
);