Unit group membership table

UnitGroupMemberships is used to represent the many-to-many relationship between Units and UnitGroups. One UnitGroupMembership indicates that the associated Unit is part of the associated UnitGroup.

Table description

DESCRIBE TABLE unitgroup_membership
 key         | name                 | encoding |
 unitgroupid | UnitGroup identifier | TEXT     |
 unitid      | Unit identifier      | TEXT     |

Sample query

SELECT unitgroupid, unitid FROM unitgroup_membership

Result

 unitgroupid          | unitid                   |
 Atlantic Northeast   | Boston                   |
 Atlantic Northeast   | New York Downtown        |
 Atlantic Northeast   | Baltimore                |
 Atlantic Northeast   | Trenton                  |
 Atlantic Northeast   | New York Soho            |
 Atlantic Northeast   | New York Chinatown       |
 Atlantic Northeast   | Buffalo                  |
 Atlantic Northeast   | New York Uptown          |
 Atlantic Northeast   | Princeton                |
 Atlantic Northeast   | Syracuse                 |
 Atlantic Northeast   | Washington DC            |
 Atlantic Northeast   | New York Midtown         |
 Atlantic Northeast   | New York Upper West Side |
 Atlantic Southeast   | Jacksonville             |
 Atlantic Southeast   | Huntsville               |
 Atlantic Southeast   | Orlando                  |
 Atlantic Southeast   | Charleston               |
 Atlantic Southeast   | Miami                    |
 Atlantic Southeast   | Tampa                    |
 Atlantic Southeast   | Savannah                 |
 Atlantic Southeast   | Myrtle Beach             |
 Midsouth             | Houston                  |
 Midsouth             | Dallas                   |
 Midsouth             | Little Rock              |
 Midwest              | Minneapolis              |
 Midwest              | Detroit                  |
 Midwest              | Chicago                  |
 Northwest            | Seattle                  |
 Northwest            | Portland                 |
 Pacific              | San Francisco            |
 Pacific              | San Jose                 |
 Pacific              | San Diego                |
 Pacific              | Los Angeles              |
 Pacific              | Long Beach               |
 Pacific              | Pasadena                 |
 Pacific              | Sacramento               |
 Southwest            | Lake Havasu City         |
 Southwest            | Las Vegas                |
 Southwest            | Phoenix                  |
 USA                  | Boston                   |
 USA                  | Orlando                  |
 USA                  | Lake Havasu City         |
 USA                  | New York Downtown        |
 USA                  | Miami                    |
 USA                  | Dallas                   |
 USA                  | Trenton                  |
 USA                  | Baltimore                |
 USA                  | Sacramento               |
 USA                  | Jacksonville             |
 USA                  | San Diego                |
 USA                  | Washington DC            |
 USA                  | Los Angeles              |
 USA                  | New York Midtown         |
 USA                  | Savannah                 |
 USA                  | Chicago                  |
 USA                  | Pasadena                 |
 USA                  | San Francisco            |
 USA                  | Huntsville               |
 USA                  | Seattle                  |
 USA                  | Charleston               |
 USA                  | New York Soho            |
 USA                  | New York Chinatown       |
 USA                  | Long Beach               |
 USA                  | Phoenix                  |
 USA                  | Buffalo                  |
 USA                  | Minneapolis              |
 USA                  | New York Uptown          |
 USA                  | Princeton                |
 USA                  | Houston                  |
 USA                  | San Jose                 |
 USA                  | Syracuse                 |
 USA                  | Las Vegas                |
 USA                  | Tampa                    |
 USA                  | Detroit                  |
 USA                  | Little Rock              |
 USA                  | Portland                 |
 USA                  | New York Upper West Side |
 USA                  | Myrtle Beach             |
 Alabama              | Huntsville               |
 Arizona              | Lake Havasu City         |
 Arizona              | Phoenix                  |
 Arkansas             | Little Rock              |
 California           | San Francisco            |
 California           | San Jose                 |
 California           | San Diego                |
 California           | Los Angeles              |
 California           | Long Beach               |
 California           | Pasadena                 |
 California           | Sacramento               |
 District of Columbia | Washington DC            |
 Florida              | Jacksonville             |
 Florida              | Orlando                  |
 Florida              | Miami                    |
 Florida              | Tampa                    |
 Georgia              | Savannah                 |
 Illinois             | Chicago                  |
 Maryland             | Baltimore                |
 Massachusetts        | Boston                   |
 Michigan             | Detroit                  |
 Minnesota            | Minneapolis              |
 Nevada               | Las Vegas                |
 New Jersey           | Princeton                |
 New Jersey           | Trenton                  |
 New York             | Buffalo                  |
 New York             | New York Uptown          |
 New York             | New York Downtown        |
 New York             | Syracuse                 |
 New York             | New York Midtown         |
 New York             | New York Soho            |
 New York             | New York Chinatown       |
 New York             | New York Upper West Side |
 Oregon               | Portland                 |
 South Carolina       | Charleston               |
 South Carolina       | Myrtle Beach             |
 Texas                | Houston                  |
 Texas                | Dallas                   |
 Washington           | Seattle                  |