musiccaps
1 row where aspect_list contains "emo", aspect_list contains "heavy metal" and aspect_list contains "live audience"
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 |
---|---|---|---|---|---|---|---|---|---|---|
2ATMQxWVpXk | A male singer screams and laughs loudly. The song is medium tempo with steady rock drumming, groovy bass line and electric guitar rhythm. The song is energetic and haunting. The song is a modern punk rock song. | ["screaming vocals", "rock band", "punk rock", "youthful", "emo teens", "eerie", "live audience", "pulsating rhythm", "rebellious nature", "ambient keyboard tones", "keyboard harmony", "laughing devilishly", "emo", "kiss", "haunting vocals", "heavy metal", "medium tempo", "haunting", "passionate", "exciting", "groovy bass line"] | ["Music", "Angry music"] | 1 | 0 | 10 | 0 | 1 | ["/m/04rlf", "/t/dd00036"] |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );