Request

‘I would like to request annual Pharmacy Dispensing at presentation level between Jan 2023 - December 2023. Ideally this would include Pharmacy ODS Code, BNF Code, BNF Name, Items Thanks’

Response

Under Section 21 of the Act, we are not required to provide information in response to a request if it is already reasonably accessible to you. The information you requested is available from web links:

January 2023 – March 2023

https://opendata.nhsbsa.net/dataset/foi-01204

April 2023

https://opendata.nhsbsa.net/dataset/foi-01240

May 2023

https://opendata.nhsbsa.net/dataset/foi-01310

June 2023

https://opendata.nhsbsa.net/dataset/foi-01378

July 2023

FOI-01424 - Datasets - Open Data Portal BETA (nhsbsa.net)

August 2023

https://opendata.nhsbsa.net/dataset/foi-01502

September 2023

https://opendata.nhsbsa.net/dataset/foi-01550

October 2023

https://opendata.nhsbsa.net/dataset/foi-01668

November 2023

https://opendata.nhsbsa.net/dataset/foi-01669

December 2023

https://opendata.nhsbsa.net/dataset/foi-01756

Some data sets are over 1 million rows of data and it may be that you will need to use add-ons already existing on Microsoft Excel to enable you to view the data set in its entirety. Microsoft PowerPivot add-on for Excel can be used to handle larger data sets.

The Microsoft PowerPivot add-on for Excel is available using the link in the 'Related Links' section below:

https://www.microsoft.com/en-us/download/details.aspx?id=43348

Once PowerPivot has been installed, to load the large files, please follow the instructions below: 1. Start Excel as normal
2. Click on the PowerPivot tab
3. Click on the PowerPivot Window icon (top left)
4. In the PowerPivot Window, click on the "From Other Sources" icon
5. In the Table Import Wizard e.g. scroll to the bottom and select Text File
6. Browse to the file you want to open and choose the file extension you require e.g. CSV