musiccaps_details (view)
3 rows where musiccaps_aspects contains "male voice", musiccaps_aspects contains "moderate tempo", musiccaps_names contains "Guitar" and musiccaps_names contains "Musical instrument"
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 |
---|---|---|---|---|---|---|---|---|---|---|
How to Play Trust by Megadeth Guitar Lesson (w/ Tabs!!) | This song features a distortion guitar. This is an instructional video. The song features an open note followed by the octave. Then a descending pattern is played on the distortion guitar. The voice gives instructions on how to play the pattern. There is no percussion in this song. There are no other instruments in this song. There is no vocal melody in this song. | 2009-03-15T04:06:25Z | m169marroquin | http://www.ObeyYourMATTster.com | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | ["distortion guitar", "heavy metal", "male voice", "instructional audio", "octaves", "no other instruments", "no percussion", "no vocal melody", "moderate tempo"] | 0 | 52odOK7G2kg | 628 | |
Guitar Hero | This clip features 2 distortion guitars playing a metal song. A high pitched male voice sings the main melody. This is accompanied by percussion playing a simple rock beat in common time. A bass guitar plays a bassline with a descending run. The distortion guitars play power chords followed by a guitar lick. One of the guitars plays one chord a little after the other guitar making it sound dissonant. This song can be played in an action movie. | 2006-04-25T16:32:40Z | Kim Burkart | Two Dudes Playing Guitar Hero | ["Guitar", "Music", "Musical instrument", "Roll", "Plucked string instrument"] | ["low quality recording", "metal song", "distortion guitar", "multiple guitars", "bassline", "power drumming", "male voice", "out of time guitar", "moderate tempo"] | 0 | dVUgd8ot6BE | 3794 | |
Jimi Hendrix - The Wind Cries Mary (w/Solo) - Blues/Rock Guitar Cover | This slow rock song features a male voice singing the main melody. This song starts off with a guitar playing hammer ons over three chords. The main part of the song starts off after this sequence. It starts off with a drum roll and a pentatonic run on the guitar. The voice comes in after the roll and the bass starts playing with the voice. The bass plays the root notes of the chords. The voice sings an emotional line. This song can be played in a movie based on the hippie culture. | 2013-11-28T20:01:28Z | GuitarForceCovers | Support me on PATREON - https://www.patreon.com/user?u=2903854&ty=h Hey, guys! This is a cover of a beautiful song by Jimi Hendrix - The Wind Cries Mary. Simple, but very unique song, the solo is just amazing. You can tell so much with just few notes. Jimi was just unique musician, human (although I'm not sure :) and a guitarist. Enjoy this cover! Watch in HD! A lesson on this song can be found HERE - https://www.youtube.com/watch?v=1L4TvB-5-cI and lesson on the Solo HERE - https://www.youtube.com/watch?v=CyKJeroyPnM | ["Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | ["slow rock", "electric guitar", "male voice", "simple percussion", "bass guitar", "moderate tempo", "emotional voice"] | 0 | fYvUB-qy4IM | 3959 |
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;