Wikidata

User:Mhl20/prompts/Minsters University

< User:Mhl20


Comparison

@@ minister university course
+++ Alan Johnson None None
+++ Alistair Carmichael Aberdeen Law
+++ Alistair Darling Aberdeen Law
--- Alan Milburn University of Lancaster history
--- Alok Sharma University of Salford
-> Alun Cairns University of Wales NULL->MBA
+++ Amber Rudd Edinburgh History
+++ Andrea Leadsom Warwick Political science
+++ Andrew Adonis Oxford Modern History
+++ Andrew Lansley Exeter Politics
--- Alun Michael University of Keele philosophy
--- Alun Michael University of Keele English literature
-> Andrew Mitchell Jesus College->Cambridge history->History
--- Andrew Smith St John's College
-> Andy Burnham Fitzwilliam College->Cambridge NULL->English
--- Bernard Jenkin Corpus Christi College
-> Bob Ainsworth NULL->None NULL->None
-> Boris Johnson Balliol College->Oxford classics->Classics
+++ Caroline Spelman QMUL European Studies
+++ Cheryl Gillan University of Law ???
+++ Chris Grayling Cambridge History
--- Caroline Flint University of East Anglia
--- Catherine Ashton University of London
--- Charles Clarke King's College
--- Charles Falconer, Baron Falconer of Thoroton Queens' College
--- Chris Grayling Sidney Sussex College
--- Chris Grayling Sidney Sussex College study of history
--- Chris Huhne Magdalen College
--- Chris Smith, Baron Smith of Finsbury Pembroke College
--- Clare Short University of Keele
-> Damian Green Balliol College->Oxford NULL->PPE
--- Damian Hinds Trinity College
-> Danny Alexander St Anne's College->Oxford NULL->PPE
-> David Cameron Brasenose College->Oxford Philosophy, Politics and Economics->PPE
+++ David Davis Warwick, London Business School Molecular Science and Computer Science BSc, Business MSc
+++ David Jones UCL Law
--- David Curry Corpus Christi College
--- David Gauke St Edmund Hall
-> David Lidington Sidney Sussex College->Cambridge NULL->History
+++ David Miliband Oxford PPE
--- David Mellor Christ's College
--- David Miliband Massachusetts Institute of Technology
--- David Miliband Corpus Christi College
-> David Mundell University of Strathclyde->Edinburgh, Strathclyde Business School NULL->Law, MBA
+++ Douglas Alexander Edinburgh Politics and Modern History
--- Derek Foster, Baron Foster of Bishop Auckland
--- Derry Irvine, Baron Irvine of Lairg Christ's College
--- Dominic Raab Jesus College
--- Dominic Raab Lady Margaret Hall
-> Ed Balls Keble College->Oxford NULL->PPE
--- Ed Davey Jesus College
--- Ed Miliband Corpus Christi College
-> Elizabeth Truss Merton College->Oxford NULL->PPE
-> Eric Pickles Leeds Beckett University->Leeds Polytechnic
--- Estelle Morris, Baroness Morris of Yardley Manchester Metropolitan University
--- Esther McVey Westfield College
--- Esther McVey City, University of London
--- Francis Maude Corpus Christi College
--- Gareth Williams, Baron Williams of Mostyn Queens' College
--- Gavin Strang Churchill College
--- Geoff Hoon Jesus College
-> George Osborne Magdalen College->Oxford NULL->Modern History
+++ George Young Oxford PPE
+++ Gordon Brown Edinburgh History
--- Gillian Shephard St Hilda's College
--- Grant Shapps Manchester Metropolitan University
-> Greg Clark Magdalene College->Cambridge NULL->Economics
-> Hazel Blears Nottingham Trent University->Nottingham Trent NULL->Law
+++ Hilary Benn Sussex Russian and East European Studies
+++ Iain Duncan Smith None None
+++ Jack Straw Leeds Law
+++ James Brokenshire Exeter Law
--- Helen Liddell, Baroness Liddell of Coatdyke University of Strathclyde
--- Ian Lang, Baron Lang of Monkton Sidney Sussex College
--- Ivor Richard, Baron Richard Pembroke College
--- Jacqui Smith Hertford College
-> James Purnell Balliol College->Oxford NULL->PPE
+++ Janet Royall QMUL Spanish and French
+++ Jaqui Smith Oxford PPE
--- Janet Royall, Baroness Royall of Blaisdon Westfield College
-> Jeremy Hunt Magdalen College->Oxford NULL->PPE
-> Jim Murphy University of Strathclyde->Strathclyde NULL->Politics and European Law
+++ John Denham Southampton Chemistry
+++ John Hutton Oxford Law
+++ John Major None None
+++ John Reid Stirling History
+++ John Whittingdale UCL Economics
+++ Jonathan Hill Cambridge History
+++ Justine Greening Southampton Economics
+++ Karen Bradley Imperial Mathematics
--- Jim Wallace, Baron Wallace of Tankerness Downing College
--- John Gummer Selwyn College
--- John Hutton, Baron Hutton of Furness Magdalen College
--- John MacGregor, Baron MacGregor of Pulham Market University of St Andrews
--- John Patten, Baron Patten Sidney Sussex College
--- John Prescott University of Hull
--- John Redwood Magdalen College
--- John Wakeham, Baron Wakeham Christ Church
--- Jonathan Hill, Baron Hill of Oareford Trinity College
-> Kenneth Clarke Gonville and Caius College->Cambridge NULL->Law
+++ Liam Fox Glasgow Medicine
-> Margaret Beckett University of Manchester Institute of Science and Technology->Manchester NULL->Metallurgy
+++ Maria Miller LSE Economics
--- Margaret Jay, Baroness Jay of Paddington Somerville College
--- Matt Hancock Christ's College
--- Matt Hancock Exeter College
-> Michael Fallon University of St Andrews->St Andrews NULL->Classics & Ancient History
--- Michael Forsyth, Baron Forsyth of Drumlean University of St Andrews
-> Michael Gove Lady Margaret Hall->Oxford NULL->English
+++ Michael Moore Edinburgh Politics and Modern History
+++ Natalie Evans Cambridge Social and political sciences
--- Michael Heseltine Pembroke College
--- Michael Howard Peterhouse
--- Michael Meacher New College
--- Michael Portillo Peterhouse
--- Mo Mowlam Trevelyan College
--- Natalie Evans, Baroness Evans Murray Edwards College
-> Nicky Morgan St Hugh's College->Oxford NULL->Jurisprudence
--- Oliver Dowden Trinity Hall
--- Oliver Heald Pembroke College
--- Oliver Letwin Trinity College
-> Owen Paterson Corpus Christi College->Cambridge NULL->History
+++ Patricia Hewitt Cambridge English
+++ Patrick McLoughlin None None
+++ Peter Hain QMUL Economics and Political Science
--- Patricia Hewitt Newnham College
--- Patricia Hewitt Nuffield College
--- Patrick Mayhew, Baron Mayhew of Twysden Balliol College
--- Paul Murphy Oriel College
--- Penny Mordaunt University of Reading
--- Peter Brooke, Baron Brooke of Sutton Mandeville Balliol College
-> Peter Mandelson St Catherine's College->Oxford NULL->PPE
-> Philip Hammond University College->Oxford Philosophy, Politics and Economics->PPE
-> Priti Patel University of Keele->Keele economics->Economics, Sociology and Social Anthropology
+++ Sajid Javid Exeter Economics and Political Science
--- Richard Caborn Sheffield Hallam University
--- Rishi Sunak Lincoln College Philosophy, Politics and Economics
--- Robert Gascoyne-Cecil, 7th Marquess of Salisbury Christ Church
--- Robert Jenrick St John's College
--- Roger Freeman, Baron Freeman Balliol College
--- Ron Davies University of Portsmouth
--- Ruth Kelly The Queen's College
--- Sarah Teather St John's College
-> Shaun Woodward Jesus College->Cambridge NULL->English
+++ Stephen Crabb Bristol Politics
--- Sir George Young Christ Church
--- Stephen Barclay Peterhouse
--- Stephen Dorrell Brasenose College
-> Theresa May St Hugh's College->Oxford geography->Geography
-> Theresa Villiers Jesus College->Bristol NULL->Law
+++ Thomas Galbraith UEA Modern Languages and European Studies
+++ Tina Stowell None None
--- Thomas Galbraith, 2nd Baron Strathclyde University of East Anglia
--- Thérèse Coffey Somerville College
-> Tony Blair St John's College->Oxford jurisprudence->Law
--- Valerie Amos, Baroness Amos University of East Anglia
-> Vince Cable Fitzwilliam College->Cambridge NULL->Economics
-> William Hague Magdalen College->Oxford Philosophy, Politics and Economics->PPE
--- William Waldegrave, Baron Waldegrave of North Hill Corpus Christi College
-> Yvette Cooper Balliol College->Oxford Philosophy, Politics and Economics->PPE

Stats

  • Items only found in SPARQL (--- in the first column): 84
  • Items only found in CSV (+++ in the first column): 41
  • Items that differ between sources (→ in the first column): 35
  • Total items in SPARQL: 119
  • Total items in CSV: 76

External source

https://docs.google.com/a/mysociety.org/spreadsheets/d/1IflGy2dvr27_jIhCKaMlywqjtG27uO_o2hDoPGt-QrY/gviz/tq?tqx=out:csv&gid=103237000

SPARQL query

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:dateTime)
    FILTER (?start_time >= "1992-04-09"^^xsd:dateTime)
    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)
Try it!

Refresh prompt

Refresh this comparison Purge the cache

Customize (optional)


Retrieved from "https://www.wikidata.org/w/index.php?title=User:Mhl20/prompts/Minsters_University&oldid=541238975"