Pharmacy Openings and Closures - June 2023

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 July 12, 2023
Metadata last updated July 12, 2023
Created July 12, 2023
Format CSV
License Open Government Licence 3.0 (United Kingdom)

Data Dictionary

Column Title Type Description
DATE Date of count as yyyymmdd number

The reporting date when the snapshot of active pharmacies have been counted. This is the last calendar day of the month, example 20210131

TOTAL_PHARMACIES Total count of pharmacies integer

The total count of all pharmacies open on that date, including distance sellers, excluding appliance contractors.

TOTAL_PHARMACIES_EXCLUDING_DISTANCE_SELLERS Total count of pharmacies excluding distance seller pharmacies integer

The total count of all pharmacies open on that date, excluding distance seller pharmacies and appliance contractors. This number should be equal to the number of small, medium and large pharmacies.

TOTAL_DISTANCE_SELLING_PHARMACIES Total count of distance selling pharmacies integer

The total count of distance seller pharmacies. This number should be equal to total pharmacies minus total pharmacies excluding distance sellers

TOTAL_HUNDRED_HOUR_PHARMACIES Total count of 100-hour pharmacies integer

The total count of pharmacies that are open on a 100-hour contract. These may be Small, Medium or Large pharmacies.

SMALL Total count of small (1 - 5) pharmacy groups integer

The total count of pharmacies open on that date that are either independent (single pharmacy site) or in a chain of fewer than 6 sites. This excludes distance seller pharmacies.

MEDIUM Total count of medium (6 - 99) pharmacy groups integer

The total count of pharmacies open on that date that are part of a chain made up of between 6 and 99 sites. This excludes distance seller pharmacies.

LARGE Total count of large (100+) pharmacy groups integer

The total count of pharmacies open on that date that are part of a chain made up of 100 or more sites. This excludes distance seller pharmacies.

TOTAL_PHARMACIES_EXCLUDING_DISTANCE_SELLERS_OPENED Total pharmacies opened in the month excluding distance sellers integer

The total number of pharmacies not including distance sellers that have opened since the previous reporting date. This includes pharmacies open on the day after the previous reporting date up to those opened on the current reporting date. Where a pharmacy has been taken over, this will appear in both the openings and closures table as the pharmacy is under new management, with a net change of 0.

TOTAL_PHARMACIES_EXCLUDING_DISTANCE_SELLERS_CLOSED Total pharmacies closed in the month excluding distance sellers integer

The total number of pharmacies not including distance sellers that have closed since the previous reporting date. This includes pharmacies closed on the day after the previous reporting date up to those closed on the current reporting date. Where a pharmacy has been taken over, this will appear in both the openings and closures table as the pharmacy is under new management, with a net change of 0.

PHARMACIES_EXCLUDING_DISTANCE_SELLERS_NET_CHANGE Total pharmacies closed in the month excluding distance sellers integer

The difference between Total pharmacies opened and Total pharmacies closed. If this number is positive, this means that there are more pharmacies open on the reporting date than the previous reporting date. If this is negative, this means there are fewer pharmacies open than on the previous reporting date. Where a pharmacy has been taken over, this will appear in both the openings and closures table as the pharmacy is under new management, with a net change of 0.

SMALL_PHARMACIES_OPENED Total small pharmacies opened in the month integer

The total number of small pharmacies that have opened since the previous reporting date. This includes pharmacies open on the day after the previous reporting date up to those opened on the current reporting date. Where a pharmacy has been taken over, this will appear in both the openings and closures table as the pharmacy is under new management, with a net change of 0.

SMALL_PHARMACIES_CLOSED Total small pharmacies closed in the month integer

The total number of small pharmacies that have closed since the previous reporting date. This includes pharmacies closed on the day after the previous reporting date up to those closed on the current reporting date. Where a pharmacy has been taken over, this will appear in both the openings and closures table as the pharmacy is under new management, with a net change of 0.

SMALL_NET_CHANGE Total net closures of small pharmacies in the month integer

The difference between Small pharmacies opened and Small pharmacies closed. If this number is positive, this means that there are more pharmacies open on the reporting date than the previous reporting date. If this is negative, this means there are fewer pharmacies open than on the previous reporting date. Where a pharmacy has been taken over, this will appear in both the openings and closures table as the pharmacy is under new management, with a net change of 0. If a pharmacy group of 5 pharmacies opens another site, this opening will be classed as a Medium pharmacy and the current 5 pharmacies will be removed from the Small count and into the Medium count. Likewise, if a group of 6 pharmacies closes one site, they will be removed from the Medium pharmacies and the 5 remaining sites will be added to the Small pharmacies. Therefore the total small pharmacies last month plus the small net closures may not equal the total small pharmacies this month.

MEDIUM_PHARMACIES_OPENED Total medium pharmacies opened in the month integer

The total number of medium pharmacies that have opened since the previous reporting date. This includes pharmacies open on the day after the previous reporting date up to those opened on the current reporting date. Where a pharmacy has been taken over, this will appear in both the openings and closures table as the pharmacy is under new management, with a net change of 0.

MEDIUM_PHARMACIES_CLOSED Total medium pharmacies closed in the month integer

The total number of medium pharmacies that have closed since the previous reporting date. This includes pharmacies closed on the day after the previous reporting date up to those closed on the current reporting date. Where a pharmacy has been taken over, this will appear in both the openings and closures table as the pharmacy is under new management, with a net change of 0.

MEDIUM_NET_CHANGE Total net closures of medium pharmacies in the month integer

The difference between Medium pharmacies opened and Medium pharmacies closed. If this number is positive, this means that there are more pharmacies open on the reporting date than the previous reporting date. If this is negative, this means there are fewer pharmacies open than on the previous reporting date. Where a pharmacy has been taken over, this will appear in both the openings and closures table as the pharmacy is under new management, with a net change of 0. If a pharmacy group of 99 pharmacies opens another site, this opening will be classed as a Large pharmacy and the current 99 pharmacies will be removed from the Medium count and into the Large count. Likewise, if a group of 100 pharmacies closes one site, they will be removed from the Large pharmacies and the 99 remaining sites will be added to the Medium pharmacies. This may also happen between Medium and Small, where changes result in chains becoming larger or smaller than the cutoff between these categories. Therefore the total medium pharmacies last month plus the medium net closures may not equal the total medium pharmacies this month.

LARGE_PHARMACIES_OPENED Total large pharmacies opened in the month integer

The total number of large pharmacies that have opened since the previous reporting date. This includes pharmacies open on the day after the previous reporting date up to those opened on the current reporting date. Where a pharmacy has been taken over, this will appear in both the openings and closures table as the pharmacy is under new management, with a net change of 0.

LARGE_PHARMACIES_CLOSED Total large pharmacies closed in the month integer

The total number of large pharmacies that have closed since the previous reporting date. This includes pharmacies closed on the day after the previous reporting date up to those closed on the current reporting date. Where a pharmacy has been taken over, this will appear in both the openings and closures table as the pharmacy is under new management, with a net change of 0.

LARGE_NET_CHANGE Total net closures of large pharmacies in the month integer

The difference between Large pharmacies opened and Large pharmacies closed. If this number is positive, this means that there are more pharmacies open on the reporting date than the previous reporting date. If this is negative, this means there are fewer pharmacies open than on the previous reporting date. Where a pharmacy has been taken over, this will appear in both the openings and closures table as the pharmacy is under new management, with a net change of 0. If a pharmacy group of 99 pharmacies opens another site, this opening will be classed as a Large pharmacy and the current 99 pharmacies will be removed from the Medium count and into the Large count. Likewise, if a group of 100 pharmacies closes one site, they will be removed from the Large pharmacies and the 99 remaining sites will be added to the Medium pharmacies. Therefore the total medium pharmacies last month plus the medium net closures may not equal the total medium pharmacies this month.

DISTANCE_SELLERS_OPENED Total distance sellers opened integer

The total number of distance sellers that have opened since the previous reporting date. This includes pharmacies open on the day after the previous reporting date up to those opened on the current reporting date. Where a pharmacy has been taken over, this will appear in both the openings and closures table as the pharmacy is under new management, with a net change of 0.

DISTANCE_SELLERS_CLOSED Total distance sellers closed integer

The total number of distance sellers that have closed since the previous reporting date. This includes pharmacies closed on the day after the previous reporting date up to those closed on the current reporting date. Where a pharmacy has been taken over, this will appear in both the openings and closures table as the pharmacy is under new management, with a net change of 0.

DISTANCE_SELLERS_NET_CHANGE Total net closures of distance sellers integer

The difference between Distance sellers opened and DIstance sellers pharmacies closed. If this number is positive, this means that there are more pharmacies open on the reporting date than the previous reporting date. If this is negative, this means there are fewer pharmacies open than on the previous reporting date. Where a pharmacy has been taken over, this will appear in both the openings and closures table as the pharmacy is under new management, with a net change of 0.