countries.sparql

#defaultView:BubbleChart
SELECT ?country ?countryLabel ?population ?rgb
WHERE
{
  ?country wdt:P31 wd:Q3624078;
           wdt:P1082 ?population.
  MINUS { ?country wdt:P576 ?ceased. }
  # Americas: red; North America: dark red; Central America: crimson; South America: dark orange
  OPTIONAL {
    ?country wdt:P30 wd:Q828.
    BIND("FF0000" AS ?rgb).
  }
  OPTIONAL {
    ?country wdt:P30 wd:Q49.
    BIND("8B0000" AS ?rgb).
  }
  OPTIONAL {
    ?country wdt:P30 wd:Q27611.
    BIND("DC143C" AS ?rgb).
  }
  OPTIONAL {
    ?country wdt:P30 wd:Q18.
    BIND("FF8C00" AS ?rgb).
  }
  # Eurasia: green; Europe: aqua, Asia: lime
  OPTIONAL {
    ?country wdt:P30 wd:Q5401.
    BIND("008000" AS ?rgb).
  }
  OPTIONAL {
    ?country wdt:P30 wd:Q46.
    BIND("00FFFF" AS ?rgb).
  }
  OPTIONAL {
    ?country wdt:P30 wd:Q48.
    BIND("00FF00" AS ?rgb).
  }
  # Africa: purple; Oceania: blue; Australia: dark blue
  OPTIONAL {
    ?country wdt:P30 wd:Q15.
    BIND("800080" AS ?rgb).
  }
  OPTIONAL {
    ?country wdt:P30 wd:Q538.
    BIND("0000FF" AS ?rgb).
  }
  OPTIONAL {
    ?country wdt:P30 wd:Q3960.
    BIND("00008B" AS ?rgb).
  }
  BIND(IF(BOUND(?rgb),?rgb,"000000") AS ?rgb).
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}