musiccaps_details (view)
2 rows where musiccaps_aspects contains "jazz", musiccaps_names contains "Drum kit" and musiccaps_names contains "Percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- jazz · 2 ✖
- acoustic drums 1
- acoustic piano 1
- background crowd 1
- brass section 1
- energetic cymbals 1
- groovy double bass 1
- groovy piano chords 1
- horn section 1
- live performance 1
- manic tom roll 1
- organ keys chords 1
- passionate 1
- punchy kick 1
- punchy snare 1
- saxophone solo melody 1
- upbeat 1
- uptempo 1
musiccaps_names (array) 12 ✖
- Drum kit · 2 ✖
- Percussion · 2 ✖
- Bass drum 1
- Brass instrument 1
- Cowbell 1
- Cymbal 1
- Drum 1
- Jazz 1
- Music 1
- Musical instrument 1
- Rimshot 1
- Snare drum 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 | |
Shirazette Tinnin - Inner Frustration | The low quality recording features a jazz live performance that consists of saxophone solo melody played over energetic cymbals, manic tom roll, punchy snare and kick hits, organ keys chords, groovy double bass and groovy piano chords. It sounds passionate and upbeat. | 2012-08-16T17:50:49Z | Latin Percussion | Shirazette Tinnin visits the LP studio to perform "Inner Frustration." Drums: Shirazette Tinnin Piano : Willerm Delisfort Piano: Rachel Eckroft Guitar: Seth Johnson Bass: Tom DiCarlo Saxophone: Camille Thurman LP LP204A Black Beauty Cowbell LP204A LP Americana Series Peruvian Cajon LP1439 | ["Cowbell", "Drum", "Drum kit", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["live performance", "jazz", "saxophone solo melody", "manic tom roll", "energetic cymbals", "punchy snare", "organ keys chords", "groovy double bass", "punchy kick", "groovy piano chords", "passionate", "upbeat"] | 4 | t1ULMDpL35I | 4998 |
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;