Civil Service Statistics data browser (Beta)

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

Status	Year	Function_of_post	Sexual_orientation	Ethnicity	Headcount	FTE	Mean_salary	Median_salary
In post	2021	Analysis	Heterosexual / straight	Asian	360	350	42360	38630
In post	2021	Analysis	Heterosexual / straight	Black	140	140	39160	36160
In post	2021	Analysis	Heterosexual / straight	Chinese	50	50	[c]	[c]
In post	2021	Analysis	Heterosexual / straight	Mixed	150	150	43160	38510
In post	2021	Analysis	Heterosexual / straight	Other ethnicity	30	30	[c]	[c]
In post	2021	Analysis	Heterosexual / straight	Undeclared	40	40	[c]	[c]
In post	2021	Analysis	Heterosexual / straight	Unknown	30	30	[c]	[c]
In post	2021	Analysis	Heterosexual / straight	White	3850	3690	44330	39570
In post	2021	Analysis	LGBO	Asian	[c]	[c]	[c]	[c]
In post	2021	Analysis	LGBO	Black	[c]	[c]	[c]	[c]
In post	2021	Analysis	LGBO	Chinese	[c]	[c]	[c]	[c]
In post	2021	Analysis	LGBO	Mixed	[c]	[c]	[c]	[c]
In post	2021	Analysis	LGBO	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Analysis	LGBO	Undeclared	[c]	[c]	[c]	[c]
In post	2021	Analysis	LGBO	Unknown	[c]	[c]	[c]	[c]
In post	2021	Analysis	LGBO	White	370	360	40450	36160
In post	2021	Analysis	Undeclared	Asian	[c]	[c]	[c]	[c]
In post	2021	Analysis	Undeclared	Black	[c]	[c]	[c]	[c]
In post	2021	Analysis	Undeclared	Chinese	[c]	[c]	[c]	[c]
In post	2021	Analysis	Undeclared	Mixed	[c]	[c]	[c]	[c]
In post	2021	Analysis	Undeclared	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Analysis	Undeclared	Undeclared	160	160	44560	41780
In post	2021	Analysis	Undeclared	Unknown	[c]	[c]	[c]	[c]
In post	2021	Analysis	Undeclared	White	280	260	44310	38550
In post	2021	Analysis	Unknown	Asian	30	30	[c]	[c]
In post	2021	Analysis	Unknown	Black	[c]	[c]	[c]	[c]
In post	2021	Analysis	Unknown	Chinese	[c]	[c]	[c]	[c]
In post	2021	Analysis	Unknown	Mixed	[c]	[c]	[c]	[c]
In post	2021	Analysis	Unknown	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Analysis	Unknown	Undeclared	50	40	[c]	[c]
In post	2021	Analysis	Unknown	Unknown	910	880	40590	36590
In post	2021	Analysis	Unknown	White	610	570	41310	36580
In post	2021	Commercial	Heterosexual / straight	Asian	240	230	41840	36780
In post	2021	Commercial	Heterosexual / straight	Black	150	150	41030	37260
In post	2021	Commercial	Heterosexual / straight	Chinese	[c]	[c]	[c]	[c]
In post	2021	Commercial	Heterosexual / straight	Mixed	80	70	41050	36260
In post	2021	Commercial	Heterosexual / straight	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Commercial	Heterosexual / straight	Undeclared	40	40	[c]	[c]
In post	2021	Commercial	Heterosexual / straight	Unknown	50	50	41410	38820
In post	2021	Commercial	Heterosexual / straight	White	3600	3490	42470	37910
In post	2021	Commercial	LGBO	Asian	[c]	[c]	[c]	[c]
In post	2021	Commercial	LGBO	Black	[c]	[c]	[c]	[c]
In post	2021	Commercial	LGBO	Chinese	[c]	[c]	[c]	[c]
In post	2021	Commercial	LGBO	Mixed	[c]	[c]	[c]	[c]
In post	2021	Commercial	LGBO	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Commercial	LGBO	Undeclared	[c]	[c]	[c]	[c]
In post	2021	Commercial	LGBO	White	170	160	38820	34490
In post	2021	Commercial	Undeclared	Asian	[c]	[c]	[c]	[c]
In post	2021	Commercial	Undeclared	Black	[c]	[c]	[c]	[c]
In post	2021	Commercial	Undeclared	Chinese	[c]	[c]	[c]	[c]
In post	2021	Commercial	Undeclared	Mixed	[c]	[c]	[c]	[c]
In post	2021	Commercial	Undeclared	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Commercial	Undeclared	Undeclared	220	210	40190	36300
In post	2021	Commercial	Undeclared	Unknown	[c]	[c]	[c]	[c]
In post	2021	Commercial	Undeclared	White	300	290	40240	36410
In post	2021	Commercial	Unknown	Asian	[c]	[c]	[c]	[c]
In post	2021	Commercial	Unknown	Black	[c]	[c]	[c]	[c]
In post	2021	Commercial	Unknown	Chinese	[c]	[c]	[c]	[c]
In post	2021	Commercial	Unknown	Mixed	[c]	[c]	[c]	[c]
In post	2021	Commercial	Unknown	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Commercial	Unknown	Undeclared	[c]	[c]	[c]	[c]
In post	2021	Commercial	Unknown	Unknown	1530	1500	60040	54700
In post	2021	Commercial	Unknown	White	420	400	45160	41820
In post	2021	Communications	Heterosexual / straight	Asian	420	410	32730	30720
In post	2021	Communications	Heterosexual / straight	Black	170	160	33180	29720
In post	2021	Communications	Heterosexual / straight	Chinese	[c]	[c]	[c]	[c]
In post	2021	Communications	Heterosexual / straight	Mixed	130	120	36790	32900
In post	2021	Communications	Heterosexual / straight	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Communications	Heterosexual / straight	Undeclared	[c]	[c]	[c]	[c]
In post	2021	Communications	Heterosexual / straight	Unknown	50	50	35750	31960
In post	2021	Communications	Heterosexual / straight	White	3930	3770	35830	31810
In post	2021	Communications	LGBO	Asian	[c]	[c]	[c]	[c]
In post	2021	Communications	LGBO	Black	[c]	[c]	[c]	[c]
In post	2021	Communications	LGBO	Chinese	[c]	[c]	[c]	[c]
In post	2021	Communications	LGBO	Mixed	[c]	[c]	[c]	[c]
In post	2021	Communications	LGBO	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Communications	LGBO	Undeclared	[c]	[c]	[c]	[c]
In post	2021	Communications	LGBO	Unknown	[c]	[c]	[c]	[c]
In post	2021	Communications	LGBO	White	330	320	36090	31810
In post	2021	Communications	Undeclared	Asian	[c]	[c]	[c]	[c]
In post	2021	Communications	Undeclared	Black	[c]	[c]	[c]	[c]
In post	2021	Communications	Undeclared	Chinese	[c]	[c]	[c]	[c]
In post	2021	Communications	Undeclared	Mixed	[c]	[c]	[c]	[c]
In post	2021	Communications	Undeclared	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Communications	Undeclared	Undeclared	150	150	34240	31810
In post	2021	Communications	Undeclared	Unknown	30	30	[c]	[c]
In post	2021	Communications	Undeclared	White	260	250	33080	31040
In post	2021	Communications	Unknown	Asian	50	40	[c]	[c]
In post	2021	Communications	Unknown	Black	[c]	[c]	[c]	[c]
In post	2021	Communications	Unknown	Chinese	[c]	[c]	[c]	[c]
In post	2021	Communications	Unknown	Mixed	[c]	[c]	[c]	[c]
In post	2021	Communications	Unknown	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Communications	Unknown	Undeclared	30	30	[c]	[c]
In post	2021	Communications	Unknown	Unknown	2080	2030	32890	26350
In post	2021	Communications	Unknown	White	370	340	36720	31810
In post	2021	Counter Fraud	Heterosexual / straight	Asian	460	440	32850	31810
In post	2021	Counter Fraud	Heterosexual / straight	Black	200	190	31470	29570
In post	2021	Counter Fraud	Heterosexual / straight	Chinese	[c]	[c]	[c]	[c]
In post	2021	Counter Fraud	Heterosexual / straight	Mixed	90	90	34600	31000
In post	2021	Counter Fraud	Heterosexual / straight	Other ethnicity	[c]	[c]	[c]	[c]

Note: Data has been truncated to 100 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 30 civil servants for FTE or Headcount, and less than 50 civil servants for median and mean salary (shown as [c]). Additionally, zero responses have been suppressed for GPDR protected characteristics. Figures are rounded to the nearest 10, or £10 as appropriate.

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

Version: Generated on 2022-07-26, with GIT 03ee02c.

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.
	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. The Defence Electronics and Components Agency does not record the date in which their employees first enter the Civil Service and so entrants data is not available. 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 March 31st).
Function_of_post	Functions relate to the post occupied by the person and are not dependent on qualifications the individual may have.
	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.
Ethnicity	Self reported ethnicity. For consistency with Civil Service Statistics, ‘Chinese’ is shown separately in the 2021 figures, but counted within ‘Asian’ for 2022.
	“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 10).
FTE	Total full-time equivalent employment numbers (rounded to nearest 10).
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.
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.