Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
50 lines (49 sloc) 1.24 KB
-- PCT18. NONFAMILY HOUSEHOLDS BY SEX OF HOUSEHOLDER BY LIVING ALONE BY AGE OF HOUSEHOLDER
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct18 (
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,
pct018001 INTEGER,
pct018001_2000 INTEGER,
pct018002 INTEGER,
pct018002_2000 INTEGER,
pct018003 INTEGER,
pct018003_2000 INTEGER,
pct018004 INTEGER,
pct018004_2000 INTEGER,
pct018005 INTEGER,
pct018005_2000 INTEGER,
pct018006 INTEGER,
pct018006_2000 INTEGER,
pct018007 INTEGER,
pct018007_2000 INTEGER,
pct018008 INTEGER,
pct018008_2000 INTEGER,
pct018009 INTEGER,
pct018009_2000 INTEGER,
pct018010 INTEGER,
pct018010_2000 INTEGER,
pct018011 INTEGER,
pct018011_2000 INTEGER,
pct018012 INTEGER,
pct018012_2000 INTEGER,
pct018013 INTEGER,
pct018013_2000 INTEGER,
pct018014 INTEGER,
pct018014_2000 INTEGER,
pct018015 INTEGER,
pct018015_2000 INTEGER,
PRIMARY KEY (geoid)
);