Care Quality Commission
Explore the interactive ERD
Table & Field Reference
location_type
| Column | Type | Keys |
|---|---|---|
type | Unknown | PK |
location_id | Unknown | PKFK |
location_relationship
| Column | Type | Keys |
|---|---|---|
location_id | Unknown | PKFK |
related_location_id | Unknown | PKFK |
reason | Unknown | |
related_location_name | Unknown | |
type | Unknown |
location_regulated_activity_contact
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
location_id | Unknown | PKFK |
location_regulated_activity_code | Unknown | PKFK |
person_family_name | Unknown | |
person_given_name | Unknown | |
person_roles | Json | |
person_title | Unknown |
location_regulated_activity
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
location_id | Unknown | PKFK |
name | Unknown |
location_gac_service_type
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
location_id | Unknown | PKFK |
description | Unknown | |
name | Unknown |
location_inspection_category
| Column | Type | Keys |
|---|---|---|
code | Unknown | PKFK |
location_id | Unknown | PKFK |
is_primary | Unknown | |
name | Unknown |
location_specialism
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
location_id | Unknown | PKFK |
location_inspection_area
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
location_id | Unknown | PKFK |
location_current_overall_key_question_rating
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
location_id | Unknown | PKFK |
report_link_id | Unknown | FK |
organisation_id | Unknown | |
rating | Unknown | |
report_date | Unknown |
location_current_service_key_question_rating
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
location_current_service_rating_name | Unknown | PKFK |
location_id | Unknown | PKFK |
rating | Unknown |
location_current_service_rating
| Column | Type | Keys |
|---|---|---|
location_id | Unknown | PKFK |
name | Unknown | PKFK |
report_link_id | Unknown | FK |
organisation_id | Unknown | |
rating | Unknown | |
report_date | Unknown |
location_historic_overall_key_question_rating
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
location_historic_rating_index | Unknown | PKFK |
location_id | Unknown | PKFK |
rating | Unknown |
location_historic_service_key_question_rating
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
location_historic_service_rating_index | Unknown | PKFK |
location_historic_service_rating_name | Unknown | PKFK |
location_id | Unknown | PKFK |
rating | Unknown |
location_historic_service_rating
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
location_historic_rating_index | Unknown | PKFK |
location_id | Unknown | PKFK |
rating | Unknown |
location_historic_rating
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
location_id | Unknown | PKFK |
report_link_id | Unknown | FK |
organisation_id | Unknown | |
overall_combined_quality_rating | Unknown | |
overall_combined_quality_summary | Unknown | |
overall_rating | Unknown | |
overall_use_of_resources_rating | Unknown | |
overall_use_of_resources_summary | Unknown | |
report_date | Unknown |
location_report_related_document
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
location_id | Unknown | PKFK |
location_report_link_id | Unknown | PKFK |
document_type | Unknown | |
document_uri | Unknown |
location_report
| Column | Type | Keys |
|---|---|---|
link_id | Unknown | PK |
location_id | Unknown | PKFK |
first_visit_date | Unknown | |
report_date | Unknown | |
report_type | Unknown | |
report_uri | Unknown |
location
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
brand_id | Unknown | |
brand_name | Unknown | |
care_home | Unknown | |
constituency | Unknown | |
current_overall_combined_quality_rating | Unknown | |
current_overall_combined_quality_summary | Unknown | |
current_overall_rating | Unknown | |
current_overall_report_date | Unknown | |
current_overall_report_link_id | Unknown | |
current_overall_use_of_resources_rating | Unknown | |
current_overall_use_of_resources_summary | Unknown | |
dormancy | Unknown | |
inspection_directorate | Unknown | |
last_inspection_date | Unknown | |
last_report_publication_date | Unknown | |
local_authority | Unknown | |
main_phone_number | Unknown | |
name | Unknown | |
number_of_beds | Unknown | |
ods_ccg_code | Unknown | |
ods_ccg_name | Unknown | |
ods_code | Unknown | |
onspd_ccg_code | Unknown | |
onspd_ccg_name | Unknown | |
onspd_icb_code | Unknown | |
onspd_icb_name | Unknown | |
onspd_latitude | Unknown | |
onspd_longitude | Unknown | |
organisation_type | Unknown | |
postal_address_line_1 | Unknown | |
postal_address_town_city | Unknown | |
postal_code | Unknown | |
provider_id | Unknown | |
region | Unknown | |
registered_manager_absent_date | Unknown | |
registration_date | Unknown | |
registration_status | Unknown | |
type | Unknown | |
uprn | Unknown |
inspection_category
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
inspection_area_id | Unknown | PKFK |
core_flag | Unknown | |
end_date | Unknown | |
name | Unknown | |
org_inspection_area_retirement_date | Unknown | |
status | Unknown |
inspection_area
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
end_date | Unknown | |
name | Unknown | |
status | Unknown | |
superseded_by | Json | |
type | Unknown |
provider_contact
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
provider_id | Unknown | PKFK |
person_family_name | Unknown | |
person_given_name | Unknown | |
person_roles | Json | |
person_title | Unknown |
provider_location
| Column | Type | Keys |
|---|---|---|
location_id | Unknown | PKFK |
provider_id | Unknown | PKFK |
provider_relationship
| Column | Type | Keys |
|---|---|---|
provider_id | Unknown | PKFK |
related_provider_id | Unknown | PKFK |
reason | Unknown | |
related_provider_name | Unknown | |
type | Unknown |
provider_regulated_activity
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
provider_id | Unknown | PKFK |
name | Unknown | |
nominated_individual_person_family_name | Unknown | |
nominated_individual_person_given_name | Unknown | |
nominated_individual_person_title | Unknown |
provider_inspection_area
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
provider_id | Unknown | PKFK |
provider_inspection_category
| Column | Type | Keys |
|---|---|---|
code | Unknown | PKFK |
provider_id | Unknown | PKFK |
is_primary | Unknown | |
name | Unknown |
provider_historic_service_key_question_rating
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
provider_historic_service_rating_index | Unknown | PKFK |
provider_historic_service_rating_name | Unknown | PKFK |
provider_id | Unknown | PKFK |
rating | Unknown |
provider_historic_service_rating
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
provider_historic_rating_index | Unknown | PKFK |
provider_id | Unknown | PKFK |
rating | Unknown |
provider_historic_overall_key_question_rating
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
provider_historic_rating_index | Unknown | PKFK |
provider_id | Unknown | PKFK |
rating | Unknown |
provider_historic_rating
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
provider_id | Unknown | PKFK |
report_link_id | Unknown | FK |
organisation_id | Unknown | |
overall_combined_quality_rating | Unknown | |
overall_combined_quality_summary | Unknown | |
overall_rating | Unknown | |
overall_use_of_resources_rating | Unknown | |
overall_use_of_resources_summary | Unknown | |
report_date | Unknown |
provider_report_related_document
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
provider_id | Unknown | PKFK |
provider_report_link_id | Unknown | PKFK |
document_type | Unknown | |
document_uri | Unknown |
provider_report
| Column | Type | Keys |
|---|---|---|
link_id | Unknown | PK |
provider_id | Unknown | PKFK |
report_date | Unknown | |
report_type | Unknown | |
report_uri | Unknown |
provider_current_overall_key_question_rating
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
provider_id | Unknown | PKFK |
report_link_id | Unknown | FK |
rating | Unknown | |
report_date | Unknown |
provider_current_service_key_question_rating
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
provider_current_service_rating_name | Unknown | PKFK |
provider_id | Unknown | PKFK |
rating | Unknown |
provider_current_service_rating
| Column | Type | Keys |
|---|---|---|
name | Unknown | PKFK |
provider_id | Unknown | PKFK |
report_link_id | Unknown | FK |
organisation_id | Unknown | |
rating | Unknown | |
report_date | Unknown |
provider
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
brand_id | Unknown | |
brand_name | Unknown | |
charity_number | Unknown | |
companies_house_number | Unknown | |
constituency | Unknown | |
current_overall_combined_quality_rating | Unknown | |
current_overall_combined_quality_summary | Unknown | |
current_overall_rating | Unknown | |
current_overall_report_date | Unknown | |
current_overall_report_link_id | Unknown | |
current_overall_use_of_resources_rating | Unknown | |
current_overall_use_of_resources_summary | Unknown | |
inspection_directorate | Unknown | |
last_inspection_date | Unknown | |
last_report_publication_date | Unknown | |
local_authority | Unknown | |
main_phone_number | Unknown | |
name | Unknown | |
ods_code | Unknown | |
onspd_icb_code | Unknown | |
onspd_icb_name | Unknown | |
onspd_latitude | Unknown | |
onspd_longitude | Unknown | |
organisation_type | Unknown | |
ownership_type | Unknown | |
postal_address_county | Unknown | |
postal_address_line_1 | Unknown | |
postal_address_line_2 | Unknown | |
postal_address_town_city | Unknown | |
postal_code | Unknown | |
region | Unknown | |
registration_date | Unknown | |
registration_status | Unknown | |
type | Unknown | |
uprn | Unknown | |
website | Unknown |