musiccaps_details (view)
3 rows where musiccaps_aspects contains "big band" and musiccaps_names contains "Swing music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- big band · 3 ✖
- acoustic drums 2
- instrumental 2
- jazz 2
- lively 2
- upbeat 2
- upright bass 2
- bells melody 1
- brass section 1
- charleston dance 1
- clarinet 1
- euphoric 1
- flute 1
- fun 1
- happy 1
- low quality 1
- no singer 1
- nostalgic 1
- piano 1
- piano chords progression 1
- playful 1
- saxophone 1
- shimmering cymbals 1
- shimmering shakers 1
- smooth bass 1
- soft kick 1
- tinny percussive elements 1
- tom rolls 1
- trumpet 1
- vibraphone 1
- vintage 1
- wide reverberant brass section melody 1
- winds section 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
James Last - Happy Music | The low quality recording features a big band song that consists of wide reverberant brass section melody, shimmering shakers and cymbals, bells melody, piano chord progression, smooth bass and soft kick hits. There are some tom rolls that represent a transition into the next section. It sounds happy and fun, but it also gives off euphoric and nostalgic vibes, as it sounds vintage. | 2009-10-19T14:24:00Z | anggip lesmana | JAMES LAST didn't burst forth on the popular music scene with a fanfare of trumpets and explosions of fire-work. He just sort of emerged in a quiet cloak of talent. For three years running LAST was voted best bass player in a German jazz poll. But the minute he found out that having an orchestra and being able to experiment with hit songs was much more satisfying and rewarding, JAMES LAST was on the way to becoming a true giant in the world of today popular music. The remarkable abilities as a bass player are only part of his musical talent. He also is an accomplished songwriter, arranger and bandleader. | ["Swing music", "Music"] | ["low quality", "big band", "wide reverberant brass section melody", "shimmering cymbals", "shimmering shakers", "tinny percussive elements", "tom rolls", "bells melody", "piano chords progression", "smooth bass", "soft kick", "happy", "fun", "nostalgic", "euphoric", "vintage"] | 4 | VnJeG9RGUVM | 3031 | |
Professional Charleston - Strictly Come Dancing 2011 | This is a big band jazz music piece. It is an accompaniment piece to the Charleston dance. The band consists of a wide range of brass sections, an upright bass, a jazz acoustic drum beat and a vibraphone. Sounds from the cheering crowd can be heard. The atmosphere is lively. The piece is upbeat. | 2011-12-05T22:33:48Z | LunaleeTreasureBox | 2011 Professional Dancers: Pasha Kovalev Katya Virshilas Artem Chigvintsev Kristina Rihanoff Brendan Cole Erin Boag Anton du Beke Ola Jordan Robin Windsor Natalie Lowe Vincent Simone Aliona Vilani James Jordan Flavia Cacace 2011 Couples: Alex Jones & James Jordan Anita Dobson & Robin Windsor Audley Harrison & Natalie Lowe Chelsee Healey & Pasha Kovalev Dan Lobb & Katya Virshilas Edwina Currie & Vincent Simone Harry Judd & Aliona Vilani Holly Valance & Artem Chigvintsev Jason Donovan & Kristina Rihanoff Lulu & Brendan Cole Nancy Dell'Olio & Anton du Beke Robbie Savage & Ola Jordan Rory Bremner & Erin Boag Russell Grant & Flavia Cacace | ["Swing music", "Ska"] | ["jazz", "big band", "charleston dance", "no singer", "instrumental", "brass section", "upright bass", "acoustic drums", "vibraphone", "lively", "upbeat"] | 9 | WmyhSRhWh3k | 3135 |
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;