musiccaps
1 row where aspect_list contains "bass guitar", aspect_list contains "male vocal" and aspect_list contains "vintage sound"
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 |
---|---|---|---|---|---|---|---|---|---|---|
IePfzUzlDng | This is a hard rock music piece. There is a male vocalist singing melodically in the lead. The main tune is being played by the overdriven electric guitar with the bass guitar playing in the background. The rhythm is being played by the acoustic drums. The atmosphere is energetic. There is a vintage sound. This piece can be played in the background at a rock bar. | ["hard rock", "male vocal", "melodic singing", "overdriven electric guitar", "bass guitar", "acoustic drums", "energetic", "vintage sound"] | ["Guitar", "Music", "Musical instrument", "Psychedelic rock", "Plucked string instrument"] | 9 | 40 | 50 | 0 | 0 | ["/m/0342h", "/m/04rlf", "/m/04szw", "/m/05w3f", "/m/0fx80y"] |
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 );