Activity Stream - Pharmacy and appliance contractor dispensing data - Datasets

Data Services Support added a new comment
{'id': '23cc123e-910a-4be2-9d4f-6970ed9d326e', 'timestamp': '2025-08-05T15:20:24.700109', 'user_id': '73783dc8-f5e5-461f-b56e-94ecedd6046c', 'object_id': '25230765-9494-4fde-b3fc-af9c00037dfb', 'activity_type': 'changed issue', 'data': {'__extras': {'author_id': '73783dc8-f5e5-461f-b56e-94ecedd6046c'}, 'comment': '2025-08-05 The April 2025 ODP Pharmacy and Appliance Contractor Dispensing Data has been reissued due to a HWB assignment error affecting appliance contractors.', 'user_id': '73783dc8-f5e5-461f-b56e-94ecedd6046c', 'issue_id': 11569, 'issue_number': 1, 'comment_id': 110, 'package': {'author': 'NHSBSA Data Services Support Team', 'author_email': 'DataServicesSupport@nhsbsa.nhs.uk', 'creator_user_id': '73783dc8-f5e5-461f-b56e-94ecedd6046c', 'id': '25230765-9494-4fde-b3fc-af9c00037dfb', 'isopen': True, 'license_id': 'OGL-UK-3.0', 'license_title': 'Open Government Licence 3.0 (United Kingdom)', 'license_url': 'https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/', 'maintainer': None, 'maintainer_email': None, 'metadata_created': '2025-06-02T16:44:27.673551', 'metadata_modified': '2025-08-05T14:51:06.367900', 'name': 'pharmacy-and-appliance-contractor-dispensing-data', 'notes': '<div class="nhsuk-warning-callout">\r\n <h3 class="nhsuk-warning-callout__label"> <span role="text">\r\n <span class="nhsuk-u-visually-hidden">Important: </span>\r\n Update on Dispensing Data Format – Temporary Support Period\r\n </span> </h3>\r\n <p>To support users with the new formatting standards, companion files for the April, May, and June 2025 Pharmacy and Appliance Contractor Dispensing Data in the previous format will be made available on the <a href="https://www.nhsbsa.nhs.uk/prescription-data/dispensing-data/dispensing-contractors-data">NHSBSA website</a>.\r\n\r\n<p><strong>Note:</strong> The April 2025 ODP Pharmacy and Appliance Contractor Dispensing Data has been reissued due to a HWB assignment error affecting appliance contractors.\r\n \r\n<p><a href="https://opendata.nhsbsa.net/news/update-on-dispensing-data-format-temporary-support-period">Read the full update on our news page</a> for more details, including API guidance and ongoing support.</p>\r\n</div>\r\n\r\n<h2>Dataset Description</h2>\r\n<p>The pharmacy and appliance contractors report is a monthly dataset that details the volume of activity that has occurred from English dispensing. The information relates to prescriptions and services that are outlined in the English & Welsh drug tariff. For example, numbers of Advanced Services such as the seven conditions within the Pharmacy First Clinical Pathways.</p>\r\n<p>The data provided is based on England community dispensing only and may include items prescribed in Wales, Scotland, Northern Ireland, and the Isle of Man which have been dispensed in England.</p>\r\n<p>The dataset is openly available via the NHSBSA Open Data Portal, promoting transparency and enabling widespread analysis.</p>\r\n<p>The Information Commissioners Office (ICO) decided it\'s in the public interest to release details of dispensing information for identified dispensers.</p>\r\n<p><a href="https://www.nhsbsa.nhs.uk/sites/default/files/2017-03/Notice_of_Intention_to_PublishV2.doc">View our approach to releasing dispensing information (Word: 301KB)</a></p>\r\n<p><strong>Key Features</strong></p>\r\n<ul style="margin-left: 2em;">\r\n <li>\r\n <strong>Organisational-Level Information:</strong> Each record is linked to a specific dispensing account, Integrated Care Board, Health and Wellbeing Board enabling analysis at various levels.\r\n </li>\r\n <li>\r\n <strong>Data Granularity:</strong> The dataset captures the numbers associated with each submission claim by an individual dispenser (and their address) that has been passed for payment. Enabling analysis of trends. \r\n </li>\r\n <li>\r\n <strong>Reference Point:</strong> The dataset allows for a quick view of dispensing activity within the community in England.\r\n </li>\r\n</ul>\r\n\r\n<details class="nhsuk-details">\r\n <summary class="nhsuk-details__summary">\r\n <span class="nhsuk-details__summary-text nhsuk-u-font-size-24">Use Cases and Benefits</span>\r\n </summary>\r\n <div class="nhsuk-details__text">\r\n <p>The dispensing data supports a range of users, including healthcare professionals, policymakers, and researchers. <br>\r\n<br>Key applications include:</p>\r\n <ul>\r\n <li><strong>Integration with Other Datasets:</strong> Can be linked with other datasets to provide a more comprehensive view of patient care and prescribing impacts.</li>\r\n \r\n </ul>\r\n </div>\r\n</details>\r\n<h2>Overview of Service</h2>\r\n<p>Information about our NHSBSA Prescriptions Data service can be found here - <a href="https://www.nhsbsa.nhs.uk/prescription-data">Prescription data | NHSBSA</a></p>\r\n<h2>Dataset Details</h2>\r\n\r\n<p><details class="nhsuk-details"> <summary class="nhsuk-details__summary"> <span class="nhsuk-details__summary-text nhsuk-u-font-size-24">Publication Frequency</span> </summary>\r\n<div class="nhsuk-details__text">\r\n<p>Data is uploaded on a monthly basis and is published retrospectively with a three-month delay.\r\n<p>For example, May data is published in August.</p>\r\n</div>\r\n</details></p>\r\n\r\n<p><details class="nhsuk-details"> <summary class="nhsuk-details__summary"> <span class="nhsuk-details__summary-text nhsuk-u-font-size-24">Data Source</span> </summary>\r\n<div class="nhsuk-details__text">\r\n<p>NHS Business Services Authority (NHSBSA) Data Warehouse.</p>\r\n</div>\r\n</details></p>\r\n<details class="nhsuk-details">\r\n <summary class="nhsuk-details__summary">\r\n <span class="nhsuk-details__summary-text nhsuk-u-font-size-24">Data Collection</span>\r\n </summary>\r\n <div class="nhsuk-details__text">\r\n <p>The pharmacy and appliance contractor’s report is compiled from multiple NHSBSA data sources to ensure accuracy and consistency in prescription records.</p>\r\n <ul>\r\n <li>\r\n <strong>Organisational Data:</strong> Derived from the NHSBSA organisational database, providing up-to-date information on NHS GP practices and primary care organisations.\r\n </li>\r\n <li>\r\n <strong>Service Data:</strong> Includes consultations that took place under an advanced service heading and all prescription items prescribed in the community in England and submitted to NHSBSA for reimbursement and remuneration by pharmacy and appliance dispensing contractors monthly.\r\n </li>\r\n </ul>\r\n </div>\r\n</details>\r\n\r\n<details class="nhsuk-details">\r\n <summary class="nhsuk-details__summary">\r\n <span class="nhsuk-details__summary-text nhsuk-u-font-size-24">Time Periods</span>\r\n </summary>\r\n <div class="nhsuk-details__text">\r\n<p>Data from January 2025 onwards is available now on the NHSBSA Open Data Portal.</p>\r\n <p>We are currently working to migrate earlier data from April 2014 onwards to the Open Data Portal. This will made available incrementally and we expect the full set to be available over the next few months.</p>\r\n<p>In the meantime, data covering January 2020 to March 2025 can be accessed via the Pharmacy and appliance contractor dispensing data section on the NHSBSA website:</p>\r\n<p><a href="https://www.nhsbsa.nhs.uk/prescription-data/dispensing-data/dispensing-contractors-data">https://www.nhsbsa.nhs.uk/prescription-data/dispensing-data/dispensing-contractors-data</a></p>\r\n </div>\r\n</details>\r\n\r\n\r\n<p><details class="nhsuk-details"> <summary class="nhsuk-details__summary"> <span class="nhsuk-details__summary-text nhsuk-u-font-size-24">Geography</span> </summary>\r\n<div class="nhsuk-details__text">\r\n<p>England.</p>\r\n</div>\r\n</details></p>\r\n\r\n<p><details class="nhsuk-details"> <summary class="nhsuk-details__summary"> <span class="nhsuk-details__summary-text nhsuk-u-font-size-24">Statistical Classification</span> </summary>\r\n<div class="nhsuk-details__text">\r\n<p>Management Information - This is not an official statistic.</p>\r\n</div>\r\n</details></p>\r\n<h2>Caveats</h2>\r\n\r\n<div class="nhsuk-inset-text">\r\n <span class="nhsuk-u-visually-hidden">Information: </span>\r\n <h3 class="nhsuk-u-font-size-32">Exclusion of contractors/service information appearing in the dataset</h3>\r\n <p>This will exclude services that were provided but not declared/paid.\r\n\r\n<p>The data that appears is for the submission month and not necessarily the month in which the activity took place.</p>\r\n\r\n<p>There may be services listed in the drug tariff that are not included.\r\n\r\n<p>Where a contractor has no submissions for a specific field this field will not appear for that contractor.\r\n\r\n<p>This data does not include dispensing doctors or personal administration accounts. Data for these contractors can be found at: <a href="https://opendata.nhsbsa.net/dataset/dispensing-doctor-and-personally-administered-padm-dispensing-data">https://opendata.nhsbsa.net/dataset/dispensing-doctor-and-personally-administered-padm-dispensing-data</a>.\r\n</p>\r\n</div>\r\n\r\n<div class="nhsuk-inset-text">\r\n <span class="nhsuk-u-visually-hidden">Information: </span>\r\n <h3 class="nhsuk-u-font-size-32">Exclusion of geographical locations</h3>\r\n <p>The data excludes items prescribed in England but dispensed in Wales, Scotland, Northern Ireland, and Isle of Man.</p>\r\n\r\n<p>The data excludes items dispensed in prisons, hospital and private prescriptions but does include dental, prison and hospital prescriptions which are dispensed in the community.</p>\r\n\r\n<p>If a prescription was issued but not presented for dispensing or was not submitted to NHSBSA Prescription Services by the dispenser, then it is not included in the data provided.</p>\r\n</div>\r\n\r\n<div class="nhsuk-inset-text">\r\n <span class="nhsuk-u-visually-hidden">Information: </span>\r\n <h3 class="nhsuk-u-font-size-32">Based on submission</h3>\r\n <p>All data is based on the month of submission. No retrospective adjustments are made to the data.\r\n\r\n<p>The basis of the location where the contractor resides is determined on the payment month.\r\n</p>\r\n</div>\r\n\r\n<div class="nhsuk-inset-text">\r\n <span class="nhsuk-u-visually-hidden">Information: </span>\r\n <h3 class="nhsuk-u-font-size-32">Data changes</h3>\r\n <p>The fields may remain consistent over time, but new ones might be added, and the definitions within those fields may change.\r\n\r\n<p>The data identified as abated covers services declared, and items prescribed on prescriptions from a previous month.\r\n</p>\r\n</div>\r\n\r\n<div class="nhsuk-inset-text">\r\n <span class="nhsuk-u-visually-hidden">Information: </span>\r\n <h3 class="nhsuk-u-font-size-32">Type of Data</h3>\r\n <p>This data is the ‘number of’ and not financial values.</p>\r\n</div>\r\n\r\n<h2>Enquiries</h2>\r\n\r\n<p><details class="nhsuk-details"> <summary class="nhsuk-details__summary"> <span class="nhsuk-details__summary-text nhsuk-u-font-size-24">Who can I contact if I have queries relating to the data?</span> </summary>\r\n<div class="nhsuk-details__text">\r\n<p>If you have any queries regarding the data provided, or if you plan on publishing the data, please contact <a href="mailto:DataServicesSupport@nhsbsa.nhs.uk">DataServicesSupport@nhsbsa.nhs.uk</a> ensuring you quote the name of the dataset for reference. This is important to ensure that the figures are not misunderstood or misrepresented.</p>\r\n</div>\r\n</details></p>\r\n<h2>Citing and Reusing This Data</h2>\r\n\r\n<p><details class="nhsuk-details"> <summary class="nhsuk-details__summary"> <span class="nhsuk-details__summary-text nhsuk-u-font-size-24">Important information regarding reusing the data and copyright</span> </summary>\r\n<div class="nhsuk-details__text">\r\n<p>If you plan on producing a press or broadcast story based upon the data, please contact <a href="mailto:communicationsteam@nhsbsa.nhs.uk">communicationsteam@nhsbsa.nhs.uk</a>. This is important to ensure that the figures are not misunderstood or misrepresented.</p>\r\n<p>The information supplied to you continues to be protected by the Copyright, Designs and Patents Act 1988 and/or other applicable law. You may use the data freely, provided that you attribute the source.</p>\r\n</div>\r\n</details></p>\r\n\r\n<p><details class="nhsuk-details"> <summary class="nhsuk-details__summary"> <span class="nhsuk-details__summary-text nhsuk-u-font-size-24">Citation </span> </summary>\r\n<div class="nhsuk-details__text">\r\n<p>NHS Business Services Authority. "Pharmacy and appliance contractor dispensing data". Accessed **[Date Accessed]**. URL: <a href="https://opendata.nhsbsa.net/dataset/pharmacy-and-appliance-contractor-dispensing-data">https://opendata.nhsbsa.net/dataset/pharmacy-and-appliance-contractor-dispensing-data</a></p>\r\n</div>\r\n</details></p>', 'num_resources': 4, 'num_tags': 0, 'organization': {'id': 'ab9f74b0-a7ac-41a8-a97b-e49f8cd02aff', 'name': 'community_prescribing_dispensing', 'title': 'Community Prescribing & Dispensing', 'type': 'organization', 'description': 'Datasets on the prescribing and dispensing of medicines in the community', 'image_url': 'https://storage.googleapis.com/dx-nhs-production/_assets/group/2020-11-29-111330.020756-prescribing-Icon.jpg', 'created': '2020-03-17T10:06:07.650987', 'is_organization': True, 'approval_status': 'approved', 'state': 'active'}, 'owner_org': 'ab9f74b0-a7ac-41a8-a97b-e49f8cd02aff', 'private': False, 'state': 'active', 'title': 'Pharmacy and appliance contractor dispensing data', 'type': 'dataset', 'upload_to_bigquery': 'true', 'url': 'NHS Business Services Authority', 'version': '1.0', 'resources': [{'bq_table_name': 'DISPENSING_DATA_202501', 'cache_last_updated': None, 'cache_url': None, 'created': '2025-07-28T15:21:28.489243', 'datastore_active': False, 'dialect': {'delimiter': ',', 'quoteChar': '"'}, 'encoding': 'utf-8', 'format': 'CSV', 'hash': 'df62924b6d8579e77ca91790f923ae28a3439a2785a7375ba7e9ea6ba7df8526', 'id': 'c83e73d1-e8ca-455d-a74b-f15682e05fd5', 'last_modified': None, 'lfs_prefix': 'community_prescribing_dispensing/pharmacy-and-appliance-contractor-dispensing-data', 'metadata_modified': '2025-07-28T15:25:29.053728', 'mimetype': 'text/csv', 'mimetype_inner': None, 'name': 'DISPENSING_DATA_202501', 'package_id': '25230765-9494-4fde-b3fc-af9c00037dfb', 'position': 0, 'resource_type': None, 'restricted': '{"level": "public"}', 'sample': {}, 'schema': {'fields': [{'name': 'YEAR_MONTH', 'type': 'yearmonth', 'format': 'default', 'title': 'Year and Month', 'description': 'The year and month for which the claim for dispensed items has been submitted to NHSBSA in the format YYYY-MM.'}, {'name': 'ICB_CODE', 'type': 'string', 'format': 'default', 'title': 'Integrated Care Board (ICB) Code', 'description': 'The unique code used to refer to an ICB.'}, {'name': 'ICB_NAME', 'type': 'string', 'format': 'default', 'title': 'Integrated Care Board (ICB) Name', 'description': 'The name given to a geographical statutory organisation by NHS England that is a smaller division of a Region.'}, {'name': 'HWB_CODE', 'type': 'string', 'format': 'default', 'title': 'HWB Code', 'description': 'The unique code used to refer to a Health and Wellbeing Board'}, {'name': 'HWB_NAME', 'type': 'string', 'format': 'default', 'title': 'HWB Name', 'description': 'The name given to the Health and Wellbeing Board as introduced in the Health and Social Care Act 2012 that the pharmacy resides under.'}, {'name': 'PHARMACY_ACCOUNT_TYPE', 'type': 'string', 'format': 'default', 'title': 'Type of pharmacy', 'description': 'Type of pharmacy contractor, which can be either pharmacy or appliance'}, {'name': 'CONTRACTOR_CODE', 'type': 'string', 'format': 'default', 'title': 'The unique contractor code for pharmacy, appliance, or local pharmaceutical services contractor', 'description': 'The Organisation Data Service (ODS) code of the premises at which pharmaceutical services may be provided e.g. FW844 . It is also sometimes referred to as OCS code or F code.'}, {'name': 'CONTRACTOR_NAME', 'type': 'string', 'format': 'default', 'title': 'The name of the contractor', 'description': 'The name of the sole trader, partnership, or body corporate'}, {'name': 'ADDRESS_1', 'type': 'string', 'format': 'default', 'title': 'First line of address', 'description': 'The first line of the address of a premises.'}, {'name': 'ADDRESS_2', 'type': 'string', 'format': 'default', 'title': 'Second line of address', 'description': 'The second line of the address of a premises.'}, {'name': 'ADDRESS_3', 'type': 'string', 'format': 'default', 'title': 'Third line of address', 'description': 'The third line of the address of a premises.'}, {'name': 'ADDRESS_4', 'type': 'string', 'format': 'default', 'title': 'Fourth line of address', 'description': 'The fourth line of the address of a premises.'}, {'name': 'POSTCODE', 'type': 'string', 'format': 'default', 'title': 'Post code', 'description': 'The post code of the address of a premises.'}, {'name': 'CONTENT_GROUP', 'type': 'string', 'format': 'default', 'title': 'Content group', 'description': 'Represents the type of service offering associated with the pharmacy account type. For further information on the filters within the data dictionary column of Content Group, please go to the <a href="https://www.nhsbsa.nhs.uk/pharmacies-gp-practices-and-appliance-contractors/drug-tariff">Drug Tariff | NHSBSA</a>.'}, {'name': 'CONTENT', 'type': 'string', 'format': 'default', 'title': 'Content', 'description': 'Details the specific products included within each service offering for the pharmacy account type. For further information on the filters within the data dictionary column of Content, please go to the <a href="https://www.nhsbsa.nhs.uk/pharmacies-gp-practices-and-appliance-contractors/drug-tariff">Drug Tariff | NHSBSA</a>.'}, {'name': 'VALUE', 'type': 'integer', 'format': 'default', 'title': 'Value', 'description': 'Indicates the number of products dispensed for each content item by the pharmacy account type.'}], 'missingValues': ['']}, 'size': 37711632, 'state': 'active', 'title': 'Pharmacy and Appliance dispensing data January 2025', 'url': 'https://opendata.nhsbsa.net/dataset/25230765-9494-4fde-b3fc-af9c00037dfb/resource/c83e73d1-e8ca-455d-a74b-f15682e05fd5/download/dispensing_data_202501.csv', 'url_type': 'upload'}, {'bq_table_name': 'DISPENSING_DATA_202502', 'cache_last_updated': None, 'cache_url': None, 'created': '2025-07-28T10:10:52.772442', 'datastore_active': False, 'dialect': {'delimiter': ',', 'quoteChar': '"'}, 'encoding': 'utf-8', 'format': 'CSV', 'hash': '2ad636ed27b1395c6c0d755f9aa078f7d584740fea04ef1dbebc4cb48615fedb', 'id': 'cdb6fbc0-c568-4b00-a106-2b6cf27d0bbd', 'last_modified': None, 'lfs_prefix': 'community_prescribing_dispensing/pharmacy-and-appliance-contractor-dispensing-data', 'metadata_modified': '2025-07-28T15:27:07.870066', 'mimetype': 'text/csv', 'mimetype_inner': None, 'name': 'DISPENSING_DATA_202502', 'package_id': '25230765-9494-4fde-b3fc-af9c00037dfb', 'position': 1, 'resource_type': None, 'restricted': '{"level": "public"}', 'sample': {}, 'schema': {'fields': [{'name': 'YEAR_MONTH', 'type': 'yearmonth', 'format': 'default', 'title': 'Year and Month', 'description': 'The year and month for which the claim for dispensed items has been submitted to NHSBSA in the format YYYY-MM.'}, {'name': 'ICB_CODE', 'type': 'string', 'format': 'default', 'title': 'Integrated Care Board (ICB) Code', 'description': 'The unique code used to refer to an ICB.'}, {'name': 'ICB_NAME', 'type': 'string', 'format': 'default', 'title': 'Integrated Care Board (ICB) Name', 'description': 'The name given to a geographical statutory organisation by NHS England that is a smaller division of a Region.'}, {'name': 'HWB_CODE', 'type': 'string', 'format': 'default', 'title': 'HWB Code', 'description': 'The unique code used to refer to a Health and Wellbeing Board'}, {'name': 'HWB_NAME', 'type': 'string', 'format': 'default', 'title': 'HWB Name', 'description': 'The name given to the Health and Wellbeing Board as introduced in the Health and Social Care Act 2012 that the pharmacy resides under.'}, {'name': 'PHARMACY_ACCOUNT_TYPE', 'type': 'string', 'format': 'default', 'title': 'Type of pharmacy', 'description': 'Type of pharmacy contractor, which can be either pharmacy or appliance'}, {'name': 'CONTRACTOR_CODE', 'type': 'string', 'format': 'default', 'title': 'The unique contractor code for pharmacy, appliance, or local pharmaceutical services contractor', 'description': 'The Organisation Data Service (ODS) code of the premises at which pharmaceutical services may be provided e.g. FW844 . It is also sometimes referred to as OCS code or F code.'}, {'name': 'CONTRACTOR_NAME', 'type': 'string', 'format': 'default', 'title': 'The name of the contractor', 'description': 'The name of the sole trader, partnership, or body corporate'}, {'name': 'ADDRESS_1', 'type': 'string', 'format': 'default', 'title': 'First line of address', 'description': 'The first line of the address of a premises.'}, {'name': 'ADDRESS_2', 'type': 'string', 'format': 'default', 'title': 'Second line of address', 'description': 'The second line of the address of a premises.'}, {'name': 'ADDRESS_3', 'type': 'string', 'format': 'default', 'title': 'Third line of address', 'description': 'The third line of the address of a premises.'}, {'name': 'ADDRESS_4', 'type': 'string', 'format': 'default', 'title': 'Fourth line of address', 'description': 'The fourth line of the address of a premises.'}, {'name': 'POSTCODE', 'type': 'string', 'format': 'default', 'title': 'Post code', 'description': 'The post code of the address of a premises.'}, {'name': 'CONTENT_GROUP', 'type': 'string', 'format': 'default', 'title': 'Content group', 'description': 'Represents the type of service offering associated with the pharmacy account type. For further information on the filters within the data dictionary column of Content Group, please go to the <a href="https://www.nhsbsa.nhs.uk/pharmacies-gp-practices-and-appliance-contractors/drug-tariff">Drug Tariff | NHSBSA</a>.'}, {'name': 'CONTENT', 'type': 'string', 'format': 'default', 'title': 'Content', 'description': 'Details the specific products included within each service offering for the pharmacy account type. For further information on the filters within the data dictionary column of Content, please go to the <a href="https://www.nhsbsa.nhs.uk/pharmacies-gp-practices-and-appliance-contractors/drug-tariff">Drug Tariff | NHSBSA</a>.'}, {'name': 'VALUE', 'type': 'integer', 'format': 'default', 'title': 'Value', 'description': 'Indicates the number of products dispensed for each content item by the pharmacy account type.'}], 'missingValues': ['']}, 'size': 37360826, 'state': 'active', 'title': 'Pharmacy and Appliance dispensing data February 2025', 'url': 'https://opendata.nhsbsa.net/dataset/25230765-9494-4fde-b3fc-af9c00037dfb/resource/cdb6fbc0-c568-4b00-a106-2b6cf27d0bbd/download/dispensing_data_202502.csv', 'url_type': 'upload'}, {'bq_table_name': 'DISPENSING_DATA_202503', 'cache_last_updated': None, 'cache_url': None, 'created': '2025-07-28T15:27:07.876164', 'datastore_active': False, 'dialect': {'delimiter': ',', 'quoteChar': '"'}, 'encoding': 'utf-8', 'format': 'CSV', 'hash': '4d8cee0f05e8a3cff8583b99222a0ad44f80c8f9894c8fb21a49d3eb02d8e0f4', 'id': '97ac3aff-b6c3-471e-b53f-470cda1cb418', 'last_modified': None, 'lfs_prefix': 'community_prescribing_dispensing/pharmacy-and-appliance-contractor-dispensing-data', 'metadata_modified': '2025-07-28T15:27:28.240510', 'mimetype': 'text/csv', 'mimetype_inner': None, 'name': 'DISPENSING_DATA_202503', 'package_id': '25230765-9494-4fde-b3fc-af9c00037dfb', 'position': 2, 'resource_type': None, 'restricted': '{"level": "public"}', 'sample': {}, 'schema': {'fields': [{'name': 'YEAR_MONTH', 'type': 'yearmonth', 'format': 'default', 'title': 'Year and Month', 'description': 'The year and month for which the claim for dispensed items has been submitted to NHSBSA in the format YYYY-MM.'}, {'name': 'ICB_CODE', 'type': 'string', 'format': 'default', 'title': 'Integrated Care Board (ICB) Code', 'description': 'The unique code used to refer to an ICB.'}, {'name': 'ICB_NAME', 'type': 'string', 'format': 'default', 'title': 'Integrated Care Board (ICB) Name', 'description': 'The name given to a geographical statutory organisation by NHS England that is a smaller division of a Region.'}, {'name': 'HWB_CODE', 'type': 'string', 'format': 'default', 'title': 'HWB Code', 'description': 'The unique code used to refer to a Health and Wellbeing Board'}, {'name': 'HWB_NAME', 'type': 'string', 'format': 'default', 'title': 'HWB Name', 'description': 'The name given to the Health and Wellbeing Board as introduced in the Health and Social Care Act 2012 that the pharmacy resides under.'}, {'name': 'PHARMACY_ACCOUNT_TYPE', 'type': 'string', 'format': 'default', 'title': 'Type of pharmacy', 'description': 'Type of pharmacy contractor, which can be either pharmacy or appliance'}, {'name': 'CONTRACTOR_CODE', 'type': 'string', 'format': 'default', 'title': 'The unique contractor code for pharmacy, appliance, or local pharmaceutical services contractor', 'description': 'The Organisation Data Service (ODS) code of the premises at which pharmaceutical services may be provided e.g. FW844 . It is also sometimes referred to as OCS code or F code.'}, {'name': 'CONTRACTOR_NAME', 'type': 'string', 'format': 'default', 'title': 'The name of the contractor', 'description': 'The name of the sole trader, partnership, or body corporate'}, {'name': 'ADDRESS_1', 'type': 'string', 'format': 'default', 'title': 'First line of address', 'description': 'The first line of the address of a premises.'}, {'name': 'ADDRESS_2', 'type': 'string', 'format': 'default', 'title': 'Second line of address', 'description': 'The second line of the address of a premises.'}, {'name': 'ADDRESS_3', 'type': 'string', 'format': 'default', 'title': 'Third line of address', 'description': 'The third line of the address of a premises.'}, {'name': 'ADDRESS_4', 'type': 'string', 'format': 'default', 'title': 'Fourth line of address', 'description': 'The fourth line of the address of a premises.'}, {'name': 'POSTCODE', 'type': 'string', 'format': 'default', 'title': 'Post code', 'description': 'The post code of the address of a premises.'}, {'name': 'CONTENT_GROUP', 'type': 'string', 'format': 'default', 'title': 'Content group', 'description': 'Represents the type of service offering associated with the pharmacy account type. For further information on the filters within the data dictionary column of Content Group, please go to the <a href="https://www.nhsbsa.nhs.uk/pharmacies-gp-practices-and-appliance-contractors/drug-tariff">Drug Tariff | NHSBSA</a>.'}, {'name': 'CONTENT', 'type': 'string', 'format': 'default', 'title': 'Content', 'description': 'Details the specific products included within each service offering for the pharmacy account type. For further information on the filters within the data dictionary column of Content, please go to the <a href="https://www.nhsbsa.nhs.uk/pharmacies-gp-practices-and-appliance-contractors/drug-tariff">Drug Tariff | NHSBSA</a>.'}, {'name': 'VALUE', 'type': 'integer', 'format': 'default', 'title': 'Value', 'description': 'Indicates the number of products dispensed for each content item by the pharmacy account type.'}], 'missingValues': ['']}, 'size': 37873974, 'state': 'active', 'title': 'Pharmacy and Appliance dispensing data March 2025', 'url': 'https://opendata.nhsbsa.net/dataset/25230765-9494-4fde-b3fc-af9c00037dfb/resource/97ac3aff-b6c3-471e-b53f-470cda1cb418/download/dispensing_data_202503.csv', 'url_type': 'upload'}, {'bq_table_name': 'DISPENSING_DATA_202504', 'cache_last_updated': None, 'cache_url': None, 'created': '2025-07-28T15:35:10.774954', 'datastore_active': False, 'description': 'Data re-ran 5th August 2025 due to error', 'dialect': {'delimiter': ',', 'quoteChar': '"'}, 'encoding': 'utf-8', 'format': 'CSV', 'hash': '2ab749196ab99f1d9cbaaa70d1011a3601d84215e32765b1f107cd88a6b5a40e', 'id': '1ec03d91-8dea-4ad9-87e8-87b7b39ca2a9', 'last_modified': None, 'lfs_prefix': 'community_prescribing_dispensing/pharmacy-and-appliance-contractor-dispensing-data', 'metadata_modified': '2025-08-05T11:55:44.847931', 'mimetype': 'text/csv', 'mimetype_inner': None, 'name': 'DISPENSING_DATA_202504', 'package_id': '25230765-9494-4fde-b3fc-af9c00037dfb', 'position': 3, 'resource_type': None, 'restricted': '{"level": "public"}', 'sample': {}, 'schema': {'fields': [{'name': 'YEAR_MONTH', 'type': 'yearmonth', 'format': 'default', 'title': 'Year and Month', 'description': 'The year and month for which the claim for dispensed items has been submitted to NHSBSA in the format YYYY-MM.'}, {'name': 'ICB_CODE', 'type': 'string', 'format': 'default', 'title': 'Integrated Care Board (ICB) Code', 'description': 'The unique code used to refer to an ICB.'}, {'name': 'ICB_NAME', 'type': 'string', 'format': 'default', 'title': 'Integrated Care Board (ICB) Name', 'description': 'The name given to a geographical statutory organisation by NHS England that is a smaller division of a Region.'}, {'name': 'HWB_CODE', 'type': 'string', 'format': 'default', 'title': 'HWB Code', 'description': 'The unique code used to refer to a Health and Wellbeing Board'}, {'name': 'HWB_NAME', 'type': 'string', 'format': 'default', 'title': 'HWB Name', 'description': 'The name given to the Health and Wellbeing Board as introduced in the Health and Social Care Act 2012 that the pharmacy resides under.'}, {'name': 'PHARMACY_ACCOUNT_TYPE', 'type': 'string', 'format': 'default', 'title': 'Type of pharmacy', 'description': 'Type of pharmacy contractor, which can be either pharmacy or appliance'}, {'name': 'CONTRACTOR_CODE', 'type': 'string', 'format': 'default', 'title': 'The unique contractor code for pharmacy, appliance, or local pharmaceutical services contractor', 'description': 'The Organisation Data Service (ODS) code of the premises at which pharmaceutical services may be provided e.g. FW844 . It is also sometimes referred to as OCS code or F code.'}, {'name': 'CONTRACTOR_NAME', 'type': 'string', 'format': 'default', 'title': 'The name of the contractor', 'description': 'The name of the sole trader, partnership, or body corporate'}, {'name': 'ADDRESS_1', 'type': 'string', 'format': 'default', 'title': 'First line of address', 'description': 'The first line of the address of a premises.'}, {'name': 'ADDRESS_2', 'type': 'string', 'format': 'default', 'title': 'Second line of address', 'description': 'The second line of the address of a premises.'}, {'name': 'ADDRESS_3', 'type': 'string', 'format': 'default', 'title': 'Third line of address', 'description': 'The third line of the address of a premises.'}, {'name': 'ADDRESS_4', 'type': 'string', 'format': 'default', 'title': 'Fourth line of address', 'description': 'The fourth line of the address of a premises.'}, {'name': 'POSTCODE', 'type': 'string', 'format': 'default', 'title': 'Post code', 'description': 'The post code of the address of a premises.'}, {'name': 'CONTENT_GROUP', 'type': 'string', 'format': 'default', 'title': 'Content group', 'description': 'Represents the type of service offering associated with the pharmacy account type. For further information on the filters within the data dictionary column of Content Group, please go to the <a href="https://www.nhsbsa.nhs.uk/pharmacies-gp-practices-and-appliance-contractors/drug-tariff">Drug Tariff | NHSBSA</a>.'}, {'name': 'CONTENT', 'type': 'string', 'format': 'default', 'title': 'Content', 'description': 'Details the specific products included within each service offering for the pharmacy account type. For further information on the filters within the data dictionary column of Content, please go to the <a href="https://www.nhsbsa.nhs.uk/pharmacies-gp-practices-and-appliance-contractors/drug-tariff">Drug Tariff | NHSBSA</a>.'}, {'name': 'VALUE', 'type': 'integer', 'format': 'default', 'title': 'Value', 'description': 'Indicates the number of products dispensed for each content item by the pharmacy account type.'}], 'missingValues': ['']}, 'size': 38046166, 'state': 'active', 'title': 'Pharmacy and Appliance dispensing data April 2025', 'url': 'https://opendata.nhsbsa.net/dataset/25230765-9494-4fde-b3fc-af9c00037dfb/resource/1ec03d91-8dea-4ad9-87e8-87b7b39ca2a9/download/dispensing_data_202504.csv', 'url_type': 'upload'}], 'tags': [], 'groups': [], 'relationships_as_subject': [], 'relationships_as_object': []}}, 'permission_labels': None} Pharmacy and appliance contractor dispensing data 3 hours ago

Data Services Support updated the dataset Pharmacy and appliance contractor dispensing data
4 hours ago

Data Services Support updated the dataset Pharmacy and appliance contractor dispensing data
6 hours ago

Data Services Support updated the dataset Pharmacy and appliance contractor dispensing data
7 hours ago

Data Services Support updated the dataset Pharmacy and appliance contractor dispensing data
1 week ago

Data Services Support created resource view Data Explorer
1 week ago

Data Services Support created a new discussion board
Pharmacy and appliance contractor dispensing data 1 week ago