User:Jacksonj04/Leeds/Prompt/All
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.
 | Warning:
There was an error the last time this prompt was refreshed:
This means that the content below may be out of date. Common problems that you might want to check include:
|
Comparison
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
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
Refresh prompt
Customize (optional)
- edit external source for this prompt.
- edit SPARQL for this prompt.
- edit header template
- edit footer template
- edit row added template
- edit row removed template
- edit row modified template
- edit stats template