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 _:t1391534830 _:t1391534831
--- 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
-> Denise Ragan (Q55469237) Denise Ragan 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Denise Ragan (Q55469237) Denise Ragan 2019-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
--- 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
--- 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
-> Ryan Stephenson (Q55469256) Ryan Stephenson 2018-05-03T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Ryan Stephenson (Q55469256) Ryan Stephenson 2019-05-07T00: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
+++ David Congreve (Q55726340) David Congreve 2010-05-07T00:00:00Z 2014-05-22T00: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
-> Kamila Maqsood (Q55469221) Kamila Maqsood 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Kamila Maqsood (Q55469221) Kamila Maqsood 2019-05-07T00:00:00Z
+++ Shirley Varley (Q57080791) Shirley Varley 2010-05-06T00:00:00Z 2014-05-22T00: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
+++ Ghulam Hussain (Q57080793) Ghulam Hussain 2010-05-07T00:00:00Z 2014-05-22T00:00:00Z
-> John Illingworth (Q55469358) John Illingworth 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ John Illingworth (Q55469358) John Illingworth 2019-05-07T00:00:00Z
-> Gerald Wilkinson (Q55469279) Gerald Wilkinson 2019-05-07T00:00:00Z NULL2019-11-01T00: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
-> Katie Dye (Q55469142) Katie Dye 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Katie Dye (Q55469142) Katie Dye 2019-05-07T00:00:00Z
-> Mary Harland (Q55469180) Mary Harland 2012-05-03T00:00:00Z2012-05-04T00:00:00Z 2016-05-05T00:00:00Z
-> Jessica Lennox (Q55469215) Jessica Lennox 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Jessica Lennox (Q55469215) Jessica Lennox 2019-05-07T00:00:00Z
-> Peter Carlill (Q55469118) Peter Carlill 2018-05-08T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Peter Carlill (Q55469118) Peter Carlill 2019-05-07T00:00:00Z
-> Suzanne McCormack (Q55469222) Suzanne McCormack 2018-05-08T00:00:00Z NULL2019-05-02T00:00:00Z
+++ Suzanne McCormack (Q55469222) Suzanne McCormack 2019-05-03T00:00:00Z
-> Christine Towler (Q56882252) Christine Towler 2012-05-03T00:00:00Z2012-05-04T00:00:00Z 2016-05-05T00:00:00Z
-> Jackie Shemilt (Q55469254) Jackie Shemilt 2018-05-08T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Jackie Shemilt (Q55469254) Jackie Shemilt 2019-05-07T00:00:00Z
-> Paul Wray (Q55469282) Paul Wray 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Paul Wray (Q55469282) Paul Wray 2019-05-07T00:00:00Z
-> Caroline Gruen (Q55469176) Caroline Gruen 2012-05-03T00:00:00Z2012-05-04T00:00:00Z 2016-05-05T00: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
--- Andrea McKenna (Q58697785) Andrea McKenna 2012-05-03T00:00:00Z 2016-05-05T00:00:00Z
-> Mohammed Shahzad (Q55469247) Mohammed Shahzad 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Mohammed Shahzad (Q55469247) Mohammed Shahzad 2019-05-07T00:00:00Z
-> Wyn Kidger (Q55469199) Wyn Kidger 2018-05-08T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Wyn Kidger (Q55469199) Wyn Kidger 2019-05-07T00:00:00Z
-> Lisa Mulherin (Q55469224) Lisa Mulherin 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Lisa Mulherin (Q55469224) Lisa Mulherin 2019-05-07T00: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
-> Elizabeth Nash (Q55469228) Elizabeth Nash 2012-05-03T00:00:00Z2012-05-04T00:00:00Z 2016-05-05T00:00:00Z
-> Gohar Almass (Q55469084) Gohar AlmasGohar Almass 2018-05-08T00:00:00Z
-> Andrew Scopes (Q55469243) Andrew Scopes 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Andrew Scopes (Q55469243) Andrew Scopes 2019-05-07T00:00:00Z
-> Jacob Goddard (Q55469167) Jacob Goddard 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Jacob Goddard (Q55469167) Jacob Goddard 2019-05-07T00:00:00Z
+++ Lucinda Yeadon (Q56882255) Lucinda Yeadon 2008-05-02T00:00:00Z 2012-05-03T00: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
-> Eileen Taylor (Q55469259) Eileen Taylor 2012-05-03T00:00:00Z2012-05-04T00:00:00Z 2016-05-05T00:00:00Z
-> Peter Harrand (Q55469185) Peter Harrand 2018-05-03T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Peter Harrand (Q55469185) Peter Harrand 2019-05-07T00:00:00Z
+++ Christine MacNiven (Q56884298) Christine Macniven 2011-05-06T00:00:00Z 2015-05-07T00:00:00Z
-> Ryk Downes (Q55469136) Ryk Downes 2018-05-03T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Ryk Downes (Q55469136) Ryk Downes 2019-05-07T00:00:00Z
-> Judith Elliott (Q55469143) Judith Elliott 2012-05-03T00:00:00Z2012-05-04T00:00:00Z 2016-05-05T00:00:00Z
-> Neil Walshaw (Q55469277) Neil Walshaw 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Neil Walshaw (Q55469277) Neil Walshaw 2019-05-07T00: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


  • Items only found in SPARQL (--- in the first column): 17
  • Items only found in CSV (+++ in the first column): 42
  • Items that differ between sources (→ in the first column): 27
  • Total items in SPARQL: 329
  • Total items in CSV: 354

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)