From Wikidata
Jump to navigation Jump to search

This compares current members of the Council.

You might want to see the Prompt of all scraped councillor terms.


@@ wikidata_id (SPARQL) wikidata_id (CSV) name (SPARQL) name (CSV) url (SPARQL) url (CSV) ward_id (SPARQL) ward_id (CSV) party_id (SPARQL) party_id (CSV) start (SPARQL) start (CSV) end (SPARQL) end (CSV)
-> Denise Ragan (Q55469237) Denise Ragan Burmantofts & Richmond Hill (Q55466805) Labour Party (Q9630) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z
-> Ryan Stephenson (Q55469256) Ryan Stephenson Harewood (Q55466789) Conservative Party (Q9626) 2018-05-03T00:00:00Z2019-05-07T00:00:00Z
-> Kamila Maqsood (Q55469221) Kamila Maqsood Gipton & Harehills (Q55466757) Labour Party (Q9630) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z
--- Gerald Wilkinson (Q55469279) Gerald Wilkinson Wetherby (Q55466810) Conservative Party (Q9626) 2019-05-07T00:00:00Z
-> John Illingworth (Q55469358) John Illingworth Kirkstall (Q55466761) Labour Co-operative (Q6467393) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z
-> Katie Dye (Q55469142) Katie Dye Killingbeck & Seacroft (Q55466786) Labour Party (Q9630) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z
-> Jessica Lennox (Q55469215) Jessica Lennox Cross Gates & Whinmoor (Q55466803) Labour Party (Q9630) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z
-> Peter Carlill (Q55469118) Peter Carlill Calverley & Farsley (Q55466776) Labour Co-operative (Q6467393) 2018-05-08T00:00:00Z2019-05-07T00:00:00Z
-> Suzanne McCormack (Q55469222) Suzanne McCormack Garforth & Swillington (Q55466783) Garforth & Swillington Independents (Q55465979) 2018-05-08T00:00:00Z2019-05-03T00:00:00Z
-> Jackie Shemilt (Q55469254) Jackie Shemilt Horsforth (Q55466779) Conservative Party (Q9626) 2018-05-08T00:00:00Z2019-05-07T00:00:00Z
-> Paul Wray (Q55469282) Paul Wray Hunslet & Riverside (Q55466821) Labour Party (Q9630) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z
--- Robert Finnigan (Q56882256) Robert Finnigan Morley North (Q55466800) Morley Borough Independents (Q55465915) 2019-05-07T00:00:00Z
-> Mohammed Shahzad (Q55469247) Mohammed Shahzad Moortown (Q55466778) Labour Co-operative (Q6467393) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z
-> Wyn Kidger (Q55469199) Wyn Kidger Morley South (Q55466782) Morley Borough Independents (Q55465915) 2018-05-08T00:00:00Z2019-05-07T00:00:00Z
-> Lisa Mulherin (Q55469224) Lisa Mulherin Ardsley & Robin Hood (Q55466797) Labour Co-operative (Q6467393) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z
-> Gohar Almass (Q55469084) Gohar AlmasGohar Almass Beeston & Holbeck (Q55466755) Labour Party (Q9630) 2018-05-08T00:00:00Z
-> Andrew Scopes (Q55469243) Andrew Scopes Beeston & Holbeck (Q55466755) Labour Party (Q9630) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z
-> Jacob Goddard (Q55469167) Jacob Goddard Roundhay (Q56651558) Labour Party (Q9630) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z
-> Peter Harrand (Q55469185) Peter Harrand Alwoodley (Q56651541) Conservative Party (Q9626) 2018-05-03T00:00:00Z2019-05-07T00:00:00Z
-> Ryk Downes (Q55469136) Ryk Downes Otley & Yeadon (Q55466766) Liberal Democrats (Q9624) 2018-05-03T00:00:00Z2019-05-07T00:00:00Z
-> Neil Walshaw (Q55469277) Neil Walshaw Headingley & Hyde Park (Q55466799) Labour Party (Q9630) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z


  • Items only found in SPARQL (--- in the first column): 2
  • Items only found in CSV (+++ in the first column): 0
  • Items that differ between sources (→ in the first column): 19
  • Total items in SPARQL: 100
  • Total items in CSV: 98

External source

SPARQL query

SELECT ?wikidata_id ?name ?url ?ward_id ?party_id ?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:P4100 ?party_id }
    OPTIONAL { ?node pq:P580 ?start }
    OPTIONAL { ?node pq:P768 ?ward_id }
    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)), ""))
    FILTER(!BOUND(?end) || ?end > NOW())
ORDER BY ?wikidata_id

Try it!

Refresh prompt

Refresh this comparison Purge the cache

Customize (optional)