📊 The census of Wikidata: biggest classes and their parents

SELECT ?class ?name ?instances ?parentName WHERE {
  ?class rete:instanceCount ?instances ;
         rdfs:label ?name ;
         wdt:P279 ?parent . FILTER(lang(?name) = "en")
  ?parent rdfs:label ?parentName . FILTER(lang(?parentNam…
}

Run this query → no server · no download · no account

caviri.github.io/rete

Run this query in the playground → no server, no download — the query runs in your browser.

The query

PREFIX wdt: <http://www.wikidata.org/prop/direct/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rete: <https://w3id.org/rete/> SELECT ?class ?name ?instances ?parentName WHERE { ?class rete:instanceCount ?instances ; rdfs:label ?name ; wdt:P279 ?parent . FILTER(lang(?name) = "en") ?parent rdfs:label ?parentName . FILTER(lang(?parentName) = "en") } ORDER BY DESC(?instances) LIMIT 30

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