Health
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 | |
| name [Indexed] | string | |
| organisation_code | string | |
| organisation_type | string | |
| phone | string | |
| partial_postcode [Indexed] | 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 | |
| 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 [Indexed] | string | |
| national_grouping | string | |
| join_parent_date | string | |
| contact_telephone_number | string | |
| partial_postcode [Indexed] | string |
Gp Surgeries
Table Name: gp_surgeries
| Field | Type | Description |
|---|---|---|
| city | string | |
| parent_name | string | |
| latitude | string | |
| organisation_id | string | |
| string | ||
| website | string | |
| fax | string | |
| name [Indexed] | 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 [Indexed] | string |
Hospitals
Table Name: hospitals
| Field | Type | Description |
|---|---|---|
| city | string | |
| parent_name | string | |
| latitude | string | |
| organisation_id | string | |
| string | ||
| website | string | |
| fax | string | |
| name [Indexed] | 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 [Indexed] | string |
Pharmacies
Table Name: pharmacies
| Field | Type | Description |
|---|---|---|
| city | string | |
| parent_name | string | |
| latitude | string | |
| organisation_id | string | |
| string | ||
| website | string | |
| fax | string | |
| name [Indexed] | 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 [Indexed] | 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;
Social Care Locations
Table Name: social_care_locations