filing-tag-explore-v1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import os, json\n",
    "import pandas as pd\n",
    "\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def load_folder_csv(folder, prefix=None, sep=\",\",encoding=\"utf-8\"):\n",
    "    files = os.listdir(folder)\n",
    "    if prefix is not None:\n",
    "        files = [f for f in files if f.startswith(prefix)]\n",
    "        \n",
    "    dfs = []\n",
    "    for f in files:\n",
    "        in_p = os.path.join(folder, f)\n",
    "        df = pd.read_csv(in_p, sep=sep, encoding=encoding)\n",
    "        dfs.append(df)\n",
    "        \n",
    "    return pd.concat(dfs, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\lewen.zhao\\AppData\\Local\\Continuum\\Anaconda3\\lib\\site-packages\\IPython\\core\\interactiveshell.py:2802: DtypeWarning: Columns (10,13) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  if self.run_code(code, result):\n",
      "C:\\Users\\lewen.zhao\\AppData\\Local\\Continuum\\Anaconda3\\lib\\site-packages\\IPython\\core\\interactiveshell.py:2802: DtypeWarning: Columns (13) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  if self.run_code(code, result):\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "5683436"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_folder = \"./data/sec\"\n",
    "num_prefix = \"numbers_sec-numbers\"\n",
    "\n",
    "df_nums = load_folder_csv(data_folder, prefix=num_prefix)\n",
    "len(df_nums)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['submission_number', 'company_name', 'measure_tag', 'version',\n",
       "       'period_end_date', 'number_of_quarters', 'units', 'dimension_hash',\n",
       "       'iprx', 'value', 'footnote', 'footnote_length', 'num_dimensions',\n",
       "       'coregistrant', 'duration_fraction', 'date_fraction', 'decimal'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_nums.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Choose frequent tags "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>measure_tag</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>StockholdersEquity</td>\n",
       "      <td>77841</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>64151</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>StockholdersEquityIncludingPortionAttributable...</td>\n",
       "      <td>52191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>OperatingIncomeLoss</td>\n",
       "      <td>50247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CashAndCashEquivalentsAtCarryingValue</td>\n",
       "      <td>48652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Revenues</td>\n",
       "      <td>42521</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Assets</td>\n",
       "      <td>39778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>IncomeTaxExpenseBenefit</td>\n",
       "      <td>38176</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>ProfitLoss</td>\n",
       "      <td>31364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>SalesRevenueNet</td>\n",
       "      <td>30901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>InterestExpense</td>\n",
       "      <td>30888</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>LiabilitiesAndStockholdersEquity</td>\n",
       "      <td>27434</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>AvailableForSaleSecurities</td>\n",
       "      <td>24937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>IncomeLossFromContinuingOperationsBeforeIncome...</td>\n",
       "      <td>24696</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>CashAndCashEquivalentsPeriodIncreaseDecrease</td>\n",
       "      <td>24539</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>NetCashProvidedByUsedInOperatingActivities</td>\n",
       "      <td>23890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>PropertyPlantAndEquipmentNet</td>\n",
       "      <td>23451</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>NetCashProvidedByUsedInFinancingActivities</td>\n",
       "      <td>23318</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>AccumulatedOtherComprehensiveIncomeLossNetOfTax</td>\n",
       "      <td>23255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>ComprehensiveIncomeNetOfTax</td>\n",
       "      <td>22787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>EarningsPerShareBasic</td>\n",
       "      <td>22063</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>NetCashProvidedByUsedInInvestingActivities</td>\n",
       "      <td>21647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>LiabilitiesCurrent</td>\n",
       "      <td>21626</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>AssetsCurrent</td>\n",
       "      <td>21622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>EarningsPerShareDiluted</td>\n",
       "      <td>21144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>CommonStockValue</td>\n",
       "      <td>21118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>WeightedAverageNumberOfSharesOutstandingBasic</td>\n",
       "      <td>21007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Goodwill</td>\n",
       "      <td>20931</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>CommonStockSharesOutstanding</td>\n",
       "      <td>20849</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>ShareBasedCompensation</td>\n",
       "      <td>20620</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>CommonStockSharesIssued</td>\n",
       "      <td>20498</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Liabilities</td>\n",
       "      <td>20462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>GeneralAndAdministrativeExpense</td>\n",
       "      <td>20223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>OperatingExpenses</td>\n",
       "      <td>20124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>GrossProfit</td>\n",
       "      <td>19925</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>RetainedEarningsAccumulatedDeficit</td>\n",
       "      <td>19787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>CommonStockSharesAuthorized</td>\n",
       "      <td>19774</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>AllocatedShareBasedCompensationExpense</td>\n",
       "      <td>19696</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>WeightedAverageNumberOfDilutedSharesOutstanding</td>\n",
       "      <td>19596</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>CommonStockParOrStatedValuePerShare</td>\n",
       "      <td>19182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>PaymentsToAcquirePropertyPlantAndEquipment</td>\n",
       "      <td>18869</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>LoansAndLeasesReceivableGrossCarryingAmount</td>\n",
       "      <td>17616</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>DepreciationDepletionAndAmortization</td>\n",
       "      <td>17428</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>SellingGeneralAndAdministrativeExpense</td>\n",
       "      <td>17040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>OtherNonoperatingIncomeExpense</td>\n",
       "      <td>15958</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>AntidilutiveSecuritiesExcludedFromComputationO...</td>\n",
       "      <td>15447</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>AccountsPayableCurrent</td>\n",
       "      <td>14677</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>IncomeLossFromContinuingOperationsBeforeIncome...</td>\n",
       "      <td>14651</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>PropertyPlantAndEquipmentGross</td>\n",
       "      <td>14416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>DebtInstrumentInterestRateStatedPercentage</td>\n",
       "      <td>14413</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                index  measure_tag\n",
       "0                                  StockholdersEquity        77841\n",
       "1                                       NetIncomeLoss        64151\n",
       "2   StockholdersEquityIncludingPortionAttributable...        52191\n",
       "3                                 OperatingIncomeLoss        50247\n",
       "4               CashAndCashEquivalentsAtCarryingValue        48652\n",
       "5                                            Revenues        42521\n",
       "6                                              Assets        39778\n",
       "7                             IncomeTaxExpenseBenefit        38176\n",
       "8                                          ProfitLoss        31364\n",
       "9                                     SalesRevenueNet        30901\n",
       "10                                    InterestExpense        30888\n",
       "11                   LiabilitiesAndStockholdersEquity        27434\n",
       "12                         AvailableForSaleSecurities        24937\n",
       "13  IncomeLossFromContinuingOperationsBeforeIncome...        24696\n",
       "14       CashAndCashEquivalentsPeriodIncreaseDecrease        24539\n",
       "15         NetCashProvidedByUsedInOperatingActivities        23890\n",
       "16                       PropertyPlantAndEquipmentNet        23451\n",
       "17         NetCashProvidedByUsedInFinancingActivities        23318\n",
       "18    AccumulatedOtherComprehensiveIncomeLossNetOfTax        23255\n",
       "19                        ComprehensiveIncomeNetOfTax        22787\n",
       "20                              EarningsPerShareBasic        22063\n",
       "21         NetCashProvidedByUsedInInvestingActivities        21647\n",
       "22                                 LiabilitiesCurrent        21626\n",
       "23                                      AssetsCurrent        21622\n",
       "24                            EarningsPerShareDiluted        21144\n",
       "25                                   CommonStockValue        21118\n",
       "26      WeightedAverageNumberOfSharesOutstandingBasic        21007\n",
       "27                                           Goodwill        20931\n",
       "28                       CommonStockSharesOutstanding        20849\n",
       "29                             ShareBasedCompensation        20620\n",
       "30                            CommonStockSharesIssued        20498\n",
       "31                                        Liabilities        20462\n",
       "32                    GeneralAndAdministrativeExpense        20223\n",
       "33                                  OperatingExpenses        20124\n",
       "34                                        GrossProfit        19925\n",
       "35                 RetainedEarningsAccumulatedDeficit        19787\n",
       "36                        CommonStockSharesAuthorized        19774\n",
       "37             AllocatedShareBasedCompensationExpense        19696\n",
       "38    WeightedAverageNumberOfDilutedSharesOutstanding        19596\n",
       "39                CommonStockParOrStatedValuePerShare        19182\n",
       "40         PaymentsToAcquirePropertyPlantAndEquipment        18869\n",
       "41        LoansAndLeasesReceivableGrossCarryingAmount        17616\n",
       "42               DepreciationDepletionAndAmortization        17428\n",
       "43             SellingGeneralAndAdministrativeExpense        17040\n",
       "44                     OtherNonoperatingIncomeExpense        15958\n",
       "45  AntidilutiveSecuritiesExcludedFromComputationO...        15447\n",
       "46                             AccountsPayableCurrent        14677\n",
       "47  IncomeLossFromContinuingOperationsBeforeIncome...        14651\n",
       "48                     PropertyPlantAndEquipmentGross        14416\n",
       "49         DebtInstrumentInterestRateStatedPercentage        14413"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tag_counts = df_nums['measure_tag'].value_counts().reset_index()\n",
    "tag_counts.head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x20c0008d1d0>"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAA4MAAAIMCAYAAABPBnlDAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4xLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvAOZPmwAAIABJREFUeJzt3X+spXV9J/D3p4xYqlVQ64QFsmA6\naaR1izpBum6au9LAoJuOTTTBmDK1bKZxMam7JFtsk7WtNdHNWje6loYWVjBUZKkuxOJSot40TRRB\nRQEp5YpURqhUQXRsqh373T/Od9rjcObeO3Nn7jnM9/VKTs7zfJ7v8+Oez3AO7/s857nVWgsAAABj\n+ZF5HwAAAACbTxgEAAAYkDAIAAAwIGEQAABgQMIgAADAgIRBAACAAQmDAAAAAxIGAQAABiQMAgAA\nDEgYBAAAGNCWeR/Akfa85z2vnX766fM+jCf57ne/m2c84xnzPozh6cP86cFi0IfFoA+LQR8Wgz7M\nnx4shiPRh89+9rPfaK39xFrjjrkwePrpp+eOO+6Y92E8yfLycpaWluZ9GMPTh/nTg8WgD4tBHxaD\nPiwGfZg/PVgMR6IPVfU36xnnMlEAAIABCYMAAAADEgYBAAAGJAwCAAAMSBgEAAAYkDAIAAAwIGEQ\nAABgQMIgAADAgIRBAACAAQmDAAAAAxIGAQAABiQMAgAADGjNMFhVP1pVn6mqL1TVPVX1O71+RlXd\nVlX3V9WHqur4Xn96n1/py0+f2tZbev2+qjp/qr6j11aq6rKp+sx9AAAAsDHrOTP4vSSvaK39bJKz\nkuyoqnOSvDPJu1tr25I8nuTiPv7iJI+31n4yybv7uFTVmUkuTPLTSXYk+YOqOq6qjkvyviQXJDkz\nyev62KyyDwAAADZgzTDYJvb22af1R0vyiiQ39PrVSV7dp3f2+fTl51ZV9fp1rbXvtda+kmQlydn9\nsdJae6C19v0k1yXZ2dc52D4AAADYgHV9Z7CfwbszyaNJbk3y5STfaq3t60P2JDmlT5+S5KEk6cuf\nSPLc6foB6xys/txV9gEAAMAGbFnPoNbaD5KcVVUnJvlIkhfOGtaf6yDLDlafFUhXG/8kVbU7ye4k\n2bp1a5aXl2cNm6u9e/cu5HGNRh/mTw8Wgz4sBn1YDPqwGPRh/vRgMWxmH9YVBvdrrX2rqpaTnJPk\nxKra0s/cnZrk4T5sT5LTkuypqi1Jnp3ksan6ftPrzKp/Y5V9HHhcVyS5Ikm2b9/elpaWDuXH2hTL\ny8tZxOMajT7Mnx4sBn1YDPqwGPRhMejD/OnBYtjMPqznbqI/0c8IpqpOSPILSe5N8skkr+nDdiW5\nsU/f1OfTl3+itdZ6/cJ+t9EzkmxL8pkktyfZ1u8cenwmN5m5qa9zsH0AAACwAes5M3hykqv7XT9/\nJMn1rbWPVtWXklxXVb+X5PNJruzjr0zygapayeSM4IVJ0lq7p6quT/KlJPuSXNIvP01VvSnJLUmO\nS3JVa+2evq3fOMg+AAAA2IA1w2Br7YtJXjyj/kAmdwI9sP4PSV57kG29PcnbZ9RvTnLzevcBAADA\nxhzSdwY5fHd97Yn8ymV/tua4B9/xqk04GgAAYHTr+tMSAAAAHFuEQQAAgAEJgwAAAAMSBgEAAAYk\nDAIAAAxIGAQAABiQMAgAADAgYRAAAGBAwiAAAMCAhEEAAIABCYMAAAADEgYBAAAGJAwCAAAMSBgE\nAAAYkDAIAAAwIGEQAABgQMIgAADAgIRBAACAAQmDAAAAAxIGAQAABiQMAgAADEgYBAAAGJAwCAAA\nMCBhEAAAYEDCIAAAwICEQQAAgAEJgwAAAAMSBgEAAAYkDAIAAAxIGAQAABiQMAgAADAgYRAAAGBA\nwiAAAMCAhEEAAIABCYMAAAADEgYBAAAGJAwCAAAMSBgEAAAYkDAIAAAwIGEQAABgQMIgAADAgIRB\nAACAAQmDAAAAAxIGAQAABiQMAgAADEgYBAAAGJAwCAAAMCBhEAAAYEDCIAAAwICEQQAAgAEJgwAA\nAAMSBgEAAAYkDAIAAAxIGAQAABiQMAgAADAgYRAAAGBAwiAAAMCAhEEAAIABCYMAAAADEgYBAAAG\nJAwCAAAMSBgEAAAYkDAIAAAwIGEQAABgQMIgAADAgIRBAACAAQmDAAAAAxIGAQAABiQMAgAADGjN\nMFhVp1XVJ6vq3qq6p6p+vdd/u6q+VlV39scrp9Z5S1WtVNV9VXX+VH1Hr61U1WVT9TOq6raqur+q\nPlRVx/f60/v8Sl9++pH84QEAAEa1njOD+5Jc2lp7YZJzklxSVWf2Ze9urZ3VHzcnSV92YZKfTrIj\nyR9U1XFVdVyS9yW5IMmZSV43tZ139m1tS/J4kot7/eIkj7fWfjLJu/s4AAAANmjNMNhae6S19rk+\n/Z0k9yY5ZZVVdia5rrX2vdbaV5KsJDm7P1Zaaw+01r6f5LokO6uqkrwiyQ19/auTvHpqW1f36RuS\nnNvHAwAAsAGH9J3Bfpnmi5Pc1ktvqqovVtVVVXVSr52S5KGp1fb02sHqz03yrdbavgPqP7StvvyJ\nPh4AAIAN2LLegVX1zCR/muTNrbVvV9XlSd6WpPXndyX51SSzzty1zA6ebZXxWWPZ9LHtTrI7SbZu\n3Zrl5eVVf5Z52HpCcumL9q05bhGP/Viyd+9er/Gc6cFi0IfFoA+LQR8Wgz7Mnx4shs3sw7rCYFU9\nLZMgeG1r7cNJ0lr7+tTyP0ry0T67J8lpU6ufmuThPj2r/o0kJ1bVln72b3r8/m3tqaotSZ6d5LED\nj6+1dkWSK5Jk+/btbWlpaT0/1qZ677U35l13rf1yP/j6paN/MANbXl7OIv77GIkeLAZ9WAz6sBj0\nYTHow/zpwWLYzD6s526ileTKJPe21n5/qn7y1LBfSnJ3n74pyYX9TqBnJNmW5DNJbk+yrd859PhM\nbjJzU2utJflkktf09XcluXFqW7v69GuSfKKPBwAAYAPWc2bw5Ul+OcldVXVnr/1mJncDPSuTyzYf\nTPJrSdJau6eqrk/ypUzuRHpJa+0HSVJVb0pyS5LjklzVWrunb+83klxXVb+X5POZhM/05w9U1Uom\nZwQv3MDPCgAAQLdmGGyt/WVmf3fv5lXWeXuSt8+o3zxrvdbaA5ncbfTA+j8kee1axwgAAMChOaS7\niQIAAHBsEAYBAAAGJAwCAAAMSBgEAAAYkDAIAAAwIGEQAABgQMIgAADAgIRBAACAAQmDAAAAAxIG\nAQAABiQMAgAADEgYBAAAGJAwCAAAMCBhEAAAYEDCIAAAwICEQQAAgAEJgwAAAAMSBgEAAAYkDAIA\nAAxIGAQAABiQMAgAADAgYRAAAGBAwiAAAMCAhEEAAIABCYMAAAADEgYBAAAGJAwCAAAMSBgEAAAY\nkDAIAAAwIGEQAABgQMIgAADAgIRBAACAAQmDAAAAAxIGAQAABiQMAgAADEgYBAAAGJAwCAAAMCBh\nEAAAYEDCIAAAwICEQQAAgAEJgwAAAAMSBgEAAAYkDAIAAAxIGAQAABiQMAgAADAgYRAAAGBAwiAA\nAMCAhEEAAIABCYMAAAADEgYBAAAGJAwCAAAMSBgEAAAYkDAIAAAwIGEQAABgQMIgAADAgIRBAACA\nAQmDAAAAAxIGAQAABiQMAgAADEgYBAAAGJAwCAAAMCBhEAAAYEDCIAAAwICEQQAAgAEJgwAAAAMS\nBgEAAAYkDAIAAAxIGAQAABiQMAgAADCgNcNgVZ1WVZ+sqnur6p6q+vVef05V3VpV9/fnk3q9quo9\nVbVSVV+sqpdMbWtXH39/Ve2aqr+0qu7q67ynqmq1fQAAALAx6zkzuC/Jpa21FyY5J8klVXVmksuS\nfLy1ti3Jx/t8klyQZFt/7E5yeTIJdknemuRlSc5O8tapcHd5H7t/vR29frB9AAAAsAFrhsHW2iOt\ntc/16e8kuTfJKUl2Jrm6D7s6yav79M4k17SJTyc5sapOTnJ+kltba4+11h5PcmuSHX3Zs1prn2qt\ntSTXHLCtWfsAAABgAw7pO4NVdXqSFye5LcnW1tojySQwJnl+H3ZKkoemVtvTa6vV98yoZ5V9AAAA\nsAFb1juwqp6Z5E+TvLm19u3+tb6ZQ2fU2mHU162qdmdymWm2bt2a5eXlQ1l9U2w9Ibn0RfvWHLeI\nx34s2bt3r9d4zvRgMejDYtCHxaAPi0Ef5k8PFsNm9mFdYbCqnpZJELy2tfbhXv56VZ3cWnukX+r5\naK/vSXLa1OqnJnm415cOqC/3+qkzxq+2jx/SWrsiyRVJsn379ra0tDRr2Fy999ob86671n65H3z9\n0tE/mIEtLy9nEf99jEQPFoM+LAZ9WAz6sBj0Yf70YDFsZh/WczfRSnJlkntba78/teimJPvvCLor\nyY1T9Yv6XUXPSfJEv8TzliTnVdVJ/cYx5yW5pS/7TlWd0/d10QHbmrUPAAAANmA9ZwZfnuSXk9xV\nVXf22m8meUeS66vq4iRfTfLavuzmJK9MspLk75O8IUlaa49V1duS3N7H/W5r7bE+/cYk709yQpKP\n9UdW2QcAAAAbsGYYbK39ZWZ/ry9Jzp0xviW55CDbuirJVTPqdyT5mRn1b87aBwAAABtzSHcTBQAA\n4NggDAIAAAxIGAQAABiQMAgAADAgYRAAAGBAwiAAAMCAhEEAAIABCYMAAAADEgYBAAAGJAwCAAAM\nSBgEAAAYkDAIAAAwIGEQAABgQMIgAADAgIRBAACAAQmDAAAAAxIGAQAABiQMAgAADEgYBAAAGJAw\nCAAAMCBhEAAAYEDCIAAAwICEQQAAgAEJgwAAAAMSBgEAAAYkDAIAAAxIGAQAABiQMAgAADAgYRAA\nAGBAwiAAAMCAhEEAAIABCYMAAAADEgYBAAAGJAwCAAAMSBgEAAAYkDAIAAAwIGEQAABgQMIgAADA\ngIRBAACAAQmDAAAAAxIGAQAABiQMAgAADEgYBAAAGJAwCAAAMCBhEAAAYEDCIAAAwICEQQAAgAEJ\ngwAAAAMSBgEAAAYkDAIAAAxIGAQAABiQMAgAADAgYRAAAGBAwiAAAMCAhEEAAIABCYMAAAADEgYB\nAAAGJAwCAAAMSBgEAAAYkDAIAAAwIGEQAABgQMIgAADAgIRBAACAAQmDAAAAAxIGAQAABiQMAgAA\nDEgYBAAAGJAwCAAAMCBhEAAAYEDCIAAAwIDWDINVdVVVPVpVd0/VfruqvlZVd/bHK6eWvaWqVqrq\nvqo6f6q+o9dWquqyqfoZVXVbVd1fVR+qquN7/el9fqUvP/1I/dAAAACjW8+Zwfcn2TGj/u7W2ln9\ncXOSVNWZSS5M8tN9nT+oquOq6rgk70tyQZIzk7yuj02Sd/ZtbUvyeJKLe/3iJI+31n4yybv7OAAA\nAI6ANcNga+0vkjy2zu3tTHJda+17rbWvJFlJcnZ/rLTWHmitfT/JdUl2VlUleUWSG/r6Vyd59dS2\nru7TNyQ5t48HAABgg7ZsYN03VdVFSe5Icmlr7fEkpyT59NSYPb2WJA8dUH9Zkucm+VZrbd+M8afs\nX6e1tq+qnujjv3HggVTV7iS7k2Tr1q1ZXl7ewI91dGw9Ibn0RfvWHLeIx34s2bt3r9d4zvRgMejD\nYtCHxaAPi0Ef5k8PFsNm9uFww+DlSd6WpPXndyX51SSzzty1zD4D2VYZnzWW/XCxtSuSXJEk27dv\nb0tLS6sc+ny899ob86671n65H3z90tE/mIEtLy9nEf99jEQPFoM+LAZ9WAz6sBj0Yf70YDFsZh8O\n626irbWvt9Z+0Fr7pyR/lMlloMnkzN5pU0NPTfLwKvVvJDmxqrYcUP+hbfXlz876L1cFAABgFYcV\nBqvq5KnZX0qy/06jNyW5sN8J9Iwk25J8JsntSbb1O4cen8lNZm5qrbUkn0zymr7+riQ3Tm1rV59+\nTZJP9PEAAABs0JrXLVbVB5MsJXleVe1J8tYkS1V1ViaXbT6Y5NeSpLV2T1Vdn+RLSfYluaS19oO+\nnTcluSXJcUmuaq3d03fxG0muq6rfS/L5JFf2+pVJPlBVK5mcEbxwwz8tAAAASdYRBltrr5tRvnJG\nbf/4tyd5+4z6zUlunlF/IP9ymel0/R+SvHat4wMAAODQHdZlogAAADy1CYMAAAADEgYBAAAGJAwC\nAAAMSBgEAAAYkDAIAAAwIGEQAABgQMIgAADAgIRBAACAAQmDAAAAAxIGAQAABiQMAgAADEgYBAAA\nGJAwCAAAMCBhEAAAYEDCIAAAwICEQQAAgAEJgwAAAAMSBgEAAAYkDAIAAAxIGAQAABiQMAgAADAg\nYRAAAGBAwiAAAMCAhEEAAIABCYMAAAADEgYBAAAGJAwCAAAMSBgEAAAYkDAIAAAwIGEQAABgQMIg\nAADAgIRBAACAAQmDAAAAAxIGAQAABiQMAgAADEgYBAAAGJAwCAAAMCBhEAAAYEDCIAAAwICEQQAA\ngAEJgwAAAAMSBgEAAAYkDAIAAAxIGAQAABiQMAgAADAgYRAAAGBAwiAAAMCAhEEAAIABCYMAAAAD\nEgYBAAAGJAwCAAAMSBgEAAAYkDAIAAAwIGEQAABgQMIgAADAgIRBAACAAQmDAAAAAxIGAQAABiQM\nAgAADEgYBAAAGJAwCAAAMCBhEAAAYEDCIAAAwICEQQAAgAEJgwAAAAMSBgEAAAYkDAIAAAxIGAQA\nABjQmmGwqq6qqker6u6p2nOq6taqur8/n9TrVVXvqaqVqvpiVb1kap1dffz9VbVrqv7Sqrqrr/Oe\nqqrV9gEAAMDGrefM4PuT7DigdlmSj7fWtiX5eJ9PkguSbOuP3UkuTybBLslbk7wsydlJ3joV7i7v\nY/evt2ONfQAAALBBa4bB1tpfJHnsgPLOJFf36auTvHqqfk2b+HSSE6vq5CTnJ7m1tfZYa+3xJLcm\n2dGXPau19qnWWktyzQHbmrUPAAAANuhwvzO4tbX2SJL05+f3+ilJHpoat6fXVqvvmVFfbR8AAABs\n0JYjvL2aUWuHUT+0nVbtzuRS02zdujXLy8uHuomjbusJyaUv2rfmuEU89mPJ3r17vcZzpgeLQR8W\ngz4sBn1YDPowf3qwGDazD4cbBr9eVSe31h7pl3o+2ut7kpw2Ne7UJA/3+tIB9eVeP3XG+NX28SSt\ntSuSXJEk27dvb0tLSwcbOjfvvfbGvOuutV/uB1+/dPQPZmDLy8tZxH8fI9GDxaAPi0EfFoM+LAZ9\nmD89WAyb2YfDvUz0piT77wi6K8mNU/WL+l1Fz0nyRL/E85Yk51XVSf3GMecluaUv+05VndPvInrR\nAduatQ8AAAA2aM1TVVX1wUzO6j2vqvZkclfQdyS5vqouTvLVJK/tw29O8sokK0n+PskbkqS19lhV\nvS3J7X3c77bW9t+U5o2Z3LH0hCQf64+ssg8AAAA2aM0w2Fp73UEWnTtjbEtyyUG2c1WSq2bU70jy\nMzPq35y1DwAAADbucC8TBQAA4ClMGAQAABiQMAgAADAgYRAAAGBAwiAAAMCAhEEAAIABCYMAAAAD\nEgYBAAAGJAwCAAAMSBgEAAAYkDAIAAAwIGEQAABgQMIgAADAgIRBAACAAQmDAAAAAxIGAQAABiQM\nAgAADEgYBAAAGJAwCAAAMCBhEAAAYEDCIAAAwICEQQAAgAEJgwAAAAMSBgEAAAYkDAIAAAxIGAQA\nABiQMAgAADAgYRAAAGBAwiAAAMCAhEEAAIABCYMAAAADEgYBAAAGJAwCAAAMSBgEAAAYkDAIAAAw\nIGEQAABgQMIgAADAgIRBAACAAQmDAAAAAxIGAQAABiQMAgAADEgYBAAAGJAwCAAAMCBhEAAAYEDC\nIAAAwICEQQAAgAEJgwAAAAMSBgEAAAYkDAIAAAxIGAQAABiQMAgAADAgYRAAAGBAwiAAAMCAhEEA\nAIABCYMAAAADEgYBAAAGJAwCAAAMSBgEAAAYkDAIAAAwIGEQAABgQMIgAADAgIRBAACAAQmDAAAA\nAxIGAQAABiQMAgAADEgYBAAAGJAwCAAAMCBhEAAAYEDCIAAAwIA2FAar6sGququq7qyqO3rtOVV1\na1Xd359P6vWqqvdU1UpVfbGqXjK1nV19/P1VtWuq/tK+/ZW+bm3keAEAAJg4EmcG/31r7azW2vY+\nf1mSj7fWtiX5eJ9PkguSbOuP3UkuTybhMclbk7wsydlJ3ro/QPYxu6fW23EEjhcAAGB4R+My0Z1J\nru7TVyd59VT9mjbx6SQnVtXJSc5Pcmtr7bHW2uNJbk2yoy97VmvtU621luSaqW0BAACwARsNgy3J\nn1fVZ6tqd69tba09kiT9+fm9fkqSh6bW3dNrq9X3zKgDAACwQVs2uP7LW2sPV9Xzk9xaVX+1ythZ\n3/drh1F/8oYnQXR3kmzdujXLy8urHvQ8bD0hufRF+9Yct4jHfizZu3ev13jO9GAx6MNi0IfFoA+L\nQR/mTw8Ww2b2YUNhsLX2cH9+tKo+ksl3/r5eVSe31h7pl3o+2ofvSXLa1OqnJnm415cOqC/3+qkz\nxs86jiuSXJEk27dvb0tLS7OGzdV7r70x77pr7Zf7wdcvHf2DGdjy8nIW8d/HSPRgMejDYtCHxaAP\ni0Ef5k8PFsNm9uGwLxOtqmdU1Y/vn05yXpK7k9yUZP8dQXclubFP35Tkon5X0XOSPNEvI70lyXlV\ndVK/ccx5SW7py75TVef0u4heNLUtAAAANmAjZwa3JvlI/2sPW5L8SWvt/1XV7Umur6qLk3w1yWv7\n+JuTvDLJSpK/T/KGJGmtPVZVb0tyex/3u621x/r0G5O8P8kJST7WHwAAAGzQYYfB1toDSX52Rv2b\nSc6dUW9JLjnItq5KctWM+h1JfuZwjxEAAIDZjsaflgAAAGDBCYMAAAADEgYBAAAGJAwCAAAMSBgE\nAAAYkDAIAAAwIGEQAABgQMIgAADAgIRBAACAAQmDAAAAAxIGAQAABiQMAgAADEgYBAAAGJAwCAAA\nMCBhEAAAYEDCIAAAwICEQQAAgAEJgwAAAAMSBgEAAAYkDAIAAAxIGAQAABiQMAgAADAgYRAAAGBA\nwiAAAMCAhEEAAIABCYMAAAADEgYBAAAGJAwCAAAMSBgEAAAYkDAIAAAwIGEQAABgQMIgAADAgIRB\nAACAAQmDAAAAAxIGAQAABiQMAgAADEgYBAAAGJAwCAAAMCBhEAAAYEDCIAAAwICEQQAAgAEJgwAA\nAAMSBgEAAAYkDAIAAAxIGAQAABiQMAgAADAgYRAAAGBAwiAAAMCAhEEAAIABCYMAAAADEgYBAAAG\nJAwCAAAMSBgEAAAYkDAIAAAwIGEQAABgQMIgAADAgIRBAACAAQmDAAAAAxIGAQAABiQMAgAADEgY\nBAAAGJAwCAAAMCBhEAAAYEDCIAAAwICEQQAAgAEJgwAAAAMSBgEAAAYkDAIAAAxIGAQAABiQMAgA\nADCghQ+DVbWjqu6rqpWqumzexwMAAHAsWOgwWFXHJXlfkguSnJnkdVV15nyPCgAA4KlvocNgkrOT\nrLTWHmitfT/JdUl2zvmYAAAAnvK2zPsA1nBKkoem5vckedmcjmVTnH7Zn6055sF3vGoTjgQAADiW\nLXoYrBm19qRBVbuT7O6ze6vqvqN6VIfneUm+cSQ2VO88ElsZ1hHrA4dNDxaDPiwGfVgM+rAY9GH+\n9GAxHIk+/Ov1DFr0MLgnyWlT86cmefjAQa21K5JcsVkHdTiq6o7W2vZ5H8fo9GH+9GAx6MNi0IfF\noA+LQR/mTw8Ww2b2YdG/M3h7km1VdUZVHZ/kwiQ3zfmYAAAAnvIW+sxga21fVb0pyS1JjktyVWvt\nnjkfFgAAwFPeQofBJGmt3Zzk5nkfxxGw0JexDkQf5k8PFoM+LAZ9WAz6sBj0Yf70YDFsWh+qtSfd\njwUAAIBj3KJ/ZxAAAICjQBg8yqpqR1XdV1UrVXXZvI/nWFBVV1XVo1V191TtOVV1a1Xd359P6vWq\nqvf01/+LVfWSqXV29fH3V9WuqfpLq+quvs57qmrWnzgZXlWdVlWfrKp7q+qeqvr1XteLTVJVP1pV\nn6mqL/Qe/E6vn1FVt/XX80P9Blypqqf3+ZW+/PSpbb2l1++rqvOn6t7D1qmqjquqz1fVR/u8Pmyy\nqnqwv2fcWVV39Jr3pE1WVSdW1Q1V9Vf9M+Ln9GHzVNVP9f8G9j++XVVv1oPNV1X/uX8+311VH6zJ\n5/ZifTa01jyO0iOTm958OckLkhyf5AtJzpz3cT3VH0l+PslLktw9VfvvSS7r05cleWeffmWSj2Xy\nNyvPSXJbrz8nyQP9+aQ+fVJf9pkkP9fX+ViSC+b9My/iI8nJSV7Sp388yV8nOVMvNrUHleSZffpp\nSW7rr+31SS7s9T9M8sY+/Z+S/GGfvjDJh/r0mf396elJzujvW8d5DzvkfvyXJH+S5KN9Xh82vwcP\nJnneATXvSZvfh6uT/Mc+fXySE/Vhbr04LsnfZvI35/Rgc1/7U5J8JckJff76JL+yaJ8NzgweXWcn\nWWmtPdBa+36S65LsnPMxPeW11v4iyWMHlHdm8uGT/vzqqfo1beLTSU6sqpOTnJ/k1tbaY621x5Pc\nmmRHX/as1tqn2uS/wGumtsWU1tojrbXP9envJLk3kzc+vdgk/bXc22ef1h8tySuS3NDrB/Zgf29u\nSHJu/23uziTXtda+11r7SpKVTN6/vIetU1WdmuRVSf64z1f0YVF4T9pEVfWsTH5pe2WStNa+31r7\nVvRhXs5N8uXW2t9ED+ZhS5ITqmpLkh9L8kgW7LNBGDy6Tkny0NT8nl7jyNvaWnskmYSUJM/v9YP1\nYLX6nhl1VtEvZXhxJmem9GIT1eTSxDuTPJrJB/WXk3yrtbavD5l+3f75te7Ln0jy3Bx6b3iy/5nk\nvyb5pz7/3OjDPLQkf15Vn62q3b3mPWlzvSDJ3yX53zW5bPqPq+oZ0Yd5uTDJB/u0Hmyi1trXkvyP\nJF/NJAQ+keSzWbDPBmHw6Jp1/bTbt26ug/XgUOscRFU9M8mfJnlza+3bqw2dUdOLDWqt/aC1dlaS\nUzP5LeELZw3rz3pwFFTVf0jyaGvts9PlGUP14eh7eWvtJUkuSHJJVf38KmP14ejYkslXOS5vrb04\nyXczuSTxYPThKOnfRfvFJP8hfHP1AAACrElEQVRnraEzanqwQf07mTszubTzXyV5RibvTQea62eD\nMHh07Uly2tT8qUkentOxHOu+3i9bSH9+tNcP1oPV6qfOqDNDVT0tkyB4bWvtw72sF3PQL8NazuT7\nHif2S1KSH37d/vm17sufnckl14faG37Yy5P8YlU9mMllOq/I5EyhPmyy1trD/fnRJB/J5Bck3pM2\n154ke1prt/X5GzIJh/qw+S5I8rnW2tf7vB5srl9I8pXW2t+11v4xyYeT/Nss2GeDMHh03Z5kW79r\n0PGZnKq/ac7HdKy6Kcn+u1ztSnLjVP2ifqesc5I80S+NuCXJeVV1Uv/NzXlJbunLvlNV5/TrtC+a\n2hZT+utzZZJ7W2u/P7VILzZJVf1EVZ3Yp0/I5IPn3iSfTPKaPuzAHuzvzWuSfKJ/3+OmJBf2O5md\nkWRbJjcH8B62Dq21t7TWTm2tnZ7Ja/SJ1trrow+bqqqeUVU/vn86k/eSu+M9aVO11v42yUNV9VO9\ndG6SL0Uf5uF1+ZdLRBM92GxfTXJOVf1Yf532/7ewWJ8NbQHutnMsPzK5Q9NfZ/I9nt+a9/EcC49M\n3tgeSfKPmfxW5OJMrqn+eJL7+/Nz+thK8r7++t+VZPvUdn41ky/hriR5w1R9eyb/A/HlJP8rSc37\nZ17ER5J/l8nlCF9Mcmd/vFIvNrUH/ybJ53sP7k7y33r9Bf2DYiWTy4Oe3us/2udX+vIXTG3rt/rr\nfF+m7grnPeyQe7KUf7mbqD5s7mv/gkzupveFJPfsf528J82lF2cluaO/N/3fTO5EqQ+b24MfS/LN\nJM+equnB5vfhd5L8VX+tPpDJHUEX6rOh+oYAAAAYiMtEAQAABiQMAgAADEgYBAAAGJAwCAAAMCBh\nEAAAYEDCIAAAwICEQQAAgAEJgwAAAAP6/5xBnBMzypwYAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x20c000d27b8>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "tag_counts['measure_tag'].hist(bins=80, figsize=(15,9))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x20c2ad2dba8>"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAA4AAAAIMCAYAAACkMcJAAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4xLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvAOZPmwAAHvhJREFUeJzt3X+MZedZH/Dvw25s8gOcxKFbYlvd\njexCNwqFsIpCqdAKU2zjNts/HGXTCBzqyBWNRYGodC2ktES1ZLdV0wYSIitOZCJg7bppWWGDm9aM\nqCrqHyE/iBMME3uDFwcCODhsqsSsefvHPU4mk5mdu9nZmbv7fD7SaM5573vee859vPf6O+8559YY\nIwAAAJz7vmG7dwAAAICtIQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0\nIQACAAA0IQACAAA0sXO7d2AzvOQlLxm7d+/esuf7whe+kOc///lb9nysTy0Wh1osDrVYHGqxONRi\ncajF4lCLxbEZtfjQhz70Z2OMb9mo3zkRAHfv3p2HHnpoy55vaWkp+/fv37LnY31qsTjUYnGoxeJQ\ni8WhFotDLRaHWiyOzahFVX16nn5OAQUAAGhCAAQAAGhCAAQAAGhCAAQAAGhCAAQAAGhCAAQAAGhC\nAAQAAGhCAAQAAGhCAAQAAGhCAAQAAGhCAAQAAGhCAAQAAGhCAAQAAGhCAAQAAGhCAAQAAGhCAAQA\nAGhCAAQAAGhCAAQAAGhCAAQAAGhCAAQAAGhCAAQAAGhi53bvwLls96G7N+xz9Oart2BPAAAAzAAC\nAAC0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0\nIQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQAC\nAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0\nIQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQAC\nAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0IQACAAA0\nIQACAAA0MVcArKorq+qRqlquqkNrPH5+Vd0xPX5/Ve1e8diNU/sjVXXFKYz5c1V1/Os7LAAAAFbb\nMABW1Y4k70xyVZK9SV5fVXtXdbsuyefGGJcmeXuSW6Zt9yY5mOTlSa5M8q6q2rHRmFW1L8kLT/PY\nAAAAWGGeGcBXJVkeYzw6xng6yeEkB1b1OZDk9mn5riSXV1VN7YfHGF8aYzyWZHkab90xp3D475P8\n9OkdGgAAACvNEwAvSvL4ivVjU9uafcYYJ5I8leTCk2x7sjFvSHJkjPGZ+Q4BAACAeeyco0+t0Tbm\n7LNe+1rBc1TVS5O8Nsn+DXeq6vok1yfJrl27srS0tNEmm+b48eNzPd9bXnFiwz5bud/nonlrwZmn\nFotDLRaHWiwOtVgcarE41GJxbGUt5gmAx5JcsmL94iRPrNPnWFXtTHJBkic32Hat9u9KcmmS5dkZ\npHleVS1P1xZ+lTHGrUluTZJ9+/aN/fv3z3Eom2NpaSnzPN8bD929YZ+jb9h4HNY3by0489RicajF\n4lCLxaEWi0MtFodaLI6trMU8p4A+mOSyqtpTVedldlOXI6v6HEly7bR8TZL7xhhjaj843SV0T5LL\nkjyw3phjjLvHGH9zjLF7jLE7yf9bK/wBAABw6jacARxjnKiqG5Lcm2RHkveOMR6uqrcleWiMcSTJ\nbUneX1XLmc38HZy2fbiq7kzyiSQnkrx5jPFMkqw15uYfHgAAAM+a5xTQjDHuSXLPqra3rlj+YmbX\n7q217U1JbppnzDX6vGCe/QMAAGBjc30RPAAAAGc/ARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAA\nAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJ\nARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAA\nAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJ\nARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAA\nAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJ\nARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAA\nAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJ\nARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAA\nAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJ\nARAAAKAJARAAAKAJARAAAKCJuQJgVV1ZVY9U1XJVHVrj8fOr6o7p8furaveKx26c2h+pqis2GrOq\nbquqj1bVx6rqrqp6wekdIgAAAMkcAbCqdiR5Z5KrkuxN8vqq2ruq23VJPjfGuDTJ25PcMm27N8nB\nJC9PcmWSd1XVjg3G/Mkxxt8dY3xHkj9McsNpHiMAAACZbwbwVUmWxxiPjjGeTnI4yYFVfQ4kuX1a\nvivJ5VVVU/vhMcaXxhiPJVmexlt3zDHG55Nk2v65ScbpHCAAAAAz8wTAi5I8vmL92NS2Zp8xxokk\nTyW58CTbnnTMqnpfkj9O8u1Jfm6OfQQAAGADO+foU2u0rZ6VW6/Peu1rBc8vjznG+NHpNNGfS/K6\nJO/7mp2quj7J9Umya9euLC0trbXvZ8Tx48fner63vOLEhn22cr/PRfPWgjNPLRaHWiwOtVgcarE4\n1GJxqMXi2MpazBMAjyW5ZMX6xUmeWKfPsarameSCJE9usO1JxxxjPFNVdyT5l1kjAI4xbk1ya5Ls\n27dv7N+/f45D2RxLS0uZ5/neeOjuDfscfcPG47C+eWvBmacWi0MtFodaLA61WBxqsTjUYnFsZS3m\nOQX0wSSXVdWeqjovs5u6HFnV50iSa6fla5LcN8YYU/vB6S6he5JcluSB9casmUuTL18D+I+S/N7p\nHSIAAADJHDOAY4wTVXVDknuT7Ejy3jHGw1X1tiQPjTGOJLktyfurajmzmb+D07YPV9WdST6R5ESS\nN48xnkmSdcb8hiS3V9U3Z3b66EeT/NjmHjIAAEBP85wCmjHGPUnuWdX21hXLX0zy2nW2vSnJTXOO\n+ddJvneefQIAAODUzPVF8AAAAJz9BEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAm\nBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAA\nAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAm\nBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAA\nAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAm\nBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAA\nAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAm\nBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAA\nAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAm\nBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAAAIAmBEAA\nAIAmBEAAAIAm5gqAVXVlVT1SVctVdWiNx8+vqjumx++vqt0rHrtxan+kqq7YaMyq+qWp/eNV9d6q\nes7pHSIAAADJHAGwqnYkeWeSq5LsTfL6qtq7qtt1ST43xrg0yduT3DJtuzfJwSQvT3JlkndV1Y4N\nxvylJN+e5BVJnpvkTad1hAAAACSZbwbwVUmWxxiPjjGeTnI4yYFVfQ4kuX1avivJ5VVVU/vhMcaX\nxhiPJVmexlt3zDHGPWOS5IEkF5/eIQIAAJDMFwAvSvL4ivVjU9uafcYYJ5I8leTCk2y74ZjTqZ8/\nnOQ35thHAAAANrBzjj61RtuYs8967WsFz9VjvivJb40x/veaO1V1fZLrk2TXrl1ZWlpaq9sZcfz4\n8bme7y2vOLFhn63c73PRvLXgzFOLxaEWi0MtFodaLA61WBxqsTi2shbzBMBjSS5ZsX5xkifW6XOs\nqnYmuSDJkxtsu+6YVfWvk3xLkn+23k6NMW5NcmuS7Nu3b+zfv3+OQ9kcS0tLmef53njo7g37HH3D\nxuOwvnlrwZmnFotDLRaHWiwOtVgcarE41GJxbGUt5jkF9MEkl1XVnqo6L7ObuhxZ1edIkmun5WuS\n3Dddw3ckycHpLqF7klyW2XV9645ZVW9KckWS148x/vr0Dg8AAIBnbTgDOMY4UVU3JLk3yY4k7x1j\nPFxVb0vy0BjjSJLbkry/qpYzm/k7OG37cFXdmeQTSU4kefMY45kkWWvM6SnfneTTSX57dh+ZfGCM\n8bZNO2IAAICm5jkFNGOMe5Lcs6rtrSuWv5jktetse1OSm+YZc2qfa58AAAA4NXN9ETwAAABnPwEQ\nAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACg\nCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQ\nAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACg\nCQEQAACgCQEQAACgiZ3bvQPd7T5091z9jt589RneEwAA4FxnBhAAAKAJARAAAKAJARAAAKAJARAA\nAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJ\nARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAA\nAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJ\nARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAA\nAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJ\nARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAAAKAJARAA\nAKCJuQJgVV1ZVY9U1XJVHVrj8fOr6o7p8furaveKx26c2h+pqis2GrOqbpjaRlW95PQODwAAgGdt\nGACrakeSdya5KsneJK+vqr2rul2X5HNjjEuTvD3JLdO2e5McTPLyJFcmeVdV7dhgzP+T5AeSfPo0\njw0AAIAV5pkBfFWS5THGo2OMp5McTnJgVZ8DSW6flu9KcnlV1dR+eIzxpTHGY0mWp/HWHXOM8eEx\nxtHTPC4AAABWmScAXpTk8RXrx6a2NfuMMU4keSrJhSfZdp4xAQAA2EQ75+hTa7SNOfus175W8Fw9\n5sl3qur6JNcnya5du7K0tHQqm5+W48ePz/V8b3nFiU17zq08vrPJvLXgzFOLxaEWi0MtFodaLA61\nWBxqsTi2shbzBMBjSS5ZsX5xkifW6XOsqnYmuSDJkxtsu9GYJzXGuDXJrUmyb9++sX///lPZ/LQs\nLS1lnud746G7N+05j75h4+fraN5acOapxeJQi8WhFotDLRaHWiwOtVgcW1mLeU4BfTDJZVW1p6rO\ny+ymLkdW9TmS5Npp+Zok940xxtR+cLpL6J4klyV5YM4xAQAA2EQbBsDpmr4bktyb5JNJ7hxjPFxV\nb6uq10zdbktyYVUtJ/mpJIembR9OcmeSTyT5jSRvHmM8s96YSVJVP15VxzKbFfxYVb1n8w4XAACg\nr3lOAc0Y454k96xqe+uK5S8mee06296U5KZ5xpza35HkHfPsFwAAAPOb64vgAQAAOPsJgAAAAE0I\ngAAAAE0IgAAAAE0IgAAAAE0IgAAAAE0IgAAAAE0IgAAAAE0IgAAAAE0IgAAAAE0IgAAAAE0IgAAA\nAE0IgAAAAE3s3O4dYD67D929YZ+jN1+9BXsCAACcrcwAAgAANCEAAgAANCEAAgAANCEAAgAANCEA\nAgAANCEAAgAANCEAAgAANCEAAgAANCEAAgAANCEAAgAANCEAAgAANCEAAgAANCEAAgAANCEAAgAA\nNCEAAgAANCEAAgAANCEAAgAANCEAAgAANCEAAgAANCEAAgAANCEAAgAANCEAAgAANLFzu3eAzbP7\n0N1z9Tt689VneE8AAIBFZAYQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACg\nCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQAACgCQEQ\nAACgiZ3bvQOc3XYfunvDPkdvvnoL9gQAANiIANiQ0AYAAD05BRQAAKAJARAAAKAJARAAAKAJ1wCy\npnmuEwQAAM4uZgABAACaEAABAACaEAABAACaEAABAACaEAABAACaEAABAACaEAABAACaEAABAACa\nEAABAACaEAABAACaEAABAACaEAABAACaEAABAACa2LndOwBnwu5Dd2/Y5+jNV2/BngAAwOIwAwgA\nANCEAAgAANCEAAgAANCEawBZGK7bAwCAM8sMIAAAQBMCIAAAQBMCIAAAQBMCIAAAQBMCIAAAQBPu\nAsoZN8/dPQEAgDPPDCAAAEATZgCBTTXvjK/vdAQA2HpmAAEAAJowAwgb2MxrGM16AQCwnQRA2nJz\nGgAAunEKKAAAQBNmADmrrJ61e8srTuSNZvK2zMlmTdUCAGDxmQEEAABowgwgsC3muQZz3pvmbOZY\nAADnMjOAAAAATcw1A1hVVyb5z0l2JHnPGOPmVY+fn+QXk3x3kj9P8roxxtHpsRuTXJfkmSQ/Psa4\n92RjVtWeJIeTvDjJ7yT54THG06d3mEB3vqD+K8yYAkBfGwbAqtqR5J1J/kGSY0kerKojY4xPrOh2\nXZLPjTEuraqDSW5J8rqq2pvkYJKXJ3lpkv9ZVX972ma9MW9J8vYxxuGqevc09i9sxsHCdtuO7xT0\ndRcAADxrnhnAVyVZHmM8miRVdTjJgSQrA+CBJP9mWr4ryc9XVU3th8cYX0ryWFUtT+NlrTGr6pNJ\nvj/JP5n63D6NKwDCKh2C3dl+jGbaFttmzgqvN9bqu+NuZr07/Pe1mcf4u3/01IZ3KnbdcS/ODGG1\nLv9NzHMN4EVJHl+xfmxqW7PPGONEkqeSXHiSbddrvzDJX0xjrPdcAAAAfB3mmQGsNdrGnH3Wa18r\neJ6s/9fuVNX1Sa6fVo9X1SNr9TtDXpLkz7bw+VjHj6vFwjhXalG3nBPPd9q12OrXYZGdzmux+t/F\nOfLf10I5hWPc8N/FZr5eHV7703BWfV6c47U8q2qxKBb1szvJ35qn0zwB8FiSS1asX5zkiXX6HKuq\nnUkuSPLkBtuu1f5nSV5YVTunWcC1nitJMsa4Ncmtc+z/pquqh8YY+7bjuflqarE41GJxqMXiUIvF\noRaLQy0Wh1osjq2sxTyngD6Y5LKq2lNV52V2U5cjq/ocSXLttHxNkvvGGGNqP1hV509397wsyQPr\njTlt85vTGJnG/NWv//AAAAB41oYzgGOME1V1Q5J7M/vKhveOMR6uqrcleWiMcSTJbUneP93k5cnM\nAl2mfndmdsOYE0nePMZ4JknWGnN6yn+V5HBV/dskH57GBgAA4DTN9T2AY4x7ktyzqu2tK5a/mOS1\n62x7U5Kb5hlzan80X7lT6KLallNPWZNaLA61WBxqsTjUYnGoxeJQi8WhFotjy2pRs7MuAQAAONfN\ncw0gAAAA5wAB8BRU1ZVV9UhVLVfVoe3en3NFVb23qj5bVR9f0fbiqvpgVf3B9PtFU3tV1TumGnys\nql65Yptrp/5/UFXXrmj/7qr63Wmbd1TVWl83QpKquqSqfrOqPllVD1fVv5ja1WOLVdU3VtUDVfXR\nqRY/O7Xvqar7p9f1julGWplutnXH9LreX1W7V4x149T+SFVdsaLde9opqKodVfXhqvq1aV0ttkFV\nHZ3eQz5SVQ9Nbd6jtkFVvbCq7qqq35s+N75HLbZeVX3b9O/h2Z/PV9VPqMX2qKqfnD63P15Vv1Kz\nz/PF+rwYY/iZ4yezm9V8KsnLkpyX5KNJ9m73fp0LP0m+L8krk3x8Rdu/S3JoWj6U5JZp+YeS/Hpm\n3xn56iT3T+0vTvLo9PtF0/KLpsceSPI90za/nuSq7T7mRf1J8q1JXjktf1OS30+yVz22pRaV5AXT\n8nOS3D+9xncmOTi1vzvJj03L/zzJu6flg0numJb3Tu9X5yfZM72P7fCe9nXV5KeS/HKSX5vW1WJ7\n6nA0yUtWtXmP2p5a3J7kTdPyeUleqBbbXpMdSf44s++DU4utf/0vSvJYkudO63cmeeOifV6YAZzf\nq5IsjzEeHWM8neRwkgPbvE/nhDHGb2V299iVDmT2wZLp9z9e0f6LY+b/Zva9kd+a5IokHxxjPDnG\n+FySDya5cnrsm8cYvz1m/6J+ccVYrDLG+MwY43em5b9M8snM3szUY4tNr+nxafU5089I8v1J7pra\nV9fi2RrdleTy6S+0B5IcHmN8aYzxWJLlzN7PvKedgqq6OMnVSd4zrVfUYpF4j9piVfXNmf0B97Yk\nGWM8Pcb4i6jFdrs8yafGGJ+OWmyXnUmeW7PvRn9eks9kwT4vBMD5XZTk8RXrx6Y2zoxdY4zPJLNQ\nkuRvTO3r1eFk7cfWaGcD02kI35XZzJN6bIOanXL4kSSfzeyD+FNJ/mKMcWLqsvL1+/JrPj3+VJIL\nc+o1Ym3/KclPJ/nraf3CqMV2GUn+R1V9qKqun9q8R229lyX50yTvq9mp0e+pqudHLbbbwSS/Mi2r\nxRYbY/xRkv+Q5A8zC35PJflQFuzzQgCc31rnOruF6tZbrw6n2s5JVNULkvzXJD8xxvj8ybqu0aYe\nm2SM8cwY4zuTXJzZX/3+zlrdpt9qcYZU1T9M8tkxxodWNq/RVS22xveOMV6Z5Kokb66q7ztJX7U4\nc3ZmdvnGL4wxvivJFzI7zXA9anGGTdeVvSbJf9mo6xptarEJpussD2R22uZLkzw/s/eq1bb180IA\nnN+xJJesWL84yRPbtC8d/Ml0ykGm35+d2terw8naL16jnXVU1XMyC3+/NMb4wNSsHttoOq1qKbNr\nNV44nVaSfPXr9+XXfHr8gsxOrT7VGvG1vjfJa6rqaGan23x/ZjOCarENxhhPTL8/m+S/ZfbHEe9R\nW+9YkmNjjPun9bsyC4RqsX2uSvI7Y4w/mdbVYuv9QJLHxhh/Osb4qyQfSPL3smCfFwLg/B5Mctl0\nF5/zMptiP7LN+3QuO5Lk2btPXZvkV1e0/8h0B6tXJ3lqOq3h3iQ/WFUvmv768oNJ7p0e+8uqevV0\nTvWPrBiLVabX6LYknxxj/McVD6nHFquqb6mqF07Lz83sQ+WTSX4zyTVTt9W1eLZG1yS5b7pW40iS\ng9OdxvYkuSyzi/m9p81pjHHjGOPiMcbuzF6n+8YYb4habLmqen5VfdOzy5m9t3w83qO23Bjjj5M8\nXlXfNjVdnuQTUYvt9Pp85fTPRC22wx8meXVVPW96rZ79d7FYnxdjAe6Yc7b8ZHbXpN/P7Dqcn9nu\n/TlXfjJ7s/pMkr/K7C8b12V2/vP/SvIH0+8XT30ryTunGvxukn0rxvmnmV0ku5zkR1e078vsfxA+\nleTnk9R2H/Oi/iT5+5mdSvCxJB+Zfn5IPbalFt+R5MNTLT6e5K1T+8umD4HlzE7zOX9q/8ZpfXl6\n/GUrxvqZ6fV+JCvu3OY97euqy/585S6garH1r//LMrvr3UeTPPzsa+U9atvq8Z1JHprep/57ZneO\nVIvtqcXzkvx5kgtWtKnF9tTiZ5P83vR6vT+zO3ku1OdFTQMBAABwjnMKKAAAQBMCIAAAQBMCIAAA\nQBMCIAAAQBMCIAAAQBMCIAAAQBMCIAAAQBMCIAAAQBP/H3CHPRErFKriAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x20c1d128278>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "tag_counts.loc[tag_counts[\"measure_tag\"]>1000, 'measure_tag'].hist(bins=80, figsize=(15,9), density=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "208"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "freq_tags = tag_counts.loc[tag_counts[\"measure_tag\"]>5000, 'index'].tolist()\n",
    "len(freq_tags)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['StockholdersEquity',\n",
       " 'NetIncomeLoss',\n",
       " 'StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest',\n",
       " 'OperatingIncomeLoss',\n",
       " 'CashAndCashEquivalentsAtCarryingValue',\n",
       " 'Revenues',\n",
       " 'Assets',\n",
       " 'IncomeTaxExpenseBenefit',\n",
       " 'ProfitLoss',\n",
       " 'SalesRevenueNet',\n",
       " 'InterestExpense',\n",
       " 'LiabilitiesAndStockholdersEquity',\n",
       " 'AvailableForSaleSecurities',\n",
       " 'IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments',\n",
       " 'CashAndCashEquivalentsPeriodIncreaseDecrease',\n",
       " 'NetCashProvidedByUsedInOperatingActivities',\n",
       " 'PropertyPlantAndEquipmentNet',\n",
       " 'NetCashProvidedByUsedInFinancingActivities',\n",
       " 'AccumulatedOtherComprehensiveIncomeLossNetOfTax',\n",
       " 'ComprehensiveIncomeNetOfTax',\n",
       " 'EarningsPerShareBasic',\n",
       " 'NetCashProvidedByUsedInInvestingActivities',\n",
       " 'LiabilitiesCurrent',\n",
       " 'AssetsCurrent',\n",
       " 'EarningsPerShareDiluted',\n",
       " 'CommonStockValue',\n",
       " 'WeightedAverageNumberOfSharesOutstandingBasic',\n",
       " 'Goodwill',\n",
       " 'CommonStockSharesOutstanding',\n",
       " 'ShareBasedCompensation',\n",
       " 'CommonStockSharesIssued',\n",
       " 'Liabilities',\n",
       " 'GeneralAndAdministrativeExpense',\n",
       " 'OperatingExpenses',\n",
       " 'GrossProfit',\n",
       " 'RetainedEarningsAccumulatedDeficit',\n",
       " 'CommonStockSharesAuthorized',\n",
       " 'AllocatedShareBasedCompensationExpense',\n",
       " 'WeightedAverageNumberOfDilutedSharesOutstanding',\n",
       " 'CommonStockParOrStatedValuePerShare',\n",
       " 'PaymentsToAcquirePropertyPlantAndEquipment',\n",
       " 'LoansAndLeasesReceivableGrossCarryingAmount',\n",
       " 'DepreciationDepletionAndAmortization',\n",
       " 'SellingGeneralAndAdministrativeExpense',\n",
       " 'OtherNonoperatingIncomeExpense',\n",
       " 'AntidilutiveSecuritiesExcludedFromComputationOfEarningsPerShareAmount',\n",
       " 'AccountsPayableCurrent',\n",
       " 'IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest',\n",
       " 'PropertyPlantAndEquipmentGross',\n",
       " 'DebtInstrumentInterestRateStatedPercentage',\n",
       " 'AssetsFairValueDisclosure',\n",
       " 'IncomeLossFromEquityMethodInvestments',\n",
       " 'FiniteLivedIntangibleAssetsAccumulatedAmortization',\n",
       " 'OtherAssetsNoncurrent',\n",
       " 'NonoperatingIncomeExpense',\n",
       " 'LongTermDebt',\n",
       " 'AccountsReceivableNetCurrent',\n",
       " 'DepreciationAndAmortization',\n",
       " 'PreferredStockSharesAuthorized',\n",
       " 'AvailableForSaleSecuritiesAmortizedCost',\n",
       " 'FinancingReceivableRecordedInvestmentPastDue',\n",
       " 'AvailableForSaleSecuritiesFairValueDisclosure',\n",
       " 'PreferredStockValue',\n",
       " 'NetIncomeLossAttributableToNoncontrollingInterest',\n",
       " 'FiniteLivedIntangibleAssetsGross',\n",
       " 'SalesRevenueGoodsNet',\n",
       " 'StockIssuedDuringPeriodValueNewIssues',\n",
       " 'InventoryNet',\n",
       " 'CostsAndExpenses',\n",
       " 'AdjustmentsToAdditionalPaidInCapitalSharebasedCompensationRequisiteServicePeriodRecognitionValue',\n",
       " 'PreferredStockSharesIssued',\n",
       " 'PreferredStockParOrStatedValuePerShare',\n",
       " 'FiniteLivedIntangibleAssetsNet',\n",
       " 'OtherComprehensiveIncomeLossNetOfTax',\n",
       " 'InterestPaid',\n",
       " 'DerivativeFairValueOfDerivativeLiability',\n",
       " 'FairValueMeasurementWithUnobservableInputsReconciliationRecurringBasisAssetValue',\n",
       " 'IncreaseDecreaseInAccountsReceivable',\n",
       " 'OtherLiabilitiesNoncurrent',\n",
       " 'ComprehensiveIncomeNetOfTaxIncludingPortionAttributableToNoncontrollingInterest',\n",
       " 'DerivativeFairValueOfDerivativeAsset',\n",
       " 'LoansAndLeasesReceivableAllowance',\n",
       " 'AdditionalPaidInCapital',\n",
       " 'IntangibleAssetsNetExcludingGoodwill',\n",
       " 'NetIncomeLossAvailableToCommonStockholdersBasic',\n",
       " 'EntityCommonStockSharesOutstanding',\n",
       " 'EarningsPerShareBasicAndDiluted',\n",
       " 'AmortizationOfIntangibleAssets',\n",
       " 'LoansAndLeasesReceivableNetOfDeferredIncome',\n",
       " 'SharesOutstanding',\n",
       " 'InvestmentIncomeInterest',\n",
       " 'CostOfGoodsSold',\n",
       " 'PreferredStockSharesOutstanding',\n",
       " 'CommitmentsAndContingencies',\n",
       " 'DefinedBenefitPlanNetPeriodicBenefitCost',\n",
       " 'ResearchAndDevelopmentExpense',\n",
       " 'AccruedLiabilitiesCurrent',\n",
       " 'DeferredIncomeTaxExpenseBenefit',\n",
       " 'RestructuringCharges',\n",
       " 'IncreaseDecreaseInInventories',\n",
       " 'DefinedBenefitPlanInterestCost',\n",
       " 'LongTermDebtNoncurrent',\n",
       " 'ProceedsFromIssuanceOfCommonStock',\n",
       " 'IncreaseDecreaseInAccountsPayable',\n",
       " 'Depreciation',\n",
       " 'EffectOfExchangeRateOnCashAndCashEquivalents',\n",
       " 'InvestmentsFairValueDisclosure',\n",
       " 'DerivativeAssets',\n",
       " 'DebtInstrumentFaceAmount',\n",
       " 'AdditionalPaidInCapitalCommonStock',\n",
       " 'ImpairedFinancingReceivableAverageRecordedInvestment',\n",
       " 'AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment',\n",
       " 'DefinedBenefitPlanServiceCost',\n",
       " 'DeferredTaxLiabilitiesNoncurrent',\n",
       " 'SharesIssued',\n",
       " 'StockIssuedDuringPeriodValueStockOptionsExercised',\n",
       " 'IncreaseDecreaseInAccountsPayableAndAccruedLiabilities',\n",
       " 'DerivativeLiabilities',\n",
       " 'ConcentrationRiskPercentage1',\n",
       " 'IncomeTaxesPaid',\n",
       " 'InterestIncomeExpenseNet',\n",
       " 'CashAndCashEquivalentsFairValueDisclosure',\n",
       " 'FinancingReceivableRecordedInvestmentCurrent',\n",
       " 'OtherAssetsCurrent',\n",
       " 'FinancingReceivableAllowanceForCreditLosses',\n",
       " 'IncreaseDecreaseInPrepaidDeferredExpenseAndOtherAssets',\n",
       " 'AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThanTwelveMonthsFairValue',\n",
       " 'StockIssuedDuringPeriodValueShareBasedCompensation',\n",
       " 'CostOfRevenue',\n",
       " 'PrepaidExpenseAndOtherAssetsCurrent',\n",
       " 'AvailableForSaleSecuritiesDebtSecurities',\n",
       " 'DeferredTaxAssetsNetCurrent',\n",
       " 'DefinedBenefitPlanExpectedReturnOnPlanAssets',\n",
       " 'DerivativeNotionalAmount',\n",
       " 'ProvisionForLoanAndLeaseLosses',\n",
       " 'IncomeLossFromContinuingOperations',\n",
       " 'ImpairedFinancingReceivableRecordedInvestment',\n",
       " 'MinorityInterest',\n",
       " 'PaymentsForRepurchaseOfCommonStock',\n",
       " 'ShareBasedCompensationArrangementByShareBasedPaymentAwardOptionsOutstandingNumber',\n",
       " 'TreasuryStockValue',\n",
       " 'OtherComprehensiveIncomeUnrealizedHoldingGainLossOnSecuritiesArisingDuringPeriodNetOfTax',\n",
       " 'IncomeLossFromContinuingOperationsIncludingPortionAttributableToNoncontrollingInterest',\n",
       " 'InvestmentOwnedPercentOfNetAssets',\n",
       " 'RepaymentsOfLongTermDebt',\n",
       " 'AvailableForSaleSecuritiesContinuousUnrealizedLossPositionFairValue',\n",
       " 'LiabilitiesFairValueDisclosure',\n",
       " 'ImpairedFinancingReceivableRelatedAllowance',\n",
       " 'StockIssuedDuringPeriodSharesNewIssues',\n",
       " 'DefinedBenefitPlanFairValueOfPlanAssets',\n",
       " 'RestructuringReserve',\n",
       " 'CommonStockDividendsPerShareDeclared',\n",
       " 'AvailableForSaleSecuritiesContinuousUnrealizedLossPositionTwelveMonthsOrLongerFairValue',\n",
       " 'FinancingReceivableRecordedInvestmentNonaccrualStatus',\n",
       " 'DefinedBenefitPlanAmortizationOfGainsLosses',\n",
       " 'OtherComprehensiveIncomeForeignCurrencyTransactionAndTranslationAdjustmentNetOfTaxPeriodIncreaseDecrease',\n",
       " 'DebtInstrumentCarryingAmount',\n",
       " 'IncreaseDecreaseInOtherOperatingAssets',\n",
       " 'LineOfCreditFacilityMaximumBorrowingCapacity',\n",
       " 'ShareBasedCompensationArrangementByShareBasedPaymentAwardOptionsOutstandingWeightedAverageExercisePrice',\n",
       " 'AllowanceForDoubtfulAccountsReceivableCurrent',\n",
       " 'SalesRevenueServicesNet',\n",
       " 'WeightedAverageNumberOfShareOutstandingBasicAndDiluted',\n",
       " 'NotesReceivableNet',\n",
       " 'DerivativeInstrumentsGainLossRecognizedInOtherComprehensiveIncomeEffectivePortionNet',\n",
       " 'NetCashProvidedByUsedInOperatingActivitiesContinuingOperations',\n",
       " 'ImpairedFinancingReceivableUnpaidPrincipalBalance',\n",
       " 'TreasuryStockShares',\n",
       " 'CostOfGoodsAndServicesSold',\n",
       " 'OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent',\n",
       " 'IncrementalCommonSharesAttributableToShareBasedPaymentArrangements',\n",
       " 'ProfessionalFees',\n",
       " 'OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax',\n",
       " 'ProceedsFromStockOptionsExercised',\n",
       " 'DerivativeInstrumentsGainLossReclassifiedFromAccumulatedOCIIntoIncomeEffectivePortionNet',\n",
       " 'IncomeLossFromDiscontinuedOperationsNetOfTax',\n",
       " 'LongTermDebtCurrent',\n",
       " 'DefinedBenefitPlanAmortizationOfPriorServiceCostCredit',\n",
       " 'ImpairedFinancingReceivableInterestIncomeAccrualMethod',\n",
       " 'DerivativeGainLossOnDerivativeNet',\n",
       " 'Cash',\n",
       " 'OtherComprehensiveIncomeLossNetOfTaxPeriodIncreaseDecrease',\n",
       " 'FinancingReceivableCollectivelyEvaluatedForImpairment',\n",
       " 'ComprehensiveIncomeNetOfTaxAttributableToNoncontrollingInterest',\n",
       " 'DividendsCommonStockCash',\n",
       " 'IncreaseDecreaseInAccruedLiabilities',\n",
       " 'FinancingReceivableAllowanceForCreditLossesCollectivelyEvaluatedForImpairment',\n",
       " 'PaymentsForProceedsFromOtherInvestingActivities',\n",
       " 'GainsLossesOnExtinguishmentOfDebt',\n",
       " 'ShareBasedCompensationArrangementByShareBasedPaymentAwardEquityInstrumentsOtherThanOptionsGrantsInPeriod',\n",
       " 'FinancingReceivableIndividuallyEvaluatedForImpairment',\n",
       " 'EmployeeRelatedLiabilitiesCurrent',\n",
       " 'StockIssuedDuringPeriodSharesStockOptionsExercised',\n",
       " 'PaymentsToAcquireBusinessesNetOfCashAcquired',\n",
       " 'OtherAssets',\n",
       " 'ShareBasedCompensationArrangementByShareBasedPaymentAwardEquityInstrumentsOtherThanOptionsNonvestedNumber',\n",
       " 'NetCashProvidedByUsedInInvestingActivitiesContinuingOperations',\n",
       " 'ProceedsFromSaleOfPropertyPlantAndEquipment',\n",
       " 'NetCashProvidedByUsedInFinancingActivitiesContinuingOperations',\n",
       " 'LaborAndRelatedExpense',\n",
       " 'OtherLiabilitiesCurrent',\n",
       " 'ExcessTaxBenefitFromShareBasedCompensationFinancingActivities',\n",
       " 'ProvisionForDoubtfulAccounts',\n",
       " 'OtherComprehensiveIncomeUnrealizedGainLossOnDerivativesArisingDuringPeriodNetOfTax',\n",
       " 'EffectiveIncomeTaxRateContinuingOperations',\n",
       " 'DerivativeInstrumentsGainLossRecognizedInIncomeNet',\n",
       " 'AvailableforsaleSecuritiesGrossUnrealizedGain',\n",
       " 'InvestmentOwnedAtFairValue']"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "freq_tags"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "with open('freq_tags.json', \"w\") as f:\n",
    "    f.write(json.dumps(freq_tags))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Looking into the meaning of columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "8861"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df_nums['submission_number'].unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>submission_number</th>\n",
       "      <th>company_name</th>\n",
       "      <th>measure_tag</th>\n",
       "      <th>version</th>\n",
       "      <th>period_end_date</th>\n",
       "      <th>number_of_quarters</th>\n",
       "      <th>units</th>\n",
       "      <th>dimension_hash</th>\n",
       "      <th>iprx</th>\n",
       "      <th>value</th>\n",
       "      <th>footnote</th>\n",
       "      <th>footnote_length</th>\n",
       "      <th>num_dimensions</th>\n",
       "      <th>coregistrant</th>\n",
       "      <th>duration_fraction</th>\n",
       "      <th>date_fraction</th>\n",
       "      <th>decimal</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>StockholdersEquity</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.101000e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>LiabilitiesAndStockholdersEquity</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20091231</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>2.380000e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>RealEstateHeldforsale</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20091231</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>3.600000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>CashAndCashEquivalentsAtCarryingValue</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20091231</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.600000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>DebtCurrent</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>5.600000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      submission_number             company_name  \\\n",
       "0  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "1  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "2  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "3  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "4  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "\n",
       "                             measure_tag       version  period_end_date  \\\n",
       "0                     StockholdersEquity  us-gaap/2009         20100630   \n",
       "1       LiabilitiesAndStockholdersEquity  us-gaap/2009         20091231   \n",
       "2                  RealEstateHeldforsale  us-gaap/2009         20091231   \n",
       "3  CashAndCashEquivalentsAtCarryingValue  us-gaap/2009         20091231   \n",
       "4                            DebtCurrent  us-gaap/2009         20100630   \n",
       "\n",
       "   number_of_quarters units dimension_hash  iprx         value footnote  \\\n",
       "0                   0   USD     0x00000000     0  1.101000e+09      NaN   \n",
       "1                   0   USD     0x00000000     0  2.380000e+09      NaN   \n",
       "2                   0   USD     0x00000000     0  3.600000e+07      NaN   \n",
       "3                   0   USD     0x00000000     0  1.600000e+07      NaN   \n",
       "4                   0   USD     0x00000000     0  5.600000e+07      NaN   \n",
       "\n",
       "   footnote_length  num_dimensions coregistrant  duration_fraction  \\\n",
       "0                0               0          NaN                0.0   \n",
       "1                0               0          NaN                0.0   \n",
       "2                0               0          NaN                0.0   \n",
       "3                0               0          NaN                0.0   \n",
       "4                0               0          NaN                0.0   \n",
       "\n",
       "   date_fraction  decimal  \n",
       "0            0.0       -5  \n",
       "1            0.0       -5  \n",
       "2            0.0       -5  \n",
       "3            0.0       -5  \n",
       "4            0.0       -5  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_nums.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>submission_number</th>\n",
       "      <th>company_name</th>\n",
       "      <th>measure_tag</th>\n",
       "      <th>version</th>\n",
       "      <th>period_end_date</th>\n",
       "      <th>number_of_quarters</th>\n",
       "      <th>units</th>\n",
       "      <th>dimension_hash</th>\n",
       "      <th>iprx</th>\n",
       "      <th>value</th>\n",
       "      <th>footnote</th>\n",
       "      <th>footnote_length</th>\n",
       "      <th>num_dimensions</th>\n",
       "      <th>coregistrant</th>\n",
       "      <th>duration_fraction</th>\n",
       "      <th>date_fraction</th>\n",
       "      <th>decimal</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>StockholdersEquity</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.101000e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>LiabilitiesAndStockholdersEquity</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20091231</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>2.380000e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>RealEstateHeldforsale</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20091231</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>3.600000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>CashAndCashEquivalentsAtCarryingValue</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20091231</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.600000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>DebtCurrent</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>5.600000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>PropertyPlantAndEquipmentNet</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20091231</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.536000e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>CashAndCashEquivalentsAtCarryingValue</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>3.600000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>EmployeeRelatedLiabilitiesCurrent</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20091231</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.800000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>TreasuryStockValue</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20091231</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.100000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>PensionAndOtherPostretirementDefinedBenefitPla...</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.200000e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>SectionExchangeProceeds</td>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>20091231</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.000000e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>DeferredTaxLiabilitiesNoncurrent</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>4.230000e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>PrepaidExpensesAndOtherAssets</td>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>20091231</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>3.300000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>AccountsPayableCurrent</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.270000e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>OtherAssetsNoncurrent</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20091231</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>2.040000e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>StockholdersEquity</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20091231</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.085000e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>PensionAndOtherPostretirementDefinedBenefitPla...</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20091231</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.160000e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>AccumulatedDepreciationDepletionAndAmortizatio...</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20091231</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.179000e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>AccumulatedOtherComprehensiveIncomeLossNetOfTax</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20091231</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-8.100000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>AdditionalPaidInCapitalCommonStock</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>2.150000e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>UninsuredClaimsCurrent</td>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>20100630</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.100000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>Assets</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>2.461000e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>PropertyPlantAndEquipmentGross</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>2.770000e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>Assets</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20091231</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>2.380000e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>LongTermDebtNoncurrent</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20091231</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>4.060000e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>AccruedAndOtherLiabilities</td>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>20100630</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>8.800000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>DeferredTaxAssetsNetCurrent</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>6.000000e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>DefinedBenefitPlanAssetsForPlanBenefitsNoncurrent</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20091231</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>3.000000e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>InventoryNet</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>5.900000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>OtherAssetsNoncurrent</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>0</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.980000e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\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>421202</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>PaymentsOfDividendsCommonStock</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20090630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>2.600000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421203</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>IncomeLossFromEquityMethodInvestments</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-9.000000e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421204</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>NetCashProvidedByUsedInFinancingActivities</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>3.200000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421205</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>IncomeLossFromDiscontinuedOperationsNetOfTaxPe...</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>4.800000e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421206</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>EarningsPerShareDiluted</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20090630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>3.800000e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421207</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>DepreciationDepletionAndAmortization</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20090630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>5.300000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421208</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>TaxDeferredRealEstateSales</td>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>20100630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>7.600000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421209</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>ProceedsFromIssuancesOfCapitalStockIncludingEx...</td>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>20090630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421210</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>TaxDeferredRealEstatePurchases</td>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>20100630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-5.300000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421211</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>ProceedsFromIssuancesOfCapitalStockIncludingEx...</td>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>20100630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>3.000000e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421212</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>InterestPaidNet</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-1.300000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421213</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>ProceedsFromSaleMaturityAndCollectionsOfInvest...</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.200000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421214</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>NetCashProvidedByUsedInFinancingActivities</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20090630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-5.600000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421215</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>OtherNonoperatingIncome</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.400000e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421216</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>IncomeLossFromContinuingOperationsPerDilutedShare</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20090630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>2.000000e-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421217</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>IncomeLossFromContinuingOperationsPerBasicShare</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20090630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>2.000000e-02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421218</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>ProceedsFromRepaymentsOfShortTermDebt</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20090630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-1.000000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421219</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>OperatingIncomeLoss</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20090630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.390000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421220</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>IncomeLossFromContinuingOperations</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20090630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>8.000000e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421221</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>IncomeLossFromDiscontinuedOperationsNetOfTaxAt...</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.980000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421222</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>PaymentsToAcquireProductiveAssets</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20090630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.900000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421223</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>SalesRevenueNet</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20090630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>6.658000e+08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421224</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>IncomeLossFromDiscontinuedOperationsNetOfTaxPe...</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>4.800000e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421225</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>TaxDeferredRealEstateSales</td>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>20090630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>3.800000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421226</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>WithdrawalsFromCapitalConstructionFund</td>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>20100630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>2.000000e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421227</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20090630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1.560000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421228</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>InvestmentIncomeNet</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>2.000000e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421229</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>PaymentsToAcquireProductiveAssets</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>2.400000e+07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421230</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>IncomeLossFromContinuingOperationsPerBasicShare</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>6.400000e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421231</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>NetCashProvidedByUsedInInvestingActivities</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20090630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>3.000000e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>204 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           submission_number             company_name  \\\n",
       "0       0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "1       0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "2       0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "3       0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "4       0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "5       0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "6       0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "7       0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "8       0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "9       0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "10      0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "11      0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "12      0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "13      0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "14      0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "15      0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "16      0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "17      0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "18      0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "19      0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "20      0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "21      0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "22      0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "23      0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "24      0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "25      0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "26      0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "27      0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "28      0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "29      0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "...                      ...                      ...   \n",
       "421202  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421203  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421204  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421205  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421206  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421207  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421208  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421209  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421210  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421211  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421212  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421213  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421214  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421215  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421216  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421217  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421218  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421219  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421220  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421221  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421222  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421223  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421224  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421225  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421226  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421227  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421228  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421229  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421230  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "421231  0000003453-10-000042  ALEXANDER & BALDWIN INC   \n",
       "\n",
       "                                              measure_tag  \\\n",
       "0                                      StockholdersEquity   \n",
       "1                        LiabilitiesAndStockholdersEquity   \n",
       "2                                   RealEstateHeldforsale   \n",
       "3                   CashAndCashEquivalentsAtCarryingValue   \n",
       "4                                             DebtCurrent   \n",
       "5                            PropertyPlantAndEquipmentNet   \n",
       "6                   CashAndCashEquivalentsAtCarryingValue   \n",
       "7                       EmployeeRelatedLiabilitiesCurrent   \n",
       "8                                      TreasuryStockValue   \n",
       "9       PensionAndOtherPostretirementDefinedBenefitPla...   \n",
       "10                                SectionExchangeProceeds   \n",
       "11                       DeferredTaxLiabilitiesNoncurrent   \n",
       "12                          PrepaidExpensesAndOtherAssets   \n",
       "13                                 AccountsPayableCurrent   \n",
       "14                                  OtherAssetsNoncurrent   \n",
       "15                                     StockholdersEquity   \n",
       "16      PensionAndOtherPostretirementDefinedBenefitPla...   \n",
       "17      AccumulatedDepreciationDepletionAndAmortizatio...   \n",
       "18        AccumulatedOtherComprehensiveIncomeLossNetOfTax   \n",
       "19                     AdditionalPaidInCapitalCommonStock   \n",
       "20                                 UninsuredClaimsCurrent   \n",
       "21                                                 Assets   \n",
       "22                         PropertyPlantAndEquipmentGross   \n",
       "23                                                 Assets   \n",
       "24                                 LongTermDebtNoncurrent   \n",
       "25                             AccruedAndOtherLiabilities   \n",
       "26                            DeferredTaxAssetsNetCurrent   \n",
       "27      DefinedBenefitPlanAssetsForPlanBenefitsNoncurrent   \n",
       "28                                           InventoryNet   \n",
       "29                                  OtherAssetsNoncurrent   \n",
       "...                                                   ...   \n",
       "421202                     PaymentsOfDividendsCommonStock   \n",
       "421203              IncomeLossFromEquityMethodInvestments   \n",
       "421204         NetCashProvidedByUsedInFinancingActivities   \n",
       "421205  IncomeLossFromDiscontinuedOperationsNetOfTaxPe...   \n",
       "421206                            EarningsPerShareDiluted   \n",
       "421207               DepreciationDepletionAndAmortization   \n",
       "421208                         TaxDeferredRealEstateSales   \n",
       "421209  ProceedsFromIssuancesOfCapitalStockIncludingEx...   \n",
       "421210                     TaxDeferredRealEstatePurchases   \n",
       "421211  ProceedsFromIssuancesOfCapitalStockIncludingEx...   \n",
       "421212                                    InterestPaidNet   \n",
       "421213  ProceedsFromSaleMaturityAndCollectionsOfInvest...   \n",
       "421214         NetCashProvidedByUsedInFinancingActivities   \n",
       "421215                            OtherNonoperatingIncome   \n",
       "421216  IncomeLossFromContinuingOperationsPerDilutedShare   \n",
       "421217    IncomeLossFromContinuingOperationsPerBasicShare   \n",
       "421218              ProceedsFromRepaymentsOfShortTermDebt   \n",
       "421219                                OperatingIncomeLoss   \n",
       "421220                 IncomeLossFromContinuingOperations   \n",
       "421221  IncomeLossFromDiscontinuedOperationsNetOfTaxAt...   \n",
       "421222                  PaymentsToAcquireProductiveAssets   \n",
       "421223                                    SalesRevenueNet   \n",
       "421224  IncomeLossFromDiscontinuedOperationsNetOfTaxPe...   \n",
       "421225                         TaxDeferredRealEstateSales   \n",
       "421226             WithdrawalsFromCapitalConstructionFund   \n",
       "421227                                      NetIncomeLoss   \n",
       "421228                                InvestmentIncomeNet   \n",
       "421229                  PaymentsToAcquireProductiveAssets   \n",
       "421230    IncomeLossFromContinuingOperationsPerBasicShare   \n",
       "421231         NetCashProvidedByUsedInInvestingActivities   \n",
       "\n",
       "                     version  period_end_date  number_of_quarters units  \\\n",
       "0               us-gaap/2009         20100630                   0   USD   \n",
       "1               us-gaap/2009         20091231                   0   USD   \n",
       "2               us-gaap/2009         20091231                   0   USD   \n",
       "3               us-gaap/2009         20091231                   0   USD   \n",
       "4               us-gaap/2009         20100630                   0   USD   \n",
       "5               us-gaap/2009         20091231                   0   USD   \n",
       "6               us-gaap/2009         20100630                   0   USD   \n",
       "7               us-gaap/2009         20091231                   0   USD   \n",
       "8               us-gaap/2009         20091231                   0   USD   \n",
       "9               us-gaap/2009         20100630                   0   USD   \n",
       "10      0000003453-10-000042         20091231                   0   USD   \n",
       "11              us-gaap/2009         20100630                   0   USD   \n",
       "12      0000003453-10-000042         20091231                   0   USD   \n",
       "13              us-gaap/2009         20100630                   0   USD   \n",
       "14              us-gaap/2009         20091231                   0   USD   \n",
       "15              us-gaap/2009         20091231                   0   USD   \n",
       "16              us-gaap/2009         20091231                   0   USD   \n",
       "17              us-gaap/2009         20091231                   0   USD   \n",
       "18              us-gaap/2009         20091231                   0   USD   \n",
       "19              us-gaap/2009         20100630                   0   USD   \n",
       "20      0000003453-10-000042         20100630                   0   USD   \n",
       "21              us-gaap/2009         20100630                   0   USD   \n",
       "22              us-gaap/2009         20100630                   0   USD   \n",
       "23              us-gaap/2009         20091231                   0   USD   \n",
       "24              us-gaap/2009         20091231                   0   USD   \n",
       "25      0000003453-10-000042         20100630                   0   USD   \n",
       "26              us-gaap/2009         20100630                   0   USD   \n",
       "27              us-gaap/2009         20091231                   0   USD   \n",
       "28              us-gaap/2009         20100630                   0   USD   \n",
       "29              us-gaap/2009         20100630                   0   USD   \n",
       "...                      ...              ...                 ...   ...   \n",
       "421202          us-gaap/2009         20090630                   2   USD   \n",
       "421203          us-gaap/2009         20100630                   2   USD   \n",
       "421204          us-gaap/2009         20100630                   2   USD   \n",
       "421205          us-gaap/2009         20100630                   2   USD   \n",
       "421206          us-gaap/2009         20090630                   2   USD   \n",
       "421207          us-gaap/2009         20090630                   2   USD   \n",
       "421208  0000003453-10-000042         20100630                   2   USD   \n",
       "421209  0000003453-10-000042         20090630                   2   USD   \n",
       "421210  0000003453-10-000042         20100630                   2   USD   \n",
       "421211  0000003453-10-000042         20100630                   2   USD   \n",
       "421212          us-gaap/2009         20100630                   2   USD   \n",
       "421213          us-gaap/2009         20100630                   2   USD   \n",
       "421214          us-gaap/2009         20090630                   2   USD   \n",
       "421215          us-gaap/2009         20100630                   2   USD   \n",
       "421216          us-gaap/2009         20090630                   2   USD   \n",
       "421217          us-gaap/2009         20090630                   2   USD   \n",
       "421218          us-gaap/2009         20090630                   2   USD   \n",
       "421219          us-gaap/2009         20090630                   2   USD   \n",
       "421220          us-gaap/2009         20090630                   2   USD   \n",
       "421221          us-gaap/2009         20100630                   2   USD   \n",
       "421222          us-gaap/2009         20090630                   2   USD   \n",
       "421223          us-gaap/2009         20090630                   2   USD   \n",
       "421224          us-gaap/2009         20100630                   2   USD   \n",
       "421225  0000003453-10-000042         20090630                   2   USD   \n",
       "421226  0000003453-10-000042         20100630                   2   USD   \n",
       "421227          us-gaap/2009         20090630                   2   USD   \n",
       "421228          us-gaap/2009         20100630                   2   USD   \n",
       "421229          us-gaap/2009         20100630                   2   USD   \n",
       "421230          us-gaap/2009         20100630                   2   USD   \n",
       "421231          us-gaap/2009         20090630                   2   USD   \n",
       "\n",
       "       dimension_hash  iprx         value footnote  footnote_length  \\\n",
       "0          0x00000000     0  1.101000e+09      NaN                0   \n",
       "1          0x00000000     0  2.380000e+09      NaN                0   \n",
       "2          0x00000000     0  3.600000e+07      NaN                0   \n",
       "3          0x00000000     0  1.600000e+07      NaN                0   \n",
       "4          0x00000000     0  5.600000e+07      NaN                0   \n",
       "5          0x00000000     0  1.536000e+09      NaN                0   \n",
       "6          0x00000000     0  3.600000e+07      NaN                0   \n",
       "7          0x00000000     0  1.800000e+07      NaN                0   \n",
       "8          0x00000000     0  1.100000e+07      NaN                0   \n",
       "9          0x00000000     0  1.200000e+08      NaN                0   \n",
       "10         0x00000000     0  1.000000e+06      NaN                0   \n",
       "11         0x00000000     0  4.230000e+08      NaN                0   \n",
       "12         0x00000000     0  3.300000e+07      NaN                0   \n",
       "13         0x00000000     0  1.270000e+08      NaN                0   \n",
       "14         0x00000000     0  2.040000e+08      NaN                0   \n",
       "15         0x00000000     0  1.085000e+09      NaN                0   \n",
       "16         0x00000000     0  1.160000e+08      NaN                0   \n",
       "17         0x00000000     0  1.179000e+09      NaN                0   \n",
       "18         0x00000000     0 -8.100000e+07      NaN                0   \n",
       "19         0x00000000     0  2.150000e+08      NaN                0   \n",
       "20         0x00000000     0  1.100000e+07      NaN                0   \n",
       "21         0x00000000     0  2.461000e+09      NaN                0   \n",
       "22         0x00000000     0  2.770000e+09      NaN                0   \n",
       "23         0x00000000     0  2.380000e+09      NaN                0   \n",
       "24         0x00000000     0  4.060000e+08      NaN                0   \n",
       "25         0x00000000     0  8.800000e+07      NaN                0   \n",
       "26         0x00000000     0  6.000000e+06      NaN                0   \n",
       "27         0x00000000     0  3.000000e+06      NaN                0   \n",
       "28         0x00000000     0  5.900000e+07      NaN                0   \n",
       "29         0x00000000     0  1.980000e+08      NaN                0   \n",
       "...               ...   ...           ...      ...              ...   \n",
       "421202     0x00000000     0  2.600000e+07      NaN                0   \n",
       "421203     0x00000000     0 -9.000000e+05      NaN                0   \n",
       "421204     0x00000000     0  3.200000e+07      NaN                0   \n",
       "421205     0x00000000     0  4.800000e-01      NaN                0   \n",
       "421206     0x00000000     0  3.800000e-01      NaN                0   \n",
       "421207     0x00000000     0  5.300000e+07      NaN                0   \n",
       "421208     0x00000000     0  7.600000e+07      NaN                0   \n",
       "421209     0x00000000     0  0.000000e+00      NaN                0   \n",
       "421210     0x00000000     0 -5.300000e+07      NaN                0   \n",
       "421211     0x00000000     0  3.000000e+06      NaN                0   \n",
       "421212     0x00000000     0 -1.300000e+07      NaN                0   \n",
       "421213     0x00000000     0  1.200000e+07      NaN                0   \n",
       "421214     0x00000000     0 -5.600000e+07      NaN                0   \n",
       "421215     0x00000000     0  1.400000e+06      NaN                0   \n",
       "421216     0x00000000     0  2.000000e-02      NaN                0   \n",
       "421217     0x00000000     0  2.000000e-02      NaN                0   \n",
       "421218     0x00000000     0 -1.000000e+07      NaN                0   \n",
       "421219     0x00000000     0  1.390000e+07      NaN                0   \n",
       "421220     0x00000000     0  8.000000e+05      NaN                0   \n",
       "421221     0x00000000     0  1.980000e+07      NaN                0   \n",
       "421222     0x00000000     0  1.900000e+07      NaN                0   \n",
       "421223     0x00000000     0  6.658000e+08      NaN                0   \n",
       "421224     0x00000000     0  4.800000e-01      NaN                0   \n",
       "421225     0x00000000     0  3.800000e+07      NaN                0   \n",
       "421226     0x00000000     0  2.000000e+06      NaN                0   \n",
       "421227     0x00000000     0  1.560000e+07      NaN                0   \n",
       "421228     0x00000000     0  2.000000e+06      NaN                0   \n",
       "421229     0x00000000     0  2.400000e+07      NaN                0   \n",
       "421230     0x00000000     0  6.400000e-01      NaN                0   \n",
       "421231     0x00000000     0  3.000000e+06      NaN                0   \n",
       "\n",
       "        num_dimensions coregistrant  duration_fraction  date_fraction  decimal  \n",
       "0                    0          NaN           0.000000            0.0       -5  \n",
       "1                    0          NaN           0.000000            0.0       -5  \n",
       "2                    0          NaN           0.000000            0.0       -5  \n",
       "3                    0          NaN           0.000000            0.0       -5  \n",
       "4                    0          NaN           0.000000            0.0       -5  \n",
       "5                    0          NaN           0.000000            0.0       -5  \n",
       "6                    0          NaN           0.000000            0.0       -5  \n",
       "7                    0          NaN           0.000000            0.0       -5  \n",
       "8                    0          NaN           0.000000            0.0       -5  \n",
       "9                    0          NaN           0.000000            0.0       -5  \n",
       "10                   0          NaN           0.000000            0.0       -5  \n",
       "11                   0          NaN           0.000000            0.0       -5  \n",
       "12                   0          NaN           0.000000            0.0       -5  \n",
       "13                   0          NaN           0.000000            0.0       -5  \n",
       "14                   0          NaN           0.000000            0.0       -5  \n",
       "15                   0          NaN           0.000000            0.0       -5  \n",
       "16                   0          NaN           0.000000            0.0       -5  \n",
       "17                   0          NaN           0.000000            0.0       -5  \n",
       "18                   0          NaN           0.000000            0.0       -5  \n",
       "19                   0          NaN           0.000000            0.0       -5  \n",
       "20                   0          NaN           0.000000            0.0       -5  \n",
       "21                   0          NaN           0.000000            0.0       -5  \n",
       "22                   0          NaN           0.000000            0.0       -5  \n",
       "23                   0          NaN           0.000000            0.0       -5  \n",
       "24                   0          NaN           0.000000            0.0       -5  \n",
       "25                   0          NaN           0.000000            0.0       -5  \n",
       "26                   0          NaN           0.000000            0.0       -5  \n",
       "27                   0          NaN           0.000000            0.0       -5  \n",
       "28                   0          NaN           0.000000            0.0       -5  \n",
       "29                   0          NaN           0.000000            0.0       -5  \n",
       "...                ...          ...                ...            ...      ...  \n",
       "421202               0          NaN           0.027398            0.0       -5  \n",
       "421203               0          NaN           0.027398            0.0       -5  \n",
       "421204               0          NaN           0.027398            0.0       -5  \n",
       "421205               0          NaN           0.027398            0.0        2  \n",
       "421206               0          NaN           0.027398            0.0        2  \n",
       "421207               0          NaN           0.027398            0.0       -5  \n",
       "421208               0          NaN           0.027398            0.0       -5  \n",
       "421209               0          NaN           0.027398            0.0       -5  \n",
       "421210               0          NaN           0.027398            0.0       -5  \n",
       "421211               0          NaN           0.027398            0.0       -5  \n",
       "421212               0          NaN           0.027398            0.0       -5  \n",
       "421213               0          NaN           0.027398            0.0       -5  \n",
       "421214               0          NaN           0.027398            0.0       -5  \n",
       "421215               0          NaN           0.027398            0.0       -5  \n",
       "421216               0          NaN           0.027398            0.0        2  \n",
       "421217               0          NaN           0.027398            0.0        2  \n",
       "421218               0          NaN           0.027398            0.0       -5  \n",
       "421219               0          NaN           0.027398            0.0       -5  \n",
       "421220               0          NaN           0.027398            0.0       -5  \n",
       "421221               0          NaN           0.027398            0.0       -5  \n",
       "421222               0          NaN           0.027398            0.0       -5  \n",
       "421223               0          NaN           0.027398            0.0       -5  \n",
       "421224               0          NaN           0.027398            0.0        2  \n",
       "421225               0          NaN           0.027398            0.0       -5  \n",
       "421226               0          NaN           0.027398            0.0       -5  \n",
       "421227               0          NaN           0.027398            0.0       -5  \n",
       "421228               0          NaN           0.027398            0.0       -5  \n",
       "421229               0          NaN           0.027398            0.0       -5  \n",
       "421230               0          NaN           0.027398            0.0        2  \n",
       "421231               0          NaN           0.027398            0.0       -5  \n",
       "\n",
       "[204 rows x 17 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_nums[df_nums['submission_number']=='0000003453-10-000042']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "IncomeTaxExpenseBenefit                                                      4\n",
       "NetIncomeLoss                                                                4\n",
       "InterestExpense                                                              4\n",
       "IncomeLossFromDiscontinuedOperationsNetOfTaxAttributableToReportingEntity    4\n",
       "SalesRevenueNet                                                              4\n",
       "IncomeBeforeTaxes                                                            4\n",
       "OperatingExpenses                                                            4\n",
       "EarningsPerShareDiluted                                                      4\n",
       "WeightedAverageNumberOfDilutedSharesOutstanding                              4\n",
       "IncomeLossFromContinuingOperations                                           4\n",
       "EarningsPerShareBasic                                                        4\n",
       "OperatingIncomeLoss                                                          4\n",
       "IncomeLossFromDiscontinuedOperationsNetOfTaxPerDilutedShare                  4\n",
       "InvestmentIncomeNet                                                          4\n",
       "CostOfGoodsAndServicesSold                                                   4\n",
       "CommonStockDividendsPerShareCashPaid                                         4\n",
       "IncomeLossFromContinuingOperationsPerDilutedShare                            4\n",
       "IncomeLossFromContinuingOperationsPerBasicShare                              4\n",
       "WeightedAverageNumberOfSharesOutstandingBasic                                4\n",
       "SellingGeneralAndAdministrativeExpense                                       4\n",
       "IncomeLossFromDiscontinuedOperationsNetOfTaxPerBasicShare                    4\n",
       "OtherNonoperatingIncome                                                      4\n",
       "IncomeLossFromEquityMethodInvestments                                        4\n",
       "TreasuryStockValue                                                           2\n",
       "AccruedAndOtherLiabilities                                                   2\n",
       "OtherAssetsNoncurrent                                                        2\n",
       "DividendsPayableAmount                                                       2\n",
       "PropertyPlantAndEquipmentGross                                               2\n",
       "TaxDeferredRealEstateSales                                                   2\n",
       "DefinedBenefitPlanAssetsForPlanBenefitsNoncurrent                            2\n",
       "                                                                            ..\n",
       "AccountsPayableCurrent                                                       2\n",
       "IncomeTaxesPaidNet                                                           2\n",
       "InterestPaidNet                                                              2\n",
       "PaymentsOfDividendsCommonStock                                               2\n",
       "CashAndCashEquivalentsAtCarryingValue                                        2\n",
       "ProceedsFromIssuancesOfCapitalStockIncludingExcessTaxBenefit                 2\n",
       "InventoryRealEstateLandAndLandDevelopmentCosts                               2\n",
       "TaxDeferredRealEstatePurchases                                               2\n",
       "LongTermDebtNoncurrent                                                       2\n",
       "RealEstateHeldforsale                                                        2\n",
       "InvestmentsInAffiliatesSubsidiariesAssociatesAndJointVentures                2\n",
       "ReceivablesNetCurrent                                                        2\n",
       "AccumulatedOtherComprehensiveIncomeLossNetOfTax                              2\n",
       "AdditionalPaidInCapitalCommonStock                                           2\n",
       "ProceedsFromSaleMaturityAndCollectionsOfInvestments                          2\n",
       "ProceedsFromRepaymentsOfShortTermDebt                                        2\n",
       "DeferredTaxAssetsNetCurrent                                                  2\n",
       "LiabilitiesAndStockholdersEquity                                             2\n",
       "PropertyPlantAndEquipmentNet                                                 2\n",
       "EmployeeRelatedLiabilitiesCurrent                                            2\n",
       "NetCashProvidedByUsedInFinancingActivities                                   2\n",
       "DeferredTaxLiabilitiesNoncurrent                                             2\n",
       "StockholdersEquity                                                           2\n",
       "WithdrawalsFromCapitalConstructionFund                                       2\n",
       "RepaymentsOfLongTermDebt                                                     2\n",
       "InventoryNet                                                                 2\n",
       "LiabilitiesCurrent                                                           2\n",
       "PensionAndOtherPostretirementDefinedBenefitPlansLiabilitiesNoncurrent        2\n",
       "EntityPublicFloat                                                            1\n",
       "EntityCommonStockSharesOutstanding                                           1\n",
       "Name: measure_tag, Length: 80, dtype: int64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_nums[df_nums['submission_number']=='0000003453-10-000042']['measure_tag'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>submission_number</th>\n",
       "      <th>company_name</th>\n",
       "      <th>measure_tag</th>\n",
       "      <th>version</th>\n",
       "      <th>period_end_date</th>\n",
       "      <th>number_of_quarters</th>\n",
       "      <th>units</th>\n",
       "      <th>dimension_hash</th>\n",
       "      <th>iprx</th>\n",
       "      <th>value</th>\n",
       "      <th>footnote</th>\n",
       "      <th>footnote_length</th>\n",
       "      <th>num_dimensions</th>\n",
       "      <th>coregistrant</th>\n",
       "      <th>duration_fraction</th>\n",
       "      <th>date_fraction</th>\n",
       "      <th>decimal</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>289335</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20090630</td>\n",
       "      <td>1</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>12600000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.013699</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289340</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>1</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>28900000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.013699</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421200</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>46200000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421227</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20090630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>15600000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           submission_number             company_name    measure_tag  \\\n",
       "289335  0000003453-10-000042  ALEXANDER & BALDWIN INC  NetIncomeLoss   \n",
       "289340  0000003453-10-000042  ALEXANDER & BALDWIN INC  NetIncomeLoss   \n",
       "421200  0000003453-10-000042  ALEXANDER & BALDWIN INC  NetIncomeLoss   \n",
       "421227  0000003453-10-000042  ALEXANDER & BALDWIN INC  NetIncomeLoss   \n",
       "\n",
       "             version  period_end_date  number_of_quarters units  \\\n",
       "289335  us-gaap/2009         20090630                   1   USD   \n",
       "289340  us-gaap/2009         20100630                   1   USD   \n",
       "421200  us-gaap/2009         20100630                   2   USD   \n",
       "421227  us-gaap/2009         20090630                   2   USD   \n",
       "\n",
       "       dimension_hash  iprx       value footnote  footnote_length  \\\n",
       "289335     0x00000000     0  12600000.0      NaN                0   \n",
       "289340     0x00000000     0  28900000.0      NaN                0   \n",
       "421200     0x00000000     0  46200000.0      NaN                0   \n",
       "421227     0x00000000     0  15600000.0      NaN                0   \n",
       "\n",
       "        num_dimensions coregistrant  duration_fraction  date_fraction  decimal  \n",
       "289335               0          NaN           0.013699            0.0       -5  \n",
       "289340               0          NaN           0.013699            0.0       -5  \n",
       "421200               0          NaN           0.027398            0.0       -5  \n",
       "421227               0          NaN           0.027398            0.0       -5  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_nums[(df_nums['submission_number']=='0000003453-10-000042')&(df_nums['measure_tag']=='NetIncomeLoss')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>submission_number</th>\n",
       "      <th>company_name</th>\n",
       "      <th>measure_tag</th>\n",
       "      <th>version</th>\n",
       "      <th>period_end_date</th>\n",
       "      <th>number_of_quarters</th>\n",
       "      <th>units</th>\n",
       "      <th>dimension_hash</th>\n",
       "      <th>iprx</th>\n",
       "      <th>value</th>\n",
       "      <th>footnote</th>\n",
       "      <th>footnote_length</th>\n",
       "      <th>num_dimensions</th>\n",
       "      <th>coregistrant</th>\n",
       "      <th>duration_fraction</th>\n",
       "      <th>date_fraction</th>\n",
       "      <th>decimal</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>289335</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20090630</td>\n",
       "      <td>1</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>12600000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.013699</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289340</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>1</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>28900000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.013699</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421200</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20100630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>46200000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421227</th>\n",
       "      <td>0000003453-10-000042</td>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2009</td>\n",
       "      <td>20090630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>15600000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           submission_number             company_name    measure_tag  \\\n",
       "289335  0000003453-10-000042  ALEXANDER & BALDWIN INC  NetIncomeLoss   \n",
       "289340  0000003453-10-000042  ALEXANDER & BALDWIN INC  NetIncomeLoss   \n",
       "421200  0000003453-10-000042  ALEXANDER & BALDWIN INC  NetIncomeLoss   \n",
       "421227  0000003453-10-000042  ALEXANDER & BALDWIN INC  NetIncomeLoss   \n",
       "\n",
       "             version  period_end_date  number_of_quarters units  \\\n",
       "289335  us-gaap/2009         20090630                   1   USD   \n",
       "289340  us-gaap/2009         20100630                   1   USD   \n",
       "421200  us-gaap/2009         20100630                   2   USD   \n",
       "421227  us-gaap/2009         20090630                   2   USD   \n",
       "\n",
       "       dimension_hash  iprx       value footnote  footnote_length  \\\n",
       "289335     0x00000000     0  12600000.0      NaN                0   \n",
       "289340     0x00000000     0  28900000.0      NaN                0   \n",
       "421200     0x00000000     0  46200000.0      NaN                0   \n",
       "421227     0x00000000     0  15600000.0      NaN                0   \n",
       "\n",
       "        num_dimensions coregistrant  duration_fraction  date_fraction  decimal  \n",
       "289335               0          NaN           0.013699            0.0       -5  \n",
       "289340               0          NaN           0.013699            0.0       -5  \n",
       "421200               0          NaN           0.027398            0.0       -5  \n",
       "421227               0          NaN           0.027398            0.0       -5  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_nums[(df_nums['submission_number'].str.startswith('0000003453'))&(df_nums['measure_tag']=='NetIncomeLoss')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "compname_sub = df_nums[df_nums['number_of_quarters']==1][['company_name','submission_number']].drop_duplicates().groupby('company_name').count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "compname_sub = compname_sub.reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>company_name</th>\n",
       "      <th>submission_number</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>ALEXANDER &amp; BALDWIN INC</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                company_name  submission_number\n",
       "220  ALEXANDER & BALDWIN INC                  1"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "compname_sub[compname_sub['company_name']==\"ALEXANDER & BALDWIN INC\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>company_name</th>\n",
       "      <th>submission_number</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2081</th>\n",
       "      <td>EMPIRE GLOBAL CORP.</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6054</th>\n",
       "      <td>TETRIDYN SOLUTIONS INC</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6788</th>\n",
       "      <td>XIANGTIAN (USA) AIR POWER CO., LTD.</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2566</th>\n",
       "      <td>FUTURE HEALTHCARE OF AMERICA</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>945</th>\n",
       "      <td>BONANZA GOLD CORP.</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1216</th>\n",
       "      <td>CD INTERNATIONAL ENTERPRISES, INC.</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5584</th>\n",
       "      <td>SITO MOBILE, LTD.</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1105</th>\n",
       "      <td>CANNAVEST CORP.</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3472</th>\n",
       "      <td>KBR, INC.</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>731</th>\n",
       "      <td>B4MC GOLD MINES INC</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>912</th>\n",
       "      <td>BLUE CALYPSO, INC.</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2395</th>\n",
       "      <td>FIRST DATA CORP</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6673</th>\n",
       "      <td>WESTPORT ENERGY HOLDINGS INC.</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5305</th>\n",
       "      <td>ROADSHIPS HOLDINGS, INC.</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5975</th>\n",
       "      <td>TARGACEPT INC</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5652</th>\n",
       "      <td>SONOCO PRODUCTS CO</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4117</th>\n",
       "      <td>MOLSON COORS BREWING CO</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1960</th>\n",
       "      <td>DYNACQ HEALTHCARE INC</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2959</th>\n",
       "      <td>HERTZ CORP</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2960</th>\n",
       "      <td>HERTZ GLOBAL HOLDINGS INC</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1886</th>\n",
       "      <td>DIRECTV</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4747</th>\n",
       "      <td>PBF LOGISTICS LP</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4663</th>\n",
       "      <td>PACIFIC GREEN TECHNOLOGIES INC.</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6379</th>\n",
       "      <td>UNIVERSAL SECURITY INSTRUMENTS INC</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2594</th>\n",
       "      <td>GAWK INC.</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6787</th>\n",
       "      <td>XG TECHNOLOGY, INC.</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3232</th>\n",
       "      <td>INSPIRED BUILDERS, INC.</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>889</th>\n",
       "      <td>BLACK HILLS CORP /SD/</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1497</th>\n",
       "      <td>COLLABRX, INC.</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>677</th>\n",
       "      <td>AUDIOEYE INC</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2502</th>\n",
       "      <td>FORTRESS TRANSPORTATION &amp; INFRASTRUCTURE INVES...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2501</th>\n",
       "      <td>FORTRESS INVESTMENT GROUP LLC</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2500</th>\n",
       "      <td>FORTRESS BIOTECH, INC.</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2499</th>\n",
       "      <td>FORTINET INC</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2498</th>\n",
       "      <td>FORRESTER RESEARCH, INC.</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2497</th>\n",
       "      <td>FORMIGLI INC.</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2519</th>\n",
       "      <td>FRANK'S INTERNATIONAL N.V.</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2520</th>\n",
       "      <td>FRANKLIN COVEY CO</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2522</th>\n",
       "      <td>FRANKLIN FINANCIAL NETWORK INC.</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2523</th>\n",
       "      <td>FRANKLIN FINANCIAL SERVICES CORP /PA/</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2549</th>\n",
       "      <td>FTD COMPANIES, INC.</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2548</th>\n",
       "      <td>FSP 303 EAST WACKER DRIVE CORP.</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2547</th>\n",
       "      <td>FS BANCORP, INC.</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2545</th>\n",
       "      <td>FRONTIER OILFIELD SERVICES INC</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2544</th>\n",
       "      <td>FRONTIER OIL CORP /NEW/</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2542</th>\n",
       "      <td>FRISCHS RESTAURANTS INC</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2541</th>\n",
       "      <td>FRIEDMAN INDUSTRIES INC</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2540</th>\n",
       "      <td>FRESHPET, INC.</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2539</th>\n",
       "      <td>FRESH PROMISE FOODS, INC.</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2538</th>\n",
       "      <td>FRESH MEDICAL LABORATORIES, INC.</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2537</th>\n",
       "      <td>FRESH MARKET, INC.</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2534</th>\n",
       "      <td>FREQUENCY ELECTRONICS INC</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2533</th>\n",
       "      <td>FREIGHTCAR AMERICA, INC.</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2532</th>\n",
       "      <td>FREEZE TAG, INC.</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2531</th>\n",
       "      <td>FREESCALE SEMICONDUCTOR, LTD.</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2530</th>\n",
       "      <td>FREEPORT-MCMORAN INC</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2529</th>\n",
       "      <td>FREEPORT MCMORAN COPPER &amp; GOLD INC</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2527</th>\n",
       "      <td>FREE FLOW, INC.</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2526</th>\n",
       "      <td>FREDS INC</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6868</th>\n",
       "      <td>ZYNGA INC</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6869 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           company_name  submission_number\n",
       "2081                                EMPIRE GLOBAL CORP.                 13\n",
       "6054                             TETRIDYN SOLUTIONS INC                  8\n",
       "6788                XIANGTIAN (USA) AIR POWER CO., LTD.                  8\n",
       "2566                       FUTURE HEALTHCARE OF AMERICA                  8\n",
       "945                                  BONANZA GOLD CORP.                  6\n",
       "1216                 CD INTERNATIONAL ENTERPRISES, INC.                  6\n",
       "5584                                  SITO MOBILE, LTD.                  5\n",
       "1105                                    CANNAVEST CORP.                  5\n",
       "3472                                          KBR, INC.                  5\n",
       "731                                 B4MC GOLD MINES INC                  5\n",
       "912                                  BLUE CALYPSO, INC.                  5\n",
       "2395                                    FIRST DATA CORP                  5\n",
       "6673                      WESTPORT ENERGY HOLDINGS INC.                  5\n",
       "5305                           ROADSHIPS HOLDINGS, INC.                  5\n",
       "5975                                      TARGACEPT INC                  4\n",
       "5652                                 SONOCO PRODUCTS CO                  4\n",
       "4117                            MOLSON COORS BREWING CO                  4\n",
       "1960                              DYNACQ HEALTHCARE INC                  4\n",
       "2959                                         HERTZ CORP                  4\n",
       "2960                          HERTZ GLOBAL HOLDINGS INC                  4\n",
       "1886                                            DIRECTV                  4\n",
       "4747                                   PBF LOGISTICS LP                  4\n",
       "4663                    PACIFIC GREEN TECHNOLOGIES INC.                  4\n",
       "6379                 UNIVERSAL SECURITY INSTRUMENTS INC                  4\n",
       "2594                                          GAWK INC.                  4\n",
       "6787                                XG TECHNOLOGY, INC.                  4\n",
       "3232                            INSPIRED BUILDERS, INC.                  4\n",
       "889                               BLACK HILLS CORP /SD/                  4\n",
       "1497                                     COLLABRX, INC.                  4\n",
       "677                                        AUDIOEYE INC                  3\n",
       "...                                                 ...                ...\n",
       "2502  FORTRESS TRANSPORTATION & INFRASTRUCTURE INVES...                  1\n",
       "2501                      FORTRESS INVESTMENT GROUP LLC                  1\n",
       "2500                             FORTRESS BIOTECH, INC.                  1\n",
       "2499                                       FORTINET INC                  1\n",
       "2498                           FORRESTER RESEARCH, INC.                  1\n",
       "2497                                      FORMIGLI INC.                  1\n",
       "2519                         FRANK'S INTERNATIONAL N.V.                  1\n",
       "2520                                  FRANKLIN COVEY CO                  1\n",
       "2522                    FRANKLIN FINANCIAL NETWORK INC.                  1\n",
       "2523              FRANKLIN FINANCIAL SERVICES CORP /PA/                  1\n",
       "2549                                FTD COMPANIES, INC.                  1\n",
       "2548                    FSP 303 EAST WACKER DRIVE CORP.                  1\n",
       "2547                                   FS BANCORP, INC.                  1\n",
       "2545                     FRONTIER OILFIELD SERVICES INC                  1\n",
       "2544                            FRONTIER OIL CORP /NEW/                  1\n",
       "2542                            FRISCHS RESTAURANTS INC                  1\n",
       "2541                            FRIEDMAN INDUSTRIES INC                  1\n",
       "2540                                     FRESHPET, INC.                  1\n",
       "2539                          FRESH PROMISE FOODS, INC.                  1\n",
       "2538                   FRESH MEDICAL LABORATORIES, INC.                  1\n",
       "2537                                 FRESH MARKET, INC.                  1\n",
       "2534                          FREQUENCY ELECTRONICS INC                  1\n",
       "2533                           FREIGHTCAR AMERICA, INC.                  1\n",
       "2532                                   FREEZE TAG, INC.                  1\n",
       "2531                      FREESCALE SEMICONDUCTOR, LTD.                  1\n",
       "2530                               FREEPORT-MCMORAN INC                  1\n",
       "2529                 FREEPORT MCMORAN COPPER & GOLD INC                  1\n",
       "2527                                    FREE FLOW, INC.                  1\n",
       "2526                                          FREDS INC                  1\n",
       "6868                                          ZYNGA INC                  1\n",
       "\n",
       "[6869 rows x 2 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "compname_sub.sort_values(by=['submission_number'], ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>submission_number</th>\n",
       "      <th>company_name</th>\n",
       "      <th>measure_tag</th>\n",
       "      <th>version</th>\n",
       "      <th>period_end_date</th>\n",
       "      <th>number_of_quarters</th>\n",
       "      <th>units</th>\n",
       "      <th>dimension_hash</th>\n",
       "      <th>iprx</th>\n",
       "      <th>value</th>\n",
       "      <th>footnote</th>\n",
       "      <th>footnote_length</th>\n",
       "      <th>num_dimensions</th>\n",
       "      <th>coregistrant</th>\n",
       "      <th>duration_fraction</th>\n",
       "      <th>date_fraction</th>\n",
       "      <th>decimal</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>716665</th>\n",
       "      <td>0001017386-15-000147</td>\n",
       "      <td>EMPIRE GLOBAL CORP.</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2015</td>\n",
       "      <td>20120630</td>\n",
       "      <td>10</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-116393.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.060274</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>724426</th>\n",
       "      <td>0001017386-15-000149</td>\n",
       "      <td>EMPIRE GLOBAL CORP.</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2015</td>\n",
       "      <td>20120930</td>\n",
       "      <td>3</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-12218.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.008220</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>728706</th>\n",
       "      <td>0001017386-15-000163</td>\n",
       "      <td>EMPIRE GLOBAL CORP.</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2015</td>\n",
       "      <td>20130630</td>\n",
       "      <td>14</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-140551.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.060274</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>732608</th>\n",
       "      <td>0001017386-15-000179</td>\n",
       "      <td>EMPIRE GLOBAL CORP.</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2015</td>\n",
       "      <td>20140331</td>\n",
       "      <td>17</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-193029.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.057535</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1044529</th>\n",
       "      <td>0001017386-15-000161</td>\n",
       "      <td>EMPIRE GLOBAL CORP.</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2015</td>\n",
       "      <td>20120331</td>\n",
       "      <td>1</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-3755.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.013699</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1045865</th>\n",
       "      <td>0001017386-15-000181</td>\n",
       "      <td>EMPIRE GLOBAL CORP.</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2015</td>\n",
       "      <td>20140630</td>\n",
       "      <td>1</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-27590.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.013699</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1126480</th>\n",
       "      <td>0001017386-15-000142</td>\n",
       "      <td>EMPIRE GLOBAL CORP.</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2015</td>\n",
       "      <td>20120331</td>\n",
       "      <td>1</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-3755.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.013699</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1156286</th>\n",
       "      <td>0001017386-15-000163</td>\n",
       "      <td>EMPIRE GLOBAL CORP.</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2015</td>\n",
       "      <td>20130630</td>\n",
       "      <td>1</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-3901.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.013699</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1157813</th>\n",
       "      <td>0001017386-15-000147</td>\n",
       "      <td>EMPIRE GLOBAL CORP.</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2015</td>\n",
       "      <td>20120630</td>\n",
       "      <td>1</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-3590.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.013699</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1238095</th>\n",
       "      <td>0001017386-15-000181</td>\n",
       "      <td>EMPIRE GLOBAL CORP.</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2015</td>\n",
       "      <td>20130630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-8080.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1289099</th>\n",
       "      <td>0001017386-15-000133</td>\n",
       "      <td>EMPIRE GLOBAL CORP.</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2015</td>\n",
       "      <td>20100630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-67696.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1296698</th>\n",
       "      <td>0001017386-15-000163</td>\n",
       "      <td>EMPIRE GLOBAL CORP.</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2015</td>\n",
       "      <td>20130630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-8080.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1383951</th>\n",
       "      <td>0001017386-15-000147</td>\n",
       "      <td>EMPIRE GLOBAL CORP.</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2015</td>\n",
       "      <td>20110630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-3452.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.027398</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1418513</th>\n",
       "      <td>0001017386-15-000171</td>\n",
       "      <td>EMPIRE GLOBAL CORP.</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2015</td>\n",
       "      <td>20120930</td>\n",
       "      <td>1</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-4873.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.002740</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1423021</th>\n",
       "      <td>0001017386-15-000136</td>\n",
       "      <td>EMPIRE GLOBAL CORP.</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2015</td>\n",
       "      <td>20100930</td>\n",
       "      <td>1</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-15362.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.002740</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1426718</th>\n",
       "      <td>0001017386-15-000149</td>\n",
       "      <td>EMPIRE GLOBAL CORP.</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2015</td>\n",
       "      <td>20120930</td>\n",
       "      <td>1</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-4873.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.002740</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1428435</th>\n",
       "      <td>0001017386-15-000136</td>\n",
       "      <td>EMPIRE GLOBAL CORP.</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2015</td>\n",
       "      <td>20110930</td>\n",
       "      <td>1</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-342.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.002740</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1437425</th>\n",
       "      <td>0001017386-15-000193</td>\n",
       "      <td>EMPIRE GLOBAL CORP.</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2015</td>\n",
       "      <td>20131231</td>\n",
       "      <td>4</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-16655.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.010959</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1496971</th>\n",
       "      <td>0001017386-15-000147</td>\n",
       "      <td>EMPIRE GLOBAL CORP.</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2015</td>\n",
       "      <td>20120630</td>\n",
       "      <td>2</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-7345.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.016439</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1505321</th>\n",
       "      <td>0001017386-15-000171</td>\n",
       "      <td>EMPIRE GLOBAL CORP.</td>\n",
       "      <td>NetIncomeLoss</td>\n",
       "      <td>us-gaap/2015</td>\n",
       "      <td>20130930</td>\n",
       "      <td>3</td>\n",
       "      <td>USD</td>\n",
       "      <td>0x00000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-11843.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.019179</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            submission_number         company_name    measure_tag  \\\n",
       "716665   0001017386-15-000147  EMPIRE GLOBAL CORP.  NetIncomeLoss   \n",
       "724426   0001017386-15-000149  EMPIRE GLOBAL CORP.  NetIncomeLoss   \n",
       "728706   0001017386-15-000163  EMPIRE GLOBAL CORP.  NetIncomeLoss   \n",
       "732608   0001017386-15-000179  EMPIRE GLOBAL CORP.  NetIncomeLoss   \n",
       "1044529  0001017386-15-000161  EMPIRE GLOBAL CORP.  NetIncomeLoss   \n",
       "1045865  0001017386-15-000181  EMPIRE GLOBAL CORP.  NetIncomeLoss   \n",
       "1126480  0001017386-15-000142  EMPIRE GLOBAL CORP.  NetIncomeLoss   \n",
       "1156286  0001017386-15-000163  EMPIRE GLOBAL CORP.  NetIncomeLoss   \n",
       "1157813  0001017386-15-000147  EMPIRE GLOBAL CORP.  NetIncomeLoss   \n",
       "1238095  0001017386-15-000181  EMPIRE GLOBAL CORP.  NetIncomeLoss   \n",
       "1289099  0001017386-15-000133  EMPIRE GLOBAL CORP.  NetIncomeLoss   \n",
       "1296698  0001017386-15-000163  EMPIRE GLOBAL CORP.  NetIncomeLoss   \n",
       "1383951  0001017386-15-000147  EMPIRE GLOBAL CORP.  NetIncomeLoss   \n",
       "1418513  0001017386-15-000171  EMPIRE GLOBAL CORP.  NetIncomeLoss   \n",
       "1423021  0001017386-15-000136  EMPIRE GLOBAL CORP.  NetIncomeLoss   \n",
       "1426718  0001017386-15-000149  EMPIRE GLOBAL CORP.  NetIncomeLoss   \n",
       "1428435  0001017386-15-000136  EMPIRE GLOBAL CORP.  NetIncomeLoss   \n",
       "1437425  0001017386-15-000193  EMPIRE GLOBAL CORP.  NetIncomeLoss   \n",
       "1496971  0001017386-15-000147  EMPIRE GLOBAL CORP.  NetIncomeLoss   \n",
       "1505321  0001017386-15-000171  EMPIRE GLOBAL CORP.  NetIncomeLoss   \n",
       "\n",
       "              version  period_end_date  number_of_quarters units  \\\n",
       "716665   us-gaap/2015         20120630                  10   USD   \n",
       "724426   us-gaap/2015         20120930                   3   USD   \n",
       "728706   us-gaap/2015         20130630                  14   USD   \n",
       "732608   us-gaap/2015         20140331                  17   USD   \n",
       "1044529  us-gaap/2015         20120331                   1   USD   \n",
       "1045865  us-gaap/2015         20140630                   1   USD   \n",
       "1126480  us-gaap/2015         20120331                   1   USD   \n",
       "1156286  us-gaap/2015         20130630                   1   USD   \n",
       "1157813  us-gaap/2015         20120630                   1   USD   \n",
       "1238095  us-gaap/2015         20130630                   2   USD   \n",
       "1289099  us-gaap/2015         20100630                   2   USD   \n",
       "1296698  us-gaap/2015         20130630                   2   USD   \n",
       "1383951  us-gaap/2015         20110630                   2   USD   \n",
       "1418513  us-gaap/2015         20120930                   1   USD   \n",
       "1423021  us-gaap/2015         20100930                   1   USD   \n",
       "1426718  us-gaap/2015         20120930                   1   USD   \n",
       "1428435  us-gaap/2015         20110930                   1   USD   \n",
       "1437425  us-gaap/2015         20131231                   4   USD   \n",
       "1496971  us-gaap/2015         20120630                   2   USD   \n",
       "1505321  us-gaap/2015         20130930                   3   USD   \n",
       "\n",
       "        dimension_hash  iprx     value footnote  footnote_length  \\\n",
       "716665      0x00000000     0 -116393.0      NaN                0   \n",
       "724426      0x00000000     0  -12218.0      NaN                0   \n",
       "728706      0x00000000     0 -140551.0      NaN                0   \n",
       "732608      0x00000000     0 -193029.0      NaN                0   \n",
       "1044529     0x00000000     0   -3755.0      NaN                0   \n",
       "1045865     0x00000000     0  -27590.0      NaN                0   \n",
       "1126480     0x00000000     0   -3755.0      NaN                0   \n",
       "1156286     0x00000000     0   -3901.0      NaN                0   \n",
       "1157813     0x00000000     0   -3590.0      NaN                0   \n",
       "1238095     0x00000000     0   -8080.0      NaN                0   \n",
       "1289099     0x00000000     0  -67696.0      NaN                0   \n",
       "1296698     0x00000000     0   -8080.0      NaN                0   \n",
       "1383951     0x00000000     0   -3452.0      NaN                0   \n",
       "1418513     0x00000000     0   -4873.0      NaN                0   \n",
       "1423021     0x00000000     0  -15362.0      NaN                0   \n",
       "1426718     0x00000000     0   -4873.0      NaN                0   \n",
       "1428435     0x00000000     0    -342.0      NaN                0   \n",
       "1437425     0x00000000     0  -16655.0      NaN                0   \n",
       "1496971     0x00000000     0   -7345.0      NaN                0   \n",
       "1505321     0x00000000     0  -11843.0      NaN                0   \n",
       "\n",
       "         num_dimensions coregistrant  duration_fraction  date_fraction  \\\n",
       "716665                0          NaN           0.060274            0.0   \n",
       "724426                0          NaN           0.008220            0.0   \n",
       "728706                0          NaN           0.060274            0.0   \n",
       "732608                0          NaN           0.057535            0.0   \n",
       "1044529               0          NaN           0.013699            0.0   \n",
       "1045865               0          NaN           0.013699            0.0   \n",
       "1126480               0          NaN           0.013699            0.0   \n",
       "1156286               0          NaN           0.013699            0.0   \n",
       "1157813               0          NaN           0.013699            0.0   \n",
       "1238095               0          NaN           0.027398            0.0   \n",
       "1289099               0          NaN           0.027398            0.0   \n",
       "1296698               0          NaN           0.027398            0.0   \n",
       "1383951               0          NaN           0.027398            0.0   \n",
       "1418513               0          NaN           0.002740            0.0   \n",
       "1423021               0          NaN           0.002740            0.0   \n",
       "1426718               0          NaN           0.002740            0.0   \n",
       "1428435               0          NaN           0.002740            0.0   \n",
       "1437425               0          NaN           0.010959            0.0   \n",
       "1496971               0          NaN           0.016439            0.0   \n",
       "1505321               0          NaN           0.019179            0.0   \n",
       "\n",
       "         decimal  \n",
       "716665         0  \n",
       "724426         0  \n",
       "728706         0  \n",
       "732608         0  \n",
       "1044529        0  \n",
       "1045865        0  \n",
       "1126480        0  \n",
       "1156286        0  \n",
       "1157813        0  \n",
       "1238095        0  \n",
       "1289099        0  \n",
       "1296698        0  \n",
       "1383951        0  \n",
       "1418513        0  \n",
       "1423021        0  \n",
       "1426718        0  \n",
       "1428435        0  \n",
       "1437425        0  \n",
       "1496971        0  \n",
       "1505321        0  "
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_nums[(df_nums['company_name'] =='EMPIRE GLOBAL CORP.')&(df_nums['measure_tag']=='NetIncomeLoss')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x20c2e6523c8>"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZgAAAELCAYAAADkyZC4AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4xLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvAOZPmwAAIABJREFUeJzt3Xl8VPW9//HXJzskgZCFBMgKCUvC\nTkSRTUAQrUq1qCgqbrUoi9a2V73eX2t723vrta0VxK1qCxWriLWodQFZRATRhE0IWyAsYQlJgJAQ\nsn9/f8wJjjGQQDI5s3yej8c8MvOdc77znsHxM99zvuccMcaglFJKtTY/uwMopZTyTlpglFJKuYQW\nGKWUUi6hBUYppZRLaIFRSinlElpglFJKuYQWGKWUUi6hBUYppZRLaIFRSinlEgF2B3CV6Ohok5yc\nbHcMpZTyKNnZ2UXGmJjW6MtrC0xycjJZWVl2x1BKKY8iIvtbqy/dRKaUUsoltMAopZRyCY8pMCIy\nUUR2ikiuiDxmdx6llFLn5xH7YETEH5gHjAfyga9F5D1jTI69yZRSnq66upr8/HwqKirsjtKmQkJC\niI+PJzAw0GWv4REFBhgK5Bpj9gKIyJvAJEALjFKqRfLz8wkPDyc5ORkRsTtOmzDGUFxcTH5+Pikp\nKS57HU/ZRNYNOOj0ON9qU0qpFqmoqCAqKspniguAiBAVFeXyUZunFJjG/uW/dylOEblfRLJEJKuw\nsLANYimlvIEvFZd6bfGePaXA5AMJTo/jgcMNFzLGvGyMyTTGZMbEtMpxQgoor6phyaZDHD55xu4o\nSikP4in7YL4G0kQkBTgETAFuszeSbzDG8LNFm/lo61EA+nXryIT0WCZkxNEzNswnf/kpZaewsDDK\nysrsjtEsHlFgjDE1IjIT+ATwB14zxmyzOZZPeHVNHh9tPcqMMT0IDwlk6baj/HHZLv64bBdJUe3P\nFpvBiZ3w99Nio5T6lkcUGABjzIfAh3bn8CVf5R3nfz/awcSMOH4+oRciwvTRPTh2qoJPtx9jac5R\n5q/dz18+zyMqNIgr+8QyISOW4anRhAT62x1fKY/w6KOPkpSUxIMPPgjAk08+iYiwevVqTpw4QXV1\nNb/97W+ZNGnSd9ZbtWoVf/jDH/jggw8AmDlzJpmZmdx1111kZ2fzyCOPUFZWRnR0NH/729/o0qVL\nm783jykwqm0dK61gxhsbSIxsz9M39f/OprDOHUK47dJEbrs0kdKKaj7bVcjSbQV8+M0R3so6SPsg\nf0alxTAhI5axvTsT0T7IxneiVPP9+v1t5Bw+1ap9pnftwK+uyzjn81OmTOHhhx8+W2AWLVrExx9/\nzE9/+lM6dOhAUVERl112Gddff32zNklXV1cza9YslixZQkxMDG+99RZPPPEEr732Wqu9p+bSAqO+\np6a2jplvbKSsoobX772U8JBzH4gVHhLItf27cm3/rlTV1PHl3mKW5hxlWU4BH287ir+fcGlKJBPS\nYxmfEUe3iHZt+E6Ucn+DBg3i2LFjHD58mMLCQjp16kSXLl346U9/yurVq/Hz8+PQoUMUFBQQFxfX\nZH87d+5k69atjB8/HoDa2lpbRi+gBUY14ulPdvJV3nH+fMtAesWFN3u9oAA/RvWMYVTPGH5zfV+2\nHCph6bajLM0p4Mn3c3jy/Rz6duvAhPQ4JmTE0is2XCcJKLdyvpGGK02ePJnFixdz9OhRpkyZwsKF\nCyksLCQ7O5vAwECSk5O/d8xKQEAAdXV1Zx/XP2+MISMjg3Xr1rXpe2iMFhj1HR9vPcJLq/dyx2VJ\n/HDQxR/L6ucnDEyIYGBCBP8xsTd7CstYllPAspwCnvl0F39atovEyG8nCQxJ0kkCyndNmTKFH//4\nxxQVFfHZZ5+xaNEiOnfuTGBgICtXrmT//u+fQT8pKYmcnBwqKyupqKhg+fLljBgxgl69elFYWMi6\ndesYNmwY1dXV7Nq1i4yMti+eWmDUWXsLy/j521sYkBDBf13bp1X77hETRo/RYY5JAqUVLN9+jKXb\njrJg3X5eWZNHZGgQV/bpzIT0OEak6SQB5VsyMjIoLS2lW7dudOnShalTp3LdddeRmZnJwIED6d27\n9/fWSUhI4Oabb6Z///6kpaUxaNAgAIKCgli8eDGzZ8+mpKSEmpoaHn74YVsKjBjzvQPivUJmZqbR\nC441X3lVDTfMW8ux0go+mD2yzfaVlFXW8NnOQpbmHGXFjmOUVtTQLtCf0T1jGJ8ey7g+OklAudb2\n7dvp06d1f1B5isbeu4hkG2MyW6N/HcEojDE88e5Wdh0rZf7dQ9t0R3xYcAA/6N+FH/TvQlVNHevz\nilm6rYClOUfPThIYmhzJhIxYxqfHEt+pfZtlU0q1jBYYxevrD/DuxkP8bHxPRvW07xQ7QQF+jEyL\nYWRaDL++PoNvDpWwNOcoS7cV8Ov3c/j1+zlkdP12kkDvOJ0koJQ70wLj4zYdPMlv3t/GmF4xzBiT\nanecs/z8hAEJEQxIiOAXV/VmrzVJYGlOAX9evotnPt1FQmQ7R7FJjyUzOVInCaiLZozxuR8rbbF7\nRPfB+LDjp6u4ds7n+PkJH8wa4TH7OpwnCXyRW0xVbR2RoUGM692ZCRlxjNRJAuoC5OXlER4e7lOn\n7K+/Hkxpaen3rgfTmvtgtMD4qNo6w11//Yr1ecd5Z/rl9IvvaHeki1JWWcPqXYUs3XaU5U6TBEb1\njGZCehxje3emU6hnFE5lD72i5XcPpNad/KrFnl2+m893F/H7G/t5bHEBxySBa/p14Zp+jkkCX+Ud\nP7vf5pNtBTpJQDUpMDDQpVd19GU6gvFBK3cc4+6/fc1NQ+L5v8n9vXKzgDHGMUnAmpG2q8BxevP0\nLh2YkBHLhPQ4+nTRSQJKNaSbyJpBC0zjDh4v59q5a+ga0Y53H7zcZ/ZV5BWdZpk1ssk+cAJjIL5T\nu7Mz0jKTOhHg7ynX31PKdbTANIMWmO+rqK5l8otr2V9czgezRpAUFWp3JFsUllayfLtjRtqa3CKq\nauro1D6QcX1imZAey8i0GNoF+UbhVaoh3QejLsqv39/G1kOneOXOTJ8tLgAx4cFMGZrIlKGJ35kk\n8Mm2oyzOzick0M+63EAc43SSgFIXTQuMj1iUdZB/fHWQGWN6cGV6rN1x3IbzJIHq2jrW7z1+9nID\nS3MK8BMYmhLJhPQ4xqfHkhCpkwSUai7dROYDth0u4cbn15KZ3IkF91yqByQ2gzGGrYdOnZ2RtrOg\nFNBJAsr76T6YZtAC41Bypprr5q6hqqaOD2aPIDos2O5IHmlf0WlrVHOUrP3fThIYn+4oNpck6yQB\n5R20wDSDFhioqzPc//csVu0s5K2fDGNIUie7I3mFwtJKVuwoYOm2Aj63JglEtA9kXO9YJmTEMkon\nCSgPpjv5VbO88NkePt1+jCevS9fi0opiwoO55ZJEbrkkkdP1kwRyCliWc5R3NjgmCYxMi2FCeizj\n+sQSGRrE/uLTvLR6L6cra/jzLQN105ryCVpgvNQXuUX8celOrhvQlWmXJ9sdx2uFBgdwdb8uXG1N\nEvgq7/jZy0QvsyYJ9OnSge1HTlFnbSx4aFwa3WPC7A2uVBvQAuOFjpScYfY/NtIjJozf39hPfy23\nkUB/P4anRjM8NZonr884O0lg7Z5i7hvZnQnpsUx+cR2f7y7SAnMB6uoMJ89UU1xWSVFZFcWnKyku\nq6K4rJLyqlpmjk31mBO1+hotMF6mqqaOGQs3UFFdywu3DyE0WP+J7SAi9IvvSL/4jvzMqT0xsj2f\n7y7y+VFleVUNxWVVFJVZxeK0VTycCkiRVVBOlFdRW/f9fcUiYIzj7xM/SLfhXaim6P99vMz/fLid\nDQdOMu+2waR21l/J7mZkWjT/2niI6to6Ar1o1llNbR3Hy60CYRWJwtJKik87RhrFZVUUOd0/U13b\naD9hwQFEhQURFRpEQmR7BiVGEBUa7GgLCyY61PE3KiyITu2D+Pnbm3n9ywNMH92DKJ0h6Xa0wHiR\n9zYf5m9r93HviBR+0L+L3XFUI0amRbNw/QE2HjjJ0JRIu+OckzGGUxU1joJgFYbGRhj1z50or260\nnwA/sQqGoyh0jw4lyqlIRFvPRYcHExUadMHnxpsxJpV/bTrEK2vyeHRi79Z466oVaYHxErsLSnns\nnS1kJnXisav1i+auhvWIxk9gze7CNi8wFdW1HD9dZY0mvt2PUXz6u5uq6kchVbV1jfbTsV2goziE\nBpPWOYzLukc6ikRYENFhwd8Wj9BgOrQLcOk+wNTOYfygXxcWrN3HT0Z1130xbsZlBUZEngR+DBRa\nTf9pjPnQeu5x4F6gFphtjPnEap8IPAv4A68YY35vtacAbwKRwAbgDmNMlauye5qyyhqmv55N+yB/\n5k0d7FWbXrxNx3aBDEiIYPXuIh6Z0KtFfZ1v53fRd0YdjvbSyppG+wkK8CPGKgoxYcH0jutAdJij\nYDiPPqLDgunUPoigAPf672vm2FQ+2HKE19bktfgzVa3L1SOYZ4wxf3BuEJF0YAqQAXQFPhWRntbT\n84DxQD7wtYi8Z4zJAZ6y+npTRF7EUZxecHF2j2CM4dHFW8grOs3C+y4jtkOI3ZFUE0amxfDcit2U\nlFfTsf13rybYcOd30TlGGE3t/I5sXz+aCKJffARRodbmqLDgs5uo6h+HBvl79EzD3nEdmJgRx1+/\n2Me9I7vTsV1g0yupNmHHJrJJwJvGmEogT0RygaHWc7nGmL0AIvImMElEtgNjgdusZeYDT6IFBoDX\nvtjHv785wmNX92ZYjyi746hmGJkWzZzlu5n95kYC/MQlO7997Xxzs8al8vG2o8xfu4/Z49LsjqMs\nri4wM0XkTiAL+Jkx5gTQDfjSaZl8qw3gYIP2S4Eo4KQxpqaR5X3a1/uO878fbmdCeiw/GdXd7jiq\nmQYmRNA7LpwdR0+5bOe3r8no2pEr+3Tm1TV53D08mfAQHcW4gxYVGBH5FIhr5KkncIww/hsw1t8/\nAvcAjf20MkBjG3bNeZZvLM/9wP0AiYmJTaT3bIWllcxYuIH4Tu34w80DPHoTh68J9Pfj44dH2R3D\n68wam8akeV+wYN1+ZoxJtTuOooUFxhhzZXOWE5G/AB9YD/OBBKen44HD1v3G2ouACBEJsEYxzss3\nzPMy8DI4TnbZzLfhcWpq65j1jw2cqqhm/j1D6aC/1pRiQEIEV/SK4dU1edx1ebIeZOwGXDYdRESc\nD8S4Adhq3X8PmCIiwdbssDTgK+BrIE1EUkQkCMdEgPeM43TPK4HJ1vrTgCWuyu0J/rB0F1/uPc7/\n3NCPPl062B1HKbcxa2wax09XsXD9frujKFxYYID/E5FvRGQLMAb4KYAxZhuwCMgBPgZmGGNqrdHJ\nTOATYDuwyFoW4FHgEWtCQBTwqgtzu7VPth3lxc/2MPXSRG4cHG93HKXcypCkToxIjebl1XmcqWp8\nwoRqO3o9GA+SV3Sa6+euISUmlLenDyM4QHf8KtXQ+r3F3PLyl/zy2nTuGZFidxyP05rXg3GvI6bU\nOZ2pquWB17Px9xeenzpYi4tS53Bp9yguTYnkxc/2UHGOad+qbWiB8QDGGJ549xt2FpTy51sGEt+p\nvd2RlHJrD41L41hpJW9nHWx6YeUyWmA8wBtfHeCfGw/x0Lg0rujV2e44Srm9YT2iGJLUiedX7aGy\nRkcxdtEC4+Y2HzzJr9/L4YpeMcweq0coK9UcIsLscWkcKangnexDdsfxWVpg3NiJ01U8uHADMeHB\nPHPzQPx87PQfSrXEqLRoBiRE8PyqXKrPcWZo5VpaYNxUbZ3hobc2UVhayQu3D6ZTqJ6GXKkLISLM\nHptK/okzvLtRRzF20ALjpuau2M3qXYU8eX0G/eMj7I6jlEca27szGV078PzKXGp0FNPmtMC4oVU7\nj/Hs8t38aHA8tw5NaHoFpVSjRIRZY9PYV1zO+1saPcOUciEtMG7m4PFyHn5rE71iw/ntD/vqSSyV\naqEJ6bH0jgtn7orcRq+fo1xHC4wbqaiu5cGFG6itNbx4+xDaBenBlEq1lJ+fYxSzt/A0H35zxO44\nPkULjBv5zQc5fHOohD/ePIDk6FC74yjlNa7uG0dq5zDmrthNnY5i2owWGDexODufN9YfYProHkzI\naOwSO0qpi+UYxaSyq6CMT7YdtTuOz9AC4wZyDp/iiXe/YVj3KH4+oafdcZTyStf270r36FDmrMjF\nW0/y6260wNis5Ew1DyzMJqJ9IHNuHUSAv/6TKOUK/n7Cg2NS2X7kFJ9uP2Z3HJ+g/zezkTGGn7+9\nmUMnzjDvtsHEhAfbHUkprzZpYFcSI9szd8VuHcW0AS0wNnrxs70syyngP6/pQ2ZypN1xlPJ6gf5+\nPHhFD7bkl7BqV6HdcbyeFhibrN1TxNOf7OAH/btw9/Bku+Mo5TNuHBxPt4h2zFmuoxhX0wJjg6Ml\nFcz+x0ZSokN56kf99WBKpdpQUIAfD1zRg40HTvJFbrHdcbyaFpg2Vl1bx4w3NlBeVcuLtw8hLDjA\n7khK+ZybMuOJ6xDCs8t36SjGhbTAtLH//XAH2ftP8NSP+pMWG253HKV8UnCAP9NHd+frfSf4cu9x\nu+N4LS0wbeiDLYd57Ys87h6ezHUDutodRymfNmVoIjHhwcxdsdvuKF5LC0wbyT1WyqOLtzAkqROP\nX93H7jhK+byQQH9+Mqo7a/cUk7VPRzGuoAWmDZyurGH66xsICfRn3m2DCQrQj10pd3DbpYlEhQYx\nZ0Wu3VG8kv6fzsWMMTz6zhb2FpYx99ZBxHUMsTuSUsrSPiiA+0Z2Z/WuQjYeOGF3HK+jBcbF/rZ2\nHx9sOcLPr+rF5anRdsdRSjVwx7AkItoHMldHMa1OC4wLZe8/zu/+vZ0r+8QyfVQPu+MopRoRFhzA\nfSNSWLHjGFsPldgdx6togXGRorJKHly4ga4R7fjjzQPw89ODKZVyV3denkyHkADmLNcZZa1JC4wL\n1NTWMeuNjZwsr+aF2wfTsV2g3ZGUUufRISSQu4ensDSngO1HTtkdx2u0qMCIyE0isk1E6kQks8Fz\nj4tIrojsFJGrnNonWm25IvKYU3uKiKwXkd0i8paIBFntwdbjXOv55JZkbgt/WraLdXuL+d0N/cjo\n2tHuOEqpZrhneAphwQE8p/tiWk1LRzBbgRuB1c6NIpIOTAEygInA8yLiLyL+wDzgaiAduNVaFuAp\n4BljTBpwArjXar8XOGGMSQWesZZzW8tyCnh+1R5uHZrI5CHxdsdRSjVTx/aBTLs8iQ+3HmF3Qand\ncbxCiwqMMWa7MWZnI09NAt40xlQaY/KAXGCodcs1xuw1xlQBbwKTxHG2x7HAYmv9+cAPnfqab91f\nDIwTNz075L6i0zyyaBP9unXkV9elN72CUsqt3DuiO+0C/XlupY5iWoOr9sF0Aw46Pc632s7VHgWc\nNMbUNGj/Tl/W8yXW8t8jIveLSJaIZBUWtu21Hs5U1TL99Wz8RHh+6mBCAv3b9PWVUi0XGRrEHZcl\n8f7mw+wpLLM7jsdrssCIyKcisrWR26TzrdZIm7mI9vP19f1GY142xmQaYzJjYmLOE691GWP4r39t\nZWdBKX+eMpCEyPZt9tpKqdZ138juBAX4MU9HMS3W5LnijTFXXkS/+UCC0+N44LB1v7H2IiBCRAKs\nUYrz8vV95YtIANARcKsTB7359UHe2ZDP7HFpjOnV2e44SqkWiAkPZuqlSfxt7T4eGpdGUlSo3ZE8\nlqs2kb0HTLFmgKUAacBXwNdAmjVjLAjHRID3jOOCDCuBydb604AlTn1Ns+5PBlYYN7qAw5b8k/xq\nyTZGpkXz0Lg0u+MopVrBT0Z1x99PeH7lHrujeLSWTlO+QUTygWHAv0XkEwBjzDZgEZADfAzMMMbU\nWqOTmcAnwHZgkbUswKPAIyKSi2Mfy6tW+6tAlNX+CHB2arPdTpZX8cDrG4gJD+bZKYPw14MplfIK\nnTuEcOslCbyzIZ+Dx8vtjuOxxI0GA60qMzPTZGVluaz/ujrDPfO/Zm1uMW9PH8aAhAiXvZZSqu0d\nKTnD6P9bxU2Z8fzuhn52x2kzIpJtjMlsesmm6ZH8F+m5lbms2lnIL69L1+KilBfq0rEdkzPjeTsr\nnyMlZ+yO45G0wFyEz3YV8synu7hxUDemXppodxyllIs8MLoHdcbw0md77Y7ikbTAXKD8E+U89OZG\nesWG87sb+uGmx3wqpVpBQmR7bhzcjTe+OsCxUxV2x/E4WmAuQGVNLTMWbqC21vDC7UNoF6QHUyrl\n7WaMSaW2zvDSah3FXCgtMBfgvz/IYXN+CU/fNICUaJ0br5QvSIoKZdLArixcv5+iskq743gULTDN\n9M8N+bz+5QF+Mqo7E/vG2R1HKdWGZoxJpbKmjr98rqOYC6EFphl2HD3Ff777DZemRPKLq3rZHUcp\n1cZ6xIRxXf+u/H3dfo6frrI7jsfQAtOEUxXVPPD6BjqEBDL3tkEE+OtHppQvmjk2lTPVtby2Js/u\nKB5D/295HsYYfvH2Zg4cL2fe1MF0Dg+xO5JSyiY9Y8O5um8cf1u7j5LyarvjeAQtMOfx8uq9fLKt\ngMev7s0lyZF2x1FK2WzmmDTKKmv461odxTSHFphzWLenmKc+3sE1/eK4d0SK3XGUUm4gvWsHxqfH\n8tqaPE5V6CimKVpgGlFwqoJZ/9hIcnQoT/2ovx5MqZQ6a/bYNE5V1LBg7T67o7g9LTANVNfWMfON\nDZyurOHF24cQHhJodySllBvpF9+Rsb0788qaPMoqa5pewYdpgWngqY928PW+E/z+R/3oGRtudxyl\nlBuaNTaVk+XVvP7lfrujuDUtME4+/OYIr6zJY9qwJCYN7GZ3HKWUmxqU2ImRadH8ZfVeyqt0FHMu\nWmAsewrL+MXbmxmUGMETP0i3O45Sys09NC6N4tNVvLH+gN1R3JYWGOB0ZQ3T/55NcKA/z08dTFCA\nfixKqfPLTI5kWPcoXlq9l4rqWrvjuCWf/z+pMYbH//kNewrLmHvrILp0bGd3JKWUh5g9Lo3C0kre\n+vqg3VHcks8XmAXr9vPe5sP8bEIvhqdG2x1HKeVBLuseySXJnXhh1R4qa3QU05BPF5js/Sf47b9z\nGNe7Mw+M7mF3HKWUhxERZo9L4+ipCt7Oyrc7jtvx2QJTXFbJjIUbiOsYwp9uHoifnx5MqZS6cCNS\noxmUGMELq/ZQVVNndxy34pMFprbOMPvNjRwvr+KFqUPo2F4PplRKXRwRYfbYNA6dPMO7G3UU48wn\nC8wzy3bxRW4xv53Ul77dOtodRynl4a7oFUO/bh2Zt3IPNbU6iqnncwVm+fYCnluZyy2ZCdx8SYLd\ncZRSXqB+X8yB4+Us2XTY7jhuw6cKzIHicn761ib6duvArydl2B1HKeVFruzTmT5dOjBvZS61dcbu\nOG7BZwpMRXUt01/PBuCFqUMICfS3OZFSyps49sWksrfoNB9s0VEM+FCB+eWSreQcOcWfpwwkIbK9\n3XGUUl7oqow4esaGMXdFLnU6imlZgRGRm0Rkm4jUiUimU3uyiJwRkU3W7UWn54aIyDcikisic8S6\n2IqIRIrIMhHZbf3tZLWLtVyuiGwRkcEXmvOtrw+wKCufWWNTGds7tiVvWSmlzsnPT5g5No3cY2V8\ntPWo3XFs19IRzFbgRmB1I8/tMcYMtG7TndpfAO4H0qzbRKv9MWC5MSYNWG49Brjaadn7rfWbH/BQ\nCf9vyTZGpEbz8JU9L2RVpZS6YD/o14XuMaHMXbHb50cxLSowxpjtxpidzV1eRLoAHYwx64wxBlgA\n/NB6ehIw37o/v0H7AuPwJRBh9dOkk+VVTH89m6jQIJ6dMhB/PZhSKeVi/n7CzDGp7DhayrLtBXbH\nsZUr98GkiMhGEflMREZabd0A5yOR8q02gFhjzBEA629np3UOnmOd83pk0WYKTlUwb+pgosKCL/Z9\nKKXUBbl+QFeSotozZ/luHL+lfVOTBUZEPhWRrY3cJp1ntSNAojFmEPAI8IaIdAAaG0I09ek3ex0R\nuV9EskQka9/R46zYcYz/d206gxM7NfESSinVegL8/ZgxJpVth0+xcucxu+PYpskCY4y50hjTt5Hb\nkvOsU2mMKbbuZwN7gJ44Rh/xTovGA/Xz+QrqN31Zf+v/VfKBhHOs0/B1XzbGZBpjMktr/fnhwK7c\ncVlSU29RKaVa3Q2DuhHfqR3PLs/12VGMSzaRiUiMiPhb97vj2EG/19r0VSoil1mzx+4E6gvVe8A0\n6/60Bu13WrPJLgNK6jelnU9wgB//c2M/rElqSinVpgL9/XjwilQ2HzzJ57uL7I5ji5ZOU75BRPKB\nYcC/ReQT66lRwBYR2QwsBqYbY45bzz0AvALk4hjZfGS1/x4YLyK7gfHWY4APgb3W8n8BHmxOtpTo\nMNoHBbTk7SmlVIv8aEg3unQM4Vkf3Rcj3vqmMzMzTVZWlt0xlFI+bsG6ffxyyTbeuO9SLveAixqK\nSLYxJrPpJZvmM0fyK6WUHW7OTKBzeDBzVuy2O0qb0wKjlFIuFBLoz09G9+DLvcdZv7fY7jhtSguM\nUkq52G1DE4kOC2Luily7o7QpLTBKKeVi7YL8uX9Ud9bkFpG9/4TdcdqMFhillGoDUy9NolP7QOb6\n0L4YLTBKKdUGQoMDuG9kd1btLGRL/km747QJLTBKKdVG7hyWRMd2gcxZ7hv7YrTAKKVUGwkPCeSe\n4Sl8ur2AbYdL7I7jclpglFKqDd01PJnw4ACe84EZZVpglFKqDXVsF8hdw5P5aOtRdh4ttTuOS2mB\nUUqpNnbP8BRCg/y9fkaZFhillGpjnUKDuPPyZP79zRFyj5XZHcdltMAopZQN7huRQkiAP/NWeu++\nGC0wSillg6iwYG6/LJElmw6xr+i03XFcQguMUkrZ5MejuhPo7+e1oxgtMEopZZPO4SHcOjSRf248\nxMHj5XbHaXVaYJRSykbTR/fAX4TnV+2xO0qr0wKjlFI2iusYws2XxLM4+yCHTp6xO06r0gKjlFI2\ne+CKVABe9LJRjBYYpZSyWbeIdkweEs9bXx/kaEmF3XFajRYYpZRyAw+MTqXWGF5a7T2jGC0wSinl\nBhKj2nPDoG68sf4Ax0q9YxQlvVYrAAASVUlEQVSjBUYppdzEjDGpVNfW8crneXZHaRVaYJRSyk2k\nRIdy/YCu/H3dforLKu2O02JaYJRSyo3MHJtKRU0tr67x/FGMFhillHIjqZ3DuaZfF+av3cfJ8iq7\n47SIFhillHIzs8amcrqqltc8fBTTogIjIk+LyA4R2SIi74pIhNNzj4tIrojsFJGrnNonWm25IvKY\nU3uKiKwXkd0i8paIBFntwdbjXOv55JZkVkopd9c7rgMTM+L469p9lJyptjvORWvpCGYZ0NcY0x/Y\nBTwOICLpwBQgA5gIPC8i/iLiD8wDrgbSgVutZQGeAp4xxqQBJ4B7rfZ7gRPGmFTgGWs5pZTyajPH\nplJaUcP8tfvsjnLRWlRgjDFLjTE11sMvgXjr/iTgTWNMpTEmD8gFhlq3XGPMXmNMFfAmMElEBBgL\nLLbWnw/80Kmv+db9xcA4a3mllPJafbt15Mo+nXl1TR5llTVNr+CGWnMfzD3AR9b9bsBBp+fyrbZz\ntUcBJ52KVX37d/qyni+xlldKKa82a2waJWeqWbBun91RLkqTBUZEPhWRrY3cJjkt8wRQAyysb2qk\nK3MR7efrq7Gs94tIlohkFRYWnustKaWURxiQEMHonjG88nke5VWeN4ppssAYY640xvRt5LYEQESm\nAdcCU40x9f/jzwcSnLqJBw6fp70IiBCRgAbt3+nLer4jcPwcWV82xmQaYzJjYmKaemtKKeX2Zo9L\n4/jpKhZ+ecDuKBespbPIJgKPAtcbY5wvx/YeMMWaAZYCpAFfAV8DadaMsSAcEwHeswrTSmCytf40\nYIlTX9Os+5OBFU6FTCmlvNqQpE4MT43ipdV7OVNVa3ecC9LSfTDPAeHAMhHZJCIvAhhjtgGLgBzg\nY2CGMabW2ocyE/gE2A4sspYFR6F6RERycexjedVqfxWIstofAc5ObVZKKV8we2waRWWV/OMrzxrF\niLcOBjIzM01WVpbdMZRSqlXc8tI69hWf5rNfjCEk0N9lryMi2caYzNboS4/kV0opDzB7XBoFpyp5\nO+tg0wu7CS0wSinlAS7vEcWQpE68sGoPVTV1dsdpFi0wSinlAUSEWWNTOVxSwTsb8u2O0yxaYJRS\nykOM7hnDgPiOzFuZS3Wt+49itMAopZSHEBFmj0sj/8QZ/rXxkN1xmqQFRimlPMjY3p3J6NqBeStz\nqXHzUYwWGKWU8iCOfTFp7Csu5/0th5tewUZaYJRSysNMSI+ld1w4z63IpbbOfY9l1AKjlFIexs9P\nmDk2lT2Fp/nwmyN2xzknLTBKKeWBru7bhdTOYTy3Ipc6Nx3FaIFRSikP5O/nOC5mZ0EpS3OO2h2n\nUVpglFLKQ13bvysp0aHMWZ6LO55XUguMUkp5KH8/YcaYVHKOnGL59mN2x/keLTBKKeXBJg3sSkJk\nO+as2O12oxgtMEop5cEC/f2YcUUqW/JLWLXLvS4VrwVGKaU83I2D4+kW0Y45y91rFKMFRimlPFxQ\ngB/Tr+jBxgMn+SK32O44Z2mBUUopL3BzZjxxHUKYs2K33VHO0gKjlFJeIDjAn+mju/NV3nG+3Ose\noxgtMEop5SWmDE0kOiyYOcvdYxSjBUYppbxESKBjFLN2TzFZ+47bHUcLjFJKeZPbLk0kMjSIOSty\n7Y6iBUYppbxJ+6AAfjyyO6t3FbLp4Elbs2iBUUopL3PHsCQi2gcy1+Z9MVpglFLKy4QFB3Dv8BSW\n7zjG1kMltuXQAqOUUl5o2vBkwkMCmGvjcTFaYJRSygt1CAnknuEpfLKtgO1HTtmSoUUFRkSeFpEd\nIrJFRN4VkQirPVlEzojIJuv2otM6Q0TkGxHJFZE5IiJWe6SILBOR3dbfTla7WMvlWq8zuCWZlVLK\nV9wzPIWw4ACes2lGWUtHMMuAvsaY/sAu4HGn5/YYYwZat+lO7S8A9wNp1m2i1f4YsNwYkwYstx4D\nXO207P3W+koppZrQsX0g0y5P4sOtR9hdUNrmr9+iAmOMWWqMqbEefgnEn295EekCdDDGrDOOU34u\nAH5oPT0JmG/dn9+gfYFx+BKIsPpRSinVhHtHdKddoD/PrWz7UUxr7oO5B/jI6XGKiGwUkc9EZKTV\n1g3Id1om32oDiDXGHAGw/nZ2WufgOdZRSil1HpGhQdxxWRLvbz7M3sKyNn3tJguMiHwqIlsbuU1y\nWuYJoAZYaDUdARKNMYOAR4A3RKQDII28RFMXL2j2OiJyv4hkiUhWYaF7XXhHKaXsct/I7gQF+DFv\n5Z42fd0mC4wx5kpjTN9GbksARGQacC0w1drshTGm0hhTbN3PBvYAPXGMPpw3o8UDh637BfWbvqy/\n9ReYzgcSzrFOw6wvG2MyjTGZMTExzXn/Sinl9WLCg7ltaBL/2nSIA8Xlbfa6LZ1FNhF4FLjeGFPu\n1B4jIv7W/e44dtDvtTZ9lYrIZdbssTuBJdZq7wHTrPvTGrTfac0muwwoqd+UppRSqnl+Mro7/n7C\n86vabl9MS/fBPAeEA8saTEceBWwRkc3AYmC6Mab+1J4PAK8AuThGNvX7bX4PjBeR3cB46zHAh8Be\na/m/AA+2MLNSSvmc2A4h3HpJAouz88k/0TajGHGn6ze3pszMTJOVlWV3DKWUchuHT55h9NMruTkz\ngd/d0K/RZUQk2xiT2Rqvp0fyK6WUj+ga0Y6bMhN4OyufIyVnXP56WmCUUsqHPDC6B3XG8NJne13+\nWlpglFLKhyREtufGwd1446sDHDtV4dLX0gKjlFI+ZsaYVGrrDC+vdu0oRguMUkr5mKSoUCYN6Mrr\n6/dTVFbpstfRAqOUUj5oxthUKmvqeOXzPJe9hhYYpZTyQT1iwriuf1cWrNvH8dNVLnkNLTBKKeWj\nZo5NpbyqltfWuGYUowVGKaV8VM/YcK7pF8f8tfsoKa9u9f61wCillA+bOSaN0soa/rq29UcxWmCU\nUsqHpXftwPj0WF5bk0dpReuOYrTAKKWUj5s9No1TFTUsWLe/VfvVAqOUUj6uX3xHxvSK4S+ft+6B\nl1pglFJKMWtcGidbeUe/FhillFIMTuzExIy4Vu1TC4xSSikAXrh9cKv2pwVGKaUUAI4r2bceLTBK\nKaVcQguMUkopl9ACo5RSyiW0wCillHIJLTBKKaVcQguMUkopl9ACo5RSyiXEGGN3BpcQkUKgdc/c\ndnGigSK7QzSTp2TVnK1Lc7YuT8kJjWdNMsbEtEbnXltg3IWIZBljMu3O0RyeklVzti7N2bo8JSe4\nPqtuIlNKKeUSWmCUUkq5hBYY13vZ7gAXwFOyas7WpTlbl6fkBBdn1X0wSimlXEJHMEoppVxCC0wT\nRCRBRFaKyHYR2SYiDzWyjIjIHBHJFZEtIjLY6bmPReSkiHzQYJ0UEVkvIrtF5C0RCbLa7xKRQhHZ\nZN3usznnTGt5IyLRzenLzXJeISIlTp/nL23OuVBEdorIVhF5TUQCm+rLzXJe1Ofp4qyvishma/nF\nIhJmtQeL47uVK47vWrKb5nSr77zT83NFpMzp8YV/nsYYvZ3nBnQBBlv3w4FdQHqDZa4BPgIEuAxY\n7/TcOOA64IMG6ywCplj3XwQesO7fBTznRjkHAcnAPiC6OX25Wc4rGi5rc85rrOUF+IfTv7u7fZ7n\nynlRn6eLs3Zwuv8n4DHr/oPAi9b9KcBbbprzLtzoO289lwn8HShzarvgz1NHME0wxhwxxmyw7pcC\n24FuDRabBCwwDl8CESLSxVpnOVDqvLCICDAWWGw1zQd+6G45rfaNxph9jbzkOftys5wXxYU5P7SW\nN8BXQHxTfblZzovmwqyn4Oz3qh1gnPqab91fDIyzlnG3nBfFVTlFxB94GviPRvq6oM9TC8wFsIaE\ng4D1DZ7qBhx0epzP9/+hnUUBJ40xNedY/kdOw+gEG3OeT4v7aqOcAMOsTRMfiUjGha7sipzWJqc7\ngI9b2lcb54QWfp6uyCoifwWOAr2BuQ37sr5rJTi+e+6WE9zrOz8TeM8Yc+RcfTX389QC00zW9tJ3\ngIfrf4k4P93IKuf7dXK+5d8Hko0x/YFP+fYXgx05z/tSLemrDXNuwHHqiwE4vtD/upCVXZjzeWC1\nMebzVuirLXO26PN0VVZjzN1AVxy/4m9pSV825HSb77yIdAVu4rvF76L6Ai0wzWL9insHWGiM+Wcj\ni+QDzr864oHD5+myCMdQNaDh8saYYmNMpdX+F2CIjTnP56L7asucxphTxpgy6/6HQKA4TQKwI6eI\n/AqIAR5paV9tnbMln6crs1p5aoG3gB817Mv6rnUEjrtbTjf7zg8CUoFcEdkHtBeR3IZ9Nffz1ALT\nBGsb46vAdmPMn86x2HvAndaMjcuAkkaGl2dZ27VXApOtpmnAEuv1nLe7X4/jl44tOZtwUX21dU4R\niavfTiwiQ3H8N19sV05xzBC6CrjVGFPXkr7syHmxn6erslrLpTr1fx2ww6mvadb9ycAK67vnVjnd\n6TtvjPm3MSbOGJNsjEkGyo0xqU59XdjnaS5iNogv3YAROIaBW4BN1u0aYDow3VpGgHnAHuAbINNp\n/c+BQuAMjl8AV1nt3XHsPM0F3gaCrfb/BbYBm3EUod4255xtPa7B8cvnlab6crOcM50+zy+By23O\nWWMtX9/nL9308zxXzov6PF2VFUeB+8JadiuwEGu2FhCC47uVi+O71t1Nc7rVd77BazjPIrvgz1OP\n5FdKKeUSuolMKaWUS2iBUUop5RJaYJRSSrmEFhillFIuoQVGKaW8gDhOSnpMRLY2Y9ln5NuTa+4S\nkZMuyaSzyJRSyvOJyCigDMe5x/pewHqzgEHGmHtaO5OOYJRqQESmi8idF7B8cnN+NbYgzxVyjlOq\nn2P5fU0dXS8i/9nyZMqdGGNW0+DIehHpIY7T8meLyOci0ruRVW/FccbsVqcFRiknIhJgjHnRGLPA\n7iwupgXGN7wMzDLGDAF+juPccmeJSBKQAqxwxYsHNL2IUp5FHGeW/RjHmWUH4bhOxp1AHxzX4QjD\ncT64u4wxR0RkFbAWGA68JyLhOI5g/oOIDMRxvZ72OI6GvscYc0JEhgCvAeXAmiby+AO/x3EtlWBg\nnjHmJRG5AnjSytIXyAZuN8YYEZkI/Nl6bkMT/Ufh+AUag+MIa3F67l84zh8VAjxrjHlZRH4PtBOR\nTcA2Y8xUEbkdx9kQgqzP7UHjOGeW8lDiOAnm5cDb8u1Z9YMbLDYFWOyqf2sdwShv1Qt42TjOUHsK\nmIHjDLGTrV9zrwG/c1o+whgz2hjzxwb9LAAetfr5BviV1f5XYLYxZlgzstyL4xxQlwCXAD8WkRTr\nuUHAw0A6jtMHDReREBwnPbwOGAnENdH/r4A1xphBOM4Xlej03D3W+80EZotIlDHmMeCMMWagVVz6\n4Diz73BjzECgFpjajPel3JsfjsuCDHS69WmwzBRctHkMdASjvNdBY8wX1v3XcWwS6gsss37N+QPO\nJ/17q2EHItIRR+H5zGqaj+PXYMP2vwNXnyfLBKC/iNSf3LQjkAZUAV8ZY/Kt19uE46qcZUCeMWa3\n1f46cP95+h8F3AiOkxWKyAmn52aLyA3W/QTrdRuenHIcjjP4fm19Nu2AY+d5PeUBjDGnRCRPRG4y\nxrxtnRyzvzFmM4CI9AI6AetclUELjPJWDadHluLYHHSuEcfpC+hbGum/qeVnGWM++U6jYxNZpVNT\nLd9+Jy90euf3lrf6vxIYZowptzYFhpwj33xjzOMX+JrKjYjIP3Bsho0WkXwcI9upwAsi8l9AIPAm\njpNqgmPn/pvGhVOJdROZ8laJIlJfTG7FcebfmPo2EQmUJq7GaIwpAU6IyEir6Q7gM2PMSaBEREZY\n7U1tTvoEeEAc1+5ARHqKSOh5lt8BpIhID6f857O6PoOIXI3jVyk4RkonrOLSG8c12etV1+cBlgOT\nRaSz1UektfNXeRBjzK3GmC7GmEBjTLwx5lVjTJ4xZqIxZoAxJt0Y8xun5Z+0Npe6jBYY5a22A9NE\nZAsQibX/BXhKRDbjOLX55c3oZxrwtNXPQKD+C3o3ME9E1uE43fn5vALkABus6cwvcZ6tB8aYChyb\nxP4tImuA/U30/2tglIhswLE57oDV/jEQYGX/bxxFtt7LwBYRWWiMyQH+C1hqLbsMcL5GiVIXRQ+0\nVF7HmkX2wYUcbKaUan06glFKKeUSOoJRqpWIyFXAUw2a84wxNzS2/EX0fzfwUIPmL4wxM1qjf6Va\nmxYYpZRSLqGbyJRSSrmEFhillFIuoQVGKaWUS2iBUUop5RJaYJRSSrnE/wedol1bmsntVgAAAABJ\nRU5ErkJggg==\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x20c2602f9b0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_nums[(df_nums['company_name'] =='EMPIRE GLOBAL CORP.')&(df_nums['measure_tag']=='NetIncomeLoss')\n",
    "        &(df_nums['number_of_quarters']==1)].sort_values(by=['period_end_date']).drop_duplicates('period_end_date').plot(x=\"period_end_date\",y='value')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "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.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}