musiccaps
1 row where aspect_list contains "acoustic guitar melody" and aspect_list contains "poor quality mix"
This data as json, CSV (advanced)
aspect_list (array) 11 ✖
- acoustic guitar melody · 1 ✖
- blues 1
- emotional 1
- groovy bass 1
- low quality 1
- mellow snare 1
- muted acoustic guitar melody 1
- passionate 1
- passionate male vocal 1
- poor quality mix · 1 ✖
- shimmering cymbals 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
9Rx57dlJtIA | The low quality recording features a blues song that consists of a passionate male vocal singing over acoustic guitar melody in the left channel, muted acoustic guitar melody in the right channel of the stereo image, groovy bass, mellow snare and shimmering cymbals. It sounds passionate and emotional. | ["low quality", "poor quality mix", "blues", "passionate male vocal", "acoustic guitar melody", "muted acoustic guitar melody", "groovy bass", "mellow snare", "shimmering cymbals", "passionate", "emotional"] | ["Blues", "Country", "Music"] | 4 | 80 | 90 | 0 | 0 | ["/m/0155w", "/m/01lyv", "/m/04rlf"] |
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 );