home / musiccaps

musiccaps

1 row where aspect_list contains "instrumental", aspect_list contains "stainless steel instrument" and aspect_list contains "steel pan"

✎ 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
UNJswfXKJ3s This song is an instrumental. The tempo is fast with a lively keyboard harmony and rhythmic steel pan . It is minimal and rhythmic. The harmony is simple , straight and the steel pan adds an interesting layer to it. The music is engaging, interesting, energetic, spirited and melodic. ["instrumental", "fast tempo", "pleasant sounds", "simple harmony", "energetic", "spirited", "vibrant", "engaging", "steel drums", "steel pan", "rhythmic", "resounding melody", "african percussion", "pannist", "lively keyboard accompaniment", "home video", "stainless steel instrument", "recycled instrument", "acoustic steel drum"] ["Music", "Steelpan"] 7 30 40 1 1 ["/m/04rlf", "/m/0l156b"]

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 912.716ms · About: simonw/musiccaps-datasette