musiccaps
1 row where aspect_list contains "rock" and aspect_list contains "solo brass melody"
This data as json, CSV (advanced)
aspect_list (array) 13 ✖
- choir 1
- electric guitar melody 1
- energetic 1
- energetic drums 1
- funky 1
- funky bass guitar 1
- live performance 1
- low quality 1
- passionate 1
- passionate male vocal 1
- rock · 1 ✖
- solo brass melody · 1 ✖
- soulful 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
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 );