User:Jacksonj04/prompts/South Africa/Assembly/Peoples Assembly/Term/26
Jump to navigation
Jump to search
Try it!
This compares Wikidata's list of the members of the 26th National Assembly to that at https://www.pa.org.za/position/member/parliament/national-assembly/?session=na26.
n.b. The "name" column here specifically refers to the subject named as (P1810) qualifier given on the described at URL (P973) property referring to their "pa.org.za" URL.
Comparison
Stats
- Items only found in SPARQL (
---
in the first column): 6 - Items only found in CSV (
+++
in the first column): 1 - Items that differ between sources (→ in the first column): 9
- Total items in SPARQL: 507
- Total items in CSV: 502
External source
https://www.pa.org.za/position/member/parliament/national-assembly/?session=na26&format=csv
SPARQL query
SELECT DISTINCT ?identifier__wikidata ?name ?source (REPLACE(STR(?start),"T00:00:00Z","") AS ?start_date) (REPLACE(STR(?end),"T00:00:00Z","") AS ?end_date) WHERE {
?identifier__wikidata p:P39 ?statement.
?statement ps:P39 wd:Q16744266; pq:P2937 wd:Q18109299 .
OPTIONAL { ?statement pq:P580 ?start }
OPTIONAL { ?statement pq:P582 ?end }
OPTIONAL {
?identifier__wikidata p:P973 ?describedAtPA .
?describedAtPA ps:P973 ?source .
OPTIONAL {
?describedAtPA pq:P1810 ?name .
}
FILTER(CONTAINS(LCASE(STR(?source)), "pa.org.za/"))
}
}
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