musiccaps_details (view)
3 rows where musiccaps_aspects contains "no other instruments", musiccaps_aspects contains "percussion", musiccaps_author = 0 and musiccaps_names contains "Drum kit"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Tea Party - Lullaby Live In Montreal - July 7, 2011 | This amateur recording features a rock song. A repetitive phrase is played on the guitar. The first bar consists of only the guitar sound. The bass and percussion start playing after one bar. The bass plays one note in groups of twos. The percussion plays a groovy rock beat. The hi-hat is played in a group of four strokes on the closed hi-hat followed by one stroke on the open hi-hat. There are no voices in this song. The mood of this song is melancholic. | 2011-07-10T12:36:07Z | Luc Beaulieu | Live at Le Métropolis, Montreal, Québec, Canada | ["Drum kit", "Guitar", "Music", "Musical instrument", "Rock music", "Pulse"] | ["amateur recording", "rock", "guitar", "repetitive phrase", "percussion", "bass", "no voice", "no other instruments", "slow tempo", "melancholic mood"] | 0 | GcYeBWujhjw | 1741 | |
KJ Sawka Live on c89.5 | This electronic music is played on a drum kit. This song also uses a processor to make electronic sounds. The percussion plays the ride continuously followed by the hi-hat continuously. Deep bass sounds are played on the electronic console. There are other animated sounds like the sound of an alien space ship played in this song. This song has no other instruments. There are no voices in this song. | 2006-11-20T22:22:32Z | briandewaide | Buy KJ Sawka's music at www.kjsawka.com or www.waxorchard.com Sawka plays his song "Axis" live on electronic music station c89.5 in Seattle. | ["Cymbal", "Drum", "Drum and bass", "Drum kit", "Electronic music", "Music", "Musical instrument", "Snare drum"] | ["electronic music", "percussion", "no other instruments", "no voices", "dance music", "ambient sounds", "low quality recording"] | 0 | kp5OxEzxuSg | 4359 | |
rodney holmes amazing cowbell groove slo-mo | This song features a drum solo. The drum solo has the accents on the cowbell. The tempo of this song is fast. The hi-hat accentuates the counts and is played in eighth note pattern. There are no other instruments in this song. This song can be played in an instructional video. | 2012-01-15T11:53:43Z | Jannes Oosterwijk | rodney holmes doin' this amazing groove cowbell groove. Includes the slo-mo credits go to drummerworld dot com | ["Cowbell", "Drum", "Drum kit", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["percussion", "cowbell sound", "drum solo", "no other instruments", "no vocal melody", "fast tempo"] | 0 | pdOskdFwRPg | 4729 |
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;