User:Jacksonj04/Leeds/Prompt

This compares current members of the Council.

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

Warning:

There was an error the last time this prompt was refreshed:

There was an error fetching: https://morph-csv-proxy.herokuapp.com/?scraper=jacksonj04%2Fleeds-city-council-members&query=SELECT+%2A+FROM+data+WHERE+current+%3D+1 - the error was: 404 Not Found

This means that the content below may be out of date.

Common problems that you might want to check include:

That the URL of the CSV file is really a valid CSV file
That the SPARQL query succeeds and returns results

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