School Level Data For All Preferences In Secondary Admissions Rounds

CREATE TABLE admissions_summary_all_secondary_2023 (
  "dfenumber" BIGINT,
  "schoolname" VARCHAR,
  "year" BIGINT,
  "places" BIGINT,
  "place_allocated" BIGINT,
  "place_refused" BIGINT,
  "place_withdrawn" BIGINT,
  "withdrawn_from_process" BIGINT,
  "total" BIGINT,
  "n_1st_pref" BIGINT,
  "n_2nd_pref" BIGINT,
  "n_3rd_pref" BIGINT,
  "n_4th_pref" BIGINT,
  "n_5th_pref" BIGINT,
  "unplaced" BIGINT,
  "sle" BIGINT,
  "catchment" BIGINT,
  "catchment_sibling" BIGINT,
  "sibling" BIGINT,
  "feeder_school" BIGINT,
  "distance" BIGINT,
  "inside_specified_area" BIGINT,
  "religion" BIGINT,
  "other" BIGINT,
  "total_1" BIGINT
);