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

Unify cities "Cartagena de Indias" BOL

a6ff0a4827e859a6e7f304ac023b8c71f8c75135 authored almost 3 years ago by cesariverit <[email protected]>
Unify cities "Hato Corozal" TOL

d1822f5389a4f4fc2f7416274835345eb0117e2c authored almost 3 years ago by cesariverit <[email protected]>
Rename city "Santuario" ANT to "El Santuario" ANT

af52c4af6a5d4b63df079014aae829e7a9f0a191 authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "Santafé de Antioquia" ANT. Duplicated with "Santa Fe de Antioquia" ANT

01355b34dbf78f1a1a5a08e83dd2551469cdea16 authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "San Vicente" ANT. Duplicated with "San Vicente Ferrer" ANT

12f1183b846e0d370021baf4b4a39eb897b44a31 authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "San Pedro" ANT. Duplicated with "San Pedro de los Milagros" ANT

f3fe882387a46cf4eb6228ffbb4dce33984dd079 authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "San Andrés de Cuerquia" ANT

84c23c02cf72129d2d1329d506f2e7c9bafa3b21 authored almost 3 years ago by cesariverit <[email protected]>
Rename city "San Andrés" ANT to "San Andrés de Cuerquia" ANT

c6210a6944c55098385746a75b5f298ce325985f authored almost 3 years ago by cesariverit <[email protected]>
Rename city "San Pedro de los Milagros" ANT

a852bad845e001341dba6dd5f54b061dc2e35799 authored almost 3 years ago by cesariverit <[email protected]>
Delete city "Don MatĂ­as" ANT. Duplicated with "DonmatĂ­as" ANT

9a5e41fa140c356711e278142847bb0862fd00d1 authored almost 3 years ago by cesariverit <[email protected]>
Rename city "Carmen de Viboral" ANT

a012606753827ddd5b26c781602913932d799b79 authored almost 3 years ago by cesariverit <[email protected]>
Update data to city "Carmen del Darien" CHO

d114672889ea4c9e92b3471d11aeeb89f0ba7179 authored almost 3 years ago by cesariverit <[email protected]>
Delete city "Paispamba" CAU. It belongs to "Sotará" CAU

1859febc4f46a6ed2c3663001fe4a839134a9a3a authored almost 3 years ago by cesariverit <[email protected]>
Unify cities "LĂłpez" CAU and "Municipio de LĂłpez de Micay" CAU to "LĂłpez de Micay" CAU

972c54044a22cc0137e33af28ee5c1c068a96a29 authored almost 3 years ago by cesariverit <[email protected]>
Delete city "El Bordo" CAU. It belongs to "PatĂ­a" CAU

71602980677094bbe99ded22a946ffc6e5ad6220 authored almost 3 years ago by cesariverit <[email protected]>
Rename city "Belalcázar" CAU to "Páez" CAU

fbe09bd7cfecb4f7291f05a288ddc3836dfe6a69 authored almost 3 years ago by cesariverit <[email protected]>
Rename city "Municipio de San Sebastián de Mariquita" TOL to "San Sebastián de Mariquita" TOL

6d624783d4b147c26735df1383cc5ebb812b1ce4 authored almost 3 years ago by cesariverit <[email protected]>
Delete some cities from state TOL

b0bca52d13890d85d3aac274f16f1edcb57b66e4 authored almost 3 years ago by cesariverit <[email protected]>
Delete city "Guayabal" TOL. It belongs to "Armero" TOL

950a8bdbbeb8545933326e8db6b34d0d673426c1 authored almost 3 years ago by cesariverit <[email protected]>
Delete city "Gaitania" TOL. It is not a city, it's a corregimiento

40d349a05d446136c709e3dfefb811729d6584e7 authored almost 3 years ago by cesariverit <[email protected]>
Delete city "FrĂ­as" TOL. It is not a city, it's a corregimiento

1c4d2f16dd1456f3332298300e48ffb9b3a19181 authored almost 3 years ago by cesariverit <[email protected]>
Delete city "Doima" TOL. It is not a city, it's a corregimiento

2351995a2fd10b6050b68df567226b1d6809c163 authored almost 3 years ago by cesariverit <[email protected]>
Delete city "Chicoral" TOL

7f95078619e0e2199acfe39b68c1d36262e25e39 authored almost 3 years ago by cesariverit <[email protected]>
Delete city "Campo Alegre" TOL

9f47cda7666cccd0f6d4c5184f6f26cdadee6ea7 authored almost 3 years ago by cesariverit <[email protected]>
Unify cities "Armero" and "Armero-Guayabal" TOL

b5a676880083216f891c37f00360538617ff5ac3 authored almost 3 years ago by cesariverit <[email protected]>
Delete city "Anaime" TOL. It is not a city, it's a corregimiento.

0ce3df215ee2474166f2b0991c22fd96259ed3a1 authored almost 3 years ago by cesariverit <[email protected]>
Rename and update city "Cruces de AnorĂ­" ANT to "AnorĂ­" ANT

cff1c48c22eb3a8b9674aa9489e5979059a54512 authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "La Merced" RIS and update "La Merced" CAL

54877bd7f80986b68821dc7b37300723abdfe182 authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "Anserma" RIS. The right one is "Anserma" CAL

6337d5d4a53bce553c46319b2506505fc80fcdbd authored almost 3 years ago by cesariverit <[email protected]>
Rename city "Puerto Yuca" MET to "Puerto Rico" MET

579ae031903138fd30d3ae29ad0c71fab1a23315 authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "San Antonio" MAG

362bf3f8afea238ac4050a7034bdd2dea15ea66f authored almost 3 years ago by cesariverit <[email protected]>
Rename and update city "Chibolo" MAG to "Chivolo" MAG

fc986df853f5329b4d2df9b3fc1ffdc86199f668 authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "Cerro San Antonio" MAG

88c9b0659f2e8bf23a151c1262cc5512ce4fcf8e authored almost 3 years ago by cesariverit <[email protected]>
Update and rename city "Buenavista" MAG to "San Sebastián de Buenavista" MAG

896706206b58746dca413467cbd3ed8e82a81ad4 authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "El Litoral del San Juan" CHO

ecd059d87e47632a6c6add745c653df78b37b6be authored almost 3 years ago by cesariverit <[email protected]>
Rename city "Santa Genoveva de DocordĂł" CHO to "Litoral del San Juan" CHO

e9a600585390c4c68cb2316f0d2dd05c584880ea authored almost 3 years ago by cesariverit <[email protected]>
Rename city "Pizarro" CHO to "Bajo BaudĂł" CHO

822425921e8751158d35fde304b73f4abc10f0c9 authored almost 3 years ago by cesariverit <[email protected]>
Rename city "Pie de PatĂł" CHO to "Alto BaudĂł" CHO

36a216f2beeb2b0e6d46af7f5db61be8dec08638 authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "El Carmen" CHO

413f0712820b271da8e13353109fcb8fc6c82a94 authored almost 3 years ago by cesariverit <[email protected]>
Delete duplicated city "El CantĂłn de San Pablo" CHO

92ee99312a13bb8113660e5f9f617f93e382ca06 authored almost 3 years ago by cesariverit <[email protected]>
Rename city "Buenavista" CHO to "Bojayá" CHO

368b1bbd1faf6b780409f4487a8c0c4f02e0840a authored almost 3 years ago by cesariverit <[email protected]>
Rename city "El marĂ­achi" CUN to "Pacho" CUN

ff46d53eb4bd6bbd72c199460b4ce296566adb04 authored almost 3 years ago by cesariverit <[email protected]>
Delete city "Puerto Bogotá" CUN. It is not a city, it's a corregimiento.

dcd9589862363d0ff9cbe6dd6d52f4a511b6971c authored almost 3 years ago by cesariverit <[email protected]>
Replace city "Barrio San Luis" from CUN state to "Bogotá D.C." from DC state

781d6bb10c841bd21e7f3df202c900bc4700dca5 authored almost 3 years ago by cesariverit <[email protected]>
Improve Ecuador States and cities

0ec8e3b3a53f1b2bc868cac53111249bcba01da7 authored almost 3 years ago by Fabricio Orrala <[email protected]>
Update README.md

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

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

35e8754cbe94d3ec7129020d04f7be8c1a155c67 authored almost 3 years ago by Darshan Gada <[email protected]>
fix spelling to Bogotá, Colombia

936f8d4243c90ae0980c3822cc80e875a8c16a61 authored almost 3 years ago by cesariverit <[email protected]>
Fix: Docs modal issue on small screen

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

9f67eb2a267de6f0cb4f01afc58342d5a499443f authored about 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Fix Issues (#342)

* Fix: #338 Attach Thika to Kiambu County
* Fix: #339 Add & Update type in states of France
* ...

1023b0e2b56663a83daeb36f7f7c461311595403 authored about 3 years ago by Darshan Gada <[email protected]>
Remove changelog action

4bfa16eb6a46b67b488bf787e316f84d4a6597fa authored about 3 years ago by Darshan Gada <[email protected]>
(chore): Export JSON, CSV, XML & YAML files (#336)

c716e0ede86adb78f6fc31f324b4ce9d06194f97 authored about 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Fix #325 & #334 (#335)

c6c2b9b9a9db4d6fb6895254c8a1f5de651c158e authored about 3 years ago by Darshan Gada <[email protected]>
End of support for plist format (#332)

6f1e63673a96482138d2634357eed999e81786ae authored about 3 years ago by Darshan Gada <[email protected]>
(chore): Export JSON, CSV, XML, YAML & PLIST files (#331)

4a2d127a903c851f8cb348b2b398816b4038912a authored about 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Update Readme count

6c42991b7c40c5a7dcf4892f7687afcf1412ca43 authored about 3 years ago by Darshan Gada <[email protected]>
Fix: #328 Add missing Nicaragua departament & its municipalities

2c1844161d8ca416504642640b425893a0350bc0 authored about 3 years ago by Darshan Gada <[email protected]>
Fix: #294 Very long name

cd5876fb73e31f95374974a50542e5ab091329d9 authored about 3 years ago by Darshan Gada <[email protected]>
Fix #324: Add Cities of Basel-Stadt

82f2891085e4e20d123a095187a8959175d70b4f authored about 3 years ago by Darshan Gada <[email protected]>
(chore): Export JSON, CSV, XML, YAML & PLIST files (#330)

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

d14c6e0dadc00374c900d335344310b4015cd9bb authored about 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
fix: #313 Ghana (#323)

22e012a9fe083de699435a9530ae1e5ef3d15b8a authored about 3 years ago by Darshan Gada <[email protected]>
(chore): Export JSON, CSV, XML, YAML & PLIST files (#322)

17c61c9255ad105c2e4c9d12552cbeee9d5235c2 authored about 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Switzerland had mistakes (#315)

7f851f1ddf43a9b6eeb5cdd5fa204479f7b1fe36 authored about 3 years ago by Serge Decker <[email protected]>
fix: #312 Add missing town in NJ (#321)

c6ee1f3d81f67eb80ee04bb0911631a5d5b4fbef authored about 3 years ago by Darshan Gada <[email protected]>
fix: #318 & #317 (#320)

* fix: #317 Istanbul cities
* fix: #318 wrong district in cyprus

c8acf2f7abb43012c2302e7c56c6072cfe3ade1a authored about 3 years ago by Darshan Gada <[email protected]>
(chore): Export JSON, CSV, XML, YAML & PLIST files (#311)

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

7251e3dd44acb02d3bf0e29f3744c99ea30199a5 authored about 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Fix: #307 Add wikiDataID column to cities.json/csv/xml/yaml

12e21460526313588e9474f7cc7bd95d5feff42f authored about 3 years ago by Darshan Gada <[email protected]>
Fix #309 & #306 (#310)

cb4a84e1a7a3c96ed937ea9051f23f95cae3ea8e authored about 3 years ago by Darshan Gada <[email protected]>
renamed cities which has been transformed from districts to counties (#303)

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

1cdca1d87b06c79e65e3fb3fb8c10f87fd8c5ef4 authored about 3 years ago by John Mwai <[email protected]>
Add exported JSON, CSV, XML, YAML & PLIST files (#299)

Signed-off-by: Darshan Gada <[email protected]>

5fd64fb2a2e7abc055a495956a16f4ba8e58b667 authored over 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Fix 287 Fix Brazil state name

9aee2506c7705df6122e0342ac2f16cee7c3de66 authored over 3 years ago by Darshan Gada <[email protected]>
Fix multiple issues (#300)

* Fix #229 Add type column to states
* Fix #294 Very long city name in France
* Fix #291 Add m...

8d5501f4add27493bb392d1f1960027dfe1b2232 authored over 3 years ago by Darshan Gada <[email protected]>
Add exported JSON, CSV, XML, YAML & PLIST files (#298)

Signed-off-by: Darshan Gada <[email protected]>

1ad364bb4ff7c4ba6293047059abfacaf7e7c171 authored over 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Add script to pull up DROP commands at the top

d416c1ccc818fe6d91b616f495fff4bcf6695b28 authored over 3 years ago by Darshan Gada <[email protected]>
Fix Data Administrative Subdivisions of Indonesia (#295)

89e8f34984154d000c79be9e5851cf1beaaf42b5 authored over 3 years ago by Yudi Purwanto <[email protected]>
Add exported JSON, CSV, XML, YAML & PLIST files (#284)

Signed-off-by: Darshan Gada <[email protected]>

db93845adbba2a225939fb2fd2d80803413ca20b authored over 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Fix #280, #282, #229 & Add numeric_code to countries (#283)

c995f2411ecc74faeeef729eafd3485b37cccb6a authored over 3 years ago by Darshan Gada <[email protected]>
Add exported JSON, CSV, XML, YAML & PLIST files (#279)

Signed-off-by: Darshan Gada <[email protected]>

006ccb4f449c8b8a8aa359c4cf404e22d2e3f646 authored over 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Update country names and add missing phonecodes (#278)

cd37ba0241aeb38d9f1f9d0f0a0c9b7d7a93a595 authored over 3 years ago by Darshan Gada <[email protected]>
Add exported JSON, CSV, XML, YAML & PLIST files (#275)

Signed-off-by: Darshan Gada <[email protected]>

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

1370a05dee7032460b58751fa232281f3354dc17 authored over 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Rename COD to Democratic Republic of the Congo

39c0fd48c7736046c81bd1ea479e6662cf3bc6d4 authored over 3 years ago by Darshan Gada <[email protected]>
Add missing morocco states (#276)

e9780004e0f156c8153645bd43768209049ff88c authored over 3 years ago by Darshan Gada <[email protected]>
Add missing Nigeria state - River and its cities (#274)

f0cc2b9ad262f7f92f8584e8d7c7cc5a8d5ec2d2 authored over 3 years ago by Darshan Gada <[email protected]>
Add exported JSON, CSV, XML, YAML & PLIST files (#269)

Signed-off-by: Darshan Gada <[email protected]>

9dbff4a719a45c5c9b288a64018cd8d736f0f387 authored over 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Fix state_code of cities of Iran & Daman (#268)

9547ddff642208bb884753c6bf309df6d7b02400 authored over 3 years ago by Darshan Gada <[email protected]>
Add exported JSON, CSV, XML, YAML & PLIST files (#251)

Signed-off-by: Darshan Gada <[email protected]>

a740def97c14c0d0797ea6bd2ed1a3f4fde586bd authored over 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Fix Issues (#266)

# This PR Fixes
* Fix Chilean Cities Updated .XLSX #255
* Fix Missing KĹŤchi Prefecture in Japa...

5a880ff5cc4368ee1c03d247f4744cd024c64289 authored over 3 years ago by Darshan Gada <[email protected]>
Translate country name into Simplified Chinese (#257)

2acc8e6e0d2a8dc8b419f0a09adbe86039fe5241 authored over 3 years ago by Hades_Dev <[email protected]>
Update README.md

821dee3d3efad265e8fe0dfc2a782a50cdb2075b authored over 3 years ago by Darshan Gada <[email protected]>
Update README.md

e3d21b9f69582d7a4c1095a1eb64abe9a6db751d authored over 3 years ago by Darshan Gada <[email protected]>
Updated NCR state code to match with states iso2 (#261)

8e6de9d2a9682661d8dde80351995ac97bc3bafc authored over 3 years ago by Sean Ervinson C. Ong <[email protected]>
Fix translations json in world.sql

065edf8125371d347d8a0ebe10ec65b573a7a5c4 authored over 3 years ago by Darshan Gada <[email protected]>
fix translations json for guam (#263)

602ea7649d8634bfc24250b6c233d2dff55106b4 authored over 3 years ago by Alexandru Bagu <[email protected]>
Fix error in world.sql

4279ab64cb924dcc377ceacd934844b79e512ff7 authored over 3 years ago by Darshan Gada <[email protected]>
Translate country name into Korean. (#249)

080bea6ae738e7a9f2af830f2536a7b492c76445 authored over 3 years ago by Rain Byun <[email protected]>
Add data.world mention

92f84a98fc359a276d674158a74ab908649f4586 authored over 3 years ago by Darshan Gada <[email protected]>
Update README.md

d9b1d72192b1d2dc88d82238d53ad2b715e559da authored over 3 years ago by Darshan Gada <[email protected]>
Update README.md

3ce8b92223adf252911187fc07cb4865a8fbd58e authored over 3 years ago by Darshan Gada <[email protected]>