Field | Value |
---|---|
Data last updated | November 4, 2024 |
Metadata last updated | November 4, 2024 |
Created | November 4, 2024 |
Format | CSV |
License | Open Government Licence 3.0 (United Kingdom) |
Column | Title | Type | Description |
---|---|---|---|
DATE | Date of count as yyyymmdd | date | 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. |