regions

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

region_num ▼ district_num_fk region_name subregion_flag belongs_to_region
1 1 Boston 0 1
2 1 New York 0 2
3 1 Buffalo 0 3
4 1 Philadelphia 0 4
5 2 Baltimore 0 5
6 2 Pittsburgh 0 6
7 2 Detroit 0 7
8 2 Cleveland 0 8
9 2 Cincinnati 0 9
10 2 Atlanta 0 10
11 2 Winston-Salem 0 11
12 3 Tampa 0 12
13 3 Chicago 0 13
14 3 St. Louis 0 14
15 3 New Orleans 0 15
16 4 Fort Worth 0 16
17 3 Kansas City 0 17
18 3 Minneapolis 0 18
19 4 Seattle 0 19
20 4 San Francisco 0 20
21 4 Los Angeles 0 21
22 1 Newark 0 22
24 1 Puerto Rico 0 24
25 3 Indianapolis 0 25
26 3 Memphis 0 26
27 4 Denver 0 27
28 4 Phoenix 0 28
29 1 Brooklyn 0 29
30 2 Milwaukee 0 30
31 4 Los Angeles 0 31
32 4 Oakland 0 32
33 3 Peoria 0 33
34 1 Hartford 0 34
36 4 Portland 1 19
37 4 Honolulu 1 20 
CREATE TABLE "regions" (
   [region_num] INTEGER PRIMARY KEY,
   [district_num_fk] INTEGER,
   [region_name] TEXT,
   [subregion_flag] INTEGER,
   [belongs_to_region] INTEGER
);