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

Add Treeware "conditions of use"

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

a9310c8e43d34582a9faae8d45433a44a83e3722 authored over 3 years ago by Darshan Gada <[email protected]>
Add LICENSE Section

4c1a3c18c37710c90d40388101c05ed9f5c9a160 authored over 3 years ago by Darshan Gada <[email protected]>
Add CONTENT_LICENSE

1c69ab9ee7183772ddcb3f888acc35d19f5bfe0a authored over 3 years ago by Darshan Gada <[email protected]>
Move LICENSE to root

f2f0e7185c9ff66b7dd42278e1e4cdcf37f503be authored over 3 years ago by Darshan Gada <[email protected]>
Add LICENSE

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

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

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

a890ca2c6846e5953183ecdb214b9d3f13cdc9ea authored over 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Remove district word from portugal states (#225)

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

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

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

0ce8f88f6307e2113f2b9025cd2644d5eff05f5b authored over 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Cosmetic updates (#223)

* Update world sql
* Add changelog action and markdown
* Trigger action on update of only worl...

5c360077fc95229a6f937024e5ad5a2da9fe6ba5 authored over 3 years ago by Darshan Gada <[email protected]>
Fix #219: Add missing cities in India (#222)

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

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

1ee0c3ff424f75f0d1997c00c342d75c36d19a6e authored over 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Fix Issues #201, #204, #205, #208 & #213 (#214)

* Fix: #205 Iran ISO codes and Add missing state and its cities
* Fix: #208 Switzerland Capital...

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

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

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

14079e440df3ea3935b3fb00cae420d1ea46e830 authored over 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Add missing state MaramureΘ™ County & Mures County Cities (#199)

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

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

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

6c217e3a1c5b0ea6d6d1f679c7b44ec0d6b26d7e authored over 3 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Data fixes and additions (#192)

* Fix #184: Removed duplicated Spain's provinces
* Fix #187: Removed city listed in states of P...

68f48c8dbd3118999f1cc8adae024899702b7e5a authored over 3 years ago by Darshan Gada <[email protected]>
(chore): Add exported JSON, CSV, XML, YAML & PLIST files (#183)

4a57806fc614b99c5ca35f042ab9a651b027d922 authored almost 4 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
FIx #178 #177 #180 #181 (#182)

* Fix: #180 Add top level domain (tld) to countries
* Fix: #177 Wrong column mapping in countri...

f6cb1e130fb9dddf5e04ca12ffa3ec52a1beb6dd authored almost 4 years ago by Darshan Gada <[email protected]>
[Export] JSON, CSV, XML, YAML & PLIST files (#174)

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

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

a715fe25d1fee3d534e5aced3a60a9f432136fc4 authored almost 4 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Skip translations in csv

9f61f36c1233a97f08011222938f2590b43e2c69 authored almost 4 years ago by Darshan Gada <[email protected]>
Fix currency_symbol NULL issue

59c346bc3bc986a9e0562d630b12e5a50bc2380c authored almost 4 years ago by Darshan Gada <[email protected]>
Update Exported Files (#172)

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

ebaacfbe061f19cec10d6572f4587d2a3beb78ad authored almost 4 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
FIx port

48086b2ac8a02eec6f388051080b4890191a1cb4 authored almost 4 years ago by Darshan Gada <[email protected]>
Update SQL Files

9636bae678f599fb2a6e925c603a8ea8419ba5be authored almost 4 years ago by Darshan Gada <[email protected]>
Enhancements (#171)

e891c2740aa19c3b1dc44eba9dcd1f9ceded8bd8 authored almost 4 years ago by Darshan Gada <[email protected]>
Issue Fixes (#170)

* Fix #140 Northern Ireland Cities Added to North Yorkshire
* Fix #165 Table cities column name...

ce271e295fdbd11970a647538174953d3747cea3 authored almost 4 years ago by Darshan Gada <[email protected]>
Update Scripts & Readme (#164)

da07a1f9080a1860da5d1c4cd4246b16e36b7904 authored about 4 years ago by Darshan Gada <[email protected]>
Update Export Scripts (#162)

651a3ab280c4db5c678e2df4304efb6720429cb6 authored about 4 years ago by Darshan Gada <[email protected]>
[Export] JSON, CSV, XML, YAML & PLIST files (#161)

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

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

5a5cb3f5545bf9d1152c15a3539b575198ba0ff4 authored about 4 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Set PHP version to 7.4 (#160)

67f21c8e2792b4ea9cfdca76f8d4f0a0577a7657 authored about 4 years ago by Darshan Gada <[email protected]>
Add Lat long to countries & states in SQL (#159)

229404135126088bbfc8bd76f0dabc98644e44b4 authored about 4 years ago by Darshan Gada <[email protected]>
Added lat/lng to Countries (#156)

Added latitude and longitude.

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

0473a907369c6747c868b9052a60bee2ca1e8f60 authored about 4 years ago by Darshan Gada <[email protected]>
Added lat/lng to States (#155)

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

c5c647fc342d9cfe3f38f20e3a4f5d9eedad64d9 authored about 4 years ago by Darshan Gada <[email protected]>
Add exported JSON, CSV, XML, YAML & PLIST files (#149)

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

e4a8a7c3074eab9fb5865ea26f54a1bf7ff5c77f authored about 4 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Merge pull request #148 from dr5hn/fix/Issues

Fix #137, #146 & #147

5f0ee3cbc94f08d0c11dc78d6452477ed5ad61ce authored about 4 years ago by Darshan Gada <[email protected]>
Fix #137 Add missing countries and timezones

50a60d35c4b651c41cea50c70244cae62fc98d5d authored about 4 years ago by Darshan Gada <[email protected]>
Fix #147 Add missing Schumen Region in Bulgaria

71986477369afd35a8fb3bc1a31cbe85f9c940e9 authored about 4 years ago by Darshan Gada <[email protected]>
Fix #146 Add missing Reghin City in Romania

13da02aed0ac0764f8994574ecb150d415a04910 authored about 4 years ago by Darshan Gada <[email protected]>
Usual Updates

2258c320c76b83a7accb74b4625e06bbee89d7f8 authored about 4 years ago by Darshan Gada <[email protected]>
Remove unwanted data (#145)

7debd9dd7e919b45ccd6d1f468d06017c45dbe88 authored about 4 years ago by Darshan Gada <[email protected]>
Add exported JSON, CSV, XML, YAML & PLIST files (#144)

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

f56a56f2ee0d9c41ee6b82dcb05c8b44937c1cd4 authored about 4 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Fix Missing Cities of Colombo & Kandy District (#143)

b93124f52fb276b990a902c218c7cf1a95395a99 authored about 4 years ago by Darshan Gada <[email protected]>
Add exported JSON, CSV, XML, YAML & PLIST files (#141)

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

b5a8edaad2f507ca44af4610332a442366bb5a0b authored about 4 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Fix composer

a42f4805504c80dbd049cb209e4ca140e0210cb8 authored about 4 years ago by Darshan Gada <[email protected]>
TimeZone added to each country (#138)

* TZ files
* Timezone changes
* Update countries with timezone data
* Improve export script f...

f66614ecf346132320b89e27c9866c79b171922b authored about 4 years ago by Valerian Pereira <[email protected]>
Fixing a few typos (#136)

Fixing a few typos :)

0738398e24e569d29fc86cbd3a08eca202c25419 authored about 4 years ago by Valerian Pereira <[email protected]>
Fix contribuation guidelines link in readme (#133)

6c20e1013ec155d7ab20311aa8692595f485bfc6 authored about 4 years ago by Patrick <[email protected]>
Add exported JSON, CSV, XML, YAML & PLIST files (#131)

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

e6e503aa21f2e6bb6a925617f0751bcf682adbf5 authored about 4 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Add region and subregion to export script (#130)

ca48514cd119e4648de975382322913cdd2c0633 authored about 4 years ago by Darshan Gada <[email protected]>
Add regions and subregions to countries (#128)

1e9040c71e94ae51f8d1008e7411252b40f79d11 authored about 4 years ago by Darshan Gada <[email protected]>
Add exported JSON, CSV, XML, YAML & PLIST files (#127)

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

7822f31076f429786030db16b4416fd2eddd5723 authored about 4 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Fix #107 - Add missing cities of Provinces in the Philippines (#126)

* Update .gitignore
* Update script
* Introducing API
* Update insights

d49c704f64300922cf4f4d8c93821f3e47b6d892 authored about 4 years ago by Darshan Gada <[email protected]>
Add exported JSON, CSV, XML, YAML & PLIST files (#122)

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

7ccde2c93fd1ab8237cb5e867f085bbbb0e794a9 authored about 4 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Update Docs (#121)

fe22bb5b20ba23816bb16efb68c4bda6d62f0d60 authored about 4 years ago by Darshan Gada <[email protected]>
Fix: #119 Nassau missing in Bahamas (#120)

dc69ca285420916ab2605f00b9b9144ffdf171ae authored about 4 years ago by Darshan Gada <[email protected]>
Add exported JSON, CSV, XML, YAML & PLIST files (#118)

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

9d0e0b4868684518de69e9dedeb12b63a6cf22e4 authored about 4 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Fix action and remove unwanted action (#117)

4fd20f4f5163a1171cbac018b8cb58c1e403bc7e authored about 4 years ago by Darshan Gada <[email protected]>
Improve Plist Export Script (#116)

82b7cde9353e248a2f3dd0765813cb4e0e268655 authored about 4 years ago by Darshan Gada <[email protected]>
LTU rajonas (#114)

* remove not existing LTU cities

45c2d5f27ece2f2b1fc7d059b97ed691f1108ded authored about 4 years ago by minved <[email protected]>
[Export] JSON, CSV, XML, YAML & PLIST files (#113)

d805e5eaca40ac3b050a6e5e566b3ab0219add36 authored about 4 years ago by github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
You can run this workflow manually (#112)

510dbbf070eae61d507234f1bea381575adcfb8b authored about 4 years ago by Darshan Gada <[email protected]>
Fix Plist Action (#111)

* Fix Plist Action
* Fix cities count in Doc

86ec233fa484e149bb82046a5f3552ab8c3285d0 authored about 4 years ago by Darshan Gada <[email protected]>
Fix Github Action (#110)

* Fix Action
* Fix name warnings in composer.json

abe8ed7637a2ab872170e32f0620396fd8022506 authored about 4 years ago by Darshan Gada <[email protected]>
fix the bug in cities sql file (#109)

* fix bug in cities sql
* fix bug in world sql
* Fix action to run on forked repo's PR

f5254b19749b3512473531074ef73d0572d34ef0 authored about 4 years ago by Mitesh Dudhat <[email protected]>
Update CONTRIBUTING.md

f896e53d3541530edfb214d828b68f17bba6316c authored over 4 years ago by Darshan Gada <[email protected]>
Improve Demo (#105)

* NEW: Improved Demo WIP
* Attach More info modal
* Finalize Demo
* clear cities if country s...

be1e8bc00f0a05bd1422b5622ea0319ae90ff71c authored over 4 years ago by Darshan Gada <[email protected]>
FIX: #63 #90 #99 #101 (#102)

* FIX: #99 Add Kosovo as Country
* FIX: #90 Add Buenos Aires City as a State
* FIX: #63 City B...

ba2d8dc4480437ed13436ea4eaedd5bfbece42b4 authored over 4 years ago by Darshan Gada <[email protected]>
MERGE: PR-52-93-94 Merged All Updates (#97)

- Fix state_code for South Africa states Gauteng and Kwazulu-Natal
- added states (parishes) of...

17ed9a7cb4834621eed2f4af18fc0a0d3e3783c6 authored over 4 years ago by Darshan Gada <[email protected]>
FIX & ADD: Austria Cities #95 & #88 (#96)

75aa7d163332d140d7df8c930fe0f5525ba1d232 authored over 4 years ago by Darshan Gada <[email protected]>
More links added.

6aec3c4d4a7dd27ae29790c37140123591929e59 authored over 4 years ago by Darshan Gada <[email protected]>
Added more sources of fundings.

071540a0a040eb64a975f8d219c2f7d7854e8164 authored over 4 years ago by Darshan Gada <[email protected]>
Merge pull request #91 from dr5hn/pr/89

"Neufahrn in Niederbayern" is not a state - SQL Update

13ddc017b813263e395df1477eb8e9ba906414c2 authored over 4 years ago by Valerian Pereira <[email protected]>
Update Exported Files

8ac2659427c422fce3d238dbafbf3b03385c3870 authored over 4 years ago by Darshan Gada <[email protected]>
πŸ› FIX: Remove 3012 Neufahrn in Niederbayern from SQLs

bb703eb1c13f38b64b1893385175c25610b9a747 authored over 4 years ago by Darshan Gada <[email protected]>
"Neufahrn in Niederbayern" is not a state

7ed05fd26c2647c27b428e4c9ceb79634cd31b20 authored over 4 years ago by Sebastian Kroll <[email protected]>
Add & Fix Some Cities in Punjab of Pakistan & India (#87)

9080b89cb0781e13f5c0c18b9508a4dd2d8b68ed authored over 4 years ago by Darshan Gada <[email protected]>
πŸ› FIX: Puerto Rico cities are missing #50 & Missing Guarda District in Portugal #82 (#85)

63b99e3dbd6cf9f01b9254c4d8dc24dfbb6863c9 authored over 4 years ago by Darshan Gada <[email protected]>
πŸ› FIX: Missing Roraima state in Brazil #41 (#84)

2bff5b746cea6f744b790769d449d5cdf7c05370 authored over 4 years ago by Darshan Gada <[email protected]>
πŸ› FIX: #36 Missing Jalisco state & its Cities of Mexico (#83)

d7647c4b46d3796cbf959e5a46a009d03e41aa95 authored over 4 years ago by Darshan Gada <[email protected]>
Fix #76 Venezuela state #79 Gujarat Cities (#81)

* Add Missing state to Venezuela. (#76)
* Fix Gujarat Cities Encoding & Add More cities to Guja...

79687b088fef80c203d46fd82df5593a19585acf authored over 4 years ago by Darshan Gada <[email protected]>
πŸ› FIX: #72 WestBengal India & #74 Sinop Turkey (#75)

* πŸ› FIX: #72 WestBengal India & #74 Sinop Turkey
* πŸ“– DOC: Update Readme Counts
* Update Export...

12df06fa784a03dbd32a2d9390c863eafdd9fe36 authored over 4 years ago by Darshan Gada <[email protected]>
Update README.md

0cbec9c55d8d39f6b9c40d7bdf9892c127f306ed authored over 4 years ago by Darshan Gada <[email protected]>
Update README.md

e58eb330a1d4b4d2cfef02ef67c1c97ee48631a0 authored over 4 years ago by Darshan Gada <[email protected]>
#70 Add State Ladakh & Cities #58 Add Country Flag (#71)

b69cce092a62c854efa0b1b84dd1609557c5a996 authored over 4 years ago by Darshan Gada <[email protected]>
πŸ› FIX: #49 Spelling of the city pathanamthitta is wrong (#69)

* πŸ‘Œ IMPROVE: Export Script
* Update Exported Files

74aa4c91300896ab8304d959d0896c323f6a0ac7 authored over 4 years ago by Darshan Gada <[email protected]>
πŸ“¦ NEW: Export to CSV (#68)

d6f4a37cb3eebb0b0d3cc0d051ccd6ac8ec6fe81 authored over 4 years ago by Darshan Gada <[email protected]>
πŸ“¦ NEW: Export to YAML (#67)

bdb9911271452029278c032ee76e287cc49d81f2 authored over 4 years ago by Darshan Gada <[email protected]>
πŸ“¦ NEW: Export to PLIST (#65)

02032c751cb5b924cae0965403ab47a8216a4220 authored over 4 years ago by Darshan Gada <[email protected]>
πŸ“¦ NEW: Export to XML (#64)

614d72f226fae9e3a2007520912e6f6010f4384d authored over 4 years ago by Darshan Gada <[email protected]>
Improve JSON Output (#62)

a2a4edbd825a68cbf95444adee488f0d16fd86fb authored over 4 years ago by Darshan Gada <[email protected]>
πŸ“¦ NEW: GitHub Actions - Automate updation of JSON Files (#61)

5b98f8d33d7676180ff6d73320c69cfdc91b94a2 authored over 4 years ago by Darshan Gada <[email protected]>
Update README.md

ef02b41281a5d94b09c94e0a92e24b3e563be2f3 authored over 4 years ago by Darshan Gada <[email protected]>
πŸ“– DOC: Update Readme

056a757de4fa06b3b0cbe7093ff710d1c65855c7 authored over 4 years ago by Darshan Gada <[email protected]>
πŸ‘Œ IMPROVE: ReadMe (#60)

1b8874120e0e5f23c86a5ee85ce140fe6a65cae6 authored over 4 years ago by Darshan Gada <[email protected]>
πŸ›FIX: #46 SQL UTF8 Encoding Issue & #37 UK Wrong Data (#57)

* UTF8 Ate
* πŸ‘Œ IMPROVE: Script Reusablity & UTF8 Preservance

Co-authored-by: Darshan Gada <g...

76f393463034b115e23725e7315983720383fa77 authored over 4 years ago by Valerian Pereira <[email protected]>
Merge pull request #47 from MegadreamsBE/master

Removed newline character from North Korea

816d8bbfc970bf2e6ad626d85a96b9e1fc2d4574 authored over 4 years ago by Darshan Gada <[email protected]>
Merge pull request #56 from dr5hn/improve/Structure

πŸ‘Œ IMPROVE: Folder Structure

cc9f01ebeaaaa64fe8076c3514a34b058d3f2edb authored over 4 years ago by Darshan Gada <[email protected]>
πŸ‘Œ IMPROVE: Folder Structure

df5bd3c701504ff4ecaa20c571253dc848ad0450 authored over 4 years ago by Darshan Gada <[email protected]>
Merge pull request #51 from dr5hn/feat/Contribution

πŸ“– DOC: Add Contribution Guidelines

f131517832089b0ab943c5d1a05a32d8dfbc34b4 authored over 4 years ago by Darshan Gada <[email protected]>