Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
118 lines (117 sloc) 2.65 KB
-- P12H. SEX BY AGE (HISPANIC OR LATINO)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p12h (
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,
p012h001 INTEGER,
p012h001_2000 INTEGER,
p012h002 INTEGER,
p012h002_2000 INTEGER,
p012h003 INTEGER,
p012h003_2000 INTEGER,
p012h004 INTEGER,
p012h004_2000 INTEGER,
p012h005 INTEGER,
p012h005_2000 INTEGER,
p012h006 INTEGER,
p012h006_2000 INTEGER,
p012h007 INTEGER,
p012h007_2000 INTEGER,
p012h008 INTEGER,
p012h008_2000 INTEGER,
p012h009 INTEGER,
p012h009_2000 INTEGER,
p012h010 INTEGER,
p012h010_2000 INTEGER,
p012h011 INTEGER,
p012h011_2000 INTEGER,
p012h012 INTEGER,
p012h012_2000 INTEGER,
p012h013 INTEGER,
p012h013_2000 INTEGER,
p012h014 INTEGER,
p012h014_2000 INTEGER,
p012h015 INTEGER,
p012h015_2000 INTEGER,
p012h016 INTEGER,
p012h016_2000 INTEGER,
p012h017 INTEGER,
p012h017_2000 INTEGER,
p012h018 INTEGER,
p012h018_2000 INTEGER,
p012h019 INTEGER,
p012h019_2000 INTEGER,
p012h020 INTEGER,
p012h020_2000 INTEGER,
p012h021 INTEGER,
p012h021_2000 INTEGER,
p012h022 INTEGER,
p012h022_2000 INTEGER,
p012h023 INTEGER,
p012h023_2000 INTEGER,
p012h024 INTEGER,
p012h024_2000 INTEGER,
p012h025 INTEGER,
p012h025_2000 INTEGER,
p012h026 INTEGER,
p012h026_2000 INTEGER,
p012h027 INTEGER,
p012h027_2000 INTEGER,
p012h028 INTEGER,
p012h028_2000 INTEGER,
p012h029 INTEGER,
p012h029_2000 INTEGER,
p012h030 INTEGER,
p012h030_2000 INTEGER,
p012h031 INTEGER,
p012h031_2000 INTEGER,
p012h032 INTEGER,
p012h032_2000 INTEGER,
p012h033 INTEGER,
p012h033_2000 INTEGER,
p012h034 INTEGER,
p012h034_2000 INTEGER,
p012h035 INTEGER,
p012h035_2000 INTEGER,
p012h036 INTEGER,
p012h036_2000 INTEGER,
p012h037 INTEGER,
p012h037_2000 INTEGER,
p012h038 INTEGER,
p012h038_2000 INTEGER,
p012h039 INTEGER,
p012h039_2000 INTEGER,
p012h040 INTEGER,
p012h040_2000 INTEGER,
p012h041 INTEGER,
p012h041_2000 INTEGER,
p012h042 INTEGER,
p012h042_2000 INTEGER,
p012h043 INTEGER,
p012h043_2000 INTEGER,
p012h044 INTEGER,
p012h044_2000 INTEGER,
p012h045 INTEGER,
p012h045_2000 INTEGER,
p012h046 INTEGER,
p012h046_2000 INTEGER,
p012h047 INTEGER,
p012h047_2000 INTEGER,
p012h048 INTEGER,
p012h048_2000 INTEGER,
p012h049 INTEGER,
p012h049_2000 INTEGER,
PRIMARY KEY (geoid)
);