Tabulation Tool
Working Age percentage of population

Other DWP benefit/scheme TabTool(JavaScript Version) Background Information Details on breakdowns How to use this tool

Percentage of population help

Useful Resources and Sites
Information on Resource Link to Resource Return to TabTool
"One click" GOR percentages of population by gender: February 2010View ResourceTop of page
Northern Ireland Benefit StatisticsView ResourceTop of page
Guidance for usersView ResourceTop of page
Statistical SummaryView ResourceTop of page
Methodology paperView ResourceTop of page
NOMIS - official labour market statisticsView ResourceTop of page
Office for National StatisticsView ResourceTop of page

Background Information
Summary Return to TabTool
Data about the ‘key’ benefits for clients are merged together to create “Client Group” data, providing information about wheth

Data about the ‘key’ benefits for clients are merged together to create “Client Group” data, providing information about whether a client is on more than one benefit. The client groups are Clients of Working Age; Clients of State Pension Age; and Children.

The Statistical Group typology for the client groups presents each person by the main reason they are in contact with the Department.

The key benefits which currently form the Working Age Client Group include the following benefits; Bereavement Benefit, Carer’s Allowance, Disability Living Allowance, Employment and Support Allowance (from November 2008), Incapacity Benefit, Income Support, Jobseeker’s Allowance and Widow’s Benefit.

These benefits are arranged hierarchically and claimants are assigned to the topmost benefit which they receive. Thus a person who is a lone parent and receives Incapacity Benefit would be classified as ‘Employment and Support Allowance and incapacity benefits’, whereas someone receiving both Bereavement Benefit and Disability Living Allowance would be classified as ‘Disabled’. For this reason the group ‘Lone Parent’, for example will not contain all lone parents claiming Income Support. Some will be included in the ‘Employment and Support Allowance and incapacity benefits’ group instead.

Benefit being claimed

Title of group

Jobseeker’s Allowance

Jobseekers

Employment and Support Allowance, Incapacity Benefit or Severe Disablement Allowance

Employment and Support Allowance and incapacity benefits

Income Support with a child under 16 and no partner

Lone Parent

Carer’s Allowance

Carer

Other Income Support (including IS Disability Premium) or Pension Credit

Other on Income Related Benefit

Disability Living Allowance, Attendance Allowance or Industrial Injuries benefits

Disabled

Widow’s Benefit, Bereavement Benefit or Industrial Death Benefit

Bereaved

Housing Benefit, Council Tax Benefit 1

Housing related

State Pension and no other benefit

Claiming State Pension only

1. At present Housing Benefit (HB), Council Tax Benefit (CTB) and Industrial Injuries Benefits are not included in WPLS. HB and CTB are expected to be added in the future. Hence, this group does not yet appear in the statistics.

Lone Parent Obligations: From 24th November 2008 lone parent obligations (LPOs) were introduced and lone parents with a youngest child aged 12 or over were no longer able to make a new or repeat claim for Income Support (IS) solely on the basis of their parental status. Existing IS LPs with a youngest child aged 12 or over had their eligibility removed over a period of time commencing 2nd March 2009. From October 2009 this policy was extended to LPs with a youngest child aged 10 or 11 and from October 2010 the policy will be extended to LPs with a youngest child aged 7 or over. Most effected LPs will leave IS and claim Jobseeker's Allowance (JSA). However, there are exceptions to these rules where the youngest child can legitimately be over the ages mentioned above. Similarly, some former LPs remain on IS for other reasons (e.g. they have a long term caring responsibility and claim Carer's Allowance). Through analysis of the effected claimants over the next quarters, it can be decided if there is a requirement to change the structure of IS LP statistics. In the meantime, the IS LP series will continue to be defined as 'single IS claimants with a child under 16'.

The effect of Tax Credits: From April 2003 figures in this, and future DWP publications, are affected by the introduction of Child Tax Credits (CTC). The main changes are:

  • Child dependency increases paid with non-income related benefits were abolished for new claims to State Pension, Bereavement Benefit, Incapacity Benefit and Carer’s Allowance from April 2003.
  • From April 2003 onwards, CTC replaced the child elements of Income Support (IS) and income-based Jobseeker’s Allowance (JSA(IB)) for those with a Tax Credits award.

Percentage of population: Population figures have been produced based on the Office for National Statistics official population estimates. Percentages are provided as "row percentages", with the columns showing a breakdown of the population in the row.

 

Total

Males

Females

Total

20%

11%

9%

England

17%

10%

7%

Scotland

22%

11%

11%

Wales

23%

14%

9%

For example, 20% of the British population are claiming this fictional benefit and 11% of the British population are male and claiming this fictional benefit. This is does not show males claiming this benefit as percentage of males in the population. To produce those statistics, use "gender" as the row breakdown for the table.

 

Total

England

Scotland

Wales

Total

20%

16%

3%

1%

Males

22%

17%

3%

2%

Females

18%

15%

2%

1%

This table shows that 22% of the British population of males are claiming this fictional benefit. Is also shows that 17% of the British population of males are claiming this benefit and living in England.

Two percentage of population breakdowns exist:

  • the first allows splits by Local Authority BUT uses the population estimates for mid 2004 for the most recent quarters. This has the effect of slightly increasing the percentage of population reported for recent quarters. This is because the true Local Authority population is likely to have increased slightly since the most recent figures in 2004;
  • the second allows splits by Government Office Region and does not provide a Local Authority breakdown. It uses population projection figures up to the most recent quarter. This gives accurate percentage of population figures. Use these tables for all analyses that do not require a Local Authority split.

 

Local Authority Boundary Changes: On 1st April 2009, the reorganisation of the Local Authorities of England created nine new unitary authorities (UAs). From May 2009 these changes were reflected in the Tabulation Tool.

Coverage: All cases in payment in Great Britain. This excludes cases in Northern Ireland. Please see http://www.dsdni.gov.uk/index/stats_and_research/benefit_publications.htm for information about benefits in Northern Ireland.

Top of page

Details on breakdowns
Variable Information on Variable Return to TabTool
Caseload (Thousands) Number of clients on the administrative system at the reference date. These figures are shown in thousands, rounded to the nearest ten cases. So, 12,345 is shown as 12.35 thousand. Top of page
Time Series These tables represent the situation at a specific point in time, called the reference date. Using "Time Series" in the row of the table gives statistics for all dates available. Top of page
Government Office region Government Office Regions are assigned by matching postcodes against the relevant postcode direcory. More information and map of Government office regions is available at: http://www.statistics.gov.uk/geography/gor.asp Top of page
Partner flag Whether the claimant has a partner, as recorded on the administrative system. Top of page
Gender of claimant Gender as recorded on the benefit system. Top of page
Statistical Group The statistical group of the client which is based on the combination of benefits being claimed. Top of page
Age of claimant Age is calculated at the reference date. It is derived from the reference date and the client's date of birth. Top of page
Percentage of population Population figures have been produced at the end of each month based on the Office for National Statistics official population estimates. Two percentage of population breakdowns exist: one allows splits by Local Authority BUT uses the population estimates for mid 2004 for the most recent quarters; the other allows splits by Government Office Region and uses population projection figures up to the most recent quarter. Use this second table for all analyses that do not require a Local Authority split. Top of page
Duration of oldest current claim The duration of the oldest benefit which the client is currently claiming. Top of page
Number of children The number of dependants includes children aged 0-16 for whom additional benefit is paid and those aged 16-18 in full time education. Data about children is affected by the introduction of Tax Credits in April 2003. Top of page
Age of youngest child dependant Age is calculated at the reference date. It is derived from the reference date and the child's date of birth. Top of page


Information on using this Tool
Summary Return to TabTool
How to use the Tool

This tool allows you to produce bespoke tabulations to your requirement of the benefit or scheme in which you are interested. You can save the tables as a text file or an html which can then be opened in a spreadsheet program.

To define the structure of a table you are taken through a step-by-step process. This section describes what each step means, together with two examples.

STEP 1: CHOOSE AN ANALYSIS VARIABLE Choose the type of information you want displayed in the body of the table. Example choices are: caseload (i.e. number of people), average amount in payment or percentage of population.

STEP 2: CHOOSE A ROW VARIABLE From the list, choose the breakdown you would like to use for the rows of the table.

STEP 3: CHOOSE A COLUMN VARIABLE Choose from the list the breakdown you would like to use for the columns of the table.

STEP 4: CHOOSE A SUBSET OR A TIME SERIES Select either "Time Series" to choose the date you require information for, or choose the breakdown by which you want to subset the table.

STEP 5a: If you chose Time Series: CHOOSE A DATE A list of dates will appear for which your table is available. Clicking one of the dates will take you to the relevant table.

STEP 5b: If you chose to subset your data: CHOOSE A TIME SERIES The categories for the variable you chose to subset the data by will appear. Click on Time Series next to the catgory by which you want to subset your data.

STEP 6: CHOOSE A TIME SERIES A list of dates will appear for which your table is available. Clicking one of the dates will take you to the relevant table.

Throughout the process of defining your table, your choices are displayed at the top of the page.

Example 1 builds a time series table for statistical groups, restricted to male Income Support claimants. Example 2 gets data for Disability Living Allowance claimants, age and gender at May 2005.

Step Action
Example 1
Benefit/Scheme Income Support
Analysis Caseload (Thousands)
Row Time Series
Column Statistical Group
Subset or Time Series Gender
Category Male - click on Time Series
Example 2
Benefit/Scheme Disability Living Allowance
Analysis Caseload (Thousands)
Row Age
Column Gender
Subset or Time Series Time Series
Time Series May 2005

Top of page