School Level Data For Allocated Preferences In Secondary Admissions Rounds

CREATE TABLE admissions_summary_allocated_secondary_2024 (
  "dfenumber" BIGINT,
  "schoolname" VARCHAR,
  "year" BIGINT,
  "places" BIGINT,
  "place_allocated" BIGINT,
  "total" BIGINT,
  "n_1st_preference" BIGINT,
  "n_2nd_preference" DOUBLE,
  "n_3rd_preference" DOUBLE,
  "n_4th_preference" DOUBLE,
  "unplaced" DOUBLE,
  "sle" BIGINT,
  "catchment" BIGINT,
  "sibling" DOUBLE,
  "feeder_school" DOUBLE,
  "distance" DOUBLE,
  "inside_specified_area" BIGINT,
  "religion" BIGINT,
  "other" DOUBLE,
  "total_1" BIGINT
);