musiccaps
1 row where aspect_list contains "cymbal crashes" and aspect_list contains "nostalgia"
This data as json, CSV (advanced)
aspect_list (array) 19 ✖
- cymbal crashes · 1 ✖
- elanchoilic 1
- emotional 1
- good old times 1
- guitar strumming 1
- keyboard organ accompaniment 1
- love song 1
- male singer 1
- modern pop song 1
- nostalgia · 1 ✖
- old memories 1
- poignant mood 1
- reflecting 1
- romantic 1
- sentimental 1
- slow tempo 1
- steady drumming rhythm 1
- strong bass line 1
- vocal echoes 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
6jeq5lP5Up0 | A male singer sings this poignant melody. The tempo pop is slow with a steady drumming rhythm, cymbal crashes, guitar accompaniment, keyboard organ accompaniment and a strong bass line. The song is a poignant love song. | ["male singer", "poignant mood", "slow tempo", "reflecting", "nostalgia", "old memories", "good old times", "vocal echoes", "guitar strumming", "keyboard organ accompaniment", "steady drumming rhythm", "cymbal crashes", "elanchoilic", "emotional", "sentimental", "romantic", "love song", "modern pop song", "strong bass line"] | ["Blues", "Music"] | 1 | 30 | 40 | 0 | 0 | ["/m/0155w", "/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 );