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_pct12k (
county VARCHAR(3),
cbsa VARCHAR(5),
csa VARCHAR(3),
necta VARCHAR(5),
cnecta VARCHAR(3),
pop100_2000 INTEGER,
hu100_2000 INTEGER,
pct012k001 INTEGER,
pct012k001_2000 INTEGER,
pct012k002 INTEGER,
pct012k002_2000 INTEGER,
pct012k003 INTEGER,
pct012k003_2000 INTEGER,
pct012k004 INTEGER,
pct012k004_2000 INTEGER,
pct012k005 INTEGER,
pct012k005_2000 INTEGER,
pct012k006 INTEGER,
pct012k006_2000 INTEGER,
pct012k007 INTEGER,
pct012k007_2000 INTEGER,
pct012k008 INTEGER,
pct012k008_2000 INTEGER,
pct012k009 INTEGER,
pct012k009_2000 INTEGER,
pct012k010 INTEGER,
pct012k010_2000 INTEGER,
pct012k011 INTEGER,
pct012k011_2000 INTEGER,
pct012k012 INTEGER,
pct012k012_2000 INTEGER,
pct012k013 INTEGER,
pct012k013_2000 INTEGER,
pct012k014 INTEGER,
pct012k014_2000 INTEGER,
pct012k015 INTEGER,
pct012k015_2000 INTEGER,
pct012k016 INTEGER,
pct012k016_2000 INTEGER,
pct012k017 INTEGER,
pct012k017_2000 INTEGER,
pct012k018 INTEGER,
pct012k018_2000 INTEGER,
pct012k019 INTEGER,
pct012k019_2000 INTEGER,
pct012k020 INTEGER,
pct012k020_2000 INTEGER,
pct012k021 INTEGER,
pct012k021_2000 INTEGER,
pct012k022 INTEGER,
pct012k022_2000 INTEGER,
pct012k023 INTEGER,
pct012k023_2000 INTEGER,
pct012k024 INTEGER,
pct012k024_2000 INTEGER,
pct012k025 INTEGER,
pct012k025_2000 INTEGER,
pct012k026 INTEGER,
pct012k026_2000 INTEGER,
pct012k027 INTEGER,
pct012k027_2000 INTEGER,
pct012k028 INTEGER,
pct012k028_2000 INTEGER,
pct012k029 INTEGER,
pct012k029_2000 INTEGER,
pct012k030 INTEGER,
pct012k030_2000 INTEGER,
pct012k031 INTEGER,
pct012k031_2000 INTEGER,
pct012k032 INTEGER,
pct012k032_2000 INTEGER,
pct012k033 INTEGER,
pct012k033_2000 INTEGER,
pct012k034 INTEGER,
pct012k034_2000 INTEGER,
pct012k035 INTEGER,
pct012k035_2000 INTEGER,
pct012k036 INTEGER,
pct012k036_2000 INTEGER,
pct012k037 INTEGER,
pct012k037_2000 INTEGER,
pct012k038 INTEGER,
pct012k038_2000 INTEGER,
pct012k039 INTEGER,
pct012k039_2000 INTEGER,
pct012k040 INTEGER,
pct012k040_2000 INTEGER,
pct012k041 INTEGER,
pct012k041_2000 INTEGER,
pct012k042 INTEGER,
pct012k042_2000 INTEGER,
pct012k043 INTEGER,
pct012k043_2000 INTEGER,
pct012k044 INTEGER,
pct012k044_2000 INTEGER,
pct012k045 INTEGER,
pct012k045_2000 INTEGER,
pct012k046 INTEGER,
pct012k046_2000 INTEGER,
pct012k047 INTEGER,
pct012k047_2000 INTEGER,
pct012k048 INTEGER,
pct012k048_2000 INTEGER,
pct012k049 INTEGER,
pct012k049_2000 INTEGER,
pct012k050 INTEGER,
pct012k050_2000 INTEGER,
pct012k051 INTEGER,
pct012k051_2000 INTEGER,
pct012k052 INTEGER,
pct012k052_2000 INTEGER,
pct012k053 INTEGER,
pct012k053_2000 INTEGER,
pct012k054 INTEGER,
pct012k054_2000 INTEGER,
pct012k055 INTEGER,
pct012k055_2000 INTEGER,
pct012k056 INTEGER,
pct012k056_2000 INTEGER,
pct012k057 INTEGER,
pct012k057_2000 INTEGER,
pct012k058 INTEGER,
pct012k058_2000 INTEGER,
pct012k059 INTEGER,
pct012k059_2000 INTEGER,
pct012k060 INTEGER,
pct012k060_2000 INTEGER,
pct012k061 INTEGER,
pct012k061_2000 INTEGER,
pct012k062 INTEGER,
pct012k062_2000 INTEGER,
pct012k063 INTEGER,
pct012k063_2000 INTEGER,
pct012k064 INTEGER,
pct012k064_2000 INTEGER,
pct012k065 INTEGER,
pct012k065_2000 INTEGER,
pct012k066 INTEGER,
pct012k066_2000 INTEGER,
pct012k067 INTEGER,
pct012k067_2000 INTEGER,
pct012k068 INTEGER,
pct012k068_2000 INTEGER,
pct012k069 INTEGER,
pct012k069_2000 INTEGER,
pct012k070 INTEGER,
pct012k070_2000 INTEGER,
pct012k071 INTEGER,
pct012k071_2000 INTEGER,
pct012k072 INTEGER,
pct012k072_2000 INTEGER,
pct012k073 INTEGER,
pct012k073_2000 INTEGER,
pct012k074 INTEGER,
pct012k074_2000 INTEGER,
pct012k075 INTEGER,
pct012k075_2000 INTEGER,
pct012k076 INTEGER,
pct012k076_2000 INTEGER,
pct012k077 INTEGER,
pct012k077_2000 INTEGER,
pct012k078 INTEGER,
pct012k078_2000 INTEGER,
pct012k079 INTEGER,
pct012k079_2000 INTEGER,
pct012k080 INTEGER,
pct012k080_2000 INTEGER,
pct012k081 INTEGER,
pct012k081_2000 INTEGER,
pct012k082 INTEGER,
pct012k082_2000 INTEGER,
pct012k083 INTEGER,
pct012k083_2000 INTEGER,
pct012k084 INTEGER,
pct012k084_2000 INTEGER,
pct012k085 INTEGER,
pct012k085_2000 INTEGER,
pct012k086 INTEGER,
pct012k086_2000 INTEGER,
pct012k087 INTEGER,
pct012k087_2000 INTEGER,
pct012k088 INTEGER,
pct012k088_2000 INTEGER,
pct012k089 INTEGER,
pct012k089_2000 INTEGER,
pct012k090 INTEGER,
pct012k090_2000 INTEGER,
pct012k091 INTEGER,
pct012k091_2000 INTEGER,
pct012k092 INTEGER,
pct012k092_2000 INTEGER,
pct012k093 INTEGER,
pct012k093_2000 INTEGER,
pct012k094 INTEGER,
pct012k094_2000 INTEGER,
pct012k095 INTEGER,
pct012k095_2000 INTEGER,
pct012k096 INTEGER,
pct012k096_2000 INTEGER,
pct012k097 INTEGER,
pct012k097_2000 INTEGER,
pct012k098 INTEGER,
pct012k098_2000 INTEGER,
pct012k099 INTEGER,
pct012k099_2000 INTEGER,
pct012k100 INTEGER,
pct012k100_2000 INTEGER,
pct012k101 INTEGER,
pct012k101_2000 INTEGER,
pct012k102 INTEGER,
pct012k102_2000 INTEGER,
pct012k103 INTEGER,
pct012k103_2000 INTEGER,
pct012k104 INTEGER,
pct012k104_2000 INTEGER,
pct012k105 INTEGER,
pct012k105_2000 INTEGER,
pct012k106 INTEGER,
pct012k106_2000 INTEGER,
pct012k107 INTEGER,
pct012k107_2000 INTEGER,
pct012k108 INTEGER,
pct012k108_2000 INTEGER,
pct012k109 INTEGER,
pct012k109_2000 INTEGER,
pct012k110 INTEGER,
pct012k110_2000 INTEGER,
pct012k111 INTEGER,
pct012k111_2000 INTEGER,
pct012k112 INTEGER,
pct012k112_2000 INTEGER,
pct012k113 INTEGER,
pct012k113_2000 INTEGER,
pct012k114 INTEGER,
pct012k114_2000 INTEGER,
pct012k115 INTEGER,
pct012k115_2000 INTEGER,
pct012k116 INTEGER,
pct012k116_2000 INTEGER,
pct012k117 INTEGER,
pct012k117_2000 INTEGER,
pct012k118 INTEGER,
pct012k118_2000 INTEGER,
pct012k119 INTEGER,
pct012k119_2000 INTEGER,
pct012k120 INTEGER,
pct012k120_2000 INTEGER,
pct012k121 INTEGER,
pct012k121_2000 INTEGER,
pct012k122 INTEGER,
pct012k122_2000 INTEGER,
pct012k123 INTEGER,
pct012k123_2000 INTEGER,
pct012k124 INTEGER,
pct012k124_2000 INTEGER,
pct012k125 INTEGER,
pct012k125_2000 INTEGER,
pct012k126 INTEGER,
pct012k126_2000 INTEGER,
pct012k127 INTEGER,
pct012k127_2000 INTEGER,
pct012k128 INTEGER,
pct012k128_2000 INTEGER,
pct012k129 INTEGER,
pct012k129_2000 INTEGER,
pct012k130 INTEGER,
pct012k130_2000 INTEGER,
pct012k131 INTEGER,
pct012k131_2000 INTEGER,
pct012k132 INTEGER,
pct012k132_2000 INTEGER,
pct012k133 INTEGER,
pct012k133_2000 INTEGER,
pct012k134 INTEGER,
pct012k134_2000 INTEGER,
pct012k135 INTEGER,
pct012k135_2000 INTEGER,
pct012k136 INTEGER,
pct012k136_2000 INTEGER,
pct012k137 INTEGER,
pct012k137_2000 INTEGER,
pct012k138 INTEGER,
pct012k138_2000 INTEGER,
pct012k139 INTEGER,
pct012k139_2000 INTEGER,
pct012k140 INTEGER,
pct012k140_2000 INTEGER,
pct012k141 INTEGER,
pct012k141_2000 INTEGER,
pct012k142 INTEGER,
pct012k142_2000 INTEGER,
pct012k143 INTEGER,
pct012k143_2000 INTEGER,
pct012k144 INTEGER,
pct012k144_2000 INTEGER,
pct012k145 INTEGER,
pct012k145_2000 INTEGER,
pct012k146 INTEGER,
pct012k146_2000 INTEGER,
pct012k147 INTEGER,
pct012k147_2000 INTEGER,
pct012k148 INTEGER,
pct012k148_2000 INTEGER,
pct012k149 INTEGER,
pct012k149_2000 INTEGER,
pct012k150 INTEGER,
pct012k150_2000 INTEGER,
pct012k151 INTEGER,
pct012k151_2000 INTEGER,
pct012k152 INTEGER,
pct012k152_2000 INTEGER,
pct012k153 INTEGER,
pct012k153_2000 INTEGER,
pct012k154 INTEGER,
pct012k154_2000 INTEGER,
pct012k155 INTEGER,
pct012k155_2000 INTEGER,
pct012k156 INTEGER,
pct012k156_2000 INTEGER,
pct012k157 INTEGER,
pct012k157_2000 INTEGER,
pct012k158 INTEGER,
pct012k158_2000 INTEGER,
pct012k159 INTEGER,
pct012k159_2000 INTEGER,
pct012k160 INTEGER,
pct012k160_2000 INTEGER,
pct012k161 INTEGER,
pct012k161_2000 INTEGER,
pct012k162 INTEGER,
pct012k162_2000 INTEGER,
pct012k163 INTEGER,
pct012k163_2000 INTEGER,
pct012k164 INTEGER,
pct012k164_2000 INTEGER,
pct012k165 INTEGER,
pct012k165_2000 INTEGER,
pct012k166 INTEGER,
pct012k166_2000 INTEGER,
pct012k167 INTEGER,
pct012k167_2000 INTEGER,
pct012k168 INTEGER,
pct012k168_2000 INTEGER,
pct012k169 INTEGER,
pct012k169_2000 INTEGER,
pct012k170 INTEGER,
pct012k170_2000 INTEGER,
pct012k171 INTEGER,
pct012k171_2000 INTEGER,
pct012k172 INTEGER,
pct012k172_2000 INTEGER,
pct012k173 INTEGER,
pct012k173_2000 INTEGER,
pct012k174 INTEGER,
pct012k174_2000 INTEGER,
pct012k175 INTEGER,
pct012k175_2000 INTEGER,
pct012k176 INTEGER,
pct012k176_2000 INTEGER,
pct012k177 INTEGER,
pct012k177_2000 INTEGER,
pct012k178 INTEGER,
pct012k178_2000 INTEGER,
pct012k179 INTEGER,
pct012k179_2000 INTEGER,
pct012k180 INTEGER,
pct012k180_2000 INTEGER,
pct012k181 INTEGER,
pct012k181_2000 INTEGER,
pct012k182 INTEGER,
pct012k182_2000 INTEGER,
pct012k183 INTEGER,
pct012k183_2000 INTEGER,
pct012k184 INTEGER,
pct012k184_2000 INTEGER,
pct012k185 INTEGER,
pct012k185_2000 INTEGER,
pct012k186 INTEGER,
pct012k186_2000 INTEGER,
pct012k187 INTEGER,
pct012k187_2000 INTEGER,
pct012k188 INTEGER,
pct012k188_2000 INTEGER,
pct012k189 INTEGER,
pct012k189_2000 INTEGER,
pct012k190 INTEGER,
pct012k190_2000 INTEGER,
pct012k191 INTEGER,
pct012k191_2000 INTEGER,
pct012k192 INTEGER,
pct012k192_2000 INTEGER,
pct012k193 INTEGER,
pct012k193_2000 INTEGER,
pct012k194 INTEGER,
pct012k194_2000 INTEGER,
pct012k195 INTEGER,
pct012k195_2000 INTEGER,
pct012k196 INTEGER,
pct012k196_2000 INTEGER,
pct012k197 INTEGER,
pct012k197_2000 INTEGER,
pct012k198 INTEGER,
pct012k198_2000 INTEGER,
pct012k199 INTEGER,
pct012k199_2000 INTEGER,
pct012k200 INTEGER,
pct012k200_2000 INTEGER,
pct012k201 INTEGER,
pct012k201_2000 INTEGER,
pct012k202 INTEGER,
pct012k202_2000 INTEGER,
pct012k203 INTEGER,
pct012k203_2000 INTEGER,
pct012k204 INTEGER,
pct012k204_2000 INTEGER,
pct012k205 INTEGER,
pct012k205_2000 INTEGER,
pct012k206 INTEGER,
pct012k206_2000 INTEGER,
pct012k207 INTEGER,
pct012k207_2000 INTEGER,
pct012k208 INTEGER,
pct012k208_2000 INTEGER,
pct012k209 INTEGER,
pct012k209_2000 INTEGER,