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 |