home

cqc_data

Data source: OUseful Databeat

Custom SQL query

active_location_measures

Location ID, Type, Measure, value

308,434 rows

active_locations

Location ID, Location HSCA start date, Care home?, Location Name, Location Telephone Number, Registered manager (note; where there is more than one manager at a location, only one is included here for ease of presentation. The full list is available if required)., Location Web Address, Care homes beds, Location Type/Sector...

49,262 rows

location_service_type

CQC Location, Service types

64,887 rows

location_specialism

CQC Location, Specialisms/services

243,932 rows

locations

CQC Location, Name, Also known as, Address, Postcode, Phone number, Service's website (if available), Date of latest check, Provider name...

49,295 rows

rated_locations

Location ID, Service / Population Group, Key Question, Latest Rating, Publication Date, Report Type

234,816 rows

rated_providers

Provider ID, Service / Population Group, Key Question, Latest Rating, Publication Date, Report Type

7,599 rows

ratings_locations

Location ID, Location Name, Care Home?, Location Type, Location Primary Inspection Category, Location Street Address, Location Address Line 2, Location City, Location Post Code...

29,650 rows

ratings_providers

Provider ID, Provider Name, Provider Type, Provider Primary Inspection Category, Provider Street Address, Provider Address Line 2, Provider City, Provider Post Code, Provider Local Authority...

251 rows

Download SQLite DB: cqc_data.db

Powered by Datasette · Query took 0.101ms · Data source: OUseful Databeat