home / musiccaps

musiccaps

1 row where aspect_list contains "booming kick", aspect_list contains "male voices", aspect_list contains "moderate tempo" and aspect_list contains "synth sounds"

✎ View and edit SQL

This data as json, CSV (advanced)

ytid ▼ url caption aspect_list audioset_names author_id start_s end_s is_balanced_subset is_audioset_eval audioset_ids
4lcZkOMhKv8 This house music clip features a male voice in the beginning followed by a male voice that has been heavily processed. This is accompanied by programmed percussion with a booming kick played on every count. After two bars, the snare is also played with the kick. Staccato synth notes are played on the 'one and' and the third count of each bar. The mood of this song is upbeat. This song can be played in a trance club. ["house music", "male voices", "effects on voices", "synth sounds", "programmed percussion", "booming kick", "moderate tempo", "upbeat music"] ["Sampler", "Electronic music", "House music", "Music"] 0 330 340 0 0 ["/m/01v1d8", "/m/02lkt", "/m/03mb9", "/m/04rlf"]

Advanced export

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

CSV options:

CREATE TABLE [musiccaps] (
   [ytid] TEXT PRIMARY KEY,
   [url] TEXT,
   [caption] TEXT,
   [aspect_list] TEXT,
   [audioset_names] TEXT,
   [author_id] TEXT,
   [start_s] TEXT,
   [end_s] TEXT,
   [is_balanced_subset] INTEGER,
   [is_audioset_eval] INTEGER,
   [audioset_ids] TEXT
);
Powered by Datasette · Queries took 782.529ms · About: simonw/musiccaps-datasette