User:Mhl20/prompts/Minsters University
Jump to navigation
Jump to search
Try it!
Comparison
@@ | minister | university | course |
---|---|---|---|
+++ | Alan Johnson | None | None |
+++ | Alistair Carmichael | Aberdeen | Law |
+++ | Alistair Darling | Aberdeen | Law |
--- | Alex Chalk | Magdalen College | |
--- | Alex Chalk | City, University of London | |
-> | 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 | Cardiff Metropolitan University | |
--- | Alun Michael | University of Keele | philosophy |
--- | Alun Michael | University of Keele | English literature |
--- | Andrew Adonis, Baron Adonis | Christ Church | |
--- | Andrew Adonis, Baron Adonis | Keble College | |
-> | Andrew Mitchell | Jesus College->Cambridge | history->History |
--- | Andrew Robathan | Oriel College | |
--- | Andrew Smith | St John's College | |
--- | Andrew Stephenson | Royal Holloway, University of London | |
-> | Andy Burnham | Fitzwilliam College->Cambridge | NULL->English |
+++ | Bob Ainsworth | None | None |
--- | Ann Taylor, Baroness Taylor of Bolton | University of Bradford | |
--- | Ben Gummer | St John's College | |
--- | Ben Gummer | Peterhouse | |
--- | Beverley Hughes | University of Manchester | |
-> | Boris Johnson | Balliol College->Oxford | classics->Classics |
+++ | Caroline Spelman | QMUL | European Studies |
+++ | Cheryl Gillan | University of Law | ??? |
+++ | Chris Grayling | Cambridge | History |
--- | Bridget Phillipson | Hertford College | |
--- | Caroline Flint | University of East Anglia | |
--- | 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 Heaton-Harris | University of Wolverhampton | |
--- | Chris Huhne | Magdalen College | |
--- | Chris Huhne | University of Paris | |
--- | Chris Philp | University College, Oxford | |
--- | Chris Smith, Baron Smith of Finsbury | Pembroke College | |
--- | Claire Coutinho | Exeter College | |
--- | Clare Short | University of Keele | |
-> | Damian Green | Balliol College->Oxford | NULL->PPE |
--- | Damian Hinds | Trinity College, Oxford | |
-> | Danny Alexander | St Anne's College->Oxford | NULL->PPE |
--- | Darren Jones | University of Plymouth | |
-> | 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 Clark, Baron Clark of Windermere | University of Manchester | |
--- | David Clark, Baron Clark of Windermere | Victoria University of Manchester | |
--- | David Frost | St John's College | |
--- | David Gauke | St Edmund Hall | |
--- | David Hanson | University of Hull | |
--- | David Heathcoat-Amory | Christ Church | |
--- | David Laws | King's College | |
-> | David Lidington | Sidney Sussex College->Cambridge | NULL->History |
+++ | David Miliband | Oxford | PPE |
+++ | David Mundell | Edinburgh, Strathclyde Business School | Law, MBA |
+++ | Douglas Alexander | Edinburgh | Politics and Modern History |
--- | David Mellor | Christ's College | |
--- | David Miliband | Massachusetts Institute of Technology | |
--- | David Miliband | Corpus Christi College | |
--- | David Willetts | Christ Church | |
--- | 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 |
+++ | Elizabeth Truss | Oxford | PPE |
--- | Ed Davey | Jesus College | |
--- | Ed Miliband | Corpus Christi College | |
--- | Edward Argar | Oriel College | |
-> | Eric Pickles | Leeds Beckett University->Leeds Polytechnic | |
--- | Esther McVey | University of London | |
--- | Esther McVey | City, University of London | |
--- | Esther McVey | Westfield College | |
--- | Francis Maude | Corpus Christi College | |
--- | Gareth Williams, Baron Williams of Mostyn | Queens' College | |
--- | Gavin Williamson | University of Bradford | |
--- | Geoff Hoon | Jesus College | |
--- | Geoffrey Robinson | Clare College | |
-> | George Osborne | Magdalen College->Oxford | NULL->Modern History |
-> | George Young | Christ Church->Oxford | NULL->PPE |
+++ | Gordon Brown | Edinburgh | History |
--- | Gillian Shephard | St Hilda's College | |
--- | Graham Stuart | Selwyn College | |
-> | Greg Clark | Magdalene College->Cambridge | NULL->Economics |
--- | Greg Hands | Robinson College | |
--- | Gregory Barker | Royal Holloway, University of London | |
-> | 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 |
--- | Ian Lang, Baron Lang of Monkton | Sidney Sussex College | |
--- | Ivor Richard, Baron Richard | Pembroke College | |
--- | Jack Cunningham, Baron Cunningham of Felling | College of St Hild and St Bede | |
--- | Jacob Rees-Mogg | Trinity College, Oxford | |
--- | Jacqui Smith | Hertford College | |
--- | James Cleverly | University of West London | |
-> | 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 | Philosophy, Politics and Economics->PPE |
+++ | Jim Murphy | Strathclyde | 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 |
--- | Jeremy Quin | Hertford College | |
--- | Jesse Norman | Merton College | |
--- | Jo Johnson | Balliol College | |
--- | Jo Stevens | University of Manchester | |
--- | Jo Stevens | Victoria University of Manchester | |
--- | Joan Lestor, Baroness Lestor of Eccles | University of London | |
--- | John Glen | Fitzwilliam College | |
--- | John Glen | Mansfield College | |
--- | John Gummer | Selwyn College | |
--- | John Healey | Christ's College | |
--- | John Hutton, Baron Hutton of Furness | Magdalen College | |
--- | John Patten, Baron Patten | Sidney Sussex College | |
--- | John Prescott | University of Hull | |
--- | John Redwood | Magdalen College | |
--- | John Spellar | St Edmund Hall | |
--- | John Wakeham, Baron Wakeham | Christ Church | |
--- | Jon Trickett | University of Hull | |
--- | Jonathan Aitken | Christ Church | |
--- | Jonathan Hill, Baron Hill of Oareford | Trinity College | |
--- | Jonathan Reynolds | University of Manchester | |
--- | Keir Starmer | St Edmund Hall | |
-> | Kenneth Clarke | Gonville and Caius College->Cambridge | NULL->Law |
+++ | Liam Fox | Glasgow | Medicine |
--- | Kit Malthouse | Newcastle University | |
--- | Kwasi Kwarteng | Trinity College | |
--- | Liam Byrne | Victoria University of Manchester | |
--- | Lisa Nandy | Newcastle University | |
--- | Liz Kendall | Queens' College | |
--- | Liz Truss | Merton College | Philosophy, Politics and Economics |
--- | Lucy Frazer | Newnham College | |
--- | Lucy Powell | Somerville College | |
--- | Lynda Chalker, Baroness Chalker of Wallasey | University of Westminster | |
-> | Margaret Beckett | University of Manchester Institute of Science and Technology->Manchester | NULL->Metallurgy |
+++ | Maria Miller | LSE | Economics |
+++ | Michael Fallon | St Andrews | Classics & Ancient History |
--- | Margaret Jay, Baroness Jay of Paddington | Somerville College | |
--- | Mark Harper | Brasenose College | |
--- | Matt Hancock | Exeter College | |
--- | Matt Hancock | Christ's College | |
--- | Mel Stride | St Edmund Hall | |
-> | 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 | |
--- | Mike Penning | University of Reading | |
--- | Mo Mowlam | Trevelyan College | |
--- | Nadine Dorries | ||
--- | Natalie Evans, Baroness Evans | Murray Edwards College | |
--- | Nicholas True, Baron True | Peterhouse | |
--- | Nick Clegg | Robinson College | |
--- | Nick Harvey | Middlesex University | |
-> | Nicky Morgan | St Hugh's College->Oxford | NULL->Jurisprudence |
+++ | Owen Paterson | Cambridge | History |
+++ | Patricia Hewitt | Cambridge | English |
+++ | Patrick McLoughlin | None | None |
+++ | Peter Hain | QMUL | Economics and Political Science |
--- | Oliver Dowden | Trinity Hall | |
--- | Oliver Letwin | Trinity College | |
--- | Owen Paterson | Corpus Christi College | |
--- | Owen Paterson | University of Northampton | |
--- | Patricia Hewitt | Newnham College | |
--- | Patricia Hewitt | Nuffield College | |
--- | Patrick Mayhew, Baron Mayhew of Twysden | Balliol College | |
--- | Paul Murphy | Oriel College | |
--- | Pauline Neville-Jones, Baroness Neville-Jones | Lady Margaret Hall | |
--- | 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->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 |
--- | Rachel Reeves | New College | |
--- | 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 | |
--- | Rory Stewart | Balliol College | |
--- | Ruth Kelly | The Queen's College | |
--- | Shabana Mahmood | Lincoln College | |
-> | Shaun Woodward | Jesus College->Cambridge | NULL->English |
+++ | Stephen Crabb | Bristol | Politics |
--- | Simon Clarke | University College, Oxford | |
--- | Stephen Dorrell | Brasenose College | |
--- | Stephen McPartland | ||
--- | Stephen Timms | Emmanuel College | |
--- | Steve Baker | St Cross College | |
--- | Steve Barclay | Peterhouse | |
--- | Suella Braverman | Queens' College | law |
-> | 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 | |
--- | Tina Stowell, Baroness Stowell of Beeston | Murray Edwards College | |
--- | Tom Tugendhat | Gonville and Caius College | Islamic studies |
--- | Tom Watson | University of Hull | |
-> | Tony Blair | St John's College->Oxford | jurisprudence->Law |
--- | Tony McNulty | Virginia Tech | |
--- | Tony Newton, Baron Newton of Braintree | Trinity College, Oxford | Philosophy, Politics and Economics |
--- | Valerie Amos, Baroness Amos | University of East Anglia | |
--- | Vernon Coaker | Nottingham Trent University | |
--- | Vicky Ford | Trinity College | |
--- | Victoria Atkins | Corpus Christi College | |
-> | Vince Cable | Fitzwilliam College->Cambridge | NULL->Economics |
--- | Wes Streeting | Selwyn College | |
-> | 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): 151 - Items only found in CSV (
+++
in the first column): 46 - Items that differ between sources (→ in the first column): 30
- Total items in SPARQL: 181
- Total items in CSV: 76
External source
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)
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