musiccaps
2 rows where audioset_ids contains "/m/01kcd" and audioset_ids contains "/m/01xqw" sorted by aspect_list
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 |
---|---|---|---|---|---|---|---|---|---|---|
kdxW11WBlQE | This song contains a fast and silent jazz drum rhythm with a fast groove on the ride. Someone is playing an arpeggio melody on an acoustic piano in the midrange, adding a little melody on top being played in the upper register. A upright bass is playing a walking bassline. A saxophone is playing the main melody. This song may be playing live as a concert. | ["jazz", "amateur recording", "upright bass", "acoustic drums", "acoustic piano", "saxophone", "fast tempo", "calm"] | ["Brass instrument", "Cello", "Saxophone", "Pizzicato", "Bowed string instrument"] | 6 | 150 | 160 | 0 | 0 | ["/m/01kcd", "/m/01xqw", "/m/06ncr", "/m/0d8_n", "/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 );