User:Jacksonj04/2019 EU Elections/Prompt/DC

This compares candidates in 2019 European Parliament election in the United Kingdom (Q22001091) on Wikidata with those on YourNextRepresentative, and produces a list of differences.

In an ideal world this would be empty, indicating that both sources agree on all things. However, due to nuances in modelling and variations in source data this might not be the case. Before editing anything, please double check with reality.

Warning:

There was an error the last time this prompt was refreshed:

There was an error fetching: https://dc-wikidata-proxy.herokuapp.com/europarl.2019-05-23/csv - the error was: 404 Not Found

This means that the content below may be out of date.

Common problems that you might want to check include:

That the URL of the CSV file is really a valid CSV file
That the SPARQL query succeeds and returns results

Comparison

@@	wikidata_id (SPARQL)	name (SPARQL)	name (CSV)	dc_id (SPARQL)	area_id (SPARQL)	party_id (SPARQL)	gender (SPARQL)	gender (CSV)
->	Annunziata Rees-Mogg (Q4769784)	Annunziata Rees-Mogg		2950	East Midlands (Q5328978)	Brexit Party (Q61651140)	cisgender female	female
->	Tom McLaren (Q63929215)	Thomas McLaren	Tom McLaren	41864	East of England (Q5329755)	Conservative Party (Q9626)	male
->	Nosheena Mobarik, Baroness Mobarik (Q18211172)	Nosheena Mobarik, Baroness Mobarik	Nosheena Mobarik	69730	Scotland (Q7435626)	Conservative Party (Q9626)	female
->	Andrew Adonis, Baron Adonis (Q337156)	Andrew Adonis, Baron Adonis	Andrew Adonis	70307	South West England (Q2973373)	Labour Party (Q9630)	male

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

External source

https://dc-wikidata-proxy.herokuapp.com/europarl.2019-05-23/csv

SPARQL query

SELECT ?wikidata_id ?wikidata_idLabel (?wikidata_idLabel as ?name) ?dc_id ?area_id ?party_id ?genderObjectLabel (?genderObjectLabel as ?gender)
WHERE 
{
  ?election wdt:P361 wd:Q22001091 . 
  ?ps ps:P3602 ?election .
  ?election p:P541 ?office .
  ?office pq:P768 ?area_id .
  ?wikidata_id p:P3602 ?ps . 
  OPTIONAL { ?ps pq:P1268 ?party_id }
  OPTIONAL { ?wikidata_id wdt:P6465 ?dc_id }
  OPTIONAL { ?wikidata_id wdt:P21 ?genderObject }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

Refresh prompt

Refresh this comparison Purge the cache