User:Clemens Radl/Wikidata

Let's collect stuff for Wikidata questions (such as useful SPARQL queries, little scripts, ...).

SPARQL

List WD entries of manuscripts of a certain library:

SELECT DISTINCT ?item ?itemLabel ?shelfmark WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". }
  {
    SELECT DISTINCT ?item ?shelfmark WHERE {
      ?item p:P31 ?statement0.
      ?statement0 (ps:P31/(wdt:P279*)) wd:Q87167.
      ?item p:P195 ?statement1.
      ?statement1 (ps:P195/(wdt:P279*)) <ID of library, e.g. wd:Q750403 for  "Madrid, BNE">.
      # ?item p:P217 ?statement2.
      # ?statement2 (ps:P217/(wdt:P279*)) ?shelfmark
    }
    LIMIT 100
  }
}

Run query

NB: Sometimes it is better to leave out the last statement about the inventory number as it is not always present.