dr5hn / countries-states-cities-database

🌍 Discover our global repository of countries, states, and cities! 🏙️ Get comprehensive data in JSON, SQL, PSQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native language, timezones (for countries), and more. #countries #states #cities
https://dr5hn.github.io/countries-states-cities-database/
Open Data Commons Open Database License v1.0
6.83k stars 2.45k forks source link

Regions/Continents and Subregions #653

Closed Freelenzer closed 10 months ago

Freelenzer commented 11 months ago

Motivation

Reference all countries of a Region/Continent is currently not possible. As well as the connection between subregions and regions is missing. Therefore it is necessary to create a Continents and a Subregions Database. Also localisation of those regions is useful

Risks

This might break the database

Freelenzer commented 11 months ago

I added a PR to discuss this feature:

https://github.com/dr5hn/countries-states-cities-database/pull/657

@dr5hn

Freelenzer commented 11 months ago

@dr5hn How do I create the json from the SQL/Database?

dr5hn commented 10 months ago

@Freelenzer Answered your question in the PR.