musiccaps
2 rows where aspect_list contains "mellow piano melody" and audioset_ids contains "/m/02mscn"
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 |
---|---|---|---|---|---|---|---|---|---|---|
4o0bARRMYQ8 | The Gospel song features a harmonized mixed choir vocals singing over mellow piano melody, smooth bass, soft kick, snare and cymbals hits and sustained strings melody. It sounds passionate, emotional, powerful and soulful. | ["gospel", "harmonized mixed choir vocals", "mellow piano melody", "smooth bass", "soft crash cymbals", "soft kick", "soft snare", "sustained strings melody", "emotional", "powerful", "soulful", "passionate"] | ["Christian music", "Music"] | 4 | 160 | 170 | 0 | 0 | ["/m/02mscn", "/m/04rlf"] | |
BiQik0xsWxk | The Soul song features a passionate male vocal singing over shimmering hi hats and shakers, groovy bass, widely spread wooden percussions, punchy kick and snare hits, wide sustained strings melody and mellow piano melody. It sounds emotional and passionate. | ["soul", "passionate male vocal", "wide wooden percussions", "punchy kick", "groovy bass", "wide sustained strings melody", "mellow piano melody", "shimmering hi hats", "punchy snare", "emotional", "passionate"] | ["Music of Asia", "Christian music", "Music", "Song"] | 4 | 30 | 40 | 0 | 1 | ["/m/028sqc", "/m/02mscn", "/m/04rlf", "/m/074ft"] |
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 );