Data set from Key stage 4 performance

All state-funded pupil characteristics and geography data

Latest data
API data set version 1.0
Published
Last updated
National, regional and local authority level performance measures in state-funded schools by pupil characteristics since 2018/19.

Data set details

Theme
School and college outcomes and performance
Publication
Key stage 4 performance
API data set ID
b3e19901-5d2b-b676-bb4c-e60937d74725
How do I use this ID?
Release type
Number of rows
342,406
Geographic levels
Local authority, National, Regional
Indicators
  • Average Attainment 8 score
  • Average Attainment 8 score for EBacc element
  • Average Attainment 8 score for English element
Filters
  • Disadvantaged status
  • Ethnicity
  • First language
Time period
2009/10 to 2024/25

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_coderegion_nameold_la_codenew_la_codela_nameversioneducation_investment_area_flagpriority_area_flagestablishment_type_groupbreakdown_topicsexethnicity_majorethnicity_minorfsm_statussen_provisionsen_statussen_primary_needdisadvantage_statusfirst_languageprior_attainmentks2_scaled_score_groupmobilityyoung_carerschool_admission_typeschool_religious_characterschool_countpupil_countattainment8_sumattainment8_averageengmath_entering_totalengmath_entering_percentengmath_95_totalengmath_95_percentengmath_94_totalengmath_94_percentebacc_entering_totalebacc_entering_percentebacc_95_totalebacc_95_percentebacc_94_totalebacc_94_percentebacc_aps_sumebacc_aps_averageprogress8_pupil_countprogress8_sumprogress8_averageprogress8_lower_95_ciprogress8_upper_95_ciprogress8eng_sumprogress8eng_averageprogress8eng_lower_95_ciprogress8eng_upper_95_ciprogress8mat_sumprogress8mat_averageprogress8mat_lower_95_ciprogress8mat_upper_95_ciprogress8ebacc_sumprogress8ebacc_averageprogress8ebacc_lower_95_ciprogress8ebacc_upper_95_ciprogress8open_sumprogress8open_averageprogress8open_lower_95_ciprogress8open_upper_95_cigcse_entering_totalgcse_entering_percentgcse_91_totalgcse_91_percentebacceng_entering_totalebacceng_entering_percentebaccmat_entering_totalebaccmat_entering_percentebaccsci_entering_totalebaccsci_entering_percentebacchum_entering_totalebacchum_entering_percentebacclan_entering_totalebacclan_entering_percentebacceng_95_totalebacceng_95_percentebaccmat_95_totalebaccmat_95_percentebaccsci_95_totalebaccsci_95_percentebacchum_95_totalebacchum_95_percentebacclan_95_totalebacclan_95_percentebacceng_94_totalebacceng_94_percentebaccmat_94_totalebaccmat_94_percentebaccsci_94_totalebaccsci_94_percentebacchum_94_totalebacchum_94_percentebacclan_94_totalebacclan_94_percentebacceng_aps_sumebacceng_aps_averageebaccmat_aps_sumebaccmat_aps_averageebaccsci_aps_sumebaccsci_aps_averageebacchum_aps_sumebacchum_aps_averageebacclan_aps_sumebacclan_aps_averageattainment8eng_sumattainment8eng_averageattainment8mat_sumattainment8mat_averageattainment8ebacc_sumattainment8ebacc_averageattainment8open_sumattainment8open_averageattainment8open_gcse_sumattainment8open_gcse_averageattainment8open_nongcse_sumattainment8open_nongcse_averageattainment8ebacc_slotfill_totalattainment8ebacc_slotfill_averageattainment8open_slotfill_totalattainment8open_slotfill_averageebacc_entering_0pillar_totalebacc_entering_0pillar_percentebacc_entering_1pillar_totalebacc_entering_1pillar_percentebacc_entering_2pillar_totalebacc_entering_2pillar_percentebacc_entering_3pillar_totalebacc_entering_3pillar_percentebacc_entering_4pillar_totalebacc_entering_4pillar_percentebaccsci_combpath_entering_totalebaccsci_combpath_entering_percentebaccsci_indpath_entering_totalebaccsci_indpath_entering_percentsci_triple_entering_totalsci_triple_entering_percentgeoghist_entering_totalgeoghist_entering_percentlan_multiple_entering_totallan_multiple_entering_percentart_subject_entering_totalart_subject_entering_percentmusic_qual_entering_totalmusic_qual_entering_percentart_qual_entering_totalart_qual_entering_percentebacceng_91_totalebacceng_91_percentebaccmat_91_totalebaccmat_91_percentebaccsci_91_totalebaccsci_91_percentebacchum_91_totalebacchum_91_percentebacclan_91_totalebacclan_91_percentebacc_91_totalebacc_91_percentgcse_five_engmath_totalgcse_five_engmath_percentprogress8_pupil_percentprogress8_adjusted_totalprogress8_adjusted_percentprogress8original_sumprogress8original_averageprogress8original_lower_95_ciprogress8original_upper_95_civalueaddedsci_pupil_countvalueaddedsci_pupil_percentvalueaddedsci_sumvalueaddedsci_averagevalueaddedsci_lower_95_civalueaddedsci_upper_95_civalueaddedhum_pupil_countvalueaddedhum_pupil_percentvalueaddedhum_sumvalueaddedhum_averagevalueaddedhum_lower_95_civalueaddedhum_upper_95_civalueaddedlan_pupil_countvalueaddedlan_pupil_percentvalueaddedlan_sumvalueaddedlan_averagevalueaddedlan_lower_95_civalueaddedlan_upper_95_ciqual_entries_sumqual_entries_averagegcse_entries_sumgcse_entries_averagequal_entries_without_discounting_sumqual_entries_without_discounting_average
202425Academic yearNationalE92000001EnglandProvisional00All state-fundedTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotal410462567328749291.4345.960006195.928257045.240352064.525343140.511632418.616055325.72551096.914.08zzzzzzzzzzzzzzzzzzzzz60620996.960348596.558561393.660220796.258882994.150768381.128727045.937688960.23187965128173447.825976651.217370460.546340674.143491969.538691065.732138263.320925172.830561134.882842440.164.542791097.334.4623382173.741487602.142.3861473759.85684891.329.18408873.3913.48508151.7213.67164520.2211.51343631.52.117047662.717114192.7219773.589311.4105951.7486307.828210945.144286370.814597723.314571723.3451717.2215173.424196138.7410936.628436545.45818179359097294.557816998.24925809728308498.524660439.437434559.8zzzzzzzzzzzzzzzzzzzzzzzzz4900407.497.845248127.249408907.9
202425Academic yearNationalE92000001EnglandProvisional00All state-fundedSexBoysTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotal389232070814100901.424430494195.114004543.720068562.611773336.75019815.77023921.91257014.873.92zzzzzzzzzzzzzzzzzzzzz30855296.230682895.729655892.530638895.529905993.225794280.413235841.317357654.116657751.914137147.312479348.47348255.522156269.12243877019459665.1157267619054768.414587974.551473932.524.61409324.574.3911401173.56650571.642.0329356029.22947865.049.24189116.8913.14028317.4912.63378488.4910.564982928624542.78627022.7135364.251991.658021.8269158.415152347.222340169.77566723.67548623.5280568.790942.89027328.1215236.711582936.129372191.630068993.829290697.924828096.313006698.311410635.618224356.8zzzzzzzzzzzzzzzzzzzzzzzzz2485009.917.722860257.125057497.8
202425Academic yearNationalE92000001EnglandProvisional00All state-fundedSexGirlsTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotal385330496514648390.014829512096.814252546.720283566.513569844.56612621.79031429.61294082.044.24zzzzzzzzzzzzzzzzzzzzz29765797.629665797.328905594.8295819972897709524974181.915491250.820331366.715221949.914036348.41349735410022264.724184479.32105326919231466.416411565.711870476.615973165.241368507.644.491381772.764.5311981003.93837030.52.74321177310.52737026.2894219756.513.84479834.2314.73786031.7312.4693802.52.38423122.88487172.884412.837321.247931.6217157.113058642.8219462727031023.17023123171155.6124234.115168849.7195706.416853655.328809694.529028395.228526398.424430097.815301898.813249843.419210263zzzzzzzzzzzzzzzzzzzzzzzzz2415397.587.922387877.324351418
202425Academic yearNationalE92000001EnglandProvisional00All state-fundedEthnicityTotalBlack / African / Caribbean / Black BritishAfricanTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotal2989316051511323.0347.83068597.11478746.82125467.21445845.7576618.2845126.7134751.384.26zzzzzzzzzzzzzzzzzzzzz3091097.83083597.63030895.93077497.43058596.82633683.316450522111066.81615051.11566551.21345351.1935356.92544980.52231270.62085768.21714465.11160270.51645895.21144867.014.581483384.691211343.83812472.5733017710.4289734.029.244624814.1445164.0114.1383466.0112.1616982890732.8896882.87642.41380.42760.924037.61356642.92347174.3711422.5711022.517175.49242.9955230.218435.81179737.33020495.63030095.93003798.22583298.11615998.21395944.21992563zzzzzzzzzzzzzzzzzzzzzzzzz253620.382354957.52547398.1
202425Academic yearNationalE92000001EnglandProvisional00All state-fundedSex by ethnicityBoysBlack / African / Caribbean / Black BritishAfricanTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotal246215722701617.544.61509796678343.1997763.5625839.8211713.5323020.562318.933.96zzzzzzzzzzzzzzzzzzzzz15243971518596.61487994.61515896.41502595.61277781.3718045.7916458.3778949.5709947.2572444.8347348.41169174.41078868.6973464.8762059.6452663750484.7770716.754.570581.54.49545743.47324122.061505869.6141433.59208482.513.3201115.512.8171351.510.9297641.9435162.8437232.85213.3970.61681.114169726246.21184575.3318020.2317720.29335.93762.4368023.49556.1493931.41479794.11487494.614727981241697.2701997.8599138.1910257.9zzzzzzzzzzzzzzzzzzzzzzzzz123490.177.91139877.31241177.9

Variables in this data set

Table showing first 5 of 183 variables
Variable nameVariable description
art_qual_entering_percentPercentage of pupils entering any arts qualification
art_qual_entering_totalNumber of pupils entering any arts qualification
art_subject_entering_percentPercentage of pupils entering any arts subject
art_subject_entering_totalNumber of pupils entering any arts subject
attainment8_averageAverage Attainment 8 score

Footnotes

  1. Local authority, region, parliamentary constituency figures cover achievements in state-funded schools only. They do not include pupils recently arrived from overseas and so will not match with state-funded figures in the national tables.
  2. Selective areas include local authorities where more than 25% of state-funded secondary places are in selective schools. These local authorities are Bexley, Buckinghamshire, Kent, Lincolnshire, Medway, Slough, Southend-on-Sea, Sutton, Torbay, Trafford and Wirral.
  3. Sub totals for EAL and SEN breakdowns may not sum to the grand total due to a small number of pupils with missing information.
  4. Unclassified includes pupils for whom the information was not obtained, refused or could not be determined.
  5. Progress 8 is not being published in 2024/25  as KS4 pupils in this year do not have KS2 assessments due to the COVID-19 pandemic. Progress 8 was also not published in 2020 or 2021 because of the COVID-19 pandemic.
  6. A Progress 8 score of 1.0 means pupils make on average a grade more progress than the national average of pupils with similar KS2 prior attainment in mainstream schools. Progress 8 should be interpreted alongside the associated confidence intervals. If the confidence intervals cross 0, then progress is not significantly different compared to pupils with similar KS2 prior attainment in mainstream schools.
  7. EBacc science includes double award GCSE for pupils on the combined science pathway or the average of a pupil's best two science grades for pupils on the single science pathway (i.e., where pupils enter three of biology, chemistry, computer science, and physics).
  8. The open element of Attainment 8 contains the three highest point scores in any three other subjects eligible for performance tables, including English language or literature (if not counted in the English slot), further GCSE qualifications (including English Baccalaureate subjects) or any other non-GCSE qualifications on the DfE approved list.
  9. For the number of slots filled, entries that were awarded U grades or other qualifications scoring 0 points are counted as a non-filled slot.
  10. Subjects included in the 'entered art' indicator include: Applied Art and Design, Art and Design, Drama, Media/Film/TV, Music, Dance and Performing Arts.
  11. Changes were made to the methodology for calculating performance data due to the commitment not to use qualification results awarded between January 2020 and August 2021 in future measures. GCSE exams returned in 2022 and grades were awarded at a midpoint between 2021 and pre-pandemic grading. In 2023, there was a return to pre-pandemic grading, with some protections. Comparisons to 2020, 2021, and 2022 should be made with caution.
  12. c = a cell that has been suppressed due to low number of pupils. Suppression was applied where deemed necessary for all data up to 2018/19. For 2019/20, DfE suppression policy changed. For 2020 and 2021 results where a geographical area contains only one school (for example Isles of Scilly) the data for that area has been suppressed. This is in line with the announcement that school level data would not be published using either summer 2020 or summer 2021 exam grades awarded. Data has not being supressed at local authority or national level from 2022 onwards.
  13. 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. Section 17ZA of the Children Act 1989 says a young carer is a person under 18 who provides or intends to provide care for another person (which isn’t a contract or voluntary work).

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


Using the API

  • API documentation

    This data set is available via an API, follow the link to get all the information to get started. The documentation provides full guidance and examples on how to make the most from our data sets.

  • Building API integrations

    To support building integrations on top of the explore education statistics API, software development kits (SDKs) are provided to streamline common tasks and communication with the API.

API data set details

API data set name
All state-funded pupil characteristics and geography data
API data set ID
b3e19901-5d2b-b676-bb4c-e60937d74725
API data set version
1.0

Download data set as CSV

Get familiar with the data. The CSV response will render its categories and column headers in a human-readable format (instead of machine-readable IDs).

Guidance: Download data set as CSV

Data set metadata

Look up human-readable labels and their corresponding machine-readable IDs to help you create data set queries.

Guidance: Get data set metadata

Query data set using GET

Quickly test the machine-readable IDs in a range of basic queries.

Guidance: Query data set (GET)

Query data set using POST

The POST endpoint is recommended for production level pipeline queries. POST requires a query to be built and supplied in JSON format using third party software such as Postman and Insomnia or programming languages such as Python, R, etc.

Guidance: Query data set (POST)

Get data set summary

Guidance: Get data set summary


API data set version history