Creating_and_Geolocating_Affiliates_Data.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Creating and Geolocating Affiliates Data.ipynb",
      "provenance": [],
      "collapsed_sections": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "metadata": {
        "id": "3nRbs30dORR7",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "#Initially, I will discuss how to get the affiliates data. I observed 5 major data sources: biorxiv, medrxiv, elsevier, pmc and cnz. Pubmed API and Selenium scraping customized \n",
        "#for major journals like medr,bior,sciencedirect gives a good fill rate"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Hc--uVGfOSiQ",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "!apt update\n",
        "!apt install chromium-chromedriver\n",
        "!pip install selenium"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "SBpRpfYOPj2L",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "!pip install ratelimit"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ac_1_BJoOS0f",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "from selenium import webdriver\n",
        "options = webdriver.ChromeOptions()\n",
        "options.add_argument('--headless')\n",
        "options.add_argument('--no-sandbox')\n",
        "options.add_argument('--disable-dev-shm-usage')\n",
        "wd = webdriver.Chrome('chromedriver',options=options)\n",
        "find_el = wd.find_elements_by_xpath\n",
        "wd.implicitly_wait(30)\n",
        "wd.set_page_load_timeout(30)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "iB9pcgAhPHJt",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "#The various scraping functions\n",
        "def node_text(node):\n",
        "    if node.text:\n",
        "        result = node.text\n",
        "    else:\n",
        "        result = ''\n",
        "    for child in node:\n",
        "        if child.tail is not None:\n",
        "            result += child.tail\n",
        "    return result\n",
        "\n",
        "def scrape_else(data):\n",
        "  try:\n",
        "    wd.get(\"https://doi.org/\"+data)\n",
        "    more_button = find_el(\"//button[@class='show-hide-details u-font-sans']\")[0]\n",
        "    more_button.click()\n",
        "    l=[]\n",
        "    for i in find_el(\"//dl[@class='affiliation']/dd\"):\n",
        "      l.append(i.text)\n",
        "    return l\n",
        "  except:\n",
        "    l=[]\n",
        "    return l\n",
        "\n",
        "@sleep_and_retry\n",
        "@limits(calls=1, period=1)\n",
        "def czi_affiliations(data):\n",
        "  try:\n",
        "    PMC_ID = data.lstrip('PMC')\n",
        "    response = requests.get('https://eutils.ncbi.nlm.nih.gov/entrez/eutils/efetch.fcgi?db=pmc&id='+PMC_ID)\n",
        "    root = ElementTree.fromstring(response.content)\n",
        "    l=[]\n",
        "    for i in root.iter('aff'):\n",
        "      l.append(node_text(i))\n",
        "    return l\n",
        "  except:\n",
        "    l=[]\n",
        "    return l\n",
        "\n",
        "def scrape_bior(data):\n",
        "  try:\n",
        "    wd.get(\"https://doi.org/\"+data)\n",
        "    wd.get(wd.current_url+\".article-info\")\n",
        "    l=[]\n",
        "    for i in find_el(\"//ol[@class='affiliation-list']/li/address/span\"):\n",
        "      l.append(i.text)\n",
        "    return l\n",
        "  except:\n",
        "    l=[]\n",
        "    return l\n",
        "\n",
        "#Medr aldo follows bior structure so same function can be used"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "dAz9zOQTPM_g",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "#Not putting the scraping results here as they were mult-threaded and run on a different env "
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "XFqfTnhEPVp9",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "#For websites that redirect to PDFs\n",
        "import os\n",
        "d=dict()\n",
        "c=0\n",
        "root_dir = '/content/gdrive/My Drive'\n",
        "for root,dirs, files in os.walk(root_dir):\n",
        "  for file in files:\n",
        "    c+=1\n",
        "    print(c)\n",
        "    if 'pdf' in file:\n",
        "      name = file.lstrip('PII').rstrip('.pdf')\n",
        "      l=[]\n",
        "      try:\n",
        "        wd.get(\"https://www.sciencedirect.com/science/article/pii/\"+name)\n",
        "        t1 = find_el(\"//a[@class='doi']\")[0]\n",
        "        more_button = find_el(\"//button[@class='show-hide-details u-font-sans']\")[0]\n",
        "        more_button.click()\n",
        "        for i in find_el(\"//dl[@class='affiliation']/dd\"):\n",
        "          l.append(i.text)\n",
        "        d[t1.text.lstrip('https://doi.org/')]=l\n",
        "      except:\n",
        "        pass\n"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "IBYsF-4cLytM",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "#Here on, we eill discuss the geolocation part\n",
        "!sudo apt-get install curl autoconf automake libtool python-dev pkg-config\n",
        "!git clone https://github.com/openvenues/libpostal\n",
        "cd libpostal\n",
        "!./bootstrap.sh\n",
        "!sudo mkdir /opt/libpostal \n",
        "!./configure --datadir=/opt/libpostal\n",
        "!make \n",
        "!sudo make install"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "q8DfK2IgPhAz",
        "colab_type": "code",
        "outputId": "234b37ae-99c9-4d91-e843-9c70f7627587",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 224
        }
      },
      "source": [
        "pip install postal"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Collecting postal\n",
            "  Using cached https://files.pythonhosted.org/packages/56/f7/69ca5d374077e23aa9a51ecd4031222ca9dfb7d19c95d7691f024e2e27ef/postal-1.1.8.tar.gz\n",
            "Requirement already satisfied: six in /usr/local/lib/python3.6/dist-packages (from postal) (1.12.0)\n",
            "Building wheels for collected packages: postal\n",
            "  Building wheel for postal (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for postal: filename=postal-1.1.8-cp36-cp36m-linux_x86_64.whl size=162432 sha256=a175cfb9fb8d0c610e63d36be7bf63d5528d690587d04a20d98011e0794f0129\n",
            "  Stored in directory: /root/.cache/pip/wheels/07/a1/d6/5d48641ee6f7c494c35534661d367b966b2b398e3789f48ffc\n",
            "Successfully built postal\n",
            "Installing collected packages: postal\n",
            "Successfully installed postal-1.1.8\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "cFlAnxrSPqiR",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "from google.colab import drive\n",
        "drive.mount('/content/gdrive')"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "UfOMpo1sP4CJ",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import pandas as pd\n",
        "import numpy as np"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "aBRvPgTrQtoc",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "#Reading in the COVID affiliates data previously created, https://github.com/isdapro/CovidClinicalTrials/blob/master/Datasets/covid_affiliates.csv\n",
        "df = pd.read_csv(\"covid_affiliates.csv\")"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Eks5qelRQ_5j",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "from ast import literal_eval\n",
        "df['affiliate'] = df['affiliate'].apply(literal_eval)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "02WnLL6ZZ0Qb",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "from geopy.geocoders import Nominatim, GeoNames, DataBC, ArcGIS, TomTom, Bing, GoogleV3\n",
        "geolocator = Bing(api_key=\"BING_API_KEY\")"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "FMOCF_7jZ8EB",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "def extract_country(data):\n",
        "  s = set()\n",
        "  for el in data:\n",
        "    d = dict(parse_address(el))\n",
        "    inv_map = {v: k for k, v in d.items()}\n",
        "    if 'country' in inv_map.keys():\n",
        "      s.add(inv_map['country'])\n",
        "    elif 'city' in inv_map.keys():\n",
        "      try:\n",
        "        s.add(geolocator.geocode(inv_map['city']).raw['address']['countryRegion'])\n",
        "      except:\n",
        "        pass\n",
        "    elif 'house' in inv_map.keys():\n",
        "      try:\n",
        "        s.add(geolocator.geocode(inv_map['house']).raw['address']['countryRegion'])\n",
        "      except:\n",
        "        pass\n",
        "  return list(s)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Hbe1U_gZcGHj",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "!pip install pandarallel"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "kXUzb5FwcJE-",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "from pandarallel import pandarallel"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "mpXUNGWochaR",
        "colab_type": "code",
        "outputId": "2c612ab0-236d-44ca-c57f-8973fb02db20",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 54
        }
      },
      "source": [
        "pandarallel.initialize()"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "INFO: Pandarallel will run on 2 workers.\n",
            "INFO: Pandarallel will use Memory file system to transfer data between the main process and workers.\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "NjqkM1QUc8xJ",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "from tqdm import tqdm\n",
        "tqdm.pandas()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "fNO7A45NgO6F",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "def set_cleaner(data):\n",
        "  s = set()\n",
        "  for i in data:\n",
        "    s.add(i.lower())\n",
        "  return list(s)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "_LfV3-PVgfc8",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "df['geolocated_country'] = df['affiliate'].parallel_apply(extract_country)\n",
        "df['geolocated_country'] = df['geolocated_country'].parallel_apply(set_cleaner)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "SDWqGj1sgnFf",
        "colab_type": "code",
        "outputId": "01c87d2d-3eb1-4539-e0fe-f6de6e40f8ed",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        }
      },
      "source": [
        "df.head(50)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Unnamed: 0</th>\n",
              "      <th>Id</th>\n",
              "      <th>doi</th>\n",
              "      <th>title</th>\n",
              "      <th>affiliate</th>\n",
              "      <th>geolocated_country</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>044d1e54d0a62dcd6234694e2a7ce1aa48fa7601</td>\n",
              "      <td>10.1016/j.tmaid.2020.101571</td>\n",
              "      <td>Outbreak of novel Corona virus (2019-nCoV); im...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>a386909bd060eac84e6dad7e1dc90986baf1be27</td>\n",
              "      <td>10.1016/j.tmaid.2020.101573</td>\n",
              "      <td>Fatal human coronavirus 229E (HCoV-229E) and R...</td>\n",
              "      <td>[Research Group Infectious Diseases and Infect...</td>\n",
              "      <td>[colombia]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2</td>\n",
              "      <td>d9e4c9b6b809ddc1f9dc8787f77368334e1e538b</td>\n",
              "      <td>10.1016/j.tmaid.2020.101575</td>\n",
              "      <td>Coronavirus infections reported by ProMED, Feb...</td>\n",
              "      <td>[Incubator in Zoonosis (SIZOO), Biodiversity a...</td>\n",
              "      <td>[saudi arabia, colombia, nepal]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>3cca30d1cc54ef4a38a3dda706059bea64906e6b</td>\n",
              "      <td>10.1016/j.tmaid.2020.101577</td>\n",
              "      <td>Coronavirus 2019-nCoV: Is the genie already ou...</td>\n",
              "      <td>[Instituto de Microbiologia, Faculdade de Medi...</td>\n",
              "      <td>[the netherlands, portugal]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>f8da9e99d451df2a2b0177cc553bb82c61f712f0</td>\n",
              "      <td>10.1016/j.jhin.2020.02.002</td>\n",
              "      <td>Novel coronavirus, poor quarantine, and the ri...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>5</td>\n",
              "      <td>af4b55f98a0bd3ff40552a86fbf52ad1ff9d68d5</td>\n",
              "      <td>10.1016/s2215-0366(20)30077-8</td>\n",
              "      <td>Online mental health services in China during ...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>6</td>\n",
              "      <td>6f07f5dc2599b774baffd5a80e0b0a59662b7f35</td>\n",
              "      <td>10.1016/s1473-3099(20)30110-9</td>\n",
              "      <td>Initiation of a new infection control system f...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>7</td>\n",
              "      <td>e740f0be0666572862dc8c736b998f527d326224</td>\n",
              "      <td>10.1016/j.ijid.2020.02.025</td>\n",
              "      <td>The basic reproduction number of novel coronav...</td>\n",
              "      <td>[JC School of Public Health and Primary Care, ...</td>\n",
              "      <td>[china, usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>8</td>\n",
              "      <td>32d7635948b54f9ce6f019847fd57fe95306f721</td>\n",
              "      <td>10.1016/j.ijid.2020.02.024</td>\n",
              "      <td>Comments on \"Preliminary estimation of the bas...</td>\n",
              "      <td>[School of Mathematical Science, University of...</td>\n",
              "      <td>[australia]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>9</td>\n",
              "      <td>c843c9f3d123553ed90bed163426cd6ef071587f</td>\n",
              "      <td>10.1016/j.cmi.2020.02.011</td>\n",
              "      <td>First atypical case of 2019 novel coronavirus ...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>10</td>\n",
              "      <td>24f204ce5a1a4d752dc9ea7525082d225caed8b3</td>\n",
              "      <td>10.1016/j.jhin.2020.02.010</td>\n",
              "      <td>The non-contact handheld cutaneous infra-red t...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>11</td>\n",
              "      <td>89795fa23ea23b2636c1c791bff839fb5580af26</td>\n",
              "      <td>10.1016/s0140-6736(20)30184-7</td>\n",
              "      <td>Data sharing and outbreaks: best practice exem...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>12</td>\n",
              "      <td>0c2d3b2313ae36f94f856546e7509712da3b6a99</td>\n",
              "      <td>10.1016/s0140-6736(20)30304-4</td>\n",
              "      <td>Baricitinib as potential treatment for 2019-nC...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>13</td>\n",
              "      <td>81036c79c0579498f42690ccadc8405f150f6944</td>\n",
              "      <td>10.1016/s0140-6736(20)30317-2</td>\n",
              "      <td>Clinical evidence does not support corticoster...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>14</td>\n",
              "      <td>f864c42617b8702b776985577444149bbdd7b176</td>\n",
              "      <td>10.1016/j.jinf.2020.02.008</td>\n",
              "      <td>Clinical features of atypical 2019 novel coron...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>15</td>\n",
              "      <td>e853129ee4083236c642e86118c6eb8336c8f813</td>\n",
              "      <td>10.1016/j.jinf.2020.02.001</td>\n",
              "      <td>The continuous evolution and dissemination of ...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>16</td>\n",
              "      <td>864f47aa4e296a8c980b6dc16b381257e3b633e7</td>\n",
              "      <td>10.1016/j.ajog.2020.02.017</td>\n",
              "      <td>Coronavirus Disease 2019 (COVID-19) and Pregna...</td>\n",
              "      <td>[Departments of Pediatrics, University of Flor...</td>\n",
              "      <td>[united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>17</td>\n",
              "      <td>d94cc20ae90a6f7bd3d35443bb8d39293cef71c2</td>\n",
              "      <td>10.1016/j.tmaid.2020.101604</td>\n",
              "      <td>The COVID-19 outbreak and implications for the...</td>\n",
              "      <td>[Panel of Sports and Travel, Latin American So...</td>\n",
              "      <td>[japan, argentina, colombia, nepal]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>18</td>\n",
              "      <td>1ac69a37f7ea4a23371848401083242835f3cdd4</td>\n",
              "      <td>10.1016/j.jhin.2020.02.016</td>\n",
              "      <td>COVID-19 in medical personnel: observation fro...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>19</td>\n",
              "      <td>1a2c79e2b65d28508db35b7b72eb7c2edfed8ef0</td>\n",
              "      <td>10.1016/j.tmaid.2020.101607</td>\n",
              "      <td>COVID-19: Zoonotic aspects</td>\n",
              "      <td>[Department of Epidemiology and Health Statist...</td>\n",
              "      <td>[china, colombia, pakistan]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>20</td>\n",
              "      <td>84fe215280aa235cc9fc6553ed8219864d471c88</td>\n",
              "      <td>10.1016/j.tmaid.2020.101608</td>\n",
              "      <td>Asymptomatic coronavirus infection: MERS-CoV a...</td>\n",
              "      <td>[Specialty Internal Medicine and Quality Depar...</td>\n",
              "      <td>[saudi arabia, usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>21</td>\n",
              "      <td>9ce59127771505d6353605873087993ce8cf6e7a</td>\n",
              "      <td>10.1016/j.tmaid.2020.101606</td>\n",
              "      <td>Clinical characteristics of laboratory confirm...</td>\n",
              "      <td>[Department of Plastic Surgery, Zhongnan Hospi...</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>22</td>\n",
              "      <td>fae1bbe7471e57135a48da93b52aad0f6d1fe6ff</td>\n",
              "      <td>10.1016/j.jhin.2020.02.018</td>\n",
              "      <td>Integrated infection control strategy to minim...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>23</td>\n",
              "      <td>73d931532f2713cfbd58e46de4874fb83ceb38eb</td>\n",
              "      <td>10.1016/s0140-6736(20)30350-0</td>\n",
              "      <td>From Hendra to Wuhan: what has been learned in...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>24</td>\n",
              "      <td>0ade5622adfb9a6e69871192b872df9800b60431</td>\n",
              "      <td>10.1016/j.jinf.2020.02.020</td>\n",
              "      <td>Novel coronavirus disease (Covid-19): The firs...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>25</td>\n",
              "      <td>77f4840c9bdd453ed8ae3c1ea4d79fc68a91e6ac</td>\n",
              "      <td>10.1016/s0140-6736(20)30311-1</td>\n",
              "      <td>2019-nCoV epidemic: what about pregnancies?</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>26</td>\n",
              "      <td>db0fd983610d337d73b23dbf6a5b44c609854c60</td>\n",
              "      <td>10.1016/s0140-6736(20)30313-5</td>\n",
              "      <td>2019-nCoV transmission through the ocular surf...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>27</td>\n",
              "      <td>1d321f94b4aafa3465879810990c0a4835b84e0f</td>\n",
              "      <td>10.1016/j.tmaid.2020.101613</td>\n",
              "      <td>COVID-19 in Latin America: The implications of...</td>\n",
              "      <td>[Public Health and Infection Research Group, F...</td>\n",
              "      <td>[paraguay, venezuela, brazil, mexico, chile, p...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>28</td>\n",
              "      <td>ba08055b16fee824ac5a3c02ab3a0ea35715191f</td>\n",
              "      <td>10.1016/j.tmaid.2020.101568</td>\n",
              "      <td>The association between domestic train transpo...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>29</td>\n",
              "      <td>48a980df98eb6778320db220cbf8de12d9eeaf02</td>\n",
              "      <td>10.1016/j.tmaid.2020.101566</td>\n",
              "      <td>SARS-CoV, MERS-CoV and now the 2019-novel CoV:...</td>\n",
              "      <td>[Semillero de Investigación en Zoonosis, Grupo...</td>\n",
              "      <td>[venezuela, saudi arabia, nepal, colombia, usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>30</td>\n",
              "      <td>cf0987354fb6a4c2d4ae2353edef93939b4df2c4</td>\n",
              "      <td>10.1016/j.puhe.2020.02.001</td>\n",
              "      <td>Wuhan novel coronavirus (COVID-19): why global...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>31</td>\n",
              "      <td>acaed5382ce4a0f4294eee8f98b19694eaf661cc</td>\n",
              "      <td>10.1016/j.tmaid.2020.101572</td>\n",
              "      <td>What goes on board aircraft? Passengers includ...</td>\n",
              "      <td>[Clinical Professor of Epidemiology and Biosta...</td>\n",
              "      <td>[united states, usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>32</td>\n",
              "      <td>2a66dc5f23ecf02ca8d7626818ef34f7663df87f</td>\n",
              "      <td>10.1016/j.tmaid.2020.101567</td>\n",
              "      <td>The next big threat to global health? 2019 nov...</td>\n",
              "      <td>[Fundación Centro de Estudios Infectológicos (...</td>\n",
              "      <td>[argentina, colombia, brazil, switzerland]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>33</td>\n",
              "      <td>ad9aa9b87ae15398ba7af6302a3ff1dfaff16be0</td>\n",
              "      <td>10.1016/s0140-6736(20)30069-6</td>\n",
              "      <td>Responding to health emergencies in the Easter...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>34</td>\n",
              "      <td>c64ab50a02b5062857c721133dd951f1f253ab22</td>\n",
              "      <td>10.1053/j.gastro.2020.02.054</td>\n",
              "      <td>COVID-19: Gastrointestinal Manifestations and ...</td>\n",
              "      <td>[Shanghai Jiao Tong University School of Medic...</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>35</td>\n",
              "      <td>a785255e17c5c1a5a33550a537083105e5551f7d</td>\n",
              "      <td>10.1016/j.jhin.2020.02.022</td>\n",
              "      <td>Effective strategies to prevent coronavirus di...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>36</td>\n",
              "      <td>074ca9f95ff2cb97eefbfa3486ae76d460184171</td>\n",
              "      <td>10.1016/j.jinf.2020.02.024</td>\n",
              "      <td>Corona Virus Disease 2019, a growing threat to...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>37</td>\n",
              "      <td>28b083110c8f4ba49593a0e281224d82d62889d3</td>\n",
              "      <td>10.1016/j.jhin.2020.02.020</td>\n",
              "      <td>Practical experiences and suggestions for the ...</td>\n",
              "      <td>[Department of Quality Management, Guangdong S...</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>38</td>\n",
              "      <td>744d673951034c6c8136bb61bc58104caebd5fd9</td>\n",
              "      <td>10.1016/j.jinf.2020.02.025</td>\n",
              "      <td>Insights into the cross-species evolution of 2...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>39</td>\n",
              "      <td>e986a38beb5e5ed8fd7e370bd3c3262789c69c74</td>\n",
              "      <td>10.1016/s0140-6736(20)30547-x</td>\n",
              "      <td>Mitigate the effects of home confinement on ch...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>40</td>\n",
              "      <td>824951708e0dab6bd8efa2b4d6e0542119ca6373</td>\n",
              "      <td>10.1016/j.jinf.2020.02.031</td>\n",
              "      <td>Public health might be endangered by possible ...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>41</td>\n",
              "      <td>83c098a0470cdca85401e8862b20bd88c47a3de2</td>\n",
              "      <td>10.1016/j.jinf.2020.02.028</td>\n",
              "      <td>Clinical manifestations and outcome of SARS-Co...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>42</td>\n",
              "      <td>9d6a7ba9e3c0dbc99577233a4d6d0139dde5a3e4</td>\n",
              "      <td>10.1016/j.jinf.2020.02.029</td>\n",
              "      <td>Lymphopenic community acquired pneumonia as si...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>43</td>\n",
              "      <td>29798795671ad2de1774d2c389e8b7159315a9ba</td>\n",
              "      <td>10.1016/j.jhin.2020.03.002</td>\n",
              "      <td>Reasons for healthcare workers becoming infect...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>44</td>\n",
              "      <td>fb5c1465c1ef8643b98a3029afa0cbb3785db454</td>\n",
              "      <td>10.1016/s0140-6736(20)30373-1</td>\n",
              "      <td>Do not violate the International Health Regula...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>45</td>\n",
              "      <td>aec75bf607be3a1ff6b06422049e376c8377b44c</td>\n",
              "      <td>10.1016/j.jtho.2020.02.025</td>\n",
              "      <td>The Treatment and Outcome of a Lung Cancer Pat...</td>\n",
              "      <td>[Department of Radiation and Medical Oncology,...</td>\n",
              "      <td>[republic of china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>46</td>\n",
              "      <td>c7ff86fa29cc55c1e991a7d27dfed5fa1852aa55</td>\n",
              "      <td>10.1016/s0140-6736(20)30356-1</td>\n",
              "      <td>Early lessons from the frontline of the 2019-n...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>47</td>\n",
              "      <td>6dde340deadeeaaef0533b4e5f15f8deff71510a</td>\n",
              "      <td>10.1016/s0140-6736(20)30557-2</td>\n",
              "      <td>SARS-CoV-2 is an appropriate name for the new ...</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>48</td>\n",
              "      <td>530d903e663909fd0465306da158eb50d9226b69</td>\n",
              "      <td>10.1016/j.jcjq.2020.03.001</td>\n",
              "      <td>Preparing for a Surge of Coronavirus Cases</td>\n",
              "      <td>[]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>49</td>\n",
              "      <td>17de15d04f7a7643550666d2f0da773f5b7dc95c</td>\n",
              "      <td>10.1016/j.ijantimicag.2020.105937</td>\n",
              "      <td>COVID-19 Therapeutic and Prevention</td>\n",
              "      <td>[MEФI, IRD, Aix Marseille Univ, AP-HM, Marseil...</td>\n",
              "      <td>[france, taiwan, italy]</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "    Unnamed: 0  ...                                 geolocated_country\n",
              "0            0  ...                                                 []\n",
              "1            1  ...                                         [colombia]\n",
              "2            2  ...                    [saudi arabia, colombia, nepal]\n",
              "3            3  ...                        [the netherlands, portugal]\n",
              "4            4  ...                                                 []\n",
              "5            5  ...                                                 []\n",
              "6            6  ...                                                 []\n",
              "7            7  ...                                       [china, usa]\n",
              "8            8  ...                                        [australia]\n",
              "9            9  ...                                                 []\n",
              "10          10  ...                                                 []\n",
              "11          11  ...                                                 []\n",
              "12          12  ...                                                 []\n",
              "13          13  ...                                                 []\n",
              "14          14  ...                                                 []\n",
              "15          15  ...                                                 []\n",
              "16          16  ...                                    [united states]\n",
              "17          17  ...                [japan, argentina, colombia, nepal]\n",
              "18          18  ...                                                 []\n",
              "19          19  ...                        [china, colombia, pakistan]\n",
              "20          20  ...                                [saudi arabia, usa]\n",
              "21          21  ...                                            [china]\n",
              "22          22  ...                                                 []\n",
              "23          23  ...                                                 []\n",
              "24          24  ...                                                 []\n",
              "25          25  ...                                                 []\n",
              "26          26  ...                                                 []\n",
              "27          27  ...  [paraguay, venezuela, brazil, mexico, chile, p...\n",
              "28          28  ...                                                 []\n",
              "29          29  ...    [venezuela, saudi arabia, nepal, colombia, usa]\n",
              "30          30  ...                                                 []\n",
              "31          31  ...                               [united states, usa]\n",
              "32          32  ...         [argentina, colombia, brazil, switzerland]\n",
              "33          33  ...                                                 []\n",
              "34          34  ...                                            [china]\n",
              "35          35  ...                                                 []\n",
              "36          36  ...                                                 []\n",
              "37          37  ...                                            [china]\n",
              "38          38  ...                                                 []\n",
              "39          39  ...                                                 []\n",
              "40          40  ...                                                 []\n",
              "41          41  ...                                                 []\n",
              "42          42  ...                                                 []\n",
              "43          43  ...                                                 []\n",
              "44          44  ...                                                 []\n",
              "45          45  ...                                [republic of china]\n",
              "46          46  ...                                                 []\n",
              "47          47  ...                                                 []\n",
              "48          48  ...                                                 []\n",
              "49          49  ...                            [france, taiwan, italy]\n",
              "\n",
              "[50 rows x 6 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 74
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "yFqJCCCxgn3w",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "df.to_csv(\"geolocated_affiliations.csv\")"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "z8aLrNovhACg",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "linked_trials = pd.read_csv(\"ClinicalTrialsLinked.csv\")"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "SeRL8ROnsuPg",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "#Running the geolocation logic on the VT SHA papers\n",
        "sha_vt = pd.read_csv(\"sha_vt.csv\")\n",
        "sha_vt.drop_duplicates(subset =\"sha\", inplace = True) "
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Em_hjnljszgo",
        "colab_type": "code",
        "outputId": "18897567-3d85-4fbc-977f-f9e91e8d2460",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 36
        }
      },
      "source": [
        "len(set(sha_vt.sha))"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "253"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 89
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "BhteZhaJNAr8",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "metadata = pd.read_csv(\"metadata.csv\")"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "FzSUx0gNuBRA",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "#We need the DOI also for getting affiliate data so some merges are necessary\n",
        "metadata = pd.read_csv(\"metadata.csv\")\n",
        "metadata = metadata.dropna(subset=['sha'])\n",
        "s = metadata['sha'].str.split(';').apply(pd.Series, 1).stack()\n",
        "s.index = s.index.droplevel(-1)\n",
        "s.name = 'sha'\n",
        "del metadata['sha']\n",
        "cleaned_meta = metadata.join(s)\n",
        "merged = sha_vt.merge(cleaned_meta, left_on='sha', right_on='sha')"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "5P0U-657ufPx",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "#Just avoiding work for papers that we have already extracted the data for\n",
        "merged2 = merged.merge(df,how='left',left_on='sha',right_on='Id')"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "vNJSY1Iyvj-K",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "merged_compact = merged2[['sha','doi_x','pmcid','affiliate','geolocated_country']]"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "k3x0IimoN_LB",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "!pip install ratelimit"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "rtD-Ecs-xy1Z",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import requests\n",
        "from tqdm import tqdm\n",
        "tqdm.pandas()\n",
        "import xml.etree.ElementTree as ElementTree\n",
        "from ratelimit import limits, sleep_and_retry\n",
        "def node_text(node):\n",
        "    if node.text:\n",
        "        result = node.text\n",
        "    else:\n",
        "        result = ''\n",
        "    for child in node:\n",
        "        if child.tail is not None:\n",
        "            result += child.tail\n",
        "    return result\n",
        "\n",
        "@sleep_and_retry\n",
        "@limits(calls=1, period=1)\n",
        "def affiliations(data):\n",
        "  try:\n",
        "    PMC_ID = data.lstrip('PMC')\n",
        "    response = requests.get('https://eutils.ncbi.nlm.nih.gov/entrez/eutils/efetch.fcgi?db=pmc&id='+PMC_ID)\n",
        "    root = ElementTree.fromstring(response.content)\n",
        "    l=[]\n",
        "    for i in root.iter('aff'):\n",
        "      l.append(node_text(i))\n",
        "    return l\n",
        "  except:\n",
        "    l=[]\n",
        "    return l"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "fdIuyE8vzuNl",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "def fun(data):\n",
        "  if not isinstance(data.affiliate,list):\n",
        "    tmp = affiliations(data.pmcid)\n",
        "    data.affiliate = tmp\n",
        "  print(data)\n",
        "  return data\n",
        " "
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "_oFMbtMXzA8T",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "merged_compact2 = merged_compact.parallel_apply(fun,axis=1)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "NikeZAT-5l3c",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "#80% fill rate\n",
        "merged_compact2['geolocated_country'].apply(lambda x: len(x)).value_counts()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "nnEPc5bK57_x",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "df_final = merged_compact2[['sha','geolocated_country']]"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "dSMibXPq6HuK",
        "colab_type": "code",
        "outputId": "d8dc02b2-5517-4c10-e563-4c9964f000d2",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        }
      },
      "source": [
        "df_final"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>sha</th>\n",
              "      <th>geolocated_country</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>00c71f72eb837e2342dbda8761664e221e2a03df</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>05192151667b1bb4e3405de11f6e4ae2f844e7c5</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>056610b4981cee0efc485ed3f978f541fbe55f54</td>\n",
              "      <td>[uk]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>0792384d074cef963c808eacf3c63e3654776a2a</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>0c36cc3dc9a1632f0fbf14372f376f89521718c5</td>\n",
              "      <td>[germany]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>0dca038ac8dfd45a921b7cd9f1c90a8554799e23</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>0dd1ab1f5811f3a1fe36f45577846243b3cf14f8</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>0eadf5a901c0d89fad2c202990056556be103e12</td>\n",
              "      <td>[china.]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>0f6a5070fd5f9bd5d46c3bbd4545c55982e726c3</td>\n",
              "      <td>[france]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>1007a3041cb5ae9e3e6f09712d81277c02ed3dbf</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>106db157fd5d6ee766feabadf0d35a24d6d37895</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>114ed64f52f503d9d2e2ba1fd1ee62b0a168cd84</td>\n",
              "      <td>[australia, china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>16f0732b9fee4779a3eb38280b344f866692d346</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>1766a9d5945897581c80f83276cc723c77e3798d</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>188e7ff1e260864c89f266b5597de26d69a84660</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>19a08cc1423d6006b2251bdcfd142f88db7002e7</td>\n",
              "      <td>[turkey, united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>19e18a7c27512439dac91fc1096937fd03496c13</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>1a48450da54865731ffe01c0e289a63065b3b1fd</td>\n",
              "      <td>[china, malawi, united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>1aa7102887a834cf5b833d122ca2eb015b7aeb91</td>\n",
              "      <td>[iran, france, thailand, norway, pakistan]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>1ad1d4b84aea4ceaf05c62a1ad04e7150f7f4684</td>\n",
              "      <td>[united kingdom]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>1b70c124d7e761eb19c35e8924b7551c0939495a</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>1d99db01b6d686c51b41ad60824f16859f67b7ef</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>1e0a165313e080137556cb75b1af2bb0f6984d9f</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>1ffc9948cf2eb9099c4a7e8055bda8c71cbc289e</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>21c4d6c08d861b792900c32c5a0df1c1d407a005</td>\n",
              "      <td>[australia, united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>21e3bb96c58ee1a3f80f743e83b0d4636ea717ae</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>23e7355b5e4e0209f64c9d8d5772092a53b72686</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>24e17488d399c436305c819953beae2961214771</td>\n",
              "      <td>[georgia, united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>2c17a581c10ece6c5b5dec88f228f1f43d3fcc14</td>\n",
              "      <td>[united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>2d0285c90976dfa43d58eca6b7d1d7ef29994fc2</td>\n",
              "      <td>[senegal, australia, china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>2f5bb8babcf9e40a337087b6925a3b5442bfbb40</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>3034d4ed2359a4706ff9f5096b1945eaa3b8bd1f</td>\n",
              "      <td>[canada]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>30b5d794d107c4c6680655a6de775093a394e8db</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>30c67218bbd1a5ffe68dab7fe7dfc5bc662e05a2</td>\n",
              "      <td>[united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>30fcd017c21fc5736d621c560aa22d624f8fcc87</td>\n",
              "      <td>[uk, france]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>3591382e6aefa066fe730ece11ba67995542353e</td>\n",
              "      <td>[sweden, india, united states, italy]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>35d36c0a736ae7ca642a8badd24bf4d9be3ca613</td>\n",
              "      <td>[canada]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>36f9ee4d21bf47a3f9f504f7fca3a1db625899d2</td>\n",
              "      <td>[united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>37341d7b81d0b9bdfaf84267318606cc7e91e3f4</td>\n",
              "      <td>[new zealand]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>3aaa23f7050caa452899603eaa4267d525bb23e9</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>3bdbda7b9bad2d94bfc88950c9efd33c90fb94b6</td>\n",
              "      <td>[turkey, germany, france, azerbaijan, india, u...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>3c15ba282c7261b3447e3a68a91e1a3b23b6fa3d</td>\n",
              "      <td>[china, united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>3e255292c1eb4fd8752ef1d603ad88beeba43f3f</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>3e3c84ba064eb8d3a0f7972d43235da7271478e8</td>\n",
              "      <td>[usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>3f13102b780fa8c0da16df0187c1236f0c2da9e6</td>\n",
              "      <td>[canada]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>3ff6ab72e32eab43e68725fb74108b596818b657</td>\n",
              "      <td>[iran.]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>4025115c646713cd5fc71cdf3c96cc235152d9b0</td>\n",
              "      <td>[united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>4043a852290c8823faa76b7592c9f9927c7d0928</td>\n",
              "      <td>[hong kong]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>417cbe38a2f8a93d0827cd67f4c42076921d6050</td>\n",
              "      <td>[lithuania, finland, estonia, norway, latvia]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>4224b1ef00b2907298fb4cb0965aac20d598693e</td>\n",
              "      <td>[taiwan]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50</th>\n",
              "      <td>430088e2d738c4c20413082888b2666668c9105f</td>\n",
              "      <td>[turkey, china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>51</th>\n",
              "      <td>43f9334d47199e5fe08b4f6094a96495cc627f53</td>\n",
              "      <td>[hong kong]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>52</th>\n",
              "      <td>4519998f22e00e318090334979b5d837a0e10da4</td>\n",
              "      <td>[finland]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>53</th>\n",
              "      <td>462cbb326ccd8587cae7a3538c8c6712d9013698</td>\n",
              "      <td>[china., canada]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>54</th>\n",
              "      <td>4774dbbe921bb0fd3be94c6e0f236dc954355db3</td>\n",
              "      <td>[saudi arabia, united states, united kingdom]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>55</th>\n",
              "      <td>48656efc59191537073975938f25f201524971af</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>56</th>\n",
              "      <td>489dc3cd19a841baa870518a82cc93697e804a30</td>\n",
              "      <td>[taiwan r.o.c.]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>57</th>\n",
              "      <td>48b0dfada83cdf2b9a3de65a15ef635cff2b505b</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>58</th>\n",
              "      <td>48b7966e4d83d9e9789c35151fd6d870dbc6551a</td>\n",
              "      <td>[india]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>59</th>\n",
              "      <td>48f486ccea11b4ba01186e287124316c962857f7</td>\n",
              "      <td>[china, usa, italy]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>60</th>\n",
              "      <td>49ac69f362c27acbc6de0c5cbb640267e7a1e797</td>\n",
              "      <td>[china., usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>61</th>\n",
              "      <td>4ad5a1ef0e00bd793a408c7915c6e207f360138f</td>\n",
              "      <td>[south korea]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>62</th>\n",
              "      <td>4bc41aaa2b754b3ec526eb40c384a18ab38b8d51</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>63</th>\n",
              "      <td>4c222bd3e1c78c48931f4e69164fc6ee7bffb5ff</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>64</th>\n",
              "      <td>4c452cc6bb3cb81575f11749b5fb5e5206d6836e</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>65</th>\n",
              "      <td>4c84d1153daa335f5ff6d61db665024b32ac8195</td>\n",
              "      <td>[china, united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>66</th>\n",
              "      <td>4f1dc6c07d444609154348e7ef42cc25d9f65df0</td>\n",
              "      <td>[india]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>67</th>\n",
              "      <td>4fd16ae978abf8de7ff390d6c19d53c39cfd93a0</td>\n",
              "      <td>[usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>68</th>\n",
              "      <td>502f8c21aca1e2e1f17dc79ee6be922c3e5dcfa6</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>69</th>\n",
              "      <td>50be853b37945ba63f2fa2c4654b8c57ce0c1597</td>\n",
              "      <td>[germany, france]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>70</th>\n",
              "      <td>5108ce6531c57ac210900865b5170794544c4692</td>\n",
              "      <td>[united kingdom]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>71</th>\n",
              "      <td>5307fbd7cbc9b0b7e87ec4d1a8b99e544d81446f</td>\n",
              "      <td>[usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>72</th>\n",
              "      <td>53b7087c5519fd69c606a2d3de52e9b6b7799945</td>\n",
              "      <td>[spain]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>73</th>\n",
              "      <td>53bc05147511693d56aa5cfe1ba38931da0a7ecb</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>74</th>\n",
              "      <td>546de9ee7a4ee26a482af31e1b374ee85242e0c5</td>\n",
              "      <td>[new zealand, china, united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75</th>\n",
              "      <td>5479e1d0baefe41058eca71bb114a61fb06c7ae9</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>76</th>\n",
              "      <td>548541513fec823d4600ec793be7541b17133a36</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>77</th>\n",
              "      <td>549a77a27e6c3cf72075693d5382f8ed14bc4c15</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>78</th>\n",
              "      <td>54cfc3c68e1e4832fee5b3294e5673e37978ebdf</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>79</th>\n",
              "      <td>55f68ad5d627bb2a2a97ad10aa4df895b3f78262</td>\n",
              "      <td>[germany]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>80</th>\n",
              "      <td>5756f748eb5e3dae569b6c4568caca120b137b50</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>81</th>\n",
              "      <td>575878920f54c7e5b25eb200434c0e769661dc30</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>82</th>\n",
              "      <td>580ef02f408295bba21f0ad87b6eba6ba9676163</td>\n",
              "      <td>[usa, taiwan]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>83</th>\n",
              "      <td>59f495eef3dd030c9e89759bcf3aeb1b0f0dd222</td>\n",
              "      <td>[turkey, taiwan roc]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>84</th>\n",
              "      <td>5a0089eb2fc6fc7eabc5f98b7216e1568967b7c7</td>\n",
              "      <td>[canada]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>85</th>\n",
              "      <td>5a17ed3e4abf295f5820c65f56398266c1baae98</td>\n",
              "      <td>[china, usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>86</th>\n",
              "      <td>5c9372cbcf5acd3ce0e9ba3c3aa9e6a75bf9ed5a</td>\n",
              "      <td>[taiwan]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>87</th>\n",
              "      <td>5ce430242bc6674c68d00110511cd1da4f53b265</td>\n",
              "      <td>[people's republic of china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>88</th>\n",
              "      <td>6427e85b4473cc2a84635b08384e479c860270da</td>\n",
              "      <td>[malaysia]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89</th>\n",
              "      <td>64f2abbb14a6eaef0fecc44ace54524595f01efd</td>\n",
              "      <td>[usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90</th>\n",
              "      <td>65486f9ea230a303f0af4a0bc0a9e66e3e7629d8</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>91</th>\n",
              "      <td>6642a3a9cff3380628946b0ba6de8b03d9f47278</td>\n",
              "      <td>[singapore]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>92</th>\n",
              "      <td>668c0f3335c42682e4c38f0647ab4a90ac2cbd70</td>\n",
              "      <td>[usa, hong kong ]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>93</th>\n",
              "      <td>66b67940ae16f657fd93fad230081d20d98c55f7</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>94</th>\n",
              "      <td>67c136d7af3f6957a92bb35dd8b7afd018276a20</td>\n",
              "      <td>[georgia, china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>95</th>\n",
              "      <td>689fd267c4b50d1031cd47d18361f76f3275db55</td>\n",
              "      <td>[united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>96</th>\n",
              "      <td>68ed7bb581b0cf32116ee46767c08e3180b05c34</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>97</th>\n",
              "      <td>6b0f17a81d8f9849d4937aafbdbf74ec71820811</td>\n",
              "      <td>[germany, china, usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>98</th>\n",
              "      <td>6b6974f77478ef8c519ebbb1a6bab4f434f7cc82</td>\n",
              "      <td>[hong kong, kong, hong kong ]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>99</th>\n",
              "      <td>6c7c93c25caa6d94c70c891e2446a4a12e729365</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>100</th>\n",
              "      <td>6cf87a546884756094da0d300e85a061c2cc43ea</td>\n",
              "      <td>[china., china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>101</th>\n",
              "      <td>6d34c33b7b2d20fa4474cb7d92d008ca466393a8</td>\n",
              "      <td>[germany. cinatl@em.uni frankfurt.de]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>102</th>\n",
              "      <td>6dd88d9273b7892dd1b5cece675247592386ef50</td>\n",
              "      <td>[united kingdom, japan]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>103</th>\n",
              "      <td>6eea00c3e8c404e11fe2fd60ffdb447da29833a9</td>\n",
              "      <td>[usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>104</th>\n",
              "      <td>6f86b074f8b9da74fbf32a1886f143cbd9aa5ca2</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>105</th>\n",
              "      <td>6fa1537d3cad42c332a707aa76b62a4d6d5e8736</td>\n",
              "      <td>[china, ireland]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>106</th>\n",
              "      <td>70fd2c4e38970a59c42925daef90f674d7b21302</td>\n",
              "      <td>[egypt., united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>107</th>\n",
              "      <td>73243d95149d9f2260f3c852599d7d39f4cc8ccc</td>\n",
              "      <td>[viet nam, france]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>108</th>\n",
              "      <td>7404ea79a88b498667ba682ed3cce74c0a2e85f8</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>109</th>\n",
              "      <td>76774987e549a1e89a4b73189cc630193ed25e72</td>\n",
              "      <td>[usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>110</th>\n",
              "      <td>76d087240ee815ccd4773810c6032f31b1901db2</td>\n",
              "      <td>[germany]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>111</th>\n",
              "      <td>779c1b5cb3afe3d50219aa2af791014a22eb355a</td>\n",
              "      <td>[usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>112</th>\n",
              "      <td>7817b03a433df4b3f93127feac4b0d8090c5b56c</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>113</th>\n",
              "      <td>79ba46fafc5a6279ea9cc27ff3a5d5dddaacdf96</td>\n",
              "      <td>[germany, china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>114</th>\n",
              "      <td>7a7c1c991ee3905b06ca628a523f693a402cc7f1</td>\n",
              "      <td>[kingdom of saudi arabia, usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>115</th>\n",
              "      <td>7acb4567a32041904593b27ebdb13d4349bcf59c</td>\n",
              "      <td>[kong, germany, china, austria, hong kong]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>116</th>\n",
              "      <td>7c8152250ebc8a8b31066de90c3bdaebc076365b</td>\n",
              "      <td>[china, united kingdom]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>117</th>\n",
              "      <td>81c77f6ea4ad20908978c014fea0abb7d5c557aa</td>\n",
              "      <td>[india]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>118</th>\n",
              "      <td>824aab33809eed4758f574ccb069df25b6da76b4</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>119</th>\n",
              "      <td>841e2b8df37c627db6013f7da95a3d9b7cff81f2</td>\n",
              "      <td>[turkey, india, united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>120</th>\n",
              "      <td>844fe2bd77662e149cfb3564d01aadb04cbd28e5</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>121</th>\n",
              "      <td>85e00fe8099f838d9eb455a7f62440d1bf7bc639</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>122</th>\n",
              "      <td>867ebb2be2d466bcb35e5a7319708eaff39c4799</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>123</th>\n",
              "      <td>8e011c1635cc819199daf9883b3fa21dd3cdf75c</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>124</th>\n",
              "      <td>8f07d14b2b470c80d8f88f54fb5cb0c72e5e7ecd</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>125</th>\n",
              "      <td>8f764e7df0f9ecd8662a9fe392222f7a8fef1644</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>126</th>\n",
              "      <td>917630308f0265e62aff9b47dd1808be33922b08</td>\n",
              "      <td>[canada, saudi arabia, usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>127</th>\n",
              "      <td>92ab5b61b296652be2d16d5b29918ead488e5915</td>\n",
              "      <td>[uk, usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128</th>\n",
              "      <td>9305dbadf39b7da72a61b551eb55bda43567b7da</td>\n",
              "      <td>[hong kong special administrative region peopl...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>129</th>\n",
              "      <td>93b922d4f3bae90ff8ce10b4fed7a84888ddcc53</td>\n",
              "      <td>[taiwan.]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>130</th>\n",
              "      <td>944bf812405f1055f6ec4f3f9c9af134e6da2b5a</td>\n",
              "      <td>[germany, japan]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>131</th>\n",
              "      <td>94911e2cb4c082fea75d81778ba059f7fa42c914</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>132</th>\n",
              "      <td>9695a8fb288be9ef014dbaf030498d3c7ce0fc81</td>\n",
              "      <td>[usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>133</th>\n",
              "      <td>96f3290023e97352b8abeecbf78bc936bbb917be</td>\n",
              "      <td>[france]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>134</th>\n",
              "      <td>97f2dbc89c2f6b587d05b88776e8da3faa527c8b</td>\n",
              "      <td>[usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>135</th>\n",
              "      <td>988ae326438f88f7131355147a2bea3c2b42175b</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>136</th>\n",
              "      <td>98d83658e5a7c2174de3524a9a3b7c057a34b085</td>\n",
              "      <td>[uk]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>137</th>\n",
              "      <td>9a097f4bfa3cbb71a7efad65d1c9280955799979</td>\n",
              "      <td>[germany, australia, united kingdom]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>138</th>\n",
              "      <td>9a58965aaaaad7424a04cebbab0871a9224a9508</td>\n",
              "      <td>[china, australia]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>139</th>\n",
              "      <td>9ad252c633b7596a4b64ca9f1699a0db5ce99c05</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>140</th>\n",
              "      <td>9b0c87f808b1b66f2937d7a7acb524a756b6113b</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>141</th>\n",
              "      <td>9b9016e259bd0ad640825ebc12c130bd7e050323</td>\n",
              "      <td>[canada]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>142</th>\n",
              "      <td>9cd6628012c0dcc7ea502d846e138d3bf8170b55</td>\n",
              "      <td>[united states, china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>143</th>\n",
              "      <td>9ce59127771505d6353605873087993ce8cf6e7a</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>144</th>\n",
              "      <td>9fd4c7331c270aa0f93c5037f0b23327e17c0f24</td>\n",
              "      <td>[brazil]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>145</th>\n",
              "      <td>a1104051dbb2b39a6a23d64dfdd49f784ea34676</td>\n",
              "      <td>[republic of korea]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>146</th>\n",
              "      <td>a1241365de2d8839b7d02dc30244c15020657329</td>\n",
              "      <td>[india]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>147</th>\n",
              "      <td>a1ddaf941a4c1a0145ce1af098cf1d9da207ed35</td>\n",
              "      <td>[united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>148</th>\n",
              "      <td>a3e8cfc509af101c522d4193c8917d6e8f68b37b</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>149</th>\n",
              "      <td>a68fdcd0f4e55fda6918c216bc3a5b37ef45289e</td>\n",
              "      <td>[belgium, germany, usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>150</th>\n",
              "      <td>a79eda4de7857a7fe88b83a1cc494013c23fc048</td>\n",
              "      <td>[united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>151</th>\n",
              "      <td>a80c3e9dfde9824cb8f54f9f382d0d601743ffc0</td>\n",
              "      <td>[hong kong sar, hong kong special administrati...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>152</th>\n",
              "      <td>aa1262ce65755ce44f6a12b1644a065596c7890e</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>153</th>\n",
              "      <td>ab1d784d27adf305fd189abf1a074d758a67b14a</td>\n",
              "      <td>[united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>154</th>\n",
              "      <td>ab6b98662d778b6aa71751d6a2e3b3c19282f72a</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>155</th>\n",
              "      <td>ad357dd76eea58e5a29727e554d3ff431cbade5d</td>\n",
              "      <td>[united states, iran]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>156</th>\n",
              "      <td>ad5590a8a445b4c404049f01469b9a5863402734</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>157</th>\n",
              "      <td>aee0ceba66759ca3b7c77b16e53069cb2fe8f2b5</td>\n",
              "      <td>[united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>158</th>\n",
              "      <td>afd976b623d40fccd44c2d5bc2ad108daef36c7a</td>\n",
              "      <td>[hong kong sar]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>159</th>\n",
              "      <td>afe2138302c85b1f5c5ff6865527d6ead67574ac</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>160</th>\n",
              "      <td>b1749aa40bfee7dd0d990fcff4e0e13294706825</td>\n",
              "      <td>[hong kong sar, hong kong-china, hong kong spe...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>161</th>\n",
              "      <td>b1b8c46ffa22a9a42bae2689db274e0e3d580e59</td>\n",
              "      <td>[united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>162</th>\n",
              "      <td>b21be53f027cbee5bfb70762cb7b008d9cdf78f5</td>\n",
              "      <td>[india]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>163</th>\n",
              "      <td>b25b080e6c1f58388f8e7ac229ef51224e081ac4</td>\n",
              "      <td>[taiwan]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>164</th>\n",
              "      <td>b47f37acf862906eeae49368e09f6b397194cdd7</td>\n",
              "      <td>[india]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>165</th>\n",
              "      <td>b5ace18191f3c38909720e5805118250b750e0c8</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>166</th>\n",
              "      <td>b5be10942198c0a79dff8aea2253b77ae2401882</td>\n",
              "      <td>[turkey, china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>167</th>\n",
              "      <td>b62add31f59fb244e0721a204bdec76888be7e16</td>\n",
              "      <td>[india]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>168</th>\n",
              "      <td>ba149723f93f8c294c473351fa73a17e42108b14</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>169</th>\n",
              "      <td>ba8577fbe95f71f3482edea00b9e7579bc360799</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>170</th>\n",
              "      <td>ba94dbb19b3a574e0f02dbd34b75c42359a52358</td>\n",
              "      <td>[hong kong special administrative region china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>171</th>\n",
              "      <td>baabfb35a321ea12028160e0d2c1552a2fda2dd5</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>172</th>\n",
              "      <td>bcf51d33bc41647bbea9b36ba89ebaae13c4a982</td>\n",
              "      <td>[uk]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>173</th>\n",
              "      <td>bdd38af290f6aa98b23b9278047ca06f232c081a</td>\n",
              "      <td>[germany, france, spain]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>174</th>\n",
              "      <td>bdfe90336091a24dd75c44257b4707a4a903d22b</td>\n",
              "      <td>[turkey, china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>175</th>\n",
              "      <td>c12a11fa9c5fdff0bf85a9f0111c64d6dffe8d26</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>176</th>\n",
              "      <td>c12d71462529856463c2432d5628d10a0027c404</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>177</th>\n",
              "      <td>c3bf8040e0bb5b6667bf25a4be148aa55b18acf0</td>\n",
              "      <td>[iraq]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>178</th>\n",
              "      <td>c646e655066d0982c151b516ebdf0334d037ffcf</td>\n",
              "      <td>[egypt, saudi arabia]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>179</th>\n",
              "      <td>c6ec1380338cb2467dc6fc14add09ca5bea18411</td>\n",
              "      <td>[china, united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>180</th>\n",
              "      <td>c747c5b5cdebe39ac26640ddfb010724d938d649</td>\n",
              "      <td>[united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>181</th>\n",
              "      <td>c954675ee859e2f7b8f352a398a67469b50f05de</td>\n",
              "      <td>[turkey]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>182</th>\n",
              "      <td>ca36180197f0a2bda83c8c743b1cad8d4c90924e</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>183</th>\n",
              "      <td>cbf20969da0fdadbb513502aa324d940defc5f15</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>184</th>\n",
              "      <td>cd70d9a7adb120c4fcbe4aa8a1bd64a7d8483764</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>185</th>\n",
              "      <td>cfeda05ff998d6973560c4f55577a5feaeccb59b</td>\n",
              "      <td>[spain]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>186</th>\n",
              "      <td>d16e1bd4c6cae1bb55dbc695c5e2ba5105a13921</td>\n",
              "      <td>[germany]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>187</th>\n",
              "      <td>d2b1853aae556beaf9e1bc9d802642fffe35cf68</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>188</th>\n",
              "      <td>d33817b56a98cb895588efa155ae076ec74ec139</td>\n",
              "      <td>[canada, spain]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>189</th>\n",
              "      <td>d3744e7581b12fe33a93e21e89b5da988b790b4b</td>\n",
              "      <td>[usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>190</th>\n",
              "      <td>d3bf1b40c7c93d6bd6ef2d1769b0e68ed233c18a</td>\n",
              "      <td>[italy]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>191</th>\n",
              "      <td>d4cfb1fc4fc53abbc1d4b0ca60276c6af6632c3c</td>\n",
              "      <td>[turkey, china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>192</th>\n",
              "      <td>d4f9d334eb5ffbefbef6c90a23f7a243fa89065c</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>193</th>\n",
              "      <td>d6a34d159840a3895ac1768920a1c498d3c448c6</td>\n",
              "      <td>[kingdom of saudi arabia, saudi arabia]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>194</th>\n",
              "      <td>d9d218af628830db318305235b3b252d85f62dea</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>195</th>\n",
              "      <td>db142fe07544dcf0e454f8a9f39452f0aa92a6ca</td>\n",
              "      <td>[turkey]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>196</th>\n",
              "      <td>db9b9f34fb37dfbeef7e0e900e834e982536de56</td>\n",
              "      <td>[united states, canada, denmark]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>197</th>\n",
              "      <td>dbefc8ad2a3de5d1696b7e604de8bce1da2ea8cd</td>\n",
              "      <td>[turkey, south korea]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>198</th>\n",
              "      <td>dc3656324843f16d93801bac3e78a5fd316ac988</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>199</th>\n",
              "      <td>ddc40ffc47069f3714c8da65843f36f41ed0f8bb</td>\n",
              "      <td>[india, united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>200</th>\n",
              "      <td>dfb0fedbeed56bd2b795a67faab28295afc14c96</td>\n",
              "      <td>[turkey, people's republic of china, china, se...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>201</th>\n",
              "      <td>e04b5db8306ab29c14bbaa9d1de25e98839ed70c</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>202</th>\n",
              "      <td>e08ff7855eaa0c9d0bb785dcffc24e65910b7184</td>\n",
              "      <td>[uk]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>203</th>\n",
              "      <td>e0ec89c24c99c50b1f83ed2d77fe7bd5ef94dc8a</td>\n",
              "      <td>[germany, poland]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>204</th>\n",
              "      <td>e2273d397d1b0c37a010d81be706c2a28af62c9e</td>\n",
              "      <td>[italy]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>205</th>\n",
              "      <td>e3b40cc8e0e137c416b4a2273a4dca94ae8178cc</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>206</th>\n",
              "      <td>e3c87d73a6abced2f827ee3e6daf050663b9b7fb</td>\n",
              "      <td>[usa]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>207</th>\n",
              "      <td>e47779a5dd554c5a35cdb58e5e7fb682ec177f24</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>208</th>\n",
              "      <td>e4b18c2650a0735f7db3a316ff8c560da61931bb</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>209</th>\n",
              "      <td>e52ecf4b22e9dcb340ccf67f0251b5a3f9373f02</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>210</th>\n",
              "      <td>e5a5a852ae1cdcd98504799f618a8bebbfd7128c</td>\n",
              "      <td>[ethiopia]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>211</th>\n",
              "      <td>e67124fe8f187a99ef873140524fefc50796eccc</td>\n",
              "      <td>[united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>212</th>\n",
              "      <td>e6af63ce394cb9c51c04251c99565fd0e6d58c1b</td>\n",
              "      <td>[china, united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>213</th>\n",
              "      <td>e6d2c030bb4bb71cae43fd29624e70872b1662a4</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>214</th>\n",
              "      <td>e6d3acfd725e130a51eab3efafcf05dfb1febbc9</td>\n",
              "      <td>[hong kong special administrative region]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>215</th>\n",
              "      <td>e7a4159ce5cead74ff87dc1199e3f461631adf96</td>\n",
              "      <td>[france, canada, italy]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>216</th>\n",
              "      <td>e847d433e7424152a9846673209cb73027415ecd</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>217</th>\n",
              "      <td>e889b19090410704479ea3c7a1596b827f3dbcd0</td>\n",
              "      <td>[china.]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>218</th>\n",
              "      <td>e9895961fa3aee4ebcaa947a2111ec9e64cbbfbf</td>\n",
              "      <td>[india, china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>219</th>\n",
              "      <td>e9dfbc4084497e74dcaf6bd9c1dbde2b0fb70802</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>220</th>\n",
              "      <td>ea646b114ea01f978d205ed97405e1f2afed2dfd</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>221</th>\n",
              "      <td>eb5bfeea7bc4bb15dcf2ad3e26dc6478c277fd6e</td>\n",
              "      <td>[finland]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>222</th>\n",
              "      <td>eba1da4b90ee7cff2811391e12e773baa5cd6c2e</td>\n",
              "      <td>[germany]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>223</th>\n",
              "      <td>ebfc471829e1303889bd23779d1c2ffb9467ab7e</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>224</th>\n",
              "      <td>ed344fa4250b398132e3066793aadfa9a305cf78</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>225</th>\n",
              "      <td>ed99ea6c7af5c77db2bf336d263db55646686098</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>226</th>\n",
              "      <td>eff6ce20122149117020cda90ad17f7cff0e9fd4</td>\n",
              "      <td>[united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>227</th>\n",
              "      <td>f0a7684b84d874e9d61eee9c4cff37bb45bb2547</td>\n",
              "      <td>[south korea]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>228</th>\n",
              "      <td>f0d2dc18c4737a62d2de12b56d4dba143d21344a</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>229</th>\n",
              "      <td>f0dea096a4f73085b277b6977c8c3367b2957a6e</td>\n",
              "      <td>[hong kong sar]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>230</th>\n",
              "      <td>f10fb0ee869f01e39652ca0079888562e865b0ea</td>\n",
              "      <td>[germany, united states, france]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>231</th>\n",
              "      <td>f14434d7d3b68f4fe7f68adba747b7700ccdd6ac</td>\n",
              "      <td>[hong kong sar, china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>232</th>\n",
              "      <td>f279037d5e828d9b0b9f6f262c0386925a70f846</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>233</th>\n",
              "      <td>f5cce8a5be5bc7be7a749a51ce8f71add6e5d08f</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>234</th>\n",
              "      <td>f6b9fd7dbed6516888eca71004caaa62aa0132d4</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>235</th>\n",
              "      <td>f7f99b10a8f56b2e0e85885a30ef3e3f3258ce7d</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>236</th>\n",
              "      <td>f8c15039fad3e71a1479b9d09516aad16fc52f70</td>\n",
              "      <td>[china]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>237</th>\n",
              "      <td>fa0c32f39abb602e0161bf738b5292e251c0c885</td>\n",
              "      <td>[united states, canada]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>238</th>\n",
              "      <td>faa2aa0782a6ca9f4072e4918205358347219799</td>\n",
              "      <td>[united states]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>239</th>\n",
              "      <td>faf3ed3d6fc359c1f310e32061e5ed414fee7017</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>240</th>\n",
              "      <td>fb0c496af128204a417aa9b18ce6ed674cbbff6e</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>241</th>\n",
              "      <td>fbe041fcdd278e6044874daa9f9e071b95b4d2ef</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>242</th>\n",
              "      <td>fc766f4da6dcc43946f06f65cde8d79dcb740c11</td>\n",
              "      <td>[saudi arabia, ethiopia]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>243</th>\n",
              "      <td>fd28e6d03eef27b0454f13ca539dc1498242a4c2</td>\n",
              "      <td>[china, canada]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>244</th>\n",
              "      <td>fd6af3846d9cfd5b1c9f86b5e16ec803a88cc1f5</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>245</th>\n",
              "      <td>ff1cc08ebe7f5a104152662fa87ff683524165c7</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                          sha                                 geolocated_country\n",
              "0    00c71f72eb837e2342dbda8761664e221e2a03df                                                 []\n",
              "1    05192151667b1bb4e3405de11f6e4ae2f844e7c5                                            [china]\n",
              "2    056610b4981cee0efc485ed3f978f541fbe55f54                                               [uk]\n",
              "3    0792384d074cef963c808eacf3c63e3654776a2a                                                 []\n",
              "4    0c36cc3dc9a1632f0fbf14372f376f89521718c5                                          [germany]\n",
              "5    0dca038ac8dfd45a921b7cd9f1c90a8554799e23                                                 []\n",
              "6    0dd1ab1f5811f3a1fe36f45577846243b3cf14f8                                            [china]\n",
              "7    0eadf5a901c0d89fad2c202990056556be103e12                                           [china.]\n",
              "8    0f6a5070fd5f9bd5d46c3bbd4545c55982e726c3                                           [france]\n",
              "9    1007a3041cb5ae9e3e6f09712d81277c02ed3dbf                                                 []\n",
              "10   106db157fd5d6ee766feabadf0d35a24d6d37895                                                 []\n",
              "11   114ed64f52f503d9d2e2ba1fd1ee62b0a168cd84                                 [australia, china]\n",
              "12   16f0732b9fee4779a3eb38280b344f866692d346                                            [china]\n",
              "13   1766a9d5945897581c80f83276cc723c77e3798d                                                 []\n",
              "14   188e7ff1e260864c89f266b5597de26d69a84660                                                 []\n",
              "15   19a08cc1423d6006b2251bdcfd142f88db7002e7                            [turkey, united states]\n",
              "16   19e18a7c27512439dac91fc1096937fd03496c13                                                 []\n",
              "17   1a48450da54865731ffe01c0e289a63065b3b1fd                     [china, malawi, united states]\n",
              "18   1aa7102887a834cf5b833d122ca2eb015b7aeb91         [iran, france, thailand, norway, pakistan]\n",
              "19   1ad1d4b84aea4ceaf05c62a1ad04e7150f7f4684                                   [united kingdom]\n",
              "20   1b70c124d7e761eb19c35e8924b7551c0939495a                                            [china]\n",
              "21   1d99db01b6d686c51b41ad60824f16859f67b7ef                                            [china]\n",
              "22   1e0a165313e080137556cb75b1af2bb0f6984d9f                                                 []\n",
              "23   1ffc9948cf2eb9099c4a7e8055bda8c71cbc289e                                                 []\n",
              "24   21c4d6c08d861b792900c32c5a0df1c1d407a005                         [australia, united states]\n",
              "25   21e3bb96c58ee1a3f80f743e83b0d4636ea717ae                                            [china]\n",
              "26   23e7355b5e4e0209f64c9d8d5772092a53b72686                                            [china]\n",
              "27   24e17488d399c436305c819953beae2961214771                           [georgia, united states]\n",
              "28   2c17a581c10ece6c5b5dec88f228f1f43d3fcc14                                    [united states]\n",
              "29   2d0285c90976dfa43d58eca6b7d1d7ef29994fc2                        [senegal, australia, china]\n",
              "30   2f5bb8babcf9e40a337087b6925a3b5442bfbb40                                                 []\n",
              "31   3034d4ed2359a4706ff9f5096b1945eaa3b8bd1f                                           [canada]\n",
              "32   30b5d794d107c4c6680655a6de775093a394e8db                                                 []\n",
              "33   30c67218bbd1a5ffe68dab7fe7dfc5bc662e05a2                                    [united states]\n",
              "34   30fcd017c21fc5736d621c560aa22d624f8fcc87                                       [uk, france]\n",
              "35   3591382e6aefa066fe730ece11ba67995542353e              [sweden, india, united states, italy]\n",
              "36   35d36c0a736ae7ca642a8badd24bf4d9be3ca613                                           [canada]\n",
              "37   36f9ee4d21bf47a3f9f504f7fca3a1db625899d2                                    [united states]\n",
              "38   37341d7b81d0b9bdfaf84267318606cc7e91e3f4                                      [new zealand]\n",
              "39   3aaa23f7050caa452899603eaa4267d525bb23e9                                            [china]\n",
              "40   3bdbda7b9bad2d94bfc88950c9efd33c90fb94b6  [turkey, germany, france, azerbaijan, india, u...\n",
              "41   3c15ba282c7261b3447e3a68a91e1a3b23b6fa3d                             [china, united states]\n",
              "42   3e255292c1eb4fd8752ef1d603ad88beeba43f3f                                                 []\n",
              "43   3e3c84ba064eb8d3a0f7972d43235da7271478e8                                              [usa]\n",
              "44   3f13102b780fa8c0da16df0187c1236f0c2da9e6                                           [canada]\n",
              "45   3ff6ab72e32eab43e68725fb74108b596818b657                                            [iran.]\n",
              "46   4025115c646713cd5fc71cdf3c96cc235152d9b0                                    [united states]\n",
              "47   4043a852290c8823faa76b7592c9f9927c7d0928                                        [hong kong]\n",
              "48   417cbe38a2f8a93d0827cd67f4c42076921d6050      [lithuania, finland, estonia, norway, latvia]\n",
              "49   4224b1ef00b2907298fb4cb0965aac20d598693e                                           [taiwan]\n",
              "50   430088e2d738c4c20413082888b2666668c9105f                                    [turkey, china]\n",
              "51   43f9334d47199e5fe08b4f6094a96495cc627f53                                        [hong kong]\n",
              "52   4519998f22e00e318090334979b5d837a0e10da4                                          [finland]\n",
              "53   462cbb326ccd8587cae7a3538c8c6712d9013698                                   [china., canada]\n",
              "54   4774dbbe921bb0fd3be94c6e0f236dc954355db3      [saudi arabia, united states, united kingdom]\n",
              "55   48656efc59191537073975938f25f201524971af                                            [china]\n",
              "56   489dc3cd19a841baa870518a82cc93697e804a30                                    [taiwan r.o.c.]\n",
              "57   48b0dfada83cdf2b9a3de65a15ef635cff2b505b                                                 []\n",
              "58   48b7966e4d83d9e9789c35151fd6d870dbc6551a                                            [india]\n",
              "59   48f486ccea11b4ba01186e287124316c962857f7                                [china, usa, italy]\n",
              "60   49ac69f362c27acbc6de0c5cbb640267e7a1e797                                      [china., usa]\n",
              "61   4ad5a1ef0e00bd793a408c7915c6e207f360138f                                      [south korea]\n",
              "62   4bc41aaa2b754b3ec526eb40c384a18ab38b8d51                                            [china]\n",
              "63   4c222bd3e1c78c48931f4e69164fc6ee7bffb5ff                                                 []\n",
              "64   4c452cc6bb3cb81575f11749b5fb5e5206d6836e                                            [china]\n",
              "65   4c84d1153daa335f5ff6d61db665024b32ac8195                             [china, united states]\n",
              "66   4f1dc6c07d444609154348e7ef42cc25d9f65df0                                            [india]\n",
              "67   4fd16ae978abf8de7ff390d6c19d53c39cfd93a0                                              [usa]\n",
              "68   502f8c21aca1e2e1f17dc79ee6be922c3e5dcfa6                                                 []\n",
              "69   50be853b37945ba63f2fa2c4654b8c57ce0c1597                                  [germany, france]\n",
              "70   5108ce6531c57ac210900865b5170794544c4692                                   [united kingdom]\n",
              "71   5307fbd7cbc9b0b7e87ec4d1a8b99e544d81446f                                              [usa]\n",
              "72   53b7087c5519fd69c606a2d3de52e9b6b7799945                                            [spain]\n",
              "73   53bc05147511693d56aa5cfe1ba38931da0a7ecb                                            [china]\n",
              "74   546de9ee7a4ee26a482af31e1b374ee85242e0c5                [new zealand, china, united states]\n",
              "75   5479e1d0baefe41058eca71bb114a61fb06c7ae9                                            [china]\n",
              "76   548541513fec823d4600ec793be7541b17133a36                                            [china]\n",
              "77   549a77a27e6c3cf72075693d5382f8ed14bc4c15                                                 []\n",
              "78   54cfc3c68e1e4832fee5b3294e5673e37978ebdf                                            [china]\n",
              "79   55f68ad5d627bb2a2a97ad10aa4df895b3f78262                                          [germany]\n",
              "80   5756f748eb5e3dae569b6c4568caca120b137b50                                                 []\n",
              "81   575878920f54c7e5b25eb200434c0e769661dc30                                                 []\n",
              "82   580ef02f408295bba21f0ad87b6eba6ba9676163                                      [usa, taiwan]\n",
              "83   59f495eef3dd030c9e89759bcf3aeb1b0f0dd222                               [turkey, taiwan roc]\n",
              "84   5a0089eb2fc6fc7eabc5f98b7216e1568967b7c7                                           [canada]\n",
              "85   5a17ed3e4abf295f5820c65f56398266c1baae98                                       [china, usa]\n",
              "86   5c9372cbcf5acd3ce0e9ba3c3aa9e6a75bf9ed5a                                           [taiwan]\n",
              "87   5ce430242bc6674c68d00110511cd1da4f53b265                       [people's republic of china]\n",
              "88   6427e85b4473cc2a84635b08384e479c860270da                                         [malaysia]\n",
              "89   64f2abbb14a6eaef0fecc44ace54524595f01efd                                              [usa]\n",
              "90   65486f9ea230a303f0af4a0bc0a9e66e3e7629d8                                                 []\n",
              "91   6642a3a9cff3380628946b0ba6de8b03d9f47278                                        [singapore]\n",
              "92   668c0f3335c42682e4c38f0647ab4a90ac2cbd70                                  [usa, hong kong ]\n",
              "93   66b67940ae16f657fd93fad230081d20d98c55f7                                            [china]\n",
              "94   67c136d7af3f6957a92bb35dd8b7afd018276a20                                   [georgia, china]\n",
              "95   689fd267c4b50d1031cd47d18361f76f3275db55                                    [united states]\n",
              "96   68ed7bb581b0cf32116ee46767c08e3180b05c34                                            [china]\n",
              "97   6b0f17a81d8f9849d4937aafbdbf74ec71820811                              [germany, china, usa]\n",
              "98   6b6974f77478ef8c519ebbb1a6bab4f434f7cc82                      [hong kong, kong, hong kong ]\n",
              "99   6c7c93c25caa6d94c70c891e2446a4a12e729365                                            [china]\n",
              "100  6cf87a546884756094da0d300e85a061c2cc43ea                                    [china., china]\n",
              "101  6d34c33b7b2d20fa4474cb7d92d008ca466393a8              [germany. cinatl@em.uni frankfurt.de]\n",
              "102  6dd88d9273b7892dd1b5cece675247592386ef50                            [united kingdom, japan]\n",
              "103  6eea00c3e8c404e11fe2fd60ffdb447da29833a9                                              [usa]\n",
              "104  6f86b074f8b9da74fbf32a1886f143cbd9aa5ca2                                            [china]\n",
              "105  6fa1537d3cad42c332a707aa76b62a4d6d5e8736                                   [china, ireland]\n",
              "106  70fd2c4e38970a59c42925daef90f674d7b21302                            [egypt., united states]\n",
              "107  73243d95149d9f2260f3c852599d7d39f4cc8ccc                                 [viet nam, france]\n",
              "108  7404ea79a88b498667ba682ed3cce74c0a2e85f8                                            [china]\n",
              "109  76774987e549a1e89a4b73189cc630193ed25e72                                              [usa]\n",
              "110  76d087240ee815ccd4773810c6032f31b1901db2                                          [germany]\n",
              "111  779c1b5cb3afe3d50219aa2af791014a22eb355a                                              [usa]\n",
              "112  7817b03a433df4b3f93127feac4b0d8090c5b56c                                                 []\n",
              "113  79ba46fafc5a6279ea9cc27ff3a5d5dddaacdf96                                   [germany, china]\n",
              "114  7a7c1c991ee3905b06ca628a523f693a402cc7f1                     [kingdom of saudi arabia, usa]\n",
              "115  7acb4567a32041904593b27ebdb13d4349bcf59c         [kong, germany, china, austria, hong kong]\n",
              "116  7c8152250ebc8a8b31066de90c3bdaebc076365b                            [china, united kingdom]\n",
              "117  81c77f6ea4ad20908978c014fea0abb7d5c557aa                                            [india]\n",
              "118  824aab33809eed4758f574ccb069df25b6da76b4                                                 []\n",
              "119  841e2b8df37c627db6013f7da95a3d9b7cff81f2                     [turkey, india, united states]\n",
              "120  844fe2bd77662e149cfb3564d01aadb04cbd28e5                                            [china]\n",
              "121  85e00fe8099f838d9eb455a7f62440d1bf7bc639                                            [china]\n",
              "122  867ebb2be2d466bcb35e5a7319708eaff39c4799                                                 []\n",
              "123  8e011c1635cc819199daf9883b3fa21dd3cdf75c                                            [china]\n",
              "124  8f07d14b2b470c80d8f88f54fb5cb0c72e5e7ecd                                                 []\n",
              "125  8f764e7df0f9ecd8662a9fe392222f7a8fef1644                                                 []\n",
              "126  917630308f0265e62aff9b47dd1808be33922b08                        [canada, saudi arabia, usa]\n",
              "127  92ab5b61b296652be2d16d5b29918ead488e5915                                          [uk, usa]\n",
              "128  9305dbadf39b7da72a61b551eb55bda43567b7da  [hong kong special administrative region peopl...\n",
              "129  93b922d4f3bae90ff8ce10b4fed7a84888ddcc53                                          [taiwan.]\n",
              "130  944bf812405f1055f6ec4f3f9c9af134e6da2b5a                                   [germany, japan]\n",
              "131  94911e2cb4c082fea75d81778ba059f7fa42c914                                                 []\n",
              "132  9695a8fb288be9ef014dbaf030498d3c7ce0fc81                                              [usa]\n",
              "133  96f3290023e97352b8abeecbf78bc936bbb917be                                           [france]\n",
              "134  97f2dbc89c2f6b587d05b88776e8da3faa527c8b                                              [usa]\n",
              "135  988ae326438f88f7131355147a2bea3c2b42175b                                                 []\n",
              "136  98d83658e5a7c2174de3524a9a3b7c057a34b085                                               [uk]\n",
              "137  9a097f4bfa3cbb71a7efad65d1c9280955799979               [germany, australia, united kingdom]\n",
              "138  9a58965aaaaad7424a04cebbab0871a9224a9508                                 [china, australia]\n",
              "139  9ad252c633b7596a4b64ca9f1699a0db5ce99c05                                            [china]\n",
              "140  9b0c87f808b1b66f2937d7a7acb524a756b6113b                                                 []\n",
              "141  9b9016e259bd0ad640825ebc12c130bd7e050323                                           [canada]\n",
              "142  9cd6628012c0dcc7ea502d846e138d3bf8170b55                             [united states, china]\n",
              "143  9ce59127771505d6353605873087993ce8cf6e7a                                            [china]\n",
              "144  9fd4c7331c270aa0f93c5037f0b23327e17c0f24                                           [brazil]\n",
              "145  a1104051dbb2b39a6a23d64dfdd49f784ea34676                                [republic of korea]\n",
              "146  a1241365de2d8839b7d02dc30244c15020657329                                            [india]\n",
              "147  a1ddaf941a4c1a0145ce1af098cf1d9da207ed35                                    [united states]\n",
              "148  a3e8cfc509af101c522d4193c8917d6e8f68b37b                                                 []\n",
              "149  a68fdcd0f4e55fda6918c216bc3a5b37ef45289e                            [belgium, germany, usa]\n",
              "150  a79eda4de7857a7fe88b83a1cc494013c23fc048                                    [united states]\n",
              "151  a80c3e9dfde9824cb8f54f9f382d0d601743ffc0  [hong kong sar, hong kong special administrati...\n",
              "152  aa1262ce65755ce44f6a12b1644a065596c7890e                                                 []\n",
              "153  ab1d784d27adf305fd189abf1a074d758a67b14a                                    [united states]\n",
              "154  ab6b98662d778b6aa71751d6a2e3b3c19282f72a                                                 []\n",
              "155  ad357dd76eea58e5a29727e554d3ff431cbade5d                              [united states, iran]\n",
              "156  ad5590a8a445b4c404049f01469b9a5863402734                                                 []\n",
              "157  aee0ceba66759ca3b7c77b16e53069cb2fe8f2b5                                    [united states]\n",
              "158  afd976b623d40fccd44c2d5bc2ad108daef36c7a                                    [hong kong sar]\n",
              "159  afe2138302c85b1f5c5ff6865527d6ead67574ac                                                 []\n",
              "160  b1749aa40bfee7dd0d990fcff4e0e13294706825  [hong kong sar, hong kong-china, hong kong spe...\n",
              "161  b1b8c46ffa22a9a42bae2689db274e0e3d580e59                                    [united states]\n",
              "162  b21be53f027cbee5bfb70762cb7b008d9cdf78f5                                            [india]\n",
              "163  b25b080e6c1f58388f8e7ac229ef51224e081ac4                                           [taiwan]\n",
              "164  b47f37acf862906eeae49368e09f6b397194cdd7                                            [india]\n",
              "165  b5ace18191f3c38909720e5805118250b750e0c8                                                 []\n",
              "166  b5be10942198c0a79dff8aea2253b77ae2401882                                    [turkey, china]\n",
              "167  b62add31f59fb244e0721a204bdec76888be7e16                                            [india]\n",
              "168  ba149723f93f8c294c473351fa73a17e42108b14                                            [china]\n",
              "169  ba8577fbe95f71f3482edea00b9e7579bc360799                                                 []\n",
              "170  ba94dbb19b3a574e0f02dbd34b75c42359a52358    [hong kong special administrative region china]\n",
              "171  baabfb35a321ea12028160e0d2c1552a2fda2dd5                                            [china]\n",
              "172  bcf51d33bc41647bbea9b36ba89ebaae13c4a982                                               [uk]\n",
              "173  bdd38af290f6aa98b23b9278047ca06f232c081a                           [germany, france, spain]\n",
              "174  bdfe90336091a24dd75c44257b4707a4a903d22b                                    [turkey, china]\n",
              "175  c12a11fa9c5fdff0bf85a9f0111c64d6dffe8d26                                                 []\n",
              "176  c12d71462529856463c2432d5628d10a0027c404                                                 []\n",
              "177  c3bf8040e0bb5b6667bf25a4be148aa55b18acf0                                             [iraq]\n",
              "178  c646e655066d0982c151b516ebdf0334d037ffcf                              [egypt, saudi arabia]\n",
              "179  c6ec1380338cb2467dc6fc14add09ca5bea18411                             [china, united states]\n",
              "180  c747c5b5cdebe39ac26640ddfb010724d938d649                                    [united states]\n",
              "181  c954675ee859e2f7b8f352a398a67469b50f05de                                           [turkey]\n",
              "182  ca36180197f0a2bda83c8c743b1cad8d4c90924e                                                 []\n",
              "183  cbf20969da0fdadbb513502aa324d940defc5f15                                                 []\n",
              "184  cd70d9a7adb120c4fcbe4aa8a1bd64a7d8483764                                                 []\n",
              "185  cfeda05ff998d6973560c4f55577a5feaeccb59b                                            [spain]\n",
              "186  d16e1bd4c6cae1bb55dbc695c5e2ba5105a13921                                          [germany]\n",
              "187  d2b1853aae556beaf9e1bc9d802642fffe35cf68                                            [china]\n",
              "188  d33817b56a98cb895588efa155ae076ec74ec139                                    [canada, spain]\n",
              "189  d3744e7581b12fe33a93e21e89b5da988b790b4b                                              [usa]\n",
              "190  d3bf1b40c7c93d6bd6ef2d1769b0e68ed233c18a                                            [italy]\n",
              "191  d4cfb1fc4fc53abbc1d4b0ca60276c6af6632c3c                                    [turkey, china]\n",
              "192  d4f9d334eb5ffbefbef6c90a23f7a243fa89065c                                            [china]\n",
              "193  d6a34d159840a3895ac1768920a1c498d3c448c6            [kingdom of saudi arabia, saudi arabia]\n",
              "194  d9d218af628830db318305235b3b252d85f62dea                                                 []\n",
              "195  db142fe07544dcf0e454f8a9f39452f0aa92a6ca                                           [turkey]\n",
              "196  db9b9f34fb37dfbeef7e0e900e834e982536de56                   [united states, canada, denmark]\n",
              "197  dbefc8ad2a3de5d1696b7e604de8bce1da2ea8cd                              [turkey, south korea]\n",
              "198  dc3656324843f16d93801bac3e78a5fd316ac988                                                 []\n",
              "199  ddc40ffc47069f3714c8da65843f36f41ed0f8bb                             [india, united states]\n",
              "200  dfb0fedbeed56bd2b795a67faab28295afc14c96  [turkey, people's republic of china, china, se...\n",
              "201  e04b5db8306ab29c14bbaa9d1de25e98839ed70c                                                 []\n",
              "202  e08ff7855eaa0c9d0bb785dcffc24e65910b7184                                               [uk]\n",
              "203  e0ec89c24c99c50b1f83ed2d77fe7bd5ef94dc8a                                  [germany, poland]\n",
              "204  e2273d397d1b0c37a010d81be706c2a28af62c9e                                            [italy]\n",
              "205  e3b40cc8e0e137c416b4a2273a4dca94ae8178cc                                            [china]\n",
              "206  e3c87d73a6abced2f827ee3e6daf050663b9b7fb                                              [usa]\n",
              "207  e47779a5dd554c5a35cdb58e5e7fb682ec177f24                                            [china]\n",
              "208  e4b18c2650a0735f7db3a316ff8c560da61931bb                                                 []\n",
              "209  e52ecf4b22e9dcb340ccf67f0251b5a3f9373f02                                                 []\n",
              "210  e5a5a852ae1cdcd98504799f618a8bebbfd7128c                                         [ethiopia]\n",
              "211  e67124fe8f187a99ef873140524fefc50796eccc                                    [united states]\n",
              "212  e6af63ce394cb9c51c04251c99565fd0e6d58c1b                             [china, united states]\n",
              "213  e6d2c030bb4bb71cae43fd29624e70872b1662a4                                                 []\n",
              "214  e6d3acfd725e130a51eab3efafcf05dfb1febbc9          [hong kong special administrative region]\n",
              "215  e7a4159ce5cead74ff87dc1199e3f461631adf96                            [france, canada, italy]\n",
              "216  e847d433e7424152a9846673209cb73027415ecd                                                 []\n",
              "217  e889b19090410704479ea3c7a1596b827f3dbcd0                                           [china.]\n",
              "218  e9895961fa3aee4ebcaa947a2111ec9e64cbbfbf                                     [india, china]\n",
              "219  e9dfbc4084497e74dcaf6bd9c1dbde2b0fb70802                                                 []\n",
              "220  ea646b114ea01f978d205ed97405e1f2afed2dfd                                                 []\n",
              "221  eb5bfeea7bc4bb15dcf2ad3e26dc6478c277fd6e                                          [finland]\n",
              "222  eba1da4b90ee7cff2811391e12e773baa5cd6c2e                                          [germany]\n",
              "223  ebfc471829e1303889bd23779d1c2ffb9467ab7e                                                 []\n",
              "224  ed344fa4250b398132e3066793aadfa9a305cf78                                                 []\n",
              "225  ed99ea6c7af5c77db2bf336d263db55646686098                                                 []\n",
              "226  eff6ce20122149117020cda90ad17f7cff0e9fd4                                    [united states]\n",
              "227  f0a7684b84d874e9d61eee9c4cff37bb45bb2547                                      [south korea]\n",
              "228  f0d2dc18c4737a62d2de12b56d4dba143d21344a                                                 []\n",
              "229  f0dea096a4f73085b277b6977c8c3367b2957a6e                                    [hong kong sar]\n",
              "230  f10fb0ee869f01e39652ca0079888562e865b0ea                   [germany, united states, france]\n",
              "231  f14434d7d3b68f4fe7f68adba747b7700ccdd6ac                             [hong kong sar, china]\n",
              "232  f279037d5e828d9b0b9f6f262c0386925a70f846                                            [china]\n",
              "233  f5cce8a5be5bc7be7a749a51ce8f71add6e5d08f                                                 []\n",
              "234  f6b9fd7dbed6516888eca71004caaa62aa0132d4                                            [china]\n",
              "235  f7f99b10a8f56b2e0e85885a30ef3e3f3258ce7d                                                 []\n",
              "236  f8c15039fad3e71a1479b9d09516aad16fc52f70                                            [china]\n",
              "237  fa0c32f39abb602e0161bf738b5292e251c0c885                            [united states, canada]\n",
              "238  faa2aa0782a6ca9f4072e4918205358347219799                                    [united states]\n",
              "239  faf3ed3d6fc359c1f310e32061e5ed414fee7017                                                 []\n",
              "240  fb0c496af128204a417aa9b18ce6ed674cbbff6e                                                 []\n",
              "241  fbe041fcdd278e6044874daa9f9e071b95b4d2ef                                                 []\n",
              "242  fc766f4da6dcc43946f06f65cde8d79dcb740c11                           [saudi arabia, ethiopia]\n",
              "243  fd28e6d03eef27b0454f13ca539dc1498242a4c2                                    [china, canada]\n",
              "244  fd6af3846d9cfd5b1c9f86b5e16ec803a88cc1f5                                                 []\n",
              "245  ff1cc08ebe7f5a104152662fa87ff683524165c7                                                 []"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 153
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "7BXMT1tB6Ict",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "df_final.to_csv(\"drug_geolocated.csv\")"
      ],
      "execution_count": 0,
      "outputs": []
    }
  ]
}