Skip to content


Subversion checkout URL

You can clone with
Download ZIP
Branch: master
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_pct12l (
county VARCHAR(3),
cbsa VARCHAR(5),
csa VARCHAR(3),
necta VARCHAR(5),
cnecta VARCHAR(3),
pop100_2000 INTEGER,
hu100_2000 INTEGER,
pct012l001 INTEGER,
pct012l001_2000 INTEGER,
pct012l002 INTEGER,
pct012l002_2000 INTEGER,
pct012l003 INTEGER,
pct012l003_2000 INTEGER,
pct012l004 INTEGER,
pct012l004_2000 INTEGER,
pct012l005 INTEGER,
pct012l005_2000 INTEGER,
pct012l006 INTEGER,
pct012l006_2000 INTEGER,
pct012l007 INTEGER,
pct012l007_2000 INTEGER,
pct012l008 INTEGER,
pct012l008_2000 INTEGER,
pct012l009 INTEGER,
pct012l009_2000 INTEGER,
pct012l010 INTEGER,
pct012l010_2000 INTEGER,
pct012l011 INTEGER,
pct012l011_2000 INTEGER,
pct012l012 INTEGER,
pct012l012_2000 INTEGER,
pct012l013 INTEGER,
pct012l013_2000 INTEGER,
pct012l014 INTEGER,
pct012l014_2000 INTEGER,
pct012l015 INTEGER,
pct012l015_2000 INTEGER,
pct012l016 INTEGER,
pct012l016_2000 INTEGER,
pct012l017 INTEGER,
pct012l017_2000 INTEGER,
pct012l018 INTEGER,
pct012l018_2000 INTEGER,
pct012l019 INTEGER,
pct012l019_2000 INTEGER,
pct012l020 INTEGER,
pct012l020_2000 INTEGER,
pct012l021 INTEGER,
pct012l021_2000 INTEGER,
pct012l022 INTEGER,
pct012l022_2000 INTEGER,
pct012l023 INTEGER,
pct012l023_2000 INTEGER,
pct012l024 INTEGER,
pct012l024_2000 INTEGER,
pct012l025 INTEGER,
pct012l025_2000 INTEGER,
pct012l026 INTEGER,
pct012l026_2000 INTEGER,
pct012l027 INTEGER,
pct012l027_2000 INTEGER,
pct012l028 INTEGER,
pct012l028_2000 INTEGER,
pct012l029 INTEGER,
pct012l029_2000 INTEGER,
pct012l030 INTEGER,
pct012l030_2000 INTEGER,
pct012l031 INTEGER,
pct012l031_2000 INTEGER,
pct012l032 INTEGER,
pct012l032_2000 INTEGER,
pct012l033 INTEGER,
pct012l033_2000 INTEGER,
pct012l034 INTEGER,
pct012l034_2000 INTEGER,
pct012l035 INTEGER,
pct012l035_2000 INTEGER,
pct012l036 INTEGER,
pct012l036_2000 INTEGER,
pct012l037 INTEGER,
pct012l037_2000 INTEGER,
pct012l038 INTEGER,
pct012l038_2000 INTEGER,
pct012l039 INTEGER,
pct012l039_2000 INTEGER,
pct012l040 INTEGER,
pct012l040_2000 INTEGER,
pct012l041 INTEGER,
pct012l041_2000 INTEGER,
pct012l042 INTEGER,
pct012l042_2000 INTEGER,
pct012l043 INTEGER,
pct012l043_2000 INTEGER,
pct012l044 INTEGER,
pct012l044_2000 INTEGER,
pct012l045 INTEGER,
pct012l045_2000 INTEGER,
pct012l046 INTEGER,
pct012l046_2000 INTEGER,
pct012l047 INTEGER,
pct012l047_2000 INTEGER,
pct012l048 INTEGER,
pct012l048_2000 INTEGER,
pct012l049 INTEGER,
pct012l049_2000 INTEGER,
pct012l050 INTEGER,
pct012l050_2000 INTEGER,
pct012l051 INTEGER,
pct012l051_2000 INTEGER,
pct012l052 INTEGER,
pct012l052_2000 INTEGER,
pct012l053 INTEGER,
pct012l053_2000 INTEGER,
pct012l054 INTEGER,
pct012l054_2000 INTEGER,
pct012l055 INTEGER,
pct012l055_2000 INTEGER,
pct012l056 INTEGER,
pct012l056_2000 INTEGER,
pct012l057 INTEGER,
pct012l057_2000 INTEGER,
pct012l058 INTEGER,
pct012l058_2000 INTEGER,
pct012l059 INTEGER,
pct012l059_2000 INTEGER,
pct012l060 INTEGER,
pct012l060_2000 INTEGER,
pct012l061 INTEGER,
pct012l061_2000 INTEGER,
pct012l062 INTEGER,
pct012l062_2000 INTEGER,
pct012l063 INTEGER,
pct012l063_2000 INTEGER,
pct012l064 INTEGER,
pct012l064_2000 INTEGER,
pct012l065 INTEGER,
pct012l065_2000 INTEGER,
pct012l066 INTEGER,
pct012l066_2000 INTEGER,
pct012l067 INTEGER,
pct012l067_2000 INTEGER,
pct012l068 INTEGER,
pct012l068_2000 INTEGER,
pct012l069 INTEGER,
pct012l069_2000 INTEGER,
pct012l070 INTEGER,
pct012l070_2000 INTEGER,
pct012l071 INTEGER,
pct012l071_2000 INTEGER,
pct012l072 INTEGER,
pct012l072_2000 INTEGER,
pct012l073 INTEGER,
pct012l073_2000 INTEGER,
pct012l074 INTEGER,
pct012l074_2000 INTEGER,
pct012l075 INTEGER,
pct012l075_2000 INTEGER,
pct012l076 INTEGER,
pct012l076_2000 INTEGER,
pct012l077 INTEGER,
pct012l077_2000 INTEGER,
pct012l078 INTEGER,
pct012l078_2000 INTEGER,
pct012l079 INTEGER,
pct012l079_2000 INTEGER,
pct012l080 INTEGER,
pct012l080_2000 INTEGER,
pct012l081 INTEGER,
pct012l081_2000 INTEGER,
pct012l082 INTEGER,
pct012l082_2000 INTEGER,
pct012l083 INTEGER,
pct012l083_2000 INTEGER,
pct012l084 INTEGER,
pct012l084_2000 INTEGER,
pct012l085 INTEGER,
pct012l085_2000 INTEGER,
pct012l086 INTEGER,
pct012l086_2000 INTEGER,
pct012l087 INTEGER,
pct012l087_2000 INTEGER,
pct012l088 INTEGER,
pct012l088_2000 INTEGER,
pct012l089 INTEGER,
pct012l089_2000 INTEGER,
pct012l090 INTEGER,
pct012l090_2000 INTEGER,
pct012l091 INTEGER,
pct012l091_2000 INTEGER,
pct012l092 INTEGER,
pct012l092_2000 INTEGER,
pct012l093 INTEGER,
pct012l093_2000 INTEGER,
pct012l094 INTEGER,
pct012l094_2000 INTEGER,
pct012l095 INTEGER,
pct012l095_2000 INTEGER,
pct012l096 INTEGER,
pct012l096_2000 INTEGER,
pct012l097 INTEGER,
pct012l097_2000 INTEGER,
pct012l098 INTEGER,
pct012l098_2000 INTEGER,
pct012l099 INTEGER,
pct012l099_2000 INTEGER,
pct012l100 INTEGER,
pct012l100_2000 INTEGER,
pct012l101 INTEGER,
pct012l101_2000 INTEGER,
pct012l102 INTEGER,
pct012l102_2000 INTEGER,
pct012l103 INTEGER,
pct012l103_2000 INTEGER,
pct012l104 INTEGER,
pct012l104_2000 INTEGER,
pct012l105 INTEGER,
pct012l105_2000 INTEGER,
pct012l106 INTEGER,
pct012l106_2000 INTEGER,
pct012l107 INTEGER,
pct012l107_2000 INTEGER,
pct012l108 INTEGER,
pct012l108_2000 INTEGER,
pct012l109 INTEGER,
pct012l109_2000 INTEGER,
pct012l110 INTEGER,
pct012l110_2000 INTEGER,
pct012l111 INTEGER,
pct012l111_2000 INTEGER,
pct012l112 INTEGER,
pct012l112_2000 INTEGER,
pct012l113 INTEGER,
pct012l113_2000 INTEGER,
pct012l114 INTEGER,
pct012l114_2000 INTEGER,
pct012l115 INTEGER,
pct012l115_2000 INTEGER,
pct012l116 INTEGER,
pct012l116_2000 INTEGER,
pct012l117 INTEGER,
pct012l117_2000 INTEGER,
pct012l118 INTEGER,
pct012l118_2000 INTEGER,
pct012l119 INTEGER,
pct012l119_2000 INTEGER,
pct012l120 INTEGER,
pct012l120_2000 INTEGER,
pct012l121 INTEGER,
pct012l121_2000 INTEGER,
pct012l122 INTEGER,
pct012l122_2000 INTEGER,
pct012l123 INTEGER,
pct012l123_2000 INTEGER,
pct012l124 INTEGER,
pct012l124_2000 INTEGER,
pct012l125 INTEGER,
pct012l125_2000 INTEGER,
pct012l126 INTEGER,
pct012l126_2000 INTEGER,
pct012l127 INTEGER,
pct012l127_2000 INTEGER,
pct012l128 INTEGER,
pct012l128_2000 INTEGER,
pct012l129 INTEGER,
pct012l129_2000 INTEGER,
pct012l130 INTEGER,
pct012l130_2000 INTEGER,
pct012l131 INTEGER,
pct012l131_2000 INTEGER,
pct012l132 INTEGER,
pct012l132_2000 INTEGER,
pct012l133 INTEGER,
pct012l133_2000 INTEGER,
pct012l134 INTEGER,
pct012l134_2000 INTEGER,
pct012l135 INTEGER,
pct012l135_2000 INTEGER,
pct012l136 INTEGER,
pct012l136_2000 INTEGER,
pct012l137 INTEGER,
pct012l137_2000 INTEGER,
pct012l138 INTEGER,
pct012l138_2000 INTEGER,
pct012l139 INTEGER,
pct012l139_2000 INTEGER,
pct012l140 INTEGER,
pct012l140_2000 INTEGER,
pct012l141 INTEGER,
pct012l141_2000 INTEGER,
pct012l142 INTEGER,
pct012l142_2000 INTEGER,
pct012l143 INTEGER,
pct012l143_2000 INTEGER,
pct012l144 INTEGER,
pct012l144_2000 INTEGER,
pct012l145 INTEGER,
pct012l145_2000 INTEGER,
pct012l146 INTEGER,
pct012l146_2000 INTEGER,
pct012l147 INTEGER,
pct012l147_2000 INTEGER,
pct012l148 INTEGER,
pct012l148_2000 INTEGER,
pct012l149 INTEGER,
pct012l149_2000 INTEGER,
pct012l150 INTEGER,
pct012l150_2000 INTEGER,
pct012l151 INTEGER,
pct012l151_2000 INTEGER,
pct012l152 INTEGER,
pct012l152_2000 INTEGER,
pct012l153 INTEGER,
pct012l153_2000 INTEGER,
pct012l154 INTEGER,
pct012l154_2000 INTEGER,
pct012l155 INTEGER,
pct012l155_2000 INTEGER,
pct012l156 INTEGER,
pct012l156_2000 INTEGER,
pct012l157 INTEGER,
pct012l157_2000 INTEGER,
pct012l158 INTEGER,
pct012l158_2000 INTEGER,
pct012l159 INTEGER,
pct012l159_2000 INTEGER,
pct012l160 INTEGER,
pct012l160_2000 INTEGER,
pct012l161 INTEGER,
pct012l161_2000 INTEGER,
pct012l162 INTEGER,
pct012l162_2000 INTEGER,
pct012l163 INTEGER,
pct012l163_2000 INTEGER,
pct012l164 INTEGER,
pct012l164_2000 INTEGER,
pct012l165 INTEGER,
pct012l165_2000 INTEGER,
pct012l166 INTEGER,
pct012l166_2000 INTEGER,
pct012l167 INTEGER,
pct012l167_2000 INTEGER,
pct012l168 INTEGER,
pct012l168_2000 INTEGER,
pct012l169 INTEGER,
pct012l169_2000 INTEGER,
pct012l170 INTEGER,
pct012l170_2000 INTEGER,
pct012l171 INTEGER,
pct012l171_2000 INTEGER,
pct012l172 INTEGER,
pct012l172_2000 INTEGER,
pct012l173 INTEGER,
pct012l173_2000 INTEGER,
pct012l174 INTEGER,
pct012l174_2000 INTEGER,
pct012l175 INTEGER,
pct012l175_2000 INTEGER,
pct012l176 INTEGER,
pct012l176_2000 INTEGER,
pct012l177 INTEGER,
pct012l177_2000 INTEGER,
pct012l178 INTEGER,
pct012l178_2000 INTEGER,
pct012l179 INTEGER,
pct012l179_2000 INTEGER,
pct012l180 INTEGER,
pct012l180_2000 INTEGER,
pct012l181 INTEGER,
pct012l181_2000 INTEGER,
pct012l182 INTEGER,
pct012l182_2000 INTEGER,
pct012l183 INTEGER,
pct012l183_2000 INTEGER,
pct012l184 INTEGER,
pct012l184_2000 INTEGER,
pct012l185 INTEGER,
pct012l185_2000 INTEGER,
pct012l186 INTEGER,
pct012l186_2000 INTEGER,
pct012l187 INTEGER,
pct012l187_2000 INTEGER,
pct012l188 INTEGER,
pct012l188_2000 INTEGER,
pct012l189 INTEGER,
pct012l189_2000 INTEGER,
pct012l190 INTEGER,
pct012l190_2000 INTEGER,
pct012l191 INTEGER,
pct012l191_2000 INTEGER,
pct012l192 INTEGER,
pct012l192_2000 INTEGER,
pct012l193 INTEGER,
pct012l193_2000 INTEGER,
pct012l194 INTEGER,
pct012l194_2000 INTEGER,
pct012l195 INTEGER,
pct012l195_2000 INTEGER,
pct012l196 INTEGER,
pct012l196_2000 INTEGER,
pct012l197 INTEGER,
pct012l197_2000 INTEGER,
pct012l198 INTEGER,
pct012l198_2000 INTEGER,
pct012l199 INTEGER,
pct012l199_2000 INTEGER,
pct012l200 INTEGER,
pct012l200_2000 INTEGER,
pct012l201 INTEGER,
pct012l201_2000 INTEGER,
pct012l202 INTEGER,
pct012l202_2000 INTEGER,
pct012l203 INTEGER,
pct012l203_2000 INTEGER,
pct012l204 INTEGER,
pct012l204_2000 INTEGER,
pct012l205 INTEGER,
pct012l205_2000 INTEGER,
pct012l206 INTEGER,
pct012l206_2000 INTEGER,
pct012l207 INTEGER,
pct012l207_2000 INTEGER,
pct012l208 INTEGER,
pct012l208_2000 INTEGER,
pct012l209 INTEGER,
pct012l209_2000 INTEGER,
Jump to Line
Something went wrong with that request. Please try again.