1. Home
  2. Themes
  3. Dispensing Contractors
  4. Consolidated Pharmaceutical List

Consolidated Pharmaceutical List

Followers
13
dispensing-contractors

Dispensing Contractors

Datasets with a focus on dispensing contractors related data and information

read more

Licence

OGL-UK-3.0

  • 5436a3f8-7dae-4fe7-832f-ed1dce2cbb91 created a new discussion board
    Consolidated Pharmaceutical List 1 year ago
  • ab80d21c-d7ad-487c-8d26-88f2fab44a16 created a new discussion board
    Consolidated Pharmaceutical List 1 year ago
  • Gravatar Oliver Staunton added a new comment
    {'id': 'b19b5ef2-5465-44b2-a5bc-fa9e0ddc71a0', 'timestamp': '2023-07-18T20:47:34.658462', 'user_id': '75ac9363-3fea-43fc-aee1-e1cc25563a74', 'object_id': '240d142d-df82-4e97-b051-12371519e4e1', 'activity_type': 'changed issue', 'data': {'id': 21, 'comment': 'Perfect, thanks for clarifying. Useful dataset and will be of increasing interest due to changes to 100 hour pharmacy contractual opening hours.', 'user_id': '75ac9363-3fea-43fc-aee1-e1cc25563a74', 'issue_id': 10, 'created': '2023-07-18 20:47:34.610851', 'visibility': 'visible', 'abuse_status': 'unmoderated', 'user': {'email_hash': 'cc04cf37e36e222fc75c2e665d41f309', 'about': None, 'display_name': 'Oliver Staunton', 'name': 'pharmdata', 'created': '2023-04-19T11:40:50.650073', 'ckan_url': '/user/pharmdata', 'gravatar_url': '//gravatar.com/avatar/cc04cf37e36e222fc75c2e665d41f309?s=48', 'id': '75ac9363-3fea-43fc-aee1-e1cc25563a74', 'sysadmin': False, 'activity_streams_email_notifications': False, 'state': 'active', 'number_of_edits': 0, 'gravatar': '<img src="//gravatar.com/avatar/cc04cf37e36e222fc75c2e665d41f309?s=48&amp;d=identicon"\n class="gravatar" width="48" height="48" alt="Gravatar" />', 'fullname': 'Oliver Staunton', 'number_created_packages': 0}, 'dataset_id': '240d142d-df82-4e97-b051-12371519e4e1', 'issue_number': 1, 'package': {'license_title': 'Open Government Licence 3.0 (United Kingdom)', 'maintainer': None, 'relationships_as_object': [], 'private': False, 'maintainer_email': None, 'num_tags': 4, 'id': '240d142d-df82-4e97-b051-12371519e4e1', 'metadata_created': '2022-12-16T10:52:50.765032', 'metadata_modified': '2023-05-23T06:49:28.631660', 'author': 'NHS England Community Pharmacy Team', 'author_email': 'england.communitypharmacy@nhs.net', 'state': 'active', 'version': '1.0', 'creator_user_id': 'd88b189d-8107-4e6e-942b-e40ed83d89aa', 'type': 'dataset', 'resources': [{'encoding': 'utf-8', 'sample': '{}', 'package_id': '240d142d-df82-4e97-b051-12371519e4e1', 'datastore_active': False, 'id': '762437b3-432b-4a0b-bbf4-e6d9d3b6b5df', 'bq_table_name': 'CONSOL_PHARMACY_LIST_202223Q2', 'size': 2670613, 'title': 'Consolidated Pharmaceutical List - 2022-23 Quarter 2', 'restricted': '{"level": "public"}', 'cache_last_updated': None, 'state': 'active', 'sha256': '83520cda8b37db925fcead16cf2a372cb8aa92a562253a43434d615035eb0928', 'lfs_prefix': 'dispensing-contractors/consolidated-pharmaceutical-list', 'schema': '{u\'fields\': [{u\'title\': u\'Organisation Data Service code for pharmacy, appliance, or local pharmaceutical services contractor\', u\'type\': u\'string\', u\'description\': u\'The Organisation Data Service (ODS) code of the premises at which pharmaceutical services may be provided by those included in a pharmaceutical list.\', u\'name\': u\'PHARMACY_ODS_CODE_F_CODE\', u\'format\': u\'default\'}, {u\'title\': u\'Health and wellbeing board name\', u\'type\': u\'string\', u\'description\': u\'The name of a health and wellbeing board as introduced in the Health and Social Care Act 2012.\', u\'name\': u\'HEALTH_AND_WELLBEING_BOARD\', u\'format\': u\'default\'}, {u\'title\': u\'Trading name of contractor\', u\'type\': u\'string\', u\'description\': u\'The name under which a pharmacy contractor, appliance contractor, or local pharmaceutical services contractor trades.\', u\'name\': u\'PHARMACY_TRADING_NAME\', u\'format\': u\'default\'}, {u\'title\': u\'Name of person or persons included in a pharmaceutical list\', u\'type\': u\'string\', u\'description\': u\'The name of the sole trader, partnership, or body corporate which is included in a pharmaceutical list.\', u\'name\': u\'ORGANISATION_NAME\', u\'format\': u\'default\'}, {u\'title\': u\'First line of address\', u\'type\': u\'string\', u\'description\': u\'The first line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD1\', u\'format\': u\'default\'}, {u\'title\': u\'Second line of address\', u\'type\': u\'string\', u\'description\': u\'The second line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD2\', u\'format\': u\'default\'}, {u\'title\': u\'Third line of address\', u\'type\': u\'string\', u\'description\': u\'The third line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD3\', u\'format\': u\'default\'}, {u\'title\': u\'Fourth line of address\', u\'type\': u\'string\', u\'description\': u\'The fourth line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD4\', u\'format\': u\'default\'}, {u\'title\': u\'Post code\', u\'type\': u\'string\', u\'description\': u\'The post code of the address of a premises.\', u\'name\': u\'POST_CODE\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Mondays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_MONDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Mondays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'MON_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Tuesdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_TUESDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Tuesdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'TUES_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Wednesdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_WEDNESDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Wednesdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'WED_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Thursdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_THURSDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Thursdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'THURS_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Fridays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_FRIDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Fridays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'FRI_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Saturdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_SATURDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Saturdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'SAT_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Sundays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_SUNDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Sundays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'SUN_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours in a full calendar week excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'WEEKLY_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'Type of contractor\', u\'type\': u\'string\', u\'description\': u\'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 \\u201cNHS appliance contractor\\u201d 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 \\u201cLPS contractor\\u201d 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\', u\'name\': u\'CONTRACT_TYPE\', u\'format\': u\'default\'}], u\'missingValues\': [u\'\']}', 'dialect': '{u\'quoteChar\': u\'"\', u\'delimiter\': u\',\'}', 'hash': '83520cda8b37db925fcead16cf2a372cb8aa92a562253a43434d615035eb0928', 'description': '', 'format': 'CSV', 'mimetype_inner': None, 'url_type': 'upload', 'mimetype': 'text/csv', 'cache_url': None, 'name': 'CONSOL_PHARMACY_LIST_202223Q2', 'created': '2022-12-16T10:58:57.502939', 'url': 'https://opendata.nhsbsa.net/dataset/240d142d-df82-4e97-b051-12371519e4e1/resource/762437b3-432b-4a0b-bbf4-e6d9d3b6b5df/download/consol_pharmacy_list_202223q2.csv', 'last_modified': None, 'position': 0, 'revision_id': '6e851d30-61f2-4f63-917d-a7eb94fbb80f', 'resource_type': None}, {'encoding': 'utf-8', 'sample': '{}', 'package_id': '240d142d-df82-4e97-b051-12371519e4e1', 'datastore_active': False, 'id': '52e0710e-1b16-4416-9849-fba0c88134b2', 'bq_table_name': 'CONSOL_PHARMACY_LIST_202223Q3', 'size': 2682203, 'title': 'Consolidated Pharmaceutical List - 2022-23 Quarter 3', 'restricted': '{"level": "public"}', 'cache_last_updated': None, 'state': 'active', 'sha256': '52b08a81e2be76445715537a878705479dff66bfc9ae61ae81121e710165d9c7', 'lfs_prefix': 'dispensing-contractors/consolidated-pharmaceutical-list', 'schema': '{u\'fields\': [{u\'title\': u\'Organisation Data Service code for pharmacy, appliance, or local pharmaceutical services contractor\', u\'type\': u\'string\', u\'description\': u\'The Organisation Data Service (ODS) code of the premises at which pharmaceutical services may be provided by those included in a pharmaceutical list.\', u\'name\': u\'PHARMACY_ODS_CODE_F_CODE\', u\'format\': u\'default\'}, {u\'title\': u\'Health and wellbeing board name\', u\'type\': u\'string\', u\'description\': u\'The name of a health and wellbeing board as introduced in the Health and Social Care Act 2012.\', u\'name\': u\'HEALTH_AND_WELLBEING_BOARD\', u\'format\': u\'default\'}, {u\'title\': u\'Trading name of contractor\', u\'type\': u\'string\', u\'description\': u\'The name under which a pharmacy contractor, appliance contractor, or local pharmaceutical services contractor trades.\', u\'name\': u\'PHARMACY_TRADING_NAME\', u\'format\': u\'default\'}, {u\'title\': u\'Name of person or persons included in a pharmaceutical list\', u\'type\': u\'string\', u\'description\': u\'The name of the sole trader, partnership, or body corporate which is included in a pharmaceutical list.\', u\'name\': u\'ORGANISATION_NAME\', u\'format\': u\'default\'}, {u\'title\': u\'First line of address\', u\'type\': u\'string\', u\'description\': u\'The first line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD1\', u\'format\': u\'default\'}, {u\'title\': u\'Second line of address\', u\'type\': u\'string\', u\'description\': u\'The second line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD2\', u\'format\': u\'default\'}, {u\'title\': u\'Third line of address\', u\'type\': u\'string\', u\'description\': u\'The third line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD3\', u\'format\': u\'default\'}, {u\'title\': u\'Fourth line of address\', u\'type\': u\'string\', u\'description\': u\'The fourth line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD4\', u\'format\': u\'default\'}, {u\'title\': u\'Post code\', u\'type\': u\'string\', u\'description\': u\'The post code of the address of a premises.\', u\'name\': u\'POST_CODE\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Mondays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_MONDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Mondays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'MON_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Tuesdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_TUESDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Tuesdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'TUES_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Wednesdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_WEDNESDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Wednesdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'WED_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Thursdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_THURSDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Thursdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'THURS_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Fridays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_FRIDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Fridays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'FRI_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Saturdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_SATURDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Saturdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'SAT_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Sundays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_SUNDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Sundays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'SUN_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours in a full calendar week excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'WEEKLY_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'Type of contractor\', u\'type\': u\'string\', u\'description\': u\'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 \\u201cNHS appliance contractor\\u201d 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 \\u201cLPS contractor\\u201d 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\', u\'name\': u\'CONTRACT_TYPE\', u\'format\': u\'default\'}], u\'missingValues\': [u\'\']}', 'dialect': '{u\'quoteChar\': u\'"\', u\'delimiter\': u\',\'}', 'hash': '52b08a81e2be76445715537a878705479dff66bfc9ae61ae81121e710165d9c7', 'description': '', 'format': 'CSV', 'mimetype_inner': None, 'url_type': 'upload', 'mimetype': 'text/csv', 'cache_url': None, 'name': 'CONSOL_PHARMACY_LIST_202223Q3', 'created': '2023-02-22T16:07:49.387561', 'url': 'https://opendata.nhsbsa.net/dataset/240d142d-df82-4e97-b051-12371519e4e1/resource/52e0710e-1b16-4416-9849-fba0c88134b2/download/consol_pharmacy_list_202223q3.csv', 'last_modified': None, 'position': 1, 'revision_id': '6986d948-de03-468a-abca-1c2fc6d1c225', 'resource_type': None}, {'encoding': 'utf-8', 'sample': '{}', 'package_id': '240d142d-df82-4e97-b051-12371519e4e1', 'datastore_active': False, 'id': '4647ba80-9222-4803-8d5c-86ee0125f859', 'bq_table_name': 'CONSOL_PHARMACY_LIST_202223Q4', 'size': 2676488, 'title': 'Consolidated Pharmaceutical List - 2022-23 Quarter 4', 'restricted': '{"level": "public"}', 'cache_last_updated': None, 'state': 'active', 'sha256': '2779dfa31e72cf2a011778c74b73939dc61c1034c0d58a150f1d78a97ccf376c', 'lfs_prefix': 'dispensing-contractors/consolidated-pharmaceutical-list', 'schema': '{u\'fields\': [{u\'title\': u\'Organisation Data Service code for pharmacy, appliance, or local pharmaceutical services contractor\', u\'type\': u\'string\', u\'description\': u\'The Organisation Data Service (ODS) code of the premises at which pharmaceutical services may be provided by those included in a pharmaceutical list.\', u\'name\': u\'PHARMACY_ODS_CODE_F_CODE\', u\'format\': u\'default\'}, {u\'title\': u\'Health and wellbeing board name\', u\'type\': u\'string\', u\'description\': u\'The name of a health and wellbeing board as introduced in the Health and Social Care Act 2012.\', u\'name\': u\'HEALTH_AND_WELLBEING_BOARD\', u\'format\': u\'default\'}, {u\'title\': u\'Trading name of contractor\', u\'type\': u\'string\', u\'description\': u\'The name under which a pharmacy contractor, appliance contractor, or local pharmaceutical services contractor trades.\', u\'name\': u\'PHARMACY_TRADING_NAME\', u\'format\': u\'default\'}, {u\'title\': u\'Name of person or persons included in a pharmaceutical list\', u\'type\': u\'string\', u\'description\': u\'The name of the sole trader, partnership, or body corporate which is included in a pharmaceutical list.\', u\'name\': u\'ORGANISATION_NAME\', u\'format\': u\'default\'}, {u\'title\': u\'First line of address\', u\'type\': u\'string\', u\'description\': u\'The first line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD1\', u\'format\': u\'default\'}, {u\'title\': u\'Second line of address\', u\'type\': u\'string\', u\'description\': u\'The second line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD2\', u\'format\': u\'default\'}, {u\'title\': u\'Third line of address\', u\'type\': u\'string\', u\'description\': u\'The third line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD3\', u\'format\': u\'default\'}, {u\'title\': u\'Fourth line of address\', u\'type\': u\'string\', u\'description\': u\'The fourth line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD4\', u\'format\': u\'default\'}, {u\'title\': u\'Post code\', u\'type\': u\'string\', u\'description\': u\'The post code of the address of a premises.\', u\'name\': u\'POST_CODE\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Mondays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_MONDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Mondays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'MON_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Tuesdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_TUESDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Tuesdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'TUES_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Wednesdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_WEDNESDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Wednesdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'WED_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Thursdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_THURSDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Thursdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'THURS_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Fridays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_FRIDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Fridays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'FRI_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Saturdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_SATURDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Saturdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'SAT_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Sundays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_SUNDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Sundays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'SUN_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours in a full calendar week excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'WEEKLY_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'Type of contractor\', u\'type\': u\'string\', u\'description\': u\'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 \\u201cNHS appliance contractor\\u201d 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 \\u201cLPS contractor\\u201d 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\', u\'name\': u\'CONTRACT_TYPE\', u\'format\': u\'default\'}], u\'missingValues\': [u\'\']}', 'dialect': '{u\'quoteChar\': u\'"\', u\'delimiter\': u\',\'}', 'hash': '2779dfa31e72cf2a011778c74b73939dc61c1034c0d58a150f1d78a97ccf376c', 'description': '', 'format': 'CSV', 'mimetype_inner': None, 'url_type': 'upload', 'mimetype': 'text/csv', 'cache_url': None, 'name': 'CONSOL_PHARMACY_LIST_202223Q4', 'created': '2023-05-23T06:49:11.592674', 'url': 'https://opendata.nhsbsa.net/dataset/240d142d-df82-4e97-b051-12371519e4e1/resource/4647ba80-9222-4803-8d5c-86ee0125f859/download/consol_pharmacy_list_202223q4.csv', 'last_modified': None, 'position': 2, 'revision_id': '1bf4fb1e-a141-410c-94bf-42e43c2f7d1a', 'resource_type': None}], 'num_resources': 3, 'tags': [{'vocabulary_id': None, 'state': 'active', 'display_name': 'Appliance contractor', 'id': '1cf94013-aec5-4580-8586-bcfd5f00b913', 'name': 'Appliance contractor'}, {'vocabulary_id': None, 'state': 'active', 'display_name': 'community pharmacy', 'id': '1fad4959-2a93-4b67-a4f8-f164ea93fdd0', 'name': 'community pharmacy'}, {'vocabulary_id': None, 'state': 'active', 'display_name': 'dispensing contractor', 'id': '3575675e-3e6b-4d08-9649-8969e6f16e92', 'name': 'dispensing contractor'}, {'vocabulary_id': None, 'state': 'active', 'display_name': 'pharmacy', 'id': '75002642-6ad1-4d67-b5bd-fdd70a86c05f', 'name': 'pharmacy'}], 'groups': [], 'license_id': 'OGL-UK-3.0', 'relationships_as_subject': [], 'organization': {'description': 'Datasets with a focus on dispensing contractors related data', 'created': '2022-12-16T08:56:25.996977', 'title': 'Dispensing Contractors', 'name': 'dispensing-contractors', 'is_organization': True, 'state': 'active', 'image_url': 'https://storage.googleapis.com/dx-nhs-production/_assets/group/2022-12-16-085625.967339-Electronic-presciption-1-PNG-Blue.png', 'revision_id': 'cbb1f506-2b7c-48a6-998b-5babf912db25', 'type': 'organization', 'id': '54c6e2c2-9cff-48dd-833a-75b1926bcb6a', 'approval_status': 'approved'}, 'name': 'consolidated-pharmaceutical-list', 'isopen': True, 'url': 'NHS Business Services Authority (NHSBSA) Master Data Replacement (MDR)', 'notes': "This dataset consolidates the pharmaceutical lists which NHS England has a regulatory duty to prepare, maintain and publish for each Health and Wellbeing Board area. This consolidated list includes lists of:\r\n\r\n1.\tNHS pharmacies (also known as NHS community pharmacies) and;\r\n\r\n2.\tNHS appliance contractors (also known as NHS dispensing appliance contractors) and;\r\n\r\n3.\tLocal Pharmaceutical Services contractors\r\n\r\nPharmaceutical lists for each Health and Wellbeing Board area are maintained by NHS England by pharmacy contract teams. Community pharmacies and dispensing appliance contractors can apply to or notify contract teams to amend the details held by the regional teams as specified in [The National Health Service (Pharmaceutical and Local Pharmaceutical Services) Regulations 2013](https://www.legislation.gov.uk/uksi/2013/349/contents) . Further details on the application processes can be found on the [Primary Care Support England website](https://pcse.england.nhs.uk/services/pharmacy-market-administration-services/).\r\n\r\nNHS BSA collates information on changes from NHS pharmacy contract teams and PCSE in the consolidated pharmaceutical list on NHS England's behalf.\r\n\r\nTypically, high volumes of changes take place each month; and so, the consolidated pharmaceutical list is produced and validated on a quarterly basis. This validation confirms the accuracy of the consolidated pharmaceutical list, by comparing it to the pharmaceutical lists maintained for each Health and Wellbeing Board area. \r\n \r\nThe consolidated pharmaceutical list here represents the data as recorded in the NHSBSA Master Data Replacement System (MDR) at the time of publishing. Where information contained in the published list is discovered to be incorrect after publication, backdated amendments are made and reflected in the next publication.\r\n\r\n\r\nWe publish the related dataset [Pharmacy Openings and Closures](https://opendata.nhsbsa.net/dataset/pharmacy-openings-and-closures) on a monthly basis.", 'owner_org': '54c6e2c2-9cff-48dd-833a-75b1926bcb6a', 'extras': [], 'license_url': 'https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/', 'title': 'Consolidated Pharmaceutical List', 'revision_id': 'd1c3a3d8-bf61-4af3-bf41-de5afd32e245'}}, 'permission_labels': None} Consolidated Pharmaceutical List 2 years ago
  • Gravatar paul_westrip added a new comment
    {'id': 'a5658119-b317-4f8d-bd93-f729470e8f9b', 'timestamp': '2023-07-18T15:03:33.078142', 'user_id': 'd88b189d-8107-4e6e-942b-e40ed83d89aa', 'object_id': '240d142d-df82-4e97-b051-12371519e4e1', 'activity_type': 'changed issue', 'data': {'id': 20, 'comment': 'Hello\r\n\r\nthanks for reaching out Q2 2022/23 data is built up across the July - September 2022 and is accurate as of the end of September (the end of quarter). Any changes are then logged over the next quarter ready to be published at the end Q3.\r\n\r\nDoes that help?', 'user_id': 'd88b189d-8107-4e6e-942b-e40ed83d89aa', 'issue_id': 10, 'created': '2023-07-18 15:03:33.030692', 'visibility': 'visible', 'abuse_status': 'unmoderated', 'user': {'email_hash': 'c3856f17748ad80346afc307e19fa00f', 'about': 'Open Data Product Owner for the NHSBSA\r\n\r\nPlease reach out if you have questions or ideas', 'display_name': 'paul_westrip', 'name': 'paul_westrip', 'created': '2022-08-04T14:58:42.347572', 'ckan_url': '/user/paul_westrip', 'gravatar_url': '//gravatar.com/avatar/c3856f17748ad80346afc307e19fa00f?s=48', 'id': 'd88b189d-8107-4e6e-942b-e40ed83d89aa', 'sysadmin': True, 'activity_streams_email_notifications': True, 'state': 'active', 'number_of_edits': 366, 'gravatar': '<img src="//gravatar.com/avatar/c3856f17748ad80346afc307e19fa00f?s=48&amp;d=identicon"\n class="gravatar" width="48" height="48" alt="Gravatar" />', 'fullname': '', 'number_created_packages': 4}, 'dataset_id': '240d142d-df82-4e97-b051-12371519e4e1', 'issue_number': 1, 'package': {'license_title': 'Open Government Licence 3.0 (United Kingdom)', 'maintainer': None, 'relationships_as_object': [], 'private': False, 'maintainer_email': None, 'num_tags': 4, 'id': '240d142d-df82-4e97-b051-12371519e4e1', 'metadata_created': '2022-12-16T10:52:50.765032', 'metadata_modified': '2023-05-23T06:49:28.631660', 'author': 'NHS England Community Pharmacy Team', 'author_email': 'england.communitypharmacy@nhs.net', 'state': 'active', 'version': '1.0', 'creator_user_id': 'd88b189d-8107-4e6e-942b-e40ed83d89aa', 'type': 'dataset', 'resources': [{'encoding': 'utf-8', 'sample': '{}', 'package_id': '240d142d-df82-4e97-b051-12371519e4e1', 'datastore_active': False, 'id': '762437b3-432b-4a0b-bbf4-e6d9d3b6b5df', 'bq_table_name': 'CONSOL_PHARMACY_LIST_202223Q2', 'size': 2670613, 'title': 'Consolidated Pharmaceutical List - 2022-23 Quarter 2', 'restricted': '{"level": "public"}', 'cache_last_updated': None, 'state': 'active', 'sha256': '83520cda8b37db925fcead16cf2a372cb8aa92a562253a43434d615035eb0928', 'lfs_prefix': 'dispensing-contractors/consolidated-pharmaceutical-list', 'schema': '{u\'fields\': [{u\'title\': u\'Organisation Data Service code for pharmacy, appliance, or local pharmaceutical services contractor\', u\'type\': u\'string\', u\'description\': u\'The Organisation Data Service (ODS) code of the premises at which pharmaceutical services may be provided by those included in a pharmaceutical list.\', u\'name\': u\'PHARMACY_ODS_CODE_F_CODE\', u\'format\': u\'default\'}, {u\'title\': u\'Health and wellbeing board name\', u\'type\': u\'string\', u\'description\': u\'The name of a health and wellbeing board as introduced in the Health and Social Care Act 2012.\', u\'name\': u\'HEALTH_AND_WELLBEING_BOARD\', u\'format\': u\'default\'}, {u\'title\': u\'Trading name of contractor\', u\'type\': u\'string\', u\'description\': u\'The name under which a pharmacy contractor, appliance contractor, or local pharmaceutical services contractor trades.\', u\'name\': u\'PHARMACY_TRADING_NAME\', u\'format\': u\'default\'}, {u\'title\': u\'Name of person or persons included in a pharmaceutical list\', u\'type\': u\'string\', u\'description\': u\'The name of the sole trader, partnership, or body corporate which is included in a pharmaceutical list.\', u\'name\': u\'ORGANISATION_NAME\', u\'format\': u\'default\'}, {u\'title\': u\'First line of address\', u\'type\': u\'string\', u\'description\': u\'The first line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD1\', u\'format\': u\'default\'}, {u\'title\': u\'Second line of address\', u\'type\': u\'string\', u\'description\': u\'The second line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD2\', u\'format\': u\'default\'}, {u\'title\': u\'Third line of address\', u\'type\': u\'string\', u\'description\': u\'The third line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD3\', u\'format\': u\'default\'}, {u\'title\': u\'Fourth line of address\', u\'type\': u\'string\', u\'description\': u\'The fourth line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD4\', u\'format\': u\'default\'}, {u\'title\': u\'Post code\', u\'type\': u\'string\', u\'description\': u\'The post code of the address of a premises.\', u\'name\': u\'POST_CODE\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Mondays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_MONDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Mondays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'MON_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Tuesdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_TUESDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Tuesdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'TUES_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Wednesdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_WEDNESDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Wednesdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'WED_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Thursdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_THURSDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Thursdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'THURS_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Fridays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_FRIDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Fridays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'FRI_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Saturdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_SATURDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Saturdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'SAT_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Sundays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_SUNDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Sundays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'SUN_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours in a full calendar week excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'WEEKLY_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'Type of contractor\', u\'type\': u\'string\', u\'description\': u\'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 \\u201cNHS appliance contractor\\u201d 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 \\u201cLPS contractor\\u201d 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\', u\'name\': u\'CONTRACT_TYPE\', u\'format\': u\'default\'}], u\'missingValues\': [u\'\']}', 'dialect': '{u\'quoteChar\': u\'"\', u\'delimiter\': u\',\'}', 'hash': '83520cda8b37db925fcead16cf2a372cb8aa92a562253a43434d615035eb0928', 'description': '', 'format': 'CSV', 'mimetype_inner': None, 'url_type': 'upload', 'mimetype': 'text/csv', 'cache_url': None, 'name': 'CONSOL_PHARMACY_LIST_202223Q2', 'created': '2022-12-16T10:58:57.502939', 'url': 'https://opendata.nhsbsa.net/dataset/240d142d-df82-4e97-b051-12371519e4e1/resource/762437b3-432b-4a0b-bbf4-e6d9d3b6b5df/download/consol_pharmacy_list_202223q2.csv', 'last_modified': None, 'position': 0, 'revision_id': '6e851d30-61f2-4f63-917d-a7eb94fbb80f', 'resource_type': None}, {'encoding': 'utf-8', 'sample': '{}', 'package_id': '240d142d-df82-4e97-b051-12371519e4e1', 'datastore_active': False, 'id': '52e0710e-1b16-4416-9849-fba0c88134b2', 'bq_table_name': 'CONSOL_PHARMACY_LIST_202223Q3', 'size': 2682203, 'title': 'Consolidated Pharmaceutical List - 2022-23 Quarter 3', 'restricted': '{"level": "public"}', 'cache_last_updated': None, 'state': 'active', 'sha256': '52b08a81e2be76445715537a878705479dff66bfc9ae61ae81121e710165d9c7', 'lfs_prefix': 'dispensing-contractors/consolidated-pharmaceutical-list', 'schema': '{u\'fields\': [{u\'title\': u\'Organisation Data Service code for pharmacy, appliance, or local pharmaceutical services contractor\', u\'type\': u\'string\', u\'description\': u\'The Organisation Data Service (ODS) code of the premises at which pharmaceutical services may be provided by those included in a pharmaceutical list.\', u\'name\': u\'PHARMACY_ODS_CODE_F_CODE\', u\'format\': u\'default\'}, {u\'title\': u\'Health and wellbeing board name\', u\'type\': u\'string\', u\'description\': u\'The name of a health and wellbeing board as introduced in the Health and Social Care Act 2012.\', u\'name\': u\'HEALTH_AND_WELLBEING_BOARD\', u\'format\': u\'default\'}, {u\'title\': u\'Trading name of contractor\', u\'type\': u\'string\', u\'description\': u\'The name under which a pharmacy contractor, appliance contractor, or local pharmaceutical services contractor trades.\', u\'name\': u\'PHARMACY_TRADING_NAME\', u\'format\': u\'default\'}, {u\'title\': u\'Name of person or persons included in a pharmaceutical list\', u\'type\': u\'string\', u\'description\': u\'The name of the sole trader, partnership, or body corporate which is included in a pharmaceutical list.\', u\'name\': u\'ORGANISATION_NAME\', u\'format\': u\'default\'}, {u\'title\': u\'First line of address\', u\'type\': u\'string\', u\'description\': u\'The first line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD1\', u\'format\': u\'default\'}, {u\'title\': u\'Second line of address\', u\'type\': u\'string\', u\'description\': u\'The second line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD2\', u\'format\': u\'default\'}, {u\'title\': u\'Third line of address\', u\'type\': u\'string\', u\'description\': u\'The third line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD3\', u\'format\': u\'default\'}, {u\'title\': u\'Fourth line of address\', u\'type\': u\'string\', u\'description\': u\'The fourth line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD4\', u\'format\': u\'default\'}, {u\'title\': u\'Post code\', u\'type\': u\'string\', u\'description\': u\'The post code of the address of a premises.\', u\'name\': u\'POST_CODE\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Mondays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_MONDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Mondays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'MON_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Tuesdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_TUESDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Tuesdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'TUES_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Wednesdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_WEDNESDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Wednesdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'WED_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Thursdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_THURSDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Thursdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'THURS_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Fridays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_FRIDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Fridays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'FRI_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Saturdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_SATURDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Saturdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'SAT_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Sundays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_SUNDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Sundays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'SUN_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours in a full calendar week excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'WEEKLY_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'Type of contractor\', u\'type\': u\'string\', u\'description\': u\'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 \\u201cNHS appliance contractor\\u201d 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 \\u201cLPS contractor\\u201d 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\', u\'name\': u\'CONTRACT_TYPE\', u\'format\': u\'default\'}], u\'missingValues\': [u\'\']}', 'dialect': '{u\'quoteChar\': u\'"\', u\'delimiter\': u\',\'}', 'hash': '52b08a81e2be76445715537a878705479dff66bfc9ae61ae81121e710165d9c7', 'description': '', 'format': 'CSV', 'mimetype_inner': None, 'url_type': 'upload', 'mimetype': 'text/csv', 'cache_url': None, 'name': 'CONSOL_PHARMACY_LIST_202223Q3', 'created': '2023-02-22T16:07:49.387561', 'url': 'https://opendata.nhsbsa.net/dataset/240d142d-df82-4e97-b051-12371519e4e1/resource/52e0710e-1b16-4416-9849-fba0c88134b2/download/consol_pharmacy_list_202223q3.csv', 'last_modified': None, 'position': 1, 'revision_id': '6986d948-de03-468a-abca-1c2fc6d1c225', 'resource_type': None}, {'encoding': 'utf-8', 'sample': '{}', 'package_id': '240d142d-df82-4e97-b051-12371519e4e1', 'datastore_active': False, 'id': '4647ba80-9222-4803-8d5c-86ee0125f859', 'bq_table_name': 'CONSOL_PHARMACY_LIST_202223Q4', 'size': 2676488, 'title': 'Consolidated Pharmaceutical List - 2022-23 Quarter 4', 'restricted': '{"level": "public"}', 'cache_last_updated': None, 'state': 'active', 'sha256': '2779dfa31e72cf2a011778c74b73939dc61c1034c0d58a150f1d78a97ccf376c', 'lfs_prefix': 'dispensing-contractors/consolidated-pharmaceutical-list', 'schema': '{u\'fields\': [{u\'title\': u\'Organisation Data Service code for pharmacy, appliance, or local pharmaceutical services contractor\', u\'type\': u\'string\', u\'description\': u\'The Organisation Data Service (ODS) code of the premises at which pharmaceutical services may be provided by those included in a pharmaceutical list.\', u\'name\': u\'PHARMACY_ODS_CODE_F_CODE\', u\'format\': u\'default\'}, {u\'title\': u\'Health and wellbeing board name\', u\'type\': u\'string\', u\'description\': u\'The name of a health and wellbeing board as introduced in the Health and Social Care Act 2012.\', u\'name\': u\'HEALTH_AND_WELLBEING_BOARD\', u\'format\': u\'default\'}, {u\'title\': u\'Trading name of contractor\', u\'type\': u\'string\', u\'description\': u\'The name under which a pharmacy contractor, appliance contractor, or local pharmaceutical services contractor trades.\', u\'name\': u\'PHARMACY_TRADING_NAME\', u\'format\': u\'default\'}, {u\'title\': u\'Name of person or persons included in a pharmaceutical list\', u\'type\': u\'string\', u\'description\': u\'The name of the sole trader, partnership, or body corporate which is included in a pharmaceutical list.\', u\'name\': u\'ORGANISATION_NAME\', u\'format\': u\'default\'}, {u\'title\': u\'First line of address\', u\'type\': u\'string\', u\'description\': u\'The first line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD1\', u\'format\': u\'default\'}, {u\'title\': u\'Second line of address\', u\'type\': u\'string\', u\'description\': u\'The second line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD2\', u\'format\': u\'default\'}, {u\'title\': u\'Third line of address\', u\'type\': u\'string\', u\'description\': u\'The third line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD3\', u\'format\': u\'default\'}, {u\'title\': u\'Fourth line of address\', u\'type\': u\'string\', u\'description\': u\'The fourth line of the address of a premises.\', u\'name\': u\'ADDRESS_FIELD4\', u\'format\': u\'default\'}, {u\'title\': u\'Post code\', u\'type\': u\'string\', u\'description\': u\'The post code of the address of a premises.\', u\'name\': u\'POST_CODE\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Mondays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_MONDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Mondays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'MON_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Tuesdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_TUESDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Tuesdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'TUES_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Wednesdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_WEDNESDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Wednesdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'WED_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Thursdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_THURSDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Thursdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'THURS_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Fridays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_FRIDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Fridays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'FRI_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Saturdays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_SATURDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Saturdays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'SAT_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'The times, represented as a 24 hour clock, during which the contractor is listed to be open on Sundays, excluding bank or public holidays\', u\'type\': u\'string\', u\'description\': u\'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.\', u\'name\': u\'PHARMACY_OPENING_HOURS_SUNDAY\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours on Sundays excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'SUN_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'Total sum of opening hours in a full calendar week excluding bank or public holidays\', u\'type\': u\'integer\', u\'description\': u\'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.\', u\'name\': u\'WEEKLY_TOTAL\', u\'format\': u\'default\'}, {u\'title\': u\'Type of contractor\', u\'type\': u\'string\', u\'description\': u\'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 \\u201cNHS appliance contractor\\u201d 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 \\u201cLPS contractor\\u201d 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\', u\'name\': u\'CONTRACT_TYPE\', u\'format\': u\'default\'}], u\'missingValues\': [u\'\']}', 'dialect': '{u\'quoteChar\': u\'"\', u\'delimiter\': u\',\'}', 'hash': '2779dfa31e72cf2a011778c74b73939dc61c1034c0d58a150f1d78a97ccf376c', 'description': '', 'format': 'CSV', 'mimetype_inner': None, 'url_type': 'upload', 'mimetype': 'text/csv', 'cache_url': None, 'name': 'CONSOL_PHARMACY_LIST_202223Q4', 'created': '2023-05-23T06:49:11.592674', 'url': 'https://opendata.nhsbsa.net/dataset/240d142d-df82-4e97-b051-12371519e4e1/resource/4647ba80-9222-4803-8d5c-86ee0125f859/download/consol_pharmacy_list_202223q4.csv', 'last_modified': None, 'position': 2, 'revision_id': '1bf4fb1e-a141-410c-94bf-42e43c2f7d1a', 'resource_type': None}], 'num_resources': 3, 'tags': [{'vocabulary_id': None, 'state': 'active', 'display_name': 'Appliance contractor', 'id': '1cf94013-aec5-4580-8586-bcfd5f00b913', 'name': 'Appliance contractor'}, {'vocabulary_id': None, 'state': 'active', 'display_name': 'community pharmacy', 'id': '1fad4959-2a93-4b67-a4f8-f164ea93fdd0', 'name': 'community pharmacy'}, {'vocabulary_id': None, 'state': 'active', 'display_name': 'dispensing contractor', 'id': '3575675e-3e6b-4d08-9649-8969e6f16e92', 'name': 'dispensing contractor'}, {'vocabulary_id': None, 'state': 'active', 'display_name': 'pharmacy', 'id': '75002642-6ad1-4d67-b5bd-fdd70a86c05f', 'name': 'pharmacy'}], 'groups': [], 'license_id': 'OGL-UK-3.0', 'relationships_as_subject': [], 'organization': {'description': 'Datasets with a focus on dispensing contractors related data', 'created': '2022-12-16T08:56:25.996977', 'title': 'Dispensing Contractors', 'name': 'dispensing-contractors', 'is_organization': True, 'state': 'active', 'image_url': 'https://storage.googleapis.com/dx-nhs-production/_assets/group/2022-12-16-085625.967339-Electronic-presciption-1-PNG-Blue.png', 'revision_id': 'cbb1f506-2b7c-48a6-998b-5babf912db25', 'type': 'organization', 'id': '54c6e2c2-9cff-48dd-833a-75b1926bcb6a', 'approval_status': 'approved'}, 'name': 'consolidated-pharmaceutical-list', 'isopen': True, 'url': 'NHS Business Services Authority (NHSBSA) Master Data Replacement (MDR)', 'notes': "This dataset consolidates the pharmaceutical lists which NHS England has a regulatory duty to prepare, maintain and publish for each Health and Wellbeing Board area. This consolidated list includes lists of:\r\n\r\n1.\tNHS pharmacies (also known as NHS community pharmacies) and;\r\n\r\n2.\tNHS appliance contractors (also known as NHS dispensing appliance contractors) and;\r\n\r\n3.\tLocal Pharmaceutical Services contractors\r\n\r\nPharmaceutical lists for each Health and Wellbeing Board area are maintained by NHS England by pharmacy contract teams. Community pharmacies and dispensing appliance contractors can apply to or notify contract teams to amend the details held by the regional teams as specified in [The National Health Service (Pharmaceutical and Local Pharmaceutical Services) Regulations 2013](https://www.legislation.gov.uk/uksi/2013/349/contents) . Further details on the application processes can be found on the [Primary Care Support England website](https://pcse.england.nhs.uk/services/pharmacy-market-administration-services/).\r\n\r\nNHS BSA collates information on changes from NHS pharmacy contract teams and PCSE in the consolidated pharmaceutical list on NHS England's behalf.\r\n\r\nTypically, high volumes of changes take place each month; and so, the consolidated pharmaceutical list is produced and validated on a quarterly basis. This validation confirms the accuracy of the consolidated pharmaceutical list, by comparing it to the pharmaceutical lists maintained for each Health and Wellbeing Board area. \r\n \r\nThe consolidated pharmaceutical list here represents the data as recorded in the NHSBSA Master Data Replacement System (MDR) at the time of publishing. Where information contained in the published list is discovered to be incorrect after publication, backdated amendments are made and reflected in the next publication.\r\n\r\n\r\nWe publish the related dataset [Pharmacy Openings and Closures](https://opendata.nhsbsa.net/dataset/pharmacy-openings-and-closures) on a monthly basis.", 'owner_org': '54c6e2c2-9cff-48dd-833a-75b1926bcb6a', 'extras': [], 'license_url': 'https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/', 'title': 'Consolidated Pharmaceutical List', 'revision_id': 'd1c3a3d8-bf61-4af3-bf41-de5afd32e245'}}, 'permission_labels': None} Consolidated Pharmaceutical List 2 years ago
  • Gravatar Oliver Staunton created a new discussion board
    Consolidated Pharmaceutical List 2 years ago
Newer activities Older activities