Farshid/Ashouri

data-transformation

4 posts tagged “data-transformation”.

  1. 2025

  2. Flattening nested JSON objects with jq

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

    jq json data-transformation cli sqlite-utils
    1 min read
  3. 2023

  4. Extracting objects recursively with jq

    The Algolia-powered Hacker News API returns nested comment threads that look like this: https://hn.algolia.com/api/v1/items/27941108 (For this story: https://news.ycombinator.com/item?id=27941108) I…

    jq json data-transformation cli recursion
    1 min read

  5. Converting Airtable JSON for use with sqlite-utils using jq

    The Airtable API outputs JSON that looks like this: The items in the array each have an , a nested dictionary and a .

    airtable json jq sqlite-utils cli
    1 min read

  6. Converting no-decimal-point latitudes and longitudes using jq

    I had some data with weird co-ordinates in it: Note the and in there. I know that this data refers to somewhere in Houston, and a few people on Twitter pointed out that it's actually really simple…

    jq json data-transformation cli geospatial
    1 min read