home / songs

charts

5 rows where song_id = "0cafdd3cad8c576eae90b36e3a1a1ef9"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ song_id steps jumps beats type difficulty meter
0cafdd3cad8c576eae90b36e3a1a1ef9-beginner-1 Isis 0cafdd3cad8c576eae90b36e3a1a1ef9 105 2 284 dance-single: beginner 1
0cafdd3cad8c576eae90b36e3a1a1ef9-challenge-9 Isis 0cafdd3cad8c576eae90b36e3a1a1ef9 547 50 284 dance-single: challenge 9
0cafdd3cad8c576eae90b36e3a1a1ef9-easy-3 Isis 0cafdd3cad8c576eae90b36e3a1a1ef9 179 26 284 dance-single: easy 3
0cafdd3cad8c576eae90b36e3a1a1ef9-hard-8 Isis 0cafdd3cad8c576eae90b36e3a1a1ef9 432 12 284 dance-single: hard 8
0cafdd3cad8c576eae90b36e3a1a1ef9-medium-5 Isis 0cafdd3cad8c576eae90b36e3a1a1ef9 228 25 284 dance-single: medium 5

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 27.929ms