musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "male voice" and musiccaps_aspects contains "slow rock" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- male voice · 3 ✖
- slow rock · 3 ✖
- moderate tempo 2
- simple percussion 2
- acoustic guitar 1
- bass guitar 1
- double bass 1
- drums 1
- electric guitar 1
- emotional voice 1
- guitar 1
- guitar lead 1
- live recording 1
- low quality music 1
- pop rock 1
- reverb guitar 1
- romantic theme 1
- simple bass 1
- slow tempo 1
- vocal harmony 1
musiccaps_names (array) 10 ✖
- Music 3
- Guitar 2
- Chorus effect 1
- Electric guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Pop music 1
- Song 1
- Soul music 1
- Tick 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Deer Tick 10-18-2007 Ashamed 1/10 | This song is a low quality live recording of a performance. This features a male voice singing the main melody. At the end of the song, other voices sing with the main voice in harmony. This is accompanied by an electric guitar plucking chords. The double bass plays the root notes of the chords. The percussion plays the cymbal, increasing volume slowly, giving it a swell feel. The mood of the song seems romantic. | 2007-10-22T00:17:05Z | vincenz7 | Live @ Cakeshop. CMJ's. Unfortunately it got cut 1 1/2 minutes into the song. But check out the rest of the show! | ["Electric guitar", "Guitar", "Music", "Tick"] | ["live recording", "male voice", "slow rock", "guitar", "double bass", "drums", "low quality music", "romantic theme", "vocal harmony", "moderate tempo"] | 0 | P90rFZQFqWk | 2510 | |
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 | |
Idiot Wind - Find The Rhythm In The Noise | This pop rock song features a male voice. This is accompanied by percussion playing a simple beat in common time. A lead guitar with heavy reverb plays a fill in between lines. An acoustic guitar strums chords in the background. A bass plays the root notes of the chords. The mood of this song is romantic. This song is played at a slow tempo. This song can be played in a retro romantic movie. | 2013-01-20T19:47:00Z | Paul Martin | http://www.idiotwind.se/se Amanda Bergman is a Swedish singer-songwriter. She performs under the stage name Idiot Wind and has also performed as Hajen and Jaw Lesson Bergman co-wrote the score for the Swedish movie En Gång Om Året (Once A Year). | ["Music", "Pop music", "Song", "Soul music"] | ["slow rock", "pop rock", "male voice", "guitar lead", "simple percussion", "slow tempo", "simple bass", "acoustic guitar", "reverb guitar"] | 0 | BjAL68IMlp0 | 1281 |
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;