Project:SPARQL/examples

Counts of classes

The following query uses these:

• P1

PREFIX wbt: <http://trex-taxonomy.wiki.opencura.com/prop/direct/>
 
SELECT DISTINCT ?class ?classLabel (COUNT(?class) AS ?counts) WHERE {
   ?item wbt:P1 ?class .
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }     
}
GROUP BY ?class ?classLabel

Try it!

Jeremy's visualization

1. defaultView:Dimensions

PREFIX ps: <http://trex-taxonomy.wiki.opencura.com/prop/statement/> PREFIX p: <http://trex-taxonomy.wiki.opencura.com/prop/> PREFIX pr: <http://trex-taxonomy.wiki.opencura.com/prop/reference/> PREFIX wdt: <http://trex-taxonomy.wiki.opencura.com/prop/direct/> PREFIX wd: <http://trex-taxonomy.wiki.opencura.com/entity/>

SELECT ?taxonLabel ?scientific_nameLabel ?authorityLabel ?doi ?year WHERE {

  ?taxon wdt:P1 wd:Q19 ;
         wdt:P8 ?scientific_name .
  ?specimen wdt:P1 wd:Q24 ;
            p:P8 [
              ps:P8 ?scientific_name ;
              prov:wasDerivedFrom [
                  pr:P31 ?authority ;
              ]
    ] .
   ?authority wdt:P7 ?date ;
              wdt:P19 ?doi .
   bind (str(year(?date)) as ?year)
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }      

} ORDER BY ?year