Civil Service Statistics data browser (Beta)

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

Status	Year	Sexual_orientation	Region_ITL2	Ethnicity	Headcount	FTE	Mean_salary	Median_salary
In post	2021	Heterosexual / straight	Bedfordshire and Hertfordshire	Asian	440	410	30870	29290
In post	2021	Heterosexual / straight	Bedfordshire and Hertfordshire	Black	190	180	31120	29290
In post	2021	Heterosexual / straight	Bedfordshire and Hertfordshire	Chinese	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Bedfordshire and Hertfordshire	Mixed	110	110	31420	29290
In post	2021	Heterosexual / straight	Bedfordshire and Hertfordshire	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Bedfordshire and Hertfordshire	Undeclared	30	30	[c]	[c]
In post	2021	Heterosexual / straight	Bedfordshire and Hertfordshire	Unknown	40	40	[c]	[c]
In post	2021	Heterosexual / straight	Bedfordshire and Hertfordshire	White	2360	2220	33000	29670
In post	2021	Heterosexual / straight	Berkshire, Buckinghamshire and Oxfordshire	Asian	490	460	30790	28550
In post	2021	Heterosexual / straight	Berkshire, Buckinghamshire and Oxfordshire	Black	240	240	30570	29120
In post	2021	Heterosexual / straight	Berkshire, Buckinghamshire and Oxfordshire	Chinese	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Berkshire, Buckinghamshire and Oxfordshire	Mixed	130	130	31830	29290
In post	2021	Heterosexual / straight	Berkshire, Buckinghamshire and Oxfordshire	Other ethnicity	40	40	[c]	[c]
In post	2021	Heterosexual / straight	Berkshire, Buckinghamshire and Oxfordshire	Undeclared	70	70	32730	29290
In post	2021	Heterosexual / straight	Berkshire, Buckinghamshire and Oxfordshire	Unknown	60	60	32770	31190
In post	2021	Heterosexual / straight	Berkshire, Buckinghamshire and Oxfordshire	White	5560	5310	33210	30030
In post	2021	Heterosexual / straight	Cheshire	Asian	50	40	[c]	[c]
In post	2021	Heterosexual / straight	Cheshire	Black	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Cheshire	Chinese	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Cheshire	Mixed	40	40	[c]	[c]
In post	2021	Heterosexual / straight	Cheshire	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Cheshire	Undeclared	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Cheshire	Unknown	30	30	[c]	[c]
In post	2021	Heterosexual / straight	Cheshire	White	2540	2410	31860	28850
In post	2021	Heterosexual / straight	Cornwall and Isles of Scilly	Asian	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Cornwall and Isles of Scilly	Black	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Cornwall and Isles of Scilly	Chinese	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Cornwall and Isles of Scilly	Mixed	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Cornwall and Isles of Scilly	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Cornwall and Isles of Scilly	Undeclared	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Cornwall and Isles of Scilly	Unknown	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Cornwall and Isles of Scilly	White	1080	990	26730	26670
In post	2021	Heterosexual / straight	Cumbria	Asian	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Cumbria	Black	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Cumbria	Chinese	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Cumbria	Mixed	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Cumbria	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Cumbria	Undeclared	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Cumbria	Unknown	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Cumbria	White	1260	1150	28740	26010
In post	2021	Heterosexual / straight	Derbyshire and Nottinghamshire	Asian	520	480	30150	27570
In post	2021	Heterosexual / straight	Derbyshire and Nottinghamshire	Black	250	240	26840	25560
In post	2021	Heterosexual / straight	Derbyshire and Nottinghamshire	Chinese	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Derbyshire and Nottinghamshire	Mixed	160	150	30240	27570
In post	2021	Heterosexual / straight	Derbyshire and Nottinghamshire	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Derbyshire and Nottinghamshire	Undeclared	60	60	27450	27570
In post	2021	Heterosexual / straight	Derbyshire and Nottinghamshire	Unknown	110	100	31010	27380
In post	2021	Heterosexual / straight	Derbyshire and Nottinghamshire	White	6730	6240	32000	27570
In post	2021	Heterosexual / straight	Devon	Asian	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Devon	Black	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Devon	Chinese	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Devon	Mixed	50	50	28240	25380
In post	2021	Heterosexual / straight	Devon	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Devon	Undeclared	40	30	[c]	[c]
In post	2021	Heterosexual / straight	Devon	Unknown	40	40	[c]	[c]
In post	2021	Heterosexual / straight	Devon	White	4690	4300	29540	27340
In post	2021	Heterosexual / straight	Dorset and Somerset	Asian	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Dorset and Somerset	Black	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Dorset and Somerset	Chinese	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Dorset and Somerset	Mixed	40	30	[c]	[c]
In post	2021	Heterosexual / straight	Dorset and Somerset	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Dorset and Somerset	Undeclared	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Dorset and Somerset	Unknown	50	40	[c]	[c]
In post	2021	Heterosexual / straight	Dorset and Somerset	White	3440	3210	29590	27570
In post	2021	Heterosexual / straight	East Anglia	Asian	320	270	26620	23660
In post	2021	Heterosexual / straight	East Anglia	Black	100	90	31760	27570
In post	2021	Heterosexual / straight	East Anglia	Chinese	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	East Anglia	Mixed	150	140	28470	27570
In post	2021	Heterosexual / straight	East Anglia	Other ethnicity	30	30	[c]	[c]
In post	2021	Heterosexual / straight	East Anglia	Undeclared	60	60	27670	27570
In post	2021	Heterosexual / straight	East Anglia	Unknown	100	90	30740	27570
In post	2021	Heterosexual / straight	East Anglia	White	7880	7370	30300	27570
In post	2021	Heterosexual / straight	East Wales	Asian	280	270	31000	25560
In post	2021	Heterosexual / straight	East Wales	Black	130	130	29500	27160
In post	2021	Heterosexual / straight	East Wales	Chinese	40	40	[c]	[c]
In post	2021	Heterosexual / straight	East Wales	Mixed	220	210	32760	28850
In post	2021	Heterosexual / straight	East Wales	Other ethnicity	50	50	[c]	[c]
In post	2021	Heterosexual / straight	East Wales	Undeclared	100	90	32310	30280
In post	2021	Heterosexual / straight	East Wales	Unknown	140	130	29800	26800
In post	2021	Heterosexual / straight	East Wales	White	12290	11510	33690	28850
In post	2021	Heterosexual / straight	East Yorkshire and Northern Lincolnshire	Asian	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	East Yorkshire and Northern Lincolnshire	Black	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	East Yorkshire and Northern Lincolnshire	Chinese	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	East Yorkshire and Northern Lincolnshire	Mixed	30	30	[c]	[c]
In post	2021	Heterosexual / straight	East Yorkshire and Northern Lincolnshire	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	East Yorkshire and Northern Lincolnshire	Undeclared	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	East Yorkshire and Northern Lincolnshire	Unknown	30	30	[c]	[c]
In post	2021	Heterosexual / straight	East Yorkshire and Northern Lincolnshire	White	3090	2830	28020	26930
In post	2021	Heterosexual / straight	Eastern Scotland	Asian	160	150	32640	27570
In post	2021	Heterosexual / straight	Eastern Scotland	Black	70	70	32090	27990
In post	2021	Heterosexual / straight	Eastern Scotland	Chinese	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Eastern Scotland	Mixed	80	80	39410	33270
In post	2021	Heterosexual / straight	Eastern Scotland	Other ethnicity	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Eastern Scotland	Undeclared	110	100	34840	33650
In post	2021	Heterosexual / straight	Eastern Scotland	Unknown	100	90	32670	27570
In post	2021	Heterosexual / straight	Eastern Scotland	White	10430	9830	35870	30650
In post	2021	Heterosexual / straight	Essex	Asian	180	170	34200	29290
In post	2021	Heterosexual / straight	Essex	Black	210	200	29390	29290
In post	2021	Heterosexual / straight	Essex	Chinese	[c]	[c]	[c]	[c]
In post	2021	Heterosexual / straight	Essex	Mixed	80	70	31970	29290

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_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.
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.