musiccaps
1 row where aspect_list contains "electric guitar arp melody" 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 |
---|---|---|---|---|---|---|---|---|---|---|
FsnRM2irjvI | The low quality recording features a live performance of an alternative/indie song and it consists of flat female vocal singing over synth keys and arpeggiated electric guitar melody. There are also some crowd noises in the background. It sounds thin, but also emotional and like something you would want to sing along. | ["low quality", "live performance", "flat female vocal", "synth keys melody", "electric guitar arp melody", "thin", "emotional", "alternative/indie", "crowd noises"] | ["Singing", "Music", "Burst, pop"] | 4 | 30 | 40 | 1 | 1 | ["/m/015lz1", "/m/04rlf", "/m/07qsvvw"] |
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 );