Simon Willison’s Weblog

Subscribe

Saturday, 20th January 2018

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.

# 1:07 am / json, pandas, sqlite, datasette

2018 » January

MTWTFSS
1234567
891011121314
15161718192021
22232425262728
293031