User:Oravrattas/prompts/Argentina/Senate
This compares Wikidata's list of the current members of the Senate to that at http://www.senado.gov.ar/senadores/listados/listaSenadoRes (via EveryPolitician.org)
Comparison
Stats
- Items only found in SPARQL (
---in the first column): 19 - Items only found in CSV (
+++in the first column): 32 - Items that differ between sources (→ in the first column): 6
- Total items in SPARQL: 59
- Total items in CSV: 72
External source
SPARQL query
SELECT DISTINCT ?wikidata ?wikidata_area ?wikidata_group WHERE {
?wikidata p:P39 ?statement .
?statement ps:P39 [ wdt:P279* wd:Q18711738 ] ; pq:P580 ?start .
OPTIONAL { ?statement pq:P768 ?wikidata_area }
OPTIONAL { ?statement pq:P4100 ?wikidata_group }
OPTIONAL { ?statement pq:P582 ?mem_end }
BIND(COALESCE(?mem_end, "3001-01-01T00:00:00Z"^^xsd:dateTime) as ?end)
FILTER (?end > NOW())
}
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