musiccaps
1 row where aspect_list contains "christmas presents" and aspect_list contains "poor audio quality"
This data as json, CSV (advanced)
aspect_list (array) 20 ✖
- adventurous 1
- brass instruments playing triumphantly 1
- christmas presents · 1 ✖
- christmas song 1
- conductor 1
- exciting 1
- horn section 1
- instrumental music 1
- marching rhythm 1
- medium tempo 1
- movie soundtrack 1
- opera hall 1
- philharmonic orchestra 1
- poor audio quality · 1 ✖
- santa claus 1
- soaring harmonies 1
- solo violin 1
- string section 1
- trumelts playing 1
- trumpets playing 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
JHkcCXF5vII | The song is an instrumental song. The song is medium tempo with a marching drum rhythm, string section harmony, brass instruments playing and a horn section playing various harmonies. The song is exciting and adventurous in nature. The song is a movie soundtrack, and the audio quality is quite poor. | ["movie soundtrack", "poor audio quality", "instrumental music", "trumpets playing", "soaring harmonies", "conductor", "santa claus", "christmas presents", "opera hall", "philharmonic orchestra", "string section", "solo violin", "trumelts playing", "medium tempo", "marching rhythm", "exciting", "adventurous", "christmas song", "horn section", "brass instruments playing triumphantly"] | ["Theme music", "Music"] | 1 | 30 | 40 | 0 | 1 | ["/m/02cjck", "/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 );