Consolidated Pharmaceutical List - 2023-24 Quarter 3

Report an issue

This resource view is not available at the moment. Click here for more information.

Download resource

Additional Info

Field Value
Data last updated February 22, 2024
Metadata last updated February 22, 2024
Created February 22, 2024
Format CSV
License Open Government Licence 3.0 (United Kingdom)

Data Dictionary

Column Title Type Description
PHARMACY_ODS_CODE_F_CODE Organisation Data Service code for pharmacy, appliance, or local pharmaceutical services contractor string

The Organisation Data Service (ODS) code of the premises at which pharmaceutical services may be provided by those included in a pharmaceutical list.

HEALTH_AND_WELLBEING_BOARD Health and wellbeing board name string

The name of a health and wellbeing board as introduced in the Health and Social Care Act 2012.

PHARMACY_TRADING_NAME Trading name of contractor string

The name under which a pharmacy contractor, appliance contractor, or local pharmaceutical services contractor trades.

ORGANISATION_NAME Name of person or persons included in a pharmaceutical list string

The name of the sole trader, partnership, or body corporate which is included in a pharmaceutical list.

ADDRESS_FIELD1 First line of address string

The first line of the address of a premises.

ADDRESS_FIELD2 Second line of address string

The second line of the address of a premises.

ADDRESS_FIELD3 Third line of address string

The third line of the address of a premises.

ADDRESS_FIELD4 Fourth line of address string

The fourth line of the address of a premises.

POST_CODE Post code string

The post code of the address of a premises.

PHARMACY_OPENING_HOURS_MONDAY The times, represented as a 24 hour clock, during which the contractor is listed to be open on Mondays, excluding bank or public holidays string

The time ranges on Mondays - excluding bank or public holidays - where the contractor is listed to be open. Where more than one time range is listed, this represents a break in the opening times which may - for instance - be for a meal break. These time ranges includes both Core and Supplementary hours.

MON_TOTAL Total sum of opening hours on Mondays excluding bank or public holidays integer

The total number of hours on Mondays - excluding bank or public holidays - during which this organisation is listed to be open. This includes both Core and Supplementary hours.

PHARMACY_OPENING_HOURS_TUESDAY The times, represented as a 24 hour clock, during which the contractor is listed to be open on Tuesdays, excluding bank or public holidays string

The time ranges on Tuesdays - excluding bank or public holidays - where the contractor is listed to be open. Where more than one time range is listed, this represents a break in the opening times which may - for instance - be for a meal break. These time ranges includes both Core and Supplementary hours.

TUES_TOTAL Total sum of opening hours on Tuesdays excluding bank or public holidays integer

The total number of hours on Tuesdays - excluding bank or public holidays - during which this organisation is listed to be open. This includes both Core and Supplementary hours.

PHARMACY_OPENING_HOURS_WEDNESDAY The times, represented as a 24 hour clock, during which the contractor is listed to be open on Wednesdays, excluding bank or public holidays string

The time ranges on Wednesdays - excluding bank or public holidays - where the contractor is listed to be open. Where more than one time range is listed, this represents a break in the opening times which may - for instance - be for a meal break. These time ranges includes both Core and Supplementary hours.

WED_TOTAL Total sum of opening hours on Wednesdays excluding bank or public holidays integer

The total number of hours on Wednesdays - excluding bank or public holidays - during which this organisation is listed to be open. This includes both Core and Supplementary hours.

PHARMACY_OPENING_HOURS_THURSDAY The times, represented as a 24 hour clock, during which the contractor is listed to be open on Thursdays, excluding bank or public holidays string

The time ranges on Thursdays - excluding bank or public holidays - where the contractor is listed to be open. Where more than one time range is listed, this represents a break in the opening times which may - for instance - be for a meal break. These time ranges includes both Core and Supplementary hours.

THURS_TOTAL Total sum of opening hours on Thursdays excluding bank or public holidays integer

The total number of hours on Thursdays - excluding bank or public holidays - during which this organisation is listed to be open. This includes both Core and Supplementary hours.

PHARMACY_OPENING_HOURS_FRIDAY The times, represented as a 24 hour clock, during which the contractor is listed to be open on Fridays, excluding bank or public holidays string

The time ranges on Fridays - excluding bank or public holidays - where the contractor is listed to be open. Where more than one time range is listed, this represents a break in the opening times which may - for instance - be for a meal break. These time ranges includes both Core and Supplementary hours.

FRI_TOTAL Total sum of opening hours on Fridays excluding bank or public holidays integer

The total number of hours on Fridays - excluding bank or public holidays - during which this organisation is listed to be open. This includes both Core and Supplementary hours.

PHARMACY_OPENING_HOURS_SATURDAY The times, represented as a 24 hour clock, during which the contractor is listed to be open on Saturdays, excluding bank or public holidays string

The time ranges on Saturdays - excluding bank or public holidays - where the contractor is listed to be open. Where more than one time range is listed, this represents a break in the opening times which may - for instance - be for a meal break. These time ranges includes both Core and Supplementary hours.

SAT_TOTAL Total sum of opening hours on Saturdays excluding bank or public holidays integer

The total number of hours on Saturdays - excluding bank or public holidays - during which this organisation is listed to be open. This includes both Core and Supplementary hours.

PHARMACY_OPENING_HOURS_SUNDAY The times, represented as a 24 hour clock, during which the contractor is listed to be open on Sundays, excluding bank or public holidays string

The time ranges on Sundays - excluding bank or public holidays - where the contractor is listed to be open. Where more than one time range is listed, this represents a break in the opening times which may - for instance - be for a meal break. These time ranges includes both Core and Supplementary hours.

SUN_TOTAL Total sum of opening hours on Sundays excluding bank or public holidays integer

The total number of hours on Sundays - excluding bank or public holidays - during which this organisation is listed to be open. This includes both Core and Supplementary hours.

WEEKLY_TOTAL Total sum of opening hours in a full calendar week excluding bank or public holidays integer

The total number of hours during a full calendar week - excluding bank or public holidays - during which this organisation is listed to be open. This includes both Core and Supplementary hours.

CONTRACT_TYPE Type of contractor string

The type of contractor defined in Regulation. Either: -"Community" means a person included in a pharmaceutical list of persons who undertake to provide pharmaceutical services in particular by way of the provision of drugs -"DAC" means a Dispensing Appliance Contractor known as an “NHS appliance contractor” in Regulation which means a person included in a pharmaceutical list of persons who undertake to provide pharmaceutical services only by way of the provision of appliances -"LPS" means an “LPS contractor” which means a person who is a local pharmaceutical services (LPS) chemist by virtue of being a party to an LPS scheme which is not an LPS pilot scheme