musiccaps
2 rows where aspect_list contains "emotional", aspect_list contains "groovy bass line" and aspect_list contains "people talking"
This data as json, CSV (advanced)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
8DQbnR7hwpc | The song is instrumental. The tempo is medium with a harpist playing a bass line accompanying a violist. The song is folk-like with a dance rhythm. The audio quality is poor with ambient crowd noise. | ["harpist", "violinist", "dance music", "groovy bass line", "instrumental music", "couples dan", "family gatherings", "poor audio quality", "romantic", "south american folk music", "folk dance music", "instrumental duo", "people talking", "ambient crowd noises", "medium tempo", "sentimental", "emotional", "cheerful", "positive", "festive spirit", "togetherness", "traditional custom dance"] | ["Harp", "Violin, fiddle", "Pizzicato", "Bowed string instrument"] | 1 | 30 | 40 | 0 | 0 | ["/m/03m5k", "/m/07y_7", "/m/0d8_n", "/m/0l14_3"] | |
jFek2xLbEww | A male singer raises this passionate melody. The song is medium tempo with an acoustic guitar accompaniment, groovy bass line and a subtle drumming rhythm. The song is passionate and relaxing. The song is played live and has poor audio quality. | ["male singer", "live performance", "groovy bass line", "medium tempo", "story telling", "ambient room nosiness", "people talking", "guitar accompaniment", "bass rhythm", "steady percussions", "folk music", "emotional", "energetic", "people talking", "poor audio quality", "folk music", "folk music", "guitarist"] | ["Singing", "Music", "Rattle (instrument)"] | 1 | 190 | 200 | 0 | 1 | ["/m/015lz1", "/m/04rlf", "/m/05r5wn"] |
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 );