fix-contribution
Skill9.9k starsChanged 7 months agoODbL-1.0View on GitHub
Fix common issues in geographic data contributions to the CSC database. Use this skill whenever you need to fix, correct, repair, patch, or resolve issues in a data contribution or PR. Trigger on: "@copilot fix this", "auto-fix" label on issues, "can you fix", "please correct", "help me fix", "what's wrong with my PR", removing auto-managed fields, correcting country codes, fixing mismatched foreign keys, or formatting JSON. Also use when a PR has validation errors and you need to commit fixes directly. Read common-fixes.md in this directory for fix patterns and examples.
We split this skill into the rules it gives an agent
14 rules. About 0 are common, 9 are distinctive, and 5 are very specific to this project.
≈0
Common · estimate
Many files like this have a rule of this kind.
≈9
Distinctive · estimate
This author's own choices. Worth a look.
5
Very specific
Tied to their project's names, files or tools. Probably skip.
Licensed with conditions — read it at the source. We count its rules but don't quote them. Read them on GitHub.
≈ “Common” is an estimate: at least 1 in 5 of the 308,232 skill files we read have a rule of the same kind, not the same words. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.
Trending
Less talk lately.about the whole repository
Who's talking about dr5hn/countries-states-cities-database
- Stack Overflow“Parsing city of origin / destination city from a string”Stack Overflow · Jan 29, 2020 · 159 votes
- Stack Overflow“How to generate/find dataset of global cities in multiple languages?”Stack Overflow · Oct 10, 2024 · 3 votes
- A Hacker News story“Show HN: DB to map cities to countries and states”Hacker News · Mar 12, 2024 · 3 points
- A Hacker News story“Open-Source Global Database: Countries, States, Cities – JSON, SQL, XML and More”Hacker News · Aug 21, 2024 · 2 points
- nextcloud/recognize“Read Geo tags”GitHub · Jan 13, 2022 · 2 reactions
The biggest 5 of 48 mentions linking to the repository that our crawl found. Each line is their own headline.
See all 48
Talked about on GitHub, Stack Overflow, Hacker News and the web (48 times).
On GitHub · 40
- Jan 13, 2022Read Geo tags — nextcloud/recognize2 reactions · 1 comment
- Dec 19, 2025Normalização dos dados de Localização — scieloorg/core1 reaction
- Oct 19, 2026build(deps): bump the production-dependencies group across 1 directory with 8 updates — cayankuzu/mrap0 reactions · 1 comment
- Sep 26, 2026Credit the map and search data on the public credits page — JamesPortman/terra-incognita0 reactions
- Sep 17, 2026Programación en KMP — pandacode2011/amanoterms0 reactions
35 more on GitHub
- Jul 24, 2026Add province/ville and password confirmation to signup — SergioRSK109/fanbosss0 reactions · 1 comment
- Jul 13, 2026url-retrieve for time-zones--timezones-url fails — xenodium/time-zones0 reactions · 1 comment
- Jun 1, 2026Import cities error — pyconid/pyconid-be0 reactions · 1 comment
- Mar 15, 2026Return coordinates for pages — martin-majlis/Wikipedia-API0 reactions · 1 comment
- Mar 5, 2026Country/State data — paleobot/pbdb2-dev0 reactions · 4 comments
- Feb 12, 2026[Feature] Please update places.json — rohitkumbhar/surmai0 reactions · 1 comment
- Dec 31, 2025Quotes and Commas not supported — PTechSoftware/csv_lib0 reactions · 1 comment
- Dec 19, 2025Add status field and data cleaning for location normalization — scieloorg/core0 reactions
- Nov 3, 2025Updated states and cities for Jersey (JE) country — harpreetkhalsagtbit/country-state-city0 reactions
- Oct 4, 2025Fixes 45 Country City Clashes — tomaytotomato/location4j0 reactions
- Aug 15, 2025Update job locations — serg-cs/unitowork0 reactions · 1 comment
- Aug 6, 2025Fix problem in State class due to breaking change in database format. — MichaelWhi/list_of_countries0 reactions
- Jun 11, 2025Country states cities database — heathdbrown/research0 reactions
- Apr 1, 2025Bump the production-dependencies group with 6 updates — zoonk/zoonk0 reactions · 1 comment
- Mar 17, 2025Update Countries/States/Cities Dataset — tomaytotomato/location4j0 reactions
- Jul 19, 2024Distinguish the proper timezone for each activity based on its location — h-yung/trip-organizer0 reactions
- Jul 6, 2024GeoData: Update to latest version — sp-framework/core0 reactions
- Jul 5, 2024Geo Packages: Add method to create new entries — sp-framework/core0 reactions
- May 30, 2024[Module Listing Request]: `nuxt-countries-api` — nuxt/modules0 reactions · 2 comments
- May 21, 2024[Feature] Add `SQLite` database support in the export workflow — navicraft/countries-states-cities-database0 reactions
- Apr 27, 2024120 backend userprofile location model updated to take array of strings wait for 118 — crystaljobe/change-mate0 reactions · 4 comments
- Apr 7, 2024BE: Pull countries + cities DB — voyageglobal/voyage-backend0 reactions
- Apr 4, 2024Please Provide The Seed for actual data — RasyidHakim-2804/Country0 reactions
- May 5, 2023Integration countries-states database as a schedule task — grandnode/grandnode20 reactions · 1 comment
- Dec 4, 2022Validate Cities — joaoftrodrigues/atpdb-cleanup-and-conversion-to-relational0 reactions · 23 comments
- Sep 28, 2022Add dr5hn to maintainers — github/india0 reactions
- Jun 25, 2022Add data for all countries, states, provinces and cities — bcProFoundation/lixi0 reactions · 1 comment
- Jun 24, 2022Get all regions and cities of a country — countries/countries0 reactions · 1 comment
- Mar 13, 2022Need help — khkwan0/countryCityStateJson0 reactions · 1 comment
- Jul 7, 2021build(deps): bump country-state-city from 1.0.5 to 3.0.1 — lapi-hotel-group/furport-front0 reactions
- Jun 21, 2021build(deps): bump country-state-city from 1.0.5 to 3.0.0 — lapi-hotel-group/furport-front0 reactions · 1 comment
- Jun 18, 2021build(deps): bump country-state-city from 1.0.5 to 2.2.0 — lapi-hotel-group/furport-front0 reactions · 1 comment
- Apr 13, 2021Hello. Sorry... but I would like to know how can I get the translations if possible as we can see on https://dr5hn.github.io/countries-states-cities-database/ through api request. — dr5hn/csc-website0 reactions
- Dec 8, 2020Can we use dr5hn/countries-states-cities-database ? — harpreetkhalsagtbit/country-state-city0 reactions · 7 comments
- Oct 23, 2020Import from CSV data — dereuromark/cakephp-data0 reactions
On Stack Overflow · 4
- Jan 29, 2020Parsing city of origin / destination city from a string159 votes
- Oct 10, 2024How to generate/find dataset of global cities in multiple languages?3 votes
- Oct 23, 2019How to import this github repo's sql files in phpmyadmin1 vote · 1 answer
- May 5, 2023OPENJSON From File and unicode chars issues0 votes
On Hacker News · 2
- Mar 12, 2024Show HN: DB to map cities to countries and states3 points
- Aug 21, 2024Open-Source Global Database: Countries, States, Cities – JSON, SQL, XML and More2 points · 3 comments
On the web · 2
- Aug 18, 2026dr5hn/countries-states-cities-database — gitstar-ranking.com
- Feb 1, 2019Add abbreviations to states and adding zip/postal codes #3 — google.com
In this repository5 other files it gives its agents.
- .claude/CLAUDE.mdCLAUDE.md
- .github/copilot-instructions.mdCopilot instructions
- review-data-prSkill
- triage-issueSkill
- validate-contributionSkill
Does it work?
Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.
No reviews yet
People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.
- It worked
- Partly
- It didn't
Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.
Your trail
Files you open will collect here, so you can find them again.
Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.
Now do this for your own.
Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.