regions
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 );