Additional school level data
Table ID: BiB_Education_Record.edrecs_additional_school_info
| Entity type | Variables | Entities | Updated | Related tables |
|---|---|---|---|---|
| School | 29 | 517 | 2022-12-08 | NA |
Additional school level information for Bradford schools. Can be linked to edrecs_annual_context using pseudoURN. Variables prefixed with “DfE_” are sourced from the Department for Education (downloaded October 2022; https://www.get-information-schools.service.gov.uk/Establishments/Search?SelectedTab=Establishments), whilst those prefixed with “ofsted_” contain results of 2021 Ofsead inspections (dowloaded October 2022; https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/1064054/State_funded_schools_inspections_and_outcomes_between_1_September_2021_and_31_December_2021.csv/preview; sheet: “Most recent inspection”).
| variable | label | value_type | summary |
|---|---|---|---|
| dfe_type | DfE: School type sub category | decimal | 1 : Academy alternative provision converter 10 : Free schools 11 : Free schools 16 to 19 12 : Further education 13 : Local authority nursery school 14 : Miscellaneous 15 : Other independent school 16 : Other independent special school 17 : Pupil referral unit 18 : Sixth form centres 19 : Studio schools 2 : Academy converter 20 : Voluntary aided school 21 : Voluntary controlled school 3 : Academy special converter 4 : Academy special sponsor led 5 : Academy sponsor led 6 : City technology college 7 : Community school 8 : Community special school 9 : Foundation school Complete: 517 (100.00%) |
| dfe_type2 | DfE: School type main category | decimal | 1 : Academies 2 : Colleges 3 : Free Schools 4 : Independent schools 5 : Local authority maintained schools 6 : Other types 7 : Special schools Complete: 517 (100.00%) |
| dfe_opened | DfE: Date school opened | date | from 1832-09-01 to 2022-09-01 Complete: 232 (44.87%) |
| dfe_closed | DfE: Date school closed | date | from 1984-12-31 to 2023-02-28 Complete: 288 (55.71%) |
| dfe_phase | DfE: Phase of education | decimal | 1 : 16 plus 2 : All-through 3 : Middle deemed secondary 4 : Not applicable 5 : Nursery 6 : Primary 7 : Secondary Complete: 517 (100.00%) |
| dfe_age_low | DfE: Statutory low age | decimal | mean (sd) 5.81 (3.66) min < median < max 0.00 < 4.00 < 16.00 Complete: 511 (98.84%) |
| dfe_age_high | DfE: Statutory high age | decimal | mean (sd) 13.34 (7.34) min < median < max 4.00 < 11.00 < 99.00 Complete: 511 (98.84%) |
| dfe_boarding_school | DfE: Boarding school status | decimal | 1 : Boarding school 2 : Children’s home (Boarding school) 3 : No boarders 4 : Not applicable Complete: 505 (97.68%) |
| dfe_sixth_form | DfE: Sixth form status | decimal | 1 : Does not have a sixth form 2 : Has a sixth form 3 : Not applicable Complete: 517 (100.00%) |
| dfe_gender | DfE: Gender policy | decimal | 1 : Boys 2 : Girls 3 : Mixed 4 : Not applicable Complete: 516 (99.81%) |
| dfe_admissions_policy | DfE: Admissions policy | decimal | 1 : Non-selective 2 : Not applicable 3 : Selective Complete: 511 (98.84%) |
| dfe_capacity | DfE: Official capacity | decimal | mean (sd) 504.48 (428.17) min < median < max 12.00 < 420.00 < 1972.00 Complete: 378 (73.11%) |
| dfe_census_date | DfE: Date of school census | date | from 2017-01-19 to 2022-01-20 Complete: 298 (57.64%) |
| dfe_headcount | DfE: Count of all students | decimal | mean (sd) 435.32 (380.85) min < median < max 0.00 < 363.50 < 2039.00 Complete: 296 (57.25%) |
| dfe_boys | DfE: Count of male students | decimal | mean (sd) 220.20 (201.20) min < median < max 0.00 < 178.00 < 1087.00 Complete: 296 (57.25%) |
| dfe_girls | DfE: Count of female students | decimal | mean (sd) 215.09 (195.41) min < median < max 0.00 < 177.50 < 1097.00 Complete: 296 (57.25%) |
| dfe_fsm | DfE: Percentage of students on free school meals | decimal | mean (sd) 107.09 (115.27) min < median < max 0.00 < 79.50 < 656.00 Complete: 292 (56.48%) |
| ofsted_date | Ofsted: Date of initial inspection | date | from 2007-01-16 to 2022-06-08 Complete: 273 (52.80%) |
| ofsted_rating | Ofsted: Rating | decimal | 1 : Good 2 : Inadequate 3 : Outstanding 4 : Requires improvement 5 : Serious Weaknesses 6 : Special Measures Complete: 261 (50.48%) |
| ofsted_idaci | Ofsted: Income deprivation affecting children index (IDACI) quintile | decimal | mean (sd) 4.01 (1.25) min < median < max 1.00 < 4.00 < 5.00 Complete: 208 (40.23%) |
| ofsted_headcount | Ofsted: Total number of pupils | decimal | mean (sd) 474.96 (386.58) min < median < max 0.00 < 385.50 < 1947.00 Complete: 208 (40.23%) |
| ofsted_full_inspection_date | Ofsted: Date of full inspection | date | from 2007-01-16 to 2021-11-03 Complete: 207 (40.04%) |
| ofsted_overall | Ofsted: Overall effectiveness | decimal | mean (sd) 2.10 (0.74) min < median < max 1.00 < 2.00 < 4.00 Complete: 207 (40.04%) |
| ofsted_quality_education | Ofsted: Quality of education | decimal | mean (sd) 8.14 (2.24) min < median < max 1.00 < 9.00 < 9.00 Complete: 207 (40.04%) |
| ofsted_behaviour_attitudes | Ofsted: Behaviour and attitudes | decimal | mean (sd) 8.11 (2.32) min < median < max 1.00 < 9.00 < 9.00 Complete: 207 (40.04%) |
| ofsted_personal_development | Ofsted: Personal development | decimal | mean (sd) 8.08 (2.38) min < median < max 1.00 < 9.00 < 9.00 Complete: 207 (40.04%) |
| ofsted_effective_leadership | Ofsted: Effectiveness of leadership and management | decimal | mean (sd) 2.00 (0.75) min < median < max 1.00 < 2.00 < 4.00 Complete: 207 (40.04%) |
| ofsted_Early_years | Ofsted: Early years provision | decimal | mean (sd) 5.03 (3.44) min < median < max 1.00 < 3.00 < 9.00 Complete: 207 (40.04%) |
| ofsted_sixth_form | Ofsted: Sixth form provision | decimal | mean (sd) 8.23 (2.20) min < median < max 1.00 < 9.00 < 9.00 Complete: 207 (40.04%) |