English Education
Educational attainment of young people in English towns
@kaggle.joebeachcapital_educational_attainment_in_english_towns
Educational attainment of young people in English towns
@kaggle.joebeachcapital_educational_attainment_in_english_towns
The dataset comes from The UK Office for National Statistics.
It was explored in the July 2023 article "Why do children and young people in smaller towns do better academically than those in larger towns?".
CREATE TABLE english_education (
"town11cd" VARCHAR,
"town11nm" VARCHAR,
"population_2011" DOUBLE,
"size_flag" VARCHAR,
"rgn11nm" VARCHAR,
"coastal" VARCHAR,
"coastal_detailed" VARCHAR,
"ttwa11cd" VARCHAR,
"ttwa11nm" VARCHAR,
"ttwa_classification" VARCHAR,
"job_density_flag" VARCHAR,
"income_flag" VARCHAR,
"university_flag" VARCHAR,
"level4qual_residents35_64_2011" VARCHAR,
"ks4_2012_2013_counts" BIGINT,
"key_stage_2_attainment_school_year_2007_to_2008" DOUBLE,
"key_stage_4_attainment_school_year_2012_to_2013" DOUBLE,
"level_2_at_age_18" DOUBLE,
"level_3_at_age_18" DOUBLE,
"activity_at_age_19_full_time_higher_education" DOUBLE,
"activity_at_age_19_sustained_further_education" DOUBLE,
"activity_at_age_19_appprenticeships" DOUBLE,
"activity_at_age_19_employment_with_earnings_above_0" DOUBLE,
"activity_at_age_19_employment_with_earnings_above_10_000" DOUBLE,
"activity_at_age_19_out_of_work" DOUBLE,
"highest_level_qualification_achieved_by_age_22_less_th_b1a970e5" DOUBLE -- Highest Level Qualification Achieved By Age 22 Less Than Level 1,
"highest_level_qualification_achieved_by_age_22_level_1_92d5542e" DOUBLE -- Highest Level Qualification Achieved By Age 22 Level 1 To Level 2,
"highest_level_qualification_achieved_by_age_22_level_3_8e58756e" DOUBLE -- Highest Level Qualification Achieved By Age 22 Level 3 To Level 5,
"highest_level_qualification_achieved_by_age_22_level_6_or_above" DOUBLE,
"highest_level_qualification_achieved_b_age_22_average_score" DOUBLE,
"education_score" DOUBLE
);Anyone who has the link will be able to view this.