About this Dataset

All Schools In Camden And Surrounding Boroughs

This dataset contains all the schools in the London Borough of Camden and surrounding boroughs that appear in the EduBase database (managed by the Department for Education). Attribution includes School type, name, address and location; as well as information on pupil numbers and facilities.
Publisher name: London Borough of Camden
Last updated: 2024-11-27T04:00:02Z

Tables

Table 1

@ukgov.all_schools_in_camden_and_surrounding_boroughs.table_1

179.55 kB
658 rows
79 columns

CREATE TABLE table_1 (
  "unique_reference_number" BIGINT,
  "local_authority_code" BIGINT,
  "local_authority_name" VARCHAR,
  "establishment_number" DOUBLE,
  "establishment_name" VARCHAR,
  "type_of_establishment" VARCHAR,
  "establishment_status" VARCHAR,
  "reason_establishment_opened" VARCHAR,
  "open_date" VARCHAR,
  "reason_establishment_closed" VARCHAR,
  "close_date" VARCHAR,
  "phase_of_education" VARCHAR,
  "statutory_low_age" DOUBLE,
  "statutory_high_age" DOUBLE,
  "boarders" VARCHAR,
  "official_sixth_form" VARCHAR,
  "gender" VARCHAR,
  "religious_character" VARCHAR,
  "diocese" VARCHAR,
  "admissions_policy" VARCHAR,
  "school_capacity" DOUBLE,
  "special_classes" VARCHAR,
  "census_date" VARCHAR,
  "number_of_pupils" DOUBLE,
  "number_of_boys" DOUBLE,
  "number_of_girls" DOUBLE,
  "percentage_claiming_free_school_meals" DOUBLE,
  "trust_school" VARCHAR,
  "trust_name" VARCHAR,
  "school_sponsored" VARCHAR,
  "school_sponsor" VARCHAR,
  "federation" VARCHAR,
  "federation_name" VARCHAR,
  "unique_property_reference_number" DOUBLE,
  "further_higher_education_identifier" DOUBLE,
  "further_education_type" VARCHAR,
  "ofsted_last_inspected" VARCHAR,
  "ofsted_special_measures" VARCHAR,
  "last_changed_date" VARCHAR,
  "street" VARCHAR,
  "locality" VARCHAR,
  "address_3" VARCHAR,
  "town" VARCHAR,
  "county" VARCHAR,
  "postcode" VARCHAR,
  "website" VARCHAR,
  "telephone_number" DOUBLE,
  "head_title" VARCHAR,
  "head_first_name" VARCHAR,
  "head_last_name" VARCHAR,
  "head_preferred_job_title" VARCHAR,
  "teen_mothers" VARCHAR,
  "teen_mothers_places" DOUBLE,
  "child_care_facilities" VARCHAR,
  "special_education_needs_pupil_referral_unit" VARCHAR,
  "emotional_behavioural_difficulties" VARCHAR,
  "full_time_provision" VARCHAR,
  "education_by_other" VARCHAR,
  "section_41_approved" VARCHAR,
  "special_education_needs_1" VARCHAR,
  "special_education_needs_2" VARCHAR,
  "region" VARCHAR,
  "administrative_ward" VARCHAR,
  "parliamentary_constituency" VARCHAR,
  "urban_rural" VARCHAR,
  "gssla_code" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "middle_super_output_area" VARCHAR,
  "lower_super_output_area" VARCHAR,
  "boarding_establishment" VARCHAR,
  "previous_local_authority_code" BIGINT,
  "previous_local_authority_name" VARCHAR,
  "previous_establishment_number" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "spatial_accuracy" VARCHAR,
  "last_uploaded" TIMESTAMP,
  "location" VARCHAR
);