query-163ad309b11ff7e48cc74cb4a8022f6c

rq turtle/ttl

MPs who began their career at a by-election since 1945

note that party data is at time of election, & is not usually available before 1997 (yet!)

some are tied to a specific by-election, others generic; this is being updated as we go along

SELECT DISTINCT ?MP ?MPLabel ?start ?constituencyLabel ?partyLabel ?electionLabel { ?membership wdt:P279 wd:Q16707842 . ?MP p:P39 ?positionStatement . ?positionStatement ps:P39 ?membership . ?positionStatement pq:P768 ?constituency . optional { ?positionStatement pq:P4100 ?party } . ?positionStatement pq:P580 ?start . ?positionStatement pq:P2715 ?election . filter not exists { ?election wdt:P31 wd:Q15283424 } # this finds all people who held an MP role but were not elected at a general election filter not exists { ?membership2 wdt:P279 wd:Q16707842 . ?MP p:P39 ?positionStatement2 . ?positionStatement2 ps:P39 ?membership2 . ?positionStatement2 pq:P580 ?start2 . FILTER (?start2 < ?start) . } # ...and where they are not recorded as having ever served in Parliament before FILTER (?start >= "1945-07-05T00:00:00Z"^^xsd:dateTime) . # limits it to only after the date of the 1945 general election SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' } } ORDER BY ?start

Use at

• https://query.wikidata.org/sparql

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# MPs who began their career at a by-election since 1945
# note that party data is at time of election, & is not usually available before 1997 (yet!)
# some are tied to a specific by-election, others generic; this is being updated as we go along
SELECT DISTINCT ?MP ?MPLabel ?start ?constituencyLabel ?partyLabel ?electionLabel 
 {
 ?membership wdt:P279 wd:Q16707842 .
 ?MP p:P39 ?positionStatement . ?positionStatement ps:P39 ?membership . 
 ?positionStatement pq:P768 ?constituency .
 optional { ?positionStatement pq:P4100 ?party } . 
 ?positionStatement pq:P580 ?start .
 ?positionStatement pq:P2715 ?election . filter not exists { ?election wdt:P31 wd:Q15283424 } 
 # this finds all people who held an MP role but were not elected at a general election
 filter not exists { ?membership2 wdt:P279 wd:Q16707842 . 
    ?MP p:P39 ?positionStatement2 . ?positionStatement2 ps:P39 ?membership2 . 
    ?positionStatement2 pq:P580 ?start2 . FILTER (?start2 < ?start) . } 
 # ...and where they are not recorded as having ever served in Parliament before
 FILTER (?start >= "1945-07-05T00:00:00Z"^^xsd:dateTime) . 
 # limits it to only after the date of the 1945 general election
 SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
}
ORDER BY ?start

Query found at

• https://www.wikidata.org/wiki/Wikidata:WikiProject_British_Politicians/Sample_Queries