User:Jacksonj04/Leeds/Prompt/2019

From Wikidata
Jump to navigation Jump to search

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


Comparison

@@ 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) NULLAmyLeedsTory
-> Ian Dowling (Q62273424) Ian Dowling 18753 Liberal Democrats (Q9624) Adel & Wharfedale (Q55466756) NULLiangdowling
-> Wayne Dixon (Q62273416) Wayne Dixon 18775 Social Democratic Party (Q7550572) Middleton Park (Q6842031) NULLWayne_Dixon
-> Matthew Clover (Q63031179) Matthew Clover 34568 Yorkshire Party (Q17059489) Killingbeck & Seacroft (Q55466786) NULLmatthewclover11
-> Dylan Brown (Q62273397) Dylan Brown 34599 Green Party of England and Wales (Q9669) Kippax & Methley (Q55466808) NULLERGreens
-> Jon Hannah (Q62273474) Jon Hannah 34740 Liberal Democrats (Q9624) Roundhay (Q56651558) NULLJCHannah77
-> 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
-> Jessica Lennox (Q55469215) Jessica Lennox 36635 Labour Party (Q9630) Cross Gates & Whinmoor (Q55466803) jess4labourNULL
-> 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
-> Stewart Harper (Q62273415) Stewart Harper 44632 Conservative Party (Q9626) Otley & Yeadon (Q55466766) NULLstewharper
-> 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
-> Victoria Smith (Q63031195) Victoria Smith 52249 Green Party of England and Wales (Q9669) Kirkstall (Q55466761) NULLtor1981
-> Shahab Adris (Q63031221) Shahab Adris 55189 Green Party of England and Wales (Q9669) Temple Newsam (Q55466781) NULLAdrisShahab
-> Rachel Hartshorne (Q63031264) Rachel Hartshorne 56179 Green Party of England and Wales (Q9669) Moortown (Q55466778) NULLrbhartshorne

Stats

  • 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): 23
  • Total items in SPARQL: 180
  • Total items in CSV: 180

External source

https://dc-wikidata-proxy.herokuapp.com?id=local.leeds.2019-05-02

SPARQL query

SELECT ?wikidata_id ?wikidata_idLabel (?wikidata_idLabel as ?name) ?dc_id ?party_id ?area_id ?twitter_username
WHERE 
{
  ?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:P4100 ?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)