home / songs

charts

4 rows where song_id = "1ffe345f553f75788210455b86903b8a"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ song_id steps jumps beats type difficulty meter
1ffe345f553f75788210455b86903b8a-challenge-11 Start On Red 1ffe345f553f75788210455b86903b8a 608 31 288 dance-single: challenge 11
1ffe345f553f75788210455b86903b8a-easy-4 Start On Red 1ffe345f553f75788210455b86903b8a 228 0 288 dance-single: easy 4
1ffe345f553f75788210455b86903b8a-hard-9 Start On Red 1ffe345f553f75788210455b86903b8a 466 38 288 dance-single: hard 9
1ffe345f553f75788210455b86903b8a-medium-7 Start On Red 1ffe345f553f75788210455b86903b8a 353 10 288 dance-single: medium 7

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [charts] (
   [song_id] TEXT REFERENCES [songs]([id]),
   [steps] INTEGER,
   [jumps] INTEGER,
   [beats] INTEGER,
   [type] TEXT,
   [difficulty] TEXT,
   [meter] INTEGER,
   [id] TEXT PRIMARY KEY
);
Powered by Datasette · Queries took 19.918ms