Simon Willison: TILs on jq

Atom feed for jq

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: …