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

From Wikidata
Jump to navigation Jump to search

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?id=local.leeds.2019-12-12

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)