Borough By Sector Employee Jobs
Greater London Authority
@ukgov.borough_by_sector_employee_jobs
Greater London Authority
@ukgov.borough_by_sector_employee_jobs
CREATE TABLE n_2023_borough_by_sector (
"borough" VARCHAR,
"sector" VARCHAR,
"year" BIGINT,
"employee_jobs" DOUBLE
);
CREATE TABLE n_2017_borough_by_sector (
"area" VARCHAR,
"year" BIGINT,
"sector" VARCHAR,
"employee_jobs" VARCHAR
);
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
);
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
);
Anyone who has the link will be able to view this.