England care-home capacity — September 2026
Source: Care Quality Commission, https://www.cqc.org.uk/about-us/transparency/using-cqc-data
Contains public sector information licensed under the Open Government Licence v3.0.
https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/

DataScoop import: 2026-09-25T09:57:07.273Z
Analysis: 2026-09-26T12:47:15.479Z

The query below runs against the normalised CQC table. This is a fixed snapshot;
rerunning against a later import can give different results. Count locations,
not provider organisations. Recorded beds are not vacancies or staffed capacity.
Blank ratings do not mean a service has never been rated. Other rating statuses
remain distinct. The import date is not a rating publication date.

SELECT
  coalesce(nullif(trim(localAuthority), ''), 'Not recorded') AS authority,
  count(*) AS homes,
  sum(CASE WHEN CAST(numberOfBeds AS REAL) > 0 THEN 1 ELSE 0 END) AS homes_with_beds,
  sum(CASE WHEN CAST(numberOfBeds AS REAL) > 0 THEN CAST(numberOfBeds AS INTEGER) ELSE 0 END) AS recorded_beds
FROM ds_cqc
WHERE lower(CAST(careHome AS TEXT)) IN ('true', '1')
GROUP BY authority
ORDER BY homes DESC;

SELECT
  coalesce(nullif(trim(overallRating), ''), 'Not recorded') AS rating,
  count(*) AS homes
FROM ds_cqc
WHERE lower(CAST(careHome AS TEXT)) IN ('true', '1')
GROUP BY rating
ORDER BY homes DESC;

The CSV contains all 153 recorded authority groups, not only the ten shown on
the guide. Totals are 14,931 care-home locations, 14,928 with positive bed counts,
and 489,957 recorded beds. Three records lack a positive bed count; missing
counts are not evidence of zero capacity. Rating and authority groups preserve
the source snapshot, which may use boundaries different from today's geography.

DataScoop is independent of CQC. This file contains aggregate public data only.
Citation: DataScoop, England care-home capacity: September 2026 snapshot,
https://datascoop.io/fix/list-of-care-homes-england#care-home-capacity