aggregate_closed_harvests.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Comparing harvests of closed files\n",
    "\n",
    "This notebook brings together annual harvests of files with an access status of 'closed', scraped from the NAA's RecordSearch database. The data files are here:\n",
    "\n",
    "* [2015](data/closed-20160101.csv) (harvested 1 January 2016)\n",
    "* [2016](data/closed-20170109.csv) (harvested 9 January 2017)\n",
    "* [2017](data/closed-20180101.csv) (harvested 1 January 2018)\n",
    "* [2018](data/closed-20190101.csv) (harvested 1 January 2019)\n",
    "* [2019](data/closed-20200101.csv) (harvested 1 January 2020)\n",
    "* [2020](data/closed-20210101.csv) (harvested 1 January 2021)\n",
    "\n",
    "The current code used to harvest 'closed' files is in [this notebook](harvest_closed_files.ipynb). Previous versions can be found in [this repository](https://github.com/wragge/closed_access)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "from pathlib import Path\n",
    "\n",
    "import altair as alt\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "harvests = {\n",
    "    \"2015\": \"closed-20160101.csv\",\n",
    "    \"2016\": \"closed-20170109.csv\",\n",
    "    \"2017\": \"closed-20180101.csv\",\n",
    "    \"2018\": \"closed-20190101.csv\",\n",
    "    \"2019\": \"closed-20200101.csv\",\n",
    "    \"2020\": \"closed-20210101.csv\",\n",
    "    \"2021\": \"closed-20220101.csv\",\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>identifier</th>\n",
       "      <th>series</th>\n",
       "      <th>control_symbol</th>\n",
       "      <th>title</th>\n",
       "      <th>series_title</th>\n",
       "      <th>contents_date_str</th>\n",
       "      <th>contents_start_date</th>\n",
       "      <th>contents_end_date</th>\n",
       "      <th>access_status</th>\n",
       "      <th>access_decision_date</th>\n",
       "      <th>reasons</th>\n",
       "      <th>harvested_year</th>\n",
       "      <th>location</th>\n",
       "      <th>access_decision_date_str</th>\n",
       "      <th>digitised_status</th>\n",
       "      <th>digitised_pages</th>\n",
       "      <th>access_decision_reasons</th>\n",
       "      <th>retrieved</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12332</td>\n",
       "      <td>A1</td>\n",
       "      <td>1911/21007</td>\n",
       "      <td>Salvatore Pagano Naturalization Issued to Immi...</td>\n",
       "      <td>Correspondence files, annual single number ser...</td>\n",
       "      <td>1961 - 1961</td>\n",
       "      <td>1961-01-01 00:00:00</td>\n",
       "      <td>1961-01-01 00:00:00</td>\n",
       "      <td>Closed</td>\n",
       "      <td>1981-07-28 00:00:00</td>\n",
       "      <td>Pre Access Recorder</td>\n",
       "      <td>2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>15403</td>\n",
       "      <td>A1</td>\n",
       "      <td>1913/6809</td>\n",
       "      <td>Meeting of Commonwealth Literary Fund (Missing...</td>\n",
       "      <td>Correspondence files, annual single number ser...</td>\n",
       "      <td>1913 - 1913</td>\n",
       "      <td>1913-01-01 00:00:00</td>\n",
       "      <td>1913-01-01 00:00:00</td>\n",
       "      <td>Closed</td>\n",
       "      <td>1981-09-28 00:00:00</td>\n",
       "      <td>Pre Access Recorder</td>\n",
       "      <td>2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>33093</td>\n",
       "      <td>A1</td>\n",
       "      <td>1915/11532</td>\n",
       "      <td>Wilhelm CA Simonsen - Naturalization Issued to...</td>\n",
       "      <td>Correspondence files, annual single number ser...</td>\n",
       "      <td>1961 - 1961</td>\n",
       "      <td>1961-01-01 00:00:00</td>\n",
       "      <td>1961-01-01 00:00:00</td>\n",
       "      <td>Closed</td>\n",
       "      <td>1981-12-03 00:00:00</td>\n",
       "      <td>Pre Access Recorder</td>\n",
       "      <td>2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>46663</td>\n",
       "      <td>A2</td>\n",
       "      <td>1907/554</td>\n",
       "      <td>Report of Conference of Statisticians (File Co...</td>\n",
       "      <td>Correspondence files, annual single number series</td>\n",
       "      <td>1904 - 1920</td>\n",
       "      <td>1904-01-01 00:00:00</td>\n",
       "      <td>1920-01-01 00:00:00</td>\n",
       "      <td>Closed</td>\n",
       "      <td>1973-06-20 00:00:00</td>\n",
       "      <td>Pre Access Recorder</td>\n",
       "      <td>2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>47046</td>\n",
       "      <td>A2</td>\n",
       "      <td>1915/346</td>\n",
       "      <td>Rossino - Mario</td>\n",
       "      <td>Correspondence files, annual single number series</td>\n",
       "      <td>1915 - 1915</td>\n",
       "      <td>1915-01-01 00:00:00</td>\n",
       "      <td>1915-01-01 00:00:00</td>\n",
       "      <td>Closed</td>\n",
       "      <td>1973-06-28 00:00:00</td>\n",
       "      <td>Pre Access Recorder</td>\n",
       "      <td>2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   identifier series control_symbol  \\\n",
       "0       12332     A1     1911/21007   \n",
       "1       15403     A1      1913/6809   \n",
       "2       33093     A1     1915/11532   \n",
       "3       46663     A2       1907/554   \n",
       "4       47046     A2       1915/346   \n",
       "\n",
       "                                               title  \\\n",
       "0  Salvatore Pagano Naturalization Issued to Immi...   \n",
       "1  Meeting of Commonwealth Literary Fund (Missing...   \n",
       "2  Wilhelm CA Simonsen - Naturalization Issued to...   \n",
       "3  Report of Conference of Statisticians (File Co...   \n",
       "4                                    Rossino - Mario   \n",
       "\n",
       "                                        series_title contents_date_str  \\\n",
       "0  Correspondence files, annual single number ser...       1961 - 1961   \n",
       "1  Correspondence files, annual single number ser...       1913 - 1913   \n",
       "2  Correspondence files, annual single number ser...       1961 - 1961   \n",
       "3  Correspondence files, annual single number series       1904 - 1920   \n",
       "4  Correspondence files, annual single number series       1915 - 1915   \n",
       "\n",
       "   contents_start_date    contents_end_date access_status  \\\n",
       "0  1961-01-01 00:00:00  1961-01-01 00:00:00        Closed   \n",
       "1  1913-01-01 00:00:00  1913-01-01 00:00:00        Closed   \n",
       "2  1961-01-01 00:00:00  1961-01-01 00:00:00        Closed   \n",
       "3  1904-01-01 00:00:00  1920-01-01 00:00:00        Closed   \n",
       "4  1915-01-01 00:00:00  1915-01-01 00:00:00        Closed   \n",
       "\n",
       "  access_decision_date              reasons harvested_year location  \\\n",
       "0  1981-07-28 00:00:00  Pre Access Recorder           2015      NaN   \n",
       "1  1981-09-28 00:00:00  Pre Access Recorder           2015      NaN   \n",
       "2  1981-12-03 00:00:00  Pre Access Recorder           2015      NaN   \n",
       "3  1973-06-20 00:00:00  Pre Access Recorder           2015      NaN   \n",
       "4  1973-06-28 00:00:00  Pre Access Recorder           2015      NaN   \n",
       "\n",
       "  access_decision_date_str digitised_status  digitised_pages  \\\n",
       "0                      NaN              NaN              NaN   \n",
       "1                      NaN              NaN              NaN   \n",
       "2                      NaN              NaN              NaN   \n",
       "3                      NaN              NaN              NaN   \n",
       "4                      NaN              NaN              NaN   \n",
       "\n",
       "  access_decision_reasons retrieved  \n",
       "0                     NaN       NaN  \n",
       "1                     NaN       NaN  \n",
       "2                     NaN       NaN  \n",
       "3                     NaN       NaN  \n",
       "4                     NaN       NaN  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Load all the data into a single dataframe\n",
    "dfs = []\n",
    "for year, data_file in harvests.items():\n",
    "    df_year = pd.read_csv(\n",
    "        Path(\"data\", data_file),\n",
    "        parse_dates=[\n",
    "            \"contents_start_date\",\n",
    "            \"contents_end_date\",\n",
    "            \"access_decision_date\",\n",
    "        ],\n",
    "        keep_default_na=False,\n",
    "    )\n",
    "    df_year[\"harvested_year\"] = year\n",
    "    dfs.append(df_year)\n",
    "df = pd.concat(dfs)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Number of closed files in each harvest"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2015</td>\n",
       "      <td>14370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2016</td>\n",
       "      <td>10750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017</td>\n",
       "      <td>11189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018</td>\n",
       "      <td>11953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2019</td>\n",
       "      <td>11867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2020</td>\n",
       "      <td>11140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021</td>\n",
       "      <td>11377</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   year  count\n",
       "0  2015  14370\n",
       "6  2016  10750\n",
       "4  2017  11189\n",
       "1  2018  11953\n",
       "2  2019  11867\n",
       "5  2020  11140\n",
       "3  2021  11377"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "year_counts = df[\"harvested_year\"].value_counts().to_frame().reset_index()\n",
    "year_counts.columns = [\"year\", \"count\"]\n",
    "year_counts.sort_values(by=\"year\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<div id=\"altair-viz-84e37827caf04837b046cac8994aee66\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  var VEGA_DEBUG = (typeof VEGA_DEBUG == \"undefined\") ? {} : VEGA_DEBUG;\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-84e37827caf04837b046cac8994aee66\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-84e37827caf04837b046cac8994aee66\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.17.0?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function maybeLoadScript(lib, version) {\n",
       "      var key = `${lib.replace(\"-\", \"\")}_version`;\n",
       "      return (VEGA_DEBUG[key] == version) ?\n",
       "        Promise.resolve(paths[lib]) :\n",
       "        new Promise(function(resolve, reject) {\n",
       "          var s = document.createElement('script');\n",
       "          document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "          s.async = true;\n",
       "          s.onload = () => {\n",
       "            VEGA_DEBUG[key] = version;\n",
       "            return resolve(paths[lib]);\n",
       "          };\n",
       "          s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "          s.src = paths[lib];\n",
       "        });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else {\n",
       "      maybeLoadScript(\"vega\", \"5\")\n",
       "        .then(() => maybeLoadScript(\"vega-lite\", \"4.17.0\"))\n",
       "        .then(() => maybeLoadScript(\"vega-embed\", \"6\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"config\": {\"view\": {\"continuousWidth\": 400, \"continuousHeight\": 300}}, \"data\": {\"name\": \"data-8f4e7534af83000c0fd2c4e15cb68ace\"}, \"mark\": {\"type\": \"bar\", \"point\": true}, \"encoding\": {\"color\": {\"field\": \"year\", \"legend\": null, \"type\": \"nominal\"}, \"tooltip\": [{\"field\": \"year\", \"type\": \"ordinal\"}, {\"field\": \"count\", \"type\": \"quantitative\"}], \"x\": {\"field\": \"year\", \"title\": \"Year end\", \"type\": \"ordinal\"}, \"y\": {\"field\": \"count\", \"title\": \"Number of closed files\", \"type\": \"quantitative\"}}, \"width\": 300, \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.17.0.json\", \"datasets\": {\"data-8f4e7534af83000c0fd2c4e15cb68ace\": [{\"year\": \"2015\", \"count\": 14370}, {\"year\": \"2018\", \"count\": 11953}, {\"year\": \"2019\", \"count\": 11867}, {\"year\": \"2021\", \"count\": 11377}, {\"year\": \"2017\", \"count\": 11189}, {\"year\": \"2020\", \"count\": 11140}, {\"year\": \"2016\", \"count\": 10750}]}}, {\"mode\": \"vega-lite\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.Chart(...)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "alt.Chart(year_counts).mark_bar(point=True).encode(\n",
    "    x=alt.X(\"year:O\", title=\"Year end\"),\n",
    "    y=alt.Y(\"count:Q\", title=\"Number of closed files\"),\n",
    "    color=alt.Color(\"year\", legend=None),\n",
    "    tooltip=[\"year:O\", \"count:Q\"],\n",
    ").properties(width=300)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Find the number of times each reason is cited in the annual harvests"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_reasons = df.copy()\n",
    "df_reasons[\"reason\"] = df_reasons[\"reasons\"].str.split(\"|\")\n",
    "df_reasons = df_reasons.explode(\"reason\")\n",
    "df_reasons[\"reason\"].replace(\"\", \"No reason\", inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['33(1)(a)',\n",
       " '33(1)(b)',\n",
       " '33(1)(c)',\n",
       " '33(1)(d)',\n",
       " '33(1)(e)(i)',\n",
       " '33(1)(e)(ii)',\n",
       " '33(1)(e)(iii)',\n",
       " '33(1)(f)(i)',\n",
       " '33(1)(f)(ii)',\n",
       " '33(1)(f)(iii)',\n",
       " '33(1)(g)',\n",
       " '33(1)(h)',\n",
       " '33(1)(j)',\n",
       " '33(2)(a)',\n",
       " '33(2)(b)',\n",
       " '33(3)(a)(i)',\n",
       " '33(3)(a)(ii)',\n",
       " '33(3)(b)',\n",
       " 'Cabinet notebooks',\n",
       " 'Closed period',\n",
       " 'Court records',\n",
       " 'Destroyed',\n",
       " 'MAKE YOUR SELECTION',\n",
       " 'NRF',\n",
       " 'No reason',\n",
       " 'Non Cwlth-depositor',\n",
       " 'Non Cwlth-no appeal',\n",
       " 'Parliament Class A',\n",
       " 'Pre Access Recorder',\n",
       " 'Withheld pending adv',\n",
       " \"['33(1)(a)', '33(1)(b)', '33(1)(c)', 'Withheld pending adv']\",\n",
       " \"['33(1)(a)', '33(1)(b)', '33(1)(d)', '33(1)(g)', 'Withheld pending adv']\",\n",
       " \"['33(1)(a)', '33(1)(b)', '33(1)(d)', '33(1)(g)']\",\n",
       " \"['33(1)(a)', '33(1)(b)', '33(1)(d)', 'Withheld pending adv']\",\n",
       " \"['33(1)(a)', '33(1)(b)', '33(1)(d)']\",\n",
       " \"['33(1)(a)', '33(1)(b)', '33(1)(e)(ii)', '33(1)(g)']\",\n",
       " \"['33(1)(a)', '33(1)(b)', '33(1)(e)(ii)']\",\n",
       " \"['33(1)(a)', '33(1)(b)', '33(1)(e)(iii)']\",\n",
       " \"['33(1)(a)', '33(1)(b)', '33(1)(g)', 'Withheld pending adv']\",\n",
       " \"['33(1)(a)', '33(1)(b)', 'Closed period', 'Withheld pending adv']\",\n",
       " \"['33(1)(a)', '33(1)(b)', 'Withheld pending adv']\",\n",
       " \"['33(1)(a)', '33(1)(b)']\",\n",
       " \"['33(1)(a)', '33(1)(c)']\",\n",
       " \"['33(1)(a)', '33(1)(d)', '33(1)(e)(i)', '33(1)(g)', 'Withheld pending adv']\",\n",
       " \"['33(1)(a)', '33(1)(d)', '33(1)(e)(i)', '33(1)(g)']\",\n",
       " \"['33(1)(a)', '33(1)(d)', '33(1)(e)(i)']\",\n",
       " \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(e)(iii)', 'NRF']\",\n",
       " \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(e)(iii)', 'Withheld pending adv']\",\n",
       " \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(e)(iii)']\",\n",
       " \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(g)', 'Closed period', 'Withheld pending adv']\",\n",
       " \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(g)']\",\n",
       " \"['33(1)(a)', '33(1)(d)', '33(1)(e)(iii)', '33(1)(g)']\",\n",
       " \"['33(1)(a)', '33(1)(d)', '33(1)(e)(iii)']\",\n",
       " \"['33(1)(a)', '33(1)(d)', '33(1)(g)', '33(1)(e)(i)']\",\n",
       " \"['33(1)(a)', '33(1)(d)', '33(1)(g)', '33(1)(e)(ii)']\",\n",
       " \"['33(1)(a)', '33(1)(d)', '33(1)(g)', 'Withheld pending adv']\",\n",
       " \"['33(1)(a)', '33(1)(d)', '33(1)(g)']\",\n",
       " \"['33(1)(a)', '33(1)(d)']\",\n",
       " \"['33(1)(a)', '33(1)(e)(ii)', '33(1)(g)']\",\n",
       " \"['33(1)(a)', '33(1)(e)(ii)']\",\n",
       " \"['33(1)(a)', '33(1)(e)(iii)']\",\n",
       " \"['33(1)(a)', '33(1)(f)(iii)']\",\n",
       " \"['33(1)(a)', '33(1)(g)', 'Withheld pending adv']\",\n",
       " \"['33(1)(a)', '33(1)(g)']\",\n",
       " \"['33(1)(a)', '33(1)(j)', '33(2)(a)', '33(2)(b)']\",\n",
       " \"['33(1)(a)', 'Closed period', 'Withheld pending adv']\",\n",
       " \"['33(1)(a)', 'Withheld pending adv']\",\n",
       " \"['33(1)(a)']\",\n",
       " \"['33(1)(b)', '33(1)(d)', '33(1)(e)(ii)']\",\n",
       " \"['33(1)(b)', '33(1)(e)(ii)']\",\n",
       " \"['33(1)(b)', '33(1)(e)(iii)']\",\n",
       " \"['33(1)(b)', '33(1)(g)']\",\n",
       " \"['33(1)(b)', 'Withheld pending adv']\",\n",
       " \"['33(1)(b)']\",\n",
       " \"['33(1)(c)']\",\n",
       " \"['33(1)(d)', '33(1)(e)(ii)', '33(1)(g)']\",\n",
       " \"['33(1)(d)', '33(1)(e)(ii)']\",\n",
       " \"['33(1)(d)', '33(1)(e)(iii)', '33(1)(g)']\",\n",
       " \"['33(1)(d)', '33(1)(g)', '33(1)(j)', '33(1)(f)(ii)']\",\n",
       " \"['33(1)(d)', '33(1)(g)', '33(1)(j)', 'Closed period']\",\n",
       " \"['33(1)(d)', '33(1)(g)', '33(1)(j)']\",\n",
       " \"['33(1)(d)', '33(1)(g)', 'Closed period']\",\n",
       " \"['33(1)(d)', '33(1)(g)']\",\n",
       " \"['33(1)(d)']\",\n",
       " \"['33(1)(e)(i)', '33(1)(e)(ii)', '33(1)(g)']\",\n",
       " \"['33(1)(e)(i)', '33(1)(f)(i)', '33(1)(g)']\",\n",
       " \"['33(1)(e)(i)', '33(1)(g)']\",\n",
       " \"['33(1)(e)(ii)', '33(1)(g)', '33(1)(j)']\",\n",
       " \"['33(1)(e)(ii)', '33(1)(g)']\",\n",
       " \"['33(1)(e)(ii)']\",\n",
       " \"['33(1)(e)(iii)', '33(1)(f)(iii)']\",\n",
       " \"['33(1)(e)(iii)', '33(1)(g)']\",\n",
       " \"['33(1)(e)(iii)', 'Withheld pending adv']\",\n",
       " \"['33(1)(e)(iii)']\",\n",
       " \"['33(1)(f)(i)']\",\n",
       " \"['33(1)(f)(ii)']\",\n",
       " \"['33(1)(f)(iii)', '33(1)(g)']\",\n",
       " \"['33(1)(f)(iii)']\",\n",
       " \"['33(1)(g)', '33(1)(j)', 'Closed period']\",\n",
       " \"['33(1)(g)', '33(1)(j)']\",\n",
       " \"['33(1)(g)', 'Closed period']\",\n",
       " \"['33(1)(g)', 'MAKE YOUR SELECTION']\",\n",
       " \"['33(1)(g)', 'Non Cwlth-depositor']\",\n",
       " \"['33(1)(g)', 'Non Cwlth-no appeal']\",\n",
       " \"['33(1)(g)', 'Parliament Class A']\",\n",
       " \"['33(1)(g)']\",\n",
       " \"['33(1)(h)']\",\n",
       " \"['33(1)(j)']\",\n",
       " \"['33(2)(a)', '33(2)(b)', '33(3)(a)(i)', '33(3)(a)(ii)', '33(3)(b)']\",\n",
       " \"['33(2)(a)', '33(2)(b)', 'Withheld pending adv']\",\n",
       " \"['33(2)(a)', '33(2)(b)']\",\n",
       " \"['33(3)(a)(i)', '33(3)(a)(ii)', '33(3)(b)']\",\n",
       " \"['33(3)(a)(i)', '33(3)(b)', '33(3)(a)(ii)', '33(3)(b)']\",\n",
       " \"['33(3)(a)(ii)', '33(3)(b)', 'MAKE YOUR SELECTION']\",\n",
       " \"['33(3)(a)(ii)', '33(3)(b)']\",\n",
       " \"['Closed period', 'Non Cwlth-no appeal']\",\n",
       " \"['Closed period', 'Withheld pending adv']\",\n",
       " \"['Closed period']\",\n",
       " \"['Court records']\",\n",
       " \"['Destroyed']\",\n",
       " \"['MAKE YOUR SELECTION', 'Withheld pending adv']\",\n",
       " \"['MAKE YOUR SELECTION']\",\n",
       " \"['NRF']\",\n",
       " \"['Non Cwlth-depositor']\",\n",
       " \"['Non Cwlth-no appeal']\",\n",
       " \"['Parliament Class A']\",\n",
       " \"['Withheld pending adv']\",\n",
       " '[]']"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "unique_reasons = sorted(list(df_reasons[\"reason\"].unique()))\n",
    "unique_reasons"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "harvest_reasons_counts = (\n",
    "    df_reasons.groupby(by=[\"harvested_year\", \"reason\"]).size().reset_index()\n",
    ")\n",
    "harvest_reasons_counts.columns = [\"year\", \"reason\", \"count\"]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Visualise the number of times each reason is cited"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<div id=\"altair-viz-3ced369c9ef24712841aaee17df83195\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  var VEGA_DEBUG = (typeof VEGA_DEBUG == \"undefined\") ? {} : VEGA_DEBUG;\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-3ced369c9ef24712841aaee17df83195\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-3ced369c9ef24712841aaee17df83195\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.17.0?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function maybeLoadScript(lib, version) {\n",
       "      var key = `${lib.replace(\"-\", \"\")}_version`;\n",
       "      return (VEGA_DEBUG[key] == version) ?\n",
       "        Promise.resolve(paths[lib]) :\n",
       "        new Promise(function(resolve, reject) {\n",
       "          var s = document.createElement('script');\n",
       "          document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "          s.async = true;\n",
       "          s.onload = () => {\n",
       "            VEGA_DEBUG[key] = version;\n",
       "            return resolve(paths[lib]);\n",
       "          };\n",
       "          s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "          s.src = paths[lib];\n",
       "        });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else {\n",
       "      maybeLoadScript(\"vega\", \"5\")\n",
       "        .then(() => maybeLoadScript(\"vega-lite\", \"4.17.0\"))\n",
       "        .then(() => maybeLoadScript(\"vega-embed\", \"6\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"config\": {\"view\": {\"continuousWidth\": 400, \"continuousHeight\": 300}}, \"data\": {\"name\": \"data-a015013f3640b08da2cc6adc70b7eeac\"}, \"mark\": \"bar\", \"encoding\": {\"color\": {\"field\": \"year\", \"legend\": null, \"type\": \"nominal\"}, \"facet\": {\"align\": \"each\", \"columns\": 5, \"field\": \"reason\", \"title\": \"Reason for being closed\", \"type\": \"ordinal\"}, \"tooltip\": [{\"field\": \"year\", \"type\": \"ordinal\"}, {\"field\": \"reason\", \"type\": \"nominal\"}, {\"field\": \"count\", \"type\": \"quantitative\"}], \"x\": {\"field\": \"year\", \"title\": null, \"type\": \"ordinal\"}, \"y\": {\"field\": \"count\", \"title\": \"Number of files\", \"type\": \"quantitative\"}}, \"height\": 200, \"resolve\": {\"scale\": {\"x\": \"independent\"}}, \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.17.0.json\", \"datasets\": {\"data-a015013f3640b08da2cc6adc70b7eeac\": [{\"year\": \"2015\", \"reason\": \"33(1)(a)\", \"count\": 1010}, {\"year\": \"2015\", \"reason\": \"33(1)(b)\", \"count\": 425}, {\"year\": \"2015\", \"reason\": \"33(1)(c)\", \"count\": 5}, {\"year\": \"2015\", \"reason\": \"33(1)(d)\", \"count\": 281}, {\"year\": \"2015\", \"reason\": \"33(1)(e)(i)\", \"count\": 46}, {\"year\": \"2015\", \"reason\": \"33(1)(e)(ii)\", \"count\": 120}, {\"year\": \"2015\", \"reason\": \"33(1)(e)(iii)\", \"count\": 21}, {\"year\": \"2015\", \"reason\": \"33(1)(f)(ii)\", \"count\": 3}, {\"year\": \"2015\", \"reason\": \"33(1)(f)(iii)\", \"count\": 3}, {\"year\": \"2015\", \"reason\": \"33(1)(g)\", \"count\": 4048}, {\"year\": \"2015\", \"reason\": \"33(1)(h)\", \"count\": 5}, {\"year\": \"2015\", \"reason\": \"33(1)(j)\", \"count\": 22}, {\"year\": \"2015\", \"reason\": \"33(2)(a)\", \"count\": 9}, {\"year\": \"2015\", \"reason\": \"33(2)(b)\", \"count\": 9}, {\"year\": \"2015\", \"reason\": \"33(3)(a)(i)\", \"count\": 29}, {\"year\": \"2015\", \"reason\": \"33(3)(a)(ii)\", \"count\": 29}, {\"year\": \"2015\", \"reason\": \"33(3)(b)\", \"count\": 58}, {\"year\": \"2015\", \"reason\": \"Cabinet notebooks\", \"count\": 1}, {\"year\": \"2015\", \"reason\": \"Closed period\", \"count\": 2565}, {\"year\": \"2015\", \"reason\": \"Court records\", \"count\": 4}, {\"year\": \"2015\", \"reason\": \"Destroyed\", \"count\": 1}, {\"year\": \"2015\", \"reason\": \"MAKE YOUR SELECTION\", \"count\": 13}, {\"year\": \"2015\", \"reason\": \"NRF\", \"count\": 2}, {\"year\": \"2015\", \"reason\": \"No reason\", \"count\": 62}, {\"year\": \"2015\", \"reason\": \"Non Cwlth-depositor\", \"count\": 3}, {\"year\": \"2015\", \"reason\": \"Non Cwlth-no appeal\", \"count\": 52}, {\"year\": \"2015\", \"reason\": \"Parliament Class A\", \"count\": 1409}, {\"year\": \"2015\", \"reason\": \"Pre Access Recorder\", \"count\": 2812}, {\"year\": \"2015\", \"reason\": \"Withheld pending adv\", \"count\": 3410}, {\"year\": \"2016\", \"reason\": \"33(1)(a)\", \"count\": 896}, {\"year\": \"2016\", \"reason\": \"33(1)(b)\", \"count\": 371}, {\"year\": \"2016\", \"reason\": \"33(1)(c)\", \"count\": 5}, {\"year\": \"2016\", \"reason\": \"33(1)(d)\", \"count\": 244}, {\"year\": \"2016\", \"reason\": \"33(1)(e)(i)\", \"count\": 33}, {\"year\": \"2016\", \"reason\": \"33(1)(e)(ii)\", \"count\": 104}, {\"year\": \"2016\", \"reason\": \"33(1)(e)(iii)\", \"count\": 27}, {\"year\": \"2016\", \"reason\": \"33(1)(f)(ii)\", \"count\": 2}, {\"year\": \"2016\", \"reason\": \"33(1)(f)(iii)\", \"count\": 3}, {\"year\": \"2016\", \"reason\": \"33(1)(g)\", \"count\": 4718}, {\"year\": \"2016\", \"reason\": \"33(1)(h)\", \"count\": 4}, {\"year\": \"2016\", \"reason\": \"33(1)(j)\", \"count\": 16}, {\"year\": \"2016\", \"reason\": \"33(2)(a)\", \"count\": 16}, {\"year\": \"2016\", \"reason\": \"33(2)(b)\", \"count\": 16}, {\"year\": \"2016\", \"reason\": \"33(3)(a)(i)\", \"count\": 36}, {\"year\": \"2016\", \"reason\": \"33(3)(a)(ii)\", \"count\": 29}, {\"year\": \"2016\", \"reason\": \"33(3)(b)\", \"count\": 65}, {\"year\": \"2016\", \"reason\": \"Closed period\", \"count\": 113}, {\"year\": \"2016\", \"reason\": \"Court records\", \"count\": 5}, {\"year\": \"2016\", \"reason\": \"MAKE YOUR SELECTION\", \"count\": 4}, {\"year\": \"2016\", \"reason\": \"NRF\", \"count\": 2}, {\"year\": \"2016\", \"reason\": \"No reason\", \"count\": 41}, {\"year\": \"2016\", \"reason\": \"Non Cwlth-depositor\", \"count\": 3}, {\"year\": \"2016\", \"reason\": \"Non Cwlth-no appeal\", \"count\": 44}, {\"year\": \"2016\", \"reason\": \"Parliament Class A\", \"count\": 1235}, {\"year\": \"2016\", \"reason\": \"Pre Access Recorder\", \"count\": 2}, {\"year\": \"2016\", \"reason\": \"Withheld pending adv\", \"count\": 3845}, {\"year\": \"2017\", \"reason\": \"33(1)(a)\", \"count\": 839}, {\"year\": \"2017\", \"reason\": \"33(1)(b)\", \"count\": 362}, {\"year\": \"2017\", \"reason\": \"33(1)(c)\", \"count\": 3}, {\"year\": \"2017\", \"reason\": \"33(1)(d)\", \"count\": 225}, {\"year\": \"2017\", \"reason\": \"33(1)(e)(i)\", \"count\": 16}, {\"year\": \"2017\", \"reason\": \"33(1)(e)(ii)\", \"count\": 97}, {\"year\": \"2017\", \"reason\": \"33(1)(e)(iii)\", \"count\": 28}, {\"year\": \"2017\", \"reason\": \"33(1)(f)(ii)\", \"count\": 2}, {\"year\": \"2017\", \"reason\": \"33(1)(f)(iii)\", \"count\": 4}, {\"year\": \"2017\", \"reason\": \"33(1)(g)\", \"count\": 4706}, {\"year\": \"2017\", \"reason\": \"33(1)(h)\", \"count\": 4}, {\"year\": \"2017\", \"reason\": \"33(1)(j)\", \"count\": 21}, {\"year\": \"2017\", \"reason\": \"33(2)(a)\", \"count\": 16}, {\"year\": \"2017\", \"reason\": \"33(2)(b)\", \"count\": 16}, {\"year\": \"2017\", \"reason\": \"33(3)(a)(i)\", \"count\": 32}, {\"year\": \"2017\", \"reason\": \"33(3)(a)(ii)\", \"count\": 24}, {\"year\": \"2017\", \"reason\": \"33(3)(b)\", \"count\": 56}, {\"year\": \"2017\", \"reason\": \"Closed period\", \"count\": 123}, {\"year\": \"2017\", \"reason\": \"Court records\", \"count\": 5}, {\"year\": \"2017\", \"reason\": \"MAKE YOUR SELECTION\", \"count\": 8}, {\"year\": \"2017\", \"reason\": \"NRF\", \"count\": 3}, {\"year\": \"2017\", \"reason\": \"No reason\", \"count\": 47}, {\"year\": \"2017\", \"reason\": \"Non Cwlth-depositor\", \"count\": 5}, {\"year\": \"2017\", \"reason\": \"Non Cwlth-no appeal\", \"count\": 57}, {\"year\": \"2017\", \"reason\": \"Parliament Class A\", \"count\": 1301}, {\"year\": \"2017\", \"reason\": \"Pre Access Recorder\", \"count\": 2}, {\"year\": \"2017\", \"reason\": \"Withheld pending adv\", \"count\": 4213}, {\"year\": \"2018\", \"reason\": \"33(1)(a)\", \"count\": 1097}, {\"year\": \"2018\", \"reason\": \"33(1)(b)\", \"count\": 355}, {\"year\": \"2018\", \"reason\": \"33(1)(c)\", \"count\": 3}, {\"year\": \"2018\", \"reason\": \"33(1)(d)\", \"count\": 376}, {\"year\": \"2018\", \"reason\": \"33(1)(e)(i)\", \"count\": 50}, {\"year\": \"2018\", \"reason\": \"33(1)(e)(ii)\", \"count\": 120}, {\"year\": \"2018\", \"reason\": \"33(1)(e)(iii)\", \"count\": 32}, {\"year\": \"2018\", \"reason\": \"33(1)(f)(i)\", \"count\": 7}, {\"year\": \"2018\", \"reason\": \"33(1)(f)(ii)\", \"count\": 2}, {\"year\": \"2018\", \"reason\": \"33(1)(f)(iii)\", \"count\": 4}, {\"year\": \"2018\", \"reason\": \"33(1)(g)\", \"count\": 4908}, {\"year\": \"2018\", \"reason\": \"33(1)(h)\", \"count\": 4}, {\"year\": \"2018\", \"reason\": \"33(1)(j)\", \"count\": 23}, {\"year\": \"2018\", \"reason\": \"33(2)(a)\", \"count\": 21}, {\"year\": \"2018\", \"reason\": \"33(2)(b)\", \"count\": 21}, {\"year\": \"2018\", \"reason\": \"33(3)(a)(i)\", \"count\": 35}, {\"year\": \"2018\", \"reason\": \"33(3)(a)(ii)\", \"count\": 24}, {\"year\": \"2018\", \"reason\": \"33(3)(b)\", \"count\": 59}, {\"year\": \"2018\", \"reason\": \"Closed period\", \"count\": 575}, {\"year\": \"2018\", \"reason\": \"Court records\", \"count\": 6}, {\"year\": \"2018\", \"reason\": \"MAKE YOUR SELECTION\", \"count\": 7}, {\"year\": \"2018\", \"reason\": \"NRF\", \"count\": 13}, {\"year\": \"2018\", \"reason\": \"No reason\", \"count\": 46}, {\"year\": \"2018\", \"reason\": \"Non Cwlth-depositor\", \"count\": 29}, {\"year\": \"2018\", \"reason\": \"Non Cwlth-no appeal\", \"count\": 60}, {\"year\": \"2018\", \"reason\": \"Parliament Class A\", \"count\": 1456}, {\"year\": \"2018\", \"reason\": \"Pre Access Recorder\", \"count\": 2}, {\"year\": \"2018\", \"reason\": \"Withheld pending adv\", \"count\": 3989}, {\"year\": \"2019\", \"reason\": \"33(1)(a)\", \"count\": 1133}, {\"year\": \"2019\", \"reason\": \"33(1)(b)\", \"count\": 363}, {\"year\": \"2019\", \"reason\": \"33(1)(c)\", \"count\": 3}, {\"year\": \"2019\", \"reason\": \"33(1)(d)\", \"count\": 399}, {\"year\": \"2019\", \"reason\": \"33(1)(e)(i)\", \"count\": 53}, {\"year\": \"2019\", \"reason\": \"33(1)(e)(ii)\", \"count\": 122}, {\"year\": \"2019\", \"reason\": \"33(1)(e)(iii)\", \"count\": 45}, {\"year\": \"2019\", \"reason\": \"33(1)(f)(i)\", \"count\": 7}, {\"year\": \"2019\", \"reason\": \"33(1)(f)(ii)\", \"count\": 5}, {\"year\": \"2019\", \"reason\": \"33(1)(f)(iii)\", \"count\": 4}, {\"year\": \"2019\", \"reason\": \"33(1)(g)\", \"count\": 4901}, {\"year\": \"2019\", \"reason\": \"33(1)(h)\", \"count\": 4}, {\"year\": \"2019\", \"reason\": \"33(1)(j)\", \"count\": 28}, {\"year\": \"2019\", \"reason\": \"33(2)(a)\", \"count\": 22}, {\"year\": \"2019\", \"reason\": \"33(2)(b)\", \"count\": 22}, {\"year\": \"2019\", \"reason\": \"33(3)(a)(i)\", \"count\": 38}, {\"year\": \"2019\", \"reason\": \"33(3)(a)(ii)\", \"count\": 28}, {\"year\": \"2019\", \"reason\": \"33(3)(b)\", \"count\": 66}, {\"year\": \"2019\", \"reason\": \"Closed period\", \"count\": 758}, {\"year\": \"2019\", \"reason\": \"Court records\", \"count\": 9}, {\"year\": \"2019\", \"reason\": \"MAKE YOUR SELECTION\", \"count\": 12}, {\"year\": \"2019\", \"reason\": \"NRF\", \"count\": 14}, {\"year\": \"2019\", \"reason\": \"No reason\", \"count\": 48}, {\"year\": \"2019\", \"reason\": \"Non Cwlth-depositor\", \"count\": 29}, {\"year\": \"2019\", \"reason\": \"Non Cwlth-no appeal\", \"count\": 62}, {\"year\": \"2019\", \"reason\": \"Parliament Class A\", \"count\": 1280}, {\"year\": \"2019\", \"reason\": \"Withheld pending adv\", \"count\": 3835}, {\"year\": \"2020\", \"reason\": \"33(1)(a)\", \"count\": 1096}, {\"year\": \"2020\", \"reason\": \"33(1)(b)\", \"count\": 362}, {\"year\": \"2020\", \"reason\": \"33(1)(c)\", \"count\": 3}, {\"year\": \"2020\", \"reason\": \"33(1)(d)\", \"count\": 429}, {\"year\": \"2020\", \"reason\": \"33(1)(e)(i)\", \"count\": 37}, {\"year\": \"2020\", \"reason\": \"33(1)(e)(ii)\", \"count\": 110}, {\"year\": \"2020\", \"reason\": \"33(1)(e)(iii)\", \"count\": 46}, {\"year\": \"2020\", \"reason\": \"33(1)(f)(i)\", \"count\": 7}, {\"year\": \"2020\", \"reason\": \"33(1)(f)(ii)\", \"count\": 5}, {\"year\": \"2020\", \"reason\": \"33(1)(f)(iii)\", \"count\": 4}, {\"year\": \"2020\", \"reason\": \"33(1)(g)\", \"count\": 5003}, {\"year\": \"2020\", \"reason\": \"33(1)(h)\", \"count\": 4}, {\"year\": \"2020\", \"reason\": \"33(1)(j)\", \"count\": 30}, {\"year\": \"2020\", \"reason\": \"33(2)(a)\", \"count\": 24}, {\"year\": \"2020\", \"reason\": \"33(2)(b)\", \"count\": 24}, {\"year\": \"2020\", \"reason\": \"33(3)(a)(i)\", \"count\": 38}, {\"year\": \"2020\", \"reason\": \"33(3)(a)(ii)\", \"count\": 28}, {\"year\": \"2020\", \"reason\": \"33(3)(b)\", \"count\": 66}, {\"year\": \"2020\", \"reason\": \"Closed period\", \"count\": 239}, {\"year\": \"2020\", \"reason\": \"Court records\", \"count\": 9}, {\"year\": \"2020\", \"reason\": \"Destroyed\", \"count\": 2}, {\"year\": \"2020\", \"reason\": \"MAKE YOUR SELECTION\", \"count\": 12}, {\"year\": \"2020\", \"reason\": \"NRF\", \"count\": 15}, {\"year\": \"2020\", \"reason\": \"No reason\", \"count\": 49}, {\"year\": \"2020\", \"reason\": \"Non Cwlth-depositor\", \"count\": 10}, {\"year\": \"2020\", \"reason\": \"Non Cwlth-no appeal\", \"count\": 60}, {\"year\": \"2020\", \"reason\": \"Parliament Class A\", \"count\": 1286}, {\"year\": \"2020\", \"reason\": \"Withheld pending adv\", \"count\": 3524}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', '33(1)(c)', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', '33(1)(d)', '33(1)(g)', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', '33(1)(d)', '33(1)(g)']\", \"count\": 2}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', '33(1)(d)', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', '33(1)(d)']\", \"count\": 4}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', '33(1)(e)(ii)', '33(1)(g)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', '33(1)(e)(ii)']\", \"count\": 4}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', '33(1)(e)(iii)']\", \"count\": 9}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', '33(1)(g)', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', 'Closed period', 'Withheld pending adv']\", \"count\": 3}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', 'Withheld pending adv']\", \"count\": 50}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)']\", \"count\": 261}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(c)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(e)(i)', '33(1)(g)', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(e)(i)', '33(1)(g)']\", \"count\": 24}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(e)(i)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(e)(iii)', 'NRF']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(e)(iii)', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(e)(iii)']\", \"count\": 4}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(g)', 'Closed period', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(g)']\", \"count\": 27}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(e)(iii)', '33(1)(g)']\", \"count\": 3}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(e)(iii)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(g)', '33(1)(e)(i)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(g)', '33(1)(e)(ii)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(g)', 'Withheld pending adv']\", \"count\": 2}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(g)']\", \"count\": 116}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)']\", \"count\": 4}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(e)(ii)', '33(1)(g)']\", \"count\": 5}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(e)(ii)']\", \"count\": 2}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(e)(iii)']\", \"count\": 5}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(f)(iii)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(g)', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(g)']\", \"count\": 6}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(j)', '33(2)(a)', '33(2)(b)']\", \"count\": 6}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', 'Closed period', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', 'Withheld pending adv']\", \"count\": 43}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)']\", \"count\": 502}, {\"year\": \"2021\", \"reason\": \"['33(1)(b)', '33(1)(d)', '33(1)(e)(ii)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(b)', '33(1)(e)(ii)']\", \"count\": 2}, {\"year\": \"2021\", \"reason\": \"['33(1)(b)', '33(1)(e)(iii)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(b)', '33(1)(g)']\", \"count\": 2}, {\"year\": \"2021\", \"reason\": \"['33(1)(b)', 'Withheld pending adv']\", \"count\": 2}, {\"year\": \"2021\", \"reason\": \"['33(1)(b)']\", \"count\": 15}, {\"year\": \"2021\", \"reason\": \"['33(1)(c)']\", \"count\": 14}, {\"year\": \"2021\", \"reason\": \"['33(1)(d)', '33(1)(e)(ii)', '33(1)(g)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(d)', '33(1)(e)(ii)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(d)', '33(1)(e)(iii)', '33(1)(g)']\", \"count\": 19}, {\"year\": \"2021\", \"reason\": \"['33(1)(d)', '33(1)(g)', '33(1)(j)', '33(1)(f)(ii)']\", \"count\": 3}, {\"year\": \"2021\", \"reason\": \"['33(1)(d)', '33(1)(g)', '33(1)(j)', 'Closed period']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(d)', '33(1)(g)', '33(1)(j)']\", \"count\": 7}, {\"year\": \"2021\", \"reason\": \"['33(1)(d)', '33(1)(g)', 'Closed period']\", \"count\": 3}, {\"year\": \"2021\", \"reason\": \"['33(1)(d)', '33(1)(g)']\", \"count\": 176}, {\"year\": \"2021\", \"reason\": \"['33(1)(d)']\", \"count\": 50}, {\"year\": \"2021\", \"reason\": \"['33(1)(e)(i)', '33(1)(e)(ii)', '33(1)(g)']\", \"count\": 5}, {\"year\": \"2021\", \"reason\": \"['33(1)(e)(i)', '33(1)(f)(i)', '33(1)(g)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(e)(i)', '33(1)(g)']\", \"count\": 3}, {\"year\": \"2021\", \"reason\": \"['33(1)(e)(ii)', '33(1)(g)', '33(1)(j)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(e)(ii)', '33(1)(g)']\", \"count\": 25}, {\"year\": \"2021\", \"reason\": \"['33(1)(e)(ii)']\", \"count\": 24}, {\"year\": \"2021\", \"reason\": \"['33(1)(e)(iii)', '33(1)(f)(iii)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(e)(iii)', '33(1)(g)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(e)(iii)', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(e)(iii)']\", \"count\": 2}, {\"year\": \"2021\", \"reason\": \"['33(1)(f)(i)']\", \"count\": 6}, {\"year\": \"2021\", \"reason\": \"['33(1)(f)(ii)']\", \"count\": 2}, {\"year\": \"2021\", \"reason\": \"['33(1)(f)(iii)', '33(1)(g)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(f)(iii)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(g)', '33(1)(j)', 'Closed period']\", \"count\": 2}, {\"year\": \"2021\", \"reason\": \"['33(1)(g)', '33(1)(j)']\", \"count\": 4}, {\"year\": \"2021\", \"reason\": \"['33(1)(g)', 'Closed period']\", \"count\": 6}, {\"year\": \"2021\", \"reason\": \"['33(1)(g)', 'MAKE YOUR SELECTION']\", \"count\": 5}, {\"year\": \"2021\", \"reason\": \"['33(1)(g)', 'Non Cwlth-depositor']\", \"count\": 3}, {\"year\": \"2021\", \"reason\": \"['33(1)(g)', 'Non Cwlth-no appeal']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(g)', 'Parliament Class A']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(g)']\", \"count\": 4807}, {\"year\": \"2021\", \"reason\": \"['33(1)(h)']\", \"count\": 4}, {\"year\": \"2021\", \"reason\": \"['33(1)(j)']\", \"count\": 8}, {\"year\": \"2021\", \"reason\": \"['33(2)(a)', '33(2)(b)', '33(3)(a)(i)', '33(3)(a)(ii)', '33(3)(b)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(2)(a)', '33(2)(b)', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(2)(a)', '33(2)(b)']\", \"count\": 15}, {\"year\": \"2021\", \"reason\": \"['33(3)(a)(i)', '33(3)(a)(ii)', '33(3)(b)']\", \"count\": 13}, {\"year\": \"2021\", \"reason\": \"['33(3)(a)(i)', '33(3)(b)', '33(3)(a)(ii)', '33(3)(b)']\", \"count\": 24}, {\"year\": \"2021\", \"reason\": \"['33(3)(a)(ii)', '33(3)(b)', 'MAKE YOUR SELECTION']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(3)(a)(ii)', '33(3)(b)']\", \"count\": 3}, {\"year\": \"2021\", \"reason\": \"['Closed period', 'Non Cwlth-no appeal']\", \"count\": 5}, {\"year\": \"2021\", \"reason\": \"['Closed period', 'Withheld pending adv']\", \"count\": 6}, {\"year\": \"2021\", \"reason\": \"['Closed period']\", \"count\": 220}, {\"year\": \"2021\", \"reason\": \"['Court records']\", \"count\": 9}, {\"year\": \"2021\", \"reason\": \"['Destroyed']\", \"count\": 2}, {\"year\": \"2021\", \"reason\": \"['MAKE YOUR SELECTION', 'Withheld pending adv']\", \"count\": 7}, {\"year\": \"2021\", \"reason\": \"['MAKE YOUR SELECTION']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['NRF']\", \"count\": 14}, {\"year\": \"2021\", \"reason\": \"['Non Cwlth-depositor']\", \"count\": 7}, {\"year\": \"2021\", \"reason\": \"['Non Cwlth-no appeal']\", \"count\": 53}, {\"year\": \"2021\", \"reason\": \"['Parliament Class A']\", \"count\": 1287}, {\"year\": \"2021\", \"reason\": \"['Withheld pending adv']\", \"count\": 3316}, {\"year\": \"2021\", \"reason\": \"[]\", \"count\": 80}]}}, {\"mode\": \"vega-lite\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.Chart(...)"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "alt.Chart(harvest_reasons_counts).mark_bar().encode(\n",
    "    x=alt.X(\"year:O\", title=None),\n",
    "    y=alt.Y(\"count:Q\", title=\"Number of files\"),\n",
    "    color=alt.Color(\"year:N\", legend=None),\n",
    "    facet=alt.Facet(\n",
    "        \"reason:O\", align=\"each\", columns=5, title=\"Reason for being closed\"\n",
    "    ),\n",
    "    tooltip=[\"year:O\", \"reason:N\", \"count:Q\"],\n",
    ").properties(height=200).resolve_scale(x=\"independent\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Focus on a specific reason\n",
    "\n",
    "Select a reason from the dropdown list to examine change over time."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<div id=\"altair-viz-6f6c2396f6d44392887f12b07151f18c\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  var VEGA_DEBUG = (typeof VEGA_DEBUG == \"undefined\") ? {} : VEGA_DEBUG;\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-6f6c2396f6d44392887f12b07151f18c\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-6f6c2396f6d44392887f12b07151f18c\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.17.0?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function maybeLoadScript(lib, version) {\n",
       "      var key = `${lib.replace(\"-\", \"\")}_version`;\n",
       "      return (VEGA_DEBUG[key] == version) ?\n",
       "        Promise.resolve(paths[lib]) :\n",
       "        new Promise(function(resolve, reject) {\n",
       "          var s = document.createElement('script');\n",
       "          document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "          s.async = true;\n",
       "          s.onload = () => {\n",
       "            VEGA_DEBUG[key] = version;\n",
       "            return resolve(paths[lib]);\n",
       "          };\n",
       "          s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "          s.src = paths[lib];\n",
       "        });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else {\n",
       "      maybeLoadScript(\"vega\", \"5\")\n",
       "        .then(() => maybeLoadScript(\"vega-lite\", \"4.17.0\"))\n",
       "        .then(() => maybeLoadScript(\"vega-embed\", \"6\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"config\": {\"view\": {\"continuousWidth\": 400, \"continuousHeight\": 300}}, \"data\": {\"name\": \"data-a015013f3640b08da2cc6adc70b7eeac\"}, \"mark\": \"bar\", \"encoding\": {\"color\": {\"field\": \"year\", \"legend\": null, \"type\": \"nominal\"}, \"column\": {\"field\": \"reason\", \"title\": \"Reason for being closed\", \"type\": \"nominal\"}, \"tooltip\": [{\"field\": \"year\", \"type\": \"ordinal\"}, {\"field\": \"reason\", \"type\": \"nominal\"}, {\"field\": \"count\", \"type\": \"quantitative\"}], \"x\": {\"field\": \"year\", \"title\": null, \"type\": \"ordinal\"}, \"y\": {\"field\": \"count\", \"title\": \"Number of files\", \"type\": \"quantitative\"}}, \"height\": 200, \"resolve\": {\"scale\": {\"x\": \"independent\"}}, \"selection\": {\"Select\": {\"type\": \"single\", \"fields\": [\"reason\"], \"bind\": {\"input\": \"select\", \"options\": [null, \"33(1)(a)\", \"33(1)(b)\", \"33(1)(c)\", \"33(1)(d)\", \"33(1)(e)(i)\", \"33(1)(e)(ii)\", \"33(1)(e)(iii)\", \"33(1)(f)(i)\", \"33(1)(f)(ii)\", \"33(1)(f)(iii)\", \"33(1)(g)\", \"33(1)(h)\", \"33(1)(j)\", \"33(2)(a)\", \"33(2)(b)\", \"33(3)(a)(i)\", \"33(3)(a)(ii)\", \"33(3)(b)\", \"Cabinet notebooks\", \"Closed period\", \"Court records\", \"Destroyed\", \"MAKE YOUR SELECTION\", \"NRF\", \"No reason\", \"Non Cwlth-depositor\", \"Non Cwlth-no appeal\", \"Parliament Class A\", \"Pre Access Recorder\", \"Withheld pending adv\", \"['33(1)(a)', '33(1)(b)', '33(1)(c)', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(b)', '33(1)(d)', '33(1)(g)', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(b)', '33(1)(d)', '33(1)(g)']\", \"['33(1)(a)', '33(1)(b)', '33(1)(d)', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(b)', '33(1)(d)']\", \"['33(1)(a)', '33(1)(b)', '33(1)(e)(ii)', '33(1)(g)']\", \"['33(1)(a)', '33(1)(b)', '33(1)(e)(ii)']\", \"['33(1)(a)', '33(1)(b)', '33(1)(e)(iii)']\", \"['33(1)(a)', '33(1)(b)', '33(1)(g)', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(b)', 'Closed period', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(b)', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(b)']\", \"['33(1)(a)', '33(1)(c)']\", \"['33(1)(a)', '33(1)(d)', '33(1)(e)(i)', '33(1)(g)', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(d)', '33(1)(e)(i)', '33(1)(g)']\", \"['33(1)(a)', '33(1)(d)', '33(1)(e)(i)']\", \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(e)(iii)', 'NRF']\", \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(e)(iii)', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(e)(iii)']\", \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(g)', 'Closed period', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(g)']\", \"['33(1)(a)', '33(1)(d)', '33(1)(e)(iii)', '33(1)(g)']\", \"['33(1)(a)', '33(1)(d)', '33(1)(e)(iii)']\", \"['33(1)(a)', '33(1)(d)', '33(1)(g)', '33(1)(e)(i)']\", \"['33(1)(a)', '33(1)(d)', '33(1)(g)', '33(1)(e)(ii)']\", \"['33(1)(a)', '33(1)(d)', '33(1)(g)', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(d)', '33(1)(g)']\", \"['33(1)(a)', '33(1)(d)']\", \"['33(1)(a)', '33(1)(e)(ii)', '33(1)(g)']\", \"['33(1)(a)', '33(1)(e)(ii)']\", \"['33(1)(a)', '33(1)(e)(iii)']\", \"['33(1)(a)', '33(1)(f)(iii)']\", \"['33(1)(a)', '33(1)(g)', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(g)']\", \"['33(1)(a)', '33(1)(j)', '33(2)(a)', '33(2)(b)']\", \"['33(1)(a)', 'Closed period', 'Withheld pending adv']\", \"['33(1)(a)', 'Withheld pending adv']\", \"['33(1)(a)']\", \"['33(1)(b)', '33(1)(d)', '33(1)(e)(ii)']\", \"['33(1)(b)', '33(1)(e)(ii)']\", \"['33(1)(b)', '33(1)(e)(iii)']\", \"['33(1)(b)', '33(1)(g)']\", \"['33(1)(b)', 'Withheld pending adv']\", \"['33(1)(b)']\", \"['33(1)(c)']\", \"['33(1)(d)', '33(1)(e)(ii)', '33(1)(g)']\", \"['33(1)(d)', '33(1)(e)(ii)']\", \"['33(1)(d)', '33(1)(e)(iii)', '33(1)(g)']\", \"['33(1)(d)', '33(1)(g)', '33(1)(j)', '33(1)(f)(ii)']\", \"['33(1)(d)', '33(1)(g)', '33(1)(j)', 'Closed period']\", \"['33(1)(d)', '33(1)(g)', '33(1)(j)']\", \"['33(1)(d)', '33(1)(g)', 'Closed period']\", \"['33(1)(d)', '33(1)(g)']\", \"['33(1)(d)']\", \"['33(1)(e)(i)', '33(1)(e)(ii)', '33(1)(g)']\", \"['33(1)(e)(i)', '33(1)(f)(i)', '33(1)(g)']\", \"['33(1)(e)(i)', '33(1)(g)']\", \"['33(1)(e)(ii)', '33(1)(g)', '33(1)(j)']\", \"['33(1)(e)(ii)', '33(1)(g)']\", \"['33(1)(e)(ii)']\", \"['33(1)(e)(iii)', '33(1)(f)(iii)']\", \"['33(1)(e)(iii)', '33(1)(g)']\", \"['33(1)(e)(iii)', 'Withheld pending adv']\", \"['33(1)(e)(iii)']\", \"['33(1)(f)(i)']\", \"['33(1)(f)(ii)']\", \"['33(1)(f)(iii)', '33(1)(g)']\", \"['33(1)(f)(iii)']\", \"['33(1)(g)', '33(1)(j)', 'Closed period']\", \"['33(1)(g)', '33(1)(j)']\", \"['33(1)(g)', 'Closed period']\", \"['33(1)(g)', 'MAKE YOUR SELECTION']\", \"['33(1)(g)', 'Non Cwlth-depositor']\", \"['33(1)(g)', 'Non Cwlth-no appeal']\", \"['33(1)(g)', 'Parliament Class A']\", \"['33(1)(g)']\", \"['33(1)(h)']\", \"['33(1)(j)']\", \"['33(2)(a)', '33(2)(b)', '33(3)(a)(i)', '33(3)(a)(ii)', '33(3)(b)']\", \"['33(2)(a)', '33(2)(b)', 'Withheld pending adv']\", \"['33(2)(a)', '33(2)(b)']\", \"['33(3)(a)(i)', '33(3)(a)(ii)', '33(3)(b)']\", \"['33(3)(a)(i)', '33(3)(b)', '33(3)(a)(ii)', '33(3)(b)']\", \"['33(3)(a)(ii)', '33(3)(b)', 'MAKE YOUR SELECTION']\", \"['33(3)(a)(ii)', '33(3)(b)']\", \"['Closed period', 'Non Cwlth-no appeal']\", \"['Closed period', 'Withheld pending adv']\", \"['Closed period']\", \"['Court records']\", \"['Destroyed']\", \"['MAKE YOUR SELECTION', 'Withheld pending adv']\", \"['MAKE YOUR SELECTION']\", \"['NRF']\", \"['Non Cwlth-depositor']\", \"['Non Cwlth-no appeal']\", \"['Parliament Class A']\", \"['Withheld pending adv']\", \"[]\"], \"labels\": [\"All\", \"33(1)(a)\", \"33(1)(b)\", \"33(1)(c)\", \"33(1)(d)\", \"33(1)(e)(i)\", \"33(1)(e)(ii)\", \"33(1)(e)(iii)\", \"33(1)(f)(i)\", \"33(1)(f)(ii)\", \"33(1)(f)(iii)\", \"33(1)(g)\", \"33(1)(h)\", \"33(1)(j)\", \"33(2)(a)\", \"33(2)(b)\", \"33(3)(a)(i)\", \"33(3)(a)(ii)\", \"33(3)(b)\", \"Cabinet notebooks\", \"Closed period\", \"Court records\", \"Destroyed\", \"MAKE YOUR SELECTION\", \"NRF\", \"No reason\", \"Non Cwlth-depositor\", \"Non Cwlth-no appeal\", \"Parliament Class A\", \"Pre Access Recorder\", \"Withheld pending adv\", \"['33(1)(a)', '33(1)(b)', '33(1)(c)', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(b)', '33(1)(d)', '33(1)(g)', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(b)', '33(1)(d)', '33(1)(g)']\", \"['33(1)(a)', '33(1)(b)', '33(1)(d)', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(b)', '33(1)(d)']\", \"['33(1)(a)', '33(1)(b)', '33(1)(e)(ii)', '33(1)(g)']\", \"['33(1)(a)', '33(1)(b)', '33(1)(e)(ii)']\", \"['33(1)(a)', '33(1)(b)', '33(1)(e)(iii)']\", \"['33(1)(a)', '33(1)(b)', '33(1)(g)', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(b)', 'Closed period', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(b)', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(b)']\", \"['33(1)(a)', '33(1)(c)']\", \"['33(1)(a)', '33(1)(d)', '33(1)(e)(i)', '33(1)(g)', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(d)', '33(1)(e)(i)', '33(1)(g)']\", \"['33(1)(a)', '33(1)(d)', '33(1)(e)(i)']\", \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(e)(iii)', 'NRF']\", \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(e)(iii)', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(e)(iii)']\", \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(g)', 'Closed period', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(g)']\", \"['33(1)(a)', '33(1)(d)', '33(1)(e)(iii)', '33(1)(g)']\", \"['33(1)(a)', '33(1)(d)', '33(1)(e)(iii)']\", \"['33(1)(a)', '33(1)(d)', '33(1)(g)', '33(1)(e)(i)']\", \"['33(1)(a)', '33(1)(d)', '33(1)(g)', '33(1)(e)(ii)']\", \"['33(1)(a)', '33(1)(d)', '33(1)(g)', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(d)', '33(1)(g)']\", \"['33(1)(a)', '33(1)(d)']\", \"['33(1)(a)', '33(1)(e)(ii)', '33(1)(g)']\", \"['33(1)(a)', '33(1)(e)(ii)']\", \"['33(1)(a)', '33(1)(e)(iii)']\", \"['33(1)(a)', '33(1)(f)(iii)']\", \"['33(1)(a)', '33(1)(g)', 'Withheld pending adv']\", \"['33(1)(a)', '33(1)(g)']\", \"['33(1)(a)', '33(1)(j)', '33(2)(a)', '33(2)(b)']\", \"['33(1)(a)', 'Closed period', 'Withheld pending adv']\", \"['33(1)(a)', 'Withheld pending adv']\", \"['33(1)(a)']\", \"['33(1)(b)', '33(1)(d)', '33(1)(e)(ii)']\", \"['33(1)(b)', '33(1)(e)(ii)']\", \"['33(1)(b)', '33(1)(e)(iii)']\", \"['33(1)(b)', '33(1)(g)']\", \"['33(1)(b)', 'Withheld pending adv']\", \"['33(1)(b)']\", \"['33(1)(c)']\", \"['33(1)(d)', '33(1)(e)(ii)', '33(1)(g)']\", \"['33(1)(d)', '33(1)(e)(ii)']\", \"['33(1)(d)', '33(1)(e)(iii)', '33(1)(g)']\", \"['33(1)(d)', '33(1)(g)', '33(1)(j)', '33(1)(f)(ii)']\", \"['33(1)(d)', '33(1)(g)', '33(1)(j)', 'Closed period']\", \"['33(1)(d)', '33(1)(g)', '33(1)(j)']\", \"['33(1)(d)', '33(1)(g)', 'Closed period']\", \"['33(1)(d)', '33(1)(g)']\", \"['33(1)(d)']\", \"['33(1)(e)(i)', '33(1)(e)(ii)', '33(1)(g)']\", \"['33(1)(e)(i)', '33(1)(f)(i)', '33(1)(g)']\", \"['33(1)(e)(i)', '33(1)(g)']\", \"['33(1)(e)(ii)', '33(1)(g)', '33(1)(j)']\", \"['33(1)(e)(ii)', '33(1)(g)']\", \"['33(1)(e)(ii)']\", \"['33(1)(e)(iii)', '33(1)(f)(iii)']\", \"['33(1)(e)(iii)', '33(1)(g)']\", \"['33(1)(e)(iii)', 'Withheld pending adv']\", \"['33(1)(e)(iii)']\", \"['33(1)(f)(i)']\", \"['33(1)(f)(ii)']\", \"['33(1)(f)(iii)', '33(1)(g)']\", \"['33(1)(f)(iii)']\", \"['33(1)(g)', '33(1)(j)', 'Closed period']\", \"['33(1)(g)', '33(1)(j)']\", \"['33(1)(g)', 'Closed period']\", \"['33(1)(g)', 'MAKE YOUR SELECTION']\", \"['33(1)(g)', 'Non Cwlth-depositor']\", \"['33(1)(g)', 'Non Cwlth-no appeal']\", \"['33(1)(g)', 'Parliament Class A']\", \"['33(1)(g)']\", \"['33(1)(h)']\", \"['33(1)(j)']\", \"['33(2)(a)', '33(2)(b)', '33(3)(a)(i)', '33(3)(a)(ii)', '33(3)(b)']\", \"['33(2)(a)', '33(2)(b)', 'Withheld pending adv']\", \"['33(2)(a)', '33(2)(b)']\", \"['33(3)(a)(i)', '33(3)(a)(ii)', '33(3)(b)']\", \"['33(3)(a)(i)', '33(3)(b)', '33(3)(a)(ii)', '33(3)(b)']\", \"['33(3)(a)(ii)', '33(3)(b)', 'MAKE YOUR SELECTION']\", \"['33(3)(a)(ii)', '33(3)(b)']\", \"['Closed period', 'Non Cwlth-no appeal']\", \"['Closed period', 'Withheld pending adv']\", \"['Closed period']\", \"['Court records']\", \"['Destroyed']\", \"['MAKE YOUR SELECTION', 'Withheld pending adv']\", \"['MAKE YOUR SELECTION']\", \"['NRF']\", \"['Non Cwlth-depositor']\", \"['Non Cwlth-no appeal']\", \"['Parliament Class A']\", \"['Withheld pending adv']\", \"[]\"]}}}, \"transform\": [{\"filter\": {\"selection\": \"Select\"}}], \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.17.0.json\", \"datasets\": {\"data-a015013f3640b08da2cc6adc70b7eeac\": [{\"year\": \"2015\", \"reason\": \"33(1)(a)\", \"count\": 1010}, {\"year\": \"2015\", \"reason\": \"33(1)(b)\", \"count\": 425}, {\"year\": \"2015\", \"reason\": \"33(1)(c)\", \"count\": 5}, {\"year\": \"2015\", \"reason\": \"33(1)(d)\", \"count\": 281}, {\"year\": \"2015\", \"reason\": \"33(1)(e)(i)\", \"count\": 46}, {\"year\": \"2015\", \"reason\": \"33(1)(e)(ii)\", \"count\": 120}, {\"year\": \"2015\", \"reason\": \"33(1)(e)(iii)\", \"count\": 21}, {\"year\": \"2015\", \"reason\": \"33(1)(f)(ii)\", \"count\": 3}, {\"year\": \"2015\", \"reason\": \"33(1)(f)(iii)\", \"count\": 3}, {\"year\": \"2015\", \"reason\": \"33(1)(g)\", \"count\": 4048}, {\"year\": \"2015\", \"reason\": \"33(1)(h)\", \"count\": 5}, {\"year\": \"2015\", \"reason\": \"33(1)(j)\", \"count\": 22}, {\"year\": \"2015\", \"reason\": \"33(2)(a)\", \"count\": 9}, {\"year\": \"2015\", \"reason\": \"33(2)(b)\", \"count\": 9}, {\"year\": \"2015\", \"reason\": \"33(3)(a)(i)\", \"count\": 29}, {\"year\": \"2015\", \"reason\": \"33(3)(a)(ii)\", \"count\": 29}, {\"year\": \"2015\", \"reason\": \"33(3)(b)\", \"count\": 58}, {\"year\": \"2015\", \"reason\": \"Cabinet notebooks\", \"count\": 1}, {\"year\": \"2015\", \"reason\": \"Closed period\", \"count\": 2565}, {\"year\": \"2015\", \"reason\": \"Court records\", \"count\": 4}, {\"year\": \"2015\", \"reason\": \"Destroyed\", \"count\": 1}, {\"year\": \"2015\", \"reason\": \"MAKE YOUR SELECTION\", \"count\": 13}, {\"year\": \"2015\", \"reason\": \"NRF\", \"count\": 2}, {\"year\": \"2015\", \"reason\": \"No reason\", \"count\": 62}, {\"year\": \"2015\", \"reason\": \"Non Cwlth-depositor\", \"count\": 3}, {\"year\": \"2015\", \"reason\": \"Non Cwlth-no appeal\", \"count\": 52}, {\"year\": \"2015\", \"reason\": \"Parliament Class A\", \"count\": 1409}, {\"year\": \"2015\", \"reason\": \"Pre Access Recorder\", \"count\": 2812}, {\"year\": \"2015\", \"reason\": \"Withheld pending adv\", \"count\": 3410}, {\"year\": \"2016\", \"reason\": \"33(1)(a)\", \"count\": 896}, {\"year\": \"2016\", \"reason\": \"33(1)(b)\", \"count\": 371}, {\"year\": \"2016\", \"reason\": \"33(1)(c)\", \"count\": 5}, {\"year\": \"2016\", \"reason\": \"33(1)(d)\", \"count\": 244}, {\"year\": \"2016\", \"reason\": \"33(1)(e)(i)\", \"count\": 33}, {\"year\": \"2016\", \"reason\": \"33(1)(e)(ii)\", \"count\": 104}, {\"year\": \"2016\", \"reason\": \"33(1)(e)(iii)\", \"count\": 27}, {\"year\": \"2016\", \"reason\": \"33(1)(f)(ii)\", \"count\": 2}, {\"year\": \"2016\", \"reason\": \"33(1)(f)(iii)\", \"count\": 3}, {\"year\": \"2016\", \"reason\": \"33(1)(g)\", \"count\": 4718}, {\"year\": \"2016\", \"reason\": \"33(1)(h)\", \"count\": 4}, {\"year\": \"2016\", \"reason\": \"33(1)(j)\", \"count\": 16}, {\"year\": \"2016\", \"reason\": \"33(2)(a)\", \"count\": 16}, {\"year\": \"2016\", \"reason\": \"33(2)(b)\", \"count\": 16}, {\"year\": \"2016\", \"reason\": \"33(3)(a)(i)\", \"count\": 36}, {\"year\": \"2016\", \"reason\": \"33(3)(a)(ii)\", \"count\": 29}, {\"year\": \"2016\", \"reason\": \"33(3)(b)\", \"count\": 65}, {\"year\": \"2016\", \"reason\": \"Closed period\", \"count\": 113}, {\"year\": \"2016\", \"reason\": \"Court records\", \"count\": 5}, {\"year\": \"2016\", \"reason\": \"MAKE YOUR SELECTION\", \"count\": 4}, {\"year\": \"2016\", \"reason\": \"NRF\", \"count\": 2}, {\"year\": \"2016\", \"reason\": \"No reason\", \"count\": 41}, {\"year\": \"2016\", \"reason\": \"Non Cwlth-depositor\", \"count\": 3}, {\"year\": \"2016\", \"reason\": \"Non Cwlth-no appeal\", \"count\": 44}, {\"year\": \"2016\", \"reason\": \"Parliament Class A\", \"count\": 1235}, {\"year\": \"2016\", \"reason\": \"Pre Access Recorder\", \"count\": 2}, {\"year\": \"2016\", \"reason\": \"Withheld pending adv\", \"count\": 3845}, {\"year\": \"2017\", \"reason\": \"33(1)(a)\", \"count\": 839}, {\"year\": \"2017\", \"reason\": \"33(1)(b)\", \"count\": 362}, {\"year\": \"2017\", \"reason\": \"33(1)(c)\", \"count\": 3}, {\"year\": \"2017\", \"reason\": \"33(1)(d)\", \"count\": 225}, {\"year\": \"2017\", \"reason\": \"33(1)(e)(i)\", \"count\": 16}, {\"year\": \"2017\", \"reason\": \"33(1)(e)(ii)\", \"count\": 97}, {\"year\": \"2017\", \"reason\": \"33(1)(e)(iii)\", \"count\": 28}, {\"year\": \"2017\", \"reason\": \"33(1)(f)(ii)\", \"count\": 2}, {\"year\": \"2017\", \"reason\": \"33(1)(f)(iii)\", \"count\": 4}, {\"year\": \"2017\", \"reason\": \"33(1)(g)\", \"count\": 4706}, {\"year\": \"2017\", \"reason\": \"33(1)(h)\", \"count\": 4}, {\"year\": \"2017\", \"reason\": \"33(1)(j)\", \"count\": 21}, {\"year\": \"2017\", \"reason\": \"33(2)(a)\", \"count\": 16}, {\"year\": \"2017\", \"reason\": \"33(2)(b)\", \"count\": 16}, {\"year\": \"2017\", \"reason\": \"33(3)(a)(i)\", \"count\": 32}, {\"year\": \"2017\", \"reason\": \"33(3)(a)(ii)\", \"count\": 24}, {\"year\": \"2017\", \"reason\": \"33(3)(b)\", \"count\": 56}, {\"year\": \"2017\", \"reason\": \"Closed period\", \"count\": 123}, {\"year\": \"2017\", \"reason\": \"Court records\", \"count\": 5}, {\"year\": \"2017\", \"reason\": \"MAKE YOUR SELECTION\", \"count\": 8}, {\"year\": \"2017\", \"reason\": \"NRF\", \"count\": 3}, {\"year\": \"2017\", \"reason\": \"No reason\", \"count\": 47}, {\"year\": \"2017\", \"reason\": \"Non Cwlth-depositor\", \"count\": 5}, {\"year\": \"2017\", \"reason\": \"Non Cwlth-no appeal\", \"count\": 57}, {\"year\": \"2017\", \"reason\": \"Parliament Class A\", \"count\": 1301}, {\"year\": \"2017\", \"reason\": \"Pre Access Recorder\", \"count\": 2}, {\"year\": \"2017\", \"reason\": \"Withheld pending adv\", \"count\": 4213}, {\"year\": \"2018\", \"reason\": \"33(1)(a)\", \"count\": 1097}, {\"year\": \"2018\", \"reason\": \"33(1)(b)\", \"count\": 355}, {\"year\": \"2018\", \"reason\": \"33(1)(c)\", \"count\": 3}, {\"year\": \"2018\", \"reason\": \"33(1)(d)\", \"count\": 376}, {\"year\": \"2018\", \"reason\": \"33(1)(e)(i)\", \"count\": 50}, {\"year\": \"2018\", \"reason\": \"33(1)(e)(ii)\", \"count\": 120}, {\"year\": \"2018\", \"reason\": \"33(1)(e)(iii)\", \"count\": 32}, {\"year\": \"2018\", \"reason\": \"33(1)(f)(i)\", \"count\": 7}, {\"year\": \"2018\", \"reason\": \"33(1)(f)(ii)\", \"count\": 2}, {\"year\": \"2018\", \"reason\": \"33(1)(f)(iii)\", \"count\": 4}, {\"year\": \"2018\", \"reason\": \"33(1)(g)\", \"count\": 4908}, {\"year\": \"2018\", \"reason\": \"33(1)(h)\", \"count\": 4}, {\"year\": \"2018\", \"reason\": \"33(1)(j)\", \"count\": 23}, {\"year\": \"2018\", \"reason\": \"33(2)(a)\", \"count\": 21}, {\"year\": \"2018\", \"reason\": \"33(2)(b)\", \"count\": 21}, {\"year\": \"2018\", \"reason\": \"33(3)(a)(i)\", \"count\": 35}, {\"year\": \"2018\", \"reason\": \"33(3)(a)(ii)\", \"count\": 24}, {\"year\": \"2018\", \"reason\": \"33(3)(b)\", \"count\": 59}, {\"year\": \"2018\", \"reason\": \"Closed period\", \"count\": 575}, {\"year\": \"2018\", \"reason\": \"Court records\", \"count\": 6}, {\"year\": \"2018\", \"reason\": \"MAKE YOUR SELECTION\", \"count\": 7}, {\"year\": \"2018\", \"reason\": \"NRF\", \"count\": 13}, {\"year\": \"2018\", \"reason\": \"No reason\", \"count\": 46}, {\"year\": \"2018\", \"reason\": \"Non Cwlth-depositor\", \"count\": 29}, {\"year\": \"2018\", \"reason\": \"Non Cwlth-no appeal\", \"count\": 60}, {\"year\": \"2018\", \"reason\": \"Parliament Class A\", \"count\": 1456}, {\"year\": \"2018\", \"reason\": \"Pre Access Recorder\", \"count\": 2}, {\"year\": \"2018\", \"reason\": \"Withheld pending adv\", \"count\": 3989}, {\"year\": \"2019\", \"reason\": \"33(1)(a)\", \"count\": 1133}, {\"year\": \"2019\", \"reason\": \"33(1)(b)\", \"count\": 363}, {\"year\": \"2019\", \"reason\": \"33(1)(c)\", \"count\": 3}, {\"year\": \"2019\", \"reason\": \"33(1)(d)\", \"count\": 399}, {\"year\": \"2019\", \"reason\": \"33(1)(e)(i)\", \"count\": 53}, {\"year\": \"2019\", \"reason\": \"33(1)(e)(ii)\", \"count\": 122}, {\"year\": \"2019\", \"reason\": \"33(1)(e)(iii)\", \"count\": 45}, {\"year\": \"2019\", \"reason\": \"33(1)(f)(i)\", \"count\": 7}, {\"year\": \"2019\", \"reason\": \"33(1)(f)(ii)\", \"count\": 5}, {\"year\": \"2019\", \"reason\": \"33(1)(f)(iii)\", \"count\": 4}, {\"year\": \"2019\", \"reason\": \"33(1)(g)\", \"count\": 4901}, {\"year\": \"2019\", \"reason\": \"33(1)(h)\", \"count\": 4}, {\"year\": \"2019\", \"reason\": \"33(1)(j)\", \"count\": 28}, {\"year\": \"2019\", \"reason\": \"33(2)(a)\", \"count\": 22}, {\"year\": \"2019\", \"reason\": \"33(2)(b)\", \"count\": 22}, {\"year\": \"2019\", \"reason\": \"33(3)(a)(i)\", \"count\": 38}, {\"year\": \"2019\", \"reason\": \"33(3)(a)(ii)\", \"count\": 28}, {\"year\": \"2019\", \"reason\": \"33(3)(b)\", \"count\": 66}, {\"year\": \"2019\", \"reason\": \"Closed period\", \"count\": 758}, {\"year\": \"2019\", \"reason\": \"Court records\", \"count\": 9}, {\"year\": \"2019\", \"reason\": \"MAKE YOUR SELECTION\", \"count\": 12}, {\"year\": \"2019\", \"reason\": \"NRF\", \"count\": 14}, {\"year\": \"2019\", \"reason\": \"No reason\", \"count\": 48}, {\"year\": \"2019\", \"reason\": \"Non Cwlth-depositor\", \"count\": 29}, {\"year\": \"2019\", \"reason\": \"Non Cwlth-no appeal\", \"count\": 62}, {\"year\": \"2019\", \"reason\": \"Parliament Class A\", \"count\": 1280}, {\"year\": \"2019\", \"reason\": \"Withheld pending adv\", \"count\": 3835}, {\"year\": \"2020\", \"reason\": \"33(1)(a)\", \"count\": 1096}, {\"year\": \"2020\", \"reason\": \"33(1)(b)\", \"count\": 362}, {\"year\": \"2020\", \"reason\": \"33(1)(c)\", \"count\": 3}, {\"year\": \"2020\", \"reason\": \"33(1)(d)\", \"count\": 429}, {\"year\": \"2020\", \"reason\": \"33(1)(e)(i)\", \"count\": 37}, {\"year\": \"2020\", \"reason\": \"33(1)(e)(ii)\", \"count\": 110}, {\"year\": \"2020\", \"reason\": \"33(1)(e)(iii)\", \"count\": 46}, {\"year\": \"2020\", \"reason\": \"33(1)(f)(i)\", \"count\": 7}, {\"year\": \"2020\", \"reason\": \"33(1)(f)(ii)\", \"count\": 5}, {\"year\": \"2020\", \"reason\": \"33(1)(f)(iii)\", \"count\": 4}, {\"year\": \"2020\", \"reason\": \"33(1)(g)\", \"count\": 5003}, {\"year\": \"2020\", \"reason\": \"33(1)(h)\", \"count\": 4}, {\"year\": \"2020\", \"reason\": \"33(1)(j)\", \"count\": 30}, {\"year\": \"2020\", \"reason\": \"33(2)(a)\", \"count\": 24}, {\"year\": \"2020\", \"reason\": \"33(2)(b)\", \"count\": 24}, {\"year\": \"2020\", \"reason\": \"33(3)(a)(i)\", \"count\": 38}, {\"year\": \"2020\", \"reason\": \"33(3)(a)(ii)\", \"count\": 28}, {\"year\": \"2020\", \"reason\": \"33(3)(b)\", \"count\": 66}, {\"year\": \"2020\", \"reason\": \"Closed period\", \"count\": 239}, {\"year\": \"2020\", \"reason\": \"Court records\", \"count\": 9}, {\"year\": \"2020\", \"reason\": \"Destroyed\", \"count\": 2}, {\"year\": \"2020\", \"reason\": \"MAKE YOUR SELECTION\", \"count\": 12}, {\"year\": \"2020\", \"reason\": \"NRF\", \"count\": 15}, {\"year\": \"2020\", \"reason\": \"No reason\", \"count\": 49}, {\"year\": \"2020\", \"reason\": \"Non Cwlth-depositor\", \"count\": 10}, {\"year\": \"2020\", \"reason\": \"Non Cwlth-no appeal\", \"count\": 60}, {\"year\": \"2020\", \"reason\": \"Parliament Class A\", \"count\": 1286}, {\"year\": \"2020\", \"reason\": \"Withheld pending adv\", \"count\": 3524}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', '33(1)(c)', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', '33(1)(d)', '33(1)(g)', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', '33(1)(d)', '33(1)(g)']\", \"count\": 2}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', '33(1)(d)', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', '33(1)(d)']\", \"count\": 4}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', '33(1)(e)(ii)', '33(1)(g)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', '33(1)(e)(ii)']\", \"count\": 4}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', '33(1)(e)(iii)']\", \"count\": 9}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', '33(1)(g)', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', 'Closed period', 'Withheld pending adv']\", \"count\": 3}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)', 'Withheld pending adv']\", \"count\": 50}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(b)']\", \"count\": 261}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(c)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(e)(i)', '33(1)(g)', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(e)(i)', '33(1)(g)']\", \"count\": 24}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(e)(i)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(e)(iii)', 'NRF']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(e)(iii)', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(e)(iii)']\", \"count\": 4}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(g)', 'Closed period', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(e)(ii)', '33(1)(g)']\", \"count\": 27}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(e)(iii)', '33(1)(g)']\", \"count\": 3}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(e)(iii)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(g)', '33(1)(e)(i)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(g)', '33(1)(e)(ii)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(g)', 'Withheld pending adv']\", \"count\": 2}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)', '33(1)(g)']\", \"count\": 116}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(d)']\", \"count\": 4}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(e)(ii)', '33(1)(g)']\", \"count\": 5}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(e)(ii)']\", \"count\": 2}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(e)(iii)']\", \"count\": 5}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(f)(iii)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(g)', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(g)']\", \"count\": 6}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', '33(1)(j)', '33(2)(a)', '33(2)(b)']\", \"count\": 6}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', 'Closed period', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)', 'Withheld pending adv']\", \"count\": 43}, {\"year\": \"2021\", \"reason\": \"['33(1)(a)']\", \"count\": 502}, {\"year\": \"2021\", \"reason\": \"['33(1)(b)', '33(1)(d)', '33(1)(e)(ii)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(b)', '33(1)(e)(ii)']\", \"count\": 2}, {\"year\": \"2021\", \"reason\": \"['33(1)(b)', '33(1)(e)(iii)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(b)', '33(1)(g)']\", \"count\": 2}, {\"year\": \"2021\", \"reason\": \"['33(1)(b)', 'Withheld pending adv']\", \"count\": 2}, {\"year\": \"2021\", \"reason\": \"['33(1)(b)']\", \"count\": 15}, {\"year\": \"2021\", \"reason\": \"['33(1)(c)']\", \"count\": 14}, {\"year\": \"2021\", \"reason\": \"['33(1)(d)', '33(1)(e)(ii)', '33(1)(g)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(d)', '33(1)(e)(ii)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(d)', '33(1)(e)(iii)', '33(1)(g)']\", \"count\": 19}, {\"year\": \"2021\", \"reason\": \"['33(1)(d)', '33(1)(g)', '33(1)(j)', '33(1)(f)(ii)']\", \"count\": 3}, {\"year\": \"2021\", \"reason\": \"['33(1)(d)', '33(1)(g)', '33(1)(j)', 'Closed period']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(d)', '33(1)(g)', '33(1)(j)']\", \"count\": 7}, {\"year\": \"2021\", \"reason\": \"['33(1)(d)', '33(1)(g)', 'Closed period']\", \"count\": 3}, {\"year\": \"2021\", \"reason\": \"['33(1)(d)', '33(1)(g)']\", \"count\": 176}, {\"year\": \"2021\", \"reason\": \"['33(1)(d)']\", \"count\": 50}, {\"year\": \"2021\", \"reason\": \"['33(1)(e)(i)', '33(1)(e)(ii)', '33(1)(g)']\", \"count\": 5}, {\"year\": \"2021\", \"reason\": \"['33(1)(e)(i)', '33(1)(f)(i)', '33(1)(g)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(e)(i)', '33(1)(g)']\", \"count\": 3}, {\"year\": \"2021\", \"reason\": \"['33(1)(e)(ii)', '33(1)(g)', '33(1)(j)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(e)(ii)', '33(1)(g)']\", \"count\": 25}, {\"year\": \"2021\", \"reason\": \"['33(1)(e)(ii)']\", \"count\": 24}, {\"year\": \"2021\", \"reason\": \"['33(1)(e)(iii)', '33(1)(f)(iii)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(e)(iii)', '33(1)(g)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(e)(iii)', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(e)(iii)']\", \"count\": 2}, {\"year\": \"2021\", \"reason\": \"['33(1)(f)(i)']\", \"count\": 6}, {\"year\": \"2021\", \"reason\": \"['33(1)(f)(ii)']\", \"count\": 2}, {\"year\": \"2021\", \"reason\": \"['33(1)(f)(iii)', '33(1)(g)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(f)(iii)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(g)', '33(1)(j)', 'Closed period']\", \"count\": 2}, {\"year\": \"2021\", \"reason\": \"['33(1)(g)', '33(1)(j)']\", \"count\": 4}, {\"year\": \"2021\", \"reason\": \"['33(1)(g)', 'Closed period']\", \"count\": 6}, {\"year\": \"2021\", \"reason\": \"['33(1)(g)', 'MAKE YOUR SELECTION']\", \"count\": 5}, {\"year\": \"2021\", \"reason\": \"['33(1)(g)', 'Non Cwlth-depositor']\", \"count\": 3}, {\"year\": \"2021\", \"reason\": \"['33(1)(g)', 'Non Cwlth-no appeal']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(g)', 'Parliament Class A']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(1)(g)']\", \"count\": 4807}, {\"year\": \"2021\", \"reason\": \"['33(1)(h)']\", \"count\": 4}, {\"year\": \"2021\", \"reason\": \"['33(1)(j)']\", \"count\": 8}, {\"year\": \"2021\", \"reason\": \"['33(2)(a)', '33(2)(b)', '33(3)(a)(i)', '33(3)(a)(ii)', '33(3)(b)']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(2)(a)', '33(2)(b)', 'Withheld pending adv']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(2)(a)', '33(2)(b)']\", \"count\": 15}, {\"year\": \"2021\", \"reason\": \"['33(3)(a)(i)', '33(3)(a)(ii)', '33(3)(b)']\", \"count\": 13}, {\"year\": \"2021\", \"reason\": \"['33(3)(a)(i)', '33(3)(b)', '33(3)(a)(ii)', '33(3)(b)']\", \"count\": 24}, {\"year\": \"2021\", \"reason\": \"['33(3)(a)(ii)', '33(3)(b)', 'MAKE YOUR SELECTION']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['33(3)(a)(ii)', '33(3)(b)']\", \"count\": 3}, {\"year\": \"2021\", \"reason\": \"['Closed period', 'Non Cwlth-no appeal']\", \"count\": 5}, {\"year\": \"2021\", \"reason\": \"['Closed period', 'Withheld pending adv']\", \"count\": 6}, {\"year\": \"2021\", \"reason\": \"['Closed period']\", \"count\": 220}, {\"year\": \"2021\", \"reason\": \"['Court records']\", \"count\": 9}, {\"year\": \"2021\", \"reason\": \"['Destroyed']\", \"count\": 2}, {\"year\": \"2021\", \"reason\": \"['MAKE YOUR SELECTION', 'Withheld pending adv']\", \"count\": 7}, {\"year\": \"2021\", \"reason\": \"['MAKE YOUR SELECTION']\", \"count\": 1}, {\"year\": \"2021\", \"reason\": \"['NRF']\", \"count\": 14}, {\"year\": \"2021\", \"reason\": \"['Non Cwlth-depositor']\", \"count\": 7}, {\"year\": \"2021\", \"reason\": \"['Non Cwlth-no appeal']\", \"count\": 53}, {\"year\": \"2021\", \"reason\": \"['Parliament Class A']\", \"count\": 1287}, {\"year\": \"2021\", \"reason\": \"['Withheld pending adv']\", \"count\": 3316}, {\"year\": \"2021\", \"reason\": \"[]\", \"count\": 80}]}}, {\"mode\": \"vega-lite\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.Chart(...)"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "input_dropdown = alt.binding_select(\n",
    "    options=[None] + unique_reasons, labels=[\"All\"] + unique_reasons\n",
    ")\n",
    "selection = alt.selection_single(fields=[\"reason\"], bind=input_dropdown, name=\"Select\")\n",
    "\n",
    "alt.Chart(harvest_reasons_counts).mark_bar().encode(\n",
    "    x=alt.X(\"year:O\", title=None),\n",
    "    y=alt.Y(\"count:Q\", title=\"Number of files\"),\n",
    "    color=alt.Color(\"year:N\", legend=None),\n",
    "    column=alt.Column(\"reason:N\", title=\"Reason for being closed\"),\n",
    "    tooltip=[\"year:O\", \"reason:N\", \"count:Q\"],\n",
    ").add_selection(selection).transform_filter(selection).properties(\n",
    "    height=200\n",
    ").resolve_scale(\n",
    "    x=\"independent\"\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.8.12"
  },
  "widgets": {
   "application/vnd.jupyter.widget-state+json": {
    "state": {},
    "version_major": 2,
    "version_minor": 0
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}