Simon Willison’s Weblog

20th January 2018 - Link Blog

How to turn a list of JSON objects into a Datasette. ramadis on GitHub cleaned up data on 184,879 crimes reported in Buenos Aires since 2016 and shared them on GitHub as a JSON file. Here are my notes on how to use Pandas to convert JSON into SQLite and publish it using Datasette.

Posted 20th January 2018 at 1:07 am

Recent articles

sqlite-utils 4.0, now with database schema migrations - 7th July 2026
sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25) - 5th July 2026
Have your agent record video demos of its work with shot-scraper video - 30th June 2026

This is a link post by Simon Willison, posted on 20th January 2018.

json 148 pandas 16 sqlite 476 datasette 1,523

Monthly briefing

Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.

Pay me to send you less!

Sponsor & subscribe