Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
118 lines (117 sloc) 2.88 KB
-- PCT13H. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (HISPANIC OR LATINO)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct13h (
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,
pct013h001 INTEGER,
pct013h001_2000 INTEGER,
pct013h002 INTEGER,
pct013h002_2000 INTEGER,
pct013h003 INTEGER,
pct013h003_2000 INTEGER,
pct013h004 INTEGER,
pct013h004_2000 INTEGER,
pct013h005 INTEGER,
pct013h005_2000 INTEGER,
pct013h006 INTEGER,
pct013h006_2000 INTEGER,
pct013h007 INTEGER,
pct013h007_2000 INTEGER,
pct013h008 INTEGER,
pct013h008_2000 INTEGER,
pct013h009 INTEGER,
pct013h009_2000 INTEGER,
pct013h010 INTEGER,
pct013h010_2000 INTEGER,
pct013h011 INTEGER,
pct013h011_2000 INTEGER,
pct013h012 INTEGER,
pct013h012_2000 INTEGER,
pct013h013 INTEGER,
pct013h013_2000 INTEGER,
pct013h014 INTEGER,
pct013h014_2000 INTEGER,
pct013h015 INTEGER,
pct013h015_2000 INTEGER,
pct013h016 INTEGER,
pct013h016_2000 INTEGER,
pct013h017 INTEGER,
pct013h017_2000 INTEGER,
pct013h018 INTEGER,
pct013h018_2000 INTEGER,
pct013h019 INTEGER,
pct013h019_2000 INTEGER,
pct013h020 INTEGER,
pct013h020_2000 INTEGER,
pct013h021 INTEGER,
pct013h021_2000 INTEGER,
pct013h022 INTEGER,
pct013h022_2000 INTEGER,
pct013h023 INTEGER,
pct013h023_2000 INTEGER,
pct013h024 INTEGER,
pct013h024_2000 INTEGER,
pct013h025 INTEGER,
pct013h025_2000 INTEGER,
pct013h026 INTEGER,
pct013h026_2000 INTEGER,
pct013h027 INTEGER,
pct013h027_2000 INTEGER,
pct013h028 INTEGER,
pct013h028_2000 INTEGER,
pct013h029 INTEGER,
pct013h029_2000 INTEGER,
pct013h030 INTEGER,
pct013h030_2000 INTEGER,
pct013h031 INTEGER,
pct013h031_2000 INTEGER,
pct013h032 INTEGER,
pct013h032_2000 INTEGER,
pct013h033 INTEGER,
pct013h033_2000 INTEGER,
pct013h034 INTEGER,
pct013h034_2000 INTEGER,
pct013h035 INTEGER,
pct013h035_2000 INTEGER,
pct013h036 INTEGER,
pct013h036_2000 INTEGER,
pct013h037 INTEGER,
pct013h037_2000 INTEGER,
pct013h038 INTEGER,
pct013h038_2000 INTEGER,
pct013h039 INTEGER,
pct013h039_2000 INTEGER,
pct013h040 INTEGER,
pct013h040_2000 INTEGER,
pct013h041 INTEGER,
pct013h041_2000 INTEGER,
pct013h042 INTEGER,
pct013h042_2000 INTEGER,
pct013h043 INTEGER,
pct013h043_2000 INTEGER,
pct013h044 INTEGER,
pct013h044_2000 INTEGER,
pct013h045 INTEGER,
pct013h045_2000 INTEGER,
pct013h046 INTEGER,
pct013h046_2000 INTEGER,
pct013h047 INTEGER,
pct013h047_2000 INTEGER,
pct013h048 INTEGER,
pct013h048_2000 INTEGER,
pct013h049 INTEGER,
pct013h049_2000 INTEGER,
PRIMARY KEY (geoid)
);