musiccaps
2 rows where aspect_list contains "percussion hits" and audioset_ids contains "/m/015lz1"
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 |
---|---|---|---|---|---|---|---|---|---|---|
FXVu-YwjhxM | A male singer sings this cool melody. The song is medium tempo with a groovy guitar lead and steady drumming with tambourine percussion. The song is cool and sophisticated. The audio quality is bad. | ["bass guitar solo", "male singer", "guitar lead", "retro pop hits", "noir style", "rhythm guitar", "percussion hits", "love song", "missing you", "together forever", "strong bass guitar", "percussions", "big band", "story telling", "romantic", "emotional", "groovy", "tambourine percussions", "medium tempo", "bad audio quality"] | ["Blues", "Singing"] | 1 | 200 | 210 | 0 | 0 | ["/m/0155w", "/m/015lz1"] | |
dHDosntsNho | A female singer sings in a huge arena live along with crowds singing along with her in vocals. The song is medium tempo with steady drumming rhyme and giant drum rolls, violin playing solo, a brass band section and orchestra playing along. The song is energetic, cheerful and highly popular. The audio quality is very poor with heavy ambient crowd noises. | ["live performance", "female singer", "bad audio quality", "syncopated rhythms", "medium tempo", "pop music", "huge arena", "crowds sing along", "live audience", "diva", "memdium tempo", "orchestra plays", "violin solo", "horn section", "brass band", "percussion hits", "big show", "jazz music show", "pop music", "big stage", "big band plays"] | ["Singing", "Music", "Pop music", "Inside, large room or hall", "Inside, public space"] | 1 | 560 | 570 | 0 | 0 | ["/m/015lz1", "/m/04rlf", "/m/064t9", "/t/dd00126", "/t/dd00127"] |
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 );