musiccaps
2 rows where aspect_list contains "short strings melody" and author_id = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|
1i1sbQOILb0 | The low quality recording features a live performance of traditional music and it consists of harmonizing female vocals singing over shimmering hi hats and tambourine hits, fat snare, boomy kick, groovy bass and short strings melody. The stereo image is unbalanced as the vocals are leaning towards the right channel of the stereo image. It sounds soulful and happy. | ["low quality", "soulful", "live performance", "happy", "traditional music", "harmonizing female vocal", "unbalanced stereo", "shimmering hi hats", "fat snare", "groovy bass", "short strings melody", "boomy kick", "shimmering tambourine"] | ["Traditional music", "Music"] | 4 | 30 | 40 | 0 | 1 | ["/m/02p0sh1", "/m/04rlf"] | |
sxgMEmp5aGE | The Traditional song features a sustained strings melody, followed by short strings melody, wide wooden percussions and shimmering shakers. It sounds soulful and passionate. | ["traditional", "sustained strings melody", "short strings melody", "wide wooden percussions", "shimmering shakers", "soulful", "passionate"] | ["Music of Asia", "Folk music", "Music"] | 4 | 20 | 30 | 0 | 0 | ["/m/028sqc", "/m/02w4v", "/m/04rlf"] |
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 );