/
ire_PCT12B.sql
437 lines (437 loc) · 10.5 KB
/
ire_PCT12B.sql
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
-- PCT12B. SEX BY AGE (BLACK OR AFRICAN AMERICAN ALONE)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct12b (
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,
pct012b001 INTEGER,
pct012b001_2000 INTEGER,
pct012b002 INTEGER,
pct012b002_2000 INTEGER,
pct012b003 INTEGER,
pct012b003_2000 INTEGER,
pct012b004 INTEGER,
pct012b004_2000 INTEGER,
pct012b005 INTEGER,
pct012b005_2000 INTEGER,
pct012b006 INTEGER,
pct012b006_2000 INTEGER,
pct012b007 INTEGER,
pct012b007_2000 INTEGER,
pct012b008 INTEGER,
pct012b008_2000 INTEGER,
pct012b009 INTEGER,
pct012b009_2000 INTEGER,
pct012b010 INTEGER,
pct012b010_2000 INTEGER,
pct012b011 INTEGER,
pct012b011_2000 INTEGER,
pct012b012 INTEGER,
pct012b012_2000 INTEGER,
pct012b013 INTEGER,
pct012b013_2000 INTEGER,
pct012b014 INTEGER,
pct012b014_2000 INTEGER,
pct012b015 INTEGER,
pct012b015_2000 INTEGER,
pct012b016 INTEGER,
pct012b016_2000 INTEGER,
pct012b017 INTEGER,
pct012b017_2000 INTEGER,
pct012b018 INTEGER,
pct012b018_2000 INTEGER,
pct012b019 INTEGER,
pct012b019_2000 INTEGER,
pct012b020 INTEGER,
pct012b020_2000 INTEGER,
pct012b021 INTEGER,
pct012b021_2000 INTEGER,
pct012b022 INTEGER,
pct012b022_2000 INTEGER,
pct012b023 INTEGER,
pct012b023_2000 INTEGER,
pct012b024 INTEGER,
pct012b024_2000 INTEGER,
pct012b025 INTEGER,
pct012b025_2000 INTEGER,
pct012b026 INTEGER,
pct012b026_2000 INTEGER,
pct012b027 INTEGER,
pct012b027_2000 INTEGER,
pct012b028 INTEGER,
pct012b028_2000 INTEGER,
pct012b029 INTEGER,
pct012b029_2000 INTEGER,
pct012b030 INTEGER,
pct012b030_2000 INTEGER,
pct012b031 INTEGER,
pct012b031_2000 INTEGER,
pct012b032 INTEGER,
pct012b032_2000 INTEGER,
pct012b033 INTEGER,
pct012b033_2000 INTEGER,
pct012b034 INTEGER,
pct012b034_2000 INTEGER,
pct012b035 INTEGER,
pct012b035_2000 INTEGER,
pct012b036 INTEGER,
pct012b036_2000 INTEGER,
pct012b037 INTEGER,
pct012b037_2000 INTEGER,
pct012b038 INTEGER,
pct012b038_2000 INTEGER,
pct012b039 INTEGER,
pct012b039_2000 INTEGER,
pct012b040 INTEGER,
pct012b040_2000 INTEGER,
pct012b041 INTEGER,
pct012b041_2000 INTEGER,
pct012b042 INTEGER,
pct012b042_2000 INTEGER,
pct012b043 INTEGER,
pct012b043_2000 INTEGER,
pct012b044 INTEGER,
pct012b044_2000 INTEGER,
pct012b045 INTEGER,
pct012b045_2000 INTEGER,
pct012b046 INTEGER,
pct012b046_2000 INTEGER,
pct012b047 INTEGER,
pct012b047_2000 INTEGER,
pct012b048 INTEGER,
pct012b048_2000 INTEGER,
pct012b049 INTEGER,
pct012b049_2000 INTEGER,
pct012b050 INTEGER,
pct012b050_2000 INTEGER,
pct012b051 INTEGER,
pct012b051_2000 INTEGER,
pct012b052 INTEGER,
pct012b052_2000 INTEGER,
pct012b053 INTEGER,
pct012b053_2000 INTEGER,
pct012b054 INTEGER,
pct012b054_2000 INTEGER,
pct012b055 INTEGER,
pct012b055_2000 INTEGER,
pct012b056 INTEGER,
pct012b056_2000 INTEGER,
pct012b057 INTEGER,
pct012b057_2000 INTEGER,
pct012b058 INTEGER,
pct012b058_2000 INTEGER,
pct012b059 INTEGER,
pct012b059_2000 INTEGER,
pct012b060 INTEGER,
pct012b060_2000 INTEGER,
pct012b061 INTEGER,
pct012b061_2000 INTEGER,
pct012b062 INTEGER,
pct012b062_2000 INTEGER,
pct012b063 INTEGER,
pct012b063_2000 INTEGER,
pct012b064 INTEGER,
pct012b064_2000 INTEGER,
pct012b065 INTEGER,
pct012b065_2000 INTEGER,
pct012b066 INTEGER,
pct012b066_2000 INTEGER,
pct012b067 INTEGER,
pct012b067_2000 INTEGER,
pct012b068 INTEGER,
pct012b068_2000 INTEGER,
pct012b069 INTEGER,
pct012b069_2000 INTEGER,
pct012b070 INTEGER,
pct012b070_2000 INTEGER,
pct012b071 INTEGER,
pct012b071_2000 INTEGER,
pct012b072 INTEGER,
pct012b072_2000 INTEGER,
pct012b073 INTEGER,
pct012b073_2000 INTEGER,
pct012b074 INTEGER,
pct012b074_2000 INTEGER,
pct012b075 INTEGER,
pct012b075_2000 INTEGER,
pct012b076 INTEGER,
pct012b076_2000 INTEGER,
pct012b077 INTEGER,
pct012b077_2000 INTEGER,
pct012b078 INTEGER,
pct012b078_2000 INTEGER,
pct012b079 INTEGER,
pct012b079_2000 INTEGER,
pct012b080 INTEGER,
pct012b080_2000 INTEGER,
pct012b081 INTEGER,
pct012b081_2000 INTEGER,
pct012b082 INTEGER,
pct012b082_2000 INTEGER,
pct012b083 INTEGER,
pct012b083_2000 INTEGER,
pct012b084 INTEGER,
pct012b084_2000 INTEGER,
pct012b085 INTEGER,
pct012b085_2000 INTEGER,
pct012b086 INTEGER,
pct012b086_2000 INTEGER,
pct012b087 INTEGER,
pct012b087_2000 INTEGER,
pct012b088 INTEGER,
pct012b088_2000 INTEGER,
pct012b089 INTEGER,
pct012b089_2000 INTEGER,
pct012b090 INTEGER,
pct012b090_2000 INTEGER,
pct012b091 INTEGER,
pct012b091_2000 INTEGER,
pct012b092 INTEGER,
pct012b092_2000 INTEGER,
pct012b093 INTEGER,
pct012b093_2000 INTEGER,
pct012b094 INTEGER,
pct012b094_2000 INTEGER,
pct012b095 INTEGER,
pct012b095_2000 INTEGER,
pct012b096 INTEGER,
pct012b096_2000 INTEGER,
pct012b097 INTEGER,
pct012b097_2000 INTEGER,
pct012b098 INTEGER,
pct012b098_2000 INTEGER,
pct012b099 INTEGER,
pct012b099_2000 INTEGER,
pct012b100 INTEGER,
pct012b100_2000 INTEGER,
pct012b101 INTEGER,
pct012b101_2000 INTEGER,
pct012b102 INTEGER,
pct012b102_2000 INTEGER,
pct012b103 INTEGER,
pct012b103_2000 INTEGER,
pct012b104 INTEGER,
pct012b104_2000 INTEGER,
pct012b105 INTEGER,
pct012b105_2000 INTEGER,
pct012b106 INTEGER,
pct012b106_2000 INTEGER,
pct012b107 INTEGER,
pct012b107_2000 INTEGER,
pct012b108 INTEGER,
pct012b108_2000 INTEGER,
pct012b109 INTEGER,
pct012b109_2000 INTEGER,
pct012b110 INTEGER,
pct012b110_2000 INTEGER,
pct012b111 INTEGER,
pct012b111_2000 INTEGER,
pct012b112 INTEGER,
pct012b112_2000 INTEGER,
pct012b113 INTEGER,
pct012b113_2000 INTEGER,
pct012b114 INTEGER,
pct012b114_2000 INTEGER,
pct012b115 INTEGER,
pct012b115_2000 INTEGER,
pct012b116 INTEGER,
pct012b116_2000 INTEGER,
pct012b117 INTEGER,
pct012b117_2000 INTEGER,
pct012b118 INTEGER,
pct012b118_2000 INTEGER,
pct012b119 INTEGER,
pct012b119_2000 INTEGER,
pct012b120 INTEGER,
pct012b120_2000 INTEGER,
pct012b121 INTEGER,
pct012b121_2000 INTEGER,
pct012b122 INTEGER,
pct012b122_2000 INTEGER,
pct012b123 INTEGER,
pct012b123_2000 INTEGER,
pct012b124 INTEGER,
pct012b124_2000 INTEGER,
pct012b125 INTEGER,
pct012b125_2000 INTEGER,
pct012b126 INTEGER,
pct012b126_2000 INTEGER,
pct012b127 INTEGER,
pct012b127_2000 INTEGER,
pct012b128 INTEGER,
pct012b128_2000 INTEGER,
pct012b129 INTEGER,
pct012b129_2000 INTEGER,
pct012b130 INTEGER,
pct012b130_2000 INTEGER,
pct012b131 INTEGER,
pct012b131_2000 INTEGER,
pct012b132 INTEGER,
pct012b132_2000 INTEGER,
pct012b133 INTEGER,
pct012b133_2000 INTEGER,
pct012b134 INTEGER,
pct012b134_2000 INTEGER,
pct012b135 INTEGER,
pct012b135_2000 INTEGER,
pct012b136 INTEGER,
pct012b136_2000 INTEGER,
pct012b137 INTEGER,
pct012b137_2000 INTEGER,
pct012b138 INTEGER,
pct012b138_2000 INTEGER,
pct012b139 INTEGER,
pct012b139_2000 INTEGER,
pct012b140 INTEGER,
pct012b140_2000 INTEGER,
pct012b141 INTEGER,
pct012b141_2000 INTEGER,
pct012b142 INTEGER,
pct012b142_2000 INTEGER,
pct012b143 INTEGER,
pct012b143_2000 INTEGER,
pct012b144 INTEGER,
pct012b144_2000 INTEGER,
pct012b145 INTEGER,
pct012b145_2000 INTEGER,
pct012b146 INTEGER,
pct012b146_2000 INTEGER,
pct012b147 INTEGER,
pct012b147_2000 INTEGER,
pct012b148 INTEGER,
pct012b148_2000 INTEGER,
pct012b149 INTEGER,
pct012b149_2000 INTEGER,
pct012b150 INTEGER,
pct012b150_2000 INTEGER,
pct012b151 INTEGER,
pct012b151_2000 INTEGER,
pct012b152 INTEGER,
pct012b152_2000 INTEGER,
pct012b153 INTEGER,
pct012b153_2000 INTEGER,
pct012b154 INTEGER,
pct012b154_2000 INTEGER,
pct012b155 INTEGER,
pct012b155_2000 INTEGER,
pct012b156 INTEGER,
pct012b156_2000 INTEGER,
pct012b157 INTEGER,
pct012b157_2000 INTEGER,
pct012b158 INTEGER,
pct012b158_2000 INTEGER,
pct012b159 INTEGER,
pct012b159_2000 INTEGER,
pct012b160 INTEGER,
pct012b160_2000 INTEGER,
pct012b161 INTEGER,
pct012b161_2000 INTEGER,
pct012b162 INTEGER,
pct012b162_2000 INTEGER,
pct012b163 INTEGER,
pct012b163_2000 INTEGER,
pct012b164 INTEGER,
pct012b164_2000 INTEGER,
pct012b165 INTEGER,
pct012b165_2000 INTEGER,
pct012b166 INTEGER,
pct012b166_2000 INTEGER,
pct012b167 INTEGER,
pct012b167_2000 INTEGER,
pct012b168 INTEGER,
pct012b168_2000 INTEGER,
pct012b169 INTEGER,
pct012b169_2000 INTEGER,
pct012b170 INTEGER,
pct012b170_2000 INTEGER,
pct012b171 INTEGER,
pct012b171_2000 INTEGER,
pct012b172 INTEGER,
pct012b172_2000 INTEGER,
pct012b173 INTEGER,
pct012b173_2000 INTEGER,
pct012b174 INTEGER,
pct012b174_2000 INTEGER,
pct012b175 INTEGER,
pct012b175_2000 INTEGER,
pct012b176 INTEGER,
pct012b176_2000 INTEGER,
pct012b177 INTEGER,
pct012b177_2000 INTEGER,
pct012b178 INTEGER,
pct012b178_2000 INTEGER,
pct012b179 INTEGER,
pct012b179_2000 INTEGER,
pct012b180 INTEGER,
pct012b180_2000 INTEGER,
pct012b181 INTEGER,
pct012b181_2000 INTEGER,
pct012b182 INTEGER,
pct012b182_2000 INTEGER,
pct012b183 INTEGER,
pct012b183_2000 INTEGER,
pct012b184 INTEGER,
pct012b184_2000 INTEGER,
pct012b185 INTEGER,
pct012b185_2000 INTEGER,
pct012b186 INTEGER,
pct012b186_2000 INTEGER,
pct012b187 INTEGER,
pct012b187_2000 INTEGER,
pct012b188 INTEGER,
pct012b188_2000 INTEGER,
pct012b189 INTEGER,
pct012b189_2000 INTEGER,
pct012b190 INTEGER,
pct012b190_2000 INTEGER,
pct012b191 INTEGER,
pct012b191_2000 INTEGER,
pct012b192 INTEGER,
pct012b192_2000 INTEGER,
pct012b193 INTEGER,
pct012b193_2000 INTEGER,
pct012b194 INTEGER,
pct012b194_2000 INTEGER,
pct012b195 INTEGER,
pct012b195_2000 INTEGER,
pct012b196 INTEGER,
pct012b196_2000 INTEGER,
pct012b197 INTEGER,
pct012b197_2000 INTEGER,
pct012b198 INTEGER,
pct012b198_2000 INTEGER,
pct012b199 INTEGER,
pct012b199_2000 INTEGER,
pct012b200 INTEGER,
pct012b200_2000 INTEGER,
pct012b201 INTEGER,
pct012b201_2000 INTEGER,
pct012b202 INTEGER,
pct012b202_2000 INTEGER,
pct012b203 INTEGER,
pct012b203_2000 INTEGER,
pct012b204 INTEGER,
pct012b204_2000 INTEGER,
pct012b205 INTEGER,
pct012b205_2000 INTEGER,
pct012b206 INTEGER,
pct012b206_2000 INTEGER,
pct012b207 INTEGER,
pct012b207_2000 INTEGER,
pct012b208 INTEGER,
pct012b208_2000 INTEGER,
pct012b209 INTEGER,
pct012b209_2000 INTEGER,
PRIMARY KEY (geoid)
);