Skip to content
Newer
Older
100644 52 lines (51 sloc) 1.2 KB
f36866c @JoeGermuska create table DDL for bulkdata export format
JoeGermuska authored
1 -- P31. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS
2 -- designed to work with the IRE Census bulk data exports
3 -- see http://census.ire.org/data/bulkdata.html
4 CREATE TABLE ire_p31 (
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 p031001 INTEGER,
19 p031001_2000 INTEGER,
20 p031002 INTEGER,
21 p031002_2000 INTEGER,
22 p031003 INTEGER,
23 p031003_2000 INTEGER,
24 p031004 INTEGER,
25 p031004_2000 INTEGER,
26 p031005 INTEGER,
27 p031005_2000 INTEGER,
28 p031006 INTEGER,
29 p031006_2000 INTEGER,
30 p031007 INTEGER,
31 p031007_2000 INTEGER,
32 p031008 INTEGER,
33 p031008_2000 INTEGER,
34 p031009 INTEGER,
35 p031009_2000 INTEGER,
36 p031010 INTEGER,
37 p031010_2000 INTEGER,
38 p031011 INTEGER,
39 p031011_2000 INTEGER,
40 p031012 INTEGER,
41 p031012_2000 INTEGER,
42 p031013 INTEGER,
43 p031013_2000 INTEGER,
44 p031014 INTEGER,
45 p031014_2000 INTEGER,
46 p031015 INTEGER,
47 p031015_2000 INTEGER,
48 p031016 INTEGER,
49 p031016_2000 INTEGER,
50 PRIMARY KEY (geoid)
51 );
Something went wrong with that request. Please try again.