musiccaps
1 row where aspect_list contains "arena" and aspect_list contains "poor audio quality"
This data as json, CSV (advanced)
aspect_list (array) 19 ✖
- adrenaline rush 1
- arena · 1 ✖
- bass guitar solo 1
- crowds cheering 1
- energetic 1
- excitement in the air 1
- exciting 1
- guitar accompaniment 1
- latin percussions 1
- latin pop hits 1
- live audience 1
- live in concert 1
- male singer 1
- medium fast tempo 1
- passionate 1
- poor audio quality · 1 ✖
- retro latin hits 1
- saxophone solo 1
- strong drumming rhythm 1
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"] |
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 );