pyoso-quickstart.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "9eb4ee93-7a33-4f2d-81f8-b61701b28593",
   "metadata": {},
   "source": [
    "# Pyoso Quickstart\n",
    "\n",
    "Full getting started with pyoso guide is available here: https://docs.opensource.observer/docs/get-started/python/"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "6c049d8f",
   "metadata": {},
   "outputs": [],
   "source": [
    "#! pip install pyoso"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "279a065a",
   "metadata": {},
   "outputs": [],
   "source": [
    "from dotenv import load_dotenv\n",
    "import os\n",
    "import pandas as pd\n",
    "from pyoso import Client\n",
    "\n",
    "load_dotenv()\n",
    "OSO_API_KEY = os.environ['OSO_API_KEY']\n",
    "client = Client(api_key=OSO_API_KEY)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "12d6651b-7938-4d83-b7b0-4dc86413a188",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Helper function for inserting arrays into queries\n",
    "def stringify(arr):\n",
    "    return \"'\" + \"','\".join(arr) + \"'\""
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fcce678f-09ce-421b-920e-cf725bbdbb66",
   "metadata": {},
   "source": [
    "# Run some initial queries just to explore the models available"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "6035c70b-6382-4af3-9b14-7c1cb489c202",
   "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>model_id</th>\n",
       "      <th>model_name</th>\n",
       "      <th>rendered_sql</th>\n",
       "      <th>rendered_at</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Zw48kKUchaKLlSr0KjRajOVmSS0Wr3uG49i2g6ok3kA=</td>\n",
       "      <td>comments_to_collection_monthly</td>\n",
       "      <td>SELECT\n",
       "  CAST(DATE_PARSE('1970-01-01', '%Y-%m-...</td>\n",
       "      <td>2025-04-01 00:10:20.820</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>jLuZLUhFXdGYrHsF4ME7RzEdKPMuC9l0kflOem1GJag=</td>\n",
       "      <td>comments_to_collection_over_all_time</td>\n",
       "      <td>SELECT\n",
       "  CAST(DATE_PARSE('1970-01-01', '%Y-%m-...</td>\n",
       "      <td>2025-04-01 00:10:53.700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>qFe8XjfH4PtcHagwy8eqByDUn85jXeI7XlZAo1QuxJM=</td>\n",
       "      <td>comments_to_collection_weekly</td>\n",
       "      <td>SELECT\n",
       "  CAST(DATE_PARSE('1970-01-01', '%Y-%m-...</td>\n",
       "      <td>2025-04-01 00:09:07.828</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Fl3ClAyf9fPjiJVnfWyzGfbdQI0ZVCd+YuiLPC2Z5o4=</td>\n",
       "      <td>commits_to_collection_daily</td>\n",
       "      <td>SELECT\n",
       "  CAST(DATE_PARSE('1970-01-01', '%Y-%m-...</td>\n",
       "      <td>2025-04-01 00:09:38.392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>cZjmmYnh4HM6nlj3OZdd7mR2evpBRPswS/xRraP0tAY=</td>\n",
       "      <td>commits_to_collection_monthly</td>\n",
       "      <td>SELECT\n",
       "  CAST(DATE_PARSE('1970-01-01', '%Y-%m-...</td>\n",
       "      <td>2025-04-01 00:10:16.741</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       model_id  \\\n",
       "0  Zw48kKUchaKLlSr0KjRajOVmSS0Wr3uG49i2g6ok3kA=   \n",
       "1  jLuZLUhFXdGYrHsF4ME7RzEdKPMuC9l0kflOem1GJag=   \n",
       "2  qFe8XjfH4PtcHagwy8eqByDUn85jXeI7XlZAo1QuxJM=   \n",
       "3  Fl3ClAyf9fPjiJVnfWyzGfbdQI0ZVCd+YuiLPC2Z5o4=   \n",
       "4  cZjmmYnh4HM6nlj3OZdd7mR2evpBRPswS/xRraP0tAY=   \n",
       "\n",
       "                             model_name  \\\n",
       "0        comments_to_collection_monthly   \n",
       "1  comments_to_collection_over_all_time   \n",
       "2         comments_to_collection_weekly   \n",
       "3           commits_to_collection_daily   \n",
       "4         commits_to_collection_monthly   \n",
       "\n",
       "                                        rendered_sql              rendered_at  \n",
       "0  SELECT\n",
       "  CAST(DATE_PARSE('1970-01-01', '%Y-%m-...  2025-04-01 00:10:20.820  \n",
       "1  SELECT\n",
       "  CAST(DATE_PARSE('1970-01-01', '%Y-%m-...  2025-04-01 00:10:53.700  \n",
       "2  SELECT\n",
       "  CAST(DATE_PARSE('1970-01-01', '%Y-%m-...  2025-04-01 00:09:07.828  \n",
       "3  SELECT\n",
       "  CAST(DATE_PARSE('1970-01-01', '%Y-%m-...  2025-04-01 00:09:38.392  \n",
       "4  SELECT\n",
       "  CAST(DATE_PARSE('1970-01-01', '%Y-%m-...  2025-04-01 00:10:16.741  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get all models currently available on OSO\n",
    "client.to_pandas(\"SELECT * FROM models_v0 LIMIT 5\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "80047c31-30c3-46c0-9fe5-7a2bc345fa98",
   "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>model_id</th>\n",
       "      <th>model_name</th>\n",
       "      <th>rendered_sql</th>\n",
       "      <th>rendered_at</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BrMoDljk10fYeGJO+2vAZhxdZ4c9+ofkb3f52rBeoZo=</td>\n",
       "      <td>event_types_v1</td>\n",
       "      <td>WITH \"all_event_types\" AS (\n",
       "  SELECT\n",
       "    \"int_...</td>\n",
       "      <td>2025-04-01 00:08:51.330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>vrv4YGCvh4se48QJiVctVgDaGhC+J9jAnaJmUPI9AuA=</td>\n",
       "      <td>collections_v1</td>\n",
       "      <td>SELECT\n",
       "  \"collections\".\"collection_id\" AS \"col...</td>\n",
       "      <td>2025-04-01 00:08:50.759</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>/Pgs0Pew5D9hUb+PKtkyXWRb57vCu4H3DZMJQYzcxDo=</td>\n",
       "      <td>artifacts_v1</td>\n",
       "      <td>SELECT\n",
       "  \"int_artifacts\".\"artifact_id\" AS \"art...</td>\n",
       "      <td>2025-04-01 00:08:49.632</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>HwiIdYd+DyWBfLGkM2y+8j7vZrMw9Ik0zzTQQHYh/4g=</td>\n",
       "      <td>artifacts_by_collection_v1</td>\n",
       "      <td>SELECT\n",
       "  \"int_artifacts_by_collection\".\"artifa...</td>\n",
       "      <td>2025-04-01 00:08:48.762</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>O0RnB9Fs+aOrKFnhvZ6TaI1YS8EiJf3jRNcJw2KdxZY=</td>\n",
       "      <td>artifacts_by_project_v1</td>\n",
       "      <td>SELECT\n",
       "  \"int_artifacts_by_project\".\"artifact_...</td>\n",
       "      <td>2025-04-01 00:08:49.911</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>cUe+fAo19qp+FCWtmTEIMjjyXKck+8w+mc6CqbrjZsQ=</td>\n",
       "      <td>projects_v1</td>\n",
       "      <td>SELECT\n",
       "  \"projects\".\"project_id\" AS \"project_i...</td>\n",
       "      <td>2025-04-01 00:08:50.206</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>laADUO2JV1w7TAV3IQHXK/01Vgir5FdBmSjqXy1jNew=</td>\n",
       "      <td>projects_by_collection_v1</td>\n",
       "      <td>SELECT\n",
       "  \"projects_by_collection\".\"project_id\"...</td>\n",
       "      <td>2025-04-01 00:08:49.354</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       model_id                  model_name  \\\n",
       "0  BrMoDljk10fYeGJO+2vAZhxdZ4c9+ofkb3f52rBeoZo=              event_types_v1   \n",
       "1  vrv4YGCvh4se48QJiVctVgDaGhC+J9jAnaJmUPI9AuA=              collections_v1   \n",
       "2  /Pgs0Pew5D9hUb+PKtkyXWRb57vCu4H3DZMJQYzcxDo=                artifacts_v1   \n",
       "3  HwiIdYd+DyWBfLGkM2y+8j7vZrMw9Ik0zzTQQHYh/4g=  artifacts_by_collection_v1   \n",
       "4  O0RnB9Fs+aOrKFnhvZ6TaI1YS8EiJf3jRNcJw2KdxZY=     artifacts_by_project_v1   \n",
       "5  cUe+fAo19qp+FCWtmTEIMjjyXKck+8w+mc6CqbrjZsQ=                 projects_v1   \n",
       "6  laADUO2JV1w7TAV3IQHXK/01Vgir5FdBmSjqXy1jNew=   projects_by_collection_v1   \n",
       "\n",
       "                                        rendered_sql              rendered_at  \n",
       "0  WITH \"all_event_types\" AS (\n",
       "  SELECT\n",
       "    \"int_...  2025-04-01 00:08:51.330  \n",
       "1  SELECT\n",
       "  \"collections\".\"collection_id\" AS \"col...  2025-04-01 00:08:50.759  \n",
       "2  SELECT\n",
       "  \"int_artifacts\".\"artifact_id\" AS \"art...  2025-04-01 00:08:49.632  \n",
       "3  SELECT\n",
       "  \"int_artifacts_by_collection\".\"artifa...  2025-04-01 00:08:48.762  \n",
       "4  SELECT\n",
       "  \"int_artifacts_by_project\".\"artifact_...  2025-04-01 00:08:49.911  \n",
       "5  SELECT\n",
       "  \"projects\".\"project_id\" AS \"project_i...  2025-04-01 00:08:50.206  \n",
       "6  SELECT\n",
       "  \"projects_by_collection\".\"project_id\"...  2025-04-01 00:08:49.354  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get the list of v1 (stable) production models\n",
    "client.to_pandas(\"SELECT * FROM models_v0 WHERE model_name LIKE '%_v1'\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "08fc5ef4-6080-4ad8-a602-b4694ea43fec",
   "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>model_id</th>\n",
       "      <th>model_name</th>\n",
       "      <th>rendered_sql</th>\n",
       "      <th>rendered_at</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>iCIIbZt/5rFkvFBb6ddgZEpOxg8ZKAjTgpJVuKptsIU=</td>\n",
       "      <td>contracts_v0</td>\n",
       "      <td>SELECT\n",
       "  CAST(DATE_TRUNC('DAY', \"int_contracts...</td>\n",
       "      <td>2025-04-01 00:08:50.480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>XIANu9uAuvHsb70FOWyUPeiRb2lHqUm4wtrsb6fKoPw=</td>\n",
       "      <td>package_owners_v0</td>\n",
       "      <td>SELECT DISTINCT\n",
       "  \"int_sbom_artifacts\".\"packag...</td>\n",
       "      <td>2025-04-01 00:08:49.051</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>PjBFaVMj8VuaIVo6YhuoN8R4NOOOned067UvHxFWOIo=</td>\n",
       "      <td>sboms_v0</td>\n",
       "      <td>SELECT DISTINCT\n",
       "  \"int_sbom_artifacts\".\"projec...</td>\n",
       "      <td>2025-04-01 00:08:51.040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>j++/Nb5HJcjMwW2AXVjRJry2Tldg59p199UqHHTXuV4=</td>\n",
       "      <td>timeseries_metrics_by_artifact_v0</td>\n",
       "      <td>WITH \"all_key_metrics_by_artifact\" AS (\n",
       "  SELE...</td>\n",
       "      <td>2025-04-01 00:08:48.112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>E43QKNjOJMJb8SgW9GXT7BnnzVotJuDN4A8bbrVSqhU=</td>\n",
       "      <td>timeseries_metrics_by_collection_v0</td>\n",
       "      <td>WITH \"all_key_metrics_by_collection\" AS (\n",
       "  SE...</td>\n",
       "      <td>2025-04-01 00:08:47.138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Y9FZAHn+jE/tsXyT8u7y6JGlI69rTziq/s2QmBYhTVU=</td>\n",
       "      <td>timeseries_metrics_by_project_v0</td>\n",
       "      <td>WITH \"all_key_metrics_by_project\" AS (\n",
       "  SELEC...</td>\n",
       "      <td>2025-04-01 00:08:46.815</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>HcyIHvfuUK4U5OPz/Hrj1lUCSFiLNtCFuJbU9M5npy4=</td>\n",
       "      <td>models_v0</td>\n",
       "      <td>WITH \"all_timeseries_metrics_by_project\" AS (\n",
       "...</td>\n",
       "      <td>2025-04-01 00:08:52.372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>IuQzTFMd110cMq6Iu7HsnQJBk8iMVRBgT6+LUgHtMsM=</td>\n",
       "      <td>key_metrics_by_artifact_v0</td>\n",
       "      <td>WITH \"key_metrics_by_artifact_v0_no_casting\" A...</td>\n",
       "      <td>2025-04-01 00:08:47.793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>I+AOCpwQiEnj6MuoN6aCFjTP+4VwKgbiPMQbkulHY5Y=</td>\n",
       "      <td>key_metrics_by_collection_v0</td>\n",
       "      <td>WITH \"key_metrics_by_collection_v0_no_casting\"...</td>\n",
       "      <td>2025-04-01 00:08:46.204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>S4WOODykLnm2K50r7scrusXdV47UBfFezfOkOzVXvGs=</td>\n",
       "      <td>key_metrics_by_project_v0</td>\n",
       "      <td>WITH \"key_metrics_by_project_v0_no_casting\" AS...</td>\n",
       "      <td>2025-04-01 00:08:46.501</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>nvV9CbM+w8wC2xfT9mS0uDbhE0fZBMUwpVGYJBFHr5s=</td>\n",
       "      <td>timeseries_events_by_artifact_v0</td>\n",
       "      <td>SELECT\n",
       "  \"int_events\".\"time\" AS \"time\",\n",
       "  \"int...</td>\n",
       "      <td>2025-03-27 22:03:31.519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>WUygDRNOE9wdvYtgHZwX0Wblsbe5A5zgYCUj0QUFrkY=</td>\n",
       "      <td>metrics_v0</td>\n",
       "      <td>/* TODO: We currenly hardcode a set of key met...</td>\n",
       "      <td>2025-04-01 00:08:47.490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>rLA15+4rZ/nqT/v+8krO2tgWSoH9TgmGb91CQHRqvt0=</td>\n",
       "      <td>repositories_v0</td>\n",
       "      <td>SELECT\n",
       "  \"int_repositories\".\"project_id\" AS \"p...</td>\n",
       "      <td>2025-04-01 00:08:48.427</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        model_id  \\\n",
       "0   iCIIbZt/5rFkvFBb6ddgZEpOxg8ZKAjTgpJVuKptsIU=   \n",
       "1   XIANu9uAuvHsb70FOWyUPeiRb2lHqUm4wtrsb6fKoPw=   \n",
       "2   PjBFaVMj8VuaIVo6YhuoN8R4NOOOned067UvHxFWOIo=   \n",
       "3   j++/Nb5HJcjMwW2AXVjRJry2Tldg59p199UqHHTXuV4=   \n",
       "4   E43QKNjOJMJb8SgW9GXT7BnnzVotJuDN4A8bbrVSqhU=   \n",
       "5   Y9FZAHn+jE/tsXyT8u7y6JGlI69rTziq/s2QmBYhTVU=   \n",
       "6   HcyIHvfuUK4U5OPz/Hrj1lUCSFiLNtCFuJbU9M5npy4=   \n",
       "7   IuQzTFMd110cMq6Iu7HsnQJBk8iMVRBgT6+LUgHtMsM=   \n",
       "8   I+AOCpwQiEnj6MuoN6aCFjTP+4VwKgbiPMQbkulHY5Y=   \n",
       "9   S4WOODykLnm2K50r7scrusXdV47UBfFezfOkOzVXvGs=   \n",
       "10  nvV9CbM+w8wC2xfT9mS0uDbhE0fZBMUwpVGYJBFHr5s=   \n",
       "11  WUygDRNOE9wdvYtgHZwX0Wblsbe5A5zgYCUj0QUFrkY=   \n",
       "12  rLA15+4rZ/nqT/v+8krO2tgWSoH9TgmGb91CQHRqvt0=   \n",
       "\n",
       "                             model_name  \\\n",
       "0                          contracts_v0   \n",
       "1                     package_owners_v0   \n",
       "2                              sboms_v0   \n",
       "3     timeseries_metrics_by_artifact_v0   \n",
       "4   timeseries_metrics_by_collection_v0   \n",
       "5      timeseries_metrics_by_project_v0   \n",
       "6                             models_v0   \n",
       "7            key_metrics_by_artifact_v0   \n",
       "8          key_metrics_by_collection_v0   \n",
       "9             key_metrics_by_project_v0   \n",
       "10     timeseries_events_by_artifact_v0   \n",
       "11                           metrics_v0   \n",
       "12                      repositories_v0   \n",
       "\n",
       "                                         rendered_sql              rendered_at  \n",
       "0   SELECT\n",
       "  CAST(DATE_TRUNC('DAY', \"int_contracts...  2025-04-01 00:08:50.480  \n",
       "1   SELECT DISTINCT\n",
       "  \"int_sbom_artifacts\".\"packag...  2025-04-01 00:08:49.051  \n",
       "2   SELECT DISTINCT\n",
       "  \"int_sbom_artifacts\".\"projec...  2025-04-01 00:08:51.040  \n",
       "3   WITH \"all_key_metrics_by_artifact\" AS (\n",
       "  SELE...  2025-04-01 00:08:48.112  \n",
       "4   WITH \"all_key_metrics_by_collection\" AS (\n",
       "  SE...  2025-04-01 00:08:47.138  \n",
       "5   WITH \"all_key_metrics_by_project\" AS (\n",
       "  SELEC...  2025-04-01 00:08:46.815  \n",
       "6   WITH \"all_timeseries_metrics_by_project\" AS (\n",
       "...  2025-04-01 00:08:52.372  \n",
       "7   WITH \"key_metrics_by_artifact_v0_no_casting\" A...  2025-04-01 00:08:47.793  \n",
       "8   WITH \"key_metrics_by_collection_v0_no_casting\"...  2025-04-01 00:08:46.204  \n",
       "9   WITH \"key_metrics_by_project_v0_no_casting\" AS...  2025-04-01 00:08:46.501  \n",
       "10  SELECT\n",
       "  \"int_events\".\"time\" AS \"time\",\n",
       "  \"int...  2025-03-27 22:03:31.519  \n",
       "11  /* TODO: We currenly hardcode a set of key met...  2025-04-01 00:08:47.490  \n",
       "12  SELECT\n",
       "  \"int_repositories\".\"project_id\" AS \"p...  2025-04-01 00:08:48.427  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get the list of v0 (less stable) production models\n",
    "client.to_pandas(\"SELECT * FROM models_v0 WHERE model_name LIKE '%_v0'\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e815cfb5-86b3-4c26-ac00-c8295d5be289",
   "metadata": {},
   "source": [
    "# Perform some queries on popular models"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "2cc5409b-0f11-483a-a1cf-fa986440caec",
   "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>project_id</th>\n",
       "      <th>project_source</th>\n",
       "      <th>project_namespace</th>\n",
       "      <th>project_name</th>\n",
       "      <th>display_name</th>\n",
       "      <th>description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9IEEBEDRzDEF7PSu59Pff6ZOhdBtP/8vQPZkRjft9+o=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>peternator7</td>\n",
       "      <td>Peter Glotfelty</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>FozKDbR9ETur69otAweoi9kIGKCejARzPhElzEjzKIo=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>pristorage-manhnvan</td>\n",
       "      <td>Pristorage</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ETTIwZYupJJehgNu2CkKgbcBGFZ8/RWQmciTA52WRVU=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>plantoids</td>\n",
       "      <td>plantoids</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ceJl36Oz36IUC81YqNHxAeTh29lGtA0HMsyl+kpHSJk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>princeton-blockchain-club</td>\n",
       "      <td>Princeton-Blockchain-Club</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>LNiZlYbnClURltqN0bCewAuqXaYdB+pZ4VWUpy3UZRI=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>protolambda</td>\n",
       "      <td>protolambda</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     project_id project_source  \\\n",
       "0  9IEEBEDRzDEF7PSu59Pff6ZOhdBtP/8vQPZkRjft9+o=  OSS_DIRECTORY   \n",
       "1  FozKDbR9ETur69otAweoi9kIGKCejARzPhElzEjzKIo=  OSS_DIRECTORY   \n",
       "2  ETTIwZYupJJehgNu2CkKgbcBGFZ8/RWQmciTA52WRVU=  OSS_DIRECTORY   \n",
       "3  ceJl36Oz36IUC81YqNHxAeTh29lGtA0HMsyl+kpHSJk=  OSS_DIRECTORY   \n",
       "4  LNiZlYbnClURltqN0bCewAuqXaYdB+pZ4VWUpy3UZRI=  OSS_DIRECTORY   \n",
       "\n",
       "  project_namespace               project_name               display_name  \\\n",
       "0               oso                peternator7            Peter Glotfelty   \n",
       "1               oso        pristorage-manhnvan                 Pristorage   \n",
       "2               oso                  plantoids                  plantoids   \n",
       "3               oso  princeton-blockchain-club  Princeton-Blockchain-Club   \n",
       "4               oso                protolambda                protolambda   \n",
       "\n",
       "  description  \n",
       "0        None  \n",
       "1        None  \n",
       "2        None  \n",
       "3        None  \n",
       "4        None  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get a list of projects\n",
    "client.to_pandas(\"SELECT * FROM projects_v1 LIMIT 5\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "ec2c5455-574b-4367-bb47-277b6089c645",
   "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>project_id</th>\n",
       "      <th>project_source</th>\n",
       "      <th>project_namespace</th>\n",
       "      <th>project_name</th>\n",
       "      <th>display_name</th>\n",
       "      <th>description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>opensource-observer</td>\n",
       "      <td>Open Source Observer</td>\n",
       "      <td>Open Source Observer is a free analytics suite...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     project_id project_source  \\\n",
       "0  UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=  OSS_DIRECTORY   \n",
       "\n",
       "  project_namespace         project_name          display_name  \\\n",
       "0               oso  opensource-observer  Open Source Observer   \n",
       "\n",
       "                                         description  \n",
       "0  Open Source Observer is a free analytics suite...  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Lookup a specific project\n",
    "client.to_pandas(\"SELECT * FROM projects_v1 WHERE project_name = 'opensource-observer'\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "6b4ad8d2-0221-4d32-8df9-d7b3f887e75c",
   "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>artifact_id</th>\n",
       "      <th>artifact_source_id</th>\n",
       "      <th>artifact_source</th>\n",
       "      <th>artifact_namespace</th>\n",
       "      <th>artifact_name</th>\n",
       "      <th>project_id</th>\n",
       "      <th>project_source</th>\n",
       "      <th>project_namespace</th>\n",
       "      <th>project_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>MJebS0B8hfqvMuF1Xp43dlR4WB5TzCyCaZ8YArOlgsk=</td>\n",
       "      <td>851248585</td>\n",
       "      <td>GITHUB</td>\n",
       "      <td>opensource-observer</td>\n",
       "      <td>sqlglot</td>\n",
       "      <td>UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>opensource-observer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>tKRIuyyc4i0/9guvlfd6uUwX9DQNCv4ol0Wtu9EGj/M=</td>\n",
       "      <td>700906634</td>\n",
       "      <td>GITHUB</td>\n",
       "      <td>opensource-observer</td>\n",
       "      <td>insights</td>\n",
       "      <td>UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>opensource-observer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BveKFTOec1N8fHTPwhfKacYMJyfW9PYwqicfOnNriDw=</td>\n",
       "      <td>829525979</td>\n",
       "      <td>GITHUB</td>\n",
       "      <td>opensource-observer</td>\n",
       "      <td>private-ops</td>\n",
       "      <td>UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>opensource-observer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>HO3Xu1wCW8uOiPnGk+V8q6mEdNXL8/8YHlyWUZQiJwA=</td>\n",
       "      <td>869660673</td>\n",
       "      <td>GITHUB</td>\n",
       "      <td>opensource-observer</td>\n",
       "      <td>awesome-oso</td>\n",
       "      <td>UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>opensource-observer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>XGpq2zZsHiZbRLrEYibeOVMdBnNoWBTZalaRn9egwhI=</td>\n",
       "      <td>670784638</td>\n",
       "      <td>GITHUB</td>\n",
       "      <td>opensource-observer</td>\n",
       "      <td>oso</td>\n",
       "      <td>UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>opensource-observer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>+kHbCsQ9F0FYxQgc8CM6oFljY1du1Ih4j8dMN4WuRsc=</td>\n",
       "      <td>847960284</td>\n",
       "      <td>GITHUB</td>\n",
       "      <td>opensource-observer</td>\n",
       "      <td>dagster-sqlmesh</td>\n",
       "      <td>UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>opensource-observer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>wAFCEJNQ4YPrs2Ev+DYUMM2/1DMT0Q1Zxa7aR1nWd1M=</td>\n",
       "      <td>875108565</td>\n",
       "      <td>GITHUB</td>\n",
       "      <td>opensource-observer</td>\n",
       "      <td>ethglobal-sf-2024</td>\n",
       "      <td>UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>opensource-observer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>qYYB+4a+C+oGOB7l95yynPNtz8i6qaZGo5UdSObuhJc=</td>\n",
       "      <td>702906083</td>\n",
       "      <td>GITHUB</td>\n",
       "      <td>opensource-observer</td>\n",
       "      <td>test-public-repo</td>\n",
       "      <td>UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>opensource-observer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>n+w2E3FSHG9x1TW0toVZwe/oPUBV/2JMhGlZy01yCG8=</td>\n",
       "      <td>853557673</td>\n",
       "      <td>GITHUB</td>\n",
       "      <td>opensource-observer</td>\n",
       "      <td>kariba</td>\n",
       "      <td>UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>opensource-observer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>RFQVW7NouLnUiz9/9Fw7eAEv+vMSjBBtZrysbU/5vqk=</td>\n",
       "      <td>767826012</td>\n",
       "      <td>GITHUB</td>\n",
       "      <td>opensource-observer</td>\n",
       "      <td>oss-funding</td>\n",
       "      <td>UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>opensource-observer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>eWYS0GBsDdv0dsqDdhw3YPDO+E+ZrwWtikZ8LR+kM1M=</td>\n",
       "      <td>https://www.npmjs.com/package/oss-directory</td>\n",
       "      <td>NPM</td>\n",
       "      <td>oss-directory</td>\n",
       "      <td>oss-directory</td>\n",
       "      <td>UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>opensource-observer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>z86u3/zIu/AtsRao0Z6K5q55Ewq/Wfxysxm4Vkzaqc0=</td>\n",
       "      <td>815095686</td>\n",
       "      <td>GITHUB</td>\n",
       "      <td>opensource-observer</td>\n",
       "      <td>cloudflare-operator</td>\n",
       "      <td>UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>opensource-observer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>5pOzM/Vf333i7MXjJRSjfpticpmY4uK16uDDyFhjP+w=</td>\n",
       "      <td>0xc5bfce27e0e7a7d7731bc23b92ebc62b9ed63b83</td>\n",
       "      <td>OPTIMISM</td>\n",
       "      <td></td>\n",
       "      <td>0xc5bfce27e0e7a7d7731bc23b92ebc62b9ed63b83</td>\n",
       "      <td>UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>opensource-observer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>qcp0dMYhDHj8NJewqbVDcXQHRQ+jdWWfVq1DPO466vw=</td>\n",
       "      <td>674006860</td>\n",
       "      <td>GITHUB</td>\n",
       "      <td>opensource-observer</td>\n",
       "      <td>oss-directory</td>\n",
       "      <td>UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>opensource-observer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>bmCOWRTvl+RlRfThBeItWAFaRKGudgmN/TjJB6lxwMk=</td>\n",
       "      <td>788040652</td>\n",
       "      <td>GITHUB</td>\n",
       "      <td>opensource-observer</td>\n",
       "      <td>tap-airbyte-wrapper</td>\n",
       "      <td>UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>opensource-observer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>TjNKy/ib7R/sKbP6qiaQryccps8OGhOzwd/bPv0vFGg=</td>\n",
       "      <td>0x5cbd6362e6f222d2a0feb89f32566ebd27091b98</td>\n",
       "      <td>ARBITRUM_ONE</td>\n",
       "      <td></td>\n",
       "      <td>0x5cbd6362e6f222d2a0feb89f32566ebd27091b98</td>\n",
       "      <td>UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>opensource-observer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>AqkkwtnE4/QUxYE7wZYEnbNSygb5X4uTtgJbfAyHzRk=</td>\n",
       "      <td>https://www.opensource.observer</td>\n",
       "      <td>WWW</td>\n",
       "      <td></td>\n",
       "      <td>https://www.opensource.observer</td>\n",
       "      <td>UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>opensource-observer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>9lovDXgpOYColaDEPutzlicaQT6HkP3d9S0jpVl3hi0=</td>\n",
       "      <td>0x06d5d71b8b35ea1eecb09522b34d2e8d2bb33e6c</td>\n",
       "      <td>MAINNET</td>\n",
       "      <td></td>\n",
       "      <td>0x06d5d71b8b35ea1eecb09522b34d2e8d2bb33e6c</td>\n",
       "      <td>UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>opensource-observer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>BjN7QqnonvKTirjKBt6L/pNiZbx6Epb0HN44Cymg2Sg=</td>\n",
       "      <td>0x87feed6162cb7dfe6b62f64366742349bf4d1b05</td>\n",
       "      <td>ANY_EVM</td>\n",
       "      <td></td>\n",
       "      <td>0x87feed6162cb7dfe6b62f64366742349bf4d1b05</td>\n",
       "      <td>UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>opensource-observer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>kkCk4QuYCw0RldItqoBee7ccO0S9lsrZ/wgI4vGxKL4=</td>\n",
       "      <td>850138299</td>\n",
       "      <td>GITHUB</td>\n",
       "      <td>opensource-observer</td>\n",
       "      <td>sqlmesh</td>\n",
       "      <td>UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=</td>\n",
       "      <td>OSS_DIRECTORY</td>\n",
       "      <td>oso</td>\n",
       "      <td>opensource-observer</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     artifact_id  \\\n",
       "0   MJebS0B8hfqvMuF1Xp43dlR4WB5TzCyCaZ8YArOlgsk=   \n",
       "1   tKRIuyyc4i0/9guvlfd6uUwX9DQNCv4ol0Wtu9EGj/M=   \n",
       "2   BveKFTOec1N8fHTPwhfKacYMJyfW9PYwqicfOnNriDw=   \n",
       "3   HO3Xu1wCW8uOiPnGk+V8q6mEdNXL8/8YHlyWUZQiJwA=   \n",
       "4   XGpq2zZsHiZbRLrEYibeOVMdBnNoWBTZalaRn9egwhI=   \n",
       "5   +kHbCsQ9F0FYxQgc8CM6oFljY1du1Ih4j8dMN4WuRsc=   \n",
       "6   wAFCEJNQ4YPrs2Ev+DYUMM2/1DMT0Q1Zxa7aR1nWd1M=   \n",
       "7   qYYB+4a+C+oGOB7l95yynPNtz8i6qaZGo5UdSObuhJc=   \n",
       "8   n+w2E3FSHG9x1TW0toVZwe/oPUBV/2JMhGlZy01yCG8=   \n",
       "9   RFQVW7NouLnUiz9/9Fw7eAEv+vMSjBBtZrysbU/5vqk=   \n",
       "10  eWYS0GBsDdv0dsqDdhw3YPDO+E+ZrwWtikZ8LR+kM1M=   \n",
       "11  z86u3/zIu/AtsRao0Z6K5q55Ewq/Wfxysxm4Vkzaqc0=   \n",
       "12  5pOzM/Vf333i7MXjJRSjfpticpmY4uK16uDDyFhjP+w=   \n",
       "13  qcp0dMYhDHj8NJewqbVDcXQHRQ+jdWWfVq1DPO466vw=   \n",
       "14  bmCOWRTvl+RlRfThBeItWAFaRKGudgmN/TjJB6lxwMk=   \n",
       "15  TjNKy/ib7R/sKbP6qiaQryccps8OGhOzwd/bPv0vFGg=   \n",
       "16  AqkkwtnE4/QUxYE7wZYEnbNSygb5X4uTtgJbfAyHzRk=   \n",
       "17  9lovDXgpOYColaDEPutzlicaQT6HkP3d9S0jpVl3hi0=   \n",
       "18  BjN7QqnonvKTirjKBt6L/pNiZbx6Epb0HN44Cymg2Sg=   \n",
       "19  kkCk4QuYCw0RldItqoBee7ccO0S9lsrZ/wgI4vGxKL4=   \n",
       "\n",
       "                             artifact_source_id artifact_source  \\\n",
       "0                                     851248585          GITHUB   \n",
       "1                                     700906634          GITHUB   \n",
       "2                                     829525979          GITHUB   \n",
       "3                                     869660673          GITHUB   \n",
       "4                                     670784638          GITHUB   \n",
       "5                                     847960284          GITHUB   \n",
       "6                                     875108565          GITHUB   \n",
       "7                                     702906083          GITHUB   \n",
       "8                                     853557673          GITHUB   \n",
       "9                                     767826012          GITHUB   \n",
       "10  https://www.npmjs.com/package/oss-directory             NPM   \n",
       "11                                    815095686          GITHUB   \n",
       "12   0xc5bfce27e0e7a7d7731bc23b92ebc62b9ed63b83        OPTIMISM   \n",
       "13                                    674006860          GITHUB   \n",
       "14                                    788040652          GITHUB   \n",
       "15   0x5cbd6362e6f222d2a0feb89f32566ebd27091b98    ARBITRUM_ONE   \n",
       "16              https://www.opensource.observer             WWW   \n",
       "17   0x06d5d71b8b35ea1eecb09522b34d2e8d2bb33e6c         MAINNET   \n",
       "18   0x87feed6162cb7dfe6b62f64366742349bf4d1b05         ANY_EVM   \n",
       "19                                    850138299          GITHUB   \n",
       "\n",
       "     artifact_namespace                               artifact_name  \\\n",
       "0   opensource-observer                                     sqlglot   \n",
       "1   opensource-observer                                    insights   \n",
       "2   opensource-observer                                 private-ops   \n",
       "3   opensource-observer                                 awesome-oso   \n",
       "4   opensource-observer                                         oso   \n",
       "5   opensource-observer                             dagster-sqlmesh   \n",
       "6   opensource-observer                           ethglobal-sf-2024   \n",
       "7   opensource-observer                            test-public-repo   \n",
       "8   opensource-observer                                      kariba   \n",
       "9   opensource-observer                                 oss-funding   \n",
       "10        oss-directory                               oss-directory   \n",
       "11  opensource-observer                         cloudflare-operator   \n",
       "12                       0xc5bfce27e0e7a7d7731bc23b92ebc62b9ed63b83   \n",
       "13  opensource-observer                               oss-directory   \n",
       "14  opensource-observer                         tap-airbyte-wrapper   \n",
       "15                       0x5cbd6362e6f222d2a0feb89f32566ebd27091b98   \n",
       "16                                  https://www.opensource.observer   \n",
       "17                       0x06d5d71b8b35ea1eecb09522b34d2e8d2bb33e6c   \n",
       "18                       0x87feed6162cb7dfe6b62f64366742349bf4d1b05   \n",
       "19  opensource-observer                                     sqlmesh   \n",
       "\n",
       "                                      project_id project_source  \\\n",
       "0   UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=  OSS_DIRECTORY   \n",
       "1   UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=  OSS_DIRECTORY   \n",
       "2   UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=  OSS_DIRECTORY   \n",
       "3   UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=  OSS_DIRECTORY   \n",
       "4   UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=  OSS_DIRECTORY   \n",
       "5   UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=  OSS_DIRECTORY   \n",
       "6   UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=  OSS_DIRECTORY   \n",
       "7   UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=  OSS_DIRECTORY   \n",
       "8   UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=  OSS_DIRECTORY   \n",
       "9   UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=  OSS_DIRECTORY   \n",
       "10  UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=  OSS_DIRECTORY   \n",
       "11  UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=  OSS_DIRECTORY   \n",
       "12  UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=  OSS_DIRECTORY   \n",
       "13  UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=  OSS_DIRECTORY   \n",
       "14  UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=  OSS_DIRECTORY   \n",
       "15  UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=  OSS_DIRECTORY   \n",
       "16  UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=  OSS_DIRECTORY   \n",
       "17  UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=  OSS_DIRECTORY   \n",
       "18  UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=  OSS_DIRECTORY   \n",
       "19  UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk=  OSS_DIRECTORY   \n",
       "\n",
       "   project_namespace         project_name  \n",
       "0                oso  opensource-observer  \n",
       "1                oso  opensource-observer  \n",
       "2                oso  opensource-observer  \n",
       "3                oso  opensource-observer  \n",
       "4                oso  opensource-observer  \n",
       "5                oso  opensource-observer  \n",
       "6                oso  opensource-observer  \n",
       "7                oso  opensource-observer  \n",
       "8                oso  opensource-observer  \n",
       "9                oso  opensource-observer  \n",
       "10               oso  opensource-observer  \n",
       "11               oso  opensource-observer  \n",
       "12               oso  opensource-observer  \n",
       "13               oso  opensource-observer  \n",
       "14               oso  opensource-observer  \n",
       "15               oso  opensource-observer  \n",
       "16               oso  opensource-observer  \n",
       "17               oso  opensource-observer  \n",
       "18               oso  opensource-observer  \n",
       "19               oso  opensource-observer  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get all artifacts owned by a project\n",
    "df_abp = client.to_pandas(\"SELECT * FROM artifacts_by_project_v1 WHERE project_name = 'opensource-observer'\")\n",
    "df_abp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "84a85181-5730-44df-ab55-88c0a1ad542c",
   "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>metric_id</th>\n",
       "      <th>metric_name</th>\n",
       "      <th>display_name</th>\n",
       "      <th>sample_date</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4qXMv/x67zMwqoF6hmivpo74Y++R2lhT4Y9CjZKpt00=</td>\n",
       "      <td>GITHUB_opened_pull_requests_over_all_time</td>\n",
       "      <td>Opened Pull Requests</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>2171.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1zNSDLeL7d1bqMgJ4b/AGBd0lQs4Q4Wy9jIf2ge72kw=</td>\n",
       "      <td>GITHUB_commits_over_all_time</td>\n",
       "      <td>Commits</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>2943.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5ZLGEJ/RoW00SLRJWIC0GFhRaud5h29Lshc2erSNHHQ=</td>\n",
       "      <td>GITHUB_avg_prs_time_to_merge_over_all_time</td>\n",
       "      <td>Average PR Time to Merge</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>0.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>fCurNzGHifHJShhc0wVn6SMz9ja/NBg7nXzIE8A9PIA=</td>\n",
       "      <td>OPTIMISM_transactions_over_all_time</td>\n",
       "      <td>Transactions</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>37.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>d5VBo6xBRMwXq6CEm4KgX+NrdrU45HR1ryhhO9szl60=</td>\n",
       "      <td>GITHUB_comments_over_all_time</td>\n",
       "      <td>Comments</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>6002.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>yENOci1vNPlXyu75FDtgH6XUKIKZh1XfTSe+AEdwLTE=</td>\n",
       "      <td>GITHUB_repositories_over_all_time</td>\n",
       "      <td>Repositories</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>12.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>ftrYmCWeazkMzCpce018wYydj/HovL+5q25MGl+4uv0=</td>\n",
       "      <td>GITHUB_opened_issues_over_all_time</td>\n",
       "      <td>Opened Issues</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>1578.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>zqqzFEQxHTmLdyh9m6KMUUAdZL01Wt+C4SYmo1VPOn0=</td>\n",
       "      <td>GITHUB_active_developers_over_all_time</td>\n",
       "      <td>Active Developers</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>102.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>/3v26jfsOswJmGRIAQiiwVjYPqYTwQDlD2dQMR0h3yw=</td>\n",
       "      <td>OPTIMISM_active_contracts_over_all_time</td>\n",
       "      <td>Active Contracts</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>1.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>gKlMLwqOAY0NndkTeXiaN4XM8RqhEu9RGvYhZRLPPMM=</td>\n",
       "      <td>GITHUB_merged_pull_requests_over_all_time</td>\n",
       "      <td>Merged Pull Requests</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>2027.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>93/Kp4P4y4dXjpK6f65ilia7+A5n+xfeYp4eMlaM6TM=</td>\n",
       "      <td>OPTIMISM_active_addresses_aggregation_over_all...</td>\n",
       "      <td>Active Addresses Aggregation</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>2.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Ogi5iZm8/w4TA690CQ/DHOEr/JgH/jPGuGikUjwPdus=</td>\n",
       "      <td>GITHUB_avg_time_to_first_response_over_all_time</td>\n",
       "      <td>Average Time to First Response</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>816625.359603</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Ajp2Y1SJELeGaHurKPvqVEFPzYULg2B8sjMThdeEcI4=</td>\n",
       "      <td>OPTIMISM_contract_invocations_over_all_time</td>\n",
       "      <td>Contract Invocations</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>39.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>OvHEN0B/pn82eKeV0jD9007tZriincUXAXgGqmYxPpc=</td>\n",
       "      <td>GITHUB_forks_over_all_time</td>\n",
       "      <td>Forks</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>220.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Fx1VYZrsdL9HlxTjJKCyPpntx7ZdGAiW+L1TEnTZgSI=</td>\n",
       "      <td>GITHUB_contributors_over_all_time</td>\n",
       "      <td>Contributors</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>171.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>IBdxUvSrFquEY1PG3bYlD1LREqoRZxIHErDZDEAlM1M=</td>\n",
       "      <td>GITHUB_closed_issues_over_all_time</td>\n",
       "      <td>Closed Issues</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>1231.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Z6qQavpdhYhLZHxNqLlgWO8Fm1yU3jc3rdxehtP91Yc=</td>\n",
       "      <td>GITHUB_stars_over_all_time</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>213.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>+oh3g/WMjgzsGSrzo+y3gmaqX2+XMJaSga0afB/XVYY=</td>\n",
       "      <td>OPTIMISM_gas_fees_over_all_time</td>\n",
       "      <td>Gas Fees</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       metric_id  \\\n",
       "0   4qXMv/x67zMwqoF6hmivpo74Y++R2lhT4Y9CjZKpt00=   \n",
       "1   1zNSDLeL7d1bqMgJ4b/AGBd0lQs4Q4Wy9jIf2ge72kw=   \n",
       "2   5ZLGEJ/RoW00SLRJWIC0GFhRaud5h29Lshc2erSNHHQ=   \n",
       "3   fCurNzGHifHJShhc0wVn6SMz9ja/NBg7nXzIE8A9PIA=   \n",
       "4   d5VBo6xBRMwXq6CEm4KgX+NrdrU45HR1ryhhO9szl60=   \n",
       "5   yENOci1vNPlXyu75FDtgH6XUKIKZh1XfTSe+AEdwLTE=   \n",
       "6   ftrYmCWeazkMzCpce018wYydj/HovL+5q25MGl+4uv0=   \n",
       "7   zqqzFEQxHTmLdyh9m6KMUUAdZL01Wt+C4SYmo1VPOn0=   \n",
       "8   /3v26jfsOswJmGRIAQiiwVjYPqYTwQDlD2dQMR0h3yw=   \n",
       "9   gKlMLwqOAY0NndkTeXiaN4XM8RqhEu9RGvYhZRLPPMM=   \n",
       "10  93/Kp4P4y4dXjpK6f65ilia7+A5n+xfeYp4eMlaM6TM=   \n",
       "11  Ogi5iZm8/w4TA690CQ/DHOEr/JgH/jPGuGikUjwPdus=   \n",
       "12  Ajp2Y1SJELeGaHurKPvqVEFPzYULg2B8sjMThdeEcI4=   \n",
       "13  OvHEN0B/pn82eKeV0jD9007tZriincUXAXgGqmYxPpc=   \n",
       "14  Fx1VYZrsdL9HlxTjJKCyPpntx7ZdGAiW+L1TEnTZgSI=   \n",
       "15  IBdxUvSrFquEY1PG3bYlD1LREqoRZxIHErDZDEAlM1M=   \n",
       "16  Z6qQavpdhYhLZHxNqLlgWO8Fm1yU3jc3rdxehtP91Yc=   \n",
       "17  +oh3g/WMjgzsGSrzo+y3gmaqX2+XMJaSga0afB/XVYY=   \n",
       "\n",
       "                                          metric_name  \\\n",
       "0           GITHUB_opened_pull_requests_over_all_time   \n",
       "1                        GITHUB_commits_over_all_time   \n",
       "2          GITHUB_avg_prs_time_to_merge_over_all_time   \n",
       "3                 OPTIMISM_transactions_over_all_time   \n",
       "4                       GITHUB_comments_over_all_time   \n",
       "5                   GITHUB_repositories_over_all_time   \n",
       "6                  GITHUB_opened_issues_over_all_time   \n",
       "7              GITHUB_active_developers_over_all_time   \n",
       "8             OPTIMISM_active_contracts_over_all_time   \n",
       "9           GITHUB_merged_pull_requests_over_all_time   \n",
       "10  OPTIMISM_active_addresses_aggregation_over_all...   \n",
       "11    GITHUB_avg_time_to_first_response_over_all_time   \n",
       "12        OPTIMISM_contract_invocations_over_all_time   \n",
       "13                         GITHUB_forks_over_all_time   \n",
       "14                  GITHUB_contributors_over_all_time   \n",
       "15                 GITHUB_closed_issues_over_all_time   \n",
       "16                         GITHUB_stars_over_all_time   \n",
       "17                    OPTIMISM_gas_fees_over_all_time   \n",
       "\n",
       "                      display_name sample_date         amount  unit  \n",
       "0             Opened Pull Requests  2025-04-02         2171.0  None  \n",
       "1                          Commits  2025-04-02         2943.0  None  \n",
       "2         Average PR Time to Merge  2025-04-02            0.0  None  \n",
       "3                     Transactions  2025-04-02           37.0  None  \n",
       "4                         Comments  2025-04-02         6002.0  None  \n",
       "5                     Repositories  2025-04-02           12.0  None  \n",
       "6                    Opened Issues  2025-04-02         1578.0  None  \n",
       "7                Active Developers  2025-04-02          102.0  None  \n",
       "8                 Active Contracts  2025-04-02            1.0  None  \n",
       "9             Merged Pull Requests  2025-04-02         2027.0  None  \n",
       "10    Active Addresses Aggregation  2025-04-02            2.0  None  \n",
       "11  Average Time to First Response  2025-04-02  816625.359603  None  \n",
       "12            Contract Invocations  2025-04-02           39.0  None  \n",
       "13                           Forks  2025-04-02          220.0  None  \n",
       "14                    Contributors  2025-04-02          171.0  None  \n",
       "15                   Closed Issues  2025-04-02         1231.0  None  \n",
       "16                           Stars  2025-04-02          213.0  None  \n",
       "17                        Gas Fees  2025-04-02       0.000042  None  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get available key metrics for OSO\n",
    "client.to_pandas(\"\"\"\n",
    "  SELECT\n",
    "    km.metric_id,\n",
    "    m.metric_name,\n",
    "    m.display_name,\n",
    "    km.sample_date,\n",
    "    km.amount,\n",
    "    km.unit \n",
    "  FROM key_metrics_by_project_v0 AS km\n",
    "  JOIN metrics_v0 AS m ON m.metric_id = km.metric_id\n",
    "  WHERE km.project_id = 'UuWbpo5bpL5QsYvlukUWNm2uE8HFjxQxzCM0e+HMZfk='\n",
    "\"\"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "adc38618-c6df-451c-b083-4842ff057194",
   "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>project_display_name</th>\n",
       "      <th>metric_display_name</th>\n",
       "      <th>sample_date</th>\n",
       "      <th>amount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Hugging Face</td>\n",
       "      <td>Forks</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>75103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Hugging Face</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>454052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Open Source Observer</td>\n",
       "      <td>Forks</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Open Source Observer</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>wevm</td>\n",
       "      <td>Forks</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>1715</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>wevm</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2025-04-02</td>\n",
       "      <td>5234</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   project_display_name metric_display_name sample_date  amount\n",
       "0          Hugging Face               Forks  2025-04-02   75103\n",
       "1          Hugging Face               Stars  2025-04-02  454052\n",
       "2  Open Source Observer               Forks  2025-04-02     220\n",
       "3  Open Source Observer               Stars  2025-04-02     213\n",
       "4                  wevm               Forks  2025-04-02    1715\n",
       "5                  wevm               Stars  2025-04-02    5234"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get a set of key metrics for a few projects using the stringify helper\n",
    "\n",
    "MY_PROJECTS = ['opensource-observer', 'huggingface', 'wevm']\n",
    "MY_METRICS = ['GITHUB_stars_over_all_time', 'GITHUB_forks_over_all_time']\n",
    "\n",
    "client.to_pandas(f\"\"\"\n",
    "  SELECT\n",
    "    --p.project_id,\n",
    "    --p.project_name,\n",
    "    p.display_name AS project_display_name,\n",
    "    --km.metric_id,\n",
    "    --m.metric_name,\n",
    "    m.display_name AS metric_display_name,\n",
    "    km.sample_date,\n",
    "    km.amount\n",
    "    --km.unit \n",
    "  FROM key_metrics_by_project_v0 AS km\n",
    "  JOIN metrics_v0 AS m ON m.metric_id = km.metric_id\n",
    "  JOIN projects_v1 AS p ON p.project_id = km.project_id\n",
    "  WHERE\n",
    "    p.project_name IN ({stringify(MY_PROJECTS)})\n",
    "    AND m.metric_name IN ({stringify(MY_METRICS)})\n",
    "  ORDER BY p.display_name, m.display_name\n",
    "\"\"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "73706339-60bc-452d-929f-9a18a2013fc2",
   "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>metric_id</th>\n",
       "      <th>metric_name</th>\n",
       "      <th>display_name</th>\n",
       "      <th>sample_date</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=</td>\n",
       "      <td>GITHUB_stars_daily</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2023-10-05</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=</td>\n",
       "      <td>GITHUB_stars_daily</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2023-10-13</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=</td>\n",
       "      <td>GITHUB_stars_daily</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2023-10-16</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=</td>\n",
       "      <td>GITHUB_stars_daily</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2023-11-02</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=</td>\n",
       "      <td>GITHUB_stars_daily</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2023-11-06</td>\n",
       "      <td>1</td>\n",
       "      <td>None</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>149</th>\n",
       "      <td>eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=</td>\n",
       "      <td>GITHUB_stars_daily</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2025-03-20</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=</td>\n",
       "      <td>GITHUB_stars_daily</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2025-03-24</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=</td>\n",
       "      <td>GITHUB_stars_daily</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2025-03-26</td>\n",
       "      <td>3</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=</td>\n",
       "      <td>GITHUB_stars_daily</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2025-03-28</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=</td>\n",
       "      <td>GITHUB_stars_daily</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2025-03-29</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>154 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        metric_id         metric_name  \\\n",
       "0    eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=  GITHUB_stars_daily   \n",
       "1    eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=  GITHUB_stars_daily   \n",
       "2    eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=  GITHUB_stars_daily   \n",
       "3    eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=  GITHUB_stars_daily   \n",
       "4    eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=  GITHUB_stars_daily   \n",
       "..                                            ...                 ...   \n",
       "149  eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=  GITHUB_stars_daily   \n",
       "150  eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=  GITHUB_stars_daily   \n",
       "151  eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=  GITHUB_stars_daily   \n",
       "152  eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=  GITHUB_stars_daily   \n",
       "153  eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=  GITHUB_stars_daily   \n",
       "\n",
       "    display_name sample_date  amount  unit  \n",
       "0          Stars  2023-10-05       1  None  \n",
       "1          Stars  2023-10-13       1  None  \n",
       "2          Stars  2023-10-16       1  None  \n",
       "3          Stars  2023-11-02       1  None  \n",
       "4          Stars  2023-11-06       1  None  \n",
       "..           ...         ...     ...   ...  \n",
       "149        Stars  2025-03-20       1  None  \n",
       "150        Stars  2025-03-24       1  None  \n",
       "151        Stars  2025-03-26       3  None  \n",
       "152        Stars  2025-03-28       1  None  \n",
       "153        Stars  2025-03-29       1  None  \n",
       "\n",
       "[154 rows x 6 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get timeseries metrics for OSO\n",
    "df_stars = client.to_pandas(\"\"\"\n",
    "  SELECT\n",
    "    tm.metric_id,\n",
    "    m.metric_name,\n",
    "    m.display_name,\n",
    "    tm.sample_date,\n",
    "    tm.amount,\n",
    "    tm.unit \n",
    "  FROM timeseries_metrics_by_project_v0 AS tm\n",
    "  JOIN metrics_v0 AS m ON m.metric_id = tm.metric_id\n",
    "  JOIN projects_v1 AS p ON p.project_id = tm.project_id\n",
    "  WHERE\n",
    "    p.project_name = 'opensource-observer'\n",
    "    AND m.metric_name = 'GITHUB_stars_daily'\n",
    "  ORDER BY tm.sample_date\n",
    "\"\"\")\n",
    "df_stars"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "cf5bc5a0-e709-49ea-a02d-104fe8f17a18",
   "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>metric_id</th>\n",
       "      <th>metric_name</th>\n",
       "      <th>display_name</th>\n",
       "      <th>sample_date</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "      <th>cumulative_amount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=</td>\n",
       "      <td>GITHUB_stars_daily</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2023-10-05</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=</td>\n",
       "      <td>GITHUB_stars_daily</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2023-10-13</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=</td>\n",
       "      <td>GITHUB_stars_daily</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2023-10-16</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=</td>\n",
       "      <td>GITHUB_stars_daily</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2023-11-02</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=</td>\n",
       "      <td>GITHUB_stars_daily</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2023-11-06</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=</td>\n",
       "      <td>GITHUB_stars_daily</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2025-03-20</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=</td>\n",
       "      <td>GITHUB_stars_daily</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2025-03-24</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=</td>\n",
       "      <td>GITHUB_stars_daily</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2025-03-26</td>\n",
       "      <td>3</td>\n",
       "      <td>None</td>\n",
       "      <td>211</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=</td>\n",
       "      <td>GITHUB_stars_daily</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2025-03-28</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=</td>\n",
       "      <td>GITHUB_stars_daily</td>\n",
       "      <td>Stars</td>\n",
       "      <td>2025-03-29</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>213</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>154 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        metric_id         metric_name  \\\n",
       "0    eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=  GITHUB_stars_daily   \n",
       "1    eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=  GITHUB_stars_daily   \n",
       "2    eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=  GITHUB_stars_daily   \n",
       "3    eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=  GITHUB_stars_daily   \n",
       "4    eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=  GITHUB_stars_daily   \n",
       "..                                            ...                 ...   \n",
       "149  eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=  GITHUB_stars_daily   \n",
       "150  eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=  GITHUB_stars_daily   \n",
       "151  eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=  GITHUB_stars_daily   \n",
       "152  eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=  GITHUB_stars_daily   \n",
       "153  eV94RLJgcpOd+aMt8Y0sYGyN4V+6CCSwuxyZC7B1/FE=  GITHUB_stars_daily   \n",
       "\n",
       "    display_name sample_date  amount  unit  cumulative_amount  \n",
       "0          Stars  2023-10-05       1  None                  1  \n",
       "1          Stars  2023-10-13       1  None                  2  \n",
       "2          Stars  2023-10-16       1  None                  3  \n",
       "3          Stars  2023-11-02       1  None                  4  \n",
       "4          Stars  2023-11-06       1  None                  5  \n",
       "..           ...         ...     ...   ...                ...  \n",
       "149        Stars  2025-03-20       1  None                207  \n",
       "150        Stars  2025-03-24       1  None                208  \n",
       "151        Stars  2025-03-26       3  None                211  \n",
       "152        Stars  2025-03-28       1  None                212  \n",
       "153        Stars  2025-03-29       1  None                213  \n",
       "\n",
       "[154 rows x 7 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_stars['cumulative_amount'] = df_stars['amount'].cumsum()\n",
    "df_stars"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "6344c44d-0410-4b29-9c46-caa0ebcb014f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Axes: xlabel='sample_date'>"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAigAAAGxCAYAAABIjE2TAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjguMCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy81sbWrAAAACXBIWXMAAA9hAAAPYQGoP6dpAABawklEQVR4nO3dd1xV9f8H8NdlXfbeMpWp4F7gnojmyErTNC0rLS1NzZFp2nCUqzJHZWnmyK+73ANXOHGhiICgoDLEwZQL3Pv5/UHeX1cBQYFzgdfz8biPh9x77rnv9z13vDz3fD5HJoQQICIiItIiOlIXQERERPQkBhQiIiLSOgwoREREpHUYUIiIiEjrMKAQERGR1mFAISIiIq3DgEJERERahwGFiIiItI6e1AU8D5VKhTt37sDMzAwymUzqcoiIiKgMhBDIysqCs7MzdHRK30dSLQPKnTt34OrqKnUZRERE9BySkpLg4uJS6jLVMqCYmZkBKGrQ3Nxc4mqIiIioLDIzM+Hq6qr+Hi9NtQwoj3/WMTc3Z0AhIiKqZspyeAYPkiUiIiKtw4BCREREWocBhYiIiLROtTwGpayUSiUKCgqkLoOoUujr60NXV1fqMoiIKkWNDChCCKSkpODhw4dSl0JUqSwtLeHo6Mj5gIioxqmRAeVxOLG3t4exsTE/vKnGEUIgNzcXaWlpAAAnJyeJKyIiqlg1LqAolUp1OLGxsZG6HKJKY2RkBABIS0uDvb09f+4hohqlxh0k+/iYE2NjY4krIap8j1/nPNaKiGqaGhdQHuPPOlQb8HVORDVVjQ0oREREVH0xoFCpbty4AZlMhgsXLmjFeoiIqHZgQKEKN3z4cPTr10/jOldXVyQnJyMgIECaoqqZVatWwdLSUuoyiIgkU+NG8ZB20tXVhaOjo9RlEBFRGZyKvweZTIaWntaS1cA9KFpEpVJh3rx58PLyglwuh5ubG77++mscPnwYMplMY+K5CxcuQCaT4caNGwD+/3/cf//9N3x9fWFsbIxXX30VOTk5WL16NTw8PGBlZYUPP/wQSqVSvR6ZTIZt27Zp1GFpaYlVq1YVW6NSqcSIESPg6ekJIyMj+Pr64rvvvlPfPnPmTKxevRrbt2+HTCaDTCbD4cOHNX7iUalUcHFxwfLlyzXWfe7cOchkMsTHxwMAMjIy8N5778He3h7m5ubo3LkzLl68WKbn8vr16+jbty8cHBxgamqKFi1a4MCBAxrLeHh44KuvvsKbb74JU1NTuLu7Y/v27bh79y769u0LU1NTBAYG4uzZsxr327x5Mxo0aAC5XA4PDw8sWLBA4/ZnPaePn4stW7agU6dOMDY2RqNGjXDixAkAwOHDh/HWW28hIyND/RzOnDmzTH0TEb2I6JRMvL3qDAb+dBLTt12GUiUkq6VWBBQhBHLzCyW5CFH2jTt16lTMmzcP06dPR1RUFNatWwcHB4cy3z83Nxfff/89NmzYgD179uDw4cPo378/du3ahV27dmHNmjX46aefsGnTpud5GgFAHS42btyIqKgozJgxA59++ik2btwIAJg4cSIGDBiAHj16IDk5GcnJyQgODtZYh46ODl5//XWsXbtW4/p169YhKCgIdevWhRACvXr1QkpKCnbt2oWIiAg0bdoUXbp0wf37959ZZ3Z2Nnr27IkDBw7g/PnzCAkJQe/evZGYmKix3KJFi9CmTRucP38evXr1wtChQ/Hmm29iyJAhOHfuHLy8vPDmm2+qt2NERAQGDBiA119/HZGRkZg5cyamT59eYqArzbRp0zBx4kRcuHABPj4+GDRoEAoLCxEcHIzFixfD3Nxc/RxOnDix3OsnIiqrWw9yMX7jBYR+dwyHotOgqyNDcw8r5BUon33nSlIrfuJ5VKBE/Rl7JXnsqC9CYGzw7Kc5KysL3333HZYsWYJhw4YBAOrVq4e2bdvi8OHDZXqsgoICLFu2DPXq1QMAvPrqq1izZg1SU1NhamqK+vXro1OnTggLC8PAgQOfqx99fX3MmjVL/benpyfCw8OxceNGDBgwAKampjAyMoJCoSj1J5033ngDCxcuxM2bN+Hu7g6VSoUNGzbg008/BQCEhYUhMjISaWlpkMvlAID58+dj27Zt2LRpE957771S62zUqBEaNWqk/vurr77C1q1bsWPHDowZM0Z9fc+ePTFy5EgAwIwZM7Bs2TK0aNECr732GgBg8uTJCAoKQmpqKhwdHbFw4UJ06dIF06dPBwD4+PggKioK3377LYYPH16OZ7IozPXq1QsAMGvWLDRo0ABxcXHw8/ODhYUFZDIZfxYjokp1PycfP4bFYc2Jm8hXqgAAvQKdMKG7D+ramUpaW63Yg1IdXL16FQqFAl26dHnudRgbG6vDCQA4ODjAw8MDpqamGtc9nh79eS1fvhzNmzeHnZ0dTE1N8fPPPz+1Z+JZmjRpAj8/P6xfvx4AcOTIEaSlpWHAgAEAivZUZGdnw8bGBqampupLQkICrl+//sz15+TkYNKkSahfvz4sLS1hamqK6Ojop+ps2LCh+t+P91YFBgY+dd3j5+zq1ato06aNxjratGmD2NhYjZ/OyuK/j/14qvoX3TZERGWVmpmH7ouOYuXxBOQrVQiqa4Pto9vgxzeaSh5OgFqyB8VIXxdRX4RI9thlWu7facuLo6NTlCP/+3NRcTOH6uvra/wtk8mKvU6lUmn8/eTPUKXNSrpx40Z8/PHHWLBgAYKCgmBmZoZvv/0Wp06dKvE+JXnjjTewbt06TJkyBevWrUNISAhsbW0BFP2U5OTkVOzeo7KMbvnkk0+wd+9ezJ8/H15eXjAyMsKrr76K/Px8jeX++/w8nvSsuOseP2dCiKcmR3vy+Svrc1ra4xARVbYv/o5CerYCnrYmmNmnAdp722rV5I+1IqDIZLIy/cwiJW9vbxgZGeHgwYN45513NG6zs7MDACQnJ8PKygoAKmw+ETs7OyQnJ6v/jo2NRW5ubonLHzt2DMHBwfjggw/U1z25R8PAwKBMexMGDx6Mzz77DBEREdi0aROWLVumvq1p06ZISUmBnp4ePDw8ytHR/9c5fPhwvPzyywCKjkl5fEDxi6hfvz6OHz+ucV14eDh8fHzU58Ip73NanLI+h0REz+PwtTTsvJQMXR0ZlgxuggbOFlKX9BT+xKMlDA0NMXnyZEyaNAm///47rl+/jpMnT2LlypXw8vKCq6srZs6ciZiYGOzcufOpkSPPq3PnzliyZAnOnTuHs2fPYtSoUU/tdfkvLy8vnD17Fnv37kVMTAymT5+OM2fOaCzj4eGBS5cu4dq1a0hPTy9xj4ynpyeCg4MxYsQIFBYWom/fvurbunbtiqCgIPTr1w979+7FjRs3EB4ejs8+++ypUTUl1bllyxZcuHABFy9exODBgytk78SECRNw8OBBfPnll4iJicHq1auxZMkSjYNYy/ucFsfDwwPZ2dk4ePAg0tPTyx1wiIhKklegxPTtlwEAbwV7aGU4ARhQtMr06dMxYcIEzJgxA/7+/hg4cCDS0tKgr6+P9evXIzo6Go0aNcK8efPw1VdfVchjLliwAK6urmjfvj0GDx6MiRMnlnqixVGjRqF///4YOHAgWrVqhXv37mnsTQGAd999F76+vurjVP75558S1/fGG2/g4sWL6N+/v8bPXDKZDLt27UL79u3x9ttvw8fHB6+//jpu3LhRppFNixYtgpWVFYKDg9G7d2+EhISgadOmZXhGSte0aVNs3LgRGzZsQEBAAGbMmIEvvvhC4wDZ8j6nxQkODsaoUaMwcOBA2NnZ4Ztvvnnh2omIAOD7g7FIuv8IThaG+Libj9TllEgmyjMOVktkZmbCwsICGRkZMDc317gtLy8PCQkJ8PT0hKGhoUQVElUNvt6JqKxiUrPwzZ5oHLhadDD+iqHNENKgakcKlvb9/STtPjCDiIiIXsidh4+waH8MNp+7BZUAdHVkeLddXXSvX/Z5tqTAgELVUoMGDXDz5s1ib1uxYgXeeOONKq6IiEi7PMzNx9LD17Eq/AbyC4uOwQsNcMTEEF/U04JhxM/CgELV0q5du0o8+LY8s+8SEdU0j/KV+C08AcsOX0dWXiEAoJWnNSaH+qGpm5XE1ZUdAwpVS+7u7lKXQESkVQqVKmyKuIVFB2KQmqkAAPg5mmFyqB86+thp1RwnZVFjA0o1PPaXqNz4OiciIQT2XknFt3ujcf1uDgCgjqURJnT3Qd/GdaCrU72CyWM1LqA8nm8iNze31NlZiWqCx/OjlHeeFSKqGYQQ+HD9efx9qWhySCtjfYzp7I0hrd0g1yvbTObaqsYFFF1dXVhaWqrPaWJsbFztdmsRPYsQArm5uUhLS4OlpaV6Flsiql3+vpSMvy8lQ19XhlEd6uHd9nVhblgz/sNS4wIKAPUZYHniNarpLC0tecZjoloq41EBvvg7CgAwupMXxnXV3knXnke5AsqcOXOwZcsWREdHw8jICMHBwZg3bx58fX3VywghMGvWLPz000948OABWrVqhR9//BENGjRQL6NQKDBx4kSsX78ejx49QpcuXbB06VK4uLhUSFMymQxOTk6wt7cv9cR3RNWZvr4+95wQ1WIL9l3D3SwF6tqa4P2O9Z59h2qmXAHlyJEjGD16NFq0aIHCwkJMmzYN3bt3R1RUFExMTAAA33zzDRYuXIhVq1bBx8cHX331Fbp164Zr167BzMwMADBu3Dj89ddf2LBhA2xsbDBhwgS89NJLiIiIqNAPXF1dXX6AExFRjXMh6SHWnCyaC+qrfgHV/niT4rzQVPd3796Fvb09jhw5gvbt20MIAWdnZ4wbNw6TJ08GULS3xMHBAfPmzcPIkSORkZEBOzs7rFmzBgMHDgQA3LlzB66urti1axdCQkKe+bjlmSqXiIioJilUqtBnyT+ISs7Ey03qYNHAxlKXVGbl+f5+oZMFZmRkAACsra0BAAkJCUhJSUH37t3Vy8jlcnTo0AHh4eEAgIiICBQUFGgs4+zsjICAAPUyT1IoFMjMzNS4EBER1UarT9xEVHImzA31MK2Xv9TlVJrnDihCCIwfPx5t27ZFQEAAACAlJQXA0zN5Ojg4qG9LSUmBgYEBrKysSlzmSXPmzIGFhYX64urq+rxlExERVVvJGY+wcN81AMCUUH/YmsolrqjyPHdAGTNmDC5duoT169c/dduTw3qFEM8c6lvaMlOnTkVGRob6kpSU9LxlExERVVuzdkQhJ1+JZu5WeL1Fzf7P+nMFlA8//BA7duxAWFiYxsibx8Mdn9wTkpaWpt6r4ujoiPz8fDx48KDEZZ4kl8thbm6ucSEiIqpNdkUmY8+VFOjqyPD1ywHQqaYzxJZVuQKKEAJjxozBli1bcOjQIXh6emrc7unpCUdHR+zfv199XX5+Po4cOYLg4GAAQLNmzaCvr6+xTHJyMi5fvqxehoiIiIpcv5uNUWsi8MHacwCAd9p6ws+x5v9HvVzDjEePHo1169Zh+/btMDMzU+8psbCwgJGREWQyGcaNG4fZs2fD29sb3t7emD17NoyNjTF48GD1siNGjMCECRNgY2MDa2trTJw4EYGBgejatWvFd0hERFQNpWbmYfGBWGw8mwSlSkBHBrzWzBUfd6tZE7KVpFwBZdmyZQCAjh07alz/22+/Yfjw4QCASZMm4dGjR/jggw/UE7Xt27dPPQcKACxatAh6enoYMGCAeqK2VatWcc4SIiKq9bIVhVgaFodf/0lAXoEKANDV3wGTevjCx8HsGfeuOV5oHhSpcB4UIiKqibIVhXjjl1O4mPQQANDM3QpTQv3QwsNa2sIqSHm+v2vkuXiIiIiqm7wCJd77/SwuJj2ElbE+5r3SEN3qO9TaE94yoBAREUmsUKnCR+vPI/z6PZgY6GLVWy3RyNVS6rIkxYBCREQkofDr6Zi3OxoXb2XAQFcHP7/ZvNaHE4ABhYiISBJRdzIxb080jsTcBQAYG+hi8cDGCPaylbgy7cCAQkREVIWS7udi4f4YbLtwG0IAejoyDG7lhg87e8POrOZOXV9eDChERERV4F62AkvC4rD2ZCLylUXDh3s3csaEbj7wsDWRuDrtw4BCRERUiXLzC7HyWAJWHI1HtqIQANDWyxaTe/gh0MVC4uq0FwMKERFRJShQqrDhTBK+OxCL9GwFACCgjjkm9/BDO287iavTfgwoREREFSzxXi6G/3Ya8ek5AAA3a2NMDPHFS4FONf4kfxWFAYWIiKgCCSEwafNFxKfnwNbUAB918cbrLdxgoFeu8/PWegwoREREFWjLuds4GX8fhvo62PpBG7haG0tdUrXEOEdERFRBHubm4+tdVwEAH3XxZjh5AQwoREREFWTu7mjcz8mHj4Mp3m1XV+pyqjX+xENERPSCHuTk48ewOGw4kwQA+PrlQOjrch/Ai2BAISIiek65+YX47Z8bWH74OrL+nePkrTYeaOFhLXFl1R8DChERUTkVKlXYePYWFh+IQVpW0Rwn/k7mmBLqh/bePJdORWBAISIiKodbD3Ix/LcziEvLBgC4WBlhYndf9GnkzDlOKhADChERURndzVJg6MrTSEjPgbWJAT7s7IXBrdwg19OVurQahwGFiIioDDLzCjDs16JwUsfSCJveD4KThZHUZdVYPMSYiIjoGRLSczD819OISs6ErakB/ninFcNJJeMeFCIiohKkZebhu4Ox2HAmCUqVgJmhHla/3RKetiZSl1bjMaAQERE9ISuvAD8djccvxxLwqEAJAOjsZ49Pe/rBy95M4upqBwYUIiKifykKlfjjZCKWHIrFg9wCAEATN0tM6eGHVnVtJK6udmFAISKiWk+pEth+4TYW7IvB7YePAAB17UwwKcQPIQ0cIJNx+HBVY0AhIqJaSwiBwzF3MW93NKJTsgAADuZyfNzVB682c4Eep6uXDAMKERHVSucTH2Du7micSrgPADAz1MP7HevhrWBPGBlwXhOpMaAQEVGtcv1uNubvvYbdl1MAAAZ6Ohge7IEPOtaDpbGBxNXRYwwoRERUK6Rm5mHxgVhsPFs0ZFhHBrzS1AXjuvmgjiXnNNE2DChERFSjZeYVYMWR61h5PAF5BSoAQFd/e3wS4gdfRw4Z1lYMKEREVCPlFSjxx8mbWBIWh4f/Dhlu5m6FKaF+aOFhLXF19CwMKEREVKMoVQJbz9/Gov3/P2TYy94Uk0J80a0+hwxXFwwoRERUIwghEHYtDfN2X8O11KIhw47mhhjfzQf9m9bhkOFqhgGFiIiqvYibDzBvdzRO3ygaMmxuqIfRnbwwLNgDhvocMlwdMaAQEVG1FZeWjW/3RmPvlVQAgFxPB8PbeOCDDl6wMNaXuDp6EQwoRERU7aRk5GHxgRhsPJsElQB0ZMBrzVwxrps3nCw4ZLgmYEAhIqJqZcfFO/jkfxehKCwaMtytvgMmhfjC24FDhmsSBhQiIqo2UjPzMG1LJBSFKjR3t8LUnn5o5s4hwzURAwoREVUbX/wdhSxFIRq5WuLPkUHQ1eGQ4ZqKY66IiKhaOHwtDTsvJUNHBsx+OYDhpIZjQCEiIq2XV6DEjO1XAABvtfFEA2cLiSuiysafeIiISKtdSHqI2TuvIvF+LpwsDPFxNx+pS6IqwIBCRERa6frdbMzfew27L6cAAAz0dDCnfyBM5fzqqg24lYmISKukZeZh8cFY/HkmCUqVgEwGvNLUBR9380EdS85xUlswoBARkVbIzCvAiiPXsfJ4AvIKiuY46epvj09C/ODryDlOahsGFCIiklRegRJ/nLyJJWFxeJhbAABo6maJKaH+aOnJOU5qKwYUIiKShFIlsO38bSzcH4PbDx8BALzsTTEpxBfd6jtAJuMw4tqMAYWIiKpcQnoO3v8jAtEpWQAAR3NDfNzNG680dYGeLmfAIAYUIiKqYskZjzDkl1O4/fARzA318EEnLwwP9oChvq7UpZEWYUAhIqIqcz8nXx1O6tqaYMPI1rA3M5S6LNJC3I9GRERVIul+Lob9ehrX7+bAycIQv49oyXBCJeIeFCIiqlT3c/Kx5FAc/jh5E/lKFaxNDLBmRCu4WBlLXRppMQYUIiKqFLn5hVh5LAErjsYjW1EIAGjjZYOZvRvAy95U4upI2zGgEBFRhSpQqvDnmSR8dzAWd7MUAIAGzuaYEuqHdt52EldH1QUDChERVQghBHZFpmD+vmtISM8BALhZG2NiiC9eCnSCjg7nNaGyY0AhIqIXdj8nH++sPoNziQ8BADYmBvioizcGtXSDgR7HY1D5MaAQEdELyVYUYvhvp3HpVgZMDHTxbvu6eKddXZ51mF4IXz1ERPTc8gqUeHf1WVy6lQFrEwNsHBnEA2CpQnC/GxERPZe0zDy8/0cETsTfg6lcD6vfaslwQhWGe1CIiKhcMvMKsOLIdaw8noC8AhUM9HTwy7DmCHSxkLo0qkEYUIiIqEzyCpT44+RNLAmLw8PcAgBAUzdLTH+pPpq4WUlcHdU0DChERPRMey4n48u/r+L2w0cAAC97U0wK8UW3+g6QyTh8mCoeAwoREZXq8u0MfLD2HFQCcDQ3xMfdvPFKUxfo6fIwRqo8DChERFQipUrg062RUAkgpIEDvnu9CQz1daUui2oBxl8iIirRmhM3cOlWBswM9fBlvwCGE6oyDChERFSs1Mw8zN8XAwCY1MMP9maGEldEtQkDChERPSUtKw8T/3cR2YpCNHa1xBst3aQuiWoZHoNCRERqWXkF+OloPH45loBHBUro6cjw9csBPNEfVTkGFCIiAgAoCpV4bfkJRKdkAQAau1ris17+aODMCdio6pX7J56jR4+id+/ecHZ2hkwmw7Zt2zRuHz58OGQymcaldevWGssoFAp8+OGHsLW1hYmJCfr06YNbt269UCNERPRiVhyJR3RKFqxNDLB8SDNs/SAYzT2spS6LaqlyB5ScnBw0atQIS5YsKXGZHj16IDk5WX3ZtWuXxu3jxo3D1q1bsWHDBhw/fhzZ2dl46aWXoFQqy98BERG9sBvpOVgSFgcA+Lx3ffQIcOQEbCSpcv/EExoaitDQ0FKXkcvlcHR0LPa2jIwMrFy5EmvWrEHXrl0BAH/88QdcXV1x4MABhISElLckIiJ6AUIITN9+GfmFKrTztkWfRs5Sl0RUOaN4Dh8+DHt7e/j4+ODdd99FWlqa+raIiAgUFBSge/fu6uucnZ0REBCA8PDwyiiHiIhKsePiHRyLTYeBng6+7BvAPSekFSr8INnQ0FC89tprcHd3R0JCAqZPn47OnTsjIiICcrkcKSkpMDAwgJWV5omlHBwckJKSUuw6FQoFFAqF+u/MzMyKLpuIqFbKeFSAL/++CgAY08kLHrYmEldEVKTCA8rAgQPV/w4ICEDz5s3h7u6OnTt3on///iXeTwhRYmqfM2cOZs2aVdGlEhHVet/ujUZ6tgJ17UwwskNdqcshUqv0idqcnJzg7u6O2NhYAICjoyPy8/Px4MEDjeXS0tLg4OBQ7DqmTp2KjIwM9SUpKamyyyYiqvHOJz7A2lOJAICv+wVCrsdp7El7VHpAuXfvHpKSkuDk5AQAaNasGfT19bF//371MsnJybh8+TKCg4OLXYdcLoe5ubnGhYiInl+hUoVpWy9DCKB/0zoIqmcjdUlEGsr9E092djbi4uLUfyckJODChQuwtraGtbU1Zs6ciVdeeQVOTk64ceMGPv30U9ja2uLll18GAFhYWGDEiBGYMGECbGxsYG1tjYkTJyIwMFA9qoeIiCpPgVKFhftjEJWcCQsjfUzr6S91SURPKXdAOXv2LDp16qT+e/z48QCAYcOGYdmyZYiMjMTvv/+Ohw8fwsnJCZ06dcKff/4JMzMz9X0WLVoEPT09DBgwAI8ePUKXLl2watUq6Opy9yIRUWURQmD35RR8u/caEtJzAABTQ/1gYyqXuDKip8mEEELqIsorMzMTFhYWyMjI4M89RERlEH49HfP2XMPFpIcAABsTA4zr5oMhrdw4rJiqTHm+v3kuHiKiGizqTibm7YnGkZi7AABjA128264u3m1fF6ZyfgWQ9uKrk4ioBkq6n4sF+65h+8U7EALQ05HhjVZuGNPZG3Zm/EmHtB8DChFRDXIvW4ElYXH44+RNFCiLfsHv08gZE7r7wN2Gk7BR9cGAQkRUA+QoCrHyeAJ+OhqPbEUhAKCdty0m9/BDQB0LiasjKj8GFCKiaqxAqcKG04n47mAc0rOLTgkSWMcCk3v4oa23rcTVET0/BhQiompIpRLYGZmMBfuu4ca9XACAu40xJnb3Ra9AJ+jocGQOVW8MKERE1cw/cemYuzsakbczAAC2pgYY28UbA1u4wUCv0icIJ6oSDChERNXE5dsZmLcnGsdi0wEAJga6eK99PbzTzhMmHDJMNQxf0UREWu7mvRws2BeDHRfvAAD0dWV4o5U7xnT2gi1ngaUaigGFiEhLpWcr8MPBWKw9lYhCVdGQ4X6NnTG+my/cbIwlro6ocjGgEBFpmWxFIX4+Go9fjsUjJ18JAGjvY4dJIb4cMky1BgMKEZGWyC9UYf3pRHx/MBb3cvIBAA1dLDClhx+CvThkmGoXBhQiIompVAJ/XbqDBftikHi/aMiwp60JJnb3Rc9AR57Mj2olBhQiIgkdi72LubujceVOJgDA1lSOcV29MbCFK/R1OWSYai8GFCIiCVy+nYE5u6/in7h7AABTuR5GdaiLt9t6wtiAH81EfBcQEVWxiJsPMHDFCRSqBAx0dTCkddGQYWsTA6lLI9IaDChERFWoQKnCtK2RKFQJtPO2xeyXA+FqzSHDRE9iQCEiqkK/Hk9AdEoWrIz18d3rTbjXhKgEPAKLiKiK3HqQi8UHYgEAU3v6M5wQlYIBhYioChQoVZix/QoeFSjR0tMarzVzkbokIq3Gn3iIiCqRSiWw63Iy5u+9hhv3cqGvK8PX/QI4twnRMzCgEBFVkoe5+Rix+iwibj4AANiaGuDz3g3g7WAmcWVE2o8BhYioEuQoCvHWqjM4n/gQJga6eK99PbzTzhMmcn7sEpUF3ylERBVMUajEqD8icD7xISyM9LFxZBB8HbnXhKg8eJAsEVEFSsnIwwd/nMOx2HQYG+jit7daMJwQPQfuQSEiqgAZjwqw/Mh1/Ho8AYpCFQx0dfDT0OZo6mYldWlE1RIDChHRC8grUOL3EzfwY9h1ZDwqAAA0d7fCtF7+aMJwQvTcGFCIiJ6DUiWw5dwtLNofgzsZeQAAb3tTTOrhh67+9hxGTPSCGFCIiMpBCIGDV9Pwzd5oxKRmAwCcLAwxvpsP+jd1ga4OgwlRRWBAISIqo4ib9zF3dzTO3Cia18TCSB+jO9XDm0EeMNTXlbg6opqFAYWI6BliU7Pwzd5r2B+VCgCQ6+ng7baeGNWhHiyM9CWujqhmYkAhIirBnYePsPhADDZF3IJKADoyYEBzV4zr6gNHC0OpyyOq0RhQiIie8DA3H8sOX8eq8BtQFKoAACENHPBJiC+87DmnCVFVYEAhIvpXXoESq8JvYGlYHDLzCgEALT2sMTnUD83cOWSYqCoxoBBRrVeoVGHzuVtYtD8WKZlFQ4Z9HcwwOdQXnXw5ZJhICgwoRFSrRdy8j8mbIxGXVjRkuI6lEcZ380G/JnU4ZJhIQgwoRFRrXbr1EG+uPI2cfCUsjfUxppMXhrR255BhIi3AgEJEtVJcWhaG/VoUToLr2WD50GYwN+SQYSJtwYBCRLVO/N1sDPnlNB7kFqCRqyV+erM5TOX8OCTSJnxHElGtkZ6twJJDcVh76iYKlALe9qZYNbwFwwmRFuK7kohqvGxFIX45Fo+fj8YjJ18JAGjnbYv5rzWClYmBxNURUXEYUIioxsovVGH96UT8cCgW6dn5AICGLhaY0sMPwV62EldHRKVhQCGiGkelEvg7Mhnz915D4v1cAICHjTE+CfFDz0BHzmtCVA0woBBRjXIs9i7m7o7GlTuZAABbUznGdvXG6y1coa+rI3F1RFRWDChEVCNE3srAvD3ROB6XDgAwlethZPu6eLutJ0x4ECxRtcN3LRFVe2tO3sT0bZcBAPq6Mgxt7YHRnerBxlQucWVE9LwYUIioWtt+4TZmbC8KJy81dMLkHn5wtTaWuCoielEMKERUbR2KTsWEjRchBDA82AOf967PA2CJaggeMUZE1dLphPt4/49zKFQJvNykDma8xHBCVJMwoBBRtXP5dgZGrDoDRaEKXf3t8c2rDaHDMw8T1SgMKERUrcTfzcawX08jS1GIVp7WWDK4KYcPE9VAfFcTUbURHpeOIb+cwr2cfATUMccvw5rDUF9X6rKIqBLwIFki0nqXbxfNcXIstmiOk7p2Jlj9VkuYGepLXBkRVRYGFCLSWon3cjF/3zXsuHgHQNEcJ2+0csfYLt48yR9RDceAQkRaR6USmLcnGr/+k4ACpQAA9G3sjAndfOFmwzlOiGoDBhQi0jr7r6ZixdF4AEB7HztMCvFFQB0LiasioqrEgEJEWmdTxC0AwFttPPB57wYSV0NEUuAoHiLSKveyFQiLTgMADGrpJnE1RCQVBhQi0irbL9xBoUqgoYsFfBzMpC6HiCTCgEJEWmXzuaKfd15p6iJxJUQkJQYUItIa0SmZuHInE/q6MvRp5Cx1OUQkIQYUItIam/89OLaznz3nOSGq5RhQiEgrFCpV2Hq+aEK2V5u5SlwNEUmNAYWItMKx2HSkZytgY2KAjr52UpdDRBJjQCEirbDp34Nj+zR25tmJiYgBhYikl5FbgP1XUgFw9A4RFWFAISLJ/XXpDvKVKvg5mqGBs7nU5RCRFmBAISLJPZ775NVmLpDJZBJXQ0TaoNwB5ejRo+jduzecnZ0hk8mwbds2jduFEJg5cyacnZ1hZGSEjh074sqVKxrLKBQKfPjhh7C1tYWJiQn69OmDW7duvVAjRFQ9Xb+bjfOJD6GrI0PfxnWkLoeItES5A0pOTg4aNWqEJUuWFHv7N998g4ULF2LJkiU4c+YMHB0d0a1bN2RlZamXGTduHLZu3YoNGzbg+PHjyM7OxksvvQSlUvn8nRBRtbTl370nHXzsYGcml7gaItIW5T6bcWhoKEJDQ4u9TQiBxYsXY9q0aejfvz8AYPXq1XBwcMC6deswcuRIZGRkYOXKlVizZg26du0KAPjjjz/g6uqKAwcOICQk5AXaIaLqRKkS2HruNgAeHEtEmir0GJSEhASkpKSge/fu6uvkcjk6dOiA8PBwAEBERAQKCgo0lnF2dkZAQIB6GSKqHX4/cQN3MvJgaayPLv72UpdDRFqk3HtQSpOSkgIAcHBw0LjewcEBN2/eVC9jYGAAKyurp5Z5fP8nKRQKKBQK9d+ZmZkVWTYRSSAlIw8L9sUAAD4J8YWhvq7EFRGRNqmUUTxPHoUvhHjmkfmlLTNnzhxYWFioL66unAabqLr74u8ryFYUoqmbJQa1cJO6HCLSMhUaUBwdHQHgqT0haWlp6r0qjo6OyM/Px4MHD0pc5klTp05FRkaG+pKUlFSRZRNRFQuLTsOuyBTo6sjw9cuB0NHh0GIi0lShAcXT0xOOjo7Yv3+/+rr8/HwcOXIEwcHBAIBmzZpBX19fY5nk5GRcvnxZvcyT5HI5zM3NNS5EVP2oVAI7Lt7BpM2XAAAj2nrC34nvZyJ6WrmPQcnOzkZcXJz674SEBFy4cAHW1tZwc3PDuHHjMHv2bHh7e8Pb2xuzZ8+GsbExBg8eDACwsLDAiBEjMGHCBNjY2MDa2hoTJ05EYGCgelQPEdU8x2PTMXfPVVy+XXQMWV07E4zr6i1xVUSkrcodUM6ePYtOnTqp/x4/fjwAYNiwYVi1ahUmTZqER48e4YMPPsCDBw/QqlUr7Nu3D2ZmZur7LFq0CHp6ehgwYAAePXqELl26YNWqVdDV5UFyRDVN5K0MzNsTjeNx6QAAU7keRravi7fbesLYoEKP0yeiGkQmhBBSF1FemZmZsLCwQEZGBn/uIdJSN9JzMH/fNfx9KRkAoK8rw5DW7hjTyQs2ppyQjag2Ks/3N//7QkQV6m6WAt8fjMX604koVAnIZEC/xnUwvpsPXK2NpS6PiKoJBhQiqhBZeQX4+VgCfjkWj9z8otNWdPS1w6QQP9TnGYqJqJwYUIjohSgKlVh3KhE/HIrD/Zx8AEAjV0tM6eGHoHo2EldHRNUVAwoRPReVSuCvS3cwf981JN1/BACoa2uCT0J80SPA8ZmTMxIRlYYBhYjKRQiBo7HpmLc7GlHJRUOG7c3kGNfVB681d4G+bqVMUE1EtQwDChGVWWxqFj7fcQXh1+8BAMzkehjVsR7eauPBIcNEVKH4iUJEZRKXloUBK07gQW4BDHR18GaQO0Z38oKViYHUpRFRDcSAQkTPdOtBLoauPI0HuQVo6GKBpW80hYsVhwwTUeVhQCGiUqVl5WHoytNIzsiDl70pVr3VEtbca0JElYwBhYiK9Shfid/CE7Ds8HVk5RWijqUR1oxgOCGiqsGAQkQaCpUqbIq4hUUHYpCaqQAA+DmaYdmQZnCyMJK4OiKqLRhQiAhA0fDhvVdS8e3eaFy/mwMAqGNphAndfdC3cR3o6nBeEyKqOgwoRAQhBD7dehnrTycCAKyM9TGmszeGtHaDXI9nGSeiqseAQkSYt+ca1p9OhI4MeL9jPYzsUA/mhvpSl0VEtRgDClEtt+zwdSw/ch0AMKd/IAa2cJO4IiIiBhSiWutulgLfH4zFmpM3AQCf9vRjOCEircGAQlTLZCsK8dPRePxyLB65+UoAwJhOXnivfT2JKyMi+n8MKES1RH6hCutO3cQPh+JwLycfANDI1RJTevghqJ6NxNUREWliQCGq4VQqgb8u3cH8fdeQdP8RAKCurQkm9fBFSANHyGQcPkxE2ocBhaiGEkLgaGw65u2ORlRyJgDA3kyOcV19MKC5C/R0dSSukIioZAwoRDXQxaSHmLcnGuHX7wEAzOR6GNWxHt5u4wkjA85rQkTajwGFqAZJSM/B/L3XsDMyGQBgoKuDN4PcMbqTF6x4Dh0iqkYYUIhqgLSsPHx/MBYbTiehUCUgkwH9m7jg427ecLEylro8IqJyY0Ahqsay8gr+HTKcgEcFRUOGO/vZY1IPX/g5mktcHRHR82NAIaqGFIVKrD2ZiCVhcbj/75DhJm5FQ4Zb1eWQYSKq/hhQiKoRlUpg+8XbWLAvBrce/Dtk2M4Ek0L8ENLAgUOGiajGYEAhqgaEEDgccxff7LmGq/8OGXYwl+Pjrj54tRmHDBNRzcOAQqTlLiQ9xNzdV3Ey/j4AwMxQD+93rIe3gjlkmIhqLgYUIi11/W425u+9ht2XUwAABno6GB7sgQ861oOlMYcME1HNxoBCpGXSMvOw+GAs/jyTBKVKQEcGvNLUBeO6+aCOpZHU5RERVQkGFCItkZlXgBVHrmPl8QTkFagAAF397fFJiB98Hc0kro6IqGoxoBBJLK9AiT9O3sSSsDg8zC0AADRzt8KUUD+08LCWuDoiImkwoBBJaN+VFMz6Kwq3HxYNGfayN8WkEF90q88hw0RUuzGgEEkkJjULH6w9h0KVgKO5IcZ380H/pnU4ZJiICAwoRJJQqQQ+23oZhSqBjr52WD6kGQz1OWSYiOgx/leNSAKbzt3C6Rv3YaSvi6/6BTCcEBE9gQGFqIrdz8nHnF1XAYBnGyYiKgEDClEVSsvKw8T/XcSD3AL4OZrhrTaeUpdERKSVeAwKURXIyivAT0fj8cuxBDwqUEJXR4avXw6EPg+IJSIqFgMKUSVSFCrxx8lELDkUiwf/znHS2NUS03r5o5m7lcTVERFpLwYUokpyPDYdkzdfUs9xUtfOBJNC/BDSgHOcEBE9CwMKUSVIy8rD+2sjkJVXCAdzOcZ19cFrzVw4xwkRURkxoBBVgq/+voqsvEIE1rHAxpFBMDLgMGIiovLgf+eIKtjRmLvYcfEOdGTA7JcDGU6IiJ4DAwpRBcorUGL69ssAgDeDPBDoYiFxRURE1RN/4iGqIHezFPjy7yjcvJcLB3M5JnT3kbokIqJqiwGF6AVlKwr/neMkHrn5SgDArD4BMDPUl7gyIqLqiwGF6DnlF6qw7tRN/HAoDvdy8gEAjVwtMaWHH4Lq2UhcHRFR9caAQvQcTsXfw8RNF5F0/985TmxN8EmIL3oEOHKOEyKiCsCAQlRO5xMf4K1VZ5Cbr4SdmRzjunpjQHNXTltPRFSBGFCIyiEmNUsdTtp62eKnN5vB2IBvIyKiisb/8hGVUdL9XAxdeQoPcwvQ2NUSK4YynBARVRYGFKIyEEJgwv8uIjVTAR8HU/w2vAVM5AwnRESVhQGFqAz+F3ELpxPuw0hfFyuHtYCViYHUJRER1WgMKETPcD8nH3N2XQUAjOvqDVdrY4krIiKq+RhQiJ5hzq6reJBbAD9HM7zd1lPqcoiIagUGFKJS/BOXjv9F3AIAfP1yIIcSExFVEX7aEpXg8u0MjFoTAQAY1NINzdytJK6IiKj2YEAhKkb83WwM+/U0shSFaOlhjRkv1Ze6JCKiWoUBhegJV5MzMXTladzLyUd9J3P8Mrw5jAx0pS6LiKhW4UQORP9Kup+LRftjsPXCbQhRdH6d30e0hDnPSkxEVOUYUKjWu5+TjyWH4vDHyZvIV6oAAL0aOmF6r/qwNZVLXB0RUe3EgEK1Vm5+IVYeS8CKo/HIVhQCANp42WByDz80dLGUtjgiolqOAYVqnQKlCn+eScJ3B2NxN0sBAGjgbI4poX5o520ncXVERAQwoFAtk5zxCEN+OYXrd3MAAG7WxpgY4ouXAp2goyOTuDoiInqMAYVqlenbruD63RzYmBjgoy7eGNTSDQZ6HMxGRKRtGFCo1th7JQUHrqZCT0eGDe+1hreDmdQlERFRCfhfR6oVchSFmLnjCgDgvfZ1GU6IiLQcAwrVCov2xyA5Iw+u1kb4sLO31OUQEdEzVHhAmTlzJmQymcbF0dFRfbsQAjNnzoSzszOMjIzQsWNHXLlypaLLIFK7cicDv4XfAAB82TeAs8ISEVUDlbIHpUGDBkhOTlZfIiMj1bd98803WLhwIZYsWYIzZ87A0dER3bp1Q1ZWVmWUQrWcUiXw6dbLUKoEejV0Qkdfe6lLIiKiMqiUgKKnpwdHR0f1xc6uaG4JIQQWL16MadOmoX///ggICMDq1auRm5uLdevWVUYpVMutO52Ii0kPYSbX4wn/iIiqkUoJKLGxsXB2doanpydef/11xMfHAwASEhKQkpKC7t27q5eVy+Xo0KEDwsPDS1yfQqFAZmamxoXoWdKy8vDNnmgAwMQQXziYG0pcERERlVWFB5RWrVrh999/x969e/Hzzz8jJSUFwcHBuHfvHlJSUgAADg4OGvdxcHBQ31acOXPmwMLCQn1xdXWt6LKpBvrq76vIyitEQxcLDGntLnU5RERUDhUeUEJDQ/HKK68gMDAQXbt2xc6dOwEAq1evVi8jk2nO2CmEeOq6/5o6dSoyMjLUl6SkpIoum2qYP07exI6Ld6AjA2a/HAhdzhJLRFStVPowYxMTEwQGBiI2NlY9mufJvSVpaWlP7VX5L7lcDnNzc40LUUl2XLyD6dsvAwA+6uKNgDoWEldERETlVekBRaFQ4OrVq3BycoKnpyccHR2xf/9+9e35+fk4cuQIgoODK7sUqgXCotMw/s8LEAIY2todY7twzhMiouqowqe6nzhxInr37g03NzekpaXhq6++QmZmJoYNGwaZTIZx48Zh9uzZ8Pb2hre3N2bPng1jY2MMHjy4okuhWuRetgI/HIrD2lM3UagS6NvYGbP6NCj1p0MiItJeFR5Qbt26hUGDBiE9PR12dnZo3bo1Tp48CXf3ooMUJ02ahEePHuGDDz7AgwcP0KpVK+zbtw9mZpx6nMovR1GIX44l4Kej15GTrwQA9GrohPmvNeLZiYmIqjGZEEJIXUR5ZWZmwsLCAhkZGTwepZbKL1Rhw5lEfH8wFunZ+QCAwDoWmNzDD229bSWujoiIilOe72+ezZiqFZVKYGdkMubvu4ab93IBAO42xvgkxBc9A5y414SIqIZgQKFq43hsOubuuYrLt4sm6rM1lWNsFy+83tIN+ro87yURUU3CgEJa7/LtDMzbE41jsekAABMDXYzsUA8j2nrCRM6XMBFRTcRPd9JaN+/lYP6+GPx18Q4AQF9XhjdauWNMZy/Ymsolro6IiCoTAwppnfRsBX44GIu1pxJRqCo6hrtfY2eM7+YLNxtjiasjIqKqwIBCWiNbUYifj8bjl2Px6iHD7X3sMCnEl7PBEhHVMgwopBW2X7iNL/6Kwr2coiHDDV0sMKWHH4K9OGSYiKg2YkAhye24eAfj/p2e3tPWBBO7+6JnoCNngSUiqsUYUEhSYdf+/9w5g1u5YVafBhwyTEREDCgknWOxd/H+HxEoVAn0aeSMr/oGcKI1IiICwIBCEohNzcI3e69hf1QqAKCTrx0WDOC5c4iI6P8xoFCVSc54hEX7Y7Ap4hZUAtCRAQNbuGHGS/X5sw4REWlgQKFKl5FbgKVH4rDqnxtQFKoAAD0aOGJiiC+87E0lro6IiLQRAwpVmrwCJVaF38DSsDhk5hUCAFp6WGNKTz80dbOSuDoiItJmDChU4QqVKmw+dwuL9sciJTMPAODrYIbJob7o5GvP4cNERPRMDChUYYQQ2B+Vim/2XkNcWjYAoI6lEcZ380G/JnWgy4NgiYiojBhQqEKcuXEfc3dHI+LmAwCApbE+xnTywpDW7jDU15W4OiIiqm4YUOiFXEvJwrd7o3HgahoAwFBfByPaemJkh3owN9SXuDoiIqquGFDoudx+WDRkeMu5oiHDujoyDGzhirFdvOFgbih1eUREVM0xoFC5PMzNx9LD17Eq/Aby/x0yHBpQNGS4nh2HDBMRUcVgQKEyeZSvxG/hCVh2+Dqy/h0y3MrTGlNC/dCEQ4aJiKiCMaBQqQqVKvwv4hYWH4hBaqYCAODnaIbJoX7o6GPHIcNERFQpGFCoWEII7L2Sim/2RiP+bg6AoiHDE0N80LdRHZ43h4iIKhUDCj3lVPw9zN0TjfOJDwEAVsb6GNPZG0Nau0GuxyHDRERU+RhQSC06JRPf7LmGQ9FFQ4aN9HXxTjtPvNu+LocMExFRlWJAIdx6kIuF+2Ow9fxtiH+HDA9q6YqPOnvDnkOGiYhIAgwotdj9nHz8GBaHNSduIl9ZNGS4V6ATJnT3QV0OGSYiIgkxoNRCufmF+O2fG1h++DqyFEVDhoPq2mBKqB8auVpKWxwREREYUGqVAqUKG88mYfGBWNzNKhoyXN/JHJND/dDe25ZDhomISGswoNQCQgjsuZyCb/deQ3x60ZBhV2sjTOzui94NnTlkmIiItA4DSg2X8agA764+i9M37gMArE0M8FFnLwxu5Q4DPR2JqyMiIioeA0oN9ihfiRGrzuDszQcwNtDFO+3q4t12njDjkGEiItJyDCg1VH6hCu+vjcDZmw9gbqiHDe8Fob6zudRlERERlQn38ddASpXA+I0XcPjaXRjq6+C3t1ownBARUbXCgFLDCCEwY/tl/H0pGfq6MqwY2hzN3K2lLouIiKhcGFBqmAX7YrD2VCJkMmDRwMbo4GMndUlERETlxmNQaohCpQpLD1/HkrA4AMDX/QLxUkNniasiIiJ6Pgwo1ZwQAnuvpOLbvdG4frdojpPJPfwwuJWbxJURERE9PwaUaiyvQImRayJwJOYuAMDKWB8TuvtiSGt3iSsjIiJ6MQwo1VSBUoUx687hSEzRSJ332tXFu+3rco4TIiKqERhQqiGVSmDSpks4cDUNcj0drH6rJVrVtZG6LCIiogrDgFLNpGXlYfbOq9h24Q70dGRYNqQpwwkREdU4DCjVRLaiED8djccvx+KRm6+ETAYsGNAInf0cpC6NiIiowjGgVAMPcvIxYMUJxKZlAwAauVri01A/7jkhIqIaiwFFy2UrCjH8t9OITcuGvZkcs/o0QI8AR8hkMqlLIyIiqjQMKFosr0CJ934/i4u3MmBlrI+177SCt4OZ1GURERFVOgYULXXmxn18vfMqLiQ9hImBLla91ZLhhIiIag0GFC0Tk5qFb/ZE48DVNACAsYEufn6zORq5WkpbGBERURViQNESdx4+wqL9Mdh87hZUAtDVkWFgC1eM7eINB3NDqcsjIiKqUgwoWuCPkzfxxd9RyC9UAQBCAxwxMcQX9exMJa6MiIhIGgwoEtsccQufbbsMAGhd1xqTe/ihiZuVxFURERFJiwFFQvuupGDS5ksAgBFtPfFZL38OHyYiIgIDiiRUKoHtF29j8uZIKFUCrzZzwbSeDCdERESPMaBUsWOxdzF3dzSu3MkEAHSv74C5/QOho8NwQkRE9BgDShURQmDO7mj8dDQeAGAq18N77etiZIe60NPVkbg6IiIi7cKAUkV+DItTh5PhwR74sLMXbEzlEldFRESknRhQqsCaEzcwf18MAGDGS/XxdltPiSsiIiLSbgwolSgjtwBLD8fhp2NFe04+6uLNcEJERFQGDCiVIK9AidXhN/BjWBwy8woBFP2s83FXb4krIyIiqh4YUCqQUiWwOeIWFh2IQXJGHgDA18EMk3r4orOfPYcRExERlREDSgWJS8vGB2sjEJOaDQBwtjDE+O6+eLlJHehyCDEREVG5MKBUgFsPcjHkl1NIycyDpbE+xnTywpDW7jDU15W6NCIiomqJAeUF3c1SYOjK00jJzIOXvSn+fK81hw8TERG9IM4Q9gIS7+Vi2K+nkZCegzqWRlgzoiXDCRERUQXgHpTnkJ6twJJDcVh76iYKlAK2pgb4451WcLIwkro0IiKiGoEBpRyyFYX45Vg8fj4aj5x8JQCgnbctZvZpAE9bE4mrIyIiqjkYUMogv1CF9acT8cOhWKRn5wMAGrpYYEoPPwR72UpcHRERUc3DgFIKlUrg78hkzN97DYn3cwEAHjbG+CTEDz0DHTmvCRERUSWR9CDZpUuXwtPTE4aGhmjWrBmOHTsmZTkajsXeRe8lx/HR+vNIvJ8LW1M5vuwXgP3jO6BXQyeGEyIiokok2R6UP//8E+PGjcPSpUvRpk0brFixAqGhoYiKioKbm5tUZSHyVgbm7YnG8bh0AICpXA8j29fF2209YSLnDiciIqKqIBNCCCkeuFWrVmjatCmWLVumvs7f3x/9+vXDnDlzSr1vZmYmLCwskJGRAXNz8wqr6eDVVIxYfRYAoK8rw9DWHhjdqR6HDhMREVWA8nx/S7JLID8/HxEREZgyZYrG9d27d0d4ePhTyysUCigUCvXfmZmZlVJXGy9buFgZoYWHNcZ384GrtXGlPA4RERGVTpKAkp6eDqVSCQcHB43rHRwckJKS8tTyc+bMwaxZsyq9LkN9Xewd154/5RAREUlM0oNknzzQVAhR7MGnU6dORUZGhvqSlJRUaTUxnBAREUlPkm9jW1tb6OrqPrW3JC0t7am9KgAgl8shl/M4ECIiotpCkj0oBgYGaNasGfbv369x/f79+xEcHCxFSURERKRFJPs9Y/z48Rg6dCiaN2+OoKAg/PTTT0hMTMSoUaOkKomIiIi0hGQBZeDAgbh37x6++OILJCcnIyAgALt27YK7u7tUJREREZGWkGwelBdRWfOgEBERUeUpz/e3pKN4iIiIiIrDgEJERERahwGFiIiItA4DChEREWkdBhQiIiLSOgwoREREpHUYUIiIiEjrMKAQERGR1qmWp+59PLdcZmamxJUQERFRWT3+3i7LHLHVMqBkZWUBAFxdXSWuhIiIiMorKysLFhYWpS5TLae6V6lUuHPnDszMzCCTySp03ZmZmXB1dUVSUlKNn0afvdZM7LVmYq81T23pE/j/XhMTEyGTyeDs7AwdndKPMqmWe1B0dHTg4uJSqY9hbm5e418wj7HXmom91kzsteapLX0CgIWFRZl75UGyREREpHUYUIiIiEjrMKA8QS6X4/PPP4dcLpe6lErHXmsm9lozsdeap7b0CTxfr9XyIFkiIiKq2bgHhYiIiLQOAwoRERFpHQYUIiIi0jqSBZQ5c+agRYsWMDMzg729Pfr164dr165pLCOEwMyZM+Hs7AwjIyN07NgRV65cUd9+//59fPjhh/D19YWxsTHc3Nzw0UcfISMjQ2M9ffr0gZubGwwNDeHk5IShQ4fizp07pdaXl5eH4cOHIzAwEHp6eujXr1+xyx05cgTNmjWDoaEh6tati+XLl5epz6VLl8LT0xOGhoZo2rQp3nrrLY0++/btC5lMpnExMjKSpM8tW7agW7dusLOzg7m5OYKCgrB3796nlnuy13bt2qFTp05wdnaGTCbDtm3bntqmwcHB6Nu3L5ydnWFsbIzOnTtj6NChz9ymjykUCjRu3BgymQwXLlwotVcAiIyMRIcOHWBkZIQ6dergiy++0Jhy+fjx42jTpg1sbGxgZGQEPz8/LFq06Jm99uvXD59//rl6mzZr1gxHjx7V6NXNzQ3e3t4wMTGBs7MzBg4ciLfffluyXh+vc9q0aXB3d4dcLke9evXw66+/ltpr/fr1ERgYqNF7dHS0Rq+Ojo5PvX4dHR0l7fXHH3+Ev78/jIyM4Ovri99///2p9TzPdu3YsSN27NiBPn36wMLCAqampnB0dES9evUqvNeyvF+Tk5MxePBg+Pr6QkdHB+PGjSt2Xc/Ta1W+X6X+bGrXrh0GDRoEFxcXGBkZwcfHBx07dnxmrx4eHk+99qdMmVJqr8CzX8Nl7fVJR48eRe/evTV6fdLw4cOfqrl169bPXHelExIJCQkRv/32m7h8+bK4cOGC6NWrl3BzcxPZ2dnqZebOnSvMzMzE5s2bRWRkpBg4cKBwcnISmZmZQgghIiMjRf/+/cWOHTtEXFycOHjwoPD29havvPKKxmMtXLhQnDhxQty4cUP8888/IigoSAQFBZVaX3Z2thg1apT46aefREhIiOjbt+9Ty8THxwtjY2MxduxYERUVJX7++Wehr68vNm3aVGqftra2Qk9PT/z8888iKipKtGnTRgAQy5cvV/dpZGQkunbtKpKTk0VYWJjo2bOnWLt2rSR9jh07VsybN0+cPn1axMTEiKlTpwp9fX1x7tw5jeWe7LVFixbC3NxcrF27VgAQW7du1dimly5dEjY2NsLAwECEhYWJ6Oho8eqrrwojIyOxcePGUnt97KOPPhKhoaECgDh//nypvWZkZAgHBwfx+uuvi8jISLF582ZhZmYm5s+fr17m3LlzYt26deLy5csiISFBrFmzRhgbG4sVK1aU2muTJk0EALFkyRIRFRUlxo4dK/T19YWpqanYvHmzCA8PFw4ODsLKykqcPXtWnDhxQgQGBgpLS8tnvn4rq1chhOjTp49o1aqV2L9/v0hISBCnTp0S//zzT6m92tnZCRsbG3H69Gn1a9rS0lLjverh4SHkcrmIjY1Vv4ZfeuklyXpdunSpMDMzExs2bBDXr18X69evF6ampmLHjh2l9vqs7RoZGSl69eolZDKZGDt2rDh37pzYtWuXCA4OFr///nuF91qW92tCQoL46KOPxOrVq0Xjxo3F2LFji11XeXut6verlJ9NkZGRom7dukJXV1fs3LlTJCQkiBkzZggA4tNPPy21V3d3d/HFF1+I5ORk9SUrK6vUXsvyGi5rr0/atWuXmDZtmti8ebO61ycNGzZM9OjRQ6Pme/fulbreqiBZQHlSWlqaACCOHDkihBBCpVIJR0dHMXfuXPUyeXl5wsLCQixfvrzE9WzcuFEYGBiIgoKCEpfZvn27kMlkIj8/v0y1DRs2rNg3x6RJk4Sfn5/GdSNHjhStW7cucV2P++zTp48Q4v/7tLOzE1OmTBFCFPWpr68vGjVqVOJ6qrLP4tSvX1/MmjWr1GX+u00BiC1btmhs02vXrgkAwszMTL1NCwsLhbW1tfj555/V6ymp1127dgk/Pz9x5cqVMn3gLV26VFhYWIi8vDz1dXPmzBHOzs5CpVKVeL+XX35ZDBkypNR1P/5w/+/rV1dXV3Ts2FG9zJOv39OnTwsA4ubNm5L0unv3bmFhYVHuD6In36upqakCgBg5cqR6mSFDhgg9Pb3neq9WRq9BQUFi4sSJGvcbO3asaNOmTanrLst2ffXVV4W+vn6V9PpfZXm/dujQocSA8qRn9VrV79f/qurPJiGE8Pf3F4aGhhrbtWnTpuKzzz5T/11cr+7u7mLRokVla+xfz/vZVJZe/6u0gFLW57cqac0xKI93k1lbWwMAEhISkJKSgu7du6uXkcvl6NChA8LDw0tdj7m5OfT0ip/F//79+1i7di2Cg4Ohr6//QjWfOHFCoz4ACAkJwdmzZ1FQUFDsfe7evQsA6NSpE4D/77NLly7qvuRyORwdHREVFQV7e3v4+Pjg3XffRVpamiR9PkmlUiErK0u9rUry5DZNTU3V2KYKhQIA0LJlS3Xvurq6MDAwwPHjxzXW82SvqampePfdd7FmzRoYGxuXqe4TJ06gQ4cOGuPwQ0JCcOfOHdy4caPY+5w/fx7h4eHo0KFDievNz8/HxYsXNXpNSEiAUqnUOOP2k6/fjIwMyGQyWFpaStLrjh070Lx5c3zzzTeoU6cOfHx8MHHiRDx69KjUdT+5XS9fvgwA6NKli3oZXV1dAMDYsWOLff1Wda8KhQKGhoYa9zMyMsLp06dLfK+WZbuqVCrs2bMH9erVw6xZs2Bvb49WrVo9tRu9onqtLGXptarfr8+joj6bAKB9+/YwNDTEgQMHIIRAWFgYYmJiEBISorGe4j6H582bBxsbGzRu3Bhff/018vPzS63neT6bytprWR0+fLjE7xupaEVAEUJg/PjxaNu2LQICAgAAKSkpAAAHBweNZR0cHNS3PenevXv48ssvMXLkyKdumzx5MkxMTGBjY4PExERs3779hetOSUkptr7CwkKkp6c/tbwQQv17cMuWLdXrAAB3d3eNvry9vREQEIBDhw5hwYIFOHPmDDp37gyFQlHlfT5pwYIFyMnJwYABA0pcprht+vDhQwD/v039/Pzg7u6O+Ph4JCUlIT8/H3PnzkVKSgqSk5MBFL9NhRAYPnw4Ro0ahebNm5e57pK21+Pb/svFxQVyuRzNmzfH6NGj8c4775S43rt370KlUqFhw4ZPvX4f9/zfx0tJSUFeXh6mTJmCwYMHq89LUdW9xsfH4/jx47h8+TK2bt2KxYsXY9OmTRg9enSJ631yuwohMGPGDABAmzZt1MuFhoaiS5cuaNas2VOvXyl6DQkJwS+//IKIiAgIIXD27Fn8+uuvKCgoKPa9CpRtu6alpSE7OxuxsbEwNzfHvn378PLLL6N///44cuRIhfdaWcrSa1W/X59HRX02AcD3338POzs7bNq0CQYGBujRoweWLl2Ktm3bAij5+2bs2LHYsGEDwsLCMGbMGCxevBgffPBBqXWX57OpPL2WVWhoKNauXVvs942UtCKgjBkzBpcuXcL69eufuu3JsxULIYo9g3FmZiZ69eqF+vXr4/PPP3/q9k8++QTnz5/Hvn37oKurizfffFN9AFKDBg1gamoKU1NThIaGlqv24up7fP2xY8fU6zU1NUX37t1x9erVYu/35HV169aFvb09AgIC0Lt3b+zevRsxMTH43//+J0mfj61fvx4zZ87En3/+CXt7ewB4qs+1a9eWaZvq6+tj8+bNyMjIQFhYGIyNjXH48GGEhoZCV1e3xG36ww8/IDMzE1OnTi2xzpJ6LW17/dexY8dw9uxZLF++HIsXL1b3UVyv06ZNAwB88cUXJfb65OO9/vrrUKlUWLp0KYCSX7+V2atKpYJMJsPatWvRsmVL9OzZEwsXLsSqVavw6NGjMm3XMWPGIC4u7qnHGzhwIFxdXWFmZqbx+t25c6ckvU6fPh2hoaFo3bo19PX10bdvXwwfPhxA0V6A592uKpUKQNGBkR4eHmjcuDGmTJmCl156CcuXL6+UXl/U8/Yqxfu1PCryswkoCiipqalo0qQJIiIisGDBAnzwwQc4cOBAqd83H3/8MTp06ICGDRvinXfewfLly7Fy5Urcu3ev1F7L+tlUnl7LauDAgejVq9dT3zc7d+4s8zoqg+RnM/7www+xY8cOHD16VOMMxY6OjgCK0qOTk5P6+rS0tKeSZlZWFnr06AFTU1Ns3bq12J80bG1tYWtrCx8fH/j7+8PV1RUnT55EUFAQdu3apd7Na2RkVObaHR0dn0q3aWlp0NPTg42NDSwsLNRHqn/xxRc4dOgQDh48iAYNGqjv97jPmzdvavT1ZJ9OTk5wdXXFtGnT4O3tXaV9Pvbnn39ixIgR+N///oeuXbuqr2/evLnGEfnffvstdu3a9dQ2ffxTxn+3abNmzdC2bVsYGxur/8fSqlUrNGzYsMRteujQIZw8efKpKZObN2+ON954A6tXry6215K2F/D0njpPT08AQGBgIFJTUzFz5kwMGjSo2F4PHjwIHR0d9ZfV48cCis7c+V8pKSm4evUqrKyscOjQIZibm5f6+q3MXp2cnFCnTh2NGv39/SGEwK1bt565XR+/d//880907Nix1Peqk5MT3N3dcfnyZcyfP7/KezUyMsKvv/6KFStWIDU1FU5OTvjpp59gZmYGW1tbmJmZPdd2tbW1hZ6eHvT19TVeQ/7+/jhy5EiFb9eK8CKv4ap8v5ZHRX82PXr0CJ9++imaNm0KX19fNGzYEA0bNsSFCxcwd+5c5Obmlvp981+PR8PExcXBxsbmhT+bytrrk/crj8fv19jY2OdeR4WowuNdNKhUKjF69Gjh7OwsYmJiir3d0dFRzJs3T32dQqF46iDZjIwM0bp1a9GhQweRk5NTpsdOTEwUAERYWFiZli/tIFl/f3+N60aNGqVxkGxxfbZs2VK8//77Gn3a29urD5Itrs+EhAQhk8mEn59flfcphBDr1q0ThoaGxR5g9Vhp2xT/ORCttG0aExMjZDKZ8Pf3L3Gb3rx5U0RGRqove/fuFQDEpk2bRFJSUon1LV26VFhaWgqFQqG+bu7cuc88EO2LL74Q7u7upfb63236+PYnD6bMzs4Wenp6wsnJSaSlpQkhnv36rcxeV6xYIYyMjDRGGGzbtk3o6OiI3NzcEnst7u9nbdf09HRhYGAg6tWrpzXbtX379mLQoEEa1z3Pdm3VqtVTB8n26tVL2NjYVHiv//WiB8k+T69V+X4ta6+V8dmUkZEhAAgTExON7Tp8+HBhYWFRru+bv/7666mD4Z9U1tdwWXotDUo4SPZJ6enpQi6Xi9WrVz/X41QUyQLK+++/LywsLMThw4c1hjb994Nx7ty5wsLCQmzZskVERkaKQYMGaQwzzszMFK1atRKBgYEiLi5OYz2FhYVCCCFOnTolfvjhB3H+/Hlx48YNcejQIdG2bVtRr149jSOmi3PlyhVx/vx50bt3b9GxY0dx/vx5jSPPHw8z/vjjj0VUVJRYuXLlU8OMi+tz+fLlQk9PT6xcubLYYcavvfaaMDExUQ/93LlzpzA1NRV6enriwoULVd7nunXrhJ6envjxxx81Hvvhw4elbtO4uDixf/9+ceLECQFALFy4UHz00UfC3NxcvU3btGkjbGxsxMWLF8W2bduEq6ursLKyKnWbPikhIaFMowIePnwoHBwcxKBBg0RkZKTYsmWLMDc31xjKt2TJErFjxw4RExMjYmJixK+//irMzc3FtGnTSu318TZdtmyZiIqKEuPGjRP6+vrCzMxMbNmyRZw/f17UqVNH6OjoiH/++UckJyeL2NhY0bRpUxEQECBJr1lZWcLFxUW8+uqr4sqVK+LIkSPC29tbvPPOO6X2OmzYMGFmZib27t2rrnfatGnq9+qpU6eEn5+fsLW1FZGRkSIsLEy0bNlS6OvriwYNGkjS67Vr18SaNWtETEyMOHXqlBg4cKCwtrYWCQkJpfb6rO0aGRkp2rVrJwCI77//XsTGxopvv/1WABB169at8F6FePb7VQihvq5Zs2Zi8ODB4vz58+LKlSsv3GtVvl/L0mtlfjbZ29sLPT09sXPnThEfHy+WLl0qZDKZcHZ2LrHX8PBwsXDhQnH+/HkRHx8v/vzzT+Hs7KwetVmSsryGy9rrk7KystTP2+Nez58/rw5MWVlZYsKECSI8PFwkJCSIsLAwERQUJOrUqaP+rpWKZAEFQLGX3377Tb2MSqUSn3/+uXB0dBRyuVy0b99eREZGqm8PCwsrcT2PP3guXbokOnXqJKytrYVcLhceHh5i1KhR4tatW8+s0d3dvdh1/9fhw4dFkyZNhIGBgfDw8BDLli0rU59DhgwR7u7uwsDAQDRp0kQMHz5c3Wfbtm1FUFCQsLOzE/r6+sLe3l7SPjt06FDs7cOGDStTr09eGjVqpO61Xr16wsHBQejr6ws3NzcxZMiQZ/b6pPJ84F26dEm0a9dOyOVy4ejoKGbOnKnxP5Tvv/9eNGjQQBgbGwtzc3PRpEkTsXTpUqFUKsvU6+N5Ipo2bSoOHz6sfv0aGBiU+fmpql6FEOLq1auia9euwsjISLi4uIjx48dr/CehtF6fvPTt21e9Xa2srISVlZV6u4aEhEjaa1RUlGjcuLEwMjIS5ubmom/fviI6Ovqp9ZR3uz7+XJo1a5bw8vIShoaGol69epXaa1k+l4q7/cm9gM/Ta1W/X6X8bGrdurXo27evcHZ2FoaGhsLV1fWZvUZERIhWrVoJCwsLYWhoKHx9fcXnn39epr0tz3oNl7XXJ5X0Pfn4frm5uaJ79+7q7xs3NzcxbNgwkZiY+MyaKxvPZkxERERaRytG8RARERH9FwMKERERaR0GFCIiItI6DChERESkdRhQiIiISOswoBAREZHWYUAhIiIircOAQkRERFqHAYWIJDV8+HD069ev0tZ/+PBhyGQyPHz4sNIeg4gqHgMKEdETOnbsiHHjxkldBlGtxoBCREREWocBhagW2bRpEwIDA2FkZAQbGxt07doVOTk5OHPmDLp16wZbW1tYWFigQ4cOOHfunMZ9ZTIZVqxYgZdeegnGxsbw9/fHiRMnEBcXh44dO8LExARBQUG4fv26+j4zZ85E48aNsWLFCri6usLY2BivvfZaqT+3CCHwzTffoG7dujAyMkKjRo2wadOmMve4a9cu+Pj4wMjICJ06dcKNGzc0br937x4GDRoEFxcXGBsbIzAwEOvXr1ffPnz4cBw5cgTfffcdZDIZZDKZeh1RUVHo2bMnTE1N4eDggKFDhyI9Pb3MtRFR2TGgENUSycnJGDRoEN5++21cvXoVhw8fRv/+/SGEQFZWFoYNG4Zjx47h5MmT8Pb2Rs+ePZGVlaWxji+//BJvvvkmLly4AD8/PwwePBgjR47E1KlTcfbsWQDAmDFjNO4TFxeHjRs34q+//sKePXtw4cIFjB49usQ6P/vsM/z2229YtmwZrly5go8//hhDhgzBkSNHntljUlIS+vfvj549e+LChQt45513MGXKFI1l8vLy0KxZM/z999+4fPky3nvvPQwdOhSnTp0CAHz33XcICgrCu+++i+TkZCQnJ8PV1RXJycno0KEDGjdujLNnz2LPnj1ITU3FgAEDyvT8E1E5SXsyZSKqKhEREQKAuHHjxjOXLSwsFGZmZuKvv/5SXwdAfPbZZ+q/T5w4IQCIlStXqq9bv369MDQ0VP/9+eefC11dXZGUlKS+bvfu3UJHR0ckJycLIYQYNmyY6Nu3rxBCiOzsbGFoaCjCw8M16hkxYoQYNGjQM+ueOnWq8Pf31zhN/eTJkwUA8eDBgxLv17NnTzFhwgT13x06dBBjx47VWGb69Omie/fuGtclJSUJAOLatWvPrI2IykdP0nRERFWmUaNG6NKlCwIDAxESEoLu3bvj1VdfhZWVFdLS0jBjxgwcOnQIqampUCqVyM3NRWJiosY6GjZsqP63g4MDACAwMFDjury8PGRmZsLc3BwA4ObmBhcXF/UyQUFBUKlUuHbtGhwdHTXWHxUVhby8PHTr1k3j+vz8fDRp0uSZPV69ehWtW7eGTCbTeLz/UiqVmDt3Lv7880/cvn0bCoUCCoUCJiYmpa47IiICYWFhMDU1feq269evw8fH55n1EVHZMaAQ1RK6urrYv38/wsPDsW/fPvzwww+YNm0aTp06hdGjR+Pu3btYvHgx3N3dIZfLERQUhPz8fI116Ovrq//9OAQUd51KpSqxjsfL/DdEPPb4fjt37kSdOnU0bpPL5c/sUQjxzGUWLFiARYsWYfHixQgMDISJiQnGjRv3VK/F1da7d2/MmzfvqducnJye+bhEVD4MKES1iEwmQ5s2bdCmTRvMmDED7u7u2Lp1K44dO4alS5eiZ8+eAIqO5aiogz8TExNx584dODs7AwBOnDgBHR2dYvc41K9fH3K5HImJiejQoUO5H6t+/frYtm2bxnUnT57U+PvYsWPo27cvhgwZAqAoeMTGxsLf31+9jIGBAZRKpcb9mjZtis2bN8PDwwN6evzoJKpsPEiWqJY4deoUZs+ejbNnzyIxMRFbtmzB3bt34e/vDy8vL6xZswZXr17FqVOn8MYbb8DIyKhCHtfQ0BDDhg3DxYsXcezYMXz00UcYMGDAUz/vAICZmRkmTpyIjz/+GKtXr8b169dx/vx5/Pjjj1i9evUzH2vUqFG4fv06xo8fj2vXrmHdunVYtWqVxjJeXl7qPUlXr17FyJEjkZKSorGMh4cHTp06hRs3biA9PR0qlQqjR4/G/fv3MWjQIJw+fRrx8fHYt28f3n777afCDBG9OAYUolrC3NwcR48eRc+ePeHj44PPPvsMCxYsQGhoKH799Vc8ePAATZo0wdChQ/HRRx/B3t6+Qh7Xy8tLPbKme/fuCAgIwNKlS0tc/ssvv8SMGTMwZ84c+Pv7IyQkBH/99Rc8PT2f+Vhubm7YvHkz/vrrLzRq1AjLly/H7NmzNZaZPn06mjZtipCQEHTs2BGOjo5PzWQ7ceJE6Orqon79+rCzs0NiYiKcnZ3xzz//QKlUIiQkBAEBARg7diwsLCygo8OPUqKKJhNl+dGWiOg5zJw5E9u2bcOFCxekLoWIqhnGfiIiItI6DChEVG2MGjUKpqamxV5GjRoldXlEVIH4Ew8RVRtpaWnIzMws9jZzc/MKO26GiKTHgEJERERahz/xEBERkdZhQCEiIiKtw4BCREREWocBhYiIiLQOAwoRERFpHQYUIiIi0joMKERERKR1GFCIiIhI6/wfArsnsluVltMAAAAASUVORK5CYII=",
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_stars.plot(x='sample_date', y='cumulative_amount')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.11.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}