Civil Service Statistics data browser (Beta)

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

Status	Year	Age	Ethnicity	Sexual_orientation	Headcount	FTE	Mean_salary	Median_salary
In post	2021	16-19	Asian	Heterosexual / straight	60	60	22730	21010
In post	2021	16-19	Asian	LGBO	[c]	[c]	[c]	[c]
In post	2021	16-19	Asian	Undeclared	[c]	[c]	[c]	[c]
In post	2021	16-19	Black	Heterosexual / straight	[c]	[c]	[c]	[c]
In post	2021	16-19	Black	LGBO	[c]	[c]	[c]	[c]
In post	2021	16-19	Black	Undeclared	[c]	[c]	[c]	[c]
In post	2021	16-19	Chinese	Heterosexual / straight	[c]	[c]	[c]	[c]
In post	2021	16-19	Chinese	LGBO	[c]	[c]	[c]	[c]
In post	2021	16-19	Mixed	Heterosexual / straight	[c]	[c]	[c]	[c]
In post	2021	16-19	Mixed	LGBO	[c]	[c]	[c]	[c]
In post	2021	16-19	Mixed	Unknown	[c]	[c]	[c]	[c]
In post	2021	16-19	Other ethnicity	Heterosexual / straight	[c]	[c]	[c]	[c]
In post	2021	16-19	Other ethnicity	LGBO	[c]	[c]	[c]	[c]
In post	2021	16-19	Undeclared	Heterosexual / straight	[c]	[c]	[c]	[c]
In post	2021	16-19	Undeclared	Undeclared	[c]	[c]	[c]	[c]
In post	2021	16-19	Unknown	Heterosexual / straight	[c]	[c]	[c]	[c]
In post	2021	16-19	Unknown	LGBO	[c]	[c]	[c]	[c]
In post	2021	16-19	Unknown	Undeclared	[c]	[c]	[c]	[c]
In post	2021	16-19	Unknown	Unknown	490	470	20500	20140
In post	2021	16-19	White	Heterosexual / straight	620	600	21490	21010
In post	2021	16-19	White	LGBO	50	50	[c]	[c]
In post	2021	16-19	White	Undeclared	40	40	[c]	[c]
In post	2021	16-19	White	Unknown	[c]	[c]	[c]	[c]
In post	2021	20-29	Asian	Heterosexual / straight	5160	5050	29140	27570
In post	2021	20-29	Asian	LGBO	140	140	31430	29570
In post	2021	20-29	Asian	Undeclared	190	180	28510	27540
In post	2021	20-29	Asian	Unknown	230	230	30030	27570
In post	2021	20-29	Black	Heterosexual / straight	1950	1920	29930	29290
In post	2021	20-29	Black	LGBO	90	90	31590	31060
In post	2021	20-29	Black	Undeclared	80	70	29710	29570
In post	2021	20-29	Black	Unknown	60	60	30050	29540
In post	2021	20-29	Chinese	Heterosexual / straight	190	190	33560	30610
In post	2021	20-29	Chinese	LGBO	[c]	[c]	[c]	[c]
In post	2021	20-29	Chinese	Undeclared	[c]	[c]	[c]	[c]
In post	2021	20-29	Chinese	Unknown	[c]	[c]	[c]	[c]
In post	2021	20-29	Mixed	Heterosexual / straight	1700	1670	30620	28650
In post	2021	20-29	Mixed	LGBO	250	240	31510	29070
In post	2021	20-29	Mixed	Undeclared	140	140	31040	29570
In post	2021	20-29	Mixed	Unknown	70	70	30700	29540
In post	2021	20-29	Other ethnicity	Heterosexual / straight	360	350	31720	30650
In post	2021	20-29	Other ethnicity	LGBO	50	40	[c]	[c]
In post	2021	20-29	Other ethnicity	Undeclared	[c]	[c]	[c]	[c]
In post	2021	20-29	Other ethnicity	Unknown	[c]	[c]	[c]	[c]
In post	2021	20-29	Undeclared	Heterosexual / straight	280	270	29470	27570
In post	2021	20-29	Undeclared	LGBO	40	40	[c]	[c]
In post	2021	20-29	Undeclared	Undeclared	1010	1000	31520	29120
In post	2021	20-29	Undeclared	Unknown	140	140	30490	28750
In post	2021	20-29	Unknown	Heterosexual / straight	510	500	29530	27570
In post	2021	20-29	Unknown	LGBO	50	50	30320	29380
In post	2021	20-29	Unknown	Undeclared	390	390	26920	25400
In post	2021	20-29	Unknown	Unknown	18800	18540	28200	26510
In post	2021	20-29	White	Heterosexual / straight	36960	36440	29050	27500
In post	2021	20-29	White	LGBO	4790	4740	29810	27570
In post	2021	20-29	White	Undeclared	2090	2050	30210	27570
In post	2021	20-29	White	Unknown	1640	1610	28620	27570
In post	2021	30-39	Asian	Heterosexual / straight	6910	6540	33140	29380
In post	2021	30-39	Asian	LGBO	140	140	36140	31990
In post	2021	30-39	Asian	Undeclared	300	280	32230	29080
In post	2021	30-39	Asian	Unknown	600	540	31440	27570
In post	2021	30-39	Black	Heterosexual / straight	2760	2670	32670	31060
In post	2021	30-39	Black	LGBO	70	70	33680	31060
In post	2021	30-39	Black	Undeclared	100	100	33250	31060
In post	2021	30-39	Black	Unknown	180	160	32220	31060
In post	2021	30-39	Chinese	Heterosexual / straight	270	260	38790	35110
In post	2021	30-39	Chinese	LGBO	[c]	[c]	[c]	[c]
In post	2021	30-39	Chinese	Undeclared	[c]	[c]	[c]	[c]
In post	2021	30-39	Chinese	Unknown	40	30	[c]	[c]
In post	2021	30-39	Mixed	Heterosexual / straight	1860	1770	36460	31810
In post	2021	30-39	Mixed	LGBO	200	200	37360	33030
In post	2021	30-39	Mixed	Undeclared	130	130	35730	31060
In post	2021	30-39	Mixed	Unknown	130	130	37120	33640
In post	2021	30-39	Other ethnicity	Heterosexual / straight	500	480	37050	33260
In post	2021	30-39	Other ethnicity	LGBO	40	40	[c]	[c]
In post	2021	30-39	Other ethnicity	Undeclared	40	40	[c]	[c]
In post	2021	30-39	Other ethnicity	Unknown	[c]	[c]	[c]	[c]
In post	2021	30-39	Undeclared	Heterosexual / straight	610	590	34190	30930
In post	2021	30-39	Undeclared	LGBO	70	70	32990	27950
In post	2021	30-39	Undeclared	Undeclared	2260	2190	36800	32920
In post	2021	30-39	Undeclared	Unknown	600	550	33480	31060
In post	2021	30-39	Unknown	Heterosexual / straight	770	730	32990	30190
In post	2021	30-39	Unknown	LGBO	60	60	39690	33400
In post	2021	30-39	Unknown	Undeclared	670	630	30880	29350
In post	2021	30-39	Unknown	Unknown	15440	14760	33970	29890
In post	2021	30-39	White	Heterosexual / straight	55330	52330	34600	30850
In post	2021	30-39	White	LGBO	4710	4630	35340	31180
In post	2021	30-39	White	Undeclared	3630	3420	34270	30850
In post	2021	30-39	White	Unknown	4900	4470	32680	29270
In post	2021	40-49	Asian	Heterosexual / straight	6130	5680	35260	30820
In post	2021	40-49	Asian	LGBO	150	140	34290	28480
In post	2021	40-49	Asian	Undeclared	460	420	31920	28080
In post	2021	40-49	Asian	Unknown	1110	960	32270	27570
In post	2021	40-49	Black	Heterosexual / straight	3070	2950	34000	31060
In post	2021	40-49	Black	LGBO	70	60	36070	29840
In post	2021	40-49	Black	Undeclared	170	160	34810	31060
In post	2021	40-49	Black	Unknown	310	280	34080	31060
In post	2021	40-49	Chinese	Heterosexual / straight	260	240	36610	31810
In post	2021	40-49	Chinese	LGBO	[c]	[c]	[c]	[c]
In post	2021	40-49	Chinese	Undeclared	[c]	[c]	[c]	[c]
In post	2021	40-49	Chinese	Unknown	40	40	[c]	[c]
In post	2021	40-49	Mixed	Heterosexual / straight	1360	1280	38690	33530

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).
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.
Age	Age in 10 year bands.
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.