Health

Location of NHS Hospitals

Show all hospitals


Find hospitals using just a partial postcode (e.g. CH64, or L1)


Find hospitals by name


Find by City


Find by County


                    

Location of NHS Clinics

Find clinics using just a partial postcode (e.g. CH64, or L1)


Find clinics by name


Find by City


Find by County


                    

Social Care service locations

Find locations using just a partial postcode (e.g. CH64, or L1)


Find locations by name


Find by City


Find by County


                    

Information about pharmacies

Find pharmacies using just a partial postcode (e.g. CH64, or L1)


Find pharmacies by name


Find by City


Find by County


                    

GP Surgeries

Find surgeries using just a partial postcode (e.g. CH64, or L1)


Find surgeries by name


Find by City


Find by County


                    

Location of General Dental Practices

Find dental practices using just a partial postcode (e.g. CH64, or L1)


Find dental practices by name


                    

The tabs below show the schema for each accessible table within this theme

Clinics

Table Name: clinics
Field Type Description
website string
city string
fax string
organisation_name string
organisation_code string
organisation_type string
phone string
partial_postcode string
address1 string
address2 string
address3 string
longitude string
county string
sub_type string
is_pims_managed string
organisation_status string
latitude string
organisation_id string
email string
postcode string

Dental Practices

Table Name: dental_practices
Field Type Description
organisation_code string
postcode string
organisation_sub_type_code string
address_line_1 string
address_line_2 string
address_line_3 string
address_line_4 string
address_line_5 string
open_date string
status_code string
close_date string
parent_organisation_code string
amended_record_indicator string
left_parent_date string
higher_health_authority string
name string
national_grouping string
join_parent_date string
contact_telephone_number string
partial_postcode string

Gp Surgeries

Table Name: gp_surgeries
Field Type Description
city string
parent_name string
latitude string
organisation_id string
email string
website string
fax string
organisation_name string
organisation_code string
organisation_type string
sub_type string
address1 string
address2 string
address3 string
phone string
organisation_status string
is_e_p_s_enabled string
postcode string
longitude string
county string
parent_o_d_s_code string
is_pims_managed string
partial_postcode string

Hospitals

Table Name: hospitals
Field Type Description
city string
parent_name string
latitude string
organisation_id string
email string
website string
fax string
organisation_name string
organisation_code string
organisation_type string
sub_type string
address1 string
address2 string
address3 string
phone string
organisation_status string
postcode string
longitude string
sector string
county string
parent_o_d_s_code string
is_pims_managed string
partial_postcode string

Pharmacies

Table Name: pharmacies
Field Type Description

Social Care Locations

Table Name: social_care_locations
Field Type Description
city string
parent_name string
latitude string
organisation_id string
email string
website string
fax string
organisation_name string
organisation_code string
organisation_type string
sub_type string
address1 string
address2 string
address3 string
local_authority string
phone string
organisation_status string
postcode string
longitude string
county string
parent_o_d_s_code string
is_pims_managed string
partial_postcode string


Within this editor you may perform SQL queries against the health database - queries are currently limited to 5 seconds execution time.

SELECT * FROM clinics limit 10;