Simon Willison: TILs on jq

jq Combined release notes from GitHub with jq and paginate-json - 2023-08-12

Matt Holt asked: …

jq Convert git log output to JSON using jq - 2023-03-25

I just spent way too long messing around with ChatGPT (transcript here) trying to figure this out. After much iteration, here's a recipe that works (mostly written by me at this point): …

jq Extracting objects recursively with jq - 2021-07-24

The Algolia-powered Hacker News API returns nested comment threads that look like this: https://hn.algolia.com/api/v1/items/27941108 …

jq Turning an array of arrays into objects with jq - 2021-05-25

Input: …

jq Converting no-decimal-point latitudes and longitudes using jq - 2021-03-11

I had some data with weird co-ordinates in it: …

jq Flattening nested JSON objects with jq - 2021-03-11

I wanted to take a nested set of JSON objects and import them into a SQLite database using sqlite-utils insert - but I wanted to "flatten" some of the nested rows. …

jq Loading radio.garden into SQLite using jq - 2021-02-17

http://radio.garden/ is an amazing website which displays a 3D globe covered in radio stations and lets you listen to any of them. …

jq Converting Airtable JSON for use with sqlite-utils using jq - 2020-08-28

The Airtable API outputs JSON that looks like this: …