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_pct12o (
county VARCHAR(3),
cbsa VARCHAR(5),
csa VARCHAR(3),
necta VARCHAR(5),
cnecta VARCHAR(3),
pop100_2000 INTEGER,
hu100_2000 INTEGER,
pct012o001 INTEGER,
pct012o001_2000 INTEGER,
pct012o002 INTEGER,
pct012o002_2000 INTEGER,
pct012o003 INTEGER,
pct012o003_2000 INTEGER,
pct012o004 INTEGER,
pct012o004_2000 INTEGER,
pct012o005 INTEGER,
pct012o005_2000 INTEGER,
pct012o006 INTEGER,
pct012o006_2000 INTEGER,
pct012o007 INTEGER,
pct012o007_2000 INTEGER,
pct012o008 INTEGER,
pct012o008_2000 INTEGER,
pct012o009 INTEGER,
pct012o009_2000 INTEGER,
pct012o010 INTEGER,
pct012o010_2000 INTEGER,
pct012o011 INTEGER,
pct012o011_2000 INTEGER,
pct012o012 INTEGER,
pct012o012_2000 INTEGER,
pct012o013 INTEGER,
pct012o013_2000 INTEGER,
pct012o014 INTEGER,
pct012o014_2000 INTEGER,
pct012o015 INTEGER,
pct012o015_2000 INTEGER,
pct012o016 INTEGER,
pct012o016_2000 INTEGER,
pct012o017 INTEGER,
pct012o017_2000 INTEGER,
pct012o018 INTEGER,
pct012o018_2000 INTEGER,
pct012o019 INTEGER,
pct012o019_2000 INTEGER,
pct012o020 INTEGER,
pct012o020_2000 INTEGER,
pct012o021 INTEGER,
pct012o021_2000 INTEGER,
pct012o022 INTEGER,
pct012o022_2000 INTEGER,
pct012o023 INTEGER,
pct012o023_2000 INTEGER,
pct012o024 INTEGER,
pct012o024_2000 INTEGER,
pct012o025 INTEGER,
pct012o025_2000 INTEGER,
pct012o026 INTEGER,
pct012o026_2000 INTEGER,
pct012o027 INTEGER,
pct012o027_2000 INTEGER,
pct012o028 INTEGER,
pct012o028_2000 INTEGER,
pct012o029 INTEGER,
pct012o029_2000 INTEGER,
pct012o030 INTEGER,
pct012o030_2000 INTEGER,
pct012o031 INTEGER,
pct012o031_2000 INTEGER,
pct012o032 INTEGER,
pct012o032_2000 INTEGER,
pct012o033 INTEGER,
pct012o033_2000 INTEGER,
pct012o034 INTEGER,
pct012o034_2000 INTEGER,
pct012o035 INTEGER,
pct012o035_2000 INTEGER,
pct012o036 INTEGER,
pct012o036_2000 INTEGER,
pct012o037 INTEGER,
pct012o037_2000 INTEGER,
pct012o038 INTEGER,
pct012o038_2000 INTEGER,
pct012o039 INTEGER,
pct012o039_2000 INTEGER,
pct012o040 INTEGER,
pct012o040_2000 INTEGER,
pct012o041 INTEGER,
pct012o041_2000 INTEGER,
pct012o042 INTEGER,
pct012o042_2000 INTEGER,
pct012o043 INTEGER,
pct012o043_2000 INTEGER,
pct012o044 INTEGER,
pct012o044_2000 INTEGER,
pct012o045 INTEGER,
pct012o045_2000 INTEGER,
pct012o046 INTEGER,
pct012o046_2000 INTEGER,
pct012o047 INTEGER,
pct012o047_2000 INTEGER,
pct012o048 INTEGER,
pct012o048_2000 INTEGER,
pct012o049 INTEGER,
pct012o049_2000 INTEGER,
pct012o050 INTEGER,
pct012o050_2000 INTEGER,
pct012o051 INTEGER,
pct012o051_2000 INTEGER,
pct012o052 INTEGER,
pct012o052_2000 INTEGER,
pct012o053 INTEGER,
pct012o053_2000 INTEGER,
pct012o054 INTEGER,
pct012o054_2000 INTEGER,
pct012o055 INTEGER,
pct012o055_2000 INTEGER,
pct012o056 INTEGER,
pct012o056_2000 INTEGER,
pct012o057 INTEGER,
pct012o057_2000 INTEGER,
pct012o058 INTEGER,
pct012o058_2000 INTEGER,
pct012o059 INTEGER,
pct012o059_2000 INTEGER,
pct012o060 INTEGER,
pct012o060_2000 INTEGER,
pct012o061 INTEGER,
pct012o061_2000 INTEGER,
pct012o062 INTEGER,
pct012o062_2000 INTEGER,
pct012o063 INTEGER,
pct012o063_2000 INTEGER,
pct012o064 INTEGER,
pct012o064_2000 INTEGER,
pct012o065 INTEGER,
pct012o065_2000 INTEGER,
pct012o066 INTEGER,
pct012o066_2000 INTEGER,
pct012o067 INTEGER,
pct012o067_2000 INTEGER,
pct012o068 INTEGER,
pct012o068_2000 INTEGER,
pct012o069 INTEGER,
pct012o069_2000 INTEGER,
pct012o070 INTEGER,
pct012o070_2000 INTEGER,
pct012o071 INTEGER,
pct012o071_2000 INTEGER,
pct012o072 INTEGER,
pct012o072_2000 INTEGER,
pct012o073 INTEGER,
pct012o073_2000 INTEGER,
pct012o074 INTEGER,
pct012o074_2000 INTEGER,
pct012o075 INTEGER,
pct012o075_2000 INTEGER,
pct012o076 INTEGER,
pct012o076_2000 INTEGER,
pct012o077 INTEGER,
pct012o077_2000 INTEGER,
pct012o078 INTEGER,
pct012o078_2000 INTEGER,
pct012o079 INTEGER,
pct012o079_2000 INTEGER,
pct012o080 INTEGER,
pct012o080_2000 INTEGER,
pct012o081 INTEGER,
pct012o081_2000 INTEGER,
pct012o082 INTEGER,
pct012o082_2000 INTEGER,
pct012o083 INTEGER,
pct012o083_2000 INTEGER,
pct012o084 INTEGER,
pct012o084_2000 INTEGER,
pct012o085 INTEGER,
pct012o085_2000 INTEGER,
pct012o086 INTEGER,
pct012o086_2000 INTEGER,
pct012o087 INTEGER,
pct012o087_2000 INTEGER,
pct012o088 INTEGER,
pct012o088_2000 INTEGER,
pct012o089 INTEGER,
pct012o089_2000 INTEGER,
pct012o090 INTEGER,
pct012o090_2000 INTEGER,
pct012o091 INTEGER,
pct012o091_2000 INTEGER,
pct012o092 INTEGER,
pct012o092_2000 INTEGER,
pct012o093 INTEGER,
pct012o093_2000 INTEGER,
pct012o094 INTEGER,
pct012o094_2000 INTEGER,
pct012o095 INTEGER,
pct012o095_2000 INTEGER,
pct012o096 INTEGER,
pct012o096_2000 INTEGER,
pct012o097 INTEGER,
pct012o097_2000 INTEGER,
pct012o098 INTEGER,
pct012o098_2000 INTEGER,
pct012o099 INTEGER,
pct012o099_2000 INTEGER,
pct012o100 INTEGER,
pct012o100_2000 INTEGER,
pct012o101 INTEGER,
pct012o101_2000 INTEGER,
pct012o102 INTEGER,
pct012o102_2000 INTEGER,
pct012o103 INTEGER,
pct012o103_2000 INTEGER,
pct012o104 INTEGER,
pct012o104_2000 INTEGER,
pct012o105 INTEGER,
pct012o105_2000 INTEGER,
pct012o106 INTEGER,
pct012o106_2000 INTEGER,
pct012o107 INTEGER,
pct012o107_2000 INTEGER,
pct012o108 INTEGER,
pct012o108_2000 INTEGER,
pct012o109 INTEGER,
pct012o109_2000 INTEGER,
pct012o110 INTEGER,
pct012o110_2000 INTEGER,
pct012o111 INTEGER,
pct012o111_2000 INTEGER,
pct012o112 INTEGER,
pct012o112_2000 INTEGER,
pct012o113 INTEGER,
pct012o113_2000 INTEGER,
pct012o114 INTEGER,
pct012o114_2000 INTEGER,
pct012o115 INTEGER,
pct012o115_2000 INTEGER,
pct012o116 INTEGER,
pct012o116_2000 INTEGER,
pct012o117 INTEGER,
pct012o117_2000 INTEGER,
pct012o118 INTEGER,
pct012o118_2000 INTEGER,
pct012o119 INTEGER,
pct012o119_2000 INTEGER,
pct012o120 INTEGER,
pct012o120_2000 INTEGER,
pct012o121 INTEGER,
pct012o121_2000 INTEGER,
pct012o122 INTEGER,
pct012o122_2000 INTEGER,
pct012o123 INTEGER,
pct012o123_2000 INTEGER,
pct012o124 INTEGER,
pct012o124_2000 INTEGER,
pct012o125 INTEGER,
pct012o125_2000 INTEGER,
pct012o126 INTEGER,
pct012o126_2000 INTEGER,
pct012o127 INTEGER,
pct012o127_2000 INTEGER,
pct012o128 INTEGER,
pct012o128_2000 INTEGER,
pct012o129 INTEGER,
pct012o129_2000 INTEGER,
pct012o130 INTEGER,
pct012o130_2000 INTEGER,
pct012o131 INTEGER,
pct012o131_2000 INTEGER,
pct012o132 INTEGER,
pct012o132_2000 INTEGER,
pct012o133 INTEGER,
pct012o133_2000 INTEGER,
pct012o134 INTEGER,
pct012o134_2000 INTEGER,
pct012o135 INTEGER,
pct012o135_2000 INTEGER,
pct012o136 INTEGER,
pct012o136_2000 INTEGER,
pct012o137 INTEGER,
pct012o137_2000 INTEGER,
pct012o138 INTEGER,
pct012o138_2000 INTEGER,
pct012o139 INTEGER,
pct012o139_2000 INTEGER,
pct012o140 INTEGER,
pct012o140_2000 INTEGER,
pct012o141 INTEGER,
pct012o141_2000 INTEGER,
pct012o142 INTEGER,
pct012o142_2000 INTEGER,
pct012o143 INTEGER,
pct012o143_2000 INTEGER,
pct012o144 INTEGER,
pct012o144_2000 INTEGER,
pct012o145 INTEGER,
pct012o145_2000 INTEGER,
pct012o146 INTEGER,
pct012o146_2000 INTEGER,
pct012o147 INTEGER,
pct012o147_2000 INTEGER,
pct012o148 INTEGER,
pct012o148_2000 INTEGER,
pct012o149 INTEGER,
pct012o149_2000 INTEGER,
pct012o150 INTEGER,
pct012o150_2000 INTEGER,
pct012o151 INTEGER,
pct012o151_2000 INTEGER,
pct012o152 INTEGER,
pct012o152_2000 INTEGER,
pct012o153 INTEGER,
pct012o153_2000 INTEGER,
pct012o154 INTEGER,
pct012o154_2000 INTEGER,
pct012o155 INTEGER,
pct012o155_2000 INTEGER,
pct012o156 INTEGER,
pct012o156_2000 INTEGER,
pct012o157 INTEGER,
pct012o157_2000 INTEGER,
pct012o158 INTEGER,
pct012o158_2000 INTEGER,
pct012o159 INTEGER,
pct012o159_2000 INTEGER,
pct012o160 INTEGER,
pct012o160_2000 INTEGER,
pct012o161 INTEGER,
pct012o161_2000 INTEGER,
pct012o162 INTEGER,
pct012o162_2000 INTEGER,
pct012o163 INTEGER,
pct012o163_2000 INTEGER,
pct012o164 INTEGER,
pct012o164_2000 INTEGER,
pct012o165 INTEGER,
pct012o165_2000 INTEGER,
pct012o166 INTEGER,
pct012o166_2000 INTEGER,
pct012o167 INTEGER,
pct012o167_2000 INTEGER,
pct012o168 INTEGER,
pct012o168_2000 INTEGER,
pct012o169 INTEGER,
pct012o169_2000 INTEGER,
pct012o170 INTEGER,
pct012o170_2000 INTEGER,
pct012o171 INTEGER,
pct012o171_2000 INTEGER,
pct012o172 INTEGER,
pct012o172_2000 INTEGER,
pct012o173 INTEGER,
pct012o173_2000 INTEGER,
pct012o174 INTEGER,
pct012o174_2000 INTEGER,
pct012o175 INTEGER,
pct012o175_2000 INTEGER,
pct012o176 INTEGER,
pct012o176_2000 INTEGER,
pct012o177 INTEGER,
pct012o177_2000 INTEGER,
pct012o178 INTEGER,
pct012o178_2000 INTEGER,
pct012o179 INTEGER,
pct012o179_2000 INTEGER,
pct012o180 INTEGER,
pct012o180_2000 INTEGER,
pct012o181 INTEGER,
pct012o181_2000 INTEGER,
pct012o182 INTEGER,
pct012o182_2000 INTEGER,
pct012o183 INTEGER,
pct012o183_2000 INTEGER,
pct012o184 INTEGER,
pct012o184_2000 INTEGER,
pct012o185 INTEGER,
pct012o185_2000 INTEGER,
pct012o186 INTEGER,
pct012o186_2000 INTEGER,
pct012o187 INTEGER,
pct012o187_2000 INTEGER,
pct012o188 INTEGER,
pct012o188_2000 INTEGER,
pct012o189 INTEGER,
pct012o189_2000 INTEGER,
pct012o190 INTEGER,
pct012o190_2000 INTEGER,
pct012o191 INTEGER,
pct012o191_2000 INTEGER,
pct012o192 INTEGER,
pct012o192_2000 INTEGER,
pct012o193 INTEGER,
pct012o193_2000 INTEGER,
pct012o194 INTEGER,
pct012o194_2000 INTEGER,
pct012o195 INTEGER,
pct012o195_2000 INTEGER,
pct012o196 INTEGER,
pct012o196_2000 INTEGER,
pct012o197 INTEGER,
pct012o197_2000 INTEGER,
pct012o198 INTEGER,
pct012o198_2000 INTEGER,
pct012o199 INTEGER,
pct012o199_2000 INTEGER,
pct012o200 INTEGER,
pct012o200_2000 INTEGER,
pct012o201 INTEGER,
pct012o201_2000 INTEGER,
pct012o202 INTEGER,
pct012o202_2000 INTEGER,
pct012o203 INTEGER,
pct012o203_2000 INTEGER,
pct012o204 INTEGER,
pct012o204_2000 INTEGER,
pct012o205 INTEGER,
pct012o205_2000 INTEGER,
pct012o206 INTEGER,
pct012o206_2000 INTEGER,
pct012o207 INTEGER,
pct012o207_2000 INTEGER,
pct012o208 INTEGER,
pct012o208_2000 INTEGER,
pct012o209 INTEGER,
pct012o209_2000 INTEGER,