Skip to content


Subversion checkout URL

You can clone with
Download ZIP
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_pct12j (
county VARCHAR(3),
cbsa VARCHAR(5),
csa VARCHAR(3),
necta VARCHAR(5),
cnecta VARCHAR(3),
pop100_2000 INTEGER,
hu100_2000 INTEGER,
pct012j001 INTEGER,
pct012j001_2000 INTEGER,
pct012j002 INTEGER,
pct012j002_2000 INTEGER,
pct012j003 INTEGER,
pct012j003_2000 INTEGER,
pct012j004 INTEGER,
pct012j004_2000 INTEGER,
pct012j005 INTEGER,
pct012j005_2000 INTEGER,
pct012j006 INTEGER,
pct012j006_2000 INTEGER,
pct012j007 INTEGER,
pct012j007_2000 INTEGER,
pct012j008 INTEGER,
pct012j008_2000 INTEGER,
pct012j009 INTEGER,
pct012j009_2000 INTEGER,
pct012j010 INTEGER,
pct012j010_2000 INTEGER,
pct012j011 INTEGER,
pct012j011_2000 INTEGER,
pct012j012 INTEGER,
pct012j012_2000 INTEGER,
pct012j013 INTEGER,
pct012j013_2000 INTEGER,
pct012j014 INTEGER,
pct012j014_2000 INTEGER,
pct012j015 INTEGER,
pct012j015_2000 INTEGER,
pct012j016 INTEGER,
pct012j016_2000 INTEGER,
pct012j017 INTEGER,
pct012j017_2000 INTEGER,
pct012j018 INTEGER,
pct012j018_2000 INTEGER,
pct012j019 INTEGER,
pct012j019_2000 INTEGER,
pct012j020 INTEGER,
pct012j020_2000 INTEGER,
pct012j021 INTEGER,
pct012j021_2000 INTEGER,
pct012j022 INTEGER,
pct012j022_2000 INTEGER,
pct012j023 INTEGER,
pct012j023_2000 INTEGER,
pct012j024 INTEGER,
pct012j024_2000 INTEGER,
pct012j025 INTEGER,
pct012j025_2000 INTEGER,
pct012j026 INTEGER,
pct012j026_2000 INTEGER,
pct012j027 INTEGER,
pct012j027_2000 INTEGER,
pct012j028 INTEGER,
pct012j028_2000 INTEGER,
pct012j029 INTEGER,
pct012j029_2000 INTEGER,
pct012j030 INTEGER,
pct012j030_2000 INTEGER,
pct012j031 INTEGER,
pct012j031_2000 INTEGER,
pct012j032 INTEGER,
pct012j032_2000 INTEGER,
pct012j033 INTEGER,
pct012j033_2000 INTEGER,
pct012j034 INTEGER,
pct012j034_2000 INTEGER,
pct012j035 INTEGER,
pct012j035_2000 INTEGER,
pct012j036 INTEGER,
pct012j036_2000 INTEGER,
pct012j037 INTEGER,
pct012j037_2000 INTEGER,
pct012j038 INTEGER,
pct012j038_2000 INTEGER,
pct012j039 INTEGER,
pct012j039_2000 INTEGER,
pct012j040 INTEGER,
pct012j040_2000 INTEGER,
pct012j041 INTEGER,
pct012j041_2000 INTEGER,
pct012j042 INTEGER,
pct012j042_2000 INTEGER,
pct012j043 INTEGER,
pct012j043_2000 INTEGER,
pct012j044 INTEGER,
pct012j044_2000 INTEGER,
pct012j045 INTEGER,
pct012j045_2000 INTEGER,
pct012j046 INTEGER,
pct012j046_2000 INTEGER,
pct012j047 INTEGER,
pct012j047_2000 INTEGER,
pct012j048 INTEGER,
pct012j048_2000 INTEGER,
pct012j049 INTEGER,
pct012j049_2000 INTEGER,
pct012j050 INTEGER,
pct012j050_2000 INTEGER,
pct012j051 INTEGER,
pct012j051_2000 INTEGER,
pct012j052 INTEGER,
pct012j052_2000 INTEGER,
pct012j053 INTEGER,
pct012j053_2000 INTEGER,
pct012j054 INTEGER,
pct012j054_2000 INTEGER,
pct012j055 INTEGER,
pct012j055_2000 INTEGER,
pct012j056 INTEGER,
pct012j056_2000 INTEGER,
pct012j057 INTEGER,
pct012j057_2000 INTEGER,
pct012j058 INTEGER,
pct012j058_2000 INTEGER,
pct012j059 INTEGER,
pct012j059_2000 INTEGER,
pct012j060 INTEGER,
pct012j060_2000 INTEGER,
pct012j061 INTEGER,
pct012j061_2000 INTEGER,
pct012j062 INTEGER,
pct012j062_2000 INTEGER,
pct012j063 INTEGER,
pct012j063_2000 INTEGER,
pct012j064 INTEGER,
pct012j064_2000 INTEGER,
pct012j065 INTEGER,
pct012j065_2000 INTEGER,
pct012j066 INTEGER,
pct012j066_2000 INTEGER,
pct012j067 INTEGER,
pct012j067_2000 INTEGER,
pct012j068 INTEGER,
pct012j068_2000 INTEGER,
pct012j069 INTEGER,
pct012j069_2000 INTEGER,
pct012j070 INTEGER,
pct012j070_2000 INTEGER,
pct012j071 INTEGER,
pct012j071_2000 INTEGER,
pct012j072 INTEGER,
pct012j072_2000 INTEGER,
pct012j073 INTEGER,
pct012j073_2000 INTEGER,
pct012j074 INTEGER,
pct012j074_2000 INTEGER,
pct012j075 INTEGER,
pct012j075_2000 INTEGER,
pct012j076 INTEGER,
pct012j076_2000 INTEGER,
pct012j077 INTEGER,
pct012j077_2000 INTEGER,
pct012j078 INTEGER,
pct012j078_2000 INTEGER,
pct012j079 INTEGER,
pct012j079_2000 INTEGER,
pct012j080 INTEGER,
pct012j080_2000 INTEGER,
pct012j081 INTEGER,
pct012j081_2000 INTEGER,
pct012j082 INTEGER,
pct012j082_2000 INTEGER,
pct012j083 INTEGER,
pct012j083_2000 INTEGER,
pct012j084 INTEGER,
pct012j084_2000 INTEGER,
pct012j085 INTEGER,
pct012j085_2000 INTEGER,
pct012j086 INTEGER,
pct012j086_2000 INTEGER,
pct012j087 INTEGER,
pct012j087_2000 INTEGER,
pct012j088 INTEGER,
pct012j088_2000 INTEGER,
pct012j089 INTEGER,
pct012j089_2000 INTEGER,
pct012j090 INTEGER,
pct012j090_2000 INTEGER,
pct012j091 INTEGER,
pct012j091_2000 INTEGER,
pct012j092 INTEGER,
pct012j092_2000 INTEGER,
pct012j093 INTEGER,
pct012j093_2000 INTEGER,
pct012j094 INTEGER,
pct012j094_2000 INTEGER,
pct012j095 INTEGER,
pct012j095_2000 INTEGER,
pct012j096 INTEGER,
pct012j096_2000 INTEGER,
pct012j097 INTEGER,
pct012j097_2000 INTEGER,
pct012j098 INTEGER,
pct012j098_2000 INTEGER,
pct012j099 INTEGER,
pct012j099_2000 INTEGER,
pct012j100 INTEGER,
pct012j100_2000 INTEGER,
pct012j101 INTEGER,
pct012j101_2000 INTEGER,
pct012j102 INTEGER,
pct012j102_2000 INTEGER,
pct012j103 INTEGER,
pct012j103_2000 INTEGER,
pct012j104 INTEGER,
pct012j104_2000 INTEGER,
pct012j105 INTEGER,
pct012j105_2000 INTEGER,
pct012j106 INTEGER,
pct012j106_2000 INTEGER,
pct012j107 INTEGER,
pct012j107_2000 INTEGER,
pct012j108 INTEGER,
pct012j108_2000 INTEGER,
pct012j109 INTEGER,
pct012j109_2000 INTEGER,
pct012j110 INTEGER,
pct012j110_2000 INTEGER,
pct012j111 INTEGER,
pct012j111_2000 INTEGER,
pct012j112 INTEGER,
pct012j112_2000 INTEGER,
pct012j113 INTEGER,
pct012j113_2000 INTEGER,
pct012j114 INTEGER,
pct012j114_2000 INTEGER,
pct012j115 INTEGER,
pct012j115_2000 INTEGER,
pct012j116 INTEGER,
pct012j116_2000 INTEGER,
pct012j117 INTEGER,
pct012j117_2000 INTEGER,
pct012j118 INTEGER,
pct012j118_2000 INTEGER,
pct012j119 INTEGER,
pct012j119_2000 INTEGER,
pct012j120 INTEGER,
pct012j120_2000 INTEGER,
pct012j121 INTEGER,
pct012j121_2000 INTEGER,
pct012j122 INTEGER,
pct012j122_2000 INTEGER,
pct012j123 INTEGER,
pct012j123_2000 INTEGER,
pct012j124 INTEGER,
pct012j124_2000 INTEGER,
pct012j125 INTEGER,
pct012j125_2000 INTEGER,
pct012j126 INTEGER,
pct012j126_2000 INTEGER,
pct012j127 INTEGER,
pct012j127_2000 INTEGER,
pct012j128 INTEGER,
pct012j128_2000 INTEGER,
pct012j129 INTEGER,
pct012j129_2000 INTEGER,
pct012j130 INTEGER,
pct012j130_2000 INTEGER,
pct012j131 INTEGER,
pct012j131_2000 INTEGER,
pct012j132 INTEGER,
pct012j132_2000 INTEGER,
pct012j133 INTEGER,
pct012j133_2000 INTEGER,
pct012j134 INTEGER,
pct012j134_2000 INTEGER,
pct012j135 INTEGER,
pct012j135_2000 INTEGER,
pct012j136 INTEGER,
pct012j136_2000 INTEGER,
pct012j137 INTEGER,
pct012j137_2000 INTEGER,
pct012j138 INTEGER,
pct012j138_2000 INTEGER,
pct012j139 INTEGER,
pct012j139_2000 INTEGER,
pct012j140 INTEGER,
pct012j140_2000 INTEGER,
pct012j141 INTEGER,
pct012j141_2000 INTEGER,
pct012j142 INTEGER,
pct012j142_2000 INTEGER,
pct012j143 INTEGER,
pct012j143_2000 INTEGER,
pct012j144 INTEGER,
pct012j144_2000 INTEGER,
pct012j145 INTEGER,
pct012j145_2000 INTEGER,
pct012j146 INTEGER,
pct012j146_2000 INTEGER,
pct012j147 INTEGER,
pct012j147_2000 INTEGER,
pct012j148 INTEGER,
pct012j148_2000 INTEGER,
pct012j149 INTEGER,
pct012j149_2000 INTEGER,
pct012j150 INTEGER,
pct012j150_2000 INTEGER,
pct012j151 INTEGER,
pct012j151_2000 INTEGER,
pct012j152 INTEGER,
pct012j152_2000 INTEGER,
pct012j153 INTEGER,
pct012j153_2000 INTEGER,
pct012j154 INTEGER,
pct012j154_2000 INTEGER,
pct012j155 INTEGER,
pct012j155_2000 INTEGER,
pct012j156 INTEGER,
pct012j156_2000 INTEGER,
pct012j157 INTEGER,
pct012j157_2000 INTEGER,
pct012j158 INTEGER,
pct012j158_2000 INTEGER,
pct012j159 INTEGER,
pct012j159_2000 INTEGER,
pct012j160 INTEGER,
pct012j160_2000 INTEGER,
pct012j161 INTEGER,
pct012j161_2000 INTEGER,
pct012j162 INTEGER,
pct012j162_2000 INTEGER,
pct012j163 INTEGER,
pct012j163_2000 INTEGER,
pct012j164 INTEGER,
pct012j164_2000 INTEGER,
pct012j165 INTEGER,
pct012j165_2000 INTEGER,
pct012j166 INTEGER,
pct012j166_2000 INTEGER,
pct012j167 INTEGER,
pct012j167_2000 INTEGER,
pct012j168 INTEGER,
pct012j168_2000 INTEGER,
pct012j169 INTEGER,
pct012j169_2000 INTEGER,
pct012j170 INTEGER,
pct012j170_2000 INTEGER,
pct012j171 INTEGER,
pct012j171_2000 INTEGER,
pct012j172 INTEGER,
pct012j172_2000 INTEGER,
pct012j173 INTEGER,
pct012j173_2000 INTEGER,
pct012j174 INTEGER,
pct012j174_2000 INTEGER,
pct012j175 INTEGER,
pct012j175_2000 INTEGER,
pct012j176 INTEGER,
pct012j176_2000 INTEGER,
pct012j177 INTEGER,
pct012j177_2000 INTEGER,
pct012j178 INTEGER,
pct012j178_2000 INTEGER,
pct012j179 INTEGER,
pct012j179_2000 INTEGER,
pct012j180 INTEGER,
pct012j180_2000 INTEGER,
pct012j181 INTEGER,
pct012j181_2000 INTEGER,
pct012j182 INTEGER,
pct012j182_2000 INTEGER,
pct012j183 INTEGER,
pct012j183_2000 INTEGER,
pct012j184 INTEGER,
pct012j184_2000 INTEGER,
pct012j185 INTEGER,
pct012j185_2000 INTEGER,
pct012j186 INTEGER,
pct012j186_2000 INTEGER,
pct012j187 INTEGER,
pct012j187_2000 INTEGER,
pct012j188 INTEGER,
pct012j188_2000 INTEGER,
pct012j189 INTEGER,
pct012j189_2000 INTEGER,
pct012j190 INTEGER,
pct012j190_2000 INTEGER,
pct012j191 INTEGER,
pct012j191_2000 INTEGER,
pct012j192 INTEGER,
pct012j192_2000 INTEGER,
pct012j193 INTEGER,
pct012j193_2000 INTEGER,
pct012j194 INTEGER,
pct012j194_2000 INTEGER,
pct012j195 INTEGER,
pct012j195_2000 INTEGER,
pct012j196 INTEGER,
pct012j196_2000 INTEGER,
pct012j197 INTEGER,
pct012j197_2000 INTEGER,
pct012j198 INTEGER,
pct012j198_2000 INTEGER,
pct012j199 INTEGER,
pct012j199_2000 INTEGER,
pct012j200 INTEGER,
pct012j200_2000 INTEGER,
pct012j201 INTEGER,
pct012j201_2000 INTEGER,
pct012j202 INTEGER,
pct012j202_2000 INTEGER,
pct012j203 INTEGER,
pct012j203_2000 INTEGER,
pct012j204 INTEGER,
pct012j204_2000 INTEGER,
pct012j205 INTEGER,
pct012j205_2000 INTEGER,
pct012j206 INTEGER,
pct012j206_2000 INTEGER,
pct012j207 INTEGER,
pct012j207_2000 INTEGER,
pct012j208 INTEGER,
pct012j208_2000 INTEGER,
pct012j209 INTEGER,
pct012j209_2000 INTEGER,
Jump to Line
Something went wrong with that request. Please try again.