-
Notifications
You must be signed in to change notification settings - Fork 33
/
ire_PCT13B.sql
117 lines (117 loc) · 2.89 KB
/
ire_PCT13B.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
-- PCT13B. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (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_pct13b (
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,
pct013b001 INTEGER,
pct013b001_2000 INTEGER,
pct013b002 INTEGER,
pct013b002_2000 INTEGER,
pct013b003 INTEGER,
pct013b003_2000 INTEGER,
pct013b004 INTEGER,
pct013b004_2000 INTEGER,
pct013b005 INTEGER,
pct013b005_2000 INTEGER,
pct013b006 INTEGER,
pct013b006_2000 INTEGER,
pct013b007 INTEGER,
pct013b007_2000 INTEGER,
pct013b008 INTEGER,
pct013b008_2000 INTEGER,
pct013b009 INTEGER,
pct013b009_2000 INTEGER,
pct013b010 INTEGER,
pct013b010_2000 INTEGER,
pct013b011 INTEGER,
pct013b011_2000 INTEGER,
pct013b012 INTEGER,
pct013b012_2000 INTEGER,
pct013b013 INTEGER,
pct013b013_2000 INTEGER,
pct013b014 INTEGER,
pct013b014_2000 INTEGER,
pct013b015 INTEGER,
pct013b015_2000 INTEGER,
pct013b016 INTEGER,
pct013b016_2000 INTEGER,
pct013b017 INTEGER,
pct013b017_2000 INTEGER,
pct013b018 INTEGER,
pct013b018_2000 INTEGER,
pct013b019 INTEGER,
pct013b019_2000 INTEGER,
pct013b020 INTEGER,
pct013b020_2000 INTEGER,
pct013b021 INTEGER,
pct013b021_2000 INTEGER,
pct013b022 INTEGER,
pct013b022_2000 INTEGER,
pct013b023 INTEGER,
pct013b023_2000 INTEGER,
pct013b024 INTEGER,
pct013b024_2000 INTEGER,
pct013b025 INTEGER,
pct013b025_2000 INTEGER,
pct013b026 INTEGER,
pct013b026_2000 INTEGER,
pct013b027 INTEGER,
pct013b027_2000 INTEGER,
pct013b028 INTEGER,
pct013b028_2000 INTEGER,
pct013b029 INTEGER,
pct013b029_2000 INTEGER,
pct013b030 INTEGER,
pct013b030_2000 INTEGER,
pct013b031 INTEGER,
pct013b031_2000 INTEGER,
pct013b032 INTEGER,
pct013b032_2000 INTEGER,
pct013b033 INTEGER,
pct013b033_2000 INTEGER,
pct013b034 INTEGER,
pct013b034_2000 INTEGER,
pct013b035 INTEGER,
pct013b035_2000 INTEGER,
pct013b036 INTEGER,
pct013b036_2000 INTEGER,
pct013b037 INTEGER,
pct013b037_2000 INTEGER,
pct013b038 INTEGER,
pct013b038_2000 INTEGER,
pct013b039 INTEGER,
pct013b039_2000 INTEGER,
pct013b040 INTEGER,
pct013b040_2000 INTEGER,
pct013b041 INTEGER,
pct013b041_2000 INTEGER,
pct013b042 INTEGER,
pct013b042_2000 INTEGER,
pct013b043 INTEGER,
pct013b043_2000 INTEGER,
pct013b044 INTEGER,
pct013b044_2000 INTEGER,
pct013b045 INTEGER,
pct013b045_2000 INTEGER,
pct013b046 INTEGER,
pct013b046_2000 INTEGER,
pct013b047 INTEGER,
pct013b047_2000 INTEGER,
pct013b048 INTEGER,
pct013b048_2000 INTEGER,
pct013b049 INTEGER,
pct013b049_2000 INTEGER,
PRIMARY KEY (geoid)
);