User:Jacksonj04/Leeds/Prompt/2019 Wetherby By-election

This compares candidates in 2019 Wetherby By-election (Q74410389) 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)	twitter_username (SPARQL)	twitter_username (CSV)

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

External source

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

SPARQL query

SELECT ?wikidata_id ?wikidata_idLabel (?wikidata_idLabel as ?name) ?dc_id ?party_id ?twitter_username
WHERE 
{
  ?wikidata_id p:P3602 ?ps .
  ?ps ps:P3602 wd:Q74410389 .
  OPTIONAL { ?wikidata_id wdt:P6465 ?dc_id }
  OPTIONAL { ?wikidata_id wdt:P21 ?gender }
  OPTIONAL { ?wikidata_id wdt:P2002 ?twitter_username }
  OPTIONAL { ?ps pq:P1268 ?party_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