musiccaps
1 row where aspect_list contains "dance music" and aspect_list contains "rock band"
This data as json, CSV (advanced)
aspect_list (array) 20 ✖
- bad audio quality 1
- couples slow dancing 1
- cymbals crashing 1
- dance music · 1 ✖
- drum rolls 1
- exciting 1
- guitar playing lead 1
- instrumental music 1
- medium tempo 1
- passionate 1
- people dancing 1
- percussive bass line 1
- retro hits 1
- retro rock and roll 1
- rock and roll music 1
- rock band · 1 ✖
- romantic 1
- spirited 1
- steady rock drumming 1
- swing music 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
YDBxdZchOuM | The song is an instrumental. The tempo is medium with a guitar playing a romantic lead, steady drumming, rock drumming, percussive bass line, cymbals crashing and guitar strumming rhythm. The song is exciting and youthful. The song has a bad audio quality. | ["rock and roll music", "medium tempo", "steady rock drumming", "guitar playing lead", "cymbals crashing", "drum rolls", "swing music", "percussive bass line", "rock band", "romantic", "exciting", "retro rock and roll", "dance music", "people dancing", "couples slow dancing", "passionate", "spirited", "retro hits", "instrumental music", "bad audio quality"] | ["Music", "Psychedelic rock", "Rock music", "Roll", "Rock and roll"] | 1 | 230 | 240 | 0 | 0 | ["/m/04rlf", "/m/05w3f", "/m/06by7", "/m/07s8j8t", "/m/07sbbz2"] |
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 );