Bubbles¶

The next query plots a bubble chart. It shows the number of accepted NFDI consortia per city where the main applicant is located.

#defaultView:BubbleChart
SELECT ?cityLabel (count(*) as ?count)
WHERE 
{
  ?item wdt:P31 wd:Q98270496.
  OPTIONAL {?item wdt:P571 ?inception.}
  OPTIONAL {?item wdt:P856 ?url.}
  OPTIONAL {?item wdt:P2002 ?twitter.}
  OPTIONAL {?item wdt:P2037 ?github.}
  OPTIONAL {?item wdt:P2397 ?youtube.}
  OPTIONAL {?item p:P1416 [
                    ps:P1416 ?affiliation;
                    pq:P3831  wd:Q105906729 ] . OPTIONAL {?affiliation wdt:P159 ?city.} }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?cityLabel
ORDER BY DESC(?count) ASC(?item)

Try it!