musiccaps
2 rows where aspect_list contains "uplifting mood" 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 |
---|---|---|---|---|---|---|---|---|---|---|
VB82vMSTYK0 | This composition contains a small orchestra playing melodies on violas and violins in the higher mid range to the higher register. The celli and the upright bass being stroked with a bow are playing a rhythmic melody part that gives the foundation of the song. This song may be playing live as a classical concert. | ["classical", "orchestra", "upright bass", "celli", "violins/violas", "uptempo", "uplifting mood"] | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | 6 | 30 | 40 | 0 | 0 | ["/m/01xqw", "/m/02fsn", "/m/07y_7", "/m/0l14_3"] | |
v4sANJkuwP4 | This symphonic song features an orchestra. At the beginning, a French horn plays a melody. This is followed by a harmony played by the string section and brass section. There is no percussion in this song. This song is uplifting. The mood of this song is suspenseful. This song can be played in a movie where a dangerous scene is taking place. | ["symphonic song", "orchestra", "horn section", "no percussion", "strings", "brass section", "instrumental", "no voices", "uplifting mood", "theme of impending danger"] | ["Brass instrument", "Cello", "Double bass", "French horn", "Orchestra", "Violin, fiddle", "Bowed string instrument"] | 0 | 30 | 40 | 0 | 0 | ["/m/01kcd", "/m/01xqw", "/m/02fsn", "/m/0319l", "/m/05pd6", "/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 );