From Wikidata
Jump to navigation Jump to search

This compares candidates in 2019 Leeds City Council election (Q62223284) with those on YourNextRepresentative.


@@ wikidata_id (SPARQL) wikidata_id (CSV) name (SPARQL) name (CSV) dc_id (SPARQL) dc_id (CSV) party_id (SPARQL) party_id (CSV) area_id (SPARQL) area_id (CSV) twitter_username (SPARQL) twitter_username (CSV)
-> Amy Green (Q62273414) Amy Green 18714 Conservative Party (Q9626) Little London & Woodhouse (Q55466753) NULLOfficiallyAmyG
-> Wayne Dixon (Q62273416) Wayne Dixon 18775 Social Democratic Party (Q7550572) Middleton Park (Q6842031) NULLWayne_Dixon
-> Dylan Brown (Q62273397) Dylan Brown 34599 Green Party of England and Wales (Q9669) Kippax & Methley (Q55466808) NULLERGreens
-> Mike Foster (Q62273267) Mike Foster 35717 Conservative Party (Q9626) Ardsley & Robin Hood (Q55466797) NULLMikeFosterARH
-> Cameron Stephenson (Q62273269) Cameron Stephenson 35719 Conservative Party (Q9626) Morley North (Q55466800) NULLCameron_Surname
-> Gideon Jones (Q62273272) Gideon Jones 36964 Green Party of England and Wales (Q9669) Alwoodley (Q56651541) NULLGideonPARANOID
-> Pete Compton (Q62273433) Pete Compton 36994 Labour Co-operative (Q6467393) Morley South (Q55466782) NULLpetemorleysouth
-> Johnathan Leng (Q62273435) Johnathan Leng 36999 Labour Co-operative (Q6467393) Morley North (Q55466800) NULLLengy007
-> Ellen Graham (Q62273304) Ellen Graham 37065 Green Party of England and Wales (Q9669) Calverley & Farsley (Q55466776) NULLGrahamEllen
-> Jacob Goddard (Q55469167) Jacob Goddard 37257 Labour Party (Q9630) Roundhay (Q56651558) NULLROGoddard
-> John Garvani (Q62273378) John Garvani 38001 Labour Party (Q9630) Horsforth (Q55466779) NULLjohngarvani
-> Nicole Sharpe (Q62273306) Nicole Sharpe 38200 Labour Party (Q9630) Temple Newsam (Q55466781) NULLmicole12_nicole
-> Shaff Sheikh (Q62273346) Shaff Sheikh 44849 Social Democratic Party (Q7550572) Gipton & Harehills (Q55466757) NULLVOTE4SHAFF
-> Hannah Barham-Brown (Q63031180) Hannah Barham-Brown 49798 Women's Equality Party (Q20648714) Roundhay (Q56651558) NULLHannahPopsy
-> Caroline Hunt (Q63031182) Caroline Hunt 49808 Women's Equality Party (Q20648714) Headingley & Hyde Park (Q55466799) NULLLineyHunt
-> Eleanor Thomson (Q63031213) Eleanor Thomson 54305 Labour Co-operative (Q6467393) Guiseley & Rawdon (Q55466823) NULLnelnanandnora


  • Items only found in SPARQL (--- in the first column): 0
  • Items only found in CSV (+++ in the first column): 0
  • Items that differ between sources (→ in the first column): 16
  • Total items in SPARQL: 180
  • Total items in CSV: 180

External source

SPARQL query

SELECT ?wikidata_id ?wikidata_idLabel (?wikidata_idLabel as ?name) ?dc_id ?party_id ?area_id ?twitter_username
  ?wikidata_id p:P3602 ?ps .
  ?ps ps:P3602 wd:Q62223284 .
  OPTIONAL { ?wikidata_id wdt:P6465 ?dc_id }
  OPTIONAL { ?wikidata_id wdt:P21 ?gender }
  OPTIONAL { ?wikidata_id wdt:P2002 ?twitter_username }
  OPTIONAL { ?ps pq:P102 ?party_id . }
  OPTIONAL { ?ps pq:P768 ?area_id . }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
Try it!

Refresh prompt

Refresh this comparison Purge the cache

Customize (optional)