User:MartinPoulter/queries/collections
See also Wikidata:WikiProject_Heritage_institutions/Tools_&_tasks#Sample_Queries
How many collections are represented in the Sum of all Paintings dataset?[edit]
SELECT (COUNT(DISTINCT ?coll) AS ?count) WHERE {
?obj wdt:P31/wdt:P279* wd:Q3305213. ?obj wdt:P195 ?coll FILTER (!CONTAINS(STR(?coll), "well-known"))
}
Self-portraits of women: Image grid[edit]
#defaultView:ImageGrid
SELECT ?p ?pLabel ?aLabel (SAMPLE(?image) AS ?img) (YEAR(?date) as ?year) WHERE {
?p wdt:P31 wd:Q3305213; wdt:P170 ?a; wdt:P136 wd:Q192110 ; wdt:P18 ?image. ?a wdt:P21 wd:Q6581072
OPTIONAL {?p wdt:P571 ?date}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?p ?pLabel ?aLabel ?date
ORDER BY ?year
Art museums (global map)[edit]
#defaultView:Map{"hide": "?coords"}
SELECT DISTINCT ?museum ?museumLabel (SAMPLE(?coords) AS ?coords) (SAMPLE(?image) AS ?image) ?url WHERE {
?museum wdt:P31 wd:Q207694 . ?museum wdt:P625 ?coords
OPTIONAL {?museum wdt:P18 ?image}
OPTIONAL {?museum wdt:P856 ?url}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?museum rdfs:label ?museumLabel }
} GROUP BY ?museum ?museumLabel ?url
How many Wikidata things have the "in collection" property[edit]
The following query uses these:
- Properties: collection (P195) , end time (P582)
SELECT (COUNT(?obj) AS ?count) WHERE { ?obj p:P195 ?s. ?s ps:P195 ?collection. MINUS { ?s pq:P582 [] } }
- As of 25 November 2017: 314,221. An extra 1,150 if we allow relations that have an end date.
- As of 2 October 2017: 464,608.
- As of 29 August 2019: 1,092,686.
Collection sizes[edit]
The following query uses these:
- Properties: part of (P361) , instance of (P31) , country (P17) , collection or exhibition size (P1436) , applies to part (P518)
SELECT ?collection ?collectionLabel ?partofLabel ?countryLabel ?size ?partLabel WHERE { ?collection p:P1436 ?s. ?s ps:P1436 ?size OPTIONAL {?s pq:P518 ?part} OPTIONAL {?collection wdt:P361 ?partof . # Get the organisation the collection is part of MINUS{ ?partof wdt:P31 wd:Q13406463 } } # but not Wikimedia list articles OPTIONAL {?collection wdt:P17 ?country} SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } FILTER (?size > 100) } ORDER BY DESC(?size)
Oldest institution in each country that now acts as a museum[edit]
SELECT DISTINCT ?countryLabel ?museum ?museumLabel (YEAR(?earliest) as ?year) WHERE {
{ SELECT ?country (MIN(?inception) as ?earliest) WHERE {
?museum wdt:P31/wdt:P279? wd:Q33506 ; wdt:P131?/wdt:P17 ?country; wdt:P571 ?inception
} GROUP BY ?country }
?museum wdt:P31/wdt:P279? wd:Q33506 ; wdt:P131?/wdt:P17 ?country; wdt:P571 ?earliest.
MINUS {?country wdt:P576 []} # Exclude abolished countries like the Austrian Empire
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY ?countryLabel
Number of items in Wikidata with each collection property[edit]
The following query uses these:
- Properties: part of (P361) , collection (P195) , end time (P582)
SELECT (COUNT(?obj) AS ?count) ?collection ?collectionLabel ?partofLabel WHERE { ?obj p:P195 ?s. ?s ps:P195 ?collection. MINUS { ?s pq:P582 [] } OPTIONAL { ?collection wdt:P361 ?partof } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } } GROUP BY ?collection ?collectionLabel ?partofLabel ORDER BY DESC(?count) LIMIT 100
Most common properties of objects in a given collection[edit]
The following query uses these:
- Items: Tate (Q430682)
- Properties: collection (P195) , depicts (P180) , creator (P170) , time period (P2348) , movement (P135) , genre (P136) , inspired by (P941) , made from material (P186) , location of creation (P1071)
SELECT (COUNT(?obj1) AS ?count) ?propertyLabel ?thingLabel ?thing WHERE { ?obj1 wdt:P195 wd:Q430682. #Tate VALUES ?prop1 {wdt:P180 wdt:P170 wdt:P2348 wdt:P135 wdt:P136 wdt:P941 wdt:P186 wdt:P1071} ?obj1 ?prop1 ?thing. ?property ?ref ?prop1 ; rdf:type wikibase:Property . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } } GROUP BY ?propertyLabel ?thingLabel ?thing ORDER BY DESC(?count) LIMIT 100
Properties that items from two collections have in common[edit]
The following query uses these:
- Properties: collection (P195) , depicts (P180) , creator (P170) , time period (P2348) , movement (P135) , genre (P136) , inspired by (P941) , made from material (P186) , location of creation (P1071)
#defaultView:ScatterChart SELECT (?count1 AS ?in_Tate) (?count2 AS ?in_Smithsonian) (CONCAT(?propertyLabel,": ",?thingLabel)AS ?attribute) WHERE { { SELECT (COUNT(?obj1) AS ?count1) ?property ?thing WHERE { ?obj1 wdt:P195 wd:Q430682. #Tate VALUES ?prop1 {wdt:P180 wdt:P170 wdt:P2348 wdt:P135 wdt:P136 wdt:P941 wdt:P186 wdt:P1071} ?obj1 ?prop1 ?thing. ?property ?ref ?prop1 ; rdf:type wikibase:Property . } GROUP BY ?property ?thing } { SELECT (COUNT(?obj2) AS ?count2) ?property ?thing WHERE { ?obj2 wdt:P195 wd:Q1192305. #Smithsonian VALUES ?prop1 {wdt:P180 wdt:P170 wdt:P2348 wdt:P135 wdt:P136 wdt:P941 wdt:P186 wdt:P1071} ?obj2 ?prop1 ?thing. ?property ?ref ?prop1 ; rdf:type wikibase:Property . } GROUP BY ?property ?thing } FILTER (?count2 >2 ) FILTER (?count1 >2 ) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?property rdfs:label ?propertyLabel .?thing rdfs:label ?thingLabel } }
Refined version of above that just focuses on artists in common[edit]
The following query uses these:
- Properties: collection (P195) , creator (P170)
#defaultView:ScatterChart SELECT (?count1 AS ?in_Tate) (?count2 AS ?in_NPG) ?artist WHERE { { SELECT (COUNT(?obj1) AS ?count1) ?creator WHERE { ?obj1 wdt:P195 wd:Q430682. #Tate ?obj1 wdt:P170 ?creator. } GROUP BY ?creator } { SELECT (COUNT(?obj2) AS ?count2) ?creator WHERE { ?obj2 wdt:P195 wd:Q238587. #National Portrait Gallery ?obj2 wdt:P170 ?creator. } GROUP BY ?creator } FILTER (?creator != wd:Q4233718) # exclude anonymous works SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?creator rdfs:label ?artist } }
Artists who died before the 19th century[edit]
SELECT DISTINCT ?artist ?artistLabel ?genderLabel ?countryLabel (year(?death) as ?deathyear) #?birthyear ?flyear
WHERE {
?artist wdt:P31 wd:Q5 ; wdt:P106/wdt:P279? wd:Q1028181 .
?artist wdt:P570 ?death FILTER(year(?death)<1800).
OPTIONAL{?artist wdt:P21 ?gender}
OPTIONAL{?artist wdt:P27 ?country}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY DESC(?deathyear)
Artists with no English Wikipedia article but an article in other languages[edit]
#title:People with a Benezit or Grove Art online link with sitelinks but no English Wikipedia article
SELECT DISTINCT ?artist ?artistLabel ?countryLabel ?links ?benezit_id ?grove_id WHERE {
{ ?artist wdt:P2843 ?benezit_id } UNION { ?artist wdt:P8406 ?grove_id }
?artist wikibase:sitelinks ?links FILTER (?links > 0).
?artist wdt:P31 wd:Q5.
?artist wdt:P27 ?country.
FILTER NOT EXISTS{?enwp schema:about ?artist; schema:inLanguage "en"}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY DESC(?links)
Paintings by Russian artists from around the time of the Russian Revolution[edit]
The following query uses these:
- Properties: instance of (P31) , creator (P170) , country of citizenship (P27) , image (P18) , inception (P571)
#title:Paintings by Russian artists from around the time of the Russian Revolution SELECT ?work ?workLabel ?artistLabel ?date ?datePrecision ?image WHERE { ?work wdt:P31 wd:Q3305213 # paintings ; wdt:P170 ?artist . ?artist wdt:P27 wd:Q34266. # artist's nationality: Russian Empire ?work p:P571/psv:P571 ?node . ?node wikibase:timeValue ?date ; # date of painting wikibase:timePrecision ?datePrecision # precision of date (e.g. day, month, year) BIND(YEAR(?date) as ?year) FILTER(?year > 1905) FILTER(?year < 1930) #specify date range FILTER (?datePrecision > 8) # known year .?work wdt:P18 ?image # only show art that Commons has an image for SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,ru,et,de,fr". } }
This query as a Histropedia timeline
Landscape art that is taller than it is wide[edit]
#defaultView:ImageGrid
#title:Landscape art that is taller than it is wide
SELECT ?i ?iLabel ?iDescription (SAMPLE(?collLabel) AS ?collection) (SAMPLE(?img) AS ?image) WHERE {
?i wdt:P31 wd:Q3305213.
?i wdt:P136 wd:Q191163 .
?i wdt:P2048 ?height.
?i wdt:P2049 ?width.
FILTER (?height > ?width)
?i wdt:P18 ?img.
?i wdt:P195 ?coll.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?coll rdfs:label ?collLabel . ?i rdfs:label ?iLabel .
?i schema:description ?iDescription }
} GROUP BY ?i ?iLabel ?iDescription
Random selection of images from a collection[edit]
In theory, results should change each day.
#defaultView:ImageGrid
SELECT ?item ?itemLabel (SAMPLE(?img) AS ?image) WHERE {
?item wdt:P195 wd:Q109893034 .
?item wdt:P18 ?img
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
BIND(SHA512(CONCAT(STR(RAND()), STR(NOW()), STR(?item))) AS ?random)
} GROUP BY ?item ?itemLabel
ORDER BY ?random
LIMIT 20
Items of type "oil painting" that don't include oil paint as a material[edit]
SELECT ?item ?itemLabel ?itemDescription ?collectionLabel WHERE {
?item wdt:P31 wd:Q56676227
MINUS {?item wdt:P186 wd:Q296955}
OPTIONAL {?item wdt:P195 ?collection}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
3D scan files of items from collections[edit]
SELECT ?item ?itemLabel ?itemDescription ?model WHERE {
?item wdt:P4896 ?model; wdt:P195 [].
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,fr" }
} ORDER BY ?itemLabel
Depictions in common between Ashmolean Museum and Cleveland Museum of Art[edit]
SELECT ?depicted ?depictedLabel ?ashcount ?ashexample ?ashexampleLabel ?clevcount ?clevexample ?clevexampleLabel WHERE {
{SELECT ?depicted (Sample(?itemash) AS ?ashexample) (COUNT(DISTINCT ?itemash) AS ?ashcount) (sample(?itemclev) as ?clevexample) (COUNT(DISTINCT ?itemclev) AS ?clevcount) WHERE {
?itemclev wdt:P195 wd:Q657415; wdt:P180 ?depicted.
?itemash wdt:P195 wd:Q636400 ; wdt:P180 ?depicted.
} GROUP BY ?depicted }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY DESC(?ashcount + ?clevcount)
Cleveland Museum of Art items with no "depicts" property[edit]
#defaultView:ImageGrid
SELECT DISTINCT ?item ?itemLabel ?id ?img WHERE {
?item p:P217 [ps:P217 ?id; pq:P195 wd:Q657415] .
?item wdt:P5008 wd:Q60729883 .
OPTIONAL { ?item wdt:P18 ?img } .
MINUS { ?item wdt:P180 [] }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Manuscripts[edit]
Image gallery of notable manuscripts (which have an image on Wikimedia Commons)[edit]
The following query uses these:
- Properties: instance of (P31) , subclass of (P279) , image (P18)
Features: ImageGrid (Q24515278)
#defaultView:ImageGrid
SELECT ?link (MIN(?image) AS ?img) ?qLabel (COUNT(DISTINCT ?sitelink) AS ?linkcount) WHERE {
?q (wdt:P31/wdt:P279*) wd:Q87167.
FILTER (?q != wd:Q145780) # Exclude Dead Sea Scrolls: too broad
?sitelink schema:about ?q.
?q wdt:P18 ?image.
BIND(URI(CONCAT("http://example.org/test/manuscripts/index.php?q=manuscript/",SUBSTR(STR(?q),32))) AS ?link)
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?q rdfs:label ?qLabel.
}
}
GROUP BY ?link ?qLabel
ORDER BY DESC(?linkcount)
LIMIT 100
The most notable manuscripts and their collections[edit]
The following query uses these:
- Properties: instance of (P31) , subclass of (P279) , language of work or name (P407) , collection (P195) , end time (P582)
SELECT ?q ?qLabel (GROUP_CONCAT(DISTINCT ?collectionLabel; separator="; ") AS ?where) ?enwp (GROUP_CONCAT(DISTINCT ?langLabel; separator=", ") AS ?languages) ?linkcount WHERE { {SELECT ?q (COUNT(?sitelink) AS ?linkcount) WHERE { ?q (wdt:P31/wdt:P279*) wd:Q87167. ?sitelink schema:about ?q } GROUP BY ?q } ?q p:P195 ?s. ?s ps:P195 ?collection . MINUS {?s pq:P582 []}. MINUS {?s ps:P195 wd:Q1322278 } OPTIONAL{ ?q wdt:P407 ?lang } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?q rdfs:label ?qLabel. ?collection rdfs:label ?collectionLabel . ?lang rdfs:label ?langLabel } OPTIONAL{?enwp schema:about ?q ; schema:isPartOf <https://en.wikipedia.org/> } # other props: inventory number; part of ; full work (P953); Commons cat; described at (P973) } GROUP BY ?q ?qLabel ?enwp ?linkcount ORDER BY DESC(?linkcount)
The most notable manuscripts available via IIIF, with IIIF links[edit]
SELECT ?q ?qLabel (GROUP_CONCAT(DISTINCT ?collectionLabel; separator="; ") AS ?where)
(URI(CONCAT('https://tools.wmflabs.org/mirador/?manifest=', STR(?iiif))) AS ?iiiflink)
WHERE {
?q (wdt:P31/wdt:P279*) wd:Q87167; wdt:P6108 ?iiif; wikibase:sitelinks ?sitecount FILTER(?sitecount > 0)
?q p:P195 ?s. ?s ps:P195 ?collection . MINUS {?s pq:P582 []}.
MINUS {?s ps:P195 wd:Q1322278 }
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?q rdfs:label ?qLabel. ?collection rdfs:label ?collectionLabel
}
}
GROUP BY ?q ?qLabel ?iiif ?sitecount
ORDER BY DESC(?sitecount)
Notable manuscripts and their collections (full query)[edit]
The following query uses these:
- Properties: instance of (P31) , subclass of (P279) , image (P18) , language of work or name (P407) , collection (P195) , end time (P582) , inventory number (P217)
SELECT ?q ?qLabel (GROUP_CONCAT(DISTINCT ?collplusinv; separator=" !!! ") AS ?where) (GROUP_CONCAT(DISTINCT ?lang; separator=" ") AS ?languages) ?linkcount (SAMPLE(?image) AS ?image) WHERE { {SELECT ?q (COUNT(?sitelink) AS ?linkcount) WHERE { ?q (wdt:P31/wdt:P279*) wd:Q87167. OPTIONAL {?sitelink schema:about ?q} } GROUP BY ?q } ?q p:P195 ?s. ?s ps:P195 ?collection . MINUS {?s pq:P582 []}. MINUS {?s ps:P195 wd:Q1322278 } OPTIONAL{ ?s pq:P217 ?inventory} OPTIONAL{ ?q wdt:P18 ?image } BIND( IF(BOUND(?inventory), CONCAT(STR(?collection)," ",?inventory), STR(?collection)) AS ?collplusinv). SERVICE wikibase:label { bd:serviceParam wikibase:language "en,fr,it,de,es,ru,bg,ca,cs,nl,zh,ja". ?q rdfs:label ?qLabel. } OPTIONAL{ ?q wdt:P407 ?lang } # other props: part of, exemplar } GROUP BY ?q ?qLabel ?linkcount ORDER BY DESC(?linkcount)
Collections of manuscripts[edit]
The following query uses these:
- Properties: instance of (P31) , subclass of (P279) , official website (P856) , collection (P195) , end time (P582)
SELECT ?collection ?l (GROUP_CONCAT(DISTINCT ?officialweb) AS ?webs) (COUNT(DISTINCT ?q) AS ?mcount) WHERE { ?q (wdt:P31/wdt:P279*) wd:Q87167. ?q p:P195 ?s. ?s ps:P195 ?collection. MINUS {?s pq:P582 []}. MINUS { ?s ps:P195 wd:Q1322278 } OPTIONAL{ ?collection wdt:P856 ?officialweb } SERVICE wikibase:label { bd:serviceParam wikibase:language "en". ?collection rdfs:label ?l } } GROUP BY ?collection ?l ORDER BY UCASE(?l)
Manuscripts (and some other things) in the Matenadaran collection[edit]
#title:Things in the Matenadaran collection
SELECT ?item ?itemLabel (GROUP_CONCAT(?typeLabel; separator=", ") AS ?thing) (YEAR(?date) AS ?year) ?image WHERE {
?item wdt:P195 wd:Q1322278
OPTIONAL {?item wdt:P31 ?type}
OPTIONAL {?item wdt:P571 ?date}
OPTIONAL {?item wdt:P18 ?image}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,hy".
?item rdfs:label ?itemLabel. ?type rdfs:label ?typeLabel}
} GROUP BY ?item ?itemLabel ?date ?image
ORDER BY DESC(?image) ?year
Languages of manuscripts[edit]
The following query uses these:
- Properties: instance of (P31) , subclass of (P279) , language of work or name (P407) , collection (P195) , end time (P582)
SELECT ?lang ?langLabel ?langDescription (COUNT(DISTINCT ?q) AS ?mcount) WHERE { ?q (wdt:P31/wdt:P279*) wd:Q87167. ?q p:P195 ?s. ?s ps:P195 ?collection . MINUS {?s pq:P582 []}. MINUS { ?s ps:P195 wd:Q1322278 } ?q wdt:P407 ?lang SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } } GROUP BY ?lang ?langLabel ?langDescription ORDER BY UCASE(?langLabel)
Top ten languages by number of manuscripts[edit]
SELECT (SUBSTR(STR(?lang),32) AS ?wd) (COUNT(DISTINCT ?q) AS ?mcount)
WHERE {
?q (wdt:P31/wdt:P279*) wd:Q87167.
?q p:P195 ?s. ?s ps:P195 ?collection . MINUS {?s pq:P582 []}.
MINUS { ?s ps:P195 wd:Q1322278 }
?q wdt:P407 ?lang
}
GROUP BY ?lang
ORDER BY DESC(?mcount)
LIMIT 10
Materials used in manuscripts[edit]
The following query uses these:
- Properties: instance of (P31) , subclass of (P279) , made from material (P186) , collection (P195) , end time (P582)
SELECT ?material ?l ?d (COUNT(DISTINCT ?q) AS ?mcount) WHERE { ?q (wdt:P31/wdt:P279*) wd:Q87167. ?q p:P195 ?s. ?s ps:P195 ?collection . MINUS {?s pq:P582 []}. MINUS { ?s ps:P195 wd:Q1322278 } ?q wdt:P186 ?material SERVICE wikibase:label { bd:serviceParam wikibase:language "en". ?material rdfs:label ?l; schema:description ?d } } GROUP BY ?material ?l ?d
Map of manuscript collections[edit]
The following query uses these:
- Items: manuscript (Q87167)
- Properties: instance of (P31) , subclass of (P279) , collection (P195) , coordinate location (P625)
Features: map (Q24515275)
#defaultView:Map
SELECT ?link ?collectionLabel ?coords
WHERE {
{SELECT DISTINCT ?collection ?coords WHERE {?q (wdt:P31/wdt:P279*) wd:Q87167;
wdt:P195 ?collection .
?collection wdt:P625 ?coords.
} }
BIND (URI(CONCAT("/collection/",SUBSTR(STR(?collection),32))) AS ?link).
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
Manuscripts lacking a collection[edit]
The following query uses these:
- Items: manuscript (Q87167)
- Properties: instance of (P31) , subclass of (P279) , collection (P195)
SELECT DISTINCT ?q ?qLabel ?qDescription ?enwp WHERE { ?q (wdt:P31/wdt:P279*) wd:Q87167. MINUS { ?q wdt:P195 []} SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } OPTIONAL{?enwp schema:about ?q ; schema:isPartOf <https://en.wikipedia.org/> } } ORDER BY DESC(?qLabel)
Objects with "instance of papyrus" (which shouldn't be the case)[edit]
SELECT * WHERE {
?item wdt:P31 wd:Q125576
}
Bodleian things and their online digitizations[edit]
SELECT ?thing ?thingLabel ?inv ?url WHERE {
VALUES ?in {wd:Q82133 wd:Q2210813} # Bodleian and Sackler
?thing p:P195 ?s; wdt:P953 ?url FILTER(CONTAINS(STR(?url),"ox.ac.uk")).
?s ps:P195 ?in
OPTIONAL { ?s pq:P217 ?inv }
MINUS {?thing wdt:P1433 []}
MINUS {?thing wdt:P361 []}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY ?thingLabel
Bodleian items with no image and no Commons category[edit]
SELECT ?item ?itemLabel ?url WHERE {
VALUES ?in {wd:Q82133 wd:Q2210813} # Bodleian and Sackler
?item wdt:P195 ?in; wdt:P953 ?url
MINUS {?item wdt:P18 []}
MINUS {?item wdt:P373 []}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Manuscripts of the Quran[edit]
SELECT DISTINCT ?item ?itemLabel ?collectionLabel ?inventory ?url ?image WHERE {
{?item wdt:P1574 wd:Q428 } UNION { ?item wdt:P1574/wdt:P31 wd:Q234262 } # Exemplar of Quran or of an individual Sura
?item p:P217 [ps:P217 ?inventory; pq:P195 ?collection]
OPTIONAL {?item wdt:P973 ?url}
OPTIONAL {?item wdt:P18 ?image}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
} ORDER BY ?collectionLabel ?inventory
Timeline of Shahnameh manuscripts[edit]
#title:Shahnameh manuscripts
SELECT DISTINCT ?item ?itemLabel ?placeLabel ?pubdate ?pubdatePrecision ?url ?img WHERE {
?item wdt:P1574 wd:Q8279.
?item p:P571/psv:P571 ?pubdateStatementNode.
?pubdateStatementNode wikibase:timeValue ?pubdate ;
wikibase:timePrecision ?pubdatePrecision # get precision of the creation date
OPTIONAL {?item wdt:P1071 ?place}
OPTIONAL {?item wdt:P973 ?url}
OPTIONAL {?item wdt:P18 ?img}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
This timeline in HistropediaJS
Ashmolean Museum[edit]
Things in the collection of the Ashmolean museum[edit]
SELECT ?type ?typeLabel (COUNT(?item) AS ?count) WHERE {
?item wdt:P195 wd:Q636400;
wdt:P31 ?type.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?type ?typeLabel ORDER BY DESC(?count)
Creators: comparison of Ashmolean items versus items in other GLAMs[edit]
SELECT DISTINCT ?creator ?creatorLabel ?creatorDescription ?enwp ?ash_items (COUNT(?other) as ?other) WHERE {
{ SELECT ?creator ?enwp (COUNT(?item) AS ?ash_items) WHERE {
?item wdt:P195 wd:Q636400; # collection: Ashmolean
wdt:P170 ?creator FILTER (?creator != wd:Q4233718) # Exclude anonymous
OPTIONAL { ?enwp schema:about ?creator; schema:isPartOf <https://en.wikipedia.org/> }
} GROUP BY ?creator ?enwp
}
?other wdt:P170 ?creator MINUS {?other wdt:P195 wd:Q636400} # objects by same creator but not in Ashmolean
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
} GROUP BY ?creator ?creatorLabel ?creatorDescription ?enwp ?ash_items
ORDER BY DESC(?ash_items) DESC(?other)
People associated with Ashmolean items[edit]
SELECT ?person ?personLabel ?personDescription (SAMPLE(?image) AS ?img) (COUNT(?item) AS ?count) (YEAR(SAMPLE(?time)) AS ?year) WHERE {
?item wdt:P195 wd:Q636400; wdt:P973 ?url FILTER (STRSTARTS(STR(?url),"http://jameelcentre") ).
?item ?prop ?person.
?person wdt:P31 wd:Q5.
OPTIONAL {?person wdt:P18 ?image}
OPTIONAL {?person wdt:P569 ?birth}
OPTIONAL {?person wdt:P1317 ?fl}
OPTIONAL {?person wdt:P2348/wdt:P580 ?erastart}
BIND(IF(BOUND(?birth), ?birth, IF(BOUND(?fl), ?fl, ?erastart) ) AS ?time).
SERVICE wikibase:label {bd:serviceParam wikibase:language "en"}
} GROUP BY ?person ?personLabel ?personDescription ORDER BY ?year
Artists in the Ashmolean with entries in Benezit Dictionary of Artists[edit]
SELECT ?artist ?artistLabel (URI(CONCAT("http://oxfordindex.oup.com/view/10.1093/benz/9780199773787.article.",?benezit)) AS ?benezit_link) (COUNT(?work) AS ?count) WHERE {
?work wdt:P195 wd:Q636400; wdt:P170 ?artist FILTER (!ISBLANK(?artist)) .
?artist wdt:P2843 ?benezit
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?artist ?artistLabel ?benezit
ORDER BY ?artistLabel
timeline of Ashmolean artists with links to Benezit
Getty Union List of Artist Names links for Ashmolean artists[edit]
SELECT ?artist ?artistLabel (URI(CONCAT("http://vocab.getty.edu/page/ulan/",?getty_id)) AS ?getty_link) (COUNT(?work) AS ?count) WHERE {
?work wdt:P195 wd:Q636400; wdt:P170 ?artist FILTER (!ISBLANK(?artist)) .
?artist wdt:P245 ?getty_id
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?artist ?artistLabel ?getty_id
ORDER BY ?artistLabel
Languages of Wikipedia articles about Ashmolean artists[edit]
SELECT ?languageLabel (COUNT(?sitelink) AS ?count) WITH { SELECT DISTINCT ?artist { ?work wdt:P195 wd:Q636400; wdt:P170 ?artist FILTER (!ISBLANK(?artist)) } } AS %artists WHERE {
INCLUDE %artists.
?sitelink schema:about ?artist; schema:inLanguage ?lang FILTER (CONTAINS(STR(?sitelink), ".wikipedia.org"))
?language wdt:P218 ?lang.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?languageLabel
ORDER BY DESC(?count)
Things depicted (but not places)[edit]
SELECT ?person ?personLabel ?personDescription (SAMPLE(?image) AS ?img) (COUNT(?item) AS ?count) WHERE {
?item wdt:P195 wd:Q636400; wdt:P973 ?url FILTER (STRSTARTS(STR(?url),"http://jameelcentre") ).
?item wdt:P180 ?person.
MINUS {?person wdt:P625 []}
OPTIONAL {?person wdt:P18 ?image}
SERVICE wikibase:label {bd:serviceParam wikibase:language "en". }
} GROUP BY ?person ?personLabel ?personDescription ORDER BY UCASE(?personLabel)
Locations associated with Ashmolean items[edit]
#defaultView:Map{"hide": ["?latlong", "?layer"]}
SELECT (URI(CONCAT("http://glam-discovery.bodleian.ox.ac.uk/location/",SUBSTR(STR(?place),32) ) ) as ?link) ?placeX ?placeLabel ?layer (SAMPLE(?coords) AS ?latlong)
WHERE {
?item wdt:P195 wd:Q636400;
wdt:P973 ?url FILTER (STRSTARTS(STR(?url),"http://jameelcentre") ).
VALUES ?property {wd:P180 wd:P1071} # wdt:P921 wdt:P189 wdt:P138
?property wikibase:directClaim ?prop.
?item ?prop ?place.
?place wdt:P625 ?coords.
SERVICE wikibase:label {bd:serviceParam wikibase:language "en".
?property rdfs:label ?layer. ?place rdfs:label ?placeLabel; schema:description ?placeX}
} GROUP BY ?place ?placeLabel ?placeX ?layer
Ashmolean items associated with a given person or location[edit]
SELECT ?prop ?item ?itemLabel ?inventory (GROUP_CONCAT(?typeLabel; separator=", ") AS ?types) ?from (YEAR(?latest) AS ?to) ?precision WHERE {
?item p:P195 [ps:P195 wd:Q636400; pq:P217 ?inventory].
?item ?prop wd:Q48129717; wdt:P31 ?type.
OPTIONAL {?item p:P571 [pq:P1319 ?earliest; pq:P1326 ?latest] }
OPTIONAL {?item p:P571/psv:P571 [ wikibase:timePrecision ?precision; wikibase:timeValue ?year ] }
BIND(IF (BOUND(?earliest), YEAR(?earliest), YEAR(?year)) AS ?from)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
?item rdfs:label ?itemLabel. ?type rdfs:label ?typeLabel }
} GROUP BY ?prop ?item ?itemLabel ?inventory ?from ?latest ?precision
ORDER BY DESC(?prop) ?from ?to
Ashmolean people associated with a given location or era[edit]
SELECT ?person ?personLabel ?personDescription (SAMPLE(?image) AS ?img) (YEAR(SAMPLE(?time)) AS ?year) WHERE {
?item wdt:P195 wd:Q636400; wdt:P973 ?url FILTER (STRSTARTS(STR(?url), "http://jameelcentre") ).
?item ?prop ?person.
?person wdt:P31 wd:Q5.
?person ?prop2 wd:Q1490.
OPTIONAL {?person wdt:P18 ?image}
OPTIONAL {?person wdt:P569 ?birth}
OPTIONAL {?person wdt:P1317 ?fl}
OPTIONAL {?person wdt:P2348/wdt:P580 ?erastart}
BIND(IF(BOUND(?birth), ?birth, IF(BOUND(?fl), ?fl, ?erastart) ) AS ?time).
SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"}
} GROUP BY ?person ?personLabel ?personDescription ORDER BY ?year
Locations associated with a given person[edit]
SELECT DISTINCT (SUBSTR(STR(?place),32) as ?link) ?propertyLabel ?placeLabel
WHERE {
wd:Q198984 ?prop ?place. ?place wdt:P625 [].
?property ?ref ?prop; rdf:type wikibase:Property.
SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"}
}
Ten nearest places to a place[edit]
SELECT DISTINCT (SUBSTR(STR(?place),32) as ?link) ?placeLabel
WHERE {
wd:Q1191 wdt:P625 ?loc2. #Starting point
{ SELECT DISTINCT ?place ?coords WHERE
{?item wdt:P195 wd:Q636400;
wdt:P973 ?url FILTER (STRSTARTS(STR(?url),"http://jameelcentre") ).
VALUES ?property {wd:P180 wd:P1071}
?property wikibase:directClaim ?prop.
?item ?prop ?place.
?place wdt:P625 ?coords
} }
BIND(geof:distance(?coords, ?loc2) AS ?distNum).
SERVICE wikibase:label {bd:serviceParam wikibase:language "en".
?place rdfs:label ?placeLabel}
} ORDER BY ?distNum OFFSET 1 LIMIT 10
Materials of things in the Ashmolean collection[edit]
This is used to make materials.json
SELECT (SUBSTR(STR(?material), 32) as ?material) ?materialLabel ?materialDescription (COUNT(?item) AS ?count) WHERE {
?item wdt:P195 wd:Q636400; wdt:P186 ?material;
wdt:P973 ?url FILTER (STRSTARTS(STR(?url),"http://jameelcentre") ).
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
} GROUP BY ?material ?materialLabel ?materialDescription ORDER BY UCASE(?materialLabel)
Ashmolean items for a given material[edit]
SELECT ?item ?itemLabel ?inventory (GROUP_CONCAT(?typeLabel; separator=", ") AS ?types) (YEAR(?earliest) AS ?from) (YEAR(?latest) AS ?to) WHERE {
?item p:P195 [ps:P195 wd:Q636400; pq:P217 ?inventory].
?item wdt:P186 wd:Q37681; wdt:P31 ?type;
wdt:P973 ?url FILTER (STRSTARTS(STR(?url),"http://jameelcentre") ).
OPTIONAL {?item p:P571 [pq:P1319 ?earliest; pq:P1326 ?latest] }
SERVICE wikibase:label { bd:serviceParam wikibase:language "en".
?item rdfs:label ?itemLabel. ?type rdfs:label ?typeLabel}
} GROUP BY ?item ?itemLabel ?inventory ?earliest ?latest
ORDER BY ?from ?to ?itemLabel
Types of things in the Ashmolean collection[edit]
used to make types.json
SELECT (SUBSTR(STR(?type), 32) as ?type) ?typeLabel ?typeDescription (COUNT(?item) AS ?count) WHERE {
?item wdt:P195 wd:Q636400; wdt:P31 ?type; wdt:P973 ?url FILTER (STRSTARTS(STR(?url),"http://jameelcentre") ).
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
} GROUP BY ?type ?typeLabel ?typeDescription ORDER BY UCASE(?typeLabel)
Items of a given type[edit]
SELECT ?item ?itemLabel ?inventory (YEAR(?earliest) AS ?from) (YEAR(?latest) AS ?to) WHERE {
?item p:P195 [ps:P195 wd:Q636400; pq:P217 ?inventory].
?item wdt:P31 wd:Q1066288; wdt:P973 ?url FILTER (STRSTARTS(STR(?url),"http://jameelcentre") ).
OPTIONAL {?item p:P571 [pq:P1319 ?earliest; pq:P1326 ?latest] }
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" .
?item rdfs:label ?itemLabel }
} ORDER BY ?from ?to ?itemLabel
Ashmolean items without a label[edit]
As of 31 March 2018, gives zero results.
SELECT ?item WHERE {
?item wdt:P195 wd:Q636400.
MINUS {?item rdfs:label []}
}
Ashmolean items without no inception date and no time period[edit]
SELECT ?item ?inventory WHERE {
?item p:P195 [ps:P195 wd:Q636400; pq:P217 ?inventory].
MINUS {?item wdt:P571 []}
MINUS {?item wdt:P2348 []}
}
Ashmolean things named "Figure of " but with no depiction property[edit]
Also includes "Standing figure of...", "Seated figure of..."
SELECT ?item ?itemLabel ?url WHERE {
?item wdt:P195 wd:Q636400; wdt:P973 ?url
MINUS {?item wdt:P180 []}
?item rdfs:label ?itemLabel filter( lang(?itemLabel)="en" ) filter( CONTAINS(?itemLabel, "igure of ") )
}
Jameel items ordered by number of statements[edit]
SELECT ?item ?itemLabel ?url ?count WHERE {
?item wdt:P195 wd:Q636400; wdt:P973 ?url FILTER (STRSTARTS(STR(?url),"http://jameelcentre") ).
?item wikibase:statements ?count.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY DESC(?count)
LIMIT 20
Count of links from Jameel items to items that have a location[edit]
SELECT (COUNT(?loc) as ?count) WHERE {
?item wdt:P195 wd:Q636400; wdt:P973 ?url FILTER (STRSTARTS(STR(?url),"http://jameelcentre") ).
?item ?prop ?loc. ?loc wdt:P625 [] FILTER (?loc != wd:Q636400)
}
Wikipedia pages about Ashmolean items in languages other than English[edit]
SELECT ?itemLabel ?inv ?languageLabel ?sitelink WHERE {
?item wdt:P195 wd:Q636400; wdt:P217 ?inv # items in the Ashmolean and get their inventory number
FILTER (?item != wd:Q1249435) . # exclude Oxyrhynchus Papyri
?sitelink schema:about ?item; # Wikimedia links (usually Wikipedia articles)
schema:inLanguage ?lang FILTER (?lang != 'en') FILTER (?lang != 'en-simple') . # exclude English language
?language wdt:P305 ?lang # convert two-letter code to language item
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY ?inv
web.ashmolean.org items without an Ashmolean Museum ID[edit]
SELECT ?item ?itemLabel ?itemDescription ?url WHERE {
?item wdt:P195 wd:Q636400.
?item wdt:P973 ?url FILTER( CONTAINS(STR(?url), "www.ashmolean.org") )
MINUS {?item wdt:P6610 []}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Things in the Ashmolean that have gold as their only material[edit]
Should give no results (no results as of 19 May 2019)
SELECT ?item ?url WHERE {
?item wdt:P195 wd:Q636400; # collection: Ashmolean
wdt:P31 wd:Q3305213; # type: painting
wdt:P186 wd:Q897 # material: gold
MINUS {?item wdt:P186 ?mat FILTER (?mat != wd:Q897) } # no non-gold material
OPTIONAL {?item wdt:P973 ?url}
}
Things with two different Ashmolean Museum identifiers (should give no results)[edit]
SELECT * WHERE {
?i wdt:P6610 ?id1; wdt:P6610 ?id2 FILTER (?id1 > ?id2)
}
External links from Ashmolean Museum's English Wikipedia article[edit]
Query provided by Lucas Werkmeister
SELECT ?extlink WHERE {
SERVICE wikibase:mwapi {
bd:serviceParam wikibase:api "Generator";
wikibase:endpoint "en.wikipedia.org";
mwapi:generator "allpages";
mwapi:gapfrom "Ashmolean_Museum";
mwapi:gapto "Ashmolean_Museum";
mwapi:prop "extlinks".
?extlink wikibase:apiOutput "extlinks/el/text()".
}
}
Links to a particular domain from the Wikipedia biographies of artists in a given collection[edit]
SELECT ?artistpage ?extlink WHERE {
{SELECT DISTINCT ?name ?artistpage WHERE {
?item wdt:P195 wd:Q636400; wdt:P170 ?artist. # Artists in the Ashmolean
?artistpage schema:about ?artist;
schema:isPartOf <https://en.wikipedia.org/>; # ENWP articles about them
schema:name ?name # Title of article
}
}
OPTIONAL {SERVICE wikibase:mwapi { # External links from each article
bd:serviceParam wikibase:api "Generator";
wikibase:endpoint "en.wikipedia.org";
mwapi:generator "allpages";
mwapi:gapfrom ?name;
mwapi:gapto ?name;
mwapi:prop "extlinks".
?extlink wikibase:apiOutput "extlinks/el/text()".
}
FILTER CONTAINS(?extlink, "rkd.nl")
}
} ORDER BY ?artistpage
Wikipedia articles about Ashmolean items, their links to the Ashmolean web site, and candidate links from Wikidata[edit]
Doesn't work yet as MWAPI doesn't return enough external links. Phabricator report
SELECT ?itempage ?extlink ?url ?ash_id WHERE {
{SELECT DISTINCT ?name ?item ?itempage WHERE {
?item wdt:P195 wd:Q636400. # items in the Ashmolean
?itempage schema:about ?item;
schema:isPartOf <https://en.wikipedia.org/>; # ENWP articles about them
schema:name ?name # Title of article
}
}
OPTIONAL {SERVICE wikibase:mwapi { # External links from each article
bd:serviceParam wikibase:api "Generator";
wikibase:endpoint "en.wikipedia.org";
mwapi:generator "allpages";
mwapi:gapfrom ?name;
mwapi:gapto ?name;
mwapi:prop "extlinks";
mwapi:ellimit 50 .
?extlink wikibase:apiOutput "extlinks/el/text()".
}
FILTER CONTAINS(?extlink, "ashmolean.org")
}
OPTIONAL {?item wdt:P973 ?url FILTER CONTAINS(STR(?url), "ashmolean.org")
}
OPTIONAL {?item wdt:P6610 ?ash_id}
} ORDER BY ?itempage
External links from Commons File:pages[edit]
Thanks to Lucas Werkmeister again
SELECT ?image ?extlink WHERE {
wd:Q4656096 wdt:P18 ?image.
BIND(STRAFTER(STR(?image), "FilePath/") AS ?encoded_name)
BIND(wikibase:decodeUri(?encoded_name) AS ?name)
OPTIONAL { SERVICE wikibase:mwapi { # External links from each image
bd:serviceParam wikibase:api "Generator";
wikibase:endpoint "commons.wikimedia.org";
mwapi:generator "allimages";
mwapi:gaifrom ?name;
mwapi:gaito ?name;
mwapi:prop "extlinks";
mwapi:ellimit "500".
?extlink wikibase:apiOutput "extlinks/el/text()".
} }
} ORDER BY ?name
Connections from Ashmolean Museum items to Japan Search entities[edit]
SELECT DISTINCT ?work ?workLabel ?propertyLabel ?thingLabel (?jps AS ?japan_search_id) WHERE {
?thing wdt:P6698 ?jps FILTER (!CONTAINS(?jps, "nmoa-")).
VALUES ?prop {wdt:P170 wdt:P180}
?work wdt:P195 wd:Q636400; ?prop ?thing.
?property ?ref ?prop ;
rdf:type wikibase:Property
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY ?thingLabel
Oxford Collections overview[edit]
Things connected to Oxford collection items[edit]
SELECT (SUBSTR(STR(?thing),32) AS ?q) (SUBSTR(STR(?prop),37) as ?p) (SUBSTR(STR(?item),32) AS ?itemq) ?itemLabel ?fullwork (SUBSTR(STR(?coll),32) as ?collq) ?inventory ?url (GROUP_CONCAT(SUBSTR(STR(?artist),32);separator=" ") AS ?artists)
(GROUP_CONCAT(?typeLabel; separator=", ") AS ?types) ?from (YEAR(?latest) AS ?to) ?precision WHERE {
VALUES ?coll {wd:Q636400 wd:Q82133 wd:Q1456119 wd:Q6941088} # Ashmolean, Bodleian, PRM, MHS
?item p:P195 [ps:P195 ?coll; pq:P217 ?inventory].
VALUES ?prop {wdt:P180 wdt:P170 wdt:P1774 wdt:P138} # depicted, creator, school of, named after
?item ?prop ?thing; wdt:P31 ?type.
OPTIONAL {?item wdt:P973 ?url FILTER(CONTAINS(STR(?url), ".ox.ac.uk")|| CONTAINS(STR(?url), "ashmolean.org") )}
OPTIONAL {?item wdt:P953 ?fullwork FILTER(CONTAINS(STR(?fullwork), ".ox.ac.uk") || CONTAINS(STR(?fullwork), "ashmolean.org") )}
FILTER (BOUND(?fullwork) || BOUND(?url) )
OPTIONAL {?item wdt:P170 ?artist}
OPTIONAL {?item p:P571 [pq:P1319 ?earliest; pq:P1326 ?latest] }
OPTIONAL {?item p:P571/psv:P571 [ wikibase:timePrecision ?precision; wikibase:timeValue ?year ] }
BIND(IF (BOUND(?earliest), YEAR(?earliest), YEAR(?year)) AS ?from)
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" .
?item rdfs:label ?itemLabel. ?type rdfs:label ?typeLabel }
} GROUP BY ?thing ?prop ?item ?itemLabel ?fullwork ?inventory ?url ?coll ?from ?latest ?precision
ORDER BY DESC(?prop) ?from ?to
[edit]
SELECT DISTINCT ?item ?itemLabel ?itemDescription WHERE {
{?item wdt:P973 ?url FILTER (STRSTARTS(STR(?url), ".ox.ac.uk")) }
UNION {?item wdt:P953 ?fullwork FILTER (CONTAINS(STR(?fullwork), ".ox.ac.uk")) }
?item wdt:P195 ?coll FILTER( ?coll NOT IN (wd:Q636400, wd:Q82133, wd:Q1456119, wd:Q6941088, wd:Q52556635) ).
SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}
Pitt Rivers Museum[edit]
Unreferenced statements about things in the Pitt Rivers Museum[edit]
SELECT (SUBSTR(STR(?item),32) AS ?wdq) (SUBSTR(STR(?prop),32) AS ?wdp) ?object ?url WHERE {
?item wdt:P195 wd:Q1456119.
?item wdt:P973 ?url FILTER CONTAINS(STR(?url), "ox.ac.uk").
?item ?p ?statement.
?prop wikibase:claim ?p; wikibase:statementProperty ?ps FILTER (?prop != wd:P973) FILTER (?prop != wd:P953)
FILTER (?prop != wd:P18) FILTER (?prop != wd:P571).
?statement ?ps ?object .
FILTER NOT EXISTS {?statement prov:wasDerivedFrom ?derivedFrom}
} ORDER BY ?item
Things whose archives are in the Pitt-Rivers Museum[edit]
As of April 2019, 50 out of 79 (one appears twice because of two VIAF IDs)
SELECT ?person ?personLabel ?personDescription (URI(CONCAT("https://viaf.org/viaf/", ?viaf)) AS ?viaf_link)
(URI(CONCAT("https://doi.org/10.1093/ref:odnb/", ?odnb)) AS ?odnb_link) ?image ?url
WHERE {
?person p:P485 [ps:P485 wd:Q1456119; pq:P973 ?url]
OPTIONAL {?person wdt:P214 ?viaf}
OPTIONAL {?person wdt:P18 ?image}
OPTIONAL {?person wdt:P1415 ?odnb}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
Image gallery of people whose archives are in the Pitt-Rivers Museum[edit]
#defaultView:ImageGrid{"hide": ["?image"]}
SELECT ?image ?personDescription ?personLabel ?prmlink
WHERE {
?person p:P485 [ps:P485 wd:Q1456119; pq:P973 ?prmlink].
?person wdt:P18 ?image
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
Histropedia timeline of people connected to the PRM, colour-coded by gender
Memory of the World Register[edit]
Language balance of Wikipedia articles about objects on the register[edit]
#title:Languages of Wikipedia articles about Memory of the World Register inscriptions
SELECT ?langcode ?langname (COUNT(?link) AS ?count) WHERE {
?item wdt:P1435 wd:Q473858. # heritage designation: Memory of the World
?link schema:about ?item ; schema:inLanguage ?langcode
FILTER(CONTAINS(str(?link), ".wikipedia.org/")) # only Wikipedia articles
OPTIONAL { ?language wdt:P218 ?langcode; rdfs:label ?langlabel FILTER(lang(?langlabel) = "en") } # Convert short code to full language name
BIND(COALESCE(?langlabel, ?langcode) AS ?langname)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?langcode ?langname
ORDER BY DESC(?count)
Wikipedia articles about objects on the register[edit]
Historic China[edit]
See also Wikidata:WikiProject_East_Asia/China_Biographical_Database_import
Things from dynasties of the imperial era, with their collections and shelfmarks[edit]
The following query uses these:
- Properties: instance of (P31) , time period (P2348) , country (P17) , country of origin (P495) , collection (P195) , made from material (P186) , inventory number (P217)
SELECT ?dynastyLabel ?thing ?thingLabel (GROUP_CONCAT(DISTINCT ?typel; separator=", ") AS ?what) (GROUP_CONCAT(DISTINCT ?matl; separator=", ") AS ?materials) ?thingDescription ?collectionLabel ?inventoryNo WHERE { ?dynasty wdt:P31 wd:Q50068795. VALUES ?prop {wdt:P2348 wdt:P17 wdt:P495}. ?thing ?prop ?dynasty; wdt:P31 ?type; wdt:P195 ?collection. ?type rdfs:label ?typel FILTER(lang(?typel) = "en"). OPTIONAL {?thing wdt:P186 ?material. ?material rdfs:label ?matl FILTER(lang(?matl) = "en") }. OPTIONAL {?thing wdt:P217 ?inventoryNo } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } } GROUP BY ?dynastyLabel ?thing ?thingLabel?thingDescription ?collectionLabel ?inventoryNo ORDER BY ?dynastyLabel
Timeline of states of Imperial period[edit]
The following query uses these:
- Properties: instance of (P31) , inception (P571) , dissolved, abolished or demolished date (P576) , country of citizenship (P27) , time period (P2348) , locator map image (P242) , image (P18)
SELECT ?dynasty ?dynastyLabel ?start ?end (SAMPLE(?image) AS ?img) WHERE { ?dynasty wdt:P31 wd:Q50068795; wdt:P571 ?start; wdt:P576 ?end. VALUES ?prop {wdt:P27 wdt:P2348} OPTIONAL {?dynasty wdt:P242 ?image} OPTIONAL {?thing wdt:P18 ?image; ?prop ?dynasty} SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } } GROUP BY ?dynasty ?dynastyLabel ?start ?end ORDER BY ?start ?end
Time periods[edit]
Historic periods and corresponding numbers of things in collections[edit]
The following query uses these:
- Properties: time period (P2348) , collection (P195) , end time (P582)
SELECT ?period ?periodLabel ?periodDescription (COUNT(?q) AS ?mcount) WHERE { ?q wdt:P2348 ?period. ?q p:P195 ?s. ?s ps:P195 ?collection . MINUS {?s pq:P582 []}. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } OPTIONAL{?enwp schema:about ?collection; schema:isPartOf <https://en.wikipedia.org/> } } GROUP BY ?period ?periodLabel ?periodDescription ORDER BY DESC(?mcount)
History of Japan[edit]
Periods of Japanese history and what they were named after[edit]
#title:Major eras of Japanese history
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. FILTER (?era NOT IN (wd:Q11358452, wd:Q11509224, wd:Q1145058) ) # Exclude ancient times, modern times
#MINUS { ?era wdt:P2348/wdt:P361 wd:Q130436 wd:Q1145058} # exclude sub-eras
MINUS {?era wdt:P2348 []}
OPTIONAL { ?era wdt:P582 ?end_time }
OPTIONAL { ?era wdt:P138 ?named }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
} ORDER BY ?start DESC(?end)
Periods of Japanese history and calendar eras within them[edit]
SELECT ?era ?eraLabel (YEAR(?start_time) AS ?start) (YEAR(?end_time) AS ?end) ?subera ?suberaLabel
(YEAR(?sub_start_time) AS ?sub_start) (YEAR(?sub_end_time) AS ?sub_end) WHERE {
?era wdt:P31 wd:Q11514315; wdt:P361 wd:Q130436; # eras of the history of Japan
wdt:P580 ?start_time.
MINUS { ?era wdt:P2348 []} # exclude sub-eras
OPTIONAL { ?era wdt:P582 ?end_time }
OPTIONAL { ?subera wdt:P2348 ?era; wdt:P361 wd:Q130436; wdt:P580 ?sub_start_time;
wdt:P582 ?sub_end_time }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
} ORDER BY ?start DESC(?end)
Japan Search[edit]
Numbers of language labels for things with a Japan Search Name ID[edit]
SELECT ?languageLabel ?count WHERE {
{SELECT ?langcode (COUNT(?label) as ?count) WHERE {
?thing wdt:P6698 ?jpsid; rdfs:label ?label.
BIND(lang(?label) AS ?langcode)
} GROUP BY ?langcode }
?language wdt:P218 ?langcode
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY DESC(?count)
Missing labels and descriptions[edit]
Paintings with no English description but a known artist label[edit]
SELECT ?item ("Den" AS ?den) (CONCAT("painting by ", ?creatorLabel) as ?toadd) WHERE {
?item wdt:P31 wd:Q3305213; wdt:P170 ?creator FILTER(?creator != wd:Q4233718) # exclude Anonymous
MINUS {?item wdt:P31 ?other FILTER(?other != wd:Q3305213) } # painting is only type
MINUS {?item schema:description ?engdesc FILTER (lang(?engdesc)="en") } # No English description
?creator rdfs:label ?creatorLabel FILTER (lang(?creatorLabel)="en") # Artist label in English is known
}
Paintings with no English label but a Commons Category[edit]
SELECT ?item ?category WHERE {
?item wdt:P31 wd:Q3305213; wdt:P373 ?category
MINUS{ ?item rdfs:label ?itemLabel FILTER (lang(?itemLabel)="en") }
}
Books with a title in a given language but not a label in that language[edit]
SELECT ?item ?lang ?title WHERE {
?item wdt:P31/wdt:P279* wd:Q571 ; # Q571 for book
wdt:P1476 ?title .
BIND(LANG(?title) as ?lang) FILTER (?lang != "und")
FILTER (NOT EXISTS{ ?item rdfs:label ?itemLabel. FILTER(lang(?itemLabel) = ?lang) })
}
Wikidata maintenance[edit]
How many items have an inventory number but no collection?[edit]
The following query uses these:
- Properties: inventory number (P217) , collection (P195)
SELECT (COUNT(?obj) AS ?count) WHERE { ?obj wdt:P217 [] MINUS {?obj wdt:P195 []} }
How many items have an inventory number with a collection in a qualifier but no collection?[edit]
The following query uses these:
- Properties: collection (P195) , inventory number (P217)
SELECT (COUNT(?obj) AS ?count) WHERE { ?obj p:P217 ?s. ?s pq:P195 ?collection MINUS {?obj wdt:P195 []} }
As of 25 November 2017, 358
Collections and inventory numbers of items an inventory number with a collection in a qualifier but no collection[edit]
The following query uses these:
- Properties: collection (P195) , inventory number (P217)
SELECT ?obj ?collection ?inventory WHERE { ?obj p:P217 ?s. ?s pq:P195 ?collection; ps:P217 ?inventory MINUS {?obj wdt:P195 []} }
Semantic search[edit]
Synonyms[edit]
SELECT DISTINCT ?name WHERE {
VALUES ?rel {rdfs:label skos:altLabel}
VALUES ?rel2 {rdfs:label skos:altLabel}
?target ?rel "Confucius"@en;
?rel2 ?name FILTER ( lang(?name)="en" )
}
Names for types of coin[edit]
SELECT DISTINCT ?name WHERE {
?sub wdt:P279+/rdfs:label "coin"@en.
{?sub rdfs:label ?name} UNION {?sub skos:altLabel ?name} FILTER (lang(?name)="en")
FILTER ( !CONTAINS(?name, "coin") )
}
[edit]
SELECT DISTINCT ?related ?relatedLabel ?relatedDescription WHERE {
VALUES ?target {wd:Q42}
{ ?target ?prop ?related } UNION { ?related ?prop ?target }
filter (CONTAINS(STR(?related),'/entity/Q') ).
SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
} ORDER BY UCASE(?relatedLabel)
Data-driven semantic clustering[edit]
#defaultView:Graph
SELECT ?item1 ?item1Label ?item2 ?item2Label WHERE {
VALUES ?item1Label {"Congressional Black Caucus"@en
"Barack Obama"@en
"Michelle Obama"@en
"University of Chicago"@en
"Time Person of the Year"@en
"Democratic Party"@en
"White House"@en
"Hillary Clinton"@en
"Aragorn"@en
"C. S. Lewis"@en
"J. R. R. Tolkien"@en
"University of Oxford"@en
"World War I"@en
"Battle of the Somme"@en
"British Army"@en
"The Lord of the Rings"@en}
VALUES ?item2Label {"Congressional Black Caucus"@en
"Barack Obama"@en
"Michelle Obama"@en
"University of Chicago"@en
"Time Person of the Year"@en
"Democratic Party"@en
"White House"@en
"Hillary Clinton"@en
"Aragorn"@en
"C. S. Lewis"@en
"J. R. R. Tolkien"@en
"University of Oxford"@en
"World War I"@en
"Battle of the Somme"@en
"British Army"@en
"The Lord of the Rings"@en}
?item1 rdfs:label ?item1Label.
?item2 rdfs:label ?item2Label.
?item1 ?prop ?item2
}
Astrolabes[edit]
All astrolabes (and parts), with collection and creator[edit]
SELECT ?collectionLabel ?inv ?url ?creatorLabel WHERE {
?item wdt:P31/wdt:P361? wd:Q164992.
?item wdt:P195 ?collection; wdt:P217 ?inv.
OPTIONAL{?item wdt:P170 ?creator}
OPTIONAL {?item wdt:P973 ?url}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY ?creatorLabel
Map of locations of Astrolabe origin[edit]
#defaultView:Map{"hide": ["?coords"]}
SELECT ?loc ?locLabel ?coords (COUNT(?item) as ?count) WHERE {
?item wdt:P31/wdt:P361? wd:Q164992.
?item wdt:P1071 ?loc. ?loc wdt:P625 ?coords.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?loc ?locLabel ?coords
Timeline of Astrolabes[edit]
#defaultView:Timeline{"hide": "?inception"}
SELECT ?item (?thingLabel as ?itemLabel) ?d ?collectionLabel ?inception WHERE {
?thing wdt:P31 wd:Q164992; wdt:P195 ?collection; wdt:P217 ?d; wdt:P571 ?inception
OPTIONAL {?thing wdt:P973 ?url}
BIND (IF(BOUND(?url),?url, URI(CONCAT("https://tools.wmflabs.org/reasonator/?q=", substr(str(?thing),32))) ) AS ?item)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?thing rdfs:label ?thingLabel. ?collection rdfs:label ?collectionLabel}
}
Creators with Reasonator links[edit]
SELECT DISTINCT (URI(CONCAT("https://tools.wmflabs.org/reasonator/?q=", SUBSTR(STR(?creator),32) )) as ?reasonator) ?creatorLabel
(GROUP_CONCAT(DISTINCT ?locLabel; separator=", ") AS ?locations) ?countryLabel (COUNT(?item) AS ?count) WHERE {
?item wdt:P31/wdt:P361? wd:Q164992.
VALUES ?rel {wdt:P170 wdt:P1774}
?item ?rel ?creator FILTER(!wikibase:isSomeValue(?creator))
OPTIONAL {?creator wdt:P27 ?country }
OPTIONAL {?creator wdt:P937 ?loc }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?loc rdfs:label ?locLabel. ?creator rdfs:label ?creatorLabel. ?country rdfs:label ?countryLabel }
} GROUP BY ?creator ?creatorLabel ?countryLabel
ORDER BY DESC(?count)
Materials[edit]
SELECT ?materialLabel ?materialDescription (COUNT(?item) AS ?count) WHERE {
?item wdt:P31/wdt:P361? wd:Q164992.
?item wdt:P186 ?material
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?materialLabel ?materialDescription
ORDER BY DESC(?count) UCASE(?materialLabel)
Image gallery[edit]
#defaultView:ImageGrid
SELECT ?image ?item ?itemLabel ?collectionLabel WHERE {
?item wdt:P31/wdt:P361? wd:Q164992; wdt:P18 ?image; wdt:P195 ?collection.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Unreferenced statements about Oxford Astrolabes[edit]
SELECT (SUBSTR(STR(?item),32) AS ?wdq) (SUBSTR(STR(?prop),32) AS ?wdp) ?object ?url WHERE {
?item wdt:P31/wdt:P361? wd:Q164992 ; wdt:P195 wd:Q6941088.
?item wdt:P973 ?url.
?item ?p ?statement.
?prop wikibase:claim ?p; wikibase:statementProperty ?ps FILTER (?prop != wd:P973)
FILTER (?prop != wd:P18).
?statement ?ps ?object .
FILTER NOT EXISTS {?statement prov:wasDerivedFrom []}
} ORDER BY ?item
Things called Astrolabe in English but with missing labels in other languages[edit]
SELECT (SUBSTR(STR(?q),32) AS ?wdq) (CONCAT("L",?astrolabe_lang) AS ?lang) ?astrolabe_label WHERE {
{SELECT ?astrolabe_lang ?astrolabe_label WHERE {
wd:Q164992 rdfs:label ?astrolabe_label. BIND(lang(?astrolabe_label) AS ?astrolabe_lang)
}
}
?q rdfs:label "Astrolabe"@en.
FILTER(NOT EXISTS {
?q rdfs:label ?label.
FILTER(LANG(?label) = ?astrolabe_lang)
})
}
English Wikipedia articles about creators of astrolabes that are in the Museum of the History of Science[edit]
SELECT DISTINCT ?person ?page ?image WHERE {
?item wdt:P31 wd:Q164992; wdt:P195 wd:Q6941088.
?item wdt:P170 ?person.
OPTIONAL { ?item wdt:P18 ?image }
?page schema:about ?person; schema:isPartOf <https://en.wikipedia.org/>
} ORDER BY ?page
Descriptions of things in the History of Science Museum[edit]
SELECT ?item ?description (lang(?description) as ?lang) WHERE {
?item wdt:P195 wd:Q6941088.
?item schema:description ?description
}
Astrolabes ordered by diameter[edit]
#defaultView:BarChart
SELECT (str(?item) as ?name) ?diam WHERE {
?item wdt:P31 wd:Q164992; p:P2386/psv:P2386 ?valuenode. # astrolabes with a diameter property
?valuenode wikibase:quantityAmount ?length; wikibase:quantityUnit ?unit.
BIND(IF(?unit = wd:Q174728, ?length * 10,?length) as ?diam) # diameter in millimetres (unit is cm or mm)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?item rdfs:label ?itemLabel }
} ORDER BY DESC(?diam)
Scatter-plot of diameter against year of creation[edit]
#defaultView:ScatterChart
SELECT (YEAR(SAMPLE(?date)) as ?year) (SAMPLE(?diam) as ?diam1) (CONCAT(?itemLabel," ",SUBSTR(str(?item),32) ) as ?name) WHERE {
?item wdt:P31 wd:Q164992; wdt:P571 ?date; p:P2386/psv:P2386 ?valuenode. # astrolabes with a diameter property
?valuenode wikibase:quantityAmount ?length; wikibase:quantityUnit ?unit.
BIND(IF(?unit = wd:Q174728, ?length * 10,?length) as ?diam) # diameter in millimetres (unit is cm or mm)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?item rdfs:label ?itemLabel }
} group by ?item ?itemLabel
Object with a given King number[edit]
SELECT * WHERE {
?item wdt:P31/wdt:P361? wd:Q164992; wdt:P528 "150"
}
IIIF[edit]
What kinds of thing have IIIF links in Wikidata?[edit]
SELECT ?typeLabel (COUNT(?thing) AS ?count) WHERE {
?thing wdt:P6108 ?iiif; wdt:P31 ?type
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?typeLabel
ORDER BY DESC(?count)
What collections have IIIF links in Wikidata?[edit]
SELECT ?collectionLabel (COUNT(?thing) AS ?count) WHERE {
?thing wdt:P6108 []; wdt:P195 ?collection
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?collectionLabel
ORDER BY DESC(?count)
What artists have IIIF links in Wikidata?[edit]
SELECT ?creator ?creatorLabel ?creatorDescription (COUNT(?art) AS ?count) WHERE {
?art wdt:P6108 []; wdt:P170 ?creator.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?creator ?creatorLabel ?creatorDescription
ORDER BY DESC(?count)
Manuscripts with IIIF links (not just notable ones)[edit]
#defaultView:ImageGrid{"hide": ["?image","?placeholder"]}
SELECT ?placeholder ?image ?qLabel (GROUP_CONCAT(DISTINCT ?collectionLabel; separator="; ") AS ?where)
(URI(CONCAT('https://tools.wmflabs.org/mirador/?manifest=', STR(?iiif))) AS ?iiiflink)
WHERE {
?q (wdt:P31/wdt:P279*) wd:Q87167; wdt:P6108 ?iiif; wikibase:sitelinks ?sitecount.
?q p:P195 ?s. ?s ps:P195 ?collection . MINUS {?s pq:P582 []}.
MINUS {?s ps:P195 wd:Q1322278 }
OPTIONAL {?q wdt:P18 ?img}
BIND (IF(BOUND(?img), ?img, <http://commons.wikimedia.org/wiki/Special:FilePath/No%20image%20available.svg>) AS ?image)
BIND (IF(BOUND(?img), 0, 1) AS ?placeholder)
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?q rdfs:label ?qLabel. ?collection rdfs:label ?collectionLabel
}
}
GROUP BY ?placeholder ?qLabel ?image ?iiif ?sitecount
ORDER BY ?placeholder DESC(?sitecount)
IIIF links for works by the artist Raphael[edit]
#defaultView:ImageGrid{"hide": ["?image"]}
SELECT ?qLabel ?image (GROUP_CONCAT(DISTINCT ?collectionLabel; separator="; ") AS ?where) (URI(CONCAT('https://tools.wmflabs.org/mirador/?manifest=', STR(?iiif))) AS ?q) WHERE {
?q wdt:P6108 ?iiif; wdt:P18 ?image;
wdt:P170 wd:Q5597; # creator: Raphael
p:P195 ?s. ?s ps:P195 ?collection . MINUS {?s pq:P582 []}.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?q rdfs:label ?qLabel. ?collection rdfs:label ?collectionLabel}
} GROUP BY ?q ?qLabel ?iiif ?image
ORDER BY ?where
Image gallery of works by J. M. W. Turner with IIIF links[edit]
#defaultView:ImageGrid{"hide": ["?image","?placeholder"]}
SELECT ?thingLabel ?image ?placeholder (URI(CONCAT('https://tools.wmflabs.org/mirador/?manifest=', STR(?iiif))) AS ?iiiflink) WHERE {
?thing wdt:P6108 ?iiif;
wdt:P170 wd:Q159758. # creator: Turner
OPTIONAL{ ?thing wdt:P18 ?img }
BIND (IF(BOUND(?img), ?img, <http://commons.wikimedia.org/wiki/Special:FilePath/No%20image%20available.svg>) AS ?image)
BIND (IF(BOUND(?img), 0, 1) AS ?placeholder)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY ?placeholder
IIIF manifests for self-portrait paintings[edit]
#defaultView:ImageGrid{"hide": ["?image", "?placeholder"]}
SELECT DISTINCT ?qLabel ?image ?placeholder (GROUP_CONCAT(DISTINCT ?collectionLabel; separator="; ") AS ?where)
(URI(CONCAT('https://tools.wmflabs.org/mirador/?manifest=', STR(?iiif))) AS ?iiiflink)
WHERE {
?q wdt:P31 wd:Q3305213; # painting
wdt:P136 wd:Q192110; # genre: self-portrait
wdt:P6108 ?iiif. # IIIF manifest link on Wikidata
OPTIONAL{ ?q wdt:P18 ?img } # Image on Commons
?q p:P195 ?s. ?s ps:P195 ?collection . MINUS {?s pq:P582 []}.
MINUS {?s ps:P195 wd:Q1322278 }
# ?collection wdt:P17 wd:Q145 # collection in the UK
BIND (IF(BOUND(?img), ?img, <http://commons.wikimedia.org/wiki/Special:FilePath/No%20image%20available.svg>) AS ?image)
BIND (IF(BOUND(?img), 1, 0) AS ?placeholder)
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?q rdfs:label ?qLabel. ?collection rdfs:label ?collectionLabel
}
} GROUP BY ?q ?qLabel ?iiif ?image ?placeholder
ORDER BY DESC(?placeholder) ?where
Exhibition histories[edit]
What objects have appeared in the most exhibitions?[edit]
#title:Objects that have appeared in most exhibitions
SELECT ?item ?itemLabel ?itemDescription (COUNT(DISTINCT ?exhibited) as ?count) WHERE {
?item wdt:P608 ?exhibited
MINUS {?item wdt:P31 wd:Q5} # exclude artists
MINUS {?item wdt:P279 []} # exclude types of thing (e.g. fighter aircraft!)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
} GROUP BY ?item ?itemLabel ?itemDescription
ORDER BY DESC(?count) LIMIT 10
Art UK[edit]
Art UK artworks and things depicted in them[edit]
#title:Art UK artworks and things they depict
SELECT ?item ?itemLabel ?id ?depictedLabel WHERE {
?item wdt:P1679 ?id.
?item wdt:P180 ?depicted.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}