About this Dataset

Lincolnshire Schools

This dataset contains information about open Lincolnshire schools. It includes details about the schools' governance, phase, intake and location.

The data is updated monthly to reflect the state of Lincolnshire schools as at the end of the previous month i.e. in April the data will be as at 31st March.

An Interactive Report is also available where the available data is visualised in a series of tables, charts and maps. Visit the Lincolnshire Schools - Interactive Report. (To return to this webpage, use the back button on your browser).

For any enquiries about this publication contact [schoolperformance@lincolnshire.gov.uk](mailto: schoolperformance@lincolnshire.gov.uk) .

You can freely re-use this data for any purpose. Please attribute as:
Contains public sector information licensed from Lincolnshire County Council under the Open Government Licence v3.0.
These copyright statements must be shown:
Contains OS data © Crown copyright and database right [year]. Contains Royal Mail data © Royal Mail copyright and database right [year].
Publisher name: Lincolnshire County Council
Last updated: 2025-06-13T04:00:02Z

Tables

Lincolnshire Schools

@ukgov.lincolnshire_schools.lincolnshire_schools

75.36 KB
387 rows
40 columns


CREATE TABLE lincolnshire_schools (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "latestdata" BOOLEAN,
  "durationfrom" TIMESTAMP,
  "durationto" TIMESTAMP,
  "month" TIMESTAMP,
  "year" BIGINT,
  "dfenumber" BIGINT,
  "ofstedurn" BIGINT,
  "schoolname" VARCHAR,
  "governance" VARCHAR,
  "phase" VARCHAR,
  "subphase" VARCHAR,
  "agerange" VARCHAR,
  "faithschool" VARCHAR,
  "open_date" TIMESTAMP,
  "intaketype" VARCHAR,
  "sixthform" VARCHAR,
  "academysponsor" VARCHAR,
  "federationname" VARCHAR,
  "numberonroll" DOUBLE,
  "uprn" DOUBLE,
  "full_address" VARCHAR,
  "postcode" VARCHAR,
  "district" VARCHAR,
  "districtcode" VARCHAR,
  "wardcode" VARCHAR,
  "wardname" VARCHAR,
  "lsoacode2011" VARCHAR,
  "lsoaname2011" VARCHAR,
  "msoacode2011" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "coordinatereferencesystem_wgs" VARCHAR,
  "geox_eastings" BIGINT,
  "geoy_northings" BIGINT,
  "coordinatereferencesystem_bng" VARCHAR,
  "geopointlicensingurl" VARCHAR,
  "attribution" VARCHAR
);