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

The following query uses these:

• P1
• P19
• P31
• P7
• P8
• Q19
• Q24

#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

Try it!