musiccaps
2 rows where aspect_list contains "symphonic song" and audioset_ids contains "/m/0319l"
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 |
---|---|---|---|---|---|---|---|---|---|---|
tr2iVjsu4xs | This song features a brass quintet. The bass notes are played on a tuba. The main melody is played on the trumpets. This is backed by the trombone and French horn. There are no other instruments in this song. There are no voices in this song. This song is an instrumental song with an epic feel. This song can be played when a victorious protagonist enters the city after a battle in a movie. | ["brass quintet", "symphonic song", "orchestra song", "tuba", "trumpet", "french horn", "trombone", "no string instruments", "no percussion", "no voices", "instrumental", "epic mood", "moderate tempo"] | ["Brass instrument", "French horn", "Trombone", "Trumpet"] | 0 | 270 | 280 | 0 | 0 | ["/m/01kcd", "/m/0319l", "/m/07c6l", "/m/07gql"] | |
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 );