Civil Service Statistics data browser (Beta)

Back to Civil Service Statistics

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

Status	Year	Ethnicity	Sexual_orientation	Region_ITL1	Headcount	FTE	Mean_salary	Median_salary
In post	2021	Asian	Heterosexual / straight	East Midlands (England)	1320	1210	27270	25560
In post	2021	Asian	Heterosexual / straight	East of England	940	850	30070	27570
In post	2021	Asian	Heterosexual / straight	London	11160	10620	37240	32090
In post	2021	Asian	Heterosexual / straight	North East (England)	310	290	28060	25560
In post	2021	Asian	Heterosexual / straight	North West (England)	2080	1940	28020	25560
In post	2021	Asian	Heterosexual / straight	Northern Ireland	[c]	[c]	[c]	[c]
In post	2021	Asian	Heterosexual / straight	Overseas	130	130	45910	41090
In post	2021	Asian	Heterosexual / straight	Scotland	420	390	32500	27570
In post	2021	Asian	Heterosexual / straight	South East (England)	1150	1070	30290	27850
In post	2021	Asian	Heterosexual / straight	South West (England)	650	620	34380	31690
In post	2021	Asian	Heterosexual / straight	Unknown	130	120	30270	27570
In post	2021	Asian	Heterosexual / straight	Wales	370	350	30420	25560
In post	2021	Asian	Heterosexual / straight	West Midlands (England)	3240	3040	27950	26130
In post	2021	Asian	Heterosexual / straight	Yorkshire and The Humber	1830	1710	28320	26780
In post	2021	Asian	LGBO	East Midlands (England)	30	30	[c]	[c]
In post	2021	Asian	LGBO	East of England	[c]	[c]	[c]	[c]
In post	2021	Asian	LGBO	London	290	270	38530	32870
In post	2021	Asian	LGBO	North East (England)	[c]	[c]	[c]	[c]
In post	2021	Asian	LGBO	North West (England)	50	40	26550	23160
In post	2021	Asian	LGBO	Northern Ireland	[c]	[c]	[c]	[c]
In post	2021	Asian	LGBO	Overseas	[c]	[c]	[c]	[c]
In post	2021	Asian	LGBO	Scotland	[c]	[c]	[c]	[c]
In post	2021	Asian	LGBO	South East (England)	30	30	[c]	[c]
In post	2021	Asian	LGBO	South West (England)	[c]	[c]	[c]	[c]
In post	2021	Asian	LGBO	Unknown	[c]	[c]	[c]	[c]
In post	2021	Asian	LGBO	Wales	[c]	[c]	[c]	[c]
In post	2021	Asian	LGBO	West Midlands (England)	60	60	27410	25190
In post	2021	Asian	LGBO	Yorkshire and The Humber	40	30	[c]	[c]
In post	2021	Asian	Undeclared	East Midlands (England)	90	80	26450	22300
In post	2021	Asian	Undeclared	East of England	80	70	29140	26260
In post	2021	Asian	Undeclared	London	830	760	34250	30890
In post	2021	Asian	Undeclared	North East (England)	[c]	[c]	[c]	[c]
In post	2021	Asian	Undeclared	North West (England)	130	110	25710	21430
In post	2021	Asian	Undeclared	Northern Ireland	[c]	[c]	[c]	[c]
In post	2021	Asian	Undeclared	Overseas	[c]	[c]	[c]	[c]
In post	2021	Asian	Undeclared	Scotland	[c]	[c]	[c]	[c]
In post	2021	Asian	Undeclared	South East (England)	70	70	29660	27570
In post	2021	Asian	Undeclared	South West (England)	50	40	[c]	[c]
In post	2021	Asian	Undeclared	Unknown	[c]	[c]	[c]	[c]
In post	2021	Asian	Undeclared	Wales	[c]	[c]	[c]	[c]
In post	2021	Asian	Undeclared	West Midlands (England)	200	180	25650	25400
In post	2021	Asian	Undeclared	Yorkshire and The Humber	120	110	26050	24890
In post	2021	Asian	Unknown	East Midlands (England)	260	220	26150	25560
In post	2021	Asian	Unknown	East of England	90	80	35130	28530
In post	2021	Asian	Unknown	London	1290	1160	36740	31880
In post	2021	Asian	Unknown	North East (England)	50	40	[c]	[c]
In post	2021	Asian	Unknown	North West (England)	320	280	26390	23730
In post	2021	Asian	Unknown	Overseas	[c]	[c]	[c]	[c]
In post	2021	Asian	Unknown	Scotland	50	50	28720	25560
In post	2021	Asian	Unknown	South East (England)	120	110	29880	27570
In post	2021	Asian	Unknown	South West (England)	60	50	32670	28690
In post	2021	Asian	Unknown	Unknown	[c]	[c]	[c]	[c]
In post	2021	Asian	Unknown	Wales	40	30	[c]	[c]
In post	2021	Asian	Unknown	West Midlands (England)	570	510	27930	26760
In post	2021	Asian	Unknown	Yorkshire and The Humber	320	280	27490	25560
In post	2021	Black	Heterosexual / straight	East Midlands (England)	420	400	26960	25560
In post	2021	Black	Heterosexual / straight	East of England	500	480	30510	29290
In post	2021	Black	Heterosexual / straight	London	8200	7960	34640	31060
In post	2021	Black	Heterosexual / straight	North East (England)	120	110	27390	25560
In post	2021	Black	Heterosexual / straight	North West (England)	600	570	28840	27570
In post	2021	Black	Heterosexual / straight	Northern Ireland	[c]	[c]	[c]	[c]
In post	2021	Black	Heterosexual / straight	Overseas	60	60	42250	37500
In post	2021	Black	Heterosexual / straight	Scotland	210	200	31650	27570
In post	2021	Black	Heterosexual / straight	South East (England)	740	700	30420	29290
In post	2021	Black	Heterosexual / straight	South West (England)	480	460	32480	31000
In post	2021	Black	Heterosexual / straight	Unknown	50	40	[c]	[c]
In post	2021	Black	Heterosexual / straight	Wales	160	150	29170	27360
In post	2021	Black	Heterosexual / straight	West Midlands (England)	970	910	28570	27570
In post	2021	Black	Heterosexual / straight	Yorkshire and The Humber	450	430	29110	27570
In post	2021	Black	LGBO	East Midlands (England)	[c]	[c]	[c]	[c]
In post	2021	Black	LGBO	East of England	[c]	[c]	[c]	[c]
In post	2021	Black	LGBO	London	200	190	37390	31060
In post	2021	Black	LGBO	North East (England)	[c]	[c]	[c]	[c]
In post	2021	Black	LGBO	North West (England)	[c]	[c]	[c]	[c]
In post	2021	Black	LGBO	Northern Ireland	[c]	[c]	[c]	[c]
In post	2021	Black	LGBO	Overseas	[c]	[c]	[c]	[c]
In post	2021	Black	LGBO	Scotland	[c]	[c]	[c]	[c]
In post	2021	Black	LGBO	South East (England)	[c]	[c]	[c]	[c]
In post	2021	Black	LGBO	South West (England)	[c]	[c]	[c]	[c]
In post	2021	Black	LGBO	Unknown	[c]	[c]	[c]	[c]
In post	2021	Black	LGBO	Wales	[c]	[c]	[c]	[c]
In post	2021	Black	LGBO	West Midlands (England)	[c]	[c]	[c]	[c]
In post	2021	Black	LGBO	Yorkshire and The Humber	[c]	[c]	[c]	[c]
In post	2021	Black	Undeclared	East Midlands (England)	[c]	[c]	[c]	[c]
In post	2021	Black	Undeclared	East of England	[c]	[c]	[c]	[c]
In post	2021	Black	Undeclared	London	530	500	33890	31060
In post	2021	Black	Undeclared	North East (England)	[c]	[c]	[c]	[c]
In post	2021	Black	Undeclared	North West (England)	40	30	[c]	[c]
In post	2021	Black	Undeclared	Overseas	[c]	[c]	[c]	[c]
In post	2021	Black	Undeclared	Scotland	[c]	[c]	[c]	[c]
In post	2021	Black	Undeclared	South East (England)	40	30	[c]	[c]
In post	2021	Black	Undeclared	South West (England)	[c]	[c]	[c]	[c]
In post	2021	Black	Undeclared	Unknown	[c]	[c]	[c]	[c]
In post	2021	Black	Undeclared	Wales	[c]	[c]	[c]	[c]
In post	2021	Black	Undeclared	West Midlands (England)	60	60	25270	25280
In post	2021	Black	Undeclared	Yorkshire and The Humber	[c]	[c]	[c]	[c]
In post	2021	Black	Unknown	East Midlands (England)	50	50	[c]	[c]
In post	2021	Black	Unknown	East of England	50	40	[c]	[c]
In post	2021	Black	Unknown	London	1040	970	33670	31070
In post	2021	Black	Unknown	North East (England)	[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).
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.
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.