reteplayground
Aggregate

Countries × organization roles

CountryRole class# organizations
United StatesCompany10,043
United StatesNonprofit7,206
United StatesFunder5,987
United StatesEducation4,512
Run this query → no server · no download · no account
caviri.github.io/rete
Run this query in the playground → 40 rows · 700 ms · 512.0 KB of 28.7 MB read over HTTP range · no server, no download — the query runs in your browser.

The query

PREFIX ror: <https://w3id.org/rete/ror#> SELECT ?country ?type (COUNT(?org) AS ?orgs) WHERE { ?org ror:countryName ?country ; a ?type . FILTER(?type != ror:Organization) } GROUP BY ?country ?type ORDER BY DESC(?orgs) LIMIT 40

rete playground · documentation · github.com/caviri/rete