![[Open Data]](/base/images/od_80x15_blue.png)
-
Data Services Support updated the dataset Consolidated Pharmaceutical List
6 days ago -
6 days ago -
6 days ago -
6 days ago -
6 days ago -
6 days ago -
6 days ago -
6 days ago -
6 days ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
2 weeks ago -
2 weeks ago -
Consolidated Pharmaceutical List 3 weeks ago -
Oliver Staunton added a new comment
{'id': '2aa79e74-45e1-437b-8dc4-b927eaaced1f', 'timestamp': '2024-07-30T11:27:11.800869', 'user_id': '75ac9363-3fea-43fc-aee1-e1cc25563a74', 'object_id': '240d142d-df82-4e97-b051-12371519e4e1', 'activity_type': 'changed issue', 'data': {'id': 58, 'comment': 'Hi, it is no problem at all, just wanted to clarify. Thanks for the quick response', 'user_id': '75ac9363-3fea-43fc-aee1-e1cc25563a74', 'issue_id': 10623, 'created': '2024-07-30 11:27:11.768178', '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&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': 2, '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', 'upload_to_bigquery': 'true', 'metadata_modified': '2024-07-30T07:26:16.845422', '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}, {'encoding': 'utf-8', 'sample': '{}', 'package_id': '240d142d-df82-4e97-b051-12371519e4e1', 'datastore_active': False, 'id': 'fb0c77ba-944b-4697-9de4-b5c207e0f8fd', 'bq_table_name': 'CONSOL_PHARMACY_LIST_202324Q1', 'size': 2645634, 'title': 'Consolidated Pharmaceutical List - 2023-24 Quarter 1', 'restricted': '{"level": "public"}', 'cache_last_updated': None, 'state': 'active', 'sha256': '715da25b3b0a5bd6c6d1b2f2fb74f15a9ed4a83cce948190da28fd629b0fa110', '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': '715da25b3b0a5bd6c6d1b2f2fb74f15a9ed4a83cce948190da28fd629b0fa110', 'description': '', 'format': 'CSV', 'mimetype_inner': None, 'url_type': 'upload', 'mimetype': 'text/csv', 'cache_url': None, 'name': 'CONSOL_PHARMACY_LIST_202324Q1', 'created': '2023-08-16T10:46:11.061776', 'url': 'https://opendata.nhsbsa.net/dataset/240d142d-df82-4e97-b051-12371519e4e1/resource/fb0c77ba-944b-4697-9de4-b5c207e0f8fd/download/consol_pharmacy_list_202324q1.csv', 'last_modified': None, 'position': 3, 'revision_id': '28f6e601-eaa9-4114-afeb-ae02ebb41c24', 'resource_type': None}, {'encoding': 'utf-8', 'sample': '{}', 'package_id': '240d142d-df82-4e97-b051-12371519e4e1', 'datastore_active': False, 'id': 'bdee8bc2-70ad-4df4-beba-991d8001cee3', 'bq_table_name': 'CONSOL_PHARMACY_LIST_202324Q2', 'size': 2645112, 'title': 'Consolidated Pharmaceutical List - 2023-24 Quarter 2', 'restricted': '{"level": "public"}', 'cache_last_updated': None, 'state': 'active', 'sha256': 'fd0e3e48d72874130130a765fd5c40910cb41e1774f7e7f2889ff9da8e17ed0d', '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': 'fd0e3e48d72874130130a765fd5c40910cb41e1774f7e7f2889ff9da8e17ed0d', 'description': '', 'format': 'CSV', 'mimetype_inner': None, 'url_type': 'upload', 'mimetype': 'text/csv', 'cache_url': None, 'name': 'CONSOL_PHARMACY_LIST_202324Q2', 'created': '2023-12-05T13:46:35.732358', 'url': 'https://opendata.nhsbsa.net/dataset/240d142d-df82-4e97-b051-12371519e4e1/resource/bdee8bc2-70ad-4df4-beba-991d8001cee3/download/consol_pharmacy_list_202324q2.csv', 'last_modified': None, 'position': 4, 'revision_id': 'eabd529a-9715-4222-8099-96efa85c485c', 'resource_type': None}, {'encoding': 'utf-8', 'sample': '{}', 'package_id': '240d142d-df82-4e97-b051-12371519e4e1', 'datastore_active': False, 'id': 'b7650d35-c9e4-4302-8b85-067ddd3931a4', 'bq_table_name': 'CONSOL_PHARMACY_LIST_202324Q3', 'size': 2617832, 'title': 'Consolidated Pharmaceutical List - 2023-24 Quarter 3', 'restricted': '{"level": "public"}', 'cache_last_updated': None, 'state': 'active', 'sha256': '8c87eec38f332768c9191646061801f19b5e59926fb4b74c4a18193354cd0815', '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': '8c87eec38f332768c9191646061801f19b5e59926fb4b74c4a18193354cd0815', 'description': '', 'format': 'CSV', 'mimetype_inner': None, 'url_type': 'upload', 'mimetype': 'text/csv', 'cache_url': None, 'name': 'CONSOL_PHARMACY_LIST_202324Q3', 'created': '2024-02-22T11:52:22.440254', 'url': 'https://opendata.nhsbsa.net/dataset/240d142d-df82-4e97-b051-12371519e4e1/resource/b7650d35-c9e4-4302-8b85-067ddd3931a4/download/consol_pharmacy_list_202324q3.csv', 'last_modified': None, 'position': 5, 'revision_id': '2c9047e6-7d0c-4c5a-a243-0771b36e9903', 'resource_type': None}, {'encoding': 'utf-8', 'sample': '{}', 'package_id': '240d142d-df82-4e97-b051-12371519e4e1', 'datastore_active': False, 'id': 'd36c355a-631d-4ddb-bc34-5a0315565e12', 'bq_table_name': 'CONSOL_PHARMACY_LIST_202324Q4', 'size': 2591411, 'title': 'Consolidated Pharmaceutical List - 2023-24 Quarter 4', 'restricted': '{"level": "public"}', 'cache_last_updated': None, 'state': 'active', 'sha256': '84134b427d5d49aeda2e5e6b6723e0a4612d5500ead25a1742f007c806186687', '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': '84134b427d5d49aeda2e5e6b6723e0a4612d5500ead25a1742f007c806186687', 'description': '', 'format': 'CSV', 'mimetype_inner': None, 'url_type': 'upload', 'mimetype': 'text/csv', 'cache_url': None, 'name': 'CONSOL_PHARMACY_LIST_202324Q4', 'created': '2024-05-09T10:41:43.130090', 'url': 'https://opendata.nhsbsa.net/dataset/240d142d-df82-4e97-b051-12371519e4e1/resource/d36c355a-631d-4ddb-bc34-5a0315565e12/download/consol_pharmacy_list_202324q4.csv', 'last_modified': None, 'position': 6, 'revision_id': '96787d2f-7acd-45b1-8fbe-122cdcb03276', 'resource_type': None}, {'encoding': 'utf-8', 'sample': '{}', 'package_id': '240d142d-df82-4e97-b051-12371519e4e1', 'datastore_active': True, 'id': '60da93f7-3100-4ce1-995f-f2dcfb766949', 'bq_table_name': 'CONSOL_PHARMACY_LIST_202425Q1', 'size': 2588496, 'title': 'Consolidated Pharmaceutical List - 2024-25 Quarter 1', 'restricted': '{"allowed_users": "", "level": "public"}', 'cache_last_updated': None, 'state': 'active', 'sha256': 'cd8a0b62c4b883cb5bdcb51f60c8176a5cb80ca9d5b306aeb1186aca52a973a9', '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': 'cd8a0b62c4b883cb5bdcb51f60c8176a5cb80ca9d5b306aeb1186aca52a973a9', 'description': '', 'format': 'CSV', 'mimetype_inner': None, 'url_type': 'upload', 'mimetype': 'text/csv', 'cache_url': None, 'name': 'CONSOL_PHARMACY_LIST_202425Q1', 'created': '2024-07-26T11:42:43.812139', 'url': 'https://opendata.nhsbsa.net/dataset/240d142d-df82-4e97-b051-12371519e4e1/resource/60da93f7-3100-4ce1-995f-f2dcfb766949/download/consol_pharmacy_list_202425q1.csv', 'last_modified': '2024-07-26T11:46:05.088000', 'position': 7, 'revision_id': 'c57a4b39-619a-4a10-aef6-0e3d133954bf', 'resource_type': None}], 'num_resources': 8, '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 and information', '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': 'a2deface-a642-4ea0-9edc-ea9881862698', '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\nNHSBSA 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) on the last day of each quarter. 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', 'license_url': 'https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/', 'title': 'Consolidated Pharmaceutical List', 'revision_id': 'bc42d91f-9128-4c32-8655-d1664e048148'}}, 'permission_labels': None} Consolidated Pharmaceutical List 1 year ago -
{'id': '51bc197c-2dfb-40a8-b65b-f783a8d736b0', 'timestamp': '2024-07-29T12:59:49.518810', 'user_id': '73783dc8-f5e5-461f-b56e-94ecedd6046c', 'object_id': '240d142d-df82-4e97-b051-12371519e4e1', 'activity_type': 'changed issue', 'data': {'id': 57, 'comment': 'Hello, @pharmdata. \r\nI can confirm that the only change to note is the addition of the Q1 2024/25 dataset.\r\nApologies for any inconvenience caused by the multiple updates which were caused by some unavoidable technical issues.\r\nThank you,\r\n \r\nKate\r\n\r\nData and Insight Analyst\r\nData Services - Digital, Data & Technology', 'user_id': '73783dc8-f5e5-461f-b56e-94ecedd6046c', 'issue_id': 10623, 'created': '2024-07-29 12:59:49.491829', 'visibility': 'visible', 'abuse_status': 'unmoderated', 'user': {'email_hash': '43e3ce422c57232dad58dc1aeeb90616', 'about': '', 'display_name': 'Data Services Support', 'name': 'dataservicessupport', 'created': '2024-06-11T07:39:15.494737', 'ckan_url': '/user/dataservicessupport', 'gravatar_url': '//gravatar.com/avatar/43e3ce422c57232dad58dc1aeeb90616?s=48', 'id': '73783dc8-f5e5-461f-b56e-94ecedd6046c', 'sysadmin': True, 'activity_streams_email_notifications': True, 'state': 'active', 'number_of_edits': 3, 'gravatar': '<img src="//gravatar.com/avatar/43e3ce422c57232dad58dc1aeeb90616?s=48&d=identicon"\n class="gravatar" width="48" height="48" alt="Gravatar" />', 'fullname': 'Data Services Support', 'number_created_packages': 0}, 'dataset_id': '240d142d-df82-4e97-b051-12371519e4e1', 'issue_number': 2, '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', 'upload_to_bigquery': 'true', 'metadata_modified': '2024-07-26T12:34:06.785006', '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}, {'encoding': 'utf-8', 'sample': '{}', 'package_id': '240d142d-df82-4e97-b051-12371519e4e1', 'datastore_active': False, 'id': 'fb0c77ba-944b-4697-9de4-b5c207e0f8fd', 'bq_table_name': 'CONSOL_PHARMACY_LIST_202324Q1', 'size': 2645634, 'title': 'Consolidated Pharmaceutical List - 2023-24 Quarter 1', 'restricted': '{"level": "public"}', 'cache_last_updated': None, 'state': 'active', 'sha256': '715da25b3b0a5bd6c6d1b2f2fb74f15a9ed4a83cce948190da28fd629b0fa110', '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': '715da25b3b0a5bd6c6d1b2f2fb74f15a9ed4a83cce948190da28fd629b0fa110', 'description': '', 'format': 'CSV', 'mimetype_inner': None, 'url_type': 'upload', 'mimetype': 'text/csv', 'cache_url': None, 'name': 'CONSOL_PHARMACY_LIST_202324Q1', 'created': '2023-08-16T10:46:11.061776', 'url': 'https://opendata.nhsbsa.net/dataset/240d142d-df82-4e97-b051-12371519e4e1/resource/fb0c77ba-944b-4697-9de4-b5c207e0f8fd/download/consol_pharmacy_list_202324q1.csv', 'last_modified': None, 'position': 3, 'revision_id': '28f6e601-eaa9-4114-afeb-ae02ebb41c24', 'resource_type': None}, {'encoding': 'utf-8', 'sample': '{}', 'package_id': '240d142d-df82-4e97-b051-12371519e4e1', 'datastore_active': False, 'id': 'bdee8bc2-70ad-4df4-beba-991d8001cee3', 'bq_table_name': 'CONSOL_PHARMACY_LIST_202324Q2', 'size': 2645112, 'title': 'Consolidated Pharmaceutical List - 2023-24 Quarter 2', 'restricted': '{"level": "public"}', 'cache_last_updated': None, 'state': 'active', 'sha256': 'fd0e3e48d72874130130a765fd5c40910cb41e1774f7e7f2889ff9da8e17ed0d', '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': 'fd0e3e48d72874130130a765fd5c40910cb41e1774f7e7f2889ff9da8e17ed0d', 'description': '', 'format': 'CSV', 'mimetype_inner': None, 'url_type': 'upload', 'mimetype': 'text/csv', 'cache_url': None, 'name': 'CONSOL_PHARMACY_LIST_202324Q2', 'created': '2023-12-05T13:46:35.732358', 'url': 'https://opendata.nhsbsa.net/dataset/240d142d-df82-4e97-b051-12371519e4e1/resource/bdee8bc2-70ad-4df4-beba-991d8001cee3/download/consol_pharmacy_list_202324q2.csv', 'last_modified': None, 'position': 4, 'revision_id': 'eabd529a-9715-4222-8099-96efa85c485c', 'resource_type': None}, {'encoding': 'utf-8', 'sample': '{}', 'package_id': '240d142d-df82-4e97-b051-12371519e4e1', 'datastore_active': False, 'id': 'b7650d35-c9e4-4302-8b85-067ddd3931a4', 'bq_table_name': 'CONSOL_PHARMACY_LIST_202324Q3', 'size': 2617832, 'title': 'Consolidated Pharmaceutical List - 2023-24 Quarter 3', 'restricted': '{"level": "public"}', 'cache_last_updated': None, 'state': 'active', 'sha256': '8c87eec38f332768c9191646061801f19b5e59926fb4b74c4a18193354cd0815', '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': '8c87eec38f332768c9191646061801f19b5e59926fb4b74c4a18193354cd0815', 'description': '', 'format': 'CSV', 'mimetype_inner': None, 'url_type': 'upload', 'mimetype': 'text/csv', 'cache_url': None, 'name': 'CONSOL_PHARMACY_LIST_202324Q3', 'created': '2024-02-22T11:52:22.440254', 'url': 'https://opendata.nhsbsa.net/dataset/240d142d-df82-4e97-b051-12371519e4e1/resource/b7650d35-c9e4-4302-8b85-067ddd3931a4/download/consol_pharmacy_list_202324q3.csv', 'last_modified': None, 'position': 5, 'revision_id': '2c9047e6-7d0c-4c5a-a243-0771b36e9903', 'resource_type': None}, {'encoding': 'utf-8', 'sample': '{}', 'package_id': '240d142d-df82-4e97-b051-12371519e4e1', 'datastore_active': False, 'id': 'd36c355a-631d-4ddb-bc34-5a0315565e12', 'bq_table_name': 'CONSOL_PHARMACY_LIST_202324Q4', 'size': 2591411, 'title': 'Consolidated Pharmaceutical List - 2023-24 Quarter 4', 'restricted': '{"level": "public"}', 'cache_last_updated': None, 'state': 'active', 'sha256': '84134b427d5d49aeda2e5e6b6723e0a4612d5500ead25a1742f007c806186687', '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': '84134b427d5d49aeda2e5e6b6723e0a4612d5500ead25a1742f007c806186687', 'description': '', 'format': 'CSV', 'mimetype_inner': None, 'url_type': 'upload', 'mimetype': 'text/csv', 'cache_url': None, 'name': 'CONSOL_PHARMACY_LIST_202324Q4', 'created': '2024-05-09T10:41:43.130090', 'url': 'https://opendata.nhsbsa.net/dataset/240d142d-df82-4e97-b051-12371519e4e1/resource/d36c355a-631d-4ddb-bc34-5a0315565e12/download/consol_pharmacy_list_202324q4.csv', 'last_modified': None, 'position': 6, 'revision_id': '96787d2f-7acd-45b1-8fbe-122cdcb03276', 'resource_type': None}, {'encoding': 'utf-8', 'sample': '{}', 'package_id': '240d142d-df82-4e97-b051-12371519e4e1', 'datastore_active': True, 'id': '60da93f7-3100-4ce1-995f-f2dcfb766949', 'bq_table_name': 'CONSOL_PHARMACY_LIST_202425Q1', 'size': 2588496, 'title': 'Consolidated Pharmaceutical List - 2024-25 Quarter 1', 'restricted': '{"allowed_users": "", "level": "public"}', 'cache_last_updated': None, 'state': 'active', 'sha256': 'cd8a0b62c4b883cb5bdcb51f60c8176a5cb80ca9d5b306aeb1186aca52a973a9', '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': 'cd8a0b62c4b883cb5bdcb51f60c8176a5cb80ca9d5b306aeb1186aca52a973a9', 'description': '', 'format': 'CSV', 'mimetype_inner': None, 'url_type': 'upload', 'mimetype': 'text/csv', 'cache_url': None, 'name': 'CONSOL_PHARMACY_LIST_202425Q1', 'created': '2024-07-26T11:42:43.812139', 'url': 'https://opendata.nhsbsa.net/dataset/240d142d-df82-4e97-b051-12371519e4e1/resource/60da93f7-3100-4ce1-995f-f2dcfb766949/download/consol_pharmacy_list_202425q1.csv', 'last_modified': '2024-07-26T11:46:05.088000', 'position': 7, 'revision_id': 'c57a4b39-619a-4a10-aef6-0e3d133954bf', 'resource_type': None}], 'num_resources': 8, '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 and information', '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': 'a2deface-a642-4ea0-9edc-ea9881862698', '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) on the last day of each quarter. 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', 'license_url': 'https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/', 'title': 'Consolidated Pharmaceutical List', 'revision_id': '100632ea-2aa5-4a4b-8e93-7388c82d61c3'}}, 'permission_labels': None} Consolidated Pharmaceutical List 1 year ago -
Consolidated Pharmaceutical List 1 year ago -
paul_westrip issue deleted Consolidated Pharmaceutical List
1 year ago
Consolidated Pharmaceutical List
- Followers
- 13
Dispensing Contractors
Datasets with a focus on dispensing contractors related data and information
Licence
-
6 days ago -
6 days ago -
6 days ago -
6 days ago -
6 days ago -
6 days ago -
6 days ago -
6 days ago -
6 days ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
1 week ago -
2 weeks ago -
2 weeks ago -
Consolidated Pharmaceutical List 3 weeks ago -
Consolidated Pharmaceutical List 1 year ago -
Consolidated Pharmaceutical List 1 year ago -
Consolidated Pharmaceutical List 1 year ago -
1 year ago
