Academic year 2022/23

Schools, pupils and their characteristics

Data guidance

Published

Description

This document describes the data included in the ‘Schools, pupils and their characteristics’ National Statistics release’s underlying data files. This data is released under the terms of the Open Government License (opens in a new tab) and is intended to meet at least 3 stars for Open Data (opens in a new tab).

The publication methodology, available on the publication report, should be referenced alongside this data. It provides information on the data sources, their coverage and quality as well as explaining methodology used in producing the data.

Coverage

This release provides information on the number of schools and pupils in:

  • state-funded primary schools
  • state-funded secondary schools
  • state-funded special schools
  • non-maintained special schools
  • pupil referral units
  • independent schools
  • local authority alternative provision

It includes information on:

  • pupil numbers, including headcount and fte, gender, ethnicity, language and free school meals eligibility
  • school numbers, including school type, academy status, denomination, admission policy, urban/rural and gender

The information is based on data collected via the pupil level spring school census, school level annual school census, general hospital schools census and alternative provision census.

File formats and conventions

Rounding

These datasets have not had suppression applied.

Conventions

The following convention is used throughout the underlying data. 

‘x’ Not applicable

‘z’ Unknown

Data files

All data files associated with this releases are listed below with guidance on their content. To download any of these files, please visit our data catalogue.

School characteristics

Filename
spc_school_characteristics_.csv
Geographic levels
Local authority; National; Regional
Time period
2015/16 to 2022/23
Content

Number of schools in England, by type, phase, denomination, admission policy, gender, urban/rural and academy status including headcounts and fte, language, fsm, age and national curriculum year breakdowns

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
academy_flagAcademy indicator - Academy or otherwise
admissions_policySchool admissions policy - Selective or otherwise
boy_boardersBoy boarders
denominationDenomination - Religious denomination
fte_pupilsFTE pupils
full_time_boys_aged_0Full time boys aged 0
full_time_boys_aged_1Full time boys aged 1
full_time_boys_aged_10Full time boys aged 10
full_time_boys_aged_11Full time boys aged 11
full_time_boys_aged_12Full time boys aged 12
full_time_boys_aged_13Full time boys aged 13
full_time_boys_aged_14Full time boys aged 14
full_time_boys_aged_15Full time boys aged 15
full_time_boys_aged_16Full time boys aged 16
full_time_boys_aged_17Full time boys aged 17
full_time_boys_aged_18Full time boys aged 18
full_time_boys_aged_19Full time boys aged 19
full_time_boys_aged_2Full time boys aged 2
full_time_boys_aged_3Full time boys aged 3 (born April to August)
full_time_boys_aged_4Full time boys aged 4 (born September to December)
full_time_boys_aged_5Full time boys aged 5
full_time_boys_aged_6Full time boys aged 6
full_time_boys_aged_7Full time boys aged 7
full_time_boys_aged_8Full time boys aged 8
full_time_boys_aged_9Full time boys aged 9
full_time_boys_early_1Full time boys Early 1
full_time_boys_early_2Full time boys Early 2
full_time_boys_nursery_1Full time boys Nursery 1
full_time_boys_nursery_2Full time boys Nursery 2
full_time_boys_receptionFull time boys Reception
full_time_boys_year_group_1Full time boys Year group 1
full_time_boys_year_group_10Full time boys Year group 10
full_time_boys_year_group_11Full time boys Year group 11
full_time_boys_year_group_12Full time boys Year group 12
full_time_boys_year_group_13Full time boys Year group 13
full_time_boys_year_group_14Full time boys Year group 14
full_time_boys_year_group_2Full time boys Year group 2
full_time_boys_year_group_3Full time boys Year group 3
full_time_boys_year_group_4Full time boys Year group 4
full_time_boys_year_group_5Full time boys Year group 5
full_time_boys_year_group_6Full time boys Year group 6
full_time_boys_year_group_7Full time boys Year group 7
full_time_boys_year_group_8Full time boys Year group 8
full_time_boys_year_group_9Full time boys Year group 9
full_time_boys_year_group_not_followedFull time boys Year group Not followed
full_time_girls_aged_0Full time girls aged 0
full_time_girls_aged_1Full time girls aged 1
full_time_girls_aged_10Full time girls aged 10
full_time_girls_aged_11Full time girls aged 11
full_time_girls_aged_12Full time girls aged 12
full_time_girls_aged_13Full time girls aged 13
full_time_girls_aged_14Full time girls aged 14
full_time_girls_aged_15Full time girls aged 15
full_time_girls_aged_16Full time girls aged 16
full_time_girls_aged_17Full time girls aged 17
full_time_girls_aged_18Full time girls aged 18
full_time_girls_aged_19Full time girls aged 19
full_time_girls_aged_2Full time girls aged 2
full_time_girls_aged_3Full time girls aged 3 (born April to August)
full_time_girls_aged_4Full time girls aged 4 (born September to December)
full_time_girls_aged_5Full time girls aged 5
full_time_girls_aged_6Full time girls aged 6
full_time_girls_aged_7Full time girls aged 7
full_time_girls_aged_8Full time girls aged 8
full_time_girls_aged_9Full time girls aged 9
full_time_girls_early_1Full time girls Early 1
full_time_girls_early_2Full time girls Early 2
full_time_girls_nursery_1Full time girls Nursery 1
full_time_girls_nursery_2Full time girls Nursery 2
full_time_girls_receptionFull time girls Reception
full_time_girls_year_group_1Full time girls Year group 1
full_time_girls_year_group_10Full time girls Year group 10
full_time_girls_year_group_11Full time girls Year group 11
full_time_girls_year_group_12Full time girls Year group 12
full_time_girls_year_group_13Full time girls Year group 13
full_time_girls_year_group_14Full time girls Year group 14
full_time_girls_year_group_2Full time girls Year group 2
full_time_girls_year_group_3Full time girls Year group 3
full_time_girls_year_group_4Full time girls Year group 4
full_time_girls_year_group_5Full time girls Year group 5
full_time_girls_year_group_6Full time girls Year group 6
full_time_girls_year_group_7Full time girls Year group 7
full_time_girls_year_group_8Full time girls Year group 8
full_time_girls_year_group_9Full time girls Year group 9
full_time_girls_year_group_not_followedFull time girls Year group Not followed
full_time_pupilsFull time pupils
girl_boardersGirl boarders
headcount_of_pupilsHeadcount - Total
headcount_total_boysHeadcount - boys
headcount_total_girlsHeadcount - girls
infants_taken_a_free_school_meal_on_census_dayInfants taken a free school meal on census day
number_of_early_year_pupils_years_e1_and_e2Number of early year pupils (years E1 and E2)
number_of_fsm_eligible_pupils_taking_a_free_school_meal_on_census_dayNumber of FSM eligible pupils taking a free school meal on census day
number_of_key_stage_1_pupils_years_1_and_2Number of key stage 1 pupils (years 1 and 2)
number_of_key_stage_2_pupils_years_3_to_6Number of key stage 2 pupils (years 3 to 6)
number_of_key_stage_3_pupils_years_7_to_9Number of key stage 3 pupils (years 7 to 9)
number_of_key_stage_4_pupils_years_10_and_11Number of key stage 4 pupils (years 10 and 11)
number_of_key_stage_5_pupils_years_12_to_14Number of key stage 5 pupils (years 12 to 14)
number_of_nursery_pupils_years_n1_and_n2Number of nursery pupils (years N1 and N2)
number_of_pupils_known_to_be_eligible_for_free_school_mealsKnown to be eligible for free school meals
number_of_pupils_known_to_be_eligible_for_free_school_meals_performance_tablesKnown to be eligible for free school meals (using performance tables methodology)
number_of_pupils_not_reception_or_key_stage_1_to_5Number of pupils not reception or key stage 1 to 5
number_of_pupils_of_compulsory_school_age_and_aboveNumber of pupils of compulsory school age and above
number_of_pupils_used_for_fsm_calculation_in_performance_tablesNumber of pupils used for FSM calculation in Performance Tables
number_of_pupils_whose_first_language_is_known_or_believed_to_be_englishFirst language is known or believed to be English
number_of_pupils_whose_first_language_is_known_or_believed_to_be_other_than_englishFirst language is known or believed to be other than English
number_of_pupils_whose_first_language_is_unclassifiedFirst language is unclassified
number_of_reception_pupils_year_rNumber of reception pupils (year R)
number_of_schoolsNumber of schools
part_time_boys_aged_0part time boys aged 0
part_time_boys_aged_1part time boys aged 1
part_time_boys_aged_10Part time boys aged 10
part_time_boys_aged_11Part time boys aged 11
part_time_boys_aged_12Part time boys aged 12
part_time_boys_aged_13Part time boys aged 13
part_time_boys_aged_14Part time boys aged 14
part_time_boys_aged_15Part time boys aged 15
part_time_boys_aged_16Part time boys aged 16
part_time_boys_aged_17Part time boys aged 17
part_time_boys_aged_18Part time boys aged 18
part_time_boys_aged_19Part time boys aged 19
part_time_boys_aged_2part time boys aged 2
part_time_boys_aged_3Part time boys aged 3 (born April to August)
part_time_boys_aged_4Part time boys aged 4 (born September to December)
part_time_boys_aged_5Part time boys aged 5
part_time_boys_aged_6Part time boys aged 6
part_time_boys_aged_7Part time boys aged 7
part_time_boys_aged_8Part time boys aged 8
part_time_boys_aged_9Part time boys aged 9
part_time_boys_early_1Part time boys Early 1
part_time_boys_early_2Part time boys Early 2
part_time_boys_nursery_1Part time boys Nursery 1
part_time_boys_nursery_2Part time boys Nursery 2
part_time_boys_receptionPart time boys Reception
part_time_boys_year_group_1Part time boys Year group 1
part_time_boys_year_group_10Part time boys Year group 10
part_time_boys_year_group_11Part time boys Year group 11
part_time_boys_year_group_12Part time boys Year group 12
part_time_boys_year_group_13Part time boys Year group 13
part_time_boys_year_group_14Part time boys Year group 14
part_time_boys_year_group_2Part time boys Year group 2
part_time_boys_year_group_3Part time boys Year group 3
part_time_boys_year_group_4Part time boys Year group 4
part_time_boys_year_group_5Part time boys Year group 5
part_time_boys_year_group_6Part time boys Year group 6
part_time_boys_year_group_7Part time boys Year group 7
part_time_boys_year_group_8Part time boys Year group 8
part_time_boys_year_group_9Part time boys Year group 9
part_time_boys_year_group_not_followedPart time boys Year group Not followed
part_time_girls_aged_0Part time girls aged 0
part_time_girls_aged_1Part time girls aged 1
part_time_girls_aged_10Part time girls aged 10
part_time_girls_aged_11Part time girls aged 11
part_time_girls_aged_12Part time girls aged 12
part_time_girls_aged_13Part time girls aged 13
part_time_girls_aged_14Part time girls aged 14
part_time_girls_aged_15Part time girls aged 15
part_time_girls_aged_16Part time girls aged 16
part_time_girls_aged_17Part time girls aged 17
part_time_girls_aged_18Part time girls aged 18
part_time_girls_aged_19Part time girls aged 19
part_time_girls_aged_2Part time girls aged 2
part_time_girls_aged_3Part time girls aged 3 (born April to August)
part_time_girls_aged_4Part time girls aged 4 (born September to December)
part_time_girls_aged_5Part time girls aged 5
part_time_girls_aged_6Part time girls aged 6
part_time_girls_aged_7Part time girls aged 7
part_time_girls_aged_8Part time girls aged 8
part_time_girls_aged_9Part time girls aged 9
part_time_girls_early_1Part time girls Early 1
part_time_girls_early_2Part time girls Early 2
part_time_girls_nursery_1Part time girls Nursery 1
part_time_girls_nursery_2Part time girls Nursery 2
part_time_girls_receptionPart time girls Reception
part_time_girls_year_group_1Part time girls Year group 1
part_time_girls_year_group_10Part time girls Year group 10
part_time_girls_year_group_11Part time girls Year group 11
part_time_girls_year_group_12Part time girls Year group 12
part_time_girls_year_group_13Part time girls Year group 13
part_time_girls_year_group_14Part time girls Year group 14
part_time_girls_year_group_2Part time girls Year group 2
part_time_girls_year_group_3Part time girls Year group 3
part_time_girls_year_group_4Part time girls Year group 4
part_time_girls_year_group_5Part time girls Year group 5
part_time_girls_year_group_6Part time girls Year group 6
part_time_girls_year_group_7Part time girls Year group 7
part_time_girls_year_group_8Part time girls Year group 8
part_time_girls_year_group_9Part time girls Year group 9
part_time_girls_year_group_not_followedPart time girls Year group Not followed
part_time_pupilsPart time pupils
phase_type_groupingSchool type - Filter by school type
sex_of_school_descriptionSex of school description - Mixed, boys, girls
total_boardersTotal boarders
type_of_establishmentSchool type (detailed) - Filter by school type (further detail)
urban_ruralUrban or rural indicator - Urban or rural indicator

Pupil characteristics - number of pupils by age and gender

Filename
spc_pupils_age_and_gender_.csv
Geographic levels
Local authority; National; Regional
Time period
2015/16 to 2022/23
Content

Pupils in state-funded nursery, primary, secondary and special schools, non-maintained special schools, pupil referral units and independent schools

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
agePupil age - Age at start of academic year (31st Aug)
fteFull time equivalent
full_timeFull time pupils
genderPupil gender - Pupil gender (Boys/girls)
headcountHeadcount
part_timePart time pupils
phase_type_groupingSchool type - Filter by school type

Pupil characteristics - number of pupils by national curriculum year group and gender

Filename
spc_pupils_yeargroup_and_gender_.csv
Geographic levels
Local authority; National; Regional
Time period
2015/16 to 2022/23
Content

Pupils in state-funded nursery, primary, secondary and special schools, non-maintained special schools, pupil referral units and independent schools

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
fteFull time equivalent
full_timeFull time pupils
genderPupil gender - Pupil gender (Boys/girls)
headcountHeadcount
ncyearYear group - National curriculum year group
part_timePart time pupils
phase_type_groupingSchool type - Filter by school type

Pupil characteristics - number of pupils by fsm eligibility

Filename
spc_pupils_fsm.csv
Geographic levels
Local authority; National; Regional
Time period
2015/16 to 2022/23
Content

Pupils in state-funded nursery, primary, secondary and special schools, non-maintained special schools and pupil referral units by FSM eligibility

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
fsmFree School Meals - Filter by free school meal status
headcountHeadcount
percent_of_pupilsFSM - Percentage of pupils
phase_type_groupingSchool type - Filter by school type
Footnotes
  1. Totals include state-funded nursery, primary, secondary, alternative provision (AP) schools and special schools, and non-maintained special schools. Does not include independent schools

Pupil characteristics - number of pupils by ethnicity and language

Filename
spc_pupils_ethnicity_and_language_.csv
Geographic levels
Local authority; National; Regional
Time period
2015/16 to 2022/23
Content

Pupils in state-funded nursery, primary, secondary and special schools, non-maintained special schools and pupil referral units by ethnicity and language

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
ethnicity_minorEthnicity - Filter by pupil ethnicity
headcountHeadcount
languageFirst language - Filter by first language
percent_of_pupilsPercent
phase_type_groupingSchool type - Filter by school type
Footnotes
  1. Totals include state-funded nursery, primary, secondary, alternative provision (AP) schools and special schools, and non-maintained special schools. Does not include independent schools
  2. Totals include pupils in General Hospital Schools, however Ethnicity and Language data is not available for these pupils. Breakdowns may not sum to totals as a result.
  3. Prior to 2017/18, Ethnicity and Language data was collected for compulsory school age children only.

Pupil characteristics - FSM eligible pupils by ethnicity or national curriculum year group

Filename
spc_pupils_fsm_ethnicity_yrgp.csv
Geographic levels
Local authority; National; Regional
Time period
2015/16 to 2022/23
Content

Pupils in state-funded nursery, primary, secondary and special schools, non-maintained special schools and pupil referral units by free school meal eligibility and ethnicity or year group

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
characteristicCharacteristics - Select required groups
denominatorTotal headcount
fsm_eligibilityFSM Eligibility - Select required groups
number_of_pupilsNumber of pupils
percent_of_pupilsPercentage
phase_type_groupingSchool type - Filter by school type
Footnotes
  1. Totals include state-funded nursery, primary, secondary, alternative provision (AP) schools and special schools, and non-maintained special schools. Does not include independent schools

Pupil characteristics - Eligibility for FSM at any time during past 6 years

Filename
spc_fsm6.csv
Geographic levels
Local authority; National; Regional
Time period
2015/16 to 2022/23
Content

Information on pupils who are known to have been eligible for free school meals at any time during the previous six years, including by ethnicity and National Curriculum year group. 

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
breakdownCharacteristics - Select required groups
denominatorTotal headcount
fsm6_eligibilityFSM6 Eligibility - Select required groups
number_of_pupilsNumber of pupils
percent_of_pupilsPercentage
phase_type_groupingSchool type - Filter by school type

Young carers by national curriculum year group

Filename
spc_pupils_young_carers_yrgp.csv
Geographic levels
Local authority; National; Regional
Time period
2022/23
Content

Pupils in state-funded nursery, primary, secondary and special schools, non-maintained special schools and pupil referral units who have been identified as a young carer

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
characteristicCharacteristics - Select required groups
denominatorTotal headcount
number_of_pupilsNumber of pupils
percent_of_pupilsPercentage
phase_type_groupingSchool type - Filter by school type
young_carerKnown to be a young carer - Select required groups
Footnotes
  1. Totals include state-funded nursery, primary, secondary, alternative provision (AP) schools and special schools, and non-maintained special schools. Does not include independent schools
  2. Data on young carers has been collected in the school census for the first time in 2022/23. The young carer indicator identifies, for those children on roll on spring census day, whether they have been identified as a young carer either by the school (including where the pupil self declares) or by parent or guardian

Class sizes - state-funded primary and secondary schools

Filename
spc_class_size_.csv
Geographic levels
Local authority; National; Regional
Time period
2015/16 to 2022/23
Content

Number of pupils and classes and average class sizes for state-funded primary and secondary schools, including infant and key stage 2 class sizes

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
average_class_sizeAverage class size
classtypeType of class - Type of class (Infant (Reception plus KS1), KS2, Primary or Secondary)
number_of_classesNumber of classes
number_of_pupilsNumber of pupils
sizeSize of class - Class size (1 to 30, 31 to 35, 36 plus)
Footnotes
  1. Totals include state-funded nursery, primary, secondary, alternative provision (AP) schools and special schools, and non-maintained special schools. Does not include independent schools

Universal Infant Free School Meals (UIFSM)

Filename
spc_uifsm.csv
Geographic levels
Local authority; National; Regional
Time period
2015/16 to 2022/23
Content

Information on the take up of Universal Infant Free School Meals, including by FSM eligibility.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
characteristicFSM eligibility - Filter by FSM, Not FSM or Total
denominatorTotal number of infant pupils
lunch_takenLunch taken - Select required groups
percentagePercentage of infant pupils taking a meal
phase_type_groupingSchool type - Filter by school type
pupilsNumber of infant pupils taking a meal
Footnotes
  1. Totals include state-funded nursery, primary, secondary, alternative provision (AP) schools and special schools, and non-maintained special schools. Does not include independent schools

School arranged alternative provision - by characteristics

Filename
spc_school_ap_characteristics.csv
Geographic levels
Local authority; National; Regional
Time period
2022/23
Content

Number of pupils in school arranged alternative provision, by pupil characteristics

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
pupil_characteristicPupil characteristic - Select required groups
pupilsNumber of pupils
setting_typeType of setting

School arranged alternative provision - by placement reason

Filename
spc_school_ap_placement.csv
Geographic levels
Local authority; National; Regional
Time period
2022/23
Content

Number of pupils in school arranged alternative provision, by reason for placement

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
pupil_characteristicPlacement Reason - Select required groups
pupilsNumber of pupils
setting_typeType of setting

Alternative provision - local authority funded placements - pupil counts

Filename
ap_placements_ap_census.csv
Geographic levels
Local authority; National; Regional
Time period
2017/18 to 2022/23
Content

Number of pupils in local authority funded alternative provision

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
agePupil age - Pupil age at 31 Aug at start of academic year
ethnicity_minorEthnicity - Ethnicity of pupil
fsmFree school meals - FSM eligible/not eligible
genderPupil gender - Gender (Girls/Boys/Other)
number_of_pupilsHeadcount

Alternative provision - local authority funded placements - placement counts

Filename
spc_ap_setting.csv
Geographic levels
Local authority; National; Regional
Time period
2022/23
Content

Number of placements in local authority funded alternative provision

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
placementsNumber of placements
setting_typeType of setting

Cross border movement

Filename
spc_cbm_230814.csv
Geographic levels
Local authority; National; Regional
Time period
2019/20 to 2022/23
Content

Includes data on cross border movements (comparing where pupils live and where they attend school), by year group and boarder status.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
Barking_and_DagenhamBarking and Dagenham
BarnetBarnet
BarnsleyBarnsley
Bath_and_North_East_SomersetBath and North East Somerset
BedfordBedford
BexleyBexley
BirminghamBirmingham
Blackburn_with_DarwenBlackburn with Darwen
BlackpoolBlackpool
boarderBoarder status - Boarder/Not boarder
BoltonBolton
Bournemouth_Christchurch_and_Poole_CouncilBournemouth Christchurch and Poole Council
Bracknell_ForestBracknell Forest
BradfordBradford
BrentBrent
Brighton_and_HoveBrighton and Hove
Bristol_City_ofBristol City of
BromleyBromley
BuckinghamshireBuckinghamshire
BuryBury
CalderdaleCalderdale
CambridgeshireCambridgeshire
CamdenCamden
Central_BedfordshireCentral Bedfordshire
Cheshire_EastCheshire East
Cheshire_West_and_ChesterCheshire West and Chester
City_of_LondonCity of London
CornwallCornwall
County_DurhamCounty Durham
CoventryCoventry
CroydonCroydon
CumbriaCumbria
DarlingtonDarlington
DerbyDerby
DerbyshireDerbyshire
DevonDevon
DoncasterDoncaster
DorsetDorset
DudleyDudley
EalingEaling
East_Riding_of_YorkshireEast Riding of Yorkshire
East_SussexEast Sussex
EnfieldEnfield
EssexEssex
GatesheadGateshead
GloucestershireGloucestershire
GreenwichGreenwich
HackneyHackney
HaltonHalton
Hammersmith_and_FulhamHammersmith and Fulham
HampshireHampshire
HaringeyHaringey
HarrowHarrow
HartlepoolHartlepool
HaveringHavering
Herefordshire_County_ofHerefordshire County of
HertfordshireHertfordshire
HillingdonHillingdon
HounslowHounslow
Isle_of_WightIsle of Wight
Isles_of_ScillyIsles of Scilly
IslingtonIslington
Kensington_and_ChelseaKensington and Chelsea
KentKent
Kingston_upon_Hull_City_ofKingston upon Hull City of
Kingston_upon_ThamesKingston upon Thames
KirkleesKirklees
KnowsleyKnowsley
LambethLambeth
LancashireLancashire
LeedsLeeds
LeicesterLeicester
LeicestershireLeicestershire
LewishamLewisham
LincolnshireLincolnshire
LiverpoolLiverpool
LutonLuton
ManchesterManchester
MedwayMedway
MertonMerton
MiddlesbroughMiddlesbrough
Milton_KeynesMilton Keynes
ncyearYear group - Reception to Year 11
Newcastle_upon_TyneNewcastle upon Tyne
NewhamNewham
NorfolkNorfolk
North_East_LincolnshireNorth East Lincolnshire
North_LincolnshireNorth Lincolnshire
North_NorthamptonshireNorth Northamptonshire
North_SomersetNorth Somerset
North_TynesideNorth Tyneside
North_YorkshireNorth Yorkshire
NorthamptonshireNorthamptonshire
NorthumberlandNorthumberland
NottinghamNottingham
NottinghamshireNottinghamshire
OldhamOldham
OxfordshireOxfordshire
PeterboroughPeterborough
phase-type_groupingSchool type - Filter by school type
PlymouthPlymouth
PortsmouthPortsmouth
ReadingReading
RedbridgeRedbridge
Redcar_and_ClevelandRedcar and Cleveland
resident_headcountNumber of pupils living in the LA
Richmond_upon_ThamesRichmond upon Thames
RochdaleRochdale
RotherhamRotherham
RutlandRutland
SalfordSalford
SandwellSandwell
school_in_laNumber of pupils living in the LA and attending state-funded schools within the LA
school_outside_laNumber of pupils living in the LA but attending state-funded schools in other LAs
SeftonSefton
SheffieldSheffield
ShropshireShropshire
SloughSlough
SolihullSolihull
SomersetSomerset
South_GloucestershireSouth Gloucestershire
South_TynesideSouth Tyneside
SouthamptonSouthampton
Southend_on_SeaSouthend on Sea
SouthwarkSouthwark
St_HelensSt Helens
StaffordshireStaffordshire
StockportStockport
Stockton_on_TeesStockton on Tees
Stoke_on_TrentStoke on Trent
SuffolkSuffolk
SunderlandSunderland
SurreySurrey
SuttonSutton
SwindonSwindon
TamesideTameside
Telford_and_WrekinTelford and Wrekin
ThurrockThurrock
TorbayTorbay
Tower_HamletsTower Hamlets
TraffordTrafford
WakefieldWakefield
WalsallWalsall
Waltham_ForestWaltham Forest
WandsworthWandsworth
WarringtonWarrington
WarwickshireWarwickshire
West_BerkshireWest Berkshire
West_NorthamptonshireWest Northamptonshire
West_SussexWest Sussex
WestminsterWestminster
WiganWigan
WiltshireWiltshire
Windsor_and_MaidenheadWindsor and Maidenhead
WirralWirral
WokinghamWokingham
WolverhamptonWolverhampton
WorcestershireWorcestershire
YorkYork

School level characteristics

Filename
spc_ees_school_characteristics.csv
Geographic levels
School
Time period
2015/16 to 2022/23
Content

School level data on school characteristics including for example school phase type grouping, academies, religious denomination, size band, location

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
number_schoolsNumber of schools

School level high level pupil counts

Filename
spc_ees_school_top_level.csv
Geographic levels
School
Time period
2015/16 to 2022/23
Content

School level data file showing characteristics of pupils including free school meals, ethnicity, language and dual registration

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
breakdownCharacteristic
breakdown_topicCharacteristic group
number_pupilsNumber of pupils

Alternative provision - local authority funded placements - setting type and placement reason

Filename
ap_placement_reason_ap_census.csv
Geographic levels
Local authority; National; Regional
Time period
2017/18 to 2022/23
Content

Number of placements in local authority funded alternative provision by placement reason and setting type

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
denominatorTotal placements
number_of_placementsNumber of placements
perc_placementsPercentage of placements
placement_reasonReason for AP placement - Reason for pupil being in AP
setting_typeType of setting - Setting with URN/UKPRN or other type