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

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

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

0762ceb91886fa7ebfc4eeb419ad536c1008c6d8 authored 11 months ago
fix: add alimosho city to lagos state, nigeria (#756)

7d38fc408e14bdba8df58017495ff4d6facf6a21 authored 11 months ago
rename 'Ar Ruways' to wikidata accepted name 'Ruwais' (#757)

ef78cae6fbb2d0a704ac15ff539b0240adf55671 authored 11 months ago
(chore): Export JSON, CSV, XML & YAML & PSQL files (#753)

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

9c892973851e44342634f68d739690b2c8c20478 authored 11 months ago
feat: use php 8.1

31c64052acc86706e721078cda9803465f501eba authored 11 months ago
fix: Uttarakhand State code from UT to UK (#752)

a3e25980f4021f3482ed8a643581eeb4da381d91 authored 11 months ago
fix names of eswatini, timor-leste, PNG, and more (#748)

8c363fce6542384d82dc02ea363c4e894b92eb40 authored 11 months ago
Fix error in the name of the state 1200 (#751)

0a6dbfb0f74800f33be3ea2b5ac334c2da70298c authored 11 months ago
Update README.md

3d3fc8e5b08525a37892a275d28d8704c153e210 authored 12 months ago
Update README.md

2d15c59eae41f9cb743a37159fa9fd1f00277ac1 authored 12 months ago
(chore): Export JSON, CSV, XML & YAML & PSQL files (#744)

Co-authored-by: dr5hn <[email protected]>
Co-authored-by: Darshan Gada <gadadarsha...

aef9b85cae1bab5bbfbf0f33ab34f81716154b0a authored 12 months ago
chore: update readme

88b1d7feb801850b6564f3f4fa738bef7489024d authored 12 months ago
chore: update readme

0ddd0d5874ac7a7745272e35f6e13f33dc445446 authored 12 months ago
fix: Mexico CDMX state_code to CMX

870bfc47a26e9c77a9d1d636a76be93d62661dd4 authored 12 months ago
fix mispeling on CapĂŁo Bonito, SP, BR. (#742)

54d8d1019de5489f73d6b0e226fd893014aa89cd authored 12 months ago
feat: Add Postgres database migration and export action (#739)

d4036d461c83b8f36015deef5e19466d2064e540 authored 12 months ago
(chore): Export JSON, CSV, XML & YAML files (#737)

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

cb7c3ac68b5d974da84eb2b42b8c1b84106df33d authored about 1 year ago
Sql Upadted Abkhazia name changed (#731)

1aed768f00da461a589e570d63539afd3515369e authored about 1 year ago
Update README.md

aafba763b3f40ab0dbf0953f276dcb6f42a16c0b authored about 1 year ago
Update README.md

2ecded3daf89bc39bf6b8a4044aa88d5a0a6c2e5 authored about 1 year ago
(chore): Export JSON, CSV, XML & YAML files (#716)

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

eb0ead3cd2d7f35c52df5be10a08960a35eb81ea authored about 1 year ago
fix: syntax

b7307646deac038e668e61b7df824b414be4137e authored about 1 year ago
feat: update github action to automatically update readme count

98ce5cdac37fb493bf1a10e99a4ee96778280ccb authored about 1 year ago
Update values for Swedish county Blekinge (#709)

91d40a2ff0decc049822956e1be22c24289bd10c authored about 1 year ago
Update cities benguela (#713)

80864a02eb98ad06611067f987b59ac961aaf356 authored about 1 year ago
(chore): Export JSON, CSV, XML & YAML files (#708)

Signed-off-by: Darshan Gada <[email protected]>
Co-authored-by: dr5hn <[email protected]....

0aeee1fb52bdd44c1a21d99cd073ae6ce3530a68 authored over 1 year ago
fix the name of the city Boa SaĂşde, in RN, Brazil (#703)

* Update cities.sql and world.sql

fix the name of the city Boa SaĂşde, in RN, Brazil. It was c...

bd53dcff0533674fbc52c74ffc939df9953fe855 authored over 1 year ago
Update README.md

968836625ddf322e3de6a534e8f7413bc5a1c8df authored over 1 year ago
(chore): Export JSON, CSV, XML & YAML files (#701)

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

85a88a238bcec2dc35ac652e20ec28a92dc03121 authored over 1 year ago
ISO 3166-2:MX -> changed Ciudad de MĂ©xico CDMX to CMX (#697)

dc6b39538a3216c72028dccedcc05d6dbca9a96b authored over 1 year ago
(chore): Export JSON, CSV, XML & YAML files (#696)

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

56496af6ab2a8b98aab6703276dea41109d3be1b authored over 1 year ago
add: Dessau-RoĂźlau, ST, DE (#694)

50afaa196e170c7e131a66606806f08b3b2071a2 authored over 1 year ago
(chore): Export JSON, CSV, XML & YAML files (#695)

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

424c619d00881d3deec98daeb660ddbab7654131 authored over 1 year ago
Add New Caledonia provinces and cities & Add hedehusene, denmark (#684)

3e775c92942b2ff3ceea11cf73502aaebee1c1be authored over 1 year ago
fix: missing escapes in subregions (#693)

61ee13dc8dbab35a00d47e21365b461cbee3d8ca authored over 1 year ago
Added new city Perinthalmanna in Kerala -> India (#689)

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

b79e42db0b7c8362321a83be452131945fd33ae3 authored over 1 year ago
(chore): Export JSON, CSV, XML & YAML files

51f5c2272e39a73d58661cdb128577284c066629 authored over 1 year ago
feat: add default charset

77e77ed178f7b53ffdc4993d6a9857a299966282 authored over 1 year ago
feat: update worlds sql

2fd0bb652f928f60d042132e1e58e119044e8853 authored over 1 year ago
feat: update scripts

c2be89b16ddddc3db74dfdc7ae5587a5830540ad authored over 1 year ago
fix: world sql

4a99a98eaa4e13cca3c6dbee33c77c40860f8f5c authored over 1 year ago
feat: update world sql

41cf29037957d47be7ab8af01b997f0f9c1dcd2f authored over 1 year ago
fix: export yml file

20d244fa779c508ff1324233fddc0a049540aafe authored over 1 year ago
feat: update export script

8fa597a5e369a1a29127ac8b34cf33609a3651fd authored over 1 year ago
feat: update readme count

854ba4c209f77e3075118f048fee9a1ff10f076b authored over 1 year ago
Feature/subregions (#668)

9abb2dead189c26521ef2e299cbcd14c27e38e66 authored over 1 year ago
(chore): Export JSON, CSV, XML & YAML files (#677)

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

3442c98ff0f2d462e67ae41d7cb7120730465b94 authored over 1 year ago
fix: export script

3cf94aae0e144c461841da09d13a36c43884ddd8 authored over 1 year ago
feat: update workflow integrate regions

d57133b753476dd760f68348ce24335327fd26ca authored over 1 year ago
add: regions database table (#657)

83d39f2ba6dda53ff398cf6b8c3e5e05757f0038 authored over 1 year ago
fix erroneous state code for sevastopol (#672)

0a66f3a9375a5b1dd9fb691a78e3e56e052cec9e authored over 1 year ago
Fix city double sleman of yogakarta indonesia (#663)

f90298a22755e7a5ed2e7f5b6dbd0799d403decd authored over 1 year ago
(chore): Export JSON, CSV, XML & YAML files (#662)

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

1b0801073a0fb70ed6fb9d81ca65d21de9c1ba7e authored over 1 year ago
chore: update readme

6ad0ef2a078aa3fbd54a7552e84f6bd96e83e346 authored over 1 year ago
feat: update scripts to add nationality

3e728d220be16a9227ccb22cb6d61956b937bf20 authored over 1 year ago
feat: add nationality to countries (#660)

27d48b84588ada2f7e6b30dd966fd29d5ea65b07 authored over 1 year ago
fix state Daerah Istimewa Yogyakarta (#655)

836b20355b85221ef0ebf0eb0f60b5496af808d7 authored over 1 year ago
Add City of Industry, CA, USA (#632)

20131eafb038205d5836a1362efb20b84c8ca906 authored over 1 year ago
(chore): Export JSON, CSV, XML & YAML files (#659)

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

807539b44c04875f486c0f5645f05a35a64b3793 authored over 1 year ago
fix: warnings

15aaac9b33cf36ff3a0db39fcc33ea7e247f7933 authored over 1 year ago
fix: issue

c228a438c3024b3469dbbae9f3144a89d0e71927 authored over 1 year ago
Add cities of Puerto Rico (#646)

2e6740578e91184bbebabef3c28b3b8215986427 authored over 1 year ago
Fix incongruent state_code and country_code for cities in Sevastopol (#633)

107f0275a2566945212398364af95718e91a9afc authored over 1 year ago
(chore): Export JSON, CSV, XML & YAML files (#656)

Signed-off-by: Darshan Gada <[email protected]>
Co-authored-by: dr5hn <[email protected]....

4bf794d579d8a4e34b5c4a42a3ca6bb3e421ee0a authored over 1 year ago
fix Ukraine capital typo (#649)

8f74af459cdf3a3c4c46a014f7b003c37f92490e authored over 1 year ago
fix: #631 add ceuta and melillia in spain (#645)

ae37e188a3b490f80e6907a9a19d293656648f38 authored over 1 year ago
fix: #638 add canary island and its cities (#644)

c28c8a5e58e8e23fd25f3fb1ff49b7d31cc85495 authored over 1 year ago
fix: #642 add missing city to crete,greece (#643)

0845cc406da9e66df66abf88fa79b0e036250c75 authored over 1 year ago
fix: #639 Add missing cities of Aland Island Finland (#641)

283f8aba90bb6d278bcb7d2721fde115048e4965 authored over 1 year ago
Remove 'Department' from Uruguayan states (#629)

fb419a618340e72decbe57c3f9da8120b12f7a1e authored over 1 year ago
Fix venezuelan iso currency code (#650)

417af71e6e7cb022e6fff8eb974034bcb284d4bc authored over 1 year ago
(chore): Export JSON, CSV, XML & YAML files (#640)

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

daa0f383fac59485a8ff2fc51256c14817737d84 authored over 1 year ago
chore: Added details of Asuncion which is capital of Paraguay (#627)

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

e6c7877df81b2c273e163d117cfb5b7ec1aae0a2 authored over 1 year ago
Remove duplicate city for Jakarta (#635)

6c2d74f90dcfba22056e8ec19b23767e9c85543c authored over 1 year ago
Rename Ă…rhus to Aarhus (#634)

1baf8a34805d6522cb0a855b07663c86fc389123 authored over 1 year ago
(chore): Export JSON, CSV, XML & YAML files (#621)

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

8060f03ab0aec1380f18d2c80b8bc7d5a8afcc6b authored over 1 year ago
Tai Po state_code fixed. (#620)

Co-authored-by: Omer Hamid Kamisli <[email protected]>

4cadbff016cb09e517e6941c9c41c06a2e819f9c authored over 1 year ago
(chore): Export JSON, CSV, XML & YAML files (#612)

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

e0a842eba00c6ce902c11b5aa82fbe21fd916f79 authored over 1 year ago
fix: some of cities has wrong state codes (#600)

08417ac9979378bb07132b3cfec205edda38fa8d authored over 1 year ago
fix: Multiple issues (#611)

a1bfbac35dce736187657d0e89fc37e02d6156d3 authored over 1 year ago
Update README.md

ae92607854cddbd1e6b906a44d944ef557117f52 authored over 1 year ago
Update README.md (#607)

ac0f40d20da5c8e4f7496f3684075885d94f6bf7 authored over 1 year ago
(chore): Export JSON, CSV, XML & YAML files (#590)

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

006dd271a0ce1189157ddeb7d750b48dbecfe06c authored almost 2 years ago
fix: Multiple issue (#589)

b989c2e4f31b104913f09fa26274ecf683fee064 authored almost 2 years ago
(chore): Export JSON, CSV, XML & YAML files (#579)

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

4fbd2b5290cbf5085e45ca6238cdcfca30dbb35c authored almost 2 years ago
Fix #562 and #566 (#578)

23f05446a98e02dd921e930fb5a3ffe15db05831 authored almost 2 years ago
Fix the date

268c40a7e9776842c9718ae809660ee6210539d1 authored almost 2 years ago
Update Sana'a to Amanat Al Asimah (#570)

52c699b363d53b774891f6b3e127f594011b420c authored almost 2 years ago
Update Macedonia to North Macedonia (#568)

59bd18064dc0db93aa5f72a6c20811e438956059 authored almost 2 years ago
All regions of Turkey have been updated (#559)

553ed72b13e2f21d7b4d71666180eb7d87d1ead6 authored almost 2 years ago
fix: added jamtland county for sweden (#534)

c2de3826a8afd509980afff6275d5803ac2ee2a6 authored about 2 years ago
Update README.md

c6ec842d4c52148bce79631fc6772caa337ca324 authored about 2 years ago
(chore): Export JSON, CSV, XML & YAML files (#540)

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

a4741c529b5f4f9dc8fbfc5505b912ac49219cc7 authored about 2 years ago
fix: Multiple issues (#539)

d47346b82a385efb937e9389e9f07c29ab78f2eb authored about 2 years ago
fix: turkish character problems for istanbul and umraniye (#537)

0ca62f61854f565101b8f28108a9a75ba83a221f authored about 2 years ago
Removed the district suffix from bangladesh districts (#524)

34a4f398a1bcf2cb4da6855ce15c19d76a897ed3 authored about 2 years ago
fix: Italian data (#531)

17bcc32a83a11294b24d2b00b75d909ef8a0771a authored about 2 years ago
(chore): Export JSON, CSV, XML & YAML files (#519)

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

b27994368fbc879ceefdba277e17db3d535dccd0 authored over 2 years ago
fix: Orissa's State code

327968094310d1e4b6658196b189fe93e8c58b00 authored over 2 years ago
chore: Update readme count

132554975a6212e44fac0bfb6ba1d22689166031 authored over 2 years ago