User:Oravrattas/prompts/Seat Count
Jump to navigation
Jump to search
Try it!
Comparison
Stats
- Items only found in SPARQL (
---
in the first column): 6 - Items only found in CSV (
+++
in the first column): 116 - Items that differ between sources (→ in the first column): 15
- Total items in SPARQL: 162
- Total items in CSV: 272
External source
SPARQL query
SELECT DISTINCT (STRAFTER(STR(?location), STR(wd:)) AS ?country) (STRAFTER(STR(?item), STR(wd:)) AS ?legislature) (xsd:integer(?seatcount) AS ?seats)
WHERE {
VALUES ?type { wd:Q10553309 wd:Q140247 }
?location wdt:P31 wd:Q6256 .
?item wdt:P31/wdt:P279* ?type ; wdt:P1001 ?location .
FILTER NOT EXISTS { ?item wdt:P576 [] } . # no end date
OPTIONAL { ?item wdt:P1342 ?seatcount }
}
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