User:Jacksonj04/Leeds/Prompt

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.


Comparison

@@ 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 https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=6662 Burmantofts & Richmond Hill (Q55466805) Labour Party (Q9630) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z
-> Ryan Stephenson (Q55469256) Ryan Stephenson https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=6667 Harewood (Q55466789) Conservative Party (Q9626) 2018-05-03T00:00:00Z2019-05-07T00:00:00Z
-> Kamila Maqsood (Q55469221) Kamila Maqsood https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=2291 Gipton & Harehills (Q55466757) Labour Party (Q9630) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z
--- Gerald Wilkinson (Q55469279) Gerald Wilkinson https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=222 Wetherby (Q55466810) Conservative Party (Q9626) 2019-05-07T00:00:00Z
-> John Illingworth (Q55469358) John Illingworth https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=192 Kirkstall (Q55466761) Labour Co-operative (Q6467393) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z
-> Katie Dye (Q55469142) Katie Dye https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7129 Killingbeck & Seacroft (Q55466786) Labour Party (Q9630) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z
-> Jessica Lennox (Q55469215) Jessica Lennox https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7121 Cross Gates & Whinmoor (Q55466803) Labour Party (Q9630) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z
-> Peter Carlill (Q55469118) Peter Carlill https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7120 Calverley & Farsley (Q55466776) Labour Co-operative (Q6467393) 2018-05-08T00:00:00Z2019-05-07T00:00:00Z
-> Suzanne McCormack (Q55469222) Suzanne McCormack https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7123 Garforth & Swillington (Q55466783) Garforth & Swillington Independents (Q55465979) 2018-05-08T00:00:00Z2019-05-03T00:00:00Z
-> Jackie Shemilt (Q55469254) Jackie Shemilt https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7125 Horsforth (Q55466779) Conservative Party (Q9626) 2018-05-08T00:00:00Z2019-05-07T00:00:00Z
-> Paul Wray (Q55469282) Paul Wray https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7127 Hunslet & Riverside (Q55466821) Labour Party (Q9630) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z
--- Robert Finnigan (Q56882256) Robert Finnigan https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=189 Morley North (Q55466800) Morley Borough Independents (Q55465915) 2019-05-07T00:00:00Z
-> Mohammed Shahzad (Q55469247) Mohammed Shahzad https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7106 Moortown (Q55466778) Labour Co-operative (Q6467393) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z
-> Wyn Kidger (Q55469199) Wyn Kidger https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7108 Morley South (Q55466782) Morley Borough Independents (Q55465915) 2018-05-08T00:00:00Z2019-05-07T00:00:00Z
-> Lisa Mulherin (Q55469224) Lisa Mulherin https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=253 Ardsley & Robin Hood (Q55466797) Labour Co-operative (Q6467393) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z
-> Gohar Almass (Q55469084) Gohar AlmasGohar Almass https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7118 Beeston & Holbeck (Q55466755) Labour Party (Q9630) 2018-05-08T00:00:00Z
-> Andrew Scopes (Q55469243) Andrew Scopes https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7119 Beeston & Holbeck (Q55466755) Labour Party (Q9630) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z
-> Jacob Goddard (Q55469167) Jacob Goddard https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=7112 Roundhay (Q56651558) Labour Party (Q9630) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z
-> Peter Harrand (Q55469185) Peter Harrand https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=114 Alwoodley (Q56651541) Conservative Party (Q9626) 2018-05-03T00:00:00Z2019-05-07T00:00:00Z
-> Ryk Downes (Q55469136) Ryk Downes https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=197 Otley & Yeadon (Q55466766) Liberal Democrats (Q9624) 2018-05-03T00:00:00Z2019-05-07T00:00:00Z
-> Neil Walshaw (Q55469277) Neil Walshaw https://democracy.leeds.gov.uk/mgUserInfo.aspx?UID=2631 Headingley & Hyde Park (Q55466799) Labour Party (Q9630) 2018-05-04T00:00:00Z2019-05-07T00:00:00Z

Stats

  • 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

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

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

Try it!

Refresh prompt

Refresh this comparison Purge the cache

Customize (optional)