Born in Bradford Data Dictionary

Additional school level data

Table ID: BiB_Education_Record.edrecs_additional_school_info

github | csv

Entity type Variables Entities Updated Related tables
School 29 517 2022-10-06 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%)