Data set from Key stage 4 destination measures

Key stage 4 leavers local authority level destinations

Latest data
Published
Last updated
Key stage 4 study leavers local authority level destinations data by location, student characteristics, provider type and qualification level

Data set details

Theme
Destination of pupils and students
Publication
Key stage 4 destination measures
Release type
Number of rows
188,650
Geographic levels
Local authority, Local authority district, Parliamentary constituency, Regional
Indicators
  • Activity not captured
  • Advanced and Higher apprenticeships (level 3 and above)
  • Further education
Filters
  • Data type
  • Institution group
  • Student characteristic
Time period
2016/17 to 2022/23

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_coderegion_nameold_la_codenew_la_codela_namepcon_codepcon_namelad_codelad_nameinstitution_groupinstitution_typebreakdown_topicbreakdowndata_typeversioncohortoveralleducationfessfsfcother_eduapprenappl3appl2all_workall_notsustall_unknown
201617Academic yearLocal authorityE92000001EnglandE12000001North East390E08000037GatesheadAlternative provisionTotalTotalTotalNumber of studentsRevised5830272210410121810
201617Academic yearLocal authorityE92000001EnglandE12000001North East390E08000037GatesheadAlternative provisionTotalTotalTotalPercentageRevised5851.746.637.91.70.06.91.70.01.73.431.017.2
201617Academic yearLocal authorityE92000001EnglandE12000001North East390E08000037GatesheadState-funded (inc. non-maintained) specialTotalTotalTotalNumber of studentsRevised605452190033000242
201617Academic yearLocal authorityE92000001EnglandE12000001North East390E08000037GatesheadState-funded (inc. non-maintained) specialTotalTotalTotalPercentageRevised6090.086.731.70.00.055.00.00.00.03.36.73.3
201617Academic yearLocal authorityE92000001EnglandE12000001North East390E08000037GatesheadState-funded mainstream and specialTotalDisadvantage StatusDisadvantagedNumber of studentsRevised56547043528512502520low20158015

Variables in this data set

Table showing first 5 of 16 variables
Variable nameVariable description
all_notsustNot recorded as a sustained destination
all_unknownActivity not captured
all_workSustained employment destination
appl2Intermediate apprenticeships (level 2)
appl3Advanced and Higher apprenticeships (level 3 and above)

Footnotes

  1. Disadvantaged pupils include pupils known to be eligible for free school meals (FSM) in any spring, autumn, summer, alternative provision or pupil referral unit census from year 6 to year 11, or that are looked after children for at least one day, or are adopted from care.
  2. Other education destinations include independent schools, specialist post-16 institutions, special schools and education combination destination.
  3. Following special educational needs and disability (SEND) reforms in 2014/15, SEN pupils are categorised as 'SEN with a statement or Education, health and care (EHC) plan' and 'SEN support'. SEN support replaces school action and school action plus (grouped as SEN without a statement up to and including 2013/14). It was expected that all transfers to this category take place during the 2014/15 academic year but some legacy categories remain in subsequent cohorts. More detailed information on the reforms can be found here: https://www.gov.uk/government/publications/send-code-of-practice-0-to-25.
  4. The state-funded mainstream & special schools total include local authority maintained schools, academies, free schools, city technology colleges, further education colleges with provision for 14- to 16-year-olds, state-funded special schools and non-maintained special schools.
  5. Alternative provision includes state place funded alternative provision (Pupil Referral Units, AP academies, AP free schools, and hospital schools) and other alternative provision (education funded by the local authority outside of state place funded schools, including independent schools, non-maintained special schools, and providers that do not meet the criteria for registration as a school).
  6. Unclassified includes pupils for whom ethnicity or first language was not obtained, refused or could not be determined.
  7. 'State-funded (inc. non-maintained) special schools' includes all state-funded special schools (including community special schools, foundation special schools, special sponsored academies, special converter academies and special free schools) and non-maintained special schools.
  8. 'Not recorded as a sustained destination' includes pupils who were captured in the source data and had some participation in the academic year but did not complete the required six months sustained participation.
  9. Activity not being captured means the student was not found to have any participation in education, apprenticeship or employment nor recorded as receiving out-of-work benefits at any point in the year. Possible reasons for this could be that the pupil was living, working or studying abroad or was attending a Scottish or Welsh college or school.
  10. State-funded mainstream schools include community schools, voluntary aided schools, voluntary controlled schools, foundation schools, academies, free schools, city technology colleges and further education colleges with provision for 14- to 16-year-olds.

Using this data

  • Download the underlying data as a compressed ZIP file

  • View or create your own tables

    View tables that we have built for you, or create your own tables from open data using our table tool

Download this data using code

Access this data using common programming languages using the URL below.

Example code