Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
48 lines (47 sloc) 1.29 KB
-- PCT10. NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE OR IN COMBINATION WITH ONE OR MORE RACES, AND WITH ONE OR MORE NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER 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_pct10 (
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,
pct010001 INTEGER,
pct010001_2000 INTEGER,
pct010002 INTEGER,
pct010002_2000 INTEGER,
pct010003 INTEGER,
pct010003_2000 INTEGER,
pct010004 INTEGER,
pct010004_2000 INTEGER,
pct010005 INTEGER,
pct010005_2000 INTEGER,
pct010006 INTEGER,
pct010006_2000 INTEGER,
pct010007 INTEGER,
pct010007_2000 INTEGER,
pct010008 INTEGER,
pct010008_2000 INTEGER,
pct010009 INTEGER,
pct010009_2000 INTEGER,
pct010010 INTEGER,
pct010010_2000 INTEGER,
pct010011 INTEGER,
pct010011_2000 INTEGER,
pct010012 INTEGER,
pct010012_2000 INTEGER,
pct010013 INTEGER,
pct010013_2000 INTEGER,
pct010014 INTEGER,
pct010014_2000 INTEGER,
PRIMARY KEY (geoid)
);