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)
--- 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

Stats

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

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)