Search - Query.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Query\n",
    "The most basic search that can be performed is the query.  The query is a free-formed text expression, similar to the type of query you can perform within Google, matching against documents within the specified view."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<refinitiv.dataplatform.core.session.desktop_session.DesktopSession at 0x195688d0>"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import refinitiv.dataplatform as rdp\n",
    "import pandas as pd\n",
    "\n",
    "rdp.open_desktop_session('Your API Key here')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'1.0.0a7.post1'"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.set_option('display.max_colwidth', 140)\n",
    "rdp.__version__"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Query - Default behavior"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>BusinessEntity</th>\n",
       "      <th>RIC</th>\n",
       "      <th>PI</th>\n",
       "      <th>DocumentTitle</th>\n",
       "      <th>PermID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ORGANISATION</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>37036</td>\n",
       "      <td>International Business Machines Corp, Public Company</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "      <td>IBM</td>\n",
       "      <td>1097326</td>\n",
       "      <td>International Business Machines Corp, Ordinary Share, NYSE Consolidated</td>\n",
       "      <td>55839165994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ORGANISATION</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>99244</td>\n",
       "      <td>IBM Credit LLC, Private Company</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ORGS</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>4297694029</td>\n",
       "      <td>IBM Retirement Fund Trust, Private Company</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ORGANISATION</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>18062670</td>\n",
       "      <td>Tiers Corporate Bond Backed Certificates Trust Series Ibm 1997 4, Private Company</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>ORGANISATION</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>27968389</td>\n",
       "      <td>SG Stuttgart Vaihingen BM-Campus 1 UG haftungsbeschraenkt, Private Company</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "      <td>0#IBMF:</td>\n",
       "      <td>48924732</td>\n",
       "      <td>Eurex International Business Machines Equity Future Chain Contract , Equity Future, USD, Eurex</td>\n",
       "      <td>21481052421</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "      <td>0#IBMDF:</td>\n",
       "      <td>259118763</td>\n",
       "      <td>Euronext Amsterdam IBM Dividend Future Chain Contracts, Equity Future, USD, Euronext Amsterdam</td>\n",
       "      <td>21612423771</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "      <td>IBMFc1</td>\n",
       "      <td>49450681</td>\n",
       "      <td>Eurex International Business Machines Equity Future Continuation 1, Equity Future, USD, Eurex</td>\n",
       "      <td>21481052892</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "      <td>IBMFc2</td>\n",
       "      <td>50092347</td>\n",
       "      <td>Eurex International Business Machines Equity Future Continuation 2, Equity Future, USD, Eurex</td>\n",
       "      <td>21481053949</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  BusinessEntity       RIC          PI  \\\n",
       "0   ORGANISATION      <NA>       37036   \n",
       "1   QUOTExEQUITY       IBM     1097326   \n",
       "2   ORGANISATION      <NA>       99244   \n",
       "3           ORGS      <NA>  4297694029   \n",
       "4   ORGANISATION      <NA>    18062670   \n",
       "5   ORGANISATION      <NA>    27968389   \n",
       "6   QUOTExEQUITY   0#IBMF:    48924732   \n",
       "7   QUOTExEQUITY  0#IBMDF:   259118763   \n",
       "8   QUOTExEQUITY    IBMFc1    49450681   \n",
       "9   QUOTExEQUITY    IBMFc2    50092347   \n",
       "\n",
       "                                                                                    DocumentTitle  \\\n",
       "0                                            International Business Machines Corp, Public Company   \n",
       "1                         International Business Machines Corp, Ordinary Share, NYSE Consolidated   \n",
       "2                                                                 IBM Credit LLC, Private Company   \n",
       "3                                                      IBM Retirement Fund Trust, Private Company   \n",
       "4               Tiers Corporate Bond Backed Certificates Trust Series Ibm 1997 4, Private Company   \n",
       "5                      SG Stuttgart Vaihingen BM-Campus 1 UG haftungsbeschraenkt, Private Company   \n",
       "6  Eurex International Business Machines Equity Future Chain Contract , Equity Future, USD, Eurex   \n",
       "7  Euronext Amsterdam IBM Dividend Future Chain Contracts, Equity Future, USD, Euronext Amsterdam   \n",
       "8   Eurex International Business Machines Equity Future Continuation 1, Equity Future, USD, Eurex   \n",
       "9   Eurex International Business Machines Equity Future Continuation 2, Equity Future, USD, Eurex   \n",
       "\n",
       "        PermID  \n",
       "0         <NA>  \n",
       "1  55839165994  \n",
       "2         <NA>  \n",
       "3         <NA>  \n",
       "4         <NA>  \n",
       "5         <NA>  \n",
       "6  21481052421  \n",
       "7  21612423771  \n",
       "8  21481052892  \n",
       "9  21481053949  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# The default syntax for search is to specify a query expression.  By default, search will return a default set of \n",
    "# fields (Properties).\n",
    "rdp.search('IBM')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>BusinessEntity</th>\n",
       "      <th>RIC</th>\n",
       "      <th>PI</th>\n",
       "      <th>DocumentTitle</th>\n",
       "      <th>PermID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ORGANISATION</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>37036</td>\n",
       "      <td>International Business Machines Corp, Public Company</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "      <td>IBM</td>\n",
       "      <td>1097326</td>\n",
       "      <td>International Business Machines Corp, Ordinary Share, NYSE Consolidated</td>\n",
       "      <td>55839165994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ORGANISATION</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>99244</td>\n",
       "      <td>IBM Credit LLC, Private Company</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ORGS</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>4297694029</td>\n",
       "      <td>IBM Retirement Fund Trust, Private Company</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ORGANISATION</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>18062670</td>\n",
       "      <td>Tiers Corporate Bond Backed Certificates Trust Series Ibm 1997 4, Private Company</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>ORGANISATION</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>27968389</td>\n",
       "      <td>SG Stuttgart Vaihingen BM-Campus 1 UG haftungsbeschraenkt, Private Company</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "      <td>0#IBMF:</td>\n",
       "      <td>48924732</td>\n",
       "      <td>Eurex International Business Machines Equity Future Chain Contract , Equity Future, USD, Eurex</td>\n",
       "      <td>21481052421</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "      <td>0#IBMDF:</td>\n",
       "      <td>259118763</td>\n",
       "      <td>Euronext Amsterdam IBM Dividend Future Chain Contracts, Equity Future, USD, Euronext Amsterdam</td>\n",
       "      <td>21612423771</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "      <td>IBMFc1</td>\n",
       "      <td>49450681</td>\n",
       "      <td>Eurex International Business Machines Equity Future Continuation 1, Equity Future, USD, Eurex</td>\n",
       "      <td>21481052892</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "      <td>IBMFc2</td>\n",
       "      <td>50092347</td>\n",
       "      <td>Eurex International Business Machines Equity Future Continuation 2, Equity Future, USD, Eurex</td>\n",
       "      <td>21481053949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "      <td>IBMDFc1</td>\n",
       "      <td>260213021</td>\n",
       "      <td>Euronext Amsterdam IBM Single Stock Dividend Future Continuation 1, Equity Future, USD, Euronext Amsterdam</td>\n",
       "      <td>21613372305</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "      <td>IBMFc3</td>\n",
       "      <td>50092348</td>\n",
       "      <td>Eurex International Business Machines Equity Future Continuation 3, Equity Future, USD, Eurex</td>\n",
       "      <td>21481053950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "      <td>IBMFc4</td>\n",
       "      <td>50092349</td>\n",
       "      <td>Eurex International Business Machines Equity Future Continuation 4, Equity Future, USD, Eurex</td>\n",
       "      <td>21481053951</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "      <td>IBMDFc2</td>\n",
       "      <td>260213022</td>\n",
       "      <td>Euronext Amsterdam IBM Single Stock Dividend Future Continuation 2, Equity Future, USD, Euronext Amsterdam</td>\n",
       "      <td>21613372306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "      <td>IBMFc5</td>\n",
       "      <td>50092350</td>\n",
       "      <td>Eurex International Business Machines Equity Future Continuation 5, Equity Future, USD, Eurex</td>\n",
       "      <td>21481053952</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "      <td>IBMFc6</td>\n",
       "      <td>50092351</td>\n",
       "      <td>Eurex International Business Machines Equity Future Continuation 6, Equity Future, USD, Eurex</td>\n",
       "      <td>21481053953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "      <td>IBMDFc3</td>\n",
       "      <td>260213023</td>\n",
       "      <td>Euronext Amsterdam IBM Single Stock Dividend Future Continuation 3, Equity Future, USD, Euronext Amsterdam</td>\n",
       "      <td>21613372307</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "      <td>IBMFc7</td>\n",
       "      <td>50092352</td>\n",
       "      <td>Eurex International Business Machines Equity Future Continuation 7, Equity Future, USD, Eurex</td>\n",
       "      <td>21481053954</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "      <td>IBMFc8</td>\n",
       "      <td>50092353</td>\n",
       "      <td>Eurex International Business Machines Equity Future Continuation 8, Equity Future, USD, Eurex</td>\n",
       "      <td>21481053955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "      <td>IBMDFc4</td>\n",
       "      <td>260213024</td>\n",
       "      <td>Euronext Amsterdam IBM Single Stock Dividend Future Continuation 4, Equity Future, USD, Euronext Amsterdam</td>\n",
       "      <td>21613372308</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   BusinessEntity       RIC          PI  \\\n",
       "0    ORGANISATION      <NA>       37036   \n",
       "1    QUOTExEQUITY       IBM     1097326   \n",
       "2    ORGANISATION      <NA>       99244   \n",
       "3            ORGS      <NA>  4297694029   \n",
       "4    ORGANISATION      <NA>    18062670   \n",
       "5    ORGANISATION      <NA>    27968389   \n",
       "6    QUOTExEQUITY   0#IBMF:    48924732   \n",
       "7    QUOTExEQUITY  0#IBMDF:   259118763   \n",
       "8    QUOTExEQUITY    IBMFc1    49450681   \n",
       "9    QUOTExEQUITY    IBMFc2    50092347   \n",
       "10   QUOTExEQUITY   IBMDFc1   260213021   \n",
       "11   QUOTExEQUITY    IBMFc3    50092348   \n",
       "12   QUOTExEQUITY    IBMFc4    50092349   \n",
       "13   QUOTExEQUITY   IBMDFc2   260213022   \n",
       "14   QUOTExEQUITY    IBMFc5    50092350   \n",
       "15   QUOTExEQUITY    IBMFc6    50092351   \n",
       "16   QUOTExEQUITY   IBMDFc3   260213023   \n",
       "17   QUOTExEQUITY    IBMFc7    50092352   \n",
       "18   QUOTExEQUITY    IBMFc8    50092353   \n",
       "19   QUOTExEQUITY   IBMDFc4   260213024   \n",
       "\n",
       "                                                                                                 DocumentTitle  \\\n",
       "0                                                         International Business Machines Corp, Public Company   \n",
       "1                                      International Business Machines Corp, Ordinary Share, NYSE Consolidated   \n",
       "2                                                                              IBM Credit LLC, Private Company   \n",
       "3                                                                   IBM Retirement Fund Trust, Private Company   \n",
       "4                            Tiers Corporate Bond Backed Certificates Trust Series Ibm 1997 4, Private Company   \n",
       "5                                   SG Stuttgart Vaihingen BM-Campus 1 UG haftungsbeschraenkt, Private Company   \n",
       "6               Eurex International Business Machines Equity Future Chain Contract , Equity Future, USD, Eurex   \n",
       "7               Euronext Amsterdam IBM Dividend Future Chain Contracts, Equity Future, USD, Euronext Amsterdam   \n",
       "8                Eurex International Business Machines Equity Future Continuation 1, Equity Future, USD, Eurex   \n",
       "9                Eurex International Business Machines Equity Future Continuation 2, Equity Future, USD, Eurex   \n",
       "10  Euronext Amsterdam IBM Single Stock Dividend Future Continuation 1, Equity Future, USD, Euronext Amsterdam   \n",
       "11               Eurex International Business Machines Equity Future Continuation 3, Equity Future, USD, Eurex   \n",
       "12               Eurex International Business Machines Equity Future Continuation 4, Equity Future, USD, Eurex   \n",
       "13  Euronext Amsterdam IBM Single Stock Dividend Future Continuation 2, Equity Future, USD, Euronext Amsterdam   \n",
       "14               Eurex International Business Machines Equity Future Continuation 5, Equity Future, USD, Eurex   \n",
       "15               Eurex International Business Machines Equity Future Continuation 6, Equity Future, USD, Eurex   \n",
       "16  Euronext Amsterdam IBM Single Stock Dividend Future Continuation 3, Equity Future, USD, Euronext Amsterdam   \n",
       "17               Eurex International Business Machines Equity Future Continuation 7, Equity Future, USD, Eurex   \n",
       "18               Eurex International Business Machines Equity Future Continuation 8, Equity Future, USD, Eurex   \n",
       "19  Euronext Amsterdam IBM Single Stock Dividend Future Continuation 4, Equity Future, USD, Euronext Amsterdam   \n",
       "\n",
       "         PermID  \n",
       "0          <NA>  \n",
       "1   55839165994  \n",
       "2          <NA>  \n",
       "3          <NA>  \n",
       "4          <NA>  \n",
       "5          <NA>  \n",
       "6   21481052421  \n",
       "7   21612423771  \n",
       "8   21481052892  \n",
       "9   21481053949  \n",
       "10  21613372305  \n",
       "11  21481053950  \n",
       "12  21481053951  \n",
       "13  21613372306  \n",
       "14  21481053952  \n",
       "15  21481053953  \n",
       "16  21613372307  \n",
       "17  21481053954  \n",
       "18  21481053955  \n",
       "19  21613372308  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# By default, 10 documents will be returned.  Let's override that.\n",
    "rdp.search(\n",
    "    query = 'IBM',\n",
    "    top = 20\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Query Expressions\n",
    "If we were to type in the following expression, we might come away believing the query will list all personnel within IBM that have a title\n",
    "of CEO.  While, the results will indicate people related to IBM and people with a title of CEO, we cannot assume they are both.  That is, \n",
    "we will see results with the term IBM and CEO listed in the document."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>BusinessEntity</th>\n",
       "      <th>PI</th>\n",
       "      <th>DocumentTitle</th>\n",
       "      <th>PermID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>PERSON</td>\n",
       "      <td>34417810693</td>\n",
       "      <td>Arvind Krishna - International Business Machines Corp - Chief Executive Officer, Director</td>\n",
       "      <td>34417810693</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>PERSON</td>\n",
       "      <td>34413248256</td>\n",
       "      <td>Rudy S. Karsan - Kenexa Corp - Chairman of the Board, Chief Executive Officer</td>\n",
       "      <td>34413248256</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>PERSON</td>\n",
       "      <td>34415058863</td>\n",
       "      <td>Mohammed Farooq - Gravitant Inc - Chairman of the Board, Chief Executive Officer, Co-Founder</td>\n",
       "      <td>34415058863</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>PERSON</td>\n",
       "      <td>34414057544</td>\n",
       "      <td>Deidre Paknad - Pss Systems Inc - President, CEO, Board Member</td>\n",
       "      <td>34414057544</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>PERSON</td>\n",
       "      <td>34414091235</td>\n",
       "      <td>Ron S Dembo - Algorithmics Inc - President &amp; CEO</td>\n",
       "      <td>34414091235</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>PERSON</td>\n",
       "      <td>34414058841</td>\n",
       "      <td>Frank Chisholm - Aptsoft Corp - CEO &amp; Founder</td>\n",
       "      <td>34414058841</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>PERSON</td>\n",
       "      <td>34414139687</td>\n",
       "      <td>Michael Knagenhjelm - Metamerge As(Ibm Corp) - Chief Executive Officer</td>\n",
       "      <td>34414139687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>PERSON</td>\n",
       "      <td>34414399995</td>\n",
       "      <td>Bruce Miller - Tarian Software(Ibm) - Chief Executive Officer</td>\n",
       "      <td>34414399995</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  BusinessEntity           PI  \\\n",
       "0         PERSON  34417810693   \n",
       "1         PERSON  34413248256   \n",
       "2         PERSON  34415058863   \n",
       "3         PERSON  34414057544   \n",
       "4         PERSON  34414091235   \n",
       "5         PERSON  34414058841   \n",
       "6         PERSON  34414139687   \n",
       "7         PERSON  34414399995   \n",
       "\n",
       "                                                                                  DocumentTitle  \\\n",
       "0     Arvind Krishna - International Business Machines Corp - Chief Executive Officer, Director   \n",
       "1                 Rudy S. Karsan - Kenexa Corp - Chairman of the Board, Chief Executive Officer   \n",
       "2  Mohammed Farooq - Gravitant Inc - Chairman of the Board, Chief Executive Officer, Co-Founder   \n",
       "3                                Deidre Paknad - Pss Systems Inc - President, CEO, Board Member   \n",
       "4                                              Ron S Dembo - Algorithmics Inc - President & CEO   \n",
       "5                                                 Frank Chisholm - Aptsoft Corp - CEO & Founder   \n",
       "6                        Michael Knagenhjelm - Metamerge As(Ibm Corp) - Chief Executive Officer   \n",
       "7                                 Bruce Miller - Tarian Software(Ibm) - Chief Executive Officer   \n",
       "\n",
       "        PermID  \n",
       "0  34417810693  \n",
       "1  34413248256  \n",
       "2  34415058863  \n",
       "3  34414057544  \n",
       "4  34414091235  \n",
       "5  34414058841  \n",
       "6  34414139687  \n",
       "7  34414399995  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Match all documents where the term IBM and CEO appear in any order\n",
    "rdp.search('IBM CEO')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "What might give a more favorable result would be to query all documents related to people that contain the term '*IBM*'. From the result, I can visually see\n",
    "titles and optionally filter out people that are not CEO's.  I can do this by selecting the '**People**' view.\n",
    "In addition, I'm going to choose specific *child* elements of the **DocumentTitle** field.  As we see in our output from the above requests, the \n",
    "'**DocumentTitle**' is selected by default.  This property is a convenient collection of elements that nicely describes the document returned and is\n",
    "made up of multiple sub-properties such as: '**DTSubjectName**', '**DTSimpleType**', '**DTSource**', and '**DTCharacteristics**'. \n",
    "\n",
    "By doing this, I can now see a nice\n",
    "break-down of the titles (DTCharacteristics), name (DTSubjectName) and company (DTSimpleType)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>DTSimpleType</th>\n",
       "      <th>DTCharacteristics</th>\n",
       "      <th>DocumentTitle</th>\n",
       "      <th>DTSubjectName</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>International Business Machines Corp</td>\n",
       "      <td>Executive Chairman of the Board</td>\n",
       "      <td>Ginni M. Rometty - International Business Machines Corp - Executive Chairman of the Board</td>\n",
       "      <td>Ginni M. Rometty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>International Business Machines Corp</td>\n",
       "      <td>President</td>\n",
       "      <td>Jim M. Whitehurst - International Business Machines Corp - President</td>\n",
       "      <td>Jim M. Whitehurst</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>International Business Machines Corp</td>\n",
       "      <td>Chief Executive Officer, Director</td>\n",
       "      <td>Arvind Krishna - International Business Machines Corp - Chief Executive Officer, Director</td>\n",
       "      <td>Arvind Krishna</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>International Business Machines Corp</td>\n",
       "      <td>Senior Vice President, Chief Financial Officer, Finance and operation</td>\n",
       "      <td>James J. Kavanaugh - International Business Machines Corp - Senior Vice President, Chief Financial Officer, Finance and operation</td>\n",
       "      <td>James J. Kavanaugh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>International Business Machines Corp</td>\n",
       "      <td>Chief Human Resource Officer, Senior Vice President</td>\n",
       "      <td>Diane J. Gherson - International Business Machines Corp - Chief Human Resource Officer, Senior Vice President</td>\n",
       "      <td>Diane J. Gherson</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>International Business Machines Corp</td>\n",
       "      <td>Executive Vice President</td>\n",
       "      <td>John E. Kelly - International Business Machines Corp - Executive Vice President</td>\n",
       "      <td>John E. Kelly</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>International Business Machines Corp</td>\n",
       "      <td>Senior Vice President - Corporate Strategy</td>\n",
       "      <td>Kenneth M. Keverian - International Business Machines Corp - Senior Vice President - Corporate Strategy</td>\n",
       "      <td>Kenneth M. Keverian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>International Business Machines Corp</td>\n",
       "      <td>Senior Vice President - Legal and Regulatory Affairs and General Counsel</td>\n",
       "      <td>Michelle H. Browdy - International Business Machines Corp - Senior Vice President - Legal and Regulatory Affairs and General Counsel</td>\n",
       "      <td>Michelle H. Browdy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>International Business Machines Corp</td>\n",
       "      <td>Vice President, Controller</td>\n",
       "      <td>Robert F. Del Bene - International Business Machines Corp - Vice President, Controller</td>\n",
       "      <td>Robert F. Del Bene</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>International Business Machines Corp</td>\n",
       "      <td>Lead Independent Director</td>\n",
       "      <td>Mike L. Eskew - International Business Machines Corp - Lead Independent Director</td>\n",
       "      <td>Mike L. Eskew</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           DTSimpleType  \\\n",
       "0  International Business Machines Corp   \n",
       "1  International Business Machines Corp   \n",
       "2  International Business Machines Corp   \n",
       "3  International Business Machines Corp   \n",
       "4  International Business Machines Corp   \n",
       "5  International Business Machines Corp   \n",
       "6  International Business Machines Corp   \n",
       "7  International Business Machines Corp   \n",
       "8  International Business Machines Corp   \n",
       "9  International Business Machines Corp   \n",
       "\n",
       "                                                          DTCharacteristics  \\\n",
       "0                                           Executive Chairman of the Board   \n",
       "1                                                                 President   \n",
       "2                                         Chief Executive Officer, Director   \n",
       "3     Senior Vice President, Chief Financial Officer, Finance and operation   \n",
       "4                       Chief Human Resource Officer, Senior Vice President   \n",
       "5                                                  Executive Vice President   \n",
       "6                                Senior Vice President - Corporate Strategy   \n",
       "7  Senior Vice President - Legal and Regulatory Affairs and General Counsel   \n",
       "8                                                Vice President, Controller   \n",
       "9                                                 Lead Independent Director   \n",
       "\n",
       "                                                                                                                          DocumentTitle  \\\n",
       "0                                             Ginni M. Rometty - International Business Machines Corp - Executive Chairman of the Board   \n",
       "1                                                                  Jim M. Whitehurst - International Business Machines Corp - President   \n",
       "2                                             Arvind Krishna - International Business Machines Corp - Chief Executive Officer, Director   \n",
       "3     James J. Kavanaugh - International Business Machines Corp - Senior Vice President, Chief Financial Officer, Finance and operation   \n",
       "4                         Diane J. Gherson - International Business Machines Corp - Chief Human Resource Officer, Senior Vice President   \n",
       "5                                                       John E. Kelly - International Business Machines Corp - Executive Vice President   \n",
       "6                               Kenneth M. Keverian - International Business Machines Corp - Senior Vice President - Corporate Strategy   \n",
       "7  Michelle H. Browdy - International Business Machines Corp - Senior Vice President - Legal and Regulatory Affairs and General Counsel   \n",
       "8                                                Robert F. Del Bene - International Business Machines Corp - Vice President, Controller   \n",
       "9                                                      Mike L. Eskew - International Business Machines Corp - Lead Independent Director   \n",
       "\n",
       "         DTSubjectName  \n",
       "0     Ginni M. Rometty  \n",
       "1    Jim M. Whitehurst  \n",
       "2       Arvind Krishna  \n",
       "3   James J. Kavanaugh  \n",
       "4     Diane J. Gherson  \n",
       "5        John E. Kelly  \n",
       "6  Kenneth M. Keverian  \n",
       "7   Michelle H. Browdy  \n",
       "8   Robert F. Del Bene  \n",
       "9        Mike L. Eskew  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rdp.search(\n",
    "    view = rdp.SearchViews.People,\n",
    "    query = 'IBM',\n",
    "    select = 'DocumentTitle, DTSubjectName, DTSimpleType, DTSource, DTCharacteristics'\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>BusinessEntity</th>\n",
       "      <th>RIC</th>\n",
       "      <th>PI</th>\n",
       "      <th>DocumentTitle</th>\n",
       "      <th>PermID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>INSTRUMENTxFIXEDINCOMExGOVCORP</td>\n",
       "      <td>046353AQ1=</td>\n",
       "      <td>0x00102cb50fde0d55</td>\n",
       "      <td>AstraZeneca PLC, Plain Vanilla Fixed Coupon Bond, TRACE Eligible AZN 2.375 12-Jun-2022</td>\n",
       "      <td>46645702869</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>QUOTExFIXEDINCOMExGOVCORP</td>\n",
       "      <td>046353AQ1=2M</td>\n",
       "      <td>0x00102c9a7ade0d0f</td>\n",
       "      <td>AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, MARKETAXESS L2</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>QUOTExFIXEDINCOMExGOVCORP</td>\n",
       "      <td>US046353AQ14=CSTW</td>\n",
       "      <td>0x00102cbda5b71586</td>\n",
       "      <td>AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, CREDIT SUISSE TRADEWEB PRICE</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>QUOTExFIXEDINCOMExGOVCORP</td>\n",
       "      <td>US046353AQ14=MKCP</td>\n",
       "      <td>0x00102ce0bcbf19c6</td>\n",
       "      <td>AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, MARKETAXESS COMPOSITE PLUS</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>QUOTExFIXEDINCOMExGOVCORP</td>\n",
       "      <td>US046353AQ14=TDTW</td>\n",
       "      <td>0x00102c435ce30dcd</td>\n",
       "      <td>AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, TDS TRADEWEB PRICE</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>QUOTExFIXEDINCOMExGOVCORP</td>\n",
       "      <td>US046353AQ14=TE</td>\n",
       "      <td>0x00102c4f5ce30dc1</td>\n",
       "      <td>AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, TRADEWEB</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>QUOTExFIXEDINCOMExGOVCORP</td>\n",
       "      <td>046353AQ1=TWEB</td>\n",
       "      <td>0x00102c1968121c43</td>\n",
       "      <td>AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, TRADEWEB</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>QUOTExFIXEDINCOMExGOVCORP</td>\n",
       "      <td>US046353AQ14=GFGL</td>\n",
       "      <td>0x00102cadc88d0eda</td>\n",
       "      <td>AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, GFI GROUP</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>QUOTExFIXEDINCOMExGOVCORP</td>\n",
       "      <td>US046353AQ14=MKAX</td>\n",
       "      <td>0x00102cc599441a3e</td>\n",
       "      <td>AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, MARKETAXESS AXESSALL</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>QUOTExFIXEDINCOMExGOVCORP</td>\n",
       "      <td>US046353AQ14=TEMK</td>\n",
       "      <td>0x00102c60801b1bdc</td>\n",
       "      <td>AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, TWEB EUCR MARKS</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   BusinessEntity                RIC                  PI  \\\n",
       "0  INSTRUMENTxFIXEDINCOMExGOVCORP         046353AQ1=  0x00102cb50fde0d55   \n",
       "1       QUOTExFIXEDINCOMExGOVCORP       046353AQ1=2M  0x00102c9a7ade0d0f   \n",
       "2       QUOTExFIXEDINCOMExGOVCORP  US046353AQ14=CSTW  0x00102cbda5b71586   \n",
       "3       QUOTExFIXEDINCOMExGOVCORP  US046353AQ14=MKCP  0x00102ce0bcbf19c6   \n",
       "4       QUOTExFIXEDINCOMExGOVCORP  US046353AQ14=TDTW  0x00102c435ce30dcd   \n",
       "5       QUOTExFIXEDINCOMExGOVCORP    US046353AQ14=TE  0x00102c4f5ce30dc1   \n",
       "6       QUOTExFIXEDINCOMExGOVCORP     046353AQ1=TWEB  0x00102c1968121c43   \n",
       "7       QUOTExFIXEDINCOMExGOVCORP  US046353AQ14=GFGL  0x00102cadc88d0eda   \n",
       "8       QUOTExFIXEDINCOMExGOVCORP  US046353AQ14=MKAX  0x00102cc599441a3e   \n",
       "9       QUOTExFIXEDINCOMExGOVCORP  US046353AQ14=TEMK  0x00102c60801b1bdc   \n",
       "\n",
       "                                                                                     DocumentTitle  \\\n",
       "0           AstraZeneca PLC, Plain Vanilla Fixed Coupon Bond, TRACE Eligible AZN 2.375 12-Jun-2022   \n",
       "1                AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, MARKETAXESS L2   \n",
       "2  AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, CREDIT SUISSE TRADEWEB PRICE   \n",
       "3    AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, MARKETAXESS COMPOSITE PLUS   \n",
       "4            AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, TDS TRADEWEB PRICE   \n",
       "5                      AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, TRADEWEB   \n",
       "6                      AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, TRADEWEB   \n",
       "7                     AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, GFI GROUP   \n",
       "8          AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, MARKETAXESS AXESSALL   \n",
       "9               AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, TWEB EUCR MARKS   \n",
       "\n",
       "        PermID  \n",
       "0  46645702869  \n",
       "1         <NA>  \n",
       "2         <NA>  \n",
       "3         <NA>  \n",
       "4         <NA>  \n",
       "5         <NA>  \n",
       "6         <NA>  \n",
       "7         <NA>  \n",
       "8         <NA>  \n",
       "9         <NA>  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Search for a specific ISIN using query\n",
    "rdp.search('US046353AQ14')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>BusinessEntity</th>\n",
       "      <th>RIC</th>\n",
       "      <th>PI</th>\n",
       "      <th>DocumentTitle</th>\n",
       "      <th>PermID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>INSTRUMENTxFIXEDINCOMExGOVCORP</td>\n",
       "      <td>046353AQ1=</td>\n",
       "      <td>0x00102cb50fde0d55</td>\n",
       "      <td>AstraZeneca PLC, Plain Vanilla Fixed Coupon Bond, TRACE Eligible AZN 2.375 12-Jun-2022</td>\n",
       "      <td>46645702869</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   BusinessEntity         RIC                  PI  \\\n",
       "0  INSTRUMENTxFIXEDINCOMExGOVCORP  046353AQ1=  0x00102cb50fde0d55   \n",
       "\n",
       "                                                                            DocumentTitle  \\\n",
       "0  AstraZeneca PLC, Plain Vanilla Fixed Coupon Bond, TRACE Eligible AZN 2.375 12-Jun-2022   \n",
       "\n",
       "        PermID  \n",
       "0  46645702869  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Narrow the search to only instruments\n",
    "rdp.search(\n",
    "    view = rdp.SearchViews.Instruments,\n",
    "    query = 'US046353AQ14'\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Query Syntax\n",
    "A query phrase can support some basic syntax including wildcards, boolean expressions and exact phrase matching."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Matched a total of 15 documents\n"
     ]
    },
    {
     "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>BusinessEntity</th>\n",
       "      <th>RIC</th>\n",
       "      <th>PI</th>\n",
       "      <th>DocumentTitle</th>\n",
       "      <th>PermID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>QUOTExCOMMODITY</td>\n",
       "      <td>.BACG</td>\n",
       "      <td>621981</td>\n",
       "      <td>BALTIC DIRTY TANKER TD9 70,000mt, Caribbean to US Gulf, Commodity Index, The Baltic Exchange</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>QUOTExCOMMODITY</td>\n",
       "      <td>.BACR</td>\n",
       "      <td>175653765</td>\n",
       "      <td>Baltic Exchange Dirty Tanker TD21 Caribbean to US Gulf (50,000mt fuel oil), Commodity Spot, The Baltic Exchange</td>\n",
       "      <td>21717867959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>QUOTExCOMMODITY</td>\n",
       "      <td>.BAAFRTD9</td>\n",
       "      <td>48950908</td>\n",
       "      <td>Baltic Exchange Dirty Tanker TD9 TCE�Caribbean to US Gulf Time Charter, Commodity Spot, The Baltic Exchange</td>\n",
       "      <td>21717782063</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>QUOTExCOMMODITY</td>\n",
       "      <td>.BAAFRTD21</td>\n",
       "      <td>325658314</td>\n",
       "      <td>Baltic Exchange Dirty Tanker TD21 TCE Caribbean to US Gulf (50,000mt fuel oil) Time Charter, Commodity Spot, The Baltic Exchange</td>\n",
       "      <td>21717782060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>PHYSICALASSETxVESSEL</td>\n",
       "      <td>C}KM7309531000</td>\n",
       "      <td>77309531000</td>\n",
       "      <td>ARDMORE ENDURANCE, Gasoline; Medium, ARDMORE SHIPPING BERMUDA LTD, North Sea|North Sea Tanker Zone|Scotland (South Shetland Ils.) Waypoint</td>\n",
       "      <td>77309531000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>PHYSICALASSETxVESSEL</td>\n",
       "      <td>C}KM7309878895</td>\n",
       "      <td>77309878895</td>\n",
       "      <td>LARGO CALIFORNIA, Medium, CENTRAL SHIPPING MONACO SAM, Gulf of Finland|Baltic Tanker Zone|Estonia</td>\n",
       "      <td>77309878895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>PHYSICALASSETxVESSEL</td>\n",
       "      <td>C}KM7309495550</td>\n",
       "      <td>77309495550</td>\n",
       "      <td>CARONI PLAIN, Medium, METHANOL HOLDINGS, North Atlantic Ocean</td>\n",
       "      <td>77309495550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>PHYSICALASSETxVESSEL</td>\n",
       "      <td>C}KN7309511101</td>\n",
       "      <td>77309511101</td>\n",
       "      <td>BALTIC PROSPERITY, Small, LAVINIA CORP, Caribbean Sea|Caribbean Tanker Zone</td>\n",
       "      <td>77309511101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>PHYSICALASSETxVESSEL</td>\n",
       "      <td>C}KC7309434563</td>\n",
       "      <td>77309434563</td>\n",
       "      <td>VASSILIO XVIII, Coastal, SANAHIL IO, West Atlantic Ocean (Americas)|Belem Tanker Zone</td>\n",
       "      <td>77309434563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>PHYSICALASSETxVESSEL</td>\n",
       "      <td>C}KA7309466817</td>\n",
       "      <td>77309466817</td>\n",
       "      <td>BALTIC, Aframax / LRII, ALPHA SHIPMANAGEMENT PTE LTD, South Pacific Ocean (NZ)|Melbourne Tanker Zone|Bass Strait Waypoint</td>\n",
       "      <td>77309466817</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         BusinessEntity             RIC           PI  \\\n",
       "0       QUOTExCOMMODITY           .BACG       621981   \n",
       "1       QUOTExCOMMODITY           .BACR    175653765   \n",
       "2       QUOTExCOMMODITY       .BAAFRTD9     48950908   \n",
       "3       QUOTExCOMMODITY      .BAAFRTD21    325658314   \n",
       "4  PHYSICALASSETxVESSEL  C}KM7309531000  77309531000   \n",
       "5  PHYSICALASSETxVESSEL  C}KM7309878895  77309878895   \n",
       "6  PHYSICALASSETxVESSEL  C}KM7309495550  77309495550   \n",
       "7  PHYSICALASSETxVESSEL  C}KN7309511101  77309511101   \n",
       "8  PHYSICALASSETxVESSEL  C}KC7309434563  77309434563   \n",
       "9  PHYSICALASSETxVESSEL  C}KA7309466817  77309466817   \n",
       "\n",
       "                                                                                                                                DocumentTitle  \\\n",
       "0                                                BALTIC DIRTY TANKER TD9 70,000mt, Caribbean to US Gulf, Commodity Index, The Baltic Exchange   \n",
       "1                             Baltic Exchange Dirty Tanker TD21 Caribbean to US Gulf (50,000mt fuel oil), Commodity Spot, The Baltic Exchange   \n",
       "2                                 Baltic Exchange Dirty Tanker TD9 TCE�Caribbean to US Gulf Time Charter, Commodity Spot, The Baltic Exchange   \n",
       "3            Baltic Exchange Dirty Tanker TD21 TCE Caribbean to US Gulf (50,000mt fuel oil) Time Charter, Commodity Spot, The Baltic Exchange   \n",
       "4  ARDMORE ENDURANCE, Gasoline; Medium, ARDMORE SHIPPING BERMUDA LTD, North Sea|North Sea Tanker Zone|Scotland (South Shetland Ils.) Waypoint   \n",
       "5                                           LARGO CALIFORNIA, Medium, CENTRAL SHIPPING MONACO SAM, Gulf of Finland|Baltic Tanker Zone|Estonia   \n",
       "6                                                                               CARONI PLAIN, Medium, METHANOL HOLDINGS, North Atlantic Ocean   \n",
       "7                                                                 BALTIC PROSPERITY, Small, LAVINIA CORP, Caribbean Sea|Caribbean Tanker Zone   \n",
       "8                                                       VASSILIO XVIII, Coastal, SANAHIL IO, West Atlantic Ocean (Americas)|Belem Tanker Zone   \n",
       "9                   BALTIC, Aframax / LRII, ALPHA SHIPMANAGEMENT PTE LTD, South Pacific Ocean (NZ)|Melbourne Tanker Zone|Bass Strait Waypoint   \n",
       "\n",
       "        PermID  \n",
       "0         <NA>  \n",
       "1  21717867959  \n",
       "2  21717782063  \n",
       "3  21717782060  \n",
       "4  77309531000  \n",
       "5  77309878895  \n",
       "6  77309495550  \n",
       "7  77309511101  \n",
       "8  77309434563  \n",
       "9  77309466817  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Use a specifc term in quotes and the boolean operator to locate specific tankers - use the Content layer \n",
    "# to print additional details.\n",
    "response = rdp.Search.search(\"'Caribbean Tanker' and Baltic\")\n",
    "print(f'Matched a total of {response.data.total} documents')\n",
    "response.data.df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Matched a total of 7106 documents\n"
     ]
    },
    {
     "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>DTSimpleType</th>\n",
       "      <th>DTCharacteristics</th>\n",
       "      <th>DTSubjectName</th>\n",
       "      <th>DTSource</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Public Company</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>Covidh Technologies Ltd</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Private Company</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>Covidien Ventures</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Reuters Polls</td>\n",
       "      <td>Daily</td>\n",
       "      <td>Coronavirus (COVID-19), Total cases, Volume</td>\n",
       "      <td>Reuters</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Reuters Polls</td>\n",
       "      <td>Daily</td>\n",
       "      <td>Coronavirus (COVID-19), Total cases, Volume</td>\n",
       "      <td>Reuters</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Reuters Polls</td>\n",
       "      <td>Daily</td>\n",
       "      <td>Coronavirus (COVID-19), Total cases, Volume</td>\n",
       "      <td>Reuters</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Reuters Polls</td>\n",
       "      <td>Daily</td>\n",
       "      <td>Coronavirus (COVID-19), Total cases, Volume</td>\n",
       "      <td>Reuters</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Reuters Polls</td>\n",
       "      <td>Daily</td>\n",
       "      <td>Middle East and North Africa, Coronavirus (COVID-19), Total cases, Volume</td>\n",
       "      <td>Reuters</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Reuters Polls</td>\n",
       "      <td>Daily</td>\n",
       "      <td>Coronavirus (COVID-19), Total cases, Volume</td>\n",
       "      <td>Reuters</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Reuters Polls</td>\n",
       "      <td>Daily</td>\n",
       "      <td>Coronavirus (COVID-19), New cases, Volume</td>\n",
       "      <td>Reuters</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Reuters Polls</td>\n",
       "      <td>Daily</td>\n",
       "      <td>Coronavirus (COVID-19), Active cases, Volume</td>\n",
       "      <td>Reuters</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      DTSimpleType DTCharacteristics  \\\n",
       "0   Public Company              <NA>   \n",
       "1  Private Company              <NA>   \n",
       "2    Reuters Polls             Daily   \n",
       "3    Reuters Polls             Daily   \n",
       "4    Reuters Polls             Daily   \n",
       "5    Reuters Polls             Daily   \n",
       "6    Reuters Polls             Daily   \n",
       "7    Reuters Polls             Daily   \n",
       "8    Reuters Polls             Daily   \n",
       "9    Reuters Polls             Daily   \n",
       "\n",
       "                                                               DTSubjectName  \\\n",
       "0                                                    Covidh Technologies Ltd   \n",
       "1                                                          Covidien Ventures   \n",
       "2                                Coronavirus (COVID-19), Total cases, Volume   \n",
       "3                                Coronavirus (COVID-19), Total cases, Volume   \n",
       "4                                Coronavirus (COVID-19), Total cases, Volume   \n",
       "5                                Coronavirus (COVID-19), Total cases, Volume   \n",
       "6  Middle East and North Africa, Coronavirus (COVID-19), Total cases, Volume   \n",
       "7                                Coronavirus (COVID-19), Total cases, Volume   \n",
       "8                                  Coronavirus (COVID-19), New cases, Volume   \n",
       "9                               Coronavirus (COVID-19), Active cases, Volume   \n",
       "\n",
       "  DTSource  \n",
       "0     <NA>  \n",
       "1     <NA>  \n",
       "2  Reuters  \n",
       "3  Reuters  \n",
       "4  Reuters  \n",
       "5  Reuters  \n",
       "6  Reuters  \n",
       "7  Reuters  \n",
       "8  Reuters  \n",
       "9  Reuters  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Use a wildcard (*) to search for references to 'Covid*'.\n",
    "response = rdp.Search.search(\n",
    "    query = \"Covid*\",\n",
    "    select = \"DTSubjectName, DTSimpleType, DTSource, DTCharacteristics\"\n",
    ")\n",
    "print(f'Matched a total of {response.data.total} documents')\n",
    "response.data.df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CouponTypeDescription</th>\n",
       "      <th>IssuerLegalName</th>\n",
       "      <th>CouponCurrency</th>\n",
       "      <th>CouponRate</th>\n",
       "      <th>MaturityDate</th>\n",
       "      <th>ISIN</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Fixed:Plain Vanilla Fixed Coupon</td>\n",
       "      <td>Vodafone Hessen GmbH &amp; Co. KG</td>\n",
       "      <td>USD</td>\n",
       "      <td>5</td>\n",
       "      <td>2025-01-15T00:00:00.000Z</td>\n",
       "      <td>USD85455AD13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Fixed:Plain Vanilla Fixed Coupon</td>\n",
       "      <td>Vodafone Hessen GmbH &amp; Co. KG</td>\n",
       "      <td>USD</td>\n",
       "      <td>5</td>\n",
       "      <td>2025-01-15T00:00:00.000Z</td>\n",
       "      <td>US913364AD74</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              CouponTypeDescription                IssuerLegalName  \\\n",
       "0  Fixed:Plain Vanilla Fixed Coupon  Vodafone Hessen GmbH & Co. KG   \n",
       "1  Fixed:Plain Vanilla Fixed Coupon  Vodafone Hessen GmbH & Co. KG   \n",
       "\n",
       "  CouponCurrency  CouponRate              MaturityDate          ISIN  \n",
       "0            USD           5  2025-01-15T00:00:00.000Z  USD85455AD13  \n",
       "1            USD           5  2025-01-15T00:00:00.000Z  US913364AD74  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# List the Vodafone bonds maturing in 2025 with a coupon rate of 5%\n",
    "# We can achieve this specific query using a special feature called 'tcm' (ticker coupon maturity).\n",
    "rdp.search(\n",
    "    query = \"vod 5% 2025\",\n",
    "    features = \"tcm\",\n",
    "    select = \"CouponCurrency, CouponTypeDescription, IssuerLegalName, CouponRate, MaturityDate, ISIN\"\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}