musiccaps

1 row where aspect_list contains "arabic percussions", aspect_list contains "arabic pop hits" and aspect_list contains "groovy music"

✎ 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
qIxpfaeZ-zs A male Arab singer sings this cool melody. The tempo is medium with Arabic percussion instruments and various stringed instruments. The song is passionate and romantic. The song has bad audio quality. ["male singer", "arabic music", "arabic percussions", "medium tempo", "groovy music", "dance song", "belly dancing", "traditional music", "arabic superstar", "movie soundtrack", "bad audio quality", "stringed instruments", "romantic", "passionate", "arabic retro hits", "arabic pop hits", "spirited", "excitement", "love songs"] ["Singing", "Music of Africa", "Music", "Middle Eastern music"] 1 380 390 0 0 ["/m/015lz1", "/m/0164x2", "/m/04rlf", "/m/06j64v"]

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
);