musiccaps_details (view)
2 rows where musiccaps_aspects contains "uptempo", musiccaps_names contains "Jazz" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- uptempo · 2 ✖
- acoustic drums 1
- acoustic piano 1
- acoustic rhythm guitar chords 1
- background crowd 1
- brass section 1
- groovy double bass 1
- horn section 1
- jazz 1
- live performance 1
- low quality 1
- mono 1
- noisy 1
- passionate 1
- spanish guitar solo melody 1
musiccaps_names (array) 11 ✖
- Jazz · 2 ✖
- Music 2
- Musical instrument · 2 ✖
- Bluegrass 1
- Brass instrument 1
- Cymbal 1
- Drum kit 1
- Guitar 1
- Percussion 1
- Plucked string instrument 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Buddy Rich Live at The Montreal Jazz Festival | This composition contains acoustic drums playing a complex groove on just the snare using brushes. The crowd in the background is cheering, whistling and clapping their hands. A bass, piano and horn section is playing a melody as a counter-beat along with trumpets playing along a modified melody in a higher register. Then saxophones are coming in playing their own countermelody. This song is highly complex and may be playing at a jazz festival. | 2013-01-30T04:49:46Z | Raphael Moura | The Buddy Rich Big Band | ["Brass instrument", "Cymbal", "Drum kit", "Jazz", "Music", "Musical instrument", "Percussion"] | ["jazz", "acoustic drums", "acoustic piano", "brass section", "horn section", "background crowd", "uptempo"] | 6 | QRKc90kuAaE | 2618 | |
Swing Amor "Rose Room" | The low quality recording features a live performance that consists of a Spanish guitar solo melody, groovy double bass and acoustic rhythm guitar chords. The recording is noisy, in mono and it sounds passionate and uptempo - like something you would dance to with your friends in a latin club. | 2008-12-02T16:54:14Z | hailletmusic | About SWING AMOR A gypsy swing band formed in 2004. Currently, the band performs in cafes and such based in Kumamoto Prefecture.In April 2006, their first album GYPSY SWING JAZZ was released. It includs 12 gems, from originals to standard Jazz tunes. In July 2007, they participated in a compilation album "DJANGO FESTIVAL4" which was released by a long-established Norwegian gypsy jazz label. In January 2009 the distribution of GYPSY SWING JAZZ will begin via iTunes stores in 22 nations. The recording of their second album, three years after the first, is scheduled as well. | ["Swing music", "Guitar", "Jazz", "Music", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["low quality", "spanish guitar solo melody", "live performance", "groovy double bass", "acoustic rhythm guitar chords", "noisy", "mono", "passionate", "uptempo"] | 4 | iUHqyjf3NcQ | 4191 |
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;