About this Dataset

Number On Roll By Age

Total numbers on roll by age for Maintained and Academy York Local Authority Schools (Excludes dual registered subsidiary pupils). All data is taken from the January School Census. Due to data protection requirements, we can't publish real values when those figures are < 5. Thus, those values have been converted to 9999.
Publisher name: City of York Council
Last updated: 2025-03-25T04:12:07Z

Tables

Number On Roll By Age

@ukgov.number_on_roll_by_age.number_on_roll_by_age

35.15 kB
682 rows
28 columns

CREATE TABLE number_on_roll_by_age (
  "schoolname" VARCHAR,
  "schoolphase" VARCHAR,
  "year" BIGINT,
  "n_1_pt" BIGINT  -- 1 PT,
  "n_2_pt" BIGINT  -- 2 PT,
  "n_3_pt" BIGINT  -- 3 PT,
  "n_4_pt" BIGINT  -- 4 PT,
  "n_1" BIGINT  -- 1,
  "n_2" BIGINT  -- 2,
  "n_3" BIGINT  -- 3,
  "n_4" BIGINT  -- 4,
  "n_5" BIGINT  -- 5,
  "n_6" BIGINT  -- 6,
  "n_7" BIGINT  -- 7,
  "n_8" BIGINT  -- 8,
  "n_9" BIGINT  -- 9,
  "n_10" BIGINT  -- 10,
  "n_11" BIGINT  -- 11,
  "n_12" BIGINT  -- 12,
  "n_13" BIGINT  -- 13,
  "n_14" BIGINT  -- 14,
  "n_15" BIGINT  -- 15,
  "n_16" BIGINT  -- 16,
  "n_17" BIGINT  -- 17,
  "n_18" BIGINT  -- 18,
  "n_19" BIGINT  -- 19,
  "n_20" BIGINT  -- 20,
  "total" BIGINT
);