musiccaps_details (view)
2 rows where musiccaps_aspects contains "big band" and musiccaps_aspects contains "clarinet"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- big band · 2 ✖
- clarinet · 2 ✖
- acoustic drums 1
- acoustic guitar 1
- ballad 1
- ending 1
- flute 1
- instrumental 1
- jazz 1
- jazz genre 1
- lively 1
- medium quality audio recording 1
- piano 1
- playful 1
- saxophone 1
- slow tempo 1
- strings 1
- trumpet 1
- upbeat 1
- upright bass 1
- winds section 1
musiccaps_names (array) 4 ✖
- Music 2
- Jazz 1
- Swing music 1
- Theremin 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Goodbye - Benny Goodman 1980 | The jazz music features a clarinet playing a melody that's ending a song. A big band that incorporates a jazz acoustic guitar accompanies the clarinet. The tempo is slow and the style is ballad. The medium quality audio recording leads me to believe this is an older recording. | 2008-08-01T22:23:11Z | SwingCla | "Benny Goodman in Japan 1980" Playlist = http://bit.ly/2wGtUzi / "Aurex Jazz Festival", Sep.3,1980 at Budokan(Tokyo,Japan) / cl:Benny Goodman, p:Teddy Wilson, tp:Tony Terran, tb:Dick Nash, g:Eddie Duran, b:Al Obidinski, dr:John Markham | ["Music", "Theremin"] | ["clarinet", "strings", "acoustic guitar", "big band", "jazz genre", "slow tempo", "ballad", "ending", "medium quality audio recording"] | 2 | 8GKbDSu9Xd0 | 908 | |
A Griffon Day | This is a big band jazz music piece. It is an instrumental piece. The main melody is played by a wide variety of the winds section composed of the saxophone, the trumpet, the flute and the clarinet. The piano and the upright bass provide backing structures. The rhythmic background consists of a jazz acoustic drum beat. The atmosphere is playful. This piece could fit perfectly in the soundtrack of a Disney-type animation movie. | 2008-01-27T00:18:25Z | George Pfeiffer | Gus the Brussels Griffon documents a typical day in his life. If you like dogs...or monkeys...or Ewoks....then you'll love this little pooch! | ["Swing music", "Jazz", "Music"] | ["jazz", "big band", "instrumental", "winds section", "saxophone", "trumpet", "flute", "clarinet", "upright bass", "piano", "acoustic drums", "lively", "playful", "upbeat"] | 9 | JU6GUqRqbtI | 2011 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;