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

319.65 kB
24,140 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

155.75 kB
24,140 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

317.69 kB
25,053 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

197.97 kB
25,053 rows
6 columns

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