User:Jacksonj04/Leeds/Prompt/2019

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)		NULL	OfficiallyAmyG
->	Wayne Dixon (Q62273416)		Wayne Dixon		18775		Social Democratic Party (Q7550572)		Middleton Park (Q6842031)		NULL	Wayne_Dixon
->	Dylan Brown (Q62273397)		Dylan Brown		34599		Green Party of England and Wales (Q9669)		Kippax & Methley (Q55466808)		NULL	ERGreens
->	Mike Foster (Q62273267)		Mike Foster		35717		Conservative Party (Q9626)		Ardsley & Robin Hood (Q55466797)		NULL	MikeFosterARH
->	Cameron Stephenson (Q62273269)		Cameron Stephenson		35719		Conservative Party (Q9626)		Morley North (Q55466800)		NULL	Cameron_Surname
->	Gideon Jones (Q62273272)		Gideon Jones		36964		Green Party of England and Wales (Q9669)		Alwoodley (Q56651541)		NULL	GideonPARANOID
->	Pete Compton (Q62273433)		Pete Compton		36994		Labour Co-operative (Q6467393)		Morley South (Q55466782)		NULL	petemorleysouth
->	Johnathan Leng (Q62273435)		Johnathan Leng		36999		Labour Co-operative (Q6467393)		Morley North (Q55466800)		NULL	Lengy007
->	Ellen Graham (Q62273304)		Ellen Graham		37065		Green Party of England and Wales (Q9669)		Calverley & Farsley (Q55466776)		NULL	GrahamEllen
->	Jacob Goddard (Q55469167)		Jacob Goddard		37257		Labour Party (Q9630)		Roundhay (Q56651558)		NULL	ROGoddard
->	John Garvani (Q62273378)		John Garvani		38001		Labour Party (Q9630)		Horsforth (Q55466779)		NULL	johngarvani
->	Nicole Sharpe (Q62273306)		Nicole Sharpe		38200		Labour Party (Q9630)		Temple Newsam (Q55466781)		NULL	micole12_nicole
->	Shaff Sheikh (Q62273346)		Shaff Sheikh		44849		Social Democratic Party (Q7550572)		Gipton & Harehills (Q55466757)		NULL	VOTE4SHAFF
->	Hannah Barham-Brown (Q63031180)		Hannah Barham-Brown		49798		Women's Equality Party (Q20648714)		Roundhay (Q56651558)		NULL	HannahPopsy
->	Caroline Hunt (Q63031182)		Caroline Hunt		49808		Women's Equality Party (Q20648714)		Headingley & Hyde Park (Q55466799)		NULL	LineyHunt
->	Eleanor Thomson (Q63031213)		Eleanor Thomson		54305		Labour Co-operative (Q6467393)		Guiseley & Rawdon (Q55466823)		NULL	nelnanandnora

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

External source

https://dc-wikidata-proxy.herokuapp.com/local.leeds.2019-05-02/csv

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: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)

• 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