Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Suggestion: Add ISO 3166-2 code column #105

Open
natydev opened this issue Feb 23, 2020 · 4 comments
Open

Suggestion: Add ISO 3166-2 code column #105

natydev opened this issue Feb 23, 2020 · 4 comments

Comments

@natydev
Copy link

@natydev natydev commented Feb 23, 2020

In CSV data should be present ISO 3166-2 code that identify a province/state relative to a country.

https://en.wikipedia.org/wiki/ISO_3166-2

That will be useful to filter and/or identify unique country or province (or state).

example actual data:

Province/State | Country/Region |
---------------------------------
Beijing        | Mainland China |
Guangxi        | Mainland China |
Chicago, IL    | US             |
               | France         |
Padua          | Italy          |

example with ISO 3166-2:

Province/State | ISO 3166-2 | Country/Region |
----------------------------------------------
Beijing        | CN-BJ      | Mainland China | 
Guangxi        | CN-GX      | Mainland China |
Chicago, IL    | US-IL      | US             |
               | FR         | France         |
Padua          | IT-PD      | Italy          |
@iceweasel1
Copy link

@iceweasel1 iceweasel1 commented Feb 23, 2020

Best of all, however, is the "ISO 3166-1 alpha-3" code. If so, it should be used as standard here.

@natydev
Copy link
Author

@natydev natydev commented Feb 23, 2020

But ISO 3166-1 alpha-3 identify only country, not the province/state.
Instead ISO 3166-2 is complete because identify country with the 2 chars before hyphen (practically those 2 chars are the ISO 3166-1 alpha-2 code) and after hyphen there is the unique code for that province (or state).
In case when province (or state) is not available, only the country code is present.

@CSSEGISandData
Copy link
Owner

@CSSEGISandData CSSEGISandData commented Mar 9, 2020

Thank you for the ideas. We will keep them in mind for building out future capabilities.

@Bost
Copy link

@Bost Bost commented Mar 9, 2020

Right now we're working on something going in this direction Bost/corona_cases#1 It's a messy work and I'm getting exhausted. Talk to me in about 24 hours. Or have a look in my repo.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
4 participants