Is there anywhere I can find data about schools in a particular area?

asked 11 Dec '10, 17:01

psychemedia's gravatar image

psychemedia ♦♦
1.1k323961
accept rate: 11%

edited 20 Jan '11, 09:37

rgrp's gravatar image

rgrp ♦♦
501122027


The TSO OpenUp Labs education page has a couple of example queries that might help?

For example, the following looks up the names of schools in the Bristol administrative district:

PREFIX sch-ont: <http://education.data.gov.uk/def/school/>

SELECT ?name WHERE {
  ?school a sch-ont:School;
  sch-ont:establishmentName ?name;
  sch-ont:districtAdministrative <http://statistics.data.gov.uk/id/local-authority-district/00HB>.
} ORDER BY ?name LIMIT 10

and this query looks up the secondary schools in the Birmingham admin district:

PREFIX sch-ont: <http://education.data.gov.uk/def/school/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT ?name  WHERE {
       ?school a sch-ont:School;
       sch-ont:establishmentName ?name;
       sch-ont:phaseOfEducation ?phaseOfEducation;
       sch-ont:districtAdministrative ?da.
       ?phaseOfEducation rdfs:label "Secondary".
       ?da rdfs:label "Birmingham".
} ORDER BY ?name LIMIT 10
link

answered 11 Dec '10, 17:45

psychemedia's gravatar image

psychemedia ♦♦
1.1k323961
accept rate: 11%

It depends what you mean by "data" and "in an area"...;-)

data.gov.uk points to an education datastore with a SPARQL endpoints at:

  • Talis: http://services.data.gov.uk/education/sparql

  • TSO: http://openuplabs.tso.co.uk/sparql/gov-education

This includes information about schools such as address, name, number of pupils, reference/administrative number/identifier, phase of education, type of establishment and more.

If you want to look up schools in a particular area, you need to identify the area in some way. The TSO OpenUp Labs website http://openuplabs.tso.co.uk/sparql/gov-education gives a few examples of how to find schools in a particular locale, such as the "administrative district of Birmingham", using the following components:

PREFIX sch-ont: <http://education.data.gov.uk/def/school/>
...
?school sch-ont:districtAdministrative ?da.
?da rdfs:label "Birmingham".

You can be more specific using an identifier for an administrative area as the following example for "City of Bristol" suggests:

?school sch-ont:districtAdministrative <http://statistics.data.gov.uk/id/local-authority-district/00HB>.

There is also a browsable HTML view over the education datastore that uses the Linked Data API at: http://education.data.gov.uk/doc/school

This can be used to build up SPARQL queries via a facet based visual query builder.

You might also want to search data.gov.uk for the term schools or education

The Guardian datastore has a few spreadsheets in its datastore relating to primary and secondary education too, such as GCSE results: http://www.guardian.co.uk/news/datablog/2010/aug/24/gcse-results-2010-exam-breakdown

Rubbish answer I'm afraid, but it was a rubbish question too...;-)

link

answered 11 Dec '10, 17:20

psychemedia's gravatar image

psychemedia ♦♦
1.1k323961
accept rate: 11%

edited 11 Dec '10, 17:33

1

I think the examples in both the answers are querying data from a DfEE database called the 'Register of Educational Establishments'. It was in NDAD until that service was shut down last year, but the CSV data can now be downloaded from TNA's Documents Online service. REE was succeeded by Edubase, which has its own site: http://www.edubase.gov.uk/ but that doesn't appear to provide data download, only queries.

(21 Jan '11, 17:16) cziwkga
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:

×13
×8
×3
×2

Asked: 11 Dec '10, 17:01

Seen: 1,293 times

Last updated: 08 Sep '11, 14:17

powered by OSQA