query-952fb27d86f3cb7272f86be0c2107cef

rq turtle/ttl

SPARQL query

Use at

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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
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#>
SELECT DISTINCT ?Minister, ?University ?Course ?ministerWD ?institution WHERE {
    ?ministerWD p:P39 ?ministerialPostStatement .
    ?ministerialPostStatement ps:P39 ?ministerialPost .
    ?ministerialPost wdt:P279* wd:Q83307 .
    ?ministerialPost wdt:P361 wd:Q112014
    OPTIONAL {
       ?ministerialPostStatement pq:P580 ?start_time
    }
    OPTIONAL {
        ?ministerWD p:P69 ?universityStatement .
        ?universityStatement ps:P69 ?institution .
        ?institution wdt:P31 ?possible_institutions
        OPTIONAL {
            ?universityStatement pq:P812 ?subject .      
        }
    }
    # FILTER (?start_time >= "2016-07-13"^^xsd:dat)
    FILTER (?start_time >= "1992-04-09"^^xsd:dat)
    SERVICE wikibase:label {
        bd:serviceParam wikibase:language "en" .
        ?ministerWD rdfs:label ?Minister .
        ?subject rdfs:label ?Course .
        ?institution rdfs:label ?University
    }
    VALUES ?possible_institutions {
        wd:Q3918 # University
        wd:Q2581649 # Oxford college
        wd:Q1055028 # Cambridge college
        wd:Q5146929 # Durham college
    }
}
ORDER BY ?Minister DESC(?start_time)

Query found at