musiccaps
1 row where aspect_list contains "acoustic rhythm guitar" and aspect_list contains "lead female vocal"
This data as json, CSV (advanced)
aspect_list (array) 8 ✖
- acoustic rhythm guitar · 1 ✖
- emotional 1
- indie folk 1
- lead female vocal · 1 ✖
- low quality 1
- passionate 1
- sad 1
- wide harmonizing male vocals 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
hTlIqICkbW8 | The low quality recording features an indie folk song that consists of wide harmonizing male vocals and acoustic rhythm guitar. In the second half of the loop, the lead female vocal appears, creating a perfect harmony with the previously mentioned male vocals. It sounds passionate, emotional and sad. | ["low quality", "wide harmonizing male vocals", "indie folk", "acoustic rhythm guitar", "lead female vocal", "passionate", "emotional", "sad"] | ["Folk music", "Acoustic guitar", "Music", "Independent music", "Song", "Strum", "Plucked string instrument"] | 4 | 60 | 70 | 0 | 1 | ["/m/02w4v", "/m/042v_gx", "/m/04rlf", "/m/05rwpb", "/m/074ft", "/m/07s0s5r", "/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 );