Wikidata:WikiProject Sled dog racing/Queries

Home

Properties

Todo

Queries

SPARQL queries :

Mushers

All mushers

The following query uses these:

• Items: human (Q5)   , dogsled musher (Q500097)   

• Properties: instance of (P31)   , occupation (P106)   

  SELECT DISTINCT ?musher ?musherLabel WHERE {
    ?musher wdt:P31 wd:Q5 .
    ?musher wdt:P106 wd:Q500097 .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en" . }
  }
  

Try it!

Gender

All mushers without gender

The following query uses these:

• Items: human (Q5)   , dogsled musher (Q500097)   

• Properties: instance of (P31)   , occupation (P106)   , sex or gender (P21)   

  SELECT DISTINCT ?musher ?musherLabel WHERE {
    ?musher wdt:P31 wd:Q5 .
    ?musher wdt:P106 wd:Q500097 . 
    FILTER NOT EXISTS {
      ?musher wdt:P21 ?genre .
    }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en" . }
  }
  

Try it!

Names

All mushers without a valid given name

The following query uses these:

• Items: human (Q5)   , dogsled musher (Q500097)   , given name (Q202444)   

• Properties: instance of (P31)   , occupation (P106)   , given name (P735)   , subclass of (P279)   

  SELECT DISTINCT ?musher ?musherLabel WHERE {
    ?musher wdt:P31 wd:Q5 .
    ?musher wdt:P106 wd:Q500097 .
    FILTER NOT EXISTS {
      ?musher wdt:P735 ?prenom .
      ?prenom wdt:P31/wdt:P279* wd:Q202444
    }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en" . }
  }
  

Try it!

Mushers with a valid given name (with duplicates)

The following query uses these:

• Items: human (Q5)   , dogsled musher (Q500097)   , given name (Q202444)   

• Properties: instance of (P31)   , occupation (P106)   , given name (P735)   , subclass of (P279)   

  SELECT DISTINCT ?musher ?musherLabel WHERE {
    ?musher wdt:P31 wd:Q5 .
    ?musher wdt:P106 wd:Q500097 .
    ?musher wdt:P735 ?prenom .
    ?prenom wdt:P31/wdt:P279* wd:Q202444 .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en" . }
  }
  

Try it!

Mushers with several given names

The following query uses these:

• Items: human (Q5)   , dogsled musher (Q500097)   , given name (Q202444)   

• Properties: instance of (P31)   , occupation (P106)   , given name (P735)   , subclass of (P279)   

  SELECT DISTINCT ?musher ?musherLabel (COUNT(distinct ?prenom) as ?count_prenom) WHERE {
    ?musher wdt:P31 wd:Q5 .
    ?musher wdt:P106 wd:Q500097 .
    ?musher wdt:P735 ?prenom .
    ?prenom wdt:P31/wdt:P279* wd:Q202444 .
  
    SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en" . }
  
  } GROUP BY ?musher ?musherLabel
  HAVING (?count_prenom >1)
  ORDER BY DESC(?count_prenom)
  

Try it!

Races

All races (?)

The following query uses these:

• Items: sled dog racing (Q1968664)   

• Properties: instance of (P31)   , subclass of (P279)   

  SELECT DISTINCT ?race ?raceLabel WHERE {
    ?race wdt:P31/wdt:P279* wd:Q1968664 .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en" . }
  }
  

Try it!

Sleds

See Wikidata:WikiProject_Sports/reports/equipment/sleds