path: root/SSP Spider.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "f4cafca6-af12-46ea-8de9-1ba36d910113",
   "metadata": {},
   "source": [
    "# SSP Spider and Notification Prototyping\n",
    "\n",
    "Once again using Jupyter to prototype a solution. This uses the following python packages (installable via pip):\n",
    "\n",
    "- Requests (HTTP)\n",
    "- BS4 (HTML parsing)\n",
    "- DiskCache (Results Cache)\n",
    "\n",
    "If we only wanted to pull the data down via a notebook we could use pandas and just run something like:\n",
    "\n",
    "```python\n",
    "active_ssps = pd.read_html(ssp_url)[0]\n",
    "expired_ssps = pd.read_html(ssp_url)[1]\n",
    "```\n",
    "\n",
    "We could write that to a CSV and have a script run with the CSV as an argument. The spider approach is slightly more complex but 'cleaner'. Having said that, I'm not going to judge someone doing the quick and dirty when the Pandas libraries are *that good* at parsing HTML tables."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "906a276b-e291-4857-83a3-0d0d6367f52b",
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests, pprint\n",
    "\n",
    "from diskcache import Index\n",
    "from bs4 import BeautifulSoup\n",
    "from unicodedata import normalize\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "83ce546b-dbc4-4bfe-b307-201333906a72",
   "metadata": {},
   "outputs": [],
   "source": [
    "site = 'https://www.nhsbsa.nhs.uk'\n",
    "base_url = f\"{site}/pharmacies-gp-practices-and-appliance-contractors/serious-shortage-protocols-ssps\"\n",
    "active_ssps = Index('ssps/active')\n",
    "expired_ssps = Index('ssps/expired')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "191f87c2-97bc-41d4-8198-08d97d1fe4ca",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "200"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "request = requests.get(base_url, headers = {'User-agent': 'friendly_python'})\n",
    "request.status_code"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "c92f11e8-9997-47a9-bf7d-1f6a078ab400",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = request.text\n",
    "soup = BeautifulSoup(data, 'html.parser')\n",
    "tables = soup.find_all('table')\n",
    "len(tables)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "24674d47-2ac8-4a99-935d-9828e7d1b9db",
   "metadata": {},
   "source": [
    "## Active SSPs\n",
    "\n",
    "Data we want to capture includes:\n",
    "\n",
    "- SSP Name/Ref\n",
    "- Link to SSP Name/Ref\n",
    "- Start date\n",
    "- End date\n",
    "- If this was reactivated\n",
    "- Supporting guidance\n",
    "- Link to supporting guidance PDF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "811f0ea5-9078-49a7-b180-c1338f9c8209",
   "metadata": {},
   "outputs": [],
   "source": [
    "# I'm using normalize here because some of the drug names use funky Unicode\n",
    "\n",
    "def extract_table(table, ssp_list):\n",
    "    new_ssps = []\n",
    "    for row in table.tbody.find_all('tr'):\n",
    "        columns = row.find_all('td')\n",
    "        if(columns != []):\n",
    "            # SSP Name/Ref\n",
    "            ssp_name = normalize('NFKD',columns[0].text.strip())\n",
    "            ssp_link = normalize('NFKD',f\"{site}{columns[0].find('a').get('href')}\")\n",
    "            # Start and End date\n",
    "            dates = normalize('NFKD',columns[1].text.strip())\n",
    "            ds = dates.split('\\n')[0].split('to')\n",
    "            #print(f\"Splitting dates: [{dates}] | ds len: {len(ds)}\")\n",
    "            start_date = ds[0].strip()\n",
    "            end_date = ds[1].strip()\n",
    "            # Guidance\n",
    "            guidance_name = normalize('NFKD',columns[2].text.strip())\n",
    "            guidance_link = normalize('NFKD',f\"{site}{columns[2].find('a').get('href')}\")\n",
    "            support = columns[2].text.strip()\n",
    "            item = {\n",
    "                'name': ssp_name,\n",
    "                'url': ssp_link,\n",
    "                'start_date': start_date,\n",
    "                'end_date': end_date,\n",
    "                'guidance': guidance_name,\n",
    "                'guidance_url': guidance_link,\n",
    "            }\n",
    "            if not ssp_link in ssp_list:\n",
    "                ssp_list[ssp_link] = item\n",
    "                new_ssps.append(item)\n",
    "            #print(item)\n",
    "    return new_ssps"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "4f11bfdb-004e-45d0-98b1-3226126781fd",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "New Active SSPs\n",
      "{'name': 'SSP061 Creon® 25000 capsules (PDF:193KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2024-05/SSP061%20Creon%2025000%20restriction%20FINAL%2023052024%20-%20Signed.pdf',\n",
      " 'start_date': '24 May 2024',\n",
      " 'end_date': '22 November 2024',\n",
      " 'guidance': 'Creon® 25000 capsules supporting guidance plus Q&A (PDF:125KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2024-05/Endorsement%20Guidance%20SSP061%20Creon%2025000%20restriction%20FINAL%2024052024.pdf'}\n",
      "{'name': 'SSP060 Creon® 10000 capsules (PDF:193KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2024-05/SSP060%20Creon%2010000%20restriction%20FINAL%2023052024%20-%20Signed.pdf',\n",
      " 'start_date': '24 May 2024',\n",
      " 'end_date': '22 November 2024',\n",
      " 'guidance': 'Creon® 10000 capsules supporting guidance plus Q&A (PDF:123KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2024-05/Endorsement%20Guidance%20SSP060%20Creon%2010000%20restriction%20FINAL%2024052024.pdf'}\n",
      "{'name': 'SSP054 Clarithromycin 250mg/5ml oral suspension (PDF:150KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-04/SSP054%20Clarithromycin%20250mg-5ml%20oral%20suspension%20final%2006042023.pdf',\n",
      " 'start_date': '22 May 2024',\n",
      " 'end_date': '21 June 2024',\n",
      " 'guidance': 'Clarithromycin 250mg/5ml oral suspension supporting guidance '\n",
      "             'plus Q&A (PDF:115KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-04/Endorsement%20guidance%20Clarithromycin%20250mg-5ml%20oral%20susp.pdf'}\n",
      "{'name': 'SSP053 Clarithromycin 125mg/5ml oral suspension (PDF:147KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-04/SSP053%20Clarithromycin%20125mg-5ml%20oral%20suspension%20final%2006042023.pdf',\n",
      " 'start_date': '22 May 2024',\n",
      " 'end_date': '21 June 2024',\n",
      " 'guidance': 'Clarithromycin 125mg/5ml oral suspension supporting guidance '\n",
      "             'plus Q&A (PDF:116KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-04/Endorsement%20guidance%20Clarithromycin%20125mg-5ml%20oral%20susp.pdf'}\n"
     ]
    }
   ],
   "source": [
    "actives = extract_table(tables[0], active_ssps)\n",
    "if len(actives) > 0:\n",
    "    print(\"New Active SSPs\")\n",
    "    for i in actives:\n",
    "        pprint.pp(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "c3c63922-edf3-46bc-a692-609071d2c310",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Newly Expired SSPs\n",
      "{'name': 'SSP059 Monomil® XL 60mg tablets (PDF:164KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2024-03/Annex%20A%20SSP059%20Monomil%20XL%2060mg%20signed%2026032024.pdf',\n",
      " 'start_date': '26 Mar 2024',\n",
      " 'end_date': '07 Jun 2024',\n",
      " 'guidance': 'Monomil® XL 60mg tablets supporting guidance plus Q&A '\n",
      "             '(PDF:150KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2024-03/Endorsement%20guidance%20SSP059%20Monomil%20XL%2060mg%2026032024.pdf'}\n",
      "{'name': 'SSP058 Jext® 300micrograms/0.3ml (1 in 1000) solution for injection '\n",
      "         'auto-injector pen (PDF:200KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-08/SSP058%20Jext%20300mcg%20autoinjector.pdf',\n",
      " 'start_date': '21 Aug 2023',\n",
      " 'end_date': '27 Oct 2023',\n",
      " 'guidance': 'Jext® 300mcg auto-injector supporting guidance plus Q&A '\n",
      "             '(PDF:122KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-08/Endorsement%20guidance%20SSP058%20Jext%20300mcg%20autoinjector.pdf'}\n",
      "{'name': 'SSP057 Estradot® 100mcg patches (PDF:218KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-08/SSP057%20Estradot%20100mcg%20patches.pdf',\n",
      " 'start_date': '21 Aug 2023',\n",
      " 'end_date': '08 Dec 2023',\n",
      " 'guidance': 'Estradot® 100mcg patches supporting guidance plus Q&A '\n",
      "             '(PDF:117KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-08/Endorsement%20guidance%20SSP057%20Estradot%20100%20patches.pdf'}\n",
      "{'name': 'SSP056 Utrogestan® 100mg capsules (PDF:193KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-05/SSP056%20Utrogestan%20100mg%20caps.pdf',\n",
      " 'start_date': '19 May 2023',\n",
      " 'end_date': '29 Sep 2023',\n",
      " 'guidance': 'Utrogestan® 100mg capsules supporting guidance plus Q&A '\n",
      "             '(PDF:123KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-06/Endorsement%20guidance%20SSP056%20Utrogestan%20restriction%2002062023.pdf'}\n",
      "{'name': 'SSP055 Estradot® 75mcg patches (PDF:216KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-04/SSP055%20Estradot%2075mcg%20patches.pdf',\n",
      " 'start_date': '13 Apr 2023',\n",
      " 'end_date': '5 May 2023',\n",
      " 'guidance': 'Estradot® 75mcg patches supporting guidance plus Q&A (PDF:114KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-04/Endorsement%20guidance%20SSP055%20Estradot%2075%20patches.pdf'}\n",
      "{'name': 'SSP052 Progynova® TS 100mcg patches (PDF:217KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-03/SSP052%20Progynova%20100mcg%20patches%20FINAL%2028032023.pdf',\n",
      " 'start_date': '28 Mar 2023',\n",
      " 'end_date': '8 Sep 2023',\n",
      " 'guidance': 'Progynova® TS 100mcg patches supporting guidance plus Q&A '\n",
      "             '(PDF:133KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-03/Progynova%20endorsement%20guidance%2028032023.pdf'}\n",
      "{'name': 'SSP051 Paracetamol 240mg suppositories (PDF:142KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-03/SSP051%20Paracetamol%20240mg%20suppositories%2016022023.pdf',\n",
      " 'start_date': '17 Mar 2023',\n",
      " 'end_date': '12 May 2023',\n",
      " 'guidance': 'Paracetamol 240mg suppositories supporting guidance plus Q&A '\n",
      "             '(PDF:111KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-03/Endorsement%20guidance%20SSP051%20Paracetamol%20240mg%20suppositories%2016032023.pdf'}\n",
      "{'name': 'SSP050 Paracetamol 120mg suppositories (PDF:143KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-02/SSP050%20Paracetamol%20120mg%20suppositories%2016022023.pdf',\n",
      " 'start_date': '16 Feb 2023',\n",
      " 'end_date': '12 May 2023',\n",
      " 'guidance': 'Paracetamol 120mg suppositories supporting guidance plus Q&A '\n",
      "             '(PDF:111KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-02/Endorsement%20guidance%20SSP050%20Paracetamol%20120mg%20suppositories%2016022023.pdf'}\n",
      "{'name': 'SSP049 Estradot® 100mcg patches (PDF:205KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-01/SSP049%20Estradot%20100mcg%20patches%20FINAL%2023012023.pdf',\n",
      " 'start_date': '25 Jan 2023',\n",
      " 'end_date': '\\u200b\\u200b\\u200b\\u200b\\u200b\\u200b17 March 2023',\n",
      " 'guidance': 'Estradot® 100mcg supporting guidance plus Q&A (PDF:114KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-01/Endorsement%20guidance%20SSP049%20Estradot%20100%2025012023.pdf'}\n",
      "{'name': 'SSP048 Estradot® 50mcg patches (PDF:205KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-01/SSP048%20Estradot%2050mcg%20patches%20FINAL%2023012023.pdf',\n",
      " 'start_date': '25 Jan 2023',\n",
      " 'end_date': '24 February 2023',\n",
      " 'guidance': 'Estradot® 50mcg supporting guidance plus Q&A (PDF:113KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-01/Endorsement%20guidance%20SSP048%20Estradot%2050%2025012023.pdf'}\n",
      "{'name': 'SSP047 Phenoxymethylpenicillin 250mg tablets (PDF:272KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-01/SSP047~1.PDF',\n",
      " 'start_date': '16 Dec 2022',\n",
      " 'end_date': '12 May 2023',\n",
      " 'guidance': 'Phenoxymethylpenicillin 250mg tablets supporting guidance plus '\n",
      "             'Q&A (PDF:238KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-01/24012023%20Endorsement%20guidance%20SSP047%20Penicillin%20250mg%20tabs.pdf'}\n",
      "{'name': 'SSP046 Phenoxymethylpenicillin 250mg/5ml oral solution sugar free '\n",
      "         '(PDF:274KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-01/SSP046~1.PDF',\n",
      " 'start_date': '16 Dec 2022',\n",
      " 'end_date': '12 May 2023',\n",
      " 'guidance': 'Phenoxymethylpenicillin 250mg/5ml sugar free supporting guidance '\n",
      "             'plus Q&A (PDF:240KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-01/240120~4.PDF'}\n",
      "{'name': 'SSP045 Phenoxymethylpenicillin 250mg/5ml oral solution (PDF:274KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-01/SSP045~1.PDF',\n",
      " 'start_date': '16 Dec 2022',\n",
      " 'end_date': '12 May 2023',\n",
      " 'guidance': 'Phenoxymethylpenicillin 250mg/5ml supporting guidance plus Q&A '\n",
      "             '(PDF:237KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-01/240120~3.PDF'}\n",
      "{'name': 'SSP044 Phenoxymethylpenicillin 125mg/5ml oral solution sugar free '\n",
      "         '(PDF:275KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-01/SSP044~1.PDF',\n",
      " 'start_date': '16 Dec 2022',\n",
      " 'end_date': '12 May 2023',\n",
      " 'guidance': 'Phenoxymethylpenicillin 125mg/5ml sugar free supporting guidance '\n",
      "             'plus Q&A (PDF:239KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-01/240120~2.PDF'}\n",
      "{'name': 'SSP043 Phenoxymethylpenicillin 125mg/5ml oral solution (PDF:273KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-01/SSP043~1.PDF',\n",
      " 'start_date': '16 Dec 2022',\n",
      " 'end_date': '12 May 2023',\n",
      " 'guidance': 'Phenoxymethylpenicillin 125mg/5ml supporting guidance plus Q&A '\n",
      "             '(PDF:237KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2023-01/240120~1.PDF'}\n",
      "{'name': 'SSP042 Phenoxymethylpenicillin 250mg/5ml oral solution (PDF:143KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-12/SSP042%20Phenoxymethylpenicillin%20250mg-5ml%20oral%20solution%201.1%2020122022.pdf',\n",
      " 'start_date': '15 Dec 2022',\n",
      " 'end_date': '12 May 2023',\n",
      " 'guidance': 'Phenoxymethylpenicillin 250mg/5ml supporting guidance plus Q&A '\n",
      "             '(PDF:123KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-12/Endorsement%20guidance%20SSP042%20Penicillin%20250mg-5ml%20oral%20soln.pdf'}\n",
      "{'name': 'SSP041 Phenoxymethylpenicillin 250mg/5ml oral solution sugar free '\n",
      "         '(PDF:145KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-12/SSP041%20Phenoxymethylpenicillin%20250mg-5ml%20oral%20solution%20sugar%20free%201.1%2020122022.pdf',\n",
      " 'start_date': '15 Dec 2022',\n",
      " 'end_date': '12 May 2023',\n",
      " 'guidance': 'Phenoxymethylpenicillin 250mg/5ml sugar free supporting guidance '\n",
      "             'plus Q&A (PDF:128KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-12/Endorsement%20guidance%20SSP041%20Penicillin%20250mg-5ml%20oral%20soln%20SF.pdf'}\n",
      "{'name': 'SSP040 Phenoxymethylpenicillin 125mg/5ml oral solution sugar free '\n",
      "         '(PDF:138KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-12/SSP040%20Phenoxymethylpenicillin%20125mg-5ml%20oral%20solution%20sugar%20free%201.1%2020122022.pdf',\n",
      " 'start_date': '15 Dec 2022',\n",
      " 'end_date': '12 May 2023',\n",
      " 'guidance': 'Phenoxymethylpenicillin 125mg/5ml sugar free supporting guidance '\n",
      "             'plus Q&A (PDF:116KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-12/Endorsement%20guidance%20SSP040%20Penicillin%20125mg-5ml%20oral%20soln%20SF.pdf'}\n",
      "{'name': 'SSP039 atorvastatin (Lipitor®)20mg chewable tablets (PDF:150KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-11/Annex%20B%20-%20SSP%20form%20for%20atorvastatin%2020mg%20chewable%20tabs%20FINAL%2023112022.pdf',\n",
      " 'start_date': '23 Nov 2022',\n",
      " 'end_date': '03 Feb 2023',\n",
      " 'guidance': 'Atorvastatin supporting guidance plus Q&A (PDF:118KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-11/Endorsement%20guidance%20SSP039%20Atorvastatin%2020mg%20Chewable%2022112022.pdf'}\n",
      "{'name': 'SSP038 Estraderm MX® 75mcg patches substitution (PDF:214KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-11/Annex%20B%20SSP038%20Estraderm%20MX%2075%20mcg%20patches%20FINAL%2015112022.pdf',\n",
      " 'start_date': '15 Nov 2022',\n",
      " 'end_date': '27 Jan 2023',\n",
      " 'guidance': 'Estraderm MX® 75mcg supporting guidance plus Q&A (PDF:114KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-11/Endorsement%20guidance%20SSP038%20Estraderm%20MX%2075%2015112022.pdf'}\n",
      "{'name': 'SSP037 Estraderm MX® 50mcg patches substitution (PDF:214KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-11/Annex%20A%20SSP037%20Estraderm%20MX%2050%20mcg%20patches%20FINAL%2015112022.pdf',\n",
      " 'start_date': '15 Nov 2022',\n",
      " 'end_date': '13 Jan 2023',\n",
      " 'guidance': 'Estraderm MX® 50mcg supporting guidance plus Q&A (PDF:114KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-11/Endorsement%20guidance%20SSP037%20Estraderm%20MX%2050%2015112022.pdf'}\n",
      "{'name': 'SSP036 Estraderm MX® 100mcg patches (PDF:214KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-09/SSP036%20Estraderm%20MX%20100mcg%20patches%20ANNEX%20B%20FINAL%2006092022.pdf',\n",
      " 'start_date': '08 Sep 2022',\n",
      " 'end_date': '27 Jan 2023',\n",
      " 'guidance': 'Estraderm MX® 100mcg supporting guidance plus Q&A (PDF:115KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-09/Endorsement%20guidance%20SSP036%20Estraderm%20MX%20100%2007092022.pdf'}\n",
      "{'name': 'SSP035 Estraderm MX® 25mcg patches (PDF:213KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-09/SSP035%20Estraderm%20MX%2025mcg%20patches%20ANNEX%20A%20FINAL%2006092022.pdf',\n",
      " 'start_date': '08 Sep 2022',\n",
      " 'end_date': '14 Oct 2022',\n",
      " 'guidance': 'Estraderm MX® 25mcg supporting guidance plus Q&A (PDF:114KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-09/Endorsement%20guidance%20SSP035%20Estraderm%20MX%2025%2007092022.pdf'}\n",
      "{'name': 'SSP034 Combisal® 125mcg/25mcg inhalers (PDF:146KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-07/SSP034%20Combisal%20125mcg-25mcg%20inhaler%2021072022.pdf',\n",
      " 'start_date': '22 Jul 2022',\n",
      " 'end_date': '7 Oct 2022',\n",
      " 'guidance': 'Combisal® 125mcg/25mcg inhalers supporting guidance plus Q&A '\n",
      "             '(PDF:153KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-07/Endorsement%20guidance%20SSP034%20Combisal%2028072022%20FINAL.pdf'}\n",
      "{'name': 'SSP033 Paracetamol 120mg suppositories (PDF:139KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/SSP033%20Paracetamol%20suppositories%2030052022.pdf',\n",
      " 'start_date': '31 May 2022',\n",
      " 'end_date': '26 Aug 2022',\n",
      " 'guidance': 'Paracetamol 120mg suppositories supporting guidance plus Q&A '\n",
      "             '(PDF:111KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/Endorsement%20guidance%20SSP033%20Paracetamol%20120mg%20suppositories%2031052022.pdf'}\n",
      "{'name': 'SSP032 Atorvastatin (Lipitor®) 10mg chewable tablets (PDF:145KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/SSP032%20Atorvastatin%2010mg%20chewable%20tabs%2031052022.pdf',\n",
      " 'start_date': '31 May 2022',\n",
      " 'end_date': '\\u200b\\u200b\\u200b12 May 2023',\n",
      " 'guidance': 'Atorvastatin (Lipitor®) 10mg chewable tablets supporting '\n",
      "             'guidance plus Q&A (PDF:117KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-06/Endorsement%20guidance%20SSP032%20Atorvastatin%20Chewable%2007062022.pdf'}\n",
      "{'name': 'SSP031 Estradiol (Sandrena®) 0.5mg and 1mg gel sachets substitution '\n",
      "         'and restriction (PDF:751KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/SSP031%20Sandrena%20Substitution%20and%20Restriction.pdf',\n",
      " 'start_date': '19 May 2022',\n",
      " 'end_date': '\\u200b\\u200b\\u200b\\u200b\\u200b\\u200b12 May 2023',\n",
      " 'guidance': 'Sandrena® supporting guidance plus Q&A (PDF:185KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/Endorsement%20guidance%20SSP031%20Sandrena%20substitution%20and%20restriction%2023052022.pdf'}\n",
      "{'name': 'SSP030 Estradiol (Sandrena®) 0.5mg and 1mg gel sachets substitution '\n",
      "         '(PDF:751KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/SSP030%20Sandrena%20Substitution.pdf',\n",
      " 'start_date': '19 May 2022',\n",
      " 'end_date': '\\u200b\\u200b\\u200b\\u200b\\u200b\\u200b12 May 2023',\n",
      " 'guidance': 'Sandrena® supporting guidance plus Q&A (PDF:183KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/Endorsement%20guidance%20SSP030%20Sandrena%20substitution%2023052022.pdf'}\n",
      "{'name': 'SSP029 Estradiol (Sandrena®) 0.5mg and 1mg gel sachets restriction '\n",
      "         '(PDF:600KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/SSP029%20Sandrena%20Restriction.pdf',\n",
      " 'start_date': '19 May 2022',\n",
      " 'end_date': '12 May 2023',\n",
      " 'guidance': 'Sandrena® supporting guidance plus Q&A (PDF:130KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/Endorsement%20guidance%20SSP029%20Sandrena%20restriction%2023052022.pdf'}\n",
      "{'name': 'SSP028 Estradiol (Lenzetto®)1.53mg/dose transdermal spray '\n",
      "         'substitution and restriction (PDF:749KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/SSP028%20Lenzetto%20Substitution%20and%20Restriction.pdf',\n",
      " 'start_date': '19 May 2022',\n",
      " 'end_date': '13 January 2023',\n",
      " 'guidance': 'Lenzetto® supporting guidance plus Q&A (PDF:147KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/Endorsement%20guidance%20SSP028%20Lenzetto%20substitution%20and%20restriction%2023052022.pdf'}\n",
      "{'name': 'SSP027 Estradiol (Lenzetto®)1.53mg/dose transdermal spray '\n",
      "         'substitution (PDF:748KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/SSP027%20Lenzetto%20Substitution.pdf',\n",
      " 'start_date': '19 May 2022',\n",
      " 'end_date': '13 January 2023',\n",
      " 'guidance': 'Lenzetto® supporting guidance plus Q&A (PDF:146KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/Endorsement%20guidance%20SSP027%20Lenzetto%20substitution%2023052022.pdf'}\n",
      "{'name': 'SSP026 Estradiol (Lenzetto®)1.53mg/dose transdermal spray '\n",
      "         'restriction (PDF:601KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/SSP026%20Lenzetto%20restriction.pdf',\n",
      " 'start_date': '19 May 2022',\n",
      " 'end_date': '13 January 2023',\n",
      " 'guidance': 'Lenzetto® supporting guidance plus Q&A (PDF:128KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/Endorsement%20guidance%20SSP026%20Lenzetto%20restriction%2023052022.pdf'}\n",
      "{'name': 'SSP025 Estriol  (Ovestin® 1mg cream) 0.1% cream substitution and '\n",
      "         'restriction (PDF:228KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-07/SSP025%20Ovestin%20substitution%20and%20restriction%20v1.1.pdf',\n",
      " 'start_date': '19 May 2022',\n",
      " 'end_date': '30 Nov 2022',\n",
      " 'guidance': 'Ovestin® supporting guidance plus Q&A (PDF:152KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-07/Endorsement%20guidance%20SSP025%20Ovestin%20substitution%20and%20restriction%2028072022.pdf'}\n",
      "{'name': 'SSP024 Estriol  (Ovestin® 1mg cream) 0.1% cream substitution '\n",
      "         '(PDF:226KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-07/SSP024%20Ovestin%20cream%20substitution%20v1.1.pdf',\n",
      " 'start_date': '19 May 2022',\n",
      " 'end_date': '30 Nov 2022',\n",
      " 'guidance': 'Ovestin® supporting guidance plus Q&A (PDF:133KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-07/Endorsement%20guidance%20SSP024%20Ovestin%20substitution%2028072022.pdf'}\n",
      "{'name': 'SSP023 Estradiol (Oestrogel® Pump-Pack 0.06% gel) 0.06% gel '\n",
      "         '(750microgram per actuation) substitution and restriction '\n",
      "         '(PDF:751KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/SSP023%20Oestrogel%20substitution%20and%20Restriction%20Amendment.pdf',\n",
      " 'start_date': '19 May 2022',\n",
      " 'end_date': '30 Nov 2022',\n",
      " 'guidance': 'Oestrogel® supporting guidance plus Q&A (PDF:150KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/Endorsement%20guidance%20SSP023%20Oestrogel%20substitution%20and%20restriction%20v2%2030052022.pdf'}\n",
      "{'name': 'SSP022 Estradiol (Oestrogel® Pump-Pack 0.06% gel) 0.06% gel '\n",
      "         '(750microgram per actuation) substitution (PDF:750KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/SSP022%20Oestrogel%20Substitution%20Amendment.pdf',\n",
      " 'start_date': '19 May 2022',\n",
      " 'end_date': '30 Nov 2022',\n",
      " 'guidance': 'Oestrogel® supporting guidance plus Q&A (PDF:149KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/Endorsement%20guidance%20SSP022%20Oestrogel%20substitution%20v2%2030052022.pdf'}\n",
      "{'name': 'SSP021 Premique® low dose 0.3mg/1.5mg modified-release tablets '\n",
      "         '(PDF:166KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-04/SSP021%20-%20Premique%20low%20dose%200.3mg.1.5mg%20modified%20release%20tablets.pdf',\n",
      " 'start_date': '29 Apr 2022',\n",
      " 'end_date': '29 Jul 2022',\n",
      " 'guidance': 'Premique® low dose supporting guidance plus Q&A (PDF:122KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/Endorsement%20guidance%20SSP021%20Premique%20Low%20Dose%20restriction%2030052022.pdf'}\n",
      "{'name': 'SSP020 Ovestin® 1mg  cream restriction (PDF:166KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-04/SSP020%20-%20Ovestin%201mg%20cream.pdf',\n",
      " 'start_date': '29 Apr 2022',\n",
      " 'end_date': '30 Nov 2022',\n",
      " 'guidance': 'Ovestin® supporting guidance plus Q&A (PDF:122KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/Endorsement%20guidance%20SSP020%20Ovestin%20restriction%2030052022.pdf'}\n",
      "{'name': 'SSP019 Oestrogel®  Pump-Pack 0.06% gel restriction (PDF:167KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-04/SSP019%20-%20Oestrogel%20pump-pack%20750mcg%20actuation%20gel.pdf',\n",
      " 'start_date': '29 Apr 2022',\n",
      " 'end_date': '30 Nov 2022',\n",
      " 'guidance': 'Oestrogel® supporting guidance plus Q&A (PDF:125KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-05/Endorsement%20guidance%20SSP019%20Oestrogel%20restriction%2030052022.pdf'}\n",
      "{'name': 'SSP018 Salazopyrin® 500mg tablets (PDF:244KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-03/SSP018%20-%20Salazopyrin%20500mg%20tablets.pdf',\n",
      " 'start_date': '16 Mar 2022',\n",
      " 'end_date': '25 Mar 2022',\n",
      " 'guidance': 'Salazopyrin® supporting guidance plus Q&A (PDF:112KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-03/Supporting%20endorsement%20guidance%20Salazopyrin%20500mg%20tablets%2010032022.pdf'}\n",
      "{'name': 'SSP017 Atorvastatin (Lipitor®) 20mg chewable tablets (PDF:122KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-02/SSP017%20-%20atorvastatin%2020mg%20chewable%20tabs%20FINAL%2015022022.pdf',\n",
      " 'start_date': '15 Feb 2022',\n",
      " 'end_date': '5 Apr 2022',\n",
      " 'guidance': 'Atorvastatin supporting guidance plus Q&A (PDF:111KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-02/Supporting%20endorsement%20guidance%20SSP017%20atorvastatin%2020mg%20chewable%20tablets%2014022022.pdf'}\n",
      "{'name': 'SSP016 Atorvastatin (Lipitor®) 10mg chewable tablets (PDF:123KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-02/SSP016%20-%20atorvastatin%2010mg%20chewable%20tabs%20FINAL%2015022022.pdf',\n",
      " 'start_date': '15 Feb 2022',\n",
      " 'end_date': '18 Mar 2022',\n",
      " 'guidance': 'Atorvastatin supporting guidance plus Q&A (PDF:111KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-02/Supporting%20endorsement%20guidance%20SSP016%20atorvastatin%2010mg%20chewable%20tablets%2014022022.pdf'}\n",
      "{'name': 'SSP015 Paracetamol 120mg and 240mg suppositories (PDF:124KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-01/SSP%20form%20paracetamol%20suppositories%20FINAL%20250122_1.pdf',\n",
      " 'start_date': '25 Jan 2022',\n",
      " 'end_date': '4 Mar 2022',\n",
      " 'guidance': 'Paracetamol supporting guidance plus Q&A (PDF:111KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-01/SSP015%20endorsement%20guidance%20250122_1.pdf'}\n",
      "{'name': 'SSP014 Salazopyrin® 500mg EN tablets (PDF:160KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2021-11/SSP014%20Salazopyrin%20EN-Tabs%20500mg.pdf',\n",
      " 'start_date': '28 Feb 2022',\n",
      " 'end_date': '1 Apr 2022',\n",
      " 'guidance': 'Salazopyrin® EN supporting guidance plus Q&A (PDF:111KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-02/SSP014%20Reactivated%20Supporting%20endorsement%20guidance%20Salazopyrin%20EN-Tabs%20500mg.pdf'}\n",
      "{'name': 'SSP013 Atorvastatin (Lipitor®) 20mg chewable tablets (PDF:211KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2021-11/Annex%20A%20-%20SSP%20form%20for%20atorvastatin%20FINAL.pdf',\n",
      " 'start_date': '18 Nov 2021',\n",
      " 'end_date': '12 Jan 2022',\n",
      " 'guidance': 'Atorvastatin supporting guidance plus Q&A (PDF: 134KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2021-11/Supporting%20endorsement%20guidance%20atorvastatin%2020mg%20chewable%20tabs%20181121.pdf'}\n",
      "{'name': 'SSP012 Estradot®  75microgram patches (PDF:204KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2021-04/SSP012%20Estradot%2075%20microgram%20patches.pdf',\n",
      " 'start_date': '29 Apr 2021',\n",
      " 'end_date': '11 Jun 2021',\n",
      " 'guidance': 'Estradot®  supporting guidance plus Q&A (PDF: 120KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2021-05/Updated%20SSP012%20Supporting%20endorsement%20guidance%20Estradot%2075mcg%20patches.pdf'}\n",
      "{'name': 'SSP011 Competact 15mg/850mg tablets (PDF:170KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2021-03/SSP%20Competact%2015mg-850mg%20tablets.pdf',\n",
      " 'start_date': '24 Mar 2021',\n",
      " 'end_date': '14 May 2021',\n",
      " 'guidance': 'Competact supporting guidance plus Q&A (PDF: 113KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2021-03/Supporting%20endorsement%20guidance%20competact%2015mg-850mg%20tabs.pdf'}\n",
      "{'name': 'SSP010 Levothyroxine 12.5microgram tablets (PDF:143KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2021-02/SSP010%20Levothyroxine%2012.5microgram%20tablets.pdf',\n",
      " 'start_date': '3 Feb 2021',\n",
      " 'end_date': '1 Apr 2021',\n",
      " 'guidance': 'Levothyroxine supporting guidance plus Q&A (PDF: 111KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2021-02/SSP010%20Supporting%20endorsement%20guidance%20levothyroxine%2012.5mcg%20tabsv2.pdf'}\n",
      "{'name': 'SSP009 Fluoxetine 40mg capsules (PDF:139KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2021-01/SSP009%20fluoxetine%2040mg%20capsules.pdf',\n",
      " 'start_date': '29 Jan 2021',\n",
      " 'end_date': '17 May 2021',\n",
      " 'guidance': 'Fluoxetine supporting guidance plus Q&A (PDF: 111KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2021-01/SSP009%20Supporting%20endorsement%20guidance%20fluoxetine%2040mg%20capsv2.pdf'}\n",
      "{'name': 'SSP008 Salazopyrin 500mg EN tablets (PDF:151KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2020-10/SSP008%20Salazopyrin%20EN-Tabs%20500mg.pdf',\n",
      " 'start_date': '20 Oct 2020',\n",
      " 'end_date': '8 Mar 2021',\n",
      " 'guidance': 'Salazopyrin EN supporting guidance plus Q&A (PDF: 130KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2020-10/SSP008%20Supporting%20endorsement%20guidance%20Salazopyrin%20EN-Tabs%20500mg.pdf'}\n",
      "{'name': 'SSP007 Fluoxetine 30mg capsules (PDF:144KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2020-10/SSP007%20Fluoxetine%2030mg%20capsules.pdf',\n",
      " 'start_date': '20 Oct 2020',\n",
      " 'end_date': '28 Jul 2021',\n",
      " 'guidance': 'Fluoxetine supporting guidance plus Q&A (PDF: 142KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2021-05/Updated%20SSP007%20Supporting%20endorsement%20guidance%20fluoxetine%2030mg%20capsules.pdf'}\n",
      "{'name': 'SSP06 Fluoxetine 40mg capsules (PDF:135KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2020-05/SSP%20Fluoxetine%2040mg%20capsules%20final%2020052020.pdf',\n",
      " 'start_date': '20 May 2020',\n",
      " 'end_date': '2 Oct 2020',\n",
      " 'guidance': 'Fluoxetine supporting guidance plus Q&A (PDF: 111KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2020-05/SSP06%20Supporting%20endorsement%20guidance%20fluoxetine%2040mg%20caps.pdf'}\n",
      "{'name': 'SSP005 Fluoxetine 10mg tablets (PDF:134KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2020-03/SSP%20Fluoxetine%2010mg%20tablets%20final%20-%20signed.pdf',\n",
      " 'start_date': '12 Mar 2020',\n",
      " 'end_date': '31 March 2023',\n",
      " 'guidance': 'Fluoxetine supporting guidance plus Q&A (PDF: 107KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2022-02/Supporting%20endorsement%20guidance%20fluoxetine%2010mg%20tablets%2001022022.pdf'}\n",
      "{'name': 'SSP04 Haloperidol  (Serenace) 500 microgram (mcg) capsules '\n",
      "         '(PDF:107KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2019-12/SSP%20Haloperidol%20500%20microgram%20capsules.pdf',\n",
      " 'start_date': '23 Dec 2019',\n",
      " 'end_date': '23 Mar 2020',\n",
      " 'guidance': 'Haloperidol supporting guidance plus Q&A (PDF:125KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2019-12/Haloperidol%20supporting%20endorsement%20guidance.pdf'}\n",
      "{'name': 'SSP03 Fluoxetine 40mg capsules (PDF:131KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2019-10/SSP%20Fluoxetine%2040mg%20capsules.pdf',\n",
      " 'start_date': '3 Oct 2019',\n",
      " 'end_date': '20 Nov 2019',\n",
      " 'guidance': 'Fluoxetine supporting endorsement guidance (PDF: 139KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2019-10/Supporting%20endorsement%20guidance%20for%20fluoxetine%20SSPs.pdf'}\n",
      "{'name': 'SSP02 Fluoxetine 30mg capsules (PDF:124KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2019-11/SSP%20Fluoxetine%2030mg%20capsule%20201119%20-%20TM_.pdf',\n",
      " 'start_date': '3 Oct 2019',\n",
      " 'end_date': '18 Dec 2019',\n",
      " 'guidance': 'Fluoxetine supporting endorsement guidance (PDF: 139KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2019-10/Supporting%20endorsement%20guidance%20for%20fluoxetine%20SSPs.pdf'}\n",
      "{'name': 'SSP01 Fluoxetine 10mg capsules (PDF:151KB)',\n",
      " 'url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2019-10/SSP%20Fluoxetine%2010mg%20capsules_0.pdf',\n",
      " 'start_date': '3 Oct 2019',\n",
      " 'end_date': '25 Oct 2019',\n",
      " 'guidance': 'Fluoxetine supporting endorsement guidance (PDF: 139KB)',\n",
      " 'guidance_url': 'https://www.nhsbsa.nhs.uk/sites/default/files/2019-10/Supporting%20endorsement%20guidance%20for%20fluoxetine%20SSPs.pdf'}\n"
     ]
    }
   ],
   "source": [
    "# And Expired SSPs\n",
    "expireds = extract_table(tables[1], expired_ssps)\n",
    "if len(expireds) > 0:\n",
    "    print(\"Newly Expired SSPs\")\n",
    "    for i in expireds:\n",
    "        pprint.pp(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "5d728666-986a-49a4-82a2-2aa257e2b567",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "4"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(actives)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "2eda9ff3-8d87-419a-98bd-f25f63a58d70",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Creon®\\xa025000 capsules\\xa0supporting guidance plus Q&A (PDF:125KB)'"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "columns[2].text"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}