-
Notifications
You must be signed in to change notification settings - Fork 33
/
ire_H16B.sql
53 lines (53 loc) · 1.28 KB
/
ire_H16B.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
-- H16B. TENURE BY HOUSEHOLD SIZE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER)
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_h16b (
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,
h016b001 INTEGER,
h016b001_2000 INTEGER,
h016b002 INTEGER,
h016b002_2000 INTEGER,
h016b003 INTEGER,
h016b003_2000 INTEGER,
h016b004 INTEGER,
h016b004_2000 INTEGER,
h016b005 INTEGER,
h016b005_2000 INTEGER,
h016b006 INTEGER,
h016b006_2000 INTEGER,
h016b007 INTEGER,
h016b007_2000 INTEGER,
h016b008 INTEGER,
h016b008_2000 INTEGER,
h016b009 INTEGER,
h016b009_2000 INTEGER,
h016b010 INTEGER,
h016b010_2000 INTEGER,
h016b011 INTEGER,
h016b011_2000 INTEGER,
h016b012 INTEGER,
h016b012_2000 INTEGER,
h016b013 INTEGER,
h016b013_2000 INTEGER,
h016b014 INTEGER,
h016b014_2000 INTEGER,
h016b015 INTEGER,
h016b015_2000 INTEGER,
h016b016 INTEGER,
h016b016_2000 INTEGER,
h016b017 INTEGER,
h016b017_2000 INTEGER,
PRIMARY KEY (geoid)
);