Labour Market Statistics Data Tables (Excel Spreadsheets), May 2012

Abstract

This document provides an index of data tables. The data tables contain historic data data going back as far as comparable data exists for each time series. The spreadsheets can be accessed from hyperlinks within the index. Most of the spreadsheets showing estimates obtained from the Labour Force Survey (eg, employment, unemployment and economic inactivity) have been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. These spreadsheets have macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer. You can either change the security settings or unhide the rows manually.

Summary tables

A01: Labour market statistics summary data tables. (2.5 Mb ZIP) This document contains the data tables which appear in the pdf version of the Labour Market Statistical Bulletin.

A02: Labour force survey summary (employment, unemployment and inactivity). (1.16 Mb Excel sheet) This table shows the headline estimates of employment, unemployment and economic inactivity. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

A03: Labour Force Survey summary (employment, unemployment and inactivity) for men aged from 16 to 64 and women aged from 16 to 59. (739.5 Kb Excel sheet) The employment and inactivity rates shown in this table were the headline employment and inactivity rates until August 2010, when ONS replaced these headlines rates with rates for those aged from 16 to 64 for both men and women. These new headline rates for those aged from 16 to 64 are shown in Table A02. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

A04: Labour market summary (employment, unemployment and inactivity) for people below state pension age. (267 Kb Excel sheet) This table is updated four times a year in February, May, August and November. Estimates in this table follow the incemental increase in the female state pension age each quarter. Between 2010 and 2018 the state pension age for women will increase gradually from 60 to 65. These estimates are not the headline labour force survey estimates. The headline estimates are shown at Table A02. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

A05: Labour market status (employment, unemployment and inactivity) by age group. (3 Mb Excel sheet) This table shows estimates of employment, unemployment and economic inactivity by sex and age group. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

A06: Educational status and labour market status (employment, unemployment and inactivity) of people aged from 16 to 24. (2.07 Mb Excel sheet) This table shows estimates for people in full-time education and people not in full-time education. Not in full-time education includes people in part-time education and/or some form of training. Estimates of young people not in employment, education or training ("NEET") cannot therefore be derived from this table. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

A07: Regional labour market summary. (101.5 Kb Excel sheet) This table shows estimates of employment, unemployment and economic inactivity by region.

A08: Labour market status (employment, unemployment and inactivity) of disabled people. (205.5 Kb Excel sheet) This table is updated four times a year in February, May, August and November. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

A09: Labour market status (employment, unemployment and inactivity) by ethnic group. (728.5 Kb Excel sheet) This table is usually updated four times a year in February, May, August and November. This table has not been updated since February 2011. It will be updated again as soon as possible.

A10: International comparisons of employment and unemployment rates. (263.5 Kb Excel sheet) The tables contains data for all EU member states plus the United States, Canada and Japan.

A11: Labour Force Survey Sampling Variability (95% confidence intervals). (51 Kb Excel sheet) This table show sampling variability estimates for key Labour Force Survey indicators for the UK and for the regions.

Employment tables

EMP01: Full-time, part-time and temporary workers. (1.2 Mb Excel sheet) This table shows seasonally adjusted and unadjusted estimates of employment and is updated every month. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

EMP02: Public and private sector employment. (70.5 Kb Excel sheet) This table is updated in March, June, September and December.

EMP03: Public sector employment by industry. (51 Kb Excel sheet) This table is updated in March, June, September and December.

EMP04: Public sector employment including and excluding financial corporations. (33 Kb Excel sheet) This table is updated in March, June, September and December.

EMP05: Employment levels by country of birth and nationality. (162.5 Kb Excel sheet) The spreadsheet also includes Table EMP06 (employment rates by country of birth and nationality). These estimates are updated in February, May, August and November. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

EMP06: Employment rates by country of birth and nationality. (162.5 Kb Excel sheet) The spreadsheet also includes Table EMP05 (Employment levels by country of birth and nationality). These estimates are updated in February, May, August and November. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

EMP07: Temporary employees: all and part-time. (118 Kb Excel sheet) This table is updated four times a year in February, May, August and November. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

EMP08: All in employment by occupation. (101.5 Kb Excel sheet) This table is published four times a year in February, May, August and November. A more detailed employment by occupation spreadsheet, published once a year, is available at Table EMP16 (290 Kb Excel sheet) . This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

EMP09: Employees and self-employed by occupation. (127 Kb Excel sheet) This table is updated four times a year in February, May, August and November. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

EMP10: Part-time and temporary workers by occupation. (109.5 Kb Excel sheet) This table is updated four times a year in February, May, August and November. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

EMP11: Employment by socio-economic classification. (39.5 Kb Excel sheet) This table is usually updated four times a year in February, May, August and November. This table has not been updated since February 2011. It will be updated again as soon as possible. It is usually updated four times a year in February, May, August and November.

EMP12: Part-time and temporary workers by socio-economic classification. (45.5 Kb Excel sheet) This table is usually updated four times a year in February, May, August and November. This table has not been updated since February 2011. It will be updated again as soon as possible. It is usually updated four times a year in February, May, August and November.

EMP13: Employment by industry (Labour Force Survey). (151.5 Kb Excel sheet) This table is updated four times a year in February, May, August and November. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.
NOTE: Workforce jobs, mainly sourced from employer surveys, provides a more reliable industrial breakdown than the Labour Force Survey. Workforce jobs by industry estimates are available at Table JOBS02 (303 Kb Excel sheet) . The public and private sector employment estimates shown at Table EMP02 (70.5 Kb Excel sheet) provide more reliable estimates than the figures from the Labour Force Survey shown in this table.

EMP14: Employees and self-employed by industry (Labour Force Survey). (249.5 Kb Excel sheet) This table is updated four times a year in February, May, August and November. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.
NOTE: Workforce jobs, mainly sourced from employer surveys, provides a more reliable industrial breakdown than the Labour Force Survey. Workforce jobs by industry estimates are available at Tables JOBS02 (303 Kb Excel sheet) and JOBS03 (644.5 Kb Excel sheet) .

EMP15: Job related training received by employees. (151 Kb Excel sheet) This table is updated four times a year in February, May, August and November. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

EMP16: Employment by Occupation. (290 Kb Excel sheet) This spreadsheet is published once a year in August and provides a detailed snapshot of employment by occupation, broken down by gender, for April-June 2011. Earlier versions of this spreadsheet containing data back to 2001 are available here.

EMP17: Employment rate revisions triangle. (494.5 Kb Excel sheet) This spreadsheet shows a revisions triangle for the headline seasonally adjusted employment rate for those aged from 16 to 64.

Hours of work tables

HOUR01: Actual weekly hours worked. (472 Kb Excel sheet) This table shows estimates of actual hours worked including paid and unpaid overtime. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

HOUR02: Usual weekly hours worked. (1.49 Mb Excel sheet) This table shows estimates of usual weekly hours worked in main jobs including paid and unpaid overtime. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

HOUR03: Average hours worked by industry. (165.5 Kb Excel sheet) This table is updated four times a year in February, May, August and November. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

Earnings tables

Monthly Wages & Salaries Survey

EARN01: Average Weekly Earnings (AWE), seasonally adjusted. (413 Kb Excel sheet) This table shows the headline estimates of earnings growth sourced from the Monthly Wages and Salaries Survey.

EARN02: Average weekly earnings by sector. (374.5 Kb Excel sheet) Tables EARN02 and EARN03 show more detailed earnings estimates sourced from the Monthly Wages and Salaries Survey.

EARN03: Average weekly earnings by industry. (521 Kb Excel sheet)   Tables EARN02 and EARN03 show more detailed earnings estimates sourced from the Monthly Wages and Salaries Survey.

Labour Force Survey

EARN04: Gross weekly earnings of full-time employees (Labour Force Survey). (122 Kb Excel sheet) This table is updated four times a year in February, May, August and November. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

EARN05: Gross weekly earnings of full-time employees by region (Labour Force Survey). (137 Kb Excel sheet) This table is updated four times a year in February, May, August and November. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

EARN06: Gross weekly earnings by occupation (Labour Force Survey). (181 Kb Excel sheet) This table is updated four times a year in February, May, August and November. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

EARN07: Gross weekly earnings by industry (Labour Force Survey). (295 Kb Excel sheet) This table is updated four times a year in February, May, August and November.  This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

EARN08: Distribution of gross hourly earnings of employees (Labour Force Survey). (293 Kb Excel sheet) This table is updated four times a year in February, May, August and November. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

Productivity and Labour Disputes tables

Productivity

PROD01: Labour productivity. (75 Kb Excel sheet) This table is updated four times a year in January, April, July and October.

Labour Disputes

LABD01: Labour disputes. (107.5 Kb Excel sheet) This table shows estimates for labour disputes and is updated every month.

LABD02: Labour disputes by sector. (81 Kb Excel sheet) This table shows more detailed estimates of labour disputes by sector and is updated every month.

LABD03: Stoppages of work. (79 Kb Excel sheet) This table provides estimates of stoppages of work and is updated every month.

Unemployment tables

UNEM01: Unemployment by age and duration. (1.95 Mb Excel sheet) This table shows the headline estimates of unemployment by age, sex and duration. The table is updated every month. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

UNEM02: Unemployment by previous occupation. (194 Kb Excel sheet) This table is updated four times a year in February, May, August and November.   This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

UNEM03: Unemployment by previous industrial sector. (242 Kb Excel sheet) This table is updated four times a year in February, May, August and November. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

UNEM04: Unemployment rate revisions triangle. (1.44 Mb Excel sheet) This table show a revisions triangle for the headline unemployment rate for those aged 16 and over.

Economic Inactivity and Redundancies tables

Economic inactivity

INAC01: Economic inactivity by reason. (2.33 Mb Excel sheet) This table shows the headline estimates of inactivity by reason for inactivity and by sex. The table is updated every month. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

Redundancies

RED01: Redundancies levels and rates. (185.5 Kb Excel sheet) This table shows estimates of whole economy redundancies by sex. The table is update every month. This spreadsheet has been set up in printer-friendly format showing data for the last two years, with historic data appearing in hidden rows. The spreadsheet has macro buttons to unhide the rows to enable users to view the entire time series. If the macros do not work this is probably due to the security settings on your computer - you can either change the security settings or unhide the rows manually.

RED02: Redundancies by industry, age, sex and re-employment rates (not seasonally adjusted). (2.39 Mb Excel sheet) This table shows more detailed estimates of redundancies and is updated four times a year in February, May, August and November.

Claimant Count and Benefits tables

Claimant count

CLA01: Claimant count summary. (293 Kb Excel sheet) The table provides estimates of the number of people claiming unemployment-related benefits; since October 1996 this has been the number of people claiming Jobseeker's Allowance (JSA).

CLA02: Claimant count by age and duration. (514 Kb Excel sheet) The table provides estimates of the number of people claiming jobseeker's allowance (JSA) by age, sex and duration of claim.

CLA03: Lone parent claimants of jobseeker's allowance. (63.5 Kb Excel sheet) The table provides estimates of the number of lone parents claiming jobseeker's allowance (JSA). These estimates are not designated as National Statistics.

CLA04: Claimant count revisions triangle. (1.41 Mb Excel sheet) This table provides a revisions triangle for the headline claimant count level.

Benefits

BEN01: Key out of work benefits. (58.5 Kb Excel sheet) Key out of work benefits includes those benefits paid to people subject to labour market activation policies by the Department for Work and Pensions. The table is usually updated four times a year in February, May, August and November.

Jobs tables

JOBS01: Workforce jobs summary. (47 Kb Excel sheet) This table shows estimates of employee jobs, self-employment jobs, HM Forces jobs and government supported trainee jobs. Workforce jobs tables are usually only updated in March, June, September and December.

JOBS02: Workforce jobs by industry. (303 Kb Excel sheet) This table shows estimates of jobs by industry according to Standard Industrial Classification 2007. Workforce jobs tables are usually only updated in March, June, September and December.

JOBS03: Employee jobs by industry. (644.5 Kb Excel sheet) This table shows estimates of employee jobs by industry according to Standard Industrial Classification 2007. This table is usually only updated in March, June, September and December.

JOBS04: Workforce jobs by region and industry. (332 Kb Excel sheet) This table shows estimates of workforce jobs by region and industry. Workforce jobs tables are usually only updated in March, June, September and December.

JOBS05: Workforce jobs revisions triangle. (311 Kb Excel sheet) This spreadsheet provides a revisions triangle for the headline seasonally adjusted estimate of total workforce jobs. Workforce jobs tables are usually only updated in March, June, September and December.

Vacancies tables

VACS01: Vacancies and unemployment. (41.5 Kb Excel sheet) This table provides estimates of the number of unemployed people per vacancy. The table is updated every month.

VACS02: Vacancies by industry. (192.5 Kb Excel sheet) This table shows vacancies by industry according to Standard Industrial Classification 2007. The table is updated every month.

VACS03: Vacancies by size of business. (64.5 Kb Excel sheet) This table shows estimates of vacancies by size of business. The table is updated every month.

Background notes

1. These data tables are accompanied by a Statistical Bulletin.                  

2. Details of the policy governing the release of new data are available by visiting www.statisticsauthority.gov.uk/assessment/code-of-practice/index.html or from the Media Relations Office email: media.relations@ons.gsi.gov.uk

   The United Kingdom Statistics Authority has designated these statistics as National Statistics, in accordance with the Statistics and Registration Service Act 2007 and signifying compliance with the Code of Practice for Official Statistics.

   Designation can be broadly interpreted to mean that the statistics:

   • meet identified user needs;
   • are well explained and readily accessible;
   • are produced according to sound methods; and
   • are managed impartially and objectively in the public interest.

   Once statistics have been designated as National Statistics it is a statutory requirement that the Code of Practice shall continue to be observed.