home / songs

charts

5 rows where song_id = "1f1ff123a4ae912e94f50f65f32ddd65"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ song_id steps jumps beats type difficulty meter
1f1ff123a4ae912e94f50f65f32ddd65-beginner-2 Soldier Dance 1f1ff123a4ae912e94f50f65f32ddd65 113 13 300 dance-single: beginner 2
1f1ff123a4ae912e94f50f65f32ddd65-challenge-10 Soldier Dance 1f1ff123a4ae912e94f50f65f32ddd65 432 82 300 dance-single: challenge 10
1f1ff123a4ae912e94f50f65f32ddd65-easy-4 Soldier Dance 1f1ff123a4ae912e94f50f65f32ddd65 178 32 300 dance-single: easy 4
1f1ff123a4ae912e94f50f65f32ddd65-hard-8 Soldier Dance 1f1ff123a4ae912e94f50f65f32ddd65 345 45 300 dance-single: hard 8
1f1ff123a4ae912e94f50f65f32ddd65-medium-7 Soldier Dance 1f1ff123a4ae912e94f50f65f32ddd65 262 53 300 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 24.979ms