musiccaps_details (view)
1 row where musiccaps_aspects contains "bass guitar", musiccaps_aspects contains "slow rock", musiccaps_names contains "Musical instrument" and musiccaps_names contains "Plucked string 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 |
---|---|---|---|---|---|---|---|---|---|---|
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;