Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
162 lines (161 sloc) 3.49 KB
-- P10. RACE FOR THE POPULATION 18 YEARS AND OVER
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p10 (
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,
p010001 INTEGER,
p010001_2000 INTEGER,
p010002 INTEGER,
p010002_2000 INTEGER,
p010003 INTEGER,
p010003_2000 INTEGER,
p010004 INTEGER,
p010004_2000 INTEGER,
p010005 INTEGER,
p010005_2000 INTEGER,
p010006 INTEGER,
p010006_2000 INTEGER,
p010007 INTEGER,
p010007_2000 INTEGER,
p010008 INTEGER,
p010008_2000 INTEGER,
p010009 INTEGER,
p010009_2000 INTEGER,
p010010 INTEGER,
p010010_2000 INTEGER,
p010011 INTEGER,
p010011_2000 INTEGER,
p010012 INTEGER,
p010012_2000 INTEGER,
p010013 INTEGER,
p010013_2000 INTEGER,
p010014 INTEGER,
p010014_2000 INTEGER,
p010015 INTEGER,
p010015_2000 INTEGER,
p010016 INTEGER,
p010016_2000 INTEGER,
p010017 INTEGER,
p010017_2000 INTEGER,
p010018 INTEGER,
p010018_2000 INTEGER,
p010019 INTEGER,
p010019_2000 INTEGER,
p010020 INTEGER,
p010020_2000 INTEGER,
p010021 INTEGER,
p010021_2000 INTEGER,
p010022 INTEGER,
p010022_2000 INTEGER,
p010023 INTEGER,
p010023_2000 INTEGER,
p010024 INTEGER,
p010024_2000 INTEGER,
p010025 INTEGER,
p010025_2000 INTEGER,
p010026 INTEGER,
p010026_2000 INTEGER,
p010027 INTEGER,
p010027_2000 INTEGER,
p010028 INTEGER,
p010028_2000 INTEGER,
p010029 INTEGER,
p010029_2000 INTEGER,
p010030 INTEGER,
p010030_2000 INTEGER,
p010031 INTEGER,
p010031_2000 INTEGER,
p010032 INTEGER,
p010032_2000 INTEGER,
p010033 INTEGER,
p010033_2000 INTEGER,
p010034 INTEGER,
p010034_2000 INTEGER,
p010035 INTEGER,
p010035_2000 INTEGER,
p010036 INTEGER,
p010036_2000 INTEGER,
p010037 INTEGER,
p010037_2000 INTEGER,
p010038 INTEGER,
p010038_2000 INTEGER,
p010039 INTEGER,
p010039_2000 INTEGER,
p010040 INTEGER,
p010040_2000 INTEGER,
p010041 INTEGER,
p010041_2000 INTEGER,
p010042 INTEGER,
p010042_2000 INTEGER,
p010043 INTEGER,
p010043_2000 INTEGER,
p010044 INTEGER,
p010044_2000 INTEGER,
p010045 INTEGER,
p010045_2000 INTEGER,
p010046 INTEGER,
p010046_2000 INTEGER,
p010047 INTEGER,
p010047_2000 INTEGER,
p010048 INTEGER,
p010048_2000 INTEGER,
p010049 INTEGER,
p010049_2000 INTEGER,
p010050 INTEGER,
p010050_2000 INTEGER,
p010051 INTEGER,
p010051_2000 INTEGER,
p010052 INTEGER,
p010052_2000 INTEGER,
p010053 INTEGER,
p010053_2000 INTEGER,
p010054 INTEGER,
p010054_2000 INTEGER,
p010055 INTEGER,
p010055_2000 INTEGER,
p010056 INTEGER,
p010056_2000 INTEGER,
p010057 INTEGER,
p010057_2000 INTEGER,
p010058 INTEGER,
p010058_2000 INTEGER,
p010059 INTEGER,
p010059_2000 INTEGER,
p010060 INTEGER,
p010060_2000 INTEGER,
p010061 INTEGER,
p010061_2000 INTEGER,
p010062 INTEGER,
p010062_2000 INTEGER,
p010063 INTEGER,
p010063_2000 INTEGER,
p010064 INTEGER,
p010064_2000 INTEGER,
p010065 INTEGER,
p010065_2000 INTEGER,
p010066 INTEGER,
p010066_2000 INTEGER,
p010067 INTEGER,
p010067_2000 INTEGER,
p010068 INTEGER,
p010068_2000 INTEGER,
p010069 INTEGER,
p010069_2000 INTEGER,
p010070 INTEGER,
p010070_2000 INTEGER,
p010071 INTEGER,
p010071_2000 INTEGER,
PRIMARY KEY (geoid)
);