Civil Service Statistics data browser (2022)

Data preview: All civil servants / Region_ITL1 / Sexual_orientation / Ethnicity / Region_ITL2

Status Year Region_ITL1 Sexual_orientation Ethnicity Region_ITL2 Headcount FTE Mean_salary Median_salary
In post 2022 East Midlands (England) Heterosexual / straight Asian Derbyshire and Nottinghamshire 725 680 31240 27570
In post 2022 East Midlands (England) Heterosexual / straight Asian Leicestershire, Rutland and Northamptonshire 825 755 26260 24880
In post 2022 East Midlands (England) Heterosexual / straight Asian Lincolnshire 20 15 [c] [c]
In post 2022 East Midlands (England) Heterosexual / straight Black Derbyshire and Nottinghamshire 340 325 28430 26820
In post 2022 East Midlands (England) Heterosexual / straight Black Leicestershire, Rutland and Northamptonshire 170 155 27690 25470
In post 2022 East Midlands (England) Heterosexual / straight Black Lincolnshire 25 20 [c] [c]
In post 2022 East Midlands (England) Heterosexual / straight Mixed Derbyshire and Nottinghamshire 195 180 30560 27130
In post 2022 East Midlands (England) Heterosexual / straight Mixed Leicestershire, Rutland and Northamptonshire 85 80 28730 25210
In post 2022 East Midlands (England) Heterosexual / straight Mixed Lincolnshire 30 30 31700 27570
In post 2022 East Midlands (England) Heterosexual / straight Other ethnicity Derbyshire and Nottinghamshire 30 25 [c] [c]
In post 2022 East Midlands (England) Heterosexual / straight Other ethnicity Leicestershire, Rutland and Northamptonshire 15 15 [c] [c]
In post 2022 East Midlands (England) Heterosexual / straight Other ethnicity Lincolnshire 5 5 [c] [c]
In post 2022 East Midlands (England) Heterosexual / straight Undeclared Derbyshire and Nottinghamshire 75 70 29450 27570
In post 2022 East Midlands (England) Heterosexual / straight Undeclared Leicestershire, Rutland and Northamptonshire 55 50 27960 27130
In post 2022 East Midlands (England) Heterosexual / straight Undeclared Lincolnshire 15 15 [c] [c]
In post 2022 East Midlands (England) Heterosexual / straight Unknown Derbyshire and Nottinghamshire 105 100 31960 28280
In post 2022 East Midlands (England) Heterosexual / straight Unknown Leicestershire, Rutland and Northamptonshire 60 55 29960 27030
In post 2022 East Midlands (England) Heterosexual / straight Unknown Lincolnshire 10 10 [c] [c]
In post 2022 East Midlands (England) Heterosexual / straight White Derbyshire and Nottinghamshire 7580 7060 33020 27930
In post 2022 East Midlands (England) Heterosexual / straight White Leicestershire, Rutland and Northamptonshire 3130 2890 29200 27130
Note: Data has been truncated to 20 rows, please download the data to view the remaining rows

Download the data

About: The Civil Service Statistics data browser is a pilot project by Cabinet Office to provide access to more detailed data on the Civil Service workforce from the Annual Civil Service Employment Survey. We welcome feedback or comments on this project, which can be addressed to civilservicestatistics@cabinetoffice.gov.uk

Notes: Summary figures are suppressed when information relates to less than 5 civil servants for FTE or Headcount, and less than 10 civil servants for median and mean salary (shown as [c]). Zero responses and salaries for less than 30 civil servants have been suppressed for GPDR special category data. FTE figures are not shown for entrants or leavers due to data quality concerns for these groups. Figures are rounded to the nearest 5, or £10 as appropriate.

Data source: All figures are aggregated from the Cabinet Office Annual Civil Service Employment Survey collection.

Version: Generated on 2023-02-15, with GIT 71a76ea.

Data column Description
Status Employment status of the civil servants.
In post - includes staff that were in post on the reference date (31 March).
New entrant CS - includes new entrants to the Civil Service over the year (1 April to 31 March).
Leaver CS - includes leavers from the Civil Service over the year (1 April to 31 March). This includes employees who have an Unknown leaving cause.
Leaver Dept. - includes leavers from the department over the year (1 April to 31 March), who did not leave the Civil Service.
Five organisations do not report when their employees first entered the Civil Service and so entrants data for these organisations is not available . These are as follows: Foreign Commonwealth and Development Office (excl. agencies), Foreign Commonwealth and Development Office Services, Defence Electronics and Components Agency, Scottish Forestry and Forest and Land Scotland. A further three organisations also could not provide entrants data in 2021. These are as follows: Department for International Development, Foreign and Commonwealth Office (excl. agencies) and Royal Fleet Auxiliary.
Organisation specific notes on status: In late June 2021 around 7,000 employees from Community Rehabilitation Companies were transferred in from the private sector to HM Prison and Probation Service, counting as entrants. HM Land Registry do not record where their departing employees transfer to and so are unable to identify those that transfer to another Civil Service department.
Year Year of data collection (as at 31 March).
Region_ITL1 Workplace postcode data are used to derive geographical information using the International Territorial Level (ITL) classification standard.
Following the UK’s withdrawal from the EU, a new UK-managed international statistical geography - International Territorial Levels (ITL) - was introduced from 1st January 2021, replacing the former NUTS classification. They align with international standards, enabling comparability both over time and internationally. To ensure continued alignment, the ITLs mirror the NUTS system. They also follow a similar review timetable - every three years.
ITL 1 divides into Wales, Scotland, Northern Ireland, and the 9 statistical regions of England.
Region_ITL2 Workplace postcode data are used to derive geographical information using the International Territorial Level (ITL) classification standard.
Following the UK’s withdrawal from the EU, a new UK-managed international statistical geography - International Territorial Levels (ITL) - was introduced from 1st January 2021, replacing the former NUTS classification. They align with international standards, enabling comparability both over time and internationally. To ensure continued alignment, the ITLs mirror the NUTS system. They also follow a similar review timetable - every three years.
ITL 2 divides into Northern Ireland, counties in England (most grouped), groups of districts in Greater London, groups of unitary authorities in Wales, groups of council areas in Scotland.
Ethnicity Self reported ethnicity. “Undeclared” accounts for employees who have actively declared that they do not want to disclose their ethnicity and “Unknown” accounts for employees who have not made an active declaration about their ethnicity.
Sexual_orientation Self reported sexual orientation.
“Undeclared” accounts for employees who have actively declared that they do not want to disclose their sexual orientation and “Unknown” accounts for employees who have not made an active declaration about their sexual orientation.
Headcount Total number of civil servants (rounded to nearest 5).
FTE Total full-time equivalent (FTE) employment numbers (rounded to nearest 5).
FTE figures are not shown for entrants or leavers due to data quality concerns for these groups.
Mean_salary Average salary (mean, rounded to nearest £10). For part-time employees, salaries represent the full-time equivalent earnings, while for full-time employees they are the actual annual gross salaries.
These figures should be interpreted with caution when the total number of employees in a group is small, as they will tend to show more variability than larger groups (i.e. may be much higher or lower than can be explained by the data shown).
Median_salary Median salary (rounded to nearest £10). For part-time employees, salaries represent the full-time equivalent earnings, while for full-time employees they are the actual annual gross salaries.
These figures should be interpreted with caution when the total number of employees in a group is small, as they will tend to show more variability than larger groups (i.e. may be much higher or lower than can be explained by the data shown).