About this Dataset

School Capacity Projections

This data shows Actual and Projected Pupil Numbers and Capacity of Schools by local authority district. 'Actual' figures provided are based on October school census data for the relevant year of intake. For more information please see the annual School Organisation Plan published by Lincolnshire County Council. This data is updated annually. Data source: Lincolnshire County Council School Organisation Planning Team. For any enquiries about this publication contact schoolorganisation@lincolnshire.gov.uk
Publisher name: Lincolnshire County Council
Last updated: 2025-02-13T04:00:02Z

Tables

School Capacity Projections

@ukgov.school_capacity_projections.school_capacity_projections

13.08 kB
196 rows
15 columns

CREATE TABLE school_capacity_projections (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "latestdata" BOOLEAN,
  "durationfrom" TIMESTAMP,
  "durationto" TIMESTAMP,
  "geoentityname" VARCHAR,
  "geocode" VARCHAR,
  "geoname" VARCHAR,
  "geouri" VARCHAR,
  "year" BIGINT,
  "pupilnumbersorcapacity_pan" VARCHAR  -- PupilNumbersOrCapacity(PAN),
  "schoolyear" VARCHAR,
  "actualorprojected" VARCHAR,
  "value" BIGINT
);

Table 2

@ukgov.school_capacity_projections.table_2

11.83 kB
17 rows
12 columns

CREATE TABLE table_2 (
  "dataset_id" BIGINT,
  "dataset_name" VARCHAR,
  "field" VARCHAR,
  "type" VARCHAR,
  "mandatory_or_optional_requirement_mor" VARCHAR  -- Mandatory Or Optional Requirement (MOR),
  "field_description" VARCHAR,
  "schema" VARCHAR,
  "lcc_mapping" VARCHAR,
  "schema_comments" VARCHAR,
  "schema_data_rules_comment" VARCHAR,
  "formatreference" VARCHAR,
  "example" VARCHAR
);