/
ire_PCT15.sql
87 lines (87 loc) · 2.15 KB
/
ire_PCT15.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
-- PCT15. HUSBAND-WIFE AND UNMARRIED-PARTNER HOUSEHOLDS BY SEX OF PARTNER BY PRESENCE OF RELATED AND OWN CHILDREN UNDER 18 YEARS
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct15 (
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,
pct015001 INTEGER,
pct015001_2000 INTEGER,
pct015002 INTEGER,
pct015002_2000 INTEGER,
pct015003 INTEGER,
pct015003_2000 INTEGER,
pct015004 INTEGER,
pct015004_2000 INTEGER,
pct015005 INTEGER,
pct015005_2000 INTEGER,
pct015006 INTEGER,
pct015006_2000 INTEGER,
pct015007 INTEGER,
pct015007_2000 INTEGER,
pct015008 INTEGER,
pct015008_2000 INTEGER,
pct015009 INTEGER,
pct015009_2000 INTEGER,
pct015010 INTEGER,
pct015010_2000 INTEGER,
pct015011 INTEGER,
pct015011_2000 INTEGER,
pct015012 INTEGER,
pct015012_2000 INTEGER,
pct015013 INTEGER,
pct015013_2000 INTEGER,
pct015014 INTEGER,
pct015014_2000 INTEGER,
pct015015 INTEGER,
pct015015_2000 INTEGER,
pct015016 INTEGER,
pct015016_2000 INTEGER,
pct015017 INTEGER,
pct015017_2000 INTEGER,
pct015018 INTEGER,
pct015018_2000 INTEGER,
pct015019 INTEGER,
pct015019_2000 INTEGER,
pct015020 INTEGER,
pct015020_2000 INTEGER,
pct015021 INTEGER,
pct015021_2000 INTEGER,
pct015022 INTEGER,
pct015022_2000 INTEGER,
pct015023 INTEGER,
pct015023_2000 INTEGER,
pct015024 INTEGER,
pct015024_2000 INTEGER,
pct015025 INTEGER,
pct015025_2000 INTEGER,
pct015026 INTEGER,
pct015026_2000 INTEGER,
pct015027 INTEGER,
pct015027_2000 INTEGER,
pct015028 INTEGER,
pct015028_2000 INTEGER,
pct015029 INTEGER,
pct015029_2000 INTEGER,
pct015030 INTEGER,
pct015030_2000 INTEGER,
pct015031 INTEGER,
pct015031_2000 INTEGER,
pct015032 INTEGER,
pct015032_2000 INTEGER,
pct015033 INTEGER,
pct015033_2000 INTEGER,
pct015034 INTEGER,
pct015034_2000 INTEGER,
PRIMARY KEY (geoid)
);