Born in Bradford Data Dictionary

Local Authority Education Record Contextual Data

Table ID: BiB_Education_Record.edrecs_annual_context

github | csv

Entity type Variables Entities Updated Related tables
Participant 10 11717 2022-10-12 NA

Data set in long form with contextual information for each academic year a child is at school and data is available. Collected information includes school identifieers, SEN status, free school meals status and ‘Gifted and Talented’ status. edcont_schoolid provides a unqiue ID for each school; as this is based on UPRN this ID will not be affected by academisation/name changes. edcont_psuedoURN can be used to link to the edrecs_additional_school_info table to obtain school level information for each child

variable label value_type summary
edcont_schoolentry Year started school decimal mean (sd)
2013.00 (1.14)

min < median < max
2011.00 < 2013.00 < 2015.00

Complete: 115562 (100.00%)

edcont_academicyear School year data was taken from decimal 1 : R
10 : Y9
11 : Y10
2 : Y1
3 : Y2
4 : Y3
5 : Y4
6 : Y5
7 : Y6
8 : Y7
9 : Y8
Complete: 114822 (99.36%)

edcont_eal Does child have English as a second language? decimal 1 : No
2 : Yes
Complete: 81159 (70.23%)

edcont_fsm Is child is in receipt of free school meals? decimal 1 : No
2 : Yes
Complete: 109685 (94.91%)

edcont_g_t Is child classed as ‘gifted and talented’? decimal 1 : No
2 : Yes
Complete: 109685 (94.91%)

edcont_lac Is child in the care of their local authority? decimal 1 : No
2 : Yes
Complete: 109685 (94.91%)

edcont_sen Does child have special educational needs? decimal 1 : EHCP
2 : Not SEN
3 : School Action
4 : School Action Plus
5 : SEN Support
6 : Statement
Complete: 107856 (93.33%)

edcont_schoolstatus School and education administrative status decimal 1 : LA school in Bradford
2 : Unknown - application processing
3 : Unknown - unable to trace
4 : Home educated
5 : Independpent school
6 : LA school outisde Bradford LA
Complete: 105439 (91.24%)

edcont_schoolid Unique BiB generated school ID decimal mean (sd)
85.42 (47.53)

min < median < max
1.00 < 88.00 < 168.00

Complete: 100008 (86.54%)

edcont_psuedoURN Psueodnymised URN number text 193 unique values
99365 non-missing values
1 to 40 characters