Skip to content
Find file
Fetching contributors…
Cannot retrieve contributors at this time
64 lines (63 sloc) 1.59 KB
-- PCT7. ASIAN ALONE OR IN COMBINATION WITH ONE OR MORE OTHER RACES, AND 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_pct7 (
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,
pct007001 INTEGER,
pct007001_2000 INTEGER,
pct007002 INTEGER,
pct007002_2000 INTEGER,
pct007003 INTEGER,
pct007003_2000 INTEGER,
pct007004 INTEGER,
pct007004_2000 INTEGER,
pct007005 INTEGER,
pct007005_2000 INTEGER,
pct007006 INTEGER,
pct007006_2000 INTEGER,
pct007007 INTEGER,
pct007007_2000 INTEGER,
pct007008 INTEGER,
pct007008_2000 INTEGER,
pct007009 INTEGER,
pct007009_2000 INTEGER,
pct007010 INTEGER,
pct007010_2000 INTEGER,
pct007011 INTEGER,
pct007011_2000 INTEGER,
pct007012 INTEGER,
pct007012_2000 INTEGER,
pct007013 INTEGER,
pct007013_2000 INTEGER,
pct007014 INTEGER,
pct007014_2000 INTEGER,
pct007015 INTEGER,
pct007015_2000 INTEGER,
pct007016 INTEGER,
pct007016_2000 INTEGER,
pct007017 INTEGER,
pct007017_2000 INTEGER,
pct007018 INTEGER,
pct007018_2000 INTEGER,
pct007019 INTEGER,
pct007019_2000 INTEGER,
pct007020 INTEGER,
pct007020_2000 INTEGER,
pct007021 INTEGER,
pct007021_2000 INTEGER,
pct007022 INTEGER,
pct007022_2000 INTEGER,
PRIMARY KEY (geoid)
);
Something went wrong with that request. Please try again.