School Admission Appeals
Leeds City Council
@ukgov.school_admission_appeals
Leeds City Council
@ukgov.school_admission_appeals
CREATE TABLE n_2014_15_academic_year (
"extractdate" TIMESTAMP,
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"servicetypeuri" VARCHAR,
"servicetypelabel" VARCHAR,
"school" VARCHAR,
"rec_1415granted" DOUBLE,
"rec1415notgranted" DOUBLE,
"yr1_1415granted" DOUBLE,
"yr1_1415notgranted" DOUBLE,
"yr2_1415granted" DOUBLE,
"yr2_1415notgranted" DOUBLE,
"yr3_1415granted" DOUBLE,
"yr3_1415notgranted" DOUBLE,
"yr4_1415granted" DOUBLE,
"yr4_1415notgranted" DOUBLE,
"yr5_1415granted" DOUBLE,
"yr5_1415notgranted" DOUBLE,
"yr6_1415granted" DOUBLE,
"yr6_1415notgranted" DOUBLE,
"yr7_1415granted" DOUBLE,
"yr7_1415notgranted" DOUBLE,
"yr8_1415granted" DOUBLE,
"yr8_1415not_granted" DOUBLE,
"yr9_1415granted" DOUBLE,
"yr9_1415notgranted" DOUBLE,
"yr10_1415granted" DOUBLE,
"yr10_1415notgranted" DOUBLE,
"yr11_1415granted" VARCHAR,
"yr11_1415notgranted" DOUBLE
);
CREATE TABLE n_2015_16_academic_year (
"unnamed_0" VARCHAR,
"rec_16_17" VARCHAR,
"unnamed_2" VARCHAR,
"in_yr_15_16_yr1" VARCHAR,
"unnamed_4" VARCHAR,
"in_yr_15_16_yr2" VARCHAR,
"unnamed_6" VARCHAR,
"in_yr_15_16_yr3" VARCHAR,
"unnamed_8" VARCHAR,
"in_yr_15_16_yr4" VARCHAR,
"unnamed_10" VARCHAR,
"in_yr_15_16_yr5" VARCHAR,
"unnamed_12" VARCHAR,
"in_yr_15_16_yr6" VARCHAR,
"unnamed_14" VARCHAR,
"high_16_17" VARCHAR,
"unnamed_16" VARCHAR,
"in_yr_15_16_yr8" VARCHAR,
"unnamed_18" VARCHAR,
"in_yr_15_16_yr9" VARCHAR,
"unnamed_20" VARCHAR,
"in_yr_15_16_yr10" VARCHAR,
"unnamed_22" VARCHAR,
"in_yr_15_16_yr11" VARCHAR,
"unnamed_24" VARCHAR
);
CREATE TABLE n_2016_17_academic_year (
"school_name" VARCHAR,
"reception_17_18_appeal_granted" VARCHAR,
"reception_17_18_appeal_not_granted" VARCHAR,
"in_year_16_17_yr1_appeal_granted" VARCHAR,
"in_year_16_17_yr1_appeal_not_granted" DOUBLE,
"in_year_16_17_yr2_appeal_granted" DOUBLE,
"in_year_16_17_yr2_appeal_not_granted" DOUBLE,
"in_year_16_17_yr3_appeal_granted" DOUBLE,
"in_year_16_17_yr3_appeal_not_granted" DOUBLE,
"in_year_16_17_yr4_appeal_granted" VARCHAR,
"in_year_16_17_yr4_appeal_not_granted" DOUBLE,
"in_year_16_17_yr_5_appeal_granted" DOUBLE,
"in_year_16_17_yr_5_appeal_not_granted" DOUBLE,
"in_year_16_17_yr6_appeal_granted" VARCHAR,
"in_year_16_17_yr6_appeal_not_granted" VARCHAR
);
CREATE TABLE n_2017_18_academic_year (
"school_name" VARCHAR,
"reception_18_19_granted" VARCHAR,
"reception_18_19_not_granted" VARCHAR,
"in_year_17_18_yr_1_granted" DOUBLE,
"in_year_17_18_yr_1_not_granted" DOUBLE,
"in_year_17_18_yr_2_granted" DOUBLE,
"in_year_17_18_yr_2_not_granted" DOUBLE,
"in_year_17_18_yr_3_granted" DOUBLE,
"in_year_17_18_yr_3_not_granted" DOUBLE,
"in_year_17_18_yr_4_granted" DOUBLE,
"in_year_17_18_yr_4_not_granted" DOUBLE,
"in_year_17_18_yr_5_granted" DOUBLE,
"in_year_17_18_yr_5_not_granted" DOUBLE,
"in_year_17_18_yr_6_granted" DOUBLE,
"in_year_17_18_yr_6_not_granted" DOUBLE
);
CREATE TABLE n_2018_19_academic_year (
"primary_school_name" VARCHAR,
"reception_19_20_granted" VARCHAR,
"reception_19_20_not_granted" VARCHAR,
"in_year_18_19_rec_granted" VARCHAR,
"in_year_18_19_rec_not_granted" VARCHAR,
"in_year_18_19_yr_1_granted" VARCHAR,
"in_year_18_19_yr_1_not_granted" VARCHAR,
"in_year_18_19_yr_2_granted" VARCHAR,
"in_year_18_19_yr_2_not_granted" VARCHAR,
"in_year_18_19_yr_3_granted" VARCHAR,
"in_year_18_19_yr_3_not_granted" VARCHAR,
"in_year_18_19_yr_4_granted" VARCHAR,
"in_year_18_19_yr_4_not_granted" VARCHAR,
"in_year_18_19_yr_5_granted" DOUBLE,
"in_year_18_19_yr_5_not_granted" DOUBLE,
"in_year_18_19_yr_6_granted" DOUBLE,
"in_year_18_19_yr_6_not_granted" DOUBLE,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR
);
CREATE TABLE n_2019_20_academic_year (
"primary_school_name" VARCHAR,
"reception_20_21_granted" VARCHAR,
"reception_20_21_not_granted" VARCHAR,
"in_yr_19_20_reception_granted" VARCHAR,
"in_yr_19_20_reception_not_granted" VARCHAR,
"in_yr_19_20_y_1_granted" VARCHAR,
"in_yr_19_20_y_1_not_granted" VARCHAR,
"in_yr_19_20_y2_granted" VARCHAR,
"in_yr_19_20_y2_not_granted" VARCHAR,
"in_yr_19_20_y3_granted" VARCHAR,
"in_yr_19_20_y3_not_granted" VARCHAR,
"in_yr_19_20_y4_granted" VARCHAR,
"in_yr_19_20_y4_not_granted" VARCHAR,
"in_yr_19_20_y5_granted" VARCHAR,
"in_yr_19_20_y5_not_granted" VARCHAR,
"in_yr_19_20_y6_granted" VARCHAR,
"in_yr_19_20_y6_not_granted" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR
);
Anyone who has the link will be able to view this.