About this Dataset

State Funded Schools

Spatial dataset of state funded schools in Durham, including academies. Please see https://www.durham.gov.uk/education for more information.
Publisher name: Durham County Council
Last updated: 2024-10-09T04:00:05Z

Tables

State Funded Schools 2017

@ukgov.https_datamillnorth_org_dataset_vq657_state_funded_schools.state_funded_schools_2017

25.55 KB
273 rows
11 columns


CREATE TABLE state_funded_schools_2017 (
  "name" VARCHAR,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "address3" VARCHAR,
  "postcode" VARCHAR,
  "telephone" VARCHAR,
  "dfes" BIGINT,
  "type" VARCHAR,
  "division" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT
);

State Funded Schools 2018

@ukgov.https_datamillnorth_org_dataset_vq657_state_funded_schools.state_funded_schools_2018

22.31 KB
270 rows
10 columns


CREATE TABLE state_funded_schools_2018 (
  "name" VARCHAR,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "address3" VARCHAR,
  "postcode" VARCHAR,
  "dfes" BIGINT,
  "type" VARCHAR,
  "division" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT
);

State Funded Schools 2019

@ukgov.https_datamillnorth_org_dataset_vq657_state_funded_schools.state_funded_schools_2019

24.87 KB
269 rows
9 columns


CREATE TABLE state_funded_schools_2019 (
  "name" VARCHAR,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "address3" VARCHAR,
  "postcode" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "lat" DOUBLE,
  "long" DOUBLE
);

State Funded Schools 2020

@ukgov.https_datamillnorth_org_dataset_vq657_state_funded_schools.state_funded_schools_2020

25.69 KB
269 rows
9 columns


CREATE TABLE state_funded_schools_2020 (
  "name" VARCHAR,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "address3" VARCHAR,
  "postcode" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "lat" DOUBLE,
  "long" DOUBLE
);

State Funded Schools 2022

@ukgov.https_datamillnorth_org_dataset_vq657_state_funded_schools.state_funded_schools_2022

25.58 KB
267 rows
9 columns


CREATE TABLE state_funded_schools_2022 (
  "name" VARCHAR,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "address3" VARCHAR,
  "postcode" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "lat" DOUBLE,
  "long" DOUBLE
);