Civil Service Statistics data browser (Beta)

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

Status	Year	Region_ITL3	Sexual_orientation	Function_of_post	Headcount	FTE	Mean_salary	Median_salary
In post	2021	Aberdeen City and Aberdeenshire	Heterosexual / straight	Commercial	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Heterosexual / straight	Digital, Data & Technology	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Heterosexual / straight	Finance	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Heterosexual / straight	Human Resources	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Heterosexual / straight	Legal	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Heterosexual / straight	No function	370	350	44130	33650
In post	2021	Aberdeen City and Aberdeenshire	Heterosexual / straight	Project Delivery	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Heterosexual / straight	Property	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Heterosexual / straight	Security	60	60	40940	44070
In post	2021	Aberdeen City and Aberdeenshire	Heterosexual / straight	Unknown	580	540	33710	29190
In post	2021	Aberdeen City and Aberdeenshire	LGBO	Commercial	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	LGBO	Digital, Data & Technology	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	LGBO	Finance	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	LGBO	Human Resources	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	LGBO	Legal	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	LGBO	No function	30	30	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	LGBO	Project Delivery	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	LGBO	Property	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	LGBO	Security	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	LGBO	Unknown	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Undeclared	Legal	80	70	24970	22820
In post	2021	Aberdeen City and Aberdeenshire	Undeclared	No function	50	40	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Undeclared	Project Delivery	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Undeclared	Property	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Undeclared	Security	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Undeclared	Unknown	70	60	29980	27570
In post	2021	Aberdeen City and Aberdeenshire	Unknown	Commercial	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Unknown	Digital, Data & Technology	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Unknown	Finance	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Unknown	Human Resources	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Unknown	Legal	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Unknown	No function	230	220	33210	33650
In post	2021	Aberdeen City and Aberdeenshire	Unknown	Project Delivery	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Unknown	Property	60	60	30420	28870
In post	2021	Aberdeen City and Aberdeenshire	Unknown	Security	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Unknown	Unknown	190	180	33880	29920
In post	2021	Angus and Dundee City	Heterosexual / straight	Counter Fraud	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Heterosexual / straight	Debt	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Heterosexual / straight	Finance	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Heterosexual / straight	Legal	30	30	[c]	[c]
In post	2021	Angus and Dundee City	Heterosexual / straight	No function	190	170	24690	21490
In post	2021	Angus and Dundee City	Heterosexual / straight	Project Delivery	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Heterosexual / straight	Property	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Heterosexual / straight	Unknown	970	900	26960	23340
In post	2021	Angus and Dundee City	LGBO	Counter Fraud	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	LGBO	Debt	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	LGBO	Finance	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	LGBO	Legal	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	LGBO	No function	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	LGBO	Project Delivery	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	LGBO	Property	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	LGBO	Unknown	60	60	23820	21070
In post	2021	Angus and Dundee City	Undeclared	Counter Fraud	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Undeclared	Finance	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Undeclared	Legal	60	50	25280	22820
In post	2021	Angus and Dundee City	Undeclared	No function	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Undeclared	Unknown	90	80	23430	21010
In post	2021	Angus and Dundee City	Unknown	Counter Fraud	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Unknown	Debt	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Unknown	Legal	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Unknown	No function	140	130	22390	20140
In post	2021	Angus and Dundee City	Unknown	Project Delivery	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Unknown	Unknown	310	280	25560	21010
In post	2021	Antrim and Newtownabbey	Heterosexual / straight	Commercial	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	Heterosexual / straight	Digital, Data & Technology	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	Heterosexual / straight	Finance	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	Heterosexual / straight	Human Resources	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	Heterosexual / straight	No function	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	Heterosexual / straight	Project Delivery	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	Heterosexual / straight	Property	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	Heterosexual / straight	Security	60	60	21210	20310
In post	2021	Antrim and Newtownabbey	Heterosexual / straight	Unknown	80	80	25120	21670
In post	2021	Antrim and Newtownabbey	LGBO	Commercial	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	LGBO	Digital, Data & Technology	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	LGBO	Finance	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	LGBO	Human Resources	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	LGBO	No function	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	LGBO	Project Delivery	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	LGBO	Property	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	LGBO	Security	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	LGBO	Unknown	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	Undeclared	Human Resources	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	Undeclared	Security	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	Undeclared	Unknown	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	Unknown	Commercial	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	Unknown	Digital, Data & Technology	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	Unknown	Human Resources	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	Unknown	No function	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	Unknown	Project Delivery	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	Unknown	Property	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	Unknown	Security	[c]	[c]	[c]	[c]
In post	2021	Antrim and Newtownabbey	Unknown	Unknown	[c]	[c]	[c]	[c]
In post	2021	Ards and North Down	Heterosexual / straight	Digital, Data & Technology	[c]	[c]	[c]	[c]
In post	2021	Ards and North Down	Heterosexual / straight	Finance	[c]	[c]	[c]	[c]
In post	2021	Ards and North Down	Heterosexual / straight	No function	40	30	[c]	[c]
In post	2021	Ards and North Down	Heterosexual / straight	Project Delivery	[c]	[c]	[c]	[c]
In post	2021	Ards and North Down	Heterosexual / straight	Property	[c]	[c]	[c]	[c]
In post	2021	Ards and North Down	Heterosexual / straight	Security	80	80	20760	20310
In post	2021	Ards and North Down	Heterosexual / straight	Unknown	50	40	[c]	[c]
In post	2021	Ards and North Down	LGBO	Digital, Data & Technology	[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_ITL3	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 3 divides into counties, unitary authorities, or districts in England (some grouped), groups of unitary authorities in Wales, groups of council areas in Scotland, groups of districts in Northern Ireland.
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.
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.