Civil Service Statistics data browser (2023)

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

Status	Year	Region_london	Sexual_orientation	Ethnicity	Age	Headcount	FTE	Mean_salary	Median_salary
In post	2023	London	Heterosexual / straight	Asian	16-19	25	25	[c]	[c]
In post	2023	London	Heterosexual / straight	Asian	20-29	2445	2425	35550	33420
In post	2023	London	Heterosexual / straight	Asian	30-39	3280	3170	42740	39150
In post	2023	London	Heterosexual / straight	Asian	40-49	3345	3160	42970	38090
In post	2023	London	Heterosexual / straight	Asian	50-59	2365	2265	40470	35060
In post	2023	London	Heterosexual / straight	Asian	60-64	705	610	36450	32520
In post	2023	London	Heterosexual / straight	Asian	65+	400	320	32150	29890
In post	2023	London	Heterosexual / straight	Asian	Unknown	[c]	[c]	[c]	[c]
In post	2023	London	Heterosexual / straight	Black	16-19	[c]	[c]	[c]	[c]
In post	2023	London	Heterosexual / straight	Black	20-29	1220	1210	33840	32520
In post	2023	London	Heterosexual / straight	Black	30-39	1665	1620	38340	35410
In post	2023	London	Heterosexual / straight	Black	40-49	1780	1715	39540	35660
In post	2023	London	Heterosexual / straight	Black	50-59	2965	2885	38090	33050
In post	2023	London	Heterosexual / straight	Black	60-64	840	785	34910	32520
In post	2023	London	Heterosexual / straight	Black	65+	270	240	32260	29660
In post	2023	London	Heterosexual / straight	Black	Unknown	[c]	[c]	[c]	[c]
In post	2023	London	Heterosexual / straight	Mixed	16-19	[c]	[c]	[c]	[c]
In post	2023	London	Heterosexual / straight	Mixed	20-29	730	725	37890	35040
In post	2023	London	Heterosexual / straight	Mixed	30-39	845	810	46150	43000
In post	2023	London	Heterosexual / straight	Mixed	40-49	575	550	49250	44480

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).
Region_london	Workplace postcode data are used to derive geographical information using the International Territorial Level (ITL) classification standard.
	Region_london groups the ITL classifications into "London", "Outside London": all UK regions excluding London, "Overseas", and "Unknown".
Ethnicity	Self reported ethnicity. "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. Age is calculated as at the reference date in each year (31st March), so entrants or leavers may have been up to one year younger at the date of exit or entry.
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).