Baselight

Borough By Sector Employee Jobs

Greater London Authority

@ukgov.borough_by_sector_employee_jobs

Loading...
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
);

Share link

Anyone who has the link will be able to view this.