Find file
Fetching contributors…
Cannot retrieve contributors at this time
438 lines (437 sloc) 10.5 KB
-- designed to work with the IRE Census bulk data exports
-- see
CREATE TABLE ire_pct12g (
county VARCHAR(3),
cbsa VARCHAR(5),
csa VARCHAR(3),
necta VARCHAR(5),
cnecta VARCHAR(3),
pop100_2000 INTEGER,
hu100_2000 INTEGER,
pct012g001 INTEGER,
pct012g001_2000 INTEGER,
pct012g002 INTEGER,
pct012g002_2000 INTEGER,
pct012g003 INTEGER,
pct012g003_2000 INTEGER,
pct012g004 INTEGER,
pct012g004_2000 INTEGER,
pct012g005 INTEGER,
pct012g005_2000 INTEGER,
pct012g006 INTEGER,
pct012g006_2000 INTEGER,
pct012g007 INTEGER,
pct012g007_2000 INTEGER,
pct012g008 INTEGER,
pct012g008_2000 INTEGER,
pct012g009 INTEGER,
pct012g009_2000 INTEGER,
pct012g010 INTEGER,
pct012g010_2000 INTEGER,
pct012g011 INTEGER,
pct012g011_2000 INTEGER,
pct012g012 INTEGER,
pct012g012_2000 INTEGER,
pct012g013 INTEGER,
pct012g013_2000 INTEGER,
pct012g014 INTEGER,
pct012g014_2000 INTEGER,
pct012g015 INTEGER,
pct012g015_2000 INTEGER,
pct012g016 INTEGER,
pct012g016_2000 INTEGER,
pct012g017 INTEGER,
pct012g017_2000 INTEGER,
pct012g018 INTEGER,
pct012g018_2000 INTEGER,
pct012g019 INTEGER,
pct012g019_2000 INTEGER,
pct012g020 INTEGER,
pct012g020_2000 INTEGER,
pct012g021 INTEGER,
pct012g021_2000 INTEGER,
pct012g022 INTEGER,
pct012g022_2000 INTEGER,
pct012g023 INTEGER,
pct012g023_2000 INTEGER,
pct012g024 INTEGER,
pct012g024_2000 INTEGER,
pct012g025 INTEGER,
pct012g025_2000 INTEGER,
pct012g026 INTEGER,
pct012g026_2000 INTEGER,
pct012g027 INTEGER,
pct012g027_2000 INTEGER,
pct012g028 INTEGER,
pct012g028_2000 INTEGER,
pct012g029 INTEGER,
pct012g029_2000 INTEGER,
pct012g030 INTEGER,
pct012g030_2000 INTEGER,
pct012g031 INTEGER,
pct012g031_2000 INTEGER,
pct012g032 INTEGER,
pct012g032_2000 INTEGER,
pct012g033 INTEGER,
pct012g033_2000 INTEGER,
pct012g034 INTEGER,
pct012g034_2000 INTEGER,
pct012g035 INTEGER,
pct012g035_2000 INTEGER,
pct012g036 INTEGER,
pct012g036_2000 INTEGER,
pct012g037 INTEGER,
pct012g037_2000 INTEGER,
pct012g038 INTEGER,
pct012g038_2000 INTEGER,
pct012g039 INTEGER,
pct012g039_2000 INTEGER,
pct012g040 INTEGER,
pct012g040_2000 INTEGER,
pct012g041 INTEGER,
pct012g041_2000 INTEGER,
pct012g042 INTEGER,
pct012g042_2000 INTEGER,
pct012g043 INTEGER,
pct012g043_2000 INTEGER,
pct012g044 INTEGER,
pct012g044_2000 INTEGER,
pct012g045 INTEGER,
pct012g045_2000 INTEGER,
pct012g046 INTEGER,
pct012g046_2000 INTEGER,
pct012g047 INTEGER,
pct012g047_2000 INTEGER,
pct012g048 INTEGER,
pct012g048_2000 INTEGER,
pct012g049 INTEGER,
pct012g049_2000 INTEGER,
pct012g050 INTEGER,
pct012g050_2000 INTEGER,
pct012g051 INTEGER,
pct012g051_2000 INTEGER,
pct012g052 INTEGER,
pct012g052_2000 INTEGER,
pct012g053 INTEGER,
pct012g053_2000 INTEGER,
pct012g054 INTEGER,
pct012g054_2000 INTEGER,
pct012g055 INTEGER,
pct012g055_2000 INTEGER,
pct012g056 INTEGER,
pct012g056_2000 INTEGER,
pct012g057 INTEGER,
pct012g057_2000 INTEGER,
pct012g058 INTEGER,
pct012g058_2000 INTEGER,
pct012g059 INTEGER,
pct012g059_2000 INTEGER,
pct012g060 INTEGER,
pct012g060_2000 INTEGER,
pct012g061 INTEGER,
pct012g061_2000 INTEGER,
pct012g062 INTEGER,
pct012g062_2000 INTEGER,
pct012g063 INTEGER,
pct012g063_2000 INTEGER,
pct012g064 INTEGER,
pct012g064_2000 INTEGER,
pct012g065 INTEGER,
pct012g065_2000 INTEGER,
pct012g066 INTEGER,
pct012g066_2000 INTEGER,
pct012g067 INTEGER,
pct012g067_2000 INTEGER,
pct012g068 INTEGER,
pct012g068_2000 INTEGER,
pct012g069 INTEGER,
pct012g069_2000 INTEGER,
pct012g070 INTEGER,
pct012g070_2000 INTEGER,
pct012g071 INTEGER,
pct012g071_2000 INTEGER,
pct012g072 INTEGER,
pct012g072_2000 INTEGER,
pct012g073 INTEGER,
pct012g073_2000 INTEGER,
pct012g074 INTEGER,
pct012g074_2000 INTEGER,
pct012g075 INTEGER,
pct012g075_2000 INTEGER,
pct012g076 INTEGER,
pct012g076_2000 INTEGER,
pct012g077 INTEGER,
pct012g077_2000 INTEGER,
pct012g078 INTEGER,
pct012g078_2000 INTEGER,
pct012g079 INTEGER,
pct012g079_2000 INTEGER,
pct012g080 INTEGER,
pct012g080_2000 INTEGER,
pct012g081 INTEGER,
pct012g081_2000 INTEGER,
pct012g082 INTEGER,
pct012g082_2000 INTEGER,
pct012g083 INTEGER,
pct012g083_2000 INTEGER,
pct012g084 INTEGER,
pct012g084_2000 INTEGER,
pct012g085 INTEGER,
pct012g085_2000 INTEGER,
pct012g086 INTEGER,
pct012g086_2000 INTEGER,
pct012g087 INTEGER,
pct012g087_2000 INTEGER,
pct012g088 INTEGER,
pct012g088_2000 INTEGER,
pct012g089 INTEGER,
pct012g089_2000 INTEGER,
pct012g090 INTEGER,
pct012g090_2000 INTEGER,
pct012g091 INTEGER,
pct012g091_2000 INTEGER,
pct012g092 INTEGER,
pct012g092_2000 INTEGER,
pct012g093 INTEGER,
pct012g093_2000 INTEGER,
pct012g094 INTEGER,
pct012g094_2000 INTEGER,
pct012g095 INTEGER,
pct012g095_2000 INTEGER,
pct012g096 INTEGER,
pct012g096_2000 INTEGER,
pct012g097 INTEGER,
pct012g097_2000 INTEGER,
pct012g098 INTEGER,
pct012g098_2000 INTEGER,
pct012g099 INTEGER,
pct012g099_2000 INTEGER,
pct012g100 INTEGER,
pct012g100_2000 INTEGER,
pct012g101 INTEGER,
pct012g101_2000 INTEGER,
pct012g102 INTEGER,
pct012g102_2000 INTEGER,
pct012g103 INTEGER,
pct012g103_2000 INTEGER,
pct012g104 INTEGER,
pct012g104_2000 INTEGER,
pct012g105 INTEGER,
pct012g105_2000 INTEGER,
pct012g106 INTEGER,
pct012g106_2000 INTEGER,
pct012g107 INTEGER,
pct012g107_2000 INTEGER,
pct012g108 INTEGER,
pct012g108_2000 INTEGER,
pct012g109 INTEGER,
pct012g109_2000 INTEGER,
pct012g110 INTEGER,
pct012g110_2000 INTEGER,
pct012g111 INTEGER,
pct012g111_2000 INTEGER,
pct012g112 INTEGER,
pct012g112_2000 INTEGER,
pct012g113 INTEGER,
pct012g113_2000 INTEGER,
pct012g114 INTEGER,
pct012g114_2000 INTEGER,
pct012g115 INTEGER,
pct012g115_2000 INTEGER,
pct012g116 INTEGER,
pct012g116_2000 INTEGER,
pct012g117 INTEGER,
pct012g117_2000 INTEGER,
pct012g118 INTEGER,
pct012g118_2000 INTEGER,
pct012g119 INTEGER,
pct012g119_2000 INTEGER,
pct012g120 INTEGER,
pct012g120_2000 INTEGER,
pct012g121 INTEGER,
pct012g121_2000 INTEGER,
pct012g122 INTEGER,
pct012g122_2000 INTEGER,
pct012g123 INTEGER,
pct012g123_2000 INTEGER,
pct012g124 INTEGER,
pct012g124_2000 INTEGER,
pct012g125 INTEGER,
pct012g125_2000 INTEGER,
pct012g126 INTEGER,
pct012g126_2000 INTEGER,
pct012g127 INTEGER,
pct012g127_2000 INTEGER,
pct012g128 INTEGER,
pct012g128_2000 INTEGER,
pct012g129 INTEGER,
pct012g129_2000 INTEGER,
pct012g130 INTEGER,
pct012g130_2000 INTEGER,
pct012g131 INTEGER,
pct012g131_2000 INTEGER,
pct012g132 INTEGER,
pct012g132_2000 INTEGER,
pct012g133 INTEGER,
pct012g133_2000 INTEGER,
pct012g134 INTEGER,
pct012g134_2000 INTEGER,
pct012g135 INTEGER,
pct012g135_2000 INTEGER,
pct012g136 INTEGER,
pct012g136_2000 INTEGER,
pct012g137 INTEGER,
pct012g137_2000 INTEGER,
pct012g138 INTEGER,
pct012g138_2000 INTEGER,
pct012g139 INTEGER,
pct012g139_2000 INTEGER,
pct012g140 INTEGER,
pct012g140_2000 INTEGER,
pct012g141 INTEGER,
pct012g141_2000 INTEGER,
pct012g142 INTEGER,
pct012g142_2000 INTEGER,
pct012g143 INTEGER,
pct012g143_2000 INTEGER,
pct012g144 INTEGER,
pct012g144_2000 INTEGER,
pct012g145 INTEGER,
pct012g145_2000 INTEGER,
pct012g146 INTEGER,
pct012g146_2000 INTEGER,
pct012g147 INTEGER,
pct012g147_2000 INTEGER,
pct012g148 INTEGER,
pct012g148_2000 INTEGER,
pct012g149 INTEGER,
pct012g149_2000 INTEGER,
pct012g150 INTEGER,
pct012g150_2000 INTEGER,
pct012g151 INTEGER,
pct012g151_2000 INTEGER,
pct012g152 INTEGER,
pct012g152_2000 INTEGER,
pct012g153 INTEGER,
pct012g153_2000 INTEGER,
pct012g154 INTEGER,
pct012g154_2000 INTEGER,
pct012g155 INTEGER,
pct012g155_2000 INTEGER,
pct012g156 INTEGER,
pct012g156_2000 INTEGER,
pct012g157 INTEGER,
pct012g157_2000 INTEGER,
pct012g158 INTEGER,
pct012g158_2000 INTEGER,
pct012g159 INTEGER,
pct012g159_2000 INTEGER,
pct012g160 INTEGER,
pct012g160_2000 INTEGER,
pct012g161 INTEGER,
pct012g161_2000 INTEGER,
pct012g162 INTEGER,
pct012g162_2000 INTEGER,
pct012g163 INTEGER,
pct012g163_2000 INTEGER,
pct012g164 INTEGER,
pct012g164_2000 INTEGER,
pct012g165 INTEGER,
pct012g165_2000 INTEGER,
pct012g166 INTEGER,
pct012g166_2000 INTEGER,
pct012g167 INTEGER,
pct012g167_2000 INTEGER,
pct012g168 INTEGER,
pct012g168_2000 INTEGER,
pct012g169 INTEGER,
pct012g169_2000 INTEGER,
pct012g170 INTEGER,
pct012g170_2000 INTEGER,
pct012g171 INTEGER,
pct012g171_2000 INTEGER,
pct012g172 INTEGER,
pct012g172_2000 INTEGER,
pct012g173 INTEGER,
pct012g173_2000 INTEGER,
pct012g174 INTEGER,
pct012g174_2000 INTEGER,
pct012g175 INTEGER,
pct012g175_2000 INTEGER,
pct012g176 INTEGER,
pct012g176_2000 INTEGER,
pct012g177 INTEGER,
pct012g177_2000 INTEGER,
pct012g178 INTEGER,
pct012g178_2000 INTEGER,
pct012g179 INTEGER,
pct012g179_2000 INTEGER,
pct012g180 INTEGER,
pct012g180_2000 INTEGER,
pct012g181 INTEGER,
pct012g181_2000 INTEGER,
pct012g182 INTEGER,
pct012g182_2000 INTEGER,
pct012g183 INTEGER,
pct012g183_2000 INTEGER,
pct012g184 INTEGER,
pct012g184_2000 INTEGER,
pct012g185 INTEGER,
pct012g185_2000 INTEGER,
pct012g186 INTEGER,
pct012g186_2000 INTEGER,
pct012g187 INTEGER,
pct012g187_2000 INTEGER,
pct012g188 INTEGER,
pct012g188_2000 INTEGER,
pct012g189 INTEGER,
pct012g189_2000 INTEGER,
pct012g190 INTEGER,
pct012g190_2000 INTEGER,
pct012g191 INTEGER,
pct012g191_2000 INTEGER,
pct012g192 INTEGER,
pct012g192_2000 INTEGER,
pct012g193 INTEGER,
pct012g193_2000 INTEGER,
pct012g194 INTEGER,
pct012g194_2000 INTEGER,
pct012g195 INTEGER,
pct012g195_2000 INTEGER,
pct012g196 INTEGER,
pct012g196_2000 INTEGER,
pct012g197 INTEGER,
pct012g197_2000 INTEGER,
pct012g198 INTEGER,
pct012g198_2000 INTEGER,
pct012g199 INTEGER,
pct012g199_2000 INTEGER,
pct012g200 INTEGER,
pct012g200_2000 INTEGER,
pct012g201 INTEGER,
pct012g201_2000 INTEGER,
pct012g202 INTEGER,
pct012g202_2000 INTEGER,
pct012g203 INTEGER,
pct012g203_2000 INTEGER,
pct012g204 INTEGER,
pct012g204_2000 INTEGER,
pct012g205 INTEGER,
pct012g205_2000 INTEGER,
pct012g206 INTEGER,
pct012g206_2000 INTEGER,
pct012g207 INTEGER,
pct012g207_2000 INTEGER,
pct012g208 INTEGER,
pct012g208_2000 INTEGER,
pct012g209 INTEGER,
pct012g209_2000 INTEGER,