Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette

1 row

View and edit SQL

Link rowid ▼ body id consideration
1 { "number": 1, "string": "This is a string" } 1 This is a string

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE generated_columns (
    body TEXT,
    id INT GENERATED ALWAYS AS (json_extract(body, '$.number')) STORED,
    consideration INT GENERATED ALWAYS AS (json_extract(body, '$.string')) STORED
);