musiccaps
2 rows where aspect_list contains "bad audio quality" and audioset_ids contains "/m/07y_7"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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"] | |
I11AcD1sGes | Male and female singers sing together in vocal unison. The song is medium tempo with a violin playing countermelody, along with a traditional string bass rhythm and percussion instruments. The song is South American folk music with a lot of passion. The song audio quality is bad with high gains all over. | ["male and female singers", "traditional latin instruments", "high gain", "violin countermelody", "folk music", "folk singers", "bad audio quality", "south american folk music", "cheerful", "emotional", "festivities", "passionate", "devotional", "family singing", "medium tempo", "vocal harmony", "vocal unison", "traditional music", "traditional string bass instrument", "amateur singers", "latin percussion instruments"] | ["Harp", "Violin, fiddle", "Pizzicato", "Bowed string instrument"] | 1 | 330 | 340 | 0 | 0 | ["/m/03m5k", "/m/07y_7", "/m/0d8_n", "/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 );