Wikidata:SPARQL query service/queries/examples

From Wikidata
Jump to: navigation, search
Translate this page;
Other languages:
čeština • ‎Deutsch • ‎English • ‎español • ‎français • ‎italiano • ‎日本語 • ‎русский

This page contains changes. Please contact a translation admin to mark them for translation.


Other languages:
čeština • ‎Deutsch • ‎English • ‎español • ‎français • ‎italiano • ‎日本語 • ‎русский
Warning: Editing this page will change the examples shown on query.wikidata.org


This page is parsed by the web interface of the query service to fill the query example dialog.

Consider adding a comment in the query noting what it illustrates, when and by whom it was written and which are its limitations given the current data and use of properties at Wikidata.

Contents

See also[edit]

Simple Queries[edit]

These basic queries help to understand SPARQL and the Wikibase RDF format.

Cats[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel 
    2 WHERE 
    3 {
    4   ?item wdt:P31 wd:Q146.
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

Goats[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID
    1 SELECT ?item ?itemLabel 
    2 WHERE 
    3 {
    4   ?item wdt:P31 wd:Q2934.
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

Horses[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, mother (P25) View with Reasonator View with SQID, father (P22) View with Reasonator View with SQID, date of birth (P569) View with Reasonator View with SQID, date of death (P570) View with Reasonator View with SQID, sex or gender (P21) View with Reasonator View with SQID
     1 #added before 2016-10
     2 #Illustrates optional fields, instances of subclasses, language fallback on label service, date to year conversion
     3 # Chevaux sur Wikidata
     4 SELECT DISTINCT ?cheval ?chevalLabel ?mere ?pere (year(?naissance) as ?Naissance) (year(?deces) as ?Décès) ?sexeLabel
     5 WHERE
     6 {
     7 	?cheval wdt:P31/wdt:P279* wd:Q726 .     # Instance et sous-classes de Q726-Cheval
     8 	 
     9 	OPTIONAL{?cheval wdt:P25 ?mere .}       # P25  : Mère
    10 	OPTIONAL{?cheval wdt:P22 ?pere .}       # P22  : Père
    11 	OPTIONAL{?cheval wdt:P569 ?naissance .} # P569 : Date de naissance
    12 	OPTIONAL{?cheval wdt:P570 ?deces .}     # P570 : Date de décès
    13 	OPTIONAL{?cheval wdt:P21 ?sexe .}       # P21  : Sexe
    14  
    15 	SERVICE wikibase:label { #BabelRainbow
    16 		bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr,ar,be,bg,bn,ca,cs,da,de,el,en,es,et,fa,fi,he,hi,hu,hy,id,it,ja,jv,ko,nb,nl,eo,pa,pl,pt,ro,ru,sh,sk,sr,sv,sw,te,th,tr,uk,yue,vec,vi,zh"
    17 	}
    18 }
    19 ORDER BY ?cheval
    

Wikidata items with a Wikispecies sitelink[edit]

#added before 2016-10
#illustrates sitelink selection, ";" notation
SELECT ?item ?itemLabel ?article
WHERE
{
	?article 	schema:about ?item ;
			schema:isPartOf <https://species.wikimedia.org/> .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
LIMIT 200

Try it!

Wikidata items about authors with a Wikispecies page[edit]

SELECT ?author ?authorLabel (COUNT(?paper) AS ?count)
WHERE
{
	?article 	schema:about ?author ;
			schema:isPartOf <https://species.wikimedia.org/> .
    ?author wdt:P31 wd:Q5.
    ?paper wdt:P50 ?author.
	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
GROUP BY ?author ?authorLabel
ORDER BY DESC(?count)
LIMIT 200

Try it!

Recent Events[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, point in time (P585) View with Reasonator View with SQID, start time (P580) View with Reasonator View with SQID
     1 SELECT ?event ?eventLabel ?date
     2 WHERE
     3 {
     4 	# find events
     5 	?event wdt:P31/wdt:P279* wd:Q1190554.
     6 	# with a point in time or start date
     7 	OPTIONAL { ?event wdt:P585 ?date. }
     8 	OPTIONAL { ?event wdt:P580 ?date. }
     9 	# but at least one of those
    10 	FILTER(BOUND(?date) && DATATYPE(?date) = xsd:dateTime).
    11 	# not in the future, and not more than 31 days ago
    12 	BIND(NOW() - ?date AS ?distance).
    13 	FILTER(0 <= ?distance && ?distance < 31).
    14 	# and get a label as well
    15 	OPTIONAL {
    16 		?event rdfs:label ?eventLabel.
    17 		FILTER(LANG(?eventLabel) = "en").
    18 	}
    19 }
    20 # limit to 10 results so we don't timeout
    21 LIMIT 10
    

Popular eye colors[edit]

The following query uses these:

Features: BubbleChart (Q24515280) View with Reasonator View with SQID

 1 #added before 2016-10
 2 #illustrates bubblechart view, count
 3 
 4 #defaultView:BubbleChart
 5 SELECT ?eyeColorLabel (COUNT(?person) AS ?count)
 6 WHERE
 7 {
 8 	?person wdt:P1340 ?eyeColor.
 9 	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
10 }
11 GROUP BY ?eyeColorLabel

Even more cats, with pictures[edit]

The following query uses these:

Features: ImageGrid (Q24515278) View with Reasonator View with SQID

 1 #added before 2016-10
 2 
 3 #defaultView:ImageGrid
 4 SELECT ?item ?itemLabel ?pic
 5 WHERE
 6 {
 7 	?item wdt:P31 wd:Q146 .
 8 	OPTIONAL {
 9 		?item wdt:P18 ?pic
10 	}
11 	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
12 }

People whose gender we know we don't know[edit]

The following query uses these:

  • Properties: sex or gender (P21) View with Reasonator View with SQID
    1 #added before 2016-10
    2 #Demonstrates "unknown value" handling
    3 SELECT ?human ?humanLabel
    4 WHERE
    5 {
    6 	?human wdt:P21 ?gender
    7 	FILTER isBLANK(?gender) .
    8 	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
    9 }
    

Humans without children[edit]

In the simplest form:

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID
    1 #added before 2016-10
    2 #Demonstrates "no value" handling
    3 SELECT ?human ?humanLabel
    4 WHERE
    5 {
    6 	?human wdt:P31 wd:Q5 .       #find humans
    7 	?human rdf:type wdno:P40 .   #with at least one P40 (child) statement defined to be "no value"
    8 	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
    9 }
    

An equivalent query (slightly more verbose):

SELECT ?human ?humanLabel 
WHERE
{
  ?human wdt:P31 wd:Q5 .         #find humans
  ?human p:P40 ?childStatement . #with at least one P40 (child) statement
  ?childStatement rdf:type wdno:P40 .   #where the P40 (child) statement is defined to be "no value"
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
}

Try it!

URLs of Wikipedia in all languages[edit]

This query provides an alternative to scraping the Wikipedia.org portal page and various lists/tables of Wikipedias that are out there.

PREFIX schema: <http://schema.org/>

SELECT ?sitelink
WHERE 
{
  BIND(wd:Q52 AS ?wikipedia)
  ?sitelink schema:about ?wikipedia .
  FILTER REGEX(STR(?sitelink), ".wikipedia.org/wiki/") .
}

Try it!

Map of hospitals[edit]

The following query uses these:

Features: Map (Q24515275) View with Reasonator View with SQID

1 #added 2017-08
2 #defaultView:Map
3 SELECT * WHERE {
4   ?item wdt:P31*/wdt:P279* wd:Q16917;
5         wdt:P625 ?geo .
6 }

Showcase Queries[edit]

These queries show the power and functionality of SPARQL and WDQS GUI.

Largest cities with female mayor[edit]

#added before 2016-10
#TEMPLATE={"template":"Largest ?c with ?sex head of government","variables":{"?sex":{"query":" SELECT ?id WHERE { ?id wdt:P31 wd:Q48264 .  } "},"?c":{"query":"SELECT DISTINCT ?id WHERE {  ?c wdt:P31 ?id.  ?c p:P6 ?mayor. }"} } }
SELECT DISTINCT ?city ?cityLabel ?mayor ?mayorLabel
WHERE
{
  BIND(wd:Q6581072 AS ?sex)
  BIND(wd:Q515 AS ?c)

	?city wdt:P31/wdt:P279* ?c .  # find instances of subclasses of city
	?city p:P6 ?statement .            # with a P6 (head of goverment) statement
	?statement ps:P6 ?mayor .          # ... that has the value ?mayor
	?mayor wdt:P21 ?sex .       # ... where the ?mayor has P21 (sex or gender) female
	FILTER NOT EXISTS { ?statement pq:P582 ?x }  # ... but the statement has no P582 (end date) qualifier
	
	# Now select the population value of the ?city
	# (wdt: properties use only statements of "preferred" rank if any, usually meaning "current population")
	?city wdt:P1082 ?population .
	# Optionally, find English labels for city and mayor:
	SERVICE wikibase:label {
		bd:serviceParam wikibase:language "en" .
	}
}
ORDER BY DESC(?population)
LIMIT 10

Try it!

List of countries ordered by the number of their cities with female mayor[edit]

#added before 2016-10
SELECT ?country ?countryLabel (count(*) AS ?count)
WHERE
{
	?city wdt:P31/wdt:P279* wd:Q515 . # find instances of subclasses of city
	?city p:P6 ?statement .           # with a P6 (head of goverment) statement
	?statement ps:P6 ?mayor .         # ... that has the value ?mayor
	?mayor wdt:P21 wd:Q6581072 .      # ... where the ?mayor has P21 (sex or gender) female
	FILTER NOT EXISTS { ?statement pq:P582 ?x }  # ... but the statement has no P582 (end date) qualifier
	?city wdt:P17 ?country .          # Also find the country of the city
 	
	# If available, get the "ru" label of the country, use "en" as fallback:
	SERVICE wikibase:label {
		bd:serviceParam wikibase:language "ru,en" .
	}
}
GROUP BY ?country ?countryLabel
ORDER BY DESC(?count)
LIMIT 100

Try it!

Popular surnames among humans[edit]

#added before 2016-10

#defaultView:BubbleChart
SELECT ?surname ?surnameLabel ?count
WHERE
{
  {
    SELECT ?surname (COUNT(?person) AS ?count) WHERE {
      ?person wdt:P31 wd:Q5.
      ?person wdt:P734 ?surname.
    }
    GROUP BY ?surname
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY DESC(?count)
LIMIT 100

Try it!

Given names with most variations[edit]

#added before 2016-10

SELECT ?name (COUNT(?otherName) AS ?count)
WHERE
{
  ?name wdt:P31 wd:Q202444;
        wdt:P460 ?otherName.
}
GROUP BY ?name
ORDER BY DESC(?count)
LIMIT 10

Try it!

Popular surnames among fictional characters[edit]

#added before 2016-10

#defaultView:BubbleChart
SELECT ?surname ?surnameLabel ?count
WHERE
{
  {
    SELECT ?surname (COUNT(?person) AS ?count) WHERE {
      ?person (wdt:P31/wdt:P279*) wd:Q95074.
      ?person wdt:P734 ?surname.
    }
    GROUP BY ?surname
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY DESC(?count)
LIMIT 100

Try it!

Women with most sitelinks and no image born in 1921 or later[edit]

#added before 2016-10

SELECT ?s ?desc ?linkcount
WHERE
{
  ?s wdt:P31 wd:Q5 .
  ?s wdt:P21 wd:Q6581072 .
  ?s wdt:P569 ?born .
  FILTER (?born >= "1921-01-01T00:00:00Z"^^xsd:dateTime) .
  ?s wikibase:sitelinks ?linkcount .
  OPTIONAL {
    ?s wdt:P18 ?dummy
  }
  FILTER ( !bound(?dummy) ) .
  OPTIONAL {
     ?s rdfs:label ?desc filter (lang(?desc) = "en").
   }
}
GROUP BY ?s ?desc ?linkcount
ORDER BY DESC(?linkcount)
LIMIT 50

Try it!

Bubble charts[edit]

Overall causes of death ranking[edit]

#added before 2016-10

#defaultView:BubbleChart
#TEMPLATE={"template":"Overall causes of death ranking of ?thing ","variables":{"?thing": {"query":"SELECT ?id  (COUNT(?id) AS ?count) WHERE {  ?sub wdt:P509 ?y.  ?sub wdt:P31 ?id. } GROUP BY ?id "} } }
SELECT ?cid ?cause (COUNT(*) AS ?count) WHERE {
  BIND(wd:Q5 AS ?thing)
  ?pid wdt:P31 ?thing.
  ?pid wdt:P509 ?cid.
  OPTIONAL {
    ?cid rdfs:label ?cause.
    FILTER((LANG(?cause)) = "en")
  }
}
GROUP BY ?cid ?cause
ORDER BY DESC(?count) ?cause

Try it!

WWII battle durations[edit]

#added before 2016-10

#defaultView:BubbleChart
SELECT DISTINCT ?item ?itemLabel (?end - ?start AS ?duration)
WHERE
{
	?item wdt:P361* wd:Q362 .
	?item wdt:P31/wdt:P279* wd:Q178561 .
	?item wdt:P580 ?start .
	?item wdt:P582 ?end .

	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}

Try it!

The top 10 heaviest humans[edit]

The following query uses these:

Features: BubbleChart (Q24515280) View with Reasonator View with SQID

 1 #defaultView:BubbleChart
 2 #TEMPLATE={ "template": "The top 10 heaviest ?type ", "variables": { "?type": { "query": "SELECT DISTINCT ?id WHERE { ?i wdt:P2067 ?v. ?i wdt:P31 ?id}" } } }
 3 SELECT ?item ?itemLabel ?mass ?image WHERE {
 4   BIND(wd:Q5 AS ?type)
 5   ?item wdt:P31 ?type;
 6         p:P2067/psn:P2067/wikibase:quantityAmount ?mass.
 7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,es,fr,de" }
 8 }
 9 ORDER BY DESC(?mass)
10 LIMIT 10

Timeline[edit]

Timeline of space probes[edit]

#defaultView:Timeline
SELECT ?item ?itemLabel ?launchdate (SAMPLE(?image) AS ?image)
WHERE
{
	?item wdt:P31 wd:Q26529 .
    ?item wdt:P619 ?launchdate .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
    OPTIONAL { ?item wdt:P18 ?image }
}
GROUP BY ?item ?itemLabel ?launchdate

Try it!

Timeline of compositions by Wolfgang Amadeus Mozart[edit]

#defaultView:Timeline
SELECT DISTINCT  ?item ?itemLabel ?catalog_code ?publication_data
WHERE
{
	?item wdt:P86 wd:Q254 ;
          wdt:P528 ?catolog_code ;
          wdt:P577 ?publication_data .
   
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}

Try it!

Dimensions[edit]

Dimensions of elements[edit]

#defaultView:Dimensions
SELECT ?elementLabel ?_boiling_point ?_melting_point ?_electronegativity ?_density ?_mass WHERE {
  ?element wdt:P31 wd:Q11344;
   wdt:P2102 ?_boiling_point;
   wdt:P2101 ?_melting_point;
   wdt:P1108 ?_electronegativity;
   wdt:P2054 ?_density;
   wdt:P2067 ?_mass.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
LIMIT 100

Try it!

Graph[edit]

Children of Genghis Khan[edit]

#added before 2016-10
 #defaultView:Graph
PREFIX gas: <http://www.bigdata.com/rdf/gas#>

SELECT ?item ?itemLabel ?pic ?linkTo
WHERE
{
  SERVICE gas:service {
    gas:program gas:gasClass "com.bigdata.rdf.graph.analytics.SSSP" ;
                gas:in wd:Q720 ;
                gas:traversalDirection "Forward" ;
                gas:out ?item ;
                gas:out1 ?depth ;
                gas:maxIterations 4 ;
                gas:linkType wdt:P40 .
  }
  OPTIONAL { ?item wdt:P40 ?linkTo }
  OPTIONAL { ?item wdt:P18 ?pic }
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}

Try it!

Firearms cartridges and which they are based on[edit]

The following query uses these:

Features: Graph (Q24515287) View with Reasonator View with SQID

 1 #Show firearms cartridges and which they are based on
 2 #defaultView:Graph
 3 SELECT 
 4 ?item ?itemLabel ?image 
 5 ?other ?otherLabel ?image2
 6 WHERE
 7 {
 8     ?item  wdt:P279+ wd:Q37144 .   # cartridges
 9     ?item  wdt:P144    ?other  .   # if the cartridge is based on another
10     OPTIONAL {
11       ?item  wdt:P18     ?image  .   # grab image
12       ?other wdt:P18     ?image2 .   # grab image
13     }
14     SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
15 }

Music genres[edit]

#more than 1000 results, could be slow

#defaultView:Graph
SELECT ?item ?itemLabel ?_image ?_subclass_of ?_subclass_ofLabel
WHERE
{
  ?item wdt:P31 wd:Q188451.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  OPTIONAL { ?item wdt:P279 ?_subclass_of. }
  OPTIONAL { ?item wdt:P18 ?_image. }
}

Try it!

Line chart[edit]

Average number of children per year[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, number of children (P1971) View with Reasonator View with SQID, date of birth (P569) View with Reasonator View with SQID
     1 #defaultView:LineChart
     2 SELECT  (str(?year) AS ?year) (AVG( ?_number_of_children ) AS ?count) WHERE {
     3   ?item wdt:P31 wd:Q5.
     4   ?item wdt:P1971 ?_number_of_children.
     5   ?item wdt:P569 ?_date_of_birth.
     6   BIND( year(?_date_of_birth) as ?year ).
     7   FILTER( ?year > 1900)
     8 }
     9 
    10 GROUP BY ?year
    

Population of countries sharing a border with Germany[edit]

The following query uses these:

  • Properties: shares border with (P47) View with Reasonator View with SQID, population (P1082) View with Reasonator View with SQID, point in time (P585) View with Reasonator View with SQID
     1 #defaultView:LineChart
     2 SELECT ?country  ?year ?population ?countryLabel WHERE {
     3   {
     4     SELECT ?country ?year (AVG(?population) AS ?population) WHERE {
     5       {
     6         SELECT ?country (str(YEAR(?date)) AS ?year) ?population WHERE {
     7           ?country wdt:P47 wd:Q183.
     8           ?country p:P1082 ?populationStatement.
     9           ?populationStatement ps:P1082 ?population.
    10           ?populationStatement pq:P585 ?date.
    11         }
    12       }
    13     }
    14     GROUP BY ?country ?year
    15   }
    16   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
    17 }
    

Population of countries sharing a border with Cameroon[edit]

The following query uses these:

  • Properties: shares border with (P47) View with Reasonator View with SQID, population (P1082) View with Reasonator View with SQID, point in time (P585) View with Reasonator View with SQID
     1 #defaultView:LineChart
     2 SELECT ?country  ?year ?population ?countryLabel WHERE {
     3   {
     4     SELECT ?country ?year (AVG(?population) AS ?population) WHERE {
     5       {
     6         SELECT ?country (str(YEAR(?date)) AS ?year) ?population WHERE {
     7           ?country wdt:P47 wd:Q1009.
     8           ?country p:P1082 ?populationStatement.
     9           ?populationStatement ps:P1082 ?population.
    10           ?populationStatement pq:P585 ?date.
    11         }
    12       }
    13     }
    14     GROUP BY ?country ?year
    15   }
    16   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
    17 }
    

List of all the lakes in Cameroon[edit]

The following query uses these:

Features: Map (Q24515275) View with Reasonator View with SQID

1 #defaultView:Map
2 SELECT ?itemLabel ?itemDescription ?image ?coord WHERE {
3   ?item (wdt:P31/wdt:P279*) wd:Q23397.
4   ?item wdt:P17 wd:Q1009.
5   ?item wdt:P625 ?coord.
6   OPTIONAL {?item wdt:P18 ?image.}
7   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
8 }

Number of books by year and genre[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, publication date (P577) View with Reasonator View with SQID, genre (P136) View with Reasonator View with SQID
     1 #defaultView:LineChart
     2 SELECT ?year (COUNT(?_genre) AS ?count ) (SAMPLE(?_genreLabel) AS ?_genreLabel )  WHERE {
     3   ?item wdt:P31 wd:Q571.
     4   ?item wdt:P577 ?_publication_date.
     5   ?item wdt:P136 ?_genre.
     6   ?_genre rdfs:label ?_genreLabel.
     7   BIND(str(YEAR(?_publication_date)) AS ?year)
     8   FILTER((LANG(?_genreLabel)) = "en")
     9  
    10  FILTER (?_publication_date >= "2000-00-00T00:00:00Z"^^xsd:dateTime)
    11 }
    12 GROUP BY ?_genreLabel ?year
    13 HAVING (?count > 10)
    

Number of bands by year and genre[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, inception (P571) View with Reasonator View with SQID, genre (P136) View with Reasonator View with SQID
     1 #defaultView:LineChart
     2 SELECT ?year (COUNT(?_genre) AS ?count)  (SAMPLE(?_genreLabel) AS ?_genreLabel)  WHERE {
     3   ?item wdt:P31 wd:Q215380.
     4   ?item wdt:P571 ?_date.
     5   ?item wdt:P136 ?_genre.
     6   ?_genre rdfs:label ?_genreLabel.
     7   BIND(str(YEAR(?_date)) AS ?year)
     8   FILTER((LANG(?_genreLabel)) = "en")
     9   FILTER(?_date >= "1960-00-00T00:00:00Z"^^xsd:dateTime)
    10 }
    11 GROUP BY ?_genreLabel ?year
    12 HAVING (?count > 10)
    

Bar chart[edit]

Battles per year per country last 80 years[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, start time (P580) View with Reasonator View with SQID, point in time (P585) View with Reasonator View with SQID, end time (P582) View with Reasonator View with SQID, location (P276) View with Reasonator View with SQID, country (P17) View with Reasonator View with SQID
     1 #defaultView:BarChart
     2 
     3 SELECT(SAMPLE(?year) AS ?year) (COUNT(?_country) AS ?battles)  (SAMPLE(?_countryLabel) AS ?_countryLabel)  WHERE {
     4   ?subj wdt:P31 wd:Q178561.
     5   OPTIONAL { ?subj wdt:P580 ?d1. }
     6   OPTIONAL { ?subj wdt:P585 ?d2. }
     7   OPTIONAL { ?subj wdt:P582 ?d3. }
     8   BIND(IF(!BOUND(?d1), IF(!BOUND(?d2), ?d3, ?d2), ?d1) AS ?date)
     9   BIND(str(YEAR(?date)) AS ?year)
    10   ?subj wdt:P276 ?_loc.
    11   ?_loc wdt:P17 ?_country.
    12   ?_country rdfs:label ?_countryLabel.
    13   BIND((NOW()) - ?date AS ?distance)
    14   FILTER(BOUND(?year))
    15   FILTER((LANG(?_countryLabel)) = "en")
    16   FILTER((0 <= ?distance) && (?distance < 31 * 12 * 80))
    17 }
    18 GROUP BY ?year ?_country
    19 ORDER BY ?_countryLabel
    

Battles per year per continent and country last 80 years (animated)[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, start time (P580) View with Reasonator View with SQID, point in time (P585) View with Reasonator View with SQID, end time (P582) View with Reasonator View with SQID, location (P276) View with Reasonator View with SQID, country (P17) View with Reasonator View with SQID, continent (P30) View with Reasonator View with SQID
     1 #defaultView:BarChart
     2 SELECT (SAMPLE(?_continentLabel) AS ?contient) (COUNT(?_country) AS ?battles) (SAMPLE(?_countryLabel) AS ?_countryLabel) (SAMPLE(?year) AS ?year)  WHERE {
     3   ?subj wdt:P31 wd:Q178561.
     4   OPTIONAL { ?subj wdt:P580 ?d1. }
     5   OPTIONAL { ?subj wdt:P585 ?d2. }
     6   OPTIONAL { ?subj wdt:P582 ?d3. }
     7   BIND(IF(!BOUND(?d1), IF(!BOUND(?d2), ?d3, ?d2), ?d1) AS ?date)
     8   BIND(str(YEAR(?date)) AS ?year)
     9   ?subj wdt:P276 ?_loc.
    10   ?_loc wdt:P17 ?_country.
    11   ?_country wdt:P30 ?_continent.
    12   ?_country rdfs:label ?_countryLabel.
    13   ?_continent rdfs:label ?_continentLabel.
    14  
    15   BIND((NOW()) - ?date AS ?distance)
    16   FILTER(BOUND(?year))
    17   FILTER((LANG(?_countryLabel)) = "en")
    18   FILTER((LANG(?_continentLabel)) = "en")
    19   FILTER((0 <= ?distance) && (?distance < 31 * 12 * 80))
    20 }
    21 GROUP BY ?year ?_country
    22 ORDER BY ?_countryLabel
    

Yearly Population stacked by country[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, population (P1082) View with Reasonator View with SQID, point in time (P585) View with Reasonator View with SQID, determination method (P459) View with Reasonator View with SQID
     1 #defaultView:BarChart
     2 # male/female population _must_ not be added unqualified as total population (!)
     3 # this is an error and should be fixed at the item using P1540 and P1539 instead
     4 # (wrong query result may be a manifestation of such)
     5 SELECT ?year (AVG(?pop) AS ?population) ?countryLabel
     6        (COUNT(*) AS ?number_of_chosen_sources) (SAMPLE(?method) AS ?a_source_of_those_chosen)
     7 WHERE
     8 {
     9   ?country wdt:P31 wd:Q6256;
    10            p:P1082 ?popStatement .
    11   ?popStatement ps:P1082 ?pop;
    12                 pq:P585 ?date .
    13   BIND(STR(YEAR(?date)) AS ?year)
    14   
    15   # IF multiple ?pop values per country per year exist, we prioritize by source
    16   #       census 1st, others 2nd, estimation(s) 3rd, unknown sources (none supplies P459) last
    17   # note: wikibase:rank won't help here: each year may have multiple statements for ?pop value
    18   #       rank:prefered is used for the best value (or values) of the latest or current year
    19   #       rank:normal may be justified for all of multiple ?pop values for a given year
    20   OPTIONAL { ?popStatement pq:P459 ?method. }
    21   OPTIONAL { ?country p:P1082 [ pq:P585 ?d; pq:P459 ?estimate ].
    22              FILTER(STR(YEAR(?d)) = ?year). FILTER(?estimate = wd:Q791801). }
    23   OPTIONAL { ?country p:P1082 [ pq:P585 ?e; pq:P459 ?census ].
    24              FILTER(STR(YEAR(?e)) = ?year). FILTER(?census = wd:Q39825). }
    25   OPTIONAL { ?country p:P1082 [ pq:P585 ?f; pq:P459 ?other ].
    26              FILTER(STR(YEAR(?f)) = ?year). FILTER(?other != wd:Q39825 && ?other != wd:Q791801). }
    27   BIND(COALESCE( 
    28     IF(BOUND(?census), ?census, 1/0),
    29     IF(BOUND(?other), ?other, 1/0),
    30     IF(BOUND(?estimate), ?estimate, 1/0) ) AS ?pref_method).
    31   FILTER(IF(BOUND(?pref_method),?method = ?pref_method,true))
    32   # .. still need to group if multiple values per country per year exist and
    33   # - none is qualified with P459
    34   # - multiple ?estimate or multiple ?census (>1 value from same source)
    35   # - ?other yields more than one source (>1 values are better than optionally
    36   #                         supplied estimate, but no census source available)
    37 
    38   SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }               
    39 }
    40 GROUP BY ?year ?countryLabel
    41 ORDER BY ?year ?countryLabel
    

Built power plants per year per country[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, inception (P571) View with Reasonator View with SQID, country (P17) View with Reasonator View with SQID
     1 #defaultView:BarChart
     2 SELECT DISTINCT  (SAMPLE(?year) AS ?year) (COUNT(?_country) AS ?count) (SAMPLE(?_countryLabel) AS ?_countryLabel) WHERE {
     3   ?object (wdt:P31/wdt:P279*) wd:Q134447.
     4   BIND(str(YEAR(?_inception)) AS ?year)
     5   ?object wdt:P571 ?_inception.
     6   ?object wdt:P17 ?_country.
     7   ?_country rdfs:label ?_countryLabel.
     8   FILTER((LANG(?_countryLabel)) = "en")
     9 }
    10 GROUP BY ?year ?_country
    11 ORDER BY ?_countryLabel
    

Area chart[edit]

Cancer deaths per year and cancer type[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, cause of death (P509) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, date of death (P570) View with Reasonator View with SQID
     1 #defaultView:AreaChart
     2 SELECT ?cid (str(SAMPLE(?year)) AS ?year )  (COUNT(*) AS ?count)  ?cause WHERE {
     3   ?pid wdt:P31 wd:Q5.
     4   ?pid wdt:P509 ?cid.
     5   ?cid wdt:P279* wd:Q12078.
     6  
     7   OPTIONAL {
     8     ?cid rdfs:label ?cause.
     9     FILTER((LANG(?cause)) = "en")
    10   }
    11    ?pid wdt:P570 ?_date_of_death.
    12   BIND ( YEAR(?_date_of_death) AS ?year )
    13   FILTER( BOUND(?cause)  )
    14   FILTER( BOUND(?year)  )
    15   FILTER( ?year > 1960 )
    16 }
    17 GROUP BY ?cid ?cause ?year
    

Tree[edit]

Continents, countries, regions and capitals[edit]

The following query uses these:

Viennese composers and their compositions by tonality[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, place of birth (P19) View with Reasonator View with SQID, place of death (P20) View with Reasonator View with SQID, residence (P551) View with Reasonator View with SQID, image (P18) View with Reasonator View with SQID, composer (P86) View with Reasonator View with SQID, tonality (P826) View with Reasonator View with SQID
     1 #defaultView:Tree
     2 SELECT ?composer ?composerLabel ?composerImage ?tonality ?tonalityLabel ?composition ?compositionLabel WHERE {
     3   ?composer wdt:P31 wd:Q5;
     4             wdt:P19|wdt:P20|wdt:P551 wd:Q1741.
     5   OPTIONAL { ?composer wdt:P18 ?composerImage. }
     6   ?composition wdt:P86 ?composer;
     7                wdt:P826 ?tonality.
     8   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],de-at,de". }
     9 }
    10 ORDER BY ?composerLabel ?tonalityLabel
    

Treemap[edit]

Popular television series (in treeview)[edit]

#added before 2016-10

#defaultView:TreeMap
SELECT ?show ?showLabel  ?season ?cleanSeasonLabel ?episode ?episodeLabel
WHERE
{
	{
		BIND(wd:Q886 as ?show) .
		?season wdt:P361 ?show .
		?season rdfs:label ?_seasonLabel.
		FILTER((LANG(?_seasonLabel)) = "en")
		BIND(SUBSTR(?_seasonLabel, 0, STRLEN(?_seasonLabel)-23) AS ?cleanSeasonLabel)
		?episode wdt:P361 ?season .
	} 
	UNION
	{
		BIND(wd:Q16538 as ?show) .
		?season wdt:P361 ?show .
		?season rdfs:label ?_seasonLabel.
		FILTER((LANG(?_seasonLabel)) = "en")
		BIND(SUBSTR(?_seasonLabel, 0, STRLEN(?_seasonLabel)-20) AS ?cleanSeasonLabel)
		?episode wdt:P361 ?season .
	}  
	UNION
	{
		BIND(wd:Q147235 as ?show) .
		?season wdt:P361 ?show .
		?season rdfs:label ?_seasonLabel.
		FILTER((LANG(?_seasonLabel)) = "en")
		BIND(CONCAT("S", SUBSTR(?_seasonLabel, 25)) AS ?cleanSeasonLabel)
		?episode wdt:P361 ?season .
	}

	SERVICE wikibase:label {  bd:serviceParam wikibase:language "en" }
}

Try it!

Famous people in categorised into eye and hair color[edit]

#defaultView:TreeMap
SELECT ?eyes ?hairColorLabel (COUNT(?person) as ?count)
WHERE
{
	?person wdt:P1340 ?eyeColor.
    ?person wdt:P1884 ?hairColor.
    ?person wdt:P2048 ?height.
    ?eyeColor rdfs:label ?_eyeColorLabel.
    FILTER((LANG(?_eyeColorLabel)) = "en")
    BIND(CONCAT(?_eyeColorLabel, " eyes") AS ?eyes)
   
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
GROUP BY ?eyes ?hairColorLabel

Try it!

Scatter chart[edit]

Number of films by year and genre[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, publication date (P577) View with Reasonator View with SQID, genre (P136) View with Reasonator View with SQID
     1 #defaultView:ScatterChart
     2 SELECT   ?year  (COUNT(?_genre) AS ?count ) (SAMPLE(?_genreLabel) AS ?label )  (?year as ?year_shown) WHERE {
     3   ?item wdt:P31 wd:Q11424.
     4   ?item wdt:P577 ?_publication_date.
     5   ?item wdt:P136 ?_genre.
     6   ?_genre rdfs:label ?_genreLabel.
     7   BIND(str(YEAR(?_publication_date)) AS ?year)
     8   FILTER((LANG(?_genreLabel)) = "en")
     9  
    10  FILTER (?_publication_date >= "2000-00-00T00:00:00Z"^^xsd:dateTime)
    11 }
    12 GROUP BY ?_genreLabel ?year
    13 HAVING (?count > 30)
    

Airports within 100km of Berlin[edit]

#added before 2016-10

#defaultView:Map
SELECT ?place ?placeLabel ?location
WHERE
{
  # Berlin coordinates
  wd:Q64 wdt:P625 ?berlinLoc .
  SERVICE wikibase:around {
    ?place wdt:P625 ?location .
    bd:serviceParam wikibase:center ?berlinLoc .
    bd:serviceParam wikibase:radius "100" .
  } .
  # Is an airport
  FILTER EXISTS { ?place wdt:P31/wdt:P279* wd:Q1248784 } .
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
  } .
}

Try it!

Airports in Belgium[edit]

#added before 2016-10

#List of airports in Belgium
#defaultView:Map
SELECT DISTINCT ?airport ?coor ?range
WHERE
{
  ?airport wdt:P31 wd:Q1248784 ;
  ?range wd:Q31;
  wdt:P625 ?coor.
}

Try it!

Schools between San Jose, CA and Sacramento, CA[edit]

The following query uses these:

Features: Map (Q24515275) View with Reasonator View with SQID, wikibase:box (Q26211169) View with Reasonator View with SQID, wikibase:box with West and East corners (Q26211177) View with Reasonator View with SQID

 1 #added before 2016-10
 2  # Schools between San Jose, CA and Sacramento, CA
 3 #defaultView:Map
 4 SELECT *
 5 WHERE
 6 {
 7   wd:Q16553 wdt:P625 ?SJloc .
 8   wd:Q18013 wdt:P625 ?SCloc .
 9   SERVICE wikibase:box {
10       ?place wdt:P625 ?location .
11       bd:serviceParam wikibase:cornerWest ?SJloc .
12       bd:serviceParam wikibase:cornerEast ?SCloc .
13     }
14   ?place wdt:P31/wdt:P279* wd:Q3914 .
15 }

Whose birthday is today?[edit]

#Whose birthday is today?
SELECT ?entityLabel (YEAR(?date) as ?year)
WHERE
{
    BIND(MONTH(NOW()) AS ?nowMonth)
    BIND(DAY(NOW()) AS ?nowDay)

    ?entity wdt:P569 ?date .
    FILTER (MONTH(?date) = ?nowMonth && DAY(?date) = ?nowDay)
    SERVICE wikibase:label {
        bd:serviceParam wikibase:language "en" .
    }
}
LIMIT 10

Try it!

Finding John and Sarah Connor[edit]

#added before 2016-10
 SELECT * WHERE {
  ?p wdt:P1080 wd:Q620588 .
  ?p rdfs:label ?pl .
  FILTER (lang(?pl) = "en")
  ?p wdt:P25 ?m .
  ?m rdfs:label ?ml .
  FILTER (lang(?ml) = "en")
}

Try it!

Data of Douglas Adams[edit]

#added before 2016-10

PREFIX entity: <http://www.wikidata.org/entity/>
#partial results

SELECT ?propUrl ?propLabel ?valUrl ?valLabel ?picture
WHERE
{
	hint:Query hint:optimizer 'None' .
	{	BIND(entity:Q42 AS ?valUrl) .
		BIND("N/A" AS ?propUrl ) .
		BIND("identity"@en AS ?propLabel ) .
	}
	UNION
	{	entity:Q42 ?propUrl ?valUrl .
		?property ?ref ?propUrl .
		?property rdf:type wikibase:Property .
		?property rdfs:label ?propLabel
	}
	
  	?valUrl rdfs:label ?valLabel
	FILTER (LANG(?valLabel) = 'en') .
	OPTIONAL{ ?valUrl wdt:P18 ?picture .}
	FILTER (lang(?propLabel) = 'en' )
}
ORDER BY ?propUrl ?valUrl
LIMIT 200

Try it!

Samples with coordinates to illustrate maps[edit]

Locations of national parks[edit]

#defaultView:Map

SELECT ?objectLabel ?objectDescription ?link ?coord
WHERE {
  ?object wdt:P31/wdt:P279? wd:Q46169 ;
          wdt:P856 ?link ;
          wdt:P625 ?coord .

          SERVICE wikibase:label {
               bd:serviceParam wikibase:language "en,fr"
          }
}

Try it!

Big cities, grouped into map layers by population[edit]

#defaultView:Map
SELECT DISTINCT ?city ?cityLabel (SAMPLE(?location) AS ?location) (MAX(?population) AS ?population) (SAMPLE(?layer) AS ?layer)
WHERE
{
  ?city wdt:P31/wdt:P279* wd:Q515;
        wdt:P625 ?location;
        wdt:P1082 ?population.
  FILTER(?population >= 500000).
  BIND(
    IF(?population < 1000000, "<1M",
    IF(?population < 2000000, "1M-2M",
    IF(?population < 5000000, "2M-5M",
    IF(?population < 10000000, "5M-10M",
    IF(?population < 20000000, "10M-20M",
    ">20M")))))
    AS ?layer).
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
GROUP BY ?city ?cityLabel

Try it!

Places with free wifi[edit]

#added before 2016-10

# Places with free wi-fi
SELECT ?item ?itemLabel ?coord
WHERE
{
	?item wdt:P2848 wd:Q1543615 ;
	      wdt:P625 ?coord .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}

Try it!

Map of U1 subway stations in Berlin[edit]

#added before 2016-10
#defaultView:Map
SELECT ?stationLabel ?coord
WHERE {
	?station wdt:P81 wd:Q99691 ;
		 wdt:P625 ?coord .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" }
}

Try it!

Locations of universities in Germany[edit]

#added before 2016-10
#defaultView:Map
SELECT ?universityLabel ?universityDescription ?website ?coord
WHERE {
	?university wdt:P31/wdt:P279* wd:Q3918 ;
		wdt:P17 wd:Q183 ;
		wdt:P625 ?coord .
	OPTIONAL {
		?university wdt:P856 ?website
	}
	SERVICE wikibase:label {
		bd:serviceParam wikibase:language "en,de" .
	}
}

Try it!

Locations of universities in Cameroon[edit]

#added before 2016-10
#defaultView:Map
SELECT ?universityLabel ?universityDescription ?website ?coord
WHERE {
	?university wdt:P31/wdt:P279* wd:Q3918 ;
		wdt:P17 wd:Q1009 ;
		wdt:P625 ?coord .
	OPTIONAL {
		?university wdt:P856 ?website
	}
	SERVICE wikibase:label {
		bd:serviceParam wikibase:language "en,de" .
	}
}

Try it!

Distribution of names of human settlements ending in "-ow" or "-itz" in Germany[edit]

#added before 2016-10
 #defaultView:Map
SELECT ?item ?itemLabel ?coord
WHERE
{
	?item wdt:P31/wdt:P279* wd:Q486972;
    	      wdt:P17 wd:Q183;
    	      rdfs:label ?itemLabel;
    	      wdt:P625 ?coord;
    	 FILTER (lang(?itemLabel) = "de") .
    	 FILTER regex (?itemLabel, "(ow|itz)$").
}

Try it!

Locations of power stations[edit]

#defaultView:Map
SELECT DISTINCT ?objectLabel ?coord ?layer
WHERE
{
  ?object wdt:P31/wdt:P279* wd:Q159719;
     wdt:P625 ?coord.
  ?object wdt:P31 ?type. ?type wdt:P279* wd:Q159719.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?type rdfs:label ?layer }
}

Try it!

Locations of stone arch bridges[edit]

#added before 2016-10
#defaultView:Map
SELECT ?label ?coord ?place ?image
WHERE
{
	?subj wdt:P31 wd:Q14276458 .
	?subj wdt:P186 wd:Q22731 .
	?subj wdt:P625 ?coord .
	OPTIONAL { ?subj wdt:P18 ?image }
	?subj rdfs:label ?label filter (lang(?label) = "en")
}

Try it!

Locations of aqueducts[edit]

#added before 2016-10
#defaultView:Map
SELECT ?label ?coord ?place
WHERE
{
   ?subj wdt:P31 wd:Q474 .
   ?subj wdt:P625 ?coord .
   ?subj rdfs:label ?label filter (lang(?label) = "en")
}

Try it!

Locations of archaelogical sites[edit]

#added before 2016-10
#defaultView:Map
SELECT ?label ?coord ?subj
WHERE
{
   ?subj wdt:P31/wdt:P279* wd:Q839954 ;
      wdt:P625 ?coord ;
      rdfs:label ?label filter (lang(?label) = "en")
}

Try it!

Locations of castles that are also archaeological sites[edit]

#added before 2016-10
#defaultView:Map
SELECT ?label ?coord ?subj
WHERE
{
   ?subj wdt:P31 wd:Q839954 .
   ?subj wdt:P31 wd:Q23413 .
   ?subj wdt:P625 ?coord .
   ?subj rdfs:label ?label filter (lang(?label) = "en")
}

Try it!

Locations of battles[edit]

#added before 2016-10
#defaultView:Map
SELECT ?label ?coord ?subj ?year
WHERE
{
	?subj wdt:P31 wd:Q178561 .
	?subj wdt:P625 ?coord .
	OPTIONAL {?subj wdt:P580 ?d1}
	OPTIONAL {?subj wdt:P585 ?d2}
  	OPTIONAL {?subj wdt:P582 ?d3}
	BIND(IF(!BOUND(?d1),(IF(!BOUND(?d2),?d3,?d2)),?d1) as ?date)
	BIND(YEAR(?date) as ?year)
	?subj rdfs:label ?label filter (lang(?label) = "en")
}

Try it!

All museums (including subclass of museum) in Washington, D.C. with coordinates[edit]

#added before 2016-10
#defaultView:Map
SELECT DISTINCT ?item ?name ?coord ?lat ?lon
WHERE {
   ?item wdt:P131* wd:Q61 .
   ?item wdt:P31/wdt:P279* wd:Q33506 .
   ?item wdt:P625 ?coord .
   ?item p:P625 ?coordinate .
   ?coordinate psv:P625 ?coordinate_node .
   ?coordinate_node wikibase:geoLatitude ?lat .
   ?coordinate_node wikibase:geoLongitude ?lon .
   SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
    ?item rdfs:label ?name
   }
}
ORDER BY ASC (?name)

Try it!

All ski resorts with coordinates[edit]

#defaultView:Map
SELECT ?item ?itemLabel ?coord #?lat ?lon
WHERE
{
   ?item               wdt:P31        wd:Q130003.
   ?item               wdt:P625         ?coord.

#  ?item                 p:P625         ?statementnode.
#  ?statementnode      psv:P625         ?valuenode.
#  ?valuenode     wikibase:geoLatitude  ?lat.
#  ?valuenode     wikibase:geoLongitude ?lon.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

Lighthouses in Norway[edit]

#added before 2016-10
#defaultView:Map
SELECT DISTINCT ?item ?itemLabel ?coor ?image
WHERE
{
	?item wdt:P31 wd:Q39715 .
	?item wdt:P17 wd:Q20 .
	OPTIONAL { ?item wdt:P625 ?coor }
	OPTIONAL { ?item wdt:P18 ?image } 
	SERVICE wikibase:label { bd:serviceParam wikibase:language "nb,nn,en,fi"  } 
}
ORDER BY ?itemLabel

Try it!

Most beautiful villages of France[edit]

#defaultView:Map
SELECT ?item ?itemLabel ?geoLoc ?image
WHERE
{
    ?item wdt:P463 wd:Q1010307 .  
    ?item wdt:P625 ?geoLoc .
    OPTIONAL { ?item wdt:P18 ?image . }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}

Try it!

Locations in Fiji[edit]

This query shows a way of mapping locations which span the 180th meridian, without the points being split between the left and right edges of the map.

#defaultView:Map
select ?item ?coords_ where {
  ?item wdt:P17 wd:Q712 .
  ?item p:P625/psv:P625 ?coords .
  ?coords wikibase:geoLatitude ?lat ;
          wikibase:geoLongitude ?lon .
  bind(strdt(concat("Point(", if((?lon < 0), str(?lon + 360), str(?lon)), " ", str(?lat), ")"), geo:wktLiteral) as ?coords_) .
}

Try it!

Listeria[edit]

Samples suitable for Listeria. Generally only include ?item as output. Listeria will add more information from that item. Additional variables from the query could also be used in the lists.

Women born in Wales without an article in Welsh for Listeria[edit]

#added before 2016-10
 #sample from cywiki:Wicipedia:Merched_a_anwyd_yng_Nghymru
SELECT ?item
WHERE
{
	# gender = female
  	?item wdt:P21 wd:Q6581072 .

  	# place of birth = Wales (Q25)
  	{ ?item wdt:P19 wd:Q25 }
	# OR place of birth within Wales. This relies on places using P131 with Q25 ("Wales") as value (or with a value that has Q25 in P131)
	UNION  { ?item wdt:P19 ?pob . ?pob wdt:P131* wd:Q25 }

	# look for articles (sitelinks) in Welsh ("cy")
  	OPTIONAL { ?sitelink schema:about ?item . ?sitelink schema:inLanguage "cy" }
	# but select items with no such article
	FILTER (!BOUND(?sitelink))

	# humans only
  	?item wdt:P31 wd:Q5 .
}
#Listeria can only handle up to 5000
LIMIT 1000

Try it!

People born in Occitania for Listeria[edit]

#added before 2016-10
 #Definition for Occitania (Q104285) is the one defined by P527 on item Q104285
SELECT ?item ?yob ?yod
WHERE
{
	# items with property place of birth
	?item wdt:P19 ?pob .
	#place of birth must be using P131 with one of the "?parts" (or -- note the "*" -- a value that uses one of the parts in P131, etc.)
	?pob wdt:P131* ?parts .

	# ?parts are those listed on item Q104285 with property P527
	wd:Q104285 wdt:P527 ?parts . 

	# humans only
  	?item wdt:P31 wd:Q5 .

	#for display in the list, extract yob/yod. Could also be done by using P569 and P570 in "columns=" of Listeria's template
	OPTIONAL { ?item wdt:P569 ?dob . BIND(YEAR(?dob) as ?yob) }
	OPTIONAL { ?item wdt:P570 ?dod . BIND(YEAR(?dod) as ?yod) }
}
#LIMIT to 2000 as Listeria can only handle up to 5000
LIMIT 2000

Try it!

People born in Scotland for Listeria[edit]

#added before 2016-10
SELECT ?item ?dob
WHERE
{
  	# place of birth = Scotland (Q22)
  	{ ?item wdt:P19 wd:Q22 }
	# OR place of birth within Scotland.
	UNION  { ?item wdt:P19 ?pob . ?pob wdt:P131* wd:Q22 }

	# humans only
  	?item wdt:P31 wd:Q5 .

	# get DOB for ordering.
	OPTIONAL { ?item wdt:P569 ?dob  }
}
#Order by date of birth, avoid overriding this in the template with sort=
ORDER BY ?dob
#Listeria can only handle up to 5000
LIMIT 4000
#start at the first item
OFFSET 0 #change to OFFSET 4000 to start at the 4001th item

Try it!

Wikibase predicates[edit]

Properties[edit]

Properties grouped by their parent property[edit]

The following query uses these:

  • Properties: subproperty of (P1647) View with Reasonator View with SQID
    1 #Properties grouped by their parent property
    2 #TODO: should display links and numeric ids
    3 #defaultView:Tree
    4 SELECT ?property2 ?property2Label ?property1 ?property1Label WHERE {
    5   ?property1 rdf:type wikibase:Property. #not replaceable with wikibase:Item, wikibase:Statement, wikibase:Reference at WDQS
    6                                          #https://www.mediawiki.org/wiki/Wikibase/Indexing/RDF_Dump_Format#WDQS_data_differences
    7   ?property1 wdt:P1647 ?property2.
    8   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    9 }
    

Subproperties of location (P276)[edit]

The following query uses these:

  • Properties: subproperty of (P1647) View with Reasonator View with SQID
    1 #Subproperties of location (P276)
    2 SELECT DISTINCT ?subProperties ?subPropertiesLabel WHERE {
    3   ?subProperties wdt:P1647* wd:P276.
    4   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
    5 }
    

Properties grouped by their Wikibase datatype (Q19798645) with number of properties[edit]

The following query uses these:

1 #Properties grouped by their type with number of properties
2 SELECT (COUNT(?property) as ?pcount ) ?wbtype WHERE {
3   ?property rdf:type               wikibase:Property.
4   ?property wikibase:propertyType  ?wbtype.
5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
6 }
7 GROUP BY ?wbtype
8 ORDER BY DESC(?pcount)

All properties with descriptions and aliases and types[edit]

The following query uses these:

 1 SELECT ?p ?pt ?pLabel ?d ?aliases WHERE {
 2   {
 3     SELECT ?p ?pt ?d (GROUP_CONCAT(DISTINCT ?alias; separator="|") as ?aliases) WHERE {
 4       ?p wikibase:propertyType ?pt .
 5       OPTIONAL {?p skos:altLabel ?alias FILTER (LANG (?alias) = "en")}
 6       OPTIONAL {?p schema:description ?d FILTER (LANG (?d) = "en") .}
 7     } GROUP BY ?p ?pt ?d 
 8   }
 9   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
10 }

Wikimedia projects[edit]

Sitelinks[edit]

Countries that have sitelinks to en.wiki[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID
     1 SELECT ?country ?countryLabel ?article WHERE {
     2 
     3     ?country wdt:P31 wd:Q3624078 . # sovereign state
     4     ?article schema:about ?country .
     5     ?article schema:isPartOf <https://en.wikipedia.org/>.
     6 
     7     SERVICE wikibase:label {
     8        bd:serviceParam wikibase:language "en"
     9     }
    10 }
    

Countries that have a Featured Article on Russian Wikipedia[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID
    1 SELECT ?sitelink ?itemLabel WHERE {
    2   ?item wdt:P31 wd:Q6256.
    3   ?sitelink schema:isPartOf <https://ru.wikipedia.org/>;
    4      schema:about ?item;
    5      wikibase:badge wd:Q17437796 . # Sitelink is badged as a Featured Article
    6     SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } .
    7 }  ORDER BY ?itemLabel
    

Numbers of sitelinks for items with Art UK artist ID (P1367) for each language[edit]

The following query uses these:

  • Properties: Art UK artist ID (P1367) View with Reasonator View with SQID
    1 SELECT ?lang (COUNT(DISTINCT ?item) AS ?count) WHERE {
    2 
    3   ?item wdt:P1367 ?yp_id .     # BBC 'Your paintings' artist identifier
    4   ?article schema:about ?item .
    5   FILTER (SUBSTR(str(?article), 11, 15) = ".wikipedia.org/") .
    6   ?article schema:inLanguage ?lang .
    7 
    8 } GROUP BY ?lang
    9 ORDER BY DESC (?count)
    

Titles of articles about Ukrainian villages on Romanian Wikipedia[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, country (P17) View with Reasonator View with SQID
     1 #Show titles of articles about Ukrainian villages on Romanian Wikipedia, plus English and Ukrainian labels in Wikidata items
     2 #added in 2017-05
     3 SELECT DISTINCT ?item ?LabelEN ?LabelUK ?page_titleRO WHERE {
     4   ?item wdt:P31 wd:Q532 .  
     5   ?item wdt:P17 wd:Q212 .
     6   ?article schema:about ?item ; schema:isPartOf <https://ro.wikipedia.org/> ;  schema:name ?page_titleRO .
     7   ?item rdfs:label ?LabelEN filter (lang(?LabelEN) = "en") .
     8   ?item rdfs:label ?LabelUK filter (lang(?LabelUK) = "uk") .
     9 }
    10 LIMIT 300
    

Wikisource pages for authors of scientific articles[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, author (P50) View with Reasonator View with SQID
     1 #Wikisource pages for authors of scientific articles, ordered by Wikisource language
     2 #added in 2017-09
     3 SELECT DISTINCT ?item ?wikisourceSitelink ?wikisourceLanguage WHERE {
     4   ?wikisourceSitelink schema:isPartOf [ wikibase:wikiGroup "wikisource" ];
     5                       schema:inLanguage ?wikisourceLanguage;
     6                       schema:about ?item.
     7   ?paper wdt:P31 wd:Q13442814;
     8          wdt:P50 ?item.
     9 }
    10 ORDER BY ?wikisourceLanguage
    11 LIMIT 300
    

Entertainment[edit]

Rock bands that start with "M"[edit]

SELECT DISTINCT ?band ?bandLabel
WHERE
{
	?band  wdt:P31 wd:Q5741069 .
        ?band rdfs:label ?bandLabel .
	FILTER(STRSTARTS(?bandLabel, 'M')) .
}

Try it!

Winner of the Academy Awards by Award and Time[edit]

SELECT DISTINCT ?item ?itemLabel ?awardLabel ?time
{
    ?item wdt:P106/wdt:P279* wd:Q3455803 ; # Items with the Occupation(P106) of Director(Q3455803) or a subclass(P279)
          p:P166 ?awardStat .              # ... with an awarded(P166) statement
    ?awardStat pq:P805 ?award ;            # Get the award (which is "subject of" XXth Academy Awards)
               ps:P166 wd:Q103360 .        # ... that has the value Academy Award for Best Director(Q103360)
    ?award wdt:P585 ?time .                # the "point of time" of the Academy Award
    SERVICE wikibase:label {               # ... include the labels
        bd:serviceParam wikibase:language "en"
    }
}
ORDER BY DESC(?time)

Try it!

Academy award data[edit]

#added before 2016-10
SELECT ?human ?humanLabel ?awardEditionLabel ?awardLabel ?awardWork ?awardWorkLabel ?director ?directorLabel ?time
WHERE
{
	{
		SELECT (SAMPLE(?human) AS ?human) ?award ?awardWork (SAMPLE(?director) AS ?director) (SAMPLE(?awardEdition) AS ?awardEdition) (SAMPLE(?time) AS ?time) WHERE {
			?award wdt:P31 wd:Q19020 .			# All items that are instance of(P31) of Academy awards (Q19020)
			{
				?human p:P166 ?awardStat .              # Humans with an awarded(P166) statement
				?awardStat ps:P166 ?award .     	 # ... that has any of the values of ?award
				?awardStat pq:P805 ?awardEdition . # Get the award edition (which is "subject of" XXth Academy Awards)
				?awardStat pq:P1686 ?awardWork . # The work they have been awarded for
				?human wdt:P31 wd:Q5 . 				# Humans
			} UNION {
				?awardWork wdt:P31 wd:Q11424 . # Films
				?awardWork p:P166 ?awardStat . # ... with an awarded(P166) statement
				?awardStat ps:P166 ?award .     	 # ... that has any of the values of ?award
				?awardStat pq:P805 ?awardEdition . # Get the award edition (which is "subject of" XXth Academy Awards)
			}
			OPTIONAL {
				?awardEdition wdt:P585 ?time . # the "point of time" of the Academy Award
				?awardWork wdt:P57 ?director .
			}
		}
		GROUP BY ?awardWork ?award # We only want every movie once for a category (a 'random' person is selected)
	}

	SERVICE wikibase:label {            # ... include the labels
		bd:serviceParam wikibase:language "en" .
	}
}
ORDER BY DESC(?time)

Try it!

People that received both Academy Award and Nobel Prize[edit]

The following query uses these:

  • Properties: award received (P166) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID
    1 SELECT DISTINCT ?personLabel WHERE {
    2   ?person wdt:P166/wdt:P279* wd:Q7191 .
    3   ?person wdt:P166/wdt:P279* wd:Q19020 .
    4   SERVICE wikibase:label {
    5     bd:serviceParam wikibase:language "en" .
    6   }
    7 }
    

Number of handed out academy awards per award type[edit]

#added before 2016-10

SELECT ?awardCount ?award ?awardLabel WHERE {
	{
		SELECT (COUNT(?award) AS ?awardCount) ?award
		WHERE
		{
			{
				SELECT (SAMPLE(?human) AS ?human) ?award ?awardWork (SAMPLE(?director) AS ?director) (SAMPLE(?awardEdition) AS ?awardEdition) (SAMPLE(?time) AS ?time) WHERE {
					?award wdt:P31 wd:Q19020 .			# All items that are instance of(P31) of Academy awards (Q19020)
					{
						?human p:P166 ?awardStat .              # Humans with an awarded(P166) statement
						?awardStat ps:P166 ?award .     	 # ... that has any of the values of ?award
						?awardStat pq:P805 ?awardEdition . # Get the award edition (which is "subject of" XXth Academy Awards)
						?awardStat pq:P1686 ?awardWork . # The work they have been awarded for
						?human wdt:P31 wd:Q5 . 				# Humans
					} UNION {
						?awardWork wdt:P31 wd:Q11424 . # Films
						?awardWork p:P166 ?awardStat . # ... with an awarded(P166) statement
						?awardStat ps:P166 ?award .     	 # ... that has any of the values of ?award
						?awardStat pq:P805 ?awardEdition . # Get the award edition (which is "subject of" XXth Academy Awards)
					}
					OPTIONAL {
						?awardEdition wdt:P585 ?time . # the "point of time" of the Academy Award
						?awardWork wdt:P57 ?director .
					}
				}
				GROUP BY ?awardWork ?award # We only want every movie once for a category (a 'random' person is selected)
			}
		} GROUP BY ?award
		ORDER BY ASC(?awardCount)
	}
	SERVICE wikibase:label {            # ... include the labels
		bd:serviceParam wikibase:language "en" .
	}
}

Try it!

Film directors ranked by number of sitelinks multiplied by their number of films[edit]

#added before 2016-10

SELECT ?director ?director_label (count(distinct ?film) as ?films) (count(distinct ?sitelink) as ?sitelinks) ((?films * ?sitelinks) as ?rank)
WHERE
{
	?director wdt:P106 wd:Q2526255 .  				# has "film director" as occupation
	?film wdt:P57 ?director . 	 					# get all films directed by the director
    ?sitelink schema:about ?director .				# get all the sitelinks about the director

	OPTIONAL {?director rdfs:label ?director_label  # get the label of the director (if it exists)
              FILTER (lang(?director_label) = "en") # filter for only English labels
	} 	
}

GROUP BY ?director ?director_label
ORDER BY DESC(?rank)
LIMIT 100

Try it!

The Simpsons television series episodes list by season[edit]

#added before 2016-10
SELECT ?show ?showLabel  ?season ?seasonNumber ?episode ?episodeLabel
WHERE
{
	BIND(wd:Q886 as ?show) .
	?season wdt:P361 ?show .
	?episode wdt:P361 ?season .
	?season p:P179 [
	        pq:P1545 ?seasonNumber] .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}

Try it!

Pokemon![edit]

#added before 2016-10

# Gotta catch 'em all
SELECT DISTINCT ?pokemon ?pokemonLabel ?pokedexNumber
WHERE
{
    ?pokemon wdt:P31/wdt:P279* wd:Q3966183 .
    ?pokemon p:P1112 ?statment.
    ?statment ps:P1112 ?pokedexNumber;
              pq:P642 wd:Q20005020.

    FILTER ( !isBLANK(?pokedexNumber) ) .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY (?pokedexNumber)

Try it!

Law & Order episodes[edit]

# All Law & Order episodes on Wikidata.
# According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes).
# As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query).

SELECT (SAMPLE(?seasonNumber) AS ?seasonNumber) (SAMPLE(?episodeNumber) AS ?episodeNumber) (SAMPLE(?title) AS ?title) (MIN(?pubDate) AS ?pubDate) ?episode
{
  # All episodes should be instance of episode with series Law & Order.
  ?episode wdt:P31 wd:Q21191270;
           wdt:P179 wd:Q321423.
  # Many of them also have the season as series, so we can get episode and season number from qualifiers there.
  OPTIONAL {
    ?episode p:P179 [
      # the season also has series Law & Order
      ps:P179/p:P179 [
        ps:P179 wd:Q321423;
                pq:P1545 ?seasonNumber
      ] ;
      pq:P1545 ?episodeNumber
    ]
  }
  OPTIONAL { ?episode wdt:P1476 ?title. }
  OPTIONAL { ?episode wdt:P577 ?pubDate. }
}
GROUP BY ?episode # make sure we return each episode only once – a few have multiple publication dates, for example
ORDER BY IF(BOUND(?seasonNumber), xsd:integer(?seasonNumber), 1000) xsd:integer(?episodeNumber) ?title

Try it!

Main subjects of West Wing episodes[edit]

#added before 2016-10

SELECT DISTINCT ?subject ?subjectLabel
WHERE
{
  ?episode wdt:P31/wdt:P279* wd:Q1983062.
  ?episode wdt:P179 wd:Q3577037.
  ?episode wdt:P921 ?subject.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}

Try it!

Movies with Bud Spencer[edit]

#added before 2016-10
SELECT ?item ?itemLabel ?_image
WHERE
{
  ?item wdt:P161 wd:Q221074.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  OPTIONAL { ?item wdt:P18 ?_image. }
}

Try it!

Fictional subjects of the Marvel Universe[edit]

#added before 2016-10

SELECT *
WHERE
{
	?u rdfs:label ?ul .
	FILTER (lang(?ul) = "en")
	?m rdfs:label ?ml .
	FILTER (lang(?ml) = "en")
	?p wdt:P1080 ?u.
	?p wdt:P31 ?m .
	?p wdt:P1080 wd:Q931597 .
	?p rdfs:label ?pl .
	FILTER (lang(?pl) = "en")
}

Try it!

Contemporary Indian actresses[edit]

#added 2016-10-0 (1998 results)
SELECT ?item ?itemLabel ?itemDescription ?img ?dob ?sl
WHERE
{
	?item wdt:P106 wd:Q33999 .
	?item wdt:P27 wd:Q668 .
	?item wdt:P21 wd:Q6581072 .
	OPTIONAL { ?item wdt:P570 ?d } FILTER(!BOUND(?d)) 
	?item wdt:P31 wd:Q5 .
	OPTIONAL { ?item wdt:P18 ?img }
	OPTIONAL { ?item wdt:P569 ?dob } 
	OPTIONAL { ?item wikibase:sitelinks ?sl } 
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "en"}
}

Try it!

Articles on Punjabi (Gurmukhi) Wikipedia about Pakistani actresses[edit]

#added 2017-03-25 (46 results)
SELECT ?sitelink
WHERE
{
	# gender = female
  	?item wdt:P21 wd:Q6581072 .

  	# country = Pakistan (Q25)
  	{ ?item wdt:P27 wd:Q843 }

        # occupation = actress (Q33999)
  	{ ?item wdt:P106 wd:Q33999 }
 
	# look for articles (sitelinks) in Punjabi ("pa")
  	{ ?sitelink schema:about ?item . ?sitelink schema:inLanguage "pa" }

	# humans only
  	?item wdt:P31 wd:Q5 .
}
#Listeria can only handle up to 5000
LIMIT 5000

Try it!

All Dr. Who performers[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, series ordinal (P1545) View with Reasonator View with SQID, performer (P175) View with Reasonator View with SQID
    1 #added 2017-07-16
    2 SELECT ?doctor ?doctorLabel ?ordinal ?performer ?performerLabel WHERE {
    3   ?doctor wdt:P31 wd:Q34358 .
    4   OPTIONAL { ?doctor wdt:P1545 ?ordinal }
    5   OPTIONAL { ?doctor wdt:P175 ?performer }
    6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
    7 } ORDER BY ASC(xsd:integer(?ordinal) )
    

Movies and their narrative location on a map[edit]

The following query uses these:

Features: Map (Q24515275) View with Reasonator View with SQID

1 #defaultView:Map
2 SELECT ?movie ?movieLabel ?narrative_location ?narrative_locationLabel ?coordinates WHERE {
3    ?movie wdt:P840 ?narrative_location ;
4           wdt:P31 wd:Q11424 .
5    ?narrative_location wdt:P625 ?coordinates .
6   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
7 }

Movies released in 2017[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, publication date (P577) View with Reasonator View with SQID
    1 SELECT DISTINCT ?item ?itemLabel WHERE {
    2   ?item wdt:P31 wd:Q11424.
    3   ?item wdt:P577 ?pubdate.
    4   FILTER((?pubdate >= "2017-01-01T00:00:00Z"^^xsd:dateTime) && (?pubdate <= "2017-12-31T00:00:00Z"^^xsd:dateTime))
    5   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    6 }
    

Geography[edit]

Continents[edit]

Continents[edit]

#added before 2016-10

SELECT ?continent ?continentLabel
WHERE
{
  ?continent wdt:P31 wd:Q5107.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY xsd:integer(SUBSTR(STR(?continent),STRLEN("http://www.wikidata.org/entity/Q")+1))

Try it!

Some other continents[edit]

#added before 2016-10

SELECT ?continentLabel
WHERE
{
  { # subquery for optimization so the label service doesn’t have to do as much work (228?ms vs 20731?ms)
    SELECT DISTINCT ?continent
    WHERE
    {
      [] wdt:P30 ?continent.
    }
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY xsd:integer(SUBSTR(STR(?continent),STRLEN("http://www.wikidata.org/entity/Q")+1))

Try it!

Places with continent Antarctica more than 3000?km north of south pole[edit]

#added before 2016-10

#defaultView:Map
SELECT ?place ?placeLabel ?location WHERE {
  wd:Q933 wdt:P625 ?southPole.                         # coordinates of south pole
  ?place wdt:P30 wd:Q51;                               # continent: antarctica
         wdt:P625 ?location.
  FILTER(geof:distance(?location, ?southPole) > 3000). # over 3000?km away from south pole
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}

Try it!

Countries[edit]

List of present-day countries and capital(s)[edit]

#added before 2016-10
SELECT DISTINCT ?country ?countryLabel ?capital ?capitalLabel
WHERE
{
  ?country wdt:P31 wd:Q3624078 .
  #not a former country
  FILTER NOT EXISTS {?country wdt:P31 wd:Q3024240}
  #and no an ancient civilisation (needed to exclude ancient Egypt)
  FILTER NOT EXISTS {?country wdt:P31 wd:Q28171280}
  OPTIONAL { ?country wdt:P36 ?capital } .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?countryLabel

Try it!

Largest cities per country[edit]

#added before 2016-10

#Largest cities per country
SELECT DISTINCT ?city ?cityLabel ?population ?country ?countryLabel ?loc WHERE {
	{
		SELECT (MAX(?population) AS ?population) ?country WHERE {
			?city wdt:P31/wdt:P279* wd:Q515 .
			?city wdt:P1082 ?population .
			?city wdt:P17 ?country .
		}
		GROUP BY ?country
		ORDER BY DESC(?population)
	}
	?city wdt:P31/wdt:P279* wd:Q515 .
	?city wdt:P1082 ?population .
	?city wdt:P17 ?country .
	?city wdt:P625 ?loc .
	SERVICE wikibase:label {
		bd:serviceParam wikibase:language "en" .
	}
}

Try it!

Wikidata people per million inhabitants for all EU countries[edit]

#added before 2016-10

#Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below
SELECT
	?country ?countryLabel
	?wikiPersons
	?population
	(ROUND(?wikiPersons/?population*1000000) AS ?wikiPersonsPerM)
WHERE
{
	{ SELECT ?country (count(*) as ?wikiPersons) WHERE {
		{SELECT DISTINCT ?person ?country WHERE {
			?country wdt:P31 wd:Q185441 .
			# BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries
			?person wdt:P31 wd:Q5 .
			?person wdt:P27 ?country .
			FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people
		} }
	} GROUP BY ?country  }
	?country wdt:P1082 ?population
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY DESC(?wikiPersonsPerM)

Try it!

Papers about wikidata[edit]

#added before 2016-10

#papers about Wikidata
SELECT ?item ?itemLabel
WHERE
{
  ?item (wdt:P31/wdt:P279*) wd:Q191067.
  ?item wdt:P921 wd:Q2013.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
LIMIT 100

Try it!

Countries sorted by population[edit]

# defaultView:BubbleChart
SELECT DISTINCT ?countryLabel ?population
{
  ?country wdt:P31 wd:Q6256 ;
           wdt:P1082 ?population .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
GROUP BY ?population ?countryLabel
ORDER BY DESC(?population)

Try it!

Country populations together with total city populations[edit]

Lists for each country the population and the total of the populations of all cities of this country. If data were complete and populations were measured at the same time for each country and the respective cities then the ratio would be 1.

SELECT ?country ?countryLabel ?population ?totalCityPopulation (?population / ?totalCityPopulation AS ?ratio) {
  ?country wdt:P1082 ?population .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
  {
    SELECT ?country (SUM(?cityPopulation) AS ?totalCityPopulation) WHERE {
      ?city wdt:P31 wd:Q515 .
      ?city wdt:P17 ?country .
      ?city wdt:P1082 ?cityPopulation .
    } GROUP BY ?country
  }
} ORDER BY ?ratio

Try it!

Cities[edit]

Former capitals[edit]

#added before 2016-10

#defaultView:Map
SELECT DISTINCT ?country ?countryLabel ?capital ?capitalLabel ?coordinates ?ended
WHERE
{
  ?country p:P36 ?stat.
  ?stat ps:P36 ?capital.
  ?capital wdt:P625 ?coordinates.
  OPTIONAL {
    ?country wdt:P582|wdt:P576 ?ended.
  }
  OPTIONAL {
    ?capital wdt:P582|wdt:P576 ?ended.
  }
  OPTIONAL {
    ?stat pq:P582 ?ended.
  }
  FILTER(BOUND(?ended)).
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}

Try it!

Largest cities of the world[edit]

#added before 2016-10
 #defaultView:BubbleChart
SELECT DISTINCT ?cityLabel ?population ?gps
WHERE
{
  ?city wdt:P31/wdt:P279* wd:Q515 .
  ?city wdt:P1082 ?population .
  ?city wdt:P625 ?gps .
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
  }
}
ORDER BY DESC(?population) LIMIT 100

Try it!

Cities as big as Antwerp give or take 1000[edit]

The following query uses these:

Features: Map (Q24515275) View with Reasonator View with SQID

 1 #added before 2016-10
 2 
 3 #defaultView:Map
 4 SELECT DISTINCT ?city ?cityLabel ?populatie2 ?coor WHERE {
 5   wd:Q12892 wdt:P1082 ?populatie .
 6   ?city wdt:P1082 ?populatie2 ;
 7         wdt:P625 ?coor .
 8   FILTER (abs(?populatie - ?populatie2) < 1000)
 9   SERVICE wikibase:label { bd:serviceParam wikibase:language "nl" }
10 }

Cities as big as Eindhoven give or take 1000[edit]

#added before 2016-10

#defaultView:Map
SELECT DISTINCT ?city ?cityLabel ?location ?populatie2 WHERE {
  wd:Q9832 wdt:P1082 ?populatie .
  ?city wdt:P1082 ?populatie2 ;
        wdt:P625 ?location .
  FILTER (abs(?populatie - ?populatie2) < 1000)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "nl" }
}

Try it!

Where in the world is Antwerp[edit]

The following query uses these:

Features: Map (Q24515275) View with Reasonator View with SQID

 1 #added before 2016-10
 2 
 3 #defaultView:Map
 4 SELECT DISTINCT ?settlement ?name ?coor
 5 WHERE
 6 {
 7   
 8    ?subclass_settlement wdt:P279+ wd:Q486972 .
 9    ?settlement wdt:P31 ?subclass_settlement ;
10                wdt:P625 ?coor ;
11                 rdfs:label ?name .
12    FILTER regex(?name, "Antwerp", "i")
13 
14 }

Destinations from Antwerp International airport[edit]

The following query uses these:

Features: Map (Q24515275) View with Reasonator View with SQID

 1 #added before 2016-10
 2 
 3 #defaultView:Map
 4 SELECT ?connectsairport ?connectsairportLabel ?place_served ?place_servedLabel ?coor
 5 WHERE
 6 {
 7   VALUES ?airport { wd:Q17480 } # Antwerp international airport  wd:Q17480
 8   ?airport wdt:P81 ?connectsairport ;
 9            wdt:P625 ?base_airport_coor .
10   ?connectsairport wdt:P931 ?place_served ;
11                    wdt:P625 ?coor .
12  
13   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
14 }

Cities connected by the European route E40[edit]

The following query uses these:

Features: Map (Q24515275) View with Reasonator View with SQID

 1 #added before 2016-10
 2 
 3 #defaultView:Map
 4 SELECT ?city ?cityLabel ?coordinates
 5 WHERE
 6 {
 7    VALUES ?highway {wd:Q327162 }
 8    ?highway wdt:P2789 ?city .
 9     ?city wdt:P625 ?coordinates .
10    SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
11 }

Cities connected by the Trans-Mongolian and Trans-Siberian Railway[edit]

The following query uses these:

Features: Map (Q24515275) View with Reasonator View with SQID

 1 #added before 2016-10
 2 
 3 #defaultView:Map
 4 SELECT ?city ?cityLabel ?coordinates
 5 WHERE
 6 {
 7    VALUES ?highway { wd:Q559037 wd:Q58767 }
 8    ?highway wdt:P2789 ?city .
 9     ?city wdt:P625 ?coordinates .
10    SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
11 }

Cities connected to Paramaribo (Suriname) by main roads[edit]

The following query uses these:

Features: Map (Q24515275) View with Reasonator View with SQID

 1 #added before 2016-10
 2 
 3 #defaultView:Map
 4 SELECT DISTINCT ?connection ?connectionLabel ?connectedWith ?connectedWithLabel ?coor
 5 WHERE
 6 {
 7   VALUES ?city {wd:Q3001} # wd:Q3001 = Paramaribo}
 8   ?connection wdt:P2789+ ?city ;
 9               wdt:P2789+ ?connectedWith .
10   ?connectedWith wdt:P625 ?coor .
11   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
12   }

Names of 100 cities with a population larger than 1000000 in the native languages of their countries[edit]

The following query uses these:

  • Properties: population (P1082) View with Reasonator View with SQID, instance of (P31) View with Reasonator View with SQID, country (P17) View with Reasonator View with SQID, official language (P37) View with Reasonator View with SQID, Wikimedia language code (P424) View with Reasonator View with SQID
     1 #added before 2016-10
     2 
     3 # Show the names of 100 cities with a population larger than 1000000 in the native languages of their countries
     4 SELECT ?city ?cityLabel ?country ?countryLabel ?lang ?langLabel ?langCode ?population
     5 WHERE
     6 {
     7   ?city wdt:P1082 ?population .
     8  
     9   FILTER(?population>1000000)
    10  
    11   ?city wdt:P31 wd:Q515;
    12         wdt:P17 ?country;
    13         rdfs:label ?cityLabel .
    14   ?country wdt:P37 ?lang;
    15            rdfs:label ?countryLabel .
    16   ?lang wdt:P424 ?langCode;
    17         rdfs:label ?langLabel .
    18  
    19   FILTER(lang(?cityLabel)=?langCode)
    20   FILTER(lang(?countryLabel)=?langCode)
    21   FILTER(lang(?langLabel)=?langCode)
    22 } LIMIT 100
    

Distances between any two cities or municipalities in an area[edit]

grouped by dist range, color-coded[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, located in the administrative territorial entity (P131) View with Reasonator View with SQID, coordinate location (P625) View with Reasonator View with SQID
     1 #defaultView:BarChart
     2 SELECT ?from ?to ?distGrp WHERE {
     3   {
     4     SELECT ?from ?to ?distNum ?mun ?mun2 WHERE {
     5       BIND(wd:Q15284 AS ?muntype).
     6       BIND(wd:Q6308 AS ?area).
     7       ?mun wdt:P31/wdt:P279* ?muntype;
     8            wdt:P131 ?area;
     9            wdt:P625 ?loc.
    10       OPTIONAL { ?mun2 wdt:P31/wdt:P279* ?muntype;
    11                        wdt:P131 ?area;
    12                        wdt:P625 ?loc2. }
    13       BIND(geof:distance(?loc, ?loc2) AS ?distNum).
    14 
    15       SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
    16         ?mun rdfs:label ?from.
    17         ?mun2 rdfs:label ?to.
    18       }
    19     }
    20   }
    21   FILTER(CONCAT(?from,STR(?mun)) <= CONCAT(?to,STR(?mun2))).
    22   #BIND(IF(STR(?from) < STR(?to),CONCAT(?from," <--> ",?to),
    23   #  CONCAT(?to," <--> ",?from)) AS ?distLabel).
    24 
    25   BIND(COALESCE(
    26     IF(?distNum >= 40, "40 - .. km", 1/0),
    27     IF(?distNum >= 30, "30 - 40 km", 1/0),
    28     IF(?distNum >= 20, "20 - 30 km", 1/0),
    29     IF(?distNum >= 10, "10 - 20 km", 1/0),
    30     IF(?distNum >= 5, "05 - 10 km", 1/0),
    31     IF(?distNum >= 1, "01 - 05 km", "00 - 01 km")) AS ?distGrp).
    32 }
    33 ORDER BY ?from ?distGrp
    
grouped per municipality on x-axis, alphabetically[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, located in the administrative territorial entity (P131) View with Reasonator View with SQID, coordinate location (P625) View with Reasonator View with SQID
     1 #defaultView:ScatterChart
     2 SELECT ?from (?distGrp1 AS ?kilometers) ?to WHERE {
     3   BIND(wd:Q15284 AS ?muntype).
     4   BIND(wd:Q6308 AS ?area).
     5   ?mun wdt:P31/wdt:P279* ?muntype;
     6        wdt:P131 ?area;
     7        wdt:P625 ?loc.
     8   OPTIONAL { ?mun2 wdt:P31/wdt:P279* ?muntype;
     9                    wdt:P131 ?area;
    10                    wdt:P625 ?loc2. }
    11   BIND(geof:distance(?loc, ?loc2) AS ?distNum).
    12   BIND(STR(ROUND(?distNum)) AS ?distGrp0).
    13   BIND(CONCAT(SUBSTR("000",STRLEN(?distGrp0)+1),?distGrp0,".",STR(ROUND((?distNum-FLOOR(?distNum))*10))," km") AS ?distGrp1).
    14 
    15   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
    16     ?mun rdfs:label ?from.
    17     ?mun2 rdfs:label ?to.
    18   }
    19 }
    20 ORDER BY ?from ?kilometers
    
grouped per municipality on x-axis, by sum of dist[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, located in the administrative territorial entity (P131) View with Reasonator View with SQID, coordinate location (P625) View with Reasonator View with SQID
     1 #defaultView:ScatterChart
     2 SELECT ?from (?distNum AS ?kilometers) ?to WHERE {
     3   BIND(wd:Q15284 AS ?muntype).
     4   BIND(wd:Q6308 AS ?area).
     5   ?mun wdt:P31/wdt:P279* ?muntype;
     6        wdt:P131 ?area;
     7        wdt:P625 ?loc.
     8   OPTIONAL { ?mun2 wdt:P31/wdt:P279* ?muntype;
     9                    wdt:P131 ?area;
    10                    wdt:P625 ?loc2. }
    11   BIND(geof:distance(?loc, ?loc2) AS ?distNum).
    12 
    13   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
    14     ?mun rdfs:label ?from.
    15     ?mun2 rdfs:label ?to.
    16   }
    17 }
    18 ORDER BY ?from ?kilometers
    
grouped per municipality on x-axis, animated per municipality on x-axis[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, located in the administrative territorial entity (P131) View with Reasonator View with SQID, coordinate location (P625) View with Reasonator View with SQID
     1 #defaultView:ScatterChart
     2 SELECT ?from (?distNum AS ?kilometers) ?to (?from AS ?animation) WHERE {
     3   BIND(wd:Q15284 AS ?muntype).
     4   BIND(wd:Q6308 AS ?area).
     5   ?mun wdt:P31/wdt:P279* ?muntype;
     6        wdt:P131 ?area;
     7        wdt:P625 ?loc.
     8   OPTIONAL { ?mun2 wdt:P31/wdt:P279* ?muntype;
     9                    wdt:P131 ?area;
    10                    wdt:P625 ?loc2. }
    11   BIND(geof:distance(?loc, ?loc2) AS ?distNum).
    12 
    13   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
    14     ?mun rdfs:label ?from.
    15     ?mun2 rdfs:label ?to.
    16   }
    17 }
    18 ORDER BY ?from ?kilometers
    
grouped per municipality on x-axis, animated per municipality on z-axis[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, located in the administrative territorial entity (P131) View with Reasonator View with SQID, coordinate location (P625) View with Reasonator View with SQID
     1 #defaultView:ScatterChart
     2 SELECT ?from (?distNum AS ?kilometers) ?to (?to AS ?animation) WHERE {
     3   BIND(wd:Q15284 AS ?muntype).
     4   BIND(wd:Q6308 AS ?area).
     5   ?mun wdt:P31/wdt:P279* ?muntype;
     6        wdt:P131 ?area;
     7        wdt:P625 ?loc.
     8   OPTIONAL { ?mun2 wdt:P31/wdt:P279* ?muntype;
     9                    wdt:P131 ?area;
    10                    wdt:P625 ?loc2. }
    11   BIND(geof:distance(?loc, ?loc2) AS ?distNum).
    12 
    13   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
    14     ?mun rdfs:label ?from.
    15     ?mun2 rdfs:label ?to.
    16   }
    17 }
    18 ORDER BY ?from ?kilometers
    
grouped per municipality on x-axis, animated by fixed dist range groups[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, located in the administrative territorial entity (P131) View with Reasonator View with SQID, coordinate location (P625) View with Reasonator View with SQID
     1 #defaultView:ScatterChart
     2 SELECT ?from (?distNum AS ?kilometers) ?to (?distGrp AS ?animation) WHERE {
     3   BIND(wd:Q15284 AS ?muntype).
     4   BIND(wd:Q6308 AS ?area).
     5   ?mun wdt:P31/wdt:P279* ?muntype;
     6        wdt:P131 ?area;
     7        wdt:P625 ?loc.
     8   OPTIONAL { ?mun2 wdt:P31/wdt:P279* ?muntype;
     9                    wdt:P131 ?area;
    10                    wdt:P625 ?loc2. }
    11   #FILTER (STR(?mun) <= STR(?mun2)).
    12   BIND(geof:distance(?loc, ?loc2) AS ?distNum).
    13   BIND(COALESCE(
    14     IF(?distNum >= 40, "40 km und mehr", 1/0),
    15     IF(?distNum >= 30, "30 - 40 km", 1/0),
    16     IF(?distNum >= 20, "20 - 30 km", 1/0),
    17     IF(?distNum >= 10, "10 - 20 km", 1/0),
    18     IF(?distNum >= 5, "05 - 10 km", 1/0),
    19     IF(?distNum >= 1, "01 - 05 km", "00 - 01 km")) AS ?distGrp).
    20   
    21   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
    22     ?mun rdfs:label ?from.
    23     ?mun2 rdfs:label ?to.
    24   }
    25 }
    26 ORDER BY ?animation ?from ?kilometers
    
grouped per municipality on x-axis, animated by ranked dist (farthest, 2nd farthest, ..)[edit]

The following query uses these:

  • Properties: coordinate location (P625) View with Reasonator View with SQID, instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, located in the administrative territorial entity (P131) View with Reasonator View with SQID
     1 #defaultView:ScatterChart
     2 # currently depends on wdt:P625 yielding a single value for a ?mun .., strange results may be fixable
     3 # by applying (https://www.wikidata.org/wiki/Help:Ranking) to ?mun items where multiple P625 values exist
     4 SELECT ?from ?kilometers ?to ?rank_group
     5 WHERE {
     6   {
     7     SELECT (SAMPLE(?mun) AS ?mun) (SAMPLE(?mun2) AS ?mun2) (SAMPLE(?distNum) AS ?kilometers)
     8            (COUNT(*)-1 AS ?rg) (IF(FLOOR((?rg-(100*FLOOR(?rg/100)))/10)=1,0,?rg-(10*FLOOR(?rg/10))) AS ?rgmod)
     9            (IF(?rgmod=1,"st",IF(?rgmod=2,"nd",IF(?rgmod=3,"rd","th"))) AS ?rgord)
    10            (CONCAT(SUBSTR("00",1+STRLEN(STR(?rg))),STR(?rg),?rgord,"-most farthest places") AS ?rank_group)
    11     WHERE {
    12       BIND(wd:Q15284 AS ?muntype).
    13       BIND(wd:Q6308 AS ?area).
    14       ?mun wdt:P31/wdt:P279* ?muntype;
    15            wdt:P131 ?area;
    16            wdt:P625 ?loc.
    17       OPTIONAL { ?mun2 wdt:P31/wdt:P279* ?muntype;
    18                        wdt:P131 ?area;
    19                        wdt:P625 ?loc2. }
    20       OPTIONAL { ?mun3 wdt:P31/wdt:P279* ?muntype;
    21                        wdt:P131 ?area;
    22                        wdt:P625 ?loc3. }
    23       BIND(geof:distance(?loc, ?loc2) AS ?distNum).
    24       BIND(geof:distance(?loc, ?loc3) AS ?d).
    25       FILTER(?distNum >= ?d).
    26     } GROUP BY ?mun ?mun2 ?distNum
    27   }
    28   
    29   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
    30     ?mun rdfs:label ?from.
    31     ?mun2 rdfs:label ?to.
    32   }
    33 }
    34 ORDER BY ?rank_group ?kilometers ?from
    

Rivers[edit]

Longest rivers[edit]

The following query uses these:

Features: BubbleChart (Q24515280) View with Reasonator View with SQID

 1 #added before 2016-10
 2 
 3 #defaultView:BubbleChart
 4 SELECT ?item ?itemLabel ?length ?pic ?location
 5 WHERE
 6 {
 7   ?item wdt:P31/wdt:P279* wd:Q4022 .
 8   ?item wdt:P2043 ?length .
 9   ?item wdt:P18 ?pic .
10   ?item wdt:P625 ?location
11   SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
12 } ORDER BY DESC(?length) ?itemLabel
13 LIMIT 50

Longest river of each continent[edit]

The following query uses these:

  • Properties: instance of (P31) View with Reasonator View with SQID, subclass of (P279) View with Reasonator View with SQID, length (P2043) View with Reasonator View with SQID, continent (P30) View with Reasonator View with SQID
     1 #added before 2016-10
     2 
     3 SELECT ?continent ?river ?continentLabel ?riverLabel
     4 WHERE
     5 {
     6   {
     7     SELECT ?continent (MAX(?length) AS ?length)
     8     WHERE
     9     {
    10       ?river wdt:P31/wdt:P279* wd:Q355304;
    11              wdt:P2043 ?length;
    12              wdt:P30 ?continent.
    13     }
    14     GROUP BY ?continent
    15   }
    16   ?river wdt:P31/wdt:P279* wd:Q355304;
    17          wdt:P2043 ?length;
    18          wdt:P30 ?continent.
    19   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
    20 }
    21 ORDER BY ?continentLabel
    

Rivers in Antarctica[edit]

#added before 2016-10

SELECT ?river ?riverLabel ?location
WHERE
{
  ?river wdt:P31/wdt:P279* wd:Q355304; # watercourse; includes a few creeks – use wd:Q4022 for rivers only
         wdt:P30 wd:Q51.
  OPTIONAL { ?river wdt:P625 ?location. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}

Try it!

Body of water with the most watercourses ending in it[edit]

#added before 2016-10

# Bodies of water that most watercourses end in (transitive).
# For example, over 4000 watercourses eventually flow into the Ob,
# and since the Ob flows into the Kara Sea, the Kara Sea has over 4000 results as well.
SELECT ?mouth (COUNT(?watercourse) AS ?count)
WHERE
{
  ?watercourse wdt:P403+ ?mouth.
}
GROUP BY ?mouth
ORDER BY DESC(?count)
LIMIT 10

Try it!

Bridges over rivers in former government district of Leipzig[edit]

The following query uses these:

Features: Map (Q24515275) View with Reasonator View with SQID

 1 #defaultView:Map
 2 SELECT (SAMPLE(?bridge) AS ?bridge) (SAMPLE(?bridgeLabel) AS ?bridgeLabel)
 3        (SAMPLE(?watercourse) AS ?watercourse) (SAMPLE(?watercourseLabel) AS ?watercourseLabel)
 4        (SAMPLE(?loc) AS ?loc) (SAMPLE(?pic) AS ?pic)
 5        (CONCAT(SAMPLE(?sKey),": ",STR(YEAR(SAMPLE(?s)))) AS ?start)
 6        (CONCAT(SAMPLE(?eKey),": ",STR(YEAR(SAMPLE(?e)))) AS ?end)
 7        (SAMPLE(?article) AS ?article) (IF(BOUND(?article),CONCAT(?bridgeLabel," in Wikipedia"),1/0) AS ?articleLabel)
 8 WHERE {
 9   {
10     SELECT ?bridge ?watercourse WHERE {
11       ?bridge wdt:P31/wdt:P279* wd:Q12280; wdt:P177 ?watercourse.
12       ?watercourse wdt:P31/wdt:P279* wd:Q355304.
13       # the following actually yields a perf penalty atm
14       #?bridge wdt:P17 wd:Q183.
15       #OPTIONAL { ?bridge wdt:P17 ?country. }. FILTER(!BOUND(?country) || ?country = wd:Q183).
16     }
17   }
18 
19   # wd:Q1202, wd:Q183 work as well atm and take progressively more time to complete
20   ?bridge (p:P131|ps:P131)+ wd:Q24186.
21 
22   OPTIONAL { ?bridge wdt:P625 ?loc. }.
23   OPTIONAL { ?bridge wdt:P18 ?pic. }.
24   OPTIONAL { ?bridge wdt:P571 ?s. }.
25   OPTIONAL { ?bridge wdt:P576 ?e. }.
26   
27   OPTIONAL {
28     ?article schema:about ?bridge.
29     FILTER (IF(EXISTS {?article schema:inLanguage "[AUTO_LANGUAGE]".},
30                SUBSTR(str(?article), 1, 25) = "https://[AUTO_LANGUAGE].wikipedia.org/",
31                IF(EXISTS {?article schema:inLanguage "en".},
32                   SUBSTR(str(?article), 1, 25) = "https://en.wikipedia.org/",
33                   SUBSTR(str(?article), 1, 25) = "https://de.wikipedia.org/"
34                )
35             )).
36   }
37 
38   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de".
39     ?bridge rdfs:label ?bridgeLabel.
40     ?watercourse rdfs:label ?watercourseLabel.
41     wd:P571 rdfs:label ?sKey.
42     wd:P576 rdfs:label ?eKey.
43   }
44 }
45 GROUP BY ?bridge ?watercourse

Mountains[edit]

Mountains, with coordinates, not located on Earth[edit]

SELECT DISTINCT ?item ?name ?coord ?lat ?lon ?globe
{
   ?item wdt:P31 wd:Q8502 ;
         p:P625 [
           psv:P625 [
             wikibase:geoLatitude ?lat ;
             wikibase:geoLongitude ?lon ;
             wikibase:geoGlobe ?globe ;
           ] ;
           ps:P625 ?coord
         ]
  FILTER ( ?globe != wd:Q2 )
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
    ?item rdfs:label ?name
   }
}
ORDER BY ASC (?name)

Try it!

Highest mountains in the universe[edit]

#added before 2016-10

#Mountains over 8000 elevation
SELECT ?subj ?label ?coord ?elev
WHERE
{
	?subj wdt:P2044 ?elev	filter(?elev > 8000) .
	?subj wdt:P625 ?coord .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en,zh" . ?subj rdfs:label ?label }
}

Try it!

Mountains over 8000 elevation[edit]

elevation above sea level (P2044)

#added before 2016-10

SELECT ?subj ?label ?coord ?elev
WHERE
{
	?subj wdt:P2044 ?elev	filter(?elev > 8000) .
	?subj wdt:P625 ?coord .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en,zh" . ?subj rdfs:label ?label }
}

Try it!

Italian mountains higher than 4000 m[edit]

#defaultView:ImageGrid
SELECT ?item ?itemLabel ?coord ?elev ?picture
{
  ?item p:P2044/psn:P2044/wikibase:quantityAmount ?elev ;  # normalized height
        wdt:P625 ?coord ;
        wdt:P17 wd:Q38 ;
        wdt:P18 ?picture
  FILTER(?elev > 4000)

  SERVICE wikibase:label { bd:serviceParam wikibase:language "it" }
}

Try it!

Metro stations in Paris[edit]

SELECT ?item ?itemLabel ?adjacent ?adjacentL ?coords
{
  ?item wdt:P31/wdt:P279* wd:Q928830 ;
        wdt:P81 wd:Q13224 ;
        wdt:P625 ?coords .
  OPTIONAL {
    ?item p:P197 [ ps:P197 ?adjacent ; pq:P560 wd:Q585752 ] .
    ?adjacent rdfs:label ?adjacentL filter (lang(?adjacentL) = "en")
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
} ORDER BY ?itemLabel

Try it!

Map of Broadway venues[edit]

#added before 2016-10

#defaultView:Map
# Venues in Broadway
SELECT DISTINCT ?venue ?venueLabel ?coords {
  	?venue wdt:P1217 ?IDBDB .
    wd:Q235065 wdt:P625 ?broadWayLoc .

    SERVICE wikibase:around {
      ?venue wdt:P625 ?coords .
      bd:serviceParam wikibase:center ?broadWayLoc .
      bd:serviceParam wikibase:radius "1.5" .
    }

  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
  }
}

Try it!

How many states this US state borders[edit]

#added before 2016-10
SELECT ?state ?stateLabel ?borders
WHERE
{
	{
		SELECT ?state (COUNT(?otherState) as ?borders)
		WHERE
		{
		?state wdt:P31 wd:Q35657 .
		?otherState wdt:P47 ?state .
		?otherState wdt:P31 wd:Q35657 .
		}
		GROUP BY ?state
	}
	SERVICE wikibase:label {
		bd:serviceParam wikibase:language "en" .
	}
}        
ORDER BY DESC(?borders)

Try it!

Places that are below 10 meters above sea level[edit]

#added before 2016-10

#defaultView:Map
SELECT ?p ?location ?el ?image
WHERE
{
  ?p p:P2044/psv:P2044 ?pel.
  ?pel wikibase:quantityAmount ?el.
  ?pel wikibase:quantityUnit ?unit.
  bind(0.01 as ?km).
  filter( (?el < ?km*1000 && ?unit = wd:Q11573) ||
         (?el < ?km*3281 && ?unit = wd:Q3710)
       || (?el < ?km && ?unit = wd:Q828224) ).
  ?p wdt:P625 ?location.
  optional { ?p wdt:P18 ?image }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}

Try it!

Globes used to represent coordinates[edit]

#added before 2016-10
 SELECT (count(?v) as ?c) ?globe
WHERE
{
	?v wikibase:geoGlobe ?globe
}
GROUP BY ?globe
ORDER BY DESC(?c)

Try it!

Places within 1km of the Empire State Building[edit]

#added before 2016-10
 SELECT ?place ?placeLabel ?location ?instanceLabel
WHERE
{
  wd:Q9188 wdt:P625 ?loc .
  SERVICE wikibase:around {
      ?place wdt:P625 ?location .
      bd:serviceParam wikibase:center ?loc .
      bd:serviceParam wikibase:radius "1" .
  }
  OPTIONAL {  	?place wdt:P31 ?instance  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
  BIND(geof:distance(?loc, ?location) as ?dist)
} ORDER BY ?dist

Try it!

Select French municipalities by INSEE code (select by identifier)[edit]

SELECT ?item ?itemLabel ?inseeCode {
  ?item wdt:P374 ?inseeCode .
  FILTER (?inseeCode in ("75056", "69123", "13055"))
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}

Try it!

Emergency numbers by population using them[edit]

#added before 2016-10

#Lists emergency numbers and the total amount of people which can use them
#defaultView:BubbleChart
SELECT ?emergencyNumber ?emergencyNumberLabel ?tel ?population ?countries
WHERE
{
 ?emergencyNumber wdt:P31 wd:Q694554 .
  OPTIONAL{SELECT ?emergencyNumber (COUNT(?state) as ?countries) (SUM(?pop) as ?population) WHERE {
  	?state wdt:P2852 ?emergencyNumber .
  	OPTIONAL{?state wdt:P1082 ?pop} .
  	?state wdt:P31/wdt:P279* wd:Q6256
  } GROUP BY ?emergencyNumber } .
  OPTIONAL{?emergencyNumber wdt:P1329 ?tel }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY DESC(?population)

Try it!

German states, ordered by the number of company headquarters per million inhabitants[edit]

#added before 2016-10

# German states, ordered by the number of company headquarters per million inhabitants
# Replace wd:Q1221156 (state of Germany) by anything else you care about, e.g., wd:Q6256 (country)
# Nested queries for correctness (don't count companies twice) and performance (aggregate before adding more data)
# Limits: states without population missing; company data in Wikidata is always incomplete
# Note: This query shows some not-so-easy nesting of DISTINCT (don't count any company twice) and aggregate, in combination with arithmetic output evaluation functions. It is a hard query that may time out if modified.
SELECT
	?state ?stateLabel
	?companies
	?population
	(?companies/?population*1000000 AS ?companiesPerM)
WHERE
{
	{ SELECT ?state (count(*) as ?companies) WHERE {
		{SELECT DISTINCT ?company ?state WHERE {
			?state wdt:P31 wd:Q1221156 .
			?company wdt:P31/wdt:P279* wd:Q4830453 .
			?company wdt:P159/wdt:P131* ?state .
			FILTER NOT EXISTS{ ?company wdt:P576 ?date } # don't count dissolved companies
		} }
	} GROUP BY ?state  }
    ?state wdt:P1082 ?population
	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" }
}
ORDER BY DESC(?companiesPerM)

Try it!

Popular names per birthplace[edit]

#added before 2016-10

#defaultView:BubbleChart
SELECT ?cid ?firstname (COUNT(*) AS ?count)
WHERE
{
  ?pid wdt:P19 wd:Q64.
  ?pid wdt:P735 ?cid.
  OPTIONAL {
    ?cid rdfs:label ?firstname
    FILTER((LANG(?firstname)) = "en")
  }
}
GROUP BY ?cid ?firstname
ORDER BY DESC(?count) ?firstname
LIMIT 50

Try it!

Map of places mentioned in travel stories with text in French accessible online[edit]

#added before 2016-10

#defaultView:Map
SELECT DISTINCT ?item ?itemLabel ?ed ?edLabel ?auteurLabel (year(?dateCreation) as ?AnneeCreation) ?lieuLabel ?coord ?lien
WHERE
{
  ?item wdt:P136 wd:Q1164267 .    # genre :récit de voyage
  ?item  wdt:P31 wd:Q571 .        # nature : livre
  OPTIONAL{
    ?item wdt:P50 ?auteur .       # [option] auteur
  }
  OPTIONAL{
    ?item wdt:P571 ?dateCreation. # [option] date de création              
  }
 
  ?item  wdt:P840 ?lieu .         # lieu de l'action
  MINUS {?item  wdt:P840 wd:Q933} # (bug du Pôle Sud)
  ?lieu wdt:P625 ?coord .         # coordonnées géographiques du lieu
 
  {
    ?item wdt:P953 ?lien .        # URL, texte intégral disponible sur
    ?item wdt:P407 wd:Q150        # langue de l'œuvre : français
  }UNION{
    ?ed wdt:P629 ?item .          # édition du livre
    ?ed wdt:P953 ?lien .          # URL, texte intégral disponible sur 
    ?ed wdt:P407 wd:Q150          # langue de l'œuvre : français
  }

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr". }
} ORDER BY ?dateCreation

Try it!

Things located where the equator meets the prime meridian[edit]

#added before 2016-10

SELECT ?place ?placeLabel ?location
WHERE
{
  wd:Q24041662 wdt:P625 ?loc00 .
  SERVICE wikibase:around {
    ?place wdt:P625 ?location .
    bd:serviceParam wikibase:center ?loc00 .
    bd:serviceParam wikibase:radius "0.001" .
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" .  }
}
ORDER BY ?placeLabel

Try it!

French communes with names ending in ac[edit]

#added before 2016-10

#defaultView:Map
SELECT ?item ?itemLabel ?coord
WHERE
{
	?item	wdt:P31/wdt:P279* wd:Q484170;
				wdt:P17 wd:Q142;
				rdfs:label ?itemLabel;
				wdt:P625 ?coord;
	FILTER (lang(?itemLabel) = "fr").
	FILTER regex (?itemLabel, "ac$").
	FILTER not exists { ?item wdt:P131 wd:Q33788 } # excluding Koumac, New Caledonia...
}

Try it!

Buildings in more than one country[edit]

#added before 2016-10
SELECT ?item ?itemLabel ?count
WHERE
{
  {
    SELECT ?item (COUNT(DISTINCT ?country) AS ?count) WHERE {
      ?item wdt:P31/wdt:P279* wd:Q41176 .
      ?item wdt:P17 ?country .
      FILTER NOT EXISTS { ?country wdt:P576 ?end }
    }
    GROUP BY ?item
  }
  FILTER ( ?count > 1 )
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}
ORDER BY DESC(?count) ?itemL

Try it!

Streets named after a person[edit]

SELECT ?street ?streetLabel ?cityLabel ?personLabel
WHERE
{
    ?street wdt:P31 wd:Q79007 .
    ?street wdt:P17 wd:Q142 .
    ?street wdt:P131 ?city .
    ?street wdt:P138 ?person .
    ?person wdt:P31 wd:Q5
    SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" }
}
ORDER BY ?city

Try it!

Streets in France without a city[edit]

SELECT ?street ?streetLabel
WHERE
{
    ?street wdt:P31/wdt:P279* wd:Q79007 .
    ?street wdt:P17 wd:Q142 .
    MINUS { ?street wdt:P131 [] } .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" }
}
ORDER BY ?streetLabel

Try it!

ATMs around Munich belonging to the Bankcard-Servicenetz interbank network (federated query)[edit]

#defaultView:Map{"hide":["?atm","?geometry"], "layer": "?bankLabel"}

PREFIX lgdo: <http://linkedgeodata.org/ontology/>
PREFIX geom: <http://geovocab.org/geometry#>
PREFIX bif: <bif:>

SELECT ?atm ?geometry ?bank ?bankLabel WHERE {
  hint:Query hint:optimizer "None".
  
  SERVICE <http://linkedgeodata.org/sparql> {
    { ?atm a lgdo:Bank; lgdo:atm true. }
    UNION { ?atm a lgdo:Atm. }
    
    ?atm geom:geometry [geo:asWKT ?geometry];
         lgdo:operator ?operator.
    FILTER(bif:st_intersects(?geometry, bif:st_point(11.5746898, 48.1479876), 5)) # 5 km around Munich
  }
  
  BIND(STRLANG(?operator, "de") as ?bankLabel) 
  ?bank rdfs:label ?bankLabel.
  
  # bank is part of the Bankcard service network, either via an explicit statement or implicitly due to its legal form (unless explicitly excluded)
  { ?bank wdt<