In recent years the UK government has got into the habit of announcing that it has employed cats. , the and the all have cats whilst the are about to appoint one. An unusual habit for a government but, I suppose, life should be full of strangeness. Downing Street Foreign Office Treasury Cabinet Office One afternoon I was feeling simultaneously bored and whimsical, a risky combination, so I spent 10 minutes building a — a list of these cats — which I published on the web. UK gov cat register the cat register The cat register is . Anyone can use it for any purpose. It is also open for contributions. Anyone can suggest changes and help improve it. done so already. open data Some people have This week I created a . That should have been relatively simple too but it took a little longer. Some of my skills are a bit rusty. dashboard for the cat register the cat dashboard A list of cats that work for the UK government might seem like a silly joke - it was :) - but it also gave me a chance to use, and give feedback on, some new developed by the . tools Open Data Institute (ODI)’s Labs team Here’s what I did. It might help others publish some or build a dashboard. If you read it all you’ll also learn who Schrödinger’s gov cats are… open data How I built cat register I started off by pulling together some of the available data: names; the department the cats worked in; the dates when they started (or ended) their work; and social media accounts. Yes, UK government cats have social media accounts: both and . The data was gathered into and saved as a CSV file. official unofficial a spreadsheet application I will shamefully admit that I did not think too much about the needs of potential users of the data. After all, this was a whimsical experiment which users would be able to help maintain if they wanted to be whimsical too. I also concluded that privacy would not be an issue as animals do not have rights under the . In less whimsical circumstances I would recommend completing before publishing a dataset. General Data Protection Regulation a privacy assessment Octopub screen for adding a dataset I used the ODI Labs’ tool to publish the CSV file. Octopub automatically creates an and uses Github to store and publish the data with all of the functionality that provides. Octopub open data certificate After that step the data was accessible on the web, openly licensed to make it clear that people can use it and was open for collaboration so that people could help improve it. Do , or if you want to. use the cat data read how to submit some extra data raise an issue This bit was easy. A dashboard was a little harder. A minimum viable cat dashboard To help with metrics and dashboards the Labs team have created : it brings you information in the form of a free platform for storing and publishing metrics as JSON or simple visualisations. This capability is built on top of another web tool, , that allows new applications to be quickly deployed to the web. Bothan Heroku Bothan’s name is inspired by about the many spies who died getting the plans for the death star in Return of the Jedi. I suspect the Labs team had many failures when building their tool… a pretty obscure line of dialogue The ODI’s lab teams have also built some which can be copied and configured to present Bothan visualisations as a dashboard using (another free tool). sample code Github Pages Setting up a instance and reconfiguring an existing dashboard was relatively easy but automating the process of getting data, like the total number of cats, from the register into Bothan proved harder. Bothan The team recommended , a web tool designed to help automate workflows. It’s less open than the other tools — I couldn’t easily share my config and the seemed to scale fast — but it looked like it would do the job and help get even more cats on the web. The team have even to make it easy. Unfortunately I had to get to grips with the and my last foray into was a while ago. Luckily there was help and . Zapier pricing plan integrated Bothan with Zapier Python scripting language similar stuff both on the web in the office a bit of Zapier configuration which, to put it another way, says “if there’s a change to cat register, then run an algorithm and store the results in the Bothan metrics platform” After getting the tech working I shared a couple of early drafts on twitter; got some feedback (at which point I learnt that Google had given me the wrong answer for the total number of cats in the UK (if only ) and improved it to a point that I was happy to call it a . searching for data was as easy as searching for documents minimum viable dashboard There is one bit of configuration and code looking for changes to the cat register and calculating new metrics for those values; whilst another bit is looking for changes to some . Everything runs automatically. official UK government data about cats You will find . Feel free to suggest new features. a bit more detail and the code for the dashboard on Github Peta is Schrödinger’s cat Schrödinger’s cats You might have noticed that the dashboard has an entry for “Schrödinger’s cats”. The reason for that is quite simple, just like the cat in Schrödinger’s I could find no data that confirms whether some cats are alive or dead. I could make an educated assumption, after all one cat started duty in 1964…, but I thought it was worth leaving the status unclear. I simply left them marked“Inactive” and imagined the life of a retired UK government cat. famous experiment some cats from the swinging 60’s. Picture courtesy of via National Archives Wikipedia Anyone who uses the data can make their own assumption about those cats whilst leaving it unclear might incentivise someone to help find the missing data and, perhaps, discover that an elderly cat from the swinging 60’s is still patrolling the corridors and of Whitehall. clubs That incentivisation is interesting. A good register should, like any , be providing a foundation on which people can build services and find insights but a good dashboard should be incentivising behaviour in line with a particular goal or strategy. My goal was to get even more cats on the web. The register and dashboard was a way of getting other people to help me. . data infrastructure Submit more cats Publish your own data or build your own dashboard But enough of cats, for now. My whimsy also helped me explore a little bit of data publishing. , , and Python all turned out to be fairly easy to use so, if you fancy giving open data a go, why don’t you publish your own dataset or create your own dashboard? Octopub Bothan Zapier this penguin would probably want its title recorded in a penguin register. standard you tube licence applies to the video. You could start with a whimsical project (penguin register anyone?) or perhaps something more useful like this list of prepared as part of the ’s work for the . data science courses in Europe ODI learning team European Data Science Academy If the documentation for each of those tools doesn’t help you with a problem then there are and, once you’ve learnt the answer, you can always suggest ways to improve the documentation and help the next person. plenty of people around to ask The hardest bit about publishing (cat) data is getting started. Tools like and are there to make it easy. Octopub Bothan — — - Update 21 April: since writing this blogpost I have done . a bit more work on cat data, privacy and complexity
