-
Notifications
You must be signed in to change notification settings - Fork 33
/
ire_PCT19.sql
41 lines (41 loc) · 1 KB
/
ire_PCT19.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
-- PCT19. NONRELATIVES BY HOUSEHOLD TYPE
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_pct19 (
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,
pct019001 INTEGER,
pct019001_2000 INTEGER,
pct019002 INTEGER,
pct019002_2000 INTEGER,
pct019003 INTEGER,
pct019003_2000 INTEGER,
pct019004 INTEGER,
pct019004_2000 INTEGER,
pct019005 INTEGER,
pct019005_2000 INTEGER,
pct019006 INTEGER,
pct019006_2000 INTEGER,
pct019007 INTEGER,
pct019007_2000 INTEGER,
pct019008 INTEGER,
pct019008_2000 INTEGER,
pct019009 INTEGER,
pct019009_2000 INTEGER,
pct019010 INTEGER,
pct019010_2000 INTEGER,
pct019011 INTEGER,
pct019011_2000 INTEGER,
PRIMARY KEY (geoid)
);