Dataset: Borough By Sector Employee Jobs

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

2023 Borough By Sector

@ukgov.borough_by_sector_employee_jobs.n_2023_borough_by_sector

19.22 KB
13728 rows
4 columns


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

2017 Borough By Sector

@ukgov.borough_by_sector_employee_jobs.n_2017_borough_by_sector

34.89 KB
24525 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

67.92 KB
528 rows
52 columns


CREATE TABLE n_2022_borough_by_sector (
  "borough" VARCHAR,
  "sector" VARCHAR,
  "n_1971" VARCHAR,
  "n_1972" VARCHAR,
  "n_1973" VARCHAR,
  "n_1974" VARCHAR,
  "n_1975" BIGINT,
  "n_1976" BIGINT,
  "n_1977" BIGINT,
  "n_1978" BIGINT,
  "n_1979" BIGINT,
  "n_1980" BIGINT,
  "n_1981" BIGINT,
  "n_1982" BIGINT,
  "n_1983" BIGINT,
  "n_1984" BIGINT,
  "n_1985" BIGINT,
  "n_1986" BIGINT,
  "n_1987" BIGINT,
  "n_1988" BIGINT,
  "n_1989" BIGINT,
  "n_1990" BIGINT,
  "n_1991" BIGINT,
  "n_1992" BIGINT,
  "n_1993" BIGINT,
  "n_1994" BIGINT,
  "n_1995" BIGINT,
  "n_1996" BIGINT,
  "n_1997" BIGINT,
  "n_1998" BIGINT,
  "n_1999" BIGINT,
  "n_2000" BIGINT,
  "n_2001" BIGINT,
  "n_2002" BIGINT,
  "n_2003" BIGINT,
  "n_2004" BIGINT,
  "n_2005" BIGINT,
  "n_2006" BIGINT,
  "n_2007" BIGINT,
  "n_2008" BIGINT,
  "n_2009" BIGINT,
  "n_2010" BIGINT,
  "n_2011" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT,
  "n_2018" BIGINT,
  "n_2019" BIGINT,
  "n_2020" BIGINT
);

2024 Borough By Sector

@ukgov.borough_by_sector_employee_jobs.n_2024_borough_by_sector

70.79 KB
528 rows
54 columns


CREATE TABLE n_2024_borough_by_sector (
  "borough" VARCHAR,
  "sector" VARCHAR,
  "n_1971" VARCHAR,
  "n_1972" VARCHAR,
  "n_1973" VARCHAR,
  "n_1974" VARCHAR,
  "n_1975" BIGINT,
  "n_1976" BIGINT,
  "n_1977" BIGINT,
  "n_1978" BIGINT,
  "n_1979" BIGINT,
  "n_1980" BIGINT,
  "n_1981" BIGINT,
  "n_1982" BIGINT,
  "n_1983" BIGINT,
  "n_1984" BIGINT,
  "n_1985" BIGINT,
  "n_1986" BIGINT,
  "n_1987" BIGINT,
  "n_1988" BIGINT,
  "n_1989" BIGINT,
  "n_1990" BIGINT,
  "n_1991" BIGINT,
  "n_1992" BIGINT,
  "n_1993" BIGINT,
  "n_1994" BIGINT,
  "n_1995" BIGINT,
  "n_1996" BIGINT,
  "n_1997" BIGINT,
  "n_1998" BIGINT,
  "n_1999" BIGINT,
  "n_2000" BIGINT,
  "n_2001" BIGINT,
  "n_2002" BIGINT,
  "n_2003" BIGINT,
  "n_2004" BIGINT,
  "n_2005" BIGINT,
  "n_2006" BIGINT,
  "n_2007" BIGINT,
  "n_2008" BIGINT,
  "n_2009" BIGINT,
  "n_2010" BIGINT,
  "n_2011" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT,
  "n_2018" BIGINT,
  "n_2019" BIGINT,
  "n_2020" BIGINT,
  "n_2021" BIGINT,
  "n_2022" BIGINT
);