Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
410 lines (409 sloc) 9.48 KB
-- designed to work with the IRE Census bulk data exports
-- see
CREATE TABLE ire_pct21 (
county VARCHAR(3),
cbsa VARCHAR(5),
csa VARCHAR(3),
necta VARCHAR(5),
cnecta VARCHAR(3),
pop100_2000 INTEGER,
hu100_2000 INTEGER,
pct021001 INTEGER,
pct021001_2000 INTEGER,
pct021002 INTEGER,
pct021002_2000 INTEGER,
pct021003 INTEGER,
pct021003_2000 INTEGER,
pct021004 INTEGER,
pct021004_2000 INTEGER,
pct021005 INTEGER,
pct021005_2000 INTEGER,
pct021006 INTEGER,
pct021006_2000 INTEGER,
pct021007 INTEGER,
pct021007_2000 INTEGER,
pct021008 INTEGER,
pct021008_2000 INTEGER,
pct021009 INTEGER,
pct021009_2000 INTEGER,
pct021010 INTEGER,
pct021010_2000 INTEGER,
pct021011 INTEGER,
pct021011_2000 INTEGER,
pct021012 INTEGER,
pct021012_2000 INTEGER,
pct021013 INTEGER,
pct021013_2000 INTEGER,
pct021014 INTEGER,
pct021014_2000 INTEGER,
pct021015 INTEGER,
pct021015_2000 INTEGER,
pct021016 INTEGER,
pct021016_2000 INTEGER,
pct021017 INTEGER,
pct021017_2000 INTEGER,
pct021018 INTEGER,
pct021018_2000 INTEGER,
pct021019 INTEGER,
pct021019_2000 INTEGER,
pct021020 INTEGER,
pct021020_2000 INTEGER,
pct021021 INTEGER,
pct021021_2000 INTEGER,
pct021022 INTEGER,
pct021022_2000 INTEGER,
pct021023 INTEGER,
pct021023_2000 INTEGER,
pct021024 INTEGER,
pct021024_2000 INTEGER,
pct021025 INTEGER,
pct021025_2000 INTEGER,
pct021026 INTEGER,
pct021026_2000 INTEGER,
pct021027 INTEGER,
pct021027_2000 INTEGER,
pct021028 INTEGER,
pct021028_2000 INTEGER,
pct021029 INTEGER,
pct021029_2000 INTEGER,
pct021030 INTEGER,
pct021030_2000 INTEGER,
pct021031 INTEGER,
pct021031_2000 INTEGER,
pct021032 INTEGER,
pct021032_2000 INTEGER,
pct021033 INTEGER,
pct021033_2000 INTEGER,
pct021034 INTEGER,
pct021034_2000 INTEGER,
pct021035 INTEGER,
pct021035_2000 INTEGER,
pct021036 INTEGER,
pct021036_2000 INTEGER,
pct021037 INTEGER,
pct021037_2000 INTEGER,
pct021038 INTEGER,
pct021038_2000 INTEGER,
pct021039 INTEGER,
pct021039_2000 INTEGER,
pct021040 INTEGER,
pct021040_2000 INTEGER,
pct021041 INTEGER,
pct021041_2000 INTEGER,
pct021042 INTEGER,
pct021042_2000 INTEGER,
pct021043 INTEGER,
pct021043_2000 INTEGER,
pct021044 INTEGER,
pct021044_2000 INTEGER,
pct021045 INTEGER,
pct021045_2000 INTEGER,
pct021046 INTEGER,
pct021046_2000 INTEGER,
pct021047 INTEGER,
pct021047_2000 INTEGER,
pct021048 INTEGER,
pct021048_2000 INTEGER,
pct021049 INTEGER,
pct021049_2000 INTEGER,
pct021050 INTEGER,
pct021050_2000 INTEGER,
pct021051 INTEGER,
pct021051_2000 INTEGER,
pct021052 INTEGER,
pct021052_2000 INTEGER,
pct021053 INTEGER,
pct021053_2000 INTEGER,
pct021054 INTEGER,
pct021054_2000 INTEGER,
pct021055 INTEGER,
pct021055_2000 INTEGER,
pct021056 INTEGER,
pct021056_2000 INTEGER,
pct021057 INTEGER,
pct021057_2000 INTEGER,
pct021058 INTEGER,
pct021058_2000 INTEGER,
pct021059 INTEGER,
pct021059_2000 INTEGER,
pct021060 INTEGER,
pct021060_2000 INTEGER,
pct021061 INTEGER,
pct021061_2000 INTEGER,
pct021062 INTEGER,
pct021062_2000 INTEGER,
pct021063 INTEGER,
pct021063_2000 INTEGER,
pct021064 INTEGER,
pct021064_2000 INTEGER,
pct021065 INTEGER,
pct021065_2000 INTEGER,
pct021066 INTEGER,
pct021066_2000 INTEGER,
pct021067 INTEGER,
pct021067_2000 INTEGER,
pct021068 INTEGER,
pct021068_2000 INTEGER,
pct021069 INTEGER,
pct021069_2000 INTEGER,
pct021070 INTEGER,
pct021070_2000 INTEGER,
pct021071 INTEGER,
pct021071_2000 INTEGER,
pct021072 INTEGER,
pct021072_2000 INTEGER,
pct021073 INTEGER,
pct021073_2000 INTEGER,
pct021074 INTEGER,
pct021074_2000 INTEGER,
pct021075 INTEGER,
pct021075_2000 INTEGER,
pct021076 INTEGER,
pct021076_2000 INTEGER,
pct021077 INTEGER,
pct021077_2000 INTEGER,
pct021078 INTEGER,
pct021078_2000 INTEGER,
pct021079 INTEGER,
pct021079_2000 INTEGER,
pct021080 INTEGER,
pct021080_2000 INTEGER,
pct021081 INTEGER,
pct021081_2000 INTEGER,
pct021082 INTEGER,
pct021082_2000 INTEGER,
pct021083 INTEGER,
pct021083_2000 INTEGER,
pct021084 INTEGER,
pct021084_2000 INTEGER,
pct021085 INTEGER,
pct021085_2000 INTEGER,
pct021086 INTEGER,
pct021086_2000 INTEGER,
pct021087 INTEGER,
pct021087_2000 INTEGER,
pct021088 INTEGER,
pct021088_2000 INTEGER,
pct021089 INTEGER,
pct021089_2000 INTEGER,
pct021090 INTEGER,
pct021090_2000 INTEGER,
pct021091 INTEGER,
pct021091_2000 INTEGER,
pct021092 INTEGER,
pct021092_2000 INTEGER,
pct021093 INTEGER,
pct021093_2000 INTEGER,
pct021094 INTEGER,
pct021094_2000 INTEGER,
pct021095 INTEGER,
pct021095_2000 INTEGER,
pct021096 INTEGER,
pct021096_2000 INTEGER,
pct021097 INTEGER,
pct021097_2000 INTEGER,
pct021098 INTEGER,
pct021098_2000 INTEGER,
pct021099 INTEGER,
pct021099_2000 INTEGER,
pct021100 INTEGER,
pct021100_2000 INTEGER,
pct021101 INTEGER,
pct021101_2000 INTEGER,
pct021102 INTEGER,
pct021102_2000 INTEGER,
pct021103 INTEGER,
pct021103_2000 INTEGER,
pct021104 INTEGER,
pct021104_2000 INTEGER,
pct021105 INTEGER,
pct021105_2000 INTEGER,
pct021106 INTEGER,
pct021106_2000 INTEGER,
pct021107 INTEGER,
pct021107_2000 INTEGER,
pct021108 INTEGER,
pct021108_2000 INTEGER,
pct021109 INTEGER,
pct021109_2000 INTEGER,
pct021110 INTEGER,
pct021110_2000 INTEGER,
pct021111 INTEGER,
pct021111_2000 INTEGER,
pct021112 INTEGER,
pct021112_2000 INTEGER,
pct021113 INTEGER,
pct021113_2000 INTEGER,
pct021114 INTEGER,
pct021114_2000 INTEGER,
pct021115 INTEGER,
pct021115_2000 INTEGER,
pct021116 INTEGER,
pct021116_2000 INTEGER,
pct021117 INTEGER,
pct021117_2000 INTEGER,
pct021118 INTEGER,
pct021118_2000 INTEGER,
pct021119 INTEGER,
pct021119_2000 INTEGER,
pct021120 INTEGER,
pct021120_2000 INTEGER,
pct021121 INTEGER,
pct021121_2000 INTEGER,
pct021122 INTEGER,
pct021122_2000 INTEGER,
pct021123 INTEGER,
pct021123_2000 INTEGER,
pct021124 INTEGER,
pct021124_2000 INTEGER,
pct021125 INTEGER,
pct021125_2000 INTEGER,
pct021126 INTEGER,
pct021126_2000 INTEGER,
pct021127 INTEGER,
pct021127_2000 INTEGER,
pct021128 INTEGER,
pct021128_2000 INTEGER,
pct021129 INTEGER,
pct021129_2000 INTEGER,
pct021130 INTEGER,
pct021130_2000 INTEGER,
pct021131 INTEGER,
pct021131_2000 INTEGER,
pct021132 INTEGER,
pct021132_2000 INTEGER,
pct021133 INTEGER,
pct021133_2000 INTEGER,
pct021134 INTEGER,
pct021134_2000 INTEGER,
pct021135 INTEGER,
pct021135_2000 INTEGER,
pct021136 INTEGER,
pct021136_2000 INTEGER,
pct021137 INTEGER,
pct021137_2000 INTEGER,
pct021138 INTEGER,
pct021138_2000 INTEGER,
pct021139 INTEGER,
pct021139_2000 INTEGER,
pct021140 INTEGER,
pct021140_2000 INTEGER,
pct021141 INTEGER,
pct021141_2000 INTEGER,
pct021142 INTEGER,
pct021142_2000 INTEGER,
pct021143 INTEGER,
pct021143_2000 INTEGER,
pct021144 INTEGER,
pct021144_2000 INTEGER,
pct021145 INTEGER,
pct021145_2000 INTEGER,
pct021146 INTEGER,
pct021146_2000 INTEGER,
pct021147 INTEGER,
pct021147_2000 INTEGER,
pct021148 INTEGER,
pct021148_2000 INTEGER,
pct021149 INTEGER,
pct021149_2000 INTEGER,
pct021150 INTEGER,
pct021150_2000 INTEGER,
pct021151 INTEGER,
pct021151_2000 INTEGER,
pct021152 INTEGER,
pct021152_2000 INTEGER,
pct021153 INTEGER,
pct021153_2000 INTEGER,
pct021154 INTEGER,
pct021154_2000 INTEGER,
pct021155 INTEGER,
pct021155_2000 INTEGER,
pct021156 INTEGER,
pct021156_2000 INTEGER,
pct021157 INTEGER,
pct021157_2000 INTEGER,
pct021158 INTEGER,
pct021158_2000 INTEGER,
pct021159 INTEGER,
pct021159_2000 INTEGER,
pct021160 INTEGER,
pct021160_2000 INTEGER,
pct021161 INTEGER,
pct021161_2000 INTEGER,
pct021162 INTEGER,
pct021162_2000 INTEGER,
pct021163 INTEGER,
pct021163_2000 INTEGER,
pct021164 INTEGER,
pct021164_2000 INTEGER,
pct021165 INTEGER,
pct021165_2000 INTEGER,
pct021166 INTEGER,
pct021166_2000 INTEGER,
pct021167 INTEGER,
pct021167_2000 INTEGER,
pct021168 INTEGER,
pct021168_2000 INTEGER,
pct021169 INTEGER,
pct021169_2000 INTEGER,
pct021170 INTEGER,
pct021170_2000 INTEGER,
pct021171 INTEGER,
pct021171_2000 INTEGER,
pct021172 INTEGER,
pct021172_2000 INTEGER,
pct021173 INTEGER,
pct021173_2000 INTEGER,
pct021174 INTEGER,
pct021174_2000 INTEGER,
pct021175 INTEGER,
pct021175_2000 INTEGER,
pct021176 INTEGER,
pct021176_2000 INTEGER,
pct021177 INTEGER,
pct021177_2000 INTEGER,
pct021178 INTEGER,
pct021178_2000 INTEGER,
pct021179 INTEGER,
pct021179_2000 INTEGER,
pct021180 INTEGER,
pct021180_2000 INTEGER,
pct021181 INTEGER,
pct021181_2000 INTEGER,
pct021182 INTEGER,
pct021182_2000 INTEGER,
pct021183 INTEGER,
pct021183_2000 INTEGER,
pct021184 INTEGER,
pct021184_2000 INTEGER,
pct021185 INTEGER,
pct021185_2000 INTEGER,
pct021186 INTEGER,
pct021186_2000 INTEGER,
pct021187 INTEGER,
pct021187_2000 INTEGER,
pct021188 INTEGER,
pct021188_2000 INTEGER,
pct021189 INTEGER,
pct021189_2000 INTEGER,
pct021190 INTEGER,
pct021190_2000 INTEGER,
pct021191 INTEGER,
pct021191_2000 INTEGER,
pct021192 INTEGER,
pct021192_2000 INTEGER,
pct021193 INTEGER,
pct021193_2000 INTEGER,
pct021194 INTEGER,
pct021194_2000 INTEGER,
pct021195 INTEGER,
pct021195_2000 INTEGER,