User:Oravrattas/prompts/Riigikogu 13 EveryPolitician

From Wikidata
Jump to navigation Jump to search


Comparison

@@ name wikidata
--- Aivar Surva Aivar Surva (Q55984168)
--- Enn Meri Enn Meri (Q53636801)
--- Jüri Saar Jüri Saar (Q16403439)
--- Karin Tammemägi Karin Tammemägi (Q53638402)
-> Oudekki Loone->Kerstin-Oudekki Loone Oudekki Loone (Q12371725)
--- Paul-Eerik Rummo Paul-Eerik Rummo (Q788525)
--- Rein Randver Rein Randver (Q14542629)
--- Signe Kivi Signe Kivi (Q2285186)
-> Siret Kotka-Repinski->Siret Kotka Siret Kotka (Q12375092)
-> Viktoria Ladõnskaja-Kubits->Viktoria Ladõnskaja Viktoria Ladõnskaja-Kubits (Q16405450)
-> Vilja Toomast->Vilja Savisaar-Toomast Vilja Toomast (Q460589)

Stats

  • Items only found in SPARQL (--- in the first column): 7
  • Items only found in CSV (+++ in the first column): 0
  • Items that differ between sources (→ in the first column): 4
  • Total items in SPARQL: 154
  • Total items in CSV: 147

External source

https://gist.githubusercontent.com/tmtmtmtm/ee5e97ad82cc66dc672b7fdcea68c19c/raw/2e149fbe2a873c272eca3c3e712a9c61bd6525ab/riigikogu-13.csv

SPARQL query

SELECT DISTINCT ?name (STRAFTER(STR(?item), STR(wd:)) AS ?wikidata) WHERE {
    ?item wdt:P39 wd:Q33129158 .
    SERVICE wikibase:label { 
      bd:serviceParam wikibase:language "et,en". 
      ?item rdfs:label ?name .
    }
  }
  ORDER BY ?name
Try it!

Refresh prompt

Refresh this comparison Purge the cache

Customize (optional)