From Wikidata
Jump to navigation Jump to search

This compares all terms for members of the Council which are known. It does not compare party or ward, since these can only be reliably scraped for the current membership.

This report is currently known to include members who appear to have been elected (ie appear in election results) but who do not have matching entries on the Council website.


@@ wikidata_id (SPARQL) wikidata_id (CSV) name (SPARQL) name (CSV) url (SPARQL) url (CSV) start (SPARQL) start (CSV) end (SPARQL) end (CSV)
--- Greg Mulholland (Q337568) Greg Mulholland MP _:t1669624716 _:t1669624717
--- Barry Anderson (Q55469085) Barry Anderson 2012-05-03T00:00:00Z 2016-05-05T00:00:00Z
--- Jonathan Bentley (Q55469091) Jonathan Bentley 2012-05-03T00:00:00Z 2016-05-05T00:00:00Z
--- Billy Flynn (Q55469150) Billy Flynn 2018-03-05T00:00:00Z
--- Angela Gabriel (Q55469151) Angela Gabriel 2016-05-05T00:00:00Z 2018-05-03T00:00:00Z
--- Sandy Lay (Q55469206) Sandy Lay 2012-05-03T00:00:00Z 2016-05-05T00:00:00Z
--- Alice Smart (Q55469255) Alice Smart 2018-03-05T00:00:00Z
--- Christopher Townsley (Q55726336) Chris Townsley 2012-05-03T00:00:00Z 2016-05-05T00:00:00Z
+++ Patrick Davey (Q56884295) Patrick Davey 2007-05-04T00:00:00Z 2011-05-05T00:00:00Z
+++ Patrick Davey (Q56884295) Patrick Davey 2011-05-06T00:00:00Z 2015-05-07T00:00:00Z
--- Bryan North (Q55738938) _:t830006211
--- Bryan North (Q55738938) _:t830006213
--- Robert Finnigan (Q56882256) Robert Finnigan 2019-05-07T00:00:00Z
--- Robert Finnigan (Q56882256) Robert Finnigan 2012-05-03T00:00:00Z 2016-05-05T00:00:00Z
--- Robert Finnigan (Q56882256) Robert Finnigan 2012-05-03T00:00:00Z 2016-05-05T00:00:00Z
--- Robert Finnigan (Q56882256) Robert Finnigan 2016-05-05T00:00:00Z 2018-05-03T00:00:00Z
--- Robert Finnigan (Q56882256) Robert Finnigan 2016-05-05T00:00:00Z 2018-05-03T00:00:00Z
--- Adam Ogilvie (Q56884294) Adam Ogilvie 2015-01-01T00:00:00Z 2018-05-03T00:00:00Z
+++ Rachael Procter (Q56884296) Rachael Procter 2004-06-10T00:00:00Z 2007-05-03T00:00:00Z
+++ Rachael Procter (Q56884296) Rachael Procter 2007-06-10T00:00:00Z 2011-05-03T00:00:00Z
+++ Rachael Procter (Q56884296) Rachael Procter 2011-05-05T00:00:00Z 2015-05-07T00:00:00Z
--- Andrea McKenna (Q58697785) Andrea McKenna 2012-05-03T00:00:00Z 2016-05-05T00:00:00Z
+++ Christine MacNiven (Q56884298) Christine Macniven 2011-05-06T00:00:00Z 2015-05-07T00:00:00Z
+++ David Congreve (Q55726340) David Congreve 2010-05-07T00:00:00Z 2014-05-22T00:00:00Z
+++ Shirley Varley (Q57080791) Shirley Varley 2010-05-06T00:00:00Z 2014-05-22T00:00:00Z
+++ Lucinda Yeadon (Q56882255) Lucinda Yeadon 2008-05-02T00:00:00Z 2012-05-03T00:00:00Z
+++ Ghulam Hussain (Q57080793) Ghulam Hussain 2010-05-07T00:00:00Z 2014-05-22T00:00:00Z
+++ Brian Selby (Q57080790) Brian Selby 2010-05-07T00:00:00Z 2014-05-22T00:00:00Z
+++ Andrea McKenna (Q58697785) Andrea McKenna 2011-05-06T00:00:00Z 2015-05-07T00:00:00Z
+++ Mick Coulson (Q57080792) Mick Coulson 2010-05-07T00:00:00Z 2014-05-22T00:00:00Z
-> Julie Heselwood (Q55469190) Julie Heselwood 2015-01-01T00:00:00Z2016-05-06T00:00:00Z 2018-05-03T00:00:00Z
+++ Graham Hyde (Q56882253) Graham Hyde 2004-06-11T00:00:00Z 2008-05-01T00:00:00Z
+++ Graham Hyde (Q56882253) Graham Hyde 2008-05-02T00:00:00Z 2012-05-03T00:00:00Z
+++ Jack Dunn (Q56884293) Jack Dunn 2004-06-11T00:00:00Z 2007-05-03T00:00:00Z
+++ Jack Dunn (Q56884293) Jack Dunn 2007-05-04T00:00:00Z 2011-05-05T00:00:00Z
+++ Jack Dunn (Q56884293) Jack Dunn 2011-05-06T00:00:00Z 2015-05-07T00:00:00Z
+++ Josie Jarosz (Q56882257) Josephine Jarosz 2004-06-11T00:00:00Z 2008-05-01T00:00:00Z
+++ Josie Jarosz (Q56882257) Josephine Jarosz 2008-05-02T00:00:00Z 2012-05-03T00:00:00Z
+++ Adam Ogilvie (Q56884294) Adam Ogilvie 2007-05-04T00:00:00Z 2011-05-05T00:00:00Z
+++ Adam Ogilvie (Q56884294) Adam Ogilvie 2011-05-06T00:00:00Z 2015-05-07T00:00:00Z
+++ Suzi Armitage (Q58697780) Suzi Armitage 2004-06-10T00:00:00Z 2008-05-01T00:00:00Z
+++ Suzi Armitage (Q58697780) Suzi Armitage 2008-05-01T00:00:00Z 2012-05-03T00:00:00Z


  • Items only found in SPARQL (--- in the first column): 17
  • Items only found in CSV (+++ in the first column): 24
  • Items that differ between sources (→ in the first column): 1
  • Total items in SPARQL: 348
  • Total items in CSV: 355

External source

SPARQL query

SELECT ?wikidata_id ?name ?url ?start ?end WHERE {
    BIND (wd:Q55465119 as ?legislature) .
    ?member wdt:P361 ?legislature ;
    MINUS {?member wdt:P576 [] }
    MINUS { ?legislature wdt:P576 [] }
    ?node ps:P39 ?member .
    OPTIONAL { ?node pq:P580 ?start }
    OPTIONAL { ?node pq:P582 ?end }
    ?node ps:P39 ?position .
    ?position wdt:P31 ?positiontype .
    ?wikidata_id p:P39 ?node .
        ?wikidata_id p:P973 ?describedAt .
        ?describedAt ps:P973 ?url .
        OPTIONAL {
            ?describedAt pq:P1810 ?name .
        FILTER(CONTAINS(LCASE(STR(?url)), ""))
ORDER BY ?wikidata_id
Try it!

Refresh prompt

Refresh this comparison Purge the cache

Customize (optional)