How do I store World/event data in a treelike structure SQL/SQLite3
I have seen a reporting database that had join tables that assigned a city to an administrative district (county), the administrative districts are assigned to another, bigger district (state), which is assigned to a country. The nesting action is done through the queries, instead of trying to have Russian Nesting Dolls of tables inside of tables.
Example:
CityID | CityName | DistrictID
1        New York   5
DistrictID | DistrictName  |  Province\State
5            New York County  7
ProvinceID   |ProvinceName|  CountryID
7             New York        127
CountryID | CountryName
127            USA