Simon Willison’s Weblog

Subscribe

Entries tagged sqlite, xml

Filters: Type: entry × sqlite × xml × Sorted by date


Building an Evernote to SQLite exporter

I’ve been using Evernote for over a decade, and I’ve long wanted to export my data from it so I can do interesting things with it.

[... 1879 words]

8:12 pm / 16th October 2020 / projects, sqlite, xml, datasette, dogsheep, sqliteutils

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

Types

Years

Tags