musiccaps
1 row where aspect_list contains "documentary soundtrack" and aspect_list contains "violin technique"
This data as json, CSV (advanced)
aspect_list (array) 19 ✖
- bad audio quality 1
- conductor 1
- documentary soundtrack · 1 ✖
- documentary video 1
- fast tempo 1
- great composers 1
- high pitched notes 1
- instrumental music 1
- melancholic 1
- passionate 1
- spirited 1
- string quartet 1
- string section 1
- studio 1
- vibrato 1
- violin solo 1
- violin technique · 1 ✖
- water splashing sound 1
- western classical music 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
0qtbbK5HVMw | The song is instrumental. The tempo is fast with violins playing in harmony showing exemplary technique. The song is emotional, spirited and passionate. The song is a western classical music hit. The audio quality is poor. | ["water splashing sound", "violin solo", "instrumental music", "great composers", "conductor", "studio", "fast tempo", "string quartet", "string section", "fast tempo", "bad audio quality", "documentary soundtrack", "documentary video", "melancholic", "passionate", "spirited", "vibrato", "high pitched notes", "violin technique", "western classical music"] | ["Music", "Musical instrument", "Pour", "Violin, fiddle", "Bowed string instrument"] | 1 | 330 | 340 | 0 | 0 | ["/m/04rlf", "/m/04szw", "/m/07prgkl", "/m/07y_7", "/m/0l14_3"] |
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 );