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
Geographic levels
Local authority, Local authority district, Parliamentary constituency, Regional
Indicators
  • Number of pupils completing key stage 4
  • Sustained education, employment & apprenticeships
  • Sustained education destination
Filters
  • Data type
  • Institution group
  • Level based on LEA area or provider location
Time period
2010/11 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_namelevel_methodologyinstitution_groupinstitution_typebreakdown_topicbreakdownversiondata_typecohortoveralleducationfessfsfcother_eduapprenappl3appl2all_workall_notsustall_unknown
201718Academic yearLocal authority districtE92000001EnglandE12000002North WestE07000028CarlisleProvider locationState-funded mainstream schoolsTotalFSM StatusFSM eligibleRevisedNumber of pupils7969533914003121382
201718Academic yearLocal authority districtE92000001EnglandE12000002North WestE07000028CarlisleProvider locationState-funded mainstream schoolsTotalTotalTotalRevisedNumber of pupils99393376434641611105357064546
201718Academic yearLocal authority districtE92000001EnglandE12000002North WestE07000029CopelandProvider locationState-funded mainstream schoolsTotalEthnicity MajorAny other ethnic groupRevisedNumber of pupils2220200000000
201718Academic yearLocal authority districtE92000001EnglandE12000002North WestE07000029CopelandProvider locationState-funded mainstream schoolsTotalEthnicity MajorMixed Dual backgroundRevisedNumber of pupils5551301000000
201718Academic yearLocal authority districtE92000001EnglandE12000002North WestE07000029CopelandProvider locationState-funded mainstream schoolsTotalFSM StatusFSM eligibleRevisedNumber of pupils585145351000404270

Variables in this data set

Table showing first 5 of 17 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