/
ire_P15.sql
53 lines (53 loc) · 1.24 KB
/
ire_P15.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
-- P15. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER BY RACE OF HOUSEHOLDER
-- designed to work with the IRE Census bulk data exports
-- see http://census.ire.org/data/bulkdata.html
CREATE TABLE ire_p15 (
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,
p015001 INTEGER,
p015001_2000 INTEGER,
p015002 INTEGER,
p015002_2000 INTEGER,
p015003 INTEGER,
p015003_2000 INTEGER,
p015004 INTEGER,
p015004_2000 INTEGER,
p015005 INTEGER,
p015005_2000 INTEGER,
p015006 INTEGER,
p015006_2000 INTEGER,
p015007 INTEGER,
p015007_2000 INTEGER,
p015008 INTEGER,
p015008_2000 INTEGER,
p015009 INTEGER,
p015009_2000 INTEGER,
p015010 INTEGER,
p015010_2000 INTEGER,
p015011 INTEGER,
p015011_2000 INTEGER,
p015012 INTEGER,
p015012_2000 INTEGER,
p015013 INTEGER,
p015013_2000 INTEGER,
p015014 INTEGER,
p015014_2000 INTEGER,
p015015 INTEGER,
p015015_2000 INTEGER,
p015016 INTEGER,
p015016_2000 INTEGER,
p015017 INTEGER,
p015017_2000 INTEGER,
PRIMARY KEY (geoid)
);