About this Dataset

Geographic Lookups For London

This dataset contains a range of geographic lookup files to scale between different areas in London.
Publisher name: Greater London Authority
Last updated: 2024-10-13T04:00:04Z

Tables

2001 OA-LSOA-MSOA-LA

@ukgov.geographic_lookups_for_london.n_2001_oa_lsoa_msoa_la

312.16 KB
24140 rows
8 columns


CREATE TABLE n_2001_oa_lsoa_msoa_la (
  "oa01cd" VARCHAR,
  "lsoa01cd" VARCHAR,
  "lsoa01nm" VARCHAR,
  "msoa01cd" VARCHAR,
  "msoa01nm" VARCHAR,
  "lad01cd" VARCHAR,
  "lad01nm" VARCHAR,
  "inner_outer" VARCHAR
);

2001 OA-Ward-LA

@ukgov.geographic_lookups_for_london.n_2001_oa_ward_la

152.1 KB
24140 rows
6 columns


CREATE TABLE n_2001_oa_ward_la (
  "oa01cd" VARCHAR,
  "ward01cd" VARCHAR,
  "ward01nm" VARCHAR,
  "lad01cd" VARCHAR,
  "lad01nm" VARCHAR,
  "inner_outer" VARCHAR
);

2011 OA-LSOA-MSOA-LA

@ukgov.geographic_lookups_for_london.n_2011_oa_lsoa_msoa_la

310.24 KB
25053 rows
8 columns


CREATE TABLE n_2011_oa_lsoa_msoa_la (
  "oa11cd" VARCHAR,
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "msoa11cd" VARCHAR,
  "msoa11nm" VARCHAR,
  "lad11cd" VARCHAR,
  "lad11nm" VARCHAR,
  "inner_outer" VARCHAR
);

2011 OA-Ward-LA

@ukgov.geographic_lookups_for_london.n_2011_oa_ward_la

193.33 KB
25053 rows
6 columns


CREATE TABLE n_2011_oa_ward_la (
  "oa11cd" VARCHAR,
  "ward11cd" VARCHAR,
  "ward11nm" VARCHAR,
  "lad11cd" VARCHAR,
  "lad11nm" VARCHAR,
  "inner_outer" VARCHAR
);