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

Bangladesh country states table type values updated (#514)

e51262c31e9b9fd814c7a34029707bf4261e8fde authored about 2 years ago by Mohammad Hafijul Islam <[email protected]>
Update README.md

4321acbf59ddac49b5d261f84c1dd075f07edbf3 authored about 2 years ago by Darshan Gada <[email protected]>
Correction State OD City Bhubaneswar (#511)

9d069fe7cff607fc6b0bf8322c365db41af8e878 authored about 2 years ago by Jayesh <[email protected]>
Added Adra, West Bengal, India in world.sql (#495)

Co-authored-by: nirjhareswar <[email protected]>

46b9a5e9ba79060d98e7bbc1c14f801339939908 authored about 2 years ago by Nirjhareswar Banerjee <[email protected]>
Fix latlng for Marche, Lazio (Italy) (#503)

15308d7fd0165a89641ec040cdd2c9675964ff5b authored about 2 years ago by João Ribeiro Bezerra <[email protected]>
chore: Update Readme

16b1394edc6a984d519ea2b27448766c9adff01d authored over 2 years ago by Darshan Gada <[email protected]>
Update README.md

a9a17c9bfa779172604dbb4fbfdd7d5f51660292 authored over 2 years ago by Darshan Gada <[email protected]>
(chore): Export JSON, CSV, XML & YAML files (#490)

Co-authored-by: dr5hn <[email protected]>

ecf4b411d6ec5578713ab5561fd647727b0a4a1e authored over 2 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
fix: Multiple issues (#489)

c2ccdada43a876631e12e92ada403f75df947553 authored over 2 years ago by Darshan Gada <[email protected]>
Add Baghdad cities (#488)

bb33d17ae77d032a55ef1fefd03fa059cfbead9b authored over 2 years ago by Abdullah Shallal <[email protected]>
(chore): Export JSON, CSV, XML & YAML files (#482)

Co-authored-by: dr5hn <[email protected]>

137e430801dd9478a0c6e3761f492f6c51a600c5 authored over 2 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Fix: #209 Spain provinces and cities sorted (#486)

1f46724c6a4227cdab162a702b77083b20b12799 authored over 2 years ago by Darshan Gada <[email protected]>
Fix: #211 Remove New york duplicate cities (#483)

930c4939016ec3e935c83e8c1ef0203100220dd3 authored over 2 years ago by Darshan Gada <[email protected]>
Fix: #228 Added missing Iran cities (#481)

2b1520744f1dd4a3325784f53c97c5901912df9d authored over 2 years ago by Darshan Gada <[email protected]>
Change 'br' translations to 'pt-BR' to match i18n mappings (#460)

dd418a80b2c63f0611eda890b311128ed4076db6 authored over 2 years ago by João Ribeiro Bezerra <[email protected]>
Update FUNDING.yml

a73db04faa0dc69a184fc1b49e882421f0f08f68 authored over 2 years ago by Darshan Gada <[email protected]>
(chore): Export JSON, CSV, XML & YAML files (#449)

Co-authored-by: dr5hn <[email protected]>

8680ce9ffcfc5680c06327319027c1b2d9e34eba authored over 2 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Fix #442 - Add missing cities in Kalimantan Barat (#448)

1c62b43037eb6e96b7222cd7c24a1cd034d92ee0 authored over 2 years ago by Darshan Gada <[email protected]>
(chore): Export JSON, CSV, XML & YAML files (#447)

Co-authored-by: dr5hn <[email protected]>

b83d13b97c8329f6bf4894fedc1e3359216fc9a1 authored over 2 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Fix emoji

0d3ec363e6f2a6f8635b16a3e046d5b2b0e17e01 authored over 2 years ago by Darshan Gada <[email protected]>
Upgrade dependencies

9075e6ecf607fd02d7032543c31bf1f80bb0b217 authored over 2 years ago by Darshan Gada <[email protected]>
Add Table Structure Guide to Contribution Guidelines

6dc6afd9683d4219e52db11ee7859cffb09a3123 authored over 2 years ago by Darshan Gada <[email protected]>
(chore): Export JSON, CSV, XML & YAML files (#441)

Co-authored-by: dr5hn <[email protected]>

564b641408fa371bf5cbcebda2bdc3e5c65b8ab5 authored over 2 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Fix many issues (#440)

* Misc updates
* Fix issues

ec49a78d57d71f4181c9c5dad6e8252075e1d874 authored over 2 years ago by Darshan Gada <[email protected]>
Add(feature/Turkish-translations): Turkish translations for country names (#425)

6b4e9b56ef56e44b927a1a6b070edf0c4634cd12 authored over 2 years ago by Aykut Büyükkaya <[email protected]>
(chore): Export JSON, CSV, XML & YAML files (#420)

Co-authored-by: dr5hn <[email protected]>

54939ff65f80369ba8b78e5277b5ed2ed503ef50 authored almost 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Fix: #419 and Fix: #415 Add missing australian suburbs

6edd0366bf79cef1ace771800713f8a408f84d96 authored almost 3 years ago by Darshan Gada <[email protected]>
(chore): Export JSON, CSV, XML & YAML files (#411)

Co-authored-by: dr5hn <[email protected]>

8ad1a90c34dc6ace74f2e1759d12234427444b17 authored almost 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Update Readme counts

88017f5e29d2a16727bab0f5569e5a5d1151d6e1 authored almost 3 years ago by Darshan Gada <[email protected]>
Fix #405 Add Ranipet in Tamlinadu

a25040172e5c55b33898c965caf426db4827b696 authored almost 3 years ago by Darshan Gada <[email protected]>
Fix #400 Add Morningside to Pennsylvania

6b7748a94294bc6b9664b5246132a8d6cba4a062 authored almost 3 years ago by Darshan Gada <[email protected]>
Fix #399 Incorrect city name

a2a452b91e2f0b782e45fe1c22aefbe83863853f authored almost 3 years ago by Darshan Gada <[email protected]>
Fix #395 Remove tab character from Data

a076e28356cae764bc48cb8fe117694eca34b53d authored almost 3 years ago by Darshan Gada <[email protected]>
Fix #397 Country name Bahamas The to The Bahamas

12b31db189a7e5eb4340ad4bc87d21d1add42be1 authored almost 3 years ago by Darshan Gada <[email protected]>
Fix #396 Remove duplicate swedene cities with suffix Kommun

77d457bac28837dbda45e637cf787178d2375a5f authored almost 3 years ago by Darshan Gada <[email protected]>
Fix #393 State's wikiData ID

05217971740e2aaf948c0a8d2a64fa9147486fee authored almost 3 years ago by Darshan Gada <[email protected]>
Fix #392 Add hazlet township in New Jersey

90c55b4bc40946e9db7e0720a05bb8438f309eb1 authored almost 3 years ago by Darshan Gada <[email protected]>
Update type column of US States

025de671b21e788be4e56fc75353e790a259c61b authored almost 3 years ago by Darshan Gada <[email protected]>
Fix: #394 Add missing region Poltava and names fixes

ca6ef61e21a01dbb3abb6b0855b6a55a742623d1 authored almost 3 years ago by Darshan Gada <[email protected]>
Fix: #388 Add Dartmouth in Massachusetts state in the US

8a80be1787e9f9e27127a80b8c890de5f3b68275 authored almost 3 years ago by Darshan Gada <[email protected]>
Fix #385 Add Huntingwood and Eagle Farm cities to Australia

551b3889e7b6f22046c123a4b745ca25fd5638dd authored almost 3 years ago by Darshan Gada <[email protected]>
Fix: #375 Add type to Cambodia's provinces and add missing province

b1e892cd3e99459e6bdee02c1c7e329ecae77709 authored almost 3 years ago by Darshan Gada <[email protected]>
Remove auto trigger on sql update

ecf5ece2200445f7a07e4a40cc723ce0982e2015 authored almost 3 years ago by Darshan Gada <[email protected]>
(chore): Export JSON, CSV, XML & YAML files (#410)

Co-authored-by: dr5hn <[email protected]>

e7b92adca4ffb08a996badf91dcfe1cc56684ff3 authored almost 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Skip adding locks to dumps

6668b32acc724b34ae21b299e166067ca40e98c8 authored almost 3 years ago by Darshan Gada <[email protected]>
Update contribution guidelines

6e69b03f744235b241c577fda347ca6db4092133 authored almost 3 years ago by Darshan Gada <[email protected]>
Fix: #379 Add commands to output other sql files via github actions

6114e903a78e97c6f9d4fdb5fb89fd6fe18b7669 authored almost 3 years ago by Darshan Gada <[email protected]>
Updates in some cities and states from Colombia (#372)

015a94d0b8c8c143c73e58b0c54822182ee075e5 authored almost 3 years ago by cesariverit <[email protected]>
trim state type field values (#403)

Co-authored-by: John Landis <[email protected]>

b4506387f91f24ac96e1799547d28215fc85494e authored almost 3 years ago by John Landis <[email protected]>
add missing Croatian county - Karlovac County (#402)

Co-authored-by: John Landis <[email protected]>

d6514dd6a09ec15429d651e61bdb9ecefa86869d authored almost 3 years ago by John Landis <[email protected]>
Fix Brazil states latlng for Bahia and Acre (#401)

bd2686afec84eabfe718bd7d61b4e6565009fd32 authored almost 3 years ago by João Ribeiro Bezerra <[email protected]>
Update Mexico State and cities names and improve state code (#391)

84a116cf92d648736a1d5d062ac15ea47ddf8f85 authored almost 3 years ago by Naim Grimaldo <[email protected]>
(chore): Export JSON, CSV, XML & YAML files (#381)

2f2793294f830203fac2e2eac0605283941fc2a3 authored almost 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Fix Issues (#383)

c9070c0c03b8183970775b79e421fe838bb28d46 authored almost 3 years ago by Darshan Gada <[email protected]>
Add lat/lng data for two states in Brazil (#377)

ac8de3473840dff56e0e6c549a1d1f11f9006007 authored almost 3 years ago by João Ribeiro Bezerra <[email protected]>
(chore): Export JSON, CSV, XML & YAML files (#370)

1e21b97e1d4451624d4515906f77fefb27d94f79 authored almost 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Add missing cities to Jiangsu

1e2b1803cc06b35429bc7e50adf11c6c20268d88 authored almost 3 years ago by Darshan Gada <[email protected]>
(chore): Export JSON, CSV, XML & YAML files (#369)

a867a7120741db81dc6d9660d8bd5915dbe914d8 authored almost 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Merge branch 'fzzio-master'

c2738aa62ed18fa8d0ac6c541659b2f28759cd00 authored almost 3 years ago by Darshan Gada <[email protected]>
Merge branch 'master' of https://github.com/fzzio/countries-states-cities-database into fzzio-master

50e3740baace779ab3ebb9eb443d37754da684d6 authored almost 3 years ago by Darshan Gada <[email protected]>
Merge branch 'cesariverit-master'

3db6fc63aed34deca81bfcc2d74c384d763f9093 authored almost 3 years ago by Darshan Gada <[email protected]>
Merge branch 'master' of https://github.com/cesariverit/countries-states-cities-database into cesariverit-master

210035a252ce6ddf8242703da1d6f38513e23dfe authored almost 3 years ago by Darshan Gada <[email protected]>
Delete duplicated city "San Sebastián de Mariquita" TOL

e945b781d6177a801ed4aad5d23f66e972804606 authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "San Pedro de Cartago" NAR

5af98c8ff21c89546998039d7a3ef978c0e18389 authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "Puerto Rico" MET

820acd6ac8f1223ff0d6f59fb0a18c5a279f36eb authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "Chivolo" MAG

238410d1d2a31ff0b8e94e592a38ec415fe7c95c authored almost 3 years ago by cesariverit <[email protected]>
Reorder recently deleted city "Paez" CAU

246637d01d708432383df9fb069ae77c5d93b82a authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "Bojayá" CHO

517ecabe1d13621ea50bcc9146db14c04d89ec72 authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "Bajo Baudó" CHO

c107d3cd90d99cd0392135526599a76ad8e8b334 authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "Alto Baudo" CHO

a3cc4a75abcdb84ebbae1329ff2ae7663c13541e authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "Paez" CAU

9209c41b3f4b179e2ed50a02272591e590f91393 authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "El Santuario" ANT

3e672fea2cc2dde59b7694fe8e3fe8343bf22d4c authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "El Carmen de Viboral" ANT

bb71064a2772450d6f2f6598dda94a472f987a8f authored almost 3 years ago by cesariverit <[email protected]>
Add city "Caracas" to the state "Distrito Capital" in country "Venezuela" VE

e8ab1987a6e3f24347ccd8c3a7abba7a525bb8c0 authored almost 3 years ago by cesariverit <[email protected]>
Add 24 missing cities in Colombia

ed6425c58006c2ff84105ae57fe17298ee54be94 authored almost 3 years ago by cesariverit <[email protected]>
Delete city "Darien" VAC. It belongs to "Calima" VAC

b29e7993513a52ec649dfda83ffdae3c7a2c0714 authored almost 3 years ago by cesariverit <[email protected]>
Rename state "Archipiélago de San Andrés, Providencia y Santa Catalina" COP

cd169c7901a16ab021a54570ae3be5f56ba7ab1b authored almost 3 years ago by cesariverit <[email protected]>
Delete "Mountain" SAP. It's not a city

14baa30817f030fe6244a57da48eb605fd4f7b0e authored almost 3 years ago by cesariverit <[email protected]>
Delete city "Socha Viejo" BOY. It's not a city

42f51db3f49581680c7a776076b3ab631b506584 authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "Manaure" CES

a64db3409bfce58f089fdb801e1005b7d87a5a99 authored almost 3 years ago by cesariverit <[email protected]>
Delete city "Ariguaní" CES. The right city is "Ariguaní" MAG

6fa7b52a4b3be1c458b88b7c3d92add0a6a3b503 authored almost 3 years ago by cesariverit <[email protected]>
Delete city "San Andres de Tumaco" NAR

e899140f131572962fdd6d3dd4ab41353246359e authored almost 3 years ago by cesariverit <[email protected]>
Delete city "Purísimia" COR. Renamed city "Purísima de la Concepción" COR to "Purísima" COR

d7eb83591475c7676be58847365e08dc4ec7c9ff authored almost 3 years ago by cesariverit <[email protected]>
Rename "San Andrés Sotavento" COR to "San Andrés de Sotavento" COR

9416aee9e0cf1e61d24194797a7cdcaddb7e3126 authored almost 3 years ago by cesariverit <[email protected]>
Delete city "Salahonda" NAR. It belongs to "Francisco Pizarro" NAR

64a31a91b5b641162cc434e128d625dea81c398e authored almost 3 years ago by cesariverit <[email protected]>
Delete city "Sotomayor" NAR. It belongs to "Los Andes" NAR

992dd2db41caf3fadeb0eb1a8603121ee07503c1 authored almost 3 years ago by cesariverit <[email protected]>
Unify cities "San José" NAR and "Albán" NAR to "San José de Albán" NAR

cb4716413fa58a3870eed10b9ca4b7beec922ab7 authored almost 3 years ago by cesariverit <[email protected]>
Delete city "Iscuandé" NAR. It belongs to "Santa Bárbara" NAR

2faf3db952ba86c5292965dfaeb4a73fd9a35f9c authored almost 3 years ago by cesariverit <[email protected]>
Unify cities "Magüi" NAR and "Payán" NAR to "Magüi Payán" NAR

a7f8581243c4a8f4f32ef60a55b0a09968b2dde8 authored almost 3 years ago by cesariverit <[email protected]>
Delete city "Piedrancha" NAR. It belongs to "Mallana" NAR

4096d44a1be4c98b939077d2974e104a2e7277de authored almost 3 years ago by cesariverit <[email protected]>
Rename city "Cartago" NAR to "San Pedro de Cartago" NAR

8a88d4863c655eea54625d99564d117b7698093d authored almost 3 years ago by cesariverit <[email protected]>
Delete city "Génova" NAR. It belongs to "Colón" NAR

8fe2c2075468d4c96953af41a0fb2dfd7c84391a authored almost 3 years ago by cesariverit <[email protected]>
Unify city "El Tablón de Gómez" NAR

3090b641e43a7243749d33bb5984aa47bee1a8ba authored almost 3 years ago by cesariverit <[email protected]>
Delete city "Carlosama" NAR. It belongs to "Cuaspud" NAR

0b30dc8ff2595970363b5e785f9dcb324f3eb4c6 authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "Leguízamo" PUT

48b16ed17997a8ef083cf50c8e2e528225deb4e0 authored almost 3 years ago by cesariverit <[email protected]>
Update city "Lebrija" SAN

a436646e78f37ecd973db05ff8865a2ecddd27a8 authored almost 3 years ago by cesariverit <[email protected]>
Add new city "Villa Caro" NSA

8351acf4020441a8f14e14b2ab5c00734462573d authored almost 3 years ago by cesariverit <[email protected]>
Delete city "La Dorada" PUT. It belongs to "San Miguel" PUT

c5d5c4357394673aa52e201d0263730ec8b7c82c authored almost 3 years ago by cesariverit <[email protected]>
Delete city "Talaigua Viejo" BOL. It belongs to "Talaigua Nuevo" CAU

579b071b0c65fa3e1aded55284523a889924557d authored almost 3 years ago by cesariverit <[email protected]>
Unify cities "María la Baja" BOL

23b30548fe9e83c9a583bfb19b47edbaecf26c04 authored almost 3 years ago by cesariverit <[email protected]>