Switch branches/tags
Nothing to show
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_pct12a (
county VARCHAR(3),
cbsa VARCHAR(5),
csa VARCHAR(3),
necta VARCHAR(5),
cnecta VARCHAR(3),
pop100_2000 INTEGER,
hu100_2000 INTEGER,
pct012a001 INTEGER,
pct012a001_2000 INTEGER,
pct012a002 INTEGER,
pct012a002_2000 INTEGER,
pct012a003 INTEGER,
pct012a003_2000 INTEGER,
pct012a004 INTEGER,
pct012a004_2000 INTEGER,
pct012a005 INTEGER,
pct012a005_2000 INTEGER,
pct012a006 INTEGER,
pct012a006_2000 INTEGER,
pct012a007 INTEGER,
pct012a007_2000 INTEGER,
pct012a008 INTEGER,
pct012a008_2000 INTEGER,
pct012a009 INTEGER,
pct012a009_2000 INTEGER,
pct012a010 INTEGER,
pct012a010_2000 INTEGER,
pct012a011 INTEGER,
pct012a011_2000 INTEGER,
pct012a012 INTEGER,
pct012a012_2000 INTEGER,
pct012a013 INTEGER,
pct012a013_2000 INTEGER,
pct012a014 INTEGER,
pct012a014_2000 INTEGER,
pct012a015 INTEGER,
pct012a015_2000 INTEGER,
pct012a016 INTEGER,
pct012a016_2000 INTEGER,
pct012a017 INTEGER,
pct012a017_2000 INTEGER,
pct012a018 INTEGER,
pct012a018_2000 INTEGER,
pct012a019 INTEGER,
pct012a019_2000 INTEGER,
pct012a020 INTEGER,
pct012a020_2000 INTEGER,
pct012a021 INTEGER,
pct012a021_2000 INTEGER,
pct012a022 INTEGER,
pct012a022_2000 INTEGER,
pct012a023 INTEGER,
pct012a023_2000 INTEGER,
pct012a024 INTEGER,
pct012a024_2000 INTEGER,
pct012a025 INTEGER,
pct012a025_2000 INTEGER,
pct012a026 INTEGER,
pct012a026_2000 INTEGER,
pct012a027 INTEGER,
pct012a027_2000 INTEGER,
pct012a028 INTEGER,
pct012a028_2000 INTEGER,
pct012a029 INTEGER,
pct012a029_2000 INTEGER,
pct012a030 INTEGER,
pct012a030_2000 INTEGER,
pct012a031 INTEGER,
pct012a031_2000 INTEGER,
pct012a032 INTEGER,
pct012a032_2000 INTEGER,
pct012a033 INTEGER,
pct012a033_2000 INTEGER,
pct012a034 INTEGER,
pct012a034_2000 INTEGER,
pct012a035 INTEGER,
pct012a035_2000 INTEGER,
pct012a036 INTEGER,
pct012a036_2000 INTEGER,
pct012a037 INTEGER,
pct012a037_2000 INTEGER,
pct012a038 INTEGER,
pct012a038_2000 INTEGER,
pct012a039 INTEGER,
pct012a039_2000 INTEGER,
pct012a040 INTEGER,
pct012a040_2000 INTEGER,
pct012a041 INTEGER,
pct012a041_2000 INTEGER,
pct012a042 INTEGER,
pct012a042_2000 INTEGER,
pct012a043 INTEGER,
pct012a043_2000 INTEGER,
pct012a044 INTEGER,
pct012a044_2000 INTEGER,
pct012a045 INTEGER,
pct012a045_2000 INTEGER,
pct012a046 INTEGER,
pct012a046_2000 INTEGER,
pct012a047 INTEGER,
pct012a047_2000 INTEGER,
pct012a048 INTEGER,
pct012a048_2000 INTEGER,
pct012a049 INTEGER,
pct012a049_2000 INTEGER,
pct012a050 INTEGER,
pct012a050_2000 INTEGER,
pct012a051 INTEGER,
pct012a051_2000 INTEGER,
pct012a052 INTEGER,
pct012a052_2000 INTEGER,
pct012a053 INTEGER,
pct012a053_2000 INTEGER,
pct012a054 INTEGER,
pct012a054_2000 INTEGER,
pct012a055 INTEGER,
pct012a055_2000 INTEGER,
pct012a056 INTEGER,
pct012a056_2000 INTEGER,
pct012a057 INTEGER,
pct012a057_2000 INTEGER,
pct012a058 INTEGER,
pct012a058_2000 INTEGER,
pct012a059 INTEGER,
pct012a059_2000 INTEGER,
pct012a060 INTEGER,
pct012a060_2000 INTEGER,
pct012a061 INTEGER,
pct012a061_2000 INTEGER,
pct012a062 INTEGER,
pct012a062_2000 INTEGER,
pct012a063 INTEGER,
pct012a063_2000 INTEGER,
pct012a064 INTEGER,
pct012a064_2000 INTEGER,
pct012a065 INTEGER,
pct012a065_2000 INTEGER,
pct012a066 INTEGER,
pct012a066_2000 INTEGER,
pct012a067 INTEGER,
pct012a067_2000 INTEGER,
pct012a068 INTEGER,
pct012a068_2000 INTEGER,
pct012a069 INTEGER,
pct012a069_2000 INTEGER,
pct012a070 INTEGER,
pct012a070_2000 INTEGER,
pct012a071 INTEGER,
pct012a071_2000 INTEGER,
pct012a072 INTEGER,
pct012a072_2000 INTEGER,
pct012a073 INTEGER,
pct012a073_2000 INTEGER,
pct012a074 INTEGER,
pct012a074_2000 INTEGER,
pct012a075 INTEGER,
pct012a075_2000 INTEGER,
pct012a076 INTEGER,
pct012a076_2000 INTEGER,
pct012a077 INTEGER,
pct012a077_2000 INTEGER,
pct012a078 INTEGER,
pct012a078_2000 INTEGER,
pct012a079 INTEGER,
pct012a079_2000 INTEGER,
pct012a080 INTEGER,
pct012a080_2000 INTEGER,
pct012a081 INTEGER,
pct012a081_2000 INTEGER,
pct012a082 INTEGER,
pct012a082_2000 INTEGER,
pct012a083 INTEGER,
pct012a083_2000 INTEGER,
pct012a084 INTEGER,
pct012a084_2000 INTEGER,
pct012a085 INTEGER,
pct012a085_2000 INTEGER,
pct012a086 INTEGER,
pct012a086_2000 INTEGER,
pct012a087 INTEGER,
pct012a087_2000 INTEGER,
pct012a088 INTEGER,
pct012a088_2000 INTEGER,
pct012a089 INTEGER,
pct012a089_2000 INTEGER,
pct012a090 INTEGER,
pct012a090_2000 INTEGER,
pct012a091 INTEGER,
pct012a091_2000 INTEGER,
pct012a092 INTEGER,
pct012a092_2000 INTEGER,
pct012a093 INTEGER,
pct012a093_2000 INTEGER,
pct012a094 INTEGER,
pct012a094_2000 INTEGER,
pct012a095 INTEGER,
pct012a095_2000 INTEGER,
pct012a096 INTEGER,
pct012a096_2000 INTEGER,
pct012a097 INTEGER,
pct012a097_2000 INTEGER,
pct012a098 INTEGER,
pct012a098_2000 INTEGER,
pct012a099 INTEGER,
pct012a099_2000 INTEGER,
pct012a100 INTEGER,
pct012a100_2000 INTEGER,
pct012a101 INTEGER,
pct012a101_2000 INTEGER,
pct012a102 INTEGER,
pct012a102_2000 INTEGER,
pct012a103 INTEGER,
pct012a103_2000 INTEGER,
pct012a104 INTEGER,
pct012a104_2000 INTEGER,
pct012a105 INTEGER,
pct012a105_2000 INTEGER,
pct012a106 INTEGER,
pct012a106_2000 INTEGER,
pct012a107 INTEGER,
pct012a107_2000 INTEGER,
pct012a108 INTEGER,
pct012a108_2000 INTEGER,
pct012a109 INTEGER,
pct012a109_2000 INTEGER,
pct012a110 INTEGER,
pct012a110_2000 INTEGER,
pct012a111 INTEGER,
pct012a111_2000 INTEGER,
pct012a112 INTEGER,
pct012a112_2000 INTEGER,
pct012a113 INTEGER,
pct012a113_2000 INTEGER,
pct012a114 INTEGER,
pct012a114_2000 INTEGER,
pct012a115 INTEGER,
pct012a115_2000 INTEGER,
pct012a116 INTEGER,
pct012a116_2000 INTEGER,
pct012a117 INTEGER,
pct012a117_2000 INTEGER,
pct012a118 INTEGER,
pct012a118_2000 INTEGER,
pct012a119 INTEGER,
pct012a119_2000 INTEGER,
pct012a120 INTEGER,
pct012a120_2000 INTEGER,
pct012a121 INTEGER,
pct012a121_2000 INTEGER,
pct012a122 INTEGER,
pct012a122_2000 INTEGER,
pct012a123 INTEGER,
pct012a123_2000 INTEGER,
pct012a124 INTEGER,
pct012a124_2000 INTEGER,
pct012a125 INTEGER,
pct012a125_2000 INTEGER,
pct012a126 INTEGER,
pct012a126_2000 INTEGER,
pct012a127 INTEGER,
pct012a127_2000 INTEGER,
pct012a128 INTEGER,
pct012a128_2000 INTEGER,
pct012a129 INTEGER,
pct012a129_2000 INTEGER,
pct012a130 INTEGER,
pct012a130_2000 INTEGER,
pct012a131 INTEGER,
pct012a131_2000 INTEGER,
pct012a132 INTEGER,
pct012a132_2000 INTEGER,
pct012a133 INTEGER,
pct012a133_2000 INTEGER,
pct012a134 INTEGER,
pct012a134_2000 INTEGER,
pct012a135 INTEGER,
pct012a135_2000 INTEGER,
pct012a136 INTEGER,
pct012a136_2000 INTEGER,
pct012a137 INTEGER,
pct012a137_2000 INTEGER,
pct012a138 INTEGER,
pct012a138_2000 INTEGER,
pct012a139 INTEGER,
pct012a139_2000 INTEGER,
pct012a140 INTEGER,
pct012a140_2000 INTEGER,
pct012a141 INTEGER,
pct012a141_2000 INTEGER,
pct012a142 INTEGER,
pct012a142_2000 INTEGER,
pct012a143 INTEGER,
pct012a143_2000 INTEGER,
pct012a144 INTEGER,
pct012a144_2000 INTEGER,
pct012a145 INTEGER,
pct012a145_2000 INTEGER,
pct012a146 INTEGER,
pct012a146_2000 INTEGER,
pct012a147 INTEGER,
pct012a147_2000 INTEGER,
pct012a148 INTEGER,
pct012a148_2000 INTEGER,
pct012a149 INTEGER,
pct012a149_2000 INTEGER,
pct012a150 INTEGER,
pct012a150_2000 INTEGER,
pct012a151 INTEGER,
pct012a151_2000 INTEGER,
pct012a152 INTEGER,
pct012a152_2000 INTEGER,
pct012a153 INTEGER,
pct012a153_2000 INTEGER,
pct012a154 INTEGER,
pct012a154_2000 INTEGER,
pct012a155 INTEGER,
pct012a155_2000 INTEGER,
pct012a156 INTEGER,
pct012a156_2000 INTEGER,
pct012a157 INTEGER,
pct012a157_2000 INTEGER,
pct012a158 INTEGER,
pct012a158_2000 INTEGER,
pct012a159 INTEGER,
pct012a159_2000 INTEGER,
pct012a160 INTEGER,
pct012a160_2000 INTEGER,
pct012a161 INTEGER,
pct012a161_2000 INTEGER,
pct012a162 INTEGER,
pct012a162_2000 INTEGER,
pct012a163 INTEGER,
pct012a163_2000 INTEGER,
pct012a164 INTEGER,
pct012a164_2000 INTEGER,
pct012a165 INTEGER,
pct012a165_2000 INTEGER,
pct012a166 INTEGER,
pct012a166_2000 INTEGER,
pct012a167 INTEGER,
pct012a167_2000 INTEGER,
pct012a168 INTEGER,
pct012a168_2000 INTEGER,
pct012a169 INTEGER,
pct012a169_2000 INTEGER,
pct012a170 INTEGER,
pct012a170_2000 INTEGER,
pct012a171 INTEGER,
pct012a171_2000 INTEGER,
pct012a172 INTEGER,
pct012a172_2000 INTEGER,
pct012a173 INTEGER,
pct012a173_2000 INTEGER,
pct012a174 INTEGER,
pct012a174_2000 INTEGER,
pct012a175 INTEGER,
pct012a175_2000 INTEGER,
pct012a176 INTEGER,
pct012a176_2000 INTEGER,
pct012a177 INTEGER,
pct012a177_2000 INTEGER,
pct012a178 INTEGER,
pct012a178_2000 INTEGER,
pct012a179 INTEGER,
pct012a179_2000 INTEGER,
pct012a180 INTEGER,
pct012a180_2000 INTEGER,
pct012a181 INTEGER,
pct012a181_2000 INTEGER,
pct012a182 INTEGER,
pct012a182_2000 INTEGER,
pct012a183 INTEGER,
pct012a183_2000 INTEGER,
pct012a184 INTEGER,
pct012a184_2000 INTEGER,
pct012a185 INTEGER,
pct012a185_2000 INTEGER,
pct012a186 INTEGER,
pct012a186_2000 INTEGER,
pct012a187 INTEGER,
pct012a187_2000 INTEGER,
pct012a188 INTEGER,
pct012a188_2000 INTEGER,
pct012a189 INTEGER,
pct012a189_2000 INTEGER,
pct012a190 INTEGER,
pct012a190_2000 INTEGER,
pct012a191 INTEGER,
pct012a191_2000 INTEGER,
pct012a192 INTEGER,
pct012a192_2000 INTEGER,
pct012a193 INTEGER,
pct012a193_2000 INTEGER,
pct012a194 INTEGER,
pct012a194_2000 INTEGER,
pct012a195 INTEGER,
pct012a195_2000 INTEGER,
pct012a196 INTEGER,
pct012a196_2000 INTEGER,
pct012a197 INTEGER,
pct012a197_2000 INTEGER,
pct012a198 INTEGER,
pct012a198_2000 INTEGER,
pct012a199 INTEGER,
pct012a199_2000 INTEGER,
pct012a200 INTEGER,
pct012a200_2000 INTEGER,
pct012a201 INTEGER,
pct012a201_2000 INTEGER,
pct012a202 INTEGER,
pct012a202_2000 INTEGER,
pct012a203 INTEGER,
pct012a203_2000 INTEGER,
pct012a204 INTEGER,
pct012a204_2000 INTEGER,
pct012a205 INTEGER,
pct012a205_2000 INTEGER,
pct012a206 INTEGER,
pct012a206_2000 INTEGER,
pct012a207 INTEGER,
pct012a207_2000 INTEGER,
pct012a208 INTEGER,
pct012a208_2000 INTEGER,
pct012a209 INTEGER,
pct012a209_2000 INTEGER,