Skip to content
Find file
Fetching contributors…
Cannot retrieve contributors at this time
438 lines (437 sloc) 10.1 KB
-- designed to work with the IRE Census bulk data exports
-- see
CREATE TABLE ire_pct12 (
county VARCHAR(3),
cbsa VARCHAR(5),
csa VARCHAR(3),
necta VARCHAR(5),
cnecta VARCHAR(3),
pop100_2000 INTEGER,
hu100_2000 INTEGER,
pct012001 INTEGER,
pct012001_2000 INTEGER,
pct012002 INTEGER,
pct012002_2000 INTEGER,
pct012003 INTEGER,
pct012003_2000 INTEGER,
pct012004 INTEGER,
pct012004_2000 INTEGER,
pct012005 INTEGER,
pct012005_2000 INTEGER,
pct012006 INTEGER,
pct012006_2000 INTEGER,
pct012007 INTEGER,
pct012007_2000 INTEGER,
pct012008 INTEGER,
pct012008_2000 INTEGER,
pct012009 INTEGER,
pct012009_2000 INTEGER,
pct012010 INTEGER,
pct012010_2000 INTEGER,
pct012011 INTEGER,
pct012011_2000 INTEGER,
pct012012 INTEGER,
pct012012_2000 INTEGER,
pct012013 INTEGER,
pct012013_2000 INTEGER,
pct012014 INTEGER,
pct012014_2000 INTEGER,
pct012015 INTEGER,
pct012015_2000 INTEGER,
pct012016 INTEGER,
pct012016_2000 INTEGER,
pct012017 INTEGER,
pct012017_2000 INTEGER,
pct012018 INTEGER,
pct012018_2000 INTEGER,
pct012019 INTEGER,
pct012019_2000 INTEGER,
pct012020 INTEGER,
pct012020_2000 INTEGER,
pct012021 INTEGER,
pct012021_2000 INTEGER,
pct012022 INTEGER,
pct012022_2000 INTEGER,
pct012023 INTEGER,
pct012023_2000 INTEGER,
pct012024 INTEGER,
pct012024_2000 INTEGER,
pct012025 INTEGER,
pct012025_2000 INTEGER,
pct012026 INTEGER,
pct012026_2000 INTEGER,
pct012027 INTEGER,
pct012027_2000 INTEGER,
pct012028 INTEGER,
pct012028_2000 INTEGER,
pct012029 INTEGER,
pct012029_2000 INTEGER,
pct012030 INTEGER,
pct012030_2000 INTEGER,
pct012031 INTEGER,
pct012031_2000 INTEGER,
pct012032 INTEGER,
pct012032_2000 INTEGER,
pct012033 INTEGER,
pct012033_2000 INTEGER,
pct012034 INTEGER,
pct012034_2000 INTEGER,
pct012035 INTEGER,
pct012035_2000 INTEGER,
pct012036 INTEGER,
pct012036_2000 INTEGER,
pct012037 INTEGER,
pct012037_2000 INTEGER,
pct012038 INTEGER,
pct012038_2000 INTEGER,
pct012039 INTEGER,
pct012039_2000 INTEGER,
pct012040 INTEGER,
pct012040_2000 INTEGER,
pct012041 INTEGER,
pct012041_2000 INTEGER,
pct012042 INTEGER,
pct012042_2000 INTEGER,
pct012043 INTEGER,
pct012043_2000 INTEGER,
pct012044 INTEGER,
pct012044_2000 INTEGER,
pct012045 INTEGER,
pct012045_2000 INTEGER,
pct012046 INTEGER,
pct012046_2000 INTEGER,
pct012047 INTEGER,
pct012047_2000 INTEGER,
pct012048 INTEGER,
pct012048_2000 INTEGER,
pct012049 INTEGER,
pct012049_2000 INTEGER,
pct012050 INTEGER,
pct012050_2000 INTEGER,
pct012051 INTEGER,
pct012051_2000 INTEGER,
pct012052 INTEGER,
pct012052_2000 INTEGER,
pct012053 INTEGER,
pct012053_2000 INTEGER,
pct012054 INTEGER,
pct012054_2000 INTEGER,
pct012055 INTEGER,
pct012055_2000 INTEGER,
pct012056 INTEGER,
pct012056_2000 INTEGER,
pct012057 INTEGER,
pct012057_2000 INTEGER,
pct012058 INTEGER,
pct012058_2000 INTEGER,
pct012059 INTEGER,
pct012059_2000 INTEGER,
pct012060 INTEGER,
pct012060_2000 INTEGER,
pct012061 INTEGER,
pct012061_2000 INTEGER,
pct012062 INTEGER,
pct012062_2000 INTEGER,
pct012063 INTEGER,
pct012063_2000 INTEGER,
pct012064 INTEGER,
pct012064_2000 INTEGER,
pct012065 INTEGER,
pct012065_2000 INTEGER,
pct012066 INTEGER,
pct012066_2000 INTEGER,
pct012067 INTEGER,
pct012067_2000 INTEGER,
pct012068 INTEGER,
pct012068_2000 INTEGER,
pct012069 INTEGER,
pct012069_2000 INTEGER,
pct012070 INTEGER,
pct012070_2000 INTEGER,
pct012071 INTEGER,
pct012071_2000 INTEGER,
pct012072 INTEGER,
pct012072_2000 INTEGER,
pct012073 INTEGER,
pct012073_2000 INTEGER,
pct012074 INTEGER,
pct012074_2000 INTEGER,
pct012075 INTEGER,
pct012075_2000 INTEGER,
pct012076 INTEGER,
pct012076_2000 INTEGER,
pct012077 INTEGER,
pct012077_2000 INTEGER,
pct012078 INTEGER,
pct012078_2000 INTEGER,
pct012079 INTEGER,
pct012079_2000 INTEGER,
pct012080 INTEGER,
pct012080_2000 INTEGER,
pct012081 INTEGER,
pct012081_2000 INTEGER,
pct012082 INTEGER,
pct012082_2000 INTEGER,
pct012083 INTEGER,
pct012083_2000 INTEGER,
pct012084 INTEGER,
pct012084_2000 INTEGER,
pct012085 INTEGER,
pct012085_2000 INTEGER,
pct012086 INTEGER,
pct012086_2000 INTEGER,
pct012087 INTEGER,
pct012087_2000 INTEGER,
pct012088 INTEGER,
pct012088_2000 INTEGER,
pct012089 INTEGER,
pct012089_2000 INTEGER,
pct012090 INTEGER,
pct012090_2000 INTEGER,
pct012091 INTEGER,
pct012091_2000 INTEGER,
pct012092 INTEGER,
pct012092_2000 INTEGER,
pct012093 INTEGER,
pct012093_2000 INTEGER,
pct012094 INTEGER,
pct012094_2000 INTEGER,
pct012095 INTEGER,
pct012095_2000 INTEGER,
pct012096 INTEGER,
pct012096_2000 INTEGER,
pct012097 INTEGER,
pct012097_2000 INTEGER,
pct012098 INTEGER,
pct012098_2000 INTEGER,
pct012099 INTEGER,
pct012099_2000 INTEGER,
pct012100 INTEGER,
pct012100_2000 INTEGER,
pct012101 INTEGER,
pct012101_2000 INTEGER,
pct012102 INTEGER,
pct012102_2000 INTEGER,
pct012103 INTEGER,
pct012103_2000 INTEGER,
pct012104 INTEGER,
pct012104_2000 INTEGER,
pct012105 INTEGER,
pct012105_2000 INTEGER,
pct012106 INTEGER,
pct012106_2000 INTEGER,
pct012107 INTEGER,
pct012107_2000 INTEGER,
pct012108 INTEGER,
pct012108_2000 INTEGER,
pct012109 INTEGER,
pct012109_2000 INTEGER,
pct012110 INTEGER,
pct012110_2000 INTEGER,
pct012111 INTEGER,
pct012111_2000 INTEGER,
pct012112 INTEGER,
pct012112_2000 INTEGER,
pct012113 INTEGER,
pct012113_2000 INTEGER,
pct012114 INTEGER,
pct012114_2000 INTEGER,
pct012115 INTEGER,
pct012115_2000 INTEGER,
pct012116 INTEGER,
pct012116_2000 INTEGER,
pct012117 INTEGER,
pct012117_2000 INTEGER,
pct012118 INTEGER,
pct012118_2000 INTEGER,
pct012119 INTEGER,
pct012119_2000 INTEGER,
pct012120 INTEGER,
pct012120_2000 INTEGER,
pct012121 INTEGER,
pct012121_2000 INTEGER,
pct012122 INTEGER,
pct012122_2000 INTEGER,
pct012123 INTEGER,
pct012123_2000 INTEGER,
pct012124 INTEGER,
pct012124_2000 INTEGER,
pct012125 INTEGER,
pct012125_2000 INTEGER,
pct012126 INTEGER,
pct012126_2000 INTEGER,
pct012127 INTEGER,
pct012127_2000 INTEGER,
pct012128 INTEGER,
pct012128_2000 INTEGER,
pct012129 INTEGER,
pct012129_2000 INTEGER,
pct012130 INTEGER,
pct012130_2000 INTEGER,
pct012131 INTEGER,
pct012131_2000 INTEGER,
pct012132 INTEGER,
pct012132_2000 INTEGER,
pct012133 INTEGER,
pct012133_2000 INTEGER,
pct012134 INTEGER,
pct012134_2000 INTEGER,
pct012135 INTEGER,
pct012135_2000 INTEGER,
pct012136 INTEGER,
pct012136_2000 INTEGER,
pct012137 INTEGER,
pct012137_2000 INTEGER,
pct012138 INTEGER,
pct012138_2000 INTEGER,
pct012139 INTEGER,
pct012139_2000 INTEGER,
pct012140 INTEGER,
pct012140_2000 INTEGER,
pct012141 INTEGER,
pct012141_2000 INTEGER,
pct012142 INTEGER,
pct012142_2000 INTEGER,
pct012143 INTEGER,
pct012143_2000 INTEGER,
pct012144 INTEGER,
pct012144_2000 INTEGER,
pct012145 INTEGER,
pct012145_2000 INTEGER,
pct012146 INTEGER,
pct012146_2000 INTEGER,
pct012147 INTEGER,
pct012147_2000 INTEGER,
pct012148 INTEGER,
pct012148_2000 INTEGER,
pct012149 INTEGER,
pct012149_2000 INTEGER,
pct012150 INTEGER,
pct012150_2000 INTEGER,
pct012151 INTEGER,
pct012151_2000 INTEGER,
pct012152 INTEGER,
pct012152_2000 INTEGER,
pct012153 INTEGER,
pct012153_2000 INTEGER,
pct012154 INTEGER,
pct012154_2000 INTEGER,
pct012155 INTEGER,
pct012155_2000 INTEGER,
pct012156 INTEGER,
pct012156_2000 INTEGER,
pct012157 INTEGER,
pct012157_2000 INTEGER,
pct012158 INTEGER,
pct012158_2000 INTEGER,
pct012159 INTEGER,
pct012159_2000 INTEGER,
pct012160 INTEGER,
pct012160_2000 INTEGER,
pct012161 INTEGER,
pct012161_2000 INTEGER,
pct012162 INTEGER,
pct012162_2000 INTEGER,
pct012163 INTEGER,
pct012163_2000 INTEGER,
pct012164 INTEGER,
pct012164_2000 INTEGER,
pct012165 INTEGER,
pct012165_2000 INTEGER,
pct012166 INTEGER,
pct012166_2000 INTEGER,
pct012167 INTEGER,
pct012167_2000 INTEGER,
pct012168 INTEGER,
pct012168_2000 INTEGER,
pct012169 INTEGER,
pct012169_2000 INTEGER,
pct012170 INTEGER,
pct012170_2000 INTEGER,
pct012171 INTEGER,
pct012171_2000 INTEGER,
pct012172 INTEGER,
pct012172_2000 INTEGER,
pct012173 INTEGER,
pct012173_2000 INTEGER,
pct012174 INTEGER,
pct012174_2000 INTEGER,
pct012175 INTEGER,
pct012175_2000 INTEGER,
pct012176 INTEGER,
pct012176_2000 INTEGER,
pct012177 INTEGER,
pct012177_2000 INTEGER,
pct012178 INTEGER,
pct012178_2000 INTEGER,
pct012179 INTEGER,
pct012179_2000 INTEGER,
pct012180 INTEGER,
pct012180_2000 INTEGER,
pct012181 INTEGER,
pct012181_2000 INTEGER,
pct012182 INTEGER,
pct012182_2000 INTEGER,
pct012183 INTEGER,
pct012183_2000 INTEGER,
pct012184 INTEGER,
pct012184_2000 INTEGER,
pct012185 INTEGER,
pct012185_2000 INTEGER,
pct012186 INTEGER,
pct012186_2000 INTEGER,
pct012187 INTEGER,
pct012187_2000 INTEGER,
pct012188 INTEGER,
pct012188_2000 INTEGER,
pct012189 INTEGER,
pct012189_2000 INTEGER,
pct012190 INTEGER,
pct012190_2000 INTEGER,
pct012191 INTEGER,
pct012191_2000 INTEGER,
pct012192 INTEGER,
pct012192_2000 INTEGER,
pct012193 INTEGER,
pct012193_2000 INTEGER,
pct012194 INTEGER,
pct012194_2000 INTEGER,
pct012195 INTEGER,
pct012195_2000 INTEGER,
pct012196 INTEGER,
pct012196_2000 INTEGER,
pct012197 INTEGER,
pct012197_2000 INTEGER,
pct012198 INTEGER,
pct012198_2000 INTEGER,
pct012199 INTEGER,
pct012199_2000 INTEGER,
pct012200 INTEGER,
pct012200_2000 INTEGER,
pct012201 INTEGER,
pct012201_2000 INTEGER,
pct012202 INTEGER,
pct012202_2000 INTEGER,
pct012203 INTEGER,
pct012203_2000 INTEGER,
pct012204 INTEGER,
pct012204_2000 INTEGER,
pct012205 INTEGER,
pct012205_2000 INTEGER,
pct012206 INTEGER,
pct012206_2000 INTEGER,
pct012207 INTEGER,
pct012207_2000 INTEGER,
pct012208 INTEGER,
pct012208_2000 INTEGER,
pct012209 INTEGER,
pct012209_2000 INTEGER,
Something went wrong with that request. Please try again.