musiccaps
2 rows where aspect_list contains "uplifting mood" and audioset_ids contains "/m/05pd6"
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 |
---|---|---|---|---|---|---|---|---|---|---|
MmqRlHntd0Q | This song contains a marching band playing a melody with a big brass section. Horns are playing the bass melody and kicks and snare rolls are providing the rhythm along with some cymbal hits. This song may be playing at a national sports-event. | ["marching band", "brass section", "drums/percussion", "amateur recording", "uplifting mood", "uptempo"] | ["Orchestra", "Clickety-clack"] | 6 | 80 | 90 | 0 | 0 | ["/m/05pd6", "/m/07rwm0c"] | |
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 );