About this Dataset

Borough By Sector Employee Jobs

This dataset provides experimental estimates of borough-by-sector employee jobs in London. It provides a time series consistent with ONS Workforce Jobs data where this would not otherwise be available. The latest workbook provides employee jobs estimates for the period 1971-2022. The estimates are modelled from Business Register and Employment Survey (BRES) and Workforce Jobs (WFJ) data published by the Office for National Statistics (ONS). The methodology is summarised in the ‘cover’ sheet of the latest xlsx workbook. A csv datafile is also provided.
Publisher name: Greater London Authority
Last updated: 2024-07-20T04:00:07Z

Tables

2017 Borough By Sector

@ukgov.borough_by_sector_employee_jobs.n_2017_borough_by_sector

35.73 kB
24,525 rows
4 columns

CREATE TABLE n_2017_borough_by_sector (
  "area" VARCHAR,
  "year" BIGINT,
  "sector" VARCHAR,
  "employee_jobs" VARCHAR
);

2022 Borough By Sector

@ukgov.borough_by_sector_employee_jobs.n_2022_borough_by_sector

69.55 kB
528 rows
52 columns

CREATE TABLE n_2022_borough_by_sector (
  "borough" VARCHAR,
  "sector" VARCHAR,
  "n_1971" VARCHAR  -- 1971,
  "n_1972" VARCHAR  -- 1972,
  "n_1973" VARCHAR  -- 1973,
  "n_1974" VARCHAR  -- 1974,
  "n_1975" BIGINT  -- 1975,
  "n_1976" BIGINT  -- 1976,
  "n_1977" BIGINT  -- 1977,
  "n_1978" BIGINT  -- 1978,
  "n_1979" BIGINT  -- 1979,
  "n_1980" BIGINT  -- 1980,
  "n_1981" BIGINT  -- 1981,
  "n_1982" BIGINT  -- 1982,
  "n_1983" BIGINT  -- 1983,
  "n_1984" BIGINT  -- 1984,
  "n_1985" BIGINT  -- 1985,
  "n_1986" BIGINT  -- 1986,
  "n_1987" BIGINT  -- 1987,
  "n_1988" BIGINT  -- 1988,
  "n_1989" BIGINT  -- 1989,
  "n_1990" BIGINT  -- 1990,
  "n_1991" BIGINT  -- 1991,
  "n_1992" BIGINT  -- 1992,
  "n_1993" BIGINT  -- 1993,
  "n_1994" BIGINT  -- 1994,
  "n_1995" BIGINT  -- 1995,
  "n_1996" BIGINT  -- 1996,
  "n_1997" BIGINT  -- 1997,
  "n_1998" BIGINT  -- 1998,
  "n_1999" BIGINT  -- 1999,
  "n_2000" BIGINT  -- 2000,
  "n_2001" BIGINT  -- 2001,
  "n_2002" BIGINT  -- 2002,
  "n_2003" BIGINT  -- 2003,
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018,
  "n_2019" BIGINT  -- 2019,
  "n_2020" BIGINT  -- 2020
);

2023 Borough By Sector

@ukgov.borough_by_sector_employee_jobs.n_2023_borough_by_sector

19.68 kB
13,728 rows
4 columns

CREATE TABLE n_2023_borough_by_sector (
  "borough" VARCHAR,
  "sector" VARCHAR,
  "year" BIGINT,
  "employee_jobs" DOUBLE
);

2024 Borough By Sector

@ukgov.borough_by_sector_employee_jobs.n_2024_borough_by_sector

72.49 kB
528 rows
54 columns

CREATE TABLE n_2024_borough_by_sector (
  "borough" VARCHAR,
  "sector" VARCHAR,
  "n_1971" VARCHAR  -- 1971,
  "n_1972" VARCHAR  -- 1972,
  "n_1973" VARCHAR  -- 1973,
  "n_1974" VARCHAR  -- 1974,
  "n_1975" BIGINT  -- 1975,
  "n_1976" BIGINT  -- 1976,
  "n_1977" BIGINT  -- 1977,
  "n_1978" BIGINT  -- 1978,
  "n_1979" BIGINT  -- 1979,
  "n_1980" BIGINT  -- 1980,
  "n_1981" BIGINT  -- 1981,
  "n_1982" BIGINT  -- 1982,
  "n_1983" BIGINT  -- 1983,
  "n_1984" BIGINT  -- 1984,
  "n_1985" BIGINT  -- 1985,
  "n_1986" BIGINT  -- 1986,
  "n_1987" BIGINT  -- 1987,
  "n_1988" BIGINT  -- 1988,
  "n_1989" BIGINT  -- 1989,
  "n_1990" BIGINT  -- 1990,
  "n_1991" BIGINT  -- 1991,
  "n_1992" BIGINT  -- 1992,
  "n_1993" BIGINT  -- 1993,
  "n_1994" BIGINT  -- 1994,
  "n_1995" BIGINT  -- 1995,
  "n_1996" BIGINT  -- 1996,
  "n_1997" BIGINT  -- 1997,
  "n_1998" BIGINT  -- 1998,
  "n_1999" BIGINT  -- 1999,
  "n_2000" BIGINT  -- 2000,
  "n_2001" BIGINT  -- 2001,
  "n_2002" BIGINT  -- 2002,
  "n_2003" BIGINT  -- 2003,
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018,
  "n_2019" BIGINT  -- 2019,
  "n_2020" BIGINT  -- 2020,
  "n_2021" BIGINT  -- 2021,
  "n_2022" BIGINT  -- 2022
);