Does anyone know of a data query service where I can look up UK HEIs by Mission group?

  • Russell Group
  • 1994 Group
  • Million+
  • University Alliance - Business-focused universities, a mix of pre- and post-1992 institutions.
  • GuildHE

and ideally get back HEI full name, shortname and UCAS code (or some other form of standard identifier)

asked 12 Sep '11, 16:36

psychemedia's gravatar image

psychemedia ♦♦
1.1k323961
accept rate: 11%


Following a bit of digging, here are a couple of ways of discovering universities by group, which arguably vary in trustworthiness...

The first approach is to make use of a spreadsheet on the Guardian datastore that contains columns relating to universities and mission groups. I found one sheet detailing university fees that contains these two columns

We can write a query on the spreadhsheet using the Google visualisation API to get the data out as a preview table or as CSV, using the form:

To get a CSV output, change the tqx=out:html fragment in the URL to tqx=out:csv

Note that there are no guarantees that all universities are listed, or that the ones that are correctly (if at all) identified as a member of a particular group.

The second approach is to use the JISC Monitoring Unit API, which presumably is authoritative?

A Linked Data endpoint to the data is available at http://api.talis.com/stores/jisc-prod-dev1/services/sparql (I don't know if the data in this store is maintained, though?)

I think this query will return all the universities and the various groups they are associated with [example]:

PREFIX mu:   <http://www.jiscmu.ac.uk/schema/muweb/>
SELECT DISTINCT ?name ?group
WHERE {  
?muOrg a <http://www.jiscmu.ac.uk/schema/muweb/Organisation> .
?muOrg mu:Sector "Higher Education" .
?muOrg mu:OfficialName ?name .
?muOrg <http://purl.org/dc/dcam/memberOf> ?group.
}

To just get a list of the different group options [example]:

PREFIX mu:   <http://www.jiscmu.ac.uk/schema/muweb/>
SELECT DISTINCT ?group
WHERE {  
?muOrg a <http://www.jiscmu.ac.uk/schema/muweb/Organisation> .
?muOrg mu:Sector "Higher Education" .
?muOrg <http://purl.org/dc/dcam/memberOf> ?group.
}

The following query should return institutions by a particular group, along with UCAS and HESA codes [example]:

PREFIX mu:   <http://www.jiscmu.ac.uk/schema/muweb/>
SELECT DISTINCT ?name ?ucas ?hesa
WHERE {  
?muOrg a <http://www.jiscmu.ac.uk/schema/muweb/Organisation> .
?muOrg mu:Sector "Higher Education" .
?muOrg mu:OfficialName ?name .
?muOrg mu:hesaCode ?hesa .
?muOrg mu:ucasCode ?ucas .
?muOrg <http://purl.org/dc/dcam/memberOf> "1994 group".
}

To actually run the queries and get data out, I use SparqlProxy (http://data-gov.tw.rpi.edu/ws/sparqlproxy.php):

  1. Under option 1, in the SPARQL service (URL) field, enter http://api.talis.com/stores/jisc-prod-dev1/services/sparql
  2. Paste the SPARQL query into the query box
  3. Select the output type (e.g. HTML or CSV)
  4. Hit the query button
link

answered 13 Sep '11, 10:24

psychemedia's gravatar image

psychemedia ♦♦
1.1k323961
accept rate: 11%

edited 13 Sep '11, 10:39

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×8
×5

Asked: 12 Sep '11, 16:36

Seen: 1,425 times

Last updated: 13 Sep '11, 10:39

powered by OSQA