{"id":"cqc","meta":{"id":"cqc","name":"CQC care providers directory (England)","category":"records","country":"GB","region":"England","licence":"Open Government Licence v3.0","attribution":"Contains public sector information licensed under the Open Government Licence v3.0. Source: Care Quality Commission (CQC). This product is not endorsed by or affiliated with the CQC.","row_count":57204,"refreshed_at":"2026-11-09T17:45:57.677Z","source_refreshed_at":"2026-11-09T17:45:57.677Z","cqc_rating_fallback_json":"{\"base_imported_at\":\"2026-11-09T17:45:57.677Z\",\"source_date\":\"2026-11-02\",\"source_url\":\"https://www.cqc.org.uk/system/files/2026-11/2_November_2026_HSCA_Active_Locations.ods\",\"source_sha256\":\"94eead37fe90b9dd2d23a332c8420d0447f292211246a6627ee387cc5eed3a10\",\"applied_at\":\"2026-11-09T17:45:57.677Z\",\"applied_count\":8796}"},"columns":[{"key":"locationId","label":"CQC Location ID","class":"organisational"},{"key":"locationName","label":"Name","class":"organisational"},{"key":"alsoKnownAs","label":"Also known as","class":"organisational"},{"key":"providerName","label":"Provider","class":"organisational"},{"key":"providerId","label":"CQC Provider ID","class":"organisational"},{"key":"careHome","label":"Care home","class":"organisational"},{"key":"serviceType","label":"Service types","class":"organisational"},{"key":"primaryServiceType","label":"Primary service type","class":"organisational"},{"key":"regulatedActivities","label":"Regulated activities","class":"organisational"},{"key":"specialisms","label":"Specialisms / service user bands","class":"organisational"},{"key":"numberOfBeds","label":"Beds","class":"organisational"},{"key":"addressLine1","label":"Address line 1","class":"organisational"},{"key":"addressLine2","label":"Address line 2","class":"organisational"},{"key":"townCity","label":"Town/City","class":"organisational"},{"key":"county","label":"County","class":"organisational"},{"key":"region","label":"Region","class":"organisational"},{"key":"postcode","label":"Postcode","class":"organisational"},{"key":"localAuthority","label":"Local authority","class":"organisational"},{"key":"latitude","label":"Latitude","class":"organisational"},{"key":"longitude","label":"Longitude","class":"organisational"},{"key":"phone","label":"Phone","class":"organisational"},{"key":"website","label":"Website","class":"organisational"},{"key":"cqcUrl","label":"CQC profile URL","class":"organisational"},{"key":"registrationStatus","label":"Registration status","class":"organisational"},{"key":"registrationDate","label":"Registration date","class":"organisational"},{"key":"overallRating","label":"Overall rating","class":"organisational"},{"key":"ratingSafe","label":"Rating: safe","class":"organisational"},{"key":"ratingEffective","label":"Rating: effective","class":"organisational"},{"key":"ratingCaring","label":"Rating: caring","class":"organisational"},{"key":"ratingResponsive","label":"Rating: responsive","class":"organisational"},{"key":"ratingWellLed","label":"Rating: well-led","class":"organisational"},{"key":"lastInspectionDate","label":"Latest check","class":"organisational"},{"key":"overallRatingSource","label":"Overall rating source","class":"organisational"},{"key":"overallRatingSourceDate","label":"Overall rating source date","class":"organisational"},{"key":"overallRatingPublicationDate","label":"Overall rating publication date","class":"organisational"}],"filters":[{"key":"locationId","label":"CQC location ID (exact)","type":"text","serverSide":true,"op":"eq","caseSensitive":true,"example":"1-100000000","description":"Exact published CQC location identifier. Keep identifiers as strings."},{"key":"providerId","label":"CQC provider ID (exact)","type":"text","serverSide":true,"op":"eq","caseSensitive":true,"example":"1-100000001","description":"Exact registered-provider identifier, not a verified ultimate owner or brand group."},{"key":"region","label":"Region","type":"enum","options":["East Midlands","East of England","London","North East","North West","South East","South West","West Midlands","Yorkshire and The Humber"],"serverSide":true,"op":"eq","example":"London"},{"key":"localAuthority","label":"Local authority contains","type":"text","serverSide":true,"op":"contains","example":"Leeds"},{"key":"localAuthorityExact","label":"Local authority (exact name)","type":"text","serverSide":true,"op":"eq","column":"localAuthority","caseSensitive":true,"example":"York","description":"Use the full local-authority name exactly as published, including its case. York matches York only, not Yorkshire authorities."},{"key":"careHome","label":"Care homes only","type":"boolean","serverSide":true,"op":"bool","example":"true","description":"Residential and nursing homes only"},{"key":"serviceType","label":"Service type contains","type":"text","serverSide":false,"op":"contains","example":"Nursing homes","description":"e.g. Residential homes, Nursing homes, Homecare agencies, Supported living, Dentist, Doctors/GPs, Hospital, Hospice, Clinic, Ambulances, Diagnosis/screening"},{"key":"specialism","label":"Specialism contains","type":"text","serverSide":false,"op":"contains","column":"specialisms","example":"Dementia"},{"key":"postcodeArea","label":"Postcode area","type":"text","serverSide":false,"op":"prefix","column":"postcode","example":"LS"},{"key":"nameContains","label":"Name contains","type":"text","serverSide":false,"op":"contains","column":"locationName","example":"Manor"},{"key":"providerContains","label":"Provider contains","type":"text","serverSide":false,"op":"contains","column":"providerName","example":"Barchester"},{"key":"overallRating","label":"Overall rating","type":"enum","options":["Outstanding","Good","Requires improvement","Inadequate"],"serverSide":true,"op":"eq","example":"Inadequate","description":"Match a published rating in the imported data. Missing ratings do not match. Hosted DataScoop queries need no customer CQC key; field availability depends on the imported source."},{"key":"minBeds","label":"Minimum beds","type":"number","serverSide":false,"op":"gte","column":"numberOfBeds","example":"40","description":"At least this many registered beds, not available beds. Missing capacity does not match a positive threshold. Hosted DataScoop queries need no customer CQC key; field availability depends on the imported source."}],"intelligence":{"enabled":true,"authorities":["","Barking and Dagenham","Barnet","Barnsley","Bath and North East Somerset","Bedford","Bexley","Birmingham","Blackburn with Darwen","Blackpool","Bolton","Bournemouth, Christchurch and Poole","Bracknell Forest","Bradford","Brent","Brighton and Hove","Bristol, City of","Bromley","Buckinghamshire","Bury","Calderdale","Cambridgeshire","Camden","Central Bedfordshire","Cheshire East","Cheshire West and Chester","Cornwall","County Durham","Coventry","Croydon","Cumberland","Darlington","Derby","Derbyshire","Devon","Doncaster","Dorset","Dudley","Ealing","East Riding of Yorkshire","East Sussex","Enfield","Essex","Gateshead","Gloucestershire","Greenwich","Hackney","Halton","Hammersmith and Fulham","Hampshire","Haringey","Harrow","Hartlepool","Havering","Herefordshire, County of","Hertfordshire","Hillingdon","Hounslow","Isle of Wight","Isles of Scilly","Islington","Kensington and Chelsea","Kent","Kingston upon Hull, City of","Kingston upon Thames","Kirklees","Knowsley","Lambeth","Lancashire","Leeds","Leicester","Leicestershire","Lewisham","Lincolnshire","Liverpool","Luton","Manchester","Medway","Merton","Middlesbrough","Milton Keynes","Newcastle upon Tyne","Newham","Norfolk","North East Lincolnshire","North Lincolnshire","North Northamptonshire","North Somerset","North Tyneside","North Yorkshire","Northumberland","Nottingham","Nottinghamshire","Oldham","Oxfordshire","Peterborough","Plymouth","Portsmouth","Reading","Redbridge","Redcar and Cleveland","Richmond upon Thames","Rochdale","Rotherham","Rutland","Salford","Sandwell","Sefton","Sheffield","Shropshire","Slough","Solihull","Somerset","South Gloucestershire","South Tyneside","Southampton","Southend-on-Sea","Southwark","St. Helens","Staffordshire","Stockport","Stockton-on-Tees","Stoke-on-Trent","Suffolk","Sunderland","Surrey","Sutton","Swindon","Tameside","Telford and Wrekin","Thurrock","Torbay","Tower Hamlets","Trafford","Unspecified","Wakefield","Walsall","Waltham Forest","Wandsworth","Warrington","Warwickshire","West Berkshire","West Northamptonshire","West Sussex","Westminster","Westmorland and Furness","Wigan","Wiltshire","Windsor and Maidenhead","Wirral","Wokingham","Wolverhampton","Worcestershire","York"]}}