User:Oravrattas/prompts/Riigikogu 13 EveryPolitician

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)

• edit external source for this prompt.
• edit SPARQL for this prompt.
• edit header template
• edit footer template
• edit row added template
• edit row removed template
• edit row modified template
• edit stats template