home / songs

charts

5 rows where song_id = "13349d67f10c3619172b2f3ad6eed587"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ song_id steps jumps beats type difficulty meter
13349d67f10c3619172b2f3ad6eed587-beginner-2 Matryoshka 13349d67f10c3619172b2f3ad6eed587 174 4 436 dance-single: beginner 2
13349d67f10c3619172b2f3ad6eed587-challenge-12 Matryoshka 13349d67f10c3619172b2f3ad6eed587 855 56 436 dance-single: challenge 12
13349d67f10c3619172b2f3ad6eed587-easy-4 Matryoshka 13349d67f10c3619172b2f3ad6eed587 328 21 436 dance-single: easy 4
13349d67f10c3619172b2f3ad6eed587-hard-9 Matryoshka 13349d67f10c3619172b2f3ad6eed587 608 86 436 dance-single: hard 9
13349d67f10c3619172b2f3ad6eed587-medium-7 Matryoshka 13349d67f10c3619172b2f3ad6eed587 469 48 436 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 22.084ms