python_selenium_demo.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Covid Clinical Research Webscrping Demo\n",
    "### Overview\n",
    "\n",
    "**Task:** Create a table file with the Covid clinical pesearch paper information where the data is in a standardized format that can be easily used in a tool that collects most up to date papers on COVID-19 or other `interested_condtion`\n",
    "\n",
    "**Link:** https://clinicaltrials.gov/ct2/\n",
    "\n",
    "**Last update:** October 6, 2021\n",
    "\n",
    "\n",
    "**Steps of Scraper**\n",
    " \n",
    "1.\t`scrape_one_page`  \n",
    "    A.\tScrapes all the table rows and columns from one page  \n",
    "    B.\tFinds the current row number on the condition results page (i.e. the ` current_row`)  \n",
    "    C.\tClicks on the next page  \n",
    "    D.\tReturns the data (i.e. ` page_dict `) to ` get_allpage_data `  \n",
    "1.\t`get_allpage_data`  \n",
    "    A.\tFinds and takes the result message text (i.e. “Showing: _ of _ studies”)  \n",
    "    B.\tAssumes each page shows 100 results   \n",
    "    C.\tGet total number of pages using  total_row_int/100     \n",
    "    D.\tCheck if len(all_page_dict) == row_count_int   \n",
    "    E.  Returns the the complete provider data (i.e. ` all_page_dict `) to ` write_out_data`   \n",
    "1.\t`write_out_data`  \n",
    "    A.\tTakes all provider data (i.e. ` all_page_dict `)     \n",
    "    B.\tConvert the condition data from list format to a data frame (i.e. `raw_df`)     \n",
    "    C.\tWrite out all condition data as data frame (i.e. `raw_df`)  \n",
    "    D.\tSelects the columns from interested condition a data frame we need from all data (`raw_df`)\n",
    "    E.  Writes out clean data (i.e. `clean_df`)   \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Package                            Version  \n",
      "---------------------------------- ---------\n",
      "alabaster                          0.7.12   \n",
      "anaconda-client                    1.7.2    \n",
      "anaconda-navigator                 1.9.7    \n",
      "anaconda-project                   0.8.2    \n",
      "argcomplete                        1.12.3   \n",
      "asn1crypto                         0.24.0   \n",
      "astroid                            2.2.5    \n",
      "astropy                            3.1.2    \n",
      "atomicwrites                       1.3.0    \n",
      "attrs                              19.1.0   \n",
      "autopep8                           1.5.7    \n",
      "Babel                              2.6.0    \n",
      "backcall                           0.1.0    \n",
      "backports.entry-points-selectable  1.1.0    \n",
      "backports.os                       0.1.1    \n",
      "backports.shutil-get-terminal-size 1.0.0    \n",
      "beautifulsoup4                     4.7.1    \n",
      "bitarray                           0.8.3    \n",
      "bkcharts                           0.2      \n",
      "bleach                             3.1.0    \n",
      "bokeh                              1.0.4    \n",
      "boto                               2.49.0   \n",
      "Bottleneck                         1.2.1    \n",
      "certifi                            2019.3.9 \n",
      "cffi                               1.12.2   \n",
      "chardet                            3.0.4    \n",
      "Click                              7.0      \n",
      "cloudpickle                        0.8.0    \n",
      "clyent                             1.2.2    \n",
      "colorama                           0.4.4    \n",
      "comtypes                           1.1.7    \n",
      "conda                              4.6.11   \n",
      "conda-build                        3.17.8   \n",
      "conda-verify                       3.1.1    \n",
      "configparser                       5.0.2    \n",
      "contextlib2                        0.5.5    \n",
      "crayons                            0.4.0    \n",
      "cryptography                       2.6.1    \n",
      "cycler                             0.10.0   \n",
      "Cython                             0.29.6   \n",
      "cytoolz                            0.9.0.1  \n",
      "dask                               1.1.4    \n",
      "decorator                          4.4.0    \n",
      "defusedxml                         0.5.0    \n",
      "distlib                            0.3.2    \n",
      "distributed                        1.26.0   \n",
      "docutils                           0.14     \n",
      "entrypoints                        0.3      \n",
      "et-xmlfile                         1.0.1    \n",
      "fastcache                          1.0.2    \n",
      "filelock                           3.0.10   \n",
      "Flask                              1.0.2    \n",
      "future                             0.17.1   \n",
      "gevent                             1.4.0    \n",
      "glob2                              0.6      \n",
      "greenlet                           0.4.15   \n",
      "h5py                               2.9.0    \n",
      "heapdict                           1.0.0    \n",
      "html5lib                           1.0.1    \n",
      "idna                               2.8      \n",
      "imageio                            2.5.0    \n",
      "imagesize                          1.1.0    \n",
      "importlib-metadata                 4.8.1    \n",
      "ipykernel                          5.1.0    \n",
      "ipython                            7.4.0    \n",
      "ipython-genutils                   0.2.0    \n",
      "ipywidgets                         7.4.2    \n",
      "isort                              4.3.16   \n",
      "itsdangerous                       1.1.0    \n",
      "jdcal                              1.4      \n",
      "jedi                               0.13.3   \n",
      "Jinja2                             2.10     \n",
      "jsonschema                         3.0.1    \n",
      "jupyter                            1.0.0    \n",
      "jupyter-client                     5.2.4    \n",
      "jupyter-console                    6.0.0    \n",
      "jupyter-core                       4.4.0    \n",
      "jupyterlab                         0.35.4   \n",
      "jupyterlab-server                  0.2.0    \n",
      "keyring                            18.0.0   \n",
      "kiwisolver                         1.0.1    \n",
      "lazy-object-proxy                  1.3.1    \n",
      "libarchive-c                       2.8      \n",
      "llvmlite                           0.28.0   \n",
      "locket                             0.2.0    \n",
      "lxml                               4.3.2    \n",
      "MarkupSafe                         1.1.1    \n",
      "matplotlib                         3.0.3    \n",
      "mccabe                             0.6.1    \n",
      "menuinst                           1.4.16   \n",
      "mistune                            0.8.4    \n",
      "mkl-fft                            1.0.10   \n",
      "mkl-random                         1.0.2    \n",
      "modules                            1.0.0    \n",
      "more-itertools                     6.0.0    \n",
      "mpmath                             1.1.0    \n",
      "msgpack                            0.6.1    \n",
      "multipledispatch                   0.6.0    \n",
      "navigator-updater                  0.2.1    \n",
      "nbconvert                          5.4.1    \n",
      "nbformat                           4.4.0    \n",
      "networkx                           2.2      \n",
      "nltk                               3.4      \n",
      "nose                               1.3.7    \n",
      "notebook                           5.7.8    \n",
      "numba                              0.43.1   \n",
      "numexpr                            2.6.9    \n",
      "numpy                              1.16.2   \n",
      "numpydoc                           0.8.0    \n",
      "olefile                            0.46     \n",
      "openpyxl                           2.6.1    \n",
      "packaging                          21.0     \n",
      "pandas                             0.24.2   \n",
      "pandocfilters                      1.4.2    \n",
      "parso                              0.3.4    \n",
      "partd                              0.3.10   \n",
      "path.py                            11.5.0   \n",
      "pathlib2                           2.3.3    \n",
      "patsy                              0.5.1    \n",
      "pep8                               1.7.1    \n",
      "pickleshare                        0.7.5    \n",
      "Pillow                             5.4.1    \n",
      "pip                                19.0.3   \n",
      "pipenv                             2021.5.29\n",
      "pipx                               0.16.4   \n",
      "pkginfo                            1.5.0.1  \n",
      "platformdirs                       2.3.0    \n",
      "pluggy                             0.9.0    \n",
      "ply                                3.11     \n",
      "prometheus-client                  0.6.0    \n",
      "prompt-toolkit                     2.0.9    \n",
      "psutil                             5.6.1    \n",
      "py                                 1.8.0    \n",
      "pycodestyle                        2.7.0    \n",
      "pycosat                            0.6.3    \n",
      "pycparser                          2.19     \n",
      "pycrypto                           2.6.1    \n",
      "pycurl                             7.43.0.2 \n",
      "pyflakes                           2.1.1    \n",
      "Pygments                           2.3.1    \n",
      "pylint                             2.3.1    \n",
      "pyodbc                             4.0.26   \n",
      "pyOpenSSL                          19.0.0   \n",
      "pyparsing                          2.3.1    \n",
      "pyreadline                         2.1      \n",
      "pyrsistent                         0.14.11  \n",
      "PySocks                            1.6.8    \n",
      "pytest                             4.3.1    \n",
      "pytest-arraydiff                   0.3      \n",
      "pytest-astropy                     0.5.0    \n",
      "pytest-doctestplus                 0.3.0    \n",
      "pytest-openfiles                   0.3.2    \n",
      "pytest-remotedata                  0.3.1    \n",
      "python-dateutil                    2.8.0    \n",
      "python-dotenv                      0.19.0   \n",
      "pytz                               2018.9   \n",
      "PyWavelets                         1.0.2    \n",
      "pywin32                            223      \n",
      "pywinpty                           0.5.5    \n",
      "PyYAML                             5.1      \n",
      "pyzmq                              18.0.0   \n",
      "QtAwesome                          0.5.7    \n",
      "qtconsole                          4.4.3    \n",
      "QtPy                               1.7.0    \n",
      "requests                           2.21.0   \n",
      "rope                               0.12.0   \n",
      "ruamel-yaml                        0.15.46  \n",
      "scikit-image                       0.14.2   \n",
      "scikit-learn                       0.20.3   \n",
      "scipy                              1.2.1    \n",
      "seaborn                            0.9.0    \n",
      "selenium                           3.141.0  \n",
      "Send2Trash                         1.5.0    \n",
      "setuptools                         58.0.3   \n",
      "simplegeneric                      0.8.1    \n",
      "singledispatch                     3.4.0.3  \n",
      "six                                1.12.0   \n",
      "snowballstemmer                    1.2.1    \n",
      "sortedcollections                  1.1.2    \n",
      "sortedcontainers                   2.1.0    \n",
      "soupsieve                          1.8      \n",
      "Sphinx                             1.8.5    \n",
      "sphinxcontrib-websupport           1.1.0    \n",
      "spyder                             3.3.3    \n",
      "spyder-kernels                     0.4.2    \n",
      "SQLAlchemy                         1.3.1    \n",
      "statsmodels                        0.9.0    \n",
      "sympy                              1.3      \n",
      "tables                             3.5.1    \n",
      "tblib                              1.3.2    \n",
      "terminado                          0.8.1    \n",
      "testpath                           0.4.2    \n",
      "toml                               0.10.2   \n",
      "toolz                              0.9.0    \n",
      "tornado                            6.0.2    \n",
      "tqdm                               4.31.1   \n",
      "traitlets                          4.3.2    \n",
      "typing-extensions                  3.10.0.2 \n",
      "unicodecsv                         0.14.1   \n",
      "urllib3                            1.24.1   \n",
      "userpath                           1.7.0    \n",
      "virtualenv                         20.7.2   \n",
      "virtualenv-clone                   0.5.6    \n",
      "wcwidth                            0.1.7    \n",
      "webdriver-manager                  3.4.2    \n",
      "webencodings                       0.5.1    \n",
      "Werkzeug                           0.14.1   \n",
      "wheel                              0.33.1   \n",
      "widgetsnbextension                 3.4.2    \n",
      "win-inet-pton                      1.1.0    \n",
      "win-unicode-console                0.5      \n",
      "wincertstore                       0.2      \n",
      "wrapt                              1.11.1   \n",
      "xlrd                               1.2.0    \n",
      "XlsxWriter                         1.1.5    \n",
      "xlwings                            0.15.4   \n",
      "xlwt                               1.3.0    \n",
      "zict                               0.1.4    \n",
      "zipp                               3.5.0    \n"
     ]
    }
   ],
   "source": [
    "!pip list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\n",
      "\n",
      "====== WebDriver manager ======\n",
      "Current google-chrome version is 94.0.4606\n",
      "Get LATEST driver version for 94.0.4606\n",
      "Driver [C:\\Users\\FYang\\.wdm\\drivers\\chromedriver\\win32\\94.0.4606.61\\chromedriver.exe] found in cache\n"
     ]
    }
   ],
   "source": [
    "#the webmanager auto detect your Chrome version and once installled, \n",
    "#Driver will be found in cache and won't need to be installed again\n",
    "from selenium import webdriver\n",
    "from webdriver_manager.chrome import ChromeDriverManager\n",
    "driver = webdriver.Chrome(ChromeDriverManager().install())\n",
    "\n",
    "from selenium.webdriver.support.ui import WebDriverWait \n",
    "from selenium.webdriver.support import expected_conditions as EC\n",
    "from selenium.webdriver.common.by import By\n",
    "from selenium.webdriver.common.keys import Keys\n",
    "from selenium.webdriver.support.ui import Select\n",
    "\n",
    "import pandas as pd\n",
    "import re \n",
    "import math\n",
    "import numpy as np\n",
    "from selenium.webdriver.support.ui import Select\n",
    "import time\n",
    "# import git\n",
    "import logging\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "interested_condtion = [\"covid\"]\n",
    "\n",
    "# find current time\n",
    "timestr = time.strftime(\"%Y%m%d-%H%M\")\n",
    "\n",
    "def create_path(last_part_path, file_type = \".csv\"): \n",
    "    ''' \n",
    "    take last part of path and provide path with identifying information\n",
    "    '''\n",
    "    path = root_path + last_part_path + \"_\" + timestr + \"_\" + file_type\n",
    "    \n",
    "    return path\n",
    "\n",
    "root_path = \"C:/Users/FYang/Projects/DS_NLPSpecialization/webscraping/Webscrping Demo for Oct Hackathon/\"\n",
    "\n",
    "dict_out_path = create_path(\"interim/page_dict\", \".txt\")\n",
    "raw_df_path = create_path(\"raw/covid_study_df\")\n",
    "logging_path = create_path(\"interim/log\", \".log\")\n",
    "clean_df_path = create_path(\"cleaned_outputs/condition_study_clean\")\n",
    "\n",
    "# configure logging\n",
    "logging.basicConfig(filename= logging_path, filemode='w',  \n",
    "                    format='%(asctime)s - %(levelname)s - %(message)s',\n",
    "                    datefmt='%d-%b-%y %H:%M:%S',\n",
    "                    level=logging.INFO)\n",
    "\n",
    "\n",
    "driver.get(\"https://clinicaltrials.gov/ct2/\")\n",
    "e=driver.find_element_by_id('home-search-condition-query')\n",
    "e.send_keys(interested_condtion)\n",
    "e.send_keys(Keys.ENTER)\n",
    "\n",
    "result_length_list = Select(driver.find_element_by_name('theDataTable_length'))\n",
    "result_length_list.select_by_value(\"100\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "def scrape_page(page,driver):\n",
    "    page_dict = dict()\n",
    "    \n",
    "    # get col names list\n",
    "    for thead in driver.find_elements_by_xpath('//*[@id=\"theDataTable\"]/thead'):\n",
    "        col_list = [item.text for item in thead.find_elements_by_xpath(\".//*[self::th]\")]\n",
    "\n",
    "    # get row values- rows of the table on page\n",
    "    for row in driver.find_elements_by_xpath('//*[@id=\"theDataTable\"]/tbody/tr'):\n",
    "        row_list = [item.text for item in row.find_elements_by_xpath(\".//*[self::td]\")]\n",
    "\n",
    "        # combine lists to make dic\n",
    "        row_dict = {k:v for k, v in zip(col_list, row_list)}\n",
    "\n",
    "        current_row=int(row_dict.get('Row'))\n",
    "        page_dict[current_row] = row_dict\n",
    "\n",
    "        current_row = current_row + 1\n",
    "\n",
    "    page_button = driver.find_element_by_xpath('//a[@aria-controls= \"theDataTable\"]').click()       \n",
    "#     page_button=WebDriverWait(driver,100).until(EC.visibility_of_element_located((By.XPATH ,'//a[@aria-controls= \"theDataTable\"]')))\n",
    "#     page_button.click()\n",
    "\n",
    "    return(page_dict)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Block Test for scraping selected number of pages and write out the result "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Block Test for get_allpage_data\n",
    "all_page_dict = dict()\n",
    "\n",
    "\n",
    "search_result=driver.find_element_by_class_name('dataTables_info')\n",
    "results_text=search_result.text\n",
    "\n",
    "total_row_list=re.findall('\\d+(?:\\.\\d+)?,\\d+', results_text)\n",
    "total_row_int=int(total_row_list[0].replace(',', ''))\n",
    "\n",
    "temp = total_row_int/100 \n",
    "pages = math.ceil(temp)\n",
    "\n",
    "\n",
    "for page in range(1, 2):\n",
    "    page_dict = scrape_page(page, driver)\n",
    "    all_page_dict.update(page_dict)\n",
    "\n",
    "# Block Test for writing out scraped one page\n",
    "\n",
    "col_names_dict={\"Row\": \"Number\",\n",
    "               \"Saved\": None,\n",
    "               \"Status\": \"Study_Paticipant_Recruitment_Status\", \n",
    "               \"Study Title\": \"Study_Title\", \n",
    "               \"Conditions\" : \"Conditions\",\n",
    "               \"Interventions\": \"Interventions\",\n",
    "               \"Locations\": \"Locations\"\n",
    "              }\n",
    "\n",
    "col_names_dict_filter = {k: v for k, v in col_names_dict.items() if v is not None}\n",
    "    \n",
    "    #write out all_page_dict\n",
    "with open(dict_out_path, 'w', encoding='utf-8') as f:\n",
    "    print(all_page_dict, file=f)\n",
    "\n",
    "raw_df=pd.DataFrame(all_page_dict).T \n",
    "    \n",
    "raw_df.to_csv(raw_df_path, index=False)\n",
    "logging.info(\"finished: writing out raw_df\")\n",
    "    \n",
    "# clean_df -- all data from all providers (as dataframe)\n",
    "# drop_duplicates -- dropping duplicated rows\n",
    "clean_df = raw_df[list(col_names_dict_filter.keys())]\n",
    "clean_df = clean_df.rename(columns= col_names_dict_filter)\n",
    "\n",
    "clean_df = clean_df.drop_duplicates()\n",
    "\n",
    "# log number of duplicated rows dropped\n",
    "count_duplicate = len(raw_df)-len(clean_df)\n",
    "logging.info('number of duplicate rows removed =' + str(count_duplicate))\n",
    "\n",
    "clean_df.to_csv(clean_df_path, index=False)\n",
    "\n",
    "logging.info(\"finished: writing out clean_df\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{1: {'Row': '1',\n",
       "  'Saved': '',\n",
       "  'Status': 'Enrolling by invitation',\n",
       "  'Study Title': 'COVID SAFE: COVID-19 Screening Assessment for Exposure',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Behavioral: Saliva-based testing',\n",
       "  'Locations': 'Penn Medicine\\nPhiladelphia, Pennsylvania, United States'},\n",
       " 2: {'Row': '2',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'CICERO- A Care Home Study of COVID-19',\n",
       "  'Conditions': 'COVID',\n",
       "  'Interventions': 'Diagnostic Test: Q16 testing\\nDiagnostic Test: Nasopharyngeal swab and main laboratory',\n",
       "  'Locations': 'Queen Mary University London\\nLondon, United Kingdom'},\n",
       " 3: {'Row': '3',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Dexamethasone for COVID-19',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Drug: Dexamethasone',\n",
       "  'Locations': 'University of Oklahoma Medical Center\\nOklahoma City, Oklahoma, United States'},\n",
       " 4: {'Row': '4',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Duvelisib to Combat COVID-19',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: Duvelisib\\nProcedure: Peripheral blood draw\\nDrug: Placebo',\n",
       "  'Locations': 'Missouri Baptist Medical Center\\nSaint Louis, Missouri, United States\\nWashington University School of Medicine\\nSaint Louis, Missouri, United States'},\n",
       " 5: {'Row': '5',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'Enhancing COVID Rehabilitation With Technology',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Behavioral: NexJ Connected Wellness\\nOther: Usual Care',\n",
       "  'Locations': ''},\n",
       " 6: {'Row': '6',\n",
       "  'Saved': '',\n",
       "  'Status': 'Active, not recruiting',\n",
       "  'Study Title': 'Post Covid-19 Cardiopulmonary and Immunological Changes',\n",
       "  'Conditions': 'COVID',\n",
       "  'Interventions': '',\n",
       "  'Locations': 'Mansoura faculty of medicine\\nMansoura, Dakahlia, Egypt'},\n",
       " 7: {'Row': '7',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Immune Modulators for Treating COVID-19',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Drug: Infliximab\\nDrug: Abatacept\\nDrug: Remdesivir\\nDrug: cenicriviroc',\n",
       "  'Locations': 'Banner University Medical Center\\nPhoenix, Arizona, United States\\nUniversity of Arkansas Medical Sciences\\nLittle Rock, Arkansas, United States\\nScripps Clinical Medical Group\\nLa Jolla, California, United States\\n(and 85 more...)'},\n",
       " 8: {'Row': '8',\n",
       "  'Saved': '',\n",
       "  'Status': 'Enrolling by invitation',\n",
       "  'Study Title': 'COVID-FISETIN: Pilot in SARS-CoV-2 of Fisetin to Alleviate Dysfunction and Inflammation',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Drug: Placebo\\nDrug: Fisetin',\n",
       "  'Locations': 'Mayo Clinic in Rochester\\nRochester, Minnesota, United States'},\n",
       " 9: {'Row': '9',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Balance in COVID-19',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Other: Balance assessments',\n",
       "  'Locations': 'Duke University Health System\\nDurham, North Carolina, United States'},\n",
       " 10: {'Row': '10',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'Ivermectin Nasal Spray for COVID19 Patients',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Drug: Ivermectin nasal\\nDrug: Ivermectin oral\\nOther: standard care',\n",
       "  'Locations': ''},\n",
       " 11: {'Row': '11',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Relationship Between CT- Value With Prognosis in COVID-19 Patients',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Diagnostic Test: Cycle threshold',\n",
       "  'Locations': 'SBMU\\nTehran, Iran, Islamic Republic of\\nNooshin Dalili\\nTehran, Iran, Islamic Republic of'},\n",
       " 12: {'Row': '12',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Observational Cohort of COVID-19 Patients at Raymond-Poincare',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': '',\n",
       "  'Locations': 'Department of Infectiology, Raymond Poincaré Hospital, APHP\\nGarches, France'},\n",
       " 13: {'Row': '13',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'Fugal Infection in COVID-19 Patients',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Other: no intervention',\n",
       "  'Locations': ''},\n",
       " 14: {'Row': '14',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'The Lymphoma and Leukemia Society Amended COVID-19 Registry',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Biological: Amended LLS COVID-19 Registry',\n",
       "  'Locations': 'Lymphoma and Leukemia Society\\nRye Brook, New York, United States'},\n",
       " 15: {'Row': '15',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Pilot Trial of XFBD, a TCM, in Persons With COVID-19',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Drug: Xuanfei Baidu Granules\\nOther: Placebo',\n",
       "  'Locations': 'University of Southern California\\nLos Angeles, California, United States'},\n",
       " 16: {'Row': '16',\n",
       "  'Saved': '',\n",
       "  'Status': 'Enrolling by invitation',\n",
       "  'Study Title': 'Estimation of Dynamics of Humoral and Cellular Immunity in COVID-19 Patients',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Diagnostic Test: Humoral and cellular immunity',\n",
       "  'Locations': 'Institute of Biophysics and Cell Engineering of National Academy of Sciences of Belarus\\nMinsk, Belarus'},\n",
       " 17: {'Row': '17',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'Study of Intravenous COVI-MSC for Treatment of COVID-19-Induced Acute Respiratory Distress',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Biological: COVI-MSC\\nDrug: Placebo',\n",
       "  'Locations': ''},\n",
       " 18: {'Row': '18',\n",
       "  'Saved': '',\n",
       "  'Status': 'Completed',\n",
       "  'Study Title': 'COVID 19 Serology in Pulmonologists',\n",
       "  'Conditions': 'Covid 19',\n",
       "  'Interventions': '',\n",
       "  'Locations': 'Uh Montpellier\\nMontpellier, France'},\n",
       " 19: {'Row': '19',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'COVID-19 Surveillance Based on Smart Wearable Device',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': '',\n",
       "  'Locations': 'Peking University First Hospital\\nBeijing, Beijing, China'},\n",
       " 20: {'Row': '20',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'Study of Allogeneic Adipose-Derived Mesenchymal Stem Cells for Treatment of COVID-19 Acute Respiratory Distress',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Biological: COVI-MSC\\nDrug: Placebo',\n",
       "  'Locations': ''},\n",
       " 21: {'Row': '21',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Effect of COVID-19 Pandemic on Pediatric Cancer Care',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': '',\n",
       "  'Locations': 'South Egypt Cancer Institute, Assiut University\\nAssiut, Egypt'},\n",
       " 22: {'Row': '22',\n",
       "  'Saved': '',\n",
       "  'Status': 'Completed',\n",
       "  'Study Title': 'A Phase 2 Trial of Infliximab in Coronavirus Disease 2019 (COVID-19).',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: Infliximab',\n",
       "  'Locations': 'Tufts Medical Center\\nBoston, Massachusetts, United States'},\n",
       " 23: {'Row': '23',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'Study to Evaluate the Safety and Efficacy of a Single Dose of STI-2020 (COVI-AMG™) to Treat COVID-19',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Biological: COVI-AMG\\nDrug: Placebo',\n",
       "  'Locations': ''},\n",
       " 24: {'Row': '24',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'Study to Evaluate a Single Intranasal Dose of STI-2099 (COVI-DROPS™) in Outpatient Adults With COVID-19 (US)',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Biological: COVI-DROPS\\nDrug: Placebo',\n",
       "  'Locations': ''},\n",
       " 25: {'Row': '25',\n",
       "  'Saved': '',\n",
       "  'Status': 'Active, not recruiting',\n",
       "  'Study Title': 'A Research Study to Evaluate the Benefits of a Self-management Booklet to Promote Wellbeing During the COVID-19 Pandemic',\n",
       "  'Conditions': 'COVID',\n",
       "  'Interventions': 'Behavioral: Self-management booklet (SWitCh: Stay well during COVID-19)',\n",
       "  'Locations': 'Online recruitment through Qualtrics\\nLondon, United Kingdom'},\n",
       " 26: {'Row': '26',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Study to Evaluate a Single Dose of STI-2020 (COVI-AMG™) in Hospitalized Adults With COVID-19',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Biological: COVI-AMG\\nDrug: Placebo',\n",
       "  'Locations': 'Teradan Clinical Trials\\nBrandon, Florida, United States'},\n",
       " 27: {'Row': '27',\n",
       "  'Saved': '',\n",
       "  'Status': 'Completed',\n",
       "  'Study Title': 'Forecast Number of Covid-19 Cases Worldwide',\n",
       "  'Conditions': 'Covid-19',\n",
       "  'Interventions': 'Other: Model Building\\nOther: Model validation',\n",
       "  'Locations': 'Republic of Turkey, Health Sciences University, Izmir Bozyaka Education and Training Hospital\\nİzmir, Turkey'},\n",
       " 28: {'Row': '28',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'Hyperbaric Oxygen Therapy (HBOT) as a Treatment for COVID-19 (COVID-19) Infection',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Device: Hyperbaric Oxygen Therapy',\n",
       "  'Locations': 'Ochsner Medical Center\\nNew Orleans, Louisiana, United States'},\n",
       " 29: {'Row': '29',\n",
       "  'Saved': '',\n",
       "  'Status': 'Completed',\n",
       "  'Study Title': 'Efficacy of Convalescent Plasma Therapy in Severely Sick COVID-19 Patients',\n",
       "  'Conditions': 'COVID',\n",
       "  'Interventions': 'Drug: Convalescent Plasma Transfusion\\nOther: Supportive Care\\nDrug: Random Donor Plasma',\n",
       "  'Locations': 'Maulana Azad medical College\\nNew Delhi, Delhi, India\\nInstitute of Liver and Biliary Sciences\\nNew Delhi, Delhi, India'},\n",
       " 30: {'Row': '30',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Study to Evaluate a Single Dose of STI-2020 (COVI-AMG™) in Adults With Mild COVID-19 Symptoms',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Biological: COVI-AMG\\nDrug: Placebo',\n",
       "  'Locations': 'Collaborative NeuroScience Research, LLC\\nGarden Grove, California, United States\\nSynergy Healthcare LLC\\nBradenton, Florida, United States\\nMed-Care Research\\nMiami, Florida, United States\\nETNA Medical Center\\nTamarac, Florida, United States'},\n",
       " 31: {'Row': '31',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'Safety and Efficacy of Tramadol in COVID-19 Egyptian Patients',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: Tramadol\\nOther: Standard care delivered in the isolation hospitals.',\n",
       "  'Locations': ''},\n",
       " 32: {'Row': '32',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Study to Evaluate a Single Intranasal Dose of STI-2099 (COVI-DROPS™) in Outpatient Adults With COVID-19 (UK)',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Biological: COVI-DROPS\\nDrug: Placebo',\n",
       "  'Locations': 'University Hospitals of Coventry and Warwickshire Hospital Trust\\nCoventry, United Kingdom'},\n",
       " 33: {'Row': '33',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Safety & Effectiveness Evaluation of Seraph 100 in Treatment of Pts With COVID-19',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Device: Seraph 100',\n",
       "  'Locations': 'Klinikum Aschaffenburg-Alzenau\\nAschaffenburg, Germany\\nVivantes Klinikum Neukölln\\nBerlin, Germany\\nUniversitätsklinikum Essen\\nEssen, Germany\\n(and 2 more...)'},\n",
       " 34: {'Row': '34',\n",
       "  'Saved': '',\n",
       "  'Status': 'Completed\\nHas Results',\n",
       "  'Study Title': 'Safety and Efficacy of C21 in Subjects With COVID-19',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: C21\\nDrug: Placebo',\n",
       "  'Locations': 'Department of Medicine, Civil Hospital and B J Medical College\\nAhmadabad, Gujarat, India\\nInfectious Disease, Metas Adventist Hospital\\nSurat, Gujarat, India\\nClinical Research Department, Basement, Unity Trauma Centre and ICU (Unity Hospital\\nSurat, Gujarat, India\\n(and 6 more...)'},\n",
       " 35: {'Row': '35',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Dornase Alpha for the Treatment of COVID-19',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: Pulmozyme',\n",
       "  'Locations': 'Acıbadem Altunizade Hospital\\nIstanbul, Turkey'},\n",
       " 36: {'Row': '36',\n",
       "  'Saved': '',\n",
       "  'Status': 'Completed',\n",
       "  'Study Title': 'Community Pharmacists Behaviour During Covid-19',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': '',\n",
       "  'Locations': 'Damanhour university\\nBeheira, Damanhour, Egypt\\nDamanhour universty\\nAlexandria, Egypt'},\n",
       " 37: {'Row': '37',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Covid-19: Possible Role of Neutrophil Extracellular Traps',\n",
       "  'Conditions': 'Covid-19',\n",
       "  'Interventions': 'Diagnostic Test: NETosis markers',\n",
       "  'Locations': 'Univeristy of Verona\\nVerona, Italy'},\n",
       " 38: {'Row': '38',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Application of Desferal to Treat COVID-19',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: Deferoxamine',\n",
       "  'Locations': 'Regenerative Medicine Research Center, Kermanshah University of Medical Sciences, Kermanshah, Iran\\nKermanshah, Iran, Islamic Republic of'},\n",
       " 39: {'Row': '39',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'A Study to Evaluate the Efficacy and Safety of Proxalutamide (GT0918) in Hospitalized COVID-19 Subjects',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Drug: GT0918\\nDrug: Standard of care\\nDrug: Matching placebo',\n",
       "  'Locations': ''},\n",
       " 40: {'Row': '40',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Study of the Safety and Efficacy of STI-5656 (Abivertinib Maleate) in Subjects Hospitalized Due to COVID-19',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Drug: STI-5656\\nDrug: Placebo',\n",
       "  'Locations': 'Hospital e Maternidade Christovão da Gama\\nSanto André, SP, Brazil'},\n",
       " 41: {'Row': '41',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'Pulmonary Rehabilitation Post-COVID-19',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Other: Exercise program (virtual/remote)',\n",
       "  'Locations': ''},\n",
       " 42: {'Row': '42',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Phase 1 Study to Assess Safety, Tolerability, PD, PK, Immunogenicity of IV NTR-441 Solution in Healthy Volunteers and COVID-19 Patients',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Drug: NTR-441\\nDrug: Placebo',\n",
       "  'Locations': 'Medical University of Vienna, Department of Infectiology and Tropical Medicine\\nVienna, Austria\\nMedical University Vienna, Department of Clinical Pharmacology\\nVienna, Austria'},\n",
       " 43: {'Row': '43',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'Safety & Efficacy of Low Dose Aspirin / Ivermectin Combination Therapy for Treatment of Covid-19 Patients',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Drug: 3-dayIVM 200 mcg/kg/day/14-day 75mgASA/day + standard of care (intervention 1)',\n",
       "  'Locations': ''},\n",
       " 44: {'Row': '44',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting\\nNEW',\n",
       "  'Study Title': 'A Pilot Study of a PhysiOthErapy-based Tailored Intervention for Long Covid',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Behavioral: Physiotherapy',\n",
       "  'Locations': 'Peter Lougheed Centre (PLC), University of Calgary\\nCalgary, Alberta, Canada\\nRockyview General Hospital, University of Calgary\\nCalgary, Alberta, Canada'},\n",
       " 45: {'Row': '45',\n",
       "  'Saved': '',\n",
       "  'Status': 'Withdrawn',\n",
       "  'Study Title': 'Study to Evaluate the Safety, Pharmacokinetics and Efficacy of STI-2020 (COVI-AMG™) in Outpatients With COVID-19',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Biological: COVI-AMG\\nDrug: Placebo',\n",
       "  'Locations': ''},\n",
       " 46: {'Row': '46',\n",
       "  'Saved': '',\n",
       "  'Status': 'Completed',\n",
       "  'Study Title': 'A Study Evaluating the Efficacy and Safety of CKD-314 in Hospitalized Adult Patients Diagnosed With COVID-19 Pneumonia',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: Nafamostat Mesilate',\n",
       "  'Locations': 'Korea Cancer Center Hospital\\nSeoul, Korea, Republic of'},\n",
       " 47: {'Row': '47',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Study of the Sars-Cov2 Neuroinvasiveness - COVID19',\n",
       "  'Conditions': 'COVID19',\n",
       "  'Interventions': 'Drug: Cerebrospinal fluid sampling, meningeal and brain parenchyma biopsies',\n",
       "  'Locations': 'Fondation A de Rothschild\\nParis, France'},\n",
       " 48: {'Row': '48',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Echinacea Drug for Covid-19',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Drug: Equinacea Arkopharma\\nOther: Placebo',\n",
       "  'Locations': 'Hospital de Barbastro\\nBarbastro, Spain\\nHospital do Barbanza\\nRibeira, Spain\\nHospital Clínico Universitario de Santiago\\nSantiago De Compostela, Spain\\nHospital Clínico Universitario Lozano Blesa\\nZaragoza, Spain'},\n",
       " 49: {'Row': '49',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'COVID-19. CT-Scan Modeling in COVID19 Sequelae',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': '',\n",
       "  'Locations': 'Hôpital Avicenne APHP\\nBobigny, France'},\n",
       " 50: {'Row': '50',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Immunoglobulin G Antibody Immune Response Profile Following Infection With SARS-CoV-2 in COVID-19 Egyptian Patients',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': '',\n",
       "  'Locations': 'Sohag University Hospital\\nSohag, Egypt'},\n",
       " 51: {'Row': '51',\n",
       "  'Saved': '',\n",
       "  'Status': 'Completed',\n",
       "  'Study Title': 'A Simple Approach to Treat COVID-19 Patients at Home.',\n",
       "  'Conditions': 'COVID 19',\n",
       "  'Interventions': 'Drug: Recommended treatment schedule\\nDrug: Control treatment schedule',\n",
       "  'Locations': 'Clinical Reserach Center for Rare Diseases \"Aldo e Cele Daccò\"\\nRanica, BG, Italy'},\n",
       " 52: {'Row': '52',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Recombinant Hyperimmune Polyclonal Antibody (GIGA-2050) in COVID-19 Patients',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: GIGA-2050',\n",
       "  'Locations': 'Icahn School of Medicine at Mount Sinai\\nNew York, New York, United States'},\n",
       " 53: {'Row': '53',\n",
       "  'Saved': '',\n",
       "  'Status': 'Active, not recruiting',\n",
       "  'Study Title': 'Clinical Study To Evaluate The Performance And Safety Of Favipiravir in COVID-19',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: Favipiravir\\nOther: Placebo',\n",
       "  'Locations': 'Asst Fatebenefratelli Sacco\\nMilano, Italy'},\n",
       " 54: {'Row': '54',\n",
       "  'Saved': '',\n",
       "  'Status': 'Completed',\n",
       "  'Study Title': 'Effectiveness and Safety of Medical Treatment for SARS-CoV-2 (COVID-19) in Colombia',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: Emtricitabine/tenofovir\\nDrug: Colchicine Pill\\nDrug: Rosuvastatin\\nOther: Standard treatment',\n",
       "  'Locations': 'Clinica santa Maria del lago\\nBogota, DC, Colombia\\nClínica Reina Sofía\\nBogotá, Colombia\\nFundacion Cardio Infantil\\nBogotá, Colombia\\n(and 3 more...)'},\n",
       " 55: {'Row': '55',\n",
       "  'Saved': '',\n",
       "  'Status': 'Completed',\n",
       "  'Study Title': 'COVID-19: A Prevalence Study of Two ART Centres After the Pandemic Lockdown in the USA (COVID-19 Free Clinics)',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Diagnostic Test: ELISA\\nDiagnostic Test: RT-PCR',\n",
       "  'Locations': 'Boston IVF Fertility Clinic\\nBoston, Massachusetts, United States\\nUtah Fertility Clinic\\nPleasant Grove, Utah, United States'},\n",
       " 56: {'Row': '56',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'A Phase 3 Randomized, Double-Blind Placebo Controlled, Multi-regional Trial to Evaluate the Efficacy and Safety of GT0918 for the Treatment of Mild to Moderate COVID-19 Male Patients',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: GT0918 tablets or placebo',\n",
       "  'Locations': 'Hospital Santa Paula\\nSão Paulo, SP, Brazil'},\n",
       " 57: {'Row': '57',\n",
       "  'Saved': '',\n",
       "  'Status': 'Withdrawn',\n",
       "  'Study Title': 'AZD1222 Vaccine for the Prevention of COVID-19',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Biological: AZD1222',\n",
       "  'Locations': 'Research Site\\nMoscow, Russian Federation\\nResearch Site\\nSaint Petersburg, Russian Federation\\nResearch Site\\nSaint-Petersburg, Russian Federation\\nResearch Site\\nSt. Petersburg, Russian Federation'},\n",
       " 58: {'Row': '58',\n",
       "  'Saved': '',\n",
       "  'Status': 'Active, not recruiting',\n",
       "  'Study Title': 'Study of AZD1222 for the Prevention of COVID-19 in Japan',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: AZD1222\\nDrug: 0.9% (w/v) saline',\n",
       "  'Locations': 'Research Site\\nFukuoka-shi, Japan\\nResearch Site\\nHachioji-shi, Japan\\nResearch Site\\nMinato-ku, Japan\\n(and 2 more...)'},\n",
       " 59: {'Row': '59',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'Oestrogen Treatment for COVID-19 Symptoms',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: Transdermal estradiol gel',\n",
       "  'Locations': 'Hamad Medical Corporation\\nDoha, Qatar'},\n",
       " 60: {'Row': '60',\n",
       "  'Saved': '',\n",
       "  'Status': 'Completed\\nHas Results',\n",
       "  'Study Title': 'Clinical Trial of Ivermectin Plus Doxycycline for the Treatment of Confirmed Covid-19 Infection',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Drug: Ivermectin and Doxycycline\\nDrug: Standard of care',\n",
       "  'Locations': 'Dhaka Medical College\\nDhaka, Bangladesh'},\n",
       " 61: {'Row': '61',\n",
       "  'Saved': '',\n",
       "  'Status': 'Withdrawn',\n",
       "  'Study Title': 'Outpatient Use of Ivermectin in COVID-19',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Drug: Ivermectin Pill\\nDrug: Placebo',\n",
       "  'Locations': 'Temple University Hospital\\nPhiladelphia, Pennsylvania, United States'},\n",
       " 62: {'Row': '62',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'Active Pharmacovigilance Study of Adsorbed COVID-19 (Inactivated) Vaccine',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Biological: Adsorbed COVID-19 (Inactivated) Vaccine',\n",
       "  'Locations': 'Centro de Saúde Escola da Faculdade de Medicina de Botucatu - Unesp.\\nBotucatu, São Paulo, Brazil\\nCentro de Saúde Escola da Faculdade de Medicina de Ribeirão Preto da Universidade de São Paulo (HCFMRP-USP) Dr. Joel Domingos Machado.\\nRibeirão Preto, São Paulo, Brazil\\nCentro de Referência de Imunobiológicos Especiais. Hospital das Clínicas da Faculdade de Medicina da Universidade de São Paulo (CRIEHCFMUSP)\\nSão Paulo, Brazil'},\n",
       " 63: {'Row': '63',\n",
       "  'Saved': '',\n",
       "  'Status': 'Active, not recruiting',\n",
       "  'Study Title': 'A Study Evaluating the Efficacy and Safety of High-Titer Anti-SARS-CoV-2 Plasma in Hospitalized Patients With COVID-19 Infection',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Biological: anti-SARS-CoV-2 convalescent plasma',\n",
       "  'Locations': 'Froedtert Hospital\\nMilwaukee, Wisconsin, United States'},\n",
       " 64: {'Row': '64',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'PK and Safety of Remdesivir for Treatment of COVID-19 in Pregnant and Non-Pregnant Women in the US',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: Remdesivir',\n",
       "  'Locations': 'USC/Los Angeles County Medical Center NICHD CRS (5048)\\nLos Angeles, California, United States\\nDavid Geffen School of Medicine at UCLA (CRS 5112)\\nLos Angeles, California, United States\\nUniversity California, San Diego (CRS 4601)\\nSan Diego, California, United States\\n(and 14 more...)'},\n",
       " 65: {'Row': '65',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Safety and Tolerability of Emricasan in Symptomatic Outpatients Diagnosed With Mild-COVID-19',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Drug: Emricasan\\nOther: Placebo',\n",
       "  'Locations': 'SUNY Downstate Health Sciences University\\nBrooklyn, New York, United States'},\n",
       " 66: {'Row': '66',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'CORonavirus (COVID-19) Diagnostic Lung UltraSound Study',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Diagnostic Test: Lung ultrasound',\n",
       "  'Locations': 'Derriford Hospital\\nPlymouth, Devon, United Kingdom'},\n",
       " 67: {'Row': '67',\n",
       "  'Saved': '',\n",
       "  'Status': 'Active, not recruiting',\n",
       "  'Study Title': 'Phase III Study of AZD7442 for Treatment of COVID-19 in Outpatient Adults',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: AZD7442\\nDrug: Placebo',\n",
       "  'Locations': 'Research Site\\nJasper, Alabama, United States\\nResearch Site\\nTucson, Arizona, United States\\nResearch Site\\nLong Beach, California, United States\\n(and 113 more...)'},\n",
       " 68: {'Row': '68',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Genotype and Susceptibility to COVID-19',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Other: Questionnaire administration,blood sampling and genetic analyses.',\n",
       "  'Locations': 'Centro di Ricerche Cliniche per le Malattie Rare \"Aldo e Cele Daccò\"\\nRanica, BG, Italy'},\n",
       " 69: {'Row': '69',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'Study to Evaluate the Efficacy and Safety of Tocilizumab Versus Corticosteroids in Hospitalised COVID-19 Patients With High Risk of Progression',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: Tocilizumab\\nDrug: Methylprednisolone',\n",
       "  'Locations': 'University Malaya Medical Centre\\nKuala Lumpur, Malaysia'},\n",
       " 70: {'Row': '70',\n",
       "  'Saved': '',\n",
       "  'Status': 'Active, not recruiting',\n",
       "  'Study Title': 'Evaluating Safety, Pharmacokinetics and Clinical Benefit of Silmitasertib (CX-4945) in Subjects With Moderate COVID-19',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Drug: Silmitasertib\\nDrug: SOC',\n",
       "  'Locations': 'Center for Advanced Research and Education\\nGainesville, Georgia, United States'},\n",
       " 71: {'Row': '71',\n",
       "  'Saved': '',\n",
       "  'Status': 'Completed\\nHas Results',\n",
       "  'Study Title': 'USEFULNESS of Topic Ivermectin and Carrageenan to Prevent Contagion of Covid 19',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Combination Product: Iota carrageenan nasal spray and Ivermectin oral drops (used as buccal drops)',\n",
       "  'Locations': 'Hospital Eurnekian\\nBuenos Aires, Argentina'},\n",
       " 72: {'Row': '72',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'UPMC OPTIMISE-C19 Trial, a COVID-19 Study',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Biological: Lilly Bamlanivimab\\nBiological: Regeneron Casirivimab + Imdevimab\\nBiological: Lilly Bamlanivimab + Etesevimab\\nBiological: Sotrovimab',\n",
       "  'Locations': 'UPMC\\nPittsburgh, Pennsylvania, United States'},\n",
       " 73: {'Row': '73',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Efficacy of Reinforcing Standard Therapy in COVID-19 Patients With Repeated Transfusion of Convalescent Plasma',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Other: Convalescent Plasma with antibody against SARS-CoV-2.\\nOther: Standard treatment for COVID-19',\n",
       "  'Locations': 'University Hospital Son Llatzer\\nPalma De Mallorca, Islas De Balears, Spain'},\n",
       " 74: {'Row': '74',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Fluvoxamine Administration in Moderate SARS-CoV-2 (COVID-19) Infected Patients',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Drug: Placebo\\nDrug: Fluvoxamine',\n",
       "  'Locations': 'Dél-pesti Centrumkórház\\nBudapest, Hungary\\nSemmelweis Egyetem Pulmonológiai Klinika\\nBudapest, Hungary\\nOrszágos Korányi Pulmonológiai Intézet\\nBudapest, Hungary\\nDebreceni Egyetem Kenézy Gyula Kórház Infektológia\\nDebrecen, Hungary'},\n",
       " 75: {'Row': '75',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Effects of Sodium Pyruvate Nasal Spray in COVID-19 Long Haulers.',\n",
       "  'Conditions': 'Long COVID',\n",
       "  'Interventions': 'Drug: sodium pyruvate nasal spray',\n",
       "  'Locations': 'Missouri State University\\nSpringfield, Missouri, United States'},\n",
       " 76: {'Row': '76',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Efficacy, Immunogenicity, and Safety of the Inactivated COVID-19 Vaccine (TURKOVAC) Versus the CoronaVac Vaccine',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Biological: TURCOVAC\\nBiological: CoronaVac',\n",
       "  'Locations': 'T.R. Ministry of Health Ankara City Hospital, Infectious Diseases and Clinical Microbiology Clinic\\nAnkara, Turkey Region, Turkey\\nÇukurova University Faculty of Medicine, Department of Infectious Diseases\\nAdana, Turkey\\nHacettepe University Faculty of Medicine Department of Infections Diseases and Clinical Microbiology\\nAnkara, Turkey\\n(and 26 more...)'},\n",
       " 77: {'Row': '77',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Long-term Outcomes in Patients With COVID-19',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': '',\n",
       "  'Locations': 'Renji Hospital, Shanghai Jiaotong University School of Medicine\\nPudong, Shanghai, China'},\n",
       " 78: {'Row': '78',\n",
       "  'Saved': '',\n",
       "  'Status': 'Active, not recruiting',\n",
       "  'Study Title': 'COVID-19 Vaccinations With a Sweepstakes',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Behavioral: Philly Vax Sweepstakes',\n",
       "  'Locations': 'University of Pennsylvania\\nPhiladelphia, Pennsylvania, United States'},\n",
       " 79: {'Row': '79',\n",
       "  'Saved': '',\n",
       "  'Status': 'Completed',\n",
       "  'Study Title': 'Comparison of Two Doses of Enoxaparin for Thromboprophylaxis in Hospitalized COVID-19 Patients',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Drug: Enoxaparin',\n",
       "  'Locations': 'Azienda Socio Sanitaria Territoriale Grande Ospedale Metropolitano Niguarda\\nMilano, Italy'},\n",
       " 80: {'Row': '80',\n",
       "  'Saved': '',\n",
       "  'Status': 'Withdrawn',\n",
       "  'Study Title': 'Clinical Trial of Allogeneic Mesenchymal Cells From Umbilical Cord Tissue in Patients With COVID-19',\n",
       "  'Conditions': 'COVID',\n",
       "  'Interventions': 'Biological: Mesenchymal cells\\nDrug: Standard of care',\n",
       "  'Locations': 'Hospital Universitario de Getafe\\nGetafe, Madrid, Spain\\nHospital Universitario de Cruces\\nBarakaldo, Spain\\nHospital Universitario de La Princesa\\nMadrid, Spain\\n(and 3 more...)'},\n",
       " 81: {'Row': '81',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'Worldwide Trends on COVID-19 Research After the Declaration of COVID-19 Pandemic',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: Convalescent Plasma Transfusion\\nDrug: Hydroxychloroquine\\nDrug: DAS181\\n(and 2 more...)',\n",
       "  'Locations': ''},\n",
       " 82: {'Row': '82',\n",
       "  'Saved': '',\n",
       "  'Status': 'Completed',\n",
       "  'Study Title': 'Convalescent Plasma Treatment in COVID-19',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Biological: Convalescent Plasma (CP)\\nOther: Drugs and supportive care',\n",
       "  'Locations': 'Aga Khan University Hospital\\nKarachi, Sind, Pakistan'},\n",
       " 83: {'Row': '83',\n",
       "  'Saved': '',\n",
       "  'Status': 'Enrolling by invitation',\n",
       "  'Study Title': 'COVID 19 Seroprevalence Amongst Healthcare Workers in JHAH',\n",
       "  'Conditions': 'COVID 19',\n",
       "  'Interventions': 'Diagnostic Test: Serology Test',\n",
       "  'Locations': 'Johns Hopkins Aramco Healthcare\\nDhahran, Eastern, Saudi Arabia'},\n",
       " 84: {'Row': '84',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'Repurposing of Chlorpromazine in Covid-19 Treatment',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: CHLORPROMAZINE (CPZ)\\nCombination Product: Standard of Care (SOC)',\n",
       "  'Locations': 'Centre Hospitalier Sainte-Anne\\nParis, France'},\n",
       " 85: {'Row': '85',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'Indirect Endovenous Systemic Ozone for New Coronavirus Disease (COVID19) in Non-intubated Patients',\n",
       "  'Conditions': 'COVID',\n",
       "  'Interventions': 'Other: Systemic indirect endovenous ozone therapy',\n",
       "  'Locations': 'SEOT\\nValencia, Spain'},\n",
       " 86: {'Row': '86',\n",
       "  'Saved': '',\n",
       "  'Status': 'Withdrawn',\n",
       "  'Study Title': 'Selective Estrogen Modulation and Melatonin in Early COVID-19',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Drug: Toremifene\\nDrug: Melatonin\\nOther: Placebo',\n",
       "  'Locations': ''},\n",
       " 87: {'Row': '87',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting\\nNEW',\n",
       "  'Study Title': 'Prophylaxis of COVID-19 Disease With Ivermectin in COVID-19 Contact Persons [German: Prophylaxe Der COVID-19-Erkrankung Mit Ivermectin Bei COVID-19 Kontaktpersonen]',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Drug: Ivermectin\\nDrug: Placebo',\n",
       "  'Locations': ''},\n",
       " 88: {'Row': '88',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Virgin Coconut Oil as Adjunctive Therapy for Hospitalized COVID-19 Patients',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Drug: Virgin Coconut Oil',\n",
       "  'Locations': 'Philippine General Hospital\\nManila, Metro Manila, Philippines'},\n",
       " 89: {'Row': '89',\n",
       "  'Saved': '',\n",
       "  'Status': 'Active, not recruiting',\n",
       "  'Study Title': 'Pegylated Interferon Lambda Treatment for COVID-19',\n",
       "  'Conditions': 'COVID-19\\nCOVID',\n",
       "  'Interventions': 'Drug: Pegylated interferon lambda',\n",
       "  'Locations': 'Massachusetts General Hospital\\nBoston, Massachusetts, United States'},\n",
       " 90: {'Row': '90',\n",
       "  'Saved': '',\n",
       "  'Status': 'Active, not recruiting',\n",
       "  'Study Title': 'Phase III Double-blind, Placebo-controlled Study of AZD7442 for Post- Exposure Prophylaxis of COVID-19 in Adults',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: AZD7442\\nDrug: Placebo',\n",
       "  'Locations': 'Research Site\\nGuntersville, Alabama, United States\\nResearch Site\\nTempe, Arizona, United States\\nResearch Site\\nLittle Rock, Arkansas, United States\\n(and 54 more...)'},\n",
       " 91: {'Row': '91',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Ivermectin Treatment Efficacy in Covid-19 High Risk Patients',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: Ivermectin 0.4mg/kg/day for 5 days',\n",
       "  'Locations': 'Sultanah Aminah Hospital\\nJohor Bahru, Johor, Malaysia\\nSultanah Bahiyah Hospital\\nAlor Setar, Kadah, Malaysia\\nSultan Abdul Halim Hospital\\nSungai Petani, Kedah, Malaysia\\n(and 9 more...)'},\n",
       " 92: {'Row': '92',\n",
       "  'Saved': '',\n",
       "  'Status': 'Completed',\n",
       "  'Study Title': 'Gut Microbiota, \"Spark and Flame\" of COVID-19 Disease',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Other: Exposure',\n",
       "  'Locations': 'Hospital CUF Infante Santo, S.A.\\nLisbon, Portugal\\nHospital de São Francisco Xavier\\nLisbon, Portugal\\nCentro Hospitalar Universitário São João\\nOporto, Portugal'},\n",
       " 93: {'Row': '93',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'Isotretinoin in Treatment of COVID-19',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: Isotretinoin Only Product in Oral Dose Form',\n",
       "  'Locations': ''},\n",
       " 94: {'Row': '94',\n",
       "  'Saved': '',\n",
       "  'Status': 'Completed',\n",
       "  'Study Title': 'Colchicine in Moderate Symptomatic COVID-19 Patients',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Drug: Colchicine\\nDrug: Placebo',\n",
       "  'Locations': 'Dhaka Medical College Hospital\\nDhaka-1000, Bangladesh'},\n",
       " 95: {'Row': '95',\n",
       "  'Saved': '',\n",
       "  'Status': 'Terminated',\n",
       "  'Study Title': 'Inhaled Nitric Oxide for Preventing Progression in COVID-19',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: Nitric Oxide',\n",
       "  'Locations': 'Tufts Medical Center\\nBoston, Massachusetts, United States'},\n",
       " 96: {'Row': '96',\n",
       "  'Saved': '',\n",
       "  'Status': 'Completed',\n",
       "  'Study Title': 'Trial to Study the Adjuvant Benefits of Quercetin Phytosome in Patients With COVID-19',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': 'Drug: Standard COVID-19 care\\nDietary Supplement: Quercetin Phytosome',\n",
       "  'Locations': 'Liaquat University Hospital\\nJāmshoro, Sindh, Pakistan'},\n",
       " 97: {'Row': '97',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Serological Surveillance for COVID-19 in Central North Carolina',\n",
       "  'Conditions': 'COVID-19',\n",
       "  'Interventions': '',\n",
       "  'Locations': 'NIEHS Clinical Research Unit (CRU)\\nResearch Triangle Park, North Carolina, United States'},\n",
       " 98: {'Row': '98',\n",
       "  'Saved': '',\n",
       "  'Status': 'Not yet recruiting',\n",
       "  'Study Title': 'Effectiveness of Hydroxychloroquine in Covid-19 Patients',\n",
       "  'Conditions': 'COVID19',\n",
       "  'Interventions': 'Drug: Hydroxychloroquine 200 Mg Oral Tablet\\nDrug: Azithromycin 500Mg Oral Tablet\\nDietary Supplement: Glucose tablets',\n",
       "  'Locations': 'Ayub Teaching Institution\\nAbbottābād, K.p.k, Pakistan'},\n",
       " 99: {'Row': '99',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Efficacy and Safety of Sirolimus in COVID-19 Infection',\n",
       "  'Conditions': 'COVID 19',\n",
       "  'Interventions': 'Drug: Sirolimus',\n",
       "  'Locations': 'Faculty of Medicine, Alexandria university, Egypt\\nAlexandria, Egypt'},\n",
       " 100: {'Row': '100',\n",
       "  'Saved': '',\n",
       "  'Status': 'Recruiting',\n",
       "  'Study Title': 'Rehabilitation for Patients With Persistent Symptoms Post COVID-19',\n",
       "  'Conditions': 'Covid19',\n",
       "  'Interventions': 'Other: Concentrated rehabilitation for patients with persistent symptoms post COVID-19',\n",
       "  'Locations': 'Helse i Hardanger\\nØystese, Kvam Herad, Norway'}}"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_page_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Conditions</th>\n",
       "      <th>Interventions</th>\n",
       "      <th>Locations</th>\n",
       "      <th>Row</th>\n",
       "      <th>Saved</th>\n",
       "      <th>Status</th>\n",
       "      <th>Study Title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Behavioral: Saliva-based testing</td>\n",
       "      <td>Penn Medicine\\nPhiladelphia, Pennsylvania, Uni...</td>\n",
       "      <td>1</td>\n",
       "      <td></td>\n",
       "      <td>Enrolling by invitation</td>\n",
       "      <td>COVID SAFE: COVID-19 Screening Assessment for ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>COVID</td>\n",
       "      <td>Diagnostic Test: Q16 testing\\nDiagnostic Test:...</td>\n",
       "      <td>Queen Mary University London\\nLondon, United K...</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>CICERO- A Care Home Study of COVID-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Dexamethasone</td>\n",
       "      <td>University of Oklahoma Medical Center\\nOklahom...</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Dexamethasone for COVID-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Drug: Duvelisib\\nProcedure: Peripheral blood d...</td>\n",
       "      <td>Missouri Baptist Medical Center\\nSaint Louis, ...</td>\n",
       "      <td>4</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Duvelisib to Combat COVID-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Behavioral: NexJ Connected Wellness\\nOther: Us...</td>\n",
       "      <td></td>\n",
       "      <td>5</td>\n",
       "      <td></td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Enhancing COVID Rehabilitation With Technology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>COVID</td>\n",
       "      <td></td>\n",
       "      <td>Mansoura faculty of medicine\\nMansoura, Dakahl...</td>\n",
       "      <td>6</td>\n",
       "      <td></td>\n",
       "      <td>Active, not recruiting</td>\n",
       "      <td>Post Covid-19 Cardiopulmonary and Immunologica...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Infliximab\\nDrug: Abatacept\\nDrug: Remde...</td>\n",
       "      <td>Banner University Medical Center\\nPhoenix, Ari...</td>\n",
       "      <td>7</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Immune Modulators for Treating COVID-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Placebo\\nDrug: Fisetin</td>\n",
       "      <td>Mayo Clinic in Rochester\\nRochester, Minnesota...</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "      <td>Enrolling by invitation</td>\n",
       "      <td>COVID-FISETIN: Pilot in SARS-CoV-2 of Fisetin ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Other: Balance assessments</td>\n",
       "      <td>Duke University Health System\\nDurham, North C...</td>\n",
       "      <td>9</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Balance in COVID-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Ivermectin nasal\\nDrug: Ivermectin oral\\...</td>\n",
       "      <td></td>\n",
       "      <td>10</td>\n",
       "      <td></td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Ivermectin Nasal Spray for COVID19 Patients</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Diagnostic Test: Cycle threshold</td>\n",
       "      <td>SBMU\\nTehran, Iran, Islamic Republic of\\nNoosh...</td>\n",
       "      <td>11</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Relationship Between CT- Value With Prognosis ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>COVID-19</td>\n",
       "      <td></td>\n",
       "      <td>Department of Infectiology, Raymond Poincaré H...</td>\n",
       "      <td>12</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Observational Cohort of COVID-19 Patients at R...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Other: no intervention</td>\n",
       "      <td></td>\n",
       "      <td>13</td>\n",
       "      <td></td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Fugal Infection in COVID-19 Patients</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Biological: Amended LLS COVID-19 Registry</td>\n",
       "      <td>Lymphoma and Leukemia Society\\nRye Brook, New ...</td>\n",
       "      <td>14</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>The Lymphoma and Leukemia Society Amended COVI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Xuanfei Baidu Granules\\nOther: Placebo</td>\n",
       "      <td>University of Southern California\\nLos Angeles...</td>\n",
       "      <td>15</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Pilot Trial of XFBD, a TCM, in Persons With CO...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Diagnostic Test: Humoral and cellular immunity</td>\n",
       "      <td>Institute of Biophysics and Cell Engineering o...</td>\n",
       "      <td>16</td>\n",
       "      <td></td>\n",
       "      <td>Enrolling by invitation</td>\n",
       "      <td>Estimation of Dynamics of Humoral and Cellular...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Biological: COVI-MSC\\nDrug: Placebo</td>\n",
       "      <td></td>\n",
       "      <td>17</td>\n",
       "      <td></td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Study of Intravenous COVI-MSC for Treatment of...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Covid 19</td>\n",
       "      <td></td>\n",
       "      <td>Uh Montpellier\\nMontpellier, France</td>\n",
       "      <td>18</td>\n",
       "      <td></td>\n",
       "      <td>Completed</td>\n",
       "      <td>COVID 19 Serology in Pulmonologists</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>COVID-19</td>\n",
       "      <td></td>\n",
       "      <td>Peking University First Hospital\\nBeijing, Bei...</td>\n",
       "      <td>19</td>\n",
       "      <td></td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>COVID-19 Surveillance Based on Smart Wearable ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Biological: COVI-MSC\\nDrug: Placebo</td>\n",
       "      <td></td>\n",
       "      <td>20</td>\n",
       "      <td></td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Study of Allogeneic Adipose-Derived Mesenchyma...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Covid19</td>\n",
       "      <td></td>\n",
       "      <td>South Egypt Cancer Institute, Assiut Universit...</td>\n",
       "      <td>21</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Effect of COVID-19 Pandemic on Pediatric Cance...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Drug: Infliximab</td>\n",
       "      <td>Tufts Medical Center\\nBoston, Massachusetts, U...</td>\n",
       "      <td>22</td>\n",
       "      <td></td>\n",
       "      <td>Completed</td>\n",
       "      <td>A Phase 2 Trial of Infliximab in Coronavirus D...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Biological: COVI-AMG\\nDrug: Placebo</td>\n",
       "      <td></td>\n",
       "      <td>23</td>\n",
       "      <td></td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Study to Evaluate the Safety and Efficacy of a...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Biological: COVI-DROPS\\nDrug: Placebo</td>\n",
       "      <td></td>\n",
       "      <td>24</td>\n",
       "      <td></td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Study to Evaluate a Single Intranasal Dose of ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>COVID</td>\n",
       "      <td>Behavioral: Self-management booklet (SWitCh: S...</td>\n",
       "      <td>Online recruitment through Qualtrics\\nLondon, ...</td>\n",
       "      <td>25</td>\n",
       "      <td></td>\n",
       "      <td>Active, not recruiting</td>\n",
       "      <td>A Research Study to Evaluate the Benefits of a...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Biological: COVI-AMG\\nDrug: Placebo</td>\n",
       "      <td>Teradan Clinical Trials\\nBrandon, Florida, Uni...</td>\n",
       "      <td>26</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Study to Evaluate a Single Dose of STI-2020 (C...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Covid-19</td>\n",
       "      <td>Other: Model Building\\nOther: Model validation</td>\n",
       "      <td>Republic of Turkey, Health Sciences University...</td>\n",
       "      <td>27</td>\n",
       "      <td></td>\n",
       "      <td>Completed</td>\n",
       "      <td>Forecast Number of Covid-19 Cases Worldwide</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Device: Hyperbaric Oxygen Therapy</td>\n",
       "      <td>Ochsner Medical Center\\nNew Orleans, Louisiana...</td>\n",
       "      <td>28</td>\n",
       "      <td></td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Hyperbaric Oxygen Therapy (HBOT) as a Treatmen...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>COVID</td>\n",
       "      <td>Drug: Convalescent Plasma Transfusion\\nOther: ...</td>\n",
       "      <td>Maulana Azad medical College\\nNew Delhi, Delhi...</td>\n",
       "      <td>29</td>\n",
       "      <td></td>\n",
       "      <td>Completed</td>\n",
       "      <td>Efficacy of Convalescent Plasma Therapy in Sev...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Biological: COVI-AMG\\nDrug: Placebo</td>\n",
       "      <td>Collaborative NeuroScience Research, LLC\\nGard...</td>\n",
       "      <td>30</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Study to Evaluate a Single Dose of STI-2020 (C...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Combination Product: Iota carrageenan nasal sp...</td>\n",
       "      <td>Hospital Eurnekian\\nBuenos Aires, Argentina</td>\n",
       "      <td>71</td>\n",
       "      <td></td>\n",
       "      <td>Completed\\nHas Results</td>\n",
       "      <td>USEFULNESS of Topic Ivermectin and Carrageenan...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Biological: Lilly Bamlanivimab\\nBiological: Re...</td>\n",
       "      <td>UPMC\\nPittsburgh, Pennsylvania, United States</td>\n",
       "      <td>72</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>UPMC OPTIMISE-C19 Trial, a COVID-19 Study</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Other: Convalescent Plasma with antibody again...</td>\n",
       "      <td>University Hospital Son Llatzer\\nPalma De Mall...</td>\n",
       "      <td>73</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Efficacy of Reinforcing Standard Therapy in CO...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Placebo\\nDrug: Fluvoxamine</td>\n",
       "      <td>Dél-pesti Centrumkórház\\nBudapest, Hungary\\nSe...</td>\n",
       "      <td>74</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Fluvoxamine Administration in Moderate SARS-Co...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Long COVID</td>\n",
       "      <td>Drug: sodium pyruvate nasal spray</td>\n",
       "      <td>Missouri State University\\nSpringfield, Missou...</td>\n",
       "      <td>75</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Effects of Sodium Pyruvate Nasal Spray in COVI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Biological: TURCOVAC\\nBiological: CoronaVac</td>\n",
       "      <td>T.R. Ministry of Health Ankara City Hospital, ...</td>\n",
       "      <td>76</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Efficacy, Immunogenicity, and Safety of the In...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>COVID-19</td>\n",
       "      <td></td>\n",
       "      <td>Renji Hospital, Shanghai Jiaotong University S...</td>\n",
       "      <td>77</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Long-term Outcomes in Patients With COVID-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Behavioral: Philly Vax Sweepstakes</td>\n",
       "      <td>University of Pennsylvania\\nPhiladelphia, Penn...</td>\n",
       "      <td>78</td>\n",
       "      <td></td>\n",
       "      <td>Active, not recruiting</td>\n",
       "      <td>COVID-19 Vaccinations With a Sweepstakes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Enoxaparin</td>\n",
       "      <td>Azienda Socio Sanitaria Territoriale Grande Os...</td>\n",
       "      <td>79</td>\n",
       "      <td></td>\n",
       "      <td>Completed</td>\n",
       "      <td>Comparison of Two Doses of Enoxaparin for Thro...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>COVID</td>\n",
       "      <td>Biological: Mesenchymal cells\\nDrug: Standard ...</td>\n",
       "      <td>Hospital Universitario de Getafe\\nGetafe, Madr...</td>\n",
       "      <td>80</td>\n",
       "      <td></td>\n",
       "      <td>Withdrawn</td>\n",
       "      <td>Clinical Trial of Allogeneic Mesenchymal Cells...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Drug: Convalescent Plasma Transfusion\\nDrug: H...</td>\n",
       "      <td></td>\n",
       "      <td>81</td>\n",
       "      <td></td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Worldwide Trends on COVID-19 Research After th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Biological: Convalescent Plasma (CP)\\nOther: D...</td>\n",
       "      <td>Aga Khan University Hospital\\nKarachi, Sind, P...</td>\n",
       "      <td>82</td>\n",
       "      <td></td>\n",
       "      <td>Completed</td>\n",
       "      <td>Convalescent Plasma Treatment in COVID-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>COVID 19</td>\n",
       "      <td>Diagnostic Test: Serology Test</td>\n",
       "      <td>Johns Hopkins Aramco Healthcare\\nDhahran, East...</td>\n",
       "      <td>83</td>\n",
       "      <td></td>\n",
       "      <td>Enrolling by invitation</td>\n",
       "      <td>COVID 19 Seroprevalence Amongst Healthcare Wor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Drug: CHLORPROMAZINE (CPZ)\\nCombination Produc...</td>\n",
       "      <td>Centre Hospitalier Sainte-Anne\\nParis, France</td>\n",
       "      <td>84</td>\n",
       "      <td></td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Repurposing of Chlorpromazine in Covid-19 Trea...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>COVID</td>\n",
       "      <td>Other: Systemic indirect endovenous ozone therapy</td>\n",
       "      <td>SEOT\\nValencia, Spain</td>\n",
       "      <td>85</td>\n",
       "      <td></td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Indirect Endovenous Systemic Ozone for New Cor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Toremifene\\nDrug: Melatonin\\nOther: Placebo</td>\n",
       "      <td></td>\n",
       "      <td>86</td>\n",
       "      <td></td>\n",
       "      <td>Withdrawn</td>\n",
       "      <td>Selective Estrogen Modulation and Melatonin in...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Ivermectin\\nDrug: Placebo</td>\n",
       "      <td></td>\n",
       "      <td>87</td>\n",
       "      <td></td>\n",
       "      <td>Not yet recruiting\\nNEW</td>\n",
       "      <td>Prophylaxis of COVID-19 Disease With Ivermecti...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Virgin Coconut Oil</td>\n",
       "      <td>Philippine General Hospital\\nManila, Metro Man...</td>\n",
       "      <td>88</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Virgin Coconut Oil as Adjunctive Therapy for H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>COVID-19\\nCOVID</td>\n",
       "      <td>Drug: Pegylated interferon lambda</td>\n",
       "      <td>Massachusetts General Hospital\\nBoston, Massac...</td>\n",
       "      <td>89</td>\n",
       "      <td></td>\n",
       "      <td>Active, not recruiting</td>\n",
       "      <td>Pegylated Interferon Lambda Treatment for COVI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Drug: AZD7442\\nDrug: Placebo</td>\n",
       "      <td>Research Site\\nGuntersville, Alabama, United S...</td>\n",
       "      <td>90</td>\n",
       "      <td></td>\n",
       "      <td>Active, not recruiting</td>\n",
       "      <td>Phase III Double-blind, Placebo-controlled Stu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Drug: Ivermectin 0.4mg/kg/day for 5 days</td>\n",
       "      <td>Sultanah Aminah Hospital\\nJohor Bahru, Johor, ...</td>\n",
       "      <td>91</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Ivermectin Treatment Efficacy in Covid-19 High...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Other: Exposure</td>\n",
       "      <td>Hospital CUF Infante Santo, S.A.\\nLisbon, Port...</td>\n",
       "      <td>92</td>\n",
       "      <td></td>\n",
       "      <td>Completed</td>\n",
       "      <td>Gut Microbiota, \"Spark and Flame\" of COVID-19 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Drug: Isotretinoin Only Product in Oral Dose Form</td>\n",
       "      <td></td>\n",
       "      <td>93</td>\n",
       "      <td></td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Isotretinoin in Treatment of COVID-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Colchicine\\nDrug: Placebo</td>\n",
       "      <td>Dhaka Medical College Hospital\\nDhaka-1000, Ba...</td>\n",
       "      <td>94</td>\n",
       "      <td></td>\n",
       "      <td>Completed</td>\n",
       "      <td>Colchicine in Moderate Symptomatic COVID-19 Pa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Drug: Nitric Oxide</td>\n",
       "      <td>Tufts Medical Center\\nBoston, Massachusetts, U...</td>\n",
       "      <td>95</td>\n",
       "      <td></td>\n",
       "      <td>Terminated</td>\n",
       "      <td>Inhaled Nitric Oxide for Preventing Progressio...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Drug: Standard COVID-19 care\\nDietary Suppleme...</td>\n",
       "      <td>Liaquat University Hospital\\nJāmshoro, Sindh, ...</td>\n",
       "      <td>96</td>\n",
       "      <td></td>\n",
       "      <td>Completed</td>\n",
       "      <td>Trial to Study the Adjuvant Benefits of Querce...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>COVID-19</td>\n",
       "      <td></td>\n",
       "      <td>NIEHS Clinical Research Unit (CRU)\\nResearch T...</td>\n",
       "      <td>97</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Serological Surveillance for COVID-19 in Centr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>COVID19</td>\n",
       "      <td>Drug: Hydroxychloroquine 200 Mg Oral Tablet\\nD...</td>\n",
       "      <td>Ayub Teaching Institution\\nAbbottābād, K.p.k, ...</td>\n",
       "      <td>98</td>\n",
       "      <td></td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Effectiveness of Hydroxychloroquine in Covid-1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>COVID 19</td>\n",
       "      <td>Drug: Sirolimus</td>\n",
       "      <td>Faculty of Medicine, Alexandria university, Eg...</td>\n",
       "      <td>99</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Efficacy and Safety of Sirolimus in COVID-19 I...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>Covid19</td>\n",
       "      <td>Other: Concentrated rehabilitation for patient...</td>\n",
       "      <td>Helse i Hardanger\\nØystese, Kvam Herad, Norway</td>\n",
       "      <td>100</td>\n",
       "      <td></td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Rehabilitation for Patients With Persistent Sy...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          Conditions                                      Interventions  \\\n",
       "1            Covid19                   Behavioral: Saliva-based testing   \n",
       "2              COVID  Diagnostic Test: Q16 testing\\nDiagnostic Test:...   \n",
       "3            Covid19                                Drug: Dexamethasone   \n",
       "4           COVID-19  Drug: Duvelisib\\nProcedure: Peripheral blood d...   \n",
       "5            Covid19  Behavioral: NexJ Connected Wellness\\nOther: Us...   \n",
       "6              COVID                                                      \n",
       "7            Covid19  Drug: Infliximab\\nDrug: Abatacept\\nDrug: Remde...   \n",
       "8            Covid19                       Drug: Placebo\\nDrug: Fisetin   \n",
       "9            Covid19                         Other: Balance assessments   \n",
       "10           Covid19  Drug: Ivermectin nasal\\nDrug: Ivermectin oral\\...   \n",
       "11          COVID-19                   Diagnostic Test: Cycle threshold   \n",
       "12          COVID-19                                                      \n",
       "13           Covid19                             Other: no intervention   \n",
       "14           Covid19          Biological: Amended LLS COVID-19 Registry   \n",
       "15           Covid19       Drug: Xuanfei Baidu Granules\\nOther: Placebo   \n",
       "16           Covid19     Diagnostic Test: Humoral and cellular immunity   \n",
       "17           Covid19                Biological: COVI-MSC\\nDrug: Placebo   \n",
       "18          Covid 19                                                      \n",
       "19          COVID-19                                                      \n",
       "20           Covid19                Biological: COVI-MSC\\nDrug: Placebo   \n",
       "21           Covid19                                                      \n",
       "22          COVID-19                                   Drug: Infliximab   \n",
       "23           Covid19                Biological: COVI-AMG\\nDrug: Placebo   \n",
       "24           Covid19              Biological: COVI-DROPS\\nDrug: Placebo   \n",
       "25             COVID  Behavioral: Self-management booklet (SWitCh: S...   \n",
       "26           Covid19                Biological: COVI-AMG\\nDrug: Placebo   \n",
       "27          Covid-19     Other: Model Building\\nOther: Model validation   \n",
       "28          COVID-19                  Device: Hyperbaric Oxygen Therapy   \n",
       "29             COVID  Drug: Convalescent Plasma Transfusion\\nOther: ...   \n",
       "30           Covid19                Biological: COVI-AMG\\nDrug: Placebo   \n",
       "..               ...                                                ...   \n",
       "71           Covid19  Combination Product: Iota carrageenan nasal sp...   \n",
       "72           Covid19  Biological: Lilly Bamlanivimab\\nBiological: Re...   \n",
       "73           Covid19  Other: Convalescent Plasma with antibody again...   \n",
       "74           Covid19                   Drug: Placebo\\nDrug: Fluvoxamine   \n",
       "75        Long COVID                  Drug: sodium pyruvate nasal spray   \n",
       "76           Covid19        Biological: TURCOVAC\\nBiological: CoronaVac   \n",
       "77          COVID-19                                                      \n",
       "78           Covid19                 Behavioral: Philly Vax Sweepstakes   \n",
       "79           Covid19                                   Drug: Enoxaparin   \n",
       "80             COVID  Biological: Mesenchymal cells\\nDrug: Standard ...   \n",
       "81          COVID-19  Drug: Convalescent Plasma Transfusion\\nDrug: H...   \n",
       "82           Covid19  Biological: Convalescent Plasma (CP)\\nOther: D...   \n",
       "83          COVID 19                     Diagnostic Test: Serology Test   \n",
       "84          COVID-19  Drug: CHLORPROMAZINE (CPZ)\\nCombination Produc...   \n",
       "85             COVID  Other: Systemic indirect endovenous ozone therapy   \n",
       "86           Covid19  Drug: Toremifene\\nDrug: Melatonin\\nOther: Placebo   \n",
       "87           Covid19                    Drug: Ivermectin\\nDrug: Placebo   \n",
       "88           Covid19                           Drug: Virgin Coconut Oil   \n",
       "89   COVID-19\\nCOVID                  Drug: Pegylated interferon lambda   \n",
       "90          COVID-19                       Drug: AZD7442\\nDrug: Placebo   \n",
       "91          COVID-19           Drug: Ivermectin 0.4mg/kg/day for 5 days   \n",
       "92          COVID-19                                    Other: Exposure   \n",
       "93          COVID-19  Drug: Isotretinoin Only Product in Oral Dose Form   \n",
       "94           Covid19                    Drug: Colchicine\\nDrug: Placebo   \n",
       "95          COVID-19                                 Drug: Nitric Oxide   \n",
       "96          COVID-19  Drug: Standard COVID-19 care\\nDietary Suppleme...   \n",
       "97          COVID-19                                                      \n",
       "98           COVID19  Drug: Hydroxychloroquine 200 Mg Oral Tablet\\nD...   \n",
       "99          COVID 19                                    Drug: Sirolimus   \n",
       "100          Covid19  Other: Concentrated rehabilitation for patient...   \n",
       "\n",
       "                                             Locations  Row Saved  \\\n",
       "1    Penn Medicine\\nPhiladelphia, Pennsylvania, Uni...    1         \n",
       "2    Queen Mary University London\\nLondon, United K...    2         \n",
       "3    University of Oklahoma Medical Center\\nOklahom...    3         \n",
       "4    Missouri Baptist Medical Center\\nSaint Louis, ...    4         \n",
       "5                                                         5         \n",
       "6    Mansoura faculty of medicine\\nMansoura, Dakahl...    6         \n",
       "7    Banner University Medical Center\\nPhoenix, Ari...    7         \n",
       "8    Mayo Clinic in Rochester\\nRochester, Minnesota...    8         \n",
       "9    Duke University Health System\\nDurham, North C...    9         \n",
       "10                                                       10         \n",
       "11   SBMU\\nTehran, Iran, Islamic Republic of\\nNoosh...   11         \n",
       "12   Department of Infectiology, Raymond Poincaré H...   12         \n",
       "13                                                       13         \n",
       "14   Lymphoma and Leukemia Society\\nRye Brook, New ...   14         \n",
       "15   University of Southern California\\nLos Angeles...   15         \n",
       "16   Institute of Biophysics and Cell Engineering o...   16         \n",
       "17                                                       17         \n",
       "18                 Uh Montpellier\\nMontpellier, France   18         \n",
       "19   Peking University First Hospital\\nBeijing, Bei...   19         \n",
       "20                                                       20         \n",
       "21   South Egypt Cancer Institute, Assiut Universit...   21         \n",
       "22   Tufts Medical Center\\nBoston, Massachusetts, U...   22         \n",
       "23                                                       23         \n",
       "24                                                       24         \n",
       "25   Online recruitment through Qualtrics\\nLondon, ...   25         \n",
       "26   Teradan Clinical Trials\\nBrandon, Florida, Uni...   26         \n",
       "27   Republic of Turkey, Health Sciences University...   27         \n",
       "28   Ochsner Medical Center\\nNew Orleans, Louisiana...   28         \n",
       "29   Maulana Azad medical College\\nNew Delhi, Delhi...   29         \n",
       "30   Collaborative NeuroScience Research, LLC\\nGard...   30         \n",
       "..                                                 ...  ...   ...   \n",
       "71         Hospital Eurnekian\\nBuenos Aires, Argentina   71         \n",
       "72       UPMC\\nPittsburgh, Pennsylvania, United States   72         \n",
       "73   University Hospital Son Llatzer\\nPalma De Mall...   73         \n",
       "74   Dél-pesti Centrumkórház\\nBudapest, Hungary\\nSe...   74         \n",
       "75   Missouri State University\\nSpringfield, Missou...   75         \n",
       "76   T.R. Ministry of Health Ankara City Hospital, ...   76         \n",
       "77   Renji Hospital, Shanghai Jiaotong University S...   77         \n",
       "78   University of Pennsylvania\\nPhiladelphia, Penn...   78         \n",
       "79   Azienda Socio Sanitaria Territoriale Grande Os...   79         \n",
       "80   Hospital Universitario de Getafe\\nGetafe, Madr...   80         \n",
       "81                                                       81         \n",
       "82   Aga Khan University Hospital\\nKarachi, Sind, P...   82         \n",
       "83   Johns Hopkins Aramco Healthcare\\nDhahran, East...   83         \n",
       "84       Centre Hospitalier Sainte-Anne\\nParis, France   84         \n",
       "85                               SEOT\\nValencia, Spain   85         \n",
       "86                                                       86         \n",
       "87                                                       87         \n",
       "88   Philippine General Hospital\\nManila, Metro Man...   88         \n",
       "89   Massachusetts General Hospital\\nBoston, Massac...   89         \n",
       "90   Research Site\\nGuntersville, Alabama, United S...   90         \n",
       "91   Sultanah Aminah Hospital\\nJohor Bahru, Johor, ...   91         \n",
       "92   Hospital CUF Infante Santo, S.A.\\nLisbon, Port...   92         \n",
       "93                                                       93         \n",
       "94   Dhaka Medical College Hospital\\nDhaka-1000, Ba...   94         \n",
       "95   Tufts Medical Center\\nBoston, Massachusetts, U...   95         \n",
       "96   Liaquat University Hospital\\nJāmshoro, Sindh, ...   96         \n",
       "97   NIEHS Clinical Research Unit (CRU)\\nResearch T...   97         \n",
       "98   Ayub Teaching Institution\\nAbbottābād, K.p.k, ...   98         \n",
       "99   Faculty of Medicine, Alexandria university, Eg...   99         \n",
       "100     Helse i Hardanger\\nØystese, Kvam Herad, Norway  100         \n",
       "\n",
       "                      Status  \\\n",
       "1    Enrolling by invitation   \n",
       "2         Not yet recruiting   \n",
       "3                 Recruiting   \n",
       "4                 Recruiting   \n",
       "5         Not yet recruiting   \n",
       "6     Active, not recruiting   \n",
       "7                 Recruiting   \n",
       "8    Enrolling by invitation   \n",
       "9                 Recruiting   \n",
       "10        Not yet recruiting   \n",
       "11                Recruiting   \n",
       "12                Recruiting   \n",
       "13        Not yet recruiting   \n",
       "14                Recruiting   \n",
       "15                Recruiting   \n",
       "16   Enrolling by invitation   \n",
       "17        Not yet recruiting   \n",
       "18                 Completed   \n",
       "19        Not yet recruiting   \n",
       "20        Not yet recruiting   \n",
       "21                Recruiting   \n",
       "22                 Completed   \n",
       "23        Not yet recruiting   \n",
       "24        Not yet recruiting   \n",
       "25    Active, not recruiting   \n",
       "26                Recruiting   \n",
       "27                 Completed   \n",
       "28        Not yet recruiting   \n",
       "29                 Completed   \n",
       "30                Recruiting   \n",
       "..                       ...   \n",
       "71    Completed\\nHas Results   \n",
       "72                Recruiting   \n",
       "73                Recruiting   \n",
       "74                Recruiting   \n",
       "75                Recruiting   \n",
       "76                Recruiting   \n",
       "77                Recruiting   \n",
       "78    Active, not recruiting   \n",
       "79                 Completed   \n",
       "80                 Withdrawn   \n",
       "81        Not yet recruiting   \n",
       "82                 Completed   \n",
       "83   Enrolling by invitation   \n",
       "84        Not yet recruiting   \n",
       "85        Not yet recruiting   \n",
       "86                 Withdrawn   \n",
       "87   Not yet recruiting\\nNEW   \n",
       "88                Recruiting   \n",
       "89    Active, not recruiting   \n",
       "90    Active, not recruiting   \n",
       "91                Recruiting   \n",
       "92                 Completed   \n",
       "93        Not yet recruiting   \n",
       "94                 Completed   \n",
       "95                Terminated   \n",
       "96                 Completed   \n",
       "97                Recruiting   \n",
       "98        Not yet recruiting   \n",
       "99                Recruiting   \n",
       "100               Recruiting   \n",
       "\n",
       "                                           Study Title  \n",
       "1    COVID SAFE: COVID-19 Screening Assessment for ...  \n",
       "2                CICERO- A Care Home Study of COVID-19  \n",
       "3                           Dexamethasone for COVID-19  \n",
       "4                         Duvelisib to Combat COVID-19  \n",
       "5       Enhancing COVID Rehabilitation With Technology  \n",
       "6    Post Covid-19 Cardiopulmonary and Immunologica...  \n",
       "7              Immune Modulators for Treating COVID-19  \n",
       "8    COVID-FISETIN: Pilot in SARS-CoV-2 of Fisetin ...  \n",
       "9                                  Balance in COVID-19  \n",
       "10         Ivermectin Nasal Spray for COVID19 Patients  \n",
       "11   Relationship Between CT- Value With Prognosis ...  \n",
       "12   Observational Cohort of COVID-19 Patients at R...  \n",
       "13                Fugal Infection in COVID-19 Patients  \n",
       "14   The Lymphoma and Leukemia Society Amended COVI...  \n",
       "15   Pilot Trial of XFBD, a TCM, in Persons With CO...  \n",
       "16   Estimation of Dynamics of Humoral and Cellular...  \n",
       "17   Study of Intravenous COVI-MSC for Treatment of...  \n",
       "18                 COVID 19 Serology in Pulmonologists  \n",
       "19   COVID-19 Surveillance Based on Smart Wearable ...  \n",
       "20   Study of Allogeneic Adipose-Derived Mesenchyma...  \n",
       "21   Effect of COVID-19 Pandemic on Pediatric Cance...  \n",
       "22   A Phase 2 Trial of Infliximab in Coronavirus D...  \n",
       "23   Study to Evaluate the Safety and Efficacy of a...  \n",
       "24   Study to Evaluate a Single Intranasal Dose of ...  \n",
       "25   A Research Study to Evaluate the Benefits of a...  \n",
       "26   Study to Evaluate a Single Dose of STI-2020 (C...  \n",
       "27         Forecast Number of Covid-19 Cases Worldwide  \n",
       "28   Hyperbaric Oxygen Therapy (HBOT) as a Treatmen...  \n",
       "29   Efficacy of Convalescent Plasma Therapy in Sev...  \n",
       "30   Study to Evaluate a Single Dose of STI-2020 (C...  \n",
       "..                                                 ...  \n",
       "71   USEFULNESS of Topic Ivermectin and Carrageenan...  \n",
       "72           UPMC OPTIMISE-C19 Trial, a COVID-19 Study  \n",
       "73   Efficacy of Reinforcing Standard Therapy in CO...  \n",
       "74   Fluvoxamine Administration in Moderate SARS-Co...  \n",
       "75   Effects of Sodium Pyruvate Nasal Spray in COVI...  \n",
       "76   Efficacy, Immunogenicity, and Safety of the In...  \n",
       "77        Long-term Outcomes in Patients With COVID-19  \n",
       "78            COVID-19 Vaccinations With a Sweepstakes  \n",
       "79   Comparison of Two Doses of Enoxaparin for Thro...  \n",
       "80   Clinical Trial of Allogeneic Mesenchymal Cells...  \n",
       "81   Worldwide Trends on COVID-19 Research After th...  \n",
       "82           Convalescent Plasma Treatment in COVID-19  \n",
       "83   COVID 19 Seroprevalence Amongst Healthcare Wor...  \n",
       "84   Repurposing of Chlorpromazine in Covid-19 Trea...  \n",
       "85   Indirect Endovenous Systemic Ozone for New Cor...  \n",
       "86   Selective Estrogen Modulation and Melatonin in...  \n",
       "87   Prophylaxis of COVID-19 Disease With Ivermecti...  \n",
       "88   Virgin Coconut Oil as Adjunctive Therapy for H...  \n",
       "89   Pegylated Interferon Lambda Treatment for COVI...  \n",
       "90   Phase III Double-blind, Placebo-controlled Stu...  \n",
       "91   Ivermectin Treatment Efficacy in Covid-19 High...  \n",
       "92   Gut Microbiota, \"Spark and Flame\" of COVID-19 ...  \n",
       "93               Isotretinoin in Treatment of COVID-19  \n",
       "94   Colchicine in Moderate Symptomatic COVID-19 Pa...  \n",
       "95   Inhaled Nitric Oxide for Preventing Progressio...  \n",
       "96   Trial to Study the Adjuvant Benefits of Querce...  \n",
       "97   Serological Surveillance for COVID-19 in Centr...  \n",
       "98   Effectiveness of Hydroxychloroquine in Covid-1...  \n",
       "99   Efficacy and Safety of Sirolimus in COVID-19 I...  \n",
       "100  Rehabilitation for Patients With Persistent Sy...  \n",
       "\n",
       "[100 rows x 7 columns]"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "raw_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Number</th>\n",
       "      <th>Study_Paticipant_Recruitment_Status</th>\n",
       "      <th>Study_Title</th>\n",
       "      <th>Conditions</th>\n",
       "      <th>Interventions</th>\n",
       "      <th>Locations</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Enrolling by invitation</td>\n",
       "      <td>COVID SAFE: COVID-19 Screening Assessment for ...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Behavioral: Saliva-based testing</td>\n",
       "      <td>Penn Medicine\\nPhiladelphia, Pennsylvania, Uni...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>CICERO- A Care Home Study of COVID-19</td>\n",
       "      <td>COVID</td>\n",
       "      <td>Diagnostic Test: Q16 testing\\nDiagnostic Test:...</td>\n",
       "      <td>Queen Mary University London\\nLondon, United K...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Dexamethasone for COVID-19</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Dexamethasone</td>\n",
       "      <td>University of Oklahoma Medical Center\\nOklahom...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Duvelisib to Combat COVID-19</td>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Drug: Duvelisib\\nProcedure: Peripheral blood d...</td>\n",
       "      <td>Missouri Baptist Medical Center\\nSaint Louis, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Enhancing COVID Rehabilitation With Technology</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Behavioral: NexJ Connected Wellness\\nOther: Us...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>Active, not recruiting</td>\n",
       "      <td>Post Covid-19 Cardiopulmonary and Immunologica...</td>\n",
       "      <td>COVID</td>\n",
       "      <td></td>\n",
       "      <td>Mansoura faculty of medicine\\nMansoura, Dakahl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Immune Modulators for Treating COVID-19</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Infliximab\\nDrug: Abatacept\\nDrug: Remde...</td>\n",
       "      <td>Banner University Medical Center\\nPhoenix, Ari...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>Enrolling by invitation</td>\n",
       "      <td>COVID-FISETIN: Pilot in SARS-CoV-2 of Fisetin ...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Placebo\\nDrug: Fisetin</td>\n",
       "      <td>Mayo Clinic in Rochester\\nRochester, Minnesota...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Balance in COVID-19</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Other: Balance assessments</td>\n",
       "      <td>Duke University Health System\\nDurham, North C...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Ivermectin Nasal Spray for COVID19 Patients</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Ivermectin nasal\\nDrug: Ivermectin oral\\...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Relationship Between CT- Value With Prognosis ...</td>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Diagnostic Test: Cycle threshold</td>\n",
       "      <td>SBMU\\nTehran, Iran, Islamic Republic of\\nNoosh...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Observational Cohort of COVID-19 Patients at R...</td>\n",
       "      <td>COVID-19</td>\n",
       "      <td></td>\n",
       "      <td>Department of Infectiology, Raymond Poincaré H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Fugal Infection in COVID-19 Patients</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Other: no intervention</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>The Lymphoma and Leukemia Society Amended COVI...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Biological: Amended LLS COVID-19 Registry</td>\n",
       "      <td>Lymphoma and Leukemia Society\\nRye Brook, New ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Pilot Trial of XFBD, a TCM, in Persons With CO...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Xuanfei Baidu Granules\\nOther: Placebo</td>\n",
       "      <td>University of Southern California\\nLos Angeles...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>Enrolling by invitation</td>\n",
       "      <td>Estimation of Dynamics of Humoral and Cellular...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Diagnostic Test: Humoral and cellular immunity</td>\n",
       "      <td>Institute of Biophysics and Cell Engineering o...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Study of Intravenous COVI-MSC for Treatment of...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Biological: COVI-MSC\\nDrug: Placebo</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>Completed</td>\n",
       "      <td>COVID 19 Serology in Pulmonologists</td>\n",
       "      <td>Covid 19</td>\n",
       "      <td></td>\n",
       "      <td>Uh Montpellier\\nMontpellier, France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>COVID-19 Surveillance Based on Smart Wearable ...</td>\n",
       "      <td>COVID-19</td>\n",
       "      <td></td>\n",
       "      <td>Peking University First Hospital\\nBeijing, Bei...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Study of Allogeneic Adipose-Derived Mesenchyma...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Biological: COVI-MSC\\nDrug: Placebo</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Effect of COVID-19 Pandemic on Pediatric Cance...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td></td>\n",
       "      <td>South Egypt Cancer Institute, Assiut Universit...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>Completed</td>\n",
       "      <td>A Phase 2 Trial of Infliximab in Coronavirus D...</td>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Drug: Infliximab</td>\n",
       "      <td>Tufts Medical Center\\nBoston, Massachusetts, U...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Study to Evaluate the Safety and Efficacy of a...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Biological: COVI-AMG\\nDrug: Placebo</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Study to Evaluate a Single Intranasal Dose of ...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Biological: COVI-DROPS\\nDrug: Placebo</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>Active, not recruiting</td>\n",
       "      <td>A Research Study to Evaluate the Benefits of a...</td>\n",
       "      <td>COVID</td>\n",
       "      <td>Behavioral: Self-management booklet (SWitCh: S...</td>\n",
       "      <td>Online recruitment through Qualtrics\\nLondon, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Study to Evaluate a Single Dose of STI-2020 (C...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Biological: COVI-AMG\\nDrug: Placebo</td>\n",
       "      <td>Teradan Clinical Trials\\nBrandon, Florida, Uni...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>Completed</td>\n",
       "      <td>Forecast Number of Covid-19 Cases Worldwide</td>\n",
       "      <td>Covid-19</td>\n",
       "      <td>Other: Model Building\\nOther: Model validation</td>\n",
       "      <td>Republic of Turkey, Health Sciences University...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Hyperbaric Oxygen Therapy (HBOT) as a Treatmen...</td>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Device: Hyperbaric Oxygen Therapy</td>\n",
       "      <td>Ochsner Medical Center\\nNew Orleans, Louisiana...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>Completed</td>\n",
       "      <td>Efficacy of Convalescent Plasma Therapy in Sev...</td>\n",
       "      <td>COVID</td>\n",
       "      <td>Drug: Convalescent Plasma Transfusion\\nOther: ...</td>\n",
       "      <td>Maulana Azad medical College\\nNew Delhi, Delhi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>30</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Study to Evaluate a Single Dose of STI-2020 (C...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Biological: COVI-AMG\\nDrug: Placebo</td>\n",
       "      <td>Collaborative NeuroScience Research, LLC\\nGard...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>71</td>\n",
       "      <td>Completed\\nHas Results</td>\n",
       "      <td>USEFULNESS of Topic Ivermectin and Carrageenan...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Combination Product: Iota carrageenan nasal sp...</td>\n",
       "      <td>Hospital Eurnekian\\nBuenos Aires, Argentina</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>72</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>UPMC OPTIMISE-C19 Trial, a COVID-19 Study</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Biological: Lilly Bamlanivimab\\nBiological: Re...</td>\n",
       "      <td>UPMC\\nPittsburgh, Pennsylvania, United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>73</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Efficacy of Reinforcing Standard Therapy in CO...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Other: Convalescent Plasma with antibody again...</td>\n",
       "      <td>University Hospital Son Llatzer\\nPalma De Mall...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>74</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Fluvoxamine Administration in Moderate SARS-Co...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Placebo\\nDrug: Fluvoxamine</td>\n",
       "      <td>Dél-pesti Centrumkórház\\nBudapest, Hungary\\nSe...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>75</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Effects of Sodium Pyruvate Nasal Spray in COVI...</td>\n",
       "      <td>Long COVID</td>\n",
       "      <td>Drug: sodium pyruvate nasal spray</td>\n",
       "      <td>Missouri State University\\nSpringfield, Missou...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>76</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Efficacy, Immunogenicity, and Safety of the In...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Biological: TURCOVAC\\nBiological: CoronaVac</td>\n",
       "      <td>T.R. Ministry of Health Ankara City Hospital, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>77</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Long-term Outcomes in Patients With COVID-19</td>\n",
       "      <td>COVID-19</td>\n",
       "      <td></td>\n",
       "      <td>Renji Hospital, Shanghai Jiaotong University S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>78</td>\n",
       "      <td>Active, not recruiting</td>\n",
       "      <td>COVID-19 Vaccinations With a Sweepstakes</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Behavioral: Philly Vax Sweepstakes</td>\n",
       "      <td>University of Pennsylvania\\nPhiladelphia, Penn...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>79</td>\n",
       "      <td>Completed</td>\n",
       "      <td>Comparison of Two Doses of Enoxaparin for Thro...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Enoxaparin</td>\n",
       "      <td>Azienda Socio Sanitaria Territoriale Grande Os...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>80</td>\n",
       "      <td>Withdrawn</td>\n",
       "      <td>Clinical Trial of Allogeneic Mesenchymal Cells...</td>\n",
       "      <td>COVID</td>\n",
       "      <td>Biological: Mesenchymal cells\\nDrug: Standard ...</td>\n",
       "      <td>Hospital Universitario de Getafe\\nGetafe, Madr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>81</td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Worldwide Trends on COVID-19 Research After th...</td>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Drug: Convalescent Plasma Transfusion\\nDrug: H...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>82</td>\n",
       "      <td>Completed</td>\n",
       "      <td>Convalescent Plasma Treatment in COVID-19</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Biological: Convalescent Plasma (CP)\\nOther: D...</td>\n",
       "      <td>Aga Khan University Hospital\\nKarachi, Sind, P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>83</td>\n",
       "      <td>Enrolling by invitation</td>\n",
       "      <td>COVID 19 Seroprevalence Amongst Healthcare Wor...</td>\n",
       "      <td>COVID 19</td>\n",
       "      <td>Diagnostic Test: Serology Test</td>\n",
       "      <td>Johns Hopkins Aramco Healthcare\\nDhahran, East...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>84</td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Repurposing of Chlorpromazine in Covid-19 Trea...</td>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Drug: CHLORPROMAZINE (CPZ)\\nCombination Produc...</td>\n",
       "      <td>Centre Hospitalier Sainte-Anne\\nParis, France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>85</td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Indirect Endovenous Systemic Ozone for New Cor...</td>\n",
       "      <td>COVID</td>\n",
       "      <td>Other: Systemic indirect endovenous ozone therapy</td>\n",
       "      <td>SEOT\\nValencia, Spain</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>86</td>\n",
       "      <td>Withdrawn</td>\n",
       "      <td>Selective Estrogen Modulation and Melatonin in...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Toremifene\\nDrug: Melatonin\\nOther: Placebo</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>87</td>\n",
       "      <td>Not yet recruiting\\nNEW</td>\n",
       "      <td>Prophylaxis of COVID-19 Disease With Ivermecti...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Ivermectin\\nDrug: Placebo</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>88</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Virgin Coconut Oil as Adjunctive Therapy for H...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Virgin Coconut Oil</td>\n",
       "      <td>Philippine General Hospital\\nManila, Metro Man...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>89</td>\n",
       "      <td>Active, not recruiting</td>\n",
       "      <td>Pegylated Interferon Lambda Treatment for COVI...</td>\n",
       "      <td>COVID-19\\nCOVID</td>\n",
       "      <td>Drug: Pegylated interferon lambda</td>\n",
       "      <td>Massachusetts General Hospital\\nBoston, Massac...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>90</td>\n",
       "      <td>Active, not recruiting</td>\n",
       "      <td>Phase III Double-blind, Placebo-controlled Stu...</td>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Drug: AZD7442\\nDrug: Placebo</td>\n",
       "      <td>Research Site\\nGuntersville, Alabama, United S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>91</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Ivermectin Treatment Efficacy in Covid-19 High...</td>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Drug: Ivermectin 0.4mg/kg/day for 5 days</td>\n",
       "      <td>Sultanah Aminah Hospital\\nJohor Bahru, Johor, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>92</td>\n",
       "      <td>Completed</td>\n",
       "      <td>Gut Microbiota, \"Spark and Flame\" of COVID-19 ...</td>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Other: Exposure</td>\n",
       "      <td>Hospital CUF Infante Santo, S.A.\\nLisbon, Port...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>93</td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Isotretinoin in Treatment of COVID-19</td>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Drug: Isotretinoin Only Product in Oral Dose Form</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>94</td>\n",
       "      <td>Completed</td>\n",
       "      <td>Colchicine in Moderate Symptomatic COVID-19 Pa...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Drug: Colchicine\\nDrug: Placebo</td>\n",
       "      <td>Dhaka Medical College Hospital\\nDhaka-1000, Ba...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>95</td>\n",
       "      <td>Terminated</td>\n",
       "      <td>Inhaled Nitric Oxide for Preventing Progressio...</td>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Drug: Nitric Oxide</td>\n",
       "      <td>Tufts Medical Center\\nBoston, Massachusetts, U...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>96</td>\n",
       "      <td>Completed</td>\n",
       "      <td>Trial to Study the Adjuvant Benefits of Querce...</td>\n",
       "      <td>COVID-19</td>\n",
       "      <td>Drug: Standard COVID-19 care\\nDietary Suppleme...</td>\n",
       "      <td>Liaquat University Hospital\\nJāmshoro, Sindh, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>97</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Serological Surveillance for COVID-19 in Centr...</td>\n",
       "      <td>COVID-19</td>\n",
       "      <td></td>\n",
       "      <td>NIEHS Clinical Research Unit (CRU)\\nResearch T...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>98</td>\n",
       "      <td>Not yet recruiting</td>\n",
       "      <td>Effectiveness of Hydroxychloroquine in Covid-1...</td>\n",
       "      <td>COVID19</td>\n",
       "      <td>Drug: Hydroxychloroquine 200 Mg Oral Tablet\\nD...</td>\n",
       "      <td>Ayub Teaching Institution\\nAbbottābād, K.p.k, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>99</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Efficacy and Safety of Sirolimus in COVID-19 I...</td>\n",
       "      <td>COVID 19</td>\n",
       "      <td>Drug: Sirolimus</td>\n",
       "      <td>Faculty of Medicine, Alexandria university, Eg...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>100</td>\n",
       "      <td>Recruiting</td>\n",
       "      <td>Rehabilitation for Patients With Persistent Sy...</td>\n",
       "      <td>Covid19</td>\n",
       "      <td>Other: Concentrated rehabilitation for patient...</td>\n",
       "      <td>Helse i Hardanger\\nØystese, Kvam Herad, Norway</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Number Study_Paticipant_Recruitment_Status  \\\n",
       "1        1             Enrolling by invitation   \n",
       "2        2                  Not yet recruiting   \n",
       "3        3                          Recruiting   \n",
       "4        4                          Recruiting   \n",
       "5        5                  Not yet recruiting   \n",
       "6        6              Active, not recruiting   \n",
       "7        7                          Recruiting   \n",
       "8        8             Enrolling by invitation   \n",
       "9        9                          Recruiting   \n",
       "10      10                  Not yet recruiting   \n",
       "11      11                          Recruiting   \n",
       "12      12                          Recruiting   \n",
       "13      13                  Not yet recruiting   \n",
       "14      14                          Recruiting   \n",
       "15      15                          Recruiting   \n",
       "16      16             Enrolling by invitation   \n",
       "17      17                  Not yet recruiting   \n",
       "18      18                           Completed   \n",
       "19      19                  Not yet recruiting   \n",
       "20      20                  Not yet recruiting   \n",
       "21      21                          Recruiting   \n",
       "22      22                           Completed   \n",
       "23      23                  Not yet recruiting   \n",
       "24      24                  Not yet recruiting   \n",
       "25      25              Active, not recruiting   \n",
       "26      26                          Recruiting   \n",
       "27      27                           Completed   \n",
       "28      28                  Not yet recruiting   \n",
       "29      29                           Completed   \n",
       "30      30                          Recruiting   \n",
       "..     ...                                 ...   \n",
       "71      71              Completed\\nHas Results   \n",
       "72      72                          Recruiting   \n",
       "73      73                          Recruiting   \n",
       "74      74                          Recruiting   \n",
       "75      75                          Recruiting   \n",
       "76      76                          Recruiting   \n",
       "77      77                          Recruiting   \n",
       "78      78              Active, not recruiting   \n",
       "79      79                           Completed   \n",
       "80      80                           Withdrawn   \n",
       "81      81                  Not yet recruiting   \n",
       "82      82                           Completed   \n",
       "83      83             Enrolling by invitation   \n",
       "84      84                  Not yet recruiting   \n",
       "85      85                  Not yet recruiting   \n",
       "86      86                           Withdrawn   \n",
       "87      87             Not yet recruiting\\nNEW   \n",
       "88      88                          Recruiting   \n",
       "89      89              Active, not recruiting   \n",
       "90      90              Active, not recruiting   \n",
       "91      91                          Recruiting   \n",
       "92      92                           Completed   \n",
       "93      93                  Not yet recruiting   \n",
       "94      94                           Completed   \n",
       "95      95                          Terminated   \n",
       "96      96                           Completed   \n",
       "97      97                          Recruiting   \n",
       "98      98                  Not yet recruiting   \n",
       "99      99                          Recruiting   \n",
       "100    100                          Recruiting   \n",
       "\n",
       "                                           Study_Title       Conditions  \\\n",
       "1    COVID SAFE: COVID-19 Screening Assessment for ...          Covid19   \n",
       "2                CICERO- A Care Home Study of COVID-19            COVID   \n",
       "3                           Dexamethasone for COVID-19          Covid19   \n",
       "4                         Duvelisib to Combat COVID-19         COVID-19   \n",
       "5       Enhancing COVID Rehabilitation With Technology          Covid19   \n",
       "6    Post Covid-19 Cardiopulmonary and Immunologica...            COVID   \n",
       "7              Immune Modulators for Treating COVID-19          Covid19   \n",
       "8    COVID-FISETIN: Pilot in SARS-CoV-2 of Fisetin ...          Covid19   \n",
       "9                                  Balance in COVID-19          Covid19   \n",
       "10         Ivermectin Nasal Spray for COVID19 Patients          Covid19   \n",
       "11   Relationship Between CT- Value With Prognosis ...         COVID-19   \n",
       "12   Observational Cohort of COVID-19 Patients at R...         COVID-19   \n",
       "13                Fugal Infection in COVID-19 Patients          Covid19   \n",
       "14   The Lymphoma and Leukemia Society Amended COVI...          Covid19   \n",
       "15   Pilot Trial of XFBD, a TCM, in Persons With CO...          Covid19   \n",
       "16   Estimation of Dynamics of Humoral and Cellular...          Covid19   \n",
       "17   Study of Intravenous COVI-MSC for Treatment of...          Covid19   \n",
       "18                 COVID 19 Serology in Pulmonologists         Covid 19   \n",
       "19   COVID-19 Surveillance Based on Smart Wearable ...         COVID-19   \n",
       "20   Study of Allogeneic Adipose-Derived Mesenchyma...          Covid19   \n",
       "21   Effect of COVID-19 Pandemic on Pediatric Cance...          Covid19   \n",
       "22   A Phase 2 Trial of Infliximab in Coronavirus D...         COVID-19   \n",
       "23   Study to Evaluate the Safety and Efficacy of a...          Covid19   \n",
       "24   Study to Evaluate a Single Intranasal Dose of ...          Covid19   \n",
       "25   A Research Study to Evaluate the Benefits of a...            COVID   \n",
       "26   Study to Evaluate a Single Dose of STI-2020 (C...          Covid19   \n",
       "27         Forecast Number of Covid-19 Cases Worldwide         Covid-19   \n",
       "28   Hyperbaric Oxygen Therapy (HBOT) as a Treatmen...         COVID-19   \n",
       "29   Efficacy of Convalescent Plasma Therapy in Sev...            COVID   \n",
       "30   Study to Evaluate a Single Dose of STI-2020 (C...          Covid19   \n",
       "..                                                 ...              ...   \n",
       "71   USEFULNESS of Topic Ivermectin and Carrageenan...          Covid19   \n",
       "72           UPMC OPTIMISE-C19 Trial, a COVID-19 Study          Covid19   \n",
       "73   Efficacy of Reinforcing Standard Therapy in CO...          Covid19   \n",
       "74   Fluvoxamine Administration in Moderate SARS-Co...          Covid19   \n",
       "75   Effects of Sodium Pyruvate Nasal Spray in COVI...       Long COVID   \n",
       "76   Efficacy, Immunogenicity, and Safety of the In...          Covid19   \n",
       "77        Long-term Outcomes in Patients With COVID-19         COVID-19   \n",
       "78            COVID-19 Vaccinations With a Sweepstakes          Covid19   \n",
       "79   Comparison of Two Doses of Enoxaparin for Thro...          Covid19   \n",
       "80   Clinical Trial of Allogeneic Mesenchymal Cells...            COVID   \n",
       "81   Worldwide Trends on COVID-19 Research After th...         COVID-19   \n",
       "82           Convalescent Plasma Treatment in COVID-19          Covid19   \n",
       "83   COVID 19 Seroprevalence Amongst Healthcare Wor...         COVID 19   \n",
       "84   Repurposing of Chlorpromazine in Covid-19 Trea...         COVID-19   \n",
       "85   Indirect Endovenous Systemic Ozone for New Cor...            COVID   \n",
       "86   Selective Estrogen Modulation and Melatonin in...          Covid19   \n",
       "87   Prophylaxis of COVID-19 Disease With Ivermecti...          Covid19   \n",
       "88   Virgin Coconut Oil as Adjunctive Therapy for H...          Covid19   \n",
       "89   Pegylated Interferon Lambda Treatment for COVI...  COVID-19\\nCOVID   \n",
       "90   Phase III Double-blind, Placebo-controlled Stu...         COVID-19   \n",
       "91   Ivermectin Treatment Efficacy in Covid-19 High...         COVID-19   \n",
       "92   Gut Microbiota, \"Spark and Flame\" of COVID-19 ...         COVID-19   \n",
       "93               Isotretinoin in Treatment of COVID-19         COVID-19   \n",
       "94   Colchicine in Moderate Symptomatic COVID-19 Pa...          Covid19   \n",
       "95   Inhaled Nitric Oxide for Preventing Progressio...         COVID-19   \n",
       "96   Trial to Study the Adjuvant Benefits of Querce...         COVID-19   \n",
       "97   Serological Surveillance for COVID-19 in Centr...         COVID-19   \n",
       "98   Effectiveness of Hydroxychloroquine in Covid-1...          COVID19   \n",
       "99   Efficacy and Safety of Sirolimus in COVID-19 I...         COVID 19   \n",
       "100  Rehabilitation for Patients With Persistent Sy...          Covid19   \n",
       "\n",
       "                                         Interventions  \\\n",
       "1                     Behavioral: Saliva-based testing   \n",
       "2    Diagnostic Test: Q16 testing\\nDiagnostic Test:...   \n",
       "3                                  Drug: Dexamethasone   \n",
       "4    Drug: Duvelisib\\nProcedure: Peripheral blood d...   \n",
       "5    Behavioral: NexJ Connected Wellness\\nOther: Us...   \n",
       "6                                                        \n",
       "7    Drug: Infliximab\\nDrug: Abatacept\\nDrug: Remde...   \n",
       "8                         Drug: Placebo\\nDrug: Fisetin   \n",
       "9                           Other: Balance assessments   \n",
       "10   Drug: Ivermectin nasal\\nDrug: Ivermectin oral\\...   \n",
       "11                    Diagnostic Test: Cycle threshold   \n",
       "12                                                       \n",
       "13                              Other: no intervention   \n",
       "14           Biological: Amended LLS COVID-19 Registry   \n",
       "15        Drug: Xuanfei Baidu Granules\\nOther: Placebo   \n",
       "16      Diagnostic Test: Humoral and cellular immunity   \n",
       "17                 Biological: COVI-MSC\\nDrug: Placebo   \n",
       "18                                                       \n",
       "19                                                       \n",
       "20                 Biological: COVI-MSC\\nDrug: Placebo   \n",
       "21                                                       \n",
       "22                                    Drug: Infliximab   \n",
       "23                 Biological: COVI-AMG\\nDrug: Placebo   \n",
       "24               Biological: COVI-DROPS\\nDrug: Placebo   \n",
       "25   Behavioral: Self-management booklet (SWitCh: S...   \n",
       "26                 Biological: COVI-AMG\\nDrug: Placebo   \n",
       "27      Other: Model Building\\nOther: Model validation   \n",
       "28                   Device: Hyperbaric Oxygen Therapy   \n",
       "29   Drug: Convalescent Plasma Transfusion\\nOther: ...   \n",
       "30                 Biological: COVI-AMG\\nDrug: Placebo   \n",
       "..                                                 ...   \n",
       "71   Combination Product: Iota carrageenan nasal sp...   \n",
       "72   Biological: Lilly Bamlanivimab\\nBiological: Re...   \n",
       "73   Other: Convalescent Plasma with antibody again...   \n",
       "74                    Drug: Placebo\\nDrug: Fluvoxamine   \n",
       "75                   Drug: sodium pyruvate nasal spray   \n",
       "76         Biological: TURCOVAC\\nBiological: CoronaVac   \n",
       "77                                                       \n",
       "78                  Behavioral: Philly Vax Sweepstakes   \n",
       "79                                    Drug: Enoxaparin   \n",
       "80   Biological: Mesenchymal cells\\nDrug: Standard ...   \n",
       "81   Drug: Convalescent Plasma Transfusion\\nDrug: H...   \n",
       "82   Biological: Convalescent Plasma (CP)\\nOther: D...   \n",
       "83                      Diagnostic Test: Serology Test   \n",
       "84   Drug: CHLORPROMAZINE (CPZ)\\nCombination Produc...   \n",
       "85   Other: Systemic indirect endovenous ozone therapy   \n",
       "86   Drug: Toremifene\\nDrug: Melatonin\\nOther: Placebo   \n",
       "87                     Drug: Ivermectin\\nDrug: Placebo   \n",
       "88                            Drug: Virgin Coconut Oil   \n",
       "89                   Drug: Pegylated interferon lambda   \n",
       "90                        Drug: AZD7442\\nDrug: Placebo   \n",
       "91            Drug: Ivermectin 0.4mg/kg/day for 5 days   \n",
       "92                                     Other: Exposure   \n",
       "93   Drug: Isotretinoin Only Product in Oral Dose Form   \n",
       "94                     Drug: Colchicine\\nDrug: Placebo   \n",
       "95                                  Drug: Nitric Oxide   \n",
       "96   Drug: Standard COVID-19 care\\nDietary Suppleme...   \n",
       "97                                                       \n",
       "98   Drug: Hydroxychloroquine 200 Mg Oral Tablet\\nD...   \n",
       "99                                     Drug: Sirolimus   \n",
       "100  Other: Concentrated rehabilitation for patient...   \n",
       "\n",
       "                                             Locations  \n",
       "1    Penn Medicine\\nPhiladelphia, Pennsylvania, Uni...  \n",
       "2    Queen Mary University London\\nLondon, United K...  \n",
       "3    University of Oklahoma Medical Center\\nOklahom...  \n",
       "4    Missouri Baptist Medical Center\\nSaint Louis, ...  \n",
       "5                                                       \n",
       "6    Mansoura faculty of medicine\\nMansoura, Dakahl...  \n",
       "7    Banner University Medical Center\\nPhoenix, Ari...  \n",
       "8    Mayo Clinic in Rochester\\nRochester, Minnesota...  \n",
       "9    Duke University Health System\\nDurham, North C...  \n",
       "10                                                      \n",
       "11   SBMU\\nTehran, Iran, Islamic Republic of\\nNoosh...  \n",
       "12   Department of Infectiology, Raymond Poincaré H...  \n",
       "13                                                      \n",
       "14   Lymphoma and Leukemia Society\\nRye Brook, New ...  \n",
       "15   University of Southern California\\nLos Angeles...  \n",
       "16   Institute of Biophysics and Cell Engineering o...  \n",
       "17                                                      \n",
       "18                 Uh Montpellier\\nMontpellier, France  \n",
       "19   Peking University First Hospital\\nBeijing, Bei...  \n",
       "20                                                      \n",
       "21   South Egypt Cancer Institute, Assiut Universit...  \n",
       "22   Tufts Medical Center\\nBoston, Massachusetts, U...  \n",
       "23                                                      \n",
       "24                                                      \n",
       "25   Online recruitment through Qualtrics\\nLondon, ...  \n",
       "26   Teradan Clinical Trials\\nBrandon, Florida, Uni...  \n",
       "27   Republic of Turkey, Health Sciences University...  \n",
       "28   Ochsner Medical Center\\nNew Orleans, Louisiana...  \n",
       "29   Maulana Azad medical College\\nNew Delhi, Delhi...  \n",
       "30   Collaborative NeuroScience Research, LLC\\nGard...  \n",
       "..                                                 ...  \n",
       "71         Hospital Eurnekian\\nBuenos Aires, Argentina  \n",
       "72       UPMC\\nPittsburgh, Pennsylvania, United States  \n",
       "73   University Hospital Son Llatzer\\nPalma De Mall...  \n",
       "74   Dél-pesti Centrumkórház\\nBudapest, Hungary\\nSe...  \n",
       "75   Missouri State University\\nSpringfield, Missou...  \n",
       "76   T.R. Ministry of Health Ankara City Hospital, ...  \n",
       "77   Renji Hospital, Shanghai Jiaotong University S...  \n",
       "78   University of Pennsylvania\\nPhiladelphia, Penn...  \n",
       "79   Azienda Socio Sanitaria Territoriale Grande Os...  \n",
       "80   Hospital Universitario de Getafe\\nGetafe, Madr...  \n",
       "81                                                      \n",
       "82   Aga Khan University Hospital\\nKarachi, Sind, P...  \n",
       "83   Johns Hopkins Aramco Healthcare\\nDhahran, East...  \n",
       "84       Centre Hospitalier Sainte-Anne\\nParis, France  \n",
       "85                               SEOT\\nValencia, Spain  \n",
       "86                                                      \n",
       "87                                                      \n",
       "88   Philippine General Hospital\\nManila, Metro Man...  \n",
       "89   Massachusetts General Hospital\\nBoston, Massac...  \n",
       "90   Research Site\\nGuntersville, Alabama, United S...  \n",
       "91   Sultanah Aminah Hospital\\nJohor Bahru, Johor, ...  \n",
       "92   Hospital CUF Infante Santo, S.A.\\nLisbon, Port...  \n",
       "93                                                      \n",
       "94   Dhaka Medical College Hospital\\nDhaka-1000, Ba...  \n",
       "95   Tufts Medical Center\\nBoston, Massachusetts, U...  \n",
       "96   Liaquat University Hospital\\nJāmshoro, Sindh, ...  \n",
       "97   NIEHS Clinical Research Unit (CRU)\\nResearch T...  \n",
       "98   Ayub Teaching Institution\\nAbbottābād, K.p.k, ...  \n",
       "99   Faculty of Medicine, Alexandria university, Eg...  \n",
       "100     Helse i Hardanger\\nØystese, Kvam Herad, Norway  \n",
       "\n",
       "[100 rows x 6 columns]"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "clean_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Below are for scraping through all pages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_allpage_data(pages, driver):\n",
    "    '''returns all data for the given condition \n",
    "    \n",
    "    Keyword arguments:\n",
    "    pages -- total number of pages for condition, integers inclusive of last page\n",
    "    driver -- chrome driver\n",
    "    '''\n",
    "    # one_provider_dict -- all data scraped for this condition as dict\n",
    "    all_page_dict = dict()\n",
    "    \n",
    "    \n",
    "    search_result=driver.find_element_by_class_name('dataTables_info')\n",
    "    results_text=search_result.text\n",
    "    \n",
    "    total_row_list=re.findall('\\d+(?:\\.\\d+)?,\\d+', results_text)\n",
    "    total_row_int=int(total_row_list[0].replace(',', ''))\n",
    "    \n",
    "    temp = total_row_int/100 \n",
    "    pages = math.ceil(temp)\n",
    "\n",
    "    \n",
    "    for page in range(1, pages + 1):\n",
    "        page_dict = scrape_page(page, driver)\n",
    "        all_page_dict.update(page_dict)\n",
    "    \n",
    "    try:\n",
    "        assert len(all_page_dict) == total_row_int, \"number of values scraped does not match number of rows\"\n",
    "    except AssertionError:\n",
    "        logging.exception(\"number of values scraped does not match number of rows\")\n",
    "        raise\n",
    "\n",
    "    logging.info('complete data scraped for ' + str(interested_condtion))\n",
    "\n",
    "    return(all_page_dict)\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "def write_out_data(all_page_dict, clean_df_path):\n",
    "    col_names_dict={\"Row\": \"Number\",\n",
    "               \"Saved\": None,\n",
    "               \"Status\": \"Study_Paticipant_Recruitment_Status\", \n",
    "               \"Study Title\": \"Study_Title\", \n",
    "               \"Conditions\" : \"Conditions\",\n",
    "               \"Interventions\": \"Interventions\",\n",
    "               \"Location\": \"Location\"\n",
    "              }\n",
    "\n",
    "    col_names_dict_filter = {k: v for k, v in col_names_dict.items() if v is not None}\n",
    "    \n",
    "    #write out all_page_dict\n",
    "    with open(dict_out_path, 'w', encoding='utf-8') as f:\n",
    "        print(all_page_dict, file=f)\n",
    "\n",
    "    raw_df = pd.concat({k: pd.DataFrame(v).T for k, v in all_page_dict.items()}, axis=0)\n",
    "    \n",
    "    raw_df.to_csv(raw_df_path, index=False)\n",
    "    logging.info(\"finished: writing out raw_df\")\n",
    "    \n",
    "    # clean_df -- all data from all providers (as dataframe)\n",
    "    # drop_duplicates -- dropping duplicated rows\n",
    "    clean_df = raw_df[list(col_names_dict_filter.keys())]\n",
    "    clean_df = clean_df.rename(columns= col_names_dict_filter)\n",
    "    \n",
    "    clean_df = clean_df.drop_duplicates()\n",
    "    \n",
    "    # log number of duplicated rows dropped\n",
    "    count_duplicate = len(raw_df)-len(clean_df)\n",
    "    logging.info('number of duplicate rows removed =' + str(count_duplicate))\n",
    "    \n",
    "    clean_df.to_csv(clean_df_path, index=False)\n",
    "    \n",
    "    logging.info(\"finished: writing out clean_df\")\n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# write out data\n",
    "write_out_data(all_page_dict,clean_df_path)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}