states.sql file have a error data

[enzochen]

the date of id 2272 name is "Shaanxi" current . the correct name should be "Shanxi"

[dr5hn]

@dosubot please label this Issue and also create a sizes label for issues similar you did for PRs. and find out how much effort will be required to solve this issue and label it accordinly.

[dosubot[bot]]

Hey @dr5hn! 😄 Great to see you diving back into the data maze with us. How's everything going on your end?

Thank you for bringing this to our attention. I've labeled this issue as data-error to categorize it properly. For sizing, based on the information provided and the nature of the issue, it seems like a small effort to correct the data.

To correct the data, we would need to update the states.sql file. The record with id 2272 should be updated from "Shaanxi" to "Shanxi". The SQL command would look something like this:

UPDATE states SET name = 'Shanxi' WHERE id = 2272;

This command will update the name of the state with id 2272 to "Shanxi". After running this command, the data should be corrected.

Please note that this change will need to be made by someone with write access to the repository, as I, Dosu, am unable to make changes to the repository directly.

If there are any other issues or errors you come across, please don't hesitate to let us know.

Sources

• sql/states.sql
• .github/CONTRIBUTING.md

About Dosu

This response is meant to be useful and save you time. It is not meant to be a precise solution, but rather a starting point for your own research.

Help me be more useful! Please leave a 👍 if this is helpful and 👎 if it is irrelevant.

If you want to continue the conversation, start your reply with @dosu-bot.