{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# How many of the functions are actually used?\n", "\n", "In this notebook we'll import data about functions that [we've harvested earlier](harvesting_functions_from_recordsearch.ipynb) and search for each of these functions in RecordSearch to see how many are actually used." ] }, { "cell_type": "code", "execution_count": 13, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "RendererRegistry.enable('notebook')" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import json\n", "import pandas as pd\n", "from tqdm import tqdm_notebook\n", "import altair as alt\n", "from recordsearch_tools.client import RSAgencySearchClient\n", "\n", "alt.renderers.enable('notebook')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Load and prepare the data" ] }, { "cell_type": "code", "execution_count": 14, "metadata": {}, "outputs": [], "source": [ "# Load the JSON file we've already harvested\n", "with open('data/functions.json', 'r') as json_file:\n", " functions = json.load(json_file)" ] }, { "cell_type": "code", "execution_count": 15, "metadata": {}, "outputs": [], "source": [ "def get_children(function):\n", " f_list = []\n", " if 'narrower' in function:\n", " for subf in function['narrower']:\n", " f_list.append(subf['term'])\n", " f_list += get_children(subf)\n", " return f_list\n", "\n", "functions_list = []\n", "for function in functions:\n", " functions_list.append(function['term'])\n", " functions_list += get_children(function)" ] }, { "cell_type": "code", "execution_count": 16, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['accommodation services',\n", " 'acquisition',\n", " 'administrative decision appeal',\n", " 'administrative decision review',\n", " 'administrative law',\n", " 'administrative services',\n", " 'advertising standards',\n", " 'aged persons services',\n", " 'agricultural sciences',\n", " 'agriculture',\n", " 'air force',\n", " 'air force administration',\n", " 'air force commands',\n", " 'air operations',\n", " 'air safety',\n", " 'air transport',\n", " 'air transport safety',\n", " 'aircraft standards',\n", " 'airport services',\n", " 'airports',\n", " 'ambulance services',\n", " 'analytical services',\n", " 'animal and veterinary sciences',\n", " 'applications for native title',\n", " 'applied sciences',\n", " 'arbitration',\n", " 'archives administration',\n", " 'army',\n", " 'army administration',\n", " 'army commands',\n", " 'artifact export regulation',\n", " 'arts',\n", " 'arts development',\n", " 'arts funding',\n", " 'arts incentive schemes',\n", " 'arts promotion',\n", " 'associations and corporate law',\n", " 'atmospheric sciences',\n", " 'audit',\n", " 'australian capital territory',\n", " 'australian defence forces (adf)',\n", " 'banking',\n", " 'bankruptcy',\n", " 'biological sciences',\n", " 'botany',\n", " 'bounties',\n", " 'broadcasting',\n", " 'broadcasting standards',\n", " 'building',\n", " 'built environment',\n", " 'cabinet',\n", " 'call centre administration',\n", " 'carriage service providers',\n", " 'carrier licensing',\n", " 'censorship',\n", " 'censorship standards',\n", " 'census collection',\n", " 'ceremonial functions',\n", " 'chemical and pesticide regulation',\n", " 'child welfare',\n", " 'citizenship',\n", " 'civic infrastructure',\n", " 'civic management',\n", " 'civil engineering',\n", " 'civil law',\n", " 'climate information services',\n", " 'coastal surveillance',\n", " 'collection access',\n", " 'collection accessioning',\n", " 'collection acquisition',\n", " 'collection management',\n", " 'collection promotion',\n", " 'collection storage',\n", " 'colonial administration',\n", " 'commissions of inquiry',\n", " 'committees of inquiry',\n", " 'commonwealth state relations',\n", " 'communications',\n", " 'community health services',\n", " 'community policing',\n", " 'community protection',\n", " 'community services',\n", " 'community support',\n", " 'community transport',\n", " 'compensation schemes',\n", " 'conservation',\n", " 'conservation programs',\n", " 'construction',\n", " 'consular services',\n", " 'consumer affairs',\n", " 'copyright',\n", " 'copyright regulation',\n", " 'coronial law',\n", " 'corporate affairs',\n", " 'corrective services',\n", " 'counselling services',\n", " 'counterfeiting',\n", " 'courier services',\n", " 'court reporting',\n", " 'courts and tribunals',\n", " 'courts martial',\n", " 'criminal law',\n", " 'criminology',\n", " 'crown land administration',\n", " 'cultural affairs',\n", " 'cultural awards and scholarships',\n", " 'cultural festivals',\n", " 'cultural gifts programs',\n", " 'currency',\n", " 'curriculum development',\n", " 'customs',\n", " 'customs regulations',\n", " 'declaration of interests',\n", " 'defence',\n", " 'defence administration',\n", " 'defence coordination',\n", " 'defence estate management',\n", " 'defence force careers',\n", " 'defence forces',\n", " 'defence forces assistance',\n", " 'defence industries',\n", " 'defence intelligence',\n", " 'defence research',\n", " 'defence service home schemes',\n", " 'dental services',\n", " 'deportation',\n", " 'detention programs',\n", " 'development assistance programs',\n", " 'diplomatic missions',\n", " 'disability services',\n", " 'disaster recovery',\n", " 'disaster relief',\n", " 'driving licenses administration',\n", " 'early childhood education',\n", " 'earth sciences',\n", " 'education',\n", " 'education and training',\n", " 'election campaigning',\n", " 'electoral boundary assessment',\n", " 'electoral matters',\n", " 'electronic commerce',\n", " 'electronic postal services',\n", " 'emergency funding',\n", " 'emergency management',\n", " 'emergency services',\n", " 'employment',\n", " 'employment services',\n", " 'energy',\n", " 'energy resources',\n", " 'environment',\n", " 'environmental impact assessment',\n", " 'environmental monitoring',\n", " 'equipment licensing',\n", " 'equity programs',\n", " 'ethical compliance',\n", " 'exchange rates',\n", " 'excise',\n", " 'export regulation',\n", " 'exports and imports',\n", " 'expositions',\n", " 'external security',\n", " 'extraditions',\n", " 'family law',\n", " 'federal law',\n", " 'field force (army)',\n", " 'film production',\n", " 'finance management',\n", " 'financial assistance',\n", " 'financial matters',\n", " 'firefighting services',\n", " 'fiscal policy',\n", " 'fisheries regulation',\n", " 'fleet',\n", " 'flight regulation',\n", " 'foreign investment control',\n", " 'foreign policy',\n", " 'forensic analysis',\n", " 'forestry regulation',\n", " 'freight',\n", " 'freight movement regulation',\n", " 'genetics',\n", " 'goods and services',\n", " 'governance',\n", " 'government accommodation and catering',\n", " 'government media',\n", " 'government representation overseas',\n", " 'governor general',\n", " 'grants administration',\n", " 'health',\n", " 'health care',\n", " 'health insurance',\n", " 'health services',\n", " 'hearing services',\n", " 'historic memorials',\n", " 'historic relic protection',\n", " 'home savings schemes',\n", " 'horticulture',\n", " 'hospitals and clinics',\n", " 'house of representatives committees',\n", " 'housing',\n", " 'human rights',\n", " 'human rights obligations',\n", " 'hydrology',\n", " 'immigration',\n", " 'import regulation',\n", " 'income assessment',\n", " 'indigenous affairs',\n", " 'indigenous cultural heritage',\n", " 'indigenous enterprises',\n", " 'indigenous heritage conservation',\n", " 'indigenous land rights',\n", " 'indigenous settlements',\n", " 'industrial relations',\n", " 'industries',\n", " 'information management standards',\n", " 'information security',\n", " 'inspection services',\n", " 'insurance',\n", " 'intelligence',\n", " 'intelligence liaison',\n", " 'intelligence support',\n", " 'internal security',\n", " 'international affairs',\n", " 'international liaison',\n", " 'international relations',\n", " 'international security liaison',\n", " 'international trade agreements',\n", " 'international treaty participation',\n", " 'internees',\n", " 'interpreter services',\n", " 'interstate trade agreements',\n", " 'investigation',\n", " 'justice administration',\n", " 'juvenile justice',\n", " 'labour market programs',\n", " 'land transport',\n", " 'land use',\n", " 'land use planning',\n", " 'land use zoning',\n", " 'land valuation',\n", " 'language services',\n", " 'law enforcement',\n", " 'leasing',\n", " 'legal',\n", " 'legal aid',\n", " 'legal aid services',\n", " 'legal services',\n", " 'legislation',\n", " 'lighthouses',\n", " 'literature funding',\n", " 'litigation processes',\n", " 'loans',\n", " 'local laws and ordinances',\n", " 'logistics',\n", " 'logistics (air force)',\n", " 'logistics (army)',\n", " 'logistics (defence)',\n", " 'maintenance',\n", " 'marine and rural regulation',\n", " 'marine and rural support',\n", " 'marine life protection programs',\n", " 'marine science',\n", " 'maritime commands (navy)',\n", " 'maritime services',\n", " 'market regulation',\n", " 'marketing',\n", " 'mathematical sciences',\n", " 'media ownership regulation',\n", " 'mediation programs',\n", " 'medical aids regulation',\n", " 'medical and health sciences',\n", " 'medical research',\n", " 'medical research funding',\n", " 'memorials',\n", " 'metals',\n", " 'meteorology',\n", " 'migrant accommodation services',\n", " 'migrant services',\n", " 'migrant settlements programs',\n", " 'migration',\n", " 'military operations',\n", " 'mineral exploration',\n", " 'mineral resources',\n", " 'mining',\n", " 'mobile telephone services',\n", " 'multicultural heritage promotion',\n", " 'multiculturalism',\n", " 'munitions',\n", " 'national events',\n", " 'national fitness',\n", " 'national heritage',\n", " 'national land use',\n", " 'national parks',\n", " 'national referral laboratory services',\n", " 'national service',\n", " 'native title claims',\n", " 'natural disasters',\n", " 'natural heritage protection',\n", " 'naturalisation assessment',\n", " 'navigation',\n", " 'navy',\n", " 'navy administration',\n", " 'navy commands',\n", " 'navy support',\n", " 'nursing services',\n", " 'occupational health and safety',\n", " 'oceanography',\n", " 'oceans governance',\n", " 'ombudsman',\n", " 'ordnance',\n", " 'overseas aid programs',\n", " 'overseas promotion',\n", " 'overseas student scholarship programs',\n", " 'parks',\n", " 'parliamentary chamber administration',\n", " 'parliamentary committees',\n", " 'parliamentary legislation',\n", " 'parliamentary matters',\n", " 'passenger entry control',\n", " 'passenger services',\n", " 'passport services',\n", " 'passports',\n", " 'pastoral',\n", " 'patent registration',\n", " 'patents and trademarks',\n", " 'pathology',\n", " 'peacekeeping forces',\n", " 'pensions and benefits',\n", " 'personnel',\n", " 'pharmaceuticals and medical aids',\n", " 'physical sciences',\n", " 'planning',\n", " 'police administration',\n", " 'police station',\n", " 'pollutant prevention programs',\n", " 'pollution emission control',\n", " 'population-based research',\n", " 'port authorities',\n", " 'port regulation',\n", " 'postal services',\n", " 'preschool education',\n", " 'presentation arrangements',\n", " 'preservation services',\n", " 'primary education',\n", " 'primary industries',\n", " 'prisoners of war',\n", " 'privacy guideline monitoring',\n", " 'property management',\n", " 'prosecution services',\n", " 'protective services',\n", " 'public borrowing',\n", " 'public service',\n", " 'public utilities',\n", " 'publishing',\n", " 'publishing and printing',\n", " 'quarantine',\n", " 'radio broadcasting',\n", " 'radio communication',\n", " 'rail harmonisation standards',\n", " 'rail land acquisition regulation',\n", " 'rail transport',\n", " 'rail transport safety',\n", " 'railway maintenance',\n", " 'rationing and price control',\n", " 'recordkeeping standards',\n", " 'records of the government',\n", " 'recreation',\n", " 'recruitment',\n", " 'refugee services',\n", " 'refugees',\n", " 'regional development',\n", " 'rehabilitation',\n", " 'removals',\n", " 'repatriation',\n", " 'repatriation hospitals',\n", " 'rescue coordination',\n", " 'research',\n", " 'research and development',\n", " 'resources',\n", " 'retail postal services',\n", " 'retirement income',\n", " 'revenue raising',\n", " 'road safety',\n", " 'road surface maintenance',\n", " 'road traffic regulation',\n", " 'road transport',\n", " 'road transport safety',\n", " 'royal commissions',\n", " 'rural community development',\n", " 'rural field day promotion',\n", " 'rural partnership programs',\n", " 'satellite communication',\n", " 'science',\n", " 'scientific research',\n", " 'sea safety',\n", " 'sea transport',\n", " 'seat of government',\n", " 'secondary education',\n", " 'secondary industries',\n", " 'security',\n", " 'security and intelligence',\n", " 'seismography',\n", " 'settlement negotiations',\n", " 'shipbuilding',\n", " 'social and economic research',\n", " 'social justice and equity',\n", " 'social welfare',\n", " 'space science',\n", " 'spatial information research',\n", " 'sport',\n", " 'standard setting',\n", " 'statistics',\n", " 'storage',\n", " 'strategic development',\n", " 'strategic policy',\n", " 'strategic support',\n", " 'student assistance',\n", " 'superannuation',\n", " 'supreme court law',\n", " 'supreme law',\n", " 'surveillance',\n", " 'surveillance, electronic',\n", " 'survey and mapping',\n", " 'tariff',\n", " 'tariff regulation',\n", " 'tariffs',\n", " 'taxation',\n", " 'taxation compliance',\n", " 'telecommunications',\n", " 'telephone services',\n", " 'television broadcasting',\n", " 'territory administration',\n", " 'tertiary education',\n", " 'tourism',\n", " 'tourism industry development',\n", " 'tourist event promotion',\n", " 'trade',\n", " 'trade development programs',\n", " 'trade expositions',\n", " 'trade practices',\n", " 'trade skills assessment',\n", " 'trade union training',\n", " 'trademark registration',\n", " 'training',\n", " 'training (air force)',\n", " 'training (army)',\n", " 'transport',\n", " 'transport and storage',\n", " 'transport infrastructure development',\n", " 'travel authorisation',\n", " 'travel missions',\n", " 'urban development',\n", " 'urban or regional development',\n", " 'valuation',\n", " 'vehicle registration',\n", " 'vehicle standards',\n", " \"veterans' affairs\",\n", " 'visas',\n", " 'viticulture',\n", " 'vocational training schemes',\n", " 'war memorials',\n", " 'wartime security',\n", " 'waste disposal',\n", " 'water conservation plans',\n", " 'water quality monitoring',\n", " 'water resources',\n", " 'water usage management',\n", " 'waterway management',\n", " 'weights and measures',\n", " 'works',\n", " 'world heritage listings',\n", " 'zoology']" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Get rid of duplicates\n", "functions_list = set(functions_list)\n", "# Sort terms\n", "sorted(functions_list)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Search for agencies associated with each function\n", "\n", "In RecordSearch, functions are performed by agencies. So when you search for a function you get back a list of agencies. Here we'll loop through the list of functions and search for associated agencies." ] }, { "cell_type": "code", "execution_count": 17, "metadata": {}, "outputs": [ { "data": { "application/vnd.jupyter.widget-view+json": { "model_id": "d3f22dfb9bbc4df587ff7f4c82688201", "version_major": 2, "version_minor": 0 }, "text/plain": [ "HBox(children=(IntProgress(value=0, max=472), HTML(value='')))" ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "\n" ] } ], "source": [ "function_totals = []\n", "# Use the agency search code in my recordsearch_tools library\n", "rsclient = RSAgencySearchClient()\n", "for function in tqdm_notebook(functions_list):\n", " agencies = rsclient.search_agencies(function=function, results_per_page=0)\n", " # Get the total results from each search (replace None with 0)\n", " total = 0 if agencies['total_results'] == None else int(agencies['total_results'])\n", " function_totals.append({'function': function, 'total': total})" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Explore the results" ] }, { "cell_type": "code", "execution_count": 18, "metadata": {}, "outputs": [], "source": [ "# Create a DataFrame with the results\n", "df = pd.DataFrame(function_totals)" ] }, { "cell_type": "code", "execution_count": 19, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
total
count472.000000
mean26.777542
std52.284938
min0.000000
25%0.000000
50%0.000000
75%28.000000
max417.000000
\n", "
" ], "text/plain": [ " total\n", "count 472.000000\n", "mean 26.777542\n", "std 52.284938\n", "min 0.000000\n", "25% 0.000000\n", "50% 0.000000\n", "75% 28.000000\n", "max 417.000000" ] }, "execution_count": 19, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.describe()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "So 75% of all functions have less than 28 associated agencies.\n", "\n", "How many are actiually used?" ] }, { "cell_type": "code", "execution_count": 20, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "229\n" ] } ], "source": [ "# How many functions are actually used\n", "used = df.loc[df['total'] > 0].count()\n", "print(used['total'])" ] }, { "cell_type": "code", "execution_count": 21, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "48.5% of the functions are used\n" ] } ], "source": [ "percent_used = used['function'] / len(functions_list)\n", "print('{:.1%} of the functions are used'.format(percent_used))" ] }, { "cell_type": "code", "execution_count": 22, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
functiontotal
363employment417
\n", "
" ], "text/plain": [ " function total\n", "363 employment 417" ] }, "execution_count": 22, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Most used function\n", "df.loc[df['total'] == df['total'].max()]" ] }, { "cell_type": "code", "execution_count": 23, "metadata": { "scrolled": true }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
functiontotal
363employment417
277education292
36army commands286
416social welfare268
376indigenous affairs267
244training230
219housing220
426scientific research212
136migration198
290goods and services195
67customs183
256government representation overseas176
40community services175
122secondary industries173
205administrative law169
105broadcasting168
228logistics (army)166
332sea transport160
123health159
236air transport154
\n", "
" ], "text/plain": [ " function total\n", "363 employment 417\n", "277 education 292\n", "36 army commands 286\n", "416 social welfare 268\n", "376 indigenous affairs 267\n", "244 training 230\n", "219 housing 220\n", "426 scientific research 212\n", "136 migration 198\n", "290 goods and services 195\n", "67 customs 183\n", "256 government representation overseas 176\n", "40 community services 175\n", "122 secondary industries 173\n", "205 administrative law 169\n", "105 broadcasting 168\n", "228 logistics (army) 166\n", "332 sea transport 160\n", "123 health 159\n", "236 air transport 154" ] }, "execution_count": 23, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Top 20 by number of agencies\n", "df.sort_values(by='total', ascending=False)[:20]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Show how agencies are distributed across functions" ] }, { "cell_type": "code", "execution_count": 24, "metadata": {}, "outputs": [ { "data": { "application/javascript": [ "var spec = {\"config\": {\"view\": {\"width\": 400, \"height\": 300}}, \"data\": {\"name\": \"data-a8a4ed3c4868c2634ece2fb1d908a4f8\"}, \"mark\": \"bar\", \"encoding\": {\"tooltip\": [{\"type\": \"quantitative\", \"bin\": {\"step\": 10}, \"field\": \"total\", \"title\": \"Agencies\"}, {\"type\": \"quantitative\", \"aggregate\": \"count\", \"title\": \"Functions\"}], \"x\": {\"type\": \"quantitative\", \"bin\": {\"step\": 10}, \"field\": \"total\", \"title\": \"Number of associated agencies\"}, \"y\": {\"type\": \"quantitative\", \"aggregate\": \"count\", \"title\": \"Number of functions\"}}, \"$schema\": \"https://vega.github.io/schema/vega-lite/v2.6.0.json\", \"datasets\": {\"data-a8a4ed3c4868c2634ece2fb1d908a4f8\": [{\"function\": \"community protection\", \"total\": 0}, {\"function\": \"field force (army)\", \"total\": 88}, {\"function\": \"publishing\", \"total\": 0}, {\"function\": \"preservation services\", \"total\": 0}, {\"function\": \"deportation\", \"total\": 24}, {\"function\": \"foreign policy\", \"total\": 34}, {\"function\": \"marine and rural support\", \"total\": 0}, {\"function\": \"associations and corporate law\", \"total\": 0}, {\"function\": \"arts promotion\", \"total\": 0}, {\"function\": \"protective services\", \"total\": 25}, {\"function\": \"census collection\", \"total\": 0}, {\"function\": \"rail harmonisation standards\", \"total\": 0}, {\"function\": \"rural community development\", \"total\": 0}, {\"function\": \"internal security\", \"total\": 42}, {\"function\": \"surveillance\", \"total\": 0}, {\"function\": \"commonwealth state relations\", \"total\": 77}, {\"function\": \"driving licenses administration\", \"total\": 0}, {\"function\": \"security and intelligence\", \"total\": 11}, {\"function\": \"viticulture\", \"total\": 12}, {\"function\": \"aged persons services\", \"total\": 0}, {\"function\": \"peacekeeping forces\", \"total\": 0}, {\"function\": \"television broadcasting\", \"total\": 3}, {\"function\": \"memorials\", \"total\": 3}, {\"function\": \"travel authorisation\", \"total\": 0}, {\"function\": \"marine and rural regulation\", \"total\": 0}, {\"function\": \"conservation programs\", \"total\": 0}, {\"function\": \"migrant services\", \"total\": 17}, {\"function\": \"media ownership regulation\", \"total\": 0}, {\"function\": \"immigration\", \"total\": 0}, {\"function\": \"patent registration\", \"total\": 0}, {\"function\": \"community policing\", \"total\": 0}, {\"function\": \"litigation processes\", \"total\": 0}, {\"function\": \"recordkeeping standards\", \"total\": 0}, {\"function\": \"trade\", \"total\": 109}, {\"function\": \"legal\", \"total\": 3}, {\"function\": \"botany\", \"total\": 0}, {\"function\": \"army commands\", \"total\": 286}, {\"function\": \"industrial relations\", \"total\": 123}, {\"function\": \"copyright\", \"total\": 33}, {\"function\": \"air force commands\", \"total\": 77}, {\"function\": \"community services\", \"total\": 175}, {\"function\": \"information security\", \"total\": 0}, {\"function\": \"port regulation\", \"total\": 38}, {\"function\": \"rationing and price control\", \"total\": 24}, {\"function\": \"privacy guideline monitoring\", \"total\": 0}, {\"function\": \"market regulation\", \"total\": 13}, {\"function\": \"customs regulations\", \"total\": 0}, {\"function\": \"repatriation\", \"total\": 116}, {\"function\": \"pensions and benefits\", \"total\": 147}, {\"function\": \"energy\", \"total\": 119}, {\"function\": \"extraditions\", \"total\": 0}, {\"function\": \"urban or regional development\", \"total\": 2}, {\"function\": \"parliamentary legislation\", \"total\": 0}, {\"function\": \"parliamentary chamber administration\", \"total\": 5}, {\"function\": \"export regulation\", \"total\": 0}, {\"function\": \"internees\", \"total\": 21}, {\"function\": \"maintenance\", \"total\": 0}, {\"function\": \"airport services\", \"total\": 77}, {\"function\": \"electoral boundary assessment\", \"total\": 0}, {\"function\": \"international security liaison\", \"total\": 0}, {\"function\": \"commissions of inquiry\", \"total\": 0}, {\"function\": \"literature funding\", \"total\": 10}, {\"function\": \"diplomatic missions\", \"total\": 0}, {\"function\": \"citizenship\", \"total\": 73}, {\"function\": \"agricultural sciences\", \"total\": 0}, {\"function\": \"repatriation hospitals\", \"total\": 12}, {\"function\": \"supreme law\", \"total\": 0}, {\"function\": \"customs\", \"total\": 183}, {\"function\": \"space science\", \"total\": 41}, {\"function\": \"cultural festivals\", \"total\": 0}, {\"function\": \"interpreter services\", \"total\": 0}, {\"function\": \"seismography\", \"total\": 0}, {\"function\": \"government media\", \"total\": 83}, {\"function\": \"electronic commerce\", \"total\": 0}, {\"function\": \"fisheries regulation\", \"total\": 34}, {\"function\": \"land valuation\", \"total\": 0}, {\"function\": \"courts martial\", \"total\": 0}, {\"function\": \"detention programs\", \"total\": 0}, {\"function\": \"parliamentary committees\", \"total\": 21}, {\"function\": \"equipment licensing\", \"total\": 0}, {\"function\": \"overseas aid programs\", \"total\": 24}, {\"function\": \"election campaigning\", \"total\": 0}, {\"function\": \"intelligence liaison\", \"total\": 0}, {\"function\": \"radio broadcasting\", \"total\": 4}, {\"function\": \"removals\", \"total\": 0}, {\"function\": \"australian capital territory\", \"total\": 0}, {\"function\": \"education and training\", \"total\": 0}, {\"function\": \"australian defence forces (adf)\", \"total\": 0}, {\"function\": \"veterans' affairs\", \"total\": 20}, {\"function\": \"cultural gifts programs\", \"total\": 0}, {\"function\": \"revenue raising\", \"total\": 0}, {\"function\": \"medical research\", \"total\": 13}, {\"function\": \"consular services\", \"total\": 0}, {\"function\": \"indigenous enterprises\", \"total\": 28}, {\"function\": \"disability services\", \"total\": 8}, {\"function\": \"legal services\", \"total\": 0}, {\"function\": \"physical sciences\", \"total\": 0}, {\"function\": \"records of the government\", \"total\": 3}, {\"function\": \"house of representatives committees\", \"total\": 7}, {\"function\": \"investigation\", \"total\": 63}, {\"function\": \"community support\", \"total\": 0}, {\"function\": \"sport\", \"total\": 25}, {\"function\": \"employment services\", \"total\": 0}, {\"function\": \"legal aid services\", \"total\": 0}, {\"function\": \"flight regulation\", \"total\": 0}, {\"function\": \"broadcasting\", \"total\": 168}, {\"function\": \"military operations\", \"total\": 0}, {\"function\": \"ordnance\", \"total\": 0}, {\"function\": \"carrier licensing\", \"total\": 0}, {\"function\": \"rehabilitation\", \"total\": 102}, {\"function\": \"copyright regulation\", \"total\": 0}, {\"function\": \"pathology\", \"total\": 0}, {\"function\": \"training (army)\", \"total\": 74}, {\"function\": \"prosecution services\", \"total\": 0}, {\"function\": \"supreme court law\", \"total\": 21}, {\"function\": \"expositions\", \"total\": 5}, {\"function\": \"munitions\", \"total\": 0}, {\"function\": \"international affairs\", \"total\": 0}, {\"function\": \"mediation programs\", \"total\": 0}, {\"function\": \"declaration of interests\", \"total\": 0}, {\"function\": \"public borrowing\", \"total\": 32}, {\"function\": \"marine life protection programs\", \"total\": 0}, {\"function\": \"secondary industries\", \"total\": 173}, {\"function\": \"health\", \"total\": 159}, {\"function\": \"urban development\", \"total\": 0}, {\"function\": \"health services\", \"total\": 107}, {\"function\": \"trade union training\", \"total\": 0}, {\"function\": \"courier services\", \"total\": 0}, {\"function\": \"criminal law\", \"total\": 0}, {\"function\": \"public service\", \"total\": 93}, {\"function\": \"earth sciences\", \"total\": 16}, {\"function\": \"mineral exploration\", \"total\": 0}, {\"function\": \"statistics\", \"total\": 2}, {\"function\": \"financial matters\", \"total\": 36}, {\"function\": \"zoology\", \"total\": 0}, {\"function\": \"environment\", \"total\": 52}, {\"function\": \"migration\", \"total\": 198}, {\"function\": \"mining\", \"total\": 74}, {\"function\": \"publishing and printing\", \"total\": 26}, {\"function\": \"water conservation plans\", \"total\": 0}, {\"function\": \"defence intelligence\", \"total\": 34}, {\"function\": \"grants administration\", \"total\": 14}, {\"function\": \"logistics\", \"total\": 0}, {\"function\": \"rail transport\", \"total\": 90}, {\"function\": \"surveillance, electronic\", \"total\": 0}, {\"function\": \"committees of inquiry\", \"total\": 119}, {\"function\": \"child welfare\", \"total\": 14}, {\"function\": \"road transport\", \"total\": 11}, {\"function\": \"preschool education\", \"total\": 6}, {\"function\": \"defence forces\", \"total\": 82}, {\"function\": \"hospitals and clinics\", \"total\": 36}, {\"function\": \"strategic policy\", \"total\": 0}, {\"function\": \"quarantine\", \"total\": 65}, {\"function\": \"tourism\", \"total\": 34}, {\"function\": \"public utilities\", \"total\": 24}, {\"function\": \"security\", \"total\": 0}, {\"function\": \"inspection services\", \"total\": 9}, {\"function\": \"navy\", \"total\": 2}, {\"function\": \"vehicle standards\", \"total\": 0}, {\"function\": \"patents and trademarks\", \"total\": 59}, {\"function\": \"migrant settlements programs\", \"total\": 0}, {\"function\": \"arts funding\", \"total\": 0}, {\"function\": \"ethical compliance\", \"total\": 0}, {\"function\": \"air transport safety\", \"total\": 0}, {\"function\": \"air force\", \"total\": 21}, {\"function\": \"freight movement regulation\", \"total\": 0}, {\"function\": \"cabinet\", \"total\": 10}, {\"function\": \"army\", \"total\": 6}, {\"function\": \"built environment\", \"total\": 0}, {\"function\": \"civic infrastructure\", \"total\": 0}, {\"function\": \"maritime services\", \"total\": 0}, {\"function\": \"telecommunications\", \"total\": 112}, {\"function\": \"refugees\", \"total\": 25}, {\"function\": \"standard setting\", \"total\": 13}, {\"function\": \"insurance\", \"total\": 42}, {\"function\": \"storage\", \"total\": 0}, {\"function\": \"waste disposal\", \"total\": 0}, {\"function\": \"meteorology\", \"total\": 57}, {\"function\": \"territory administration\", \"total\": 151}, {\"function\": \"intelligence\", \"total\": 0}, {\"function\": \"occupational health and safety\", \"total\": 33}, {\"function\": \"transport\", \"total\": 91}, {\"function\": \"atmospheric sciences\", \"total\": 0}, {\"function\": \"carriage service providers\", \"total\": 0}, {\"function\": \"horticulture\", \"total\": 39}, {\"function\": \"royal commissions\", \"total\": 116}, {\"function\": \"indigenous land rights\", \"total\": 39}, {\"function\": \"airports\", \"total\": 57}, {\"function\": \"corporate affairs\", \"total\": 59}, {\"function\": \"national referral laboratory services\", \"total\": 0}, {\"function\": \"call centre administration\", \"total\": 0}, {\"function\": \"bounties\", \"total\": 9}, {\"function\": \"trademark registration\", \"total\": 0}, {\"function\": \"counterfeiting\", \"total\": 0}, {\"function\": \"electronic postal services\", \"total\": 0}, {\"function\": \"international liaison\", \"total\": 0}, {\"function\": \"radio communication\", \"total\": 0}, {\"function\": \"sea safety\", \"total\": 4}, {\"function\": \"settlement negotiations\", \"total\": 0}, {\"function\": \"leasing\", \"total\": 0}, {\"function\": \"mineral resources\", \"total\": 0}, {\"function\": \"intelligence support\", \"total\": 0}, {\"function\": \"survey and mapping\", \"total\": 76}, {\"function\": \"prisoners of war\", \"total\": 9}, {\"function\": \"tourism industry development\", \"total\": 0}, {\"function\": \"administrative law\", \"total\": 169}, {\"function\": \"marketing\", \"total\": 10}, {\"function\": \"tariff regulation\", \"total\": 5}, {\"function\": \"development assistance programs\", \"total\": 0}, {\"function\": \"information management standards\", \"total\": 0}, {\"function\": \"law enforcement\", \"total\": 3}, {\"function\": \"collection access\", \"total\": 0}, {\"function\": \"rescue coordination\", \"total\": 0}, {\"function\": \"natural disasters\", \"total\": 7}, {\"function\": \"international treaty participation\", \"total\": 0}, {\"function\": \"artifact export regulation\", \"total\": 0}, {\"function\": \"recreation\", \"total\": 12}, {\"function\": \"collection storage\", \"total\": 0}, {\"function\": \"land use planning\", \"total\": 0}, {\"function\": \"housing\", \"total\": 220}, {\"function\": \"parks\", \"total\": 5}, {\"function\": \"seat of government\", \"total\": 0}, {\"function\": \"historic relic protection\", \"total\": 0}, {\"function\": \"fiscal policy\", \"total\": 0}, {\"function\": \"human rights\", \"total\": 26}, {\"function\": \"primary education\", \"total\": 6}, {\"function\": \"primary industries\", \"total\": 99}, {\"function\": \"navy commands\", \"total\": 34}, {\"function\": \"logistics (army)\", \"total\": 166}, {\"function\": \"administrative decision review\", \"total\": 0}, {\"function\": \"navy administration\", \"total\": 28}, {\"function\": \"financial assistance\", \"total\": 0}, {\"function\": \"tariffs\", \"total\": 0}, {\"function\": \"administrative decision appeal\", \"total\": 0}, {\"function\": \"national parks\", \"total\": 18}, {\"function\": \"superannuation\", \"total\": 44}, {\"function\": \"air transport\", \"total\": 154}, {\"function\": \"conservation\", \"total\": 18}, {\"function\": \"human rights obligations\", \"total\": 0}, {\"function\": \"compensation schemes\", \"total\": 46}, {\"function\": \"cultural awards and scholarships\", \"total\": 0}, {\"function\": \"civil law\", \"total\": 0}, {\"function\": \"indigenous heritage conservation\", \"total\": 0}, {\"function\": \"police station\", \"total\": 0}, {\"function\": \"training\", \"total\": 230}, {\"function\": \"cultural affairs\", \"total\": 46}, {\"function\": \"rural partnership programs\", \"total\": 0}, {\"function\": \"aircraft standards\", \"total\": 0}, {\"function\": \"personnel\", \"total\": 0}, {\"function\": \"national events\", \"total\": 26}, {\"function\": \"foreign investment control\", \"total\": 0}, {\"function\": \"defence coordination\", \"total\": 2}, {\"function\": \"hearing services\", \"total\": 0}, {\"function\": \"road transport safety\", \"total\": 0}, {\"function\": \"health care\", \"total\": 0}, {\"function\": \"historic memorials\", \"total\": 9}, {\"function\": \"government representation overseas\", \"total\": 176}, {\"function\": \"multicultural heritage promotion\", \"total\": 0}, {\"function\": \"mobile telephone services\", \"total\": 0}, {\"function\": \"government accommodation and catering\", \"total\": 53}, {\"function\": \"valuation\", \"total\": 0}, {\"function\": \"energy resources\", \"total\": 0}, {\"function\": \"collection management\", \"total\": 26}, {\"function\": \"taxation\", \"total\": 66}, {\"function\": \"research and development\", \"total\": 15}, {\"function\": \"applications for native title\", \"total\": 0}, {\"function\": \"corrective services\", \"total\": 0}, {\"function\": \"road safety\", \"total\": 6}, {\"function\": \"world heritage listings\", \"total\": 0}, {\"function\": \"arts incentive schemes\", \"total\": 0}, {\"function\": \"federal law\", \"total\": 23}, {\"function\": \"civil engineering\", \"total\": 37}, {\"function\": \"arbitration\", \"total\": 45}, {\"function\": \"counselling services\", \"total\": 0}, {\"function\": \"tourist event promotion\", \"total\": 0}, {\"function\": \"pollution emission control\", \"total\": 0}, {\"function\": \"curriculum development\", \"total\": 18}, {\"function\": \"education\", \"total\": 292}, {\"function\": \"international trade agreements\", \"total\": 0}, {\"function\": \"national land use\", \"total\": 4}, {\"function\": \"coronial law\", \"total\": 0}, {\"function\": \"passenger entry control\", \"total\": 62}, {\"function\": \"passport services\", \"total\": 0}, {\"function\": \"disaster relief\", \"total\": 0}, {\"function\": \"interstate trade agreements\", \"total\": 0}, {\"function\": \"indigenous cultural heritage\", \"total\": 0}, {\"function\": \"bankruptcy\", \"total\": 28}, {\"function\": \"science\", \"total\": 56}, {\"function\": \"crown land administration\", \"total\": 0}, {\"function\": \"travel missions\", \"total\": 0}, {\"function\": \"goods and services\", \"total\": 195}, {\"function\": \"overseas student scholarship programs\", \"total\": 0}, {\"function\": \"language services\", \"total\": 0}, {\"function\": \"agriculture\", \"total\": 118}, {\"function\": \"civic management\", \"total\": 0}, {\"function\": \"air operations\", \"total\": 120}, {\"function\": \"student assistance\", \"total\": 26}, {\"function\": \"water resources\", \"total\": 13}, {\"function\": \"electoral matters\", \"total\": 114}, {\"function\": \"broadcasting standards\", \"total\": 0}, {\"function\": \"oceanography\", \"total\": 0}, {\"function\": \"environmental impact assessment\", \"total\": 0}, {\"function\": \"defence\", \"total\": 14}, {\"function\": \"construction\", \"total\": 150}, {\"function\": \"justice administration\", \"total\": 2}, {\"function\": \"applied sciences\", \"total\": 0}, {\"function\": \"shipbuilding\", \"total\": 0}, {\"function\": \"rail land acquisition regulation\", \"total\": 0}, {\"function\": \"emergency management\", \"total\": 0}, {\"function\": \"legal aid\", \"total\": 55}, {\"function\": \"fleet\", \"total\": 0}, {\"function\": \"excise\", \"total\": 0}, {\"function\": \"archives administration\", \"total\": 67}, {\"function\": \"trade skills assessment\", \"total\": 8}, {\"function\": \"ceremonial functions\", \"total\": 19}, {\"function\": \"accommodation services\", \"total\": 0}, {\"function\": \"coastal surveillance\", \"total\": 52}, {\"function\": \"legislation\", \"total\": 5}, {\"function\": \"secondary education\", \"total\": 0}, {\"function\": \"mathematical sciences\", \"total\": 0}, {\"function\": \"advertising standards\", \"total\": 0}, {\"function\": \"presentation arrangements\", \"total\": 0}, {\"function\": \"air safety\", \"total\": 6}, {\"function\": \"regional development\", \"total\": 106}, {\"function\": \"satellite communication\", \"total\": 0}, {\"function\": \"land transport\", \"total\": 29}, {\"function\": \"external security\", \"total\": 27}, {\"function\": \"ambulance services\", \"total\": 0}, {\"function\": \"passenger services\", \"total\": 0}, {\"function\": \"multiculturalism\", \"total\": 93}, {\"function\": \"social and economic research\", \"total\": 34}, {\"function\": \"transport infrastructure development\", \"total\": 0}, {\"function\": \"sea transport\", \"total\": 160}, {\"function\": \"taxation compliance\", \"total\": 0}, {\"function\": \"forensic analysis\", \"total\": 0}, {\"function\": \"film production\", \"total\": 12}, {\"function\": \"vocational training schemes\", \"total\": 18}, {\"function\": \"war memorials\", \"total\": 11}, {\"function\": \"weights and measures\", \"total\": 16}, {\"function\": \"national service\", \"total\": 8}, {\"function\": \"hydrology\", \"total\": 0}, {\"function\": \"army administration\", \"total\": 17}, {\"function\": \"exchange rates\", \"total\": 0}, {\"function\": \"marine science\", \"total\": 16}, {\"function\": \"naturalisation assessment\", \"total\": 0}, {\"function\": \"migrant accommodation services\", \"total\": 0}, {\"function\": \"land use\", \"total\": 5}, {\"function\": \"health insurance\", \"total\": 72}, {\"function\": \"port authorities\", \"total\": 0}, {\"function\": \"property management\", \"total\": 9}, {\"function\": \"rural field day promotion\", \"total\": 0}, {\"function\": \"waterway management\", \"total\": 0}, {\"function\": \"court reporting\", \"total\": 17}, {\"function\": \"native title claims\", \"total\": 0}, {\"function\": \"acquisition\", \"total\": 0}, {\"function\": \"pharmaceuticals and medical aids\", \"total\": 7}, {\"function\": \"national fitness\", \"total\": 3}, {\"function\": \"forestry regulation\", \"total\": 50}, {\"function\": \"parliamentary matters\", \"total\": 45}, {\"function\": \"training (air force)\", \"total\": 65}, {\"function\": \"police administration\", \"total\": 147}, {\"function\": \"chemical and pesticide regulation\", \"total\": 0}, {\"function\": \"refugee services\", \"total\": 0}, {\"function\": \"employment\", \"total\": 417}, {\"function\": \"dental services\", \"total\": 0}, {\"function\": \"collection accessioning\", \"total\": 0}, {\"function\": \"strategic development\", \"total\": 0}, {\"function\": \"resources\", \"total\": 73}, {\"function\": \"collection promotion\", \"total\": 0}, {\"function\": \"lighthouses\", \"total\": 80}, {\"function\": \"defence industries\", \"total\": 152}, {\"function\": \"audit\", \"total\": 20}, {\"function\": \"defence force careers\", \"total\": 0}, {\"function\": \"logistics (air force)\", \"total\": 111}, {\"function\": \"ombudsman\", \"total\": 9}, {\"function\": \"postal services\", \"total\": 114}, {\"function\": \"indigenous affairs\", \"total\": 267}, {\"function\": \"community transport\", \"total\": 0}, {\"function\": \"logistics (defence)\", \"total\": 56}, {\"function\": \"overseas promotion\", \"total\": 0}, {\"function\": \"criminology\", \"total\": 2}, {\"function\": \"emergency funding\", \"total\": 0}, {\"function\": \"national heritage\", \"total\": 12}, {\"function\": \"analytical services\", \"total\": 114}, {\"function\": \"navigation\", \"total\": 0}, {\"function\": \"exports and imports\", \"total\": 130}, {\"function\": \"consumer affairs\", \"total\": 40}, {\"function\": \"censorship\", \"total\": 19}, {\"function\": \"trade practices\", \"total\": 44}, {\"function\": \"community health services\", \"total\": 0}, {\"function\": \"early childhood education\", \"total\": 0}, {\"function\": \"water usage management\", \"total\": 0}, {\"function\": \"genetics\", \"total\": 0}, {\"function\": \"population-based research\", \"total\": 0}, {\"function\": \"oceans governance\", \"total\": 0}, {\"function\": \"maritime commands (navy)\", \"total\": 121}, {\"function\": \"pollutant prevention programs\", \"total\": 0}, {\"function\": \"road traffic regulation\", \"total\": 0}, {\"function\": \"finance management\", \"total\": 0}, {\"function\": \"defence service home schemes\", \"total\": 0}, {\"function\": \"visas\", \"total\": 0}, {\"function\": \"rail transport safety\", \"total\": 0}, {\"function\": \"home savings schemes\", \"total\": 0}, {\"function\": \"indigenous settlements\", \"total\": 36}, {\"function\": \"pastoral\", \"total\": 101}, {\"function\": \"research\", \"total\": 36}, {\"function\": \"land use zoning\", \"total\": 0}, {\"function\": \"defence research\", \"total\": 59}, {\"function\": \"metals\", \"total\": 4}, {\"function\": \"firefighting services\", \"total\": 0}, {\"function\": \"telephone services\", \"total\": 0}, {\"function\": \"trade development programs\", \"total\": 0}, {\"function\": \"defence estate management\", \"total\": 0}, {\"function\": \"local laws and ordinances\", \"total\": 0}, {\"function\": \"transport and storage\", \"total\": 3}, {\"function\": \"wartime security\", \"total\": 20}, {\"function\": \"social welfare\", \"total\": 268}, {\"function\": \"road surface maintenance\", \"total\": 0}, {\"function\": \"emergency services\", \"total\": 0}, {\"function\": \"loans\", \"total\": 2}, {\"function\": \"censorship standards\", \"total\": 0}, {\"function\": \"governance\", \"total\": 0}, {\"function\": \"works\", \"total\": 65}, {\"function\": \"social justice and equity\", \"total\": 0}, {\"function\": \"strategic support\", \"total\": 0}, {\"function\": \"retirement income\", \"total\": 0}, {\"function\": \"scientific research\", \"total\": 212}, {\"function\": \"climate information services\", \"total\": 0}, {\"function\": \"collection acquisition\", \"total\": 0}, {\"function\": \"colonial administration\", \"total\": 42}, {\"function\": \"communications\", \"total\": 40}, {\"function\": \"water quality monitoring\", \"total\": 0}, {\"function\": \"vehicle registration\", \"total\": 0}, {\"function\": \"medical aids regulation\", \"total\": 0}, {\"function\": \"medical and health sciences\", \"total\": 0}, {\"function\": \"spatial information research\", \"total\": 0}, {\"function\": \"tertiary education\", \"total\": 51}, {\"function\": \"natural heritage protection\", \"total\": 0}, {\"function\": \"juvenile justice\", \"total\": 0}, {\"function\": \"building\", \"total\": 41}, {\"function\": \"arts development\", \"total\": 21}, {\"function\": \"air force administration\", \"total\": 23}, {\"function\": \"recruitment\", \"total\": 2}, {\"function\": \"environmental monitoring\", \"total\": 9}, {\"function\": \"freight\", \"total\": 0}, {\"function\": \"medical research funding\", \"total\": 0}, {\"function\": \"trade expositions\", \"total\": 0}, {\"function\": \"defence administration\", \"total\": 52}, {\"function\": \"planning\", \"total\": 9}, {\"function\": \"tariff\", \"total\": 5}, {\"function\": \"retail postal services\", \"total\": 0}, {\"function\": \"governor general\", \"total\": 9}, {\"function\": \"currency\", \"total\": 20}, {\"function\": \"navy support\", \"total\": 61}, {\"function\": \"income assessment\", \"total\": 0}, {\"function\": \"courts and tribunals\", \"total\": 5}, {\"function\": \"defence forces assistance\", \"total\": 0}, {\"function\": \"labour market programs\", \"total\": 5}, {\"function\": \"nursing services\", \"total\": 0}, {\"function\": \"passports\", \"total\": 11}, {\"function\": \"international relations\", \"total\": 16}, {\"function\": \"railway maintenance\", \"total\": 0}, {\"function\": \"biological sciences\", \"total\": 0}, {\"function\": \"banking\", \"total\": 70}, {\"function\": \"family law\", \"total\": 17}, {\"function\": \"disaster recovery\", \"total\": 0}, {\"function\": \"industries\", \"total\": 24}, {\"function\": \"import regulation\", \"total\": 0}, {\"function\": \"arts\", \"total\": 30}, {\"function\": \"equity programs\", \"total\": 3}, {\"function\": \"animal and veterinary sciences\", \"total\": 0}, {\"function\": \"administrative services\", \"total\": 3}]}};\n", "var opt = {};\n", "var type = \"vega-lite\";\n", "var id = \"7b680e53-201b-4908-8176-ba0b9bf55a59\";\n", "\n", "var output_area = this;\n", "\n", "require([\"nbextensions/jupyter-vega/index\"], function(vega) {\n", " var target = document.createElement(\"div\");\n", " target.id = id;\n", " target.className = \"vega-embed\";\n", "\n", " var style = document.createElement(\"style\");\n", " style.textContent = [\n", " \".vega-embed .error p {\",\n", " \" color: firebrick;\",\n", " \" font-size: 14px;\",\n", " \"}\",\n", " ].join(\"\\\\n\");\n", "\n", " // element is a jQuery wrapped DOM element inside the output area\n", " // see http://ipython.readthedocs.io/en/stable/api/generated/\\\n", " // IPython.display.html#IPython.display.Javascript.__init__\n", " element[0].appendChild(target);\n", " element[0].appendChild(style);\n", "\n", " vega.render(\"#\" + id, spec, type, opt, output_area);\n", "}, function (err) {\n", " if (err.requireType !== \"scripterror\") {\n", " throw(err);\n", " }\n", "});\n" ], "text/plain": [ "" ] }, "metadata": { "jupyter-vega": "#7b680e53-201b-4908-8176-ba0b9bf55a59" }, "output_type": "display_data" }, { "data": { "text/plain": [] }, "execution_count": 24, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAckAAAFfCAYAAAAlADcvAAAgAElEQVR4nO3dXYwc1Z338e+MZ8b4Db8QMAshCzEsWbOYkGCe8MBiJ5g4fguExAssEMM+SSAGEggQj9llzYsIM1HAMmiDEhGBEmXHthBCEUJopQjFQopkiZW44IKVRnuBtBJXK/lmrx71c/E/9XTNuE/PTHW5p8Z8P9KRe8o1Nf+u6elfn1NVp0CSJEmSJEmSJEmSJEmSJEmSJEnqakmHZQPASIflI+n/JEk6rZ0N/BzYCzwCfDEtvxp4AXgMGAWWAUuB/cCjwEvAxn4XK0lSP30VuDI9vhg4CAwCHwJnpOW3AjcCW4Bdadly4H1guG+VSpI0T64leo5fA1YDr5b+73rgbmAP7UAFOJ7WlSTptLYZeJoYTj0XeLn0f1cB3wXuBzaUlk+QQnJ8fPzA2NhYq9xeeeWV/5mcnGzZbDabzTbH9p99Sb5ZuAw4Mz0+A/iICL73SutsTm0bsCktGwDeocsJPGNjY616S5UkfRpMTk42Jj9uBnYQYbeW6B0OEMcmLwQWA88AlwDriZN4IHqUz3bbsCEpSaqiSSF5DjHMOgG8RgytQgTiu8DbwL1p2RDwRFr3GHBBtw0bkpKkKpoUkoUVnDx0OpyWT7cSWDTTBg1JSVIVTQzJ2hmSkqQqDElJkjI+NSG5c/Rw17Zj30TXk38kSZ8+hqQhKUnKMCQNSUlShiFpSEqSMgxJQ1KSlGFIGpKSpAxD0pCUJGUYkoakJCnDkDQkJUkZhqQhKUnKMCQNSUlShiFpSEqSMgxJQ1KSlGFIGpKSpAxD0pCUJGUYkoakJCnDkDQkJUkZhqQhKUnKMCQNSUlShiFpSEqSMgxJQ1KSlGFIGpKSpAxD0pCUJGUYkoakJCnDkDQkJUkZhqQhKUnKMCQNSUlShiFpSEqSMgxJQ1KSlGFIGpKSpAxD0pCUJGUYkoakJCnDkDQkJUkZhqQhKUnKMCQNSUlShiFpSEqSMgxJQ1KSlGFIGpKSpAxD0pCUJGU0MSSXAAOzXHdkNusakpKkKpoUkquAZ4CHgQeArWn5VuBJYG9q5wJLgf3Ao8BLwMZuGzYkJUlVNCkktwI70uMh4CNgBfB9YC0wWFp3C7ArPV4OvA8M5zZsSEqSqmhSSA6lBnAZ8Ep6fBB4HTgG7E7r7AGuLH3vcWB1bsOGpCSpiiaFJMAiYDvwB2BdWnYb0ZNcATwHbADuT/8WJkghOT4+fmBsbKw1vc0UkocO/6k1OTlps9lsNtuU1q8AnMkQcTzyfiIQIU7KGSqtsxm4A9gGbCqt8w5dTuCxJylJqqJJIXkNEZJlS4gAXE30Mh8CrgDWA6NpnQ1A14AzJCVJVTQpJO8BWsCJUjsLuAF4lThGeRewmOhdPkEMsx4DLui2YUNSklRFk0Kym2EiHKdbSfQwuzIkJUlVLJSQ7IkhKUmqwpA0JCVJGYakISlJyjAkDUlJUoYhaUhKkjIMSUNSkpRhSBqSkqQMQ9KQlCRlGJKGpCQpw5A0JCVJGYakISlJyjAkDUlJUoYhaUhKkjIMSUNSkpRhSBqSkqQMQ9KQlCRlGJKGpCQpw5A0JCVJGYakISlJyjAkDUlJUoYhaUhKkjIMSUNSkpRhSBqSkqQMQ9KQlCRlGJKGpCQpw5A0JCVJGYakISlJyjAkDUlJUoYhaUhKkjIMSUNSkpRhSBqSkqQMQ9KQlCRlGJKGpCQpw5A0JCVJGYakISlJyjAkDUlJUoYhaUhKkjIMSUNSkpRhSBqSkqQMQ9KQlCRlGJKGpCQpo4khuQQYmLZsABjpsO5Ih3VPYkhKkqroNSQXA9uIoNoF3A98ruK2VgHPAA8DDwBb0/KrgReAx4BRYBmwFNgPPAq8BGzstmFDUpJURa8h+TBwArgcaAGTwO8rbmsrsCM9HgI+As4EPgTOSMtvBW4EthChDLAceB8Yzm3YkJQkVdFLSA4CfwauIXqQx4GzibD8TIXtDaUGcBnwCrAaeLW0zvXA3cAe4MrS8uNp3Y4MSUlSFb2E5ADwJjHcegz4MfA3REgur7jNRcB24A/AOuBc4OXS/18FfJcI5Q2l5ROkkBwfHz8wNjbWmt5mCslDh//UmpyctNlsNpttSquYZwDcQoRiC/gC8DYwXnFbQ8Tw7f3AitKy90rrbE5tG7ApLRsA3qHLCTz2JCVJVfQakhA9vnXp8XXEiTVVXEOE5HQHgQuJk4SeAS4B1hMn8UD0KLsGnCEpSaqijpA8jxgGLbdFFbZzD9EjPVFqZxGB+C7RS703rTsEPEEMsx4DLui2YUNSklRFryG5h/Zwa7kt7r20KYZpD8GWrWQWgWxISpKq6CUkB4izSp8ijkdeUmqDtVRXE0NSklRFrz3Jl4iTdxrNkJQkVdFrSD4EfAzsBe4otaFu39RvhqQkqYpeQ/Io/Tkm2RNDUpJURa8hOUicODO9NYohKUmqoteQXAxcS5y8c5CYV/XMGuqqlSEpSaqi15C8iRhefZuY2LwFHMKzWyVJp4FeQnKEuEPHXbSnhNtEBOXZvZdWH0NSklRFLyE5TMyKs7207AoiJM/vsa5aGZKSpCp6HW59irjv42PExOTvAWM11FUrQ1KSVEWvIbkKuBP4I/ABcB9xe6tGMSQlSVXUMcE5xGUfw3Vs6FQwJCVJVVQJyUXAG8D1xGUfb3RoIzXW2DNDUpJURZWQHAQeB75EHId8vENrVK/SkJQkVdHrcOu1TL3cYwmwFTijl43WzZCUJFVRNSTXATcTJ+w8lB7fDPyAuASkUbPuGJKSpCqqhuQNdJ7YvIWXgEiSThNVQ3KIGFJ9AtiQHhetcQxJSVIVdVwCMgh8BVgLrEiPPbtVkrTg1RGSdxLDrJcC56TH/0R7Ptd5Z0hKkqqoIyTfBO4hrp8cpD3J+Vm9brguhqQkqYpeQ3KAmI7ucdo9x21ESJ7XW2n1MSQlSVXU0ZO8hwjF94A/pMdP97rROhmSkqQq6gjJYeBy4HvAAeCrwMpeN1onQ1KSVEVdE5yfB1w1rS2qY8N1MCQlSVXUEZJ76DypwOJeN1wXQ1KSVEUdJ+4cJ26+/AXgklIb7Lm6mhiSkqQq6uhJvgTcUkMtp4whKUmqoo6QfAj4GNgL3FFqQ71uuC6GpCSpijpC8igek5QknYbqmrt1UYfWGIakJKmKOkJyG3FMcnpzuFWStKDVNXerw62SpNNOHSG5FFiW2iriBJ4xvAuIJGmBq2vGnbKriJ7kmro3XJUhKUmqoo6QfBr4dWqvEpeDfEKDbrxsSEqSqqgjJPcDz6f2c+B+4K973WidDElJUhVVQ3IAWA+sIKaja9RdP6YzJCVJVVQNySHiuOOdwBvAt4ErpjXnbpUkLWi9DLf+nM6XfngJiCTptNBLSI4AFxHT0m0D1k1r9iQlSQtaHSfurACGa6ilMDiH7Y0wi+sxDUlJUhWn4jrJqgaAvwBuBXaXlm8FniQmKdgLnEtMYLAfeJS4VdfGbhs2JCVJVTQpJEeIcDzA1JD8PrCWqcO3W4Bd6fFy4H269D4NSUlSFVVDchFxRutaYDvRA6zLdUwNyYPA68CxtHwI2ANcWVrnOLA6t0FDUpJURdWQHCRm1XmGCK99wO3TWtW7gEwPyduIMF4BPAdsICYs2FBaZ4IUkuPj4wfGxsZa09tMIXno8J9ak5OTNpvNZrNNaRWzjDs5NZeAlENygKlhuxm4gzibdlNpnXfocgKPPUlJUhW9hCTEsOsTxDR0Q9NaVeWQXEIE4Or0sx4iJipYD4ymdTYAXQPOkJQkVdFrSEL0GK8FniKOH94InNnD9qYPt95ATJz+CnBX+nlDRDhPEMO9F3TboCEpSaqijpC8iRhefRv4fXp8iHonExim8/DtSqKH2ZUhKUmqoteQHAE+JHp4xTHBTURQnt1bafUxJCVJVfQaksPACeIykMIVREie38uG62RISpKqqGO49SngI+Ax4tKM94CxXjdaJ0NSklRFHSG5irgc5I/AB8B9xNRxjWFISpKqqCMkC4uod6Lz2hiSkqQq6gzJxjIkJUlVGJKGpCQpo9eQHCDOYs1OLt4EhqQkqYo6QvINYvabxjIkJUlV1DHcWkx0voO4RrJodc640xNDUpJURR0h+Sb13gWkdoakJKmKOkLy88AlHZo9SUnSglbXXUDuBF4DtgK7cDIBSdJpoI6Q3EsMr34IfBN4nLiFVS/3lKyVISlJqqLXkBwkwnEb8C0iJC8iQrMxvUlDUpJURR2XgLwP7AFuJ26WfCMRnGf0XF1NDElJUhV1DLd+m5PPbP1erxutkyEpSaqirmnpzieGWn8IbKFhE50bkpKkKuoIyUHiMpBbgO8Af0WDTtoBQ1KSVE0dIbmTk4dbDxDHKxvBkJQkVVHH2a0fEZd8rAFWAt8lgnJNz9XVxJCUJFVRR0/yNaaeqHMF8Ame3SpJWuB6CckdwE3AU0TPcQ8x885bwG9o0HFJQ1KSVEUvIfkBnSc2d4JzSdJpoZeQXAIs7dIaw5CUJFVRxzHJc4G7gQdTeyC1xlwraUhKkqqoIyR/SwyvniBO2Cmaw62SpAWtjrlbjwO30aDrIqczJCVJVdTRk7wZOAhcSsy8UzRvuixJWtDqCMnv49mtkqTTUB3DrR8RPcmrgS+V2qKeq6uJISlJqqKOnuQ/EveRbCxDUpJURR0h+TPizNbfAb8utZFeN1wXQ1KSVEUdIfkI8FyH5nWSkqQFra6bLjeaISlJqqKOkHwceKFDc7hVkrSg1RGSTwAvplbMvvMGDrdKkha4UzHcug04irfKkiQtcHWE5HLgzNRWAruI3uSaXjdcF0NSklRFHSH5JifPtvMHnExAkrTA1RGS24BbUrsZuBZY3etG62RISpKq6CUkLweu6NKqTnA+yMkn/QzQ+WzZEWZx9xFDUpJURS8hOUnnic2rTnA+APwFcCtTp7m7mrik5DFgFFgGLAX2A48CLwEbu23YkJQkVdFLSF4MXFJq24ibLbeIWXjmekxyhAjHA7RDchD4EDgjfX0rcCOwhThBCOLEoffpcsmJISlJqqKOY5JnAvcQ4fgycV/JXlxHOyRXA6+W/u964G5gD3BlaflxuhwHNSQlSVX0EpLDwNeJXty7wN9Szxmt5ZA8lwjewlXAd4H7gQ2l5ROkkBwfHz8wNjbWmt5mCslDh//UmpyctNlsNpttSqsaZsXsOh8TZ7VuntaqBmY5JIeA90r/V2x7G7ApLRsA3qHLCTz2JCVJVfQSknWfuFMohyTEDZ0vTNt7hjj+uZ44iQeiR9k14AxJSVIVvYTk2cA5XdqMl2ZkTA/J9cRw7tvAvWnZEDFn7ARwDLig2wYNSUlSFb2EZD8NAys6LF/JLIZ1DUlJUhULJSR7YkhKkqowJA1JSVKGIWlISpIyDElDUpKUYUgakpKkDEPSkJQkZRiShqQkKcOQNCQlSRmGpCEpScowJA1JSVKGIWlISpIyDElDUpKUYUgakpKkDEPSkJQkZRiShqQkKcOQNCQlSRmGpCEpScowJA1JSVKGIWlISpIyDElDUpKUYUgakpKkDEPSkJQkZRiShqQkKcOQNCQlSRmGpCEpScowJA1JSVKGIWlISpIyDElDUpKUYUgakpKkDEPSkJQkZRiShqQkKcOQNCQlSRmGpCEpScowJA1JSVKGIWlISpIyDElDUpKUYUgakpKkDEPSkJQkZRiShqQkKcOQNCQlSRmGpCEpScpY6CE5AgzMtJIhKUmqYiGE5FbgSWBvaucCS4H9wKPAS8DGbhswJCVJVSyEkPw+sBYYLC3bAuxKj5cD7wPDuQ0YkpKkKhZCSB4EXgeOAbuBIWAPcGVpnePA6twGDElJUhULISRvI3qSK4DngA3A/enfwgQpJMfHxw+MjY21preZQvLQ4T+1JicnbTabzWab0vodenMxQPQcC5uBO4BtwKbSOu/Q5QQee5KSpCqaHpJLiABcDSwCHgKuANYDo2mdDUDXgDMkJUlVND0kAW4AXgVeAe4CFhO9yyeIYdZjwAXdNmBISpKqWAghCXHm6uIOy1cSPcyuDElJUhULJSR7YkhKkqowJA1JSVKGIWlISpIyDElDUpKUYUgakpKkDEPSkJQkZRiShqQkKcOQNCQlSRmGpCEpScowJA1JSVKGIWlISpIyDMlSSO4cPbJ/pvU2P3l0+Xw/H0lSfxiShqQkKcOQNCQlSRmGpCEpScowJA1JSVKGIVkhJHfuO3yi+3oTh+b7OUuSemdIGpKSpAxD0pCUJGUYkoakJCnDkDQkJUkZhqQhKUnKMCQNSUlShiFpSEqSMgxJQ1KSlGFIGpKSpAxD0pCUJGUYkqcoJHfsO/zgTNva/tjRc+d730iS8gxJQ1KSlGFIGpKSpAxD0pCUJGUYkgsgJHf+9PA9M21r6+jRi0/1fpSkTxtDcp5DcsfoxH91rWt04jeGpCTND0PSkJQkZRiShqQkKcOQ/JSF5I7Rw7tnUdcXT/XvZLpd+45eN2Ndo//6jX7XJenTzZA0JA1JScowJE+jkNy5b+I/ZniORwxJSZo9Q9KQNCQlKcOQNCQNSUnKMCQNycohuX30X78x07Z27Tt63Y7RiWMzPMdjTQ3JraNHL56prp0/PXxPv+uS1B8LPSRHgIGZVjIk5x6SO0cn/r3revsOv21ItkNyx+jEb2Z4jv/V79ol9W6hhuRSYD/wKPASsLHbyobk6ROSO/cdfnuGff/vdb7Q6gzJ7Y8dPXfm1+HhB+usX1JvFmpIbgF2pcfLgfeB4dzKhqQh2cmO0cNHuz/Hif9oakhufvLo8hnrGj2yf7b7YiFzsg2dSgs1JPcAV5a+Pg6szq1sSP7/5/ipCMmof6Zgm/hOU0Ny5+jEoRn2/Ym6Q3Lmuur9++jhb//k2ufhOuLZ/H3U+Rx1asTruvvve6GG5P3AhtLXE6SQHB8fPzA2NtYqt+eff/7/Tl9ms9lsNttM7c033/zveUm5Hm0DNqXHA8A7dDmBZ2xsrJGfBKxrbqxrbppaFzS3NuuaG+tqrvXAaHq8AXi228pN3WHWNTfWNTdNrQuaW5t1zY11NdcQ8AQxzHoMuKDbyk3dYdY1N9Y1N02tC5pbm3XNjXU130pg0UwrNXWHWdfcWNfcNLUuaG5t1jU31nWaGB8fPzDfNXRiXXNjXXPT1LqgubVZ19xYlyRJkiRJn3YDxHyv820JcfJRoQl1DTG1psLifheSdNofSzj5Up9+77tOP2uEzvupn/tuaYdlQ3Q+Zj/fdUHnfTbfdQ1kapjVHNE1WdJh2SBwRofl811Xbnk/6yp+3mxeS7m/ByVXAy8AjxGXjyybpzpWAe8Cf9mgum4F/g+wF/i7tOz8VNdDwMH0dT8sAy4B3qK9L1YBzwAPAw8AW9Pyfu67TnUNAT8AfpJq25GW93PfrQN+CdybalhPvKneBjxFXB51O/GmNd91FRYBPyOml6QhdW0kXlvfA35EvPnPaY7oHp0N/Jz4G3wEKO7E81XgX0p1faYhdV0CjBPvGz+eh7oKs3kt5f4eVDIIfEj709itwI3zUMci4oX+PBGSTajrLNqTMSwCPgBWEKHzV2mdy4kXfz9cDuwGJmmH0VbaATQEfAScSX/3Xae6NgJ/P22dAfq77/4JKKZcuwj4FfHa+llpnV8CFzagrsItwE9pv7E1oa6jwNr0eB9x/fWc5oju0VdpT7V5MfEGvwj4mPboxVbizX6+64LYXyvT47OBc/pcV2E2r6Xc34NKVgOvlr6+Hrh7HurYDfw18Uf4lzSnrgPEi+lp4tMiwO9p/xGcR1yT2k/vMbXHVgwFXwa8wvztu3JdO4le7OvAL4AvpOX93HeLaX8q/g5wB/Bl4M7SOj8CrmpAXRC/v28Rb2rFG1sT6tpO9NgeSPUsYY5zRNfkWqIn9LX0dTGcOUyMpnyxAXUNA38GHiRGxf6eCPJ+1zXb11Lu70El5wIvl76+Cvhun2u4nBiagHZINqGuM4lPhbcDdwF/IN5IjhE9SogX+u/6XFc5jCA+VW8n6lvH/O27cl33EIH9GeLN67W0vN/7bjkxn/HzxND0tUSPo3A38KUG1LWGGLobZuob23zXBfAkMUx4EzGk/jm6zBF9Cm0mPqyWe9PnET24HxAfFue7rjVAC7ghPd5PvL76WddcXku5vweVDBFvboXNqfXTs8CviW7/e0SX/3MNqGsjEdqFJ4lPaP9M+9jQ+cTxm36a3pN8mPgjXFFaNh/7rlzXd4g31cIRYvi6n/tuFRHU22n3tj9PHJMpPJzqmO+6dgFvEH8DR4gPZ19pQF1riJ5R8fV2YtRnTnNE9+gy4gMrxCGE4pDCxcRIxRWldee7rrVESBYnx1wF/EOf65rLayn396BpDhLj0IuJYYtL+vzzVxJvoGcRw5tXEp+C5ruuC4AXiTeIQSLI1wLfJo7xDRBvGLtyGzhFymF0DZ3fOOdj35Xruor4XS4iPrUeIfZXP/fdvcRxo7KlxBvUEiIA3iXe4JpQV/E38C3iQ8bSBtQ1TOyvold5F9H7mNMc0T26mTjuPkD8/U2kx28Bn522bhPq+h1waVrnLuB/9bmuubyWcn8PmmY9sXPeJv5Q5tMjtM9ubUJd9wJvEi/8Yux+DfHp7AgxrJk7BfxUmT6s2QJOlNpZzM++m97DvZM4DvIy7TP/+rnvjjJ137yelt9MDE3/GfjbBtVV+CrtIbIm1LWJCKRXgMeJ3/Gc5oju0TnEcOYEMWx/Fe1hzfLr/h8aUBdED/dF4LfAD2lf1tavuspm81rq9PegDoZpD9c1SRPqOoOTry0apP3puqmasO86Xb/ZhH23lIXzO21CXYuI45XTzWqO6JqsYPZDlE2oq9MHmn7W1UnutdTp70GSJEmSJEmSJEmSJEmSJEmSpB407TT1YT5dtxjK3TZOkhacFnFnjrPS1yvSsrpmbfkdMadnP5xPXITdIq71aoIlRD1/N8N61zH3+TBvAj6h87WJ8+l5YrJzSVrwWqk9mL6uOySPELfi6YdtRO1NmhFkiAiz9TOs9xrtKclm62bi+TYtJK+n/3MoS9Ip0Sq1dUwNyRXAGDEPJ8Qb/RhxV4UtxNySNxNv8HuJaeUOETeMvTB9z5G07EfE9HN30x4OvQi4j5ja7Ie073Z/PzFd3feYevcBiNDZTUzO/Mf0c5cTE0m/nmr/Z06+D9+1qa4Jpk70/sW0/huplpmWryQmez6WnttNtIdSLyLmwD0CfJ+Ykmxx2mfFrZs61bGNuLfnH2nP8/llYrL819LPKHrGX0/Lxojp3zqF5CriRr6vExNYX5OWD6SfVXz/7vTvCNHj/Rpxf8gXaPdqNwHPEa+HV4k5gM8u/ZwH0895jPYHge8Rv0+IEYrvEFOdHSBeO6Sab0/f+xwxubYkNU6LeEN7mXhzXEk7JFcztVe5MX19EXEfwRbwEyJMWsQcsLcTw7dj6XuOpP97mhiCaxFBMULcVPYp4ma4H9C+m8qv0nrvcnKv8Cvp/35AvMl/nH7m2bRD438zdbi1eE4/JYY1PybCd2WqdW96bu+l55VbDhF+HxAfDn6ctlvcYeL36TntJgLvUaYOt+bquJiYQPrl9Pjzab17iHsNtogPJeelxy+m51x8uJkekncQobuZmOf4o/SzL0jrHyU+rHySvj4D+EaqZztx66YWMT/yt9Pjl1KtJ2jPT3x3+r+7id/tO8Tv9Re0h1uLuUi3AL8hPlyMEJNqf0J8GNmb9vepvl2VJM1Zi7hP5yXp8XbmFpJLiLssFPfHAxinfePfI0T4DhC9wHeJN+EN6XvuI26+/Dvatw/6FfGG2+kEnCeIibSLeTD3A/9G9OZ2p22MTPueIaKnuYMI1xbRS1tBvFEfJ3q61xKBkVteBPt9pe1+kNY5P2336vR/56efuZR2SObqgKnDrbel/7uZ2PcniN7WN9LyNWm9p+kckmuI38W3iGAqRgl2pMdFGD1COyRfJnp1O4nXQwv4Ju2QLObyfI34fS4ifpfFPV5Xp+e2nHZInplqfzZtt/gwdWnaH0X43kq8hk7VbaEkqbIiJCGG/4rexS7ijbF4s4bo/UwPyRHiBs7lY4E/I3pVECE5nh4X98h7grgdT9Ej3FVqI0RIPpep9wXizgmFB4mgGiEfkp8leirjxPDhu7TD6fPp+b+RvvfRLsuXpf1T3Jx6MG3rCSIgWrRvmrsy7ZdyT7JbHa/RDsmiJ1eE5K60/p1peXEXlbvpHJI/InqFu2nfAWZdaf8U3/9A+nppWv8IU38X62mHZPGBpRhxWEYEYDEcviQ938W0Q/LC9L1PTdvuWiKYtxBBX7zm+nXXC0matXJIriYCpwjJRcSb+r8Q97sreiVzDckTxO14ip7MZto91x+k7T1M++ShX5G/l97X0vfdSPTajtO+zVcuJIsh2i/T7sE+RQThn4njdGcTt3l6q8tyiLB8hzhm9820rWuIcPiIuEfn3xCh9yJTQzJXB2n9Q8TvYFf6v68RQfUz4ljkpbSHN68metCdQvItIsjWAP+Y1ikP475I9Ow+pN2TfJb4XV9K/K6eS49zIUmq/d+I2z/9hAjaFbRDcgnR8y4C87b0XFYQHwh+SXxwuD79DI9LSmqcckhCe0ivGGL9FhFyHxMnXhQhWRwr6xSSzxLDp9C+j95baZ2DtN/Ut6T/L45nrkvLu4XkMuLNuTge9xrRM4F8SC4jep+ttO3fEPf/HCaGTj8pbas4vphbfj7teyq2iF5fcQPar5eWv0MEQxGSu2eo4xYiZB8gAukuIqhbRCitIj607EvLPiJOEuoUkjcQgfcxEUbF72aQ6JH+lhjmPEg7AM8hgq54zvelnzc9JH9JOyQvJY7XttL3Fb//X6TtQ4T8z9M6H9O+YfM64oNU8Vwe4eSTrSRpQRjh5OCZqwE6X6owQPSe5npd44r0fXM5jrUys3wp+fvndVpe1Nzp+ZxBnNHZ7fnk6hhialAMZ9ZdycyBsoSTj+l+luidrikR1c0AAABOSURBVKV97PC309ZZxtxu2jxEPN+Z6lnVYZ0B4DOz+F5Jkk655cRx0BbR02zR7tlJkvSpN0wMA19Ge5YlSZIkSZIkSZIkSZIkSdLp7v8BuL+PoqEcPFUAAAAASUVORK5CYII=" }, "metadata": { "jupyter-vega": "#7b680e53-201b-4908-8176-ba0b9bf55a59" }, "output_type": "display_data" } ], "source": [ "# Bin the agencies to make it wasier to read\n", "alt.Chart(df).mark_bar().encode(\n", " x=alt.X('total:Q', bin=alt.Bin(step=10), title='Number of associated agencies'),\n", " y=alt.Y('count()', title='Number of functions'),\n", " tooltip=[alt.Tooltip('total:Q', bin=alt.Bin(step=10), title='Agencies'), alt.Tooltip('count()', title='Functions')]\n", ")" ] }, { "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.6.5" } }, "nbformat": 4, "nbformat_minor": 2 }