archive.today webpage capture | Saved from | ||
| All snapshots | from host query.wikidata.org | ||
| WebpageScreenshot | |||
 share download .zip report bug or abuse Buy me a coffee | |||
short link
long link
markdown
html code
wiki code
Wikidata Query ServiceRendering result
Loading, please wait
Test error
Loading...
Explorer
382
| Simple queries | ||||
| Cats | P31|Q146 | SELECT ?item ?itemLabel WHERE { ?item wdt:P31 wd:Q146. # Must be a cat SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } # Helps get the label in your language, if not, then default for all languages, then en language } | ||
| Horses (showing some info about them) | P31|P279|Q726|Q726|P25|P22|P569|P570|P21 | #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 of and subclasses of Q726 (horse) OPTIONAL{?horse wdt:P25 ?mother .} # mother OPTIONAL{?horse wdt:P22 ?father .} # father OPTIONAL{?horse wdt:P569 ?birthdate .} # date of birth OPTIONAL{?horse wdt:P570 ?deathdate .} # date of death OPTIONAL{?horse wdt:P21 ?gender .} # sex or gender SERVICE wikibase:label { #BabelRainbow bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,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 | P31|Q146|P18 | #title: Cats, with pictures #defaultView:ImageGrid SELECT ?item ?itemLabel ?pic WHERE { ?item wdt:P31 wd:Q146; wdt:P18 ?pic. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } | ||
| Map of hospitals | P31|P279|Q16917|P625 | #added 2017-08 #defaultView:Map SELECT DISTINCT * WHERE { ?item wdt:P31/wdt:P279* wd:Q16917; wdt:P625 ?geo . } | ||
| Map of hackerspaces using country as color | P31|Q1032372|P625|P17 | #added 2021-12 #defaultView:Map{"layer":"?country"} SELECT DISTINCT * WHERE { ?item wdt:P31 wd:Q1032372; wdt:P625 ?geo ; wdt:P17 ?country } | ||
| Number of humans in Wikidata | P31|Q5 | #title: Number of humans in Wikidata SELECT (COUNT(*) AS ?count) WHERE { ?item wdt:P31 wd:Q5 . } | ||
| Humans born in New York City | P31|Q5|P19|P131|Q60|P19|Q60 | #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],mul,en" } } ORDER BY DESC(?sitelinks) | ||
| Humans who died on a specific date on the English Wikipedia, ordered by label | P570 | # 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 "[AUTO_LANGUAGE],mul,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],mul,en" . } } | |||
| Items about authors with a Wikispecies page | P31|Q5|P50 | #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],mul,en" . } } ORDER BY DESC(?count) | ||
| Recent events | P31|P279|Q1190554|P585|P580 | #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],mul,en" . } } | ||
| Popular eye colors among humans | P31|Q5|P1340|P465 | #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],mul,en". } } GROUP BY ?eyeColor ?eyeColorLabel ?rgb ORDER BY DESC(?count) | ||
| Humans whose gender we know we don't know | P31|Q5|P21 | #title: Humans whose gender we know we don't know # Demonstrates filtering for "unknown value" SELECT ?human ?humanLabel WHERE { ?human wdt:P31 wd:Q5 . # instance of human ?human wdt:P21 ?gender . FILTER wikibase:isSomeValue(?gender) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } | ||
| URLs of Wikipedia in all languages | #title: URLs of Wikipedia in all languages SELECT ?wikipedia WHERE { ?wikipedia wikibase:wikiGroup "wikipedia". } | |||
| Names of Wikipedia articles in multiple languages | Q5 | 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 | P1800|P1800 | # 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],mul,en". } } # remove or change limit for more results LIMIT 10 | ||
| All statements of an item containing another item (direct / first-degree connections) | Q12345|P18|P18 | #defaultView:Graph #TEMPLATE={ "template": { "en": "All statements of ?item containing another item" }, "variables": { "?item": {} } } SELECT ?item ?itemLabel ?itemImage ?value ?valueLabel ?valueImage ?edgeLabel WHERE { BIND(wd:Q12345 AS ?item) ?item ?wdt ?value. ?edge a wikibase:Property; wikibase:propertyType wikibase:WikibaseItem; # note: to show all statements, removing this is not enough, the graph view only shows entities wikibase:directClaim ?wdt. OPTIONAL { ?item wdt:P18 ?itemImage. } OPTIONAL { ?value wdt:P18 ?valueImage. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } | ||
| 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. } | |||
| Wikidata items with English spoken text audio | P989|P989|P989|P407|Q1860 | #title: Wikidata items with English spoken text audio SELECT DISTINCT ?item ?itemLabel WHERE { ?item p:P989 ?statement .# check for spoken text audio statement and exclude those without P989 value ?statement ps:P989 ?spokentext . ?statement pq:P407 ?lang . # get qualifier language FILTER(?lang = wd:Q1860) . # filter for EN SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } | ||
| Total population in the Øresund Region | P361|Q297853|P361|Q297853|P1082|P1082|P31|Q1907114|P31|Q1907114|P527|P527 | #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],mul,en". } } GROUP BY ?area ?areaLabel | ||
| Mayors that are any kind of domesticated animal | P279|Q622852|P31|P39|P39|Q30185|P642|P18 | #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],mul,en". } } | ||
| Mayors that are either a dog, a cat or a chicken | Q144|Q146|Q780|P31|P39|P39|Q30185|P642|P18 | # 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],mul,en". } } | ||
| Items in the Messier Catalog, with image | P528|P528|P972|Q14530|P18 | #defaultView:ImageGrid # Items in the Messier Catalog SELECT DISTINCT ?item ?itemLabel ?numero (SAMPLE(?image) AS ?image) WHERE { ?item p:P528 ?catalogStatement . ?catalogStatement ps:P528 ?numero . ?catalogStatement pq:P972 wd:Q14530 . OPTIONAL {?item wdt:P18 ?image . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?item ?itemLabel ?numero ORDER BY ?numero | ||
| Brightest stars, with image | P31|Q523|P1215|P18 | #defaultView:ImageGrid # Brightest celestial bodies SELECT ?star ?starLabel ?images ?apparent_magnitude WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } { SELECT ?star ?apparent_magnitude ?images WHERE { ?star wdt:P31 wd:Q523; wdt:P1215 ?apparent_magnitude; wdt:P18 ?images . FILTER(?apparent_magnitude < 1) } LIMIT 10 } } ORDER BY (?apparent_magnitude) | ||
| Map of the world's sign languages with number of practicians | P1098|P17|P625|P31|Q34228 | #title:Map of the world's sign languages with number of practicians #defaultView:Map SELECT ?sign_language ?sign_languageLabel ?indigenous_to ?coordinate_location ?practicians WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } OPTIONAL { ?sign_language wdt:P1098 ?practicians. } OPTIONAL { ?sign_language wdt:P17 ?country. } OPTIONAL { ?country wdt:P625 ?coordinate_location. } ?sign_language wdt:P31 wd:Q34228. } | ||
| Humans without children | ||||
| Only truthy values | P31|Q5|P40|P40 | #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],mul,en" } } | ||
| Including non-truthy values | P31|Q5|P40|P40|P40|P40 | #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],mul,en" . } } | ||
| Lexeme queries | ||||
| Senses on Swedish phrase lexemes with a synonym | Q9027|P279|P31|Q187931|P5973 | #title: Senses on Swedish phrase lexemes with a synonym # date: 2024-04-25 # author: So9q # note: Thanks to Nikki and Ainali for help with selecting the synonym lexeme SELECT ?l ?sense ?lemma ?synonym ?synonym_lemma WHERE { ?l ontolex:sense ?sense ; # the sense dct:language wd:Q9027 ; # the language wikibase:lemma ?lemma ; # and the lemma wikibase:lexicalCategory ?category. ?category wdt:P279/wdt:P31* wd:Q187931. # subclass of phrase ?sense wdt:P5973 ?synonym_sense . ?synonym ontolex:sense ?synonym_sense . # select synonym lexeme ?synonym wikibase:lemma ?synonym_lemma . # get the synonym lemma } | ||
| Senses on English lexemes with an offensive or profanity style statement | Q1860|Q184439|Q545779|P6191 | #title: Senses on English lexemes with an offensive or profanity style statement # date: 2024-01-25 # author: So9q SELECT ?l ?sense ?lemma ?swearLabel WHERE { ?l ontolex:sense ?sense ; # the sense dct:language wd:Q1860 ; # the language wikibase:lemma ?lemma . # and the lemma VALUES ?swear { wd:Q184439 wd:Q545779 } ?sense wdt:P6191 ?swear . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" . } } | ||
| Swedish lexemes missing in SAOB | Q9027|P9660|Q1935308 | #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 | Q9027|P5831|P5831|P6072|P5830 | #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. } } | ||
| Get the lemma for an inflected word in English | Q1860 | #title: Get the lemma for an inflected 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 dct:language wd:Q1860 ; wikibase:lemma ?lemma ; ontolex:lexicalForm ?form . ?form ontolex:representation ?word . } | ||
| The Swedish alphabet | Q9027|Q9788 | #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 phrases | Q9035|P279|Q187931 | #title: Danish phrases # Author: So9q # Date: 2024-01-03 SELECT ?l ?lemma WHERE { ?l dct:language wd:Q9035; # Change language here wikibase:lemma ?lemma; wikibase:lexicalCategory ?cat. ?cat wdt:P279 wd:Q187931. } | ||
| All forms in Swedish missing a pronunciation for the form with a representation identical to the lemma of the lexeme | Q9027|P443 | #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 | Q1860 | # 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 | Q9027|P5831|P5831|P6072|P5830 | #title: Lexemes in Swedish with usage example that demonstrates both a form and a sense # So9q 23-12-2020 SELECT ?lexemeId ?lemma ?example WHERE { ?lexemeId dct: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) | Q1860|P5137|P18 | # 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],mul,en". } } ORDER BY lcase(?lemma) # order a-z | ||
| German picture dictionary for young children | P5137|Q188|P5137|P18|P31|Q3624078|Q47092|Q198|Q124490|Q170382|Q1576|P5137|Q8102|Q545779|Q1521634|Q184439|P6191 | # 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,mul". } } ORDER BY lcase(?lemma) # order a-z | ||
| Lexeme languages by number of usage examples | P5831|P5831|P6072|P5830 | #title: Lexeme languages by number of usage examples # by Vesihiisi # improved by So9q 23-02-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 dct:language ?language; p:P5831 ?statement. ?statement ps:P5831 ?example; pq:P6072 []; pq:P5830 []. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } GROUP BY ?languageLabel ORDER BY DESC(?count) | ||
| Lexemes describing a color | P31|Q376431 | #title: Lexemes describing a color # By Vesihiisi SELECT ?l ?lemma ?languageLabel WHERE { ?l dct:language ?language; wikibase:lemma ?lemma; wdt:P31 wd:Q376431. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } ORDER BY ?languageLabel | ||
| Lexemes that means water ordered by language | P5137|Q29053744|Q29053744 | # 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],mul,en". } } # Lower case before order ORDER BY (LCASE(?languageLabel)) | ||
| The 100 most translated concepts in the Lexeme namespace | P5137 | # 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],mul,en" . } } ORDER BY desc(?count) | ||
| Demonyms on map | P218|P6271|P625 | # 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],mul,en". } } | ||
| Forms in Hebrew that are both feminine and masculine | Q9288|Q1084|Q499327|Q1775415 | #title: Forms of nouns in Hebrew that are both feminine and masculine # by Uziel302 SELECT ?lexemeId ?lemma ?form ?word WHERE { ?lexemeId dct:language wd:Q9288; wikibase:lexicalCategory wd:Q1084; wikibase:lemma ?lemma; ontolex:lexicalForm ?form. ?form wikibase:grammaticalFeature wd:Q499327, wd:Q1775415; ontolex:representation ?word. } | ||
| Lexemes by number of statements | #title:Lexemes by number of statements SELECT * { ?l dct:language []; wikibase:statements ?c. } ORDER BY desc(?c) LIMIT 50 | |||
| Standard Mandarin Lexeme Forms missing Pinyin Transliteration | Q727694|P1721 | #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. }) } | ||
| List of French nouns that have no audio recording added, formatted for LinguaLibre.org generator | Q150|Q1084|P443 | # author: Lea Lacroix (WMDE) 2018-12-18 #contact: Yug SELECT ?id ?label WHERE { ?l a ontolex:LexicalEntry ; dct:language wd:Q150 ; wikibase:lexicalCategory wd:Q1084 ; ontolex:lexicalForm ?id . ?id ontolex:representation ?label . FILTER NOT EXISTS { ?id wdt:P443 ?audio. } } | ||
| List of Puno Quechua lexeme-forms that have no audio recording added, formatted for LinguaLibre.org generator | Q5218|Q24905|P443|Q7260479 | #author: Elwinlhq 2022-11-20 #contact: Yug SELECT ?id ?label WHERE { ?l a ontolex:LexicalEntry ; dct:language wd:Q5218 ; wikibase:lexicalCategory wd:Q24905 ; ontolex:lexicalForm ?id . ?id ontolex:representation ?label . FILTER NOT EXISTS { ?id wdt:P443 ?audio. } FILTER (LANG(?label) = "qu-x-q7260479"). # retrieve Puno Quechua lexemes/forms: qu-x-Q7260479 !!Lowercase } | ||
| Properties | ||||
| Properties grouped by their parent property | P1647 | #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],mul,en". } } | ||
| Subproperties of location (P276) | P276|P1647|P276 | #Subproperties of location (P276) SELECT DISTINCT ?subProperties ?subPropertiesLabel WHERE { ?subProperties wdt:P1647* wd:P276. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,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],mul,en". } } GROUP BY ?wbtype ORDER BY DESC(?pcount) | |||
| Properties used to link to instances of technical standard (Q317623) | P31|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],mul,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],mul,en". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P'))) | |||
| Properties connecting items of type zoo (Q43501) with items of type animal (Q729) | P31|P279|Q729|P31|P279|Q43501 | 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],mul,en". } } GROUP BY ?p ?pLabel ORDER BY desc(?count) | ||
| Identifier properties present on one item, but absent on another | Q4573|Q39666|P1630|Q4573|Q39666 | #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],mul,en". } } GROUP BY ?p ?pLabel ORDER BY ?url_comp2 | ||
| A 7 level inverse tree (of Property categories) | Q18616576|P279|P18|P18|P18|P18|P18|P18|P18 | #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,mul". ?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 | P2302|Q21503250|P2302|Q53869507|P31 | # 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],mul,en". } } } } GROUP BY ?property ?propertyLabel ?propertyDescription ?propertyAltLabel | ||
| Most used properties | Q16917|P31|Q16917 | #title: Most Used Properties for Hospitals in Wikidata #defaultView:BubbleChart # This query retrieves the most frequently used properties for items that are instances of a hospital (Q16917). # It counts how many times each property is used and displays the results in descending order. # The visualization is set to a Bubble Chart to provide a visual representation of property usage. SELECT ?property ?propertyLabel ?count WHERE { # Subquery to calculate the count of each property used by hospital items { SELECT (IRI(REPLACE(STR(?prop), "http://www.wikidata.org/prop/direct/", "http://www.wikidata.org/entity/")) AS ?property) # Convert direct property to property entity (COUNT(*) AS ?count) # Count the number of occurrences for each property WHERE { ?item wdt:P31 wd:Q16917 . # Select items that are instances of a hospital ?item ?prop ?value . # Retrieve all properties and their values for these items FILTER(STRSTARTS(STR(?prop), STR(wdt:))) . # Ensure only direct properties (wdt:) are considered } GROUP BY ?prop # Group results by property to aggregate counts ORDER BY DESC(?count) # Order properties by count in descending order } # Retrieve human-readable labels for the properties SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". # Fetch labels in the user's language or English } } ORDER BY DESC(?count) # Final ordering of the results by count LIMIT 1000 | ||
| References | ||||
| Content of a reference for a specific statement | Q51955019|P1343|P958|P1343|P1343|Q51955019|P1343|P958 | # 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 | P279|P279|P279|P279|P279|Q7048977|Q112276019 | # 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,mul". } } ORDER BY (?itemLabel) | ||
| Wikimedia projects | ||||
| Countries that have sitelinks to en.wiki | P31|Q3624078 | 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 "[AUTO_LANGUAGE],mul,en" } } | ||
| Canadian subjects with no English article in Wikipedia | P27|P205|P17|Q16|P106|Q488111|P106|Q3286043|P106|Q4610556 | #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],mul,en,fr,es,de" } #Service to resolve labels in (fallback) languages: automatic user language, default for all languages, English, French, Spanish, German. } ORDER BY DESC (?cnt) | ||
| Countries that have a Featured Article on Russian Wikipedia | P31|Q6256|Q17437796 | 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],mul,en" } . } ORDER BY ?itemLabel | ||
| Numbers of Wikipedia sitelinks for items with Art UK artist ID (P1367) for each language | P1367 | 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 an Art UK artist identifier ?article schema:isPartOf / wikibase:wikiGroup "wikipedia" . # only Wikipedia 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 | P31|Q532|P17|Q212 | #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: is a - village ?item wdt:P31 wd:Q532 . # item: country - Ukraine ?item wdt:P17 wd:Q212 . # exists article in item that is ro.wiki ?article schema:about ?item ; schema:isPartOf <https://ro.wikipedia.org/> ; schema:name ?page_titleRO . # wd labels ?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 | P31|Q13442814|P50 | #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 | P1741 | 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],mul,en,nl". } } | ||
| People deceased in 2018 ordered by the number of sitelinks | P31|Q5|P570 | 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],mul,en" . } } ORDER BY desc(?sitelinks) | ||
| List of small monuments and other similar sites with link to Commons category (sitelink or P373) | P131|Q894107|P373|Q1746392|Q108325|Q4989906|Q10861631|Q15077340|Q1516537|Q47008262|P31|P279 | 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 | P106|Q182436|P40 | #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 "[AUTO_LANGUAGE],mul,en,de,es,ar,fr" } } GROUP BY ?linkcount ?person ?personLabel ?parent ?parentLabel ORDER BY DESC(?linkcount) | ||
| All languages with a Wikimedia language code (P424) | P424|Q34770|Q436240|Q1288568|Q33215|P31|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],mul,en". } } ORDER BY ?lang_code | ||
| All Wikipedia sites | P31|Q10876391|P856 | # 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],mul,en". } } | ||
| Featured articles of all Wikimedia projects | Q17437796|Q17437796 | # 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],mul,en". } } | ||
| People born in Lisbon without articles on ptwiki but with articles on other Wikipedias | P31|Q5|P19|P20|P131|Q597 | # 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,mul". } } | ||
| List of French communes in Finistère, formatter for Lingualibre.org list generator | P31|Q484170|Q484170|P131|Q3389|P131|Q3389 | # author: Yug 2024-12-11 # https://w.wiki/CNrc SELECT ?id ?label WHERE { ?id wdt:P31 wd:Q484170; # item is `commune de france` (Q484170) wdt:P131 wd:Q3389. # item is `located in administrative entity` (P131) of `finistere` (Q3389) ?id rdfs:label ?label. # fetch labels FILTER(lang(?label) = "fr") # keep French ones } | ||
| Countries | ||||
| List of present-day countries and capital(s) | P31|Q3624078|P31|Q3024240|P31|Q28171280|P36 | 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 "[AUTO_LANGUAGE],mul,en" } } ORDER BY ?countryLabel | ||
| UN member states | P31|P279|Q3624078|P463|P463|Q1065|P582|P576|P582 | 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 | P31|P279|Q515|P1082|P17|P31|P279|Q515|P1082|P17|P625 | #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 "[AUTO_LANGUAGE],mul,en" . } } ORDER BY DESC(?population) | ||
| Wikidata people per million inhabitants for all EU countries | Q458|P150|Q30|P31|Q5|P27|P570|P1082 | #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 "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) | ||
| Papers about Wikidata | P921|Q2013|P31|P279|Q191067 | #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 "[AUTO_LANGUAGE],mul,en". } } LIMIT 100 | ||
| Countries sorted by population | P31|Q6256|P1082 | # defaultView:BubbleChart SELECT DISTINCT ?countryLabel ?population { ?country wdt:P31 wd:Q6256 ; wdt:P1082 ?population . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?population ?countryLabel ORDER BY DESC(?population) | ||
| Country populations together with total city populations | P1082|P31|Q515|P17|P1082 | SELECT ?country ?countryLabel ?population ?totalCityPopulation (?population / ?totalCityPopulation AS ?ratio) { ?country wdt:P1082 ?population . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,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 | P30|Q15|P37|P31|Q6256|P424 | 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 | P31|P17|Q55|Q34770|Q33384|P31|Q10876391|P407 | 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 "[AUTO_LANGUAGE],mul,nl,en". } } GROUP BY ?language ?languageLabel ?wikipediaLabel | ||
| Cities | ||||
| Population of cities and towns in Denmark and their OSM relation id | Q3957|Q515|P31|P279|P17|Q35|P1082|P402 | # 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],mul,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 | P36|P36|P625|P582|P576|P582|P576|P582 | #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 "[AUTO_LANGUAGE],mul,en". } } | ||
| Largest cities of the world | P31|P279|Q515|P1082|P625 | #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],mul,en" . } } ORDER BY DESC(?population) | ||
| Cities as big as Eindhoven give or take 1000 | Q9832|P1082|P1082|P625 | #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],mul,nl" } } | ||
| Where in the world is Antwerp | P279|Q486972|P31|P625 | #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 | Q17480|Q17480|P81|P625|P931|P625 | #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 "[AUTO_LANGUAGE],mul,en". } } | ||
| Cities connected by the European route E40 | Q327162|P2789|P625 | #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 "[AUTO_LANGUAGE],mul,en". } } | ||
| Cities connected by the Trans-Mongolian and Trans-Siberian Railway | Q559037|Q58767|P2789|P625 | #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 "[AUTO_LANGUAGE],mul,en". } } | ||
| Metro station of city with template | P31|P279|Q1637706|Q8686|P31|P279|Q928830|P131|P279|P625|P81|P197|P465|P81|P625|P625|P625|P625|P625|P625|P625 | #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],mul,en\"} }"} } } #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],mul,en". } } ORDER BY (?connectingLine1Label) | ||
| Cities connected to Paramaribo (Suriname) by main roads | Q3001|Q3001|P2789|P2789|P625 | #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 "[AUTO_LANGUAGE],mul,en". } } | ||
| Names of 100 cities with a population larger than 1000000 in the native languages of their countries | P1082|P31|Q515|P17|P37|P424 | # 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 | ||
| Show all Dutch municipalities that share a border with Alphen aan den Rijn (Q213246), ignoring rank | P31|P31|Q2039348|P47|Q213246 | 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 | P361|P31|Q902814|P17|P625 | # 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],mul,en". ?border_city rdfs:label ?border_cityLabel. ?country rdfs:label ?countryLabel.} } GROUP BY ?border_city ?border_cityLabel ?countryLabel ?coords ORDER BY ?countryLabel ?border_cityLabel | ||
| Municipalities of the Basque Country without former municipalities | P527|P582|P31|P131|P527|Q47588|P31|Q484170|P31|Q2074737|P582 | # This query has two different features: # First, it is able to search for municipalities which are part of two different states, looking to P527 # Second, it doesn't show former municipalities, filtering the old ones from the P582 statement. SELECT DISTINCT ?udalerri ?udalerriLabel WHERE { ?udalerri p:P31 ?status. ?udalerri wdt:P131*/^wdt:P527 wd:Q47588 . {?status ps:P31 wd:Q484170.} UNION {?status ps:P31 wd:Q2074737} MINUS {?status pq:P582 ?old .} SERVICE wikibase:label { bd:serviceParam wikibase:language "eu,es,fr,en". } } | ||
| Distances between any two cities or municipalities in an area | ||||
| grouped by dist range, color-coded | Q15284|Q6308|P31|P279|P131|P625|P31|P279|P131|P625 | #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],mul,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 | Q15284|Q6308|P31|P279|P131|P625|P31|P279|P131|P625 | #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],mul,en". ?mun rdfs:label ?from. ?mun2 rdfs:label ?to. } } ORDER BY ?from ?kilometers | ||
| grouped per municipality on x-axis, by sum of dist | Q15284|Q6308|P31|P279|P131|P625|P31|P279|P131|P625 | #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],mul,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 | Q15284|Q6308|P31|P279|P131|P625|P31|P279|P131|P625 | #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],mul,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 | Q15284|Q6308|P31|P279|P131|P625|P31|P279|P131|P625 | #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],mul,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 | Q15284|Q6308|P31|P279|P131|P625|P31|P279|P131|P625 | #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],mul,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, ..) | Q15284|Q6308|P31|P279|P131|P625|P31|P279|P131|P625|P31|P279|P131|P625 | #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],mul,en". ?mun rdfs:label ?from. ?mun2 rdfs:label ?to. } } ORDER BY ?rank_group ?kilometers ?from | ||
| Rivers | ||||
| Longest rivers | P31|P279|Q4022|P2043|P18|P625 | #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 "[AUTO_LANGUAGE],mul,en" . } } ORDER BY DESC(?length) ?itemLabel LIMIT 50 | ||
| Longest river of each continent | P31|P279|Q355304|P2043|P30|P31|P279|Q355304|P2043|P30 | SELECT ?continent ?river ?continentLabel ?riverLabel ?maxlength WHERE { { SELECT ?continent (MAX(?length) AS ?maxlength) 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 ?maxlength; wdt:P30 ?continent. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } ORDER BY ?continentLabel | ||
| Rivers in Antarctica | P31|P279|Q355304|Q4022|P30|Q51|P625 | 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 "[AUTO_LANGUAGE],mul,en". } } | ||
| Body of water with the most watercourses ending in it | 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 | P31|P279|Q12280|P177|P31|P279|Q355304|P17|Q183|P17|Q183|Q1202|Q183|P131|P131|Q24186|P625|P18|P571|P576|P571|P576 | #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],mul,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 | P31|Q429088|P625|P625|P625|Q2 | 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 "[AUTO_LANGUAGE],mul,en" . ?item rdfs:label ?name } } ORDER BY ASC (?name) | ||
| Highest places on Earth | P2044|Q11573|P2044|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],mul,en". } } ORDER BY DESC(?elevation) | ||
| Highest mountains in the universe (with units) | P2044|P2044|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],mul,en". } } ORDER BY DESC(?elevation) | ||
| Highest mountains in the universe (with units, compact form) | P2044|P2044|P2044|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],mul,en". } } ORDER BY DESC(?elevation) | ||
| Mountains over 8000 meters elevation | P31|Q8502|P2044|P2044|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],mul,en" } } | ||
| Italian mountains higher than 4000 meters | P2044|P2044|P625|P17|Q38|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" } } | ||
| Geography | ||||
| Places in Antarctica more than 3000km away from the South Pole | Q933|P625|P30|Q51|P625 | #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 | P31|P279|Q928830|P81|Q13224|P625|P197|P197|P5051|Q585752|P81|Q13224|P1619 | 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 | P1217|Q235065|P625|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 | P31|Q35657|P47|P31|Q35657 | 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],mul,en" . } } ORDER BY DESC(?borders) | ||
| Places that are below 10 meters above sea level | P2044|P2044|Q11573|Q3710|Q828224|P625|P18 | #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],mul,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 | Q9188|P625|P625|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) | P374 | SELECT ?item ?itemLabel ?inseeCode { ?item wdt:P374 ?inseeCode . FILTER (?inseeCode in ("75056", "69123", "13055")) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } | ||
| Map and list of municipalities in The Netherlands | P31|P625|P31|Q2039348|P31|P31|Q7265977|P582 | #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 | P31|Q694554|P2852|P1082|P31|P279|Q6256|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],mul,en" } } ORDER BY DESC(?population) | ||
| German states, ordered by the number of company headquarters per million inhabitants | Q1221156|Q6256|P31|Q1221156|P31|P279|Q4830453|P159|P131|P576|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 | P19|Q64|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 | P136|Q1164267|P31|Q571|P50|P571|P840|P840|Q933|P625|P953|P407|Q150|P629|P953|P407|Q150 | #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 | Q24041662|P625|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 | P31|P279|Q484170|P17|Q142|P625|P131|Q33788 | #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 | P31|P279|Q41176|P17|P576 | 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 | P31|Q79007|P17|Q142|P131|P138|P31|Q5 | 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 | P31|P279|Q79007|P17|Q142|P131 | 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) | P527|Q806724|P1454|Q5349747|Q806724|P3113 | #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 | P625 | 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],mul,en". } } ORDER BY ?distance LIMIT 100 | ||
| Ten largest islands in the world | P31|P279|Q23442|P18|P2046|P2046 | #title: Ten largest islands in the world # Inspired by this infographic: https://redd.it/a6423t #defaultView:ImageGrid SELECT DISTINCT ?island ?islandLabel ?islandImage WHERE { ?island (wdt:P31/(wdt:P279*)) wd:Q23442. OPTIONAL { ?island wdt:P18 ?islandImage. } ?island (p:P2046/psn:P2046/wikibase:quantityAmount) ?islandArea. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } ORDER BY DESC (?islandArea) LIMIT 10 | ||
| City gates in the Dutch province of Zeeland | P31|Q2039348|P131|Q705|P31|Q82117|P131|P276 | 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 | P31|P279|Q35666|P625|P2046|P2046 | #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],mul,en". } } | ||
| Demography | ||||
| Birthplaces of humans named Antoine | P31|Q5|P735|Q15235674|P19|P625 | # 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 | P31|Q5|P106|P569|P569|P570|P570 | # 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 | P569 | 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 | P40 | 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 | Q730|P1082|P585|P1082 | #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 | P31|Q5|P570|P570 | 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 | ||
| Dutch general election 2017 | ||||
| Candidates for the Dutch general election in 2017 | P3602|P2002|P2035|P3602|Q16061881|P1545|P1268|P2035 | 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 | P3602|P21|P3602|Q16061881|P1545|P1268 | #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 | P3602|P551|Q12892|P2002|P2035|P3602|Q16061881|P1545|P1268 | 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 | P3602|P551|P17|P625|P3602|Q16061881|Q55 | #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 | Q747910|Q275441|P3602|P21|P106|P3602|Q16061881|P1545|P1268 | #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". } } | ||
| Politics | ||||
| Gender balance of members of Irish parliament | P39|Q654291|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 | P31|P279|Q1752346|P1342|P1001|P571|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 | P31|Q3624078|P31|Q3024240|P6|P6|P6|P582|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 | P31|Q5|P39|P279|Q83307|P22|P25|P39|P279|Q83307|P27|P901 | 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 | P39|Q3044918|P19|P17|P17|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 | P31|Q7138926|P18|P17 | #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 | P1622 | 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 | P39|P39|Q13423495|P580|P582 | #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 | P39|P102|P102|P582|P361|P39|Q4416090|P768|P580|P582|P18 | 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],mul,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 | P106|Q188094|P101|Q8134|P570|P19|P625|P569 | #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 | P2218|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 | P31|Q6256|P38|P31|P279|Q13479982 | # 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],mul,en". } } | ||
| Business listed on NYSE and NASDAQ along with their ticker symbols | P414|Q13677|Q82059|P414|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],mul,en". } ?id p:P414 ?exchange. VALUES ?exchanges { wd:Q13677 wd:Q82059 } ?exchange ps:P414 ?exchanges; pq:P249 ?ticker. } | ||
| Human Development Index of specified country(s) | Q148|Q39|P1081|P1081|P585 | #title: Human Development Index of specified country(s) #defaultView:LineChart SELECT ?year ?hdi ?countryLabel WHERE { VALUES ?country { wd:Q148 wd:Q39 # to add another country : # 1,uncomment the last commented line below, # 2,optionnally replace « US » by another country name, # 3,put cursor to the end of line, # 4,and press CTRL+SPACE，or CTRL+ALT+SPACE, or ALT+ENTER, # 5,and select first item, and press CTRL+ENTER to execute. #wd:US } ?country p:P1081 ?statement. ?statement ps:P1081 ?hdi. ?statement pq:P585 ?date. BIND (STR(YEAR(?date)) as ?year) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } | ||
| Diseases | ||||
| The number of existing translations for diseases in Wikidata | P699 | 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) | P699|P279|Q18123741|P2176 | #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 | P31|Q12136|P279|Q12136|P699 | 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) | P31|P279|Q18123741|P3488|P3488|P3487|P3487 | 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 | P351|P703|Q15978631 | 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 | P3329|P31 | #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],mul,en" } } GROUP BY ?variant_typeLabel ORDER BY ?counts | ||
| Which variant of which gene predicts a positive prognosis in colorectal cancer | Q188874|P3358|P3358|P3433|P3433 | 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],mul,en" } } | ||
| Variants that are associated with renal cell carcinoma | P3356|P3357|P3358|P3359|P3329|Q1164529|Q1164529|P3354|P2175|Q1164529|P3354|P2175|Q1164529 | # 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],mul,en" } } | ||
| PubMed references in CIViCdb | P3329|P248|P31|Q13442814|P698 | # 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],mul,en" } } | ||
| Variant counts by predictor type | P3354|P3355|P3356|P3357|P3358|P3359|P3329 | #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],mul,en" } } GROUP BY ?propertyLabel ?prognostic_typeLabel ORDER BY ?counts | ||
| Proteins | ||||
| Get Wikidata - UniprotId mappings for homo sapiens | P352|P703|Q15978631 | 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 | P31|Q11173|P31|Q8054|P703|P703|P248|P2410|P356 | 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) | P2410|P527|P2888|P1117|P1117|P2410|P527 | #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],mul,en". } } | ||
| Taxon | ||||
| Asterophryinae parent taxon reverse graph | Q1968598|P171|P171|P18 | #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 | P2410|P703|Q15978631 | SELECT ?pathway ?pathwayLabel ?wpid WHERE { ?pathway wdt:P2410 ?wpid ; wdt:P703 wd:Q15978631 . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } | ||
| Biomarkers in Wikidata which interact with proteins in human pathways from Wikipathways | Q420633|Q27125809|Q422462|P31|Q11173|P638|P31|Q8054|P638|P702|P703|Q15978631|P2888 | 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 | P2410|P2860 | 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 | P2410|P527|P31|Q7187|P2410|P527|P31|Q11173 | #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 | Q4915012|Q2996394|P31|P527|P688|P527|P638|P2410|P3937 | 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],mul,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) | P3354|P3355|P3356|P3357|P3358|P3359|P2175|P2410|P527|P279|Q504775|P3329|P3433 | 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],mul,en". } } | ||
| Known interaction types in Wikipathways for a pathway with Identifier WP716 (federated query) | P2410|P2888 | 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) | P2410|P2888 | 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 . } } | ||
| Biology and Medicine | ||||
| Find drugs for cancers that target genes related to cell proliferation | Q19484|Q190805|P129|P688|P2293|P279|Q12078|Q12078|P682|P361|P279|Q189101|Q14818032|Q14818032|Q14599311|P2176 | #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 | Q42196|P171|P171|P18 | #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 | P31|Q16521|P105|Q7432|P171|Q7367|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 | P31|Q16521|P225|P138 | 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 | P2002|P106|P18|P279|Q864503 | 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). | P31|Q21014462|P31|P279|Q14296 | 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 | P31|Q12140|P274|P117 | 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 | P2974|Q5880|P703|P1056|Q319541 | 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 | P141|P225|P1843|Q11394|Q219127|Q278113|P141 | #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 | P31|Q235557|P1195|P1163 | 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 | P1462|Q37033|P856 | 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 | P31|P139|Q7397|P571|P348|P577 | 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 | P31|P279|Q341|P856|P277|Q37227 | SELECT DISTINCT ?instance_of ?instance_ofDescription ?instance_ofLabel ?official_website WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,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 | P31|P279|Q341|P856|P277|Q37227 | SELECT DISTINCT ?instance_of ?instance_ofDescription ?instance_ofLabel ?official_website WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } ?instance_of wdt:P31/wdt:P279* wd:Q341 OPTIONAL { ?instance_of wdt:P856 ?official_website. } ?instance_of wdt:P277 wd:Q37227. } | ||
| Freeware games for Windows, ordered from recent date | P31|Q7889|P400|Q1406|P275|Q178285|P577|P136|P1733|P856 | SELECT DISTINCT ?game ?gameLabel (MIN(?publication_date) as ?publicationDateMin) (GROUP_CONCAT(?genre_label; SEPARATOR=", ") as ?genres) ?gameDescription ?steamLink ?official_website WHERE { ?game wdt:P31 wd:Q7889. ?game wdt:P400 wd:Q1406. ?game wdt:P275 wd:Q178285. OPTIONAL { ?game wdt:P577 ?publication_date } OPTIONAL { ?game wdt:P136 ?genre . ?genre rdfs:label ?genre_label FILTER (lang(?genre_label) = "en"). } OPTIONAL { ?game wdt:P1733 ?steam } BIND(URI(CONCAT("https://store.steampowered.com/app/", ?steam)) as ?steamLink) OPTIONAL { ?game wdt:P856 ?official_website } SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } GROUP BY ?game ?gameLabel ?publicationDateMin ?genres ?gameDescription ?steamLink ?official_website ORDER BY DESC(?publicationDateMin) | ||
| Universities of main programming language authors | P31|P279|Q9143|P31|Q5|P287|P170|P943|P178|P69|P625 | 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 | P275|P31|Q27075870 | 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 | P31|Q726235|P1072|Q1941622 | 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 | P31|P31|P279|Q7397|P1072 | #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 | P31|P279|Q235557|P1163 | 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 | P485|Q964035|P18|P2021 | #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 | P31|Q11344|P2102|P2101|P1108|P2054|P2067 | 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) | P31|Q11344|P1086|P246|P279|P1148 | 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 | P31|Q11173|P462|P465 | #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 | P31|Q11173|P1117|P1117|P248|P356 | 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 | P231 | 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 | P231|P231 | #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 | P231 | #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 | P166|P166|P166|Q44585|Q44585|P585|P18 | #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 (Q44585) ?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 | P279|P31|Q421948|P18|P117 | #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],mul,en". } } | ||
| Boiling points of alkanes | P31|P279|Q41581|P274|P2102|P2102|P2102 | 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],mul,en". } } ORDER BY DESC(?bpUnit) ASC(?bp) | ||
| Solubilities of chemicals | P248|P356|P1629|Q170731|P31|Q21077852|P2076|P2178 | 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],mul,en". } } ORDER BY ASC(?propEntityLabel) | ||
| Space | ||||
| Who discovered the most asteroids? | P31|Q3863|P61 | 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],mul,en" . } } ORDER BY DESC(?count) | ||
| Who discovered the most planets? (with list) | P279|Q634|P31|P61 | 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 | P31|Q26529|P18|P619 | #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 | Q11631|P18|P569|P19|P625 | # 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 | P31|Q44559|P18 | #defaultView:ImageGrid SELECT ?exoplanet ?exoplanetLabel ?image WHERE { ?exoplanet wdt:P31 wd:Q44559 ; wdt:P18 ?image . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } | ||
| Scientists | ||||
| Number of scientists per gender | P31|Q5|P21|P106|P279|Q901 | 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 | P138|P106|Q170790 | 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 | P31|Q13442814|P50|P106 | #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 | P166|P31|Q5|P31|P279|Q7191|P50|P31|Q13442814|P18 | #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 | Q18016466|P31|Q13442814|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],mul,en". } } | ||
| Female scientists with most number of sitelinks (but not English Wikipedia) | P31|Q5|P21|Q6581072|P106|Q901 | #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 | P157|P61 | SELECT ?inventor ?inventorLabel ?gadget ?gadgetLabel WHERE { ?inventor wdt:P157 ?gadget. ?gadget wdt:P61 ?inventor. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } | ||
| Most cited female authors | P2860|P50|P21|Q6581072 | #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 | P31|P279|Q13442814|P50|P1476|P2021|P2021 | # 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 | P31|Q5|P31|Q5|P27|Q16|P69|P69|P18|P69|P625|P512|P512|P31|P279|Q849697 | #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],mul,en". } } | ||
| Scientific literature | ||||
| PMID-DOI mappings | P698|P356 | SELECT DISTINCT ?pmid ?doi WHERE { ?item wdt:P698 ?pmid ; wdt:P356 ?doi . } | ||
| The number of statements by DOI | P248|P356 | 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 | P248|P356 | 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 | P248|P356 | 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) | P699|P424|P31|P279|Q17376908 | 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 | P31|Q5633421|P921|Q199655|P921|Q16387|P921|Q13420675 | 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 . } } | ||
| Most popular subjects of scientific articles | P31|Q13442814|P921 | #title:Most popular subjects of scientific articles SELECT (count(?work) as ?count) ?subject ?subjectLabel where { ?work wdt:P31 wd:Q13442814; wdt:P921 ?subject . SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } GROUP BY ?subject ?subjectLabel ORDER BY desc(?count) LIMIT 200 | ||
| Galaxies ordered by the ones that are most linked from scientific articles | P31|Q13442814|P921|P31|P279|Q318 | #title:Galaxies ordered by the ones that are most linked from scientific articles #author: So9q #date:2021-10-27 #note:I deliberately choose a smaller subgraph (galaxies) to prevent a timeout on WDQS SELECT ?main_subject ?main_subjectLabel (count(?item) as ?c) WHERE { ?item wdt:P31 wd:Q13442814; wdt:P921 ?main_subject. ?main_subject wdt:P31/wdt:P279* wd:Q318. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } GROUP BY ?main_subject ?main_subjectLabel ORDER BY DESC(?c) | ||
| Scientific journals with editors on Twitter | P31|Q5633421|P98|P123|P2002 | SELECT ?journal ?journalLabel ?editor ?editorLabel ?twitter ?ex_publisher ?ex_publisherLabel WITH { SELECT ?journal ?editor ?twitter (SAMPLE(?publisher) AS ?ex_publisher) WHERE { ?journal wdt:P31 wd:Q5633421 ; wdt:P98 ?editor . OPTIONAL { ?journal wdt:P123 ?publisher } ?editor wdt:P2002 ?twitter . } GROUP BY ?journal ?editor ?twitter } AS %result WHERE { INCLUDE %result SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } ORDER BY ?journalLabel | ||
| Math | ||||
| Mathematical proofs | P31|Q11538 | SELECT ?proof ?proofLabel WHERE { ?proof wdt:P31 wd:Q11538. SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } | ||
| Timeline of death of mathematicans and their theorems | P31|Q65943|P138|P570|P21|P2534 | #defaultView:Timeline SELECT ?genderLabel ?theorem ?theoremLabel ?nameLabel ?death ?formula WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en,de,pl". } ?theorem wdt:P31 wd:Q65943; wdt:P138 ?name. ?name wdt:P570 ?death; wdt:P21 ?gender . # OPTIONAL{ ?theorem wdt:P2534 ?formula. # } } ORDER BY DESC(?death) LIMIT 100 | ||
| Science | ||||
| Databases listed in Wikidata and if available applicable licenses | P31|Q8513|P275 | SELECT DISTINCT * WHERE { ?item wdt:P31 wd:Q8513 ; rdfs:label ?name . OPTIONAL { ?item wdt:P275 ?licenseItem . ?licenseItem rdfs:label ?license . FILTER (LANG(?license) = "en")} FILTER (LANG(?name) = "en") } | ||
| Fictional universes with most fictional planets | P31|Q2775969|P1080 | SELECT ?universe (SAMPLE(?label) AS ?label) (COUNT(?planet) AS ?count) WHERE { ?planet wdt:P31 wd:Q2775969; wdt:P1080 ?universe. ?universe rdfs:label ?label. FILTER(LANG(?label) = "en"). } GROUP BY ?universe ORDER BY DESC(?count) | ||
| Objects with most mass | P2067|P2067|P31|Q3647172 | SELECT ?object ?objectLabel ?mass WHERE { { SELECT ?object (MAX(?mass) AS ?mass) WHERE { ?object p:P2067/psn:P2067/wikibase:quantityAmount ?mass. MINUS { ?object wdt:P31 wd:Q3647172. } } GROUP BY ?object ORDER BY DESC(?mass) LIMIT 100 } SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY DESC(?mass) | ||
| Biological databases listed in Wikidata and, if available, applicable licenses | P31|Q4117139|P856|P275 | SELECT ?item ?itemLabel ?url ?licence ?licenceLabel WHERE { ?item wdt:P31 wd:Q4117139. OPTIONAL { ?item wdt:P856 ?url } OPTIONAL { ?item wdt:P275 ?licence } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY ?itemLabel | ||
| American universities founded before the states they reside in were created | P31|P279|Q3918|P131|P571|P31|Q35657|P571 | SELECT ?uLabel ?founded ?stateLabel ?stateStart WHERE { ?u wdt:P31/wdt:P279* wd:Q3918 ; wdt:P131+ ?state ; wdt:P571 ?founded . ?state wdt:P31 wd:Q35657 ; wdt:P571 ?stateStart . FILTER (?founded < ?stateStart) . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } LIMIT 10 | ||
| Universities ranked by PageRank on English Wikipedia (federated query) | P31|P279|Q3918 | PREFIX vrank:<http://purl.org/voc/vrank#> SELECT DISTINCT ?uni ?uniLabel ?pr WHERE { ?uni wdt:P31/wdt:P279* wd:Q3918. SERVICE <http://dbpedia.org/sparql> { ?uni vrank:hasRank/vrank:rankValue ?pr } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } ORDER BY DESC(?pr) LIMIT 50 | ||
| Education | ||||
| Ranking(s) of university(es) | Q832355|Q1108197|Q16952|Q16955|Q478743|P1352|P1352|P459|P585 | #ranking(s) of university(es) #defaultView:LineChart SELECT ?year ?ranking ?universityLabel ?deternimationMethodLabel ?university WHERE { VALUES ?university { wd:Q832355 wd:Q1108197 wd:Q16952 wd:Q16955 # to add another university : # 1,uncomment the last commented line below, # 2,optionnally replace « Zhejiang_University » by another university name, # 3,put cursor to the end of line, # 4,and press CTRL+SPACE，or CTRL+ALT+SPACE, or ALT+ENTER, # 5,and select first item, and press CTRL+ENTER to execute #wd:Zhejiang_University } VALUES ?deternimationMethod { wd:Q478743 # to add another deternimationMethod : # 1,uncomment the last commented line below, # 2,optionnally replace the « Shanghai .. » method by another one, # 3,put cursor to the end of line, # 4,and press CTRL+SPACE，or CTRL+ALT+SPACE, or ALT+ENTER, # 5,and select first item, and press CTRL+ENTER to execute #wd:Shanghai_Academic_Ranking_of_World_Universities } ?university p:P1352 ?statement. ?statement ps:P1352 ?ranking. ?statement pq:P459 ?deternimationMethod. ?statement pq:P585 ?date. BIND (STR(YEAR(?date)) as ?year) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } | ||
| History | ||||
| Presidents and spouses | P31|Q6256|Q30|P6|P6|P26|P18|P18 | #TEMPLATE={"template":"Presidents of ?country and their spouses","variables":{"?country":{"query":" SELECT ?id WHERE { ?id wdt:P31 wd:Q6256 . }"} } } SELECT ?p ?pLabel ?ppicture ?w ?wLabel ?wpicture WHERE { BIND(wd:Q30 AS ?country) ?country (p:P6/ps:P6) ?p. ?p wdt:P26 ?w. OPTIONAL { ?p wdt:P18 ?ppicture. ?w wdt:P18 ?wpicture. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } | ||
| Politicians who died of cancer (of any type) | P106|Q82955|P106|Q82955|P509|P509|P279|Q12078|P279|Q12078|P39|Q11696 | SELECT ?politician ?cause ?politician_label ?cause_of_death_label WHERE { ?politician wdt:P106 wd:Q82955 . # find items that have "occupation (P106): politician (Q82955)" ?politician wdt:P509 ?cause . # with a P509 (cause of death) claim ?cause wdt:P279* wd:Q12078 . # ... where the cause is a subclass of (P279*) cancer (Q12078) # ?politician wdt:P39 wd:Q11696 . # Uncomment this line to include only U.S. Presidents OPTIONAL {?politician rdfs:label ?politician_label FILTER (lang(?politician_label) = "en") .} OPTIONAL {?cause rdfs:label ?cause_of_death_label FILTER (lang(?cause_of_death_label) = "en").} } ORDER BY ASC (?politician) | ||
| List of popes | P31|Q5|P39|P39|Q19546|P580|P569|P18|P570 | SELECT ?link ?linkLabel ?picture ?age WHERE { ?link wdt:P31 wd:Q5 ; p:P39 [ ps:P39 wd:Q19546 ; pq:P580 ?startTime ] . OPTIONAL { ?link wdt:P569 ?dateOfBirth } OPTIONAL { ?link wdt:P18 ?picture } OPTIONAL { ?link wdt:P570 ?dateOfDeath } BIND(YEAR(?dateOfDeath) - YEAR(?dateOfBirth) as ?age) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr,en" } } ORDER BY DESC(?startTime) | ||
| Years with 3 popes | P39|P39|Q19546|P580|P582|P1365|P1366|P39|P39|Q19546|P582|P39|P39|Q19546|P580 | SELECT ?year ?pope1Label ?pope2Label ?pope3Label WHERE { ?pope2 p:P39 [ ps:P39 wd:Q19546; pq:P580 ?p2s; pq:P582 ?p2e; pq:P1365 ?pope1; pq:P1366 ?pope3 ]. ?pope1 p:P39 [ ps:P39 wd:Q19546; pq:P582 ?p1e ]. ?pope3 p:P39 [ ps:P39 wd:Q19546; pq:P580 ?p3s ]. BIND(YEAR(?p2s) AS ?year). FILTER(YEAR(?p2e) = ?year && YEAR(?p1e) = ?year && YEAR(?p3s) = ?year). SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } ORDER BY ?year | ||
| Popes with children | P22|P31|Q5|P39|Q19546|P18 | # All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 | ||
| French heads of government by length of service | P31|Q5|P39|P39|P580|P31|P279|Q15135541|P582|P18 | SELECT DISTINCT ?item ?itemLabel ?positionLabel ?picture ?start ?end ?days WHERE { ?item wdt:P31 wd:Q5 ; p:P39 ?position_statement . ?position_statement ps:P39 ?position ; pq:P580 ?start FILTER (?start >= "1815-01-01T00:00:00Z"^^xsd:dateTime) . ?position wdt:P31|wdt:P279* wd:Q15135541 . OPTIONAL { ?position_statement pq:P582 ?x } OPTIONAL { ?item wdt:P18 ?picture } bind(if(bound(?x), ?x, NOW()) as ?end ) bind(floor(?end - ?start) as ?days) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" . } } ORDER BY DESC(?days) ?itemLabel | ||
| List of countries in 1754 | Q3024240|Q6256|Q3624078|P31|P31|P571|P576|P625 | #updated 2020-12-06 SELECT DISTINCT ?h ?hLabel ?inception ?dissolved ?coor WHERE { VALUES ?countryclass { wd:Q3024240 wd:Q6256 wd:Q3624078 } ?h p:P31/ps:P31 ?countryclass . ?h wdt:P571 ?inception . OPTIONAL { ?h wdt:P576 ?dissolved } . FILTER (?inception < "1755-01-01T00:00:00Z"^^xsd:dateTime) FILTER (?dissolved >= "1755-01-01T00:00:00Z"^^xsd:dateTime || !Bound(?dissolved) ) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } OPTIONAL { ?h wdt:P625 ?coor } . } ORDER BY ?inception | ||
| Population in Europe after 1960 | Q458|P150|P1082|P1082|P585 | SELECT ?objectLabel (YEAR(?date) as ?year) ?population (?objectLabel as ?Location) WHERE { wd:Q458 wdt:P150 ?object . # European Union contains administrative territorial entity ?object p:P1082 ?populationStatement . ?populationStatement ps:P1082 ?population ; pq:P585 ?date . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } FILTER (YEAR(?date) >= 1960) } ORDER BY ?objectLabel ?year | ||
| Locations of air accidents | P31|Q744913|P625 | SELECT ?label ?coord ?place WHERE { ?subj wdt:P31 wd:Q744913 . ?subj wdt:P625 ?coord . ?subj rdfs:label ?label FILTER (lang(?label) = "en") } | ||
| Most prolific fathers | P22|P18 | SELECT ?father ?fatherLabel (SAMPLE(?picture_) AS ?picture) ?children WITH { SELECT ?father (COUNT(?father) AS ?children) WHERE { ?subj wdt:P22 ?father . } GROUP BY ?father ORDER BY DESC(?children) LIMIT 50 } AS %get_fathers WHERE { INCLUDE %get_fathers OPTIONAL { ?father wdt:P18 ?picture_ . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?father ?fatherLabel ?children ORDER BY DESC(?children) | ||
| List of suicide attacks | P31|Q18493502|Q217327|P1339|P1120|P276|P625|P585|P18 | SELECT ?h ?hLabel ?location (CONCAT("injured: ",str(?injured)) as ?injuredl) (concat("dead: ",str(?dead)) as ?deadl) ?date ?image WHERE { ?h wdt:P31 ?attack. values (?attack) { (wd:Q18493502) (wd:Q217327) } OPTIONAL { ?h wdt:P1339 ?injured . } OPTIONAL { ?h wdt:P1120 ?dead. } OPTIONAL { ?h wdt:P276?/wdt:P625 ?location } OPTIONAL { ?h wdt:P585 ?date } OPTIONAL { ?h wdt:P18 ?image } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } | ||
| People who died by burning - on a timeline | P31|Q5|P509|Q468455|P570 | #defaultView:Timeline SELECT ?person ?personLabel ?date WHERE { ?person wdt:P31 wd:Q5; wdt:P509 wd:Q468455; wdt:P570 ?date. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } ORDER BY ?date | ||
| People who lived in the same period as another person | P31|Q5|P569|P570 | SELECT ?person ?personLabel ?personDescription ?birth ?death ?age { ?person wdt:P31 wd:Q5. # instance of human ?person wdt:P569 ?birth . # birth date ?person wdt:P570 ?death . # death date hint:Prior hint:rangeSafe true . # tell the optimizer that fields doesn’t mix dates, strings, integers or other data types, which simplifies the range comparison FILTER (?birth > "1452-04-15"^^xsd:dateTime && ?death < "1519-05-02"^^xsd:dateTime) # And between these two dates bind( year(?death)-year(?birth) as ?age ) # Make a new variable called ?age that we can use FILTER (?age > 10 && ?age < 100) # Only find people with realistic ages SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } # used to display a label } | ||
| People elevated in the public domain in 2020 "life+50 years" | Q16|Q142|Q39|Q31|Q30|Q2500638|Q20826540|Q215627|P31|Q5|P21|P27|P27|P106|P279|P106|P570 | #added before 2019-02 #Shows people raised in the public domain "life + 50 years". SELECT ?item ?itemLabel ?genderLabel (GROUP_CONCAT(DISTINCT ?occupationLabel; SEPARATOR=", ") AS ?occupations) (GROUP_CONCAT(DISTINCT ?countryLabel; SEPARATOR=", ") AS ?countries) ?death ?articles { VALUES ?target_country { wd:Q16 wd:Q142 wd:Q39 wd:Q31 wd:Q30 } . #countries: Canada, France, Switzerland, Belgium, USA. Removing this line to get worldwide may cause a query timeout. VALUES ?occ { wd:Q2500638 wd:Q20826540 wd:Q215627 } . #occupation: creator, erudite, person. These 3 occupations will also look for subclasses. Example: Alan Turing is a cryptographer, a subclass of cryptologist, a subclass of mathematician, a subclass of scientist, a subclass of erudite. ?item wdt:P31 wd:Q5; wdt:P21 ?gender; wdt:P27 ?target_country; wdt:P27 ?country; wdt:P106/wdt:P279* ?occ ; wdt:P106 ?occupation; wikibase:sitelinks ?articles . #Service to count the number of articles in Wikipedia language versions. The higher the number, the greater the chances that the person is very notorious. ?item wdt:P570 ?death . hint:Prior hint:rangeSafe true . FILTER( ?death >= "1969-01-01T00:00:00"^^xsd:dateTime && ?death < "1970-01-01T00:00:00"^^xsd:dateTime ) #death: public domain "life+50 years". Change both years to get a list in different legislation. Example for USA: life+70 years SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en" . #Service to retrieve the labels of items, in order of language. Example: if the label does not exist in French, the service will take the English label ?item rdfs:label ?itemLabel . ?gender rdfs:label ?genderLabel . ?occupation rdfs:label ?occupationLabel . ?country rdfs:label ?countryLabel . } . } GROUP BY ?item ?itemLabel ?genderLabel ?death ?articles ORDER BY DESC (?articles) #Order by the number of articles in Wikipedia language versions. The most notorious people will be at the top of the list. | ||
| List of torture devices | P366|Q132781|P18 | SELECT ?thing ?thingLabel ?image WHERE { ?thing wdt:P366 wd:Q132781 . ?thing wdt:P18 ?image . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } | ||
| Animals that were executed | P31|P31|Q16521|P509|P279|Q8454|P570|P18 | SELECT ?animal ?animalLabel ?died ?mannerOfDeathLabel ?image WHERE { ?animal wdt:P31/wdt:P31 wd:Q16521; # instance of some taxon (does not include human) wdt:P509 ?mannerOfDeath. ?mannerOfDeath wdt:P279* wd:Q8454. # some subclass of capital punishment OPTIONAL { ?animal wdt:P570 ?died. } OPTIONAL { ?animal wdt:P18 ?image. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } ORDER BY ?died | ||
| People who were stateless for some time | P31|Q5|P27|P27|P580|P582 | # persons who were stateless (country of citizenship: no value) for some time (start time and end time qualifiers) SELECT ?person ?personLabel ?start ?end WHERE { ?person wdt:P31 wd:Q5; p:P27 [ rdf:type wdno:P27; pq:P580 ?start; pq:P582 ?end ]. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } ORDER BY DESC(?end - ?start) | ||
| Poets who were through An Lushan Rebellion | Q253774|P580|Q253774|P582|P106|Q49757|P497|P569|P570 | # Poets who were through An Lushan Rebellion SELECT ?poet ?poetLabel WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],zh-hant,zh". } wd:Q253774 wdt:P580 ?battleStartTime. wd:Q253774 wdt:P582 ?battleEndTime. ?poet wdt:P106 wd:Q49757. ?poet wdt:P497 ?cbdbId. ?poet wdt:P569 ?birthDate. FILTER(?birthDate < ?battleStartTime). ?poet wdt:P570 ?deathDate. FILTER(?deathDate > ?battleEndTime). } | ||
| Periods of Japanese history and what they were named after | P31|Q11514315|P361|Q130436|P580|P2348|P361|Q130436|P582|P138 | SELECT ?era ?eraLabel (YEAR(?start_time) AS ?start) (YEAR(?end_time) AS ?end) ?namedLabel ?namedDescription WHERE { ?era wdt:P31 wd:Q11514315; wdt:P361 wd:Q130436; # eras of the history of Japan wdt:P580 ?start_time. MINUS { ?era wdt:P2348/wdt:P361 wd:Q130436 } # exclude sub-eras OPTIONAL { ?era wdt:P582 ?end_time } # optional end-time to make sure we include the current era OPTIONAL { ?era wdt:P138 ?named } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY ?start DESC(?end) | ||
| Ancestors of Willem-Alexander of the Netherlands | Q154952|P22|P25|P569 | SELECT DISTINCT ?item ?itemLabel ?dateofbirth WHERE { wd:Q154952 (wdt:P22|wdt:P25)* ?item . OPTIONAL { ?item wdt:P569 ?dateofbirth } . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY ?itemLabel | ||
| All events that occured on 2001/09/11 | P585|P585 | SELECT ?item ?itemLabel WHERE { ?item p:P585/ps:P585 "2001-09-11T00:00:00Z"^^xsd:dateTime SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } | ||
| Everything with a time property on a given date | P31|P279|Q18636219|P31 | SELECT (GROUP_CONCAT(?classLabel; SEPARATOR = "; ") AS ?classes) ?propLabel ?i ?iLabel ?iDescription WHERE { { SELECT ?i ?prop ?class WHERE { { SELECT ?prop ?p WHERE { ?prop wikibase:directClaim ?p; (wdt:P31/(wdt:P279*)) wd:Q18636219. } } ?i ?p "2001-5-11"^^xsd:dateTime. OPTIONAL { ?i wdt:P31 ?class } } LIMIT 1000 } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". ?class rdfs:label ?classLabel. ?prop rdfs:label ?propLabel. ?i rdfs:label ?iLabel; schema:description ?iDescription. } } GROUP BY ?propLabel ?i ?iLabel ?iDescription | ||
| US presidents & causes of death | ||||
| List of presidents with causes of death | P39|Q11696|P509|P570 | SELECT ?h ?hLabel ?cause ?causeLabel (YEAR(?date) AS ?year) WHERE { ?h wdt:P39 wd:Q11696; wdt:P509 ?cause; wdt:P570 ?date SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } ORDER BY ?year | ||
| Presidents and their causes of death ranking | P39|Q11696|P509 | #defaultView:BubbleChart SELECT ?cid ?cause (count(*) as ?count) WHERE { ?pid wdt:P39 wd:Q11696 . ?pid wdt:P509 ?cid . OPTIONAL { ?cid rdfs:label ?cause FILTER (lang(?cause) = "en") . } } GROUP BY ?cid ?cause ORDER BY DESC(?count) ASC(?cause) | ||
| Churches | ||||
| Cathedrals in Paris | P31|Q2977|P131|P131|Q90|P625|P18 | SELECT ?item ?itemLabel ?placeLabel ?coords ?image WHERE { ?item wdt:P31 wd:Q2977 . ?item wdt:P131 ?place . ?place wdt:P131 wd:Q90 . OPTIONAL { ?item wdt:P625 ?coords . } OPTIONAL { ?item wdt:P18 ?image . } SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . } } ORDER BY ?placeLabel ?itemLabel | ||
| Churches in church district Wittenberg | Q75849591|P527|P527|P361|P31|Q76598130|P625|P373|P18 | #defaultView:Map{"layer": "?pbLabel"} SELECT ?item ?itemLabel ?pbLabel (SAMPLE(?cat) AS ?cat) (SAMPLE(?coord) AS ?coord) (SAMPLE(?img) AS ?img) WHERE { wd:Q75849591 wdt:P527 [ wdt:P527 ?item; wdt:P361 ?pb ]. ?pb wdt:P31 wd:Q76598130. ?item wdt:P625 ?coord. OPTIONAL { ?item wdt:P373 ?cat. } OPTIONAL { ?item wdt:P18 ?img. } SERVICE wikibase:label { bd:serviceParam wikibase:language "de". } } GROUP BY ?item ?itemLabel ?pbLabel | ||
| Special church type "Spitalkirche" in Germany | P31|Q16970|P131|P17|Q183|P625 | #defaultView:Map SELECT ?pid ?name ?coord ?ort ?ortLabel WHERE { ?pid wdt:P31 wd:Q16970. ?pid rdfs:label ?name FILTER((LANG(?name)) = "de") FILTER(REGEX(STR(?name), "[Ss]pitalkirche")). ?pid wdt:P131 ?ort. ?pid wdt:P17 wd:Q183. ?pid wdt:P625 ?coord. SERVICE wikibase:label { bd:serviceParam wikibase:language "de,en". } } | ||
| Museums | ||||
| Museums in Brittany | P539|P131|Q12130|P131|P166|Q2275045|P856|P625|P625|P625 | SELECT DISTINCT ?museumLabel ?museumDescription ?villeId ?villeIdLabel (?villeIdLabel AS ?ville) ?coord ?lat ?lon WHERE { ?museum wdt:P539 ?museofile. # french museofile Id ?museum wdt:P131* wd:Q12130. # in Brittany ?museum wdt:P131 ?villeId. #city of the museum # ?object wdt:P166 wd:Q2275045 # that have french label "musées de France" OPTIONAL {?museum wdt:P856 ?link.} # official website OPTIONAL {?museum wdt:P625 ?coord .} # geographic coord OPTIONAL { ?museum p:P625 ?statement. ?statement psv:P625 ?node. ?node wikibase:geoLatitude ?lat. ?node wikibase:geoLongitude ?lon. } SERVICE wikibase:label { bd:serviceParam wikibase:language "fr". } #french label } ORDER BY ?villeIdLabel | ||
| All museums in Barcelona with coordinates | P131|Q1492|P31|P279|Q33506|P625|P625|P625 | #All museums (including subclass of museum) in Barcelona with coordinates SELECT DISTINCT ?item ?name ?coord ?lat ?lon WHERE { hint:Query hint:optimizer "None" . ?item wdt:P131* wd:Q1492 . ?item wdt:P31/wdt:P279* wd:Q33506 . ?item wdt:P625 ?coord . ?item p:P625 ?coordinate . ?coordinate psv:P625 ?coordinate_node . ?coordinate_node wikibase:geoLatitude ?lat . ?coordinate_node wikibase:geoLongitude ?lon . SERVICE wikibase:label { bd:serviceParam wikibase:language "ca" . ?item rdfs:label ?name } } ORDER BY ASC (?name) | ||
| Museums in Antwerp | P31|P279|Q33506|P131|Q12892|P625 | #defaultView:Map SELECT ?item ?itemLabel ?coordinates WHERE { ?item wdt:P31/wdt:P279* wd:Q33506 ; wdt:P131 wd:Q12892 ; wdt:P625 ?coordinates . SERVICE wikibase:label { bd:serviceParam wikibase:language "nl, en" } } | ||
| Louvre artworks in display cases | P276|P31|Q3561331|P276|P31|P279|Q180516|Q15206795|P466|P361|Q19675|P18 | #defaultView:ImageGrid SELECT ?item ?itemLabel ?itemDescription ?image WHERE { #part1: objects in cases { ?item wdt:P276 ?case . ?case wdt:P31 wd:Q3561331 . ?case wdt:P276 ?room . ?room wdt:P31/wdt:P279* wd:Q180516 . # wd:Q15206795 ?room wdt:P466 ?dep . ?dep wdt:P361+ wd:Q19675 } OPTIONAL { ?item wdt:P18 ?image } # Optionally with an image SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en,fr" } } | ||
| Film and television | ||||
| Characters portrayed by most actors | P161|P161|P453|P31|Q5 | SELECT ?character ?characterLabel (COUNT(?actor) AS ?count) WHERE { { SELECT DISTINCT ?character ?actor WHERE { ?film p:P161 [ ps:P161 ?actor; pq:P453 ?character ]. #?character wdt:P31 wd:Q5. # uncomment to filter for real people } } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } GROUP BY ?character ?characterLabel ORDER BY DESC(?count) LIMIT 25 | ||
| List of actors with pictures with year of birth and/or death | P31|Q5|P106|Q33999|P18|P569|P570 | #defaultView:ImageGrid SELECT ?human ?humanLabel ?yob ?yod ?picture WHERE { ?human wdt:P31 wd:Q5 ; wdt:P106 wd:Q33999 . ?human wdt:P18 ?picture . OPTIONAL { ?human wdt:P569 ?dob . ?human wdt:P570 ?dod }. BIND(YEAR(?dob) as ?yob) . #if available: year BIND(YEAR(?dod) as ?yod) . SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . } } LIMIT 88 | ||
| Actors who played the same role more than 40 years apart | P161|P161|P453|P577|P161|P161|P453|P577|P31|P279|Q24856|P31|P279|Q24856|Q18086706 | SELECT DISTINCT ?actor ?actorLabel ?characterLabel ?movie1Label ?movie2Label WHERE { ?movie1 p:P161 [ ps:P161 ?actor; pq:P453 ?character ]; wdt:P577 ?movie1Publication. ?movie2 p:P161 [ ps:P161 ?actor; pq:P453 ?character ]; wdt:P577 ?movie2Publication. MINUS{?movie1 wdt:P31/wdt:P279? wd:Q24856} # Not a series MINUS{?movie2 wdt:P31/wdt:P279? wd:Q24856} # Not a series FILTER(?character != wd:Q18086706). # Not as "themselves" FILTER(?movie1Publication + "P40Y"^^xsd:duration < ?movie2Publication) # 40 years between them SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } | ||
| Films of directors by their English Wikipedia name | P31|Q11424|P136|P57|P577 | SELECT ?film ?filmLabel ?genere ?d WHERE { { SELECT ?film (GROUP_CONCAT(DISTINCT ?gL; SEPARATOR = ", ") AS ?genere) (MIN(YEAR(?date)) AS ?d) WHERE { ?sitelink schema:about ?director; schema:isPartOf <https://en.wikipedia.org/>; schema:name "Steven Spielberg"@en. # Edit this with different director's name to see their films. Use the English Wikipedia title only. ?film wdt:P31 wd:Q11424; wdt:P136 ?g, ?g. ?g rdfs:label ?gL. ?film wdt:P57 ?director; wdt:P577 ?date. FILTER((LANG(?gL)) = "en") SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } GROUP BY ?film } SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY DESC (?d) | ||
| Winner of the Academy Awards by Award and Time | P106|P279|Q3455803|P106|Q3455803|P279|P166|P166|P805|P166|Q103360|Q103360|P585 | SELECT DISTINCT ?item ?itemLabel ?awardLabel ?time { ?item wdt:P106/wdt:P279* wd:Q3455803 ; # Items with the Occupation(P106) of Director(Q3455803) or a subclass(P279) p:P166 ?awardStat . # ... with an awarded(P166) statement ?awardStat pq:P805 ?award ; # Get the award (which is "subject of" XXth Academy Awards) ps:P166 wd:Q103360 . # ... that has the value Academy Award for Best Director(Q103360) ?award wdt:P585 ?time . # the "point of time" of the Academy Award SERVICE wikibase:label { # ... include the labels bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?time) | ||
| Academy award data | P31|Q19020|P31|Q19020|P166|P166|P166|P805|P1686|P31|Q5|P31|Q11424|P166|P166|P166|P805|P585|P57 | SELECT ?human ?humanLabel ?awardEditionLabel ?awardLabel ?awardWork ?awardWorkLabel ?director ?directorLabel ?time WHERE { { SELECT (SAMPLE(?human) AS ?human) ?award ?awardWork (SAMPLE(?director) AS ?director) (SAMPLE(?awardEdition) AS ?awardEdition) (SAMPLE(?time) AS ?time) WHERE { ?award wdt:P31 wd:Q19020 . # All items that are instance of(P31) of Academy awards (Q19020) { ?human p:P166 ?awardStat . # Humans with an awarded(P166) statement ?awardStat ps:P166 ?award . # ... that has any of the values of ?award ?awardStat pq:P805 ?awardEdition . # Get the award edition (which is "subject of" XXth Academy Awards) ?awardStat pq:P1686 ?awardWork . # The work they have been awarded for ?human wdt:P31 wd:Q5 . # Humans } UNION { ?awardWork wdt:P31 wd:Q11424 . # Films ?awardWork p:P166 ?awardStat . # ... with an awarded(P166) statement ?awardStat ps:P166 ?award . # ... that has any of the values of ?award ?awardStat pq:P805 ?awardEdition . # Get the award edition (which is "subject of" XXth Academy Awards) } OPTIONAL { ?awardEdition wdt:P585 ?time . # the "point of time" of the Academy Award ?awardWork wdt:P57 ?director . } } GROUP BY ?awardWork ?award # We only want every movie once for a category (a 'random' person is selected) } SERVICE wikibase:label { # ... include the labels bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" . } } ORDER BY DESC(?time) | ||
| People that received both Academy Award and Nobel Prize | P279|P31|Q7191|P279|P31|Q19020|P166|P166 | SELECT DISTINCT ?Person ?PersonLabel ?NobelPrizeLabel ?AcademyAwardLabel WHERE { ?NobelPrize wdt:P279?/wdt:P31? wd:Q7191 . # <- subtypes of nobel prize ?AcademyAward wdt:P279?/wdt:P31? wd:Q19020 . # <- subtypes of academy award ?Person wdt:P166? ?NobelPrize . # <- people awarded a nobel prize ?Person wdt:P166? ?AcademyAward . # <- people awarded an academy award SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" . } } | ||
| Number of handed out Academy Awards per award type | P31|Q19020|P31|Q19020|P166|P166|P166|P805|P1686|P31|Q5|P31|Q11424|P166|P166|P166|P805|P585|P57 | SELECT ?awardCount ?award ?awardLabel WHERE { { SELECT (COUNT(?award) AS ?awardCount) ?award WHERE { { SELECT (SAMPLE(?human) AS ?human) ?award ?awardWork (SAMPLE(?director) AS ?director) (SAMPLE(?awardEdition) AS ?awardEdition) (SAMPLE(?time) AS ?time) WHERE { ?award wdt:P31 wd:Q19020 . # All items that are instance of(P31) of Academy awards (Q19020) { ?human p:P166 ?awardStat . # Humans with an awarded(P166) statement ?awardStat ps:P166 ?award . # ... that has any of the values of ?award ?awardStat pq:P805 ?awardEdition . # Get the award edition (which is "subject of" XXth Academy Awards) ?awardStat pq:P1686 ?awardWork . # The work they have been awarded for ?human wdt:P31 wd:Q5 . # Humans } UNION { ?awardWork wdt:P31 wd:Q11424 . # Films ?awardWork p:P166 ?awardStat . # ... with an awarded(P166) statement ?awardStat ps:P166 ?award . # ... that has any of the values of ?award ?awardStat pq:P805 ?awardEdition . # Get the award edition (which is "subject of" XXth Academy Awards) } OPTIONAL { ?awardEdition wdt:P585 ?time . # the "point of time" of the Academy Award ?awardWork wdt:P57 ?director . } } GROUP BY ?awardWork ?award # We only want every movie once for a category (a 'random' person is selected) } } GROUP BY ?award ORDER BY ASC(?awardCount) } SERVICE wikibase:label { # ... include the labels bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" . } } | ||
| Film directors ranked by number of sitelinks multiplied by their number of films | P106|Q2526255|P57 | SELECT ?director ?director_label ?films ?sitelinks ((?films * ?sitelinks) as ?rank) WHERE { {SELECT ?director (count(DISTINCT ?film) as ?films) (count(DISTINCT ?sitelink) as ?sitelinks) WHERE { ?director wdt:P106 wd:Q2526255 . # has "film director" as occupation ?film wdt:P57 ?director . # get all films directed by the director ?sitelink schema:about ?director . # get all the sitelinks about the director } GROUP BY ?director } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". # Get label if it exists ?director rdfs:label ?director_label } } ORDER BY DESC(?rank) LIMIT 100 | ||
| The Simpsons television series episodes list by season | Q886|P179|P527|P179|P1545 | SELECT ?show ?showLabel ?seasonNumber ?episode ?episodeLabel WHERE { BIND(wd:Q886 as ?show) . ?season wdt:P179 ?show; wdt:P527 ?episode; p:P179 [pq:P1545 ?seasonNumber] . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY xsd:integer(?seasonNumber) | ||
| Law & Order episodes | P31|Q21191270|P179|Q321423|P179|P179|P179|P179|Q321423|P1545|P1545|P1476|P577 | # All Law & Order episodes on Wikidata. # According to enwp, “[a] total of 456 original episodes… aired before cancellation” (https://en.wikipedia.org/wiki/List_of_Law_%26_Order_episodes). # As of this writing, the query returns 451 results, so some episodes are missing (either without item or lacking the necessary statements to match this query). SELECT (SAMPLE(?seasonNumber) AS ?seasonNumber) (SAMPLE(?episodeNumber) AS ?episodeNumber) (SAMPLE(?title) AS ?title) (MIN(?pubDate) AS ?pubDate) ?episode { # All episodes should be instance of episode with series Law & Order. ?episode wdt:P31 wd:Q21191270; wdt:P179 wd:Q321423. # Many of them also have the season as series, so we can get episode and season number from qualifiers there. OPTIONAL { ?episode p:P179 [ # the season also has series Law & Order ps:P179/p:P179 [ ps:P179 wd:Q321423; pq:P1545 ?seasonNumber ] ; pq:P1545 ?episodeNumber ] } OPTIONAL { ?episode wdt:P1476 ?title. } OPTIONAL { ?episode wdt:P577 ?pubDate. } } GROUP BY ?episode # make sure we return each episode only once – a few have multiple publication dates, for example ORDER BY IF(BOUND(?seasonNumber), xsd:integer(?seasonNumber), 1000) xsd:integer(?episodeNumber) ?title | ||
| Main subjects of West Wing episodes | P31|P279|Q1983062|P179|P921|P179|Q3577037|P1545 | SELECT DISTINCT ?episode ?ordinal ?episodeLabel ?subject ?subjectLabel WHERE { ?episode wdt:P31/wdt:P279* wd:Q1983062; p:P179 ?statement. OPTIONAL{ ?episode wdt:P921 ?subject } ?statement ps:P179 wd:Q3577037; pq:P1545 ?ordinal SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } ORDER BY xsd:integer(?ordinal) | ||
| Movies with Bud Spencer | P161|Q221074|P577|P18 | SELECT ?item ?itemLabel (MIN(?date) AS ?firstReleased) ?_image WHERE { ?item wdt:P161 wd:Q221074; wdt:P577 ?date SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } OPTIONAL { ?item wdt:P18 ?_image. } } GROUP BY ?item ?itemLabel ?_image ORDER BY (?date) | ||
| Contemporary Indian actresses | P106|Q33999|P27|Q668|P21|Q6581072|P570|P18|P569 | SELECT ?item ?itemLabel ?itemDescription (SAMPLE(?img) AS ?image) (SAMPLE(?dob) AS ?dob) ?sl WHERE { ?item wdt:P106 wd:Q33999 ; wdt:P27 wd:Q668 ; wdt:P21 wd:Q6581072 . MINUS { ?item wdt:P570 [] } OPTIONAL { ?item wdt:P18 ?img } OPTIONAL { ?item wdt:P569 ?dob } OPTIONAL { ?item wikibase:sitelinks ?sl } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en"} } GROUP BY ?item ?itemLabel ?itemDescription ?sl ORDER BY DESC(?sl) | ||
| Articles on Punjabi (Gurmukhi) Wikipedia about Pakistani actresses | P21|Q6581072|Q25|P27|Q843|Q33999|P106|Q33999|P31|Q5 | #added 2017-03-25 (46 results) SELECT ?sitelink WHERE { # gender = female ?item wdt:P21 wd:Q6581072 . # country = Pakistan (Q25) { ?item wdt:P27 wd:Q843 } # occupation = actress (Q33999) { ?item wdt:P106 wd:Q33999 } # look for articles (sitelinks) in Punjabi ("pa") { ?sitelink schema:about ?item . ?sitelink schema:inLanguage "pa" } # humans only ?item wdt:P31 wd:Q5 . } #Listeria can only handle up to 5000 LIMIT 5000 | ||
| All Dr. Who performers | P31|Q47543030|P1545|P175|P175 | #added 2017-07-16, updated 2020-07-08 SELECT ?doctor ?doctorLabel ?ordinal ?performer ?performerLabel WHERE { ?doctor wdt:P31 wd:Q47543030 . OPTIONAL { ?doctor wdt:P1545 ?ordinal } OPTIONAL { ?doctor p:P175 / ps:P175 ?performer } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY ASC(xsd:integer(?ordinal) ) | ||
| Movies and their narrative location on a map | P840|P31|Q11424|P625 | #defaultView:Map SELECT ?movie ?movieLabel ?narrative_location ?narrative_locationLabel ?coordinates WHERE { ?movie wdt:P840 ?narrative_location ; wdt:P31 wd:Q11424 . ?narrative_location wdt:P625 ?coordinates . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } | ||
| Movies released in 2017 | P31|Q11424|P577 | SELECT DISTINCT ?item ?itemLabel WHERE { ?item wdt:P31 wd:Q11424. ?item wdt:P577 ?pubdate. FILTER((?pubdate >= "2017-01-01T00:00:00Z"^^xsd:dateTime) && (?pubdate <= "2017-12-31T00:00:00Z"^^xsd:dateTime)) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } | ||
| Literature | ||||
| Authors, writers and poets ranked by sitelink and also includes "country of citizenship" | P106|Q36180|P106|Q482980|P106|Q49757|P27 | SELECT DISTINCT ?writer ?place ?linkcount WHERE { {?s wdt:P106 wd:Q36180 .} UNION { ?s wdt:P106 wd:Q482980 . } UNION { ?s wdt:P106 wd:Q49757 . } ?s wdt:P27 ?pl . ?s wikibase:sitelinks ?linkcount . OPTIONAL { ?s rdfs:label ?writer FILTER (lang(?writer) = "en"). } OPTIONAL { ?pl rdfs:label ?place FILTER (lang(?place) = "en"). } } GROUP BY ?place ?writer ?linkcount HAVING (?linkcount > 10) ORDER BY DESC(?linkcount) | ||
| Occupation: writer, language: Belarussian, died more than 50 years (so his books now in public domain) | P31|Q5|P106|Q36180|P1412|Q9091|P570 | SELECT ?writer ?writerLabel ?dateOfDeath WHERE { ?writer wdt:P31 wd:Q5; # Instance of human wdt:P106 wd:Q36180; # Occupation writer wdt:P1412 wd:Q9091; # Languages spoken or written Belarusian wdt:P570 ?dateOfDeath . FILTER((YEAR(?dateOfDeath)) <= (YEAR(NOW()) - 50)) . # More than 50 years ago SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],be". } } ORDER BY DESC(?dateOfDeath) | ||
| Birth places of German poets | P106|Q49757|P19|P17|Q183|P625|P569 | #defaultView:Map{"hide": ["?coord"]} SELECT ?subj ?subjLabel ?place ?placeLabel ?coord ?birthyear WHERE { ?subj wdt:P106 wd:Q49757 . ?subj wdt:P19 ?place . ?place wdt:P17 wd:Q183 . ?place wdt:P625 ?coord . OPTIONAL { ?subj wdt:P569 ?dob } BIND(YEAR(?dob) as ?birthyear) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } | ||
| Books or literary works published before 1830 with place of publication or narrative location coordinates | Q571|Q7725634|P31|P577|P291|P840|P625 | SELECT ?item ?label ?coord ?place WHERE { VALUES ?type {wd:Q571 wd:Q7725634} # book or literary work ?item wdt:P31 ?type . ?item wdt:P577 ?date FILTER (?date < "1830-01-01T00:00:00Z"^^xsd:dateTime) . ?item rdfs:label ?label FILTER (lang(?label) = "en") OPTIONAL { ?item (wdt:P291|wdt:P840) ?place . # publication or narration place is ?place ?place wdt:P625 ?coord } } | ||
| Books by a given Author including genres and date of first publication | P50|P136|P577 | SELECT DISTINCT ?book ?bookLabel ?authorLabel (GROUP_CONCAT(?genre_label) as ?genres) (MIN(?publicationDate) as ?firstPublication) WHERE { ?author rdfs:label "Ernest Hemingway"@en . ?book wdt:P50 ?author . OPTIONAL { ?book wdt:P136 ?genre . ?genre rdfs:label ?genre_label FILTER (lang(?genre_label) = "en"). } OPTIONAL { ?book wdt:P577 ?publicationDate . } SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . } } GROUP BY ?book ?bookLabel ?authorLabel | ||
| Text by author containing case-insensitive title with optional cover image | P31|P279|Q234460|P50|P18 | SELECT DISTINCT ?item ?authorLabel ?itemLabel ?image where { ?item wdt:P31/wdt:P279* wd:Q234460. ?author ?label 'Bram Stoker'. ?item wdt:P50 ?author. ?item rdfs:label ?itemLabel. FILTER contains(lcase(?itemLabel), 'dracula'). OPTIONAL {?item wdt:P18 ?image.} SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE]".} } LIMIT 50 | ||
| Literary works by label count | P31|Q7725634 | SELECT ?s ?desc (COUNT(DISTINCT ?label) as ?labelcount) WHERE { ?s wdt:P31 wd:Q7725634 . ?s rdfs:label ?label . OPTIONAL { ?s rdfs:label ?desc FILTER (lang(?desc) = "en"). } } GROUP BY ?s ?desc ORDER BY DESC(?labelcount) | ||
| All subclasses of "Literary Work" | P279|Q7725634 | SELECT ?s ?desc WHERE { ?s wdt:P279 wd:Q7725634 . OPTIONAL { ?s rdfs:label ?desc FILTER (lang(?desc) = "en"). } } | ||
| Epic poems by label count | P31|Q37484 | SELECT ?s ?desc (COUNT(DISTINCT ?label) as ?labelcount) WHERE { ?s wdt:P31 wd:Q37484 . ?s rdfs:label ?label . OPTIONAL { ?s rdfs:label ?desc FILTER (lang(?desc) = "en"). } } GROUP BY ?s ?desc ORDER BY DESC(?labelcount) | ||
| Epic poems by sitelink count | P31|Q37484 | #old method for sitelink count SELECT ?s ?desc ?linkcount WHERE { ?s wdt:P31 wd:Q37484 . ?s wikibase:sitelinks ?linkcount . OPTIONAL { ?s rdfs:label ?desc FILTER (lang(?desc) = "en"). } } GROUP BY ?s ?desc ?linkcount ORDER BY DESC(?linkcount) | ||
| Instance of Book by sitelink count | P31|Q571 | #old method for sitelink count SELECT ?s ?desc ?linkcount WHERE { ?s wdt:P31 wd:Q571 . ?s wikibase:sitelinks ?linkcount . OPTIONAL { ?s rdfs:label ?desc FILTER (lang(?desc) = "en"). } } GROUP BY ?s ?desc ?linkcount ORDER BY DESC(?linkcount) | ||
| Poets and monarchs | P39|P39|Q877838|P580|P748|P582|P18|P569|P570 | SELECT ?poetLabel ?image ?yob ?yod ?start ?end ?monarchLabel WHERE { ?poet p:P39 ?positionStat. ?positionStat ps:P39 wd:Q877838; pq:P580 ?start; pq:P748 ?monarch. OPTIONAL { ?positionStat pq:P582 ?end. } OPTIONAL { ?poet wdt:P18 ?image; wdt:P569 ?dob; wdt:P570 ?dod. } BIND(YEAR(?dob) AS ?yob). BIND(YEAR(?dod) AS ?yod). SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } } ORDER BY ?start DESC(?monarchLabel) | ||
| List of digital libraries in the world | P31|P279|Q212805|P856|P576 | SELECT DISTINCT ?item ?itemLabel ?website WHERE { ?item wdt:P31/wdt:P279* wd:Q212805 # digital libraries or subtypes OPTIONAL { ?item wdt:P856 ?website } # Official URL if known MINUS { ?item wdt:P576 [] } # Exclude those that have shut down SERVICE wikibase:label { bd:serviceParam wikibase:language "en, es, ca, fr, de, pl, uk, ru, he" } } ORDER BY ?itemLabel | ||
| Map of Libraries in Canada | P31|P279|Q7075|P17|Q16|P625 | # Canadian libraries on a map (must have coordinates!) #defaultView:Map SELECT ?library ?libraryLabel ?coords WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en,fr". } ?library (wdt:P31/wdt:P279*) wd:Q7075. ?library wdt:P17 wd:Q16. ?library wdt:P625 ?coords. } | ||
| List of authors unsuccessfully nominated for Nobel prize in literature | Q37922|P1411|P1411|P585|P27|P166 | SELECT ?nominee ?nomineeLabel (SAMPLE(?citizenshipLabel) AS ?country) (COUNT(DISTINCT ?year) as ?timesNominated) WHERE { BIND( wd:Q37922 as ?prize ) ?nominee p:P1411 [ ps:P1411 ?prize; pq:P585 ?time ] BIND( year(?time) as ?year ) OPTIONAL { ?nominee wdt:P27 [ rdfs:label ?citizenshipLabel ] FILTER (lang(?citizenshipLabel) = "en") . } FILTER NOT EXISTS { ?nominee wdt:P166 ?prize . } SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } } GROUP BY ?nominee ?nomineeLabel ORDER BY DESC(?timesNominated) ?nomineeLabel | ||
| Authors whose works enter the public domain in 2017 (died in 1946) | P31|Q5|P106|P279|Q482980|P570 | SELECT DISTINCT ?item WHERE { ?item wdt:P31 wd:Q5 ; wdt:P106/wdt:P279* wd:Q482980 . ?item wdt:P570 ?time0 . FILTER((?time0 >= "1945-01-01T00:00:00Z"^^xsd:dateTime) && (?time0 <= "1946-01-01T00:00:00Z"^^xsd:dateTime)) } | ||
| Authors with United States citizenship without a Goodreads identifier | P31|Q5|P31|Q5|P27|Q30|P27|Q30|P106|Q36180|P106|Q36180|P2963 | #authors with country of citizenship United States who do not have a Goodreads identifier SELECT ?item ?itemLabel WHERE { ?item wdt:P31 wd:Q5. #instance of (P31) human (Q5) ?item wdt:P27 wd:Q30. #country of citizenship (P27) is United States (Q30) ?item wdt:P106 wd:Q36180. #occupation (P106) is writer (Q36180) MINUS { ?item wdt:P2963 [] } . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } | ||
| Works by women that were born between 1800 and 1900, are in the WomenWriters database and are translated | P655|P50|P2533|P21|Q6581072|P569 | SELECT ?translator ?translatorLabel ?work ?workLabel ?author ?authorLabel { ?work wdt:P655 ?translator; wdt:P50 ?author. ?author wdt:P2533 ?wid; wdt:P21 wd:Q6581072; wdt:P569 ?birth; FILTER (?birth > "1800-01-01"^^xsd:dateTime && ?birth < "1900-01-01"^^xsd:dateTime) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en,nl,fr". } } | ||
| Fictional characters | ||||
| Pokémon! | P31|P279|Q3966183|P1685|P1685|P972|Q20005020 | # Updated 2020-06-17 # Gotta catch 'em all SELECT DISTINCT ?pokemon ?pokemonLabel ?pokedexNumber WHERE { ?pokemon wdt:P31/wdt:P279* wd:Q3966183 . ?pokemon p:P1685 ?statement. ?statement ps:P1685 ?pokedexNumber; pq:P972 wd:Q20005020. FILTER (! wikibase:isSomeValue(?pokedexNumber) ) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY (?pokedexNumber) | ||
| Fictional subjects of the Marvel Universe | P1080|Q931597|P31|P1080 | SELECT ?char ?charName (GROUP_CONCAT(DISTINCT ?typeLabel;separator=", ") AS ?types) (GROUP_CONCAT(DISTINCT ?universeLabel;separator=", ") AS ?universes) WHERE { ?char wdt:P1080 wd:Q931597; wdt:P31 ?type ; wdt:P1080 ?universe . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". ?char rdfs:label ?charName . ?universe rdfs:label ?universeLabel . ?type rdfs:label ?typeLabel .} } GROUP BY ?char ?charName | ||
| Fictional characters whose birth/death date is in the current decade | P279|Q95074|P31|P569|P570 | SELECT DISTINCT ?character ?characterLabel ?birth ?death WITH { # Fictional character subclasses as a named subquery SELECT ?fictiontype WHERE { ?fictiontype wdt:P279* wd:Q95074. hint:Prior hint:gearing "forward". } } AS %i WHERE { INCLUDE %i ?character wdt:P31 ?fictiontype. # Date of birth { ?character wdt:P569 ?birth . } # Date of death UNION { ?character wdt:P570 ?death . } # Get actual decade to compare with dates BIND(xsd:integer(YEAR(NOW())/10) as ?actual_decade). # Only show characters born or deceased in the current decade FILTER(xsd:integer(YEAR(?birth)/10) = ?actual_decade || xsd:integer(YEAR(?death)/10) = ?actual_decade) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" . } } ORDER BY ?birth ?death | ||
| Music | ||||
| List tracks of an album, with links to Yandex, Apple, Spotify, Amazon | Q105834355|P658|P658|P1545|P750|P750|Q4537983|P2699|P750|P750|Q20056642|P2699|P5749|P2207 | SELECT ?order ?item ?itemLabel ?yandex ?apple (URI(CONCAT("https://open.spotify.com/track/", ?spotify_id)) AS ?spotify) (URI(CONCAT("https://www.amazon.com/dp/", ?amazon_id)) AS ?amazon) { wd:Q105834355 p:P658 ?st . ?st ps:P658 ?item . OPTIONAL { ?st pq:P1545 ?order } . OPTIONAL {?item p:P750 [ps:P750 wd:Q4537983 ; pq:P2699 ?yandex ] .} OPTIONAL {?item p:P750 [ps:P750 wd:Q20056642 ; pq:P2699 ?apple ] .} OPTIONAL {?item wdt:P5749 ?amazon_id .} OPTIONAL {?item wdt:P2207 ?spotify_id .} SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],ru,en" } } ORDER BY xsd:integer(?order) | ||
| List tracks of an album, with links to Yandex, Apple, Spotify, Amazon: URLs without triangles - as text | Q105834355|P658|P658|P1545|P750|P750|Q4537983|P2699|P750|P750|Q20056642|P2699|P5749|P2207 | SELECT ?order ?item ?itemLabel (STR(?_yandex) AS ?yandex) (STR(?_apple) AS ?apple) (CONCAT("https://open.spotify.com/track/", ?spotify_id) AS ?spotify) (CONCAT("https://www.amazon.com/dp/", ?amazon_id) AS ?amazon) { wd:Q105834355 p:P658 ?st . ?st ps:P658 ?item . OPTIONAL { ?st pq:P1545 ?order } . OPTIONAL {?item p:P750 [ps:P750 wd:Q4537983 ; pq:P2699 ?_yandex ] .} OPTIONAL {?item p:P750 [ps:P750 wd:Q20056642 ; pq:P2699 ?_apple ] .} OPTIONAL {?item wdt:P5749 ?amazon_id .} OPTIONAL {?item wdt:P2207 ?spotify_id .} SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],ru,en" } } ORDER BY xsd:integer(?order) | ||
| Timeline of albums by Manu Chao and Mano Negra | Q936474|Q207898|P175|P577 | #defaultView:Timeline SELECT ?album ?performerLabel ?albumLabel ?publication_date WHERE { VALUES ?performer { wd:Q936474 wd:Q207898 } ?album wdt:P175 ?performer ; wdt:P577 ?publication_date . SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } | ||
| Most popular tonality | P826 | SELECT ?tonalityLabel (COUNT(?tonalityLabel) as ?count) WHERE { ?work wdt:P826 ?tonality. SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } } GROUP BY ?tonalityLabel ORDER BY DESC(?count) | ||
| Music composers by birth place | P106|Q36834|P18|P19|P625 | #defaultView:Map SELECT ?item ?itemLabel ?_coordinates ?_image WHERE { ?item wdt:P106 wd:Q36834; # occupation: composer wdt:P18 ?_image; # with an image depicting them wdt:P19/wdt:P625 ?_coordinates # their birthplace, specifically the coordinates of their birthplace SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } # labels in English } | ||
| Composers and their most-used tonality | P86|P826|P86|P826 | # Each composer’s most used tonality, with number of works in that tonality. # (If this is ambiguous – multiple tonalities with the same number – there are multiple results for one composer.) # # The SPARQL for this is an evil perversion of three subqueries (one of them nested in another). # To understand it, you have to go inside out… follow the numbers. SELECT ?composerLabel ?tonalityLabel ?count WHERE { { # 4. Group again, this time just by the composer. # We also select the highest count of a tonality. # Notice that we don’t know what tonality this count is associated with – we’ll get to that. # So now we have each composer, along with how often they used whatever tonality they used most. SELECT ?composer (MAX(?count) AS ?count_) WHERE { { # 2. Group by composer and tonality, so that for each composer and tonality, we get a count of how often the composer used this tonality. SELECT ?composer ?tonality (COUNT(?composition) AS ?count) WHERE { # 1. Extremely straightforward: the ?composition has the composer ?composer and the tonality ?tonality. # (I’m not bothering with any “instance of” because the presence of these two properties is a sufficient indicator of ?composition being a composition.) ?composition wdt:P86 ?composer; wdt:P826 ?tonality. } GROUP BY ?composer ?tonality HAVING(?count > 1) # 3. Limit that to counts > 1, because using a tonality once is hardly “most used”. } } GROUP BY ?composer } { # 6. Identical to 2. SELECT ?composer ?tonality (COUNT(?composition) AS ?count) WHERE { # 5. Identical to 1. ?composition wdt:P86 ?composer; wdt:P826 ?tonality. } GROUP BY ?composer ?tonality HAVING(?count > 1) # 7. Identical to 3. } # 8. That’s it. Wait, what? # From 4, we now have ?composer, any composer, and ?count, the count of how often they used whatever tonality they used most. # From 6, we also have a ?composer, as well as a ?tonality, and the count of how often they used that particular tonality. # The trick is that ?composer and ?count are the same variable in each subquery, and so now, when the two subqueries are joined, # we select only that ?tonality from 6 where the ?composer and the ?count are identical to those from 4 – # that is, where this tonality was used as often as the composer’s most-used tonality. # In other words, this must *be* the composer’s most-used tonality (except when there are multiple tonalities with the same count). SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY DESC(?count) # 9. Order by count (highest first), because the result isn’t very meaningful for low counts (many compositions aren’t on Wikidata or don’t have a tonality statement). | ||
| Songs with longest melody | P1236 | SELECT ?song ?songLabel ?code WHERE { ?song wdt:P1236 ?code. SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY DESC(STRLEN(REPLACE(?code, " ", ""))) LIMIT 10 | ||
| How many musicians dies at certain age | P31|Q5|P106|P279|Q639669|P569|P569|P570|P570 | # Query to find all musicians who have already died # calculate their age (full years) at death # count how many of them died at each age SELECT ?age (COUNT (DISTINCT ?a) AS ?count) WHERE { ?a wdt:P31 wd:Q5 . #instance of human ?a wdt:P106/wdt:P279 wd:Q639669 . #occupation a subclass of musician ?a p:P569/psv:P569 ?birth_date_node . ?a p:P570/psv:P570 ?death_date_node . ?birth_date_node wikibase:timeValue ?birth_date . ?death_date_node wikibase:timeValue ?death_date . FILTER(?age > 10 && ?age < 100) . #ignore outlyers, several of which are probably errors BIND( year(?death_date) - year(?birth_date) - if(month(?death_date)<month(?birth_date) || (month(?death_date)=month(?birth_date) && day(?death_date)<day(?birth_date)),1,0) as ?age ) # calculate the age, precisely to the day (times and timezones ignored) } GROUP BY ?age ORDER BY ?age | ||
| Musicians born in Rotterdam (the Netherlands) | P106|P279|Q639669|P19|P131|Q34370 | SELECT DISTINCT ?item ?itemLabel ?itemDescription where { ?item wdt:P106/wdt:P279* wd:Q639669 . ?item wdt:P19/wdt:P131* wd:Q34370 . SERVICE wikibase:label { bd:serviceParam wikibase:language "en,nl" } } | ||
| Paintings depicting woodwind instruments | P31|P279|Q3305213|P180|P279|Q181247|P170|P18 | #title:Paintings depicting woodwind instruments #defaultView:ImageGrid SELECT ?item ?itemLabel ?object ?objectLabel ?artistLabel ?image WHERE { ?item wdt:P31/wdt:P279* wd:Q3305213 . # Painting or sub-type of painting ?item wdt:P180 ?object . ?object wdt:P279* wd:Q181247 . OPTIONAL {?item wdt:P170 ?artistitem} BIND (IF(wikibase:isSomeValue(?artistitem), "Artist unknown", ?artistitem) AS ?artist). ?item wdt:P18 ?image . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } | ||
| Paintings depicting musical instruments with some connection to Hamburg | P279|Q34379|P180|P31|P279|Q3305213|P18|Q1055 | #defaultView:ImageGrid SELECT DISTINCT ?item ?image { hint:Query hint:optimizer "None" . ?object wdt:P279* wd:Q34379 . ?item wdt:P180 ?object . ?item wdt:P31/wdt:P279* wd:Q3305213 . ?item wdt:P18 ?image . ?item ?prop ?hhlink . ?hhlink ?prop2 wd:Q1055 . } | ||
| Rock bands that start with "M" | P31|Q5741069 | SELECT ?band ?bandLabel WHERE { ?band wdt:P31 wd:Q5741069 . ?band rdfs:label ?bandLabel . FILTER(LANG(?bandLabel) = "en") . FILTER(STRSTARTS(?bandLabel, 'M')) . } ORDER BY LCASE(?bandLabel) | ||
| Musicians or singers that have a genre containing 'rock' | Q177220|Q639669|P31|Q5|P106|P136 | SELECT DISTINCT ?human ?humanLabel WHERE { VALUES ?professions {wd:Q177220 wd:Q639669} ?human wdt:P31 wd:Q5 . ?human wdt:P106 ?professions . ?human wdt:P136 ?genre . ?human wikibase:statements ?statementcount . ?genre rdfs:label ?genreLabel . FILTER CONTAINS(?genreLabel, "rock") . FILTER (?statementcount > 50 ) . SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } } ORDER BY ?humanLabel LIMIT 50 | ||
| '27 club' - musicians who died at age 27 | P31|Q5|P106|P279|Q639669|P569|P570|P569|P570 | SELECT ?person ?personLabel ?dob ?dod (xsd:integer(?age_) as ?age) where { # We do a subquery here, because otherwise we'll get a timeout because of the labels { SELECT DISTINCT ?person ?dob ?dod ?age_ where { ?person wdt:P31 wd:Q5; # Get all humans wdt:P106/wdt:P279* wd:Q639669; # That have a musician or a subclass thereof as their occupation p:P569 ?dob_st; # death of birth p:P570 ?dod_st. # death of death ?dob_st psv:P569 [ wikibase:timeValue ?dob; wikibase:timePrecision ?dob_prec ]; a wikibase:BestRank. ?dod_st psv:P570 [ wikibase:timeValue ?dod; wikibase:timePrecision ?dod_prec ]; a wikibase:BestRank. # Only accept date precisions of a day or better, so it doesn't cause problems when we calculate age FILTER(?dob_prec >= 11 && ?dod_prec >= 11) # Time differences in Blazegraph are counted as days and is xsd:double # We then calculate the age by dividing this by the orbital period of Earth # This is a shortcut, but it is accurate enough for our purposes bind((?dod - ?dob) / 365.2564 as ?age_) # And filter by age filter(?age_ >= 27.0 && ?age_ < 28.0) } #LIMIT 1000 } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } ORDER BY desc(?dod) # Order by most recent | ||
| Visual arts | ||||
| Public sculptures in Paris | P31|P279|Q860861|P136|Q557141|P131|Q90|P131|P131|Q90|P170|P571|P18|P625 | SELECT DISTINCT ?item ?Titre ?createur (year(?date) as ?AnneeCreation) ?image ?coord WHERE { ?item wdt:P31/wdt:P279* wd:Q860861. # sculpture ?item wdt:P136 wd:Q557141 . # genre : art public {?item wdt:P131 wd:Q90.} # ... située dans Paris UNION {?item wdt:P131 ?arr. # ... ou dans un arrondissement de Paris ?arr wdt:P131 wd:Q90. } ?item rdfs:label ?Titre FILTER (lang(?Titre) = "fr"). # Titre OPTIONAL {?item wdt:P170 ?Qcreateur. # créateur/créatrice (option) ?Qcreateur rdfs:label ?createur FILTER (lang(?createur) = "fr") .} OPTIONAL {?item wdt:P571 ?date.} # date de création (option) OPTIONAL {?item wdt:P18 ?image.} # image (option) OPTIONAL {?item wdt:P625 ?coord.} # coordonnées géographiques (option) } | ||
| Locations of Pablo Picasso works | P170|Q5593|P276|P625 | #defaultView:Map SELECT ?label ?coord ?subj WHERE { ?subj wdt:P170 wd:Q5593 . OPTIONAL {?subj wdt:P276 ?loc . ?loc wdt:P625 ?coord } . ?subj rdfs:label ?label FILTER (lang(?label) = "en") } | ||
| Eiffel Tower in art | P180|Q243|P31|P170|P571|P18 | SELECT DISTINCT ?item ?itemLabel ?instanceLabel ?creatorLabel (YEAR(?date) as ?year) ?image WHERE { ?item wdt:P180 wd:Q243 . ?item wdt:P31 ?instance . OPTIONAL { ?item wdt:P170 ?creator } OPTIONAL { ?item wdt:P571 ?date } OPTIONAL { ?item wdt:P18 ?image } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr,en" . } } ORDER BY ?itemLabel | ||
| Paintings by Gustav Klimt | P31|Q3305213|P170|Q34661|P18 | #defaultView:ImageGrid SELECT * WHERE { ?item wdt:P31 wd:Q3305213 . ?item wdt:P170 wd:Q34661 . ?item wdt:P18 ?pic . } | ||
| Map of all the paintings for which we know a location with the count per location | P31|Q3305213|P276|P625 | #Map of all the paintings for which we know a location with the count per location #defaultView:Map SELECT ?locationLabel ?coord (count(*) as ?count) WHERE { ?painting wdt:P31 wd:Q3305213 . ?painting wdt:P276 ?location . ?location wdt:P625 ?coord SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } } GROUP BY ?locationLabel ?coord | ||
| Versions of The Scream | P179|Q471379|P18|P571|P31|P195|P186 | SELECT ?item (SAMPLE (?itemL) AS ?title) (SAMPLE (?y) AS ?year) (SAMPLE (?typeL) AS ?type) (group_concat(DISTINCT ?materialL ; separator = ", ") as ?materials) (SAMPLE (?collectionL) AS ?collection) (SAMPLE (?img) AS ?image) { SELECT ?item ?itemL (YEAR(?date) AS ?y) ?typeL ?collectionL ?img ?materialL WHERE { ?item wdt:P179 wd:Q471379 . ?item wdt:P18 ?img . ?item wdt:P571 ?date . ?item wdt:P31 ?instance . ?item rdfs:label ?itemL FILTER (lang(?itemL) = "en"). ?instance rdfs:label ?typeL FILTER (lang(?typeL) = "en"). OPTIONAL { ?item wdt:P195 ?collection . ?collection rdfs:label ?collectionL FILTER (lang(?collectionL) = "en"). } OPTIONAL { ?item wdt:P186 ?material . ?material rdfs:label ?materialL FILTER (lang(?materialL) = "en"). } } } GROUP BY ?item ORDER BY ?year ?item ?itemLabel | ||
| Depicted objects in art work | P180 | SELECT DISTINCT ?depicts (SAMPLE(?dL) AS ?depictsLabel) (COUNT(DISTINCT ?item) AS ?count) WHERE { ?item wdt:P180 ?depicts . OPTIONAL { ?depicts rdfs:label ?dL FILTER (lang(?dL) = "en") } } GROUP BY ?depicts ORDER BY DESC(?count) ?depictsLabel | ||
| Monuments historiques in Loire-Atlantique | P1435|P279|Q916475|P1435|P582|P380|P131|P131|Q3068|P131|P625|P18 | SELECT DISTINCT ?item ?itemLabel ?communeLabel (group_concat(DISTINCT ?merimee ; separator = ", ") as ?merimee) ?coords ?image WHERE { { SELECT DISTINCT ?item ?merimee WHERE { ?item wdt:P1435/wdt:P279* wd:Q916475 . ?item p:P1435 ?heritage_statement . FILTER NOT EXISTS { ?heritage_statement pq:P582 ?end . } ?item wdt:P380 ?merimee. } ORDER BY ?merimee } ?item wdt:P131/wdt:P131* wd:Q3068 . ?item wdt:P131 ?commune . OPTIONAL { ?item wdt:P625 ?coords . } OPTIONAL { ?item wdt:P18 ?image . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr" . } } GROUP BY ?item ?itemLabel ?communeLabel ?coords ?image ORDER BY ?communeLabel ?itemLabel | ||
| Sculptures by Max Bill | P31|P279|Q860861|P170|Q123454|P17|P131|P571|P625|P18 | SELECT DISTINCT ?item ?itemLabel ?countryLabel ?placeLabel (YEAR(?date) as ?year) ?coords ?image WHERE { ?item wdt:P31/wdt:P279* wd:Q860861 . ?item wdt:P170 wd:Q123454 . OPTIONAL { ?item wdt:P17 ?country . } OPTIONAL { ?item wdt:P131 ?place . } OPTIONAL { ?item wdt:P571 ?date . } OPTIONAL { ?item wdt:P625 ?coords . } OPTIONAL { ?item wdt:P18 ?image . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" . } } ORDER BY ?itemLabel ?placeLabel | ||
| Paintings by Rembrandt in the Louvre or the Rijkmuseum | P31|Q3305213|P170|Q5598|P195|P361|Q190804|Q19675|P18 | #defaultView:ImageGrid SELECT DISTINCT ?item ?itemLabel ?itemDescription ?image ?collection WHERE { ?item wdt:P31 wd:Q3305213 ; # Get items that are instances of painting wdt:P170 wd:Q5598 ; # By creator Rembrandt wdt:P195/wdt:P361* ?collection . # That are in some collection # Only return results where 'collection' is either Rijkmuseum or Louvre FILTER ( ?collection = wd:Q190804 || ?collection = wd:Q19675 ) OPTIONAL { ?item wdt:P18 ?image } # Optionally with an image SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]" } } | ||
| Authority control properties usage for paintings | P31|Q3305213|P31|Q44847669 | # Make a list of the most used authority control properties for works for paintings SELECT ?propertyLabel ?propertyDescription (COUNT(?propertyclaim) AS ?count) WHERE { ?item wdt:P31 wd:Q3305213 . ?property wikibase:propertyType wikibase:ExternalId . ?property wdt:P31 wd:Q44847669 . ?property wikibase:claim ?propertyclaim . ?item ?propertyclaim [] . SERVICE wikibase:label { # ... include the labels bd:serviceParam wikibase:language "en" . } } GROUP BY ?propertyLabel ?propertyDescription ORDER BY DESC (?count) LIMIT 100 | ||
| Authority control properties usage for painters | P106|Q1028181|P31|Q5|P31|Q19595382 | # Make a list of the most used authority control properties for people for painters SELECT ?propertyLabel ?propertyDescription ?count WHERE { { SELECT ?propertyclaim (COUNT(*) AS ?count) where { ?item wdt:P106 wd:Q1028181 . ?item wdt:P31 wd:Q5 . ?item ?propertyclaim [] . } GROUP BY ?propertyclaim } ?property wikibase:propertyType wikibase:ExternalId . ?property wdt:P31 wd:Q19595382 . ?property wikibase:claim ?propertyclaim . SERVICE wikibase:label { # ... include the labels bd:serviceParam wikibase:language "en" . } } ORDER BY DESC (?count) LIMIT 100 | ||
| Ten random painting images | P31|Q3305213|P18 | # This returns 10 random painting images # RAND() returns one random number (cached like every query). # The string representation of the item and the random number are hashed. # This will give a complete different ordering every time you have a different random number. # You can change the LIMIT or OFFSET if you want to trigger a new random number #defaultView:ImageGrid SELECT ?item ?itemLabel ?image (MD5(CONCAT(str(?item),str(RAND()))) as ?random) WHERE { ?item wdt:P31 wd:Q3305213. ?item wdt:P18 ?image. SERVICE wikibase:label { bd:serviceParam wikibase:language "en"} } ORDER BY ?random LIMIT 10 OFFSET 0 | ||
| Painters related to anonymous works | P31|Q3305213|P170|Q4233718|P170 | #Paintings by anonymous painters, but are related to some other painter #defaultView:BubbleChart SELECT ?creatorqualifierLabel (COUNT(?creatorqualifier) AS ?count) WHERE { ?item wdt:P31 wd:Q3305213 . ?item wdt:P170 wd:Q4233718 . OPTIONAL { ?item p:P170 ?creatorstatement . ?creatorstatement rdf:type wikibase:BestRank . ?creatorstatement ?qualifier ?creatorqualifier . ?qualifierproperty wikibase:qualifier ?qualifier } SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } } GROUP BY ?creatorqualifierLabel HAVING (?count > 2) LIMIT 20000 | ||
| Painters type of relations with anonymous works | P31|Q3305213|P170|Q4233718|P170 | #Paintings by anonymous painters, types of relationships with other painters #defaultView:BubbleChart SELECT ?qualifierpropertyLabel (COUNT(?creatorqualifier) AS ?count) WHERE { ?item wdt:P31 wd:Q3305213 . ?item wdt:P170 wd:Q4233718 . OPTIONAL { ?item p:P170 ?creatorstatement . ?creatorstatement rdf:type wikibase:BestRank . ?creatorstatement ?qualifier ?creatorqualifier . ?qualifierproperty wikibase:qualifier ?qualifier } SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } } GROUP BY ?qualifierpropertyLabel HAVING (?count > 2) LIMIT 2000 | ||
| Using formatter url to construct links in SPARQL | P350|P1630|P350|P1630|P31|Q3305213|P18|P350 | # Get 10 paintings that have a link to RKDimages (P350) # Use the formatter URL (P1630) to construct the links to RKDimages #defaultView:ImageGrid SELECT ?item ?image ?rkdurl WHERE { wd:P350 wdt:P1630 ?formatterurl . ?item wdt:P31 wd:Q3305213 . ?item wdt:P18 ?image . ?item wdt:P350 ?rkdid . BIND(IRI(REPLACE(?rkdid, '^(.+)$', ?formatterurl)) AS ?rkdurl). } LIMIT 10 | ||
| Map of the locations of all paintings by Johannes Vermeer with an image | P276|P170|Q41264|P18|P625 | #defaultView:Map SELECT ?painting ?paintingLabel ?location ?image where { ?painting wdt:P276 ?collection; wdt:P170 wd:Q41264; wdt:P18 ?image. ?collection wdt:P625 ?location. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } | ||
| All impressionist painters that have been in an exhibition, together with the amount of exhibitions they have been in | P106|Q1028181|P106|Q1028181|P135|Q40415|Q40415|P135|P170|P170|P608|P608 | #title:Impressionist painters by number of exhibitions SELECT DISTINCT ?painter ?painterLabel (count (DISTINCT ?exhibition) as ?exhibition_count) (group_concat(DISTINCT ?exhibitionLabel; separator=", ") as ?exhibitions) WHERE { ?painter wdt:P106 wd:Q1028181 . #give me all people with occupation (P106) painter (Q1028181) ?painter wdt:P135 wd:Q40415 . #who belonged to the impressionist (Q40415) movement (P135) ?painting wdt:P170 ?painter . #the paintings created by (P170) the painter ?painting wdt:P608 ?exhibition . #have an exhibition history (P608) at an exhibition ?exhibition rdfs:label ?exhibitionLabel . #give me the english Labels of these exhibitions, if possible FILTER (lang(?exhibitionLabel) = "en") SERVICE wikibase:label {bd:serviceParam wikibase:language "en".} } GROUP BY ?painter ?painterLabel | ||
| Culture | ||||
| List of theatre plays | P31|Q25379 | SELECT ?play ?playLabel WHERE { ?play wdt:P31 wd:Q25379 . SERVICE wikibase:label { bd:serviceParam wikibase:language "en,es,pt,de,fr,ja,zh" . } } LIMIT 1000 | ||
| Public art in Paris | P136|Q557141|P131|Q90|P136|Q557141|P131|P131|Q90|P170|P136|Q557141|P31|P276|P131|P131|Q90|P18|P625 | SELECT ?item (SAMPLE (?titleL) AS ?title) (group_concat(DISTINCT ?creatorL ; separator = ", ") as ?creator) (group_concat(DISTINCT ?genreL ; separator = ", ") as ?genre) (group_concat(DISTINCT ?placeL ; separator = ", ") as ?place) (group_concat(DISTINCT ?arr ; separator = ", ") as ?arrondissement) (SAMPLE (?img) AS ?image) (SAMPLE (?coord) AS ?coordinates) { { SELECT DISTINCT ?item { { ?item wdt:P136 wd:Q557141 ; # genre: public art wdt:P131 wd:Q90 # located in: Paris } UNION { # or ?item wdt:P136 wd:Q557141 ; # genre: public art wdt:P131/wdt:P131* wd:Q90 # located in an arrondissement of Paris } } } # title OPTIONAL { ?item rdfs:label ?titleL FILTER (lang(?titleL) = "fr") } # creators OPTIONAL { ?item wdt:P170 [rdfs:label ?creatorL] FILTER (lang(?creatorL) = "fr") } #genre OPTIONAL { { ?item wdt:P136 ?g FILTER (STR(?g) != 'http://www.wikidata.org/entity/Q557141') } UNION { ?item wdt:P31 ?g . } ?g rdfs:label ?genreL FILTER (lang(?genreL) = "fr") . } # place OPTIONAL { ?item wdt:P276 [rdfs:label ?placeL] FILTER (lang(?placeL) = "fr") . } # arrondissement OPTIONAL { ?item wdt:P131 [wdt:P131 wd:Q90 ; rdfs:label ?arrL] FILTER (lang(?arrL) = "fr"). BIND(REPLACE(?arrL, '^([0-9]+).*$', "$1", "si") AS ?arr) } # image OPTIONAL { ?item wdt:P18 ?img } # coordinates OPTIONAL { ?item wdt:P625 ?coord } } GROUP BY ?item | ||
| Works of art where the name might be a rhyme | P31|P279|Q838948|P1476 | SELECT ?work ?title WHERE { ?work wdt:P31/wdt:P279* wd:Q838948; wdt:P1476 ?title. FILTER(REGEX(?title, "^\\w*(\\w{3})(\\W+\\w*\\1)+$", "i") && !REGEX(?title, "^(\\w+)(\\W+\\1)+$", "i")). } ORDER BY STR(?title) | ||
| Works of art where the title is an alliteration | P31|P279|Q838948|P1476 | SELECT ?work ?title WHERE { ?work wdt:P31/wdt:P279* wd:Q838948; wdt:P1476 ?title. FILTER(REGEX(STR(?title), "^(\\p{L})\\w+(?:\\W+\\1\\w+){2,}$", "i")). } ORDER BY STR(?title) | ||
| Distribution of public art by place | P136|Q557141|P131 | SELECT ?place ?placeLabel (COUNT(*) AS ?count) WHERE { ?item wdt:P136 wd:Q557141 . ?item wdt:P131 ?place . SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . } } GROUP BY ?place ?placeLabel ORDER BY DESC(?count) ?placeLabel | ||
| Birthplaces of Europeana280 artists | P31|P279|Q838948|P608|Q20980830|P170|P19|P625 | #defaultView:Map SELECT ?creator ?creatorLabel ?placebirthLabel ?geoloc where { ?item wdt:P31/wdt:P279* wd:Q838948 . # œuvre d’art et ss-classe ?item wdt:P608 wd:Q20980830 . # du projet Europeana 280 ?item wdt:P170 ?creator . # créateur ?creator wdt:P19 ?placebirth . # lieu de naissance ?placebirth wdt:P625 ?geoloc . #coordonnées géo SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,es,en" . } } | ||
| Female artists | P31|Q5|P21|Q6581072|P106|P279|Q483501 | SELECT DISTINCT ?women ?women_label ?women_description WHERE { ?women wdt:P31 wd:Q5 . ?women wdt:P21 wd:Q6581072 . ?women wdt:P106/wdt:P279* wd:Q483501 . # artists OPTIONAL {?women rdfs:label ?women_label FILTER (LANG(?women_label) = "en")}. OPTIONAL {?women schema:description ?women_description FILTER (LANG(?women_description) = "en")}. } LIMIT 500 | ||
| Common phrases | P31|Q15841920 | SELECT ?q ?qLabel WHERE { ?q wdt:P31 wd:Q15841920. SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } } | ||
| Padua University Rectors by dates | P106|P106|Q212071|P642|Q193510|P580|P582 | SELECT ?rettore ?rettoreLabel ?starttime ?endtime WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } ?rettore p:P106 [ ps:P106 wd:Q212071; # is a Rector pq:P642 wd:Q193510; # of Padua Univerity pq:P580 ?starttime; pq:P582 ?endtime ]. } ORDER BY ?starttime | ||
| Top 100 podcasts by number of statements | P31|Q24634210 | # Top 100 podcasts by number of statements SELECT ?item ?itemLabel ?statements WHERE { ?item wdt:P31 wd:Q24634210. # Instance of: podcast ?item wikibase:statements ?statements. # Number of statements SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } ORDER BY desc(?statements) # Sort by number of statements LIMIT 100 # Only the top 100 items | ||
| Food & Drink | ||||
| German breweries | P31|P279|Q131734|P17|Q183|P625 | #Locations of breweries in Germany #defaultView:Map SELECT ?breweryLabel ?breweryDescription ?coord WHERE { ?brewery wdt:P31/wdt:P279* wd:Q131734 ; wdt:P17 wd:Q183 ; wdt:P625 ?coord . SERVICE wikibase:label { bd:serviceParam wikibase:language "en, de" . } } | ||
| Sandwiches | P279|Q28803|P18 | #defaultView:ImageGrid SELECT ?item ?itemLabel ?_image WHERE { ?item wdt:P279 wd:Q28803. SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } OPTIONAL { ?item wdt:P18 ?_image. } } LIMIT 100 | ||
| Sandwich ingredients | P31|P279|Q28803|P527|P279|Q7802 | SELECT ?sandwich ?ingredient ?sandwichLabel ?ingredientLabel WHERE { ?sandwich wdt:P31?/wdt:P279* wd:Q28803; wdt:P527 ?ingredient. MINUS { ?ingredient wdt:P279* wd:Q7802. } SERVICE wikibase:label { bd:serviceParam wikibase:language "en", "fr". } } ORDER BY UCASE(STR(?sandwichLabel)) | ||
| Sports | ||||
| Mushers with neither a ranking in a race nor a reason for not finishing it | P31|P279|Q1968664|P31|P641|Q1968664|P710|P710|P1352|P793 | SELECT DISTINCT ?race ?raceLabel ?musherLabel WHERE { { ?race wdt:P31/wdt:P279* wd:Q1968664 . } UNION { ?race wdt:P31/wdt:P641* wd:Q1968664 . } ?race p:P710 ?musherS . #here we have a full statement, not a value ?musherS ps:P710 ?musher . #here we get the value FILTER NOT EXISTS { ?musherS pq:P1352 ?rank } FILTER NOT EXISTS { ?musherS pq:P793 ?event } SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en" } } ORDER BY ?raceLabel | ||
| What is the relation between Terrell Buckley and Miami Dolphins? | Q5571382|Q223243 | SELECT ?l WHERE { wd:Q5571382 ?p wd:Q223243 . ?property ?ref ?p . ?property rdf:type wikibase:Property . ?property rdfs:label ?l FILTER (lang(?l) = "en") } | ||
| The awards received by Cristiano Ronaldo by year | Q11571|P166|P166|P585 | SELECT ?entity ?desc (year(?date) as ?year) { wd:Q11571 p:P166 [ps:P166 ?entity ; pq:P585 ?date ] OPTIONAL { ?entity rdfs:label ?desc FILTER((LANG(?desc)) = "en") } } ORDER BY ?year | ||
| Figshare citations | ||||
| Wikidata statements with a reference to data in Figshare | P356 | SELECT ?doi (count(?doi) as ?counts) WHERE { ?statement prov:wasDerivedFrom ?ref . ?ref pr:P356 ?doi . FILTER (CONTAINS(lcase(?doi), "figshare")) } GROUP BY ?doi ORDER BY DESC(?counts) | ||
| Wikidata statement with a reference to data in Figshare of which a Wikicite item exists | P356|P356|P356 | SELECT DISTINCT ?wikiciteLabel ?doi WHERE { ?wikicite p:P356/ps:P356 ?doi . ?statement prov:wasDerivedFrom ?ref . ?ref pr:P356 ?doi . FILTER (CONTAINS(lcase(?doi), "figshare")) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } | ||
| Wikidata statements with a reference to a Figshare DOI (Q28061352) | Q28061352 | SELECT DISTiNCT ?item ?itemLabel WHERE { ?item ?p ?statement. ?statement prov:wasDerivedFrom ?ref . ?ref ?prop wd:Q28061352 . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } } | ||
| Zika corpus | ||||
| Scholarly articles with "Zika" in the item label | P31|Q13442814|P698|P356 | SELECT ?item ?itemLabel ?DOI ?PMID WITH { SELECT * WHERE { BIND ("zika" AS ?searchfor) } } AS %p WITH { SELECT ?item WHERE { INCLUDE %p BIND (CONCAT("haswbstatement:P31=Q13442814 ", ?searchfor) AS ?searchstr) SERVICE wikibase:mwapi { bd:serviceParam wikibase:endpoint "www.wikidata.org" . bd:serviceParam wikibase:api "Generator" . bd:serviceParam mwapi:generator "search" . bd:serviceParam mwapi:gsrsearch ?searchstr . bd:serviceParam mwapi:gsrlimit "max" . bd:serviceParam mwapi:gsrnamespace "0" . bd:serviceParam mwapi:gsrprop "" . ?item wikibase:apiOutputItem mwapi:title . } } } AS %i WHERE { INCLUDE %i INCLUDE %p ?item rdfs:label ?itemLabel . FILTER (LANG(?itemLabel)="en") FILTER(CONTAINS(LCASE(?itemLabel), ?searchfor)) OPTIONAL { ?item wdt:P698 ?PMID. } OPTIONAL { ?item wdt:P356 ?DOI. } } | ||
| Scientific articles that have subject Zika virus or fever and that are used as a reference in another item | P31|Q13442814|P921|Q202864|P921|Q8071861 | SELECT ?item ?itemLabel ?reference ?referenceType WHERE { ?item wdt:P31 wd:Q13442814 #Scientific article { ?item wdt:P921 wd:Q202864 } #Zika virus UNION { ?item wdt:P921 wd:Q8071861 } #Zika fever ?reference ?referenceType ?item #find references to item having any property and store reference type SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } } | ||
| CIViC Corpus | ||||
| Get the CIViC citation corpus | P3354|P3355|P3356|P3357|P3358|P3359|P3329|P3329|P248|P698 | SELECT DISTINCT ?pmid ?citation ?citationLabel WHERE { VALUES ?predictor {p:P3354 p:P3355 p:P3356 p:P3357 p:P3358 p:P3359 } ?item p:P3329 ?civicId ; ?predictor ?predictor_value . ?civicId ps:P3329 ?id . ?predictor_value prov:wasDerivedFrom ?reference . ?reference pr:P248 ?citation . ?citation wdt:P698 ?pmid ; SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } } | ||
| Biological pathway citation corpora | ||||
| Get the Pathways citation corpus | P3937|P2410|P2860 | SELECT ?id ?item ?itemLabel ?referenceLabel WHERE { {?item wdt:P3937 ?id } UNION {?item wdt:P2410 ?id } ?item wdt:P2860 ?reference . SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } } | ||
| Get the Wikipathways citation corpus | P2410|P2860 | SELECT ?wpid ?item ?itemLabel ?referenceLabel WHERE { ?item wdt:P2410 ?wpid ; wdt:P2860 ?reference ; SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } } | ||
| Get the Reactome citation corups | P3937|P2860 | SELECT ?reactome_id ?item ?itemLabel ?referenceLabel WHERE { ?item wdt:P3937 ?reactome_id ; wdt:P2860 ?reference ; SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } } | ||
| Queries for bibliographic citation (Wikicite) | ||||
| Suriname citation corpora | P31|Q13442814|P698 | SELECT ?item ?itemLabel ?_PubMed_ID WHERE { ?item wdt:P31 wd:Q13442814 ; rdfs:label ?itemLabel . FILTER(CONTAINS(LCASE(?itemLabel), "suriname")) OPTIONAL { ?item wdt:P698 ?_PubMed_ID. } } | ||
| English common names and information for animals given their scientific names | P225|P1843|P2043|P2250|P2048|P2050|P2067|P642|Q78101716|P2067 | # Given the scientific name for a list of animals, it will return all the # English common names, their length, life expectency, height, wing span and mass # Note: There is more information on these specific animals. Unfortunately, a lot of animals on WikiData have missing information (e.g. no life expectancy or mass) SELECT DISTINCT ?item ?scientific_name ?common_name ?length ?life_expectency ?height ?wing_span ?mass WHERE { ?item wdt:P225 ?scientific_name; wdt:P1843 ?common_name. OPTIONAL { ?item wdt:P2043 ?length. } OPTIONAL { ?item wdt:P2250 ?life_expectency. } OPTIONAL { ?item wdt:P2048 ?height. } OPTIONAL { ?item wdt:P2050 ?wing_span. } # Adult mass only. Excludes birth mass OPTIONAL { ?item p:P2067 ?mass_statement_node. ?mass_statement_node pq:P642 wd:Q78101716; ps:P2067 ?mass. } # Only return common names in English FILTER(LANGMATCHES(LANG(?common_name), "en")) # List of animals. All lowercase to avoid capitalisation issues FILTER(lcase(str(?scientific_name)) IN ( "mustela erminea", "aquila adalberti", "vespula germanica", "accipiter nisus", "buteo buteo" )) SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } | ||
| External identifiers | ||||
| Swedish municipalities which changed their municipality identifier at some point | P525|P525 | #title:Swedish municipalities which changed their municipality identifier at some point #author:Salgo60 2021-09-11 SELECT DISTINCT ?item ?itemLabel ?kkod1 ?kkod2 ?svwp_artikel WHERE { ?item wdt:P525 ?kkod1 . ?item wdt:P525 ?kkod2 . FILTER ( ?kkod1<?kkod2 ) SERVICE wikibase:label { bd:serviceParam wikibase:language "sv". } OPTIONAL { ?svwp_artikel schema:about ?item; schema:isPartOf <https://sv.wikipedia.org/> } } ORDER BY ?itemLabel | ||
You can create queries without having to write SPARQL in the Query Builder