musiccaps
1 row where aspect_list contains "poignant" and aspect_list contains "violinist"
This data as json, CSV (advanced)
aspect_list (array) 18 ✖
- acoustic song 1
- bowing technique 1
- cool melody 1
- emotional 1
- home music video 1
- indie music 1
- instrumental music 1
- medium tempo 1
- melancholic music 1
- mode music video 1
- pizzicato 1
- poignant · 1 ✖
- raspy notes 1
- suspense 1
- violin music 1
- violinist · 1 ✖
- virtuoso 1
- youtube music video 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
vfMEPOl1Wqw | The song is an instrumental. The tempo is medium with a violinist playing a poignant melody with pizzicato played at the beginning. The song is emotional and poignant. The song is a YouTube music video. | ["pizzicato", "violinist", "instrumental music", "violin music", "youtube music video", "virtuoso", "mode music video", "home music video", "indie music", "acoustic song", "medium tempo", "poignant", "suspense", "emotional", "cool melody", "raspy notes", "bowing technique", "melancholic music"] | ["Zither", "Violin, fiddle", "Pizzicato", "Bowed string instrument"] | 1 | 10 | 20 | 0 | 0 | ["/m/01bns_", "/m/07y_7", "/m/0d8_n", "/m/0l14_3"] |
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 );