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

Vibe coding SwiftUI apps is a lot of fun - 27th March 2026
Experimenting with Starlette 1.0 with Claude skills - 22nd March 2026
Profiling Hacker News users based on their comments - 21st March 2026

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

json 146 pandas 16 sqlite 453 datasette 1459

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