User:Jacksonj04/Leeds/Prompt/All

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.


Comparison

@@ 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 https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=345 _:t1391534830 _:t1391534831
--- Barry Anderson (Q55469085) Barry Anderson https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=184 2012-05-03T00:00:00Z 2016-05-05T00:00:00Z
--- Jonathan Bentley (Q55469091) Jonathan Bentley https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=4578 2012-05-03T00:00:00Z 2016-05-05T00:00:00Z
--- Billy Flynn (Q55469150) Billy Flynn https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=6003 2018-03-05T00:00:00Z
--- Angela Gabriel (Q55469151) Angela Gabriel https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=199 2016-05-05T00:00:00Z 2018-05-03T00:00:00Z
--- Sandy Lay (Q55469206) Sandy Lay https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=4577 2012-05-03T00:00:00Z 2016-05-05T00:00:00Z
-> Denise Ragan (Q55469237) Denise Ragan https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=6662 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Denise Ragan (Q55469237) Denise Ragan https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=6662 2019-05-07T00:00:00Z
+++ Suzi Armitage (Q58697780) Suzi Armitage https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=177 2004-06-10T00:00:00Z 2008-05-01T00:00:00Z
+++ Suzi Armitage (Q58697780) Suzi Armitage https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=177 2008-05-01T00:00:00Z 2012-05-03T00:00:00Z
--- Alice Smart (Q55469255) Alice Smart https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=6008 2018-03-05T00:00:00Z
--- Christopher Townsley (Q55726336) Chris Townsley https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=203 2012-05-03T00:00:00Z 2016-05-05T00:00:00Z
--- Bryan North (Q55738938) _:t830006211
--- Bryan North (Q55738938) _:t830006213
--- Robert Finnigan (Q56882256) Robert Finnigan https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=189 2019-05-07T00:00:00Z
--- Robert Finnigan (Q56882256) Robert Finnigan https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=189 2012-05-03T00:00:00Z 2016-05-05T00:00:00Z
--- Robert Finnigan (Q56882256) Robert Finnigan https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7364 2012-05-03T00:00:00Z 2016-05-05T00:00:00Z
--- Robert Finnigan (Q56882256) Robert Finnigan https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=189 2016-05-05T00:00:00Z 2018-05-03T00:00:00Z
--- Robert Finnigan (Q56882256) Robert Finnigan https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7364 2016-05-05T00:00:00Z 2018-05-03T00:00:00Z
--- Adam Ogilvie (Q56884294) Adam Ogilvie https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=257 2015-01-01T00:00:00Z 2018-05-03T00:00:00Z
-> Ryan Stephenson (Q55469256) Ryan Stephenson https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=6667 2018-05-03T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Ryan Stephenson (Q55469256) Ryan Stephenson https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=6667 2019-05-07T00:00:00Z
+++ Graham Hyde (Q56882253) Graham Hyde https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=179 2004-06-11T00:00:00Z 2008-05-01T00:00:00Z
+++ Graham Hyde (Q56882253) Graham Hyde https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=179 2008-05-02T00:00:00Z 2012-05-03T00:00:00Z
+++ David Congreve (Q55726340) David Congreve https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=211 2010-05-07T00:00:00Z 2014-05-22T00:00:00Z
+++ Mick Coulson (Q57080792) Mick Coulson https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=218 2010-05-07T00:00:00Z 2014-05-22T00:00:00Z
-> Julie Heselwood (Q55469190) Julie Heselwood https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=6339 2015-01-01T00:00:00Z2016-05-06T00:00:00Z 2018-05-03T00:00:00Z
-> Kamila Maqsood (Q55469221) Kamila Maqsood https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=2291 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Kamila Maqsood (Q55469221) Kamila Maqsood https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=2291 2019-05-07T00:00:00Z
+++ Shirley Varley (Q57080791) Shirley Varley https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=2298 2010-05-06T00:00:00Z 2014-05-22T00:00:00Z
+++ Patrick Davey (Q56884295) Patrick Davey https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=232 2007-05-04T00:00:00Z 2011-05-05T00:00:00Z
+++ Patrick Davey (Q56884295) Patrick Davey https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=232 2011-05-06T00:00:00Z 2015-05-07T00:00:00Z
+++ Ghulam Hussain (Q57080793) Ghulam Hussain https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=2286 2010-05-07T00:00:00Z 2014-05-22T00:00:00Z
-> John Illingworth (Q55469358) John Illingworth https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=192 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ John Illingworth (Q55469358) John Illingworth https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=192 2019-05-07T00:00:00Z
-> Gerald Wilkinson (Q55469279) Gerald Wilkinson https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=222 2019-05-07T00:00:00Z NULL2019-11-01T00:00:00Z
+++ Rachael Procter (Q56884296) Rachael Procter https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=224 2004-06-10T00:00:00Z 2007-05-03T00:00:00Z
+++ Rachael Procter (Q56884296) Rachael Procter https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=224 2007-06-10T00:00:00Z 2011-05-03T00:00:00Z
+++ Rachael Procter (Q56884296) Rachael Procter https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=224 2011-05-05T00:00:00Z 2015-05-07T00:00:00Z
-> Katie Dye (Q55469142) Katie Dye https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7129 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Katie Dye (Q55469142) Katie Dye https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7129 2019-05-07T00:00:00Z
-> Mary Harland (Q55469180) Mary Harland https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=4568 2012-05-03T00:00:00Z2012-05-04T00:00:00Z 2016-05-05T00:00:00Z
-> Jessica Lennox (Q55469215) Jessica Lennox https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7121 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Jessica Lennox (Q55469215) Jessica Lennox https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7121 2019-05-07T00:00:00Z
-> Peter Carlill (Q55469118) Peter Carlill https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7120 2018-05-08T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Peter Carlill (Q55469118) Peter Carlill https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7120 2019-05-07T00:00:00Z
-> Suzanne McCormack (Q55469222) Suzanne McCormack https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7123 2018-05-08T00:00:00Z NULL2019-05-02T00:00:00Z
+++ Suzanne McCormack (Q55469222) Suzanne McCormack https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7123 2019-05-03T00:00:00Z
-> Christine Towler (Q56882252) Christine Towler https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=4567 2012-05-03T00:00:00Z2012-05-04T00:00:00Z 2016-05-05T00:00:00Z
-> Jackie Shemilt (Q55469254) Jackie Shemilt https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7125 2018-05-08T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Jackie Shemilt (Q55469254) Jackie Shemilt https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7125 2019-05-07T00:00:00Z
-> Paul Wray (Q55469282) Paul Wray https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7127 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Paul Wray (Q55469282) Paul Wray https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7127 2019-05-07T00:00:00Z
-> Caroline Gruen (Q55469176) Caroline Gruen https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=4563 2012-05-03T00:00:00Z2012-05-04T00:00:00Z 2016-05-05T00:00:00Z
+++ Josie Jarosz (Q56882257) Josephine Jarosz https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=205 2004-06-11T00:00:00Z 2008-05-01T00:00:00Z
+++ Josie Jarosz (Q56882257) Josephine Jarosz https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=205 2008-05-02T00:00:00Z 2012-05-03T00:00:00Z
--- Andrea McKenna (Q58697785) Andrea McKenna https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=268 2012-05-03T00:00:00Z 2016-05-05T00:00:00Z
-> Mohammed Shahzad (Q55469247) Mohammed Shahzad https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7106 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Mohammed Shahzad (Q55469247) Mohammed Shahzad https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7106 2019-05-07T00:00:00Z
-> Wyn Kidger (Q55469199) Wyn Kidger https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7108 2018-05-08T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Wyn Kidger (Q55469199) Wyn Kidger https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7108 2019-05-07T00:00:00Z
-> Lisa Mulherin (Q55469224) Lisa Mulherin https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=253 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Lisa Mulherin (Q55469224) Lisa Mulherin https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=253 2019-05-07T00:00:00Z
+++ Adam Ogilvie (Q56884294) Adam Ogilvie https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=257 2007-05-04T00:00:00Z 2011-05-05T00:00:00Z
+++ Adam Ogilvie (Q56884294) Adam Ogilvie https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=257 2011-05-06T00:00:00Z 2015-05-07T00:00:00Z
-> Elizabeth Nash (Q55469228) Elizabeth Nash https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=256 2012-05-03T00:00:00Z2012-05-04T00:00:00Z 2016-05-05T00:00:00Z
-> Gohar Almass (Q55469084) Gohar AlmasGohar Almass https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7118 2018-05-08T00:00:00Z
-> Andrew Scopes (Q55469243) Andrew Scopes https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7119 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Andrew Scopes (Q55469243) Andrew Scopes https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7119 2019-05-07T00:00:00Z
-> Jacob Goddard (Q55469167) Jacob Goddard https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7112 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Jacob Goddard (Q55469167) Jacob Goddard https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7112 2019-05-07T00:00:00Z
+++ Lucinda Yeadon (Q56882255) Lucinda Yeadon https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=1864 2008-05-02T00:00:00Z 2012-05-03T00:00:00Z
+++ Brian Selby (Q57080790) Brian Selby https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=261 2010-05-07T00:00:00Z 2014-05-22T00:00:00Z
+++ Andrea McKenna (Q58697785) Andrea McKenna https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=268 2011-05-06T00:00:00Z 2015-05-07T00:00:00Z
-> Eileen Taylor (Q55469259) Eileen Taylor https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=1852 2012-05-03T00:00:00Z2012-05-04T00:00:00Z 2016-05-05T00:00:00Z
-> Peter Harrand (Q55469185) Peter Harrand https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=114 2018-05-03T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Peter Harrand (Q55469185) Peter Harrand https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=114 2019-05-07T00:00:00Z
+++ Christine MacNiven (Q56884298) Christine Macniven https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=2626 2011-05-06T00:00:00Z 2015-05-07T00:00:00Z
-> Ryk Downes (Q55469136) Ryk Downes https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=197 2018-05-03T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Ryk Downes (Q55469136) Ryk Downes https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=197 2019-05-07T00:00:00Z
-> Judith Elliott (Q55469143) Judith Elliott https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=234 2012-05-03T00:00:00Z2012-05-04T00:00:00Z 2016-05-05T00:00:00Z
-> Neil Walshaw (Q55469277) Neil Walshaw https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=2631 2018-05-04T00:00:00Z NULL2019-05-06T00:00:00Z
+++ Neil Walshaw (Q55469277) Neil Walshaw https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=2631 2019-05-07T00:00:00Z
+++ Jack Dunn (Q56884293) Jack Dunn https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=180 2004-06-11T00:00:00Z 2007-05-03T00:00:00Z
+++ Jack Dunn (Q56884293) Jack Dunn https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=180 2007-05-04T00:00:00Z 2011-05-05T00:00:00Z
+++ Jack Dunn (Q56884293) Jack Dunn https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=180 2011-05-06T00:00:00Z 2015-05-07T00:00:00Z

Stats

  • 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

https://morph-csv-proxy.herokuapp.com/?scraper=jacksonj04%2Fleeds-city-council-members&query=SELECT+%2A+FROM+data

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 .
    OPTIONAL {
        ?wikidata_id p:P973 ?describedAt .
        ?describedAt ps:P973 ?url .
        OPTIONAL {
            ?describedAt pq:P1810 ?name .
        }
        FILTER(CONTAINS(LCASE(STR(?url)), "democracy.leeds.gov.uk/"))
    }
}
ORDER BY ?wikidata_id

Try it!

Refresh prompt

Refresh this comparison Purge the cache

Customize (optional)