musiccaps
2 rows where aspect_list contains "exciting" and aspect_list contains "live in concert"
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 |
---|---|---|---|---|---|---|---|---|---|---|
244y56-vLWE | A male singer sings this exciting Latin dance melody. The tempo is medium fast with a saxophone solo, percussive bass line, guitar accompaniment, latin percussion, steady drumming rhythm, and cymbal crashes. The song is exciting with the crowds going crazy. The audio quality is poor. | ["live audience", "saxophone solo", "bass guitar solo", "arena", "excitement in the air", "latin percussions", "strong drumming rhythm", "guitar accompaniment", "latin pop hits", "retro latin hits", "crowds cheering", "poor audio quality", "live in concert", "exciting", "energetic", "passionate", "adrenaline rush", "medium fast tempo", "male singer"] | ["Jazz", "Music"] | 1 | 30 | 40 | 0 | 0 | ["/m/03_d0", "/m/04rlf"] | |
hzznbzry5R8 | The song is an instrumental. The song is medium tempo, with an acoustic guitar playing blues, strong drumming rhythm, walking bass line and keyboard harmony. The song is exciting and has a dance rhythm. The audio quality is poor. | ["acoustic guitar lead", "country blues music", "poor audio quality", "instrumental music", "blues legends", "blues legends", "live performance", "live audience", "live in concert", "country blues band", "retro blues hits", "bad audio quality", "strong walking bass", "blues guitar", "steady rock drumming", "exciting", "enthusiastic", "retro blues", "country blues hits", "emotional", "enthusiastic", "groovy music", "blues dance music"] | ["Blues", "Guitar", "Music", "Steel guitar, slide guitar"] | 1 | 170 | 180 | 0 | 0 | ["/m/0155w", "/m/0342h", "/m/04rlf", "/m/06w87"] |
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 );