Jump to content

User:Jjanhone

From Wikidata
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.
sv-4 Den här användaren kan svenska nästan på modersmålsnivå.
fr-3 Cette personne dispose de connaissances avancées en français.
de-2 Dieser Benutzer beherrscht Deutsch auf fortgeschrittenem Niveau.
da-0 Denne bruger har intet kendskab til dansk (eller forstår det kun med stor vanskelighed).
no-0 Denne brukeren har lite eller ingen kjennskap til norsk (eller har svært vanskelig for å forstå det).
es-0 Esta persona no tiene ningún conocimiento del español (o lo entiende con mucha dificultad).
pl-0 Ten użytkownik nie rozumie języka polskiego (albo ma z nim olbrzymie trudności).
it-0 Quest'utente non è in grado di comunicare in italiano (o lo capisce solo con notevole difficoltà).
Users by language

Hi! I'm Johanna Janhonen, a Wikimedian from Finland. Learn more about me from Q130724245.

I'm here to learn more about Wikidata to be able to teach it. I'm also a Wikipedian in residence and a paid editor. Until the end of October 2025 I had made less than 500 edits on Wikidata, part of them things I actually did on Wikipedia like moving pages. They were typically changes to names/photos of the items – I did not make a lot of changes on them.

In November 2025 (inspired by the first WikidataCon I participated) I started to study Wikidata more.

Since then I started to add new kind of information to the Wikidata items, also items that are related to my customers. As I want to be open about my customer projects I have here, I keep a track of them below.

Wikidata milestones

[edit]

I made my

  • first edit on 4th March 2013
  • the 100th edit in 2021
  • the 500th edit in November 2025
  • the 1000th edit on 25 November 2025
  • the 2000th edit on 9th December 2025
  • the 3000th edit on 17th February 2026
  • the 4000th edit on 24th March 2026
  • the 5000th edit on 20th April 2026
  • the 6000th edit on 18th May 2026
  • the 7000th edit on 2nd June 2026
  • the 8000th edit on 17th June 2026
  • the 9000th edit on 3rd July 2026
  • the 10K edit on 7th September 2026

Started to use

  • common.js on 28th January 2026

My customer projects

[edit]

Items I've edited:

Marginaalimerkintöjä edits (2024–2025)

[edit]

Items I've edited at Marginaalimerkintöjä project (2024–2025) where I'm a WIR: Annikki Arola-Anttila, Anni Lötjönen, Art+Feminism, Category:Gender studies, Category:Gender studies academics, Category for Finnish academics of gender studies, Fredrika Runeberg, Hiski Salomaa, Huora, Máze Group, Mimmi Label, Möttö, Tellervo Anttila, Saga Mast, Sakura Fujita, Saku Sahlstedt, Sanna Solanterä, Sara Siren, Tellervo Anttila, women's studies

Edits for people I know IRL

[edit]
[edit]

Trainings

[edit]

Finnish institutes that have operated in Wikidata

[edit]
  • 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]

Tools

[edit]

WikiData Projects

[edit]

Other Projects

[edit]

Queries

[edit]

Suhteita Muumilaaksossa

[edit]

Kyselyn teki User:MartinPoulter

The following query uses these:

Features: Graph (Q24515287)  View with Reasonator View with SQID

#defaultView:Graph
#title:Graph of Moominworld
SELECT ?item1 ?image ?item1Label ?item2 ?image2 ?item2Label ?edgeLabel
WITH { SELECT ?item1 WHERE {
?item1 wdt:P1080 wd:Q105110642
} } AS %item1
WITH {SELECT (?item1 AS ?item2) WHERE {INCLUDE %item1} } AS %item2
WHERE {
  INCLUDE %item1.
  INCLUDE %item2.
?item1 ?prop ?item2.
?edge wikibase:directClaim ?prop ; a wikibase:Property
OPTIONAL {?item1 wdt:P18 ?image}
OPTIONAL {?item2 wdt:P18 ?image2}
SERVICE wikibase:label { bd:serviceParam wikibase:language "fi" }
}
Graph of Moominworld

City halls before 1500

[edit]

The following query uses these:

Features: Wikidata SPARQL map (Q24515275)  View with Reasonator View with SQID

#defaultView:Map
SELECT ?item ?itemLabel ?itemDescription ?image (YEAR(?date) AS ?year) ?coord WHERE {
?item wdt:P31/wdt:P279? wd:Q25550691.
 OPTIONAL {     ?item wdt:P18 ?image}.
  ?item wdt:P571 ?date FILTER (YEAR(?date) <1500)
                               ?item wdt:P625 ?coord .
          SERVICE wikibase:label { bd:serviceParam wikibase:language "fi,en". }
} order by ?year
Try it!


People born in Kangasniemi

[edit]

The following query uses these:

  • Properties: place of birth (P19)  View with Reasonator View with SQID
    SELECT ?item ?itemLabel ?itemDescription WHERE {
?item wdt:P19 wd:Q1025714.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fi,en". }
} order by ?itemLabel
Try it!

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

[edit]

The following query uses these:

  • Properties: collection (P195)  View with Reasonator View with SQID, location (P276)  View with Reasonator View with SQID
    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

[edit]

The following query uses these:

  • Properties: collection (P195)  View with Reasonator View with SQID, image (P18)  View with Reasonator View with SQID, location (P276)  View with Reasonator View with SQID
    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

[edit]

The following query uses these:

  • Properties: collection (P195)  View with Reasonator View with SQID, creator (P170)  View with Reasonator View with SQID
    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

[edit]

The following query uses these:

  • Properties: instance of (P31)  View with Reasonator View with SQID, creator (P170)  View with Reasonator View with SQID, collection (P195)  View with Reasonator View with SQID, coordinate location (P625)  View with Reasonator View with SQID
    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

[edit]

The following query uses these:

  • Properties: country of citizenship (P27)  View with Reasonator View with SQID, creator (P170)  View with Reasonator View with SQID, image (P18)  View with Reasonator View with SQID, collection (P195)  View with Reasonator View with SQID, coordinate location (P625)  View with Reasonator View with SQID
    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!

Musical awards

[edit]

User:Samoasambia created these two queries. Many thanks!

Human winners

[edit]

The following query uses these:

  • Properties: award received (P166)  View with Reasonator View with SQID
    SELECT ?item ?itemLabel WHERE {
  ?item wdt:P166 wd:Q115916994. # saanut vuoden yhtyeen Emma-palkinnon
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } }
Try it!

Other winners

[edit]

The following query uses these:

  • Properties: award received (P166)  View with Reasonator View with SQID, part of (P361)  View with Reasonator View with SQID
    SELECT ?item ?itemLabel ?award ?awardLabel WHERE {
  ?item wdt:P166 ?award. # saanut palkinnon
  ?award wdt:P361 wd:Q1337975. # palkinto on osa Emma-palkintoa
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". } }
Try it!


Finnish people born on year 2000

[edit]

The following query uses these:

  • Properties: country of citizenship (P27)  View with Reasonator View with SQID, sex or gender (P21)  View with Reasonator View with SQID, date of birth (P569)  View with Reasonator View with SQID
    SELECT ?item ?itemLabel ?itemDescription ?sex_or_genderLabel WHERE {
  ?item wdt:P27 wd:Q33.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fi,en". }
  OPTIONAL { ?item wdt:P21 ?sex_or_gender. }
  ?item wdt:P569 ?date.
  FILTER((YEAR(?date)) = 2000 )
}
ORDER BY (?itemLabel)
Try it!

Number of Finnish people born on year 2000

[edit]

The following query uses these:

Try it!

Count of Finnish male people born on year 2000

[edit]

The following query uses these:

  • Properties: country of citizenship (P27)  View with Reasonator View with SQID, sex or gender (P21)  View with Reasonator View with SQID, date of birth (P569)  View with Reasonator View with SQID
    SELECT (COUNT(*) AS ?count)

WHERE {
  ?item wdt:P27 wd:Q33.
?item wdt:P21 wd:Q6581097.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fi,en". }
  OPTIONAL { ?item wdt:P21 ?sex_or_gender. }
  ?item wdt:P569 ?date.
  FILTER((YEAR(?date)) = (2000) )
}
Try it!


Count of Finnish people in Finnish Wikipedia by sex and birth decade

[edit]

The following query uses these:

  • Properties: instance of (P31)  View with Reasonator View with SQID, country of citizenship (P27)  View with Reasonator View with SQID, date of birth (P569)  View with Reasonator View with SQID, sex or gender (P21)  View with Reasonator View with SQID
    SELECT 
  ?birthyear 
  (COUNT(?item) AS ?count)  
  (sum(xsd:integer(?gender IN (wd:Q6581097, wd:Q15145778) )) as ?males ) 
  (sum(xsd:integer(?gender IN (wd:Q6581072, wd:Q15145779 ) )) as ?females) 
  (sum(xsd:integer(?gender IN (wd:Q1052281, wd:Q18116794,  wd:Q2449503, wd:Q1052281, wd:Q1097630, wd:Q48270, wd:Q179294))) as ?others) WHERE {
{
SELECT ?item ?gender (floor(floor(year(?birthdate)/10)*10) as ?birthyear) WHERE {
   ?item wdt:P31 wd:Q5 .
    ?item wdt:P27 wd:Q33.
   ?item wdt:P569 ?birthdate .
   ?item wdt:P21 ?gender .
   ?article schema:about ?item .
   ?article schema:isPartOf  . #Targeting Wikipedia language where subjects has no article.
}
}
FILTER(?birthyear>2004)
}
GROUP BY ?birthyear
ORDER BY ?birthyear
Try it!
Retrieved from "https://www.wikidata.org/w/index.php?title=User:Jjanhone&oldid=2553485090"