Civil Service Statistics data browser (2023)

Data preview: All civil servants / Region_ITL3 / Parent_department / Region_ITL2 / Sex

Status	Year	Region_ITL3	Parent_department	Region_ITL2	Sex	Headcount	FTE	Mean_salary	Median_salary
In post	2023	Aberdeen City and Aberdeenshire	Department for Business, Energy and Industrial Strategy	North Eastern Scotland	Female	65	60	47610	38280
In post	2023	Aberdeen City and Aberdeenshire	Department for Business, Energy and Industrial Strategy	North Eastern Scotland	Male	70	70	50160	40040
In post	2023	Aberdeen City and Aberdeenshire	Department for Environment, Food and Rural Affairs	North Eastern Scotland	Female	10	10	[c]	[c]
In post	2023	Aberdeen City and Aberdeenshire	Department for Environment, Food and Rural Affairs	North Eastern Scotland	Male	5	5	[c]	[c]
In post	2023	Aberdeen City and Aberdeenshire	Department for Transport	North Eastern Scotland	Female	25	20	[c]	[c]
In post	2023	Aberdeen City and Aberdeenshire	Department for Transport	North Eastern Scotland	Male	55	55	33360	29660
In post	2023	Aberdeen City and Aberdeenshire	Department for Work and Pensions	North Eastern Scotland	Female	175	150	30020	28120
In post	2023	Aberdeen City and Aberdeenshire	Department for Work and Pensions	North Eastern Scotland	Male	165	155	55920	32800
In post	2023	Aberdeen City and Aberdeenshire	Department of Health and Social Care	North Eastern Scotland	Female	[c]	[c]	[c]	[c]
In post	2023	Aberdeen City and Aberdeenshire	Department of Health and Social Care	North Eastern Scotland	Male	[c]	[c]	[c]	[c]
In post	2023	Aberdeen City and Aberdeenshire	Food Standards Agency	North Eastern Scotland	Female	[c]	[c]	[c]	[c]
In post	2023	Aberdeen City and Aberdeenshire	Food Standards Agency	North Eastern Scotland	Male	[c]	[c]	[c]	[c]
In post	2023	Aberdeen City and Aberdeenshire	HM Revenue and Customs	North Eastern Scotland	Female	[c]	[c]	[c]	[c]
In post	2023	Aberdeen City and Aberdeenshire	HM Revenue and Customs	North Eastern Scotland	Male	[c]	[c]	[c]	[c]
In post	2023	Aberdeen City and Aberdeenshire	Home Office	North Eastern Scotland	Female	10	10	[c]	[c]
In post	2023	Aberdeen City and Aberdeenshire	Home Office	North Eastern Scotland	Male	25	25	[c]	[c]
In post	2023	Aberdeen City and Aberdeenshire	Ministry of Defence	North Eastern Scotland	Female	15	15	[c]	[c]
In post	2023	Aberdeen City and Aberdeenshire	Ministry of Defence	North Eastern Scotland	Male	80	80	44230	45880
In post	2023	Aberdeen City and Aberdeenshire	Ministry of Justice	North Eastern Scotland	Female	[c]	[c]	[c]	[c]
In post	2023	Aberdeen City and Aberdeenshire	Ministry of Justice	North Eastern Scotland	Male	[c]	[c]	[c]	[c]

Note: Data has been truncated to 20 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 5 civil servants for FTE or Headcount, and less than 10 civil servants for median and mean salary (shown as [c]). Zero responses and salaries for less than 30 civil servants have been suppressed for GPDR special category data. FTE figures are not shown for entrants or leavers due to data quality concerns for these groups. Figures are rounded to the nearest 5, or £10 as appropriate.

Data source: All figures are aggregated from the Cabinet Office Annual Civil Service Employment Survey collection.

Version: Generated on 2023-07-29, with GIT d545f65.

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.
	Four organisations do not report when their employees first entered the Civil Service and so entrants data for these organisations is not available . These are as follows: Foreign Commonwealth and Development Office (excl. agencies), Foreign Commonwealth and Development Office Services, Scottish Forestry and Forest and Land Scotland. A further three organisations also could not provide entrants data in 2021. These are as follows: Department for International Development, Foreign and Commonwealth Office (excl. agencies) and Royal Fleet Auxiliary.
Year	Year of data collection (as at 31 March).
Parent_department	Government Department, total figures for both Ministerial and Non-Ministerial Departments include all of their Executive Agencies.
Region_ITL2	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 2 divides into Northern Ireland, counties in England (most grouped), groups of districts in Greater London, groups of unitary authorities in Wales, groups of council areas in Scotland.
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.
Sex	Self reported sex.
	"Unknown" accounts for employees who were recorded with an unknown sex.
Headcount	Total number of civil servants (rounded to nearest 5).
FTE	Total full-time equivalent (FTE) employment numbers (rounded to nearest 5).
	FTE figures are not shown for entrants or leavers due to data quality concerns for these groups.
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.
	These figures should be interpreted with caution when the total number of employees in a group is small, as they will tend to show more variability than larger groups (i.e. may be much higher or lower than can be explained by the data shown).
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.
	These figures should be interpreted with caution when the total number of employees in a group is small, as they will tend to show more variability than larger groups (i.e. may be much higher or lower than can be explained by the data shown).