musiccaps
2 rows where aspect_list contains "energetic", aspect_list contains "passionate", aspect_list contains "passionate male vocal" and aspect_list contains "rock"
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 |
---|---|---|---|---|---|---|---|---|---|---|
1QFli7KSXAQ | The Rock song features a passionate male vocalist singing over wide electric guitar melodies, groovy bass guitar, shimmering cymbals, groovy toms, punchy snare and kick hits. It sounds energetic, passionate, emotional and loud. | ["rock", "punchy kick", "punchy snare", "groovy toms", "wide electric guitars melodies", "groovy bass guitar", "shimmering cymbals", "passionate male vocal", "energetic", "passionate", "emotional", "loud"] | ["Disco", "Music"] | 4 | 30 | 40 | 0 | 0 | ["/m/026z9", "/m/04rlf"] | |
VfARCp38XtA | The low quality recording features a live performance of a rock song and it consists of passionate male vocal singing over energetic drums, funky bass guitar, electric guitar melody and solo brass melody. At the end of the loop, there is a short snippet of choir singing in harmony. Overall it sounds funky, energetic, soulful and passionate - as a live performance should sound. | ["rock", "low quality", "live performance", "passionate male vocal", "choir", "solo brass melody", "funky bass guitar", "energetic drums", "electric guitar melody", "energetic", "soulful", "passionate", "funky"] | ["Singing", "Music", "Rock music", "Song", "Rock and roll", "Yell"] | 4 | 70 | 80 | 1 | 1 | ["/m/015lz1", "/m/04rlf", "/m/06by7", "/m/074ft", "/m/07sbbz2", "/m/07sr1lc"] |
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 );