Civil Service Statistics data browser (Beta)

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

Status	Year	Region_ITL3	Function_of_post	Ethnicity	Headcount	FTE	Mean_salary	Median_salary
In post	2021	Aberdeen City and Aberdeenshire	Commercial	Asian	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Commercial	Black	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Commercial	Chinese	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Commercial	Mixed	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Commercial	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Commercial	Undeclared	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Commercial	White	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Digital, Data & Technology	Asian	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Digital, Data & Technology	Black	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Digital, Data & Technology	Chinese	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Digital, Data & Technology	Mixed	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Digital, Data & Technology	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Digital, Data & Technology	Undeclared	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Digital, Data & Technology	White	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Finance	Asian	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Finance	Black	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Finance	Chinese	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Finance	Mixed	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Finance	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Finance	White	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Human Resources	Asian	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Human Resources	Black	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Human Resources	Chinese	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Human Resources	Mixed	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Human Resources	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Human Resources	Unknown	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Human Resources	White	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Legal	Asian	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Legal	Black	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Legal	Chinese	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Legal	Mixed	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Legal	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Legal	Undeclared	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Legal	Unknown	80	60	24390	22820
In post	2021	Aberdeen City and Aberdeenshire	Legal	White	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	No function	Asian	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	No function	Black	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	No function	Chinese	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	No function	Mixed	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	No function	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	No function	Undeclared	40	30	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	No function	Unknown	200	190	34370	28410
In post	2021	Aberdeen City and Aberdeenshire	No function	White	400	380	41120	33650
In post	2021	Aberdeen City and Aberdeenshire	Project Delivery	Asian	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Project Delivery	Black	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Project Delivery	Chinese	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Project Delivery	Mixed	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Project Delivery	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Project Delivery	Unknown	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Project Delivery	White	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Property	Asian	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Property	Black	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Property	Chinese	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Property	Mixed	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Property	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Property	Unknown	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Property	White	80	70	31020	30160
In post	2021	Aberdeen City and Aberdeenshire	Security	Asian	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Security	Black	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Security	Chinese	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Security	Mixed	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Security	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Security	Undeclared	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Security	Unknown	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Security	White	70	70	41240	44070
In post	2021	Aberdeen City and Aberdeenshire	Unknown	Asian	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Unknown	Black	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Unknown	Chinese	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Unknown	Mixed	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Unknown	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Unknown	Undeclared	[c]	[c]	[c]	[c]
In post	2021	Aberdeen City and Aberdeenshire	Unknown	Unknown	120	110	34600	30650
In post	2021	Aberdeen City and Aberdeenshire	Unknown	White	700	640	33360	29190
In post	2021	Angus and Dundee City	Counter Fraud	Asian	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Counter Fraud	Black	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Counter Fraud	Chinese	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Counter Fraud	Mixed	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Counter Fraud	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Counter Fraud	White	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Debt	Asian	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Debt	Black	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Debt	Chinese	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Debt	Mixed	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Debt	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Debt	White	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Finance	Asian	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Finance	Black	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Finance	Chinese	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Finance	Mixed	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Finance	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Finance	White	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Legal	Asian	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Legal	Black	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Legal	Chinese	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Legal	Mixed	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Legal	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	Legal	Unknown	60	50	24900	22820
In post	2021	Angus and Dundee City	Legal	White	40	40	[c]	[c]
In post	2021	Angus and Dundee City	No function	Asian	[c]	[c]	[c]	[c]
In post	2021	Angus and Dundee City	No function	Black	[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.
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.
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.