Skip to content
corpus.blog
Sign in Claim your blog
Record · simonwillison.net

Joining CSV and JSON data with an in-memory SQLite database

Simon Willison · 8 min read

A post on simonwillison.net is cited by 2 distinct blogs to date (corpus.blog, measured 12 October 2026).

A record is what was published and who pointed at it. The text of the post is not shown here: read it at the source, or at its Wayback capture.

Read at simonwillison.net (opens in a new tab) Wayback capture (opens in a new tab)

2blogs citing

Citing blogs and links by period
Period Blogs Links
All time22
Last 90 days00
Last 30 days00
Last 7 days00
Figures for this page
First cited7 Feb 2020
Latest citation1 Jun 2022
Words blogs link it with2
External links23
Length1,740

Words blogs link it with

The words blogs link this page with, by how many different blogs use them.

  • joining csv and json data with an in-memory sqlite database1 blog
  • tools1 blog

Cited by 2 blogs in 2 posts

One row per blog, the most recently citing first. Each shows the blog's newest citing post; open a row for the others.

Blog
Newest citing post
Date
Home | Shubhro Saha1 post
CSVFiddle for querying CSVs with SQL

linked as “tools”

Read at shubhro.com (opens in a new tab)
1 Jun 2022
sachinsu.github.io1 post
Databases

linked as “Joining CSV and JSON data with an in-memory SQLite database”

Read at sachinsu.github.io (opens in a new tab)
7 Feb 2020

Links from this post

Link
Host
https://sqlite-utils.datasette.io/en/latest/changelog.html Who cites this page
sqlite-utils.datasette.io
https://www.youtube.com/watch?v=OUjd0rkc678 Who cites this page
youtube.com
https://sqlite-utils.datasette.io/en/stable/cli.html Who cites this page
sqlite-utils.datasette.io
https://github.com/dogsheep Who cites this page
github.com
https://github.com/nytimes/covid-19-data/blob/master/us-states.csv Who cites this page
github.com
https://covid.cdc.gov/covid-data-tracker/COVIDData/getAjaxData?id=vaccination_data
covid.cdc.gov
https://github.com/simonw/cdc-vaccination-history Who cites this page
github.com
https://stedolan.github.io/jq/ Who cites this page
stedolan.github.io
http://www.sqlite.org/draft/lang_select.html Who cites this page
sqlite.org
https://datasette.io/ Who cites this page
datasette.io
https://github.com/simonw/sqlite-utils Who cites this page
github.com
https://github.com/simonw/sqlite-utils/releases/tag/3.10 Who cites this page
github.com
https://github.com/simonw/sqlite-utils/releases Who cites this page
github.com
https://github.com/dogsheep/dogsheep-beta Who cites this page
github.com
https://github.com/dogsheep/dogsheep-beta/releases/tag/0.10.2 Who cites this page
github.com
https://github.com/dogsheep/dogsheep-beta/releases Who cites this page
github.com
https://github.com/simonw/yaml-to-sqlite Who cites this page
github.com
https://github.com/simonw/yaml-to-sqlite/releases/tag/1.0 Who cites this page
github.com
https://github.com/simonw/yaml-to-sqlite/releases Who cites this page
github.com
https://github.com/simonw/markdown-to-sqlite Who cites this page
github.com
https://github.com/simonw/markdown-to-sqlite/releases/tag/1.0 Who cites this page
github.com
https://github.com/simonw/markdown-to-sqlite/releases Who cites this page
github.com
https://api.github.com/users/dogsheep/repos Who cites this page
api.github.com
Elsewhere on simonwillison.net (1)

Something wrong here? Report a problem