musiccaps
2 rows where aspect_list contains "exciting", aspect_list contains "groovy bass line", aspect_list contains "passionate" and aspect_list contains "youthful"
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"] | |
D2w3qHmJrdU | The song is an instrumental. The song is medium tempo with a guitar playing solo, steady drum rhythm, groovy bass line and steady bass line. The song is funky and groovy in nature. The song is an ad jingle. | ["instrumental music", "cash register click", "passionate", "spirited", "exciting", "medium tempo", "groovy rhythm", "romantic", "energetic", "youthful", "jazz music influences", "dreamy", "enterprising", "guitar solo", "groovy bass line", "steady drumming rhythm", "ad jingle", "soundtrack", "funk jazz music", "shakers percussions", "groovy", "soul music", "medium tempo"] | ["Music", "Camera"] | 1 | 0 | 10 | 1 | 1 | ["/m/04rlf", "/m/0dv5r"] |
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 );