Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
128 lines (127 sloc) 3.03 KB
-- PCT1. AMERICAN INDIAN AND ALASKA NATIVE ALONE WITH ONE TRIBE REPORTED FOR SELECTED TRIBES
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct1 (
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,
pct001001 INTEGER,
pct001001_2000 INTEGER,
pct001002 INTEGER,
pct001002_2000 INTEGER,
pct001003 INTEGER,
pct001003_2000 INTEGER,
pct001004 INTEGER,
pct001004_2000 INTEGER,
pct001005 INTEGER,
pct001005_2000 INTEGER,
pct001006 INTEGER,
pct001006_2000 INTEGER,
pct001007 INTEGER,
pct001007_2000 INTEGER,
pct001008 INTEGER,
pct001008_2000 INTEGER,
pct001009 INTEGER,
pct001009_2000 INTEGER,
pct001010 INTEGER,
pct001010_2000 INTEGER,
pct001011 INTEGER,
pct001011_2000 INTEGER,
pct001012 INTEGER,
pct001012_2000 INTEGER,
pct001013 INTEGER,
pct001013_2000 INTEGER,
pct001014 INTEGER,
pct001014_2000 INTEGER,
pct001015 INTEGER,
pct001015_2000 INTEGER,
pct001016 INTEGER,
pct001016_2000 INTEGER,
pct001017 INTEGER,
pct001017_2000 INTEGER,
pct001018 INTEGER,
pct001018_2000 INTEGER,
pct001019 INTEGER,
pct001019_2000 INTEGER,
pct001020 INTEGER,
pct001020_2000 INTEGER,
pct001021 INTEGER,
pct001021_2000 INTEGER,
pct001022 INTEGER,
pct001022_2000 INTEGER,
pct001023 INTEGER,
pct001023_2000 INTEGER,
pct001024 INTEGER,
pct001024_2000 INTEGER,
pct001025 INTEGER,
pct001025_2000 INTEGER,
pct001026 INTEGER,
pct001026_2000 INTEGER,
pct001027 INTEGER,
pct001027_2000 INTEGER,
pct001028 INTEGER,
pct001028_2000 INTEGER,
pct001029 INTEGER,
pct001029_2000 INTEGER,
pct001030 INTEGER,
pct001030_2000 INTEGER,
pct001031 INTEGER,
pct001031_2000 INTEGER,
pct001032 INTEGER,
pct001032_2000 INTEGER,
pct001033 INTEGER,
pct001033_2000 INTEGER,
pct001034 INTEGER,
pct001034_2000 INTEGER,
pct001035 INTEGER,
pct001035_2000 INTEGER,
pct001036 INTEGER,
pct001036_2000 INTEGER,
pct001037 INTEGER,
pct001037_2000 INTEGER,
pct001038 INTEGER,
pct001038_2000 INTEGER,
pct001039 INTEGER,
pct001039_2000 INTEGER,
pct001040 INTEGER,
pct001040_2000 INTEGER,
pct001041 INTEGER,
pct001041_2000 INTEGER,
pct001042 INTEGER,
pct001042_2000 INTEGER,
pct001043 INTEGER,
pct001043_2000 INTEGER,
pct001044 INTEGER,
pct001044_2000 INTEGER,
pct001045 INTEGER,
pct001045_2000 INTEGER,
pct001046 INTEGER,
pct001046_2000 INTEGER,
pct001047 INTEGER,
pct001047_2000 INTEGER,
pct001048 INTEGER,
pct001048_2000 INTEGER,
pct001049 INTEGER,
pct001049_2000 INTEGER,
pct001050 INTEGER,
pct001050_2000 INTEGER,
pct001051 INTEGER,
pct001051_2000 INTEGER,
pct001052 INTEGER,
pct001052_2000 INTEGER,
pct001053 INTEGER,
pct001053_2000 INTEGER,
pct001054 INTEGER,
pct001054_2000 INTEGER,
PRIMARY KEY (geoid)
);