Civil Service Statistics data browser (Beta)

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

Status	Year	Ethnicity	Sexual_orientation	Age	Headcount	FTE	Mean_salary	Median_salary
In post	2021	Asian	Heterosexual / straight	16-19	60	60	22730	21010
In post	2021	Asian	Heterosexual / straight	20-29	5160	5050	29140	27570
In post	2021	Asian	Heterosexual / straight	30-39	6910	6540	33140	29380
In post	2021	Asian	Heterosexual / straight	40-49	6130	5680	35260	30820
In post	2021	Asian	Heterosexual / straight	50-59	4090	3850	34250	30170
In post	2021	Asian	Heterosexual / straight	60-64	950	820	32100	28810
In post	2021	Asian	Heterosexual / straight	65+	420	320	31040	27760
In post	2021	Asian	Heterosexual / straight	Unknown	[c]	[c]	[c]	[c]
In post	2021	Asian	LGBO	16-19	[c]	[c]	[c]	[c]
In post	2021	Asian	LGBO	20-29	140	140	31430	29570
In post	2021	Asian	LGBO	30-39	140	140	36140	31990
In post	2021	Asian	LGBO	40-49	150	140	34290	28480
In post	2021	Asian	LGBO	50-59	80	80	31980	27570
In post	2021	Asian	LGBO	60-64	40	40	[c]	[c]
In post	2021	Asian	LGBO	65+	[c]	[c]	[c]	[c]
In post	2021	Asian	LGBO	Unknown	[c]	[c]	[c]	[c]
In post	2021	Asian	Undeclared	16-19	[c]	[c]	[c]	[c]
In post	2021	Asian	Undeclared	20-29	190	180	28510	27540
In post	2021	Asian	Undeclared	30-39	300	280	32230	29080
In post	2021	Asian	Undeclared	40-49	460	420	31920	28080
In post	2021	Asian	Undeclared	50-59	450	420	30810	28240
In post	2021	Asian	Undeclared	60-64	160	130	28580	26350
In post	2021	Asian	Undeclared	65+	90	70	30280	27130
In post	2021	Asian	Unknown	20-29	230	230	30030	27570
In post	2021	Asian	Unknown	30-39	600	540	31440	27570
In post	2021	Asian	Unknown	40-49	1110	960	32270	27570
In post	2021	Asian	Unknown	50-59	880	800	31830	27570
In post	2021	Asian	Unknown	60-64	230	190	30570	26930
In post	2021	Asian	Unknown	65+	140	110	30170	25630
In post	2021	Black	Heterosexual / straight	16-19	[c]	[c]	[c]	[c]
In post	2021	Black	Heterosexual / straight	20-29	1950	1920	29930	29290
In post	2021	Black	Heterosexual / straight	30-39	2760	2670	32670	31060
In post	2021	Black	Heterosexual / straight	40-49	3070	2950	34000	31060
In post	2021	Black	Heterosexual / straight	50-59	4090	3960	33930	30920
In post	2021	Black	Heterosexual / straight	60-64	850	780	31420	29300
In post	2021	Black	Heterosexual / straight	65+	220	190	29510	26150
In post	2021	Black	Heterosexual / straight	Unknown	[c]	[c]	[c]	[c]
In post	2021	Black	LGBO	16-19	[c]	[c]	[c]	[c]
In post	2021	Black	LGBO	20-29	90	90	31590	31060
In post	2021	Black	LGBO	30-39	70	70	33680	31060
In post	2021	Black	LGBO	40-49	70	60	36070	29840
In post	2021	Black	LGBO	50-59	80	80	36700	29550
In post	2021	Black	LGBO	60-64	[c]	[c]	[c]	[c]
In post	2021	Black	LGBO	65+	[c]	[c]	[c]	[c]
In post	2021	Black	LGBO	Unknown	[c]	[c]	[c]	[c]
In post	2021	Black	Undeclared	16-19	[c]	[c]	[c]	[c]
In post	2021	Black	Undeclared	20-29	80	70	29710	29570
In post	2021	Black	Undeclared	30-39	100	100	33250	31060
In post	2021	Black	Undeclared	40-49	170	160	34810	31060
In post	2021	Black	Undeclared	50-59	340	320	31750	29540
In post	2021	Black	Undeclared	60-64	70	60	29580	27570
In post	2021	Black	Undeclared	65+	[c]	[c]	[c]	[c]
In post	2021	Black	Unknown	20-29	60	60	30050	29540
In post	2021	Black	Unknown	30-39	180	160	32220	31060
In post	2021	Black	Unknown	40-49	310	280	34080	31060
In post	2021	Black	Unknown	50-59	730	700	32470	31060
In post	2021	Black	Unknown	60-64	190	170	30640	27570
In post	2021	Black	Unknown	65+	70	60	29210	26690
In post	2021	Chinese	Heterosexual / straight	16-19	[c]	[c]	[c]	[c]
In post	2021	Chinese	Heterosexual / straight	20-29	190	190	33560	30610
In post	2021	Chinese	Heterosexual / straight	30-39	270	260	38790	35110
In post	2021	Chinese	Heterosexual / straight	40-49	260	240	36610	31810
In post	2021	Chinese	Heterosexual / straight	50-59	160	150	36120	30160
In post	2021	Chinese	Heterosexual / straight	60-64	40	40	[c]	[c]
In post	2021	Chinese	Heterosexual / straight	65+	[c]	[c]	[c]	[c]
In post	2021	Chinese	Heterosexual / straight	Unknown	[c]	[c]	[c]	[c]
In post	2021	Chinese	LGBO	16-19	[c]	[c]	[c]	[c]
In post	2021	Chinese	LGBO	20-29	[c]	[c]	[c]	[c]
In post	2021	Chinese	LGBO	30-39	[c]	[c]	[c]	[c]
In post	2021	Chinese	LGBO	40-49	[c]	[c]	[c]	[c]
In post	2021	Chinese	LGBO	50-59	[c]	[c]	[c]	[c]
In post	2021	Chinese	LGBO	60-64	[c]	[c]	[c]	[c]
In post	2021	Chinese	LGBO	65+	[c]	[c]	[c]	[c]
In post	2021	Chinese	LGBO	Unknown	[c]	[c]	[c]	[c]
In post	2021	Chinese	Undeclared	20-29	[c]	[c]	[c]	[c]
In post	2021	Chinese	Undeclared	30-39	[c]	[c]	[c]	[c]
In post	2021	Chinese	Undeclared	40-49	[c]	[c]	[c]	[c]
In post	2021	Chinese	Undeclared	50-59	[c]	[c]	[c]	[c]
In post	2021	Chinese	Undeclared	60-64	[c]	[c]	[c]	[c]
In post	2021	Chinese	Undeclared	65+	[c]	[c]	[c]	[c]
In post	2021	Chinese	Unknown	20-29	[c]	[c]	[c]	[c]
In post	2021	Chinese	Unknown	30-39	40	30	[c]	[c]
In post	2021	Chinese	Unknown	40-49	40	40	[c]	[c]
In post	2021	Chinese	Unknown	50-59	50	40	[c]	[c]
In post	2021	Chinese	Unknown	60-64	[c]	[c]	[c]	[c]
In post	2021	Chinese	Unknown	65+	[c]	[c]	[c]	[c]
In post	2021	Mixed	Heterosexual / straight	16-19	[c]	[c]	[c]	[c]
In post	2021	Mixed	Heterosexual / straight	20-29	1700	1670	30620	28650
In post	2021	Mixed	Heterosexual / straight	30-39	1860	1770	36460	31810
In post	2021	Mixed	Heterosexual / straight	40-49	1360	1280	38690	33530
In post	2021	Mixed	Heterosexual / straight	50-59	1130	1080	36750	31860
In post	2021	Mixed	Heterosexual / straight	60-64	250	220	33630	28200
In post	2021	Mixed	Heterosexual / straight	65+	80	60	30720	27130
In post	2021	Mixed	Heterosexual / straight	Unknown	[c]	[c]	[c]	[c]
In post	2021	Mixed	LGBO	16-19	[c]	[c]	[c]	[c]
In post	2021	Mixed	LGBO	20-29	250	240	31510	29070
In post	2021	Mixed	LGBO	30-39	200	200	37360	33030
In post	2021	Mixed	LGBO	40-49	120	120	41710	35310
In post	2021	Mixed	LGBO	50-59	100	100	35860	31650
In post	2021	Mixed	LGBO	60-64	[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).
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.