CSV is a great format for releasing sets of structured data in response to Freedom of Information requests. Indeed, on WhatDoTheyKnow we’ve seen several thousands of CSVs released.

We’ve recently added the ability to explore CSV files via a Datasette instance. Here’s an example.

Opening the CSV in Datasette makes it easy to explore and analyse it in an interactive website.

If you’re not familiar, Datasette converts the CSV to an sqlite database, which means you can then query the data using SQL.

Alaveteli uses the publicly available lite.datasette.io instance by default, but you can host your own instance and configure it at theme level like we’ve done for WhatDoTheyKnow.

You can see the implementation details at mysociety/alaveteli/#7961.

—

Banner image: Joshua Fuller