Wikibase/Indexing/SPARQL Query Examples

Syntax according to RDF Dump format. See also https://phabricator.wikimedia.org/T86786

Further examples can be found at d:Wikidata:SPARQL query service/queries

This page is parsed by the web interface of the query service to fill its drop down of example queries.

Standard Prefixes
These are standard prefixes, however their use is optional as the query endpoint knows to resolve standard prefixes automatically. PREFIX wd:  PREFIX wdt:  PREFIX wikibase:  PREFIX p:  PREFIX ps:  PREFIX pq:  PREFIX rdfs: 

__

US presidents and spouses

 * Items used:
 * Properties used: ,

US presidents & causes of death

 * Items used:
 * Properties used: ,

Politicians who died of cancer (of any type)

 * Items used: ,
 * Properties used:, ,

People born before year 1880 with no death date

 * Items used:
 * Properties used:, ,

Largest cities with female mayor

 * Items used: ,
 * Properties used:, , , , ,

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

 * Items used: ,
 * Properties used:, , , , ,

List of present-day countries and capital(s)

 * Items used:
 * Properties used: ,

How many states this US state borders

 * Items used:
 * Properties used: ,

Whose birthday is today?

 * Properties used:

Who discovered the most asteroids?

 * Items used:
 * Properties used: ,

Who discovered the most planets? (with list)

 * Items used:
 * Properties used:, ,

American universities founded before the states they reside in were created

 * Items used:.
 * Properties used:, , , ,

What is the relation between Terrell Buckley and Miami Dolphins?

 * Items used: ,

Properties that are defined as "qualifier only" but are used in references

 * Items used:
 * Properties used:

Aliases of properties which are used more than once

 * Items used: none
 * Properties used: all

WDQ queries: https://www.wikidata.org/wiki/Wikidata:List_of_queries

French people with an article on the English Wikipedia but not on the French one

 * Items used: ,
 * Properties used: ,

Number of scientists per gender

 * Items used: ,
 * Properties used:, ,

Mushers with neither a ranking in a race nor a reason for not finishing it

 * Items used:
 * Properties used:, , , , ,

Cats
Item used:

People born between 1895 and 1910 with no death date or other

 * Items used:
 * Properties used:, , , , ,

Which Lincoln was Lincoln named for?

 * Properties used: ,

How many horses are there? (basic count)

 * Properties used:
 * Items used:

How many horses are there of each sex? (basic count with GROUP BY)

 * Properties used:
 * Items used:

Label source #1: labels from SERVICE wikibase:label

 * Items used: ,
 * Properties used:, ,

Label source #2: labels from rdfs:label (same items as previous sample)

 * Items used: ,
 * Properties used:, ,

Label source #3: labels from skos:prefLabel (same items as previous sample)

 * Items used: ,
 * Properties used:, ,

Labels added after grouping (label from SERVICE wikibase:label)

 * Items used:
 * Properties used: ,

Labels for specific languages in comparison (labels from rdfs:label)

 * Items used:
 * Properties used:

Syntax sample #1: basic

 * Items used:
 * Properties used:

Syntax sample #2: without where, with semicolon

 * Items used:
 * Properties used:

Syntax sample #3: slash (/)

 * Items used:
 * Properties used:

Syntax sample #4: subject/object inverted (^)

 * Items used:
 * Properties used:

Syntax sample #5: prefixes expanded

 * Items used:
 * Properties used: