Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
82 lines (81 sloc) 1.85 KB
-- P21. HOUSEHOLDS BY AGE OF HOUSEHOLDER BY HOUSEHOLD TYPE BY PRESENCE OF RELATED CHILDREN
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p21 (
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,
p021001 INTEGER,
p021001_2000 INTEGER,
p021002 INTEGER,
p021002_2000 INTEGER,
p021003 INTEGER,
p021003_2000 INTEGER,
p021004 INTEGER,
p021004_2000 INTEGER,
p021005 INTEGER,
p021005_2000 INTEGER,
p021006 INTEGER,
p021006_2000 INTEGER,
p021007 INTEGER,
p021007_2000 INTEGER,
p021008 INTEGER,
p021008_2000 INTEGER,
p021009 INTEGER,
p021009_2000 INTEGER,
p021010 INTEGER,
p021010_2000 INTEGER,
p021011 INTEGER,
p021011_2000 INTEGER,
p021012 INTEGER,
p021012_2000 INTEGER,
p021013 INTEGER,
p021013_2000 INTEGER,
p021014 INTEGER,
p021014_2000 INTEGER,
p021015 INTEGER,
p021015_2000 INTEGER,
p021016 INTEGER,
p021016_2000 INTEGER,
p021017 INTEGER,
p021017_2000 INTEGER,
p021018 INTEGER,
p021018_2000 INTEGER,
p021019 INTEGER,
p021019_2000 INTEGER,
p021020 INTEGER,
p021020_2000 INTEGER,
p021021 INTEGER,
p021021_2000 INTEGER,
p021022 INTEGER,
p021022_2000 INTEGER,
p021023 INTEGER,
p021023_2000 INTEGER,
p021024 INTEGER,
p021024_2000 INTEGER,
p021025 INTEGER,
p021025_2000 INTEGER,
p021026 INTEGER,
p021026_2000 INTEGER,
p021027 INTEGER,
p021027_2000 INTEGER,
p021028 INTEGER,
p021028_2000 INTEGER,
p021029 INTEGER,
p021029_2000 INTEGER,
p021030 INTEGER,
p021030_2000 INTEGER,
p021031 INTEGER,
p021031_2000 INTEGER,
PRIMARY KEY (geoid)
);