musiccaps
1 row where aspect_list contains "nature sounds" and aspect_list contains "unbalanced stereo"
This data as json, CSV (advanced)
aspect_list (array) 10 ✖
- acoustic guitar solo melody 1
- banjo melody 1
- folk 1
- live perforamnce 1
- low quality 1
- nature sounds · 1 ✖
- noisy 1
- passionate 1
- unbalanced stereo · 1 ✖
- upbeat 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
qyCea2TuUV4 | The low quality recording features a live performance of a folk song and it consists of acoustic guitar solo melody, followed by banjo melody. The recording is noisy, there are some natural sounds - since it was performed outdoors and the stereo image is unbalanced due to the fact that the instruments are leaning towards the right channel of the stereo image. It still sounds passionate and upbeat. | ["low quality", "noisy", "live perforamnce", "unbalanced stereo", "nature sounds", "acoustic guitar solo melody", "upbeat", "banjo melody", "folk", "passionate"] | ["Banjo", "Country", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | 4 | 100 | 110 | 0 | 0 | ["/m/018j2", "/m/01lyv", "/m/0342h", "/m/04rlf", "/m/04szw", "/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 );