Mapping Region names to Iso Country and Region codes and WikiData IDs

[WolfgangFahl]

In addition to https://github.com/CSSEGISandData/COVID-19/blob/master/csse_covid_19_data/UID_ISO_FIPS_LookUp_Table.csv

At https://github.com/WolfgangFahl/jhuregionmapper you'll find a proposal how to map the JHU country and province names to identifiers in other systems via 2 digit ISO country code and 4 digit ISO Region code and or WikiData ID.

If wanted I will also map unlocodes for cities. See http://wiki.bitplan.com/index.php/SPARQL#Structure_of_the_Example_Data

The main SPARQL WikiData Query used is available at http://wiki.bitplan.com/index.php/SPARQL#COVID-19_-_background_data_Population_and_Location_of_Countries_and_Provinces and in the source code.

Here is an excerpt which shows the population of the region as example data from WikiData

✅                  China               Fujian   26.1, 118.0 -   37 km-> CN-FJ;   Q41705;                                  Fujian; 36894216;  25.9; 118.3
✅                  China                Gansu   37.8, 101.1 -   85 km-> CN-GS;   Q42392;                                   Gansu; 25575254;  38.0; 102.0
✅                  China            Guangdong   23.3, 113.4 -   10 km-> CN-GD;   Q15175;                               Guangdong;       -1;  23.4; 113.5
✅                  China              Guangxi   23.8, 108.8 -   56 km-> CN-GX;   Q15176;        Guangxi Zhuang Autonomous Region; 46026629;  23.6; 108.3
✅                  China              Guizhou   26.8, 106.9 -    5 km-> CN-GZ;   Q47097;                                 Guizhou;       -1;  26.8; 106.8
✅                  China               Hainan   19.2, 109.7 -  111 km-> CN-HI;   Q42200;                                  Hainan;  9171300;  20.0; 110.3
✅                  China                Hebei   39.5, 116.1 -  219 km-> CN-HE;   Q21208;                                   Hebei; 71854202;  38.0; 114.5
✅                  China         Heilongjiang   47.9, 127.8 -   94 km-> CN-HL;   Q19206;                            Heilongjiang; 38312224;  48.0; 129.0
✅                  China                Henan   33.9, 113.6 -   11 km-> CN-HA;   Q43684;      
...
✅                Ukraine                        48.4,  31.2 -   92 km->    UA;     Q212;                                 Ukraine; 42558328;  49.0;  32.0
✅   United Arab Emirates                        24.0,  54.0 -   54 km->    AE;     Q878;                    United Arab Emirates;  9400145;  24.4;  54.3
✅         United Kingdom              Bermuda   32.3, -64.8 -    3 km->    BM;   Q23635;                                 Bermuda;    65024;  32.3; -64.8
✅         United Kingdom       Cayman Islands   19.3, -81.3 -   82 km->    KY;    Q5785;                          Cayman Islands;    58435;  19.5; -80.5
✅         United Kingdom      Channel Islands   49.4,  -2.4 -    7 km->     ?; Q3405693;                                    Sark;      600;  49.4;  -2.4
✅         United Kingdom            Gibraltar   36.1,  -5.4 -    1 km->    GI;    Q1410;                               Gibraltar;    33140;  36.1;  -5.3
✅         United Kingdom          Isle of Man   54.2,  -4.5 -    3 km->    IM;    Q9676;                             Isle of Man;    85888;  54.2;  -4.5
✅         United Kingdom           Montserrat   16.7, -62.2 -    2 km->    MS;   Q13353;                              Montserrat;     5215;  16.8; -62.2
✅         United Kingdom                        55.4,  -3.4 -    0 km->GB-UKM;     Q145;                          United Kingdom; 65102385;  54.6;  -2.0
✅                Uruguay                       -32.5, -55.8 -   86 km->    UY;      Q77;        

[greg-minshall]

nice. it might be nice if your table in the github page had column names.

[WolfgangFahl]

@greg-minshall thx for the hint - I have added a line

[WolfgangFahl]

see also https://github.com/WolfgangFahl/jhuregionmapper/blob/master/regions.csv