About this Dataset

School Pupils Numbers On Roll, And Free School Meals

This dataset shows: • Pupil Numbers on Roll (NOR) in Lincolnshire schools. NOR is the total number of pupils on school rolls. • Pupils receiving Free School Meals, numbers and percentages. The dataset covers current and main pupils on the roll of schools in Lincolnshire, and includes Gender breakouts. Pupils are allocated to geographical areas (Wards and NHS Clinical Commissioning Groups) based on home address. Figures shown in the data as ‘Out of County’ represent pupils not resident within the Lincolnshire administrative boundary. Those are included in the Lincolnshire total. Data is suppressed where appropriate 5 persons and below (which may be shown as zero or by missing data). That and any unmatched postcodes may mean numbers for small areas might not add up exactly to figures shown for larger areas. Data is from the Schools Census and shows a snapshot in January. 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 Numbers On Roll, And Free School Meals

@ukgov.school_pupils_numbers_on_roll_and_free_school_meals.school_pupils_numbers_on_roll_and_free_school_meals

27.47 KB
160 rows
21 columns


CREATE TABLE school_pupils_numbers_on_roll_and_free_school_meals (
  "organisationname" VARCHAR,
  "organisationcode" VARCHAR,
  "publisheddate" TIMESTAMP,
  "durationfrom" VARCHAR,
  "durationto" VARCHAR,
  "latestdata" BOOLEAN,
  "geoentityname" VARCHAR,
  "geocode" VARCHAR,
  "geoname" VARCHAR,
  "geouri" VARCHAR,
  "year" BIGINT,
  "month" TIMESTAMP,
  "pupils_totalnumberonroll" BIGINT,
  "boys_totalnumberonroll" BIGINT,
  "girls_totalnumberonroll" BIGINT,
  "pupils_freeschoolmeals_number" BIGINT,
  "pupils_freeschoolmeals_percent" DOUBLE,
  "boys_freeschoolmeals_number" BIGINT,
  "boys_freeschoolmeals_percent" DOUBLE,
  "girls_freeschoolmeals_number" BIGINT,
  "girls_freeschoolmeals_percent" DOUBLE
);

Table 1

@ukgov.school_pupils_numbers_on_roll_and_free_school_meals.table_1

11.57 KB
21 rows
12 columns


CREATE TABLE table_1 (
  "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
);