School Level Data For Allocated Preferences In Secondary Admissions Rounds

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