notebook.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "# Use the absolute path to the parquet file in the output directory\n",
    "df = pd.read_parquet('/workspace/graphrag/output/create_final_documents.parquet')\n",
    "# Adjust the display option to show the entire content of the 'summary' column\n",
    "#pd.set_option('display.max_colwidth', None)\n",
    "\n",
    "# # Display the DataFrame\n",
    "#print(df['text'])\n",
    "df\n",
    "\n",
    "df.to_csv('/workspace/data/final_documents.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "# Use the absolute path to the parquet file in the output directory\n",
    "df = pd.read_parquet('/workspace/graphrag/output/create_final_text_units.parquet')\n",
    "# Adjust the display option to show the entire content of the 'summary' column\n",
    "#pd.set_option('display.max_colwidth', None)\n",
    "\n",
    "# # Display the DataFrame\n",
    "#print(df['text'])\n",
    "df\n",
    "\n",
    "df.to_csv('/workspace/data/final_text_units.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>human_readable_id</th>\n",
       "      <th>title</th>\n",
       "      <th>community</th>\n",
       "      <th>level</th>\n",
       "      <th>degree</th>\n",
       "      <th>x</th>\n",
       "      <th>y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>38c4255d86504b12a5e55981e2e4909d</td>\n",
       "      <td>0</td>\n",
       "      <td>CATHERINE MILLER</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>6ae6e449cf7a412dae826593facf6ab3</td>\n",
       "      <td>1</td>\n",
       "      <td>KENNETH STOCKS</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>93f5fa9d70ef4fe5a7fcd10d25d0ce25</td>\n",
       "      <td>2</td>\n",
       "      <td>DENNIS WRIGHT</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>97afb18fcc84471b94ed0eb74234ae57</td>\n",
       "      <td>3</td>\n",
       "      <td>MARY WRIGHT</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>9a1b43eb7f994316bf54bc195dcbb649</td>\n",
       "      <td>4</td>\n",
       "      <td>RESIDENTIAL LANDLORD-TENANT ACT OF 1973</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55881</th>\n",
       "      <td>dbb0120eb41044d18f8f6896a1c06063</td>\n",
       "      <td>10781</td>\n",
       "      <td>AUTOMATIC RENEWAL</td>\n",
       "      <td>2000</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55912</th>\n",
       "      <td>8ad629d9996740c99d782367339fb7ce</td>\n",
       "      <td>10812</td>\n",
       "      <td>MULTIPLE PARTIES</td>\n",
       "      <td>1991</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55913</th>\n",
       "      <td>a11c626e40774763b8aaba7f08e288c5</td>\n",
       "      <td>10813</td>\n",
       "      <td>WRITTEN FINDINGS</td>\n",
       "      <td>1991</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55933</th>\n",
       "      <td>dfa592ce37464942843e1310573abd5e</td>\n",
       "      <td>10833</td>\n",
       "      <td>CROSS MOTIONS</td>\n",
       "      <td>1991</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55964</th>\n",
       "      <td>7d2c453eb7fd405a98a80379ea1283bd</td>\n",
       "      <td>10864</td>\n",
       "      <td>DE NOVO</td>\n",
       "      <td>1991</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>32982 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     id  human_readable_id  \\\n",
       "0      38c4255d86504b12a5e55981e2e4909d                  0   \n",
       "1      6ae6e449cf7a412dae826593facf6ab3                  1   \n",
       "2      93f5fa9d70ef4fe5a7fcd10d25d0ce25                  2   \n",
       "3      97afb18fcc84471b94ed0eb74234ae57                  3   \n",
       "4      9a1b43eb7f994316bf54bc195dcbb649                  4   \n",
       "...                                 ...                ...   \n",
       "55881  dbb0120eb41044d18f8f6896a1c06063              10781   \n",
       "55912  8ad629d9996740c99d782367339fb7ce              10812   \n",
       "55913  a11c626e40774763b8aaba7f08e288c5              10813   \n",
       "55933  dfa592ce37464942843e1310573abd5e              10833   \n",
       "55964  7d2c453eb7fd405a98a80379ea1283bd              10864   \n",
       "\n",
       "                                         title  community  level  degree  x  y  \n",
       "0                             CATHERINE MILLER         12      0      11  0  0  \n",
       "1                               KENNETH STOCKS         12      0       4  0  0  \n",
       "2                                DENNIS WRIGHT         14      0       4  0  0  \n",
       "3                                  MARY WRIGHT         14      0       3  0  0  \n",
       "4      RESIDENTIAL LANDLORD-TENANT ACT OF 1973         26      0      10  0  0  \n",
       "...                                        ...        ...    ...     ... .. ..  \n",
       "55881                        AUTOMATIC RENEWAL       2000      4       1  0  0  \n",
       "55912                         MULTIPLE PARTIES       1991      4       1  0  0  \n",
       "55913                         WRITTEN FINDINGS       1991      4       1  0  0  \n",
       "55933                            CROSS MOTIONS       1991      4       1  0  0  \n",
       "55964                                  DE NOVO       1991      4       1  0  0  \n",
       "\n",
       "[32982 rows x 8 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "# Use the absolute path to the parquet file in the output directory\n",
    "df = pd.read_parquet('/workspace/graphrag/output/create_final_nodes.parquet')\n",
    "# Adjust the display option to show the entire content of the 'summary' column\n",
    "#pd.set_option('display.max_colwidth', None)\n",
    "\n",
    "# # Display the DataFrame\n",
    "#print(df['text'])\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>human_readable_id</th>\n",
       "      <th>source</th>\n",
       "      <th>target</th>\n",
       "      <th>description</th>\n",
       "      <th>weight</th>\n",
       "      <th>combined_degree</th>\n",
       "      <th>text_unit_ids</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>c8ea7d7d612643c48683ede30fecc766</td>\n",
       "      <td>0</td>\n",
       "      <td>CATHERINE MILLER</td>\n",
       "      <td>DENNIS WRIGHT</td>\n",
       "      <td>Catherine Miller leased a residence from Dennis Wright, establishing a landlord-tenant relationship</td>\n",
       "      <td>8.0</td>\n",
       "      <td>15</td>\n",
       "      <td>[bbff4edb5cd4048c200fb720caaa1e8a]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ae4b8f73ec0f47f3938fdfd4980b4e74</td>\n",
       "      <td>1</td>\n",
       "      <td>CATHERINE MILLER</td>\n",
       "      <td>KENNETH STOCKS</td>\n",
       "      <td>Kenneth Stocks is the spouse of Catherine Miller and was involved in the lease agreement and subsequent legal dispute</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15</td>\n",
       "      <td>[bbff4edb5cd4048c200fb720caaa1e8a]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>f8779e8a9dfd4807af038261af05e501</td>\n",
       "      <td>2</td>\n",
       "      <td>CATHERINE MILLER</td>\n",
       "      <td>LEASE</td>\n",
       "      <td>Catherine Miller entered into a lease agreement with Dennis and Mary Wright for the residence</td>\n",
       "      <td>8.0</td>\n",
       "      <td>311</td>\n",
       "      <td>[bbff4edb5cd4048c200fb720caaa1e8a]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>195ca30581d346f3b980bd188943b313</td>\n",
       "      <td>3</td>\n",
       "      <td>CATHERINE MILLER</td>\n",
       "      <td>ARBITRATION</td>\n",
       "      <td>Catherine Miller's case went to arbitration to resolve the dispute with the Wrights</td>\n",
       "      <td>7.0</td>\n",
       "      <td>40</td>\n",
       "      <td>[bbff4edb5cd4048c200fb720caaa1e8a]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2202844814fd4b46b6fd98711ec4d3be</td>\n",
       "      <td>4</td>\n",
       "      <td>CATHERINE MILLER</td>\n",
       "      <td>BREACH OF CONTRACT</td>\n",
       "      <td>Catherine Miller counterclaimed for breach of contract against the Wrights</td>\n",
       "      <td>1.0</td>\n",
       "      <td>56</td>\n",
       "      <td>[bbff4edb5cd4048c200fb720caaa1e8a]</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19077</th>\n",
       "      <td>ebc9ef4b7fb24490856f0f6b6b326a44</td>\n",
       "      <td>19077</td>\n",
       "      <td>ENDORSEMENT</td>\n",
       "      <td>SUSPENSION</td>\n",
       "      <td>The endorsement specifies the conditions under which insurance coverage is suspended due to vacancy</td>\n",
       "      <td>8.0</td>\n",
       "      <td>16</td>\n",
       "      <td>[60d0d62de71bacb257c43a64b2bfe35f]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19078</th>\n",
       "      <td>3dd80fb253d7481881b27ec9089cf342</td>\n",
       "      <td>19078</td>\n",
       "      <td>AMOUNT OF VACANCY</td>\n",
       "      <td>CUSTOMARY OPERATIONS</td>\n",
       "      <td>The customary operations of the building determine whether the amount of vacancy meets the policy's requirements</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3</td>\n",
       "      <td>[60d0d62de71bacb257c43a64b2bfe35f]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19079</th>\n",
       "      <td>c8c6960a84d347bf8216bdcf1acf88ad</td>\n",
       "      <td>19079</td>\n",
       "      <td>OWNERS ASS’N BD. OF DIRS.</td>\n",
       "      <td>ALLSTATE INS. CO.</td>\n",
       "      <td>The Owners Association Board of Directors is involved in a legal case against Allstate Insurance Company regarding policy coverage</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3</td>\n",
       "      <td>[ab7f53f8a27e5f48862eb268f866bb4c]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19080</th>\n",
       "      <td>60ac0b25415e4886aa8e4e1a957851ea</td>\n",
       "      <td>19080</td>\n",
       "      <td>VACANCY ENDORSEMENT</td>\n",
       "      <td>60 DAYS</td>\n",
       "      <td>The vacancy endorsement specifies coverage limitations that begin after a building has been vacant for 60 days</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6</td>\n",
       "      <td>[ab7f53f8a27e5f48862eb268f866bb4c]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19081</th>\n",
       "      <td>259d71aa7b3b483394897307d5029fb9</td>\n",
       "      <td>19081</td>\n",
       "      <td>VACANCY ENDORSEMENT</td>\n",
       "      <td>CONDITIONS</td>\n",
       "      <td>Conditions in a vacant building can affect the application of the vacancy endorsement in the insurance policy</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6</td>\n",
       "      <td>[ab7f53f8a27e5f48862eb268f866bb4c]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>19082 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     id  human_readable_id  \\\n",
       "0      c8ea7d7d612643c48683ede30fecc766                  0   \n",
       "1      ae4b8f73ec0f47f3938fdfd4980b4e74                  1   \n",
       "2      f8779e8a9dfd4807af038261af05e501                  2   \n",
       "3      195ca30581d346f3b980bd188943b313                  3   \n",
       "4      2202844814fd4b46b6fd98711ec4d3be                  4   \n",
       "...                                 ...                ...   \n",
       "19077  ebc9ef4b7fb24490856f0f6b6b326a44              19077   \n",
       "19078  3dd80fb253d7481881b27ec9089cf342              19078   \n",
       "19079  c8c6960a84d347bf8216bdcf1acf88ad              19079   \n",
       "19080  60ac0b25415e4886aa8e4e1a957851ea              19080   \n",
       "19081  259d71aa7b3b483394897307d5029fb9              19081   \n",
       "\n",
       "                          source                target  \\\n",
       "0               CATHERINE MILLER         DENNIS WRIGHT   \n",
       "1               CATHERINE MILLER        KENNETH STOCKS   \n",
       "2               CATHERINE MILLER                 LEASE   \n",
       "3               CATHERINE MILLER           ARBITRATION   \n",
       "4               CATHERINE MILLER    BREACH OF CONTRACT   \n",
       "...                          ...                   ...   \n",
       "19077                ENDORSEMENT            SUSPENSION   \n",
       "19078          AMOUNT OF VACANCY  CUSTOMARY OPERATIONS   \n",
       "19079  OWNERS ASS’N BD. OF DIRS.     ALLSTATE INS. CO.   \n",
       "19080        VACANCY ENDORSEMENT               60 DAYS   \n",
       "19081        VACANCY ENDORSEMENT            CONDITIONS   \n",
       "\n",
       "                                                                                                                              description  \\\n",
       "0                                     Catherine Miller leased a residence from Dennis Wright, establishing a landlord-tenant relationship   \n",
       "1                   Kenneth Stocks is the spouse of Catherine Miller and was involved in the lease agreement and subsequent legal dispute   \n",
       "2                                           Catherine Miller entered into a lease agreement with Dennis and Mary Wright for the residence   \n",
       "3                                                     Catherine Miller's case went to arbitration to resolve the dispute with the Wrights   \n",
       "4                                                              Catherine Miller counterclaimed for breach of contract against the Wrights   \n",
       "...                                                                                                                                   ...   \n",
       "19077                                 The endorsement specifies the conditions under which insurance coverage is suspended due to vacancy   \n",
       "19078                    The customary operations of the building determine whether the amount of vacancy meets the policy's requirements   \n",
       "19079  The Owners Association Board of Directors is involved in a legal case against Allstate Insurance Company regarding policy coverage   \n",
       "19080                      The vacancy endorsement specifies coverage limitations that begin after a building has been vacant for 60 days   \n",
       "19081                       Conditions in a vacant building can affect the application of the vacancy endorsement in the insurance policy   \n",
       "\n",
       "       weight  combined_degree                       text_unit_ids  \n",
       "0         8.0               15  [bbff4edb5cd4048c200fb720caaa1e8a]  \n",
       "1         7.0               15  [bbff4edb5cd4048c200fb720caaa1e8a]  \n",
       "2         8.0              311  [bbff4edb5cd4048c200fb720caaa1e8a]  \n",
       "3         7.0               40  [bbff4edb5cd4048c200fb720caaa1e8a]  \n",
       "4         1.0               56  [bbff4edb5cd4048c200fb720caaa1e8a]  \n",
       "...       ...              ...                                 ...  \n",
       "19077     8.0               16  [60d0d62de71bacb257c43a64b2bfe35f]  \n",
       "19078     8.0                3  [60d0d62de71bacb257c43a64b2bfe35f]  \n",
       "19079     8.0                3  [ab7f53f8a27e5f48862eb268f866bb4c]  \n",
       "19080     9.0                6  [ab7f53f8a27e5f48862eb268f866bb4c]  \n",
       "19081     1.0                6  [ab7f53f8a27e5f48862eb268f866bb4c]  \n",
       "\n",
       "[19082 rows x 8 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "# Use the absolute path to the parquet file in the output directory\n",
    "df = pd.read_parquet('/workspace/graphrag/output/create_final_relationships.parquet')\n",
    "# Adjust the display option to show the entire content of the 'summary' column\n",
    "pd.set_option('display.max_colwidth', 512)\n",
    "\n",
    "# # Display the DataFrame\n",
    "#print(df['text'])\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>human_readable_id</th>\n",
       "      <th>title</th>\n",
       "      <th>type</th>\n",
       "      <th>description</th>\n",
       "      <th>text_unit_ids</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>38c4255d86504b12a5e55981e2e4909d</td>\n",
       "      <td>0</td>\n",
       "      <td>CATHERINE MILLER</td>\n",
       "      <td>PERSON</td>\n",
       "      <td>Catherine Miller is an individual who leased a residence from Dennis and Mary Wright and was involved in a legal dispute regarding the lease terms.</td>\n",
       "      <td>[bbff4edb5cd4048c200fb720caaa1e8a]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>6ae6e449cf7a412dae826593facf6ab3</td>\n",
       "      <td>1</td>\n",
       "      <td>KENNETH STOCKS</td>\n",
       "      <td>PERSON</td>\n",
       "      <td>Kenneth Stocks is the spouse of Catherine Miller who was joined in the lease agreement and the subsequent legal dispute.</td>\n",
       "      <td>[bbff4edb5cd4048c200fb720caaa1e8a]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>93f5fa9d70ef4fe5a7fcd10d25d0ce25</td>\n",
       "      <td>2</td>\n",
       "      <td>DENNIS WRIGHT</td>\n",
       "      <td>PERSON</td>\n",
       "      <td>Dennis Wright is an individual who owns the residence leased to Catherine Miller and is involved in the legal dispute as a landlord.</td>\n",
       "      <td>[bbff4edb5cd4048c200fb720caaa1e8a]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>97afb18fcc84471b94ed0eb74234ae57</td>\n",
       "      <td>3</td>\n",
       "      <td>MARY WRIGHT</td>\n",
       "      <td>PERSON</td>\n",
       "      <td>Mary Wright is an individual who co-owns the residence leased to Catherine Miller and is involved in the legal dispute as a landlord.</td>\n",
       "      <td>[bbff4edb5cd4048c200fb720caaa1e8a]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>9a1b43eb7f994316bf54bc195dcbb649</td>\n",
       "      <td>4</td>\n",
       "      <td>RESIDENTIAL LANDLORD-TENANT ACT OF 1973</td>\n",
       "      <td>LEGAL CONCEPT</td>\n",
       "      <td>The Residential Landlord-Tenant Act of 1973 (RLTA) is a comprehensive legislative enactment in Washington State that governs the rights and responsibilities of landlords and tenants involved in residential leases. This statute provides a detailed framework outlining the specific duties of both parties, ensuring clarity in their relationship. It includes provisions for rental agreements and establishes specific remedies for violations of tenant rights, thereby protecting the interests of both landlords a...</td>\n",
       "      <td>[023fa4d4186e7d9c1c23d0c43dcf0229, 0267ec32ab9fb1b116069b6b47d1f057, 1324776e2bcf228fce4b7d5dddb02b77, 139dbb6ab96e021cd083a13611f7953a, 5f600f08ad81816236999c4db4b5f445, aff8b6fd2efa3912264b394844fef218, bbff4edb5cd4048c200fb720caaa1e8a, efe6921005a432438a25242f26120b26, f37b29574e94b4098bc7259686e321e7]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10919</th>\n",
       "      <td>130138aaa9d546f984c6f8b7751a2c31</td>\n",
       "      <td>10919</td>\n",
       "      <td>GORDON MCCLOUD</td>\n",
       "      <td>PERSON</td>\n",
       "      <td>Gordon McCloud is a Justice who is part of a judicial panel that concurs on a decision.</td>\n",
       "      <td>[bda3a09a559864ed82f8e7a9f4d7581b]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10920</th>\n",
       "      <td>e1ec251141684c0aa2f802e5585865ee</td>\n",
       "      <td>10920</td>\n",
       "      <td>YU</td>\n",
       "      <td>PERSON</td>\n",
       "      <td>Yu is a Justice who is part of a judicial panel that concurs on a decision.</td>\n",
       "      <td>[bda3a09a559864ed82f8e7a9f4d7581b]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10921</th>\n",
       "      <td>d3b56f77fcf54b7092bce06fbb662f16</td>\n",
       "      <td>10921</td>\n",
       "      <td>ISSUES</td>\n",
       "      <td>LEGAL CONCEPT</td>\n",
       "      <td>Issues refer to the specific legal questions or matters that are being considered or disputed in a court case.</td>\n",
       "      <td>[bda3a09a559864ed82f8e7a9f4d7581b]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10922</th>\n",
       "      <td>6533532ded9b4c9da6679ea73c1cfb07</td>\n",
       "      <td>10922</td>\n",
       "      <td>SLIP OPINION</td>\n",
       "      <td>LEGAL DOCUMENT</td>\n",
       "      <td>A slip opinion is a preliminary version of a court's decision that is subject to revision before being published in a final form.</td>\n",
       "      <td>[bda3a09a559864ed82f8e7a9f4d7581b]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10923</th>\n",
       "      <td>6bdf8a07ed9d4f89ae1bf4aae69cf1db</td>\n",
       "      <td>10923</td>\n",
       "      <td>UNPUBLISHED</td>\n",
       "      <td>LEGAL CONCEPT</td>\n",
       "      <td>Unpublished refers to court opinions that are not published in official reports and are typically not intended to be cited as precedent.</td>\n",
       "      <td>[bda3a09a559864ed82f8e7a9f4d7581b]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10924 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     id  human_readable_id  \\\n",
       "0      38c4255d86504b12a5e55981e2e4909d                  0   \n",
       "1      6ae6e449cf7a412dae826593facf6ab3                  1   \n",
       "2      93f5fa9d70ef4fe5a7fcd10d25d0ce25                  2   \n",
       "3      97afb18fcc84471b94ed0eb74234ae57                  3   \n",
       "4      9a1b43eb7f994316bf54bc195dcbb649                  4   \n",
       "...                                 ...                ...   \n",
       "10919  130138aaa9d546f984c6f8b7751a2c31              10919   \n",
       "10920  e1ec251141684c0aa2f802e5585865ee              10920   \n",
       "10921  d3b56f77fcf54b7092bce06fbb662f16              10921   \n",
       "10922  6533532ded9b4c9da6679ea73c1cfb07              10922   \n",
       "10923  6bdf8a07ed9d4f89ae1bf4aae69cf1db              10923   \n",
       "\n",
       "                                         title            type  \\\n",
       "0                             CATHERINE MILLER          PERSON   \n",
       "1                               KENNETH STOCKS          PERSON   \n",
       "2                                DENNIS WRIGHT          PERSON   \n",
       "3                                  MARY WRIGHT          PERSON   \n",
       "4      RESIDENTIAL LANDLORD-TENANT ACT OF 1973   LEGAL CONCEPT   \n",
       "...                                        ...             ...   \n",
       "10919                           GORDON MCCLOUD          PERSON   \n",
       "10920                                       YU          PERSON   \n",
       "10921                                   ISSUES   LEGAL CONCEPT   \n",
       "10922                             SLIP OPINION  LEGAL DOCUMENT   \n",
       "10923                              UNPUBLISHED   LEGAL CONCEPT   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           description  \\\n",
       "0                                                                                                                                                                                                                                                                                                                                                                                  Catherine Miller is an individual who leased a residence from Dennis and Mary Wright and was involved in a legal dispute regarding the lease terms.   \n",
       "1                                                                                                                                                                                                                                                                                                                                                                                                             Kenneth Stocks is the spouse of Catherine Miller who was joined in the lease agreement and the subsequent legal dispute.   \n",
       "2                                                                                                                                                                                                                                                                                                                                                                                                 Dennis Wright is an individual who owns the residence leased to Catherine Miller and is involved in the legal dispute as a landlord.   \n",
       "3                                                                                                                                                                                                                                                                                                                                                                                                Mary Wright is an individual who co-owns the residence leased to Catherine Miller and is involved in the legal dispute as a landlord.   \n",
       "4      The Residential Landlord-Tenant Act of 1973 (RLTA) is a comprehensive legislative enactment in Washington State that governs the rights and responsibilities of landlords and tenants involved in residential leases. This statute provides a detailed framework outlining the specific duties of both parties, ensuring clarity in their relationship. It includes provisions for rental agreements and establishes specific remedies for violations of tenant rights, thereby protecting the interests of both landlords a...   \n",
       "...                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                ...   \n",
       "10919                                                                                                                                                                                                                                                                                                                                                                                                                                          Gordon McCloud is a Justice who is part of a judicial panel that concurs on a decision.   \n",
       "10920                                                                                                                                                                                                                                                                                                                                                                                                                                                      Yu is a Justice who is part of a judicial panel that concurs on a decision.   \n",
       "10921                                                                                                                                                                                                                                                                                                                                                                                                                   Issues refer to the specific legal questions or matters that are being considered or disputed in a court case.   \n",
       "10922                                                                                                                                                                                                                                                                                                                                                                                                A slip opinion is a preliminary version of a court's decision that is subject to revision before being published in a final form.   \n",
       "10923                                                                                                                                                                                                                                                                                                                                                                                         Unpublished refers to court opinions that are not published in official reports and are typically not intended to be cited as precedent.   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                            text_unit_ids  \n",
       "0                                                                                                                                                                                                                                                                                      [bbff4edb5cd4048c200fb720caaa1e8a]  \n",
       "1                                                                                                                                                                                                                                                                                      [bbff4edb5cd4048c200fb720caaa1e8a]  \n",
       "2                                                                                                                                                                                                                                                                                      [bbff4edb5cd4048c200fb720caaa1e8a]  \n",
       "3                                                                                                                                                                                                                                                                                      [bbff4edb5cd4048c200fb720caaa1e8a]  \n",
       "4      [023fa4d4186e7d9c1c23d0c43dcf0229, 0267ec32ab9fb1b116069b6b47d1f057, 1324776e2bcf228fce4b7d5dddb02b77, 139dbb6ab96e021cd083a13611f7953a, 5f600f08ad81816236999c4db4b5f445, aff8b6fd2efa3912264b394844fef218, bbff4edb5cd4048c200fb720caaa1e8a, efe6921005a432438a25242f26120b26, f37b29574e94b4098bc7259686e321e7]  \n",
       "...                                                                                                                                                                                                                                                                                                                   ...  \n",
       "10919                                                                                                                                                                                                                                                                                  [bda3a09a559864ed82f8e7a9f4d7581b]  \n",
       "10920                                                                                                                                                                                                                                                                                  [bda3a09a559864ed82f8e7a9f4d7581b]  \n",
       "10921                                                                                                                                                                                                                                                                                  [bda3a09a559864ed82f8e7a9f4d7581b]  \n",
       "10922                                                                                                                                                                                                                                                                                  [bda3a09a559864ed82f8e7a9f4d7581b]  \n",
       "10923                                                                                                                                                                                                                                                                                  [bda3a09a559864ed82f8e7a9f4d7581b]  \n",
       "\n",
       "[10924 rows x 6 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "# Use the absolute path to the parquet file in the output directory\n",
    "df = pd.read_parquet('/workspace/graphrag/output/create_final_entities.parquet')\n",
    "# Adjust the display option to show the entire content of the 'summary' column\n",
    "#pd.set_option('display.max_colwidth', None)\n",
    "\n",
    "# # Display the DataFrame\n",
    "#print(df['text'])\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "# Use the absolute path to the parquet file in the output directory\n",
    "df = pd.read_parquet('/workspace/graphrag/output/create_final_communities.parquet')\n",
    "# Adjust the display option to show the entire content of the 'summary' column\n",
    "#pd.set_option('display.max_colwidth', None)\n",
    "\n",
    "# # Display the DataFrame\n",
    "#print(df['text'])\n",
    "df\n",
    "\n",
    "df.to_csv('/workspace/data/final_communities.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>human_readable_id</th>\n",
       "      <th>community</th>\n",
       "      <th>level</th>\n",
       "      <th>title</th>\n",
       "      <th>summary</th>\n",
       "      <th>full_content</th>\n",
       "      <th>rank</th>\n",
       "      <th>rank_explanation</th>\n",
       "      <th>findings</th>\n",
       "      <th>full_content_json</th>\n",
       "      <th>period</th>\n",
       "      <th>size</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>8a5a55b0-9345-4d98-97b2-87d982c4e118</td>\n",
       "      <td>1992</td>\n",
       "      <td>1992</td>\n",
       "      <td>4</td>\n",
       "      <td>Jackowski v. Borchelt: Legal Framework and Implications</td>\n",
       "      <td>The community surrounding the Jackowski v. Borchelt case involves key entities such as the trial court, the plaintiff, and legal instructions that shape the understanding of negligence and breach of contract claims. The relationships among these entities highlight the complexities of landlord liability and the presumption of negligence, which are central to the case's legal principles.</td>\n",
       "      <td># Jackowski v. Borchelt: Legal Framework and Implications\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as the trial court, the plaintiff, and legal instructions that shape the understanding of negligence and breach of contract claims. The relationships among these entities highlight the complexities of landlord liability and the presumption of negligence, which are central to the case's legal principles.\\n\\n## Instruction No. 9 as a pivotal legal dir...</td>\n",
       "      <td>9.0</td>\n",
       "      <td>The case is highly significant for understanding breach of contract claims and landlord liability, making it essential for legal practitioners.</td>\n",
       "      <td>[{'explanation': 'Instruction No. 9 is a comprehensive directive issued by the trial court that outlines the essential elements the plaintiff must establish to succeed in their claims. This instruction serves multiple purposes, including addressing the defense of independent intervening acts, which allows the jury to consider various defenses during deliberations. By providing specific legal standards related to negligence, Instruction No. 9 ensures that the jury is well-informed about the r...</td>\n",
       "      <td>{\\n    \"title\": \"Jackowski v. Borchelt: Legal Framework and Implications\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as the trial court, the plaintiff, and legal instructions that shape the understanding of negligence and breach of contract claims. The relationships among these entities highlight the complexities of landlord liability and the presumption of negligence, which are central to the case's legal principles.\",\\n    \"rating\"...</td>\n",
       "      <td>2024-12-17</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>8a4581ba-7ad5-476e-a983-d9ed481cae7d</td>\n",
       "      <td>1993</td>\n",
       "      <td>1993</td>\n",
       "      <td>4</td>\n",
       "      <td>Jackowski v. Borchelt: Breach of Contract and Landlord Liability</td>\n",
       "      <td>The community surrounding the Jackowski v. Borchelt case involves key entities such as the trial court, the concept of margin of safety, and the tubing involved in the case. The relationships among these entities highlight the legal principles of breach of contract claims, reasonable reliance in tort law, and landlord liability, which are critical for understanding the implications of the court's rulings.</td>\n",
       "      <td># Jackowski v. Borchelt: Breach of Contract and Landlord Liability\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as the trial court, the concept of margin of safety, and the tubing involved in the case. The relationships among these entities highlight the legal principles of breach of contract claims, reasonable reliance in tort law, and landlord liability, which are critical for understanding the implications of the court's rulings.\\n\\n## Importance ...</td>\n",
       "      <td>9.0</td>\n",
       "      <td>The case is highly significant as it addresses essential legal principles that impact future breach of contract claims and landlord liability interpretations.</td>\n",
       "      <td>[{'explanation': 'The concept of 'Margin of Safety' is pivotal in the Jackowski v. Borchelt case, as it pertains to the critical length of tubing necessary to ensure secure connections to a faucet. The trial court emphasized this concept in its findings, indicating that maintaining a sufficient margin of safety is essential to avoid hazards associated with tubing disconnection. This principle not only affects the specific case at hand but also sets a precedent for future cases involving simi...</td>\n",
       "      <td>{\\n    \"title\": \"Jackowski v. Borchelt: Breach of Contract and Landlord Liability\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as the trial court, the concept of margin of safety, and the tubing involved in the case. The relationships among these entities highlight the legal principles of breach of contract claims, reasonable reliance in tort law, and landlord liability, which are critical for understanding the implications of the cou...</td>\n",
       "      <td>2024-12-17</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>b271cea4-0e5d-4bbf-b50f-d6344176b3b3</td>\n",
       "      <td>1995</td>\n",
       "      <td>1995</td>\n",
       "      <td>4</td>\n",
       "      <td>Jackowski v. Borchelt: Breach of Contract and Tort Law Implications</td>\n",
       "      <td>The community surrounding the Jackowski v. Borchelt case involves key entities such as the plaintiffs, defendants, and the court system, all of which play significant roles in the legal analysis of breach of contract claims and tort law principles. The relationships among these entities highlight the complexities of landlord liability and the economic loss rule, which are central to understanding the implications of the court's rulings.</td>\n",
       "      <td># Jackowski v. Borchelt: Breach of Contract and Tort Law Implications\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as the plaintiffs, defendants, and the court system, all of which play significant roles in the legal analysis of breach of contract claims and tort law principles. The relationships among these entities highlight the complexities of landlord liability and the economic loss rule, which are central to understanding the implications of the...</td>\n",
       "      <td>9.0</td>\n",
       "      <td>The case is highly significant for its implications on breach of contract claims and tort law, particularly regarding reasonable reliance and landlord liability.</td>\n",
       "      <td>[{'explanation': 'In the Jackowski v. Borchelt case, the primary parties involved are the plaintiffs, Jackowski, and the defendants, Borchelt. Jackowski alleges that Borchelt breached a contract related to a rental agreement, which is a common issue in landlord-tenant disputes. The relationship between these parties is foundational to the case, as it sets the stage for the legal arguments surrounding breach of contract and the expectations of both parties under the agreement. The court's int...</td>\n",
       "      <td>{\\n    \"title\": \"Jackowski v. Borchelt: Breach of Contract and Tort Law Implications\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as the plaintiffs, defendants, and the court system, all of which play significant roles in the legal analysis of breach of contract claims and tort law principles. The relationships among these entities highlight the complexities of landlord liability and the economic loss rule, which are central to unders...</td>\n",
       "      <td>2024-12-17</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>a1b219e6-db4a-419c-94ac-d03761dc3884</td>\n",
       "      <td>1996</td>\n",
       "      <td>1996</td>\n",
       "      <td>4</td>\n",
       "      <td>Jackowski v. Borchelt: Legal Community Analysis</td>\n",
       "      <td>The community surrounding the Jackowski v. Borchelt case involves key entities such as the Superior Court, the Homebuilders Association, and various legal principles including breach of contract and reasonable reliance. The relationships among these entities highlight the complexities of landlord liability and the economic loss rule, which are central to the case's implications for future legal interpretations.</td>\n",
       "      <td># Jackowski v. Borchelt: Legal Community Analysis\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as the Superior Court, the Homebuilders Association, and various legal principles including breach of contract and reasonable reliance. The relationships among these entities highlight the complexities of landlord liability and the economic loss rule, which are central to the case's implications for future legal interpretations.\\n\\n## Role of the Superior C...</td>\n",
       "      <td>9.5</td>\n",
       "      <td>The case is highly significant for understanding breach of contract claims and landlord liability, with potential implications for future case law.</td>\n",
       "      <td>[{'explanation': 'The Superior Court serves as the primary judicial body adjudicating the Jackowski v. Borchelt case, with general jurisdiction over civil matters including contract disputes. Its rulings not only impact the parties involved but also set precedents that influence future cases. The court's authority to review and reverse decisions made by lower courts underscores its critical role in the legal landscape, particularly in matters of landlord liability and breach of contract clai...</td>\n",
       "      <td>{\\n    \"title\": \"Jackowski v. Borchelt: Legal Community Analysis\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as the Superior Court, the Homebuilders Association, and various legal principles including breach of contract and reasonable reliance. The relationships among these entities highlight the complexities of landlord liability and the economic loss rule, which are central to the case's implications for future legal interpretation...</td>\n",
       "      <td>2024-12-17</td>\n",
       "      <td>19.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>f6d09c20-446a-477e-b7f3-8c754d0b14ef</td>\n",
       "      <td>1997</td>\n",
       "      <td>1997</td>\n",
       "      <td>4</td>\n",
       "      <td>Judicial Relationships in Jackowski v. Borchelt</td>\n",
       "      <td>The community surrounding the Jackowski v. Borchelt case involves key judicial figures, specifically Justices Green and Roe, who played significant roles in the case's adjudication. Their relationships highlight the collaborative nature of judicial decision-making and the implications of their rulings on breach of contract and tort law.</td>\n",
       "      <td># Judicial Relationships in Jackowski v. Borchelt\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key judicial figures, specifically Justices Green and Roe, who played significant roles in the case's adjudication. Their relationships highlight the collaborative nature of judicial decision-making and the implications of their rulings on breach of contract and tort law.\\n\\n## Justice Green's dual role\\n\\nJustice Green is a pivotal figure in this community, serving both as ...</td>\n",
       "      <td>8.5</td>\n",
       "      <td>The rating reflects the case's substantial relevance to legal principles, particularly in breach of contract claims and judicial interpretations of landlord liability.</td>\n",
       "      <td>[{'explanation': 'Justice Green is a pivotal figure in this community, serving both as a Justice who concurred with the judgment in the Jackowski v. Borchelt case and as an appellant in a separate legal matter against the City of Seattle. Her involvement in multiple legal contexts underscores the interconnectedness of judicial roles and the potential for her decisions to influence broader legal interpretations. The case illustrates how a Justice's rulings can have far-reaching implications, ...</td>\n",
       "      <td>{\\n    \"title\": \"Judicial Relationships in Jackowski v. Borchelt\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key judicial figures, specifically Justices Green and Roe, who played significant roles in the case's adjudication. Their relationships highlight the collaborative nature of judicial decision-making and the implications of their rulings on breach of contract and tort law.\",\\n    \"rating\": 8.5,\\n    \"rating_explanation\": \"The rating reflects the...</td>\n",
       "      <td>2024-12-17</td>\n",
       "      <td>2.0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024</th>\n",
       "      <td>571f09b9-8948-4496-b29c-7b4d266fa980</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "      <td>Jackowski v. Borchelt: Legal Relationships and Implications</td>\n",
       "      <td>The community surrounding the Jackowski v. Borchelt case involves key entities such as Ronald L. Ewer, Goodyear Tire and Rubber Company, and the concept of injury, which is central to the legal claims made. The relationships between the plaintiff, the defendant, and the nature of the injuries sustained highlight significant legal principles, including breach of contract, negligence, and landlord liability.</td>\n",
       "      <td># Jackowski v. Borchelt: Legal Relationships and Implications\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as Ronald L. Ewer, Goodyear Tire and Rubber Company, and the concept of injury, which is central to the legal claims made. The relationships between the plaintiff, the defendant, and the nature of the injuries sustained highlight significant legal principles, including breach of contract, negligence, and landlord liability.\\n\\n## Centrality of I...</td>\n",
       "      <td>9.0</td>\n",
       "      <td>The case is highly significant as it addresses critical legal principles that will influence future tort and contract claims.</td>\n",
       "      <td>[{'explanation': 'In the context of the Jackowski v. Borchelt case, the concept of injury is pivotal. Injury encompasses a wide range of physical, emotional, and financial harm that can arise from various circumstances, including negligence. In this case, Ronald L. Ewer claims to have sustained injuries due to the explosion of a tractor tire manufactured by Goodyear Tire and Rubber Company. This claim illustrates how injuries serve as the foundation for legal actions in tort law, necessitati...</td>\n",
       "      <td>{\\n    \"title\": \"Jackowski v. Borchelt: Legal Relationships and Implications\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as Ronald L. Ewer, Goodyear Tire and Rubber Company, and the concept of injury, which is central to the legal claims made. The relationships between the plaintiff, the defendant, and the nature of the injuries sustained highlight significant legal principles, including breach of contract, negligence, and landlord l...</td>\n",
       "      <td>2024-12-17</td>\n",
       "      <td>222.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025</th>\n",
       "      <td>9f2373c7-2892-472d-b042-5fb453800819</td>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "      <td>0</td>\n",
       "      <td>Jackowski v. Borchelt: Breach of Contract and Liability Dynamics</td>\n",
       "      <td>The community surrounding the Jackowski v. Borchelt case involves key entities such as the parties to the dispute, the sheriff's sale process, and legal principles like breach of contract and reasonable reliance. The relationships among these entities highlight the complexities of enforcing legal obligations and the implications of judicial interpretations on future cases, particularly regarding landlord liability and the economic loss rule.</td>\n",
       "      <td># Jackowski v. Borchelt: Breach of Contract and Liability Dynamics\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as the parties to the dispute, the sheriff's sale process, and legal principles like breach of contract and reasonable reliance. The relationships among these entities highlight the complexities of enforcing legal obligations and the implications of judicial interpretations on future cases, particularly regarding landlord liability and the ...</td>\n",
       "      <td>9.0</td>\n",
       "      <td>The case is highly significant as it addresses critical legal principles that will influence future interpretations of breach of contract and liability issues.</td>\n",
       "      <td>[{'explanation': 'The Jackowski v. Borchelt case centers on a breach of contract claim, where the plaintiff, Jackowski, alleges that Borchelt failed to fulfill contractual obligations. This case illustrates the importance of clearly defined terms in contracts and the legal consequences of failing to adhere to them. The court's ruling will likely set a precedent for how similar cases are interpreted in the future, emphasizing the need for parties to understand their contractual duties and the...</td>\n",
       "      <td>{\\n    \"title\": \"Jackowski v. Borchelt: Breach of Contract and Liability Dynamics\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as the parties to the dispute, the sheriff's sale process, and legal principles like breach of contract and reasonable reliance. The relationships among these entities highlight the complexities of enforcing legal obligations and the implications of judicial interpretations on future cases, particularly regard...</td>\n",
       "      <td>2024-12-17</td>\n",
       "      <td>150.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2026</th>\n",
       "      <td>d439707e-5855-4991-af43-c19fbf87af42</td>\n",
       "      <td>48</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>Jackowski v. Borchelt: Landlord-Tenant Dynamics and Liability</td>\n",
       "      <td>The community surrounding the Jackowski v. Borchelt case involves landlords, tenants, and the trial court, all of which play significant roles in assessing damages related to property and contractual obligations. The relationships among these entities highlight the complexities of breach of contract claims, reasonable reliance in tort law, and the implications of judicial interpretations on landlord liability and the economic loss rule.</td>\n",
       "      <td># Jackowski v. Borchelt: Landlord-Tenant Dynamics and Liability\\n\\nThe community surrounding the Jackowski v. Borchelt case involves landlords, tenants, and the trial court, all of which play significant roles in assessing damages related to property and contractual obligations. The relationships among these entities highlight the complexities of breach of contract claims, reasonable reliance in tort law, and the implications of judicial interpretations on landlord liability and the economic...</td>\n",
       "      <td>9.5</td>\n",
       "      <td>The case is highly significant for understanding breach of contract claims, landlord liability, and the economic loss rule in tort law.</td>\n",
       "      <td>[{'explanation': 'The trial court plays a pivotal role in assessing and awarding damages in disputes, particularly in landlord-tenant relationships. In the Jackowski v. Borchelt case, the court evaluated claims of damage based on evidence from both parties, including the condition of the premises and obligations outlined in the lease agreement. The court's judgment reflects its responsibility to ensure fair compensation for damages incurred, which is essential in resolving disputes and maint...</td>\n",
       "      <td>{\\n    \"title\": \"Jackowski v. Borchelt: Landlord-Tenant Dynamics and Liability\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves landlords, tenants, and the trial court, all of which play significant roles in assessing damages related to property and contractual obligations. The relationships among these entities highlight the complexities of breach of contract claims, reasonable reliance in tort law, and the implications of judicial interpretations on land...</td>\n",
       "      <td>2024-12-17</td>\n",
       "      <td>821.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2027</th>\n",
       "      <td>40ff7897-011c-4420-a1f3-d2ee1df81a59</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>Jackowski v. Borchelt: Legal Relationships and Implications</td>\n",
       "      <td>The community surrounding the Jackowski v. Borchelt case involves key entities such as the plaintiffs (Jackowski), defendants (Borchelt), legal practitioners, and regulatory bodies. The relationships among these entities highlight the complexities of breach of contract claims, reasonable reliance in tort law, and the implications of judicial interpretations on landlord liability and the economic loss rule.</td>\n",
       "      <td># Jackowski v. Borchelt: Legal Relationships and Implications\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as the plaintiffs (Jackowski), defendants (Borchelt), legal practitioners, and regulatory bodies. The relationships among these entities highlight the complexities of breach of contract claims, reasonable reliance in tort law, and the implications of judicial interpretations on landlord liability and the economic loss rule.\\n\\n## Parties Involve...</td>\n",
       "      <td>9.5</td>\n",
       "      <td>The case is highly significant for understanding breach of contract claims and landlord liability, with implications for future legal interpretations.</td>\n",
       "      <td>[{'explanation': 'In the Jackowski v. Borchelt case, the primary parties involved are the plaintiffs, Jackowski, and the defendants, Borchelt. The plaintiffs allege that the defendants breached a contract related to a rental agreement, which is central to the case. The relationship between these parties is crucial as it establishes the basis for the legal claims made. The plaintiffs argue that they relied on the defendants' representations regarding the rental property, which they claim were...</td>\n",
       "      <td>{\\n    \"title\": \"Jackowski v. Borchelt: Legal Relationships and Implications\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as the plaintiffs (Jackowski), defendants (Borchelt), legal practitioners, and regulatory bodies. The relationships among these entities highlight the complexities of breach of contract claims, reasonable reliance in tort law, and the implications of judicial interpretations on landlord liability and the economic l...</td>\n",
       "      <td>2024-12-17</td>\n",
       "      <td>88.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2028</th>\n",
       "      <td>19b4c0d2-838c-4a2d-9f7f-7fdb99bae6bf</td>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>Jackowski v. Borchelt: Legal Relationships and Implications</td>\n",
       "      <td>The community surrounding the Jackowski v. Borchelt case involves key entities such as Frederick Streib, Kenneth Davis, and the Heart of Seattle Hotel Co., Inc., all of which are interconnected through legal disputes regarding breach of contract and tort claims. The relationships among these parties highlight the complexities of landlord liability and the economic loss rule, which are central to the case's legal principles.</td>\n",
       "      <td># Jackowski v. Borchelt: Legal Relationships and Implications\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as Frederick Streib, Kenneth Davis, and the Heart of Seattle Hotel Co., Inc., all of which are interconnected through legal disputes regarding breach of contract and tort claims. The relationships among these parties highlight the complexities of landlord liability and the economic loss rule, which are central to the case's legal principles.\\n\\n...</td>\n",
       "      <td>9.0</td>\n",
       "      <td>The case is highly significant for understanding breach of contract claims and landlord liability, with implications for future legal interpretations.</td>\n",
       "      <td>[{'explanation': 'The primary parties in the Jackowski v. Borchelt case include Frederick Streib and Kenneth Davis, both of whom were stockholders and promoters of the Heart of Seattle Hotel Co., Inc. Their roles as co-promoters are crucial as they executed a promissory note together, which is central to the legal dispute. The relationship between these individuals and the corporation they formed is indicative of the complexities involved in corporate governance and liability. The case illus...</td>\n",
       "      <td>{\\n    \"title\": \"Jackowski v. Borchelt: Legal Relationships and Implications\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as Frederick Streib, Kenneth Davis, and the Heart of Seattle Hotel Co., Inc., all of which are interconnected through legal disputes regarding breach of contract and tort claims. The relationships among these parties highlight the complexities of landlord liability and the economic loss rule, which are central to t...</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2029 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        id  human_readable_id  community  \\\n",
       "0     8a5a55b0-9345-4d98-97b2-87d982c4e118               1992       1992   \n",
       "1     8a4581ba-7ad5-476e-a983-d9ed481cae7d               1993       1993   \n",
       "2     b271cea4-0e5d-4bbf-b50f-d6344176b3b3               1995       1995   \n",
       "3     a1b219e6-db4a-419c-94ac-d03761dc3884               1996       1996   \n",
       "4     f6d09c20-446a-477e-b7f3-8c754d0b14ef               1997       1997   \n",
       "...                                    ...                ...        ...   \n",
       "2024  571f09b9-8948-4496-b29c-7b4d266fa980                 43         43   \n",
       "2025  9f2373c7-2892-472d-b042-5fb453800819                 44         44   \n",
       "2026  d439707e-5855-4991-af43-c19fbf87af42                 48         48   \n",
       "2027  40ff7897-011c-4420-a1f3-d2ee1df81a59                 50         50   \n",
       "2028  19b4c0d2-838c-4a2d-9f7f-7fdb99bae6bf                 -1         -1   \n",
       "\n",
       "      level  \\\n",
       "0         4   \n",
       "1         4   \n",
       "2         4   \n",
       "3         4   \n",
       "4         4   \n",
       "...     ...   \n",
       "2024      0   \n",
       "2025      0   \n",
       "2026      0   \n",
       "2027      0   \n",
       "2028      0   \n",
       "\n",
       "                                                                    title  \\\n",
       "0                 Jackowski v. Borchelt: Legal Framework and Implications   \n",
       "1        Jackowski v. Borchelt: Breach of Contract and Landlord Liability   \n",
       "2     Jackowski v. Borchelt: Breach of Contract and Tort Law Implications   \n",
       "3                         Jackowski v. Borchelt: Legal Community Analysis   \n",
       "4                         Judicial Relationships in Jackowski v. Borchelt   \n",
       "...                                                                   ...   \n",
       "2024          Jackowski v. Borchelt: Legal Relationships and Implications   \n",
       "2025     Jackowski v. Borchelt: Breach of Contract and Liability Dynamics   \n",
       "2026        Jackowski v. Borchelt: Landlord-Tenant Dynamics and Liability   \n",
       "2027          Jackowski v. Borchelt: Legal Relationships and Implications   \n",
       "2028          Jackowski v. Borchelt: Legal Relationships and Implications   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                            summary  \\\n",
       "0                                                              The community surrounding the Jackowski v. Borchelt case involves key entities such as the trial court, the plaintiff, and legal instructions that shape the understanding of negligence and breach of contract claims. The relationships among these entities highlight the complexities of landlord liability and the presumption of negligence, which are central to the case's legal principles.   \n",
       "1                                          The community surrounding the Jackowski v. Borchelt case involves key entities such as the trial court, the concept of margin of safety, and the tubing involved in the case. The relationships among these entities highlight the legal principles of breach of contract claims, reasonable reliance in tort law, and landlord liability, which are critical for understanding the implications of the court's rulings.   \n",
       "2          The community surrounding the Jackowski v. Borchelt case involves key entities such as the plaintiffs, defendants, and the court system, all of which play significant roles in the legal analysis of breach of contract claims and tort law principles. The relationships among these entities highlight the complexities of landlord liability and the economic loss rule, which are central to understanding the implications of the court's rulings.   \n",
       "3                                    The community surrounding the Jackowski v. Borchelt case involves key entities such as the Superior Court, the Homebuilders Association, and various legal principles including breach of contract and reasonable reliance. The relationships among these entities highlight the complexities of landlord liability and the economic loss rule, which are central to the case's implications for future legal interpretations.   \n",
       "4                                                                                                                The community surrounding the Jackowski v. Borchelt case involves key judicial figures, specifically Justices Green and Roe, who played significant roles in the case's adjudication. Their relationships highlight the collaborative nature of judicial decision-making and the implications of their rulings on breach of contract and tort law.   \n",
       "...                                                                                                                                                                                                                                                                                                                                                                                                                                                             ...   \n",
       "2024                                      The community surrounding the Jackowski v. Borchelt case involves key entities such as Ronald L. Ewer, Goodyear Tire and Rubber Company, and the concept of injury, which is central to the legal claims made. The relationships between the plaintiff, the defendant, and the nature of the injuries sustained highlight significant legal principles, including breach of contract, negligence, and landlord liability.   \n",
       "2025  The community surrounding the Jackowski v. Borchelt case involves key entities such as the parties to the dispute, the sheriff's sale process, and legal principles like breach of contract and reasonable reliance. The relationships among these entities highlight the complexities of enforcing legal obligations and the implications of judicial interpretations on future cases, particularly regarding landlord liability and the economic loss rule.   \n",
       "2026       The community surrounding the Jackowski v. Borchelt case involves landlords, tenants, and the trial court, all of which play significant roles in assessing damages related to property and contractual obligations. The relationships among these entities highlight the complexities of breach of contract claims, reasonable reliance in tort law, and the implications of judicial interpretations on landlord liability and the economic loss rule.   \n",
       "2027                                      The community surrounding the Jackowski v. Borchelt case involves key entities such as the plaintiffs (Jackowski), defendants (Borchelt), legal practitioners, and regulatory bodies. The relationships among these entities highlight the complexities of breach of contract claims, reasonable reliance in tort law, and the implications of judicial interpretations on landlord liability and the economic loss rule.   \n",
       "2028                    The community surrounding the Jackowski v. Borchelt case involves key entities such as Frederick Streib, Kenneth Davis, and the Heart of Seattle Hotel Co., Inc., all of which are interconnected through legal disputes regarding breach of contract and tort claims. The relationships among these parties highlight the complexities of landlord liability and the economic loss rule, which are central to the case's legal principles.   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             full_content  \\\n",
       "0     # Jackowski v. Borchelt: Legal Framework and Implications\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as the trial court, the plaintiff, and legal instructions that shape the understanding of negligence and breach of contract claims. The relationships among these entities highlight the complexities of landlord liability and the presumption of negligence, which are central to the case's legal principles.\\n\\n## Instruction No. 9 as a pivotal legal dir...   \n",
       "1     # Jackowski v. Borchelt: Breach of Contract and Landlord Liability\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as the trial court, the concept of margin of safety, and the tubing involved in the case. The relationships among these entities highlight the legal principles of breach of contract claims, reasonable reliance in tort law, and landlord liability, which are critical for understanding the implications of the court's rulings.\\n\\n## Importance ...   \n",
       "2     # Jackowski v. Borchelt: Breach of Contract and Tort Law Implications\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as the plaintiffs, defendants, and the court system, all of which play significant roles in the legal analysis of breach of contract claims and tort law principles. The relationships among these entities highlight the complexities of landlord liability and the economic loss rule, which are central to understanding the implications of the...   \n",
       "3     # Jackowski v. Borchelt: Legal Community Analysis\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as the Superior Court, the Homebuilders Association, and various legal principles including breach of contract and reasonable reliance. The relationships among these entities highlight the complexities of landlord liability and the economic loss rule, which are central to the case's implications for future legal interpretations.\\n\\n## Role of the Superior C...   \n",
       "4     # Judicial Relationships in Jackowski v. Borchelt\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key judicial figures, specifically Justices Green and Roe, who played significant roles in the case's adjudication. Their relationships highlight the collaborative nature of judicial decision-making and the implications of their rulings on breach of contract and tort law.\\n\\n## Justice Green's dual role\\n\\nJustice Green is a pivotal figure in this community, serving both as ...   \n",
       "...                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   ...   \n",
       "2024  # Jackowski v. Borchelt: Legal Relationships and Implications\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as Ronald L. Ewer, Goodyear Tire and Rubber Company, and the concept of injury, which is central to the legal claims made. The relationships between the plaintiff, the defendant, and the nature of the injuries sustained highlight significant legal principles, including breach of contract, negligence, and landlord liability.\\n\\n## Centrality of I...   \n",
       "2025  # Jackowski v. Borchelt: Breach of Contract and Liability Dynamics\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as the parties to the dispute, the sheriff's sale process, and legal principles like breach of contract and reasonable reliance. The relationships among these entities highlight the complexities of enforcing legal obligations and the implications of judicial interpretations on future cases, particularly regarding landlord liability and the ...   \n",
       "2026  # Jackowski v. Borchelt: Landlord-Tenant Dynamics and Liability\\n\\nThe community surrounding the Jackowski v. Borchelt case involves landlords, tenants, and the trial court, all of which play significant roles in assessing damages related to property and contractual obligations. The relationships among these entities highlight the complexities of breach of contract claims, reasonable reliance in tort law, and the implications of judicial interpretations on landlord liability and the economic...   \n",
       "2027  # Jackowski v. Borchelt: Legal Relationships and Implications\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as the plaintiffs (Jackowski), defendants (Borchelt), legal practitioners, and regulatory bodies. The relationships among these entities highlight the complexities of breach of contract claims, reasonable reliance in tort law, and the implications of judicial interpretations on landlord liability and the economic loss rule.\\n\\n## Parties Involve...   \n",
       "2028  # Jackowski v. Borchelt: Legal Relationships and Implications\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as Frederick Streib, Kenneth Davis, and the Heart of Seattle Hotel Co., Inc., all of which are interconnected through legal disputes regarding breach of contract and tort claims. The relationships among these parties highlight the complexities of landlord liability and the economic loss rule, which are central to the case's legal principles.\\n\\n...   \n",
       "\n",
       "      rank  \\\n",
       "0      9.0   \n",
       "1      9.0   \n",
       "2      9.0   \n",
       "3      9.5   \n",
       "4      8.5   \n",
       "...    ...   \n",
       "2024   9.0   \n",
       "2025   9.0   \n",
       "2026   9.5   \n",
       "2027   9.5   \n",
       "2028   9.0   \n",
       "\n",
       "                                                                                                                                                             rank_explanation  \\\n",
       "0                             The case is highly significant for understanding breach of contract claims and landlord liability, making it essential for legal practitioners.   \n",
       "1              The case is highly significant as it addresses essential legal principles that impact future breach of contract claims and landlord liability interpretations.   \n",
       "2           The case is highly significant for its implications on breach of contract claims and tort law, particularly regarding reasonable reliance and landlord liability.   \n",
       "3                         The case is highly significant for understanding breach of contract claims and landlord liability, with potential implications for future case law.   \n",
       "4     The rating reflects the case's substantial relevance to legal principles, particularly in breach of contract claims and judicial interpretations of landlord liability.   \n",
       "...                                                                                                                                                                       ...   \n",
       "2024                                            The case is highly significant as it addresses critical legal principles that will influence future tort and contract claims.   \n",
       "2025          The case is highly significant as it addresses critical legal principles that will influence future interpretations of breach of contract and liability issues.   \n",
       "2026                                  The case is highly significant for understanding breach of contract claims, landlord liability, and the economic loss rule in tort law.   \n",
       "2027                   The case is highly significant for understanding breach of contract claims and landlord liability, with implications for future legal interpretations.   \n",
       "2028                   The case is highly significant for understanding breach of contract claims and landlord liability, with implications for future legal interpretations.   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 findings  \\\n",
       "0     [{'explanation': 'Instruction No. 9 is a comprehensive directive issued by the trial court that outlines the essential elements the plaintiff must establish to succeed in their claims. This instruction serves multiple purposes, including addressing the defense of independent intervening acts, which allows the jury to consider various defenses during deliberations. By providing specific legal standards related to negligence, Instruction No. 9 ensures that the jury is well-informed about the r...   \n",
       "1     [{'explanation': 'The concept of 'Margin of Safety' is pivotal in the Jackowski v. Borchelt case, as it pertains to the critical length of tubing necessary to ensure secure connections to a faucet. The trial court emphasized this concept in its findings, indicating that maintaining a sufficient margin of safety is essential to avoid hazards associated with tubing disconnection. This principle not only affects the specific case at hand but also sets a precedent for future cases involving simi...   \n",
       "2     [{'explanation': 'In the Jackowski v. Borchelt case, the primary parties involved are the plaintiffs, Jackowski, and the defendants, Borchelt. Jackowski alleges that Borchelt breached a contract related to a rental agreement, which is a common issue in landlord-tenant disputes. The relationship between these parties is foundational to the case, as it sets the stage for the legal arguments surrounding breach of contract and the expectations of both parties under the agreement. The court's int...   \n",
       "3     [{'explanation': 'The Superior Court serves as the primary judicial body adjudicating the Jackowski v. Borchelt case, with general jurisdiction over civil matters including contract disputes. Its rulings not only impact the parties involved but also set precedents that influence future cases. The court's authority to review and reverse decisions made by lower courts underscores its critical role in the legal landscape, particularly in matters of landlord liability and breach of contract clai...   \n",
       "4     [{'explanation': 'Justice Green is a pivotal figure in this community, serving both as a Justice who concurred with the judgment in the Jackowski v. Borchelt case and as an appellant in a separate legal matter against the City of Seattle. Her involvement in multiple legal contexts underscores the interconnectedness of judicial roles and the potential for her decisions to influence broader legal interpretations. The case illustrates how a Justice's rulings can have far-reaching implications, ...   \n",
       "...                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   ...   \n",
       "2024  [{'explanation': 'In the context of the Jackowski v. Borchelt case, the concept of injury is pivotal. Injury encompasses a wide range of physical, emotional, and financial harm that can arise from various circumstances, including negligence. In this case, Ronald L. Ewer claims to have sustained injuries due to the explosion of a tractor tire manufactured by Goodyear Tire and Rubber Company. This claim illustrates how injuries serve as the foundation for legal actions in tort law, necessitati...   \n",
       "2025  [{'explanation': 'The Jackowski v. Borchelt case centers on a breach of contract claim, where the plaintiff, Jackowski, alleges that Borchelt failed to fulfill contractual obligations. This case illustrates the importance of clearly defined terms in contracts and the legal consequences of failing to adhere to them. The court's ruling will likely set a precedent for how similar cases are interpreted in the future, emphasizing the need for parties to understand their contractual duties and the...   \n",
       "2026  [{'explanation': 'The trial court plays a pivotal role in assessing and awarding damages in disputes, particularly in landlord-tenant relationships. In the Jackowski v. Borchelt case, the court evaluated claims of damage based on evidence from both parties, including the condition of the premises and obligations outlined in the lease agreement. The court's judgment reflects its responsibility to ensure fair compensation for damages incurred, which is essential in resolving disputes and maint...   \n",
       "2027  [{'explanation': 'In the Jackowski v. Borchelt case, the primary parties involved are the plaintiffs, Jackowski, and the defendants, Borchelt. The plaintiffs allege that the defendants breached a contract related to a rental agreement, which is central to the case. The relationship between these parties is crucial as it establishes the basis for the legal claims made. The plaintiffs argue that they relied on the defendants' representations regarding the rental property, which they claim were...   \n",
       "2028  [{'explanation': 'The primary parties in the Jackowski v. Borchelt case include Frederick Streib and Kenneth Davis, both of whom were stockholders and promoters of the Heart of Seattle Hotel Co., Inc. Their roles as co-promoters are crucial as they executed a promissory note together, which is central to the legal dispute. The relationship between these individuals and the corporation they formed is indicative of the complexities involved in corporate governance and liability. The case illus...   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        full_content_json  \\\n",
       "0     {\\n    \"title\": \"Jackowski v. Borchelt: Legal Framework and Implications\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as the trial court, the plaintiff, and legal instructions that shape the understanding of negligence and breach of contract claims. The relationships among these entities highlight the complexities of landlord liability and the presumption of negligence, which are central to the case's legal principles.\",\\n    \"rating\"...   \n",
       "1     {\\n    \"title\": \"Jackowski v. Borchelt: Breach of Contract and Landlord Liability\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as the trial court, the concept of margin of safety, and the tubing involved in the case. The relationships among these entities highlight the legal principles of breach of contract claims, reasonable reliance in tort law, and landlord liability, which are critical for understanding the implications of the cou...   \n",
       "2     {\\n    \"title\": \"Jackowski v. Borchelt: Breach of Contract and Tort Law Implications\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as the plaintiffs, defendants, and the court system, all of which play significant roles in the legal analysis of breach of contract claims and tort law principles. The relationships among these entities highlight the complexities of landlord liability and the economic loss rule, which are central to unders...   \n",
       "3     {\\n    \"title\": \"Jackowski v. Borchelt: Legal Community Analysis\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as the Superior Court, the Homebuilders Association, and various legal principles including breach of contract and reasonable reliance. The relationships among these entities highlight the complexities of landlord liability and the economic loss rule, which are central to the case's implications for future legal interpretation...   \n",
       "4     {\\n    \"title\": \"Judicial Relationships in Jackowski v. Borchelt\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key judicial figures, specifically Justices Green and Roe, who played significant roles in the case's adjudication. Their relationships highlight the collaborative nature of judicial decision-making and the implications of their rulings on breach of contract and tort law.\",\\n    \"rating\": 8.5,\\n    \"rating_explanation\": \"The rating reflects the...   \n",
       "...                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   ...   \n",
       "2024  {\\n    \"title\": \"Jackowski v. Borchelt: Legal Relationships and Implications\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as Ronald L. Ewer, Goodyear Tire and Rubber Company, and the concept of injury, which is central to the legal claims made. The relationships between the plaintiff, the defendant, and the nature of the injuries sustained highlight significant legal principles, including breach of contract, negligence, and landlord l...   \n",
       "2025  {\\n    \"title\": \"Jackowski v. Borchelt: Breach of Contract and Liability Dynamics\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as the parties to the dispute, the sheriff's sale process, and legal principles like breach of contract and reasonable reliance. The relationships among these entities highlight the complexities of enforcing legal obligations and the implications of judicial interpretations on future cases, particularly regard...   \n",
       "2026  {\\n    \"title\": \"Jackowski v. Borchelt: Landlord-Tenant Dynamics and Liability\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves landlords, tenants, and the trial court, all of which play significant roles in assessing damages related to property and contractual obligations. The relationships among these entities highlight the complexities of breach of contract claims, reasonable reliance in tort law, and the implications of judicial interpretations on land...   \n",
       "2027  {\\n    \"title\": \"Jackowski v. Borchelt: Legal Relationships and Implications\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as the plaintiffs (Jackowski), defendants (Borchelt), legal practitioners, and regulatory bodies. The relationships among these entities highlight the complexities of breach of contract claims, reasonable reliance in tort law, and the implications of judicial interpretations on landlord liability and the economic l...   \n",
       "2028  {\\n    \"title\": \"Jackowski v. Borchelt: Legal Relationships and Implications\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as Frederick Streib, Kenneth Davis, and the Heart of Seattle Hotel Co., Inc., all of which are interconnected through legal disputes regarding breach of contract and tort claims. The relationships among these parties highlight the complexities of landlord liability and the economic loss rule, which are central to t...   \n",
       "\n",
       "          period   size  \n",
       "0     2024-12-17    2.0  \n",
       "1     2024-12-17    2.0  \n",
       "2     2024-12-17    2.0  \n",
       "3     2024-12-17   19.0  \n",
       "4     2024-12-17    2.0  \n",
       "...          ...    ...  \n",
       "2024  2024-12-17  222.0  \n",
       "2025  2024-12-17  150.0  \n",
       "2026  2024-12-17  821.0  \n",
       "2027  2024-12-17   88.0  \n",
       "2028        None    NaN  \n",
       "\n",
       "[2029 rows x 13 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "# Use the absolute path to the parquet file in the output directory\n",
    "df = pd.read_parquet('/workspace/graphrag/output/create_final_community_reports.parquet')\n",
    "# Adjust the display option to show the entire content of the 'summary' column\n",
    "pd.set_option('display.max_colwidth', 500)\n",
    "\n",
    "# # Display the DataFrame\n",
    "# print(df['summary'])\n",
    "df\n",
    "\n",
    "#df.to_csv('/workspace/data/final_community_reports.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>human_readable_id</th>\n",
       "      <th>community</th>\n",
       "      <th>level</th>\n",
       "      <th>title</th>\n",
       "      <th>summary</th>\n",
       "      <th>full_content</th>\n",
       "      <th>rank</th>\n",
       "      <th>rank_explanation</th>\n",
       "      <th>findings</th>\n",
       "      <th>full_content_json</th>\n",
       "      <th>period</th>\n",
       "      <th>size</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>408</th>\n",
       "      <td>5dd3f290-47af-4268-a4f1-b3095c4e0427</td>\n",
       "      <td>524</td>\n",
       "      <td>524</td>\n",
       "      <td>2</td>\n",
       "      <td>Clean Water Act and Wetlands Regulation Community</td>\n",
       "      <td>This community encompasses key entities involved in the regulation of wetlands and water quality under the Clean Water Act, including the Army Corps of Engineers, state authorities, and legislative figures like Senator Wallop. The relationships among these entities highlight the complexities of water rights, environmental protection, and regulatory compliance.</td>\n",
       "      <td># Clean Water Act and Wetlands Regulation Community\\n\\nThis community encompasses key entities involved in the regulation of wetlands and water quality under the Clean Water Act, including the Army Corps of Engineers, state authorities, and legislative figures like Senator Wallop. The relationships among these entities highlight the complexities of water rights, environmental protection, and regulatory compliance.\\n\\n## The significance of Wetlands in environmental law\\n\\nWetlands are crucial ecological...</td>\n",
       "      <td>9.5</td>\n",
       "      <td>The high rating reflects the critical importance of the Clean Water Act and its implications for environmental law, water rights, and regulatory frameworks.</td>\n",
       "      <td>[{'explanation': 'Wetlands are crucial ecological areas defined by the presence of water, which are subject to specific regulatory requirements under environmental laws. The Army Corps of Engineers designates these areas, and their protection is vital for maintaining biodiversity and water quality. The regulatory framework surrounding wetlands is influenced by various legislative acts, including the Clean Water Act, which imposes restrictions on development activities that could harm these ecosystems. T...</td>\n",
       "      <td>{\\n    \"title\": \"Clean Water Act and Wetlands Regulation Community\",\\n    \"summary\": \"This community encompasses key entities involved in the regulation of wetlands and water quality under the Clean Water Act, including the Army Corps of Engineers, state authorities, and legislative figures like Senator Wallop. The relationships among these entities highlight the complexities of water rights, environmental protection, and regulatory compliance.\",\\n    \"rating\": 9.5,\\n    \"rating_explanation\": \"The high ...</td>\n",
       "      <td>2024-12-17</td>\n",
       "      <td>17.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>559</th>\n",
       "      <td>37149b03-e759-4c47-930e-4c78bd2d8083</td>\n",
       "      <td>685</td>\n",
       "      <td>685</td>\n",
       "      <td>2</td>\n",
       "      <td>Jackowski v. Borchelt: Leakage and Liability</td>\n",
       "      <td>The community surrounding the Jackowski v. Borchelt case involves key entities such as Leakage and the Dancing Hall, which are central to the legal dispute regarding water damage. The relationships between these entities highlight the complexities of breach of contract claims and landlord liability, particularly in the context of the building's structural issues.</td>\n",
       "      <td># Jackowski v. Borchelt: Leakage and Liability\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as Leakage and the Dancing Hall, which are central to the legal dispute regarding water damage. The relationships between these entities highlight the complexities of breach of contract claims and landlord liability, particularly in the context of the building's structural issues.\\n\\n## Leakage as a central issue\\n\\nLeakage is a pivotal element in the Jackowski v. Borchel...</td>\n",
       "      <td>8.5</td>\n",
       "      <td>The case is highly significant as it addresses critical issues of landlord liability and breach of contract, impacting future legal interpretations.</td>\n",
       "      <td>[{'explanation': 'Leakage is a pivotal element in the Jackowski v. Borchelt case, representing the water escaping from the roof of the building. This issue is not only a physical problem but also a legal one, as it directly affects the claims made by the plaintiffs regarding damages. The plaintiffs argue that the leakage constitutes a breach of the landlord's duty to maintain the property, which is a fundamental aspect of landlord-tenant law. The court's interpretation of this issue could set a preceden...</td>\n",
       "      <td>{\\n    \"title\": \"Jackowski v. Borchelt: Leakage and Liability\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as Leakage and the Dancing Hall, which are central to the legal dispute regarding water damage. The relationships between these entities highlight the complexities of breach of contract claims and landlord liability, particularly in the context of the building's structural issues.\",\\n    \"rating\": 8.5,\\n    \"rating_explanation\": \"The case is...</td>\n",
       "      <td>2024-12-17</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>604</th>\n",
       "      <td>6f959435-b3a9-4e46-817e-d1e9dbc40dd7</td>\n",
       "      <td>731</td>\n",
       "      <td>731</td>\n",
       "      <td>2</td>\n",
       "      <td>Jackowski v. Borchelt: Landlord Liability and Breach of Contract</td>\n",
       "      <td>The community surrounding the Jackowski v. Borchelt case involves key entities such as the landlord (Borchelt) and the tenant (Jackowski), with significant relationships defined by the lease agreement and the implications of breach of contract claims. The case highlights the legal principles of reasonable reliance in tort law and landlord liability, shaping future interpretations of similar disputes.</td>\n",
       "      <td># Jackowski v. Borchelt: Landlord Liability and Breach of Contract\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as the landlord (Borchelt) and the tenant (Jackowski), with significant relationships defined by the lease agreement and the implications of breach of contract claims. The case highlights the legal principles of reasonable reliance in tort law and landlord liability, shaping future interpretations of similar disputes.\\n\\n## Key entities involved in the...</td>\n",
       "      <td>9.0</td>\n",
       "      <td>The case is highly significant for understanding breach of contract claims and landlord liability, with implications for future legal interpretations.</td>\n",
       "      <td>[{'explanation': 'The primary entities in the Jackowski v. Borchelt case are the landlord, Borchelt, and the tenant, Jackowski. Their relationship is governed by a lease agreement that outlines the rights and responsibilities of both parties. This relationship is crucial as it sets the stage for the legal disputes that arise, particularly regarding the obligations of the landlord to maintain the property and the tenant's reliance on those obligations. The case underscores the importance of clearly defin...</td>\n",
       "      <td>{\\n    \"title\": \"Jackowski v. Borchelt: Landlord Liability and Breach of Contract\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as the landlord (Borchelt) and the tenant (Jackowski), with significant relationships defined by the lease agreement and the implications of breach of contract claims. The case highlights the legal principles of reasonable reliance in tort law and landlord liability, shaping future interpretations of similar disputes.\",\\n...</td>\n",
       "      <td>2024-12-17</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>682</th>\n",
       "      <td>49e327ec-1cc4-4927-84f1-70d88ebf5427</td>\n",
       "      <td>810</td>\n",
       "      <td>810</td>\n",
       "      <td>2</td>\n",
       "      <td>Jackowski v. Borchelt: Waste Discharge and Environmental Liability</td>\n",
       "      <td>The community surrounding the Jackowski v. Borchelt case involves key entities such as the City of Spokane, the Spokane River, and various regulatory permits like the Waste Discharge Permit and NPDES Permit. These entities are interconnected through their roles in managing waste discharge and ensuring compliance with environmental regulations, which are central to the legal claims in this case.</td>\n",
       "      <td># Jackowski v. Borchelt: Waste Discharge and Environmental Liability\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as the City of Spokane, the Spokane River, and various regulatory permits like the Waste Discharge Permit and NPDES Permit. These entities are interconnected through their roles in managing waste discharge and ensuring compliance with environmental regulations, which are central to the legal claims in this case.\\n\\n## Role of the City of Spokane\\n\\nT...</td>\n",
       "      <td>9.0</td>\n",
       "      <td>The case is highly significant as it addresses breach of contract claims and environmental liability, impacting future regulatory compliance and judicial interpretations.</td>\n",
       "      <td>[{'explanation': 'The City of Spokane plays a pivotal role in the management of waste discharge permits, which are essential for regulating the disposal of pollutants into the Spokane River. As the entity responsible for issuing these permits, the City directly influences the environmental health of the river, which has been a focal point in the legal proceedings. The relationship between the City and the Waste Discharge Permit is crucial, as it underscores the City's regulatory authority and its obliga...</td>\n",
       "      <td>{\\n    \"title\": \"Jackowski v. Borchelt: Waste Discharge and Environmental Liability\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as the City of Spokane, the Spokane River, and various regulatory permits like the Waste Discharge Permit and NPDES Permit. These entities are interconnected through their roles in managing waste discharge and ensuring compliance with environmental regulations, which are central to the legal claims in this case.\",\\n    ...</td>\n",
       "      <td>2024-12-17</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1400</th>\n",
       "      <td>a739ec7c-e98d-4b14-92dc-d31d8f39cdd4</td>\n",
       "      <td>1543</td>\n",
       "      <td>1543</td>\n",
       "      <td>2</td>\n",
       "      <td>Jackowski v. Borchelt: Landlord Liability and Breach of Contract</td>\n",
       "      <td>The community surrounding the Jackowski v. Borchelt case involves multiple stakeholders, including the Jackowski family, the Borchelt family, real estate agents, and insurance companies. The relationships among these entities highlight the complexities of breach of contract claims, reasonable reliance in tort law, and the implications of judicial interpretations on landlord liability and the economic loss rule.</td>\n",
       "      <td># Jackowski v. Borchelt: Landlord Liability and Breach of Contract\\n\\nThe community surrounding the Jackowski v. Borchelt case involves multiple stakeholders, including the Jackowski family, the Borchelt family, real estate agents, and insurance companies. The relationships among these entities highlight the complexities of breach of contract claims, reasonable reliance in tort law, and the implications of judicial interpretations on landlord liability and the economic loss rule.\\n\\n## Breach of Contrac...</td>\n",
       "      <td>9.5</td>\n",
       "      <td>The case is highly significant for understanding legal principles related to breach of contract and liability issues, particularly in the context of real estate transactions and natural disasters.</td>\n",
       "      <td>[{'explanation': 'The Jackowski family is appealing a court's dismissal of their claims related to a real estate transaction, which raises important questions about breach of contract. The case underscores the necessity for clear contractual obligations and the potential consequences of failing to meet those obligations. In this instance, the Jackowskis allege that the Borchelts, through their real estate agents, failed to disclose critical information regarding the property, which ultimately led to sig...</td>\n",
       "      <td>{\\n    \"title\": \"Jackowski v. Borchelt: Landlord Liability and Breach of Contract\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves multiple stakeholders, including the Jackowski family, the Borchelt family, real estate agents, and insurance companies. The relationships among these entities highlight the complexities of breach of contract claims, reasonable reliance in tort law, and the implications of judicial interpretations on landlord liability and the economic los...</td>\n",
       "      <td>2024-12-17</td>\n",
       "      <td>18.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        id human_readable_id  community  \\\n",
       "408   5dd3f290-47af-4268-a4f1-b3095c4e0427               524        524   \n",
       "559   37149b03-e759-4c47-930e-4c78bd2d8083               685        685   \n",
       "604   6f959435-b3a9-4e46-817e-d1e9dbc40dd7               731        731   \n",
       "682   49e327ec-1cc4-4927-84f1-70d88ebf5427               810        810   \n",
       "1400  a739ec7c-e98d-4b14-92dc-d31d8f39cdd4              1543       1543   \n",
       "\n",
       "      level  \\\n",
       "408       2   \n",
       "559       2   \n",
       "604       2   \n",
       "682       2   \n",
       "1400      2   \n",
       "\n",
       "                                                                   title  \\\n",
       "408                    Clean Water Act and Wetlands Regulation Community   \n",
       "559                         Jackowski v. Borchelt: Leakage and Liability   \n",
       "604     Jackowski v. Borchelt: Landlord Liability and Breach of Contract   \n",
       "682   Jackowski v. Borchelt: Waste Discharge and Environmental Liability   \n",
       "1400    Jackowski v. Borchelt: Landlord Liability and Breach of Contract   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                             summary  \\\n",
       "408                                                       This community encompasses key entities involved in the regulation of wetlands and water quality under the Clean Water Act, including the Army Corps of Engineers, state authorities, and legislative figures like Senator Wallop. The relationships among these entities highlight the complexities of water rights, environmental protection, and regulatory compliance.   \n",
       "559                                                    The community surrounding the Jackowski v. Borchelt case involves key entities such as Leakage and the Dancing Hall, which are central to the legal dispute regarding water damage. The relationships between these entities highlight the complexities of breach of contract claims and landlord liability, particularly in the context of the building's structural issues.   \n",
       "604              The community surrounding the Jackowski v. Borchelt case involves key entities such as the landlord (Borchelt) and the tenant (Jackowski), with significant relationships defined by the lease agreement and the implications of breach of contract claims. The case highlights the legal principles of reasonable reliance in tort law and landlord liability, shaping future interpretations of similar disputes.   \n",
       "682                    The community surrounding the Jackowski v. Borchelt case involves key entities such as the City of Spokane, the Spokane River, and various regulatory permits like the Waste Discharge Permit and NPDES Permit. These entities are interconnected through their roles in managing waste discharge and ensuring compliance with environmental regulations, which are central to the legal claims in this case.   \n",
       "1400  The community surrounding the Jackowski v. Borchelt case involves multiple stakeholders, including the Jackowski family, the Borchelt family, real estate agents, and insurance companies. The relationships among these entities highlight the complexities of breach of contract claims, reasonable reliance in tort law, and the implications of judicial interpretations on landlord liability and the economic loss rule.   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         full_content  \\\n",
       "408   # Clean Water Act and Wetlands Regulation Community\\n\\nThis community encompasses key entities involved in the regulation of wetlands and water quality under the Clean Water Act, including the Army Corps of Engineers, state authorities, and legislative figures like Senator Wallop. The relationships among these entities highlight the complexities of water rights, environmental protection, and regulatory compliance.\\n\\n## The significance of Wetlands in environmental law\\n\\nWetlands are crucial ecological...   \n",
       "559   # Jackowski v. Borchelt: Leakage and Liability\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as Leakage and the Dancing Hall, which are central to the legal dispute regarding water damage. The relationships between these entities highlight the complexities of breach of contract claims and landlord liability, particularly in the context of the building's structural issues.\\n\\n## Leakage as a central issue\\n\\nLeakage is a pivotal element in the Jackowski v. Borchel...   \n",
       "604   # Jackowski v. Borchelt: Landlord Liability and Breach of Contract\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as the landlord (Borchelt) and the tenant (Jackowski), with significant relationships defined by the lease agreement and the implications of breach of contract claims. The case highlights the legal principles of reasonable reliance in tort law and landlord liability, shaping future interpretations of similar disputes.\\n\\n## Key entities involved in the...   \n",
       "682   # Jackowski v. Borchelt: Waste Discharge and Environmental Liability\\n\\nThe community surrounding the Jackowski v. Borchelt case involves key entities such as the City of Spokane, the Spokane River, and various regulatory permits like the Waste Discharge Permit and NPDES Permit. These entities are interconnected through their roles in managing waste discharge and ensuring compliance with environmental regulations, which are central to the legal claims in this case.\\n\\n## Role of the City of Spokane\\n\\nT...   \n",
       "1400  # Jackowski v. Borchelt: Landlord Liability and Breach of Contract\\n\\nThe community surrounding the Jackowski v. Borchelt case involves multiple stakeholders, including the Jackowski family, the Borchelt family, real estate agents, and insurance companies. The relationships among these entities highlight the complexities of breach of contract claims, reasonable reliance in tort law, and the implications of judicial interpretations on landlord liability and the economic loss rule.\\n\\n## Breach of Contrac...   \n",
       "\n",
       "      rank  \\\n",
       "408    9.5   \n",
       "559    8.5   \n",
       "604    9.0   \n",
       "682    9.0   \n",
       "1400   9.5   \n",
       "\n",
       "                                                                                                                                                                                          rank_explanation  \\\n",
       "408                                           The high rating reflects the critical importance of the Clean Water Act and its implications for environmental law, water rights, and regulatory frameworks.   \n",
       "559                                                   The case is highly significant as it addresses critical issues of landlord liability and breach of contract, impacting future legal interpretations.   \n",
       "604                                                 The case is highly significant for understanding breach of contract claims and landlord liability, with implications for future legal interpretations.   \n",
       "682                             The case is highly significant as it addresses breach of contract claims and environmental liability, impacting future regulatory compliance and judicial interpretations.   \n",
       "1400  The case is highly significant for understanding legal principles related to breach of contract and liability issues, particularly in the context of real estate transactions and natural disasters.   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             findings  \\\n",
       "408   [{'explanation': 'Wetlands are crucial ecological areas defined by the presence of water, which are subject to specific regulatory requirements under environmental laws. The Army Corps of Engineers designates these areas, and their protection is vital for maintaining biodiversity and water quality. The regulatory framework surrounding wetlands is influenced by various legislative acts, including the Clean Water Act, which imposes restrictions on development activities that could harm these ecosystems. T...   \n",
       "559   [{'explanation': 'Leakage is a pivotal element in the Jackowski v. Borchelt case, representing the water escaping from the roof of the building. This issue is not only a physical problem but also a legal one, as it directly affects the claims made by the plaintiffs regarding damages. The plaintiffs argue that the leakage constitutes a breach of the landlord's duty to maintain the property, which is a fundamental aspect of landlord-tenant law. The court's interpretation of this issue could set a preceden...   \n",
       "604   [{'explanation': 'The primary entities in the Jackowski v. Borchelt case are the landlord, Borchelt, and the tenant, Jackowski. Their relationship is governed by a lease agreement that outlines the rights and responsibilities of both parties. This relationship is crucial as it sets the stage for the legal disputes that arise, particularly regarding the obligations of the landlord to maintain the property and the tenant's reliance on those obligations. The case underscores the importance of clearly defin...   \n",
       "682   [{'explanation': 'The City of Spokane plays a pivotal role in the management of waste discharge permits, which are essential for regulating the disposal of pollutants into the Spokane River. As the entity responsible for issuing these permits, the City directly influences the environmental health of the river, which has been a focal point in the legal proceedings. The relationship between the City and the Waste Discharge Permit is crucial, as it underscores the City's regulatory authority and its obliga...   \n",
       "1400  [{'explanation': 'The Jackowski family is appealing a court's dismissal of their claims related to a real estate transaction, which raises important questions about breach of contract. The case underscores the necessity for clear contractual obligations and the potential consequences of failing to meet those obligations. In this instance, the Jackowskis allege that the Borchelts, through their real estate agents, failed to disclose critical information regarding the property, which ultimately led to sig...   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    full_content_json  \\\n",
       "408   {\\n    \"title\": \"Clean Water Act and Wetlands Regulation Community\",\\n    \"summary\": \"This community encompasses key entities involved in the regulation of wetlands and water quality under the Clean Water Act, including the Army Corps of Engineers, state authorities, and legislative figures like Senator Wallop. The relationships among these entities highlight the complexities of water rights, environmental protection, and regulatory compliance.\",\\n    \"rating\": 9.5,\\n    \"rating_explanation\": \"The high ...   \n",
       "559   {\\n    \"title\": \"Jackowski v. Borchelt: Leakage and Liability\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as Leakage and the Dancing Hall, which are central to the legal dispute regarding water damage. The relationships between these entities highlight the complexities of breach of contract claims and landlord liability, particularly in the context of the building's structural issues.\",\\n    \"rating\": 8.5,\\n    \"rating_explanation\": \"The case is...   \n",
       "604   {\\n    \"title\": \"Jackowski v. Borchelt: Landlord Liability and Breach of Contract\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as the landlord (Borchelt) and the tenant (Jackowski), with significant relationships defined by the lease agreement and the implications of breach of contract claims. The case highlights the legal principles of reasonable reliance in tort law and landlord liability, shaping future interpretations of similar disputes.\",\\n...   \n",
       "682   {\\n    \"title\": \"Jackowski v. Borchelt: Waste Discharge and Environmental Liability\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves key entities such as the City of Spokane, the Spokane River, and various regulatory permits like the Waste Discharge Permit and NPDES Permit. These entities are interconnected through their roles in managing waste discharge and ensuring compliance with environmental regulations, which are central to the legal claims in this case.\",\\n    ...   \n",
       "1400  {\\n    \"title\": \"Jackowski v. Borchelt: Landlord Liability and Breach of Contract\",\\n    \"summary\": \"The community surrounding the Jackowski v. Borchelt case involves multiple stakeholders, including the Jackowski family, the Borchelt family, real estate agents, and insurance companies. The relationships among these entities highlight the complexities of breach of contract claims, reasonable reliance in tort law, and the implications of judicial interpretations on landlord liability and the economic los...   \n",
       "\n",
       "          period  size  \n",
       "408   2024-12-17  17.0  \n",
       "559   2024-12-17   2.0  \n",
       "604   2024-12-17   2.0  \n",
       "682   2024-12-17  10.0  \n",
       "1400  2024-12-17  18.0  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "# Load the parquet file\n",
    "df = pd.read_parquet('/workspace/graphrag/output/create_final_community_reports.parquet')\n",
    "\n",
    "# Adjust display options to see the entire content of columns\n",
    "pd.set_option('display.max_colwidth', 512)  # Display the entire content of cells\n",
    "\n",
    "df['human_readable_id'] = df['human_readable_id'].astype(str)\n",
    "# Filter rows where 'human_readable_id' contains a specific substring (example: 'keyword')\n",
    "# filtered_df = df[df['human_readable_id'].str.contains('1176', na=False)]\n",
    "\n",
    "ids_to_filter = ['685', '731', '810', '524', '1543']\n",
    "\n",
    "filtered_df = df[df['human_readable_id'].isin(ids_to_filter)]\n",
    "\n",
    "# Display the filtered DataFrame\n",
    "filtered_df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>human_readable_id</th>\n",
       "      <th>community</th>\n",
       "      <th>level</th>\n",
       "      <th>title</th>\n",
       "      <th>entity_ids</th>\n",
       "      <th>relationship_ids</th>\n",
       "      <th>text_unit_ids</th>\n",
       "      <th>period</th>\n",
       "      <th>size</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>699</th>\n",
       "      <td>e46d64d4-a2d0-4a8e-9ae4-07007a8aee02</td>\n",
       "      <td>524</td>\n",
       "      <td>524</td>\n",
       "      <td>2</td>\n",
       "      <td>Community 524</td>\n",
       "      <td>[8d81e4c881f947d5841ecca5bb70e804, 0f2e8a4b0c634aea83c7d2649348abbc, a4e7ce7523a34ccf814e3725500e7c12, 33b56fda82f14b3495cddadb21fdd0e1, f8050adcbe2249f3987b4a70be16984b, 61a8482ef8cd4cb884e44c1ebecc44e0, 86e0d706a5fe412a92ef2ffb8d48a598, ddcce488efae4ebb8382049922585cd9, 2d44683e95944afd847e9895ec8541b3, 58c316b40fbd499aa9a4e2a62a64df62, c2f276b017044ad98175651defb7b53f, 3e90edbf44994ff0b832e71c24e88fc6, e432f2e1eb4046f686c9eee684484c71, 0cc1b2b2d0bf415190426480b44e1be6, 446c0d23c400404b929c85e031b0895...</td>\n",
       "      <td>[49e5664da73341019015169f67217992, b005434809cc44719359b9c15943f914, 907e1aa736f2412baef5aaf00ec1994b, 86612a6767d24f408327325308b2a287, 004342fdf77d40818ec9b82bea12a45e, 1cee783db9f54027a3b03f0bb135780a, 00e2cbd6b468404a9623841c9cd4b56f, 9f96f176aae745a38324460b16989c64, db234c8e96584cfc9cb0848a57df0a67, 9411ff69de4645c0b9b8bfed5d7592e0, 6b1cd278d03b41ee905069137eeb8b5d, fd2b7c3bee36472bba7af9f067985453, 8c3d4edefddc4eeab7e21511c9811f74, 978b06ee16a34bc3981189e274023c1e, 4573312951444f7bbd9e2c16c47f68b...</td>\n",
       "      <td>[0371900a624648f1596be0b34e250f46,cbab760f12d0c219151149f946b96663, 0371900a624648f1596be0b34e250f46,27a0933dc7e66aaf06f185f674739090,395a8bbd6e781764bcfb8f3f43abbce4,4d4b330ebbfd95a52f1404a792c7d9d6,5cb9387d33ef0586c52e9715c5d7c6d8,6ceb2b973680d705479e69aebcf50925,8a990be2de128cfc6068090fae6cb40d,9e227e8648a657d5c39d8b23eaf7e225,a8ae81a8dbd58bd70f8558c9c99cb6cf,bb5c29be0d2ce6d080ccbce3f4a009a7,d508d0487436bf2ef8296cb44b79ae4b,dfc3849bbae95805700699e135079c35, 4b226aca3b51ac997518032ba32a6ed5,5fe907d03a...</td>\n",
       "      <td>2024-12-17</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>737</th>\n",
       "      <td>1e1d6688-1292-4279-8538-5525f5e346b6</td>\n",
       "      <td>1543</td>\n",
       "      <td>1543</td>\n",
       "      <td>2</td>\n",
       "      <td>Community 1543</td>\n",
       "      <td>[3a2763d21d23462788c1178be5adfdb9, bdeaf3a3660b4ecc8209d556f6ccd413, b3b57365d8ba4d61a21cdf7acf5d198f, a2eae24f23dc4eb19ba6eb40cd82842b, 22094d3a8e6a4bb89da75fff535c283c, 7cbc2e316532473b9368916ec8baef73, ac1b450c0f4643a7896fabb70a4e1efe, a62c4e589d374cb7aedd2721ec0e6b3b, 66d33ceccfa24ac6baa954ea5d079271, fc4c7115dc124b26845e648779023712, 971014eae1a14fc888e5d92520c6b8d0, ba17029602e941ef863a6e84bed6f189, 9bbe326e0e604298a92a2d4177e92a7f, 04359c0fc95f46c89003b2ed74c255a2, be611369daeb41b6ad400baabc44cb8...</td>\n",
       "      <td>[0e8aa5be3bc2439788dac14ba377e18c, 3b403644e4fd4c77a56e26a0f782fc2d, 0cd443ae325c4c32934900f747da513d, 220319d51310434ea0378e79b147c213, 2daa540d7ac34d43b9b430d92cb10ec8, 4a2310db1d904a05b7d6d8d8e7af3f13, 5cc211f4bbc44166922c244a789e53d5, 24486d1539e4424baaf0b8eb618e5552, 465ba156a8864088a5215907843e0a0c, b13b382de3554251a267fac320e77fd7, f3d41a131fbf488eba84ee166ec6fbda, ee75cf2410c04c6d9f3c79ab7d51b3ba, 3f194cde2ccd489d8a6d1483117ffdc4, 570691cfd95449e781b3d55b2ee76919, 3fa8876c469744d3bb2c7088bbcf295...</td>\n",
       "      <td>[0b77aea3ed8857c87ce001239a8a1c33,1f250bdd59d2aade7181d1efa69a09c3,325840329b0b91ca8c2c6df75970a1ef,51c96f990568e9b28cdff330f2c1de36,54ac6d5144f12c98f26d616d973a0e85,8d43e5ae45e4ae1621a94db902f497e4,9cf232043c4b6da0150e7f95ce3ec4d2,a05c80f47fb13b654919f62a635a16d0,afc704a697307c48740ba92dd7973a97,b125a440e33b201b56dbace744610668,bf6b7d22e919e90623ed9909f38f49c9,d4b94faf389d9546e612edc2b80ae38b, 0b77aea3ed8857c87ce001239a8a1c33,8cc011ee0bde192fedb30a073557b85d,bf6b7d22e919e90623ed9909f38f49c9, 1f250bdd59...</td>\n",
       "      <td>2024-12-17</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>750</th>\n",
       "      <td>871164f1-0159-4304-9a7c-a3ebff8a6b40</td>\n",
       "      <td>810</td>\n",
       "      <td>810</td>\n",
       "      <td>2</td>\n",
       "      <td>Community 810</td>\n",
       "      <td>[b40fc4adc1d04e4bbd1a90d66c9c19f5, 6f4568ed16ed4149a57fcb075aadf7f2, 7dae69fe7c28490db9b02352eb56b8c7, c2f8e025b0c44a478a0154038050f65b, 50eda552bf4542598538dfbb15304395, a42d4b6d189647f29852a5fd49b67d10, df1adf3b67c04bb6a4cfc935b3c1142c, 21b536544c7c497088000554ffdf75db, 59f9e6f5116744bb935710ff95d67827, 2fc205e6e00f492099714837ea43ce21]</td>\n",
       "      <td>[6a959eab78324b6c9eaa64cb4934d82f, beef39998909497a923dec7d9ca0e1de, 1716178a9a9e446d8b5ba3290ed9964e, 2fd183b2071347c18ab45c9a6c795da4, 57b7b2e039d64f6e9d302160f36d3dac, 240b1d06e82c455fb3451e7e86b18301, 7d3c799ed2474c14b677cf5aa2e8f025, e89404a43e044887a156abd0f6799a9b, 620a241ab28c40fc942ec5d9f93a0b11, 3290b782a0744a90951d881d91f9a9eb, c42073c4db6b4d93a3d24e82767769c6, b3e8fa6987be45be8f0e06275fcebadf, 83f391f49a7e464cb73ad621be651d12, 9f470161f89449d09b9059869ddcf7eb, c33cd9849f744e4c975410599fdf42e...</td>\n",
       "      <td>[572c7989132b21881c5b8ddc773a970c,701046dcc8de738822cec856f65242ae,a2dbed2e1fec83a9f5d72108c87e048a,a7f0517b761afc946452a442bd7bd940,b1ea4e6cd485d8775dcb4dd5f98e37a9,dd4923f74a15880b8cd7de0dcc11a2a4,e4da97a6a424883df324276c86694adb,f1f605ca09c0fc65fcaf4423b9e6426d, 0e6f0179982487fdf046cef89064118f,31b0fd0039b53ce6f8318c624e7f1bef,701046dcc8de738822cec856f65242ae,b1ea4e6cd485d8775dcb4dd5f98e37a9,bb62079d7a0163b6ad5d0e4a4d7662e4, 31b0fd0039b53ce6f8318c624e7f1bef, 701046dcc8de738822cec856f65242ae, b1ea4e6c...</td>\n",
       "      <td>2024-12-17</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1035</th>\n",
       "      <td>cb456015-c1f3-44cb-a9d7-bbcfea148d55</td>\n",
       "      <td>685</td>\n",
       "      <td>685</td>\n",
       "      <td>2</td>\n",
       "      <td>Community 685</td>\n",
       "      <td>[60081fc71c544ce78d4934893dc14957, caa1666576734aa38aa54c95c2915feb]</td>\n",
       "      <td>[841f9b74b303421b81d6d8b9a5a1893b, 2c8b1fdbf8a24b74a116bd6b6b33cb6b, ed999131027441e98f419b17b804b5f8, 63e24446694f4f7693fad49b9a26ed43]</td>\n",
       "      <td>[8e6debc663311fb1ef4732852b12643b]</td>\n",
       "      <td>2024-12-17</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1624</th>\n",
       "      <td>375022b8-5d7a-4db2-b07e-ec453eba185c</td>\n",
       "      <td>731</td>\n",
       "      <td>731</td>\n",
       "      <td>2</td>\n",
       "      <td>Community 731</td>\n",
       "      <td>[2fdb83eee7464fdc9c5e4501c704cb42, e8f450b7190c439fa448f4866f220b14]</td>\n",
       "      <td>[87476b9679c0412e8f1d43551da01f39, 681232c41f864732a0bbae407638ffc7, bf3de1eace8340dd83ecc7f84ec2c44c]</td>\n",
       "      <td>[e8ccdad56b979f9ae69736e62b2d6518]</td>\n",
       "      <td>2024-12-17</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        id human_readable_id  community  \\\n",
       "699   e46d64d4-a2d0-4a8e-9ae4-07007a8aee02               524        524   \n",
       "737   1e1d6688-1292-4279-8538-5525f5e346b6              1543       1543   \n",
       "750   871164f1-0159-4304-9a7c-a3ebff8a6b40               810        810   \n",
       "1035  cb456015-c1f3-44cb-a9d7-bbcfea148d55               685        685   \n",
       "1624  375022b8-5d7a-4db2-b07e-ec453eba185c               731        731   \n",
       "\n",
       "      level           title  \\\n",
       "699       2   Community 524   \n",
       "737       2  Community 1543   \n",
       "750       2   Community 810   \n",
       "1035      2   Community 685   \n",
       "1624      2   Community 731   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           entity_ids  \\\n",
       "699   [8d81e4c881f947d5841ecca5bb70e804, 0f2e8a4b0c634aea83c7d2649348abbc, a4e7ce7523a34ccf814e3725500e7c12, 33b56fda82f14b3495cddadb21fdd0e1, f8050adcbe2249f3987b4a70be16984b, 61a8482ef8cd4cb884e44c1ebecc44e0, 86e0d706a5fe412a92ef2ffb8d48a598, ddcce488efae4ebb8382049922585cd9, 2d44683e95944afd847e9895ec8541b3, 58c316b40fbd499aa9a4e2a62a64df62, c2f276b017044ad98175651defb7b53f, 3e90edbf44994ff0b832e71c24e88fc6, e432f2e1eb4046f686c9eee684484c71, 0cc1b2b2d0bf415190426480b44e1be6, 446c0d23c400404b929c85e031b0895...   \n",
       "737   [3a2763d21d23462788c1178be5adfdb9, bdeaf3a3660b4ecc8209d556f6ccd413, b3b57365d8ba4d61a21cdf7acf5d198f, a2eae24f23dc4eb19ba6eb40cd82842b, 22094d3a8e6a4bb89da75fff535c283c, 7cbc2e316532473b9368916ec8baef73, ac1b450c0f4643a7896fabb70a4e1efe, a62c4e589d374cb7aedd2721ec0e6b3b, 66d33ceccfa24ac6baa954ea5d079271, fc4c7115dc124b26845e648779023712, 971014eae1a14fc888e5d92520c6b8d0, ba17029602e941ef863a6e84bed6f189, 9bbe326e0e604298a92a2d4177e92a7f, 04359c0fc95f46c89003b2ed74c255a2, be611369daeb41b6ad400baabc44cb8...   \n",
       "750                                                                                                                                                                              [b40fc4adc1d04e4bbd1a90d66c9c19f5, 6f4568ed16ed4149a57fcb075aadf7f2, 7dae69fe7c28490db9b02352eb56b8c7, c2f8e025b0c44a478a0154038050f65b, 50eda552bf4542598538dfbb15304395, a42d4b6d189647f29852a5fd49b67d10, df1adf3b67c04bb6a4cfc935b3c1142c, 21b536544c7c497088000554ffdf75db, 59f9e6f5116744bb935710ff95d67827, 2fc205e6e00f492099714837ea43ce21]   \n",
       "1035                                                                                                                                                                                                                                                                                                                                                                                                                                                             [60081fc71c544ce78d4934893dc14957, caa1666576734aa38aa54c95c2915feb]   \n",
       "1624                                                                                                                                                                                                                                                                                                                                                                                                                                                             [2fdb83eee7464fdc9c5e4501c704cb42, e8f450b7190c439fa448f4866f220b14]   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     relationship_ids  \\\n",
       "699   [49e5664da73341019015169f67217992, b005434809cc44719359b9c15943f914, 907e1aa736f2412baef5aaf00ec1994b, 86612a6767d24f408327325308b2a287, 004342fdf77d40818ec9b82bea12a45e, 1cee783db9f54027a3b03f0bb135780a, 00e2cbd6b468404a9623841c9cd4b56f, 9f96f176aae745a38324460b16989c64, db234c8e96584cfc9cb0848a57df0a67, 9411ff69de4645c0b9b8bfed5d7592e0, 6b1cd278d03b41ee905069137eeb8b5d, fd2b7c3bee36472bba7af9f067985453, 8c3d4edefddc4eeab7e21511c9811f74, 978b06ee16a34bc3981189e274023c1e, 4573312951444f7bbd9e2c16c47f68b...   \n",
       "737   [0e8aa5be3bc2439788dac14ba377e18c, 3b403644e4fd4c77a56e26a0f782fc2d, 0cd443ae325c4c32934900f747da513d, 220319d51310434ea0378e79b147c213, 2daa540d7ac34d43b9b430d92cb10ec8, 4a2310db1d904a05b7d6d8d8e7af3f13, 5cc211f4bbc44166922c244a789e53d5, 24486d1539e4424baaf0b8eb618e5552, 465ba156a8864088a5215907843e0a0c, b13b382de3554251a267fac320e77fd7, f3d41a131fbf488eba84ee166ec6fbda, ee75cf2410c04c6d9f3c79ab7d51b3ba, 3f194cde2ccd489d8a6d1483117ffdc4, 570691cfd95449e781b3d55b2ee76919, 3fa8876c469744d3bb2c7088bbcf295...   \n",
       "750   [6a959eab78324b6c9eaa64cb4934d82f, beef39998909497a923dec7d9ca0e1de, 1716178a9a9e446d8b5ba3290ed9964e, 2fd183b2071347c18ab45c9a6c795da4, 57b7b2e039d64f6e9d302160f36d3dac, 240b1d06e82c455fb3451e7e86b18301, 7d3c799ed2474c14b677cf5aa2e8f025, e89404a43e044887a156abd0f6799a9b, 620a241ab28c40fc942ec5d9f93a0b11, 3290b782a0744a90951d881d91f9a9eb, c42073c4db6b4d93a3d24e82767769c6, b3e8fa6987be45be8f0e06275fcebadf, 83f391f49a7e464cb73ad621be651d12, 9f470161f89449d09b9059869ddcf7eb, c33cd9849f744e4c975410599fdf42e...   \n",
       "1035                                                                                                                                                                                                                                                                                                                                                                                         [841f9b74b303421b81d6d8b9a5a1893b, 2c8b1fdbf8a24b74a116bd6b6b33cb6b, ed999131027441e98f419b17b804b5f8, 63e24446694f4f7693fad49b9a26ed43]   \n",
       "1624                                                                                                                                                                                                                                                                                                                                                                                                                           [87476b9679c0412e8f1d43551da01f39, 681232c41f864732a0bbae407638ffc7, bf3de1eace8340dd83ecc7f84ec2c44c]   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        text_unit_ids  \\\n",
       "699   [0371900a624648f1596be0b34e250f46,cbab760f12d0c219151149f946b96663, 0371900a624648f1596be0b34e250f46,27a0933dc7e66aaf06f185f674739090,395a8bbd6e781764bcfb8f3f43abbce4,4d4b330ebbfd95a52f1404a792c7d9d6,5cb9387d33ef0586c52e9715c5d7c6d8,6ceb2b973680d705479e69aebcf50925,8a990be2de128cfc6068090fae6cb40d,9e227e8648a657d5c39d8b23eaf7e225,a8ae81a8dbd58bd70f8558c9c99cb6cf,bb5c29be0d2ce6d080ccbce3f4a009a7,d508d0487436bf2ef8296cb44b79ae4b,dfc3849bbae95805700699e135079c35, 4b226aca3b51ac997518032ba32a6ed5,5fe907d03a...   \n",
       "737   [0b77aea3ed8857c87ce001239a8a1c33,1f250bdd59d2aade7181d1efa69a09c3,325840329b0b91ca8c2c6df75970a1ef,51c96f990568e9b28cdff330f2c1de36,54ac6d5144f12c98f26d616d973a0e85,8d43e5ae45e4ae1621a94db902f497e4,9cf232043c4b6da0150e7f95ce3ec4d2,a05c80f47fb13b654919f62a635a16d0,afc704a697307c48740ba92dd7973a97,b125a440e33b201b56dbace744610668,bf6b7d22e919e90623ed9909f38f49c9,d4b94faf389d9546e612edc2b80ae38b, 0b77aea3ed8857c87ce001239a8a1c33,8cc011ee0bde192fedb30a073557b85d,bf6b7d22e919e90623ed9909f38f49c9, 1f250bdd59...   \n",
       "750   [572c7989132b21881c5b8ddc773a970c,701046dcc8de738822cec856f65242ae,a2dbed2e1fec83a9f5d72108c87e048a,a7f0517b761afc946452a442bd7bd940,b1ea4e6cd485d8775dcb4dd5f98e37a9,dd4923f74a15880b8cd7de0dcc11a2a4,e4da97a6a424883df324276c86694adb,f1f605ca09c0fc65fcaf4423b9e6426d, 0e6f0179982487fdf046cef89064118f,31b0fd0039b53ce6f8318c624e7f1bef,701046dcc8de738822cec856f65242ae,b1ea4e6cd485d8775dcb4dd5f98e37a9,bb62079d7a0163b6ad5d0e4a4d7662e4, 31b0fd0039b53ce6f8318c624e7f1bef, 701046dcc8de738822cec856f65242ae, b1ea4e6c...   \n",
       "1035                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               [8e6debc663311fb1ef4732852b12643b]   \n",
       "1624                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               [e8ccdad56b979f9ae69736e62b2d6518]   \n",
       "\n",
       "          period  size  \n",
       "699   2024-12-17    17  \n",
       "737   2024-12-17    18  \n",
       "750   2024-12-17    10  \n",
       "1035  2024-12-17     2  \n",
       "1624  2024-12-17     2  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "# Use the absolute path to the parquet file in the output directory\n",
    "df = pd.read_parquet('/workspace/graphrag/output/create_final_communities.parquet')\n",
    "\n",
    "\n",
    "pd.set_option('display.max_colwidth', 512)  # Display the entire content of cells\n",
    "\n",
    "df['human_readable_id'] = df['human_readable_id'].astype(str)\n",
    "# Filter rows where 'human_readable_id' contains a specific substring (example: 'keyword')\n",
    "# filtered_df = df[df['human_readable_id'].str.contains('1176', na=False)]\n",
    "\n",
    "ids_to_filter = ['685', '731', '810', '524', '1543']\n",
    "\n",
    "filtered_df = df[df['human_readable_id'].isin(ids_to_filter)]\n",
    "\n",
    "# Display the filtered DataFrame\n",
    "filtered_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>human_readable_id</th>\n",
       "      <th>text</th>\n",
       "      <th>n_tokens</th>\n",
       "      <th>document_ids</th>\n",
       "      <th>entity_ids</th>\n",
       "      <th>relationship_ids</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>cbab760f12d0c219151149f946b96663</td>\n",
       "      <td>71</td>\n",
       "      <td>Postemas claim the water is surface water. Smith, and his expert, claim the water was a natural watercourse. If the water comes from a natural watercourse or through a “natural drain,” the common enemy rule does not apply. The Postemas argue that even if the water were not surface water, they still have no liability because they only directed it through the natural watercourse. This argument is incorrect under case law more recent than Trigg. Only if the waters are determined to be “surface waters” are the Postemas entitled to seek the shield of the common enemy doctrine. The determination of what classification of water is involved is a question for the trier of fact and should not be taken from “the jury.” There are disputed issues of material fact, and summary judgment should not have been granted.\\nAlternatively, even if the Postemas are correct, that these waters are merely surface waters, there also exists a question of material fact as to whether the Postemas’ upstream actions caused a greater dis...</td>\n",
       "      <td>1200</td>\n",
       "      <td>[255045]</td>\n",
       "      <td>[5a87a9196ccf4e399f6bd6db3c7f8a82, 33a4ee7341344732990f4fdc43107a42, acf6469ba0214efb93da633e23de099d, 0a9e2436bba84cf181323a6fe5c9f67d, 3ce07d6ef400488dbbb7d6bc7321d91d, 4e36272e21184f30b2dad88f9961486a, bfe9daf04d944939906cd3f291e11a7b, 75c5227bec0447eda5cd1e572a349fb1, 4346aec80c5d4080a3e40233b3a26d6f, a92cec5ab10b477d9572b9c7e2133425, 990f044726f542f3b0218577272be948, d5e42682c2bf47e687807d0f84004050, bb60b4e0056f4c24835443361f1b0afa, 31f7a94953dd4027a6c03b9ceb07e9fa, a07f9b30952e4f2780292db9fa2699aa, 59cbb3c99f60494391a90bd942673fd1, 85348c3ef4704331b7b635ed0a9f8be7, a4cd7bdfe9454b459b06189385ea9d5c, 1f682015554e49799b8667f394a09e62, 0ee30bd1b545474e80cdc9f4c446b4bf, 0c89d797c8184c769c8295ac228cdc83, 8306ab2031f0415a870cdd650723786a, c41ec86ef9ac4096a77969882cff7d79, 94ea8ec796da43589ab8091f96e903f3, fbcbfb5195d94e8087e23a14417269c8, 8d81e4c881f947d5841ecca5bb70e804, 6f3ec0b465264e688d34fe47f89aef3a]</td>\n",
       "      <td>[32e1cfaec8e04287a8c73bad5a1224ca, 101971e0712645f89f20f837a6583ea7, 80527ee0a69b41cba9b2598baf2282c9, 8827e69a626d44e98f9a2317e83f2d14, f629efebc3004a3c8d2e8a0ff633c3e0, 56076d25a1ce44099c081c44693d3796, 53fbd69f7412401fac435649ccc0ebb7, 91c0777fd84b4d54a79ce549ebca18e7, dda48c7fc84042ffaaa52bb3a715506b]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>395a8bbd6e781764bcfb8f3f43abbce4</td>\n",
       "      <td>96</td>\n",
       "      <td>Sweeney, C.J.\\nWashington’s unlawful detainer statute (RCW 59.12) authorizes a limited summary proceeding to determine the right to possession of property. Skarperud v. Long, 40 Wn. App. 548, 550, 699 P.2d 786 (1985). Counterclaims and setoffs are generally not permitted in an unlawful detainer action. Skarperud, 40 Wn. App. at 550. A lessee may, however, assert a counterclaim or a setoff, if the lessee’s covenant to pay rent is dependent upon a covenant that the lessor has breached. Skarperud, 40 Wn. App. at 550.\\nThe dispute here centers on a farm development lease. The term of the lease was four years with a right to renew for another four years. The lessee, Keico Industries, Inc. (Keico), developed an irrigated farm during the first four-year term. When Keico failed to make the last rent payment on the first four-year term, the lessors, William D. Heaverlo and Charlotte M. Heaverlo (the Heaverlos), sued for unlawful detainer. Keico counterclaimed contending the Heaverlos had breached a number of coven...</td>\n",
       "      <td>1200</td>\n",
       "      <td>[420969]</td>\n",
       "      <td>[973e932adf324cd2bba0522c1e36732e, 3e5754cde3a540e8bb5a612f8f0e8bfd, c02429b83ebf4c7994e6e5717b9e1a9f, 8625a240220641ad897a58dafec89f59, 33a4ee7341344732990f4fdc43107a42, ed27c6e76d714bdfb43d9f1e293a8708, 8f6c479f7c5f4b3f94fdee83e618d775, 7ed8374c4d7648369f0ffb66765c5ecf, 0962b9fd91bb4fffb2069728ec4d7145, 9ce546b7640c4cd2bab4cd2aa1e7a2f2, 78b1aa9a6c4c4ae58ae20d718691819e, 0f2e8a4b0c634aea83c7d2649348abbc, f8050adcbe2249f3987b4a70be16984b, ea5038f3e8ca448c88adb54cd1f1c587, 53c1d720997342c493a3a32e53ccf225]</td>\n",
       "      <td>[079b7fbfaa334716bb60809918d376d0, 16530116c80f45aca289028343d2aa60, 3bfe2ac8373b4050b060109087a7cd01, 3d312750daba40c48c6bdf5f20c550c9, d27ea25223dd44aa850878f04020a37c, 974b7283278f49c88f240df419ef9219, f2b89de15ccf4b9fbffdf324b56a1a29, 0890578054a34cae85241ba23268bc5d, 56f35227b24944d798ae86742b4a7b4b, e346d07474bd415eac6d51844725e0c2, 123b18ee01b74d60b2ffe6703f62e8b3, b46bbd1a3e6c45428a48c8db343731d5, eea255fcab7f430c9c5c3ade31805483, 1266526788844c69ab1960ce0dc9af6a, b47bc57266ce4ae4bd9b63339678f563, 5b4d05c1f9f34440867e881b45b7fed6, b005434809cc44719359b9c15943f914]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>342</th>\n",
       "      <td>8e6debc663311fb1ef4732852b12643b</td>\n",
       "      <td>343</td>\n",
       "      <td>in the fact which so far impeaches it as to require the court to say that it was the result of passion and prejudice. Moreover, we do not find' in the record that the estimates of the plaintiffs ’ witnesses were disputed by the other side. There was a leakage from the roof at one time for which the defendants admitted fault, and they offered testimony to the effect that the damage caused thereby did not exceed $50, but on the general question of the amount of damages, the cause went to the jury on the testimony of the plaintiffs ’ witnesses. It would seem that, under these circumstances, the court could hardly find either passion or prejudice had the verdict been for the full amount demanded.\\nThe second contention under this head is that the overwhelming weight of the evidence relating to the cause of the damage is against the verdict of the jury. It is first argued that the building was constructed according to the plans and specifications, and if it was so constructed as not to furnish protection agai...</td>\n",
       "      <td>1200</td>\n",
       "      <td>[782330]</td>\n",
       "      <td>[7704fcb505944aeeba16972bd58f7fad, 33a4ee7341344732990f4fdc43107a42, acf6469ba0214efb93da633e23de099d, 48dd98a7e9694e868a18d51afe3dba9d, 1cd321dc3c174397bb2bb05dc189f83a, f25ce65b3bb443268c8339daffe11db2, 82010d56d2d24321a3696114e35e6fe7, 964163716b7b480ea07689d6ce1ac2f8, a8e79d0571f34a8e8d5190c4efcc5a57, ca28d4c0d05b4333933162837ef85669, ee4890933a04451c9c84978213ef8048, 122d549d41f946ddbe0b797bb9e3bd22, 60081fc71c544ce78d4934893dc14957, caa1666576734aa38aa54c95c2915feb, bc264b41054548109687bf389a51aabd, 7dc7091c8e354d56af4ed6e43aae9955]</td>\n",
       "      <td>[be3e40ba9b18482f963a459a13d7c0cc, 7761b38c04164a498e4d153506f8d801, a0271ddbef2e4bb990e3ac8b982e397a, 87f2d7e1657342208456486729a3dc08, cb3689c3cf1e4db985b0e29e811da56b, d9935c26b448443681ff761a0fd253f0, bc7fa57b16534658872ef9fb8974c01f, 247c3738a1344a1c96e01d29f5fc950d, f9c0e3b95a094a03a1fc3494df3061fe, 2035909765d045fab2f65f788bec83c9, 2c8b1fdbf8a24b74a116bd6b6b33cb6b, be72d0dfdd354c3dbe0f6bdd005005b9, ed999131027441e98f419b17b804b5f8, 63e24446694f4f7693fad49b9a26ed43, 841f9b74b303421b81d6d8b9a5a1893b]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>504</th>\n",
       "      <td>6ceb2b973680d705479e69aebcf50925</td>\n",
       "      <td>505</td>\n",
       "      <td>Madsen, J.\\n— This case raises the question whether the Department of Ecology has authority to condition a water quality certification under the Clean Water Act of 1977 (33 U.S.C. §§ 1251-1387) on maintenance of minimum instream flows, where such conditions affect existing water rights. The case also involves issues concerning RCW 90.03.380, the surface water statute governing changes in and transfers of water rights, and issues of abandonment and statutory forfeiture of water rights. We conclude that the Department of Ecology has authority to impose bypass flow conditions in a water quality certification regardless of whether the applicant has existing water rights that may be affected. We also conclude that when acting on change applications under RCW 90.03.380, Ecology may not deny an application based upon public interest considerations, and that the change statute does not apply to inchoate water rights. In addition, we conclude that the water rights at issue were neither abandoned nor forfeited unde...</td>\n",
       "      <td>1200</td>\n",
       "      <td>[960846]</td>\n",
       "      <td>[810db66b3e2c488293adcfc199524f92, e10d2b599ef6495ca9028e5a7707d231, 0f2e8a4b0c634aea83c7d2649348abbc, 2e845bdcfb4d43528c677bbfc4b1d296, f7a30824aa354d1fbcb77257399cd060, 6424c793b0834a869a0e1520e51776d1, 77b3061f18fd42d099b83d9cbc62e4b5, d7f7055fd1844c9b8baeff2083d4c42a, 19a0523b2445422cb7afafd87320cfde, b87e949ae32a4ce08994c9410d025475, ba6cf6f5f0e04616a0e589573af93ba4, 8027607faab8403e8b57c9acac769c8a, 0b7478f001344bad96a79fa3b20a1d8c, 73aff77a7a17420fb34826a5d8fc5823, 40248f92be224d4ab87302012e883bba, a829a1301d2c429d98e038d865948301, 1cba0b9d5920484d90d26291b2341899, 1d2dab12ffe6454eb261910ae6067e6a, 7a1a78fbe1724fd99e5cb3d77e394f39, 8ddf200b6fc44ad7931a2d1b881517e1, 00ee7d0daac7402d8bf77fcefb41baa8, 269c8b0e556740b59e7a0fcbe259f69f, cd9b6baa849545148cab11bd4db12329, 7c662215303a48219d4662067b2f80f1, 57bf024261034d59b31e957fb59599e9, 6e1e886e6de140d6917c87f0ed7c0126, 9152a917cd704bdb90678a0a3f7ee177]</td>\n",
       "      <td>[b4b3b18ed291403faf3b666ed7858bee, 5d0547b8dcdc43cf821dd0aec568c42d, 443d218214574dc9b60c24e8a712e41e, 1d5194752ffa454b93983a6dc73b063a, 907e1aa736f2412baef5aaf00ec1994b, da7f632c158049fdb2652b1a192fad78, 0a3324bba4a54a3dbe72c13de7e964a6, 584636a013b149c79614e9c9bbf571cc, bce5f2b569ee429bbfe2b66725486c48, ea7b3715ee0a43d1850302de4556fa5f, 9cad155077334a68806e0c4f7405a76f, 76dd6272a8fe481e802ca043faf65bb3, 5b8de4af01654718ae7d0c42cc218058, 0b308a90ebe248de854652859f190b8e, 6bc0beea1195419d976be7f27c08531d, 56dbd5f1929f458b834889e82e62753b, 806048873b9546d0ab4a05da5be92d5e, fa29926f009b4898898ce361e2e15390, f5de71cde8df441e89115fb85a20eee3, 4a1260425a0943508dc644f64c250429, 5b46d43a52564f02a7adf6e91188ac43, f75ebf1660c64a52864834e005df51d8]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>505</th>\n",
       "      <td>bb5c29be0d2ce6d080ccbce3f4a009a7</td>\n",
       "      <td>506</td>\n",
       "      <td>state hydroelectric licensing fees in connection with its 1907 water right. It also paid fees in connection with the 1980 water right, although for a period of years it failed to pay the fees for most of the 440 cfs right, due to a clerical error. In 1998, it informed Ecology about the missing fees and paid the late fees.\\nIn 1992, the District proposed to reestablish power generation. The new Sullivan Creek Project would use the same configuration for the project as the original project, but would be bigger than the original. As noted, in 1994 the District filed the application with the Federal Energy Regulatory Commission to amend its federal license to allow power generation. Because the project requires a federal license, on October 30, 1996, the District filed an application for a state water quality certification with the Department of Ecology (Ecology), as required under the Clean Water Act. On October 28, 1997, Ecology issued an order certifying that the District’s project complies with the act a...</td>\n",
       "      <td>1200</td>\n",
       "      <td>[960846]</td>\n",
       "      <td>[0de3a0d557ca4b5a9c6668a67ff55150, e10d2b599ef6495ca9028e5a7707d231, 0f2e8a4b0c634aea83c7d2649348abbc, f7a30824aa354d1fbcb77257399cd060, ed30d6de493944e785f4a477fd0672fe, b87e949ae32a4ce08994c9410d025475, 054996a062bf4e3faeb598e59cf69d5d, f38aca2abcaf4af2bf4b9c1654bcf79e, 48531e39e80f4c2788fbc5fb0547e57b, 4705a683213a425d98f2829b49117f73, 8f8efaccbbe344edb3d94d6d9e5b1f74, 68ecb452ebd94b78b5360f658a801fcd, 467c409544604ee2827231573ce75956, b145c9c9e7b04c749c575519df608bb1, dac5620fa0144c4dbe68690ac2cdc35f, 65ae2053fb9a49678f3683c7b9dcef9a, f224726072f243d3891b7ae95c2198fa, 900e9346c4b74b0eafbe7af1f18b5dea]</td>\n",
       "      <td>[fc197eaf68774eaca17c1f5eca285bf2, 6577ce42be19486b88ff59fd4e15b17a, aaf5685f165840b78ea11dd53548387f, 86612a6767d24f408327325308b2a287, e6a1079e3b774a06a1b95b0748f5b4a7, 1dbceb0b810440348460a033243aedc6, c26bee5440614f79acf56c59bd870d82, 931bc96a8c104d32a827a877706e0732, 6ad410843c9947a998a910f0a34dacb9, f92d0d33dc4e42e99dfcd015b1625097, 9d07672312ee4b50978260647c9cd9d4, cf97da9ccdd94c809481527a787eb5e6, b4f12e154ea2427cb7e9e5356eedf73f, 9b4d0531a4bb40a8a65fb332fe6215a2, ea5c9f7b43b04a3fa2d128ae14d7ee68, 66d7d74f000448dab5befc0a2d636230, 92ee97716de84c468341acfad876c53f]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>512</th>\n",
       "      <td>5cb9387d33ef0586c52e9715c5d7c6d8</td>\n",
       "      <td>513</td>\n",
       "      <td>development and failed to pay licensing fees, and that under RCW 90.16.060 this is conclusive evidence of abandonment of the water right used or proposed to be used for power development. We do not read RCW 90.16.060 as providing for such abandonment. First, as to payment of fees, the statute states that “the failure to file statement and pay the fees, as herein required, for any power site or claim of power rights on account of riparian ownership within two years after June 12, 1929, shall be conclusive evidence of abandonment.” RCW 90.16.060 (emphasis added). The statute was enacted in 1929 and, evidently, the quoted language was intended to assure that power developers complied with the new act’s provisions in a timely fashion. Nothing in the statute indicates that the abandonment provision applies to the failure to pay fees after 1931. Moreover, the rest of the statute demonstrates that it does not. RCW 90.16.060 also provides that\\n[s]hould any claimant fail or neglect to file such statement within ...</td>\n",
       "      <td>1200</td>\n",
       "      <td>[960846]</td>\n",
       "      <td>[0de3a0d557ca4b5a9c6668a67ff55150, e10d2b599ef6495ca9028e5a7707d231, 0f2e8a4b0c634aea83c7d2649348abbc, ed30d6de493944e785f4a477fd0672fe, 054996a062bf4e3faeb598e59cf69d5d, 36d411750546465bb11748de08cb1ca0, 0557c7b0fd8d470abd74ef778bf5d703, 86e0d706a5fe412a92ef2ffb8d48a598, c8806d42ea954a1da21ff13da96a0cd8, 922bd5652a0146a6b9f7264d28c4a0ac, 705aee711c884543bfdb063b2f5cb6e3]</td>\n",
       "      <td>[65028418de0742879572881973fd2321, 6577ce42be19486b88ff59fd4e15b17a, ae654565176749ef83a7e455effcf925, 86612a6767d24f408327325308b2a287, 004342fdf77d40818ec9b82bea12a45e, 1dbceb0b810440348460a033243aedc6, 6170b098dc78449daf7fd78a5bf00fb7, 5cbe8323c84e4793904d4f76556f4e62, f990e931b8424360a46ecedb9090ae3b, 4abbf83b9faf4293a61e8dc4abe02e8b, 0110f772c5894a91b81793bfd5abeaa0]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>513</th>\n",
       "      <td>27a0933dc7e66aaf06f185f674739090</td>\n",
       "      <td>514</td>\n",
       "      <td>511 U.S. at 704 (quoting 33 U.S.C. § 1251(a)). “The act also seeks to attain ‘water quality which provides for the protection and propagation of fish, shellfish, and wildlife.’ ” Id. at 704 (quoting 33 U.S.C. § 1251(a)(2)).\\nUnder § 303 of the Clean Water Act, each state must establish, subject to federal approval, comprehensive water quality standards setting water quality goals for intrastate waters. 33 U.S.C. §§ 1311(b)(1)(C), 1313. 33 U.S.C. § 1313(c)(2)(A) provides that a state water quality standard “shall consist of the designated uses of the navigable waters involved and the water quality criteria for such waters based upon such uses.” Further, state water quality standards must “protect the public health or welfare, enhance the quality of water and serve the purposes of this chapter. Such standards shall be established taking into consideration their use and value for public water supplies, propagation of fish and wildlife, recreational” and other purposes. Id. Section 303 also contains an antid...</td>\n",
       "      <td>1200</td>\n",
       "      <td>[960846]</td>\n",
       "      <td>[0f2e8a4b0c634aea83c7d2649348abbc, 5309dda8c2de43c6b80590466c9b691e, 568f541aee9846d99416c7b123068e82, b87e949ae32a4ce08994c9410d025475, 054996a062bf4e3faeb598e59cf69d5d, 13796e43d53b4918b5447e4c6eefcabe, 162d32c90bf24a829a2cf1a107f2049e, 67bd894ef20f4690ba6bfd6940c84e16, 5a825a62b2e5424d884867c0943325ad, 46274d4465af4f79bb04d3236f320fa7, d291c450654c40d1961c1640260070f7, 10f31c2e4efb4f62b49706160edfa899, 20dc2bc0fedf41cabd22923ec8f61233]</td>\n",
       "      <td>[86612a6767d24f408327325308b2a287, 1cee783db9f54027a3b03f0bb135780a, 00e2cbd6b468404a9623841c9cd4b56f, 9f96f176aae745a38324460b16989c64, 1387b2c084e14a6b93f18897dcacde3a, 3580b42c2bd0409ea1920101af0c4272, f56a59d925a942128503ab95fcecdb2a, fd0d4e342ed44e118ab7b8d466236720, f9b1538ac8b24b579cb2212abd8020bc, d602e73930584cd6abc23b063bf663ee, a61b0d15742d4ef19e2118e8662fa924, b1004812b2dd4d149f37eccfc8a6ab5d, 64053c94ad2a408e9416b42e2db3db7a]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>514</th>\n",
       "      <td>0371900a624648f1596be0b34e250f46</td>\n",
       "      <td>515</td>\n",
       "      <td>become a condition on any Federal license or permit subject to the provisions of this section.\\n33 U.S.C. § 1341(d).\\nIn Department of Ecology v. Public Utility District No. 1 of Jefferson County, 121 Wn.2d 179, 849 P.2d 646 (1993) (Elkhorn I) (the decision reviewed in Elkhorn ID, this court addressed the propriety of conditions in a § 401(d) water quality certification that required that the applicants maintain certain minimum instream flows in the Dosewallips River, also classified as AA. The applicants there were a city and a local utility district that wanted to build a dam, and applied for a hydroelectric license from the Federal Energy Regulatory Commission. A § 401 water quality certification was therefore required. The proposed site would reduce streamflow on a stretch of the river between the initial diversion and the place downstream where the water would be returned—the bypass reach—and would adversely affect the salmonid population in that portion of the river.\\nThis court upheld the streamfl...</td>\n",
       "      <td>1200</td>\n",
       "      <td>[960846]</td>\n",
       "      <td>[8d81e4c881f947d5841ecca5bb70e804, e10d2b599ef6495ca9028e5a7707d231, 0f2e8a4b0c634aea83c7d2649348abbc, 6424c793b0834a869a0e1520e51776d1, ba6cf6f5f0e04616a0e589573af93ba4, 705aee711c884543bfdb063b2f5cb6e3, 20dc2bc0fedf41cabd22923ec8f61233, 4ac610bad3a74ec897d3d4878e2993e0, a5c31691378042609b58dc813a74cd0c, 417380320b1146e5a6e5af2a621759fb, 03a610f6316241a9b9f0e9ac257aa14e, bb8fe969d98e4b47a688449cb8a80ff5, b1faadc995a6474d9c92435fab163cb6]</td>\n",
       "      <td>[49e5664da73341019015169f67217992, 65f29a300ca4402c9493cb092ae8fa20, db234c8e96584cfc9cb0848a57df0a67, 9411ff69de4645c0b9b8bfed5d7592e0, 03dade4c9c9b4d6883a2c18b1f962902, 349166e83c3e4910b02fdf069fd3a3fd, 72d8c4d5dc7a46f78eacf6858ad8a89b, eacaee91ee3e4fa4a01edebe90344416, 0d19cb75fb304fdfbbd57e796fa8d61e, 4b861003cb754cc9a79287642dc560f6, da9e1b57651244bda0a0e1ec72aadb92, 5a3ee52c36304dafad113f9014b94396, a9670e0cf030499ca0252c15d920bcaa]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>515</th>\n",
       "      <td>dfc3849bbae95805700699e135079c35</td>\n",
       "      <td>516</td>\n",
       "      <td>conditions as part of § 401 water quality certification where necessary to enforce a designated use and conform to state and federal antidegradation policies.\\nThe District contends, however, that Elkhorn II does not apply here because the District has existing water rights, unlike the applicants in Elkhorn II. The District argues that in light of § 101(g) (33 U.S.C. § 1251(g)) and § 510(2) (33 U.S.C. § 1370(2)) of the Clean Water Act, deferring to state law on water allocation, a condition that may affect the quantity of water available to one who holds an existing water right must be authorized by state law. There is no such state authorization, in the District’s view. The District also contends that minimum flow requirements cannot be imposed without compliance with procedures set out in chapters 90.22 and 90.54 RCW.\\nWe do not agree that Elkhorn II is distinguishable.\\nIn Elkhorn II, the Court rejected the argument that § 101(g) and § 510(2) of the Clean Water Act excluded regulation of water quantit...</td>\n",
       "      <td>1200</td>\n",
       "      <td>[960846]</td>\n",
       "      <td>[e10d2b599ef6495ca9028e5a7707d231, 0f2e8a4b0c634aea83c7d2649348abbc, ed30d6de493944e785f4a477fd0672fe, cae5f406c1c54771a4429c1ca6cd9292, 60317f088ab1486cb9aa99a055827aba, ddcce488efae4ebb8382049922585cd9, 2d44683e95944afd847e9895ec8541b3, 33b56fda82f14b3495cddadb21fdd0e1, 58c316b40fbd499aa9a4e2a62a64df62, c2f276b017044ad98175651defb7b53f, 0ecac5102097429ca5247ddd2ef42ac0, 3e90edbf44994ff0b832e71c24e88fc6, 2b47d1bc1a2f4d3780ab0cd33f9f332d]</td>\n",
       "      <td>[ae654565176749ef83a7e455effcf925, 00f07fa34a4b457cb4d4c5ad309cf981, 6b1cd278d03b41ee905069137eeb8b5d, fd2b7c3bee36472bba7af9f067985453, 8c3d4edefddc4eeab7e21511c9811f74, 978b06ee16a34bc3981189e274023c1e, 4573312951444f7bbd9e2c16c47f68b8, f6348e31e8ca4eea821c7c7962f1a5b6, 4807e12ebc594d2f8f229dee36cbca63, 0cb7fc3b60684925a19f2941fa5e28fe, 0736f39fc77345d68cd327daeb09966e, 664f679eb86041c6b26d8a0e47d9ecaf, 2e6eb75a5f584aeb8f893af30897bd04, 1acc6a643ffd4a979a284f25444e1db8]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516</th>\n",
       "      <td>4d4b330ebbfd95a52f1404a792c7d9d6</td>\n",
       "      <td>517</td>\n",
       "      <td>Callaway, 392 F. Supp. 685 (D.D.C. 1975) held that the Corps of Engineers, having administrative responsibilities under § 404, had to promulgate regulations concerning all waters of the United States, and not just traditionally navigable waters. Hobbs &amp; Raley, supra, at 846. Concern arose that farming practices, irrigation, and municipal water projects might be barred or restricted by § 404 permitting jurisdiction. Id. at 847. By 1977, a “standoff’ existed between the House and Senate as to the reach of § 404, and Senators Wallop and Hart were key in a series of compromises that became law—among them, § 101(g). Hobbs &amp; Raley, supra, at 853-54.\\nSenator Wallop explained, in addition to the comments quoted above:\\nWater quality and interstate movement is an acceptable Federal role and influence. But the States [sic] historic rights to allocate quantity, and establish priority of usage remains inviolate because of this amendment. The Water Pollution Control Act was designed to protect the quality of water a...</td>\n",
       "      <td>1200</td>\n",
       "      <td>[960846]</td>\n",
       "      <td>[0f2e8a4b0c634aea83c7d2649348abbc, 14343803142e47e0a43bb8d6550947bb, 13796e43d53b4918b5447e4c6eefcabe, c2f276b017044ad98175651defb7b53f, c058ea1379ad4ebba91d1337938bac6a, 8fde418daeb7474e946a58adce948c8f, 150b84379318481b84e2a5e38c5c2bf9, e432f2e1eb4046f686c9eee684484c71, 0cc1b2b2d0bf415190426480b44e1be6, 49dae3489270471b8ce461600a81b8cb, 446c0d23c400404b929c85e031b08957, 1aa109aa8c8f413aa85c5df520650cd7, 9721c61913754d7d80c28d9d721438e2, a21880220a12456798c4241452e98090, 339bac5eb40f42e5a05d7f18abf4cb51, 6899375426ee43d1a09fc17ac2442700, e435a5ea440640b593dc86c927b928f6, e8d8a563a95c4eeba0b3b3828ab96df2, 1986f12523d8419a91a29d987f646698, 224d14b13ecc48f6b457fbe1db01b418]</td>\n",
       "      <td>[3614a7acb3f24b6d9cfb8b922fd1c019, c668475c9fa1445fbb3e4718d2ecac9d, 5cf2c38a1fbb4697af886d9dd84a024b, e0e7ecaf42c64b7a8d3ceec44eb7cdc6, c738ed3f26044f94a7e12d9ba3ec3d90, 9d8e4001ee0d44af81d0be69646d690e, 1bc02d3e6d094bb2942b7850b44995c4, 6d5211b439b246e3b7f9eb8beb3c05c6]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>517</th>\n",
       "      <td>a8ae81a8dbd58bd70f8558c9c99cb6cf</td>\n",
       "      <td>518</td>\n",
       "      <td>him from depositing dredged or fill material into certain waters, channels or wetlands, specified by the Corps of Engineers, without a permit (unless a permit was determined to be unnecessary or he did not receive a timely decision on whether a permit was not required). The farmer built a dike across the wetlands, and he argued the dike was an exempt irrigation facility for purposes of § 404’s dredge and fill permit requirements. He also argued that under § 101(g) the irrigation exemption should be applied so as to avoid impairment or abrogation of his state allocated irrigation rights, which he claimed were rendered virtually meaningless otherwise.\\nThe court disagreed, reasoning that “any incidental effect on [the farmer’s] rights to state-allocated water from [the river] is justified because protection of [the wetlands] is the type of legitimate purpose for which the [Clean Water] Act was intended.” Akers, 785 F.2d at 821. See also Water Works &amp; Sewer Bd. v. United States Dep’t of Army, 983 F. Supp. 1...</td>\n",
       "      <td>1200</td>\n",
       "      <td>[960846]</td>\n",
       "      <td>[e10d2b599ef6495ca9028e5a7707d231, 0f2e8a4b0c634aea83c7d2649348abbc, a4e7ce7523a34ccf814e3725500e7c12, ed30d6de493944e785f4a477fd0672fe, cc2bf1037a7b4d988280018d3f46d115, 054996a062bf4e3faeb598e59cf69d5d, 4705a683213a425d98f2829b49117f73, 8ac57a1e681342d88c8051f06df280cc, c8806d42ea954a1da21ff13da96a0cd8, 8fde418daeb7474e946a58adce948c8f, c0bc6ea01b384d0aa148f77545a2649d, 0b66c2387e3641998ebe28cdb22f3d76, f52c499aa02847b9aa218a24c2bd96a1, 00daacbbd3ac4889bcbf233e2b00f397, cba57409b0da4756bd46e50ae10acd30]</td>\n",
       "      <td>[862459fd048741abbe661b513a85f1ee, 86612a6767d24f408327325308b2a287, 09e35cf611bc44188ab5fb3f5610aed5, c6e8c73bca5641d394fedab078c51d76, 10127cdf700f4cf2bf3bc3b9ba25416b, b149a2d568cf4087a1dc3b2ba766d609, 1dbceb0b810440348460a033243aedc6, 5825b2b9fd974d5e803652e080c6aa76, 30f4de2d01f7405e9653f6304c88d88b, 4abbf83b9faf4293a61e8dc4abe02e8b, 5ecb16ff9e1540f595516eea404a8fdf, 224ab63b070f4e4e98f8abd0d7c774bc, 54f619ee3ca641b69124ed93321e3ccf, 93883bf571d240e383bb23aadaef9ebc, 4dd53806ec5a491599d3c5e4867f2cad]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>518</th>\n",
       "      <td>d508d0487436bf2ef8296cb44b79ae4b</td>\n",
       "      <td>519</td>\n",
       "      <td>broad grant of authority, from imposing conditions that may affect an existing water right. This is in sharp contrast to other areas of Ecology’s regulatory authority. See, e.g., RCW 90.03.030; RCW 90.44.040. In this connection, we disagree with the District’s contention that the absence of a savings clause in chapter 90.48 RCW has no significance. The District says that the state Water Pollution Control Act, chapter 90.48 RCW, simply authorizes the “discharge” of material into water that causes or tends to cause pollution, and authorizes cooperation with the federal government under the Clean Water Act. The District maintains that the withdrawal and use of water is not the same as the discharge of pollutant(s) under the state Water Pollution Control Act or the Clean Water Act. Therefore, the District says, neither the Congress nor the Legislature authorized regulation of the use of water under existing water rights.\\nOf course, Elkhorn II clearly holds to the contrary as far as the Clean Water Act is co...</td>\n",
       "      <td>1200</td>\n",
       "      <td>[960846]</td>\n",
       "      <td>[9197e0d741d444ee9bbe712483a154b0, e10d2b599ef6495ca9028e5a7707d231, 637f58bf03a04185aef452bbca15e7d6, 0f2e8a4b0c634aea83c7d2649348abbc, ed30d6de493944e785f4a477fd0672fe, 568f541aee9846d99416c7b123068e82, 054996a062bf4e3faeb598e59cf69d5d, 13796e43d53b4918b5447e4c6eefcabe, d291c450654c40d1961c1640260070f7, 00daacbbd3ac4889bcbf233e2b00f397, 71f1b4c52e8d4444afed054fdcd5abc5, cade215a92d544ecbc1b59a4d0001994, 538870f25d004ced989d2adf36d9ea70, 807b3acb67954b03b34b2987014a2491, 604ae2b0c0a84669b04d322f13d6debe]</td>\n",
       "      <td>[0ba8b63fd8644ef5b23e6f2a2692108c, 6577ce42be19486b88ff59fd4e15b17a, 572b59e352434dcaa2f06d721831105d, 99d4f3906e09469994850331a4848762, 86612a6767d24f408327325308b2a287, 3eb7c97bb16e43028ecbdc0992cf37fb, 1dbceb0b810440348460a033243aedc6, ca1d45baeda448d784603ca947251f49, 6c1f420a9e894c14875e1456ac5615c8, 635a6d6ea3e44ac7b418dbd722345ccd, 981312280e8948efb4270fec3f56b251, cf885b3ac93343d893054d4ff0728e0d, ddee5c52f60544faac6a4a404a23bb72, e460e01848f84594b6af0bad49dc2c74]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519</th>\n",
       "      <td>8a990be2de128cfc6068090fae6cb40d</td>\n",
       "      <td>520</td>\n",
       "      <td>change under the statute. We hold that the District’s water rights were not abandoned or statutorily relinquished.\\nFor the reasons stated, the Board’s decisions are affirmed in part and reversed in part.\\nSmith, Johnson, Ireland, Bridge, Chambers, and Owens, JJ., concur.\\nThe certification requires the following instream flows:\\nOctober 1-March 31 75 cfs\\nApril 1-7 100 cfs\\nApril 8-14 140 cfs\\nApril 15-21 160 cfs\\nApril 22-30 200 cfs\\nMay 1-July 31 200 cfs\\nAugust 1-September 1 125 cfs\\nIn re Certification to Pub. Util. Dist. No. 1 of Pend Oreille County, Dep’t of Ecology, Order No. DE 97WQ-E361, at 3 (Wash. Oct. 28, 1997). From May 1 through September 30, the required flows are the lesser of the above flows or the natural flows entering Mill Pond.\\nAn inchoate water right is\\n“an incomplete appropriative right in good standing. It comes into being as the first step provided by law for acquiring an appropriative right is taken. It remains in good standing so long as the requirements of law are being ful...</td>\n",
       "      <td>1200</td>\n",
       "      <td>[960846]</td>\n",
       "      <td>[e10d2b599ef6495ca9028e5a7707d231, 8a53b824484c45b1bf85f614e8b9a696, 0f2e8a4b0c634aea83c7d2649348abbc, ed30d6de493944e785f4a477fd0672fe, cae5f406c1c54771a4429c1ca6cd9292, 054996a062bf4e3faeb598e59cf69d5d, 4705a683213a425d98f2829b49117f73, 8ac57a1e681342d88c8051f06df280cc, 012e454018fa4684885cda7e693dac35, a82b65d9505a4b2f975879f8bf64f6f0, 32f641e8a3b44a6a94647bf3fe25b464, c666f2bc58e0406c9f0624ab72b8c05c, 9b2cfee9b821410d949ee86d928beda0, 1ad8d7ba10ac4b7a8736060d8ae6e006, 0f832ff609764255b3b470f98c243114, ae0cfd461d084e4790e50b04d6cef4ac]</td>\n",
       "      <td>[aaf5685f165840b78ea11dd53548387f, 00f07fa34a4b457cb4d4c5ad309cf981, 750cdce308344170928490b8e557fa6c, ca5f571dd8504c0cb67cc56aaa55ba45, cbcd2bf6740a4acdb27946aac9e79867, 2d4c47f0e0f548e3b575d2e8e3d02abc, e9ea99444724460abcf48c4efd3aa97f, f3fc15910c04466fb384ddc04f9a3471, 86612a6767d24f408327325308b2a287, 07b8db7c2f354864a7b29664b22d027a, 33e68df4cc9844c3bb45d06d698eea4f, 34d6652c3ff648fb9a6062372b3b3b21, bb11cfd172da4989974d3ce0e29b1a66, 4db880f2a2824bfd984ba989bcd14ab9, 07004983503d4f9cac29024e5fcb011d]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>520</th>\n",
       "      <td>9e227e8648a657d5c39d8b23eaf7e225</td>\n",
       "      <td>521</td>\n",
       "      <td>W 90.54.020 was such a state law.\\nThe Court also said that 33 U.S.C. § 1314(f) expressly recognizes that water pollution, may result from changes in movement, flow, or circulation, from dams or other diversions, thus also showing congressional concern with the physical and biological integrity of water. Elkhorn II, 511 U.S. at 719-20.\\nAs the Court said in Elkhorn II, the language in § 101(g) gives a state the authority to allocate water rights, and thus the Court found it “peculiar” that the applicants in Elkhorn II argued that it prevented the state from regulating stream flow. Pub. Util. Dist. No. 1 of Jefferson County v. Wash. Dep’t of Ecology, 511 U.S. 700, 720, 114 S. Ct. 1900, 128 L. Ed. 2d 716 (1994) (Elkhorn II).\\nAs the Ninth Circuit noted, the farmer conceded, for purposes of the case, that portions of his property were wetlands subject to permit requirements, and exemptions, of § 404 of the Clean Water Act. United States v. Akers, 785 F.2d 814, 816 n.1 (9th Cir. 1986).\\nWe note that additiona...</td>\n",
       "      <td>487</td>\n",
       "      <td>[960846]</td>\n",
       "      <td>[33a4ee7341344732990f4fdc43107a42, 0f2e8a4b0c634aea83c7d2649348abbc, a4e7ce7523a34ccf814e3725500e7c12, fd15c2b2123243deae7b7b0a13fff22e, ed30d6de493944e785f4a477fd0672fe, 8ac57a1e681342d88c8051f06df280cc, 60317f088ab1486cb9aa99a055827aba, c0bc6ea01b384d0aa148f77545a2649d, aaba3b7347e7493986cd07faecf4078d, c539edce4de540afa2942a3f635f2d23, 5c7e2d17ceee45b4b22146f45785885e, 9d0f342db552477b9c5e868c2582c19b, 3607ba0e44f542a2ba51ef372256726b, a4ec2fa742a24eda8df11c0c54826173]</td>\n",
       "      <td>[df2581f38c224d059008d83cb1729c27, b67781325f4e43eda0ddf0f6e52ffc4e, b149a2d568cf4087a1dc3b2ba766d609, 5eda0235c57d404c832f83fe715bfc6e, 438a47540e8a40a7ace2d907a92f208b, c58d5e888aa0438e8b7ed79cb8110ac1, 7caa1c2ec9674b30b518c95dc80473b6, 02c200438b40483d844fa7c2dfeb8a98, b59bf19a3a964a13ac21b0baa8aa3920, 96616af7b2dd4a79aad6caa0771d3c6b]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1742</th>\n",
       "      <td>e8ccdad56b979f9ae69736e62b2d6518</td>\n",
       "      <td>1743</td>\n",
       "      <td>feet in length. It is divided by two parapets which separate the roof into three sections. The first, the west end, was constructed in 1968, consisted of 13,000 square feet, was recoated in 1975 per the terms of the original lease and was reroofed in 1984. The second, the center section, was constructed in 1973, consisted of 24,000 square feet, and was reroofed in August 1986. The third section, the east end, was constructed in 1974, consisted of 13,000 square feet, and was reroofed in August 1986. It was to be used only as a wholesale beverage distributorship unless consent of the lessor was given.\\nWhile examination of the lease language as a whole provides for such a result, a specific provision dealing with hot tar treatment, including time frames, and allocation of responsibility for the same would avoid such problems in the future.</td>\n",
       "      <td>203</td>\n",
       "      <td>[8848167]</td>\n",
       "      <td>[973e932adf324cd2bba0522c1e36732e, ee4890933a04451c9c84978213ef8048, 9c773874c7a8404ba867eefcffb413dc, 5067bd244c064db1bf265d5f58578a94, 31c3527e38b9442f96f41529afacb013, 2fdb83eee7464fdc9c5e4501c704cb42, e8f450b7190c439fa448f4866f220b14, d3fb5a40da8e4f91bb3952741772a5d4, 090184a8dba749e3b2d2b65534602245, dce9d40fc8a34a598af122723d10ade2]</td>\n",
       "      <td>[d3efb3d4785248ea8e4a9555dc5fd596, 87ad6ba5b69244a38a346fc1c2db0421, 35b192bcbbad4d93a3c5b31105108c4b, 681232c41f864732a0bbae407638ffc7, c9327ddebc0743c49884502ad8520c34, 16560b19d0ab4c01a854ab27c62ee3e7, a4105b18e6be412abd773ebc7e93888f, 1cc2786035f74ba1914998a9941d076d, 010eb696ddd94a53825cca2ef9a0503e, ca316799a30342ea8a8ca84bf56fd65b, bf3de1eace8340dd83ecc7f84ec2c44c, 87476b9679c0412e8f1d43551da01f39]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    id  human_readable_id  \\\n",
       "70    cbab760f12d0c219151149f946b96663                 71   \n",
       "95    395a8bbd6e781764bcfb8f3f43abbce4                 96   \n",
       "342   8e6debc663311fb1ef4732852b12643b                343   \n",
       "504   6ceb2b973680d705479e69aebcf50925                505   \n",
       "505   bb5c29be0d2ce6d080ccbce3f4a009a7                506   \n",
       "512   5cb9387d33ef0586c52e9715c5d7c6d8                513   \n",
       "513   27a0933dc7e66aaf06f185f674739090                514   \n",
       "514   0371900a624648f1596be0b34e250f46                515   \n",
       "515   dfc3849bbae95805700699e135079c35                516   \n",
       "516   4d4b330ebbfd95a52f1404a792c7d9d6                517   \n",
       "517   a8ae81a8dbd58bd70f8558c9c99cb6cf                518   \n",
       "518   d508d0487436bf2ef8296cb44b79ae4b                519   \n",
       "519   8a990be2de128cfc6068090fae6cb40d                520   \n",
       "520   9e227e8648a657d5c39d8b23eaf7e225                521   \n",
       "1742  e8ccdad56b979f9ae69736e62b2d6518               1743   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 text  \\\n",
       "70     Postemas claim the water is surface water. Smith, and his expert, claim the water was a natural watercourse. If the water comes from a natural watercourse or through a “natural drain,” the common enemy rule does not apply. The Postemas argue that even if the water were not surface water, they still have no liability because they only directed it through the natural watercourse. This argument is incorrect under case law more recent than Trigg. Only if the waters are determined to be “surface waters” are the Postemas entitled to seek the shield of the common enemy doctrine. The determination of what classification of water is involved is a question for the trier of fact and should not be taken from “the jury.” There are disputed issues of material fact, and summary judgment should not have been granted.\\nAlternatively, even if the Postemas are correct, that these waters are merely surface waters, there also exists a question of material fact as to whether the Postemas’ upstream actions caused a greater dis...   \n",
       "95    Sweeney, C.J.\\nWashington’s unlawful detainer statute (RCW 59.12) authorizes a limited summary proceeding to determine the right to possession of property. Skarperud v. Long, 40 Wn. App. 548, 550, 699 P.2d 786 (1985). Counterclaims and setoffs are generally not permitted in an unlawful detainer action. Skarperud, 40 Wn. App. at 550. A lessee may, however, assert a counterclaim or a setoff, if the lessee’s covenant to pay rent is dependent upon a covenant that the lessor has breached. Skarperud, 40 Wn. App. at 550.\\nThe dispute here centers on a farm development lease. The term of the lease was four years with a right to renew for another four years. The lessee, Keico Industries, Inc. (Keico), developed an irrigated farm during the first four-year term. When Keico failed to make the last rent payment on the first four-year term, the lessors, William D. Heaverlo and Charlotte M. Heaverlo (the Heaverlos), sued for unlawful detainer. Keico counterclaimed contending the Heaverlos had breached a number of coven...   \n",
       "342    in the fact which so far impeaches it as to require the court to say that it was the result of passion and prejudice. Moreover, we do not find' in the record that the estimates of the plaintiffs ’ witnesses were disputed by the other side. There was a leakage from the roof at one time for which the defendants admitted fault, and they offered testimony to the effect that the damage caused thereby did not exceed $50, but on the general question of the amount of damages, the cause went to the jury on the testimony of the plaintiffs ’ witnesses. It would seem that, under these circumstances, the court could hardly find either passion or prejudice had the verdict been for the full amount demanded.\\nThe second contention under this head is that the overwhelming weight of the evidence relating to the cause of the damage is against the verdict of the jury. It is first argued that the building was constructed according to the plans and specifications, and if it was so constructed as not to furnish protection agai...   \n",
       "504   Madsen, J.\\n— This case raises the question whether the Department of Ecology has authority to condition a water quality certification under the Clean Water Act of 1977 (33 U.S.C. §§ 1251-1387) on maintenance of minimum instream flows, where such conditions affect existing water rights. The case also involves issues concerning RCW 90.03.380, the surface water statute governing changes in and transfers of water rights, and issues of abandonment and statutory forfeiture of water rights. We conclude that the Department of Ecology has authority to impose bypass flow conditions in a water quality certification regardless of whether the applicant has existing water rights that may be affected. We also conclude that when acting on change applications under RCW 90.03.380, Ecology may not deny an application based upon public interest considerations, and that the change statute does not apply to inchoate water rights. In addition, we conclude that the water rights at issue were neither abandoned nor forfeited unde...   \n",
       "505    state hydroelectric licensing fees in connection with its 1907 water right. It also paid fees in connection with the 1980 water right, although for a period of years it failed to pay the fees for most of the 440 cfs right, due to a clerical error. In 1998, it informed Ecology about the missing fees and paid the late fees.\\nIn 1992, the District proposed to reestablish power generation. The new Sullivan Creek Project would use the same configuration for the project as the original project, but would be bigger than the original. As noted, in 1994 the District filed the application with the Federal Energy Regulatory Commission to amend its federal license to allow power generation. Because the project requires a federal license, on October 30, 1996, the District filed an application for a state water quality certification with the Department of Ecology (Ecology), as required under the Clean Water Act. On October 28, 1997, Ecology issued an order certifying that the District’s project complies with the act a...   \n",
       "512    development and failed to pay licensing fees, and that under RCW 90.16.060 this is conclusive evidence of abandonment of the water right used or proposed to be used for power development. We do not read RCW 90.16.060 as providing for such abandonment. First, as to payment of fees, the statute states that “the failure to file statement and pay the fees, as herein required, for any power site or claim of power rights on account of riparian ownership within two years after June 12, 1929, shall be conclusive evidence of abandonment.” RCW 90.16.060 (emphasis added). The statute was enacted in 1929 and, evidently, the quoted language was intended to assure that power developers complied with the new act’s provisions in a timely fashion. Nothing in the statute indicates that the abandonment provision applies to the failure to pay fees after 1931. Moreover, the rest of the statute demonstrates that it does not. RCW 90.16.060 also provides that\\n[s]hould any claimant fail or neglect to file such statement within ...   \n",
       "513    511 U.S. at 704 (quoting 33 U.S.C. § 1251(a)). “The act also seeks to attain ‘water quality which provides for the protection and propagation of fish, shellfish, and wildlife.’ ” Id. at 704 (quoting 33 U.S.C. § 1251(a)(2)).\\nUnder § 303 of the Clean Water Act, each state must establish, subject to federal approval, comprehensive water quality standards setting water quality goals for intrastate waters. 33 U.S.C. §§ 1311(b)(1)(C), 1313. 33 U.S.C. § 1313(c)(2)(A) provides that a state water quality standard “shall consist of the designated uses of the navigable waters involved and the water quality criteria for such waters based upon such uses.” Further, state water quality standards must “protect the public health or welfare, enhance the quality of water and serve the purposes of this chapter. Such standards shall be established taking into consideration their use and value for public water supplies, propagation of fish and wildlife, recreational” and other purposes. Id. Section 303 also contains an antid...   \n",
       "514    become a condition on any Federal license or permit subject to the provisions of this section.\\n33 U.S.C. § 1341(d).\\nIn Department of Ecology v. Public Utility District No. 1 of Jefferson County, 121 Wn.2d 179, 849 P.2d 646 (1993) (Elkhorn I) (the decision reviewed in Elkhorn ID, this court addressed the propriety of conditions in a § 401(d) water quality certification that required that the applicants maintain certain minimum instream flows in the Dosewallips River, also classified as AA. The applicants there were a city and a local utility district that wanted to build a dam, and applied for a hydroelectric license from the Federal Energy Regulatory Commission. A § 401 water quality certification was therefore required. The proposed site would reduce streamflow on a stretch of the river between the initial diversion and the place downstream where the water would be returned—the bypass reach—and would adversely affect the salmonid population in that portion of the river.\\nThis court upheld the streamfl...   \n",
       "515    conditions as part of § 401 water quality certification where necessary to enforce a designated use and conform to state and federal antidegradation policies.\\nThe District contends, however, that Elkhorn II does not apply here because the District has existing water rights, unlike the applicants in Elkhorn II. The District argues that in light of § 101(g) (33 U.S.C. § 1251(g)) and § 510(2) (33 U.S.C. § 1370(2)) of the Clean Water Act, deferring to state law on water allocation, a condition that may affect the quantity of water available to one who holds an existing water right must be authorized by state law. There is no such state authorization, in the District’s view. The District also contends that minimum flow requirements cannot be imposed without compliance with procedures set out in chapters 90.22 and 90.54 RCW.\\nWe do not agree that Elkhorn II is distinguishable.\\nIn Elkhorn II, the Court rejected the argument that § 101(g) and § 510(2) of the Clean Water Act excluded regulation of water quantit...   \n",
       "516    Callaway, 392 F. Supp. 685 (D.D.C. 1975) held that the Corps of Engineers, having administrative responsibilities under § 404, had to promulgate regulations concerning all waters of the United States, and not just traditionally navigable waters. Hobbs & Raley, supra, at 846. Concern arose that farming practices, irrigation, and municipal water projects might be barred or restricted by § 404 permitting jurisdiction. Id. at 847. By 1977, a “standoff’ existed between the House and Senate as to the reach of § 404, and Senators Wallop and Hart were key in a series of compromises that became law—among them, § 101(g). Hobbs & Raley, supra, at 853-54.\\nSenator Wallop explained, in addition to the comments quoted above:\\nWater quality and interstate movement is an acceptable Federal role and influence. But the States [sic] historic rights to allocate quantity, and establish priority of usage remains inviolate because of this amendment. The Water Pollution Control Act was designed to protect the quality of water a...   \n",
       "517    him from depositing dredged or fill material into certain waters, channels or wetlands, specified by the Corps of Engineers, without a permit (unless a permit was determined to be unnecessary or he did not receive a timely decision on whether a permit was not required). The farmer built a dike across the wetlands, and he argued the dike was an exempt irrigation facility for purposes of § 404’s dredge and fill permit requirements. He also argued that under § 101(g) the irrigation exemption should be applied so as to avoid impairment or abrogation of his state allocated irrigation rights, which he claimed were rendered virtually meaningless otherwise.\\nThe court disagreed, reasoning that “any incidental effect on [the farmer’s] rights to state-allocated water from [the river] is justified because protection of [the wetlands] is the type of legitimate purpose for which the [Clean Water] Act was intended.” Akers, 785 F.2d at 821. See also Water Works & Sewer Bd. v. United States Dep’t of Army, 983 F. Supp. 1...   \n",
       "518    broad grant of authority, from imposing conditions that may affect an existing water right. This is in sharp contrast to other areas of Ecology’s regulatory authority. See, e.g., RCW 90.03.030; RCW 90.44.040. In this connection, we disagree with the District’s contention that the absence of a savings clause in chapter 90.48 RCW has no significance. The District says that the state Water Pollution Control Act, chapter 90.48 RCW, simply authorizes the “discharge” of material into water that causes or tends to cause pollution, and authorizes cooperation with the federal government under the Clean Water Act. The District maintains that the withdrawal and use of water is not the same as the discharge of pollutant(s) under the state Water Pollution Control Act or the Clean Water Act. Therefore, the District says, neither the Congress nor the Legislature authorized regulation of the use of water under existing water rights.\\nOf course, Elkhorn II clearly holds to the contrary as far as the Clean Water Act is co...   \n",
       "519    change under the statute. We hold that the District’s water rights were not abandoned or statutorily relinquished.\\nFor the reasons stated, the Board’s decisions are affirmed in part and reversed in part.\\nSmith, Johnson, Ireland, Bridge, Chambers, and Owens, JJ., concur.\\nThe certification requires the following instream flows:\\nOctober 1-March 31 75 cfs\\nApril 1-7 100 cfs\\nApril 8-14 140 cfs\\nApril 15-21 160 cfs\\nApril 22-30 200 cfs\\nMay 1-July 31 200 cfs\\nAugust 1-September 1 125 cfs\\nIn re Certification to Pub. Util. Dist. No. 1 of Pend Oreille County, Dep’t of Ecology, Order No. DE 97WQ-E361, at 3 (Wash. Oct. 28, 1997). From May 1 through September 30, the required flows are the lesser of the above flows or the natural flows entering Mill Pond.\\nAn inchoate water right is\\n“an incomplete appropriative right in good standing. It comes into being as the first step provided by law for acquiring an appropriative right is taken. It remains in good standing so long as the requirements of law are being ful...   \n",
       "520   W 90.54.020 was such a state law.\\nThe Court also said that 33 U.S.C. § 1314(f) expressly recognizes that water pollution, may result from changes in movement, flow, or circulation, from dams or other diversions, thus also showing congressional concern with the physical and biological integrity of water. Elkhorn II, 511 U.S. at 719-20.\\nAs the Court said in Elkhorn II, the language in § 101(g) gives a state the authority to allocate water rights, and thus the Court found it “peculiar” that the applicants in Elkhorn II argued that it prevented the state from regulating stream flow. Pub. Util. Dist. No. 1 of Jefferson County v. Wash. Dep’t of Ecology, 511 U.S. 700, 720, 114 S. Ct. 1900, 128 L. Ed. 2d 716 (1994) (Elkhorn II).\\nAs the Ninth Circuit noted, the farmer conceded, for purposes of the case, that portions of his property were wetlands subject to permit requirements, and exemptions, of § 404 of the Clean Water Act. United States v. Akers, 785 F.2d 814, 816 n.1 (9th Cir. 1986).\\nWe note that additiona...   \n",
       "1742                                                                                                                                                                                feet in length. It is divided by two parapets which separate the roof into three sections. The first, the west end, was constructed in 1968, consisted of 13,000 square feet, was recoated in 1975 per the terms of the original lease and was reroofed in 1984. The second, the center section, was constructed in 1973, consisted of 24,000 square feet, and was reroofed in August 1986. The third section, the east end, was constructed in 1974, consisted of 13,000 square feet, and was reroofed in August 1986. It was to be used only as a wholesale beverage distributorship unless consent of the lessor was given.\\nWhile examination of the lease language as a whole provides for such a result, a specific provision dealing with hot tar treatment, including time frames, and allocation of responsibility for the same would avoid such problems in the future.   \n",
       "\n",
       "      n_tokens document_ids  \\\n",
       "70        1200     [255045]   \n",
       "95        1200     [420969]   \n",
       "342       1200     [782330]   \n",
       "504       1200     [960846]   \n",
       "505       1200     [960846]   \n",
       "512       1200     [960846]   \n",
       "513       1200     [960846]   \n",
       "514       1200     [960846]   \n",
       "515       1200     [960846]   \n",
       "516       1200     [960846]   \n",
       "517       1200     [960846]   \n",
       "518       1200     [960846]   \n",
       "519       1200     [960846]   \n",
       "520        487     [960846]   \n",
       "1742       203    [8848167]   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  entity_ids  \\\n",
       "70    [5a87a9196ccf4e399f6bd6db3c7f8a82, 33a4ee7341344732990f4fdc43107a42, acf6469ba0214efb93da633e23de099d, 0a9e2436bba84cf181323a6fe5c9f67d, 3ce07d6ef400488dbbb7d6bc7321d91d, 4e36272e21184f30b2dad88f9961486a, bfe9daf04d944939906cd3f291e11a7b, 75c5227bec0447eda5cd1e572a349fb1, 4346aec80c5d4080a3e40233b3a26d6f, a92cec5ab10b477d9572b9c7e2133425, 990f044726f542f3b0218577272be948, d5e42682c2bf47e687807d0f84004050, bb60b4e0056f4c24835443361f1b0afa, 31f7a94953dd4027a6c03b9ceb07e9fa, a07f9b30952e4f2780292db9fa2699aa, 59cbb3c99f60494391a90bd942673fd1, 85348c3ef4704331b7b635ed0a9f8be7, a4cd7bdfe9454b459b06189385ea9d5c, 1f682015554e49799b8667f394a09e62, 0ee30bd1b545474e80cdc9f4c446b4bf, 0c89d797c8184c769c8295ac228cdc83, 8306ab2031f0415a870cdd650723786a, c41ec86ef9ac4096a77969882cff7d79, 94ea8ec796da43589ab8091f96e903f3, fbcbfb5195d94e8087e23a14417269c8, 8d81e4c881f947d5841ecca5bb70e804, 6f3ec0b465264e688d34fe47f89aef3a]   \n",
       "95                                                                                                                                                                                                                                                                                                                                                                                                                            [973e932adf324cd2bba0522c1e36732e, 3e5754cde3a540e8bb5a612f8f0e8bfd, c02429b83ebf4c7994e6e5717b9e1a9f, 8625a240220641ad897a58dafec89f59, 33a4ee7341344732990f4fdc43107a42, ed27c6e76d714bdfb43d9f1e293a8708, 8f6c479f7c5f4b3f94fdee83e618d775, 7ed8374c4d7648369f0ffb66765c5ecf, 0962b9fd91bb4fffb2069728ec4d7145, 9ce546b7640c4cd2bab4cd2aa1e7a2f2, 78b1aa9a6c4c4ae58ae20d718691819e, 0f2e8a4b0c634aea83c7d2649348abbc, f8050adcbe2249f3987b4a70be16984b, ea5038f3e8ca448c88adb54cd1f1c587, 53c1d720997342c493a3a32e53ccf225]   \n",
       "342                                                                                                                                                                                                                                                                                                                                                                                         [7704fcb505944aeeba16972bd58f7fad, 33a4ee7341344732990f4fdc43107a42, acf6469ba0214efb93da633e23de099d, 48dd98a7e9694e868a18d51afe3dba9d, 1cd321dc3c174397bb2bb05dc189f83a, f25ce65b3bb443268c8339daffe11db2, 82010d56d2d24321a3696114e35e6fe7, 964163716b7b480ea07689d6ce1ac2f8, a8e79d0571f34a8e8d5190c4efcc5a57, ca28d4c0d05b4333933162837ef85669, ee4890933a04451c9c84978213ef8048, 122d549d41f946ddbe0b797bb9e3bd22, 60081fc71c544ce78d4934893dc14957, caa1666576734aa38aa54c95c2915feb, bc264b41054548109687bf389a51aabd, 7dc7091c8e354d56af4ed6e43aae9955]   \n",
       "504   [810db66b3e2c488293adcfc199524f92, e10d2b599ef6495ca9028e5a7707d231, 0f2e8a4b0c634aea83c7d2649348abbc, 2e845bdcfb4d43528c677bbfc4b1d296, f7a30824aa354d1fbcb77257399cd060, 6424c793b0834a869a0e1520e51776d1, 77b3061f18fd42d099b83d9cbc62e4b5, d7f7055fd1844c9b8baeff2083d4c42a, 19a0523b2445422cb7afafd87320cfde, b87e949ae32a4ce08994c9410d025475, ba6cf6f5f0e04616a0e589573af93ba4, 8027607faab8403e8b57c9acac769c8a, 0b7478f001344bad96a79fa3b20a1d8c, 73aff77a7a17420fb34826a5d8fc5823, 40248f92be224d4ab87302012e883bba, a829a1301d2c429d98e038d865948301, 1cba0b9d5920484d90d26291b2341899, 1d2dab12ffe6454eb261910ae6067e6a, 7a1a78fbe1724fd99e5cb3d77e394f39, 8ddf200b6fc44ad7931a2d1b881517e1, 00ee7d0daac7402d8bf77fcefb41baa8, 269c8b0e556740b59e7a0fcbe259f69f, cd9b6baa849545148cab11bd4db12329, 7c662215303a48219d4662067b2f80f1, 57bf024261034d59b31e957fb59599e9, 6e1e886e6de140d6917c87f0ed7c0126, 9152a917cd704bdb90678a0a3f7ee177]   \n",
       "505                                                                                                                                                                                                                                                                                                                     [0de3a0d557ca4b5a9c6668a67ff55150, e10d2b599ef6495ca9028e5a7707d231, 0f2e8a4b0c634aea83c7d2649348abbc, f7a30824aa354d1fbcb77257399cd060, ed30d6de493944e785f4a477fd0672fe, b87e949ae32a4ce08994c9410d025475, 054996a062bf4e3faeb598e59cf69d5d, f38aca2abcaf4af2bf4b9c1654bcf79e, 48531e39e80f4c2788fbc5fb0547e57b, 4705a683213a425d98f2829b49117f73, 8f8efaccbbe344edb3d94d6d9e5b1f74, 68ecb452ebd94b78b5360f658a801fcd, 467c409544604ee2827231573ce75956, b145c9c9e7b04c749c575519df608bb1, dac5620fa0144c4dbe68690ac2cdc35f, 65ae2053fb9a49678f3683c7b9dcef9a, f224726072f243d3891b7ae95c2198fa, 900e9346c4b74b0eafbe7af1f18b5dea]   \n",
       "512                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   [0de3a0d557ca4b5a9c6668a67ff55150, e10d2b599ef6495ca9028e5a7707d231, 0f2e8a4b0c634aea83c7d2649348abbc, ed30d6de493944e785f4a477fd0672fe, 054996a062bf4e3faeb598e59cf69d5d, 36d411750546465bb11748de08cb1ca0, 0557c7b0fd8d470abd74ef778bf5d703, 86e0d706a5fe412a92ef2ffb8d48a598, c8806d42ea954a1da21ff13da96a0cd8, 922bd5652a0146a6b9f7264d28c4a0ac, 705aee711c884543bfdb063b2f5cb6e3]   \n",
       "513                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               [0f2e8a4b0c634aea83c7d2649348abbc, 5309dda8c2de43c6b80590466c9b691e, 568f541aee9846d99416c7b123068e82, b87e949ae32a4ce08994c9410d025475, 054996a062bf4e3faeb598e59cf69d5d, 13796e43d53b4918b5447e4c6eefcabe, 162d32c90bf24a829a2cf1a107f2049e, 67bd894ef20f4690ba6bfd6940c84e16, 5a825a62b2e5424d884867c0943325ad, 46274d4465af4f79bb04d3236f320fa7, d291c450654c40d1961c1640260070f7, 10f31c2e4efb4f62b49706160edfa899, 20dc2bc0fedf41cabd22923ec8f61233]   \n",
       "514                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               [8d81e4c881f947d5841ecca5bb70e804, e10d2b599ef6495ca9028e5a7707d231, 0f2e8a4b0c634aea83c7d2649348abbc, 6424c793b0834a869a0e1520e51776d1, ba6cf6f5f0e04616a0e589573af93ba4, 705aee711c884543bfdb063b2f5cb6e3, 20dc2bc0fedf41cabd22923ec8f61233, 4ac610bad3a74ec897d3d4878e2993e0, a5c31691378042609b58dc813a74cd0c, 417380320b1146e5a6e5af2a621759fb, 03a610f6316241a9b9f0e9ac257aa14e, bb8fe969d98e4b47a688449cb8a80ff5, b1faadc995a6474d9c92435fab163cb6]   \n",
       "515                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               [e10d2b599ef6495ca9028e5a7707d231, 0f2e8a4b0c634aea83c7d2649348abbc, ed30d6de493944e785f4a477fd0672fe, cae5f406c1c54771a4429c1ca6cd9292, 60317f088ab1486cb9aa99a055827aba, ddcce488efae4ebb8382049922585cd9, 2d44683e95944afd847e9895ec8541b3, 33b56fda82f14b3495cddadb21fdd0e1, 58c316b40fbd499aa9a4e2a62a64df62, c2f276b017044ad98175651defb7b53f, 0ecac5102097429ca5247ddd2ef42ac0, 3e90edbf44994ff0b832e71c24e88fc6, 2b47d1bc1a2f4d3780ab0cd33f9f332d]   \n",
       "516                                                                                                                                                                                                                                                 [0f2e8a4b0c634aea83c7d2649348abbc, 14343803142e47e0a43bb8d6550947bb, 13796e43d53b4918b5447e4c6eefcabe, c2f276b017044ad98175651defb7b53f, c058ea1379ad4ebba91d1337938bac6a, 8fde418daeb7474e946a58adce948c8f, 150b84379318481b84e2a5e38c5c2bf9, e432f2e1eb4046f686c9eee684484c71, 0cc1b2b2d0bf415190426480b44e1be6, 49dae3489270471b8ce461600a81b8cb, 446c0d23c400404b929c85e031b08957, 1aa109aa8c8f413aa85c5df520650cd7, 9721c61913754d7d80c28d9d721438e2, a21880220a12456798c4241452e98090, 339bac5eb40f42e5a05d7f18abf4cb51, 6899375426ee43d1a09fc17ac2442700, e435a5ea440640b593dc86c927b928f6, e8d8a563a95c4eeba0b3b3828ab96df2, 1986f12523d8419a91a29d987f646698, 224d14b13ecc48f6b457fbe1db01b418]   \n",
       "517                                                                                                                                                                                                                                                                                                                                                                                                                           [e10d2b599ef6495ca9028e5a7707d231, 0f2e8a4b0c634aea83c7d2649348abbc, a4e7ce7523a34ccf814e3725500e7c12, ed30d6de493944e785f4a477fd0672fe, cc2bf1037a7b4d988280018d3f46d115, 054996a062bf4e3faeb598e59cf69d5d, 4705a683213a425d98f2829b49117f73, 8ac57a1e681342d88c8051f06df280cc, c8806d42ea954a1da21ff13da96a0cd8, 8fde418daeb7474e946a58adce948c8f, c0bc6ea01b384d0aa148f77545a2649d, 0b66c2387e3641998ebe28cdb22f3d76, f52c499aa02847b9aa218a24c2bd96a1, 00daacbbd3ac4889bcbf233e2b00f397, cba57409b0da4756bd46e50ae10acd30]   \n",
       "518                                                                                                                                                                                                                                                                                                                                                                                                                           [9197e0d741d444ee9bbe712483a154b0, e10d2b599ef6495ca9028e5a7707d231, 637f58bf03a04185aef452bbca15e7d6, 0f2e8a4b0c634aea83c7d2649348abbc, ed30d6de493944e785f4a477fd0672fe, 568f541aee9846d99416c7b123068e82, 054996a062bf4e3faeb598e59cf69d5d, 13796e43d53b4918b5447e4c6eefcabe, d291c450654c40d1961c1640260070f7, 00daacbbd3ac4889bcbf233e2b00f397, 71f1b4c52e8d4444afed054fdcd5abc5, cade215a92d544ecbc1b59a4d0001994, 538870f25d004ced989d2adf36d9ea70, 807b3acb67954b03b34b2987014a2491, 604ae2b0c0a84669b04d322f13d6debe]   \n",
       "519                                                                                                                                                                                                                                                                                                                                                                                         [e10d2b599ef6495ca9028e5a7707d231, 8a53b824484c45b1bf85f614e8b9a696, 0f2e8a4b0c634aea83c7d2649348abbc, ed30d6de493944e785f4a477fd0672fe, cae5f406c1c54771a4429c1ca6cd9292, 054996a062bf4e3faeb598e59cf69d5d, 4705a683213a425d98f2829b49117f73, 8ac57a1e681342d88c8051f06df280cc, 012e454018fa4684885cda7e693dac35, a82b65d9505a4b2f975879f8bf64f6f0, 32f641e8a3b44a6a94647bf3fe25b464, c666f2bc58e0406c9f0624ab72b8c05c, 9b2cfee9b821410d949ee86d928beda0, 1ad8d7ba10ac4b7a8736060d8ae6e006, 0f832ff609764255b3b470f98c243114, ae0cfd461d084e4790e50b04d6cef4ac]   \n",
       "520                                                                                                                                                                                                                                                                                                                                                                                                                                                             [33a4ee7341344732990f4fdc43107a42, 0f2e8a4b0c634aea83c7d2649348abbc, a4e7ce7523a34ccf814e3725500e7c12, fd15c2b2123243deae7b7b0a13fff22e, ed30d6de493944e785f4a477fd0672fe, 8ac57a1e681342d88c8051f06df280cc, 60317f088ab1486cb9aa99a055827aba, c0bc6ea01b384d0aa148f77545a2649d, aaba3b7347e7493986cd07faecf4078d, c539edce4de540afa2942a3f635f2d23, 5c7e2d17ceee45b4b22146f45785885e, 9d0f342db552477b9c5e868c2582c19b, 3607ba0e44f542a2ba51ef372256726b, a4ec2fa742a24eda8df11c0c54826173]   \n",
       "1742                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    [973e932adf324cd2bba0522c1e36732e, ee4890933a04451c9c84978213ef8048, 9c773874c7a8404ba867eefcffb413dc, 5067bd244c064db1bf265d5f58578a94, 31c3527e38b9442f96f41529afacb013, 2fdb83eee7464fdc9c5e4501c704cb42, e8f450b7190c439fa448f4866f220b14, d3fb5a40da8e4f91bb3952741772a5d4, 090184a8dba749e3b2d2b65534602245, dce9d40fc8a34a598af122723d10ade2]   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  relationship_ids  \n",
       "70                                                                                                                                                                                                                                                                                                                                                                                                                                                              [32e1cfaec8e04287a8c73bad5a1224ca, 101971e0712645f89f20f837a6583ea7, 80527ee0a69b41cba9b2598baf2282c9, 8827e69a626d44e98f9a2317e83f2d14, f629efebc3004a3c8d2e8a0ff633c3e0, 56076d25a1ce44099c081c44693d3796, 53fbd69f7412401fac435649ccc0ebb7, 91c0777fd84b4d54a79ce549ebca18e7, dda48c7fc84042ffaaa52bb3a715506b]  \n",
       "95                                                                                                                                                                              [079b7fbfaa334716bb60809918d376d0, 16530116c80f45aca289028343d2aa60, 3bfe2ac8373b4050b060109087a7cd01, 3d312750daba40c48c6bdf5f20c550c9, d27ea25223dd44aa850878f04020a37c, 974b7283278f49c88f240df419ef9219, f2b89de15ccf4b9fbffdf324b56a1a29, 0890578054a34cae85241ba23268bc5d, 56f35227b24944d798ae86742b4a7b4b, e346d07474bd415eac6d51844725e0c2, 123b18ee01b74d60b2ffe6703f62e8b3, b46bbd1a3e6c45428a48c8db343731d5, eea255fcab7f430c9c5c3ade31805483, 1266526788844c69ab1960ce0dc9af6a, b47bc57266ce4ae4bd9b63339678f563, 5b4d05c1f9f34440867e881b45b7fed6, b005434809cc44719359b9c15943f914]  \n",
       "342                                                                                                                                                                                                                                                 [be3e40ba9b18482f963a459a13d7c0cc, 7761b38c04164a498e4d153506f8d801, a0271ddbef2e4bb990e3ac8b982e397a, 87f2d7e1657342208456486729a3dc08, cb3689c3cf1e4db985b0e29e811da56b, d9935c26b448443681ff761a0fd253f0, bc7fa57b16534658872ef9fb8974c01f, 247c3738a1344a1c96e01d29f5fc950d, f9c0e3b95a094a03a1fc3494df3061fe, 2035909765d045fab2f65f788bec83c9, 2c8b1fdbf8a24b74a116bd6b6b33cb6b, be72d0dfdd354c3dbe0f6bdd005005b9, ed999131027441e98f419b17b804b5f8, 63e24446694f4f7693fad49b9a26ed43, 841f9b74b303421b81d6d8b9a5a1893b]  \n",
       "504   [b4b3b18ed291403faf3b666ed7858bee, 5d0547b8dcdc43cf821dd0aec568c42d, 443d218214574dc9b60c24e8a712e41e, 1d5194752ffa454b93983a6dc73b063a, 907e1aa736f2412baef5aaf00ec1994b, da7f632c158049fdb2652b1a192fad78, 0a3324bba4a54a3dbe72c13de7e964a6, 584636a013b149c79614e9c9bbf571cc, bce5f2b569ee429bbfe2b66725486c48, ea7b3715ee0a43d1850302de4556fa5f, 9cad155077334a68806e0c4f7405a76f, 76dd6272a8fe481e802ca043faf65bb3, 5b8de4af01654718ae7d0c42cc218058, 0b308a90ebe248de854652859f190b8e, 6bc0beea1195419d976be7f27c08531d, 56dbd5f1929f458b834889e82e62753b, 806048873b9546d0ab4a05da5be92d5e, fa29926f009b4898898ce361e2e15390, f5de71cde8df441e89115fb85a20eee3, 4a1260425a0943508dc644f64c250429, 5b46d43a52564f02a7adf6e91188ac43, f75ebf1660c64a52864834e005df51d8]  \n",
       "505                                                                                                                                                                             [fc197eaf68774eaca17c1f5eca285bf2, 6577ce42be19486b88ff59fd4e15b17a, aaf5685f165840b78ea11dd53548387f, 86612a6767d24f408327325308b2a287, e6a1079e3b774a06a1b95b0748f5b4a7, 1dbceb0b810440348460a033243aedc6, c26bee5440614f79acf56c59bd870d82, 931bc96a8c104d32a827a877706e0732, 6ad410843c9947a998a910f0a34dacb9, f92d0d33dc4e42e99dfcd015b1625097, 9d07672312ee4b50978260647c9cd9d4, cf97da9ccdd94c809481527a787eb5e6, b4f12e154ea2427cb7e9e5356eedf73f, 9b4d0531a4bb40a8a65fb332fe6215a2, ea5c9f7b43b04a3fa2d128ae14d7ee68, 66d7d74f000448dab5befc0a2d636230, 92ee97716de84c468341acfad876c53f]  \n",
       "512                                                                                                                                                                                                                                                                                                                                                                                         [65028418de0742879572881973fd2321, 6577ce42be19486b88ff59fd4e15b17a, ae654565176749ef83a7e455effcf925, 86612a6767d24f408327325308b2a287, 004342fdf77d40818ec9b82bea12a45e, 1dbceb0b810440348460a033243aedc6, 6170b098dc78449daf7fd78a5bf00fb7, 5cbe8323c84e4793904d4f76556f4e62, f990e931b8424360a46ecedb9090ae3b, 4abbf83b9faf4293a61e8dc4abe02e8b, 0110f772c5894a91b81793bfd5abeaa0]  \n",
       "513                                                                                                                                                                                                                                                                                                                     [86612a6767d24f408327325308b2a287, 1cee783db9f54027a3b03f0bb135780a, 00e2cbd6b468404a9623841c9cd4b56f, 9f96f176aae745a38324460b16989c64, 1387b2c084e14a6b93f18897dcacde3a, 3580b42c2bd0409ea1920101af0c4272, f56a59d925a942128503ab95fcecdb2a, fd0d4e342ed44e118ab7b8d466236720, f9b1538ac8b24b579cb2212abd8020bc, d602e73930584cd6abc23b063bf663ee, a61b0d15742d4ef19e2118e8662fa924, b1004812b2dd4d149f37eccfc8a6ab5d, 64053c94ad2a408e9416b42e2db3db7a]  \n",
       "514                                                                                                                                                                                                                                                                                                                     [49e5664da73341019015169f67217992, 65f29a300ca4402c9493cb092ae8fa20, db234c8e96584cfc9cb0848a57df0a67, 9411ff69de4645c0b9b8bfed5d7592e0, 03dade4c9c9b4d6883a2c18b1f962902, 349166e83c3e4910b02fdf069fd3a3fd, 72d8c4d5dc7a46f78eacf6858ad8a89b, eacaee91ee3e4fa4a01edebe90344416, 0d19cb75fb304fdfbbd57e796fa8d61e, 4b861003cb754cc9a79287642dc560f6, da9e1b57651244bda0a0e1ec72aadb92, 5a3ee52c36304dafad113f9014b94396, a9670e0cf030499ca0252c15d920bcaa]  \n",
       "515                                                                                                                                                                                                                                                                                   [ae654565176749ef83a7e455effcf925, 00f07fa34a4b457cb4d4c5ad309cf981, 6b1cd278d03b41ee905069137eeb8b5d, fd2b7c3bee36472bba7af9f067985453, 8c3d4edefddc4eeab7e21511c9811f74, 978b06ee16a34bc3981189e274023c1e, 4573312951444f7bbd9e2c16c47f68b8, f6348e31e8ca4eea821c7c7962f1a5b6, 4807e12ebc594d2f8f229dee36cbca63, 0cb7fc3b60684925a19f2941fa5e28fe, 0736f39fc77345d68cd327daeb09966e, 664f679eb86041c6b26d8a0e47d9ecaf, 2e6eb75a5f584aeb8f893af30897bd04, 1acc6a643ffd4a979a284f25444e1db8]  \n",
       "516                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               [3614a7acb3f24b6d9cfb8b922fd1c019, c668475c9fa1445fbb3e4718d2ecac9d, 5cf2c38a1fbb4697af886d9dd84a024b, e0e7ecaf42c64b7a8d3ceec44eb7cdc6, c738ed3f26044f94a7e12d9ba3ec3d90, 9d8e4001ee0d44af81d0be69646d690e, 1bc02d3e6d094bb2942b7850b44995c4, 6d5211b439b246e3b7f9eb8beb3c05c6]  \n",
       "517                                                                                                                                                                                                                                                 [862459fd048741abbe661b513a85f1ee, 86612a6767d24f408327325308b2a287, 09e35cf611bc44188ab5fb3f5610aed5, c6e8c73bca5641d394fedab078c51d76, 10127cdf700f4cf2bf3bc3b9ba25416b, b149a2d568cf4087a1dc3b2ba766d609, 1dbceb0b810440348460a033243aedc6, 5825b2b9fd974d5e803652e080c6aa76, 30f4de2d01f7405e9653f6304c88d88b, 4abbf83b9faf4293a61e8dc4abe02e8b, 5ecb16ff9e1540f595516eea404a8fdf, 224ab63b070f4e4e98f8abd0d7c774bc, 54f619ee3ca641b69124ed93321e3ccf, 93883bf571d240e383bb23aadaef9ebc, 4dd53806ec5a491599d3c5e4867f2cad]  \n",
       "518                                                                                                                                                                                                                                                                                   [0ba8b63fd8644ef5b23e6f2a2692108c, 6577ce42be19486b88ff59fd4e15b17a, 572b59e352434dcaa2f06d721831105d, 99d4f3906e09469994850331a4848762, 86612a6767d24f408327325308b2a287, 3eb7c97bb16e43028ecbdc0992cf37fb, 1dbceb0b810440348460a033243aedc6, ca1d45baeda448d784603ca947251f49, 6c1f420a9e894c14875e1456ac5615c8, 635a6d6ea3e44ac7b418dbd722345ccd, 981312280e8948efb4270fec3f56b251, cf885b3ac93343d893054d4ff0728e0d, ddee5c52f60544faac6a4a404a23bb72, e460e01848f84594b6af0bad49dc2c74]  \n",
       "519                                                                                                                                                                                                                                                 [aaf5685f165840b78ea11dd53548387f, 00f07fa34a4b457cb4d4c5ad309cf981, 750cdce308344170928490b8e557fa6c, ca5f571dd8504c0cb67cc56aaa55ba45, cbcd2bf6740a4acdb27946aac9e79867, 2d4c47f0e0f548e3b575d2e8e3d02abc, e9ea99444724460abcf48c4efd3aa97f, f3fc15910c04466fb384ddc04f9a3471, 86612a6767d24f408327325308b2a287, 07b8db7c2f354864a7b29664b22d027a, 33e68df4cc9844c3bb45d06d698eea4f, 34d6652c3ff648fb9a6062372b3b3b21, bb11cfd172da4989974d3ce0e29b1a66, 4db880f2a2824bfd984ba989bcd14ab9, 07004983503d4f9cac29024e5fcb011d]  \n",
       "520                                                                                                                                                                                                                                                                                                                                                                                                                           [df2581f38c224d059008d83cb1729c27, b67781325f4e43eda0ddf0f6e52ffc4e, b149a2d568cf4087a1dc3b2ba766d609, 5eda0235c57d404c832f83fe715bfc6e, 438a47540e8a40a7ace2d907a92f208b, c58d5e888aa0438e8b7ed79cb8110ac1, 7caa1c2ec9674b30b518c95dc80473b6, 02c200438b40483d844fa7c2dfeb8a98, b59bf19a3a964a13ac21b0baa8aa3920, 96616af7b2dd4a79aad6caa0771d3c6b]  \n",
       "1742                                                                                                                                                                                                                                                                                                                                                      [d3efb3d4785248ea8e4a9555dc5fd596, 87ad6ba5b69244a38a346fc1c2db0421, 35b192bcbbad4d93a3c5b31105108c4b, 681232c41f864732a0bbae407638ffc7, c9327ddebc0743c49884502ad8520c34, 16560b19d0ab4c01a854ab27c62ee3e7, a4105b18e6be412abd773ebc7e93888f, 1cc2786035f74ba1914998a9941d076d, 010eb696ddd94a53825cca2ef9a0503e, ca316799a30342ea8a8ca84bf56fd65b, bf3de1eace8340dd83ecc7f84ec2c44c, 87476b9679c0412e8f1d43551da01f39]  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "# Use the absolute path to the parquet file in the output directory\n",
    "df = pd.read_parquet('/workspace/graphrag/output/create_final_text_units.parquet')\n",
    "\n",
    "\n",
    "pd.set_option('display.max_colwidth', 1024)  # Display the entire content of cells\n",
    "\n",
    "df['id'] = df['id'].astype(str)\n",
    "# Filter rows where 'human_readable_id' contains a specific substring (example: 'keyword')\n",
    "# filtered_df = df[df['human_readable_id'].str.contains('1176', na=False)]\n",
    "\n",
    "ids_to_filter = ['0371900a624648f1596be0b34e250f46','cbab760f12d0c219151149f946b96663', '0371900a624648f1596be0b34e250f46','27a0933dc7e66aaf06f185f674739090','395a8bbd6e781764bcfb8f3f43abbce4','4d4b330ebbfd95a52f1404a792c7d9d6','5cb9387d33ef0586c52e9715c5d7c6d8','6ceb2b973680d705479e69aebcf50925','8a990be2de128cfc6068090fae6cb40d','9e227e8648a657d5c39d8b23eaf7e225','a8ae81a8dbd58bd70f8558c9c99cb6cf','bb5c29be0d2ce6d080ccbce3f4a009a7','d508d0487436bf2ef8296cb44b79ae4b','dfc3849bbae95805700699e135079c35','8e6debc663311fb1ef4732852b12643b','e8ccdad56b979f9ae69736e62b2d6518']\n",
    "\n",
    "filtered_df = df[df['id'].isin(ids_to_filter)]\n",
    "\n",
    "# Display the filtered DataFrame\n",
    "filtered_df"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": ".venv",
   "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.12.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}