musiccaps
2 rows where aspect_list contains "acoustic guitar melody" and aspect_list contains "passionate male vocal"
This data as json, CSV (advanced)
aspect_list (array) 16 ✖
- acoustic guitar melody · 2 ✖
- emotional 2
- low quality 2
- passionate 2
- passionate male vocal · 2 ✖
- alternative/indie 1
- blues 1
- groovy bass 1
- heartfelt 1
- live performance 1
- mellow snare 1
- mono 1
- muted acoustic guitar melody 1
- noisy 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"] | |
TLMEsc_42Gw | The low quality recording features a live performance of an alternative/indie song, sung by passionate male vocalists over an acoustic guitar melody. It sounds passionate, emotional and heartfelt. The recording is noisy and in mono. | ["low quality", "alternative/indie", "live performance", "passionate male vocal", "acoustic guitar melody", "noisy", "mono", "emotional", "passionate", "heartfelt"] | ["Singing", "Guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | 4 | 210 | 220 | 0 | 0 | ["/m/015lz1", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07xzm", "/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 );