Skip to content
This repository
branch: master
Fetching contributors…

Cannot retrieve contributors at this time

file 437 lines (437 sloc) 10.776 kb
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437
-- PCT12C. SEX BY AGE (AMERICAN INDIAN AND ALASKA NATIVE ALONE)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct12c (
geoid VARCHAR(11) NOT NULL,
sumlev VARCHAR(3) NOT NULL,
state VARCHAR(2) NOT NULL,
county VARCHAR(3),
cbsa VARCHAR(5),
csa VARCHAR(3),
necta VARCHAR(5),
cnecta VARCHAR(3),
name VARCHAR(90) NOT NULL,
pop100 INTEGER NOT NULL,
hu100 INTEGER NOT NULL,
pop100_2000 INTEGER,
hu100_2000 INTEGER,
pct012c001 INTEGER,
pct012c001_2000 INTEGER,
pct012c002 INTEGER,
pct012c002_2000 INTEGER,
pct012c003 INTEGER,
pct012c003_2000 INTEGER,
pct012c004 INTEGER,
pct012c004_2000 INTEGER,
pct012c005 INTEGER,
pct012c005_2000 INTEGER,
pct012c006 INTEGER,
pct012c006_2000 INTEGER,
pct012c007 INTEGER,
pct012c007_2000 INTEGER,
pct012c008 INTEGER,
pct012c008_2000 INTEGER,
pct012c009 INTEGER,
pct012c009_2000 INTEGER,
pct012c010 INTEGER,
pct012c010_2000 INTEGER,
pct012c011 INTEGER,
pct012c011_2000 INTEGER,
pct012c012 INTEGER,
pct012c012_2000 INTEGER,
pct012c013 INTEGER,
pct012c013_2000 INTEGER,
pct012c014 INTEGER,
pct012c014_2000 INTEGER,
pct012c015 INTEGER,
pct012c015_2000 INTEGER,
pct012c016 INTEGER,
pct012c016_2000 INTEGER,
pct012c017 INTEGER,
pct012c017_2000 INTEGER,
pct012c018 INTEGER,
pct012c018_2000 INTEGER,
pct012c019 INTEGER,
pct012c019_2000 INTEGER,
pct012c020 INTEGER,
pct012c020_2000 INTEGER,
pct012c021 INTEGER,
pct012c021_2000 INTEGER,
pct012c022 INTEGER,
pct012c022_2000 INTEGER,
pct012c023 INTEGER,
pct012c023_2000 INTEGER,
pct012c024 INTEGER,
pct012c024_2000 INTEGER,
pct012c025 INTEGER,
pct012c025_2000 INTEGER,
pct012c026 INTEGER,
pct012c026_2000 INTEGER,
pct012c027 INTEGER,
pct012c027_2000 INTEGER,
pct012c028 INTEGER,
pct012c028_2000 INTEGER,
pct012c029 INTEGER,
pct012c029_2000 INTEGER,
pct012c030 INTEGER,
pct012c030_2000 INTEGER,
pct012c031 INTEGER,
pct012c031_2000 INTEGER,
pct012c032 INTEGER,
pct012c032_2000 INTEGER,
pct012c033 INTEGER,
pct012c033_2000 INTEGER,
pct012c034 INTEGER,
pct012c034_2000 INTEGER,
pct012c035 INTEGER,
pct012c035_2000 INTEGER,
pct012c036 INTEGER,
pct012c036_2000 INTEGER,
pct012c037 INTEGER,
pct012c037_2000 INTEGER,
pct012c038 INTEGER,
pct012c038_2000 INTEGER,
pct012c039 INTEGER,
pct012c039_2000 INTEGER,
pct012c040 INTEGER,
pct012c040_2000 INTEGER,
pct012c041 INTEGER,
pct012c041_2000 INTEGER,
pct012c042 INTEGER,
pct012c042_2000 INTEGER,
pct012c043 INTEGER,
pct012c043_2000 INTEGER,
pct012c044 INTEGER,
pct012c044_2000 INTEGER,
pct012c045 INTEGER,
pct012c045_2000 INTEGER,
pct012c046 INTEGER,
pct012c046_2000 INTEGER,
pct012c047 INTEGER,
pct012c047_2000 INTEGER,
pct012c048 INTEGER,
pct012c048_2000 INTEGER,
pct012c049 INTEGER,
pct012c049_2000 INTEGER,
pct012c050 INTEGER,
pct012c050_2000 INTEGER,
pct012c051 INTEGER,
pct012c051_2000 INTEGER,
pct012c052 INTEGER,
pct012c052_2000 INTEGER,
pct012c053 INTEGER,
pct012c053_2000 INTEGER,
pct012c054 INTEGER,
pct012c054_2000 INTEGER,
pct012c055 INTEGER,
pct012c055_2000 INTEGER,
pct012c056 INTEGER,
pct012c056_2000 INTEGER,
pct012c057 INTEGER,
pct012c057_2000 INTEGER,
pct012c058 INTEGER,
pct012c058_2000 INTEGER,
pct012c059 INTEGER,
pct012c059_2000 INTEGER,
pct012c060 INTEGER,
pct012c060_2000 INTEGER,
pct012c061 INTEGER,
pct012c061_2000 INTEGER,
pct012c062 INTEGER,
pct012c062_2000 INTEGER,
pct012c063 INTEGER,
pct012c063_2000 INTEGER,
pct012c064 INTEGER,
pct012c064_2000 INTEGER,
pct012c065 INTEGER,
pct012c065_2000 INTEGER,
pct012c066 INTEGER,
pct012c066_2000 INTEGER,
pct012c067 INTEGER,
pct012c067_2000 INTEGER,
pct012c068 INTEGER,
pct012c068_2000 INTEGER,
pct012c069 INTEGER,
pct012c069_2000 INTEGER,
pct012c070 INTEGER,
pct012c070_2000 INTEGER,
pct012c071 INTEGER,
pct012c071_2000 INTEGER,
pct012c072 INTEGER,
pct012c072_2000 INTEGER,
pct012c073 INTEGER,
pct012c073_2000 INTEGER,
pct012c074 INTEGER,
pct012c074_2000 INTEGER,
pct012c075 INTEGER,
pct012c075_2000 INTEGER,
pct012c076 INTEGER,
pct012c076_2000 INTEGER,
pct012c077 INTEGER,
pct012c077_2000 INTEGER,
pct012c078 INTEGER,
pct012c078_2000 INTEGER,
pct012c079 INTEGER,
pct012c079_2000 INTEGER,
pct012c080 INTEGER,
pct012c080_2000 INTEGER,
pct012c081 INTEGER,
pct012c081_2000 INTEGER,
pct012c082 INTEGER,
pct012c082_2000 INTEGER,
pct012c083 INTEGER,
pct012c083_2000 INTEGER,
pct012c084 INTEGER,
pct012c084_2000 INTEGER,
pct012c085 INTEGER,
pct012c085_2000 INTEGER,
pct012c086 INTEGER,
pct012c086_2000 INTEGER,
pct012c087 INTEGER,
pct012c087_2000 INTEGER,
pct012c088 INTEGER,
pct012c088_2000 INTEGER,
pct012c089 INTEGER,
pct012c089_2000 INTEGER,
pct012c090 INTEGER,
pct012c090_2000 INTEGER,
pct012c091 INTEGER,
pct012c091_2000 INTEGER,
pct012c092 INTEGER,
pct012c092_2000 INTEGER,
pct012c093 INTEGER,
pct012c093_2000 INTEGER,
pct012c094 INTEGER,
pct012c094_2000 INTEGER,
pct012c095 INTEGER,
pct012c095_2000 INTEGER,
pct012c096 INTEGER,
pct012c096_2000 INTEGER,
pct012c097 INTEGER,
pct012c097_2000 INTEGER,
pct012c098 INTEGER,
pct012c098_2000 INTEGER,
pct012c099 INTEGER,
pct012c099_2000 INTEGER,
pct012c100 INTEGER,
pct012c100_2000 INTEGER,
pct012c101 INTEGER,
pct012c101_2000 INTEGER,
pct012c102 INTEGER,
pct012c102_2000 INTEGER,
pct012c103 INTEGER,
pct012c103_2000 INTEGER,
pct012c104 INTEGER,
pct012c104_2000 INTEGER,
pct012c105 INTEGER,
pct012c105_2000 INTEGER,
pct012c106 INTEGER,
pct012c106_2000 INTEGER,
pct012c107 INTEGER,
pct012c107_2000 INTEGER,
pct012c108 INTEGER,
pct012c108_2000 INTEGER,
pct012c109 INTEGER,
pct012c109_2000 INTEGER,
pct012c110 INTEGER,
pct012c110_2000 INTEGER,
pct012c111 INTEGER,
pct012c111_2000 INTEGER,
pct012c112 INTEGER,
pct012c112_2000 INTEGER,
pct012c113 INTEGER,
pct012c113_2000 INTEGER,
pct012c114 INTEGER,
pct012c114_2000 INTEGER,
pct012c115 INTEGER,
pct012c115_2000 INTEGER,
pct012c116 INTEGER,
pct012c116_2000 INTEGER,
pct012c117 INTEGER,
pct012c117_2000 INTEGER,
pct012c118 INTEGER,
pct012c118_2000 INTEGER,
pct012c119 INTEGER,
pct012c119_2000 INTEGER,
pct012c120 INTEGER,
pct012c120_2000 INTEGER,
pct012c121 INTEGER,
pct012c121_2000 INTEGER,
pct012c122 INTEGER,
pct012c122_2000 INTEGER,
pct012c123 INTEGER,
pct012c123_2000 INTEGER,
pct012c124 INTEGER,
pct012c124_2000 INTEGER,
pct012c125 INTEGER,
pct012c125_2000 INTEGER,
pct012c126 INTEGER,
pct012c126_2000 INTEGER,
pct012c127 INTEGER,
pct012c127_2000 INTEGER,
pct012c128 INTEGER,
pct012c128_2000 INTEGER,
pct012c129 INTEGER,
pct012c129_2000 INTEGER,
pct012c130 INTEGER,
pct012c130_2000 INTEGER,
pct012c131 INTEGER,
pct012c131_2000 INTEGER,
pct012c132 INTEGER,
pct012c132_2000 INTEGER,
pct012c133 INTEGER,
pct012c133_2000 INTEGER,
pct012c134 INTEGER,
pct012c134_2000 INTEGER,
pct012c135 INTEGER,
pct012c135_2000 INTEGER,
pct012c136 INTEGER,
pct012c136_2000 INTEGER,
pct012c137 INTEGER,
pct012c137_2000 INTEGER,
pct012c138 INTEGER,
pct012c138_2000 INTEGER,
pct012c139 INTEGER,
pct012c139_2000 INTEGER,
pct012c140 INTEGER,
pct012c140_2000 INTEGER,
pct012c141 INTEGER,
pct012c141_2000 INTEGER,
pct012c142 INTEGER,
pct012c142_2000 INTEGER,
pct012c143 INTEGER,
pct012c143_2000 INTEGER,
pct012c144 INTEGER,
pct012c144_2000 INTEGER,
pct012c145 INTEGER,
pct012c145_2000 INTEGER,
pct012c146 INTEGER,
pct012c146_2000 INTEGER,
pct012c147 INTEGER,
pct012c147_2000 INTEGER,
pct012c148 INTEGER,
pct012c148_2000 INTEGER,
pct012c149 INTEGER,
pct012c149_2000 INTEGER,
pct012c150 INTEGER,
pct012c150_2000 INTEGER,
pct012c151 INTEGER,
pct012c151_2000 INTEGER,
pct012c152 INTEGER,
pct012c152_2000 INTEGER,
pct012c153 INTEGER,
pct012c153_2000 INTEGER,
pct012c154 INTEGER,
pct012c154_2000 INTEGER,
pct012c155 INTEGER,
pct012c155_2000 INTEGER,
pct012c156 INTEGER,
pct012c156_2000 INTEGER,
pct012c157 INTEGER,
pct012c157_2000 INTEGER,
pct012c158 INTEGER,
pct012c158_2000 INTEGER,
pct012c159 INTEGER,
pct012c159_2000 INTEGER,
pct012c160 INTEGER,
pct012c160_2000 INTEGER,
pct012c161 INTEGER,
pct012c161_2000 INTEGER,
pct012c162 INTEGER,
pct012c162_2000 INTEGER,
pct012c163 INTEGER,
pct012c163_2000 INTEGER,
pct012c164 INTEGER,
pct012c164_2000 INTEGER,
pct012c165 INTEGER,
pct012c165_2000 INTEGER,
pct012c166 INTEGER,
pct012c166_2000 INTEGER,
pct012c167 INTEGER,
pct012c167_2000 INTEGER,
pct012c168 INTEGER,
pct012c168_2000 INTEGER,
pct012c169 INTEGER,
pct012c169_2000 INTEGER,
pct012c170 INTEGER,
pct012c170_2000 INTEGER,
pct012c171 INTEGER,
pct012c171_2000 INTEGER,
pct012c172 INTEGER,
pct012c172_2000 INTEGER,
pct012c173 INTEGER,
pct012c173_2000 INTEGER,
pct012c174 INTEGER,
pct012c174_2000 INTEGER,
pct012c175 INTEGER,
pct012c175_2000 INTEGER,
pct012c176 INTEGER,
pct012c176_2000 INTEGER,
pct012c177 INTEGER,
pct012c177_2000 INTEGER,
pct012c178 INTEGER,
pct012c178_2000 INTEGER,
pct012c179 INTEGER,
pct012c179_2000 INTEGER,
pct012c180 INTEGER,
pct012c180_2000 INTEGER,
pct012c181 INTEGER,
pct012c181_2000 INTEGER,
pct012c182 INTEGER,
pct012c182_2000 INTEGER,
pct012c183 INTEGER,
pct012c183_2000 INTEGER,
pct012c184 INTEGER,
pct012c184_2000 INTEGER,
pct012c185 INTEGER,
pct012c185_2000 INTEGER,
pct012c186 INTEGER,
pct012c186_2000 INTEGER,
pct012c187 INTEGER,
pct012c187_2000 INTEGER,
pct012c188 INTEGER,
pct012c188_2000 INTEGER,
pct012c189 INTEGER,
pct012c189_2000 INTEGER,
pct012c190 INTEGER,
pct012c190_2000 INTEGER,
pct012c191 INTEGER,
pct012c191_2000 INTEGER,
pct012c192 INTEGER,
pct012c192_2000 INTEGER,
pct012c193 INTEGER,
pct012c193_2000 INTEGER,
pct012c194 INTEGER,
pct012c194_2000 INTEGER,
pct012c195 INTEGER,
pct012c195_2000 INTEGER,
pct012c196 INTEGER,
pct012c196_2000 INTEGER,
pct012c197 INTEGER,
pct012c197_2000 INTEGER,
pct012c198 INTEGER,
pct012c198_2000 INTEGER,
pct012c199 INTEGER,
pct012c199_2000 INTEGER,
pct012c200 INTEGER,
pct012c200_2000 INTEGER,
pct012c201 INTEGER,
pct012c201_2000 INTEGER,
pct012c202 INTEGER,
pct012c202_2000 INTEGER,
pct012c203 INTEGER,
pct012c203_2000 INTEGER,
pct012c204 INTEGER,
pct012c204_2000 INTEGER,
pct012c205 INTEGER,
pct012c205_2000 INTEGER,
pct012c206 INTEGER,
pct012c206_2000 INTEGER,
pct012c207 INTEGER,
pct012c207_2000 INTEGER,
pct012c208 INTEGER,
pct012c208_2000 INTEGER,
pct012c209 INTEGER,
pct012c209_2000 INTEGER,
PRIMARY KEY (geoid)
);
Something went wrong with that request. Please try again.