Search - Properties & Metadata.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Properties / Metadata\n",
    "The document properties represent the fields that define the data elements you want to retrieve as well as the elements you choose to filter your results.  In addition, properties are at the heart of other Search parameters such as Navigation, Grouping, and Boosting.  There are hundreds of properties available for each View providing critical details needed to fulfill your searching requirements.\n",
    "\n",
    "In order for you to be successful at search, you will need to understand how to access the available properties, how to determine what values they contain and what they mean.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<refinitiv.dataplatform.core.session.desktop_session.DesktopSession at 0x509c6d8>"
      ]
     },
     "execution_count": 1,
     "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": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'1.0.0a7.post1'"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.set_option('display.max_colwidth', 140)\n",
    "rdp.__version__"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Optionally override maximum dataframe rows\n",
    "#pd.set_option('display.max_rows', 10000)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Help on class SearchViews in module refinitiv.dataplatform.content.search.SearchViews:\n",
      "\n",
      "class SearchViews(enum.Enum)\n",
      " |  SearchViews(value, names=None, *, module=None, qualname=None, type=None, start=1)\n",
      " |  \n",
      " |  define all possible views\n",
      " |  \n",
      " |  Method resolution order:\n",
      " |      SearchViews\n",
      " |      enum.Enum\n",
      " |      builtins.object\n",
      " |  \n",
      " |  Data and other attributes defined here:\n",
      " |  \n",
      " |  BondFutOptQuotes = <SearchViews.BondFutOptQuotes: 'BondFutOptQuotes'>\n",
      " |  \n",
      " |  CdsInstruments = <SearchViews.CdsInstruments: 'CdsInstruments'>\n",
      " |  \n",
      " |  CdsQuotes = <SearchViews.CdsQuotes: 'CdsQuotes'>\n",
      " |  \n",
      " |  CmoInstruments = <SearchViews.CmoInstruments: 'CmoInstruments'>\n",
      " |  \n",
      " |  CmoQuotes = <SearchViews.CmoQuotes: 'CmoQuotes'>\n",
      " |  \n",
      " |  CommodityQuotes = <SearchViews.CommodityQuotes: 'CommodityQuotes'>\n",
      " |  \n",
      " |  DealsMergersAndAcquisitions = <SearchViews.DealsMergersAndAcquisitions...\n",
      " |  \n",
      " |  DerivativeInstruments = <SearchViews.DerivativeInstruments: 'Derivativ...\n",
      " |  \n",
      " |  DerivativeQuotes = <SearchViews.DerivativeQuotes: 'DerivativeQuotes'>\n",
      " |  \n",
      " |  EquityDerivativeInstruments = <SearchViews.EquityDerivativeInstruments...\n",
      " |  \n",
      " |  EquityDerivativeQuotes = <SearchViews.EquityDerivativeQuotes: 'EquityD...\n",
      " |  \n",
      " |  EquityInstruments = <SearchViews.EquityInstruments: 'EquityInstruments...\n",
      " |  \n",
      " |  EquityQuotes = <SearchViews.EquityQuotes: 'EquityQuotes'>\n",
      " |  \n",
      " |  FixedIncomeInstruments = <SearchViews.FixedIncomeInstruments: 'FixedIn...\n",
      " |  \n",
      " |  FixedIncomeQuotes = <SearchViews.FixedIncomeQuotes: 'FixedIncomeQuotes...\n",
      " |  \n",
      " |  FundQuotes = <SearchViews.FundQuotes: 'FundQuotes'>\n",
      " |  \n",
      " |  GovCorpInstruments = <SearchViews.GovCorpInstruments: 'GovCorpInstrume...\n",
      " |  \n",
      " |  GovCorpQuotes = <SearchViews.GovCorpQuotes: 'GovCorpQuotes'>\n",
      " |  \n",
      " |  IRDQuotes = <SearchViews.IRDQuotes: 'IRDQuotes'>\n",
      " |  \n",
      " |  IndexInstruments = <SearchViews.IndexInstruments: 'IndexInstruments'>\n",
      " |  \n",
      " |  IndexQuotes = <SearchViews.IndexQuotes: 'IndexQuotes'>\n",
      " |  \n",
      " |  IndicatorQuotes = <SearchViews.IndicatorQuotes: 'IndicatorQuotes'>\n",
      " |  \n",
      " |  Instruments = <SearchViews.Instruments: 'Instruments'>\n",
      " |  \n",
      " |  LoanInstruments = <SearchViews.LoanInstruments: 'LoanInstruments'>\n",
      " |  \n",
      " |  LoanQuotes = <SearchViews.LoanQuotes: 'LoanQuotes'>\n",
      " |  \n",
      " |  MoneyQuotes = <SearchViews.MoneyQuotes: 'MoneyQuotes'>\n",
      " |  \n",
      " |  MortQuotes = <SearchViews.MortQuotes: 'MortQuotes'>\n",
      " |  \n",
      " |  MortgageInstruments = <SearchViews.MortgageInstruments: 'MortgageInstr...\n",
      " |  \n",
      " |  MunicipalInstruments = <SearchViews.MunicipalInstruments: 'MunicipalIn...\n",
      " |  \n",
      " |  MunicipalQuotes = <SearchViews.MunicipalQuotes: 'MunicipalQuotes'>\n",
      " |  \n",
      " |  Organisations = <SearchViews.Organisations: 'Organisations'>\n",
      " |  \n",
      " |  People = <SearchViews.People: 'People'>\n",
      " |  \n",
      " |  PhysicalAssets = <SearchViews.PhysicalAssets: 'PhysicalAssets'>\n",
      " |  \n",
      " |  Quotes = <SearchViews.Quotes: 'Quotes'>\n",
      " |  \n",
      " |  QuotesAndSTIRs = <SearchViews.QuotesAndSTIRs: 'QuotesAndSTIRs'>\n",
      " |  \n",
      " |  STIRs = <SearchViews.STIRs: 'STIRs'>\n",
      " |  \n",
      " |  SearchAll = <SearchViews.SearchAll: 'SearchAll'>\n",
      " |  \n",
      " |  VesselPhysicalAssets = <SearchViews.VesselPhysicalAssets: 'VesselPhysi...\n",
      " |  \n",
      " |  YieldCurveContQuotes = <SearchViews.YieldCurveContQuotes: 'YieldCurveC...\n",
      " |  \n",
      " |  ----------------------------------------------------------------------\n",
      " |  Data descriptors inherited from enum.Enum:\n",
      " |  \n",
      " |  name\n",
      " |      The name of the Enum member.\n",
      " |  \n",
      " |  value\n",
      " |      The value of the Enum member.\n",
      " |  \n",
      " |  ----------------------------------------------------------------------\n",
      " |  Data descriptors inherited from enum.EnumMeta:\n",
      " |  \n",
      " |  __members__\n",
      " |      Returns a mapping of member name->value.\n",
      " |      \n",
      " |      This mapping lists all enum members, including aliases. Note that this\n",
      " |      is a read-only view of the internal mapping.\n",
      "\n"
     ]
    }
   ],
   "source": [
    "help(rdp.SearchViews)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Metadata\n",
    "MetaData is a convenient service that allows you to list all available properties within a View.  To properly build a metadata list for inspection, you can issue the following:"
   ]
  },
  {
   "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>Type</th>\n",
       "      <th>Searchable</th>\n",
       "      <th>Sortable</th>\n",
       "      <th>Navigable</th>\n",
       "      <th>Groupable</th>\n",
       "      <th>Exact</th>\n",
       "      <th>Symbol</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>AAACurrencyBondBenchmarkChain</th>\n",
       "      <td>String</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AACurrencyBondBenchmarkChain</th>\n",
       "      <td>String</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ABSMBSBondsRIC</th>\n",
       "      <td>String</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ActivityDate</th>\n",
       "      <td>Date</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ACurrencyBondBenchmarkChain</th>\n",
       "      <td>String</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WarrantsCount</th>\n",
       "      <td>Double</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WarrantType</th>\n",
       "      <td>String</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WarrantTypeName</th>\n",
       "      <td>String</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wert</th>\n",
       "      <td>String</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>XMSAssetCategory</th>\n",
       "      <td>String</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>609 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 Type  Searchable  Sortable  Navigable  \\\n",
       "AAACurrencyBondBenchmarkChain  String       False     False      False   \n",
       "AACurrencyBondBenchmarkChain   String       False     False      False   \n",
       "ABSMBSBondsRIC                 String       False     False      False   \n",
       "ActivityDate                     Date        True      True       True   \n",
       "ACurrencyBondBenchmarkChain    String       False     False      False   \n",
       "...                               ...         ...       ...        ...   \n",
       "WarrantsCount                  Double        True      True       True   \n",
       "WarrantType                    String        True     False      False   \n",
       "WarrantTypeName                String        True     False      False   \n",
       "Wert                           String        True     False      False   \n",
       "XMSAssetCategory               String        True     False      False   \n",
       "\n",
       "                               Groupable  Exact  Symbol  \n",
       "AAACurrencyBondBenchmarkChain      False  False   False  \n",
       "AACurrencyBondBenchmarkChain       False  False   False  \n",
       "ABSMBSBondsRIC                     False  False   False  \n",
       "ActivityDate                       False  False   False  \n",
       "ACurrencyBondBenchmarkChain        False  False   False  \n",
       "...                                  ...    ...     ...  \n",
       "WarrantsCount                      False  False   False  \n",
       "WarrantType                        False  False   False  \n",
       "WarrantTypeName                    False  False   False  \n",
       "Wert                               False  False    True  \n",
       "XMSAssetCategory                   False  False   False  \n",
       "\n",
       "[609 rows x 7 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Specify the view\n",
    "df = rdp.get_search_metadata(view = rdp.SearchViews.CommodityQuotes)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Export metadata to a spreadsheet for easy viewing\n",
    "df.to_excel(\"CommodityQuotes.xlsx\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Debugging (*_debugall*)\n",
    "While MetaData will help list all properties available within a View, all properties will not be available for use.  That is, depending on the type of search you perform, will determine which properties will be populated - not all will be.  This is where users can use a technique to list all available properties that are populated, for the specific search requested."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "jupyter": {
     "outputs_hidden": true
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Total': 40503,\n",
       " 'Hits': [{'meta': {'_id': '37036',\n",
       "    '_index': 'eikonsearch_organisation_1.132.0',\n",
       "    '_score': 2838764.0,\n",
       "    '_timestamp': 1609533547151,\n",
       "    '_timestamp_human': '2021-01-01T20:39:07.151Z',\n",
       "    '_version': 1609531573000},\n",
       "   'raw_source': {'RCSOrganisationTypeGenealogy': 'OT:1',\n",
       "    'SPsRatingOutlookX1XSPsRatingOutlookRank': 'SPI/NegativeX1X-1|SPI/NegativeX1X-1',\n",
       "    'RCSTRBCGenealogy': 'B:161\\\\B:171\\\\B:172\\\\B:173',\n",
       "    'IssuerID': '0x000019000050e3aa',\n",
       "    'SicSchemeCode': '8742',\n",
       "    'OfficersExist': True,\n",
       "    'IssuerBondsExist': True,\n",
       "    'CertificatesOfDepositCount': 0,\n",
       "    'MktCapCompanyUsd': 112166269762,\n",
       "    'TotalAssetsUsd': 152186000000,\n",
       "    'GEMPermID': '4295904307',\n",
       "    'SubjectBoost': 'firm',\n",
       "    'EEDBID': '14129',\n",
       "    'SigDevExist': True,\n",
       "    'SDCID': '3104001',\n",
       "    'TotalAssets': 152186000000,\n",
       "    'EstimatesExist': True,\n",
       "    'Ticker': 'IBM',\n",
       "    'CdsUltimateParentCount': 7,\n",
       "    'FilingsExist': True,\n",
       "    'CompanyOfficers': 'Senior Vice President:Erich Clementi |Senior Vice President:Diane J. Gherson |Senior Vice President:Martin J. Schroeter |Senior Vice President:John E. Kelly |Senior Vice President:Michelle H. Browdy |Chief Financial Officer:James J. Kavanaugh |Senior Vice President:Kenneth M. Keverian |Vice President:Robert F. Del Bene |Chairman:Virginia M. Rometty',\n",
       "    'CompositeSearchAllZh': '公司',\n",
       "    'CommonNameJaHani': 'インターナショナル･ビジネス･マシーンズ･コーポレーション',\n",
       "    'RatingOutlookRank': 'MDL/0|MDL/0|MRS/0',\n",
       "    'CurrentRatio': 1.019071,\n",
       "    'UltimateParentOrganisationOrgid': '18228',\n",
       "    'PreviousNames': 'COMPUTING-TABULATING-RECORDING-CO.|1911-06-16|1924-02-14',\n",
       "    'TRBCHierarchicalCode': '5720101010',\n",
       "    'NetProfit': 9431000000,\n",
       "    'PrimaryIssuePILC': '144477',\n",
       "    'IsExchange': False,\n",
       "    'RCSOriginalAccountsCurrencyLeafML': 'ja 米ドル|zh-Hans 美元|zh-Hant 美元',\n",
       "    'DTSubjectNameJaHani': 'インターナショナル･ビジネス･マシーンズ･コーポレーション',\n",
       "    'RCSOriginalAccountsCurrencyLeaf': 'US Dollar',\n",
       "    'SPsRatingScopeRank': 'SIS/1|SSU/1|SIS/2|SSU/2|SPI/2|SMU/1|SCP/2|SPI/1|SMU/2',\n",
       "    'CompositeSearchAllJa': '事業法人',\n",
       "    'IsMainCompanyFiling': True,\n",
       "    'RatingsScope': [{'Agency': 'FTC',\n",
       "      'RatingType': 'FDL',\n",
       "      'CurrentRatingRank': 98,\n",
       "      'CurrentRatingDate': '2019-07-01T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'F'},\n",
       "     {'Agency': 'EGJ',\n",
       "      'RatingType': 'EJC',\n",
       "      'CurrentRatingRank': 2,\n",
       "      'CurrentRatingDate': '2018-11-02T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'D'},\n",
       "     {'Agency': 'MDY',\n",
       "      'RatingType': 'MCP',\n",
       "      'CurrentRatingRank': 1,\n",
       "      'CurrentRatingDate': '2016-03-30T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'D'},\n",
       "     {'Agency': 'MDY',\n",
       "      'RatingType': 'MDL',\n",
       "      'CurrentRatingRank': 7,\n",
       "      'CurrentRatingDate': '2019-07-09T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'OutlookRank': 0,\n",
       "      'RatingScope': 'F',\n",
       "      'Outlook': 'Stable'},\n",
       "     {'Agency': 'MDY',\n",
       "      'RatingType': 'MIS',\n",
       "      'CurrentRatingRank': 7,\n",
       "      'CurrentRatingDate': '2019-07-09T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'D'},\n",
       "     {'Agency': 'EGJ',\n",
       "      'RatingType': 'EJC',\n",
       "      'CurrentRatingRank': 2,\n",
       "      'CurrentRatingDate': '2019-01-30T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'F'},\n",
       "     {'Agency': 'MDY',\n",
       "      'RatingType': 'MIS',\n",
       "      'CurrentRatingRank': 7,\n",
       "      'CurrentRatingDate': '2019-07-09T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'F'},\n",
       "     {'Agency': 'FTC',\n",
       "      'RatingType': 'FCP',\n",
       "      'CurrentRatingRank': 98,\n",
       "      'CurrentRatingDate': '2019-07-01T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'F'},\n",
       "     {'Agency': 'MDY',\n",
       "      'RatingType': 'MDL',\n",
       "      'CurrentRatingRank': 7,\n",
       "      'CurrentRatingDate': '2019-07-09T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'OutlookRank': 0,\n",
       "      'RatingScope': 'D',\n",
       "      'Outlook': 'Stable'},\n",
       "     {'Agency': 'MDY',\n",
       "      'RatingType': 'MSU',\n",
       "      'CurrentRatingRank': 7,\n",
       "      'CurrentRatingDate': '2019-07-09T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'F'},\n",
       "     {'Agency': 'FTC',\n",
       "      'RatingType': 'FSS',\n",
       "      'CurrentRatingRank': 98,\n",
       "      'CurrentRatingDate': '2007-05-30T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'F'},\n",
       "     {'Agency': 'FTC',\n",
       "      'RatingType': 'FSU',\n",
       "      'CurrentRatingRank': 7,\n",
       "      'CurrentRatingDate': '2018-10-30T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'y',\n",
       "      'RatingScope': 'F'},\n",
       "     {'Agency': 'MDY',\n",
       "      'RatingType': 'MSU',\n",
       "      'CurrentRatingRank': 7,\n",
       "      'CurrentRatingDate': '2019-07-09T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'D'},\n",
       "     {'Agency': 'MDY',\n",
       "      'RatingType': 'MCP',\n",
       "      'CurrentRatingRank': 1,\n",
       "      'CurrentRatingDate': '1994-10-19T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'F'},\n",
       "     {'Agency': 'FTC',\n",
       "      'RatingType': 'FMU',\n",
       "      'CurrentRatingRank': 98,\n",
       "      'CurrentRatingDate': '2015-07-15T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'D'},\n",
       "     {'Agency': 'FTC',\n",
       "      'RatingType': 'FDT',\n",
       "      'CurrentRatingRank': 2,\n",
       "      'CurrentRatingDate': '2018-10-30T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'y',\n",
       "      'RatingScope': 'D'},\n",
       "     {'Agency': 'MDY',\n",
       "      'RatingType': 'MMU',\n",
       "      'CurrentRatingRank': 98,\n",
       "      'CurrentRatingDate': '2016-11-18T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'F'},\n",
       "     {'Agency': 'FTC',\n",
       "      'RatingType': 'FSU',\n",
       "      'CurrentRatingRank': 98,\n",
       "      'CurrentRatingDate': '2019-07-01T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'D'},\n",
       "     {'Agency': 'MDY',\n",
       "      'RatingType': 'MRS',\n",
       "      'CurrentRatingRank': 1,\n",
       "      'CurrentRatingDate': '2019-07-09T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'OutlookRank': 0,\n",
       "      'RatingScope': 'F',\n",
       "      'Outlook': 'Stable'},\n",
       "     {'Agency': 'EGJ',\n",
       "      'RatingType': 'EJU',\n",
       "      'CurrentRatingRank': 8,\n",
       "      'CurrentRatingDate': '2020-04-29T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'F'},\n",
       "     {'Agency': 'EGJ',\n",
       "      'RatingType': 'EJU',\n",
       "      'CurrentRatingRank': 8,\n",
       "      'CurrentRatingDate': '2020-04-29T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'D'},\n",
       "     {'Agency': 'FTC',\n",
       "      'RatingType': 'FDS',\n",
       "      'CurrentRatingRank': 98,\n",
       "      'CurrentRatingDate': '2019-07-01T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'F'},\n",
       "     {'Agency': 'FTC',\n",
       "      'RatingType': 'FIS',\n",
       "      'CurrentRatingRank': 98,\n",
       "      'CurrentRatingDate': '2005-10-05T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'F'},\n",
       "     {'Agency': 'MDY',\n",
       "      'RatingType': 'MMU',\n",
       "      'CurrentRatingRank': 98,\n",
       "      'CurrentRatingDate': '2016-11-18T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'D'},\n",
       "     {'Agency': 'FTC',\n",
       "      'RatingType': 'FCP',\n",
       "      'CurrentRatingRank': 2,\n",
       "      'CurrentRatingDate': '2007-05-30T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'y',\n",
       "      'RatingScope': 'D'}],\n",
       "    'RatingType': 'Issuer/FTC/FDL|Issuer/EGJ/EJC|Issuer/MDY/MCP|Issuer/MDY/MDL|Issuer/MDY/MIS|Issuer/EGJ/EJC|Issuer/MDY/MIS|Issuer/FTC/FCP|Issuer/MDY/MDL|Issuer/MDY/MSU|Issuer/FTC/FSS|Issuer/FTC/FSU|Issuer/MDY/MSU|Issuer/MDY/MCP|Issuer/FTC/FMU|Issuer/FTC/FDT|Issuer/MDY/MMU|Issuer/FTC/FSU|Issuer/MDY/MRS|Issuer/EGJ/EJU|Issuer/EGJ/EJU|Issuer/FTC/FDS|Issuer/FTC/FIS|Issuer/MDY/MMU|Issuer/FTC/FCP',\n",
       "    'SPsRatingNameX1XSPsRatingType': \"Issuer/Standard & Poor's Bond Rating ServicesX1XS&P/S&P Short-term Issuer Credit RatingX1XSIS|Issuer/Standard & Poor's Bond Rating ServicesX1XS&P/S&P Senior UnsecuredX1XSSU|Issuer/Standard & Poor's Bond Rating ServicesX1XS&P/S&P Short-term Issuer Credit RatingX1XSIS|Issuer/Standard & Poor's Bond Rating ServicesX1XS&P/S&P Senior UnsecuredX1XSSU|Issuer/Standard & Poor's Bond Rating ServicesX1XS&P/S&P Long-term Issuer RatingX1XSPI|Issuer/Standard & Poor's Bond Rating ServicesX1XS&P/S&P Long-term Senior Unsecured MTN RatingX1XSMU|Issuer/Standard & Poor's Bond Rating ServicesX1XS&P/S&P Commercial PaperX1XSCP|Issuer/Standard & Poor's Bond Rating ServicesX1XS&P/S&P Long-term Issuer RatingX1XSPI|Issuer/Standard & Poor's Bond Rating ServicesX1XS&P/S&P Long-term Senior Unsecured MTN RatingX1XSMU\",\n",
       "    'AddressLine1': '1 New Orchard Rd',\n",
       "    'RCSCountryHeadquarters': 'G:6J',\n",
       "    'ParentCompanyNDAPI': '37036',\n",
       "    'GicsName': 'Information Technology|Information Technology/Software & Services|Information Technology/Software & Services/IT Services|Information Technology/Software & Services/IT Services/IT Consulting & Other Services',\n",
       "    'InvestmentCertificateCount': 0,\n",
       "    'SuggestPhrase': 'internatnl intl intrnl internatnl intl intrnl | it services & consulting (nec) organisation corporation listed |big blue|guo ji shang ye ji qi gong si|guo ji shang yong ji qi|ibm|intanashonaru bijinesu mashinzu|international business machines|software artistry inc|unison software inc|international business machines corp|international business machines corporation|never',\n",
       "    'OAOrgSubTypeName': 'Company',\n",
       "    'ListingStatusName': 'Listed',\n",
       "    'RCSCountryHeadquartersLeafML': 'ja 米国|zh-Hans 美国|zh-Hant 美國|es Estados Unidos|fr États Unis|ko 미국|ru США',\n",
       "    'RCSTRBCName': 'Technology\\\\Software & IT Services\\\\Software & IT Services\\\\IT Services & Consulting',\n",
       "    'RCSOrganisationTypeNameML': 'ja 事業法人|zh-Hans 公司|zh-Hant 公司',\n",
       "    'LongTermDebt': 54102000000,\n",
       "    'RCSTRBC2012NameML': 'ja テクノロジー\\\\ソフトウェア & IT サービス\\\\ソフトウェア & IT サービス\\\\IT サービス & コンサルティング\\\\IT サービス & コンサルティング (その他)|zh-Hans 技术\\\\软件及信息技术服务\\\\软件及信息技术服务\\\\信息技术服务及咨询\\\\IT 服务及咨询 (NEC)|zh-Hant 技術\\\\軟體及信息技術服務\\\\軟體及信息技術服務\\\\信息技術服務及諮詢\\\\IT 服務及諮詢 (NEC)',\n",
       "    'SPsRatingX1XSPsRatingScopeRank': 'SIS/DX1X1|SSU/DX1X1|SIS/FX1X2|SSU/FX1X2|SPI/FX1X2|SMU/DX1X1|SCP/FX1X2|SPI/DX1X1|SMU/FX1X2',\n",
       "    'Ev': 166341269762,\n",
       "    'PrimaryRICRCSAssetCategory': 'A:1L',\n",
       "    'RCSFilingCurrencyName': 'US Dollar',\n",
       "    'UltimateParentOrganisationName': 'International Business Machines Corp',\n",
       "    'BusinessDescription': 'International Business Machines Corporation (IBM) is a technology company. The Company operates through five segments: Cognitive Solutions, Global Business Services (GBS), Technology Services & Cloud Platforms, Systems and Global Financing. The Cognitive Solutions segment delivers a spectrum of capabilities, from descriptive, predictive and prescriptive analytics to cognitive systems. Cognitive Solutions includes Watson, a cognitive computing platform that has the ability to interact in natural language, process big data, and learn from interactions with people and computers. The GBS segment provides clients with consulting, application management services and global process services. The Technology Services & Cloud Platforms segment provides information technology infrastructure services. The Systems segment provides clients with infrastructure technologies. The Global Financing segment includes client financing, commercial financing, and remanufacturing and remarketing.',\n",
       "    'RCSCountryOfIncorporationGenealogy': 'M:DQ\\\\G:AM\\\\G:6J|M:DQ\\\\G:AN\\\\G:6J|M:DH\\\\G:4\\\\G:9\\\\G:6J|M:DQ\\\\G:AQ\\\\G:6J|M:DQ\\\\G:AR\\\\G:6J|M:DQ\\\\G:AS\\\\G:6J|M:A9\\\\G:6J|M:DQ\\\\G:B9\\\\G:6J|M:1M2\\\\G:3U8\\\\G:3U9\\\\G:6J|M:DQ\\\\G:CX\\\\G:6J|M:DQ\\\\G:DE\\\\G:6J',\n",
       "    'TRBCPrimaryCode': '173',\n",
       "    'CommonNameJaKana': 'インターナショナルビジネスマシーンズコーポレーション',\n",
       "    'RatingScopeRank': 'FDL/2|EJC/1|MCP/1|MDL/2|MIS/1|EJC/2|MIS/2|FCP/2|MDL/1|MSU/2|FSS/2|FSU/2|MSU/1|MCP/2|FMU/1|FDT/1|MMU/2|FSU/1|MRS/2|EJU/2|EJU/1|FDS/2|FIS/2|MMU/1|FCP/1',\n",
       "    'LegalNameJaHani': 'インターナショナル･ビジネス･マシーンズ･コーポレーション',\n",
       "    'OpMargin': 13.896846,\n",
       "    'SearchAllCategory': 'Companies/Issuers',\n",
       "    'RCSOriginalAccountsCurrency': 'C:6',\n",
       "    'RCSTRBC2012': 'B:1790',\n",
       "    'SicScheme': 'Engineering and management services/Management and Public Relations/Management Consulting Services',\n",
       "    'SearchTypeBase': 1,\n",
       "    'RatingX1XRatingScopeRank': 'FDL/FX1X2|EJC/DX1X1|MCP/DX1X1|MDL/FX1X2|MIS/DX1X1|EJC/FX1X2|MIS/FX1X2|FCP/FX1X2|MDL/DX1X1|MSU/FX1X2|FSS/FX1X2|FSU/FX1X2|MSU/DX1X1|MCP/FX1X2|FMU/DX1X1|FDT/DX1X1|MMU/FX1X2|FSU/DX1X1|MRS/FX1X2|EJU/FX1X2|EJU/DX1X1|FDS/FX1X2|FIS/FX1X2|MMU/DX1X1|FCP/DX1X1',\n",
       "    'InterestCover': 7.434813,\n",
       "    'CommonName': 'International Business Machines Corp',\n",
       "    'OAOrgTypeName': 'Business Organization',\n",
       "    'NAVPrimaryRIC': '<a:Rship name=\"x\" xmlns:a=\"http://www.reuters.com/ns/2007/10/31/webservices/SearchAndNavigation_1/NavCommonResponse_1\"><a:Entity><a:Prop name=\"RIC\" value=\"IBM\"/><a:Req value=\"62\" scheme=\"IDN\"/><a:Req value=\"4017\" scheme=\"IDN\"/></a:Entity></a:Rship>',\n",
       "    'MainFilingType': 'CONSOLIDATED',\n",
       "    'OrganizationWebsite': 'https://www.ibm.com/',\n",
       "    'EquityInstrumentsCount': 4,\n",
       "    'UltimateParentCompanyOAPermID': '4295904307',\n",
       "    'SPsRatingPreliminary': 'SIS/n|SSU/n|SIS/n|SSU/n|SPI/n|SMU/n|SCP/n|SPI/n|SMU/n',\n",
       "    'PrimaryRICCUSIP': '459200101',\n",
       "    'DTSubjectNameJaKana': 'インターナショナルビジネスマシーンズコーポレーション',\n",
       "    'RCSFilingCountryLeaf': 'United States',\n",
       "    'MainFilingCommonName': 'International Business Machines Corp.',\n",
       "    'DocumentsExist': True,\n",
       "    'RCSTRBCLeaf': 'IT Services & Consulting',\n",
       "    'ShortTermDebt': 8797000000,\n",
       "    'TRBC2012PrimaryCode': '1790',\n",
       "    'ParentCompanyOAPermID': '4295904307',\n",
       "    'AddressCity': 'ARMONK',\n",
       "    'SalesToWorkingCap': 13.257776,\n",
       "    'IndicesCount': 0,\n",
       "    'RbssSchemeCode': '1790',\n",
       "    'Filename': 'Update_CL3_US2P_G1.4_Organisation_0033361_20210101_200613_A_incr_wi_002390.xml.xz',\n",
       "    'PretaxProfitUsd': 10166000000,\n",
       "    'MainRepnoAttributes': '<a:Rship name=\"x\" xmlns:a=\"http://www.reuters.com/ns/2007/10/31/webservices/SearchAndNavigation_1/NavCommonResponse_1\"><a:Entity><a:Prop name=\"ActiveEstimatesExist\" value=\"Y\"/><a:Prop name=\"BusinessIntelligenceExists\" value=\"Y\"/><a:Prop name=\"FundamentalsExist\" value=\"Y\"/><a:Prop name=\"EstimatesExist\" value=\"Y\"/><a:Prop name=\"SigDevExist\" value=\"Y\"/><a:Prop name=\"OfficersExist\" value=\"Y\"/><a:Prop name=\"Repno\" value=\"4741N\"/><a:Prop name=\"CommonName\" value=\"International Business Machines Corp.\"/><a:Prop name=\"Type\" value=\"CONSOLIDATED\"/><a:Prop name=\"IsMainIssueFiling\" value=\"Y\"/><a:Prop name=\"IsMainCompanyFiling\" value=\"Y\"/><a:Prop name=\"RCSCurrencyName\" value=\"US Dollar\"/><a:Prop name=\"RCSCountryLeaf\" value=\"United States\"/></a:Entity></a:Rship>',\n",
       "    'RevenueUsd': 77147000000,\n",
       "    'IsPublic': True,\n",
       "    'OwnershipExists': True,\n",
       "    'OAPermID': '4295904307',\n",
       "    'Ebit': 10721000000,\n",
       "    'DebtToEquity': 6.295331,\n",
       "    'CompanyDataStreamID': '003671',\n",
       "    'IsTRACEEligible': True,\n",
       "    'InsertDateTime': '2020-11-23T13:32:26.000Z',\n",
       "    'SynonymDescriptiveName': 'internatnl INTL intrnl internatnl INTL intrnl',\n",
       "    'CDS5YSuperRIC': '<a:Rship name=\"x\" xmlns:a=\"http://www.reuters.com/ns/2007/10/31/webservices/SearchAndNavigation_1/NavCommonResponse_1\"><a:Entity rank=\"1\"><a:Prop name=\"RIC\" value=\"IBM5YUSAX=\"/><a:Prop name=\"DisplayName\" value=\"IBM\" lang=\"en\"/><a:Req value=\"6995\" scheme=\"IDN\"/></a:Entity></a:Rship>',\n",
       "    'RCSFilingCountryNameML': 'ja 国際機関\\\\\\\\米国|zh-Hans 国家分组\\\\\\\\美国|zh-Hant 國家分組\\\\\\\\美國|es \\\\\\\\Estados Unidos|fr \\\\\\\\États Unis|ko \\\\\\\\미국|ru \\\\\\\\США|ja 国際機関\\\\\\\\米国|zh-Hans 国家分组\\\\北大西洋公约组织\\\\美国|zh-Hant 國家分組\\\\北大西洋公約組織\\\\美國|es \\\\\\\\Estados Unidos|fr \\\\\\\\États Unis|ko \\\\\\\\미국|ru \\\\\\\\США|es Continentes/regiones\\\\Continente Americano\\\\Norteamérica\\\\Estados Unidos|fr Continents/Régions\\\\Amérique\\\\Amérique du Nord\\\\États Unis|ja 大陸 / 地域\\\\北米 & 中南米\\\\北米\\\\米国|ru Континенты/регионы\\\\Америка\\\\Северная Америка\\\\США|zh-Hans 大陆/地区\\\\美洲\\\\北美\\\\美国|zh-Hant 大陸/地區\\\\美洲\\\\北美\\\\美國|ko \\\\미주\\\\북아메리카\\\\미국|ja 国際機関\\\\\\\\米国|zh-Hans 国家分组\\\\亚太经济合作组织\\\\美国|zh-Hant 國家分組\\\\亞太經濟合作組織\\\\美國|es \\\\\\\\Estados Unidos|fr \\\\\\\\États Unis|ko \\\\\\\\미국|ru \\\\\\\\США|ja 国際機関\\\\\\\\米国|zh-Hans 国家分组\\\\经济合作与发展组织\\\\美国|zh-Hant 國家分組\\\\經濟合作與發展組織\\\\美國|es \\\\\\\\Estados Unidos|fr \\\\\\\\États Unis|ko \\\\\\\\미국|ru \\\\\\\\США|ja 国際機関\\\\\\\\米国|zh-Hans 国家分组\\\\\\\\美国|zh-Hant 國家分組\\\\\\\\美國|es \\\\\\\\Estados Unidos|fr \\\\\\\\États Unis|ko \\\\\\\\미국|ru \\\\\\\\США|ja 国\\\\米国|zh-Hans 国家/地区\\\\美国|zh-Hant 國家/地區\\\\美國|es \\\\Estados Unidos|fr \\\\États Unis|ko \\\\미국|ru \\\\США|ja 国際機関\\\\\\\\米国|zh-Hans 国家分组\\\\\\\\美国|zh-Hant 國家分組\\\\\\\\美國|es \\\\\\\\Estados Unidos|fr \\\\\\\\États Unis|ko \\\\\\\\미국|ru \\\\\\\\США|ja FRUC 地域\\\\グローバル\\\\北米\\\\米国|zh-Hans FRUC 区域\\\\全球\\\\北美\\\\美国|zh-Hant FRUC 區域\\\\全球\\\\北美\\\\美國|es \\\\\\\\\\\\Estados Unidos|fr \\\\\\\\\\\\États Unis|ko \\\\\\\\\\\\미국|ru \\\\\\\\\\\\США|ja 国際機関\\\\\\\\米国|zh-Hans 国家分组\\\\G10 集团\\\\美国|zh-Hant 國家分組\\\\G10 集團\\\\美國|es \\\\\\\\Estados Unidos|fr \\\\\\\\États Unis|ko \\\\\\\\미국|ru \\\\\\\\США|ja 国際機関\\\\北アフリカ (EIU)\\\\米国|zh-Hans 国家分组\\\\北美 (EIU)\\\\美国|zh-Hant 國家分組\\\\北美 (EIU)\\\\美國|es \\\\\\\\Estados Unidos|fr \\\\\\\\États Unis|ko \\\\\\\\미국|ru \\\\\\\\США',\n",
       "    'MnaParentTargetCount': 0,\n",
       "    'SectorIndices': '<a:Rship name=\"x\" xmlns:a=\"http://www.reuters.com/ns/2007/10/31/webservices/SearchAndNavigation_1/NavCommonResponse_1\"><a:Entity rank=\"1\"><a:Prop name=\"DisplayName\" value=\"DOW JONES TECHNOLOGY NDX\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".DJUSTC\"/><a:Req value=\"9822\" scheme=\"IDN\"/><a:Req value=\"4017\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"2\"><a:Prop name=\"DisplayName\" value=\"S&amp;P 500 IT Consulting&amp;Other Serv(SI)\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".SPLRCTKCS\"/><a:Req value=\"5185\" scheme=\"IDN\"/><a:Req value=\"5775\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"3\"><a:Prop name=\"DisplayName\" value=\"S&amp;P 500 IT Services (Industry)\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".SPLRCITCS\"/><a:Req value=\"5185\" scheme=\"IDN\"/><a:Req value=\"5775\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"4\"><a:Prop name=\"DisplayName\" value=\"S&amp;P 500 Software &amp; Services (IG)\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".SPLRCIS\"/><a:Req value=\"5185\" scheme=\"IDN\"/><a:Req value=\"5775\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"5\"><a:Prop name=\"DisplayName\" value=\"标普信息技术指数\" lang=\"zh-Hans\"/><a:Prop name=\"RIC\" value=\".SPLRCT\"/><a:Req value=\"5185\" scheme=\"IDN\"/><a:Req value=\"5775\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"6\"><a:Prop name=\"DisplayName\" value=\"S&amp;P 500種 情報技術セクター指数\" lang=\"ja-Hani\"/><a:Prop name=\"RIC\" value=\".SPLRCT\"/><a:Req value=\"5185\" scheme=\"IDN\"/><a:Req value=\"5775\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"7\"><a:Prop name=\"DisplayName\" value=\"S&amp;P 500 Information Tech(Sector)\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".SPLRCT\"/><a:Req value=\"5185\" scheme=\"IDN\"/><a:Req value=\"5775\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"8\"><a:Prop name=\"DisplayName\" value=\"S&amp;P Composite 1500 Software&amp;Serv(IG)\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".SPCOMIS\"/><a:Req value=\"5185\" scheme=\"IDN\"/><a:Req value=\"5775\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"9\"><a:Prop name=\"DisplayName\" value=\"S&amp;P 1500 IT Services (Ind)\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".SPCOMITCS\"/><a:Req value=\"5185\" scheme=\"IDN\"/><a:Req value=\"5775\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"10\"><a:Prop name=\"DisplayName\" value=\"S&amp;P 1500 Info Technology (Sector)\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".SPCOMT\"/><a:Req value=\"5185\" scheme=\"IDN\"/><a:Req value=\"5775\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"11\"><a:Prop name=\"DisplayName\" value=\"S&amp;P 1500 ITConsulting&amp;Other Serv(SI)\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".SPCOMTKCS\"/><a:Req value=\"5185\" scheme=\"IDN\"/><a:Req value=\"5775\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"12\"><a:Prop name=\"DisplayName\" value=\"ARCA COMPUT TECH\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".XCI\"/><a:Req value=\"6465\" scheme=\"IDN\"/><a:Req value=\"5053\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"13\"><a:Prop name=\"DisplayName\" value=\"Refinitiv United States Technology Price Return Index\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".TRXFLDUSPTEC\"/><a:Req value=\"7642\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"14\"><a:Prop name=\"DisplayName\" value=\"Refinitiv North America Technology Price Return Index\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".TRXFLDNAPUTEC\"/><a:Req value=\"7642\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"15\"><a:Prop name=\"DisplayName\" value=\"Refinitiv NAFTA Technology Price Return Index\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".TRXFLDNFPUTEC\"/><a:Req value=\"7642\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"16\"><a:Prop name=\"DisplayName\" value=\"Refinitiv G7 Technology Price Return Index\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".TRXFLDG7PUTEC\"/><a:Req value=\"3112\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"17\"><a:Prop name=\"DisplayName\" value=\"Refinitiv Global Technology Price Return Index\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".TRXFLDGLPUTEC\"/><a:Req value=\"3112\" scheme=\"IDN\"/></a:Entity></a:Rship>',\n",
       "    'OpProfitInterim': 1845000000,\n",
       "    'Source': 'NDA',\n",
       "    'DisclosureIDs': 'I510600000',\n",
       "    'RCSFilingCountry': 'G:6J',\n",
       "    'GeneralAliasNameZhHans': '国际商业机器公司|国际商用机器',\n",
       "    'RCSTRBCNameML': 'ja テクノロジー\\\\ソフトウェア & IT サービス\\\\ソフトウェア & IT サービス\\\\IT サービス & コンサルティング|zh-Hans 技术\\\\软件及信息技术服务\\\\软件及信息技术服务\\\\信息技术服务及咨询|zh-Hant 技術\\\\軟體及信息技術服務\\\\軟體及信息技術服務\\\\信息技術服務及諮詢',\n",
       "    'SPsRatingX1XSPsRatingRankForeign': 'SIS/A-1X1X2|SSU/AX1X11|SPI/AX1X6|SCP/A-1X1X2|SMU/NRX1X0',\n",
       "    'CalaisAlias': \"International Business Machines Corporation|IBM Corporation|INTL Business Machines Corp|International Business machines|IBM Corp.|International Business Machines|International Business Machines (IBM)|Intl Business Machines Corp|International Business Machines Corp|INTL|International Business|Software, Inc.|Business Machines Corp|International Business Machines Corp.|Unison|IBM Corp|INTERNATIONAL BUSINESS MACHINES CORP|International Business Machines Corporation (IBM)|@IBM|IBM's|IBM|International|INTERNATIONAL BUSINESS MACHINES|IBM Inc|International Business Machines Corp's (IBM|INTERNATIONAL BUSINESS MACHINES CORPORATION|International Business Machines Corp (IBM)|International Business Machines Corp .|International Business Machines Corp  .|IBM CORP|Big Ag\",\n",
       "    'GeneralAliasName': 'Big Blue|Guo Ji Shang Ye Ji Qi Gong Si|Guo Ji Shang Yong Ji Qi|IBM|Intanashonaru Bijinesu Mashinzu|International Business Machines|Software Artistry Inc|Unison Software Inc',\n",
       "    'Gics': 'Information Technology/Software & Services/IT Services/IT Consulting & Other Services',\n",
       "    'SPsRatings': '<EntityList xmlns=\"uri://GenericEntityContainer_2.xsd\"><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Standard &amp; Poor&apos;s Bond Rating Services\"/><Property name=\"RatingType\" value=\"S&amp;P Short-term Issuer Credit Rating\"/><Property name=\"RatingTypeCode\" value=\"SIS\"/><Property name=\"CurrentRating\" value=\"A-1\"/><Property name=\"CurrentRatingDate\" value=\"2017-05-05\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"D\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Standard &amp; Poor&apos;s Bond Rating Services\"/><Property name=\"RatingType\" value=\"S&amp;P Senior Unsecured\"/><Property name=\"RatingTypeCode\" value=\"SSU\"/><Property name=\"CurrentRating\" value=\"A\"/><Property name=\"CurrentRatingDate\" value=\"2018-10-29\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"D\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Standard &amp; Poor&apos;s Bond Rating Services\"/><Property name=\"RatingType\" value=\"S&amp;P Short-term Issuer Credit Rating\"/><Property name=\"RatingTypeCode\" value=\"SIS\"/><Property name=\"CurrentRating\" value=\"A-1\"/><Property name=\"CurrentRatingDate\" value=\"2017-05-05\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"F\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Standard &amp; Poor&apos;s Bond Rating Services\"/><Property name=\"RatingType\" value=\"S&amp;P Senior Unsecured\"/><Property name=\"RatingTypeCode\" value=\"SSU\"/><Property name=\"CurrentRating\" value=\"A\"/><Property name=\"CurrentRatingDate\" value=\"2018-10-29\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"F\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Standard &amp; Poor&apos;s Bond Rating Services\"/><Property name=\"RatingType\" value=\"S&amp;P Long-term Issuer Rating\"/><Property name=\"RatingTypeCode\" value=\"SPI\"/><Property name=\"CurrentRating\" value=\"A\"/><Property name=\"CurrentRatingDate\" value=\"2018-10-29\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"Outlook\" value=\"Negative\"/><Property name=\"RatingScope\" value=\"F\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Standard &amp; Poor&apos;s Bond Rating Services\"/><Property name=\"RatingType\" value=\"S&amp;P Long-term Senior Unsecured MTN Rating\"/><Property name=\"RatingTypeCode\" value=\"SMU\"/><Property name=\"CurrentRating\" value=\"A\"/><Property name=\"CurrentRatingDate\" value=\"2018-10-29\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"D\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Standard &amp; Poor&apos;s Bond Rating Services\"/><Property name=\"RatingType\" value=\"S&amp;P Commercial Paper\"/><Property name=\"RatingTypeCode\" value=\"SCP\"/><Property name=\"CurrentRating\" value=\"A-1\"/><Property name=\"CurrentRatingDate\" value=\"2017-05-05\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"F\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Standard &amp; Poor&apos;s Bond Rating Services\"/><Property name=\"RatingType\" value=\"S&amp;P Long-term Issuer Rating\"/><Property name=\"RatingTypeCode\" value=\"SPI\"/><Property name=\"CurrentRating\" value=\"A\"/><Property name=\"CurrentRatingDate\" value=\"2018-10-29\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"Outlook\" value=\"Negative\"/><Property name=\"RatingScope\" value=\"D\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Standard &amp; Poor&apos;s Bond Rating Services\"/><Property name=\"RatingType\" value=\"S&amp;P Long-term Senior Unsecured MTN Rating\"/><Property name=\"RatingTypeCode\" value=\"SMU\"/><Property name=\"CurrentRating\" value=\"NR\"/><Property name=\"CurrentRatingDate\" value=\"2011-05-13\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"F\"/></Entity></EntityList>',\n",
       "    'LiquidityRIC': '0#IBM=',\n",
       "    'DocumentTitleJaHira': 'いんたーなしょなるびじねすましーんずこーぽれーしょん, Public Company',\n",
       "    'RCSTRBC2012Name': 'Technology\\\\Software & IT Services\\\\Software & IT Services\\\\IT Services & Consulting\\\\IT Services & Consulting (NEC)',\n",
       "    'MnaTargetCount': 0,\n",
       "    'TotalLiabilities': 131201000000,\n",
       "    'CompositeSymbolOnly': '18228',\n",
       "    'RCSPartyCountry': 'G:6J',\n",
       "    'IsLegacySearchContent': True,\n",
       "    'RbssScheme': 'IT Services & Consulting - NEC',\n",
       "    'PreferenceSharesCount': 9,\n",
       "    'RCSFilingCountryName': 'Country Grouping\\\\G7\\\\United States|Country Grouping\\\\NATO\\\\United States|Continent / Region\\\\Americas\\\\North America\\\\United States|Country Grouping\\\\APEC\\\\United States|Country Grouping\\\\OECD\\\\United States|Country Grouping\\\\G8\\\\United States|Country\\\\United States|Country Grouping\\\\G20\\\\United States|FRUC Regions\\\\Global\\\\North America\\\\United States|Country Grouping\\\\G10\\\\United States|Country Grouping\\\\North America (EIU)\\\\United States',\n",
       "    'IssuersTRCDSCurveRIC': '<a:Rship name=\"x\" xmlns:a=\"http://www.reuters.com/ns/2007/10/31/webservices/SearchAndNavigation_1/NavCommonResponse_1\"><a:Entity rank=\"1\"><a:Prop name=\"RIC\" value=\"0#IBMUSAXRBMK=\"/><a:Prop name=\"DisplayName\" value=\"IBM\" lang=\"en\"/><a:Req value=\"7674\" scheme=\"IDN\"/></a:Entity></a:Rship>',\n",
       "    'PrimaryRIC': 'IBM',\n",
       "    'CommercialPaperCount': 0,\n",
       "    'RCSCountryHeadquartersName': 'Country Grouping\\\\G7\\\\United States|Country Grouping\\\\NATO\\\\United States|Continent / Region\\\\Americas\\\\North America\\\\United States|Country Grouping\\\\APEC\\\\United States|Country Grouping\\\\OECD\\\\United States|Country Grouping\\\\G8\\\\United States|Country\\\\United States|Country Grouping\\\\G20\\\\United States|FRUC Regions\\\\Global\\\\North America\\\\United States|Country Grouping\\\\G10\\\\United States|Country Grouping\\\\North America (EIU)\\\\United States',\n",
       "    'SPsRatingRank': 'SIS/2|SSU/11|SIS/2|SSU/11|SPI/6|SMU/11|SCP/2|SPI/6|SMU/0',\n",
       "    'SynonymDescriptiveNameJa': 'インタナショナル コーポレイション インタナショナル コーポレイション',\n",
       "    'DTSubjectName': 'International Business Machines Corp',\n",
       "    'CostOfSales': -40659000000,\n",
       "    'RegistrationAuthorityName': 'New York State Department Of State',\n",
       "    'RevenueGrowth5Y': -3.625805,\n",
       "    'GicsCode': '45102010',\n",
       "    'CdsCount': 463,\n",
       "    'DebtToAssets': 0.86211,\n",
       "    'UltimateParentCompanyNDAPI': '37036',\n",
       "    'RatingPreliminary': 'FDL/n|EJC/n|MCP/n|MDL/n|MIS/n|EJC/n|MIS/n|FCP/n|MDL/n|MSU/n|FSS/n|FSU/n|MSU/n|MCP/n|FMU/n|FDT/n|MMU/n|FSU/n|MRS/n|EJU/n|EJU/n|FDS/n|FIS/n|MMU/n|FCP/n',\n",
       "    'TRBCHierarchicalShortCode': '572211',\n",
       "    'FundsCount': 0,\n",
       "    'OriginalAccountsCurrency': 'USD',\n",
       "    'FitchIssuerRating': 'WD',\n",
       "    'LegalNameJaHira': 'いんたーなしょなるびじねすましーんずこーぽれーしょん',\n",
       "    'RCSOrganisationType': 'OT:1',\n",
       "    'CIK': '0000051143',\n",
       "    'RCSOrganisationSubType': 'OAOST:COR',\n",
       "    'Red6Code': '49EB20',\n",
       "    'PEBackedStatus': 'Never',\n",
       "    'RegistrationNumber': '30059',\n",
       "    'PrimaryRICPI': '1097326',\n",
       "    'RatingX1XRatingRankForeign': 'FDL/WDX1X98|MDL/A2X1X7|EJC/A1X1X2|MIS/A2X1X7|FCP/WDX1X98|MSU/A2X1X7|FSS/WDX1X98|FSU/AX1X7|MCP/P-1X1X1|MMU/WRX1X98|MRS/P-1X1X1|EJU/BBB+X1X8|FDS/WDX1X98|FIS/WDX1X98',\n",
       "    'RegistrationAuthorityOrganizationID': '5000064525',\n",
       "    'RatingX1XRatingRankDomestic': 'EJC/A1X1X2|MCP/P-1X1X1|MIS/A2X1X7|MDL/A2X1X7|MSU/A2X1X7|FMU/WDX1X98|FDT/F1X1X2|FSU/WDX1X98|EJU/BBB+X1X8|MMU/WRX1X98|FCP/F1X1X2',\n",
       "    'TotalOperatingIncome': 77147000000,\n",
       "    'SPsRatingOutlookRank': 'SPI/-1|SPI/-1',\n",
       "    'PrimaryRICRICUsageCount': 6647,\n",
       "    'RatingsExist': True,\n",
       "    'Orgid': '18228',\n",
       "    'NumberOfEmployees': 352600,\n",
       "    'SubsidiariesCount': 199,\n",
       "    'FundamentalsExist': True,\n",
       "    'IsActive': True,\n",
       "    'DTSubjectNameJaHira': 'いんたーなしょなるびじねすましーんずこーぽれーしょん',\n",
       "    'InterimNetIncome': 1698000000,\n",
       "    'OAOrgSubType': 'COR',\n",
       "    'SPIssuerRating': 'A',\n",
       "    'BusinessEntity': 'ORGANISATION',\n",
       "    'DEBUGBATCH': 'Update_CL3_US2P_G1.4_Organisation_0033361_20210101_200613_A_incr_wi_002390.xml.xz',\n",
       "    'RCSTRBCLeafML': 'ja IT サービス & コンサルティング|zh-Hans 信息技术服务及咨询|zh-Hant 信息技術服務及諮詢',\n",
       "    'OrganisationTypeName': 'Corporation',\n",
       "    'CompositeIdentifyingCode': 'VGRQXHF3J8VDLUA7XE92 US4592001014 0000051143 4295904307 459200101 49EB20 IBM',\n",
       "    'Roe': 45.252147,\n",
       "    'OrganisationStatus': 'Listed',\n",
       "    'CurrentLiabilities': 37701000000,\n",
       "    'PrimaryRICTickerSymbol': 'IBM',\n",
       "    'RCSCountryHeadquartersNameML': 'ja 国際機関\\\\\\\\米国|zh-Hans 国家分组\\\\\\\\美国|zh-Hant 國家分組\\\\\\\\美國|es \\\\\\\\Estados Unidos|fr \\\\\\\\États Unis|ko \\\\\\\\미국|ru \\\\\\\\США|ja 国際機関\\\\\\\\米国|zh-Hans 国家分组\\\\北大西洋公约组织\\\\美国|zh-Hant 國家分組\\\\北大西洋公約組織\\\\美國|es \\\\\\\\Estados Unidos|fr \\\\\\\\États Unis|ko \\\\\\\\미국|ru \\\\\\\\США|es Continentes/regiones\\\\Continente Americano\\\\Norteamérica\\\\Estados Unidos|fr Continents/Régions\\\\Amérique\\\\Amérique du Nord\\\\États Unis|ja 大陸 / 地域\\\\北米 & 中南米\\\\北米\\\\米国|ru Континенты/регионы\\\\Америка\\\\Северная Америка\\\\США|zh-Hans 大陆/地区\\\\美洲\\\\北美\\\\美国|zh-Hant 大陸/地區\\\\美洲\\\\北美\\\\美國|ko \\\\미주\\\\북아메리카\\\\미국|ja 国際機関\\\\\\\\米国|zh-Hans 国家分组\\\\亚太经济合作组织\\\\美国|zh-Hant 國家分組\\\\亞太經濟合作組織\\\\美國|es \\\\\\\\Estados Unidos|fr \\\\\\\\États Unis|ko \\\\\\\\미국|ru \\\\\\\\США|ja 国際機関\\\\\\\\米国|zh-Hans 国家分组\\\\经济合作与发展组织\\\\美国|zh-Hant 國家分組\\\\經濟合作與發展組織\\\\美國|es \\\\\\\\Estados Unidos|fr \\\\\\\\États Unis|ko \\\\\\\\미국|ru \\\\\\\\США|ja 国際機関\\\\\\\\米国|zh-Hans 国家分组\\\\\\\\美国|zh-Hant 國家分組\\\\\\\\美國|es \\\\\\\\Estados Unidos|fr \\\\\\\\États Unis|ko \\\\\\\\미국|ru \\\\\\\\США|ja 国\\\\米国|zh-Hans 国家/地区\\\\美国|zh-Hant 國家/地區\\\\美國|es \\\\Estados Unidos|fr \\\\États Unis|ko \\\\미국|ru \\\\США|ja 国際機関\\\\\\\\米国|zh-Hans 国家分组\\\\\\\\美国|zh-Hant 國家分組\\\\\\\\美國|es \\\\\\\\Estados Unidos|fr \\\\\\\\États Unis|ko \\\\\\\\미국|ru \\\\\\\\США|ja FRUC 地域\\\\グローバル\\\\北米\\\\米国|zh-Hans FRUC 区域\\\\全球\\\\北美\\\\美国|zh-Hant FRUC 區域\\\\全球\\\\北美\\\\美國|es \\\\\\\\\\\\Estados Unidos|fr \\\\\\\\\\\\États Unis|ko \\\\\\\\\\\\미국|ru \\\\\\\\\\\\США|ja 国際機関\\\\\\\\米国|zh-Hans 国家分组\\\\G10 集团\\\\美国|zh-Hant 國家分組\\\\G10 集��\\\\美國|es \\\\\\\\Estados Unidos|fr \\\\\\\\États Unis|ko \\\\\\\\미국|ru \\\\\\\\США|ja 国際機関\\\\北アフリカ (EIU)\\\\米国|zh-Hans 国家分组\\\\北美 (EIU)\\\\美国|zh-Hant 國家分組\\\\北美 (EIU)\\\\美國|es \\\\\\\\Estados Unidos|fr \\\\\\\\États Unis|ko \\\\\\\\미국|ru \\\\\\\\США',\n",
       "    'RCSTRBC2012LeafML': 'ja IT サービス & コンサルティング (その他)|zh-Hans IT 服务及咨询 (NEC)|zh-Hant IT 服務及諮詢 (NEC)',\n",
       "    'WarrantsCount': 3035,\n",
       "    'ParentOrganisationOrgid': '18228',\n",
       "    'DocumentTitle': 'International Business Machines Corp, Public Company',\n",
       "    'ShortName': 'IBM',\n",
       "    'DEBUGRANKRULES': '200001|300000',\n",
       "    'DTSimpleType': 'Public Company',\n",
       "    'UnderlyingEquityQuoteIssueCount': 0,\n",
       "    'Revenue': 77147000000,\n",
       "    'IsShariahCompliant': False,\n",
       "    'RCSTRBC2012Leaf': 'IT Services & Consulting (NEC)',\n",
       "    'IsPreIPO': False,\n",
       "    'PretaxProfitInterim': 1827000000,\n",
       "    'ReutersIndustryClassification': 'Data Processing & Reproduction',\n",
       "    'OpProfit': 10721000000,\n",
       "    'RatingX1XRatingRank': 'FDL/WDX1X98|EJC/A1X1X2|MCP/P-1X1X1|MDL/A2X1X7|MIS/A2X1X7|EJC/A1X1X2|MIS/A2X1X7|FCP/WDX1X98|MDL/A2X1X7|MSU/A2X1X7|FSS/WDX1X98|FSU/AX1X7|MSU/A2X1X7|MCP/P-1X1X1|FMU/WDX1X98|FDT/F1X1X2|MMU/WRX1X98|FSU/WDX1X98|MRS/P-1X1X1|EJU/BBB+X1X8|EJU/BBB+X1X8|FDS/WDX1X98|FIS/WDX1X98|MMU/WRX1X98|FCP/F1X1X2',\n",
       "    'SuggestCompletion': [{'input': ['big',\n",
       "       'big blue',\n",
       "       'company',\n",
       "       'corporation',\n",
       "       'guo',\n",
       "       'guo ji',\n",
       "       'guo ji shang',\n",
       "       'guo ji shang ye',\n",
       "       'guo ji shang ye ji',\n",
       "       'guo ji shang ye ji qi',\n",
       "       'guo ji shang yong',\n",
       "       'guo ji shang yong ji',\n",
       "       'guo ji shang yong ji qi',\n",
       "       'ibm',\n",
       "       'intanashonaru',\n",
       "       'intanashonaru bijinesu',\n",
       "       'intanashonaru bijinesu mashinzu',\n",
       "       'international',\n",
       "       'international business',\n",
       "       'international business machines',\n",
       "       'international business machines corp',\n",
       "       'international business machines corporation',\n",
       "       'software',\n",
       "       'software artistry',\n",
       "       'software artistry inc',\n",
       "       'unison',\n",
       "       'unison software',\n",
       "       'unison software inc'],\n",
       "      'weight': 6453129},\n",
       "     {'input': ['company',\n",
       "       'corporation',\n",
       "       'ibm',\n",
       "       'it',\n",
       "       'it services',\n",
       "       'it services & consulting',\n",
       "       'it services & consulting (nec)'],\n",
       "      'weight': 1000000},\n",
       "     {'input': ['united', 'united states'], 'weight': 7000000}],\n",
       "    'CompositeSearchAll': 'IT Services & Consulting (NEC) ORGANISATION Corporation Listed',\n",
       "    'Rofa': 10.032872,\n",
       "    'NetProfitUsd': 9431000000,\n",
       "    'MortgagesCount': 0,\n",
       "    'AddressPostalCode': '10504-1722',\n",
       "    'IsMainIssueFiling': True,\n",
       "    'PrimaryRICISIN': 'US4592001014',\n",
       "    'RCSTRBC2012Genealogy': 'B:278\\\\B:171\\\\B:172\\\\B:290\\\\B:1790',\n",
       "    'Nd': 54031000000,\n",
       "    'PrimaryRICRICAcctsCount': 2944,\n",
       "    'LoanCount': 0,\n",
       "    'FtseScheme': 'Information Technology/Software & Computer Services/Computer Services',\n",
       "    'StaffCosts': -453000000,\n",
       "    'CPERMIDs': 'C000002474',\n",
       "    'IssuerCikNumber': '0000051143',\n",
       "    'CashAndEquivalents': 8172000000,\n",
       "    'RCSCountryHeadquartersLeaf': 'United States',\n",
       "    'CurrentAssets': 38420000000,\n",
       "    'PrimaryRICRCSAssetCategoryLeaf': 'Ordinary Share',\n",
       "    'RCSCountryOfIncorporation': 'G:6J',\n",
       "    'PrimaryRICExchangeCode': 'NYQ',\n",
       "    'TotalAssetsToEquity': 7.302241,\n",
       "    'SPsRatingX1XSPsRatingRankDomestic': 'SIS/A-1X1X2|SSU/AX1X11|SMU/AX1X11|SPI/AX1X6',\n",
       "    'Ratings': '<EntityList xmlns=\"uri://GenericEntityContainer_2.xsd\"><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Fitch\"/><Property name=\"RatingType\" value=\"Fitch Long-term Issuer Default Rating\"/><Property name=\"RatingTypeCode\" value=\"FDL\"/><Property name=\"CurrentRating\" value=\"WD\"/><Property name=\"CurrentRatingDate\" value=\"2019-07-01\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"F\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Egan-Jones Ratings Co.\"/><Property name=\"RatingType\" value=\"Egan-Jones Commercial Paper\"/><Property name=\"RatingTypeCode\" value=\"EJC\"/><Property name=\"CurrentRating\" value=\"A1\"/><Property name=\"CurrentRatingDate\" value=\"2018-11-02\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"D\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Moody&apos;s\"/><Property name=\"RatingType\" value=\"Moody&apos;s Commercial Paper\"/><Property name=\"RatingTypeCode\" value=\"MCP\"/><Property name=\"CurrentRating\" value=\"P-1\"/><Property name=\"CurrentRatingDate\" value=\"2016-03-30\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"D\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Moody&apos;s\"/><Property name=\"RatingType\" value=\"Moody&apos;s Derived Long-term Issuer Rating\"/><Property name=\"RatingTypeCode\" value=\"MDL\"/><Property name=\"CurrentRating\" value=\"A2\"/><Property name=\"CurrentRatingDate\" value=\"2019-07-09\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"Outlook\" value=\"Stable\"/><Property name=\"RatingScope\" value=\"F\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Moody&apos;s\"/><Property name=\"RatingType\" value=\"Moody&apos;s Long-term Issuer Rating\"/><Property name=\"RatingTypeCode\" value=\"MIS\"/><Property name=\"CurrentRating\" value=\"A2\"/><Property name=\"CurrentRatingDate\" value=\"2019-07-09\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"D\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Egan-Jones Ratings Co.\"/><Property name=\"RatingType\" value=\"Egan-Jones Commercial Paper\"/><Property name=\"RatingTypeCode\" value=\"EJC\"/><Property name=\"CurrentRating\" value=\"A1\"/><Property name=\"CurrentRatingDate\" value=\"2019-01-30\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"F\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Moody&apos;s\"/><Property name=\"RatingType\" value=\"Moody&apos;s Long-term Issuer Rating\"/><Property name=\"RatingTypeCode\" value=\"MIS\"/><Property name=\"CurrentRating\" value=\"A2\"/><Property name=\"CurrentRatingDate\" value=\"2019-07-09\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"F\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Fitch\"/><Property name=\"RatingType\" value=\"Fitch Commercial Paper\"/><Property name=\"RatingTypeCode\" value=\"FCP\"/><Property name=\"CurrentRating\" value=\"WD\"/><Property name=\"CurrentRatingDate\" value=\"2019-07-01\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"F\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Moody&apos;s\"/><Property name=\"RatingType\" value=\"Moody&apos;s Derived Long-term Issuer Rating\"/><Property name=\"RatingTypeCode\" value=\"MDL\"/><Property name=\"CurrentRating\" value=\"A2\"/><Property name=\"CurrentRatingDate\" value=\"2019-07-09\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"Outlook\" value=\"Stable\"/><Property name=\"RatingScope\" value=\"D\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Moody&apos;s\"/><Property name=\"RatingType\" value=\"Moody&apos;s Senior Unsecured\"/><Property name=\"RatingTypeCode\" value=\"MSU\"/><Property name=\"CurrentRating\" value=\"A2\"/><Property name=\"CurrentRatingDate\" value=\"2019-07-09\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"F\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Fitch\"/><Property name=\"RatingType\" value=\"Fitch Short-term Issuer Rating\"/><Property name=\"RatingTypeCode\" value=\"FSS\"/><Property name=\"CurrentRating\" value=\"WD\"/><Property name=\"CurrentRatingDate\" value=\"2007-05-30\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"F\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Fitch\"/><Property name=\"RatingType\" value=\"Fitch Senior Unsecured\"/><Property name=\"RatingTypeCode\" value=\"FSU\"/><Property name=\"CurrentRating\" value=\"A\"/><Property name=\"CurrentRatingDate\" value=\"2018-10-30\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"y\"/><Property name=\"RatingScope\" value=\"F\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Moody&apos;s\"/><Property name=\"RatingType\" value=\"Moody&apos;s Senior Unsecured\"/><Property name=\"RatingTypeCode\" value=\"MSU\"/><Property name=\"CurrentRating\" value=\"A2\"/><Property name=\"CurrentRatingDate\" value=\"2019-07-09\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"D\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Moody&apos;s\"/><Property name=\"RatingType\" value=\"Moody&apos;s Commercial Paper\"/><Property name=\"RatingTypeCode\" value=\"MCP\"/><Property name=\"CurrentRating\" value=\"P-1\"/><Property name=\"CurrentRatingDate\" value=\"1994-10-19\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"F\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Fitch\"/><Property name=\"RatingType\" value=\"Fitch Long-term Senior Unsecured MTN Rating\"/><Property name=\"RatingTypeCode\" value=\"FMU\"/><Property name=\"CurrentRating\" value=\"WD\"/><Property name=\"CurrentRatingDate\" value=\"2015-07-15\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"D\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Fitch\"/><Property name=\"RatingType\" value=\"Fitch Short-term Debt Rating\"/><Property name=\"RatingTypeCode\" value=\"FDT\"/><Property name=\"CurrentRating\" value=\"F1\"/><Property name=\"CurrentRatingDate\" value=\"2018-10-30\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"y\"/><Property name=\"RatingScope\" value=\"D\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Moody&apos;s\"/><Property name=\"RatingType\" value=\"Moody&apos;s Long-term Senior Unsecured MTN Rating\"/><Property name=\"RatingTypeCode\" value=\"MMU\"/><Property name=\"CurrentRating\" value=\"WR\"/><Property name=\"CurrentRatingDate\" value=\"2016-11-18\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"F\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Fitch\"/><Property name=\"RatingType\" value=\"Fitch Senior Unsecured\"/><Property name=\"RatingTypeCode\" value=\"FSU\"/><Property name=\"CurrentRating\" value=\"WD\"/><Property name=\"CurrentRatingDate\" value=\"2019-07-01\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"D\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Moody&apos;s\"/><Property name=\"RatingType\" value=\"Moody&apos;s Most Recent Short-term Rating\"/><Property name=\"RatingTypeCode\" value=\"MRS\"/><Property name=\"CurrentRating\" value=\"P-1\"/><Property name=\"CurrentRatingDate\" value=\"2019-07-09\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"Outlook\" value=\"Stable\"/><Property name=\"RatingScope\" value=\"F\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Egan-Jones Ratings Co.\"/><Property name=\"RatingType\" value=\"Egan-Jones Senior Unsecured\"/><Property name=\"RatingTypeCode\" value=\"EJU\"/><Property name=\"CurrentRating\" value=\"BBB+\"/><Property name=\"CurrentRatingDate\" value=\"2020-04-29\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"F\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Egan-Jones Ratings Co.\"/><Property name=\"RatingType\" value=\"Egan-Jones Senior Unsecured\"/><Property name=\"RatingTypeCode\" value=\"EJU\"/><Property name=\"CurrentRating\" value=\"BBB+\"/><Property name=\"CurrentRatingDate\" value=\"2020-04-29\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"D\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Fitch\"/><Property name=\"RatingType\" value=\"Fitch Short-term Issuer Default Rating\"/><Property name=\"RatingTypeCode\" value=\"FDS\"/><Property name=\"CurrentRating\" value=\"WD\"/><Property name=\"CurrentRatingDate\" value=\"2019-07-01\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"F\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Fitch\"/><Property name=\"RatingType\" value=\"Fitch Long-term Issuer Rating\"/><Property name=\"RatingTypeCode\" value=\"FIS\"/><Property name=\"CurrentRating\" value=\"WD\"/><Property name=\"CurrentRatingDate\" value=\"2005-10-05\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"F\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Moody&apos;s\"/><Property name=\"RatingType\" value=\"Moody&apos;s Long-term Senior Unsecured MTN Rating\"/><Property name=\"RatingTypeCode\" value=\"MMU\"/><Property name=\"CurrentRating\" value=\"WR\"/><Property name=\"CurrentRatingDate\" value=\"2016-11-18\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"n\"/><Property name=\"RatingScope\" value=\"D\"/></Entity><Entity name=\"Rating\"><Property name=\"Agency\" value=\"Fitch\"/><Property name=\"RatingType\" value=\"Fitch Commercial Paper\"/><Property name=\"RatingTypeCode\" value=\"FCP\"/><Property name=\"CurrentRating\" value=\"F1\"/><Property name=\"CurrentRatingDate\" value=\"2007-05-30\"/><Property name=\"Preliminary\" value=\"n\"/><Property name=\"Solicited\" value=\"y\"/><Property name=\"RatingScope\" value=\"D\"/></Entity></EntityList>',\n",
       "    'SDCCUSIP': '459200',\n",
       "    'Edcoid': 'IBM.N',\n",
       "    'LocalScheme': 'Industrial|Information Technology/Information Technology Hardware|Industrials/Computer Hardware',\n",
       "    'BusinessIntelligenceExists': True,\n",
       "    'QuickRatio': 0.976128,\n",
       "    'VEFirmID': '21142',\n",
       "    'CommonNameJaHira': 'いんたーなしょなるびじねすましーんずこーぽれーしょん',\n",
       "    'RCSTRBC': 'B:173',\n",
       "    'PI': '37036',\n",
       "    'Rota': 6.844772,\n",
       "    'VentureEconomicsID': '99636',\n",
       "    'PrimaryRICExchangeName': 'NYSE Consolidated',\n",
       "    'IsContributor': False,\n",
       "    'RatingRank': 'FDL/98|EJC/2|MCP/1|MDL/7|MIS/7|EJC/2|MIS/7|FCP/98|MDL/7|MSU/7|FSS/98|FSU/7|MSU/7|MCP/1|FMU/98|FDT/2|MMU/98|FSU/98|MRS/1|EJU/8|EJU/8|FDS/98|FIS/98|MMU/98|FCP/2',\n",
       "    'OpProfitUsd': 10721000000,\n",
       "    'RatingOutlookX1XRatingOutlookRank': 'MDL/StableX1X0|MDL/StableX1X0|MRS/StableX1X0',\n",
       "    'MarkItShortName': 'Intl Business Machs Corp',\n",
       "    'Rank': 2838764,\n",
       "    'SearchAllCategoryv2': 'Companies/Issuers',\n",
       "    'MXID': '100085757',\n",
       "    'SalesToReceivables': 2.63967,\n",
       "    'CountryHeadquartersName': 'United States',\n",
       "    'ForecastDividendCashflowRIC': '<a:Rship name=\"x\" xmlns:a=\"http://www.reuters.com/ns/2007/10/31/webservices/SearchAndNavigation_1/NavCommonResponse_1\"><a:Entity><a:Prop name=\"RIC\" value=\"IBMDIVCF.N\"/><a:Req value=\"145\" scheme=\"IDN\"/></a:Entity></a:Rship>',\n",
       "    'SearchAllCategoryv3': 'Companies/Issuers',\n",
       "    'TaxID': '130871985',\n",
       "    'MnaParentAcquirerCount': 0,\n",
       "    'TRBCHierarchicalCodeMeaning': 'IT Services & Consulting - NEC',\n",
       "    'PretaxProfit': 10166000000,\n",
       "    'UnderlyingEquityOptionIssueCount': 0,\n",
       "    'DocDateTime': '2021-01-01T20:06:13.000Z',\n",
       "    'RCSOrganisationTypeLeafML': 'ja 事業法人|zh-Hans 公司|zh-Hant 公司',\n",
       "    'SPsRatingsScope': [{'Agency': 'S&P',\n",
       "      'RatingType': 'SIS',\n",
       "      'CurrentRatingRank': 2,\n",
       "      'CurrentRatingDate': '2017-05-05T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'D'},\n",
       "     {'Agency': 'S&P',\n",
       "      'RatingType': 'SSU',\n",
       "      'CurrentRatingRank': 11,\n",
       "      'CurrentRatingDate': '2018-10-29T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'D'},\n",
       "     {'Agency': 'S&P',\n",
       "      'RatingType': 'SIS',\n",
       "      'CurrentRatingRank': 2,\n",
       "      'CurrentRatingDate': '2017-05-05T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'F'},\n",
       "     {'Agency': 'S&P',\n",
       "      'RatingType': 'SSU',\n",
       "      'CurrentRatingRank': 11,\n",
       "      'CurrentRatingDate': '2018-10-29T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'F'},\n",
       "     {'Agency': 'S&P',\n",
       "      'RatingType': 'SPI',\n",
       "      'CurrentRatingRank': 6,\n",
       "      'CurrentRatingDate': '2018-10-29T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'OutlookRank': -1,\n",
       "      'RatingScope': 'F',\n",
       "      'Outlook': 'Negative'},\n",
       "     {'Agency': 'S&P',\n",
       "      'RatingType': 'SMU',\n",
       "      'CurrentRatingRank': 11,\n",
       "      'CurrentRatingDate': '2018-10-29T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'D'},\n",
       "     {'Agency': 'S&P',\n",
       "      'RatingType': 'SCP',\n",
       "      'CurrentRatingRank': 2,\n",
       "      'CurrentRatingDate': '2017-05-05T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'F'},\n",
       "     {'Agency': 'S&P',\n",
       "      'RatingType': 'SPI',\n",
       "      'CurrentRatingRank': 6,\n",
       "      'CurrentRatingDate': '2018-10-29T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'OutlookRank': -1,\n",
       "      'RatingScope': 'D',\n",
       "      'Outlook': 'Negative'},\n",
       "     {'Agency': 'S&P',\n",
       "      'RatingType': 'SMU',\n",
       "      'CurrentRatingRank': 0,\n",
       "      'CurrentRatingDate': '2011-05-13T00:00:00.000Z',\n",
       "      'Preliminary': 'n',\n",
       "      'Solicited': 'n',\n",
       "      'RatingScope': 'F'}],\n",
       "    'TRBCPrimaryCodeMeaning': 'IT Services & Consulting',\n",
       "    'OrgMainRepno': '4741N',\n",
       "    'AddressStateProvince': 'NEW YORK',\n",
       "    'TotalLiabilitiesUsd': 131201000000,\n",
       "    'RCSCountryHeadquartersGenealogy': 'M:DQ\\\\G:AM\\\\G:6J|M:DQ\\\\G:AN\\\\G:6J|M:DH\\\\G:4\\\\G:9\\\\G:6J|M:DQ\\\\G:AQ\\\\G:6J|M:DQ\\\\G:AR\\\\G:6J|M:DQ\\\\G:AS\\\\G:6J|M:A9\\\\G:6J|M:DQ\\\\G:B9\\\\G:6J|M:1M2\\\\G:3U8\\\\G:3U9\\\\G:6J|M:DQ\\\\G:CX\\\\G:6J|M:DQ\\\\G:DE\\\\G:6J',\n",
       "    'RevenueGrowthInterim': -2.595962,\n",
       "    'OAOrgType': 'COM',\n",
       "    'GicsLeaf': 'IT Consulting & Other Services',\n",
       "    'GeneralAliasNameJaHani': 'インターナショナル・ビジネス・マシーンズ',\n",
       "    'FDS': 'IBM',\n",
       "    'MarketCapitalisationIndices': '<a:Rship name=\"x\" xmlns:a=\"http://www.reuters.com/ns/2007/10/31/webservices/SearchAndNavigation_1/NavCommonResponse_1\"><a:Entity rank=\"1\"><a:Prop name=\"DisplayName\" value=\"道琼斯工业平均指数\" lang=\"zh-Hans\"/><a:Prop name=\"RIC\" value=\".DJI\"/><a:Req value=\"9822\" scheme=\"IDN\"/><a:Req value=\"4017\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"2\"><a:Prop name=\"DisplayName\" value=\"DJ工業株30種平均指数\" lang=\"ja-Hani\"/><a:Prop name=\"RIC\" value=\".DJI\"/><a:Req value=\"9822\" scheme=\"IDN\"/><a:Req value=\"4017\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"3\"><a:Prop name=\"DisplayName\" value=\"DOW JONES INDU AVERAGE NDX\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".DJI\"/><a:Req value=\"9822\" scheme=\"IDN\"/><a:Req value=\"4017\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"4\"><a:Prop name=\"DisplayName\" value=\"DJ COMP AVERAGE\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".DJA\"/><a:Req value=\"9822\" scheme=\"IDN\"/><a:Req value=\"4017\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"5\"><a:Prop name=\"DisplayName\" value=\"道琼斯综合指数\" lang=\"zh-Hans\"/><a:Prop name=\"RIC\" value=\".DJA\"/><a:Req value=\"9822\" scheme=\"IDN\"/><a:Req value=\"4017\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"6\"><a:Prop name=\"DisplayName\" value=\"DJ コンポジット平均\" lang=\"ja-Hani\"/><a:Prop name=\"RIC\" value=\".DJA\"/><a:Req value=\"9822\" scheme=\"IDN\"/><a:Req value=\"4017\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"7\"><a:Prop name=\"DisplayName\" value=\"S&amp;P Composite 1500 Index\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".SPSUP\"/><a:Req value=\"5185\" scheme=\"IDN\"/><a:Req value=\"5775\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"8\"><a:Prop name=\"DisplayName\" value=\"DOW JONES GL TITAN 50 EUR NDX\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".DJGTE\"/><a:Req value=\"9822\" scheme=\"IDN\"/><a:Req value=\"4017\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"9\"><a:Prop name=\"DisplayName\" value=\"Refinitiv United States Price Return Index\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".TRXFLDUSP\"/><a:Req value=\"7642\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"10\"><a:Prop name=\"DisplayName\" value=\"Refinitiv North America Price Return Index\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".TRXFLDNAPU\"/><a:Req value=\"7642\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"11\"><a:Prop name=\"DisplayName\" value=\"Refinitiv NAFTA Price Return Index\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".TRXFLDNFPU\"/><a:Req value=\"7642\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"12\"><a:Prop name=\"DisplayName\" value=\"Refinitiv G7 Price Return Index\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".TRXFLDG7PU\"/><a:Req value=\"3112\" scheme=\"IDN\"/></a:Entity><a:Entity rank=\"13\"><a:Prop name=\"DisplayName\" value=\"Refinitiv Global Price Return Index\" lang=\"en\"/><a:Prop name=\"RIC\" value=\".TRXFLDGLPU\"/><a:Req value=\"3112\" scheme=\"IDN\"/></a:Entity></a:Rship>',\n",
       "    'ShareholdersEquity': 20841000000,\n",
       "    'PretaxProfitMargin': 0.131774,\n",
       "    'LegalNameJaKana': 'インターナショナルビジネスマシーンズコーポレーション',\n",
       "    'RCSOrganisationSubTypeLeaf': 'Company',\n",
       "    'IssuersUltimateParentHasCDS': True,\n",
       "    'IssuerHasCds': True,\n",
       "    'ListingStatus': 'LIS',\n",
       "    'ShareholdersEquityUsd': 20841000000,\n",
       "    'FuturesCount': 28,\n",
       "    'DocumentTitleJaHani': 'インターナショナル･ビジネス･マシーンズ･コーポレーション, Public Company',\n",
       "    'RCSOrganisationSubTypeNameML': 'ja OA 組織サブタイプ\\\\法人|zh-Hans OA 组织子类型\\\\公司',\n",
       "    'SPsRatingType': 'Issuer/S&P/SIS|Issuer/S&P/SSU|Issuer/S&P/SIS|Issuer/S&P/SSU|Issuer/S&P/SPI|Issuer/S&P/SMU|Issuer/S&P/SCP|Issuer/S&P/SPI|Issuer/S&P/SMU',\n",
       "    'SalesToInventory': 46.741593,\n",
       "    'EquityIndices': '.DJA~DLM~en:DJ COMP AVERAGE|DLM|.DJA~DLM~ja-Hani:DJ コンポジット平均|DLM|.DJA~DLM~zh-Hans:道琼斯综合指数|DLM|.DJGTE~DLM~en:DOW JONES GL TITAN 50 EUR NDX|DLM|.DJGT~DLM~en:Dow Jones Global Titans Index|DLM|.DJI~DLM~en:DOW JONES INDU AVERAGE NDX|DLM|.DJI~DLM~ja-Hani:DJ工業株30種平均指数|DLM|.DJI~DLM~zh-Hans:道琼斯工业平均指数|DLM|.DJUSTC~DLM~en:DOW JONES TECHNOLOGY NDX|DLM|.IVX~DLM~en:S&P 500 Value Index|DLM|.NYA~DLM~en:NYSE COMPOSITE|DLM|.NYA~DLM~ja-Hani:NYSE 総合指数|DLM|.OEXA~DLM~en:S&P 100 INDEX|DLM|.OEXA~DLM~ja-Hani:S&P 100種 指数|DLM|.OEXA~DLM~zh-Hans:标普100指数|DLM|.SPCOMIS~DLM~en:S&P Composite 1500 Software&Serv(IG)|DLM|.SPCOMITCS~DLM~en:S&P 1500 IT Services (Ind)|DLM|.SPCOMTKCS~DLM~en:S&P 1500 ITConsulting&Other Serv(SI)|DLM|.SPCOMT~DLM~en:S&P 1500 Info Technology (Sector)|DLM|.SPLGMID~DLM~en:S&P 900 INDEX|DLM|.SPLRCIS~DLM~en:S&P 500 Software & Services (IG)|DLM|.SPLRCITCS~DLM~en:S&P 500 IT Services (Industry)|DLM|.SPLRCTKCS~DLM~en:S&P 500 IT Consulting&Other Serv(SI)|DLM|.SPLRCT~DLM~en:S&P 500 Information Tech(Sector)|DLM|.SPLRCT~DLM~ja-Hani:S&P 500種 情報技術セクター指数|DLM|.SPLRCT~DLM~zh-Hans:标普信息技术指数|DLM|.SPSUP~DLM~en:S&P Composite 1500 Index|DLM|.SPX~DLM~en:S&P 500 INDEX|DLM|.SPX~DLM~ja-Hani:S&P 500 指数|DLM|.SPX~DLM~zh-Hans:标普500指数|DLM|.SX150P~DLM~en:STXGL150 INDEX CHAIN|DLM|.TRAFWLP1~DLM~en:Refinitiv StarMine Affinity World Leaders Price Return Index (USD)|DLM|.TRENVUS1~DLM~en:Refinitiv/S-Network US Large Cap Environmental Best Practices Index (USD)|DLM|.TRENVUSE1~DLM~en:Refinitiv/S-Network US Large Cap Environmental Best Practices Index (EUR)|DLM|.TRESGQ1~DLM~en:RF IX GL ESG Equal Weighted PR|DLM|.TRESGUS1~DLM~en:Refinitiv/S-Network US Large Cap ESG Best Practices Index (USD)|DLM|.TRESGUSE1~DLM~en:Refinitiv/S-Network US Large Cap ESG Best Practices Index (EUR)|DLM|.TRESGZQ1~DLM~en:RF IX GL ESG HDLV Equal Weighted PR|DLM|.TRGRPSE1~DLM~en:Refinitiv GL Resource Protection Select|DLM|.TRSCUS1~DLM~en:Refinitiv/S-Network US Large Cap Social Best Practices Index (USD)|DLM|.TRSCUSE1~DLM~en:Refinitiv/S-Network US Large Cap Social Best Practices Index (EUR)|DLM|.TRX500USP~DLM~en:Refinitiv United States 500 Price Return Index|DLM|.TRXFLDAAPU~DLM~en:Refinitiv Americas Price Return Index|DLM|.TRXFLDAATL~DLM~en:RF AMERICAS TR LCY IDX|DLM|.TRXFLDG7PUSVIT~DLM~en:Refinitiv G7 IT Services & Consulting Price Return Index|DLM|.TRXFLDG7PUT21~DLM~en:Refinitiv G7 Software & IT Services-572010 Price Return Index|DLM|.TRXFLDG7PUT2~DLM~en:Refinitiv G7 Software & IT Services-5720 Price Return Index|DLM|.TRXFLDG7PUTEC~DLM~en:Refinitiv G7 Technology Price Return Index|DLM|.TRXFLDG7PU~DLM~en:Refinitiv G7 Price Return Index|DLM|.TRXFLDGAPUUSD~DLM~en:Refinitiv Global AUD Price Return Index (USD)|DLM|.TRXFLDGAPU~DLM~en:Refinitiv Global AUD Price Return Index (AUD)|DLM|.TRXFLDGATUUSD~DLM~en:Refinitiv Global AUD Total Return Index (USD)|DLM|.TRXFLDGDPUSVIT~DLM~en:Refinitiv Global Developed IT Services & Consulting Price Return Index|DLM|.TRXFLDGDPUT21~DLM~en:Refinitiv Global Developed Software & IT Services-572010 Price Return Index|DLM|.TRXFLDGDPUT2~DLM~en:Refinitiv Global Developed Software & IT Services-5720 Price Return Index|DLM|.TRXFLDGDPUTEC~DLM~en:Refinitiv Global Developed Technology Price Return Index|DLM|.TRXFLDGDPU~DLM~en:Refinitiv Global Developed Price Return Index|DLM|.TRXFLDGFPU~DLM~en:Refinitiv Global Ex Frontier Large and Mid Cap Price Return Index (USD)|DLM|.TRXFLDGLPUSVIT~DLM~en:Refinitiv Global IT Services & Consulting Price Return Index|DLM|.TRXFLDGLPUT21~DLM~en:Refinitiv Global Software & IT Services-572010 Price Return Index|DLM|.TRXFLDGLPUT2~DLM~en:Refinitiv Global Software & IT Services-5720 Price Return Index|DLM|.TRXFLDGLPUTEC~DLM~en:Refinitiv Global Technology Price Return Index|DLM|.TRXFLDGLPU~DLM~en:Refinitiv Global Price Return Index|DLM|.TRXFLDGLTL~DLM~en:RF GLOBAL TR LCY IDX|DLM|.TRXFLDGSPUUSD~DLM~en:Refinitiv Global Developed Ex Australia Price Return Index (USD)|DLM|.TRXFLDGSPU~DLM~en:Refinitiv Global Developed Ex Australia Price Return Index (AUD)|DLM|.TRXFLDGSTUUSD~DLM~en:Refinitiv Global Developed Ex Australia Total Return Index (USD)|DLM|.TRXFLDNAPUSVIT~DLM~en:Refinitiv North America IT Services & Consulting Price Return Index|DLM|.TRXFLDNAPUT21~DLM~en:Refinitiv North America Software & IT Services-572010 Price Return Index|DLM|.TRXFLDNAPUT2~DLM~en:Refinitiv North America Software & IT Services-5720 Price Return Index|DLM|.TRXFLDNAPUTEC~DLM~en:Refinitiv North America Technology Price Return Index|DLM|.TRXFLDNAPU~DLM~en:Refinitiv North America Price Return Index|DLM|.TRXFLDNFPUSVIT~DLM~en:Refinitiv NAFTA IT Services & Consulting Price Return Index|DLM|.TRXFLDNFPUT21~DLM~en:Refinitiv NAFTA Software & IT Services-572010 Price Return Index|DLM|.TRXFLDNFPUT2~DLM~en:Refinitiv NAFTA Software & IT Services-5720 Price Return Index|DLM|.TRXFLDNFPUTEC~DLM~en:Refinitiv NAFTA Technology Price Return Index|DLM|.TRXFLDNFPU~DLM~en:Refinitiv NAFTA Price Return Index|DLM|.TRXFLDUSPSVIT~DLM~en:Refinitiv United States IT Services & Consulting Price Return Index|DLM|.TRXFLDUSPT21~DLM~en:Refinitiv United States Software & IT Services-572010 Price Return Index|DLM|.TRXFLDUSPT2~DLM~en:Refinitiv United States Software & IT Services-5720 Price Return Index|DLM|.TRXFLDUSPTEC~DLM~en:Refinitiv United States Technology Price Return Index|DLM|.TRXFLDUSP~DLM~en:Refinitiv United States Price Return Index|DLM|.TRXUSPCA~DLM~en:RF SM COMBINED ALPHA US IDX|DLM|.XCI~DLM~en:ARCA COMPUT TECH|DLM|.XMI~DLM~en:ARCA MAJOR MKT|DLM|.XMI~DLM~ja-Hani:NYSE Arca主要株価指数',\n",
       "    'RCSOrganisationTypeName': 'Corporation',\n",
       "    'MnaAcquirerCount': 0,\n",
       "    'MnaSellerCount': 0,\n",
       "    'ParentOrganisationName': 'International Business Machines Corp',\n",
       "    'ImpliedVolatilityRIC': '<a:Rship name=\"x\" xmlns:a=\"http://www.reuters.com/ns/2007/10/31/webservices/SearchAndNavigation_1/NavCommonResponse_1\"><a:Entity><a:Prop name=\"RIC\" value=\"IBMATMIV.U\"/><a:Req value=\"6410\" scheme=\"IDN\"/><a:Req value=\"4018\" scheme=\"IDN\"/></a:Entity></a:Rship>',\n",
       "    'RCSFilingCountryLeafML': 'ja 米国|zh-Hans 美国|zh-Hant 美國|es Estados Unidos|fr États Unis|ko 미국|ru США',\n",
       "    'OptionsCount': 916,\n",
       "    'DocumentTitleJaKana': 'インターナショナルビジネスマシーンズコーポレーション, Public Company',\n",
       "    'RatingNameX1XRatingType': \"Issuer|Issuer/FitchX1XFTC|Issuer/FitchX1XFTC/Fitch Long-term Issuer Default RatingX1XFDL|Issuer/Egan-Jones Ratings Co.X1XEGJ|Issuer/Egan-Jones Ratings Co.X1XEGJ/Egan-Jones Commercial PaperX1XEJC|Issuer/Moody'sX1XMDY|Issuer/Moody'sX1XMDY/Moody's Commercial PaperX1XMCP|Issuer/Moody'sX1XMDY/Moody's Derived Long-term Issuer RatingX1XMDL|Issuer/Moody'sX1XMDY/Moody's Long-term Issuer RatingX1XMIS|Issuer/FitchX1XFTC/Fitch Commercial PaperX1XFCP|Issuer/Moody'sX1XMDY/Moody's Senior UnsecuredX1XMSU|Issuer/FitchX1XFTC/Fitch Short-term Issuer RatingX1XFSS|Issuer/FitchX1XFTC/Fitch Senior UnsecuredX1XFSU|Issuer/FitchX1XFTC/Fitch Long-term Senior Unsecured MTN RatingX1XFMU|Issuer/FitchX1XFTC/Fitch Short-term Debt RatingX1XFDT|Issuer/Moody'sX1XMDY/Moody's Long-term Senior Unsecured MTN RatingX1XMMU|Issuer/Moody'sX1XMDY/Moody's Most Recent Short-term RatingX1XMRS|Issuer/Egan-Jones Ratings Co.X1XEGJ/Egan-Jones Senior UnsecuredX1XEJU|Issuer/FitchX1XFTC/Fitch Short-term Issuer Default RatingX1XFDS|Issuer/FitchX1XFTC/Fitch Long-term Issuer RatingX1XFIS\",\n",
       "    'SponsorBondsExist': False,\n",
       "    'ICBSchemeName': 'Technology/Technology/Software & Computer Services/Computer Services',\n",
       "    'RCSOrganisationSubTypeGenealogy': 'M:1NJ\\\\OAOST:COR',\n",
       "    'REC': 'IBM',\n",
       "    'TRBC2012PrimaryCodeMeaning': 'Technology/Software & IT Services/Software & IT Services/IT Services & Consulting/IT Services & Consulting - NEC',\n",
       "    'RCSFilingCountryGenealogy': 'M:DQ\\\\G:AM\\\\G:6J|M:DQ\\\\G:AN\\\\G:6J|M:DH\\\\G:4\\\\G:9\\\\G:6J|M:DQ\\\\G:AQ\\\\G:6J|M:DQ\\\\G:AR\\\\G:6J|M:DQ\\\\G:AS\\\\G:6J|M:A9\\\\G:6J|M:DQ\\\\G:B9\\\\G:6J|M:1M2\\\\G:3U8\\\\G:3U9\\\\G:6J|M:DQ\\\\G:CX\\\\G:6J|M:DQ\\\\G:DE\\\\G:6J',\n",
       "    'SPsRatingX1XSPsRatingRank': 'SIS/A-1X1X2|SSU/AX1X11|SIS/A-1X1X2|SSU/AX1X11|SPI/AX1X6|SMU/AX1X11|SCP/A-1X1X2|SPI/AX1X6|SMU/NRX1X0',\n",
       "    'CompositeDescriptiveNameZh': '国际商业机器公司|国际商用机器',\n",
       "    'OrganisationType': 'CO',\n",
       "    'ICBScheme': '9533',\n",
       "    'SalesToAssets': 0.559913,\n",
       "    'UltimateParentOrganizationID': '4295904307',\n",
       "    'RCSCountryOfIncorporationLeaf': 'United States',\n",
       "    'EquitiesCount': 99,\n",
       "    'RCSOrganisationSubTypeLeafML': 'ja 法人|zh-Hans 公司',\n",
       "    'RCSPartyCountryLeaf': 'United States',\n",
       "    'CompositeDescriptiveName': 'Big Blue|Guo Ji Shang Ye Ji Qi Gong Si|Guo Ji Shang Yong Ji Qi|IBM|Intanashonaru Bijinesu Mashinzu|International Business Machines|Software Artistry Inc|Unison Software Inc INTERNATIONAL BUSINESS MACHINES CORPORATION International Business Machines Corp IBM',\n",
       "    'RevenueInterim': 17560000000,\n",
       "    'ActiveEstimatesExist': True,\n",
       "    'LegalName': 'INTERNATIONAL BUSINESS MACHINES CORPORATION',\n",
       "    'EquityDividends': -5707000000,\n",
       "    'BondsCount': 45,\n",
       "    'RCSOrganisationTypeLeaf': 'Corporation',\n",
       "    'CountryHeadquarters': 'USA',\n",
       "    'LEI': 'VGRQXHF3J8VDLUA7XE92',\n",
       "    'RCSOrganisationSubTypeName': 'OA Organization Subtype\\\\Company',\n",
       "    'CompositeDescriptiveNameJa': 'インターナショナル･ビジネス･マシーンズ･コーポレーション インターナショナルビジネスマシーンズコーポレーション いんたーなしょなるびじねすましーんずこーぽれーしょん インターナショナル・ビジネス・マシーンズ',\n",
       "    'MoodysIssuerRating': 'A2',\n",
       "    'Ebitda': 16780000000,\n",
       "    'ERRORS': ['VPIP CompanyOfficers',\n",
       "     'VPIP RCSCountryOfIncorporationGenealogy',\n",
       "     'VPIP GeneralAliasNameZhHans',\n",
       "     'VPIP CalaisAlias',\n",
       "     'VPIP GeneralAliasName',\n",
       "     'VPIP RCSFilingCountryName',\n",
       "     'VPIP RCSCountryHeadquartersName',\n",
       "     'VPIP LocalScheme',\n",
       "     'VPIP RCSCountryHeadquartersGenealogy',\n",
       "     'VPIP EquityIndices',\n",
       "     'VPIP RCSFilingCountryGenealogy']},\n",
       "   'copy_targets': {'symbol': ['18228',\n",
       "     'VGRQXHF3J8VDLUA7XE92 US4592001014 0000051143 4295904307 459200101 49EB20 IBM'],\n",
       "    'code': ['VGRQXHF3J8VDLUA7XE92 US4592001014 0000051143 4295904307 459200101 49EB20 IBM'],\n",
       "    'namezh': ['国际商业机器公司|国际商用机器'],\n",
       "    'SearchAllJa': ['事業法人',\n",
       "     'インタナショナル コーポレイション インタナショナル コーポレイション',\n",
       "     'インターナショナル･ビジネス･マシーンズ･コーポレーション インターナショナルビジネスマシーンズコーポレーション いんたーなしょなるびじねすましーんずこーぽれーしょん インターナショナル・ビジネス・マシーンズ'],\n",
       "    'RCSOriginalAccountsCurrencyGenealogy': ['C:6'],\n",
       "    'RCSOriginalAccountsCurrencyNameML': ['ja 米ドル|zh-Hans 美元|zh-Hant 美元'],\n",
       "    'name': ['internatnl INTL intrnl internatnl INTL intrnl',\n",
       "     'Big Blue|Guo Ji Shang Ye Ji Qi Gong Si|Guo Ji Shang Yong Ji Qi|IBM|Intanashonaru Bijinesu Mashinzu|International Business Machines|Software Artistry Inc|Unison Software Inc INTERNATIONAL BUSINESS MACHINES CORPORATION International Business Machines Corp IBM'],\n",
       "    'SearchAllSymbol': ['18228',\n",
       "     'VGRQXHF3J8VDLUA7XE92 US4592001014 0000051143 4295904307 459200101 49EB20 IBM'],\n",
       "    'SearchAllZh': ['公司', '国际商业机器公司|国际商用机器'],\n",
       "    'RCSOriginalAccountsCurrencyName': ['US Dollar'],\n",
       "    'nameja': ['インタナショナル コーポレイション インタナショナル コーポレイション',\n",
       "     '��ンターナショナル･ビジネス･マシーンズ･コーポレーション インターナショナルビジネスマシーンズコーポレーション いんたーなしょなるびじねすましーんずこーぽれーしょん インターナショナル・ビジネス・マシーンズ'],\n",
       "    'SearchAllText': ['internatnl INTL intrnl internatnl INTL intrnl',\n",
       "     'IT Services & Consulting (NEC) ORGANISATION Corporation Listed',\n",
       "     'Big Blue|Guo Ji Shang Ye Ji Qi Gong Si|Guo Ji Shang Yong Ji Qi|IBM|Intanashonaru Bijinesu Mashinzu|International Business Machines|Software Artistry Inc|Unison Software Inc INTERNATIONAL BUSINESS MACHINES CORPORATION International Business Machines Corp IBM']}}]}"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Query for all documents with the company IBM defined\n",
    "response=rdp.Search.search(\n",
    "    query = \"IBM\",\n",
    "    top = 1,    # Note: It is critical you select a top=1 because the amount of data returned is very large.\n",
    "    select = \"_debugall\"\n",
    ")\n",
    "response.data.raw"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Understanding values using Navigators\n",
    "Using the output from a debugging session, there are a number of common properties that are very useful when filtering your search.  For example, you may want to filter your results based on a specific category of data.  Using navigators will help us understand these categories.\n",
    "\n",
    "Looking at our debug output above, one useful property: **SearchAllCategoryv3** will helps us understand all available categories of documents the query term 'IBM' was found.  To list these categories, use the following:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'Label': 'Other Quote', 'Count': 24448},\n",
       " {'Label': 'Warrants', 'Count': 6513},\n",
       " {'Label': 'Bond Pricing', 'Count': 2038},\n",
       " {'Label': 'Bonds', 'Count': 1414},\n",
       " {'Label': 'Commercial Papers', 'Count': 1282},\n",
       " {'Label': 'Options', 'Count': 1004},\n",
       " {'Label': 'Companies/Issuers', 'Count': 775},\n",
       " {'Label': 'Futures', 'Count': 751},\n",
       " {'Label': 'Mergers & Acquisitions', 'Count': 716},\n",
       " {'Label': 'Equities', 'Count': 496},\n",
       " {'Label': 'Credit Default Swaps', 'Count': 463},\n",
       " {'Label': 'Analyst', 'Count': 237},\n",
       " {'Label': 'Officers', 'Count': 176},\n",
       " {'Label': 'FX & Money', 'Count': 66},\n",
       " {'Label': 'Fixed Income Curves', 'Count': 48},\n",
       " {'Label': 'Other Instrument', 'Count': 23},\n",
       " {'Label': 'Mortgage Backed Securities', 'Count': 12},\n",
       " {'Label': 'Funds', 'Count': 10},\n",
       " {'Label': 'People', 'Count': 7},\n",
       " {'Label': 'CMO & ABS', 'Count': 5},\n",
       " {'Label': 'Loans', 'Count': 5},\n",
       " {'Label': 'Buy Side Contact', 'Count': 4},\n",
       " {'Label': 'Fund Manager', 'Count': 4},\n",
       " {'Label': 'ABS & CMO', 'Count': 2},\n",
       " {'Label': 'Commodities Physical Assets', 'Count': 2},\n",
       " {'Label': 'Commodities', 'Count': 1},\n",
       " {'Label': 'Indices', 'Count': 1}]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "response=rdp.Search.search(\n",
    "    query = \"IBM\",\n",
    "    top = 0,\n",
    "    navigators = \"SearchAllCategoryv3\"\n",
    ")\n",
    "response.data.raw[\"Navigators\"][\"SearchAllCategoryv3\"][\"Buckets\"]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Using the above listing, we can narrow our result set based on these categories using a Filter."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Special Properties\n",
    "The Search service includes a number of special properties that enhance the ability to find meaningful results. In addition to the special property *_debugall* used within the **select** parameter as outlined above, the following properties are available: "
   ]
  },
  {
   "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>PermID</th>\n",
       "      <th>PI</th>\n",
       "      <th>DocumentTitle</th>\n",
       "      <th>RIC</th>\n",
       "      <th>BusinessEntity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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",
       "      <td>ORGANISATION</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>55839165994</td>\n",
       "      <td>1097326</td>\n",
       "      <td>International Business Machines Corp, Ordinary Share, NYSE Consolidated</td>\n",
       "      <td>IBM</td>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>21475739068</td>\n",
       "      <td>79345498</td>\n",
       "      <td>International Business Machines Corp, Ordinary Share, MiFID Composite Cross Market Service</td>\n",
       "      <td>IBMEUR.xbo</td>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>55838283585</td>\n",
       "      <td>1006058</td>\n",
       "      <td>International Business Machines Corp, Depository Receipt, Bolsa de Comercio de Buenos Aires</td>\n",
       "      <td>IBM.BA</td>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>55838323096</td>\n",
       "      <td>1090370</td>\n",
       "      <td>International Business Machines Corp, Ordinary Share, New York Stock Exchange</td>\n",
       "      <td>IBM.N</td>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>55835333953</td>\n",
       "      <td>765744</td>\n",
       "      <td>International Business Machines Corp, Ordinary Share, NASDAQ INTERMARKET</td>\n",
       "      <td>IBM.TH</td>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>55837129318</td>\n",
       "      <td>753753</td>\n",
       "      <td>International Business Machines Corp, Ordinary Share, NYSE Arca</td>\n",
       "      <td>IBM.P</td>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>55845629228</td>\n",
       "      <td>53703996</td>\n",
       "      <td>International Business Machines Corp, Ordinary Share, Cboe BZX Exchange</td>\n",
       "      <td>IBM.Z</td>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>55836444333</td>\n",
       "      <td>722691</td>\n",
       "      <td>International Business Machines Corp, Ordinary Share, Frankfurt Stock Exchange</td>\n",
       "      <td>IBM.F</td>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>21475059739</td>\n",
       "      <td>73533774</td>\n",
       "      <td>International Business Machines Corp, Ordinary Share, Cboe EDGX Exchange</td>\n",
       "      <td>IBM.DG</td>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        PermID        PI  \\\n",
       "0         <NA>     37036   \n",
       "1  55839165994   1097326   \n",
       "2  21475739068  79345498   \n",
       "3  55838283585   1006058   \n",
       "4  55838323096   1090370   \n",
       "5  55835333953    765744   \n",
       "6  55837129318    753753   \n",
       "7  55845629228  53703996   \n",
       "8  55836444333    722691   \n",
       "9  21475059739  73533774   \n",
       "\n",
       "                                                                                 DocumentTitle  \\\n",
       "0                                         International Business Machines Corp, Public Company   \n",
       "1                      International Business Machines Corp, Ordinary Share, NYSE Consolidated   \n",
       "2   International Business Machines Corp, Ordinary Share, MiFID Composite Cross Market Service   \n",
       "3  International Business Machines Corp, Depository Receipt, Bolsa de Comercio de Buenos Aires   \n",
       "4                International Business Machines Corp, Ordinary Share, New York Stock Exchange   \n",
       "5                     International Business Machines Corp, Ordinary Share, NASDAQ INTERMARKET   \n",
       "6                              International Business Machines Corp, Ordinary Share, NYSE Arca   \n",
       "7                      International Business Machines Corp, Ordinary Share, Cboe BZX Exchange   \n",
       "8               International Business Machines Corp, Ordinary Share, Frankfurt Stock Exchange   \n",
       "9                     International Business Machines Corp, Ordinary Share, Cboe EDGX Exchange   \n",
       "\n",
       "          RIC BusinessEntity  \n",
       "0        <NA>   ORGANISATION  \n",
       "1         IBM   QUOTExEQUITY  \n",
       "2  IBMEUR.xbo   QUOTExEQUITY  \n",
       "3      IBM.BA   QUOTExEQUITY  \n",
       "4       IBM.N   QUOTExEQUITY  \n",
       "5      IBM.TH   QUOTExEQUITY  \n",
       "6       IBM.P   QUOTExEQUITY  \n",
       "7       IBM.Z   QUOTExEQUITY  \n",
       "8       IBM.F   QUOTExEQUITY  \n",
       "9      IBM.DG   QUOTExEQUITY  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# The 'code' specification will search across all codes, such as RICs, tickers, SEDOLs etc.  \n",
    "# Primarily used within a filter but can be used as a selectable property.\n",
    "rdp.search(\n",
    "    filter = \"code eq 'IBM'\"\n",
    ")"
   ]
  },
  {
   "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>PermID</th>\n",
       "      <th>PI</th>\n",
       "      <th>DocumentTitle</th>\n",
       "      <th>RIC</th>\n",
       "      <th>BusinessEntity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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",
       "      <td>ORGANISATION</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>55839165994</td>\n",
       "      <td>1097326</td>\n",
       "      <td>International Business Machines Corp, Ordinary Share, NYSE Consolidated</td>\n",
       "      <td>IBM</td>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\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",
       "      <td>ORGANISATION</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\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",
       "      <td>ORGS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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",
       "      <td>ORGANISATION</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\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",
       "      <td>ORGANISATION</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>21481052421</td>\n",
       "      <td>48924732</td>\n",
       "      <td>Eurex International Business Machines Equity Future Chain Contract , Equity Future, USD, Eurex</td>\n",
       "      <td>0#IBMF:</td>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>21612423771</td>\n",
       "      <td>259118763</td>\n",
       "      <td>Euronext Amsterdam IBM Dividend Future Chain Contracts, Equity Future, USD, Euronext Amsterdam</td>\n",
       "      <td>0#IBMDF:</td>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>21481052892</td>\n",
       "      <td>49450681</td>\n",
       "      <td>Eurex International Business Machines Equity Future Continuation 1, Equity Future, USD, Eurex</td>\n",
       "      <td>IBMFc1</td>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>21481053949</td>\n",
       "      <td>50092347</td>\n",
       "      <td>Eurex International Business Machines Equity Future Continuation 2, Equity Future, USD, Eurex</td>\n",
       "      <td>IBMFc2</td>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        PermID          PI  \\\n",
       "0         <NA>       37036   \n",
       "1  55839165994     1097326   \n",
       "2         <NA>       99244   \n",
       "3         <NA>  4297694029   \n",
       "4         <NA>    18062670   \n",
       "5         <NA>    27968389   \n",
       "6  21481052421    48924732   \n",
       "7  21612423771   259118763   \n",
       "8  21481052892    49450681   \n",
       "9  21481053949    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",
       "        RIC BusinessEntity  \n",
       "0      <NA>   ORGANISATION  \n",
       "1       IBM   QUOTExEQUITY  \n",
       "2      <NA>   ORGANISATION  \n",
       "3      <NA>           ORGS  \n",
       "4      <NA>   ORGANISATION  \n",
       "5      <NA>   ORGANISATION  \n",
       "6   0#IBMF:   QUOTExEQUITY  \n",
       "7  0#IBMDF:   QUOTExEQUITY  \n",
       "8    IBMFc1   QUOTExEQUITY  \n",
       "9    IBMFc2   QUOTExEQUITY  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# The 'name' specification will search across all names, such as common name, legal name, issuer name, etc. \n",
    "# Primarily used within a filter but can be used as a selectable property.\n",
    "rdp.search(\n",
    "    filter = \"name eq 'IBM'\",\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>PermID</th>\n",
       "      <th>PI</th>\n",
       "      <th>DocumentTitle</th>\n",
       "      <th>RIC</th>\n",
       "      <th>SearchAllCategoryv3</th>\n",
       "      <th>BusinessEntity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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",
       "      <td>Companies/Issuers</td>\n",
       "      <td>ORGANISATION</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>55839165994</td>\n",
       "      <td>1097326</td>\n",
       "      <td>International Business Machines Corp, Ordinary Share, NYSE Consolidated</td>\n",
       "      <td>IBM</td>\n",
       "      <td>Equities</td>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\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",
       "      <td>Companies/Issuers</td>\n",
       "      <td>ORGANISATION</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\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",
       "      <td>Companies/Issuers</td>\n",
       "      <td>ORGS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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",
       "      <td>Companies/Issuers</td>\n",
       "      <td>ORGANISATION</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>21788990768</td>\n",
       "      <td>483772175</td>\n",
       "      <td>OPRA International Business Machines Equity Option 140 Put Feb 2021 , Equity Cash Option, Put 140 USD 05-Feb-2021, OPRA</td>\n",
       "      <td>IBMN052114000.U</td>\n",
       "      <td>Options</td>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>21788990802</td>\n",
       "      <td>483772209</td>\n",
       "      <td>OPRA International Business Machines Equity Option 100 Put Feb 2021 , Equity Cash Option, Put 100 USD 05-Feb-2021, OPRA</td>\n",
       "      <td>IBMN052110000.U</td>\n",
       "      <td>Options</td>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>21788990869</td>\n",
       "      <td>483772275</td>\n",
       "      <td>OPRA International Business Machines Equity Option 140 Call Feb 2021 , Equity Cash Option, Call 140 USD 05-Feb-2021, OPRA</td>\n",
       "      <td>IBMB052114000.U</td>\n",
       "      <td>Options</td>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>21788990957</td>\n",
       "      <td>483772362</td>\n",
       "      <td>OPRA International Business Machines Equity Option 145 Call Feb 2021 , Equity Cash Option, Call 145 USD 05-Feb-2021, OPRA</td>\n",
       "      <td>IBMB052114500.U</td>\n",
       "      <td>Options</td>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>21788991201</td>\n",
       "      <td>483772606</td>\n",
       "      <td>OPRA International Business Machines Equity Option 145 Put Feb 2021 , Equity Cash Option, Put 145 USD 05-Feb-2021, OPRA</td>\n",
       "      <td>IBMN052114500.U</td>\n",
       "      <td>Options</td>\n",
       "      <td>QUOTExEQUITY</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          PermID          PI  \\\n",
       "0           <NA>       37036   \n",
       "1    55839165994     1097326   \n",
       "2           <NA>       99244   \n",
       "3           <NA>  4297694029   \n",
       "4           <NA>    18062670   \n",
       "..           ...         ...   \n",
       "995  21788990768   483772175   \n",
       "996  21788990802   483772209   \n",
       "997  21788990869   483772275   \n",
       "998  21788990957   483772362   \n",
       "999  21788991201   483772606   \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",
       "..                                                                                                                         ...   \n",
       "995    OPRA International Business Machines Equity Option 140 Put Feb 2021 , Equity Cash Option, Put 140 USD 05-Feb-2021, OPRA   \n",
       "996    OPRA International Business Machines Equity Option 100 Put Feb 2021 , Equity Cash Option, Put 100 USD 05-Feb-2021, OPRA   \n",
       "997  OPRA International Business Machines Equity Option 140 Call Feb 2021 , Equity Cash Option, Call 140 USD 05-Feb-2021, OPRA   \n",
       "998  OPRA International Business Machines Equity Option 145 Call Feb 2021 , Equity Cash Option, Call 145 USD 05-Feb-2021, OPRA   \n",
       "999    OPRA International Business Machines Equity Option 145 Put Feb 2021 , Equity Cash Option, Put 145 USD 05-Feb-2021, OPRA   \n",
       "\n",
       "                 RIC SearchAllCategoryv3 BusinessEntity  \n",
       "0               <NA>   Companies/Issuers   ORGANISATION  \n",
       "1                IBM            Equities   QUOTExEQUITY  \n",
       "2               <NA>   Companies/Issuers   ORGANISATION  \n",
       "3               <NA>   Companies/Issuers           ORGS  \n",
       "4               <NA>   Companies/Issuers   ORGANISATION  \n",
       "..               ...                 ...            ...  \n",
       "995  IBMN052114000.U             Options   QUOTExEQUITY  \n",
       "996  IBMN052110000.U             Options   QUOTExEQUITY  \n",
       "997  IBMB052114000.U             Options   QUOTExEQUITY  \n",
       "998  IBMB052114500.U             Options   QUOTExEQUITY  \n",
       "999  IBMN052114500.U             Options   QUOTExEQUITY  \n",
       "\n",
       "[1000 rows x 6 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# The special character underscore (_) is a convenient token that can be used to select the default Properties.  \n",
    "# This will allow users to quickly select the default values plus any other properties when testing out your search.\n",
    "rdp.search(\n",
    "    query = \"IBM\",\n",
    "    top = 1000,\n",
    "    select = \"_, SearchAllCategoryv3\"\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Common Properties\n",
    "As you become more familiar with search, you will soon recognize there will be a number of very useful properties that will act as your \"go-tos\" when filtering or selecting fields."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>DTSource</th>\n",
       "      <th>DTCharacteristics</th>\n",
       "      <th>DTSubjectName</th>\n",
       "      <th>DTSimpleType</th>\n",
       "      <th>DocumentTitle</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>International Business Machines Corp</td>\n",
       "      <td>Public Company</td>\n",
       "      <td>International Business Machines Corp, Public Company</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NYSE Consolidated</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>International Business Machines Corp</td>\n",
       "      <td>Ordinary Share</td>\n",
       "      <td>International Business Machines Corp, Ordinary Share, NYSE Consolidated</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>IBM Credit LLC</td>\n",
       "      <td>Private Company</td>\n",
       "      <td>IBM Credit LLC, Private Company</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>IBM Retirement Fund Trust</td>\n",
       "      <td>Private Company</td>\n",
       "      <td>IBM Retirement Fund Trust, Private Company</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>Tiers Corporate Bond Backed Certificates Trust Series Ibm 1997 4</td>\n",
       "      <td>Private Company</td>\n",
       "      <td>Tiers Corporate Bond Backed Certificates Trust Series Ibm 1997 4, Private Company</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>OPRA</td>\n",
       "      <td>Put 128 USD 08-Jan-2021</td>\n",
       "      <td>OPRA International Business Machines Equity Option 128 Put Jan 2021</td>\n",
       "      <td>Equity Cash Option</td>\n",
       "      <td>OPRA International Business Machines Equity Option 128 Put Jan 2021 , Equity Cash Option, Put 128 USD 08-Jan-2021, OPRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>OPRA</td>\n",
       "      <td>Put 127 USD 22-Jan-2021</td>\n",
       "      <td>OPRA International Business Machines Equity Option 127 Put Jan 2021</td>\n",
       "      <td>Equity Cash Option</td>\n",
       "      <td>OPRA International Business Machines Equity Option 127 Put Jan 2021 , Equity Cash Option, Put 127 USD 22-Jan-2021, OPRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>OPRA</td>\n",
       "      <td>Call 127 USD 22-Jan-2021</td>\n",
       "      <td>OPRA International Business Machines Equity Option 127 Call Jan 2021</td>\n",
       "      <td>Equity Cash Option</td>\n",
       "      <td>OPRA International Business Machines Equity Option 127 Call Jan 2021 , Equity Cash Option, Call 127 USD 22-Jan-2021, OPRA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>NYSE Arca</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>International Business Machines Corp</td>\n",
       "      <td>Ordinary Share</td>\n",
       "      <td>International Business Machines Corp, Ordinary Share, NYSE Arca</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>Corts Trust Iv For Ibm Debentures</td>\n",
       "      <td>Private Company</td>\n",
       "      <td>Corts Trust Iv For Ibm Debentures, Private Company</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             DTSource         DTCharacteristics  \\\n",
       "0                <NA>                      <NA>   \n",
       "1   NYSE Consolidated                      <NA>   \n",
       "2                <NA>                      <NA>   \n",
       "3                <NA>                      <NA>   \n",
       "4                <NA>                      <NA>   \n",
       "..                ...                       ...   \n",
       "95               OPRA   Put 128 USD 08-Jan-2021   \n",
       "96               OPRA   Put 127 USD 22-Jan-2021   \n",
       "97               OPRA  Call 127 USD 22-Jan-2021   \n",
       "98          NYSE Arca                      <NA>   \n",
       "99               <NA>                      <NA>   \n",
       "\n",
       "                                                           DTSubjectName  \\\n",
       "0                                   International Business Machines Corp   \n",
       "1                                   International Business Machines Corp   \n",
       "2                                                         IBM Credit LLC   \n",
       "3                                              IBM Retirement Fund Trust   \n",
       "4       Tiers Corporate Bond Backed Certificates Trust Series Ibm 1997 4   \n",
       "..                                                                   ...   \n",
       "95   OPRA International Business Machines Equity Option 128 Put Jan 2021   \n",
       "96   OPRA International Business Machines Equity Option 127 Put Jan 2021   \n",
       "97  OPRA International Business Machines Equity Option 127 Call Jan 2021   \n",
       "98                                  International Business Machines Corp   \n",
       "99                                     Corts Trust Iv For Ibm Debentures   \n",
       "\n",
       "          DTSimpleType  \\\n",
       "0       Public Company   \n",
       "1       Ordinary Share   \n",
       "2      Private Company   \n",
       "3      Private Company   \n",
       "4      Private Company   \n",
       "..                 ...   \n",
       "95  Equity Cash Option   \n",
       "96  Equity Cash Option   \n",
       "97  Equity Cash Option   \n",
       "98      Ordinary Share   \n",
       "99     Private Company   \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",
       "..                                                                                                                        ...  \n",
       "95    OPRA International Business Machines Equity Option 128 Put Jan 2021 , Equity Cash Option, Put 128 USD 08-Jan-2021, OPRA  \n",
       "96    OPRA International Business Machines Equity Option 127 Put Jan 2021 , Equity Cash Option, Put 127 USD 22-Jan-2021, OPRA  \n",
       "97  OPRA International Business Machines Equity Option 127 Call Jan 2021 , Equity Cash Option, Call 127 USD 22-Jan-2021, OPRA  \n",
       "98                                                            International Business Machines Corp, Ordinary Share, NYSE Arca  \n",
       "99                                                                         Corts Trust Iv For Ibm Debentures, Private Company  \n",
       "\n",
       "[100 rows x 5 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# DocumentTitle\n",
    "# As you've seen in some of the above output, this property is on by default when you want to display your search results.  \n",
    "# The DocumentTitle property is a quick way to describe the content retrieved for each matching document.  \n",
    "# It is made up of the following child properties: \n",
    "#    'DTSubjectName', 'DTSimpleType', 'DTSource', and 'DTCharacteristics'.\n",
    "rdp.search(\n",
    "    query = \"IBM\",\n",
    "    top = 100,\n",
    "    select = \"DocumentTitle, DTSubjectName, DTSimpleType, DTSource, DTCharacteristics\"\n",
    ")"
   ]
  },
  {
   "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>BusinessEntity</th>\n",
       "      <th>DocumentTitle</th>\n",
       "      <th>PI</th>\n",
       "      <th>PermID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>PERSON</td>\n",
       "      <td>John Denham - IsUnknown</td>\n",
       "      <td>34414661717</td>\n",
       "      <td>34414661717</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>PERSON</td>\n",
       "      <td>Charlie Maxfield - IsUnknown</td>\n",
       "      <td>34414669683</td>\n",
       "      <td>34414669683</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>PERSON</td>\n",
       "      <td>Claudia Barclay - IsUnknown</td>\n",
       "      <td>34414721056</td>\n",
       "      <td>34414721056</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>PERSON</td>\n",
       "      <td>Robert Ploder - IsUnknown</td>\n",
       "      <td>34414738667</td>\n",
       "      <td>34414738667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>PERSON</td>\n",
       "      <td>Tom Cadigan - IsUnknown</td>\n",
       "      <td>34414743082</td>\n",
       "      <td>34414743082</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>PERSON</td>\n",
       "      <td>R. L. Jay Vivian - IsUnknown</td>\n",
       "      <td>34414808510</td>\n",
       "      <td>34414808510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>PERSON</td>\n",
       "      <td>William E. Baker - IsUnknown</td>\n",
       "      <td>34415092341</td>\n",
       "      <td>34415092341</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  BusinessEntity                 DocumentTitle           PI       PermID\n",
       "0         PERSON       John Denham - IsUnknown  34414661717  34414661717\n",
       "1         PERSON  Charlie Maxfield - IsUnknown  34414669683  34414669683\n",
       "2         PERSON   Claudia Barclay - IsUnknown  34414721056  34414721056\n",
       "3         PERSON     Robert Ploder - IsUnknown  34414738667  34414738667\n",
       "4         PERSON       Tom Cadigan - IsUnknown  34414743082  34414743082\n",
       "5         PERSON  R. L. Jay Vivian - IsUnknown  34414808510  34414808510\n",
       "6         PERSON  William E. Baker - IsUnknown  34415092341  34415092341"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# SearchAllCategoryv3\n",
    "# When trying to narrow down your search to specific categories, this property can be extremely useful.  \n",
    "# When you apply a Navigator on this property, it will return a list of ~40 categories, depending on the view. \n",
    "# Categories include asset-related instruments such as:\n",
    "#     'Equities', 'Futures' , 'Options', 'Bonds', 'Commodities' \n",
    "#     but can also include things like: 'People', 'Analyst', 'Officers'.\n",
    "rdp.search(\n",
    "    query = \"IBM\",\n",
    "    filter = \"SearchAllCategoryv3 eq 'People'\",\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>SEDOL</th>\n",
       "      <th>DocumentTitle</th>\n",
       "      <th>RIC</th>\n",
       "      <th>ISIN</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BF4SNM7</td>\n",
       "      <td>AstraZeneca PLC, Plain Vanilla Fixed Coupon Bond, TRACE Eligible AZN 2.375 12-Jun-2022</td>\n",
       "      <td>046353AQ1=</td>\n",
       "      <td>US046353AQ14</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     SEDOL  \\\n",
       "0  BF4SNM7   \n",
       "\n",
       "                                                                            DocumentTitle  \\\n",
       "0  AstraZeneca PLC, Plain Vanilla Fixed Coupon Bond, TRACE Eligible AZN 2.375 12-Jun-2022   \n",
       "\n",
       "          RIC          ISIN  \n",
       "0  046353AQ1=  US046353AQ14  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# CodeResolutionBase\n",
    "# Represents the most significant codes defined within the document.  For example, when searching for a symbol such \n",
    "# as ISIN, SEDOL, RIC, etc, filtering against this property will significantly reduce the matches and only bring \n",
    "# back the most relevant results.\n",
    "rdp.search(\n",
    "    filter = \"CodeResolutionBase eq 'US046353AQ14'\",\n",
    "    select = \"DocumentTitle, ISIN, SEDOL, RIC\"\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>SEDOL</th>\n",
       "      <th>DocumentTitle</th>\n",
       "      <th>RIC</th>\n",
       "      <th>ISIN</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BF4SNM7</td>\n",
       "      <td>AstraZeneca PLC, Plain Vanilla Fixed Coupon Bond, TRACE Eligible AZN 2.375 12-Jun-2022</td>\n",
       "      <td>046353AQ1=</td>\n",
       "      <td>US046353AQ14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BF4SNM7</td>\n",
       "      <td>AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, MARKETAXESS L2</td>\n",
       "      <td>046353AQ1=2M</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BF4SNM7</td>\n",
       "      <td>AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, CREDIT SUISSE TRADEWEB PRICE</td>\n",
       "      <td>US046353AQ14=CSTW</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BF4SNM7</td>\n",
       "      <td>AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, MARKETAXESS COMPOSITE PLUS</td>\n",
       "      <td>US046353AQ14=MKCP</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BF4SNM7</td>\n",
       "      <td>AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, TDS TRADEWEB PRICE</td>\n",
       "      <td>US046353AQ14=TDTW</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>BF4SNM7</td>\n",
       "      <td>AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, TRADEWEB</td>\n",
       "      <td>US046353AQ14=TE</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>BF4SNM7</td>\n",
       "      <td>AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, TRADEWEB</td>\n",
       "      <td>046353AQ1=TWEB</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>BF4SNM7</td>\n",
       "      <td>AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, GFI GROUP</td>\n",
       "      <td>US046353AQ14=GFGL</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>BF4SNM7</td>\n",
       "      <td>AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, MARKETAXESS AXESSALL</td>\n",
       "      <td>US046353AQ14=MKAX</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>BF4SNM7</td>\n",
       "      <td>AstraZeneca PLC, Bond Quote, TRACE Eligible AZN 2.375 12-Jun-2022, TWEB EUCR MARKS</td>\n",
       "      <td>US046353AQ14=TEMK</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     SEDOL  \\\n",
       "0  BF4SNM7   \n",
       "1  BF4SNM7   \n",
       "2  BF4SNM7   \n",
       "3  BF4SNM7   \n",
       "4  BF4SNM7   \n",
       "5  BF4SNM7   \n",
       "6  BF4SNM7   \n",
       "7  BF4SNM7   \n",
       "8  BF4SNM7   \n",
       "9  BF4SNM7   \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",
       "                 RIC          ISIN  \n",
       "0         046353AQ1=  US046353AQ14  \n",
       "1       046353AQ1=2M          <NA>  \n",
       "2  US046353AQ14=CSTW          <NA>  \n",
       "3  US046353AQ14=MKCP          <NA>  \n",
       "4  US046353AQ14=TDTW          <NA>  \n",
       "5    US046353AQ14=TE          <NA>  \n",
       "6     046353AQ1=TWEB          <NA>  \n",
       "7  US046353AQ14=GFGL          <NA>  \n",
       "8  US046353AQ14=MKAX          <NA>  \n",
       "9  US046353AQ14=TEMK          <NA>  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Conversely, if we were to choose the more generic term 'code', would result in a wider range of matches.\n",
    "rdp.search(\n",
    "    filter = \"code eq 'US046353AQ14'\",\n",
    "    select = \"DocumentTitle, ISIN, SEDOL, RIC\"\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Common Properties - RCS (Reuters Classification Scheme)\n",
    "Throughout many documents, you will notice a number of RCS fields that are popular when selecting and filtering.\n",
    "\n",
    "*Note* - I'll use navigators to demonstrate the values of these common properties."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'Label': 'Barrier Warrant', 'Count': 15864353},\n",
       " {'Label': 'Bond', 'Count': 13681973},\n",
       " {'Label': 'Commodity Future', 'Count': 4563437},\n",
       " {'Label': 'Traditional Warrant', 'Count': 3605593},\n",
       " {'Label': 'Equity Cash Option', 'Count': 3154392},\n",
       " {'Label': 'Commodity Future Option', 'Count': 3080616},\n",
       " {'Label': 'Commodity Spread', 'Count': 2704910},\n",
       " {'Label': 'Equity Future', 'Count': 2675699},\n",
       " {'Label': 'Certificate of Deposit', 'Count': 2642695},\n",
       " {'Label': 'Mortgage-Backed Security', 'Count': 2614772},\n",
       " {'Label': 'Interest Rate Future Spread', 'Count': 2610354},\n",
       " {'Label': 'Commercial Paper', 'Count': 2005020},\n",
       " {'Label': 'Commodity Spot', 'Count': 1795525},\n",
       " {'Label': 'Ordinary Share', 'Count': 1625025},\n",
       " {'Label': 'Commodity Forward', 'Count': 1512966},\n",
       " {'Label': 'Buffered Risk / Bonus Certificate', 'Count': 1319090},\n",
       " {'Label': 'Commodity Cash Option', 'Count': 1274582},\n",
       " {'Label': 'Open-End Fund', 'Count': 1180139},\n",
       " {'Label': 'Warrant', 'Count': 1132918},\n",
       " {'Label': 'Investment Certificate', 'Count': 927468}]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# RCSAssetCategoryLeaf\n",
    "# Specific to assets, this property will categorize the results into a readable identifier such as: 'Bond', \n",
    "# 'Commodity Future', 'Commercial Paper', etc.  Where the property SearchAllCategoryv3 provides general categories, \n",
    "# this property will be more specific to assets.  Pull out the top 10.\n",
    "response = rdp.Search.search(\n",
    "    top = 0,\n",
    "    navigators = \"RCSAssetCategoryLeaf(buckets:20)\"\n",
    ")\n",
    "response.data.raw[\"Navigators\"][\"RCSAssetCategoryLeaf\"][\"Buckets\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'Label': 'United States', 'Count': 11886196},\n",
       " {'Label': 'Eurobond Market', 'Count': 3625919},\n",
       " {'Label': 'Colombia', 'Count': 1261857},\n",
       " {'Label': 'China (Mainland)', 'Count': 1246430},\n",
       " {'Label': 'South Korea', 'Count': 536071},\n",
       " {'Label': 'Germany', 'Count': 470564},\n",
       " {'Label': 'Canada', 'Count': 375648},\n",
       " {'Label': 'France', 'Count': 222344},\n",
       " {'Label': 'India', 'Count': 186745},\n",
       " {'Label': 'Japan', 'Count': 156828},\n",
       " {'Label': 'Chile', 'Count': 152510},\n",
       " {'Label': 'Italy', 'Count': 135912},\n",
       " {'Label': 'Australia', 'Count': 87386},\n",
       " {'Label': 'Switzerland', 'Count': 59324},\n",
       " {'Label': 'Spain', 'Count': 58929},\n",
       " {'Label': 'Russia', 'Count': 57523},\n",
       " {'Label': 'Austria', 'Count': 55512},\n",
       " {'Label': 'Norway', 'Count': 53510},\n",
       " {'Label': 'United Kingdom', 'Count': 50883},\n",
       " {'Label': 'Malaysia', 'Count': 49862}]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# RCSCountryLeaf\n",
    "# RCSIssuerCountryLeaf\n",
    "# RCSExchangeCountryLeaf\n",
    "# Specific to some assets, will allow you to narrow your search to focus on a specific country.  Pull out the top 20.\n",
    "response = rdp.Search.search(\n",
    "    top = 0,\n",
    "    navigators = \"RCSCountryLeaf(buckets:20)\"\n",
    ")\n",
    "response.data.raw[\"Navigators\"][\"RCSCountryLeaf\"][\"Buckets\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'Label': 'US Dollar', 'Count': 32045392},\n",
       " {'Label': 'Euro', 'Count': 29382601},\n",
       " {'Label': 'Chinese Yuan', 'Count': 2075556},\n",
       " {'Label': 'US Cent', 'Count': 1649531},\n",
       " {'Label': 'Colombian Peso', 'Count': 1435036},\n",
       " {'Label': 'Japanese Yen', 'Count': 1001296},\n",
       " {'Label': 'Hong Kong Dollar', 'Count': 869821},\n",
       " {'Label': 'Canadian Dollar', 'Count': 854063},\n",
       " {'Label': 'Swiss Franc', 'Count': 772215},\n",
       " {'Label': 'Swedish Krona', 'Count': 745436},\n",
       " {'Label': 'Indian Rupee', 'Count': 730009},\n",
       " {'Label': 'British Pound', 'Count': 727956},\n",
       " {'Label': 'Korean (South) Won', 'Count': 704452},\n",
       " {'Label': 'Australian Dollar', 'Count': 438773},\n",
       " {'Label': 'British Penny', 'Count': 436884},\n",
       " {'Label': 'Hungarian Forint', 'Count': 344813},\n",
       " {'Label': 'Norwegian Krone', 'Count': 325879},\n",
       " {'Label': 'South African Rand', 'Count': 275789},\n",
       " {'Label': 'Turkish Lira', 'Count': 239867},\n",
       " {'Label': 'Taiwanese Dollar', 'Count': 238238}]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# RCSCurrencyLeaf\n",
    "# Specific to some assets, will allow you to narrow your search to focus on a specific currency.  Just pull out the top 20.\n",
    "response = rdp.Search.search(\n",
    "    top = 0,\n",
    "    navigators = \"RCSCurrencyLeaf(buckets:20)\"\n",
    ")\n",
    "response.data.raw[\"Navigators\"][\"RCSCurrencyLeaf\"][\"Buckets\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'Label': 'Banks (NEC)', 'Count': 3688516},\n",
       " {'Label': 'Corporate Financial Services (NEC)', 'Count': 2816443},\n",
       " {'Label': 'Corporate Banks', 'Count': 1649937},\n",
       " {'Label': 'Retail & Mortgage Banks', 'Count': 1274749},\n",
       " {'Label': 'Public Finance Activities', 'Count': 900226},\n",
       " {'Label': 'Investment Banking & Brokerage Services (NEC)', 'Count': 599195},\n",
       " {'Label': 'Consumer Lending (NEC)', 'Count': 379218},\n",
       " {'Label': 'Investment Management & Fund Operators (NEC)', 'Count': 354486},\n",
       " {'Label': 'Electric Utilities (NEC)', 'Count': 286029},\n",
       " {'Label': 'Investment Holding Companies (NEC)', 'Count': 277534},\n",
       " {'Label': 'Diversified Investment Services', 'Count': 263421},\n",
       " {'Label': 'Wealth Management', 'Count': 250728},\n",
       " {'Label': 'Construction & Engineering (NEC)', 'Count': 241926},\n",
       " {'Label': 'Real Estate Rental, Development & Operations (NEC)',\n",
       "  'Count': 238710},\n",
       " {'Label': 'Compliance & Investor Communication', 'Count': 226743},\n",
       " {'Label': 'Business Support Services (NEC)', 'Count': 202788},\n",
       " {'Label': 'Building Contractors', 'Count': 197167},\n",
       " {'Label': 'Financial & Commodity Market Operators & Service Providers (NEC)',\n",
       "  'Count': 180377},\n",
       " {'Label': 'UK Investment Trusts', 'Count': 160932},\n",
       " {'Label': 'Management Consulting Services', 'Count': 154123}]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# RCSTRBC2012Leaf\n",
    "# Represents the industry sector.  For example, if I query for Apple Computers, I will get many different industry sectors such as: \n",
    "# 'Computer Hardware (NEC)', 'Laptop & Desktop Computers', 'Phones & Smart Phones', etc.\n",
    "response = rdp.Search.search(\n",
    "    top = 0,\n",
    "    navigators = \"RCSTRBC2012Leaf(buckets:20)\"\n",
    ")\n",
    "response.data.raw[\"Navigators\"][\"RCSTRBC2012Leaf\"][\"Buckets\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Total': 6674722,\n",
       " 'Hits': [],\n",
       " 'Navigators': {'RCSTRBC2012Genealogy': {'Buckets': [{'Label': 'B:261\\\\B:262\\\\B:127\\\\B:128\\\\B:1615',\n",
       "     'Count': 3660697},\n",
       "    {'Label': 'B:261\\\\B:262\\\\B:127\\\\B:128\\\\B:1616', 'Count': 1633629},\n",
       "    {'Label': 'B:261\\\\B:262\\\\B:127\\\\B:128\\\\B:1617', 'Count': 1265972},\n",
       "    {'Label': 'B:261\\\\B:262\\\\B:127\\\\B:128\\\\B:1619', 'Count': 35446},\n",
       "    {'Label': 'B:261\\\\B:262\\\\B:127\\\\B:131\\\\B:1629', 'Count': 20039},\n",
       "    {'Label': 'B:261\\\\B:262\\\\B:263\\\\B:207\\\\B:1638', 'Count': 3863},\n",
       "    {'Label': 'B:261\\\\B:262\\\\B:127\\\\B:128\\\\B:1618', 'Count': 507},\n",
       "    {'Label': 'B:261\\\\B:262\\\\B:127\\\\B:128\\\\B:1620', 'Count': 364}]},\n",
       "  'RCSTRBC2012Leaf': {'Buckets': [{'Label': 'Banks (NEC)', 'Count': 3688516},\n",
       "    {'Label': 'Corporate Banks', 'Count': 1649937},\n",
       "    {'Label': 'Retail & Mortgage Banks', 'Count': 1274815},\n",
       "    {'Label': 'Private Banks', 'Count': 36268},\n",
       "    {'Label': 'Import-Export Banks', 'Count': 20337},\n",
       "    {'Label': 'Merchant Banks', 'Count': 3888},\n",
       "    {'Label': 'Money Center Banks', 'Count': 554},\n",
       "    {'Label': 'Islamic Banks', 'Count': 407}]},\n",
       "  'RCSTRBC2012Name': {'Buckets': [{'Label': 'Financials\\\\Banking & Investment Services\\\\Banking Services\\\\Banks\\\\Banks (NEC)',\n",
       "     'Count': 3660697},\n",
       "    {'Label': 'Financials\\\\Banking & Investment Services\\\\Banking Services\\\\Banks\\\\Corporate Banks',\n",
       "     'Count': 1633629},\n",
       "    {'Label': 'Financials\\\\Banking & Investment Services\\\\Banking Services\\\\Banks\\\\Retail & Mortgage Banks',\n",
       "     'Count': 1265972},\n",
       "    {'Label': 'Financials\\\\Banking & Investment Services\\\\Banking Services\\\\Banks\\\\Private Banks',\n",
       "     'Count': 35446},\n",
       "    {'Label': 'Financials\\\\Banking & Investment Services\\\\Banking Services\\\\Corporate Financial Services\\\\Import-Export Banks',\n",
       "     'Count': 20039},\n",
       "    {'Label': 'Financials\\\\Banking & Investment Services\\\\Investment Banking & Investment Services\\\\Investment Banking & Brokerage Services\\\\Merchant Banks',\n",
       "     'Count': 3863},\n",
       "    {'Label': 'Financials\\\\Banking & Investment Services\\\\Banking Services\\\\Banks\\\\Money Center Banks',\n",
       "     'Count': 507},\n",
       "    {'Label': 'Financials\\\\Banking & Investment Services\\\\Banking Services\\\\Banks\\\\Islamic Banks',\n",
       "     'Count': 364}]}}}"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# RCSTRBC2012Leaf\n",
    "# RCSTRBC2012Genealogy\n",
    "# RCSTRBC2012Name\n",
    "# Provide a breakdown of the hierarchy defined for many of these RCS attributes.  You can see the mapping between the \n",
    "# hierarchy defined with the Genealogy property and Name property.  \n",
    "# For example, the code 'B:262' maps to the name 'Banking & Investment Services'.\n",
    "response = rdp.Search.search(\n",
    "    filter = \"RCSTRBC2012Leaf eq 'Banks'\",    # Limit the sector to banks so we can easily observe the output below\n",
    "    top = 0,\n",
    "    navigators = \"RCSTRBC2012Leaf, RCSTRBC2012Genealogy, RCSTRBC2012Name\"\n",
    ")\n",
    "response.data.raw"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The above output includes 3 separate sections: RCSTRBC2012Genealogy, RCSTRBC2012Leaf and RCSTRBC2012Name.  For each you can see a breakdown ot the buckets."
   ]
  },
  {
   "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
}