About this Dataset

School Pupils Number On Roll

This dataset shows School Pupils Number on Roll (NOR) in Lincolnshire schools. Numbers of Pupils are shown by School and by School Phase, and by Age and National Curriculum Year. The dataset covers current and main pupils on the roll of schools in Lincolnshire. Pupil numbers are allocated to local authority district areas based on the geographical location of school. Points to be aware of: • Sixth form pupils who now attend consortia Sixth forms must be recorded as a subsidiary pupil at the school they receive education at and as a Main (Dual registered) pupil with the school that holds their registration details. • FTE means the full time equivalent numbers of pupils in attendance. For example, a class of 20 nursery children attending either mornings or afternoons only (half days) would count as 10 FTE. Note the FTE for Primary Schools includes Nursery Pupils Data is from the Schools Census and shows a snapshot in May. It is updated annually. Data source: Lincolnshire County Council Childrens Services. For any enquiries about this publication contact schoolcensus@lincolnshire.gov.uk
Publisher name: Lincolnshire County Council
Last updated: 2024-06-14T04:01:48Z

Tables

School Pupils Number On Roll

@ukgov.school_pupils_number_on_roll.school_pupils_number_on_roll

69.08 KB
369 rows
58 columns


CREATE TABLE school_pupils_number_on_roll (
  "organisationname" VARCHAR,
  "organisationcode" VARCHAR,
  "published_date" TIMESTAMP,
  "durationfrom" TIMESTAMP,
  "durationto" TIMESTAMP,
  "latestdata" BOOLEAN,
  "month" TIMESTAMP,
  "geoentityname" VARCHAR,
  "geocode" VARCHAR,
  "geoname" VARCHAR,
  "geouri" VARCHAR,
  "schoolphase" VARCHAR,
  "dfe_number" DOUBLE,
  "school_name" VARCHAR,
  "n__governance" VARCHAR,
  "age_1" DOUBLE,
  "age_2" DOUBLE,
  "age_3" DOUBLE,
  "age_4" DOUBLE,
  "age_5" DOUBLE,
  "age_6" DOUBLE,
  "age_7" DOUBLE,
  "age_8" DOUBLE,
  "age_9" DOUBLE,
  "age_10" DOUBLE,
  "age_11" DOUBLE,
  "age_12" DOUBLE,
  "age_13" DOUBLE,
  "age_14" DOUBLE,
  "age_15" DOUBLE,
  "age_16" DOUBLE,
  "age_17" DOUBLE,
  "age_18" DOUBLE,
  "age_19" DOUBLE,
  "age_20" DOUBLE,
  "ncyear_e2" DOUBLE,
  "ncyear_n1" DOUBLE,
  "ncyear_n2" DOUBLE,
  "ncyear_r" DOUBLE,
  "ncyear_1" DOUBLE,
  "ncyear_2" DOUBLE,
  "ncyear_3" DOUBLE,
  "ncyear_4" DOUBLE,
  "ncyear_5" DOUBLE,
  "ncyear_6" DOUBLE,
  "ncyear_7" DOUBLE,
  "ncyear_8" DOUBLE,
  "ncyear_9" DOUBLE,
  "ncyear_10" DOUBLE,
  "ncyear_11" DOUBLE,
  "ncyear_12" DOUBLE,
  "ncyear_13" DOUBLE,
  "ncyear_14" DOUBLE,
  "numberonroll_nor" BIGINT,
  "numberonroll_nor_minusnurseryorpreschoolpupils" DOUBLE,
  "totalfte" DOUBLE,
  "subsidiarypupils" DOUBLE,
  "total_nor_minussubsidiarypupils" DOUBLE
);

Table 2

@ukgov.school_pupils_number_on_roll.table_2

12.29 KB
58 rows
12 columns


CREATE TABLE table_2 (
  "dataset_id" BIGINT,
  "dataset_name" VARCHAR,
  "field" VARCHAR,
  "type" VARCHAR,
  "mandatory_or_optional_requirement_mor" VARCHAR,
  "field_description" VARCHAR,
  "schema" VARCHAR,
  "lcc_mapping" VARCHAR,
  "schema_comments" VARCHAR,
  "schema_data_rules_comment" VARCHAR,
  "formatreference" VARCHAR,
  "example" VARCHAR
);