/
ire_P34F.sql
63 lines (63 loc) · 1.52 KB
/
ire_P34F.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
-- P34F. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (SOME OTHER RACE ALONE)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p34f (
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,
p034f001 INTEGER,
p034f001_2000 INTEGER,
p034f002 INTEGER,
p034f002_2000 INTEGER,
p034f003 INTEGER,
p034f003_2000 INTEGER,
p034f004 INTEGER,
p034f004_2000 INTEGER,
p034f005 INTEGER,
p034f005_2000 INTEGER,
p034f006 INTEGER,
p034f006_2000 INTEGER,
p034f007 INTEGER,
p034f007_2000 INTEGER,
p034f008 INTEGER,
p034f008_2000 INTEGER,
p034f009 INTEGER,
p034f009_2000 INTEGER,
p034f010 INTEGER,
p034f010_2000 INTEGER,
p034f011 INTEGER,
p034f011_2000 INTEGER,
p034f012 INTEGER,
p034f012_2000 INTEGER,
p034f013 INTEGER,
p034f013_2000 INTEGER,
p034f014 INTEGER,
p034f014_2000 INTEGER,
p034f015 INTEGER,
p034f015_2000 INTEGER,
p034f016 INTEGER,
p034f016_2000 INTEGER,
p034f017 INTEGER,
p034f017_2000 INTEGER,
p034f018 INTEGER,
p034f018_2000 INTEGER,
p034f019 INTEGER,
p034f019_2000 INTEGER,
p034f020 INTEGER,
p034f020_2000 INTEGER,
p034f021 INTEGER,
p034f021_2000 INTEGER,
p034f022 INTEGER,
p034f022_2000 INTEGER,
PRIMARY KEY (geoid)
);