query-6e1e1d72b0ee8ac6abc6b9cc216ad68b
| Query: Recent changes | Find images | TABernacle | PetScan | WDQS . Manual changes to the list will be removed on the next update! a botThis list is periodically updated by Manually update list 6.06 1749.0 28835.0 Cuba 13.19 3086.0 23390.0 Republic of the Congo 20.03 5699.0 28444.0 Afghanistan 27.78 5382.0 19372.0 Bhutan 28.14 6582.0 23390.0 Democratic Republic of the Congo 28.92 6112.0 21130.0 Burundi 34.11 8574.0 25132.0 Libya 36.87 10625.0 28815.0 Ethiopia 37.15 8691.0 23390.0 Somalia 38.66 9587.0 24798.0 Sudan 40.59 9758.0 24038.0 Guinea 40.93 11803.0 28835.0 Haiti 43.48 10171.0 23390.0 Madagascar 45.0 10526.0 23390.0 Chad 45.63 9661.0 21172.0 Lesotho 45.99 10758.0 23390.0 Burkina Faso 46.77 10582.0 22625.0 Uganda 47.02 13550.0 28815.0 Panama 48.1 13871.0 28835.0 Ukraine 49.1 11481.0 23382.0 Mali 50.34 12653.0 25132.0 Bulgaria 51.83 12121.0 23382.0 Senegal 52.58 12300.0 23390.0 Togo 52.66 10202.0 19372.0 Qatar 52.86 11980.0 22662.0 Trinidad and Tobago 53.14 12044.0 22662.0 Rwanda 54.71 12579.0 22988.0 Mauritania 56.23 16214.0 28835.0 Iran 56.64 13250.0 23390.0 Gabon 56.67 10140.0 17892.0 Papua New Guinea 61.56 17318.0 28129.0 Pakistan 62.88 18133.0 28835.0 Lebanon 63.69 16009.0 25132.0 Nepal 64.72 15139.0 23390.0 Niger 65.5 18889.0 28835.0 El Salvador 65.75 12020.0 18280.0 Bangladesh 65.91 11809.0 17916.0 São Tomé and Príncipe 67.1 11726.0 17474.0 Angola 68.63 15540.0 22642.0 Algeria 69.32 19359.0 27927.0 Myanmar 69.43 8266.0 11904.0 Kazakhstan 70.85 20390.0 28777.0 Ecuador 72.31 16635.0 23002.0 Syria 72.57 18240.0 25132.0 Jordan 73.15 18385.0 25132.0 Laos 73.33 8619.0 11753.0 Georgia 74.25 12215.0 16451.0 Central African Republic 74.58 18745.0 25132.0 Spain 75.57 15429.0 20415.0 Equatorial Guinea 76.33 13328.0 17460.0 Samoa 77.9 13957.0 17916.0 Mozambique 77.98 15959.0 20464.0 Eswatini 79.73 15904.0 19947.0 Guyana 80.43 18814.0 23390.0 Cameroon 80.55 19976.0 24798.0 Tunisia 81.4 20092.0 24682.0 Ghana 82.07 9440.0 11502.0 North Macedonia 82.65 9977.0 12071.0 North Korea 83.35 24036.0 28835.0 France 84.13 19341.0 22988.0 Mongolia 84.73 13325.0 15725.0 Vanuatu 84.91 10040.0 11823.0 Bosnia and Herzegovina 85.01 21365.0 25132.0 Sri Lanka 85.09 14310.0 16817.0 Solomon Islands 85.26 24587.0 28835.0 Dominican Republic 85.54 16542.0 19338.0 People's Republic of China 85.83 16561.0 19293.0 United Arab Emirates 86.26 19857.0 23018.0 Sierra Leone 86.37 24905.0 28835.0 Paraguay 86.81 10335.0 11904.0 Azerbaijan 87.21 15942.0 18280.0 Grenada 87.92 10466.0 11904.0 Tajikistan 89.77 25888.0 28835.0 Nicaragua 90.05 25968.0 28835.0 Chile 91.6 22715.0 24798.0 Morocco 91.62 18891.0 20617.0 Mauritius 91.66 21425.0 23373.0 Nigeria 92.29 23196.0 25132.0 Albania 92.51 14538.0 15715.0 Belize 92.73 26731.0 28826.0 Liberia 93.87 27042.0 28807.0 Guatemala 94.62 21444.0 22662.0 Jamaica 94.68 20416.0 21563.0 Maldives 94.79 16929.0 17859.0 Comoros 95.39 27108.0 28417.0 Thailand 95.47 23995.0 25132.0 Austria 95.54 22349.0 23390.0 Ivory Coast 95.66 21451.0 22424.0 Kuwait 96.06 15806.0 16453.0 Saint Lucia 96.23 27748.0 28835.0 Poland 96.28 20763.0 21563.0 The Gambia 96.3 11153.0 11581.0 Slovakia 96.35 27765.0 28814.0 Bolivia 97.16 11566.0 11904.0 Kyrgyzstan 97.44 11521.0 11823.0 Slovenia 97.62 28150.0 28835.0 Argentina 97.64 19251.0 19715.0 Fiji 97.72 28172.0 28829.0 India 97.89 20675.0 21119.0 Barbados 97.98 28231.0 28813.0 Venezuela 98.0 28249.0 28823.0 Colombia 98.36 21846.0 22208.0 Kenya 98.38 11712.0 11904.0 Armenia 98.51 28354.0 28781.0 Honduras 98.97 11335.0 11452.0 Monaco 99.05 19207.0 19391.0 Egypt 99.11 22932.0 23137.0 South Africa 99.14 21888.0 22076.0 Tanzania 99.28 11985.0 12071.0 Estonia 99.36 28643.0 28826.0 Costa Rica 99.4 17078.0 17181.0 Vietnam 99.45 8690.0 8738.0 Serbia 99.45 11839.0 11904.0 Moldova 99.45 28677.0 28835.0 Brazil 99.48 9105.0 9152.0 Tonga 99.53 11849.0 11904.0 Turkmenistan 99.61 28666.0 28777.0 Iraq 99.71 12060.0 12094.0 Belarus 99.75 8040.0 8060.0 Switzerland 99.77 25075.0 25132.0 Finland 99.79 25081.0 25132.0 Portugal 99.82 18611.0 18644.0 The Bahamas 99.85 28794.0 28835.0 Turkey 99.85 11956.0 11973.0 Russia 99.87 28793.0 28828.0 Peru 99.87 28735.0 28771.0 Belgium 99.91 12061.0 12071.0 Marshall Islands 99.91 12061.0 12071.0 Latvia 99.91 28419.0 28444.0 Iceland 99.95 28809.0 28821.0 Mexico 99.97 28829.0 28835.0 New Zealand 99.97 12580.0 12583.0 Namibia 99.97 22293.0 22299.0 Malaysia 99.97 28828.0 28835.0 Luxembourg 99.97 28829.0 28835.0 Kingdom of Denmark 99.98 9151.0 9152.0 Nauru 99.98 23387.0 23390.0 Cyprus 99.99 28833.0 28835.0 United Kingdom 99.99 28443.0 28444.0 Sweden 99.99 28580.0 28582.0 Philippines 99.99 19355.0 19356.0 Oman 99.99 28787.0 28788.0 Kingdom of the Netherlands 99.99 24761.0 24762.0 Japan 99.99 25130.0 25132.0 Hungary 99.99 18643.0 18644.0 Germany 99.99 28818.0 28819.0 Canada 99.99 21170.0 21172.0 Botswana 99.99 12635.0 12636.0 Benin 99.99 28825.0 28827.0 Australia 100.0 16111.0 16111.0 Zimbabwe 100.0 11904.0 11904.0 Uzbekistan 100.0 28835.0 28835.0 United States of America 100.0 4831.0 4831.0 South Sudan 100.0 21563.0 21563.0 Singapore 100.0 17545.0 17545.0 Seychelles 100.0 28835.0 28835.0 Saudi Arabia 100.0 16090.0 16089.0 Saint Vincent and the Grenadines 100.0 14988.0 14987.0 Saint Kitts and Nevis 100.0 28801.0 28801.0 Norway 100.0 6673.0 6673.0 Montenegro 100.0 21859.0 21857.0 Malta 100.0 21858.0 21857.0 Malawi 100.0 9152.0 9152.0 Kiribati 100.0 25132.0 25132.0 Ireland 100.0 21191.0 21191.0 Indonesia 100.0 12071.0 12071.0 Federated States of Micronesia 100.0 11452.0 11452.0 Eritrea 100.0 8043.0 8043.0 East Timor 100.0 17181.0 17181.0 Djibouti 100.0 11823.0 11823.0 Croatia 100.0 17916.0 17916.0 Cape Verde 100.0 14623.0 14623.0 Brunei 100.0 19372.0 19372.0 Bahrain 100.0 15668.0 15668.0 Antigua and Barbuda 100.0 11391.0 11391.0 Andorra 100.05 21868.0 21857.0 Zambia 100.27 12104.0 12071.0 Lithuania 100.58 27700.0 27540.0 Israel 100.7 12156.0 12071.0 South Korea 100.93 18003.0 17837.0 Suriname 100.99 11696.0 11581.0 Czech Republic 101.23 16934.0 16727.0 Dominica 101.45 25497.0 25132.0 Italy 101.79 18609.0 18280.0 Guinea-Bissau 102.12 29447.0 28834.0 Greece 102.5 9015.0 8795.0 Tuvalu 105.19 26438.0 25132.0 Cambodia 105.89 26613.0 25132.0 Romania 126.03 15822.0 12554.0 Yemen 199.89 23796.0 11904.0 San Marino Percent Filled Days With Data Days In UN Country End of automatically generated list.The underlying query behind this report is:
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?country ?countryLabel ?daysInUN (SUM(?daysInOffice) AS ?filled) (FLOOR(?filled / ?daysInUN * 10000) / 100 AS ?knownPercent) WHERE {
# Current UN Member States
?country wdt:P31 wd:Q3624078 ; p:P463 ?ms .
?ms ps:P463 wd:Q1065 ; pq:P580 ?joined .
FILTER NOT EXISTS { ?ms pq:P582 [] }
BIND(FLOOR(NOW()-?joined) AS ?daysInUN)
# what office(s) = head of government, and when?
?country p:P1313 ?os .
?os ps:P1313 ?office .
OPTIONAL { ?os pq:P580 ?office580 }
OPTIONAL { ?os pq:P582 ?office582 }
FILTER ( !BOUND(?office582)|| (?office582 > ?joined) )
BIND(IF(BOUND(?office580), IF(?office580 < ?joined, ?joined, ?office580), ?joined) AS ?officeStart)
BIND(IF(BOUND(?office582), ?office582, NOW()) AS ?officeEnd)
# Who has held office in that period?
?person wdt:P31 wd:Q5 ; p:P39 ?ps .
?ps ps:P39 ?office ; pq:P580 ?heldStart .
OPTIONAL { ?ps pq:P582 ?heldEnd }
BIND(IF(BOUND(?heldEnd), ?heldEnd, NOW()) AS ?heldEnd)
BIND(IF(?heldEnd > ?officeEnd, ?officeEnd, ?heldEnd) AS ?hogEnd)
BIND(IF(?heldStart < ?officeStart, ?officeStart, ?heldStart) AS ?hogStart)
FILTER ((?heldStart < ?officeEnd) && (?heldEnd > ?officeStart))
BIND(FLOOR(?hogEnd - ?hogStart) AS ?daysInOffice)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?country ?countryLabel ?daysInUN
ORDER BY DESC(?knownPercent) ?countryLabel