Guidance

Industrial Injuries Disablement Benefit on Stat-Xplore: user guide

Updated 4 October 2022

The Industrial Injuries Disablement Benefit (IIDB) Stat-Xplore Database provides information on claims paid under the IIDB scheme.

Information is available for Great Britain from March 2017 to the currently published quarter. It is available at a local authority, regional, country and UK level.

IIDB statistics will now be published quarterly via Stat-Xplore only, and not via the Excel tables. These historic Excel tables will continue to be accessible for users.

Please email benefits.statistics@dwp.gov.uk with comments and suggestions.

Please add “Source: IIDB Stat-Xplore” to any analysis shared or published.

1. What is Stat-Xplore?

Stat-Xplore provides a guided way to explore DWP benefit statistics. Using Stat-Xplore you can:

• create customised tabulations
• view results in interactive charts
• share outputs via social networking tools or download into common file formats

2. Breakdowns available

IIDB Stat-Xplore allows users to explore 5 datasets, and create their own analysis of the following breakdowns.

1. IIDB Claims

• Month
• Residence based geography
• Age (bands and single year)
• Gender of claimant
• Cause of accident
• Prescribed disease
• Type of claim
• Working age or Pension age

2. IIDB Assessments

• Month
• Residence based geography
• Age (bands and single year)
• Working age or Pension age
• Gender of claimant
• Cause of accident
• Prescribed disease
• Type of claim
• Decision type
• Decision time (number of weekdays in bands)
• Degree of disablement
• Attributable agent
• Standard Industrial Classification
• Standard Occupational Classification

3. IIDB Assessments in payment

• Quarter
• Residence based geography
• Age (bands and single year)
• Gender of claimant
• Working age or Pension age
• Type of assessment
• Average weekly amount (bands)

4. Payments made for Pneumoconiosis Workers’ Compensation Act 1979 and 2008 Mesothelioma Scheme

• Month
• Scheme
• Type of claimant (sufferer or dependant)

5. Pneumoconiosis Workers’ Compensation Act 1979 and 2008 Mesothelioma Scheme – Claimants

• Month
• Residence based geography
• Age (bands and single year)
• Working age or Pension age
• Gender (of sufferer)
• Scheme
• Medical condition
• Type of claimant
• Amount of compensation paid (bands)

3. Methodological changes to IIDB Stat-Xplore data

Geographies

Geography information on Stat-Xplore is derived using 2011 Census Output Areas (COAs) whereas data in the older Excel tables is based on Government Office location, therefore figures may differ to those previously published (though the underlying data remains the same). The older Excel tables contain information on abroad cases. These are estimates, which are not included in the figures reported in the Excel tables. The abroad cases reported on Stat-Xplore are derived from NINo and claimant’s date of birth.

Rounding and disclosure control

Statistical disclosure control has been applied within Stat-Xplore, which guards against the identification of an individual claimant. The method by which the data is randomly adjusted for disclosure control differs within Stat-Xplore to the previously published Excel tables. Therefore, the raw data in Stat-Xplore may not be an exact match to the figures in the Excel tables, which are often rounded to the nearest ten. The method of calculating totals differs between the Excel tables and Stat-Xplore.

4. Ready-Made Tables

Ready-made tables are available for users to quickly recreate some of the previously published excel tables to output main headline IIDB statistics. The following ready-made tables are available:

• IIDB Assessments in payment
  • Table 1.1 IIDB, REA and RA in payment by type of assessment
  • Table 1.2 IIDB, REA and RA in payment by type of weekly payment amount
  • Table 2.1 IIDB, REA and RA in payment by type of assessments payable, gender and age group
  • Table 2.2 IIDB, REA and RA in payment by type of assessments payable and Region
• IIDB Assessments
  • Table 1.9 First diagnosed prescribed diseases all assessments by payability
  • Table 1.10 First diagnosed prescribed diseases all assessments by type of disease
  • Table 1.10A First diagnosed prescribed diseases all assessments resulting in payment in the quarter by type of disease
  • Table 1.11 First diagnosed prescribed diseases all assessments in the quarter by Standard Industry Classification
  • Table 2.5 First diagnosed all assessments by type of assessment, county, gender and age group
• IIDB Claims
  • Table 1.5 New claims by type of claim
  • Table 1.6 New prescribed disease and accident claims by Region
  • Table 1.8 New accident claims by cause of accident

5. Recreating the Excel tables

When recreating or producing new tables, build them in the following order:

1. Filter
2. Wafer
3. Column
4. Row

The remaining Excel tables that aren’t available as ready-made tables can be created as follows.

Table number	Analysis	Dataset	Filter	Wafer	Row	Column
1.7	New prescribed disease claims received by prescribed disease	IIDB Claims	Type of claim: Prescribed disease		Prescribed disease: select all at level	Month: select all at level
1.11a	First diagnosed prescribed diseases all assessments resulting in payment and Standard Industry Classification	IIDB Assessments		Decision type: Accepted – payable	Standard Industrial Classification: select all at level	Month: select all at level
1.12	First diagnosed prescribed diseases all assessments relating to asbestos	IIDB Assessments	Attributable agent: asbestos	Decision type: Accepted payable, Accepted – not payable	Prescribed disease: Pneumoconiosis with asbestos agent, Diffuse mesothelioma, Primary carcinoma of the lung (with accompanying asbestos), Primary carcinoma of the lung, Unilateral or bilateral diffuse pleural thickening	Month: select all at a level
1.12a	First diagnosed prescribed diseases all assessments relating to asbestos	IIDB Assessments	Attributable agent: asbestos	Decision type: Accepted payable	Prescribed disease: Pneumoconiosis with asbestos agent, Diffuse mesothelioma, Primary carcinoma of the lung (with accompanying asbestos), Primary carcinoma of the lung, Unilateral or bilateral diffuse pleural thickening	Month: select all at a level
2.3	New claims by type of claim, country, sex and age group	IIDB Claims		Gender: Male, Female	Region: select all at level, Working age or pension age, Type of claim: select all at level	Month: select all at level
2.4	Decisions made, by type and outcome of claim	IIDB Assessments		Type of claim: select all at level	Decision type: select all at level	Month: select all at level
2.6	First diagnosed all assessments, by occupation and prescribed disease	IIDB Assessments	Type of claim: Prescribed disease	Decision type: Accepted – payable, Accepted – not payable	Standard Occupational Code: select all at level, Prescribed disease: select all at level	Month: select all at level
2.7	First diagnosed all assessments, by prescribed disease and percentage assessment	IIDB Assessments	Type of claim: prescribed disease	Decision type: Accepted -payable, Accepted – not payable	Degree of disablement: select all at level, Prescribed diseases: Select all at level	Month: select all at level
2.8	First diagnosed all assessments, by standard industry classification, prescribed disease and payability	IIDB Assessments	Type of claim: Prescribed disease	Decision type: Accepted – payable, Accepted – not payable, Accepted – no loss of faculty	Standard Industrial Classification: select all at level, Prescribed disease: select all at level	Month: select all at level
2.9	Pneumoconiosis (D1), first diagnosed all assessments, by attributable agent and percentage assessment	IIDB Assessments	Prescribed disease: Pneumoconiosis (D1)	Decision type: accepted payable, accepted – not payable	Attributable agent: dust from asbestos, dust from coal, Degree of disablement: select all at level	Month: select all at level

6. Further Top Tips

Summing Months to Quarters

You can create custom summations to aid your analysis.

a. Creating custom data

To create custom data, double click on the chosen dataset and click ‘custom data’ at the bottom, below the variable list.

b. Selecting months

Select the months you would like to group together into quarters.

c. Grouping months

Click the double arrow button to add the months into Step 2, where they will be grouped.

d. Saving recode

Save the recode and call it something like ‘First Quarter 2017’. Save it in Private and you can use it in the dataset. NB: You must be registered to use this function. You can register for free.

7. Annex

Table numbers

Some table numbers were changed in the May 2021 release of the published IIDB tables (data to September 2020). Please see below the previously used table numbers and their current number.

Previous table number	Table number in May 2021 release
1.10A	1.11
1.11	1.12
1.11A	1.13
1.12	1.14
1.12A	1.15

Please add “IIDB Stat-Xplore” for any analysis published or shared.

Please email benefit-statistics@dwp.gov.uk with any comments or suggestions.