Civil Service Statistics data browser (2021)

Data preview: All civil servants / Function_of_post / Sexual_orientation / Ethnicity / Sex

Status	Year	Function_of_post	Sexual_orientation	Ethnicity	Sex	Headcount	FTE	Mean_salary	Median_salary
In post	2021	Analysis	Heterosexual / straight	Asian	Female	175	165	42540	38020
In post	2021	Analysis	Heterosexual / straight	Asian	Male	190	185	42190	39730
In post	2021	Analysis	Heterosexual / straight	Asian	Unknown	[c]	[c]	[c]	[c]
In post	2021	Analysis	Heterosexual / straight	Black	Female	80	80	37310	35060
In post	2021	Analysis	Heterosexual / straight	Black	Male	65	65	41470	40080
In post	2021	Analysis	Heterosexual / straight	Black	Unknown	[c]	[c]	[c]	[c]
In post	2021	Analysis	Heterosexual / straight	Chinese	Female	25	25	[c]	[c]
In post	2021	Analysis	Heterosexual / straight	Chinese	Male	20	20	[c]	[c]
In post	2021	Analysis	Heterosexual / straight	Chinese	Unknown	[c]	[c]	[c]	[c]
In post	2021	Analysis	Heterosexual / straight	Mixed	Female	70	70	43600	38460
In post	2021	Analysis	Heterosexual / straight	Mixed	Male	75	75	42920	38860
In post	2021	Analysis	Heterosexual / straight	Mixed	Unknown	[c]	[c]	[c]	[c]
In post	2021	Analysis	Heterosexual / straight	Other ethnicity	Female	15	15	[c]	[c]
In post	2021	Analysis	Heterosexual / straight	Other ethnicity	Male	15	15	[c]	[c]
In post	2021	Analysis	Heterosexual / straight	Other ethnicity	Unknown	[c]	[c]	[c]	[c]
In post	2021	Analysis	Heterosexual / straight	Undeclared	Female	10	10	[c]	[c]
In post	2021	Analysis	Heterosexual / straight	Undeclared	Male	25	25	[c]	[c]
In post	2021	Analysis	Heterosexual / straight	Undeclared	Unknown	[c]	[c]	[c]	[c]
In post	2021	Analysis	Heterosexual / straight	Unknown	Female	10	10	[c]	[c]
In post	2021	Analysis	Heterosexual / straight	Unknown	Male	20	20	[c]	[c]

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-16, 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.
Year	Year of data collection (as at 31 March).
Function_of_post	Functions relate to the post occupied by the person and are not dependent on qualifications the individual may have.
	The Department for Work and Pensions provided aggregated functions data for 2021, which are available in the Civil Service Statistics publication. However, figures in this browser are derived from individual level data and so are not available for this department in 2021.
	Home Office, Welsh Government and Royal Fleet Auxiliary did not report any functions information for their employees.
	Of the 20 bodies under the Scottish Government, 16 did not report any functions information for their employees.
Sex	Self reported sex.
	“Unknown” accounts for employees who were recorded with an unknown sex.
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.
	For consistency with Civil Service Statistics, ‘Chinese’ is shown separately in the 2021 figures, but counted within ‘Asian’ from 2022 onwards.
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).