Cities are not related to their subdivisions (region, province or state).

The Subdivision table was imported by a collaborator so, as those relations/pointers were not created by him, it is hard for us to identify exactly which cities belong to which subdivisions, so this is not really an issue but a characteristic of this particular database. If the cities/provinces you need are from the USA, you might find the information you are looking for in one of these datasets: https://www.back4app.com/database/back4app/usa-by-state https://www.back4app.com/database/countries/united-states-cities/city

As this is a collaborative dataset, if you have the information to match cities and subdivisions available, you can become a collaborator and make the missing link.