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

Qwen 3.8 27B is excellent, but it defaults to wildly overthinking things - 16th August 2026
Now we have a timeline of the OpenAI accidental attack against Hugging Face - 7th August 2026
One-shotting a Raccoon Heist game using Claude Fable 5 - 5th August 2026

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

json 150 pandas 16 sqlite 484 datasette 1,535

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