English Education

Educational attainment of young people in English towns

@kaggle.joebeachcapital_educational_attainment_in_english_towns

Table List

1 table(169 KB)

English Education

@kaggle.joebeachcapital_educational_attainment_in_english_towns.english_education

169 KB
1104 rows
31 columns

town11cd Town11cd	town11nm Town11nm	population_2011 Population 2011	size_flag Size Flag	rgn11nm Rgn11nm	coastal Coastal	coastal_detailed Coastal Detailed	ttwa11cd Ttwa11cd	ttwa11nm Ttwa11nm	ttwa_classification Ttwa Classification	job_density_flag Job Density Flag	income_flag Income Flag	university_flag University Flag	level4qual_residents35_64_2011 Level4qual Residents35–64 2011	ks4_2012_2013_counts Ks4–2012 2013 Counts	key_stage_2_attainment_school_year_2007_to_2008 Key Stage 2 Attainment School Year 2007 To 2008	key_stage_4_attainment_school_year_2012_to_2013 Key Stage 4 Attainment School Year 2012 To 2013	level_2_at_age_18 Level 2 At Age 18	level_3_at_age_18 Level 3 At Age 18	activity_at_age_19_full_time_higher_education Activity At Age 19 Full Time Higher Education	activity_at_age_19_sustained_further_education Activity At Age 19 Sustained Further Education	activity_at_age_19_appprenticeships Activity At Age 19 Appprenticeships	activity_at_age_19_employment_with_earnings_above_0 Activity At Age 19 Employment With Earnings Above 0	activity_at_age_19_employment_with_earnings_above_10_000 Activity At Age 19 Employment With Earnings Above 10–000	activity_at_age_19_out_of_work Activity At Age 19 Out Of Work	highest_level_qualification_achieved_by_age_22_level_1_92d5542e Highest Level Qualification Achieved By Age 22 Level 1 To Level 2	highest_level_qualification_achieved_by_age_22_level_3_8e58756e Highest Level Qualification Achieved By Age 22 Level 3 To Level 5	highest_level_qualification_achieved_by_age_22_level_6_or_above Highest Level Qualification Achieved By Age 22 Level 6 Or Above	highest_level_qualification_achieved_b_age_22_average_score Highest Level Qualification Achieved B Age 22 Average Score	education_score Education Score
E34000007	Carlton in Lindrick BUA	5456	Small Towns	East Midlands	Non-coastal	Smaller non-coastal town	E30000291	Worksop and Retford	Majority town and city (small)	Residential	Higher deprivation towns	No university	Low	65	65	70.76923076923077	72.3076923076923	50.76923076923077	30.76923076923077	21.53846153846154		52.30769230769232	36.92307692307693		34.9	39.7		3.3230769230769237	-0.533750422
E34000016	Dorchester (West Dorset) BUA	19060	Small Towns	South West	Non-coastal	Smaller non-coastal town	E30000046	Dorchester and Weymouth	Majority town and city (small)	Working	Mid deprivation towns	No university	Medium	239	69.05829596412556	71.1297071129707	85.71428571428571	60.08403361344538	41.84100418410041	13.389121338912132	10.0418410041841	51.04602510460251	24.686192468619247	4.184100418410042	21.7	44.6	33.3	3.7322175732217575	1.952018749
E34000020	Ely BUA	19090	Small Towns	East of England	Non-coastal	Smaller non-coastal town	E30000186	Cambridge	Majority town and city (Large Towns)	Working	Lower deprivation towns	No university	Medium	155	71.42857142857143	56.12903225806451	83.87096774193549	45.80645161290322	35.483870967741936	10.967741935483872	7.741935483870968	57.41935483870968	27.741935483870968		34.4	31.2	32.5	3.548387096774193	-1.044127985
E34000026	Market Weighton BUA	6429	Small Towns	Yorkshire and The Humber	Non-coastal	Smaller non-coastal town	E30000220	Hull	Majority town and city (Large Towns)	Residential	Lower deprivation towns	No university	Medium	58	70.96774193548387	53.44827586206896	91.2280701754386	49.122807017543856	25.86206896551724	25.86206896551724		58.620689655172406	31.03448275862069			66.1		3.4827586206896552	-1.249261949
E34000027	Downham Market BUA	10884	Small Towns	East of England	Non-coastal	Smaller non-coastal town	E30000225	King's Lynn	Majority rural	Mixed	Higher deprivation towns	No university	Low	93	78.04878048780488	62.36559139784946	78.49462365591397	40.86021505376344	26.881720430107524	20.43010752688172	15.053763440860216	55.91397849462365	30.107526881720432	15.053763440860216	32.6	44.2		3.161290322580645	-1.169078452
E34000039	Penrith BUA	15181	Small Towns	North West	Non-coastal	Smaller non-coastal town	E30000106	Penrith	Majority rural	Working	Lower deprivation towns	No university	Low	158	73.8562091503268	74.0506329113924	91.13924050632912	46.20253164556962	31.64556962025317	16.455696202531644	12.658227848101266	62.0253164556962	37.34177215189873	7.59493670886076	29.4	40	28.1	3.4746835443037973	0.84513109
E34000048	Bolsover BUA	11754	Small Towns	East Midlands	Non-coastal	Smaller non-coastal town	E30000190	Chesterfield	Majority town and city (Large Towns)	Residential	Higher deprivation towns	No university	Low	118	70.9090909090909	50	76.27118644067797	37.28813559322034	21.1864406779661	27.11864406779661	20.33898305084746	50.84745762711864	26.27118644067797	11.864406779661016	34.5	47.9		3.101694915254237	-3.717919688
E34000055	March BUA	21051	Medium Towns	East of England	Non-coastal	Large non-coastal town	E30000287	Wisbech	Majority town and city (small)	Residential	Higher deprivation towns	No university	Low	235	71.06382978723404	57.44680851063831	84.25531914893617	40.42553191489361	25.53191489361702	17.4468085106383	10.212765957446807	47.65957446808511	26.80851063829787	6.808510638297872	37.8	37.8	23.6	3.2851063829787237	-2.171307159
E34000056	Southam BUA	6567	Small Towns	West Midlands	Non-coastal	Smaller non-coastal town	E30000228	Leamington Spa	Majority town and city (small)	Working	Lower deprivation towns	No university	Medium	92	81.92771084337349	91.30434782608695	90.21739130434784	67.3913043478261	38.04347826086957	21.73913043478261	16.304347826086957	52.17391304347826	25		19.6	47.8	32.6	3.847826086956522	6.437661398
E34000067	Royston BUA	15781	Small Towns	East of England	Non-coastal	Smaller non-coastal town	E30000186	Cambridge	Majority town and city (Large Towns)	Working	Lower deprivation towns	No university	Medium	169	73.03370786516854	65.08875739644971	82.24852071005917	53.84615384615385	23.66863905325444	21.89349112426036	14.201183431952662	57.98816568047337	39.05325443786983		23.7	50.9	23.7	3.3846153846153846	0.29540337


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_level_1_92d5542e" DOUBLE,
  "highest_level_qualification_achieved_by_age_22_level_3_8e58756e" DOUBLE,
  "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
);