musiccaps
1 row where aspect_list contains "strings section melody" and audioset_ids contains "/m/0l14_3"
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 |
---|---|---|---|---|---|---|---|---|---|---|
HRVVqstIabc | The low quality recording features an orchestra song that consists of a string section melody. The section contains violin melody playing in the left channel, cello in the right channel and later on, double bass in the middle. It sounds emotional and passionate. | ["low quality", "orchestral", "strings section melody", "cello melody", "violin melody", "double bass", "emotional", "passionate"] | ["Cello", "String section", "Violin, fiddle", "Bowed string instrument"] | 4 | 240 | 250 | 0 | 0 | ["/m/01xqw", "/m/02qmj0d", "/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 );