Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
118 lines (117 sloc) 2.87 KB
-- PCT13D. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (ASIAN ALONE)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct13d (
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,
pct013d001 INTEGER,
pct013d001_2000 INTEGER,
pct013d002 INTEGER,
pct013d002_2000 INTEGER,
pct013d003 INTEGER,
pct013d003_2000 INTEGER,
pct013d004 INTEGER,
pct013d004_2000 INTEGER,
pct013d005 INTEGER,
pct013d005_2000 INTEGER,
pct013d006 INTEGER,
pct013d006_2000 INTEGER,
pct013d007 INTEGER,
pct013d007_2000 INTEGER,
pct013d008 INTEGER,
pct013d008_2000 INTEGER,
pct013d009 INTEGER,
pct013d009_2000 INTEGER,
pct013d010 INTEGER,
pct013d010_2000 INTEGER,
pct013d011 INTEGER,
pct013d011_2000 INTEGER,
pct013d012 INTEGER,
pct013d012_2000 INTEGER,
pct013d013 INTEGER,
pct013d013_2000 INTEGER,
pct013d014 INTEGER,
pct013d014_2000 INTEGER,
pct013d015 INTEGER,
pct013d015_2000 INTEGER,
pct013d016 INTEGER,
pct013d016_2000 INTEGER,
pct013d017 INTEGER,
pct013d017_2000 INTEGER,
pct013d018 INTEGER,
pct013d018_2000 INTEGER,
pct013d019 INTEGER,
pct013d019_2000 INTEGER,
pct013d020 INTEGER,
pct013d020_2000 INTEGER,
pct013d021 INTEGER,
pct013d021_2000 INTEGER,
pct013d022 INTEGER,
pct013d022_2000 INTEGER,
pct013d023 INTEGER,
pct013d023_2000 INTEGER,
pct013d024 INTEGER,
pct013d024_2000 INTEGER,
pct013d025 INTEGER,
pct013d025_2000 INTEGER,
pct013d026 INTEGER,
pct013d026_2000 INTEGER,
pct013d027 INTEGER,
pct013d027_2000 INTEGER,
pct013d028 INTEGER,
pct013d028_2000 INTEGER,
pct013d029 INTEGER,
pct013d029_2000 INTEGER,
pct013d030 INTEGER,
pct013d030_2000 INTEGER,
pct013d031 INTEGER,
pct013d031_2000 INTEGER,
pct013d032 INTEGER,
pct013d032_2000 INTEGER,
pct013d033 INTEGER,
pct013d033_2000 INTEGER,
pct013d034 INTEGER,
pct013d034_2000 INTEGER,
pct013d035 INTEGER,
pct013d035_2000 INTEGER,
pct013d036 INTEGER,
pct013d036_2000 INTEGER,
pct013d037 INTEGER,
pct013d037_2000 INTEGER,
pct013d038 INTEGER,
pct013d038_2000 INTEGER,
pct013d039 INTEGER,
pct013d039_2000 INTEGER,
pct013d040 INTEGER,
pct013d040_2000 INTEGER,
pct013d041 INTEGER,
pct013d041_2000 INTEGER,
pct013d042 INTEGER,
pct013d042_2000 INTEGER,
pct013d043 INTEGER,
pct013d043_2000 INTEGER,
pct013d044 INTEGER,
pct013d044_2000 INTEGER,
pct013d045 INTEGER,
pct013d045_2000 INTEGER,
pct013d046 INTEGER,
pct013d046_2000 INTEGER,
pct013d047 INTEGER,
pct013d047_2000 INTEGER,
pct013d048 INTEGER,
pct013d048_2000 INTEGER,
pct013d049 INTEGER,
pct013d049_2000 INTEGER,
PRIMARY KEY (geoid)
);