Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
branch: master
Fetching contributors…

Cannot retrieve contributors at this time

166 lines (165 sloc) 3.707 kb
-- P11. HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO BY 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_p11 (
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,
p011001 INTEGER,
p011001_2000 INTEGER,
p011002 INTEGER,
p011002_2000 INTEGER,
p011003 INTEGER,
p011003_2000 INTEGER,
p011004 INTEGER,
p011004_2000 INTEGER,
p011005 INTEGER,
p011005_2000 INTEGER,
p011006 INTEGER,
p011006_2000 INTEGER,
p011007 INTEGER,
p011007_2000 INTEGER,
p011008 INTEGER,
p011008_2000 INTEGER,
p011009 INTEGER,
p011009_2000 INTEGER,
p011010 INTEGER,
p011010_2000 INTEGER,
p011011 INTEGER,
p011011_2000 INTEGER,
p011012 INTEGER,
p011012_2000 INTEGER,
p011013 INTEGER,
p011013_2000 INTEGER,
p011014 INTEGER,
p011014_2000 INTEGER,
p011015 INTEGER,
p011015_2000 INTEGER,
p011016 INTEGER,
p011016_2000 INTEGER,
p011017 INTEGER,
p011017_2000 INTEGER,
p011018 INTEGER,
p011018_2000 INTEGER,
p011019 INTEGER,
p011019_2000 INTEGER,
p011020 INTEGER,
p011020_2000 INTEGER,
p011021 INTEGER,
p011021_2000 INTEGER,
p011022 INTEGER,
p011022_2000 INTEGER,
p011023 INTEGER,
p011023_2000 INTEGER,
p011024 INTEGER,
p011024_2000 INTEGER,
p011025 INTEGER,
p011025_2000 INTEGER,
p011026 INTEGER,
p011026_2000 INTEGER,
p011027 INTEGER,
p011027_2000 INTEGER,
p011028 INTEGER,
p011028_2000 INTEGER,
p011029 INTEGER,
p011029_2000 INTEGER,
p011030 INTEGER,
p011030_2000 INTEGER,
p011031 INTEGER,
p011031_2000 INTEGER,
p011032 INTEGER,
p011032_2000 INTEGER,
p011033 INTEGER,
p011033_2000 INTEGER,
p011034 INTEGER,
p011034_2000 INTEGER,
p011035 INTEGER,
p011035_2000 INTEGER,
p011036 INTEGER,
p011036_2000 INTEGER,
p011037 INTEGER,
p011037_2000 INTEGER,
p011038 INTEGER,
p011038_2000 INTEGER,
p011039 INTEGER,
p011039_2000 INTEGER,
p011040 INTEGER,
p011040_2000 INTEGER,
p011041 INTEGER,
p011041_2000 INTEGER,
p011042 INTEGER,
p011042_2000 INTEGER,
p011043 INTEGER,
p011043_2000 INTEGER,
p011044 INTEGER,
p011044_2000 INTEGER,
p011045 INTEGER,
p011045_2000 INTEGER,
p011046 INTEGER,
p011046_2000 INTEGER,
p011047 INTEGER,
p011047_2000 INTEGER,
p011048 INTEGER,
p011048_2000 INTEGER,
p011049 INTEGER,
p011049_2000 INTEGER,
p011050 INTEGER,
p011050_2000 INTEGER,
p011051 INTEGER,
p011051_2000 INTEGER,
p011052 INTEGER,
p011052_2000 INTEGER,
p011053 INTEGER,
p011053_2000 INTEGER,
p011054 INTEGER,
p011054_2000 INTEGER,
p011055 INTEGER,
p011055_2000 INTEGER,
p011056 INTEGER,
p011056_2000 INTEGER,
p011057 INTEGER,
p011057_2000 INTEGER,
p011058 INTEGER,
p011058_2000 INTEGER,
p011059 INTEGER,
p011059_2000 INTEGER,
p011060 INTEGER,
p011060_2000 INTEGER,
p011061 INTEGER,
p011061_2000 INTEGER,
p011062 INTEGER,
p011062_2000 INTEGER,
p011063 INTEGER,
p011063_2000 INTEGER,
p011064 INTEGER,
p011064_2000 INTEGER,
p011065 INTEGER,
p011065_2000 INTEGER,
p011066 INTEGER,
p011066_2000 INTEGER,
p011067 INTEGER,
p011067_2000 INTEGER,
p011068 INTEGER,
p011068_2000 INTEGER,
p011069 INTEGER,
p011069_2000 INTEGER,
p011070 INTEGER,
p011070_2000 INTEGER,
p011071 INTEGER,
p011071_2000 INTEGER,
p011072 INTEGER,
p011072_2000 INTEGER,
p011073 INTEGER,
p011073_2000 INTEGER,
PRIMARY KEY (geoid)
);
Jump to Line
Something went wrong with that request. Please try again.