Skip to content
Newer
Older
100644 48 lines (47 sloc) 1.25 KB
f36866c @JoeGermuska create table DDL for bulkdata export format
JoeGermuska authored Jul 28, 2011
1 -- PCT9. NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE WITH ONE OR MORE NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER CATEGORIES FOR SELECTED GROUPS
2 -- designed to work with the IRE Census bulk data exports
3 -- see http://census.ire.org/data/bulkdata.html
4 CREATE TABLE ire_pct9 (
5 geoid VARCHAR(11) NOT NULL,
6 sumlev VARCHAR(3) NOT NULL,
7 state VARCHAR(2) NOT NULL,
8 county VARCHAR(3),
9 cbsa VARCHAR(5),
10 csa VARCHAR(3),
11 necta VARCHAR(5),
12 cnecta VARCHAR(3),
13 name VARCHAR(90) NOT NULL,
14 pop100 INTEGER NOT NULL,
15 hu100 INTEGER NOT NULL,
16 pop100_2000 INTEGER,
17 hu100_2000 INTEGER,
18 pct009001 INTEGER,
19 pct009001_2000 INTEGER,
20 pct009002 INTEGER,
21 pct009002_2000 INTEGER,
22 pct009003 INTEGER,
23 pct009003_2000 INTEGER,
24 pct009004 INTEGER,
25 pct009004_2000 INTEGER,
26 pct009005 INTEGER,
27 pct009005_2000 INTEGER,
28 pct009006 INTEGER,
29 pct009006_2000 INTEGER,
30 pct009007 INTEGER,
31 pct009007_2000 INTEGER,
32 pct009008 INTEGER,
33 pct009008_2000 INTEGER,
34 pct009009 INTEGER,
35 pct009009_2000 INTEGER,
36 pct009010 INTEGER,
37 pct009010_2000 INTEGER,
38 pct009011 INTEGER,
39 pct009011_2000 INTEGER,
40 pct009012 INTEGER,
41 pct009012_2000 INTEGER,
42 pct009013 INTEGER,
43 pct009013_2000 INTEGER,
44 pct009014 INTEGER,
45 pct009014_2000 INTEGER,
46 PRIMARY KEY (geoid)
47 );
Something went wrong with that request. Please try again.