home / musiccaps

musiccaps

1 row where aspect_list contains "guitar strumming", aspect_list contains "slow tempo" and aspect_list contains "steady drumming rhythm"

✎ 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
6jeq5lP5Up0 A male singer sings this poignant melody. The tempo pop is slow with a steady drumming rhythm, cymbal crashes, guitar accompaniment, keyboard organ accompaniment and a strong bass line. The song is a poignant love song. ["male singer", "poignant mood", "slow tempo", "reflecting", "nostalgia", "old memories", "good old times", "vocal echoes", "guitar strumming", "keyboard organ accompaniment", "steady drumming rhythm", "cymbal crashes", "elanchoilic", "emotional", "sentimental", "romantic", "love song", "modern pop song", "strong bass line"] ["Blues", "Music"] 1 30 40 0 0 ["/m/0155w", "/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 786.548ms · About: simonw/musiccaps-datasette