Catalogue of Social Care Data

Has the worker completed training in category – Control and restraint

Not recorded
No
Yes
Not known

Most recent date the worker completed training in category – Control and restraint

Date

Number of instances of training completed in category – Control and restraint

Number

Number of accredited instances of training completed in category – Control and restraint

Number

Number of non-accredited instances of training completed in category – Control and restraint

Number

Number of unknown accreditation instances of training completed in category – Control and restraint

Number

Does the worker get paid an hourly rate or annual salary?

Not known
Not recorded
Annual
Hourly

The workers annual salary. Dependent on salaryint.

Salary in £

The workers hourly rate. Dependent on salaryint.

Rate in £

Date when hrlyrate was last changed.

Date

The full-time equivalent hourly rate of the worker. Dependent on salaryint and conthrs/averagehours.

Rate in £

The full-time equivalent annual salary of the worker. Dependent on salaryint and conthrs/averagehours.

Salary in £

Is the worker doing training as part of an apprenticeship.

Not recorded
No
Yes
Not known

Date when apprentice was last changed.

Date

Does the worker hold a qualification relevant to adult social care?

Not recorded
No
Yes
Not known

Date when scqheld was last changed.

Date

Highest level of adult social care relevant qualification held. Dependent on scqheld.

Missing
Entry
Level 1
Level 2
Level 3
Level 4
Level 5
Level 6
Level 7
Level 8 or above

Does the worker hold a qualification not relevant to adult social care?

Not recorded
No
Yes
Not known

Date when nonscqheld was last changed.

Date

Highest level of non-relevant adult social care qualification held. Dependent on nonscqheld.

Missing
Entry
Level 1
Level 2
Level 3
Level 4
Level 5
Level 6
Level 7
Level 8 or above

Does the worker hold one or more of the listed qualifications?
[unable to retrieve list from dataset documentation]

Health and Social Care NVQ
Health and Social Care NVQ
Health and Social Care NVQ
Care NVQ
Care NVQ
Care NVQ
Any Learning Disabled Awards Framework (LDAF) award
Other health and care-related NVQ(s)
Registered Manager’s (Adults) NVQ
Other management awards
A1, A2 or other Assessor NVQ
V1 or other Internal Verifier NVQ
L20 or other Mentoring NVQ
Social Work degree (UK)
Social Work diploma or other approved UK or non-UK social work qualification
Combined Nursing & Social Work degree
Post-Qualifying Award in Social Work (PQSW) Part 1
Advanced Award in Social Work (AASW)
Mental Health Social Work Award (MHSWA)
Mentor Award
Other Post-Qualifying Social Work Award
Any professional Occupational Therapy qualification
Any Registered Nursing qualification
Any qualification in assessment of work-based learning other than social work
Any other relevant professional qualification
A Basic Skills qualification
A Basic Skills qualification
A Basic Skills qualification
Any other qualification relevant to social care
Any other qualification relevant to the job role
Any other qualifications held
Supporting Activity Provision in Social Care
Activity Provision in Social Care
Awareness of Dementia
Awareness of Dementia
Dementia Care
Dementia Care
Emergency First Aid at Work
Health and Social Care – Generic pathway
Health and Social Care – Generic pathway
Health and Social Care – Dementia
Health and Social Care – Dementia
Health and Social Care – Learning disabilities
Health and Social Care – Learning disabilities
Leadership in Health and Social Care and Children and Young People’s Services – Adults’ Residential Management
Leadership in Health and Social Care and Children and Young People’s Services – Adults’ Management
Leadership in Health and Social Care and Children and Young People’s Services – Adults’ Advanced Practice
Supporting Individuals with Learning Disabilities
Supporting Individuals with Learning Disabilities
Understanding Working with People with Mental Health Issues
Assisting and Moving Individuals in Social Care
Providing an Induction in to Assisting & Moving Individuals in Adult Social Care
Preparing to work in Adult Social Care
Preparing to work in Adult Social Care
Any Assessor qualification
Any Internal Verifier qualification
Any Mentoring qualification
Preparing to Work in Adult Social Care
Award in Stroke Awareness
Certificate in Stroke Care Management
Basic awareness of Diabetes
Working with individuals with Diabetes
Food safety in health and social care and early years and childcare settings
Promoting food safety and nutrition in health and social care or early years and childcare settings
Introduction to Health, Social Care and Children’s and Young People’s Settings
Introduction to Health, Social Care and Children’s and Young People’s Settings
Supporting Individuals with Learning Disabilities
Supporting Individuals with Learning Disabilities
Employment Responsibilities and Rights in Health, Social Care, Children and Young People’s Settings
Delivering Chair-Based Exercise with Frailer Older Adults and Adults with Disabilities in Care and Community Settings
Awareness of End of Life Care
Awareness of End of Life Care
Working in End of Life care
Leading and Managing Services to Support End of Life and Significant Life Events
Awareness of the Mental Capacity Act 2005
Approved Mental Health Practitioner
Approved Social Worker
Award in Supporting Individuals on the Autistic Spectrum
Certificate in Supporting Individuals on the Autistic Spectrum
Adult Care
Adult Care
Any other social care relevant award
Any other non-social care relevant award
Any other social care relevant certificate
Any other non-social care relevant certificate
Any other social care relevant diploma
Any other non-social care relevant diploma
Any children’s/young people’s qualification
Certificate in Independent Advocacy
Certificate in Assisting and Moving Individuals for a Social care Setting
Certificate in Understanding Autism
Certificate in Autism Support
Certificate in Understanding Autism
Certificate in Clinical Skills
Certificate in Clinical Skills
Certificate in Fundamental Knowledge in Commissioning for Wellbeing
Certificate in Understanding Care and Management of Diabetes
Certificate in Understanding Diabetes
Certificate in Understanding Care and Management of Diabetes
Diploma in Care (RQF)
Diploma in Care (RQF)
Certificate in Principles of Leadership and Management in Adult Care
Diploma in Leadership and Management for Adult Care (RQF)
Certificate in Understanding the Safe Handling of Medication
Certificate in Principles of Safe Handling of Medication in Health and Social Care (RQF)
Certificate in Understanding the Safe Handling of Medication in Health and Social Care
Certificate in Awareness of Mental Health Problems
Certificate in Mental Health Awareness
Certificate in Principles of Working with People with Mental Health Needs
Certificate in Understanding Working in Mental Health
Certificate in Understanding Working with People with Mental Health Needs
Certificate in Understanding Mental Health Care
Certificate in Understanding Mental Health Care
Certificate in Social Prescribing
Intermediate Apprenticeship in Health and Social Care (framework)
Adult Care Worker (standard)
Advance Apprenticeships in Health and Social Care (framework)
Adult Care Worker (standard)
Lead Practitioner in Adult Care (standard)
Higher Apprenticeship in Care Leadership and Management (framework)
Leader in Adult Care (standard)
Degree Social Worker (standard)
Nursing Associate (standard)
Degree Registered Nurse (standard)
Any other apprenticeship framework or standard
Occupational Therapist
Physiotherapist

Does the worker hold the qualification – Health and Social Care NVQ at level 2

Not recorded
No
Yes
Not known

Year the worker achieved – Health and Social Care NVQ at level 2

Year

The source of the recruitment.

Not recorded
Adult care sector: local authority
Adult care sector: private or voluntary sector
Health sector
Other sector
Internal promotion or transfer or career development
Not previously employed
Agency
Other sources
Not known
Children’s/young people’s social care
First role after education

The number of sickness days the worker had in the previous 12 months.

Number

Has the worker completed any of the listed training?
[unable to retrieve list from dataset documentation]

Control and restraint
Dementia care
Emergency Aid awareness
Fire Safety
First Aid
Food safety and catering
Health and Safety
Infection Control
Leadership & Management
Learning disability
Medication safe handling and awareness
Mental capacity and deprivation of liberty
Moving and handling
Nutrition and hydration
Palliative or end of life care
Physical Disability
Positive Behaviour and support
Safeguarding Adults
Dignity, Respect, Person Centred care
Equality, Diversity and Human Rights training
Any other not in the above categories
Children’s / young people’s related training
Confidentiality/GDPR
Epilepsy
Communication Skills
Diabetes
COSHH
Mental Health
Autism
Continence Care
Duty of Care
Supervision / Performance management
Stroke
Complaints handling/conflict resolution
Personal Care
Activity provision/Well-being
Sensory disability

Date when nationality was last changed.

Date

Data quality filter – Country of birth

Afghanistan
Albania
Antarctica
Algeria
American Samoa
Andorra
Angola
Antigua and Barbuda
Azerbaijan
Argentina
Australia
Austria
Bahamas
Bahrain
Bangladesh
Armenia
Barbados
Belgium
Bermuda
Bhutan
Bolivia
Bosnia and Herzegovina
Botswana
Bouvet Island
Brazil
Belize
British Indian Ocean Territory
Solomon Islands
Virgin Islands British
Brunei Darussalam
Bulgaria
Myanmar
Burundi
Belarus
Cambodia
Cameroon
Canada
Cape Verde
Cayman Islands
Central African Republic
Sri Lanka
Chad
Chile
China
Taiwan Province of China
Christmas Island
Cocos (Keeling) Islands
Colombia
Comoros
Mayotte
Congo
Congo Democratic Republic of the
Cook Islands
Costa Rica
Croatia
Cuba
Cyprus
Czech Republic
Benin
Denmark
Dominica
Dominican Republic
Ecuador
El Salvador
Equatorial Guinea
Ethiopia
Eritrea
Estonia
Faroe Islands
Falkland Islands (Malvinas)
South Georgia and the South Sandwich Islands
Fiji
Finland
Aland Islands
France
French Guiana
French Polynesia
French Southern Territories
Djibouti
Gabon
Georgia
Gambia
Palestine, State of
Germany
Ghana
Gibraltar
Kiribati
Greece
Greenland
Grenada
Guadeloupe
Guam
Guatemala
Guinea
Guyana
Haiti
Heard Island and McDonald Islands
Holy See (Vatican City State)
Honduras
Hong Kong
Hungary
Iceland
India
Indonesia
Iran Islamic Republic of
Iraq
Ireland
Israel
Italy
Cote d’Ivoire
Jamaica
Japan
Kazakhstan
Jordan
Kenya
Korea Democratic People’s Republic of
Korea Republic of
Kuwait
Kyrgyzstan
Laos
Lebanon
Lesotho
Latvia
Liberia
Libya
Liechtenstein
Lithuania
Luxembourg
Macao
Madagascar
Malawi
Malaysia
Maldives
Mali
Malta
Martinique
Mauritania
Mauritius
Mexico
Monaco
Mongolia
Moldova
Montenegro
Montserrat
Morocco
Mozambique
Oman
Namibia
Nauru
Nepal
Netherlands
Curacao (Formerly Netherlands Antilles)
Aruba
Sint Maarten (Dutch part) (Formerly Netherlands Antilles)
Bonaire, Sint Eustatius and Saba
New Caledonia
Vanuatu
New Zealand
Nicaragua
Niger
Nigeria
Niue
Norfolk Island
Norway
Northern Mariana Islands
US Minor Outlying Islands
Micronesia Federated States of
Marshall Islands
Palau
Pakistan
Panama
Papua New Guinea
Paraguay
Peru
Philippines
Pitcairn
Poland
Portugal
Guinea-Bissau
Timor-Leste
Puerto Rico
Qatar
Reunion
Romania
Russian Federation
Rwanda
Saint Barthelemy
St Helena Ascension & Tristan da Cunha
Saint Kitts and Nevis
Anguilla
Saint Lucia
Saint Martin (French part)
Saint Pierre and Miquelon
St Vincent and the Grenadines
San Marino
Sao Tome and Principe
Saudi Arabia
Senegal
Serbia
Seychelles
Sierra Leone
Singapore
Slovakia
Viet Nam
Slovenia
Somalia
South Africa
Zimbabwe
Spain
South Sudan
Western Sahara
Sudan
Suriname
Svalbard and Jan Mayen
Swaziland
Sweden
Switzerland
Syrian Arab Republic
Tajikistan
Thailand
Togo
Tokelau
Tonga
Trinidad and Tobago
United Arab Emirates
Tunisia
Turkey
Turkmenistan
Turks and Caicos Islands
Tuvalu
Uganda
Ukraine
Macedonia the former Yugoslav Republic of
Egypt
United Kingdom
Guernsey
Jersey
Tanzania Untd Republic of
United States
Virgin Islands U.S.
Burkina Faso
Uruguay
Uzbekistan
Venezuela
Wallis and Futuna
Samoa
Yemen
Zambia
Kosovo
Unknown

Reason for excluding worker from country of birth

Included
No COB data supplied
All workers non-UK (not known)
50+ workers and all non-UK born
100+ workers and 99%+ are non-UK born (org)
100+ workers and 99%+ are non-UK born (est)
500+ workers and 99% are UK born (org)
500+ workers and 99% are UK born (est)
100+ workers and all are UK born (org) – E/EM/L/SE/SW/WM only
100+ workers and all are UK born (est) – E/EM/L/SE/SW/WM only
200+ workers and 99%+ are UK born (org) – LDN & SE only
200+ workers and 99%+ are UK born (est) – LDN & SE only
50%+ of non-UK born are non-UK-not known (org)

Was the worker born in the UK?

The workers country of birth.

Afghanistan
Albania
Antarctica
Algeria
American Samoa
Andorra
Angola
Antigua and Barbuda
Azerbaijan
Argentina
Australia
Austria
Bahamas
Bahrain
Bangladesh
Armenia
Barbados
Belgium
Bermuda
Bhutan
Bolivia
Bosnia and Herzegovina
Botswana
Bouvet Island
Brazil
Belize
British Indian Ocean Territory
Solomon Islands
Virgin Islands British
Brunei Darussalam
Bulgaria
Myanmar
Burundi
Belarus
Cambodia
Cameroon
Canada
Cape Verde
Cayman Islands
Central African Republic
Sri Lanka
Chad
Chile
China
Taiwan Province of China
Christmas Island
Cocos (Keeling) Islands
Colombia
Comoros
Mayotte
Congo
Congo Democratic Republic of the
Cook Islands
Costa Rica
Croatia
Cuba
Cyprus
Czech Republic
Benin
Denmark
Dominica
Dominican Republic
Ecuador
El Salvador
Equatorial Guinea
Ethiopia
Eritrea
Estonia
Faroe Islands
Falkland Islands (Malvinas)
South Georgia and the South Sandwich Islands
Fiji
Finland
Aland Islands
France
French Guiana
French Polynesia
French Southern Territories
Djibouti
Gabon
Georgia
Gambia
Palestine, State of
Germany
Ghana
Gibraltar
Kiribati
Greece
Greenland
Grenada
Guadeloupe
Guam
Guatemala
Guinea
Guyana
Haiti
Heard Island and McDonald Islands
Holy See (Vatican City State)
Honduras
Hong Kong
Hungary
Iceland
India
Indonesia
Iran Islamic Republic of
Iraq
Ireland
Israel
Italy
Cote d’Ivoire
Jamaica
Japan
Kazakhstan
Jordan
Kenya
Korea Democratic People’s Republic of
Korea Republic of
Kuwait
Kyrgyzstan
Laos
Lebanon
Lesotho
Latvia
Liberia
Libya
Liechtenstein
Lithuania
Luxembourg
Macao
Madagascar
Malawi
Malaysia
Maldives
Mali
Malta
Martinique
Mauritania
Mauritius
Mexico
Monaco
Mongolia
Moldova
Montenegro
Montserrat
Morocco
Mozambique
Oman
Namibia
Nauru
Nepal
Netherlands
Curacao (Formerly Netherlands Antilles)
Aruba
Sint Maarten (Dutch part) (Formerly Netherlands Antilles)
Bonaire, Sint Eustatius and Saba
New Caledonia
Vanuatu
New Zealand
Nicaragua
Niger
Nigeria
Niue
Norfolk Island
Norway
Northern Mariana Islands
US Minor Outlying Islands
Micronesia Federated States of
Marshall Islands
Palau
Pakistan
Panama
Papua New Guinea
Paraguay
Peru
Philippines
Pitcairn
Poland
Portugal
Guinea-Bissau
Timor-Leste
Puerto Rico
Qatar
Reunion
Romania
Russian Federation
Rwanda
Saint Barthelemy
St Helena Ascension & Tristan da Cunha
Saint Kitts and Nevis
Anguilla
Saint Lucia
Saint Martin (French part)
Saint Pierre and Miquelon
St Vincent and the Grenadines
San Marino
Sao Tome and Principe
Saudi Arabia
Senegal
Serbia
Seychelles
Sierra Leone
Singapore
Slovakia
Viet Nam
Slovenia
Somalia
South Africa
Zimbabwe
Spain
South Sudan
Western Sahara
Sudan
Suriname
Svalbard and Jan Mayen
Swaziland
Sweden
Switzerland
Syrian Arab Republic
Tajikistan
Thailand
Togo
Tokelau
Tonga
Trinidad and Tobago
United Arab Emirates
Tunisia
Turkey
Turkmenistan
Turks and Caicos Islands
Tuvalu
Uganda
Ukraine
Macedonia the former Yugoslav Republic of
Egypt
United Kingdom
Guernsey
Jersey
Tanzania Untd Republic of
United States
Virgin Islands U.S.
Burkina Faso
Uruguay
Uzbekistan
Venezuela
Wallis and Futuna
Samoa
Yemen
Zambia
Kosovo
Unknown

If the worker was not born in the UK, the year the worker arrive in the UK?

Not recorded
No
Yes
Not known

The employment status of staff record.

Not recorded
Permanent
Temporary
Bank or pool
Agency
Student
Other

The workers main job role.

Senior Management
Middle Management
First Line Manager
Registered Manager
Supervisor
Social Worker
Senior Care Worker
Care Worker
Community Support and Outreach Work
Employment Support
Advice Guidance and Advocacy
Occupational Therapist
Registered Nurse
Allied Health Professional
Technician
Other care-providing job role
Managers and staff in care-related but not care-providing roles
Administrative or office staff not care-providing
Ancillary staff not care-providing
Other non-care-providing job roles
Activities worker or co-ordinator
Safeguarding and reviewing officer
Occupational therapist assistant
Nursing Associate
Nursing Assistant
Assessment officer
Care co-ordinator
Care navigator
Any Children’s/young peoples job role

Is the worker employed on a zero-hours contract?

Not recorded
No
Yes
Not known

The average hours worked in the previous week. Dependent on employment status and zero-hours contract.

Average hours

The contracted weekly hours of the worker. Dependent on employment status and zero-hours contract.

Weekly hours

Is the worker employed in the role – Senior Management

Not recorded
No
Yes
Not known

Is the social worker employed as a Approved Mental Health Professional. Dependent on jr06flag.

Not recorded
No
Yes
Not known

The workers start date in their current role.

Date

The year the worker started in their current role.

Year

The year the worker started working in adult social care.

Year

The local authority area of the workplace. Based on local authority district, unitary authority, metropolitan district or London borough.

Eastern
East Midlands
London
North East
North West
South East
South West
West Midlands
Yorkshire and the Humber

The clinical commissioning group area.

NHS Airedale, Wharfedale and Craven
NHS Ashford
NHS Aylesbury Vale
NHS Barking and Dagenham
NHS Barnet
NHS Barnsley
NHS Basildon and Brentwood
NHS Bassetlaw
NHS Bath and North East Somerset
NHS Bedfordshire
NHS Bexley
NHS Birmingham CrossCity
NHS Birmingham South and Central
NHS Blackburn with Darwen
NHS Blackpool
NHS Bolton
NHS Bracknell and Ascot
NHS Bradford City
NHS Bradford Districts
NHS Brent
NHS Brighton and Hove
NHS Bristol
NHS Bromley
NHS Bury
NHS Calderdale
NHS Cambridgeshire and Peterborough
NHS Camden
NHS Cannock Chase
NHS Canterbury and Coastal
NHS Castle Point and Rochford
NHS Central London (Westminster)
NHS Central Manchester
NHS Chiltern
NHS Chorley and South Ribble
NHS City and Hackney
NHS Corby
NHS Coventry and Rugby
NHS Crawley
NHS Croydon
NHS Cumbria
NHS Darlington
NHS Dartford, Gravesham and Swanley
NHS Doncaster
NHS Dorset
NHS Dudley
NHS Durham Dales, Easington and Sedgefield
NHS Ealing
NHS East and North Hertfordshire
NHS East Lancashire
NHS East Leicestershire and Rutland
NHS East Riding of Yorkshire
NHS East Staffordshire
NHS East Surrey
NHS Eastbourne, Hailsham and Seaford
NHS Eastern Cheshire
NHS Enfield
NHS Erewash
NHS Fareham and Gosport
NHS Gloucestershire
NHS Great Yarmouth and Waveney
NHS Greater Huddersfield
NHS Greenwich
NHS Halton
NHS Hambleton, Richmond shire and Whitby
NHS Hammersmith and Fulham
NHS Hardwick
NHS Haringey
NHS Harrogate and Rural District
NHS Harrow
NHS Hartlepool and Stockton-on-Tees
NHS Hastings and Rother
NHS Havering
NHS Herefordshire
NHS Herts Valleys
NHS Heywood, Middleton and Rochdale
NHS High Weald Lewes Havens
NHS Hillingdon
NHS Horsham and Mid Sussex
NHS Hounslow
NHS Hull
NHS Ipswich and East Suffolk
NHS Isle of Wight
NHS Islington
NHS Kernow
NHS Kingston
NHS Knowsley
NHS Lambeth
NHS Lancashire North
NHS Leeds North
NHS Leeds South and East
NHS Leeds West
NHS Leicester City
NHS Lewisham
NHS Lincolnshire East
NHS Lincolnshire West
NHS Liverpool
NHS Luton
NHS Mansfield and Ashfield
NHS Medway
NHS Merton
NHS Mid Essex
NHS Milton Keynes
NHS Nene
NHS Newark and Sherwood
NHS Newbury and District
NHS Newham
NHS North & West Reading
NHS North Derbyshire
NHS North Durham
NHS North East Essex
NHS North East Hampshire and Farnham
NHS North East Lincolnshire
NHS North Hampshire
NHS North Kirklees
NHS North Lincolnshire
NHS North Manchester
NHS North Norfolk
NHS North Somerset
NHS North Staffordshire
NHS North Tyneside
NHS North West Surrey
NHS Northern, Eastern and Western Devon
NHS Northumberland
NHS Nottingham City
NHS Nottingham North and East
NHS Nottingham West
NHS Oldham
NHS Oxfordshire
NHS Portsmouth
NHS Redbridge
NHS Redditch and Bromsgrove
NHS Richmond
NHS Rotherham
NHS Rushcliffe
NHS Salford
NHS Sandwell and West Birmingham
NHS Scarborough and Ryedale
NHS Sheffield
NHS Shropshire
NHS Slough
NHS Solihull
NHS Somerset
NHS South Cheshire
NHS South Devon and Torbay
NHS South East Staffordshire and Selsdon Peninsula
NHS South Eastern Hampshire
NHS South Gloucestershire
NHS South Kent Coast
NHS South Lincolnshire
NHS South Manchester
NHS South Reading
NHS South Sefton
NHS South Tees
NHS South Tyneside
NHS South Warwickshire
NHS South West Lincolnshire
NHS South Worcestershire
NHS Southampton
NHS Southend
NHS Southern Derbyshire
NHS Southport and Formby
NHS Southwark
NHS St Helens
NHS Stafford and Surrounds
NHS Stockport
NHS Stoke on Trent
NHS Sunderland
NHS Surrey Downs
NHS Surrey Heath
NHS Sutton
NHS Swale
NHS Swindon
NHS Tameside and Glossop
NHS Telford and Wrekin
NHS Thanet
NHS Thurrock
NHS Tower Hamlets
NHS Trafford
NHS Vale of York
NHS Vale Royal
NHS Wakefield
NHS Walsall
NHS Waltham Forest
NHS Wandsworth
NHS Warrington
NHS Warwickshire North
NHS West Cheshire
NHS West Essex
NHS West Hampshire
NHS West Kent
NHS West Lancashire
NHS West Leicestershire
NHS West London
NHS West Norfolk
NHS West Suffolk
NHS Wigan Borough
NHS Wiltshire
NHS Windsor Ascot and Maidenhead
NHS Wirral
NHS Wokingham
NHS Wolverhampton
NHS Wyre Forest
NHS Newcastle Gateshead
NHS Coastal West Sussex
NHS Guildford and Waverley
NHS North Cumbria
NHS Manchester
NHS Norwich
NHS South Norfolk
NHS Birmingham and Solihull
NHS Berkshire West
NHS Bristol, North Somerset and South Gloucestershire
NHS Buckinghamshire
NHS East Berkshire
NHS Leeds
NHS Fylde and Wyre
NHS Greater Preston
NHS Morecambe Bay
NHS Derby and Derbyshire
NHS Devon
NHS Bath and North East Somerset, Swindon and Wiltshire
NHS Bradford District and Craven
NHS Cheshire
NHS County Durham
NHS East Sussex
NHS Herefordshire and Worcestershire
NHS Kent and Medway
NHS Lincolnshire
NHS Norfolk & Waveney
NHS North Central London
NHS North Yorkshire
NHS Northamptonshire
NHS Nottingham and Nottinghamshire
NHS South East London
NHS South West London
NHS Surrey Heartlands
NHS Tees Valley
NHS West Sussex
NHS Bedfordshire, Luton and Milton Keynes
NHS Black Country and West Birmingham
NHS Coventry and Warwickshire
NHS Frimley
NHS Hampshire, Southampton and Isle of Wight
NHS Kirklees
NHS North East London
NHS North West London
NHS Shropshire, Telford and Wrekin

Local authority district – Unitary authority – Metropolitan district – London borough. Defined by ONS.

Hartlepool
Middlesbrough
Redcar and Cleveland
Stockton-on-Tees
Darlington
Halton
Warrington
Blackburn with Darwen
Blackpool
Kingston upon Hull, City of
East Riding of Yorkshire
North East Lincolnshire
North Lincolnshire
York
Derby
Leicester
Rutland
Nottingham
Herefordshire, County of
Telford and Wrekin
Stoke-on-Trent
Bath and North East Somerset
Bristol, City of
North Somerset
South Gloucestershire
Plymouth
Torbay
Swindon
Peterborough
Luton
Southend-on-Sea
Thurrock
Medway
Bracknell Forest
West Berkshire
Reading
Slough
Windsor and Maidenhead
Wokingham
Milton Keynes
Brighton and Hove
Portsmouth
Southampton
Isle of Wight
County Durham
Cheshire East
Cheshire West and Chester
Shropshire
Cornwall
Isles of Scilly
Wiltshire
Bedford
Central Bedfordshire
Northumberland
Bournemouth, Christchurch and Poole
Dorset
Buckinghamshire
Cambridge
East Cambridgeshire
Fenland
Huntingdonshire
South Cambridgeshire
Allerdale
Barrow-in-Furness
Carlisle
Copeland
Eden
South Lakeland
Amber Valley
Bolsover
Chesterfield
Derbyshire Dales
Erewash
High Peak
North East Derbyshire
South Derbyshire
East Devon
Exeter
Mid Devon
North Devon
South Hams
Teignbridge
Torridge
West Devon
Eastbourne
Hastings
Lewes
Rother
Wealden
Basildon
Braintree
Brentwood
Castle Point
Chelmsford
Colchester
Epping Forest
Harlow
Maldon
Rochford
Tendring
Uttlesford
Cheltenham
Cotswold
Forest of Dean
Gloucester
Stroud
Tewkesbury
Basingstoke and Deane
East Hampshire
Eastleigh
Fareham
Gosport
Hart
Havant
New Forest
Rushmoor
Test Valley
Winchester
Broxbourne
Dacorum
Hertsmere
North Hertfordshire
Three Rivers
Watford
Ashford
Canterbury
Dartford
Dover
Gravesham
Maidstone
Sevenoaks
Folkestone and Hythe
Swale
Thanet
Tonbridge and Malling
Tunbridge Wells
Burnley
Chorley
Fylde
Hyndburn
Lancaster
Pendle
Preston
Ribble Valley
Rossendale
South Ribble
West Lancashire
Wyre
Blaby
Charnwood
Harborough
Hinckley and Bosworth
Melton
North West Leicestershire
Oadby and Wigston
Boston
East Lindsey
Lincoln
North Kesteven
South Holland
South Kesteven
West Lindsey
Breckland
Broadland
Great Yarmouth
King’s Lynn and West Norfolk
North Norfolk
Norwich
South Norfolk
Corby
Daventry
East Northamptonshire
Kettering
Northampton
South Northamptonshire
Wellingborough
Craven
Hambleton
Harrogate
Richmond shire
Ryedale
Scarborough
Selby
Ashfield
Bassetlaw
Broxtowe
Gedling
Mansfield
Newark and Sherwood
Rushcliffe
Cherwell
Oxford
South Oxfordshire
Vale of White Horse
West Oxfordshire
Mendip
Sedgemoor
South Somerset
Cannock Chase
East Staffordshire
Lichfield
Newcastle-under-Lyme
South Staffordshire
Stafford
Staffordshire Moorlands
Tamworth
Babergh
Ipswich
Mid Suffolk
Elmbridge
Epsom and Ewell
Guildford
Mole Valley
Reigate and Banstead
Runnymede
Spelthorne
Surrey Heath
Tandridge
Waverley
Woking
North Warwickshire
Nuneaton and Bedworth
Rugby
Stratford-on-Avon
Warwick
Adur
Arun
Chichester
Crawley
Horsham
Mid Sussex
Worthing
Bromsgrove
Malvern Hills
Redditch
Worcester
Wychavon
Wyre Forest
St Albans
Welwyn Hatfield
East Hertfordshire
Stevenage
East Suffolk
West Suffolk
Somerset West and Taunton
Bolton
Bury
Manchester
Oldham
Rochdale
Salford
Stockport
Tameside
Trafford
Wigan
Knowsley
Liverpool
St. Helens
Sefton
Wirral
Barnsley
Doncaster
Rotherham
Sheffield
Newcastle upon Tyne
North Tyneside
South Tyneside
Sunderland
Birmingham
Coventry
Dudley
Sandwell
Solihull
Walsall
Wolverhampton
Bradford
Calderdale
Kirklees
Leeds
Wakefield
Gateshead
City of London
Barking and Dagenham
Barnet
Bexley
Brent
Bromley
Camden
Croydon
Ealing
Enfield
Greenwich
Hackney
Hammersmith and Fulham
Haringey
Harrow
Havering
Hillingdon
Hounslow
Islington
Kensington and Chelsea
Kingston upon Thames
Lambeth
Lewisham
Merton
Newham
Redbridge
Richmond upon Thames
Southwark
Sutton
Tower Hamlets
Waltham Forest
Wandsworth
Westminster

Straight line distance between workers home and workplace postcode in miles.

Staight line distance between workers home and workplace postcode in miles.

The sector of the workplace.

Not allocated
Local authority (adult services)
Local authority (generic/other)
Private sector
Voluntary/charity
Other

The total number of staff at the workplace.

Number

Number of staff records for the workplace.

Number

The main service provided by the workplace.

Care home services with nursing – CQC Regulated
Care home services without nursing – CQC Regulated
Sheltered housing
Other adult residential care service
Day care and day services
Other adult day care services
Domiciliary Care services – CQC Regulated
Live-in Care (can only be used as Other Service) – CQC Regulated
Extra Care housing services – CQC Regulated
Supported living services – CQC Regulated
Domestic services and home help
Other adult domiciliary care services
Shared lives – CQC Regulated
Carers support
Short breaks or respite care
Community support and outreach
Social work and care management
Disability adaptations or assistive technology services
Occupational or employment related services
Information and advice services
Other adult community care services
Community based services for people with a learning disability – CQC Regulated
Community based services for people with mental health needs – CQC Regulated
Community based services for people who misuse substances – CQC Regulated
Community healthcare services – CQC Regulated
Hospice services – CQC Regulated
Long Term conditions services – CQC Regulated
Hospital services for people with mental health needs and/or learning disabilities and/or problems with substance misuse – CQC Regulated
Rehabilitation services – CQC Regulated
Residential substance misuse treatment/rehabilitation services – CQC Regulated
Other healthcare service
Nurses agency – CQC Regulated
Any Other Services
Head Office Services
Any children’s young peoples services
Specialist College Services – SPC

Date when any service provided was last changed.

Date

Capacity of the service at the workplace.

Number

Utilisation

Don’t know
Not recorded
No
Yes
Not disclosed

Date when any service user type was last changed.

Date

Type of people cared for at the service.

Older people with dementia
Older people with mental disorders or infirmities, excluding learning disability or dementia
Older people detained under the Mental Health Act
Older people with learning disabilities and/or autism
Older people with physical disabilities
Older people with sensory impairment(s)
Older people who misuse alcohol/drugs
Older people with an eating disorder
Older people others not in above categories
Adults with dementia
Adults with mental disorders or infirmities, excluding learning disability or dementia
Adults detained under the Mental Health Act
Adults with learning disabilities and/or autism
Adults with physical disabilities
Adults with sensory impairments
Adults who misuse alcohol or drugs
Adults with an eating disorder
Adults others not in above categories
Any children and young people
Carers of older people
Carers of adults
Carers of children and young people
Other others not in above categories

Date the staff record was created.

Date

Date the staff record was last changed.

Date

Unique identifier for a staff record.

Identifier

Unique identifier for an individual. Based on NI number of date of birth.

Identifier

The workers age when the dataset was captured.

Age

The workers gender.

Not recorded
Male
Female
Unknown
Other

Does the worker identify as having a disability?

Don’t know
Not recorded
No
Yes
Not disclosed

The workers ethnicity.

Not recorded
English / Welsh / Scottish / Northern Irish / British
Irish
Gypsy or Irish Traveller
Any Other White background
White and Black Caribbean
White and Black African
White and Asian
Any Other Mixed / multiple ethnic background
Indian
Pakistani
Bangladeshi
Chinese
Any other Asian background
African
Caribbean
Any other Black / African / Caribbean background
Arab
Any other ethnic group
Not known

Data quality filter – Nationality

Afghan
Albanian
Algerian
American
Andorran
Angolan
Citizen of Antigua and Barbuda
Azerbaijani
Argentine
Australian
Australian
Australian
Australian
Australian
Austrian
Bahamian
Bahraini
Bangladeshi
Armenian
Barbadian
Belgian
Bermudian
Bhutanese
Bolivian
Citizen of Bosnia and Herzegovina
Botswanan
Brazilian
Belizean
Solomon Islander
Bruneian
Bulgarian
Burmese
Burundian
Belarusian
Cambodian
Cameroonian
Canadian
Cape Verdean
Cayman Islander
Central African
Sri Lankan
Chadian
Chilean
Chinese
Taiwanese
Colombian
Comoran
Congolese (Congo)
Congolese (DRC)
Cook Islander
Costa Rican
Croatian
Cuban
Cypriot
Czech
Beninese
Danish
Dominican
Citizen of the Dominican Republic
Ecuadorean
Salvadorean
Equatorial Guinean
Ethiopian
Eritrean
Estonian
Faroese
Fijian
Finnish
Finnish
French
French
French
French
French
French
French
French
French
French
French
Djiboutian
Gabonese
Georgian
Gambian
Palestinian
German
Ghanaian
Gibraltarian
Citizen of Kiribati
Greek
Greenlandic
Grenadian
Guamanian
Guatemalan
Guinean
Guyanese
Haitian
Honduran
Hong Konger
Hungarian
Icelandic
Indian
Indonesian
Iranian
Iraqi
Irish
Israeli
Italian
Italian
Ivorian
Jamaican
Japanese
Kazakh
Jordanian
Kenyan
North Korean
South Korean
Kuwaiti
Kyrgyz
Lao
Lebanese
Mosotho
Latvian
Liberian
Libyan
Liechtenstein citizen
Lithuanian
Luxembourger
Macanese
Malagasy
Malawian
Malaysian
Maldivian
Malian
Maltese
Martiniquais
Mauritanian
Mauritian
Mexican
Monegasque
Mongolian
Moldovan
Montenegrin
Montserratian
Moroccan
Mozambican
Omani
Namibian
Nauruan
Nepalese
Dutch
Dutch
Dutch
Dutch
Dutch
Citizen of Vanuatu
New Zealander
New Zealander
Nicaraguan
Nigerien
Nigerian
Niuean
Norwegian
Norwegian
Norwegian
Micronesian
Marshallese
Palauan
Pakistani
Panamanian
Papua New Guinean
Paraguayan
Peruvian
Filipino
Polish
Portuguese
Guinea-Bissau
East Timorese
Puerto Rican
Qatari
Romanian
Russian
Rwandan
St Helenian
Kittitian
Anguillan
St Lucian
Vincentian
Sammarinese
Sao Tomean
Saudi Arabian
Senegalese
Serbian
Citizen of Seychelles
Sierra Leonean
Singaporean
Slovak
Vietnamese
Slovenian
Somali
South African
Zimbabwean
Spanish
South Sudanese
Moroccan
Sudanese
Surinamese
Swazi
Swedish
Swiss
Syrian
Tajik
Thai
Togolese
Tongan
Trinidadian
Emirati
Tunisian
Turkish
Turkmen
Turks and Caicos Islander
Tuvaluan
Ugandan
Ukrainian
Macedonian
Egyptian
British
British
British
British
British
British
British
British
Tanzanian
American
American
American
American
Burkinan
Uruguayan
Uzbek
Venezuelan
Wallisian
Samoan
Samoan
Yemeni
Zambian
Kosovan
Unknown

Reason for excluding worker from nationality

Included
No COB data supplied
All workers non-UK (not known)
50+ workers and all non-UK born
100+ workers and 99%+ are non-UK born (org)
100+ workers and 99%+ are non-UK born (est)
500+ workers and 99% are UK born (org)
500+ workers and 99% are UK born (est)
100+ workers and all are UK born (org) – E/EM/L/SE/SW/WM only
100+ workers and all are UK born (est) – E/EM/L/SE/SW/WM only
200+ workers and 99%+ are UK born (org) – LDN & SE only
200+ workers and 99%+ are UK born (est) – LDN & SE only
50%+ of non-UK born are non-UK-not known (org)

Does the worker have British nationality?

Not recorded
No
Yes
Not known

Date the workplace was created

Year and month

Unique identifier for a workplace. Only used within the dataset.

Unique identifier

The postcode of the workplace.

Postcode

Unique identifier for an organisation. The orgid is the establishment of the parent workplace.

Organisation unique identifier

Flag to define if a workplace has reliable starters or leavers information.

Include
Exclude

Total number of permanent and temporary staff that started in the previous 12 months. This shows ‘Don’t know’, not recorded and no starters.

Number

Total number of permanent and temporary staff that left in the previous 12 months. This shows ‘Don’t know’, not recorded and no leavers.

Number

Total number of permanent and temporary vacancies at the time of the workplace last update. This shows ‘Don’t know’, not recorded and no vacancies.

Number

Does the workplace have staff records?

Don’t know
Not recorded
No
Yes
Not disclosed

Number of permanent staff employed. Based on staff records.

Number

Number of temporary staff employed. Based on staff records.

Number

Number of pool/bank staff employed. Based on staff records.

Number

Number of agency staff employed. Based on staff records.

Number

Number of other staff employed. Based on staff records.

Number

Number of permanent and temporary staff (employees). Based on staff records.

Number

Number of staff records.

Number

Number of permanent and temporary staff that started in the previous 12 months. If totalstarters is ‘not known’ or not recorded, value is zero.

Number

Number of permanent and temporary staff that left in the previous 12 months. If totalleavers is ‘not known’ or not recorded, value is zero.

Number

Number of permanent and temporary staff vacancies at the time of last update. If totalvacancies is ‘not known’ or not recorded, value is zero.

Number

Sum of totalstaff across the organisation.

Number

Number of instances of training completed in category – Control and restraint both accredited and non-accredited

Number of instances

Most recent date the worker completed training in category – Control and restraint

Date

Has the worker completed training in category – Control and restraint

Has the worker completed any of the listed training?

Type of people cared for at the service

Type of people

The average hours workers in the previous week. Dependent on employment status and zero-hours contract.

No. of hours.

The worker’s gender.

Gender value

The workers age when the dataset was captured.

Age value

Utilisation (of service at provider)

Number of utilisations

Capacity of the service at the workplace.

Capacity value

The main service provided by the workplace.

Service type

Sum of total staff across the organisation.

Number of staff. Also shows ‘Don’t know’, not recorded and no starters.

Number of staff records.

Number of records.

Number of permanent and temporary staff (employees). Based on staff records.

Number of staff. Also shows ‘Don’t know’, not recorded and no starters.

Number of other staff employed. Based on staff records.

Number of staff. Also shows ‘Don’t know’, not recorded and no starters.

Number of agency staff employed. Based on staff records.

Number of staff. Also shows ‘Don’t know’, not recorded and no starters.

Number of pool/bank staff employed. Based on staff records.

Number of staff. Also shows ‘Don’t know’, not recorded and no starters.

Number of temporary staff employed. Based on staff records.

Number of staff. Also shows ‘Don’t know’, not recorded and no starters.

Number of permanent staff employed. Based on staff records.

Number of staff. Also shows ‘Don’t know’, not recorded and no starters.

Total number of permanent and temporary vacancies at the time of the workplace last update.

Number of vacancies. Also shows ‘Don’t know’, not recorded and no starters.

Total number of permanent and temporary staff that left in the previous 12 months.

Number of staff. Also shows ‘Don’t know’, not recorded and no starters.

Total number of permanent and temporary staff that started in the previous 12 months.

Number of staff. Also shows ‘Don’t know’, not recorded and no starters.