Diarie Linköpings kommun.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Diarie Linköpings kommun\n",
    "* Denna [Jupyter Notebook](https://github.com/salgo60/open-data-examples/blob/master/Diarie%20Link%C3%B6pings%20kommun.ipynb)\n",
    "\n",
    "* om [ärenden Linköping](https://www.linkoping.se/open/data/arende/)\n",
    "\n",
    "OBS unik nyckel måste begäras se [open](https://www.linkoping.se/open/)\n",
    "\n",
    "GITHUB [open-data-examples](https://github.com/salgo60/open-data-examples)   \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'http://arendedata.linkoping.se/api/v1/Cases?maxItemsInResult=1000&api_key=e4628c0b272a454f855ec3784b7b61a0'"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from IPython.display  import JSON\n",
    "import requests\n",
    "import json\n",
    "key = \"e4628c0b272a454f855ec3784b7b61a0\"\n",
    "baseUrl = \"http://arendedata.linkoping.se/api/v1/\"\n",
    "endpoint = \"Cases?maxItemsInResult=1000&api_key=\"\n",
    "headers = {'content-type': 'application/json'}\n",
    "url = baseUrl + endpoint + key\n",
    "url\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "req = requests.get(url,headers=headers)\n",
    "data = json.loads(req.text)\n",
    "import pandas as pd\n",
    "df = pd.DataFrame(data)\n",
    "df.head(n=40) \n",
    "req"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "%matplotlib inline \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1000 entries, 0 to 999\n",
      "Data columns (total 6 columns):\n",
      " #   Column          Non-Null Count  Dtype \n",
      "---  ------          --------------  ----- \n",
      " 0   caseNumber      1000 non-null   object\n",
      " 1   subject         1000 non-null   object\n",
      " 2   registeredDate  1000 non-null   object\n",
      " 3   closedDate      109 non-null    object\n",
      " 4   diary           1000 non-null   object\n",
      " 5   hasEvents       1000 non-null   bool  \n",
      "dtypes: bool(1), object(5)\n",
      "memory usage: 40.2+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>caseNumber</th>\n",
       "      <th>subject</th>\n",
       "      <th>registeredDate</th>\n",
       "      <th>closedDate</th>\n",
       "      <th>diary</th>\n",
       "      <th>hasEvents</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SON 2021-779</td>\n",
       "      <td>Statlig ersättning för försörjningsstöd för en...</td>\n",
       "      <td>2021-06-24T14:05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>SON 2021</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>KOF 2021-160</td>\n",
       "      <td>Friidrottshallen från och med 2021</td>\n",
       "      <td>2021-06-24T14:02:00</td>\n",
       "      <td>None</td>\n",
       "      <td>KOF 2021</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SON 2021-778</td>\n",
       "      <td>Sätt stopp för bidragsfusk i välfärd svar på m...</td>\n",
       "      <td>2021-06-24T13:49:00</td>\n",
       "      <td>None</td>\n",
       "      <td>SON 2021</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SON 2021-777</td>\n",
       "      <td>Stoppa dem som skor sig på vård välfärd svar p...</td>\n",
       "      <td>2021-06-24T13:43:00</td>\n",
       "      <td>None</td>\n",
       "      <td>SON 2021</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BOU 2021-591</td>\n",
       "      <td>--- Sekretess ---</td>\n",
       "      <td>2021-06-24T13:34:32.083</td>\n",
       "      <td>None</td>\n",
       "      <td>BOU 2021</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>BOU 2021-590</td>\n",
       "      <td>--- Sekretess ---</td>\n",
       "      <td>2021-06-24T13:26:35.47</td>\n",
       "      <td>None</td>\n",
       "      <td>BOU 2021</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>BIN 2021-450</td>\n",
       "      <td>--- Sekretess ---</td>\n",
       "      <td>2021-06-24T13:14:29.53</td>\n",
       "      <td>None</td>\n",
       "      <td>BIN 2021</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>BIN 2021-449</td>\n",
       "      <td>--- Sekretess ---</td>\n",
       "      <td>2021-06-24T13:11:58.07</td>\n",
       "      <td>None</td>\n",
       "      <td>BIN 2021</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>KS 2021-560</td>\n",
       "      <td>Förslag till lokal utvecklingsstrategi</td>\n",
       "      <td>2021-06-24T12:52:00</td>\n",
       "      <td>None</td>\n",
       "      <td>KS 2021</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>BIN 2021-448</td>\n",
       "      <td>--- Sekretess ---</td>\n",
       "      <td>2021-06-24T12:14:19.57</td>\n",
       "      <td>None</td>\n",
       "      <td>BIN 2021</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>BMN 2021-79</td>\n",
       "      <td>Remiss: Förslag till föreskrifter om bekämpnin...</td>\n",
       "      <td>2021-06-24T11:33:19.37</td>\n",
       "      <td>None</td>\n",
       "      <td>BMN 2021</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>SON 2021-776</td>\n",
       "      <td>Upphandling av bankkort</td>\n",
       "      <td>2021-06-24T11:27:00</td>\n",
       "      <td>None</td>\n",
       "      <td>SON 2021</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>VN 2021-41</td>\n",
       "      <td>Jämställdhetsbokslut för 2019 och 2020</td>\n",
       "      <td>2021-06-24T10:51:00</td>\n",
       "      <td>None</td>\n",
       "      <td>VN 2021</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>VN 2021-42</td>\n",
       "      <td>Uppföljningen av måluppfyllelse för 2018 för m...</td>\n",
       "      <td>2021-06-24T10:51:00</td>\n",
       "      <td>None</td>\n",
       "      <td>VN 2021</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>VN 2021-40</td>\n",
       "      <td>Barnbokslut 2019 och 2020</td>\n",
       "      <td>2021-06-24T10:50:00</td>\n",
       "      <td>None</td>\n",
       "      <td>VN 2021</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>VN 2021-39</td>\n",
       "      <td>Energi- och klimatbokslut verksamhetsåret 2019</td>\n",
       "      <td>2021-06-24T10:48:00</td>\n",
       "      <td>None</td>\n",
       "      <td>VN 2021</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>VN 2021-38</td>\n",
       "      <td>Riktlinje för IT-styrning</td>\n",
       "      <td>2021-06-24T10:46:00</td>\n",
       "      <td>None</td>\n",
       "      <td>VN 2021</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>VN 2021-37</td>\n",
       "      <td>Reklam inför valet</td>\n",
       "      <td>2021-06-24T10:44:00</td>\n",
       "      <td>None</td>\n",
       "      <td>VN 2021</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>SON 2021-775</td>\n",
       "      <td>Avropsavtal för handledningstjänster IFO BoU u...</td>\n",
       "      <td>2021-06-24T10:03:00</td>\n",
       "      <td>None</td>\n",
       "      <td>SON 2021</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>SBN 2021-661</td>\n",
       "      <td>Kontrakt Hanorpsvägen</td>\n",
       "      <td>2021-06-24T09:21:00</td>\n",
       "      <td>None</td>\n",
       "      <td>SBN 2021</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      caseNumber                                            subject  \\\n",
       "0   SON 2021-779  Statlig ersättning för försörjningsstöd för en...   \n",
       "1   KOF 2021-160                 Friidrottshallen från och med 2021   \n",
       "2   SON 2021-778  Sätt stopp för bidragsfusk i välfärd svar på m...   \n",
       "3   SON 2021-777  Stoppa dem som skor sig på vård välfärd svar p...   \n",
       "4   BOU 2021-591                                  --- Sekretess ---   \n",
       "5   BOU 2021-590                                  --- Sekretess ---   \n",
       "6   BIN 2021-450                                  --- Sekretess ---   \n",
       "7   BIN 2021-449                                  --- Sekretess ---   \n",
       "8    KS 2021-560             Förslag till lokal utvecklingsstrategi   \n",
       "9   BIN 2021-448                                  --- Sekretess ---   \n",
       "10   BMN 2021-79  Remiss: Förslag till föreskrifter om bekämpnin...   \n",
       "11  SON 2021-776                            Upphandling av bankkort   \n",
       "12    VN 2021-41             Jämställdhetsbokslut för 2019 och 2020   \n",
       "13    VN 2021-42  Uppföljningen av måluppfyllelse för 2018 för m...   \n",
       "14    VN 2021-40                          Barnbokslut 2019 och 2020   \n",
       "15    VN 2021-39     Energi- och klimatbokslut verksamhetsåret 2019   \n",
       "16    VN 2021-38                          Riktlinje för IT-styrning   \n",
       "17    VN 2021-37                                 Reklam inför valet   \n",
       "18  SON 2021-775  Avropsavtal för handledningstjänster IFO BoU u...   \n",
       "19  SBN 2021-661                              Kontrakt Hanorpsvägen   \n",
       "\n",
       "             registeredDate closedDate     diary  hasEvents  \n",
       "0       2021-06-24T14:05:00       None  SON 2021       True  \n",
       "1       2021-06-24T14:02:00       None  KOF 2021      False  \n",
       "2       2021-06-24T13:49:00       None  SON 2021       True  \n",
       "3       2021-06-24T13:43:00       None  SON 2021       True  \n",
       "4   2021-06-24T13:34:32.083       None  BOU 2021       True  \n",
       "5    2021-06-24T13:26:35.47       None  BOU 2021       True  \n",
       "6    2021-06-24T13:14:29.53       None  BIN 2021       True  \n",
       "7    2021-06-24T13:11:58.07       None  BIN 2021       True  \n",
       "8       2021-06-24T12:52:00       None   KS 2021       True  \n",
       "9    2021-06-24T12:14:19.57       None  BIN 2021       True  \n",
       "10   2021-06-24T11:33:19.37       None  BMN 2021       True  \n",
       "11      2021-06-24T11:27:00       None  SON 2021       True  \n",
       "12      2021-06-24T10:51:00       None   VN 2021       True  \n",
       "13      2021-06-24T10:51:00       None   VN 2021       True  \n",
       "14      2021-06-24T10:50:00       None   VN 2021       True  \n",
       "15      2021-06-24T10:48:00       None   VN 2021       True  \n",
       "16      2021-06-24T10:46:00       None   VN 2021       True  \n",
       "17      2021-06-24T10:44:00       None   VN 2021       True  \n",
       "18      2021-06-24T10:03:00       None  SON 2021       True  \n",
       "19      2021-06-24T09:21:00       None  SBN 2021       True  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(20)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Ärenden"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>eventNumber</th>\n",
       "      <th>eventName</th>\n",
       "      <th>direction</th>\n",
       "      <th>date</th>\n",
       "      <th>eventType</th>\n",
       "      <th>senderOrReceiver</th>\n",
       "      <th>case</th>\n",
       "      <th>caseNumber</th>\n",
       "      <th>diary</th>\n",
       "      <th>diaryId</th>\n",
       "      <th>documentNumber</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SON 2020-593: 6</td>\n",
       "      <td>Hemlöshetsundersökning i Linköpings kommun 2020</td>\n",
       "      <td>In</td>\n",
       "      <td>2021-06-24T15:32:19.11</td>\n",
       "      <td>Skrivelse</td>\n",
       "      <td>None</td>\n",
       "      <td>Hemlöshet i Linköpings kommun</td>\n",
       "      <td>SON 2020-593</td>\n",
       "      <td>Social- och omsorgsnämnden</td>\n",
       "      <td>215</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SON 2021-776: 1</td>\n",
       "      <td>Avbrytande beslut</td>\n",
       "      <td>In</td>\n",
       "      <td>2021-06-24T15:25:07.83</td>\n",
       "      <td>Beslut</td>\n",
       "      <td>{'name': '', 'organization': None}</td>\n",
       "      <td>Upphandling av bankkort</td>\n",
       "      <td>SON 2021-776</td>\n",
       "      <td>Social- och omsorgsnämnden</td>\n",
       "      <td>215</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>KOF 2019-14: 22</td>\n",
       "      <td>Avtal Linköpings Sporthall - TG 1</td>\n",
       "      <td>Upp</td>\n",
       "      <td>2021-06-24T15:24:53.303</td>\n",
       "      <td>Avtal</td>\n",
       "      <td>{'name': '', 'organization': None}</td>\n",
       "      <td>Upphandling drift och skötsel - Linköpings Spo...</td>\n",
       "      <td>KOF 2019-14</td>\n",
       "      <td>Kultur- och fritidsnämnden</td>\n",
       "      <td>49</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SON 2020-1206: 8</td>\n",
       "      <td>SBN § 116 Policy för ett ökat träbyggande i Li...</td>\n",
       "      <td>In</td>\n",
       "      <td>2021-06-24T15:23:45.747</td>\n",
       "      <td>Beslut</td>\n",
       "      <td>{'name': '', 'organization': None}</td>\n",
       "      <td>Handlingar för kännedom</td>\n",
       "      <td>SON 2020-1206</td>\n",
       "      <td>Social- och omsorgsnämnden</td>\n",
       "      <td>215</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SBN 2021-10: 188</td>\n",
       "      <td>Grannehörande - Idrottsgrenen 2 (Drabantgatan 37)</td>\n",
       "      <td>Ut</td>\n",
       "      <td>2021-06-24T15:22:48.243</td>\n",
       "      <td>Yttrande</td>\n",
       "      <td>{'name': '', 'organization': 'mos/mex'}</td>\n",
       "      <td>Remiss grannehörande - Grannemedgivande bygglov</td>\n",
       "      <td>SBN 2021-10</td>\n",
       "      <td>Samhällsbyggnadsnämnden</td>\n",
       "      <td>118</td>\n",
       "      <td>188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>KOF 2021-58: 7</td>\n",
       "      <td>Granskning och samråd aktiviteter Handlingspla...</td>\n",
       "      <td>In</td>\n",
       "      <td>2021-06-24T15:22:31.497</td>\n",
       "      <td>Skrivelse</td>\n",
       "      <td>{'name': '', 'organization': None}</td>\n",
       "      <td>Handlingsplan för Linköpings kommuns kulturpol...</td>\n",
       "      <td>KOF 2021-58</td>\n",
       "      <td>Kultur- och fritidsnämnden</td>\n",
       "      <td>49</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>SON 2020-1206: 7</td>\n",
       "      <td>Kf § 276 Stoppa dem som skor sig på vår välfärd</td>\n",
       "      <td>In</td>\n",
       "      <td>2021-06-24T15:22:15.537</td>\n",
       "      <td>Beslut</td>\n",
       "      <td>{'name': '', 'organization': None}</td>\n",
       "      <td>Handlingar för kännedom</td>\n",
       "      <td>SON 2020-1206</td>\n",
       "      <td>Social- och omsorgsnämnden</td>\n",
       "      <td>215</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>SON 2021-777: 1</td>\n",
       "      <td>Kf § 276 Stoppa dem som skor sig på vår välfärd</td>\n",
       "      <td>In</td>\n",
       "      <td>2021-06-24T15:21:25.133</td>\n",
       "      <td>Beslut</td>\n",
       "      <td>{'name': '', 'organization': None}</td>\n",
       "      <td>Stoppa dem som skor sig på vård välfärd svar p...</td>\n",
       "      <td>SON 2021-777</td>\n",
       "      <td>Social- och omsorgsnämnden</td>\n",
       "      <td>215</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>SBN 2021-10: 187</td>\n",
       "      <td>Grannehörande - Glasfatet 3 (Roxtorpsgatan 14)</td>\n",
       "      <td>Ut</td>\n",
       "      <td>2021-06-24T15:21:20.017</td>\n",
       "      <td>Yttrande</td>\n",
       "      <td>{'name': '', 'organization': 'mos/mex'}</td>\n",
       "      <td>Remiss grannehörande - Grannemedgivande bygglov</td>\n",
       "      <td>SBN 2021-10</td>\n",
       "      <td>Samhällsbyggnadsnämnden</td>\n",
       "      <td>118</td>\n",
       "      <td>187</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>SON 2020-1206: 6</td>\n",
       "      <td>Kf § 275 Sätt stopp för bidragsfusk i välfärde...</td>\n",
       "      <td>In</td>\n",
       "      <td>2021-06-24T15:19:44.73</td>\n",
       "      <td>None</td>\n",
       "      <td>{'name': '', 'organization': None}</td>\n",
       "      <td>Handlingar för kännedom</td>\n",
       "      <td>SON 2020-1206</td>\n",
       "      <td>Social- och omsorgsnämnden</td>\n",
       "      <td>215</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        eventNumber                                          eventName  \\\n",
       "0   SON 2020-593: 6    Hemlöshetsundersökning i Linköpings kommun 2020   \n",
       "1   SON 2021-776: 1                                  Avbrytande beslut   \n",
       "2   KOF 2019-14: 22                  Avtal Linköpings Sporthall - TG 1   \n",
       "3  SON 2020-1206: 8  SBN § 116 Policy för ett ökat träbyggande i Li...   \n",
       "4  SBN 2021-10: 188  Grannehörande - Idrottsgrenen 2 (Drabantgatan 37)   \n",
       "5    KOF 2021-58: 7  Granskning och samråd aktiviteter Handlingspla...   \n",
       "6  SON 2020-1206: 7    Kf § 276 Stoppa dem som skor sig på vår välfärd   \n",
       "7   SON 2021-777: 1    Kf § 276 Stoppa dem som skor sig på vår välfärd   \n",
       "8  SBN 2021-10: 187     Grannehörande - Glasfatet 3 (Roxtorpsgatan 14)   \n",
       "9  SON 2020-1206: 6  Kf § 275 Sätt stopp för bidragsfusk i välfärde...   \n",
       "\n",
       "  direction                     date  eventType  \\\n",
       "0        In   2021-06-24T15:32:19.11  Skrivelse   \n",
       "1        In   2021-06-24T15:25:07.83     Beslut   \n",
       "2       Upp  2021-06-24T15:24:53.303      Avtal   \n",
       "3        In  2021-06-24T15:23:45.747     Beslut   \n",
       "4        Ut  2021-06-24T15:22:48.243   Yttrande   \n",
       "5        In  2021-06-24T15:22:31.497  Skrivelse   \n",
       "6        In  2021-06-24T15:22:15.537     Beslut   \n",
       "7        In  2021-06-24T15:21:25.133     Beslut   \n",
       "8        Ut  2021-06-24T15:21:20.017   Yttrande   \n",
       "9        In   2021-06-24T15:19:44.73       None   \n",
       "\n",
       "                          senderOrReceiver  \\\n",
       "0                                     None   \n",
       "1       {'name': '', 'organization': None}   \n",
       "2       {'name': '', 'organization': None}   \n",
       "3       {'name': '', 'organization': None}   \n",
       "4  {'name': '', 'organization': 'mos/mex'}   \n",
       "5       {'name': '', 'organization': None}   \n",
       "6       {'name': '', 'organization': None}   \n",
       "7       {'name': '', 'organization': None}   \n",
       "8  {'name': '', 'organization': 'mos/mex'}   \n",
       "9       {'name': '', 'organization': None}   \n",
       "\n",
       "                                                case     caseNumber  \\\n",
       "0                      Hemlöshet i Linköpings kommun   SON 2020-593   \n",
       "1                            Upphandling av bankkort   SON 2021-776   \n",
       "2  Upphandling drift och skötsel - Linköpings Spo...    KOF 2019-14   \n",
       "3                            Handlingar för kännedom  SON 2020-1206   \n",
       "4    Remiss grannehörande - Grannemedgivande bygglov    SBN 2021-10   \n",
       "5  Handlingsplan för Linköpings kommuns kulturpol...    KOF 2021-58   \n",
       "6                            Handlingar för kännedom  SON 2020-1206   \n",
       "7  Stoppa dem som skor sig på vård välfärd svar p...   SON 2021-777   \n",
       "8    Remiss grannehörande - Grannemedgivande bygglov    SBN 2021-10   \n",
       "9                            Handlingar för kännedom  SON 2020-1206   \n",
       "\n",
       "                        diary  diaryId  documentNumber  \n",
       "0  Social- och omsorgsnämnden      215               6  \n",
       "1  Social- och omsorgsnämnden      215               1  \n",
       "2  Kultur- och fritidsnämnden       49              22  \n",
       "3  Social- och omsorgsnämnden      215               8  \n",
       "4     Samhällsbyggnadsnämnden      118             188  \n",
       "5  Kultur- och fritidsnämnden       49               7  \n",
       "6  Social- och omsorgsnämnden      215               7  \n",
       "7  Social- och omsorgsnämnden      215               1  \n",
       "8     Samhällsbyggnadsnämnden      118             187  \n",
       "9  Social- och omsorgsnämnden      215               6  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "endpointEvent = \"Events?maxItemsInResult=1000&api_key=f3d212d2700f4c80aba7d2a88bc94529\"\n",
    "urlEvent = baseUrl + endpointEvent \n",
    "dataEvent = json.loads(requests.get(urlEvent).text)\n",
    "import pandas as pd\n",
    "dfEvent = pd.DataFrame(dataEvent)\n",
    "dfEvent.head(n=10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Barn- och ungdomsnämnden      213\n",
       "Social- och omsorgsnämnden    177\n",
       "Äldrenämnden                  145\n",
       "Samhällsbyggnadsnämnden       135\n",
       "Kommunstyrelsen               127\n",
       "Bildningsnämnden               84\n",
       "Kultur- och fritidsnämnden     44\n",
       "Arbetsmarknadsnämnden          38\n",
       "Överförmyndarnämnden           19\n",
       "Valnämnden                     14\n",
       "Bygg- och Miljönämnden          4\n",
       "Name: diary, dtype: int64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.set_option('display.max_rows', None) \n",
    "dfEvent[\"diary\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}