musiccaps
1 row where aspect_list contains "melancholic" and aspect_list contains "string bass drum kicks"
This data as json, CSV (advanced)
aspect_list (array) 20 ✖
- backup singers 1
- choral music 1
- christmas carols 1
- christmas time 1
- december 1
- emotional 1
- female singer 1
- medium tempo 1
- melancholic · 1 ✖
- nostalgic 1
- piano accompaniment 1
- presents 1
- snowfall 1
- steady drumming rhythm 1
- string bass drum kicks · 1 ✖
- string bass line 1
- strong bass drum kicks 1
- strong bass line 1
- vocal harmony 1
- winter wonderland 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
7LlKoQAvXUc | A female singer sings this beautiful melody with vocal harmony. The song is medium tempo with a piano accompaniment, steady drumming rhythm, strong bass drum kicks and a steady bass line. The song is melancholic and emotional. The song is a modern Christmas carol. | ["female singer", "backup singers", "strong bass line", "strong bass drum kicks", "vocal harmony", "piano accompaniment", "medium tempo", "steady drumming rhythm", "string bass drum kicks", "string bass line", "melancholic", "choral music", "christmas carols", "winter wonderland", "emotional", "nostalgic", "christmas time", "december", "snowfall", "presents"] | ["Christmas music", "Music"] | 1 | 30 | 40 | 0 | 1 | ["/m/0140xf", "/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 );