Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
50 lines (49 sloc) 1.16 KB
-- P23. HOUSEHOLDS BY PRESENCE OF PEOPLE 60 YEARS AND OVER BY HOUSEHOLD TYPE
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p23 (
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,
p023001 INTEGER,
p023001_2000 INTEGER,
p023002 INTEGER,
p023002_2000 INTEGER,
p023003 INTEGER,
p023003_2000 INTEGER,
p023004 INTEGER,
p023004_2000 INTEGER,
p023005 INTEGER,
p023005_2000 INTEGER,
p023006 INTEGER,
p023006_2000 INTEGER,
p023007 INTEGER,
p023007_2000 INTEGER,
p023008 INTEGER,
p023008_2000 INTEGER,
p023009 INTEGER,
p023009_2000 INTEGER,
p023010 INTEGER,
p023010_2000 INTEGER,
p023011 INTEGER,
p023011_2000 INTEGER,
p023012 INTEGER,
p023012_2000 INTEGER,
p023013 INTEGER,
p023013_2000 INTEGER,
p023014 INTEGER,
p023014_2000 INTEGER,
p023015 INTEGER,
p023015_2000 INTEGER,
PRIMARY KEY (geoid)
);