musiccaps
2 rows where aspect_list contains "mellow" and audioset_ids contains "/m/02fsn"
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 |
---|---|---|---|---|---|---|---|---|---|---|
BkSCfcTBMRY | This is a classical music piece performed by a trio of the violin, the cello and the piano. The melody being played is a gentle one and there is a feeling of resolution in this section of the piece. This piece could be used in the soundtrack of a drama TV series during the closing scenes. | ["classical music", "violin", "cello", "piano", "gentle", "mellow", "resolution"] | ["Cello", "Double bass", "Keyboard (musical)", "Piano", "Violin, fiddle", "Bowed string instrument"] | 9 | 230 | 240 | 0 | 0 | ["/m/01xqw", "/m/02fsn", "/m/05148p4", "/m/05r5c", "/m/07y_7", "/m/0l14_3"] | |
EkmHGd0U8yE | This music is instrumental. The tempo is slow with a melancholic cello harmony, and a piano and violin accompaniment. The music is soft, pensive, melancholic, sentimental, sad, reflective, meditative and delicate. This music is a Violin Instrumental. | ["instrumental", "slow tempo", "cello", "violin", "sad", "reflective", "delicate", "poignant", "meditative", "reflective", "piano accompaniment", "soft", "mellow", "ambient", "pensive", "ponderous", "sentimental", "emotional"] | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | 7 | 100 | 110 | 0 | 0 | ["/m/01xqw", "/m/02fsn", "/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 );