Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
64 lines (63 sloc) 1.54 KB
-- PCT6. ASIAN ALONE WITH ONE OR MORE ASIAN CATEGORIES FOR SELECTED GROUPS
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct6 (
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,
pct006001 INTEGER,
pct006001_2000 INTEGER,
pct006002 INTEGER,
pct006002_2000 INTEGER,
pct006003 INTEGER,
pct006003_2000 INTEGER,
pct006004 INTEGER,
pct006004_2000 INTEGER,
pct006005 INTEGER,
pct006005_2000 INTEGER,
pct006006 INTEGER,
pct006006_2000 INTEGER,
pct006007 INTEGER,
pct006007_2000 INTEGER,
pct006008 INTEGER,
pct006008_2000 INTEGER,
pct006009 INTEGER,
pct006009_2000 INTEGER,
pct006010 INTEGER,
pct006010_2000 INTEGER,
pct006011 INTEGER,
pct006011_2000 INTEGER,
pct006012 INTEGER,
pct006012_2000 INTEGER,
pct006013 INTEGER,
pct006013_2000 INTEGER,
pct006014 INTEGER,
pct006014_2000 INTEGER,
pct006015 INTEGER,
pct006015_2000 INTEGER,
pct006016 INTEGER,
pct006016_2000 INTEGER,
pct006017 INTEGER,
pct006017_2000 INTEGER,
pct006018 INTEGER,
pct006018_2000 INTEGER,
pct006019 INTEGER,
pct006019_2000 INTEGER,
pct006020 INTEGER,
pct006020_2000 INTEGER,
pct006021 INTEGER,
pct006021_2000 INTEGER,
pct006022 INTEGER,
pct006022_2000 INTEGER,
PRIMARY KEY (geoid)
);