Wikidata:SPARQL query service/queries/examples
Jump to navigation
Jump to search
Try it!
Try it!
Horses on Wikidata
Try it!
Try it!
Try it!
Number of humans in Wikidata
Humans without children (only truthy values)
Humans without children (including non-truthy values)
Humans born in New York City
Try it!
Items with a Wikispecies sitelink
Items about authors with a Wikispecies page
Recent events
Popular eye colors among humans
Humans whose gender we know we don't know
URLs of Wikipedia in all languages
Try it!
Try it!
Try it!
Total population in the Øresund Region
Mayors that are any kind of domesticated animal
Try it!
Swedish lexemes that are missing in the biggest official printed Swedish dictionary SAOB.
Forms in Swedish that have no example demonstrating them
Lemmatize a word in English
The Swedish alphabet
Danish idioms
All forms in Swedish missing a pronunciation for the form with a representation identical to the lemma of the lexeme
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Lexemes by number of statements
Standard Mandarin Lexeme Forms missing Pinyin Transliteration
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
All languages with a Wikimedia language code (P424)
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Elevations over 8000 meter
Try it!
Try it!
Try it!
Try it!
Places in Antarctica over 3000km away from the South Pole
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Animals which are Threatened as per IUCN Red List
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Software applications ranked in descending order by the number of writable file formats
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
Map of institutions where Canadian citizens got their PhD - screenshot of the query results as of 2018-08-01.
 | Warning: Editing this page will change the examples shown on query.wikidata.org |
 | Please help to improve this page! Phabricator task T132690 |
| Feel free to add your example, or edit an existing one, if you think it is useful |
This page is parsed by the web interface of the query service to fill the query example dialog. Many of the examples also work in {{Wikidata list}} template calls parsed by the Listerbot, which however requires the ?item
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.
Some queries did not fit here because of technical restrictions:
- Advanced examples showcase more advanced functionality.
- Human examples have all kinds of human related queries.
- Maintenance examples help to curate all our items.
See also
Simple queries
These basic queries help to understand SPARQL and the Wikibase RDF format.
Cats
This query looks at all items whose value of instance of (P31) is house cat (Q146). It uses the service wikibase:label to return the labels in your default language or in English.
SELECT ?item ?itemLabel
WHERE
{
?item wdt:P31 wd:Q146. # Must be of a cat
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # Helps get the label in your language, if not, then en language
}
Goats
This query looks at all items whose value of instance of (P31) is goat (Q2934). It uses the service wikibase:label to return the labels in your default language or in English.
SELECT ?item ?itemLabel
WHERE
{
?item wdt:P31 wd:Q2934.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Horses (showing some info about them)
This query looks at items whose value of instance of (P31) is horse (Q726) or any subclass of (subclass of (P279)) horse (Q726). It displays the value of mother (P25), father (P22), sex or gender (P21) and computes birth year using date of birth (P569) death year using date of death (P570). Items are ordered using the horses qid.
#Illustrates optional fields, instances of subclasses, language fallback on label service, date to year conversion
#title: Horses on Wikidata
SELECT DISTINCT ?horse ?horseLabel ?mother ?motherLabel ?father ?fatherLabel (year(?birthdate) as ?birthyear) (year(?deathdate) as ?deathyear) ?genderLabel
WHERE
{
?horse wdt:P31/wdt:P279* wd:Q726 . # Instance et sous-classes de Q726-Cheval
OPTIONAL{?horse wdt:P25 ?mother .} # P25 : Mère
OPTIONAL{?horse wdt:P22 ?father .} # P22 : Père
OPTIONAL{?horse wdt:P569 ?birthdate .} # P569 : Date de naissance
OPTIONAL{?horse wdt:P570 ?deathdate .} # P570 : Date de décès
OPTIONAL{?horse wdt:P21 ?gender .} # P21 : Sexe
SERVICE wikibase:label { #BabelRainbow
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"
}
}
ORDER BY ?horse
Cats, with pictures
This query looks at all items with value of instance of (P31) equals to house cat (Q146) with a image (P18). The results are displayed as a gallery with the option '#defaultView:ImageGrid'.
#defaultView:ImageGrid
SELECT ?item ?itemLabel ?pic
WHERE
{
?item wdt:P31 wd:Q146 .
?item wdt:P18 ?pic
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
Map of hospitals
The query displays all items whose value of instance of (P31) is hospital (Q16917) or any subclass of (P279) of hospital (Q16917) with coordinate location (P625). The results are displayed on a map using 'defaultView:Map'.
#added 2017-08
#defaultView:Map
SELECT DISTINCT * WHERE {
?item wdt:P31/wdt:P279* wd:Q16917;
wdt:P625 ?geo .
}
Map of hackerspaces
The query displays on a map ("defaultView:Map") all items whose value of instance of (P31) is hackerspace (Q1032372) and with values for property coordinate location (P625).
Warnings:
- Items of class hackerspace (Q1032372) without any value for coordinate location (P625) are not returned in the query.
- Items which are instances of a subclass of hackerspace (Q1032372) are not returned.
#added 2021-12
#defaultView:Map
SELECT DISTINCT * WHERE {
?item wdt:P31 wd:Q1032372;
wdt:P625 ?geo .
}
Number of humans in Wikidata
This query takes all items whose value of instance of (P31) is human (Q5) and count the total number of items using COUNT function.
#title: Number of humans in Wikidata
SELECT (COUNT(*) AS ?count)
WHERE {
?item wdt:P31 wd:Q5 .
}
Humans without children
Only truthy values
In the simplest form (using only truthy[1] values):
#Demonstrates "no value" handling
#title: Humans without children (only truthy values)
SELECT ?human ?humanLabel
WHERE
{
?human wdt:P31 wd:Q5 . #find humans
?human rdf:type wdno:P40 . #with at least one truthy P40 (child) statement defined to be "no value"
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
Including non-truthy values
A similar query which also considers non-truthy (for example, values with deprecated rank) "no value" statements:
#title: Humans without children (including non-truthy values)
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" . }
}
Humans born in New York City
This example highlights the correct way to use the place of birth (P19) property, and by extension the place of death (P20) property. place of birth (P19) is the most specific known place of birth. For example, it is known that Donald Trump (Donald Trump (Q22686)) was born in the Jamaica Hospital (Jamaica Hospital Medical Center (Q23497866)) in New York City. Therefore, he wouldn't show up in direct query for humans born in New York City.
#title: Humans born in New York City
SELECT DISTINCT ?item ?itemLabel ?itemDescription ?sitelinks
WHERE {
?item wdt:P31 wd:Q5; # Any instance of a human
wdt:P19/wdt:P131* wd:Q60; # Who was born in any value (eg. a hospital)
# that has the property of 'administrative area of' New York City or New York City itself.
# Note that using wdt:P19 wd:Q60; # Who was born in New York City.
# Doesn't include humans with the birth place listed as a hospital
# or an administrative area or other location of New York City.
wikibase:sitelinks ?sitelinks.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
ORDER BY DESC(?sitelinks)
Humans who died on a specific date on the English Wikipedia, ordered by label
# Humans who died on August 25 2001 according to the English Wikipedia
SELECT ?item ?articlename ?itemLabel ?itemDescription ?sl
WHERE {
VALUES ?dod {"+2001-08-25"^^xsd:dateTime}
?dod ^wdt:P570 ?item .
?item wikibase:sitelinks ?sl .
?item ^schema:about ?article .
?article schema:isPartOf <https://en.wikipedia.org/>;
schema:name ?articlename .
SERVICE wikibase:label
{
bd:serviceParam wikibase:language "en" .
?item rdfs:label ?itemLabel .
?item schema:description ?itemDescription .
}
BIND(REPLACE(?itemLabel, "^.*(?<! [Vv][ao]n| [Dd][aeiu]| [Dd][e][lns]| [Ll][ae]) (?!([SJ]r\\.?|[XVI]+)$)", "") AS ?sortname)
} ORDER BY ASC(UCASE(?sortname)) ASC(UCASE(?itemLabel))
Items with a Wikispecies sitelink
#illustrates sitelink selection, ";" notation
#title: Items with a Wikispecies sitelink
SELECT ?item ?itemLabel ?article
WITH {
SELECT *
WHERE {
?article schema:about ?item ;
schema:isPartOf <https://species.wikimedia.org/> .
}
LIMIT 200
} AS %i
WHERE {
INCLUDE %i
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
}
Items about authors with a Wikispecies page
 | This page is outdated. |
#title: Items about authors with a Wikispecies page
SELECT ?author ?authorLabel ?count
WITH {
SELECT ?author (COUNT(?paper) AS ?count)
WHERE {
?article schema:about ?author ;
schema:isPartOf <https://species.wikimedia.org/> .
?author wdt:P31 wd:Q5.
?paper wdt:P50 ?author.
}
GROUP BY ?author
ORDER BY DESC(?count)
LIMIT 200
} AS %i
WHERE {
INCLUDE %i
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
}
ORDER BY DESC(?count)
Recent events
#title: Recent events
SELECT ?event ?eventLabel ?date
WITH {
SELECT DISTINCT ?event ?date
WHERE {
# find events
?event wdt:P31/wdt:P279* wd:Q1190554.
# with a point in time or start date
OPTIONAL { ?event wdt:P585 ?date. }
OPTIONAL { ?event wdt:P580 ?date. }
# but at least one of those
FILTER(BOUND(?date) && DATATYPE(?date) = xsd:dateTime).
# not in the future, and not more than 31 days ago
BIND(NOW() - ?date AS ?distance).
FILTER(0 <= ?distance && ?distance < 31).
}
LIMIT 150
} AS %i
WHERE {
INCLUDE %i
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
}
Popular eye colors among humans
#title:Popular eye colors among humans
#illustrates bubblechart view, count
#defaultView:BubbleChart
SELECT ?eyeColor ?eyeColorLabel ?rgb (COUNT(?human) AS ?count)
WHERE
{
?human wdt:P31 wd:Q5.
?human wdt:P1340 ?eyeColor.
OPTIONAL { ?eyeColor wdt:P465 ?rgb. }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?eyeColor ?eyeColorLabel ?rgb
ORDER BY DESC(?count)
Humans whose gender we know we don't know
#title: Humans whose gender we know we don't know
# Demonstrates filtering for "unknown value"
SELECT ?human ?humanLabel
WHERE
{
?human wdt:P21 ?gender .
FILTER wikibase:isSomeValue(?gender)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
URLs of Wikipedia in all languages
This query provides an alternative to scraping the Wikipedia.org portal page and various lists/tables of Wikipedias that are out there. (The sitematrix API is another alternative.)
#title: URLs of Wikipedia in all languages
SELECT ?wikipedia WHERE {
?wikipedia wikibase:wikiGroup "wikipedia".
}
Names of Wikipedia articles in multiple languages
The query retrieves Wikipedia article names (in the main namespace) in various languages for the given Q identity. Labels are returned instead of real article names.
SELECT DISTINCT ?lang ?name WHERE {
?article schema:about wd:Q5 . hint:Prior hint:runFirst true.
?article schema:inLanguage ?lang ;
schema:name ?name ;
schema:isPartOf [ wikibase:wikiGroup "wikipedia" ] .
FILTER(?lang in ('en', 'uz', 'ru', 'ko')) .
FILTER (!CONTAINS(?name, ':')) .
}
All items with a property
# Sample to query all values of a property
# Property talk pages on Wikidata include basic queries adapted to each property
SELECT
?item ?itemLabel
?value ?valueLabel
# valueLabel is only useful for properties with item-datatype
WHERE
{
?item wdt:P1800 ?value
# change P1800 to another property
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
# remove or change limit for more results
LIMIT 10
Wikidata items of Wikipedia articles
#Returns a list of Wikidata items for a given list of Wikipedia article names
#List of Wikipedia article names (lemma) is like "WIKIPEDIA ARTICLE NAME"@LANGUAGE CODE with de for German, en for English, etc.
#Language version and project is defined in schema:isPartOF with de.wikipedia.org for German Wikipedia, es.wikivoyage for Spanish Wikivoyage, etc.
SELECT ?lemma ?item WHERE {
VALUES ?lemma {
"Wikipedia"@de
"Wikidata"@de
"Berlin"@de
"Technische Universität Berlin"@de
}
?sitelink schema:about ?item;
schema:isPartOf <https://de.wikipedia.org/>;
schema:name ?lemma.
}
Total population in the Øresund Region
#title: Total population in the Øresund Region
# Illustrates the SUM aggregate function
SELECT DISTINCT ?area ?areaLabel (sum(?folkm_ngd) as ?total_folkm) # the first two variables can be removed
# if only the number is needed
WHERE {
?item wdt:P361 wd:Q297853. # part of (P361) Øresund Region (Q297853)
?item wdt:P1082 ?folkm_ngd. # population (P1082)
?area wdt:P31 wd:Q1907114. # instance of (P31) metropolitan area (Q1907114)
?area wdt:P527 ?item. # has part (P527)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?area ?areaLabel
Mayors that are any kind of domesticated animal
#title: Mayors that are any kind of domesticated animal
SELECT ?image ?speciesLabel ?mayorLabel ?placeLabel WHERE {
?species wdt:P279* wd:Q622852 .
?mayor wdt:P31 ?species .
?mayor p:P39 ?node .
?node ps:P39 wd:Q30185 .
?node pq:P642 ?place .
OPTIONAL {?mayor wdt:P18 ?image}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Mayors that are either a dog, a cat or a chicken
Illustrates the VALUES clause.
SELECT ?image ?speciesLabel ?mayorLabel ?placeLabel WHERE {
VALUES ?species {wd:Q144 wd:Q146 wd:Q780}
?mayor wdt:P31 ?species .
?mayor p:P39 ?node .
?node ps:P39 wd:Q30185 .
?node pq:P642 ?place .
OPTIONAL {?mayor wdt:P18 ?image}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Lexeme queries
Swedish lexemes missing in SAOB
#title:Swedish lexemes that are missing in the biggest official printed Swedish dictionary SAOB.
#date: 2021-10-12
#author:So9q
SELECT ?lemma
WHERE {
?lexemeId dct:language wd:Q9027;
wikibase:lemma ?lemma;
wdt:P9660 wd:Q1935308.
}
Forms in Swedish that have no example demonstrating them
#title:Forms in Swedish that have no example demonstrating them
# 2021-08-06
SELECT ?form ?lemma
WHERE {
?lexemeId dct:language wd:Q9027;
wikibase:lemma ?lemma;
ontolex:lexicalForm ?form.
MINUS {
?lexemeId p:P5831 ?statement.
?statement ps:P5831 ?example;
pq:P6072 [];
pq:P5830 ?form_with_example.
}
}
Lemmatize a word in English
#title:Lemmatize a word in English
# Author: So9q
# 2021-07-25
# inspired by https://sinaahmadi.github.io/posts/10-essential-sparql-queries-for-lexicographical-data-on-wikidata.html
SELECT DISTINCT ?l ?word ?lemma WHERE {
VALUES ?word {'bought'@en}
?l a ontolex:LexicalEntry ;
dct:language wd:Q1860 ;
wikibase:lemma ?lemma ;
ontolex:lexicalForm ?form .
?form ontolex:representation ?word .
}
The Swedish alphabet
#title:The Swedish alphabet
# Author: So9q
# 2021-07-22
SELECT ?lexemeId ?lemma WHERE {
?lexemeId dct:language wd:Q9027;
wikibase:lemma ?lemma.
?lexemeId wikibase:lexicalCategory wd:Q9788
}
ORDER BY ?lemma
Danish idioms
#title:Danish idioms
# Author: So9q
# Date: 2021-04-11
SELECT ?l ?lemma WHERE {
?l dct:language wd:Q9035; # Danish (Q9035)
wikibase:lemma ?lemma;
wikibase:lexicalCategory wd:Q184511. # idiom (Q184511)
}
All forms in Swedish missing a pronunciation for the form with a representation identical to the lemma of the lexeme
#title:All forms in Swedish missing a pronunciation for the form with a representation identical to the lemma of the lexeme
# So9q 13-01-2021
SELECT ?l ?lemma ?form ?audio WHERE {
?l dct:language wd:Q9027;
wikibase:lemma ?lemma;
ontolex:lexicalForm ?form .
?form ontolex:representation ?lemma .
MINUS {?form wdt:P443 ?audio.}
}
Lexemes in English that match an expression
# Lexemes in English that match an expression
SELECT ?lexemeId ?lemma WHERE {
?lexemeId dct:language wd:Q1860;
wikibase:lemma ?lemma.
# only those lemmas that begin with "pota", i.e. "potato"
FILTER (regex(?lemma, '^pota.*'))
}
Lexemes in Swedish with usage example that demonstrates both a form and a sense
#Lexemes in Swedish with usage example that demonstrates both a form and a sense
# So9q 23-12-2020
SELECT ?lexemeId ?lemma ?example
WHERE {
?lexemeId <http://purl.org/dc/terms/language> wd:Q9027;
wikibase:lemma ?lemma.
?lexemeId p:P5831 ?statement.
?statement ps:P5831 ?example;
pq:P6072 [];
pq:P5830 [].
}
Pictures of noun lexemes in English (picture dictionary à la Wikidata)
# Lexemes in English with picture and description fetched from the concept Q-item
# NB: when 2 or more pictures occur for the same lemma a preferred rank is missing on the Q-item.
# Please fix that if you know how.
# by So9q
#defaultView:ImageGrid
SELECT DISTINCT ?lexemeId ?lemma ?q_concept ?q_conceptDescription ?picture
WHERE {
?lexemeId dct:language wd:Q1860;
wikibase:lemma ?lemma;
ontolex:sense ?sense.
?sense wdt:P5137 ?q_concept.
?q_concept wdt:P18 ?picture.
# if you wish to only browse certain items you can insert a FILTER
# regular expression here, like in the example above.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY lcase(?lemma) # order a-z
German picture dictionary for young children
# German picture dictionary for young children
# NB: when 2 or more pictures occur for the same lemma a preferred rank is missing on the Q-item.
# Please fix that if you know how.
# If any inapproriate terms show up it is probably because the sense is missing a correct P5137
# by So9q
#defaultView:ImageGrid
SELECT DISTINCT ?lexemeId ?lemma ?q_concept ?q_conceptDescription ?picture
WHERE {
?lexemeId dct:language wd:Q188; # change language here
wikibase:lemma ?lemma;
ontolex:sense ?sense.
?sense wdt:P5137 ?q_concept.
?q_concept wdt:P18 ?picture.
############
# Exclusions
############
# Exclude out of scope concepts
MINUS {?q_concept wdt:P31 wd:Q3624078.}. # countries
# Exclude non suitable concepts
VALUES ?minus {
wd:Q47092 # rape
wd:Q198 # war
wd:Q124490 # violence
wd:Q170382 # revolver
wd:Q1576 #cigar
#... add yours here
}.
MINUS {?sense wdt:P5137 ?minus.}.
# Exclude senses not suitable for young children:
VALUES ?filter {
wd:Q8102
wd:Q545779
wd:Q1521634
wd:Q184439}.
FILTER NOT EXISTS {?sense wdt:P6191 ?filter.}.
# if you wish to only browse certain items you can insert a FILTER
# regular expression here, like in the example above.
SERVICE wikibase:label { bd:serviceParam wikibase:language "de,en". }
}
ORDER BY lcase(?lemma) # order a-z
Lexeme languages by number of usage examples
# Lexeme languages by number of usage examples
# by Vesihiisi
# improved by So9q 23-20-2020 to only show those with both a form and a sense,
# because that's what we really want
#defaultView:BubbleChart
SELECT ?languageLabel (COUNT(?example) AS ?count ) WHERE {
?l a ontolex:LexicalEntry; dct:language ?language.
?l p:P5831 ?statement.
?statement ps:P5831 ?example;
pq:P6072 [];
pq:P5830 [].
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?languageLabel
ORDER BY DESC(?count)
Lexemes describing a color
# Lexemes describing a color
# By Vesihiisi
SELECT ?l ?lemma ?languageLabel WHERE {
?l a ontolex:LexicalEntry;
dct:language ?language;
wikibase:lemma ?lemma .
?l wdt:P31 wd:Q376431.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?languageLabel
Lexemes that means water ordered by language
# By So9q
# Lexemes that means (liquid) water
SELECT ?l ?sense ?lemma ?languageLabel WHERE {
?l a ontolex:LexicalEntry ; # get from the special LexicalEntry
ontolex:sense ?sense ; # the sense
dct:language ?language ; # the language
wikibase:lemma ?lemma. # and the lemma
?sense wdt:P5137 wd:Q29053744 .
# change Q29053744 to anything you want
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
# Lower case before order
ORDER BY (LCASE(?languageLabel))
The 100 most translated concepts in the Lexeme namespace
# by So9q, 2019-11-21
#defaultView:BubbleChart
SELECT ?meaning ?meaningLabel ?count
WITH {
SELECT ?meaning (count(?l) as ?count)
WHERE {
?l a ontolex:LexicalEntry ;
ontolex:sense ?sense.
?sense wdt:P5137 ?meaning.
}
GROUP BY ?meaning
ORDER BY desc(?count)
LIMIT 100
} AS %i
WHERE {
INCLUDE %i
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
}
ORDER BY desc(?count)
Demonyms on map
# Words describing people from a certain place
# e.g. swede
# by Vesihiisi
#defaultView:Map
SELECT ?l ?lemma ?demoPlaceLabel ?coords WHERE {
?l a ontolex:LexicalEntry ;
dct:language ?language ;
wikibase:lemma ?lemma .
?language wdt:P218 'sv'. # language
?l ontolex:sense ?sense.
?sense wdt:P6271 ?demoPlace.
?demoPlace wdt:P625 ?coords
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Forms in Hebrew that are both feminine and masculine
# Forms of nouns in Hebrew that are both feminine and masculine
# e.g. ???
# by Uziel302
SELECT ?lexemeId ?lemma ?form ?word WHERE {
?lexemeId dct:language wd:Q9288;
wikibase:lexicalCategory wd:Q1084;
wikibase:lemma ?lemma.
?lexemeId ontolex:lexicalForm ?form .
?form wikibase:grammaticalFeature wd:Q499327;
wikibase:grammaticalFeature wd:Q1775415;
ontolex:representation ?word .
}
Lexemes by number of statements
#title:Lexemes by number of statements
#author:Nikki 2021-09-15
SELECT * {
?l dct:language [];
wikibase:statements ?c.
}
ORDER BY desc(?c) LIMIT 50
Standard Mandarin Lexeme Forms missing Pinyin Transliteration
#title:Standard Mandarin Lexeme Forms missing Pinyin Transliteration
#author:0xDeadbeef 2022-07-31
SELECT ?lexemeId ?lemma ?form ?word WHERE {
?lexemeId dct:language wd:Q727694;
wikibase:lemma ?lemma;
ontolex:lexicalForm ?form.
?form ontolex:representation ?word.
FILTER(NOT EXISTS { ?form wdt:P1721 ?o. })
}
Wikibase predicates
Properties
Properties grouped by their parent property
#Properties grouped by their parent property
#TODO: should display links and numeric ids
#defaultView:Tree
SELECT ?property2 ?property2Label ?property1 ?property1Label WHERE {
?property1 rdf:type wikibase:Property. #not replaceable with wikibase:Item, wikibase:Statement, wikibase:Reference at WDQS
#https://www.mediawiki.org/wiki/Wikibase/Indexing/RDF_Dump_Format#WDQS_data_differences
?property1 wdt:P1647 ?property2.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Subproperties of location (P276)
#Subproperties of location (P276)
SELECT DISTINCT ?subProperties ?subPropertiesLabel WHERE {
?subProperties wdt:P1647* wd:P276.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Properties grouped by their Wikibase datatype (Q19798645) with number of properties
#Properties grouped by their type with number of properties
SELECT (COUNT(?property) as ?pcount ) ?wbtype WHERE {
?property rdf:type wikibase:Property.
?property wikibase:propertyType ?wbtype.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?wbtype
ORDER BY DESC(?pcount)
properties used to link to instances of technical standard (Q317623)
#properties used to link to instances of technical standard
SELECT DISTINCT ?propertyRel ?propertyItem ?propertyItemLabel WHERE
{
?item ?propertyRel ?standard.
?standard wdt:P31 wd:Q317623.
?propertyItem wikibase:directClaim ?propertyRel
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
All properties with descriptions and aliases and types
SELECT ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel WHERE {
?property wikibase:propertyType ?propertyType .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))
Properties connecting items of type zoo (Q43501) with items of type animal (Q729)
SELECT ?p ?pLabel (count (*) as ?count) {
?s ?pd ?o .
?p wikibase:directClaim ?pd .
?s wdt:P31/wdt:P279* wd:Q729 .
?o wdt:P31/wdt:P279* wd:Q43501 .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?p ?pLabel ORDER BY desc(?count)
Identifier properties present on one item, but absent on another
#added November 1, 2020 (76 ids then)
#TEMPLATE={ "template":"Identifiers present on the item for Penelope Cruz, but not on the item for Sean Connery"}
SELECT
?p ?pLabel
(SAMPLE(?url) as ?url_comp2)
WHERE
{
hint:Query hint:optimizer "None".
BIND( wd:Q4573 as ?comp1)
BIND( wd:Q39666 as ?comp2)
{
?comp2 ?wdt ?v .
?p wikibase:directClaim ?wdt ; wikibase:propertyType wikibase:ExternalId .
FILTER NOT EXISTS { ?comp1 ?wdt [] }
OPTIONAL { ?p wdt:P1630 ?f }
BIND(uri(REPLACE(?f,"\\$1",?v)) as ?url)
}
UNION { BIND(wd:Q4573 as ?p) }
UNION { BIND(wd:Q39666 as ?p) }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?p ?pLabel
ORDER BY ?url_comp2
A 7 level inverse tree (of Property categories)
#defaultView:Tree
SELECT ?root ?rootLabel ?item ?itemL ?itemImage ?item2 ?itemL2 ?itemImage2 ?item3 ?itemL3 ?itemImage3 ?item4 ?itemL4 ?itemImage4 ?item5 ?itemL5 ?itemImage5 ?item6 ?itemL6 ?itemImage6 ?item7 ?itemL7 ?itemImage7 WHERE {
BIND(wd:Q18616576 AS ?root)
BIND(wdt:P279 AS ?property)
?item ?property ?root.
OPTIONAL { ?item wdt:P18 ?itemImage. }
OPTIONAL {
?item2 ?property ?item.
OPTIONAL { ?item2 wdt:P18 ?itemImage2. }
OPTIONAL {
?item3 ?property ?item2.
OPTIONAL { ?item3 wdt:P18 ?itemImage3. }
OPTIONAL {
?item4 ?property ?item3.
OPTIONAL { ?item4 wdt:P18 ?itemImage4. }
OPTIONAL {
?item5 ?property ?item4.
OPTIONAL { ?item5 wdt:P18 ?itemImage5. }
OPTIONAL {
?item6 ?property ?item5.
OPTIONAL { ?item6 wdt:P18 ?itemImage6. }
OPTIONAL {
?item7 ?property ?item6.
OPTIONAL { ?item7 wdt:P18 ?itemImage7. }
}
}
}
}
}
}
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,es,fr,de".
?root rdfs:label ?rootLabel.
?item rdfs:label ?itemLabel;
schema:description ?itemDescription.
?item2 rdfs:label ?itemLabel2;
schema:description ?itemDescription2.
?item3 rdfs:label ?itemLabel3;
schema:description ?itemDescription3.
?item4 rdfs:label ?itemLabel4;
schema:description ?itemDescription4.
?item5 rdfs:label ?itemLabel5;
schema:description ?itemDescription5.
?item6 rdfs:label ?itemLabel6;
schema:description ?itemDescription6.
?item7 rdfs:label ?itemLabel7;
schema:description ?itemDescription7.
}
BIND(CONCAT(?itemLabel, ": ", COALESCE(?itemDescription, "")) AS ?itemL)
BIND(CONCAT(?itemLabel2, ": ", COALESCE(?itemDescription2, "")) AS ?itemL2)
BIND(CONCAT(?itemLabel3, ": ", COALESCE(?itemDescription3, "")) AS ?itemL3)
BIND(CONCAT(?itemLabel4, ": ", COALESCE(?itemDescription4, "")) AS ?itemL4)
BIND(CONCAT(?itemLabel5, ": ", COALESCE(?itemDescription5, "")) AS ?itemL5)
BIND(CONCAT(?itemLabel6, ": ", COALESCE(?itemDescription6, "")) AS ?itemL6)
BIND(CONCAT(?itemLabel7, ": ", COALESCE(?itemDescription7, "")) AS ?itemL7)
}
ORDER BY (?itemL) (?itemL2) (?itemL3) (?itemL4) (?itemL5) (?itemL6) (?itemL7)
LIMIT 20000
Properties likely missing type constraints
# All properties whose values are items and which lack a type constraint and property scope constraint.
# Some of these may be actually general properties, while others just don't have their relevant type constraint defined yet.
#
# The lack of property scope constraint just identifies high priority ones, as that constraint is always required, so
# if it is missing, it makes it more likely that there is a reasonable type constraint that just hasn't been defined.
SELECT ?property (GROUP_CONCAT(?propertyCategoryLabel; SEPARATOR = "; ") AS ?categories) ?propertyLabel ?propertyDescription ?propertyAltLabel WHERE {
{
SELECT ?property ?propertyCategoryLabel ?propertyLabel ?propertyDescription ?propertyAltLabel WHERE {
?property wikibase:propertyType wikibase:WikibaseItem.
MINUS { ?property wdt:P2302 wd:Q21503250. }
MINUS { ?property wdt:P2302 wd:Q53869507. }
OPTIONAL { ?property wdt:P31 ?propertyCategory. }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
}
}
GROUP BY ?property ?propertyLabel ?propertyDescription ?propertyAltLabel
References
Content of a reference for a specific statement
# See also the SPARQL manual
# https://en.wikibooks.org/wiki/SPARQL/WIKIDATA_Qualifiers,_References_and_Ranks
# In this example we look for statements which assign a specific value (Q51955019)
# to the property P1343 and then look for references of that property, specifically
# the string associated to P958 for the reference. May actually bring up references
# for other P1343 statements; uses the shortened expression syntax with brackets.
SELECT ?item ?reference
WHERE {
?item wdt:P1343 wd:Q51955019 .
?item p:P1343 [ prov:wasDerivedFrom [ pr:P958 ?reference ] ] .
}
Subclasses
Some classes with both physical and non-physical super-classes
# This gives a list of classes whose super-classes include both "physical entity" and "non-physical entity".
# One of these is, presumably, in error.
# Due to timeouts, it is necessary to explicitly limit the depth.
SELECT DISTINCT ?item ?itemLabel WHERE {
{
SELECT ?item WHERE { ?item (wdt:P279/wdt:P279/(wdt:P279?)/(wdt:P279?)/(wdt:P279?)) wd:Q7048977, wd:Q112276019. }
LIMIT 300
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,es,fr,de". }
}
ORDER BY (?itemLabel)
Wikimedia projects
See also: Help:Sitelinks
Countries that have sitelinks to en.wiki
SELECT ?country ?countryLabel ?article WHERE {
?country wdt:P31 wd:Q3624078 . # sovereign state
?article schema:about ?country .
?article schema:isPartOf <https://en.wikipedia.org/>.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en"
}
}
Canadian subjects with no English article in Wikipedia
#added before 2019-02
SELECT ?item ?itemLabel ?cnt WHERE {
{
SELECT ?item (COUNT(?sitelink) AS ?cnt) WHERE {
?item wdt:P27|wdt:P205|wdt:P17 wd:Q16 . #Canadian subjects.
MINUS {?item wdt:P106 wd:Q488111 .} #Minus occupations that would be inappropriate in most situations.
MINUS {?item wdt:P106 wd:Q3286043 .}
MINUS {?item wdt:P106 wd:Q4610556 .}
?sitelink schema:about ?item .
FILTER NOT EXISTS {
?article schema:about ?item .
?article schema:isPartOf <https://en.wikipedia.org/> . #Targeting Wikipedia language where subjects has no article.
}
} GROUP BY ?item ORDER BY DESC (?cnt) LIMIT 1000 #Sorted by amount of articles in other languages. Result limited to 1000 lines to not have a timeout error.
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,fr,es,de" } #Service to resolve labels in (fallback) languages: automatic user language, English, French, Spanish, German.
} ORDER BY DESC (?cnt)
Countries that have a Featured Article on Russian Wikipedia
SELECT ?sitelink ?itemLabel WHERE {
?item wdt:P31 wd:Q6256.
?sitelink schema:isPartOf <https://ru.wikipedia.org/>;
schema:about ?item;
wikibase:badge wd:Q17437796 . # Sitelink is badged as a Featured Article
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } .
} ORDER BY ?itemLabel
Numbers of Wikipedia sitelinks for items with Art UK artist ID (P1367) for each language
SELECT ?lang (COUNT(DISTINCT ?article) AS ?count) WHERE {
hint:Query hint:optimizer "None".
?item wdt:P1367 ?yp_id .
?article schema:about ?item . # find articles about things with a BBC 'Your paintings' artist identifier
?article schema:isPartOf / wikibase:wikiGroup "wikipedia" . # only Wikipedias articles
hint:Prior hint:gearing "forward" .
# This hint says to search the property chain above from left to right ("forward"),
# i.e. it is checked if each previously found value for ?article is linked to a Wikipedia.
# The default ("reverse") would be to search it from right to left, i.e. find all Wikipedia
# articles first, and then select the intersection with the previously found values of ?article.
?article schema:inLanguage ?lang .
} GROUP BY ?lang
ORDER BY DESC (?count)
Titles of articles about Ukrainian villages on Romanian Wikipedia
#Show titles of articles about Ukrainian villages on Romanian Wikipedia, plus English and Ukrainian labels in Wikidata items
#added in 2017-05
SELECT DISTINCT ?item ?LabelEN ?LabelUK ?page_titleRO WHERE {
?item wdt:P31 wd:Q532 .
?item wdt:P17 wd:Q212 .
?article schema:about ?item ; schema:isPartOf <https://ro.wikipedia.org/> ; schema:name ?page_titleRO .
?item rdfs:label ?LabelEN FILTER (lang(?LabelEN) = "en") .
?item rdfs:label ?LabelUK FILTER (lang(?LabelUK) = "uk") .
}
LIMIT 300
Wikisource pages for authors of scientific articles
#Wikisource pages for authors of scientific articles, ordered by Wikisource language
#added in 2017-09
SELECT DISTINCT ?item ?wikisourceSitelink ?wikisourceLanguage WHERE {
?wikisourceSitelink schema:isPartOf [ wikibase:wikiGroup "wikisource" ];
schema:inLanguage ?wikisourceLanguage;
schema:about ?item.
?paper wdt:P31 wd:Q13442814;
wdt:P50 ?item.
}
ORDER BY ?wikisourceLanguage
LIMIT 300
Items with a GTAA id and their articles on the Dutch and English Wikipedia
SELECT ?item ?itemLabel ?gtaa ?_articleEN ?_articleNL where {
?item wdt:P1741 ?gtaa. # GTAA id
OPTIONAL {
?_articleEN schema:about ?item.
?_articleNL schema:about ?item.
?_articleEN schema:isPartOf <https://en.wikipedia.org/>.
?_articleNL schema:isPartOf <https://nl.wikipedia.org/>.
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,nl". }
}
People deceased in 2018 ordered by the number of sitelinks
SELECT ?person ?personLabel ?died ?sitelinks
WITH {
SELECT *
WHERE {
?person wdt:P31 wd:Q5;
wdt:P570 ?died.
FILTER (?died >= "2018-01-01T00:00:00Z"^^xsd:dateTime && ?died < "2019-01-01T00:00:00Z"^^xsd:dateTime)
?person wikibase:sitelinks ?sitelinks.
}
ORDER BY desc(?sitelinks)
LIMIT 100
} AS %i
WHERE {
INCLUDE %i
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
}
ORDER BY desc(?sitelinks)
List of small monuments and other similar sites with link to Commons category (sitelink or P373)
SELECT ?item ?comm ?p373 ?cat WHERE {
?item wdt:P131* wd:Q894107. # ... municipality ...
OPTIONAL {?comm schema:about ?item ; schema:isPartOf <https://commons.wikimedia.org/> .}
BIND(replace(wikibase:decodeUri(SUBSTR(STR(?comm), 45)),"_"," ") AS ?comm_decode)
OPTIONAL {?item wdt:P373 ?p373 .}
bind(COALESCE(?comm_decode, ?p373) as ?cat) .
VALUES ?trida { wd:Q1746392 wd:Q108325 wd:Q4989906 wd:Q10861631 wd:Q15077340 wd:Q1516537 wd:Q47008262} # chapel, small monument, memorial, belltower, memorial monument, technical monument, group of small monuments
?item wdt:P31/wdt:P279* ?trida. # small monument
}
Most famous child of a librarian
#Children of librarians with the most number of sitelinks (as a proxy for fame)
SELECT ?person ?personLabel ?parentLabel ?linkcount WHERE {
?parent wdt:P106 wd:Q182436 .
?parent wdt:P40 ?person .
?person wikibase:sitelinks ?linkcount .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de,es,ar,fr" }
}
GROUP BY ?linkcount ?person ?personLabel ?parent ?parentLabel
ORDER BY DESC(?linkcount)
All languages with a Wikimedia language code (P424)
#title: All languages with a Wikimedia language code (P424)
# Date: 2021-09-24
SELECT DISTINCT ?lang_code ?itemLabel ?item
WHERE
{
# ?lang is one of these options
VALUES ?lang {
wd:Q34770 # language
wd:Q436240 # ancient language
wd:Q1288568 # modern language
wd:Q33215 # constructed language
}
?item wdt:P31 ?lang ;
# get the language code
wdt:P424 ?lang_code .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY ?lang_code
All Wikipedia sites
# Get all Wikipedia sites
SELECT ?item ?itemLabel ?website
WHERE
{
#?item wdt:P31 wd:Q10876391.
?item wdt:P856 ?website.
?website wikibase:wikiGroup "wikipedia".
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Featured articles of all Wikimedia projects
# Get all Featured Articles (Q17437796)
SELECT ?lang ?name ?itemLabel ?sitelink ?linkcount ?item WHERE {
?item wikibase:sitelinks ?linkcount.
?sitelink schema:name ?name;
schema:inLanguage ?lang;
schema:about ?item;
# Sitelink is badged as a Featured Article
wikibase:badge wd:Q17437796.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
People born in Lisbon without articles on ptwiki but with articles on other Wikipedias
# People born in Lisbon that don't have an article on Portuguese Wikipedia
# but do have an article on other Wikipedias.
SELECT DISTINCT ?person ?personLabel WHERE
{
?person wdt:P31 wd:Q5. # Instance of human
?person (wdt:P19|wdt:P20)/wdt:P131* wd:Q597. # Born or died in Lisbon (or anywhere within)
MINUS { ?ptArticle schema:about ?person; schema:isPartOf <https://pt.wikipedia.org/>. } # No article on pt.wiki
?anyArticle schema:about ?person; schema:isPartOf/wikibase:wikiGroup "wikipedia". # Do have (some) Wikipedia article
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],pt,en". }
}
Geography
Countries
List of present-day countries and capital(s)
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
UN member states
SELECT DISTINCT ?state WHERE {
?state wdt:P31/wdt:P279* wd:Q3624078;
p:P463 ?memberOfStatement.
?memberOfStatement a wikibase:BestRank;
ps:P463 wd:Q1065.
MINUS { ?memberOfStatement pq:P582 ?endTime. }
MINUS { ?state wdt:P576|wdt:P582 ?end. }
}
Largest cities per country
- Items used: city (Q515)
- Properties used: instance of (P31) subclass of (P279) population (P1082) coordinate location (P625) country (P17)
#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" .
}
}
ORDER BY DESC(?population)
Wikidata people per million inhabitants for all EU countries
#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 {
wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity
# 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)
Papers about Wikidata
- Items used: article (Q191067) Wikidata (Q2013)
- Properties used: instance of (P31) subclass of (P279) main subject (P921)
#papers about Wikidata
SELECT ?item ?itemLabel
WHERE {
?item wdt:P921 wd:Q2013. hint:Prior hint:runFirst true.
?item wdt:P31/wdt:P279* wd:Q191067.
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
LIMIT 100
Countries sorted by population
- Items used: country (Q6256)
- Properties used: instance of (P31) population (P1082)
# 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)
Country populations together with total city populations
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
Names of African countries in all their official languages and English
SELECT DISTINCT ?item ?itemLabel_ol ?official_language ?itemLabel_en WHERE {
?item wdt:P30 wd:Q15 ;
wdt:P37 ?officiallanguage ;
wdt:P31 wd:Q6256 .
?officiallanguage wdt:P424 ?langcode .
?item rdfs:label ?itemLabel_ol . FILTER(lang(?itemLabel_ol)=?langcode)
?item rdfs:label ?itemLabel_en . FILTER(lang(?itemLabel_en)='en')
?officiallanguage rdfs:label ?official_language . FILTER(lang(?official_language)='en')
}
ORDER BY ?item ?itemLabel_ol ?official_language
Languages and dialects spoken in the Netherlands with their optional Wikipedia editions
SELECT DISTINCT ?language ?languageLabel ?wikipediaLabel where {
?language wdt:P31 ?instance;
wdt:P17 wd:Q55.
FILTER (?instance in (wd:Q34770, wd:Q33384)).
OPTIONAL {
?wikipedia wdt:P31 wd:Q10876391;
wdt:P407 ?language.
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "nl,en". }
} GROUP BY ?language ?languageLabel ?wikipediaLabel
Cities
Population of cities and towns in Denmark and their OSM relation id
# Population of cities and towns in Denmark and their OSM relation id
# This shows a simple OR using VALUES and a variable
SELECT ?city ?cityLabel ?population ?OSM_relation_ID WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
VALUES ?town_or_city {
wd:Q3957
wd:Q515
}
?city (wdt:P31/(wdt:P279*)) ?town_or_city;
wdt:P17 wd:Q35.
OPTIONAL { ?city wdt:P1082 ?population. }
OPTIONAL { ?city wdt:P402 ?OSM_relation_ID. }
}
LIMIT 100
Former capitals
- Properties used: capital (P36) coordinate location (P625) end time (P582) dissolved, abolished or demolished date (P576)
#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". }
}
Largest cities of the world
#defaultView:BubbleChart
SELECT ?cityLabel ?population ?gps
WITH {
SELECT DISTINCT *
WHERE {
?city wdt:P31/wdt:P279* wd:Q515 .
?city wdt:P1082 ?population .
?city wdt:P625 ?gps .
}
ORDER BY DESC(?population)
LIMIT 100
} AS %i
WHERE {
INCLUDE %i
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
}
ORDER BY DESC(?population)
Cities as big as Eindhoven give or take 1000
#defaultView:Map
SELECT ?city ?cityLabel ?location ?populatie2 WHERE {
{ SELECT DISTINCT * 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 "[AUTO_LANGUAGE],nl" }
}
Where in the world is Antwerp
| This page is outdated. |
#defaultView:Map
SELECT DISTINCT ?settlement ?name ?coor
WHERE
{
?subclass_settlement wdt:P279+ wd:Q486972 .
?settlement wdt:P31 ?subclass_settlement ;
wdt:P625 ?coor ;
rdfs:label ?name .
FILTER regex(?name, "Antwerp", "i")
}
Destinations from Antwerp International airport
#defaultView:Map
SELECT ?connectsairport ?connectsairportLabel ?place_served ?place_servedLabel ?coor
WHERE
{
VALUES ?airport { wd:Q17480 } # Antwerp international airport wd:Q17480
?airport wdt:P81 ?connectsairport ;
wdt:P625 ?base_airport_coor .
?connectsairport wdt:P931 ?place_served ;
wdt:P625 ?coor .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Cities connected by the European route E40
#defaultView:Map
SELECT ?city ?cityLabel ?coordinates
WHERE
{
VALUES ?highway {wd:Q327162 }
?highway wdt:P2789 ?city .
?city wdt:P625 ?coordinates .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Cities connected by the Trans-Mongolian and Trans-Siberian Railway
#defaultView:Map
SELECT ?city ?cityLabel ?coordinates
WHERE
{
VALUES ?highway { wd:Q559037 wd:Q58767 }
?highway wdt:P2789 ?city .
?city wdt:P625 ?coordinates .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Metro station of city with template
#TEMPLATE={"template":"metro station of ?city","variables":{"?city":{"query":"SELECT DISTINCT ?cityLabel where {?city wdt:P31/wdt:P279* wd:Q1637706. SERVICE wikibase:label { bd:serviceParam wikibase:language \"[AUTO_LANGUAGE]\"} }"} } }
#defaultView:Map{"hide":["?comm1Label","?coord1", "?comm2","coord2","?layer","?str","?line", "?rgb"],"layer":"?connectingLine1Label"}
SELECT ?comm1 ?comm1Label ?coord1 ?comm2 ?coord2 ?line ?connectingLine1 ?connectingLine1Label ?layer ?rgb WHERE {
BIND(wd:Q8686 AS ?city)
?comm1 wdt:P31/wdt:P279* wd:Q928830 ;
wdt:P131*/wdt:P279* ?city;
wdt:P625 ?coord1 ;
wdt:P81 ?connectingLine1;
wdt:P197 ?comm2 .
?connectingLine1 wdt:P465 ?rgb.
?comm2 wdt:P81 ?connectingLine2;
wdt:P625 ?coord2 .
FILTER (?connectingLine1 = ?connectingLine2)
?comm1 p:P625 [# ps:P625 [];
psv:P625 [ wikibase:geoLongitude ?coord1lon; wikibase:geoLatitude ?coord1lat; ] ] .
?comm2 p:P625 [# ps:P625 [];
psv:P625 [ wikibase:geoLongitude ?coord2lon; wikibase:geoLatitude ?coord2lat; ] ] .
BIND(CONCAT('LINESTRING (', STR(?coord1lon), ' ', STR(?coord1lat), ',', STR(?coord2lon), ' ', STR(?coord2lat), ')') AS ?str) .
BIND(STRDT(?str, geo:wktLiteral) AS ?line) .
BIND(?connectingLine1 AS ?layer)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
}
ORDER BY (?connectingLine1Label)
Cities connected to Paramaribo (Suriname) by main roads
#defaultView:Map
SELECT DISTINCT ?connection ?connectionLabel ?connectedWith ?connectedWithLabel ?coor
WHERE
{
VALUES ?city {wd:Q3001} # wd:Q3001 = Paramaribo}
?connection wdt:P2789+ ?city ;
wdt:P2789+ ?connectedWith .
?connectedWith wdt:P625 ?coor .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Names of 100 cities with a population larger than 1000000 in the native languages of their countries
# Show the names of 100 cities with a population larger than 1000000 in the native languages of their countries
SELECT ?city ?cityLabel ?country ?countryLabel ?lang ?langLabel ?langCode ?population
WHERE
{
?city wdt:P1082 ?population . hint:Prior hint:runFirst true.
FILTER(?population>1000000)
?city wdt:P31 wd:Q515;
wdt:P17 ?country;
rdfs:label ?cityLabel .
?country wdt:P37 ?lang;
rdfs:label ?countryLabel .
?lang wdt:P424 ?langCode;
rdfs:label ?langLabel .
FILTER(lang(?cityLabel)=?langCode)
FILTER(lang(?countryLabel)=?langCode)
FILTER(lang(?langLabel)=?langCode)
} LIMIT 100
Distances between any two cities or municipalities in an area
grouped by dist range, color-coded
#defaultView:BarChart
PREFIX var_muntype: <http://www.wikidata.org/entity/Q15284>
PREFIX var_area: <http://www.wikidata.org/entity/Q6308>
SELECT ?from ?to ?distGrp WHERE {
{
SELECT ?from ?to ?distNum ?mun ?mun2 WHERE {
{ SELECT ?mun (SAMPLE(?loc) AS ?loc)
WHERE { ?mun wdt:P31/wdt:P279* var_muntype:;
wdt:P131 var_area:;
wdt:P625 ?loc. }
GROUP BY ?mun
}
OPTIONAL {
{ SELECT (?mun AS ?mun2) (SAMPLE(?loc) AS ?loc2)
WHERE { ?mun wdt:P31/wdt:P279* var_muntype:;
wdt:P131 var_area:;
wdt:P625 ?loc. }
GROUP BY ?mun
}
}
BIND(geof:distance(?loc, ?loc2) AS ?distNum).
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?mun rdfs:label ?from.
?mun2 rdfs:label ?to.
}
}
}
FILTER(CONCAT(?from,STR(?mun)) <= CONCAT(?to,STR(?mun2))).
#BIND(IF(STR(?from) < STR(?to),CONCAT(?from," <--> ",?to),
# CONCAT(?to," <--> ",?from)) AS ?distLabel).
BIND(COALESCE(
IF(?distNum >= 40, "40 - .. km", 1/0),
IF(?distNum >= 30, "30 - 40 km", 1/0),
IF(?distNum >= 20, "20 - 30 km", 1/0),
IF(?distNum >= 10, "10 - 20 km", 1/0),
IF(?distNum >= 5, "05 - 10 km", 1/0),
IF(?distNum >= 1, "01 - 05 km", "00 - 01 km")) AS ?distGrp).
}
ORDER BY ?from ?distGrp
grouped per municipality on x-axis, alphabetically
#defaultView:ScatterChart
PREFIX var_muntype: <http://www.wikidata.org/entity/Q15284>
PREFIX var_area: <http://www.wikidata.org/entity/Q6308>
SELECT ?from (?distGrp1 AS ?kilometers) ?to WHERE {
{ SELECT ?mun (SAMPLE(?loc) AS ?loc)
WHERE { ?mun wdt:P31/wdt:P279* var_muntype:;
wdt:P131 var_area:;
wdt:P625 ?loc. }
GROUP BY ?mun
}
OPTIONAL {
{ SELECT (?mun AS ?mun2) (SAMPLE(?loc) AS ?loc2)
WHERE { ?mun wdt:P31/wdt:P279* var_muntype:;
wdt:P131 var_area:;
wdt:P625 ?loc. }
GROUP BY ?mun
}
}
BIND(geof:distance(?loc, ?loc2) AS ?distNum).
BIND(STR(ROUND(?distNum)) AS ?distGrp0).
BIND(CONCAT(SUBSTR("000",STRLEN(?distGrp0)+1),?distGrp0,".",STR(ROUND((?distNum-FLOOR(?distNum))*10))," km") AS ?distGrp1).
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?mun rdfs:label ?from.
?mun2 rdfs:label ?to.
}
}
ORDER BY ?from ?kilometers
grouped per municipality on x-axis, by sum of dist
#defaultView:ScatterChart
PREFIX var_muntype: <http://www.wikidata.org/entity/Q15284>
PREFIX var_area: <http://www.wikidata.org/entity/Q6308>
SELECT ?from (?distNum AS ?kilometers) ?to WHERE {
{ SELECT ?mun (SAMPLE(?loc) AS ?loc)
WHERE { ?mun wdt:P31/wdt:P279* var_muntype:;
wdt:P131 var_area:;
wdt:P625 ?loc. }
GROUP BY ?mun
}
OPTIONAL {
{ SELECT (?mun AS ?mun2) (SAMPLE(?loc) AS ?loc2)
WHERE { ?mun wdt:P31/wdt:P279* var_muntype:;
wdt:P131 var_area:;
wdt:P625 ?loc. }
GROUP BY ?mun
}
}
BIND(geof:distance(?loc, ?loc2) AS ?distNum).
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?mun rdfs:label ?from.
?mun2 rdfs:label ?to.
}
}
ORDER BY ?from ?kilometers
grouped per municipality on x-axis, animated per municipality on x-axis
#defaultView:ScatterChart
PREFIX var_muntype: <http://www.wikidata.org/entity/Q15284>
PREFIX var_area: <http://www.wikidata.org/entity/Q6308>
SELECT ?from (?distNum AS ?kilometers) ?to (?from AS ?animation) WHERE {
{ SELECT ?mun (SAMPLE(?loc) AS ?loc)
WHERE { ?mun wdt:P31/wdt:P279* var_muntype:;
wdt:P131 var_area:;
wdt:P625 ?loc. }
GROUP BY ?mun
}
OPTIONAL {
{ SELECT (?mun AS ?mun2) (SAMPLE(?loc) AS ?loc2)
WHERE { ?mun wdt:P31/wdt:P279* var_muntype:;
wdt:P131 var_area:;
wdt:P625 ?loc. }
GROUP BY ?mun
}
}
BIND(geof:distance(?loc, ?loc2) AS ?distNum).
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?mun rdfs:label ?from.
?mun2 rdfs:label ?to.
}
}
ORDER BY ?from ?kilometers
grouped per municipality on x-axis, animated per municipality on z-axis
#defaultView:ScatterChart
PREFIX var_muntype: <http://www.wikidata.org/entity/Q15284>
PREFIX var_area: <http://www.wikidata.org/entity/Q6308>
SELECT ?from (?distNum AS ?kilometers) ?to (?to AS ?animation) WHERE {
{ SELECT ?mun (SAMPLE(?loc) AS ?loc)
WHERE { ?mun wdt:P31/wdt:P279* var_muntype:;
wdt:P131 var_area:;
wdt:P625 ?loc. }
GROUP BY ?mun
}
OPTIONAL {
{ SELECT (?mun AS ?mun2) (SAMPLE(?loc) AS ?loc2)
WHERE { ?mun wdt:P31/wdt:P279* var_muntype:;
wdt:P131 var_area:;
wdt:P625 ?loc. }
GROUP BY ?mun
}
}
BIND(geof:distance(?loc, ?loc2) AS ?distNum).
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?mun rdfs:label ?from.
?mun2 rdfs:label ?to.
}
}
ORDER BY ?from ?kilometers
grouped per municipality on x-axis, animated by fixed dist range groups
#defaultView:ScatterChart
PREFIX var_muntype: <http://www.wikidata.org/entity/Q15284>
PREFIX var_area: <http://www.wikidata.org/entity/Q6308>
SELECT ?from (?distNum AS ?kilometers) ?to (?distGrp AS ?animation) WHERE {
{ SELECT ?mun (SAMPLE(?loc) AS ?loc)
WHERE { ?mun wdt:P31/wdt:P279* var_muntype:;
wdt:P131 var_area:;
wdt:P625 ?loc. }
GROUP BY ?mun
}
OPTIONAL {
{ SELECT (?mun AS ?mun2) (SAMPLE(?loc) AS ?loc2)
WHERE { ?mun wdt:P31/wdt:P279* var_muntype:;
wdt:P131 var_area:;
wdt:P625 ?loc. }
GROUP BY ?mun
}
}
#FILTER (STR(?mun) <= STR(?mun2)).
BIND(geof:distance(?loc, ?loc2) AS ?distNum).
BIND(COALESCE(
IF(?distNum >= 40, "40 km und mehr", 1/0),
IF(?distNum >= 30, "30 - 40 km", 1/0),
IF(?distNum >= 20, "20 - 30 km", 1/0),
IF(?distNum >= 10, "10 - 20 km", 1/0),
IF(?distNum >= 5, "05 - 10 km", 1/0),
IF(?distNum >= 1, "01 - 05 km", "00 - 01 km")) AS ?distGrp).
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?mun rdfs:label ?from.
?mun2 rdfs:label ?to.
}
}
ORDER BY ?animation ?from ?kilometers
grouped per municipality on x-axis, animated by ranked dist (farthest, 2nd farthest, ..)
#defaultView:ScatterChart
PREFIX var_muntype: <http://www.wikidata.org/entity/Q15284>
PREFIX var_area: <http://www.wikidata.org/entity/Q6308>
SELECT ?from ?kilometers ?to ?rank_group
WHERE {
{
SELECT (SAMPLE(?mun) AS ?mun) (SAMPLE(?mun2) AS ?mun2) (SAMPLE(?distNum) AS ?kilometers)
(COUNT(*)-1 AS ?rg) (SUBSTR("00",1+STRLEN(STR(?rg))) AS ?rgpad)
(IF(FLOOR((?rg-(100*FLOOR(?rg/100)))/10)=1,0,?rg-(10*FLOOR(?rg/10))) AS ?rgmod)
(IF(?rgmod=1,"st",IF(?rgmod=2,"nd",IF(?rgmod=3,"rd","th"))) AS ?rgord)
(CONCAT(?rgpad,STR(?rg),?rgord,"-most farthest places") AS ?rank_group)
WHERE {
{ SELECT ?mun (SAMPLE(?loc) AS ?loc)
WHERE { ?mun wdt:P31/wdt:P279* var_muntype:;
wdt:P131 var_area:;
wdt:P625 ?loc. }
GROUP BY ?mun
}
OPTIONAL {
{ SELECT (?mun AS ?mun2) (SAMPLE(?loc) AS ?loc2)
WHERE { ?mun wdt:P31/wdt:P279* var_muntype:;
wdt:P131 var_area:;
wdt:P625 ?loc. }
GROUP BY ?mun
}
}
OPTIONAL {
{ SELECT (?mun AS ?mun3) (SAMPLE(?loc) AS ?loc3)
WHERE { ?mun wdt:P31/wdt:P279* var_muntype:;
wdt:P131 var_area:;
wdt:P625 ?loc. }
GROUP BY ?mun
}
}
BIND(geof:distance(?loc, ?loc2) AS ?distNum).
BIND(geof:distance(?loc, ?loc3) AS ?d).
FILTER(?distNum >= ?d).
} GROUP BY ?mun ?mun2 ?distNum
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?mun rdfs:label ?from.
?mun2 rdfs:label ?to.
}
}
ORDER BY ?rank_group ?kilometers ?from
SELECT ?muni ?muniLabel where {
?muni p:P31 [ps:P31 wd:Q2039348];
wdt:P47 wd:Q213246.
SERVICE wikibase:label { bd:serviceParam wikibase:language "nl". }
}
Border cities of the world
# To filter by country add FILTER (?country = wd:Qxx)
#defaultView:Map
# To show the cities of several countries use FILTER (?country IN (wd:Qxx, wd:Qyy))
# To obtain cities that are part of a particular continent or territory ?country
# should not be optional and add "?country wdt:P361 wd:Qxx ."
SELECT ?border_city ?border_cityLabel ?countryLabel ?coords
WHERE {
?border_city wdt:P31 wd:Q902814.
OPTIONAL { ?border_city wdt:P17 ?country. }
OPTIONAL { ?border_city wdt:P625 ?coords. }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?border_city rdfs:label ?border_cityLabel.
?country rdfs:label ?countryLabel.}
}
GROUP BY ?border_city ?border_cityLabel ?countryLabel ?coords
ORDER BY ?countryLabel ?border_cityLabel
Rivers
Longest rivers
#defaultView:BubbleChart
SELECT ?item ?itemLabel ?length ?pic ?location
WHERE
{
?item wdt:P31/wdt:P279* wd:Q4022 .
?item wdt:P2043 ?length .
?item wdt:P18 ?pic .
?item wdt:P625 ?location
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
} ORDER BY DESC(?length) ?itemLabel
LIMIT 50
Longest river of each continent
SELECT ?continent ?river ?continentLabel ?riverLabel
WHERE
{
{
SELECT ?continent (MAX(?length) AS ?length)
WHERE
{
?river wdt:P31/wdt:P279* wd:Q355304;
wdt:P2043 ?length;
wdt:P30 ?continent.
}
GROUP BY ?continent
}
?river wdt:P31/wdt:P279* wd:Q355304;
wdt:P2043 ?length;
wdt:P30 ?continent.
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY ?continentLabel
Rivers in Antarctica
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". }
}
Body of water with the most watercourses ending in it
- Items used: None
- Properties used: mouth of the watercourse (P403)
# 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
Bridges over rivers in former government district of Leipzig
#defaultView:Map
SELECT (SAMPLE(?bridge) AS ?bridge) (SAMPLE(?bridgeLabel) AS ?bridgeLabel)
(SAMPLE(?watercourse) AS ?watercourse) (SAMPLE(?watercourseLabel) AS ?watercourseLabel)
(SAMPLE(?loc) AS ?loc) (SAMPLE(?pic) AS ?pic)
(CONCAT(SAMPLE(?sKey),": ",STR(YEAR(SAMPLE(?s)))) AS ?start)
(CONCAT(SAMPLE(?eKey),": ",STR(YEAR(SAMPLE(?e)))) AS ?end)
(SAMPLE(?article) AS ?article) (IF(BOUND(?article),CONCAT(?bridgeLabel," in Wikipedia"),1/0) AS ?articleLabel)
WHERE {
{
SELECT ?bridge ?watercourse WHERE {
?bridge wdt:P31/wdt:P279* wd:Q12280; wdt:P177 ?watercourse.
?watercourse wdt:P31/wdt:P279* wd:Q355304.
# the following actually yields a perf penalty atm
#?bridge wdt:P17 wd:Q183.
#OPTIONAL { ?bridge wdt:P17 ?country. }. FILTER(!BOUND(?country) || ?country = wd:Q183).
}
}
# wd:Q1202, wd:Q183 work as well atm and take progressively more time to complete
?bridge (p:P131|ps:P131)+ wd:Q24186.
OPTIONAL { ?bridge wdt:P625 ?loc. }.
OPTIONAL { ?bridge wdt:P18 ?pic. }.
OPTIONAL { ?bridge wdt:P571 ?s. }.
OPTIONAL { ?bridge wdt:P576 ?e. }.
OPTIONAL {
?article schema:about ?bridge.
FILTER (IF(EXISTS {?article schema:inLanguage "[AUTO_LANGUAGE]".},
SUBSTR(str(?article), 1, 25) = "https://[AUTO_LANGUAGE].wikipedia.org/",
IF(EXISTS {?article schema:inLanguage "en".},
SUBSTR(str(?article), 1, 25) = "https://en.wikipedia.org/",
SUBSTR(str(?article), 1, 25) = "https://de.wikipedia.org/"
)
)).
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de".
?bridge rdfs:label ?bridgeLabel.
?watercourse rdfs:label ?watercourseLabel.
wd:P571 rdfs:label ?sKey.
wd:P576 rdfs:label ?eKey.
}
}
GROUP BY ?bridge ?watercourse
Mountains
Mons (mountains), with coordinates, not located on Earth
- Items used: mons (Q429088) Earth (Q2)
- Properties used: coordinate location (P625) instance of (P31)
SELECT DISTINCT ?item ?name ?coord ?lat ?lon ?globe
{
?item wdt:P31 wd:Q429088 ;
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)
Highest places on Earth
- Items used: None
- Properties used: elevation above sea level (P2044) coordinate location (P625)
#title:Elevations over 8000 meter
SELECT ?elevation ?item ?itemLabel ?itemDescription ?coord WHERE {
hint:Query hint:optimizer "None".
?st psn:P2044 ?psn .
?psn wikibase:quantityAmount ?elevation . FILTER(?elevation > 8000) .
?psn wikibase:quantityUnit wd:Q11573 .
?st wikibase:rank ?rank . FILTER(?rank != wikibase:DeprecatedRank) .
?item p:P2044 ?st .
?item wdt:P625 ?coord .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?elevation)
Highest mountains in the universe (with units)
- Items used: None
- Properties used: elevation above sea level (P2044) coordinate location (P625)
#Elevations over 8000
#Displays units
#Last updated 2021-04-25
SELECT ?elevation ?unit ?unitLabel ?item ?itemLabel ?itemDescription ?coord
WHERE
{
?psv_triples wikibase:quantityAmount ?elevation .
filter(?elevation > 8000)
?psv_triples wikibase:quantityUnit ?unit .
?p_triples psv:P2044 ?psv_triples .
?p_triples a wikibase:BestRank .
?item p:P2044 ?p_triples .
?item wdt:P625 ?coord .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?elevation)
Highest mountains in the universe (with units, compact form)
- Items used: None
- Properties used: elevation above sea level (P2044) coordinate location (P625)
#Elevations over 8000
#Displays units
#Last updated 2021-04-25
SELECT ?elevation ?unit ?unitLabel ?item ?itemLabel ?itemDescription ?coord
WHERE
{
?item wdt:P2044 ?elevation .
# this could be dropped, but is included to speed it up
filter(?elevation > 8000)
?item p:P2044 [ a wikibase:BestRank ; psv:P2044 [ wikibase:quantityAmount ?elevation ; wikibase:quantityUnit ?unit ] ] .
?item wdt:P625 ?coord .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?elevation)
Mountains over 8000 meters elevation
- Properties used: elevation above sea level (P2044) coordinate location (P625)
#Last updated 2021-04-25
#defaultView:Map
SELECT ?item ?itemLabel ?itemDescription ?coord ?elevation
WHERE
{
?item wdt:P31 wd:Q8502 .
?item p:P2044 [ a wikibase:BestRank; psn:P2044/wikibase:quantityAmount ?elevation ]
FILTER(?elevation >= 8000 )
?item wdt:P625 ?coord.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
Italian mountains higher than 4000 meters
- Items used: Italy (Q38)
- Properties used: elevation above sea level (P2044) coordinate location (P625) country (P17) image (P18)
#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" }
}
Places in Antarctica more than 3000km away from the South Pole
#title: Places in Antarctica over 3000km away from the South Pole
#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 3000km away from south pole
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Metro stations of Paris Métro Line 1 (Q13224) in Paris
- Items used: metro station (Q928830) Paris Métro Line 1 (Q13224) Château de Vincennes (Q585752)
- Properties used: instance of (P31) connecting line (P81) coordinate location (P625) adjacent station (P197) direction (P560)
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:P5051 wd:Q585752;
pq:P81 wd:Q13224] .
?adjacent rdfs:label ?adjacentL FILTER (lang(?adjacentL) = "en")
}
?item wdt:P1619 ?founded_date. #needs existence
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
} ORDER BY ?itemLabel
Map of Broadway venues
- Items used: Broadway theatre (Q235065)
- Properties used: Internet Broadway Database venue ID (P1217) coordinate location (P625)
#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" .
}
}
How many states this US state borders
- Items used: U.S. state (Q35657)
- Properties used: instance of (P31), shares border with (P47)
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 "[AUTO_LANGUAGE],en" .
}
}
ORDER BY DESC(?borders)
Places that are below 10 meters above sea level
- Items used: metre (Q11573)
- Properties used: elevation above sea level (P2044)
#defaultView:Map
SELECT ?place ?location ?elev ?image
WHERE
{
?place p:P2044/psv:P2044 ?placeElev.
?placeElev wikibase:quantityAmount ?elev.
?placeElev wikibase:quantityUnit ?unit.
bind(0.01 as ?km).
filter( (?elev < ?km*1000 && ?unit = wd:Q11573)
|| (?elev < ?km*3281 && ?unit = wd:Q3710)
|| (?elev < ?km && ?unit = wd:Q828224) ).
?place wdt:P625 ?location.
OPTIONAL { ?place wdt:P18 ?image }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
Globes used to represent coordinates
SELECT (count(?v) as ?c) ?globe
WHERE
{
?v wikibase:geoGlobe ?globe
}
GROUP BY ?globe
ORDER BY DESC(?c)
Places within 1km of the Empire State Building
- Items used: Empire State Building (Q9188)
- Properties used: coordinate location (P625) instance of (P31)
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
Select French municipalities by INSEE code (select by identifier)
- Properties used: INSEE municipality code (P374)
SELECT ?item ?itemLabel ?inseeCode {
?item wdt:P374 ?inseeCode .
FILTER (?inseeCode in ("75056", "69123", "13055"))
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
Map and list of municipalities in The Netherlands
#Concise list & map of the 355 Dutch municipalities, their geo coordinates and their provinces, per 1-1-2019
#See also:
#https://almanak.overheid.nl/organisaties/Gemeenten/ - 355 in aantal
#https://nl.wikipedia.org/wiki/Lijst_van_Nederlandse_gemeenten - 355 in aantal
#defaultView:Map
SELECT ?muni ?muniLabel ?location where {
?muni p:P31 ?instanceOf; # Get statement because we need this later
wdt:P625 ?location. # And location
?instanceOf ps:P31 wd:Q2039348. # P31 should be 'municipality of the Netherlands'
MINUS { ?muni wdt:P31 wd:Q7265977. } # Don't show former municipalities
MINUS { ?instanceOf pq:P582 ?endTime. } # And don't show municipalities that have an end time
SERVICE wikibase:label { bd:serviceParam wikibase:language "nl". } # Show names in Dutch
}
Emergency numbers by population using them
- Items used : emergency telephone number (Q694554) country (Q6256)
- Properties used: instance of (P31) population (P1082) emergency phone number (P2852) subclass of (P279) phone number (P1329)
#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 "[AUTO_LANGUAGE],en" }
}
ORDER BY DESC(?population)
German states, ordered by the number of company headquarters per million inhabitants
- Items used: federated state of Germany (Q1221156) business (Q4830453)
- Properties used: headquarters location (P159) instance of (P31) subclass of (P279) headquarters location (P159) located in the administrative territorial entity (P131) dissolved, abolished or demolished date (P576) population (P1082)
# 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)
Popular names per birthplace
- Items used: Berlin (Q64)
- Properties used: place of birth (P19) given name (P735)
#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
Map of places mentioned in travel stories with text in French accessible online
- Items used: travel book (Q1164267) book (Q571) South Pole (Q933) French (Q150)
- Properties used: genre (P136) instance of (P31) author (P50) narrative location (P840) coordinate location (P625) full work available at URL (P953) original language of film or TV show (P364) edition or translation of (P629) language of work or name (P407)
#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
Things located where the equator meets the prime meridian
- Items used: Soul buoy (Q24041662)
- Properties used: coordinate location (P625)
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
French communes with names ending in ac
#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...
}
Buildings in more than one country
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
Streets named after a person
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
Streets in France without a city
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
ATMs around Munich belonging to the Bankcard-Servicenetz interbank network (federated query)
| This page is outdated. |
#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:P527 wd:Q806724. }
UNION { ?bank wdt:P1454 wd:Q5349747. }
MINUS { wd:Q806724 wdt:P3113 ?bank. }
}
Items geographically located around the Wikimedia Foundation office, sorted by distance
SELECT ?place ?location ?distance ?placeLabel WHERE {
SERVICE wikibase:around {
?place wdt:P625 ?location .
bd:serviceParam wikibase:center "Point(-122.402251 37.789246)"^^geo:wktLiteral .
bd:serviceParam wikibase:radius "1" .
bd:serviceParam wikibase:distance ?distance .
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY ?distance LIMIT 100
Ten largest islands in the world
# Ten largest islands in the world
# Inspired by this infographic: https://redd.it/a6423t
#defaultView:ImageGrid
SELECT ?island ?islandLabel ?islandImage
WITH {
SELECT DISTINCT *
WHERE {
# Instances of island (or of subclasses of island)
?island (wdt:P31/wdt:P279*) wd:Q23442.
# Optionally with an image
OPTIONAL { ?island wdt:P18 ?islandImage. }
# Get the area of the island
# Use the psn: prefix to normalize the values to a common unit of area
?island p:P2046/psn:P2046/wikibase:quantityAmount ?islandArea.
}
ORDER BY DESC(?islandArea)
LIMIT 10
} AS %i
WHERE {
INCLUDE %i
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
}
ORDER BY DESC(?islandArea)
City gates in the Dutch province of Zeeland
SELECT ?town ?townLabel ?gate ?gateLabel where {
# Municipalities within the province
?muni wdt:P31 wd:Q2039348;
wdt:P131 wd:Q705.
# Instances of city gate located within any of the municipalities
?gate wdt:P31 wd:Q82117;
wdt:P131 ?muni;
# The Location (usually Town) that the gate is in
wdt:P276 ?town.
SERVICE wikibase:label { bd:serviceParam wikibase:language "nl". }
}
Glaciers map
- Items used: glacier (Q35666)
- Properties used: instance of (P31) , subclass of (P279) , coordinate location (P625) , area (P2046)
- Features used: map (Q24515275)
#by Jura1, 2021-05-21
#defaultView:Map{"hide":["?coor","?area_scale_km"], "layer": "?area_scale_km"}
SELECT ?item ?itemLabel ?itemDescription ?coor ?area_sqkm ?area_scale_km
{
?item wdt:P31/wdt:P279* wd:Q35666 .
OPTIONAL { ?item wdt:P625 ?coor }
OPTIONAL { ?item p:P2046 [ a wikibase:BestRank; psn:P2046/wikibase:quantityAmount ?area_sqm ] .
BIND( ROUND(?area_sqm/10000)/100 as ?area_sqkm)
BIND( strlen(str(ROUND(?area_sqm/1000000))) as ?area_scale_km)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Demography
Birthplaces of humans named Antoine
# Coordinates of the birth places of people named Antoine
#defaultView:Map
SELECT ?item ?itemLabel ?coord
WHERE
{
?item wdt:P31 wd:Q5 . # human
?item wdt:P735 wd:Q15235674.
?item wdt:P19 ?place.
?place wdt:P625 ?coord.
SERVICE wikibase:label { bd:serviceParam wikibase:language "fr". }
}
Average lifespan by occupation
# Select the desired columns and get labels
SELECT ?occ ?occLabel ?avgAge ?avgBirthYear ?count
WHERE
{
{
# Group the people by their occupation and calculate age
SELECT
?occ
(count(?p) as ?count)
(round(avg(?birthYear)) as ?avgBirthYear)
(avg(?deathYear - ?birthYear) as ?avgAge)
WHERE {
{
# Get people with occupation + birth/death dates; combine multiple birth/death dates using avg
SELECT
?p
?occ
(avg(year(?birth)) as ?birthYear)
(avg(year(?death)) as ?deathYear)
WHERE {
?p wdt:P31 wd:Q5 ;
wdt:P106 ?occ ;
p:P569/psv:P569 [
wikibase:timePrecision "9"^^xsd:integer ; # precision of at least year
wikibase:timeValue ?birth ;
] ;
p:P570/psv:P570 [
wikibase:timePrecision "9"^^xsd:integer ; # precision of at least year
wikibase:timeValue ?death ;
] .
}
GROUP BY ?p ?occ
}
}
GROUP BY ?occ
}
FILTER (?count > 300) # arbitrary number to weed out values with 'few' observations
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}
ORDER BY ASC(?avgAge)
Items with the most birth dates
SELECT ?person (COUNT(?date) AS ?dateC) {
?person wdt:P569 ?date
}
GROUP BY ?person
HAVING (?dateC > 2)
ORDER BY DESC (?dateC)
LIMIT 100
Things/people with most children
SELECT ?parent ?parentLabel ?count
WHERE
{
{
SELECT ?parent (COUNT(?child) AS ?count)
WHERE
{
?parent wdt:P40 ?child.
}
GROUP BY ?parent
ORDER BY DESC(?count)
LIMIT 10
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY DESC(?count)
LIMIT 10
Population growth in Suriname from 1960 onward
#defaultView:LineChart
SELECT ?year ?population {
wd:Q730 p:P1082 ?p .
?p pq:P585 ?year ;
ps:P1082 ?population .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?year
Number of dead people by month since 2000
SELECT ?yearmonth (COUNT(?person) as ?count)
WHERE
{
?person wdt:P31 wd:Q5;
p:P570/psv:P570 [
wikibase:timePrecision ?precision ;
wikibase:timeValue ?date ;
] .
BIND(CONCAT(STR(YEAR(?date)),"-",STR(MONTH(?date))) as ?yearmonth).
FILTER( ?date >= "2000-01-01T00:00:00"^^xsd:dateTime )
FILTER( ?precision >= "10"^^xsd:integer ) # precision of at least month
}
GROUP BY ?yearmonth
Politics
Dutch general election 2017
Candidates for the Dutch general election in 2017
SELECT ?item ?itemLabel ?twitter ?LinkedIN ?politieke_partij ?politieke_partijLabel ?positie_op_lijst
WHERE {
?item p:P3602 ?node .
OPTIONAL { ?item wdt:P2002 ?twitter }
OPTIONAL { ?item wdt:P2035 ?LinkedIN }
?node ps:P3602 wd:Q16061881 .
OPTIONAL { ?node pq:P1545 ?positie_op_lijst }
OPTIONAL { ?node pq:P1268 ?politieke_partij }
OPTIONAL { ?node pq:P2035 ?LinkedIN }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl" }
}
Gender distribution in the candidates for the Dutch general election 2017
#Kandidaten voor de Nederlandse tk verkiezingen van 2017
#defaultView:Dimensions
SELECT ?positie_op_lijst ?genderLabel ?politieke_partijLabel WHERE {
?item p:P3602 ?node.
?item wdt:P21 ?gender.
?node ps:P3602 wd:Q16061881 .
?node pq:P1545 ?positie_op_lijst.
?node pq:P1268 ?politieke_partij.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl". }
}
Candidates for the Dutch general election 2017 living in Antwerp, Belgium
SELECT ?item ?itemLabel ?twitter ?LinkedIN ?politieke_partij ?politieke_partijLabel ?positie_op_lijst WHERE {
?item p:P3602 ?node.
?item wdt:P551 wd:Q12892.
OPTIONAL { ?item wdt:P2002 ?twitter. }
OPTIONAL { ?item wdt:P2035 ?LinkedIN. }
?node ps:P3602 wd:Q16061881.
OPTIONAL { ?node pq:P1545 ?positie_op_lijst. }
OPTIONAL { ?node pq:P1268 ?politieke_partij. }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl". }
}
Candidates for the Dutch general election 2017 living abroad
#defaultView:Map
SELECT ?item ?itemLabel ?coordinates WHERE {
?item p:P3602 ?node.
?item wdt:P551 ?residence .
?residence wdt:P17 ?country ;
wdt:P625 ?coordinates .
?node ps:P3602 wd:Q16061881.
FILTER (?country != wd:Q55)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl". }
}
Occupations of candidates of the Dutch general election 2017
#Kandidaten voor de Nederlandse TK verkiezingen van 2017
#defaultView:Dimensions
SELECT ?positie_op_lijst ?genderLabel ?occupationLabel ?politieke_partijLabel WHERE {
VALUES ?politieke_partij {wd:Q747910 wd:Q275441}
?item p:P3602 ?node.
?item wdt:P21 ?gender.
?item wdt:P106 ?occupation.
?node ps:P3602 wd:Q16061881.
?node pq:P1545 ?positie_op_lijst.
?node pq:P1268 ?politieke_partij.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl". }
}
Gender balance of members of Irish parliament
- Items used: Teachta Dála (Q654291)
- Properties used: position held (P39) sex or gender (P21)
SELECT ?genderlabel (COUNT(?genderlabel) as ?total)
WHERE
{
?subj wdt:P39 wd:Q654291 .
?subj wdt:P21 ?gender .
?gender rdfs:label ?genderlabel FILTER (lang(?genderlabel) = "en") .
?subj rdfs:label ?label FILTER (lang(?label) = "en")
}
GROUP BY ?genderlabel
Assemblies by number of seats
- Items used: assembly (Q1752346)
- Properties used: instance of (P31) subclass of (P279) number of seats (P1342) applies to jurisdiction (P1001) inception (P571) dissolved, abolished or demolished date (P576)
SELECT DISTINCT ?item ?title ?seats ?jurisdiction (YEAR(?inception) AS ?start) (YEAR(?dissolution) AS ?end)
WHERE
{
?item wdt:P31/wdt:P279* wd:Q1752346 .
OPTIONAL { ?item wdt:P1342 ?seats . }
OPTIONAL {
?item wdt:P1001 ?j .
?j rdfs:label ?jurisdiction FILTER (lang(?jurisdiction) = "en") .
}
OPTIONAL { ?item wdt:P571 ?inception . }
OPTIONAL { ?item wdt:P576 ?dissolution . }
OPTIONAL { ?item rdfs:label ?title FILTER (lang(?title) = "en") . }
}
ORDER BY DESC(?seats) ?title
List of countries by age of the head of government
- Items used: sovereign state (Q3624078) historical country (Q3024240)
- Properties used: instance of (P31) head of government (P6) end time (P582) date of birth (P569)
#added by Jura1, rev. 2016-11-08
SELECT DISTINCT ?age ?country ?countryLabel ?hgovernment ?hgovernmentLabel
{
?country wdt:P31 wd:Q3624078 .
FILTER NOT EXISTS {?country wdt:P31 wd:Q3024240}
?country p:P6 ?statement .
?statement ps:P6 ?hgovernment .
?country wdt:P6 ?hgovernment .
FILTER NOT EXISTS { ?statement pq:P582 ?x }
?hgovernment wdt:P569 ?dob . BIND(YEAR(now())-YEAR(?dob) as ?age)
FILTER(?age>=65)
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY DESC(?age)
Number of ministers who are themselves children of a minister, per country
- Items used: human (Q5) minister (Q83307)
- Properties used: instance of (P31) position held (P39) subclass of (P279) father (P22) mother (P25) country of citizenship (P27)
SELECT ?cc (COUNT(DISTINCT ?child) AS ?number) {
?child wdt:P31 wd:Q5 ; # Looking for real humans and not fictional ones
wdt:P39/wdt:P279* wd:Q83307 ;
(wdt:P22|wdt:P25) [wdt:P39/wdt:P279* wd:Q83307] ;
wdt:P27/wdt:P901 ?cc
}
GROUP BY ?cc
ORDER BY DESC(?number)
Members of the French National Assembly born out of France
- Items used: member of the French National Assembly (Q3044918) France (Q142)
- Properties used: position held (P39) place of birth (P19) country (P17) France (Q142)
SELECT DISTINCT ?item ?itemLabel ?placeLabel ?countryLabel
WHERE
{
?item wdt:P39 wd:Q3044918 .
?item wdt:P19 ?place .
?place wdt:P17 ?country .
FILTER NOT EXISTS { ?place wdt:P17 wd:Q142 . }
SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
}
ORDER BY ?countryLabel ?itemLabel
List of parliament buildings with pictures by country
- Items used: parliament building (Q7138926)
- Properties used: country (P17) image (P18) instance of (P31)
#defaultView:ImageGrid
SELECT ?building ?buildingLabel ?country ?countryLabel ?picture
WHERE
{
?building wdt:P31 wd:Q7138926 .
?building wdt:P18 ?picture .
OPTIONAL { ?building wdt:P17 ?country } . #if available
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
}
ORDER BY ?countryLabel
LIMIT 188
Number of jurisdictions by driving side
SELECT ?sideLabel (COUNT(?jurisdiction) AS ?count)
WHERE
{
?jurisdiction wdt:P1622 ?side.
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
GROUP BY ?sideLabel
ORDER BY ?sideLabel
Timeline of mayors of Amsterdam, the Netherlands
#defaultView:Timeline
SELECT ?mayor ?mayorLabel ?start ?end where {
?mayor p:P39 ?position.
?position ps:P39 wd:Q13423495;
pq:P580 ?start;
pq:P582 ?end.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl,en". }
}
Current U.S. members of the Senate with district, party and date they assumed office
SELECT ?senator ?senatorLabel ?districtLabel ?partyLabel ?assumedOffice (sample(?image) as ?image) where {
# Get all senators
?senator p:P39 ?posheld; # With position held
p:P102 ?partystatement. # And with a certain party
# Get the party
?partystatement ps:P102 ?party.
MINUS { ?partystatement pq:P582 ?partyEnd. } # but minus the ones the senator is no longer a member of
MINUS { ?party wdt:P361 ?partOf. } # and the 'Minnesota Democratic–Farmer–Labor Party' and such
# Check on the position in the senate
?posheld ps:P39 wd:Q4416090; # Position held is in the senate
pq:P768 ?district;
pq:P580 ?assumedOffice. # And should have a starttime
MINUS { ?posheld pq:P582 ?endTime. } # But not an endtime
# Add an image
OPTIONAL { ?senator wdt:P18 ?image. }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?senator ?senatorLabel ?districtLabel ?partyLabel ?assumedOffice ORDER BY ?senatorLabel
Economics and Business
Map of places of birth of dead economists, colour-coded by era
#defaultView:Map
SELECT DISTINCT ?person ?name ?birthplace ?birthyear ?coord ?layer WHERE {
{?person wdt:P106 wd:Q188094} UNION {?person wdt:P101 wd:Q8134}
?person wdt:P570 ?dod;
wdt:P19 ?place .
?place wdt:P625 ?coord
OPTIONAL { ?person wdt:P569 ?dob }
BIND(YEAR(?dob) as ?birthyear)
BIND(IF( (?birthyear < 1700), "Pre-1700", IF((?birthyear < 1751), "1700-1750", IF((?birthyear < 1801), "1751-1800", IF((?birthyear < 1851), "1801-1850", IF((?birthyear < 1901), "1851-1900", IF((?birthyear < 1951), "1901-1950", "Post-1950") ) ) ) )) AS ?layer )
?person rdfs:label ?name FILTER (lang(?name) = "en")
?place rdfs:label ?birthplace FILTER (lang(?birthplace) = "en")
} ORDER BY ?birthyear
Distinct billionaires
The following query uses these:
- Properties: net worth (P2218) , place of birth (P19)
#title: Distinct billionaires SELECT ?locationLabel ?item ?itemLabel (MAX(?billion) as ?billions) WHERE { ?item wdt:P2218 ?worth. ?item wdt:P19 ?location . FILTER(?worth>1000000000). BIND(?worth/1000000000 AS ?billion). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de". } } GROUP BY ?locationLabel ?item ?itemLabel ORDER BY DESC(?billions)
Countries that have adopted a cryptocurrency as legal tender
The following query uses these:
- Properties: instance of (P31) , currency (P38) , subclass of (P279)
# Countries that have adopted a cryptocurrency as legal tender SELECT ?country ?countryLabel ?currency ?currencyLabel WHERE { ?country wdt:P31 wd:Q6256. # Instances of country ?country wdt:P38 ?currency. # Country has currency ?currency wdt:P31/wdt:P279* wd:Q13479982. # Currency is instance or subclass of cryptocurrency SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Business listed on NYSE and NASDAQ along with their ticker symbols
The following query uses these:
- Properties: stock exchange (P414) , ticker symbol (P249)
# Business listed on NYSE and NASDAQ along with their ticker symbols SELECT DISTINCT ?id ?idLabel ?exchangesLabel ?ticker WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } ?id p:P414 ?exchange. VALUES ?exchanges { wd:Q13677 wd:Q82059 } ?exchange ps:P414 ?exchanges; pq:P249 ?ticker. }
Science
Biology and Medicine
Diseases
The number of existing translations for diseases in Wikidata
Items used: disease (Q12136)
SELECT ?disease ?doid ?enLabel (count(?language) as ?languages)
WHERE
{
?disease wdt:P699 ?doid ;
rdfs:label ?label ;
rdfs:label ?enLabel .
FILTER (lang(?enLabel) = "en")
BIND (lang(?label) AS ?language)
}
GROUP BY ?disease ?doid ?enLabel
ORDER BY desc(?languages)
A network of Drug-disease interactions on infectious diseases (Source: Disease Ontology, NDF-RT and ChEMBL)
#defaultView:Graph
SELECT DISTINCT ?item ?itemLabel ?rgb ?link
WHERE
{
VALUES ?toggle { true false }
?disease wdt:P699 ?doid;
wdt:P279+ wd:Q18123741;
wdt:P2176 ?drug.
?drug rdfs:label ?drugLabel.
FILTER(LANG(?drugLabel) = "en").
?disease rdfs:label ?diseaseLabel.
FILTER(LANG(?diseaseLabel) = "en").
BIND(IF(?toggle,?disease,?drug) AS ?item).
BIND(IF(?toggle,?diseaseLabel,?drugLabel) AS ?itemLabel).
BIND(IF(?toggle,"FFA500","7FFF00") AS ?rgb).
BIND(IF(?toggle,"",?disease) AS ?link).
}
The number of Wikidata items on Diseases and the percentage of those with a pointer to the Disease Ontology
SELECT (COUNT(?disease) AS ?total) (SUM(?ref) AS ?byDO) (100*?byDO/?total AS ?percent)
WHERE
{
{?disease wdt:P31 wd:Q12136 }
UNION
{?disease wdt:P279 wd:Q12136 .}
OPTIONAL {
?disease p:P699 ?statement.
BIND(1 AS ?ref).
}
}
Infectious diseases with their human minimum and maximum incubation time (in days)
SELECT ?DiseaseLabel ((?min / 86400) AS ?Minimal_Incubation_Time) ((?max / 86400) AS ?Maximum_Incubation_Time)
WHERE {
?Disease wdt:P31/wdt:P279* wd:Q18123741 .
?Disease p:P3488/psn:P3488/wikibase:quantityAmount ?min .
?Disease p:P3487/psn:P3487/wikibase:quantityAmount ?max
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
}
ORDER BY ?DiseaseLabel
Genes
Human genes updated this week
SELECT DISTINCT ?item ?ncbi_gene ?date_modified
WHERE
{
?item wdt:P351 ?ncbi_gene ;
wdt:P703 wd:Q15978631 ;
schema:dateModified ?date_modified .
BIND (now() - ?date_modified as ?date_range)
FILTER (?date_range < 8)
}
Variants
Counts of gene-variant types sourced from the CIViC database
#defaultView:BarChart
SELECT ?variant_typeLabel (count(?variant_typeLabel) as ?counts)
WHERE
{
?item wdt:P3329 ?civic_id ;
wdt:P31 ?variant_type .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
GROUP BY ?variant_typeLabel
ORDER BY ?counts
Which variant of which gene predicts a positive prognosis in colorectal cancer
SELECT ?geneLabel ?variantLabel
WHERE
{
VALUES ?disease {wd:Q188874}
?variant wdt:P3358 ?disease ; # P3358 Positive prognostic predictor
wdt:P3433 ?gene . # P3433 biological variant of
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
Variants that are associated with renal cell carcinoma
# variants that are associated with renal cell carcinoma
SELECT DISTINCT ?civic_id ?item ?itemLabel
WHERE
{
VALUES ?property {
wdt:P3356 # positive diagnostic predictor
wdt:P3357 # negative diagnostic predictor
wdt:P3358 # positive prognostic predicator
wdt:P3359 # negative prognostic predictor
}
?item wdt:P3329 ?civic_id .
{?item ?property wd:Q1164529.} # wd:Q1164529 = renal cell carcinoma
UNION
{?item p:P3354 ?o . # positive therapeutic predictor
?o pq:P2175 wd:Q1164529 .}
UNION
{?item p:P3354 ?o . # negative therapeutic predictor
?o pq:P2175 wd:Q1164529 .}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
PubMed references in CIViCdb
# variants that are associated with renal cell carcinoma
SELECT DISTINCT ?reference ?referenceLabel ?pmid
WHERE
{
?item wdt:P3329 ?civicId ;
?property ?object .
?object prov:wasDerivedFrom ?provenance .
?provenance pr:P248 ?reference .
?reference wdt:P31 wd:Q13442814 ;
wdt:P698 ?pmid .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
Variant counts by predictor type
#defaultView:BubbleChart
SELECT ?propertyLabel (count(?prognostic_type) as ?counts)
WHERE
{
VALUES ?prognostic_type {wdt:P3354 wdt:P3355 wdt:P3356 wdt:P3357 wdt:P3358 wdt:P3359}
?item wdt:P3329 ?civic_id ;
?prognostic_type ?prognostic_value .
?property wikibase:directClaim ?prognostic_type .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
GROUP BY ?propertyLabel ?prognostic_typeLabel
ORDER BY ?counts
Proteins
Get Wikidata - UniprotId mappings for homo sapiens
SELECT ?item ?itemLabel ?uniprotid ?tax_node
WHERE
{
?item wdt:P352 ?uniprotid ;
wdt:P703 wd:Q15978631 .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Metabolites
Metabolites and the species where they are found in
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX prov: <http://www.w3.org/ns/prov#>
SELECT ?compound ?compoundLabel ?speciesLabel ?sourceLabel ?doi ?wpid WHERE {
?compound wdt:P31 wd:Q11173.
MINUS { ?compound wdt:P31 wd:Q8054. }
?compound p:P703 ?statement.
?statement rdf:type wikibase:BestRank.
?statement ps:P703 ?species.
OPTIONAL {
?statement (prov:wasDerivedFrom/pr:P248) ?source.
OPTIONAL { ?source wdt:P2410 ?wpid. }
OPTIONAL { ?source wdt:P356 ?doi. }
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY ASC(?compound)
Metabolite-metabolite interactions (mostly conversions) and their pKa change (federated query)
Federated query using the WikiPathways SPARQL endpoint to retrieve interaction information. The dimensions plot show the pKa changes during metabolite-metabolite interaction. It must be noted here that many very basic or very acidic are reported in pathways as the uncharged structure, whereas in normal biological pathways these compounds are charged and then have quite different pKa charges.
#defaultView:Dimensions
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wp: <http://vocabularies.wikipathways.org/wp#>
PREFIX dcterms: <http://purl.org/dc/terms/>
SELECT DISTINCT ?wpid ?metaboliteLabel ?pKa ?pKa2 ?metabolite2Label ?wpid2
WITH {
SELECT ?wpid ?source_pathway ?metabolite ?pKa ?pKa2 ?metabolite2 ?wpid2
WHERE {
# VALUES ?wpid { "WP550" }
?pathway wdt:P2410 ?wpid ;
wdt:P527 ?metabolite ;
wdt:P2888 ?source_pathway .
?metabolite wdt:P1117 ?pKa .
SERVICE <http://sparql.wikipathways.org/sparql> {
?wp_mb1 wp:bdbWikidata ?metabolite .
?wp_mb1 dcterms:isPartOf ?interaction .
?interaction rdf:type wp:Interaction .
?wp_mb2 dcterms:isPartOf ?interaction .
?wp_mb2 wp:bdbWikidata ?metabolite2 .
FILTER (?wp_mb1 != ?wp_mb2)
}
}
} AS %result
WHERE {
INCLUDE %result
?metabolite2 wdt:P1117 ?pKa2 .
?pathway2 wdt:P2410 ?wpid2 ;
wdt:P527 ?metabolite2 ;
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Taxon
Asterophryinae parent taxon reverse graph
#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:Q1968598;
gas:traversalDirection "Reverse" ;
gas:out ?item ;
gas:out1 ?depth ;
gas:maxIterations 3 ;
gas:linkType wdt:P171 .
}
OPTIONAL { ?item wdt:P171 ?linkTo }
OPTIONAL { ?item wdt:P18 ?pic }
SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}
Pathways
All human pathways from Wikipathways
SELECT ?pathway ?pathwayLabel ?wpid WHERE {
?pathway wdt:P2410 ?wpid ;
wdt:P703 wd:Q15978631 .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Biomarkers in Wikidata which interact with proteins in human pathways from Wikipathways
prefix void: <http://rdfs.org/ns/void#>
prefix pav: <http://purl.org/pav/>
prefix xsd: <http://www.w3.org/2001/XMLSchema#>
prefix freq: <http://purl.org/cld/freq/>
prefix biopax: <http://www.biopax.org/release/biopax-level3.owl#>
prefix skos: <http://www.w3.org/2004/02/skos/core#>
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix gpml: <http://vocabularies.wikipathways.org/gpml#>
prefix wp: <http://vocabularies.wikipathways.org/wp#>
prefix dcterms: <http://purl.org/dc/terms/>
prefix wprdf: <http://rdf.wikipathways.org/>
prefix prov: <http://www.w3.org/ns/prov#>
prefix foaf: <http://xmlns.com/foaf/0.1/>
prefix dc: <http://purl.org/dc/elements/1.1/>
SELECT DISTINCT ?biomarkerLabel ?proteinLabel ?geneID ?WP_gene ?PathwayID ?PathwayName #results that are displayed.
WHERE {
VALUES ?biomarker {wd:Q420633 wd:Q27125809 wd:Q422462} #you can add more biomarkers here if needed, separated by a space.
?biomarker wdt:P31 wd:Q11173. #Stating that all biomarkers have to be "instance of" "chemical compound" (you could ommit this, but query will probably take longer).
?biomarker wdt:P638 ?pdbID . #Checking if a biomarker has a Protein Databank ID (PDB) -> meaning the metabolite can interact with a protein.
?protein wdt:P31 wd:Q8054 . #Stating that all proteins are "instance of" "protein"
?protein wdt:P638 ?pdbID . #Checking which proteins have a PDB ID, which we queried previously in relationship to the biomarkers.
?protein wdt:P702 ?gene . #Connecting the protein to a gene ("encoded by" relationship) -> to get an identifier we can use later in federated WikiPathways query.
?gene wdt:P703 wd:Q15978631 . #Now removing all genes that are not found in species "Homo sapiens". -> This info is not always available for proteins in WikiData.
?gene wdt:P2888 ?geneID . #Getting the "exact match" identifier for the gene, related to the protein, related to the biomarker.
##The IRI from Wikidata starts with http:// , where the one from WikiPathways starts with https:// , so we need to rewrite the IRI
BIND( # Bind the created IRI into a new variable (called ?newIRI)
IRI( # Convert the string back to an IRI
CONCAT( # Concatenate item 1 and 2 together as one string
"https", # First item to concat (more items can be added with a comma
#Second item to concat:
SUBSTR( # Obtain a substring
STR(?geneID), # Convert the geneID IRI from Wikidata to a string,
5) # removing the first 5 characters (<http)
)) AS ?newIRI # Name for the new variable
)
SERVICE <http://sparql.wikipathways.org/sparql> { #Connecting to the WikiPathways SPARQL endpoint.
?WP_pathway a wp:Pathway . #Stating a ?WP_pathway is indeed a pathway in the WikiPathways RDF .
?WP_pathway wp:organismName "Homo sapiens" . #Removing all PWs not for species Homo sapiens.
?WP_pathway dc:identifier ?PathwayID . #Query the identifier of the pathway in WPs.
?WP_pathway dc:title ?PathwayName . #Obtaining the name of the pathway.
?WP_gene a wp:Protein . #Stating that a ?WP_gene is a Protein DataNode (you could ommit this, to also get all DataNodes modeled as GeneProducts out, but query will take longer).
?WP_gene wp:bdbEntrezGene ?newIRI . #Connecting the previously queried "exact match" from WikiData to the NCBI/Entrez Gene ID in WPs.
?WP_gene dcterms:isPartOf ?WP_pathway . #Connecting the WP_gene to the WP_pathway.
}
OPTIONAL {?biomarker rdfs:label ?biomarkerLabel. #Create a label (aka name) for the biomarkers in WikiData, without using the service query.
FILTER(LANG(?biomarkerLabel) = "en").
}
OPTIONAL {?protein rdfs:label ?proteinLabel. #Create a label(aka name) for the proteins in WikiData, without using the service query.
FILTER(LANG(?proteinLabel) = "en").
}
}
ORDER BY DESC (?biomarkerLabel) #Order results for biomarkers
Ranking of most cited work in WikiPathways
SELECT ?citation ?citationLabel (count(?pathway) as ?times_cited) WHERE {
?pathway wdt:P2410 ?WikiPathwaysID ;
wdt:P2860 ?citation .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
GROUP BY ?pathway ?citation ?citationLabel
Gene and metabolite counts per pathway
#Gene and metabolite counts per path
#defaultView:ScatterChart
SELECT ?path ?genes ?metabolites ?pathway WHERE {
{SELECT DISTINCT ?path (COUNT(?pwPart) AS ?genes) WHERE {
?path wdt:P2410 ?WikipathsID.
?path wdt:P527 ?pwPart.
?pwPart wdt:P31 wd:Q7187.
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
GROUP BY ?path ?genes
}
{SELECT DISTINCT ?path (COUNT(?pwPart) AS ?metabolites) WHERE {
?path wdt:P2410 ?WikipathsID.
?path wdt:P527 ?pwPart.
?pwPart wdt:P31 wd:Q11173.
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
GROUP BY ?path ?metabolites
}
OPTIONAL { ?path rdfs:label ?pathway. }
}
ORDER BY DESC(?genes)
Biological pathways with protein structures in the PDB database
SELECT ?pathway ?pathwayLabel ?WikiPathways ?Reactome (COUNT(DISTINCT ?protein) as ?count) WHERE {
VALUES ?pathwayType { wd:Q4915012 wd:Q2996394 }
?pathway wdt:P31 ?pathwayType .
{ ?pathway wdt:P527/wdt:P688 ?protein . } UNION { ?pathway wdt:P527 ?protein . }
?protein wdt:P638 ?PDBID .
OPTIONAL { ?pathway wdt:P2410 ?WikiPathways }
OPTIONAL { ?pathway wdt:P3937 ?Reactome }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?pathway ?pathwayLabel ?WikiPathways ?Reactome
ORDER BY DESC(?count)
Get known variants reported in CIViC database (Q27612411) of genes reported in a Wikipathways pathway: Bladder cancer (Q30230812)
SELECT DISTINCT ?pathway ?pathwayLabel ?pwpart ?pwpartLabel ?variant ?variantLabel ?disease?diseaseLabel WHERE {
VALUES ?predictor {p:P3354 p:P3355 p:P3356 p:P3357 p:P3358 p:P3359}
VALUES ?predictorQualifier {pq:P2175}
VALUES ?wpID {"WP2828"}
?pathway wdt:P2410 ?wpID ; # Pathways has a Wikipathways identifier
wdt:P527 ?pwpart . # which contains pathways parts
?disease wdt:P279+ wd:Q504775 . # The disease is a subclass of urinary bladder cancer
# based on annotations in the Disease ontology
?variant wdt:P3329 ?civicID ; # a variant known in CIViC
?predictor ?node ; # has a predicting relation with diseases
# labeled as being a subclass of urinary bladder cancer
wdt:P3433 ?pwpart . # variant is biological variant of
{?node ?predictorStatement ?drug_label ;
?predictorQualifier ?disease .}
UNION
{
?node ?predictorStatement ?disease .
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Known interaction types in Wikipathways for a pathway with Identifier WP716 (federated query)
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX wp: <http://vocabularies.wikipathways.org/wp#>
SELECT DISTINCT ?interaction_type WHERE {
VALUES ?wpid {"WP716"}
?item wdt:P2410 ?wpid ;
wdt:P2888 ?source_pathway .
SERVICE <http://sparql.wikipathways.org/sparql> {
?wp_pathway dc:identifier ?source_pathway .
?s dcterms:isPartOf ?wp_pathway, ?interaction .
?interaction rdf:type wp:Interaction .
?interaction rdf:type ?interaction_type .
?interaction wp:participants ?participants .
}
}
Local annotations from Wikipathways using Federated query on a Pathway with identifier WP716 (federated query)
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX wp: <http://vocabularies.wikipathways.org/wp#>
SELECT DISTINCT ?item ?pw_annotation WHERE {
VALUES ?wpid {"WP716"}
?item wdt:P2410 ?wpid ;
wdt:P2888 ?source_pathway .
SERVICE <http://sparql.wikipathways.org/sparql> {
?wp_pathway dc:identifier ?source_pathway .
?wp_pathway wp:ontologyTag ?pw_annotation .
# ?pw_annotation rdfs:label ?annotation_label .
}
}
#cases where a drug physically interacts with the product of gene known to be genetically associated a disease
#these cases may show opportunities to repurpose a drug for a new disease
#See http://database.oxfordjournals.org/content/2016/baw083.long and
#http://drug-repurposing.nationwidechildrens.org/search
#an example that was recently validated involved a new link between Metformin wd:Q19484 and cancer survival
#https://jamia.oxfordjournals.org/content/22/1/179
#currently set up to find drugs for cancers that target genes related to cell proliferation
#adapt by changing constraints (e.g. to 'heart disease' Q190805) or removing them
SELECT ?drugLabel ?geneLabel ?biological_processLabel ?diseaseLabel
WHERE {
?drug wdt:P129 ?gene_product . # drug interacts with a gene_product
?gene wdt:P688 ?gene_product . # gene_product (usually a protein) is a product of a gene (a region of DNA)
?disease wdt:P2293 ?gene . # genetic association between disease and gene
?disease wdt:P279* wd:Q12078 . # limit to cancers wd:Q12078 (the * operator runs up a transitive relation..)
?gene_product wdt:P682 ?biological_process . #add information about the GO biological processes that the gene is related to
?biological_process (wdt:P361|wdt:P279)* wd:Q189101 . # chain down subclass/part-of
#Change the last statement (wd:Q14818032) to limit to genes related to certain biological processes (and their sub-processes):
#cell proliferation wd:Q14818032 (Current example)
#apoptosis wd:Q14599311
#uncomment the next line to find a subset of the known true positives (there are not a lot of them in here yet; will lead to 4 drugs if biological process is cell proliferation 2018-12-17)
#?disease wdt:P2176 ?drug . # disease is treated by a drug
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
}
LIMIT 1000
Parent taxons of Blue Whale
- Items used: Balaenoptera musculus (Q42196)
- Properties used: image (P18) parent taxon (P171)
#defaultView:Graph
SELECT ?item ?itemLabel ?pic ?linkTo
WHERE
{
wd:Q42196 wdt:P171* ?item
OPTIONAL { ?item wdt:P171 ?linkTo }
OPTIONAL { ?item wdt:P18 ?pic }
SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}
Mosquito species
- Items used: taxon (Q16521) species (Q7432) Culicidae (Q7367)
- Properties used: instance of (P31) taxon rank (P105) parent taxon (P171) taxon name (P225)
# Species of mosquitoes
# added 2017-06
SELECT ?item ?taxonname WHERE {
?item wdt:P31 wd:Q16521 ;
wdt:P105 wd:Q7432 ;
wdt:P171* wd:Q7367 ;
wdt:P225 ?taxonname .
}
Taxons and what they are named after
SELECT ?taxon ?eponym ?taxonName ?eponymLabel
WHERE
{
?taxon wdt:P31 wd:Q16521;
wdt:P225 ?taxonName;
wdt:P138 ?eponym.
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY ?eponym
Biologists with Twitter accounts
SELECT DISTINCT ?personLabel (CONCAT("https://twitter.com/",?twitterName) AS ?twitterlink) ?pic
WHERE {
?person wdt:P2002 ?twitterName ;
wdt:P106 ?occupation .
OPTIONAL { ?person wdt:P18 ?pic . }
?occupation wdt:P279* wd:Q864503 . # all subclasses of biologists
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en"
}
}
Cell lines with names that could also be URLs (Internet of Cell Lines).
SELECT * WHERE {
{
SELECT ?cell_line ?cell_line_name WHERE {
?cell_line wdt:P31 wd:Q21014462;
rdfs:label ?cell_line_name.
FILTER(LANG(?cell_line_name) = "en").
Filter REGEX(STR(?cell_line_name), "^[\\w\\-\\.]+\\.[A-z]+$")
}
}
?tld wdt:P31/wdt:P279* wd:Q14296;
rdfs:label ?tld_name.
FILTER(LANG(?tld_name) = "en").
FILTER REGEX(STR(?cell_line_name), CONCAT(REPLACE(?tld_name, "\\.", "\\\\."), "$"), "i")
BIND(URI(CONCAT("http://", ?cell_line_name)) as ?url)
}
List of pharmaceutical drugs with picture
SELECT ?moleculeLabel ?formule ?picture ?molecule
WHERE
{
?molecule wdt:P31 wd:Q12140
; wdt:P274 ?formule
; wdt:P117 ?picture
SERVICE wikibase:label { bd:serviceParam wikibase:language "en, de" . }
}
ORDER BY ?moleculeLabel
Organisms that are located in the female urogential tract and that have a gene with product indole
- Items used: vagina (Q5880) 1H-indole (Q319541)
- Properties used: location (P276) found in taxon (P703) product or material produced or service provided (P1056)
SELECT ?organism_name
WHERE
{
?organism_item wdt:P2974 wd:Q5880
; rdfs:label ?organism_name .
?gene wdt:P703 ?organism_item
; wdt:P1056 wd:Q319541 .
FILTER (LANG(?organism_name) = "en") .
}
Threatened Species of Animals as per IUCN Classification
#title: Animals which are Threatened as per IUCN Red List
# https://en.wikipedia.org/wiki/Conservation_status
# Common names are in English only
SELECT ?animal ?scientific_names ?common_names ?statusLabel where
{
# hint:Prior hint:runLast true
{
SELECT DISTINCT ?animal (GROUP_CONCAT(DISTINCT ?scientific_name; separator=", ") as ?scientific_names) (GROUP_CONCAT(DISTINCT ?common_name; separator=", ") as ?common_names) WHERE
{
?animal wdt:P141 ?status;
wdt:P225 ?scientific_name;
wdt:P1843 ?common_name.
filter( ?status
IN (
wd:Q11394, #Endangered
wd:Q219127, #critcally endangered
wd:Q278113 #vulnurable
)
).
# Only return common names in English
FILTER(LANGMATCHES(LANG(?common_name), "en"))
}
GROUP BY ?animal
}.
?animal wdt:P141 ?status.
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Computer Science and Technology
List of computer files formats
SELECT DISTINCT ?idExtension ?extension ?mediaType ?idExtensionLabel
WHERE
{
?idExtension wdt:P31 wd:Q235557
; wdt:P1195 ?extension .
OPTIONAL { ?idExtension wdt:P1163 ?mediaType }
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?extension ?mediaType
List of W3C standards
SELECT DISTINCT ?standard ?standardLabel ?website
WHERE
{
?standard wdt:P1462 wd:Q37033 .
OPTIONAL{ ?standard wdt:P856 ?website }
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?standardLabel
Oldest software
SELECT ?software ?softwareLabel ?date (ROUND((NOW() - ?date)/365.2425) AS ?age)
{
?software wdt:P31/wdt:P139* wd:Q7397.
OPTIONAL { ?software wdt:P571 ?date. }
OPTIONAL { ?software p:P348/pq:P577 ?date. }
FILTER(BOUND(?date)).
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY ?date
LIMIT 10
Software written in Go programming language
SELECT DISTINCT ?instance_of ?instance_ofDescription ?instance_ofLabel ?official_website WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
?instance_of (wdt:P31/(wdt:P279*)) wd:Q341.
OPTIONAL { ?instance_of wdt:P856 ?official_website. }
?instance_of wdt:P277 wd:Q37227.
}
Free and open-source software written in Go programming language
SELECT DISTINCT ?instance_of ?instance_ofDescription ?instance_ofLabel ?official_website WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
?instance_of wdt:P31/wdt:P279* wd:Q341
OPTIONAL { ?instance_of wdt:P856 ?official_website. }
?instance_of wdt:P277 wd:Q37227.
}
Universities of main programming language authors
SELECT ?lang ?langLabel ?human ?humanLabel ?educatedat ?educatedatLabel ?coords
{
?lang wdt:P31/wdt:P279* wd:Q9143 .
?human wdt:P31 wd:Q5 .
{ ?lang wdt:P287 ?human } UNION { ?lang wdt:P170 ?human } UNION { ?lang wdt:P943 ?human } UNION { ?lang wdt:P178 ?human } .
?human wdt:P69 ?educatedat .
?educatedat wdt:P625 ?coords .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,fr" }
}
LIMIT 100
Websites with OpenAPI endpoints
SELECT ?database ?databaseLabel ?license ?licenseLabel ?value WHERE {
?database ?p ?wds .
OPTIONAL { ?database wdt:P275 ?license }
?wds ?v ?value.
?wdP wikibase:statementProperty ?v.
?wdP wikibase:claim ?p.
?wds pq:P31 wd:Q27075870.
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
} ORDER BY ASC(?databaseLabel)
E-Readers that support the mobipocket file format
SELECT ?ereader ?ereaderLabel
WHERE {
?ereader wdt:P31 wd:Q726235 .
?ereader wdt:P1072 wd:Q1941622 .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
}
Software applications ranked in descending order by the number of writable file formats
#defaultView:BubbleChart
#title:Software applications ranked in descending order by the number of writable file formats
SELECT ?app ?appLabel (COUNT(?format) AS ?count)
WHERE {
?app (p:P31/ps:P31/wdt:P279) wd:Q7397 .
?app wdt:P1072 ?format .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
}
GROUP BY ?app ?appLabel
ORDER BY DESC(?count)
Return a bubble chart of mediatypes by count of file formats
SELECT DISTINCT ?mediaType (COUNT (?ff) as ?count)
WHERE
{
?ff wdt:P31/wdt:P279* wd:Q235557.
?ff wdt:P1163 ?mediaType.
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
GROUP BY ?mediaType
ORDER BY DESC (?count)
Erdos Numbers and images of people who have oral histories in the Computer History Museum's collection
#defaultView:ImageGrid
SELECT ?personLabel ?image ?Erdos
WHERE {
?person wdt:P485 wd:Q964035 .
?person wdt:P18 ?image .
?person wdt:P2021 ?Erdos
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
}
Chemistry
Chemical elements and their properties
SELECT ?elementLabel ?_boiling_point ?_melting_point ?_electronegativity ?_density ?_mass
WHERE
{
?element wdt:P31 wd:Q11344.
?element wdt:P2102 ?_boiling_point.
?element wdt:P2101 ?_melting_point.
?element wdt:P1108 ?_electronegativity.
?element wdt:P2054 ?_density.
?element wdt:P2067 ?_mass.
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
LIMIT 100
Chemical elements and their isotopes by number of neutrons (min/max)
SELECT ?element (SAMPLE(?symbol) AS ?symbol) (SAMPLE(?protons) AS ?protons) (MIN(?neutrons) AS ?minNeutrons) (MAX(?neutrons) AS ?maxNeutrons)
WHERE
{
?element wdt:P31 wd:Q11344;
wdt:P1086 ?protons;
wdt:P246 ?symbol.
?isotope wdt:P279 ?element;
wdt:P1148 ?neutrons.
}
GROUP BY ?element
ORDER BY ?protons
Colors of chemical compounds
#defaultView:BubbleChart
SELECT ?rgb ?colorLabel (COUNT(?compound) AS ?count)
WHERE
{
?compound wdt:P31 wd:Q11173;
wdt:P462 ?color.
OPTIONAL { ?color wdt:P465 ?rgb. }
BIND(IF(BOUND(?rgb),?rgb,"CCCCCC") AS ?rgb).
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
GROUP BY ?rgb ?colorLabel
All pKa data in Wikidata and the source titles
SELECT ?compound ?compoundLabel ?pKa ?source ?sourceLabel ?doi
WHERE
{
?compound wdt:P31 wd:Q11173 ; p:P1117 ?statement .
?statement rdf:type wikibase:BestRank ;
ps:P1117 ?pKa .
OPTIONAL {
?statement prov:wasDerivedFrom/pr:P248 ?source .
OPTIONAL { ?source wdt:P356 ?doi . }
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } #English label
}
All CAS registry numbers in Wikidata
SELECT DISTINCT ?compound ?compoundLabel ?cas
WHERE
{
?compound wdt:P231 ?cas .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Chemical compounds in Wikidata sharing the same CAS registry number
#two chemical compounds with the same CAS registry number
SELECT DISTINCT ?cas ?compound1 ?compound1Label ?compound2 ?compound2Label WHERE {
?compound1 wdt:P231 ?cas .
?compound2 wdt:P231 ?cas .
FILTER (?compound1 != ?compound2)
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
The number of Chemical compounds in Wikidata sharing the same CAS registry number
#The number of times a cas registry number is shared by distinct Wikidata items
SELECT ?cas ?items
WHERE
{
{SELECT DISTINCT ?cas (count(?compound) as ?items) WHERE {
?compound wdt:P231 ?cas .
}
GROUP BY ?cas }
FILTER (?items >1)
}
ORDER BY desc(?items)
Awarded Chemistry Nobel Prizes
#defaultView:Timeline
SELECT DISTINCT ?item ?itemLabel ?when (YEAR(?when) as ?date) ?pic
WHERE {
?item p:P166 ?awardStat . # … with an awarded(P166) statement
?awardStat ps:P166 wd:Q44585 . # … that has the value Nobel Prize in Chemistry (Q35637)
?awardStat pq:P585 ?when . # when did they receive the Nobel prize
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
OPTIONAL { ?item wdt:P18 ?pic }
}
Images of organic acids
#defaultView:ImageGrid
SELECT ?compound ?compoundLabel ?image WHERE {
?compound wdt:P279+|wdt:P31+ wd:Q421948 ;
wdt:P18|wdt:P117 ?image .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Boiling points of alkanes
SELECT DISTINCT ?comp ?compLabel ?formula ?bp ?bpUnit ?bpUnitLabel WHERE {
?comp wdt:P31/wdt:P279* wd:Q41581 ;
wdt:P274 ?formula ;
p:P2102 [
ps:P2102 ?bp ;
psv:P2102/wikibase:quantityUnit ?bpUnit
] .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY DESC(?bpUnit) ASC(?bp)
Solubilities of chemicals
SELECT DISTINCT ?chemical ?chemicalLabel ?value ?units ?unitsLabel ?solvent ?solventLabel ?temperature ?temperatureUnit ?temperatureUnitLabel ?source ?sourceLabel ?doi
WITH {
SELECT DISTINCT ?chemical ?value ?units ?source ?doi ?solvent ?temperature ?temperatureUnit WHERE {
?chemical ?propp ?statement .
?statement a wikibase:BestRank ;
?proppsv [
wikibase:quantityAmount ?value ;
wikibase:quantityUnit ?units
] .
OPTIONAL {
?statement prov:wasDerivedFrom/pr:P248 ?source .
OPTIONAL { ?source wdt:P356 ?doi . }
}
?property wikibase:claim ?propp ;
wikibase:statementValue ?proppsv ;
wdt:P1629 wd:Q170731 ;
wdt:P31 wd:Q21077852 .
OPTIONAL {
?statement pqv:P2076 ?temperatureNode .
?temperatureNode wikibase:quantityAmount ?temperature ;
wikibase:quantityUnit ?temperatureUnit .
}
OPTIONAL {
wd:P2178 wikibase:qualifier ?qualifierS .
?qualifierS a owl:ObjectProperty .
?statement ?qualifierS ?solvent .
}
} GROUP BY ?chemical ?value ?units ?temperature ?temperatureUnit ?solvent ?source ?doi
} AS %result
WHERE {
INCLUDE %result
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ASC(?propEntityLabel)
Space
Who discovered the most asteroids?
SELECT ?discoverer ?discovererLabel ?count
WITH {
SELECT ?discoverer (COUNT(?asteroid) AS ?count)
WHERE {
?asteroid wdt:P31 wd:Q3863;
wdt:P61 ?discoverer .
}
GROUP BY ?discoverer
ORDER BY DESC(?count)
LIMIT 20
} AS %i
WHERE {
INCLUDE %i
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
}
ORDER BY DESC(?count)
Who discovered the most planets? (with list)
SELECT
?discoverer ?discovererLabel
(COUNT(DISTINCT ?planet) as ?count)
(GROUP_CONCAT(DISTINCT(?planetLabel); separator=", ") as ?planets)
WHERE
{
?ppart wdt:P279* wd:Q634 .
?planet wdt:P31 ?ppart .
?planet wdt:P61 ?discoverer .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
?discoverer rdfs:label ?discovererLabel .
?planet rdfs:label ?planetLabel
}
}
GROUP BY ?discoverer ?discovererLabel
ORDER BY DESC(?count)
List of space probes with pictures
#defaultView:ImageGrid
SELECT ?spaceProbeLabel ?date ?picture
WHERE
{
?spaceProbe wdt:P31 wd:Q26529;
wdt:P18 ?picture;
wdt:P619 ?date . #mandatory
SERVICE wikibase:label {
bd:serviceParam wikibase:language "fr,en" .
}
}
ORDER BY ?date
LIMIT 88
Birthplaces of astronauts
# select all astronauts with name, image, birthdate, birthplace and coordinates of the birthplace
SELECT ?astronaut ?astronautLabel ?image ?birthdate ?birthplace ?coord WHERE {
?astronaut ?x1 wd:Q11631;
wdt:P18 ?image;
wdt:P569 ?birthdate;
wdt:P19 ?birthplace.
?birthplace wdt:P625 ?coord
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY DESC(?birthdate)
(Artist) Images of Exoplanets
#defaultView:ImageGrid
SELECT ?exoplanet ?exoplanetLabel ?image WHERE {
?exoplanet wdt:P31 wd:Q44559 ;
wdt:P18 ?image .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Scientists
Number of scientists per gender
- Items used: human (Q5), scientist (Q901)
- Properties used: sex or gender (P21), instance of (P31), occupation (P106), subclass of (P279)
SELECT ?gender (count(DISTINCT ?human) as ?number)
WHERE
{
?human wdt:P31 wd:Q5
; wdt:P21 ?gender
; wdt:P106/wdt:P279* wd:Q901 .
}
GROUP BY ?gender
LIMIT 10
Most eponymous mathematicians
- Items used: mathematician (Q170790)
- Properties used: named after (P138) occupation (P106)
SELECT ?eponym ?eponymLabel ?count ?sample ?sampleLabel
WHERE
{
{
SELECT ?eponym (COUNT(?item) as ?count) (SAMPLE(?item) AS ?sample)
WHERE
{
?item wdt:P138 ?eponym.
?eponym wdt:P106 wd:Q170790.
}
GROUP BY ?eponym
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY DESC(?count)
Authors of scientific articles by occupation
#defaultView:BubbleChart
SELECT ?occupationLabel (count(DISTINCT ?author) as ?count)
WHERE
{
?object wdt:P31 wd:Q13442814
; wdt:P50 ?author .
?author wdt:P106 ?occupation .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,fr" }
}
GROUP BY ?occupationLabel
ORDER BY DESC(?count)
Authors of scientific articles who received a Nobel prize
#added in 2016-10
#Authors of scientific articles who received a Nobel prize
SELECT ?item ?itemLabel ?person ?personLabel ?_image ?award ?awardLabel
WHERE {
?person wdt:P166 ?award ; #person received an award
wdt:P31 wd:Q5 . #person is instance of human
?award wdt:P31/wdt:P279* wd:Q7191 . #award is a Nobel Prize
?item wdt:P50 ?person ; #person is an author of item
wdt:P31 wd:Q13442814 . #item is a scientific article
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
OPTIONAL { ?person wdt:P18 ?_image. } #Wikimedia Commons has an image of person
}
Using VALUES for extracting scientific articles of specific authors
- Items used: Lydia Pintscher (Q18016466) scholarly article (Q13442814)
- Properties used: instance of (P31) author (P50)
SELECT ?entity ?entityLabel ?authorLabel WHERE {
VALUES ?author {wd:Q18016466} #initialize "?author with the Wikidata item "Lydia Pintscher"
?entity wdt:P31 wd:Q13442814. #filter by scientific articles
?entity wdt:P50 ?author.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Female scientists with most number of sitelinks (but not English Wikipedia)
#Female scientists with most number of sitelinks (but not English Wikipedia)
#PREFIX schema: <http://schema.org/>
SELECT ?item ?itemLabel ?linkcount WHERE {
?item wdt:P31 wd:Q5 .
?item wdt:P21 wd:Q6581072 .
?item wdt:P106 wd:Q901 .
?item wikibase:sitelinks ?linkcount .
FILTER (?linkcount >= 1) . # only include items with 1 or more sitelinks
FILTER NOT EXISTS {
?article schema:about ?item .
?article schema:inLanguage "en" .
?article schema:isPartOf <https://en.wikipedia.org/>
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de,es,ar,fr" }
}
GROUP BY ?item ?itemLabel ?linkcount
ORDER BY DESC(?linkcount)
Inventors killed by their own invention
SELECT ?inventor ?inventorLabel ?gadget ?gadgetLabel WHERE {
?inventor wdt:P157 ?gadget.
?gadget wdt:P61 ?inventor.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Most cited female authors
#added 2016-12
##defaultView:BubbleChart
SELECT ?author ?authorLabel (COUNT(?publication) AS ?count)
WHERE
{
?item wdt:P2860 ?publication . #citations
?publication wdt:P50 ?author . #authors
?author wdt:P21 wd:Q6581072. #females
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
}
GROUP BY ?author ?authorLabel
ORDER BY DESC(?count)
Scientists who have worked together but whose Erdos numbers don’t reflect that
# Finds authors who have published scientific articles together,
# but whose Erdos numbers are more than one apart.
# These would appear to violate the definition of the Erdos number.
SELECT
# Q#s
?paper
?author1
?author2
# title (either from title statement or label)
(IF(BOUND(?title), ?title, ?paperLabel) AS ?title)
# author labels (should be names) and their Erdos numbers
?author1Label
?erdos1
?author2Label
?erdos2
# distance between Erdos numbers
?distance
WHERE
{
# paper, instance of or subclass of scientific article; also has two authors
?paper wdt:P31/wdt:P279* wd:Q13442814;
wdt:P50 ?author1, ?author2.
# if it has a title, we’ll grab that as well, but it’s also okay if there’s no title
OPTIONAL { ?paper wdt:P1476 ?title. }
# grab Erdos numbers of the two authors
?author1 wdt:P2021 ?erdos1.
?author2 wdt:P2021 ?erdos2.
# introduce a new variable for the difference of the Erdos numbers
BIND(?erdos2 - ?erdos1 AS ?distance).
# select those cases where the distance is > 1
# (note: by *not* taking the absolute value of the distance, we avoid getting duplicated cases because the author variables might be swapped)
FILTER(?distance > 1).
# get *Label variables automagically
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
# sort by distance first (descending), then by first author, then by second author
ORDER BY DESC(?distance) ?author1Label ?author2Label
Map of institutions where Canadian citizens got their PhD
#defaultView:Map
SELECT DISTINCT ?institution ?institutionLabel ?academics ?academicsLabel ?degree ?degreeLabel ?geoloc ?image WHERE {
?academics wdt:P31 wd:Q5 ; # instances (P31) of humans (Q5)
wdt:P27 wd:Q16 ; # country of citizenship
p:P69 ?statement . # check for an "educated at" (P69) statement
OPTIONAL { ?academics wdt:P18 ?image }. #image
?statement ps:P69 ?institution . # get value of the "educated at" statement, i.e. the institution
?institution wdt:P625 ?geoloc . # get the geolocation of the institution
?statement pq:P512 ?degree . # get qualifier "academic degree" (P512)
?degree wdt:P31/wdt:P279* wd:Q849697 . # filter for doctoral degrees
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Scientific literature
PMID-DOI mappings
SELECT DISTINCT ?pmid ?doi
WHERE
{
?item wdt:P698 ?pmid ;
wdt:P356 ?doi .
}
The number of statements by DOI
SELECT ?doi (COUNT (?entry) as ?entries)
{
?entry ?p ?statement .
?statement prov:wasDerivedFrom/pr:P248/wdt:P356 ?doi .
}
GROUP BY ?doi
ORDER BY DESC(?entries)
number of statements backed by a reference with a DOI
SELECT (COUNT (?statement) as ?statements)
WHERE
{
?entry ?p ?statement .
?statement prov:wasDerivedFrom/
<http://www.wikidata.org/prop/reference/P248>/
wdt:P356 ?doi .
}
Statements originating from a specific DOI
SELECT ?entryRes ?entry ?statement
WHERE
{
?entryRes ?p ?statement ;
rdfs:label ?entry .
?statement prov:wasDerivedFrom/
<http://www.wikidata.org/prop/reference/P248>/
wdt:P356 "10.1021/JA01577A030" .
FILTER(lang(?entry) = "en")
}
Translations of the Disease Ontology term DOID:399 (Tuberculosis)
- Properties used: Disease Ontology ID (P699) Wikimedia language code (P424)
SELECT ?English ?language ?label WHERE {
?disease wdt:P699 "DOID:399";
rdfs:label ?English;
rdfs:label ?label .
BIND(LANG(?label) as ?languageCode)
?wdLanguage wdt:P424 ?languageCode;
rdfs:label ?language .
FILTER EXISTS {?wdLanguage wdt:P31?/wdt:P279+ wd:Q17376908}
FILTER (LANG(?English)="en")
FILTER (LANG(?language)="en")
} ORDER BY ?language
Library and Information Science journals
- items used: scientific journal (Q5633421) library science (Q199655) library science (Q199655) information science (Q16387) library and information science (Q13420675)
- Properties used: instance of (P31) main subject (P921)
SELECT DISTINCT ?journal ?name WHERE {
?journal wdt:P31 wd:Q5633421 . # is scientific journal
{
{ ?journal wdt:P921 wd:Q199655 } # with topic library science
UNION { ?journal wdt:P921 wd:Q16387 } # and/or topic information science
UNION { ?journal wdt:P921 wd:Q13420675 } # and/or topic library and information science
}
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
?journal rdfs:label ?name .
}
}