musiccaps
2 rows where aspect_list contains "trombones" and audioset_ids contains "/m/06ncr"
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 |
---|---|---|---|---|---|---|---|---|---|---|
3dzR3ZWOe8Y | This song contains acoustic drums playing a complex rhythm along with a e-bass playing a walking bassline and a piano playing jazz chords in the mid range. A baritone saxophone is playing the main melody accompanied by other brass instruments. This song may be playing during a live concert. | ["jazz", "baritone saxophone", "acoustic piano", "saxophones", "trombones", "trumpets", "acoustic drums", "e-bass", "very fast tempo"] | ["Brass instrument", "Saxophone"] | 6 | 410 | 420 | 0 | 0 | ["/m/01kcd", "/m/06ncr"] | |
8zcogfmAD_o | A woman talks before the beginning of the music track. The song is instrumental with a trumpet playing a swing melody accompanied by a brass band and jazz orchestra. The tempo is medium with a walking bass line, piano accompaniment, steady rhythm and clapping percussion. The song is a classic swing jazz tune. | ["woman talks", "trumpet melody", "jazz music", "walking bass line", "new orleans", "video soundtrack", "big band orchestra", "brass instruments", "piano accompaniment", "trombones", "jazz music", "vintage jazz", "retro jazz hits", "swing music", "steady drumming rhythm", "clapping rhythm", "jazz classics", "swing era", "instrumental music"] | ["Brass instrument", "Saxophone"] | 1 | 180 | 190 | 0 | 0 | ["/m/01kcd", "/m/06ncr"] |
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 );