Simon Willison’s Weblog

Subscribe

Entries in Apr, 2018

Filters: Type: entry × Year: 2018 × Month: Apr × Sorted by date


Exploring the UK Register of Members Interests with SQL and Datasette

Ever wondered which UK Members of Parliament get gifted the most helicopter rides? How about which MPs have been given Christmas hampers by the Sultan of Brunei? (David Cameron, William Hague and Michael Howard apparently). Here’s how to dig through the Register of Members Interests using SQL and Datasette.

[... 1167 words]

3:49 pm / 25th April 2018 / mysociety, politicalhacking, politics, projects, sqlite, xml, datasette

Datasette plugins, and building a clustered map visualization

Datasette now supports plugins!

[... 751 words]

3:41 pm / 20th April 2018 / maps, plugins, projects, visualization, datasette, pytest

Types

Years

Months

Tags