Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
118 lines (117 sloc) 2.9 KB
-- PCT13I. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (WHITE ALONE, NOT HISPANIC OR LATINO)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct13i (
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,
pct013i001 INTEGER,
pct013i001_2000 INTEGER,
pct013i002 INTEGER,
pct013i002_2000 INTEGER,
pct013i003 INTEGER,
pct013i003_2000 INTEGER,
pct013i004 INTEGER,
pct013i004_2000 INTEGER,
pct013i005 INTEGER,
pct013i005_2000 INTEGER,
pct013i006 INTEGER,
pct013i006_2000 INTEGER,
pct013i007 INTEGER,
pct013i007_2000 INTEGER,
pct013i008 INTEGER,
pct013i008_2000 INTEGER,
pct013i009 INTEGER,
pct013i009_2000 INTEGER,
pct013i010 INTEGER,
pct013i010_2000 INTEGER,
pct013i011 INTEGER,
pct013i011_2000 INTEGER,
pct013i012 INTEGER,
pct013i012_2000 INTEGER,
pct013i013 INTEGER,
pct013i013_2000 INTEGER,
pct013i014 INTEGER,
pct013i014_2000 INTEGER,
pct013i015 INTEGER,
pct013i015_2000 INTEGER,
pct013i016 INTEGER,
pct013i016_2000 INTEGER,
pct013i017 INTEGER,
pct013i017_2000 INTEGER,
pct013i018 INTEGER,
pct013i018_2000 INTEGER,
pct013i019 INTEGER,
pct013i019_2000 INTEGER,
pct013i020 INTEGER,
pct013i020_2000 INTEGER,
pct013i021 INTEGER,
pct013i021_2000 INTEGER,
pct013i022 INTEGER,
pct013i022_2000 INTEGER,
pct013i023 INTEGER,
pct013i023_2000 INTEGER,
pct013i024 INTEGER,
pct013i024_2000 INTEGER,
pct013i025 INTEGER,
pct013i025_2000 INTEGER,
pct013i026 INTEGER,
pct013i026_2000 INTEGER,
pct013i027 INTEGER,
pct013i027_2000 INTEGER,
pct013i028 INTEGER,
pct013i028_2000 INTEGER,
pct013i029 INTEGER,
pct013i029_2000 INTEGER,
pct013i030 INTEGER,
pct013i030_2000 INTEGER,
pct013i031 INTEGER,
pct013i031_2000 INTEGER,
pct013i032 INTEGER,
pct013i032_2000 INTEGER,
pct013i033 INTEGER,
pct013i033_2000 INTEGER,
pct013i034 INTEGER,
pct013i034_2000 INTEGER,
pct013i035 INTEGER,
pct013i035_2000 INTEGER,
pct013i036 INTEGER,
pct013i036_2000 INTEGER,
pct013i037 INTEGER,
pct013i037_2000 INTEGER,
pct013i038 INTEGER,
pct013i038_2000 INTEGER,
pct013i039 INTEGER,
pct013i039_2000 INTEGER,
pct013i040 INTEGER,
pct013i040_2000 INTEGER,
pct013i041 INTEGER,
pct013i041_2000 INTEGER,
pct013i042 INTEGER,
pct013i042_2000 INTEGER,
pct013i043 INTEGER,
pct013i043_2000 INTEGER,
pct013i044 INTEGER,
pct013i044_2000 INTEGER,
pct013i045 INTEGER,
pct013i045_2000 INTEGER,
pct013i046 INTEGER,
pct013i046_2000 INTEGER,
pct013i047 INTEGER,
pct013i047_2000 INTEGER,
pct013i048 INTEGER,
pct013i048_2000 INTEGER,
pct013i049 INTEGER,
pct013i049_2000 INTEGER,
PRIMARY KEY (geoid)
);