About this Dataset

MyLondon

My London is a new tool to help people who are moving to London for the first time or who are moving within London. It allows people to define an area or neighbourhood of interest and pulls back an uptodate range of data important to decision making when moving house.
Publisher name: Greater London Authority
Last updated: 2024-09-14T08:09:13Z

Tables

Bounding Boxes

@ukgov.mylondon.bounding_boxes

1.79 MB
25,053 rows
10 columns

CREATE TABLE bounding_boxes (
  "lsoa" VARCHAR,
  "oa" VARCHAR,
  "left" DOUBLE,
  "bottom" DOUBLE,
  "right" DOUBLE,
  "top" DOUBLE,
  "easting" BIGINT,
  "northing" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Bounding Boxes (LSOA Resolution)

@ukgov.mylondon.bounding_boxes_lsoa_resolution

253.76 kB
4,835 rows
6 columns

CREATE TABLE bounding_boxes_lsoa_resolution (
  "lsoa" VARCHAR,
  "os" VARCHAR,
  "left" DOUBLE,
  "right" DOUBLE,
  "top" DOUBLE,
  "bottom" DOUBLE
);

Modelled OA Rents

@ukgov.mylondon.modelled_oa_rents

391.27 kB
25,053 rows
5 columns

CREATE TABLE modelled_oa_rents (
  "oa11cd" VARCHAR,
  "ave_rent_1_bedroom" BIGINT,
  "ave_rent_2_bedroom" BIGINT,
  "ave_rent_3_bedroom" BIGINT,
  "ave_rent_4_bedroom" BIGINT
);

MyLondon Fare Zone OA

@ukgov.mylondon.mylondon_fare_zone_oa

175.62 kB
25,053 rows
2 columns

CREATE TABLE mylondon_fare_zone_oa (
  "oa11cd" VARCHAR,
  "fare_zone" BIGINT
);

MyLondon LOAC Area Description Text V3

@ukgov.mylondon.mylondon_loac_area_description_text_v3

177.84 kB
25,053 rows
3 columns

CREATE TABLE mylondon_loac_area_description_text_v3 (
  "oa11cd" VARCHAR,
  "general_description" VARCHAR,
  "oa_description" VARCHAR
);

MyLondon Postcode OA

@ukgov.mylondon.mylondon_postcode_oa

162.67 kB
25,053 rows
2 columns

CREATE TABLE mylondon_postcode_oa (
  "oa11cd" VARCHAR,
  "pc_dist" VARCHAR
);

MyLondonSchoolsCatchmentv2

@ukgov.mylondon.mylondonschoolscatchmentv2

360.15 kB
25,053 rows
13 columns

CREATE TABLE mylondonschoolscatchmentv2 (
  "oa11cd" VARCHAR,
  "pschoolname1" VARCHAR,
  "pschool1percent" BIGINT,
  "pschoolname2" VARCHAR,
  "pschool2percent" VARCHAR,
  "pschoolname3" VARCHAR,
  "pschool3percent" VARCHAR,
  "sschoolname1" VARCHAR,
  "sschool1percent" BIGINT,
  "sschoolname2" VARCHAR,
  "sschool2percent" BIGINT,
  "sschoolname3" VARCHAR,
  "sschool3percent" VARCHAR
);

MyLondon Traveltime To Bank Station OA

@ukgov.mylondon.mylondon_traveltime_to_bank_station_oa

357.73 kB
25,053 rows
8 columns

CREATE TABLE mylondon_traveltime_to_bank_station_oa (
  "oa11cd" VARCHAR,
  "driving_distance_miles" DOUBLE,
  "driving_time_mins" BIGINT,
  "public_transport_time_mins" BIGINT,
  "cycling_distance_miles" DOUBLE,
  "cycling_time_mins" BIGINT,
  "walking_distance_miles" DOUBLE,
  "walking_time_mins" BIGINT
);

Summary

@ukgov.mylondon.summary

514.69 kB
25,053 rows
8 columns

CREATE TABLE summary (
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "lad" VARCHAR,
  "rent_per_m" BIGINT,
  "green_spac" DOUBLE,
  "travel" DOUBLE,
  "safety" DOUBLE,
  "schools" DOUBLE
);