Ecosyste.ms: OpenCollective

An open API service for software projects hosted on Open Collective.

github.com/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://github.com/dr5hn/countries-states-cities-database

Should be "The Gambia", not "Gambia The"

xukaizju opened this issue 4 months ago

Incoherence between the data across tables

dugzino opened this issue 4 months ago

Data not matching with API Demo

VectorChi opened this issue 5 months ago

Some cities are missing or miss defined in country "TZ" in state "Dar es salaam"

Mudathiralawi opened this issue 5 months ago

Migration from V1.9 to Latest Tag V2.3

ganesh-gupta-clapself opened this issue 5 months ago

Spain states database issue

kikecastillo opened this issue 5 months ago

Missing cities from Germany and misspelled state

Zegameus opened this issue 5 months ago

Missing record for city Liebefeld in Kanton Bern Switzerland .

arunLivello opened this issue 5 months ago

City Rosenthal am Rennsteig not Present in the state of Thuringia Germany

arunLivello opened this issue 5 months ago

Library is causing the react website to crash in safari browser

shayan-analytica opened this issue 5 months ago

Update states.csv

Engineer-Hasibur-Rahman opened this pull request 5 months ago

Problemas al obtener las ciudades en algunos estados de Francia

faRandstad opened this issue 5 months ago

500 Error everyday after 10pm IST

sushant-gvw opened this issue 6 months ago

New cli console && rename directory

tigran90 opened this pull request 6 months ago

closes Missing cities of Faroe Islands #666

dr5hn opened this pull request 6 months ago

fixes #769 Wrong city name showing for below information

dr5hn opened this pull request 6 months ago

fix: Remove the "+" symbol from all instances of country "phone_code"…

dr5hn opened this pull request 6 months ago

removed all + in phone code in countries.csv

dr5hn opened this pull request 6 months ago

fix: Duplicate Entries in Cities List #735

dr5hn opened this pull request 6 months ago

fix: #795 Poland State Code Changes

dr5hn opened this pull request 6 months ago

(chore): Export JSON, CSV, XML, YAML, MYSQL, PSQL & SQLITE files

github-actions[bot] opened this pull request 6 months ago

Remove invalid "Campinas" brazilian city from database

skpeter opened this pull request 6 months ago

UK States too specific

IzMichael opened this issue 6 months ago

Omitted anything irrelevant to me.

leonwigley opened this pull request 6 months ago

info error

le011 opened this issue 6 months ago

Poland State Code Changes

falahati opened this issue 6 months ago

Timezones is missing for Czech Republic in sql/countries.sql

apfromiit opened this issue 6 months ago

Bogotá D.C. city is duplicate

mario-alba opened this issue 6 months ago

In iphone shows error maximum call stack exceeded error ,but working in android , window and mac

shahidforsdlc opened this issue 6 months ago

Why is Arabic translation listed under "fa"

gharam37 opened this issue 6 months ago

countries-states-cities-database/master/cities.json is missing location info.

luke-song opened this issue 6 months ago

PL, UK and RU translations for regions, subregions and countries

dorkyboi opened this pull request 6 months ago

Question regarding contribution

dorkyboi opened this issue 6 months ago

Add Arabic translation

Ala-Alsanea opened this issue 6 months ago

Flag issue

amanpoplify opened this issue 6 months ago

Clearing search is not rendering the whole list

StellarLogic opened this issue 6 months ago

UK states and no cities

coxy17 opened this issue 7 months ago

(chore): Export JSON, CSV, XML, YAML, MYSQL, PSQL & SQLITE files

github-actions[bot] opened this pull request 7 months ago

add 19 cities and edit 11 city names for Malta

ryanvelbon opened this pull request 7 months ago

[Feature] Add `SQLite` database support in the export workflow

navicraft opened this pull request 7 months ago

(chore): Export JSON, CSV, XML & YAML & PSQL files

github-actions[bot] opened this pull request 7 months ago

Add Cities For Malaysia

hachirobei opened this pull request 7 months ago

Update countries.json

Abd0195031 opened this pull request 8 months ago

Remove non-existent Uruguay cities, update existing ones & add missing ones

juandidasilva opened this pull request 8 months ago

Missing data in Vietnam

lenam200996 opened this issue 8 months ago

Vallensbæk in Denmark has Strand at the end

ymg2006 opened this pull request 8 months ago

Can i have just the country, state, cities

devfemibadmus opened this issue 8 months ago

what is the flag field for?

singleseeker opened this issue 9 months ago

API key request page broken

Ladvace opened this issue 9 months ago

Wrong cities in DRC

b-shop opened this issue 9 months ago

Wrong city name showing for below information

ReveProduct opened this issue 9 months ago

Update country name from Turkey to Türkiye

mustafazeydani opened this pull request 9 months ago

Spanish cities missing lat/long

scottgigante opened this issue 9 months ago

Spelling corrections for place names in Kerala

Sukanyeah opened this pull request 9 months ago

Cities on Philippines per state incomplete

johnperricruz opened this issue 9 months ago

Errors while trying to run the sql file

Preyas552 opened this issue 10 months ago

Missing cities in Hampshire

adititipnis opened this issue 10 months ago

update: add major lagos cities

laurentcodes opened this pull request 10 months ago

Import Error world.sql

strongui opened this issue 10 months ago

City field doesn't print in Message body

germanrandhawa opened this issue 10 months ago

(chore): Export JSON, CSV, XML & YAML & PSQL files

github-actions[bot] opened this pull request 10 months ago

Buenos Aires Province and Ciudad Autonoma de Buenos Aires

leonardotallone opened this issue 10 months ago

rename 'Ar Ruways' to wikidata accepted name 'Ruwais'

scottgigante opened this pull request 10 months ago

fix: add alimosho city to lagos state, nigeria

laurentcodes opened this pull request 10 months ago

The listing of Friedens in Pennsylvania should be Friedensburg.

fascom-ft2 opened this issue 10 months ago

Duplicate entries

V4A001 opened this issue 10 months ago

(chore): Export JSON, CSV, XML & YAML & PSQL files

github-actions[bot] opened this pull request 10 months ago

fix: Uttarakhand State code from UT to UK

dr5hn opened this pull request 10 months ago

Fix error in the name of the state 1200

rsenses opened this pull request 10 months ago

Invalid state code for Uttarakhand (India)

akgurjar opened this issue 10 months ago

countries.sql -> emoji column has '??'

apfromiit opened this issue 10 months ago

fix names of eswatini, timor-leste, PNG, and more

scottgigante opened this pull request 11 months ago

Add to a new country and 5 new cities, some data editing information

cihanbagdatli opened this issue 11 months ago

Missing Cities And States Of Greece

mertozylmz opened this issue 11 months ago

Hi, i would like to add city Ulaanbaatar the capital of mongolia.

Tsolmonx opened this issue 11 months ago

(chore): Export JSON, CSV, XML & YAML & PSQL files

github-actions[bot] opened this pull request 11 months ago

city do not change when selected in the dropdown i guess the error is related to values of option the value is same for all options

sumiran01 opened this issue 11 months ago

fix mispeling on Capão Bonito, SP, BR.

jvlomazzi opened this pull request 11 months ago

Unable to fetch states based on selected country.

alankar-asthana opened this issue 11 months ago

Mauritius - duplicate cities

geerishw opened this issue 11 months ago

feat: Add Postgres database migration and export action

agostinofiscale opened this pull request 12 months ago

Null data

GiuniGiorgio01 opened this issue 12 months ago

(chore): Export JSON, CSV, XML & YAML files

github-actions[bot] opened this pull request 12 months ago

Updated all instances of Name of Republic of Abkhazia to Abkhazia

CBattershillDev opened this pull request 12 months ago

Duplicate Entries in Cities List

ManojKiranA opened this issue about 1 year ago

Incorrect City in Bangladesh

abidt20ahmed opened this issue about 1 year ago

india

vipinlakhawat opened this issue about 1 year ago

states.sql file have a error data

enzochen opened this issue about 1 year ago

Sql Upadted Abkhazia name changed

gchikovanii opened this pull request about 1 year ago

Add currencies table

pedro757 opened this pull request about 1 year ago

Feature Request: separate currency table

pedro757 opened this issue about 1 year ago

Geographical position of Zambia

IsaacHatilima opened this issue about 1 year ago

Request for feedback - United States IRS Country Codes

KennethScott opened this issue about 1 year ago

Added support for mongodb

mliuchengyu opened this pull request about 1 year ago

Name Has Changed to Abkhazia By protection of contribution rights.

gchikovanii opened this pull request about 1 year ago

Removed Italian provinces

MoroAlberto opened this pull request about 1 year ago

Updated and Refactored Name of: Autonomous Republic of Abkhazia to Ab…

gchikovanii opened this pull request about 1 year ago

CH - Uri state lat/long fix

RomainJACQUEMIN opened this pull request about 1 year ago

Why the latitude and longitude is undefined.

trantien0410 opened this issue about 1 year ago

Delete sql directory

ravaldarshan opened this pull request about 1 year ago