Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
162 lines (161 sloc) 3.45 KB
-- P8. RACE
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p8 (
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,
p008001 INTEGER,
p008001_2000 INTEGER,
p008002 INTEGER,
p008002_2000 INTEGER,
p008003 INTEGER,
p008003_2000 INTEGER,
p008004 INTEGER,
p008004_2000 INTEGER,
p008005 INTEGER,
p008005_2000 INTEGER,
p008006 INTEGER,
p008006_2000 INTEGER,
p008007 INTEGER,
p008007_2000 INTEGER,
p008008 INTEGER,
p008008_2000 INTEGER,
p008009 INTEGER,
p008009_2000 INTEGER,
p008010 INTEGER,
p008010_2000 INTEGER,
p008011 INTEGER,
p008011_2000 INTEGER,
p008012 INTEGER,
p008012_2000 INTEGER,
p008013 INTEGER,
p008013_2000 INTEGER,
p008014 INTEGER,
p008014_2000 INTEGER,
p008015 INTEGER,
p008015_2000 INTEGER,
p008016 INTEGER,
p008016_2000 INTEGER,
p008017 INTEGER,
p008017_2000 INTEGER,
p008018 INTEGER,
p008018_2000 INTEGER,
p008019 INTEGER,
p008019_2000 INTEGER,
p008020 INTEGER,
p008020_2000 INTEGER,
p008021 INTEGER,
p008021_2000 INTEGER,
p008022 INTEGER,
p008022_2000 INTEGER,
p008023 INTEGER,
p008023_2000 INTEGER,
p008024 INTEGER,
p008024_2000 INTEGER,
p008025 INTEGER,
p008025_2000 INTEGER,
p008026 INTEGER,
p008026_2000 INTEGER,
p008027 INTEGER,
p008027_2000 INTEGER,
p008028 INTEGER,
p008028_2000 INTEGER,
p008029 INTEGER,
p008029_2000 INTEGER,
p008030 INTEGER,
p008030_2000 INTEGER,
p008031 INTEGER,
p008031_2000 INTEGER,
p008032 INTEGER,
p008032_2000 INTEGER,
p008033 INTEGER,
p008033_2000 INTEGER,
p008034 INTEGER,
p008034_2000 INTEGER,
p008035 INTEGER,
p008035_2000 INTEGER,
p008036 INTEGER,
p008036_2000 INTEGER,
p008037 INTEGER,
p008037_2000 INTEGER,
p008038 INTEGER,
p008038_2000 INTEGER,
p008039 INTEGER,
p008039_2000 INTEGER,
p008040 INTEGER,
p008040_2000 INTEGER,
p008041 INTEGER,
p008041_2000 INTEGER,
p008042 INTEGER,
p008042_2000 INTEGER,
p008043 INTEGER,
p008043_2000 INTEGER,
p008044 INTEGER,
p008044_2000 INTEGER,
p008045 INTEGER,
p008045_2000 INTEGER,
p008046 INTEGER,
p008046_2000 INTEGER,
p008047 INTEGER,
p008047_2000 INTEGER,
p008048 INTEGER,
p008048_2000 INTEGER,
p008049 INTEGER,
p008049_2000 INTEGER,
p008050 INTEGER,
p008050_2000 INTEGER,
p008051 INTEGER,
p008051_2000 INTEGER,
p008052 INTEGER,
p008052_2000 INTEGER,
p008053 INTEGER,
p008053_2000 INTEGER,
p008054 INTEGER,
p008054_2000 INTEGER,
p008055 INTEGER,
p008055_2000 INTEGER,
p008056 INTEGER,
p008056_2000 INTEGER,
p008057 INTEGER,
p008057_2000 INTEGER,
p008058 INTEGER,
p008058_2000 INTEGER,
p008059 INTEGER,
p008059_2000 INTEGER,
p008060 INTEGER,
p008060_2000 INTEGER,
p008061 INTEGER,
p008061_2000 INTEGER,
p008062 INTEGER,
p008062_2000 INTEGER,
p008063 INTEGER,
p008063_2000 INTEGER,
p008064 INTEGER,
p008064_2000 INTEGER,
p008065 INTEGER,
p008065_2000 INTEGER,
p008066 INTEGER,
p008066_2000 INTEGER,
p008067 INTEGER,
p008067_2000 INTEGER,
p008068 INTEGER,
p008068_2000 INTEGER,
p008069 INTEGER,
p008069_2000 INTEGER,
p008070 INTEGER,
p008070_2000 INTEGER,
p008071 INTEGER,
p008071_2000 INTEGER,
PRIMARY KEY (geoid)
);