DWP Tabulation Tool
Welcome to the DWPs Tabulation Tool.
This Tool allows you to download National Statistics to your requirements.
The best statistics to use are sourced from the newly published Work and Pensions Longitudinal Study (WPLS). These data are based on 100% of claimants and cover information such as age and gender of claimant, duration of their spell on benefit and geographical locations of claimants.
If you require more detailed breakdowns specific to one benefit (for example type of JSA in payment) you may need to rely on our 5% sample data which has more detail but less comprehensive coverage.
Please use the WPLS data first, and only access the samples if the data you need is not available on the WPLS. DWP recommends that, where the detail is only available on the 5% sample data, the proportions derived should be applied to the overall 100% total for the benefit. The Guide to Sources document lists which information is available from each data source and provides more detail.
For more information on the two sources, download this Guide to Sources (76KB) 
For information on the differences between DWP JSA statistics and ONS Claimant Count statistics, download this Information on Differences (104KB)
Local Authority Boundary Changes (1st April 2009)
On 1st April 2009, the reorganisation of the Local Authorities of England created nine new unitary authorities (UAs). From May 2009 these changes will be reflected in the Tabulation Tool.Further details of the reorganisation are shown below:
- Bedford UA will be formed from Bedford District Council
- Central Bedfordshire UA will be formed from Mid Beds and South Beds District Councils.
- Cheshire East UA will be formed from Congleton, Crewe & Nantwich and Macclesfield District Councils.
- Cheshire West and Chester UA will be formed from Chester, Ellesmere Port and Vale Royal District Councils.
- Cornwall UA will be formed from the Caradon, Carrick, Kerrier, North Cornwall, Penwith and Restormel District Councils (note the Isles of Scilly remains separate).
- County Durham UA will be formed from Chester-le-Street, Derwentside, Durham, Easington, Sedgefield, Teesdale and Wear Valley District Councils.
- Northumberland UA will be formed from Alnwick, Berwick-upon-Tweed, Blyth Valley, Castle Morpeth, Tynedale and Wansbeck District Councils.
- Shropshire UA will be formed from Bridgnorth, North Shropshire, Oswestry, Shrewsbury and South Shropshire District Councils.
- Wiltshire UA will be formed from Kennet, North Wiltshire, Salisbury and West Wiltshire District Councils.
Benefit Data:
Click here for: Benefit Caseload National Statistics (WPLS) data
Click here for: Employment and Support Allowance (ESA) data
Click here for: JSA Sanction & Disallowance Decision Stats
Click here for Neighbourhood Statistics Data: Ward and Super Output Area/Data Zone
Or here if the WPLS data does not hold the detail you need: Sample data
For enquiries please contact the appropriate member of the Information Directorate using the list at this link https://secureonline.dwp.gov.uk/iad-contact/contacts.asp
Benefit Flows Data (experimental):
The Flows tabulation tool will not be updated from and including May 2008. The historic flows information will remain, however there will be no further updates on superstats day until further notice. Updated pension credit information will be available via a one-click table. If you require information on flows please contact our adhocs team via the following email address: gillian.ferry@dwp.gsi.gov.uk.
Click here for On Flows data (excludes JSA)
Click here for Off Flows data (excludes JSA)
Click here to view ONS JSA Claimant Count Flows data
Or here for a Guide to using Experimental Statistics
Employment Programmes:
Click here: Employment Programmes
Please note that this link to Vacancy statistics has been disabled, please see the note below for further information.
Information Directorate have withdrawn the Vacancy Tab Tool from the DWP website. Users can access National Statistics on vacancies notified to Jobcentre Plus via the NOMIS site.
If you wish to discuss the withdrawn vacancy data please contact: elaine.cuthbert@dwp.gsi.gov.uk.
Lifetime Labour Market Data:
Click here for: Lifetime Labour Market Data
National Insurance Number Allocations to Adult Overseas Nationals entering the UK:
Tabulation Tool – latest quarterly data to September 2009
Click here for: Tabulation Tool
Analytic Report – reflects latest annual figures to March 2009
Click here for: Analytical report (504KB)
Summary Tables - latest quarterly data to September 2009
Click here for: Summary tables (493KB) 
Lone Parents claiming JSA
These figures provide a lone parent breakdown of the Office for National Statistics Jobseeker's Allowance Claimant Count statistics. This is in response to the changes to the eligibility rules for Income Support introduced in November 2008. The breakdown is not available for the DWP JSA figures, and is produced one month in arrear of the ONS publication. Click here to access the tables and background information Lone Parents claiming JSA
Children in Out of Work Benefit Households
These figures provide a breakdown of the statistics on Children in Out of Work Benefit Households. Click here to access the tables and background information on Children in Out of Work Benefit Households
Early Estimates for Working Age Inactive Benefit Client Groups
These figures provide early estimates and are designed to give indicative, timely information; they are not a substitute for the National Statistics. The early estimates will be replaced by the quarterly National Statistics covering the same period when they are published. The National Statistics are the finalised figures.
Click here for Early Estimate documents.
Tabulation Tool Redevelopment
DWP is currently in the process of redeveloping the Tabulation Tool with a view to providing a new and improved service in the future. We previously asked for feedback from our users which we have now completed collecting. Thank you to all those who contributed.
Contact us
If you would like to give us feedback on the Tabulation Tool please e-mail us at: stats-consultation@dwp.gsi.gov.uk
For all other enquiries please contact the appropriate member of the Information Directorate using the list at this link:
https://secureonline.dwp.gov.uk/iad-contact/contacts.asp