User:Oravrattas/prompts/Scottish Parliament
Jump to navigation
Jump to search
Try it!
This prompt compares the Wikidata information on current MSPs, with the data from TheyWorkForYou (Q7783633).
Comparison
Stats
- Items only found in SPARQL (
---
in the first column): 2 - Items only found in CSV (
+++
in the first column): 2 - Items that differ between sources (→ in the first column): 11
- Total items in SPARQL: 129
- Total items in CSV: 129
External source
SPARQL query
SELECT DISTINCT ?wikidata ?wikidata_group ?area ?gender ?twitter ?facebook WHERE {
?wikidata p:P39 ?mem.
?mem ps:P39 wd:Q30580546.
OPTIONAL { ?mem pq:P4100|pq:P102 ?wikidata_group. }
OPTIONAL { ?mem pq:P768 ?raw_area. }
OPTIONAL { ?wikidata wdt:P21 ?raw_gender }
OPTIONAL { ?wikidata wdt:P2002 ?twitter }
OPTIONAL { ?wikidata wdt:P2013 ?facebook }
FILTER NOT EXISTS { ?mem pq:P582 [] }
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en".
?raw_gender rdfs:label ?gender .
?raw_area rdfs:label ?area .
}
}
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