musiccaps

1 row where aspect_list contains "live performance" and audioset_ids = "["/m/015lz1", "/m/04rlf", "/m/06rqw"]"

✎ 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
fp0oCFL6w4o This is a live performance of a rock music piece. There are male vocals singing melodically. The electric guitar is playing the main tune. The bass guitar is playing a simple bass line. In the rhythmic background, there is a simple acoustic drum beat. The atmosphere is cheerful. This piece can be used in the soundtrack of a feelgood TV series during the credits. ["rock music", "live performance", "male vocals", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "cheerful"] ["Singing", "Music", "Ska"] 9 160 170 0 0 ["/m/015lz1", "/m/04rlf", "/m/06rqw"]

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