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 _:t1669624716 _:t1669624717
--- 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
--- 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
+++ 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
--- 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
+++ 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
--- Andrea McKenna (Q58697785) Andrea McKenna https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=268 2012-05-03T00:00:00Z 2016-05-05T00: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
+++ David Congreve (Q55726340) David Congreve https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=211 2010-05-07T00:00:00Z 2014-05-22T00: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
+++ Lucinda Yeadon (Q56882255) Lucinda Yeadon https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=1864 2008-05-02T00:00:00Z 2012-05-03T00: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
+++ 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
+++ 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
+++ 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
+++ 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
+++ 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
+++ 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
+++ 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

Stats

  • 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

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)