Education Datasets and Resources

Education is one of the featured themes of the second Hack the City.  Hacks to help parents with any of the following are eligible for the Open Data Challenge Series, and a stab at £5k to £50k in development prizes:

  1. Finding or expressing a preference for a school
  2. Choosing a subject or other learning priorities
  3. Engaging with their children’s learning

To help, the ODI and Nesta have compiled a great suite of datasets.  These are summarised below to give an idea of the scope of data available.

The full list, including individual download links, are on this Google spreadsheet.  Most of them are provided with some handy context information.  The spreadsheet also has some a bunch of ideas for inspiration on apps and hacks that could be prototyped.

Thanks to Chris Hopkinson for trawling the list and compiling a comprehensive archive of the core education data. You can download the 350Mb of recent datasets from Dropbox. We’ll have these available on a local filestore for Hack the City to avoid download congestion on the day. We’re also planning to get them into the Gangplank platform, so you should also be able to review the data schemas across the suite more easily.

Schools performance datasets School performance data at all key stages. Data covers: school performance, characteristics and spend per pupil data and for academies, their latest set of financial accounts. Entry level qualifications and attainment datasets available here too
Location of educational establishments Grid referenced location of educational establishments Source: Department for Education and Skills (DfES), ONS Access to Services Team Publisher: Neighbourhood Statistics Geographies: Grid Reference Geographic coverage: England Time coverage: 2003, 2005 Type of data: Administrative data Notes: The information presented here provides details on primary and middle deemed primary Local Education Authority maintained schools in England.
Pupil Absence in Schools in England This Statistical First Release reports on absence in primary and secondary schools, city technology colleges and academies.
Admission Appeals for Maintained Primary and Secondary Schools in England This SFR provides information about appeals lodged by parents during the academic year against non-admission of their children to their preferred school. It includes all appeals lodged during the academic year across all year groups. Figures are provided at both national and local authority level.
Destinations of Key Stage 4 and Key Stage 5 pupils Education destination measures will show the percentage of students progressing to further learning in a school, further education or 6th form college, apprenticeship or higher education institution a year after they have left school or college.
Qualification success rates for school sixth forms: 2011 to 2012 This statistical first release provides experimental statistics on qualification success rates (QSRs) for state-funded school and academy sixth forms in England. QSRs measure the proportion of academic and vocational learning aims, for 16- to 19-year-olds, that are started, finished and completed successfully. This is the first release on QSRs and it is the first year that national figures for QSRs have been published. QSRs are provided for learning aims at levels 1, 2, 3 and ‘4 or higher’ that were completed in the 2011 to 2012 academic year.
Permanent and fixed period exclusions from schools in England: 2011 to 2012 academic year This statistical first release (SFR) provides information about exclusions from schools and exclusion appeals in England during 2011 to 2012
Secondary School Applications and Offers in England Information about secondary school applications and offers received by parents on National Offer Day as provided by local authorities.
School Capacity: Information on the number of places and the number of pupils in maintained Primary and Secondary schools and Academies
Special Educational Needs in England Provides information on the incidence and placement of pupils with SEN together with analyses on the characteristics of pupils by their stage of SEN
OPSN data on school performance at KS4 (GCSE). Focuses on quality of teaching in secondary schools across England detailing improvemnets in schools, subject entries, subject attainment. Also includes a link to a report summarising findings and patterns
Edubase EduBase is a register of educational establishments in England and Wales, maintained by the Department for Education. It provides information on establishments providing compulsory, higher and further education. EduBase offers a number of different services allowing you full access to the data, please contact our service desk for further information. Services range from infrequent or frequent access to data extracts, to the provision of specific tailor made datasets.
Attainment by Pupil Characteristics Attainment at all key stages, by Pupil Characteristics (specifically gender, ethnicity, eligibility for free school meals (FSM), special educational needs (SEN) and English as a first language)
National Curriculum Assessments at Key Stage 2 in England Provides provisional information on the achievements of eligible pupils (typically 11 year olds) in the National Curriculum assessments at Key Stage 2 and 3 (KS2 and KS3). At KS2, assessments are based on tests and teacher assessments. At KS3, there are only teacher assessments as formal tests have been abolished.
Income and expenditure in local authority maintained schools in England: 2011-12 A national summary of schools’ income and expenditure for the financial year 2011 to 2012, utilising the full range of data schools provide to the Department for Education in their consistent financial reporting returns.
GCSE and Equivalent Results, England Provides the earliest information on the overall achievements of young people in GCSE and equivalent examinations.
A level and other level 3 results in England: academic year 2012 to 2013 (provisional) This release provides advanced level results (A level and other level 3 results) of young people (aged 16 to 19) in England.
Participation in education, training and employment by 16- to 18-year-olds in England, end 2012 This Statistical First Release (SFR) provides provisional end 2012 estimates
of participation in education, training and employment and those who are not
in education, employment or training (NEET) for 16, 17 and 18 year olds in
England. It also updates the end 2011 estimates from SFR 12/2012 published
in February 2013.
Youth Cohort Study & Longitudinal Study of Young People in England Statistics based on survey responses to YCS and LSYPE and brings together data about the family environment, attitudes to school, risky behaviours, engagement, attainment and post-16 participation. This publication reports on the same group of young people annually until age 19. The current group is now 19 and will be reported on in July 2011. A new study has not yet been commissioned and no publication is scheduled for 2012.
Open Street Map Full open street map datasets
Daily pollutant levels Maximum pollutant levels recorded for the 24 period Source: UK National Air Quality Information Archive Publisher: UK Air Quality Archive Geographies: Site Geographic coverage: England Time coverage: 2008 Type of data: Administrative data
Road transport energy consumption at regional and local authority level Consumption statistics for fuels used in road transport at regional and local levels are available below. In March 2008, this dataset gained National Statistics status. This applies to all data from 2005 onwards. Please note that the 2002, 2003 and 2004 datasets are still classed as experimental statistics.
Traffic, Speeds and Congestion
Independent school inspections and outcomes Publication of the results of the independent school inspections and outcomes including regulation compliance.
Source agency: Office for Standards in Education, Children’s Services and Skills
Index of Deprivation 2004 – Income Deprivation Affecting Children ID 2004 Income Deprivation Affecting Children supplementary index (number of children in households in receipt of means tested low income benefits) Source: Office of the Deputy Prime Minister (ODPM): ID 2004 Publisher: Communities and Local Government (CLG) Geographies: Lower Layer Super Output Area (LSOA) Geographic coverage: England Time coverage: 2004 (using 2001 data) Type of data: Administrative data (with statistical transformations applied)
Income Deprivation Affecting Children Index 2007 The Index of Multiple Deprivation, which was produced at LSOA level in 2007 and 2004, combines seven distinct domains of deprivation together to give an overall impression of the level of deprivation experienced by an area. The Living Environment domain combines 4 indicators to give an overall score for the level of deprivation in the quality of the local environment. The indicators used in the latest update of this domain are; – Social and private housing in poor condition – Houses without central heating – Air quality – Road traffic accidents involving injury to pedestrians and cyclists More information about this domain can be found in Chapter 2, Section 8 of the English Indices of Deprivation 2007 Report.
Cycle routes A digital geographical description of the cycle path network that is used in the Transport Direct cycle journey planner. The data describes the cycle route geometry and a variety of cycling features on cycle paths and roads, such as the presence of cycle lanes and toucan crossings. The road data is referenced to the Ordnance Survey digital road network and doesn’t include road geometry. The data is free and is made available under the Open Government Licence. The data will be refreshed every few months, taking account of feedback from users and local authorities.
Special Educational Needs, Children in Care: Pupil Absence, exclusions and SEN Numbers of children looked after for at least twelve months, and general information about their education, including whether they have Special Educational Needs (SEN) whether have been absent for at least 25 days or whether facing permanent exclusions
Truancy: Penalty notices, fast-track, parenting contracts & parenting orders Download records of penalty notices, parenting orders and parenting contracts issued by LAs, as well as details of cases entering the fast track to attendance case management process. This data is published annually.
PE and Sport Survey The PE and Sport Survey is in its seventh year and consists of a census of all schools and FE colleges in England, measuring levels of participation in PE and out of hours sport.
Pupil / Teacher Ratio Pupil teacher ratios for maintained primary and secondary schools
PISA The Programme for International Student Assessment (PISA) is a survey of the educational achievement of 15-year-olds organised by the Organisation for Economic Co-operation and Development (OECD). A total of 65 countries participated in PISA 2009.
School Workforce in England (including pupil: teacher ratios and pupil: adult ratios) January 2010 Information on the School Workforce in England. It combines information on teacher numbers and vacancies, sickness absence and ethnicity with information on support staff, pupil: teacher ratios (PTR) and pupil: adult ratios (PAR).


3 thoughts on “Education Datasets and Resources

  1. Hi Jag,

    It’s great to see this being shared. We also have some recent data on our new Socrata platform community especially for the open data challenge series:

    If people want to find out more about entering the challenge themselves, they can find our project submission platform on collabfinder:

    Looking forward to seeing you on Saturday.


  2. There’s a full post on the marvel that is Data for Neighbourhoods and Regeneration.

    Within that treasure trove, there’s a vast amount of education and skills data, broken into the following themes:

    • Adult learning and Higher Education (HE) statistics
    • Pupil attainment
    • School characteristics
    • Adult skills
    • Index of Multiple Deprivation
    • School access
    • Training

    The datasets include details as broad as Children in Need, Class sizes by year group, Permanent exclusions, School capacity, Free school meals, Teacher sickness and many more.

Leave a Reply

Your email address will not be published. Required fields are marked *