Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Branch: master
Fetching contributors…

Cannot retrieve contributors at this time

82 lines (81 sloc) 1.975 kB
-- PCT11. HISPANIC OR LATINO BY SPECIFIC ORIGIN
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct11 (
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,
pct011001 INTEGER,
pct011001_2000 INTEGER,
pct011002 INTEGER,
pct011002_2000 INTEGER,
pct011003 INTEGER,
pct011003_2000 INTEGER,
pct011004 INTEGER,
pct011004_2000 INTEGER,
pct011005 INTEGER,
pct011005_2000 INTEGER,
pct011006 INTEGER,
pct011006_2000 INTEGER,
pct011007 INTEGER,
pct011007_2000 INTEGER,
pct011008 INTEGER,
pct011008_2000 INTEGER,
pct011009 INTEGER,
pct011009_2000 INTEGER,
pct011010 INTEGER,
pct011010_2000 INTEGER,
pct011011 INTEGER,
pct011011_2000 INTEGER,
pct011012 INTEGER,
pct011012_2000 INTEGER,
pct011013 INTEGER,
pct011013_2000 INTEGER,
pct011014 INTEGER,
pct011014_2000 INTEGER,
pct011015 INTEGER,
pct011015_2000 INTEGER,
pct011016 INTEGER,
pct011016_2000 INTEGER,
pct011017 INTEGER,
pct011017_2000 INTEGER,
pct011018 INTEGER,
pct011018_2000 INTEGER,
pct011019 INTEGER,
pct011019_2000 INTEGER,
pct011020 INTEGER,
pct011020_2000 INTEGER,
pct011021 INTEGER,
pct011021_2000 INTEGER,
pct011022 INTEGER,
pct011022_2000 INTEGER,
pct011023 INTEGER,
pct011023_2000 INTEGER,
pct011024 INTEGER,
pct011024_2000 INTEGER,
pct011025 INTEGER,
pct011025_2000 INTEGER,
pct011026 INTEGER,
pct011026_2000 INTEGER,
pct011027 INTEGER,
pct011027_2000 INTEGER,
pct011028 INTEGER,
pct011028_2000 INTEGER,
pct011029 INTEGER,
pct011029_2000 INTEGER,
pct011030 INTEGER,
pct011030_2000 INTEGER,
pct011031 INTEGER,
pct011031_2000 INTEGER,
PRIMARY KEY (geoid)
);
Jump to Line
Something went wrong with that request. Please try again.