Jjanhone

Babel user information
fi-N Tämän käyttäjän äidinkieli on suomi. en-4 This user has near native speaker knowledge of English. fr-3 Cet·te utilisateur·rice dispose de connaissances avancées en français. de-2 Dieser Benutzer beherrscht Deutsch auf fortgeschrittenem Niveau. sv-4 Den här användaren kan svenska nästan på modersmålsnivå. da-1 Denne bruger har grundlæggende kendskab til dansk. no-1 Denne brukeren har grunnleggende kjennskap til norsk. Template:User sp-1
Users by language

Hi! I'm Johanna Janhonen from Finland, a Wikipedia trainer. I'm here to learn more about Wikidata to be able to teach also that.

Inspiring contenct / useful links

• Native Finnish speakers on Wikidata
• GLAM users User:Alicia_Fagerving_(WMSE)
• User pages with queries: User:Battleofalma, User:MartinPoulter/queries, User:Samoasambia, User:Seb35, User:Vesihiisi, User:Jamie7687, User:Kq-hit, User:Väsk
• OpenRefine
• Merge
• Quick statements, e.g. [1]
• Sanasto, asetukset

Finnish institutes that have operated in Wikidata

• Q3022430, Aboa Vetus Ars Nova
• Kansallisgalleria had a WIR in 2018, see [2]
• Q4412746 Porin taidemuseo in 2015: [3]
• Q28821145 Suomen pelimuseo, see [4]
• Q11899172 Werstas
• Vapriikki
• THL, see [5]
• Maybe also Oscari-museotietojärjestelmä (Jyväskylän yliopiston avoimen tiedon keskus) ?
• Projekt Fredrika, see [6]

Interesting projects

• from Wikidata to Finna
• Sum of all paintings
• Mediataideteokset

Existing collection

Current Wikidata items shown as in the collection of the Amox Rex Museum.

The following query uses these:

• Items: Amos Rex (Q22662489)   

• Properties: collection (P195)   , location (P276)   

  Select ?item ?itemLabel ?location ?locationLabel
  
  where { ?item wdt:P195 wd:Q22662489 .
         
         
         OPTIONAL { ?item wdt:P276 ?location }
         
         SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
         
         }
  

Try it!

Same query, but items show images

The following query uses these:

• Items: Amos Rex (Q22662489)   

• Properties: collection (P195)   , image (P18)   , location (P276)   

  Select ?item ?itemLabel ?location ?locationLabel ?image ?imageLabel
  
  where { ?item wdt:P195 wd:Q22662489 . #things in the amos rex collection
          ?item wdt:P18 ?image #item has image
          
         
         
         OPTIONAL { ?item wdt:P276 ?location }
         
         SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
         
         }
  

Try it!

Paintings by any artist in the Amos Rex museum and the Smithsonian

The following query uses these:

• Items: Amos Rex (Q22662489)   , Smithsonian American Art Museum (Q1192305)   , anonymous (Q4233718)   

• Properties: collection (P195)   , creator (P170)   

  SELECT (?count1 AS ?in_Amos_Rex) (?count2 AS ?in_Smithsonian) ?artist WHERE {
  { SELECT (COUNT(?obj1) AS ?count1) ?creator WHERE {
   ?obj1 wdt:P195 wd:Q22662489. #Amos Rex Museum
   ?obj1 wdt:P170 ?creator.
    } GROUP BY ?creator }
  { SELECT (COUNT(?obj2) AS ?count2) ?creator WHERE {
   ?obj2 wdt:P195 wd:Q1192305. #Smithsonian 
   ?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 }
  }
  

Try it!

Works of Paul Signac, with collection, with a map of those collections

The following query uses these:

• Items: painting (Q3305213)   , Paul Signac (Q151573)   

• Properties: instance of (P31)   , creator (P170)   , collection (P195)   , coordinate location (P625)   

  SELECT ?item ?itemLabel ?collection ?collectionLabel ?location ?locationLabel #added a Label here
  
  WHERE { ?item wdt:P31 wd:Q3305213  . #instance of paintings, 
          ?item wdt:P170 wd:Q151573 . #creator is Paul Signac 
          ?item wdt:P195 ?collection . #item has collection
          ?collection wdt:P625 ?location
         
         
         SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } #added labelservice here
        
        }
  

Try it!

Works of Finnish artists

The following query uses these:

• Items: Finland (Q33)   

• Properties: country of citizenship (P27)   , creator (P170)   , image (P18)   , collection (P195)   , coordinate location (P625)   

  SELECT ?artistLabel ?workLabel ?collectionLabel ?image ?coordinates WHERE {
    ?artist wdt:P27 wd:Q33 . # nationality of the artist: Finland
    ?work wdt:P170 ?artist . # creator of the work
    OPTIONAL { ?work wdt:P18 ?image . } # image of the work
    OPTIONAL {
      ?work wdt:P195 ?collection . # optional collection of the work
      OPTIONAL { ?collection wdt:P625 ?coordinates . } # optional coordinates of the collection
    }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "fi,mul,en". }
  }
  

Try it!