musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "electric guitar" and musiccaps_aspects contains "simple percussion" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_names (array) 9 ✖
musiccaps_aspects (array) 9 ✖
- bass guitar 2
- electric guitar · 2 ✖
- male voice 2
- moderate tempo 2
- simple percussion · 2 ✖
- country rock 1
- emotional voice 1
- romantic mood 1
- slow rock 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Indie Music Streaming - 6 Years | This country rock song features a male voice singing at a high pitch. This is accompanied by percussion playing a simple beat. A guitar strums chords. The bass guitar plays the root notes of the chords. The mood of this song is romantic. This song can be played in a romantic movie. | 2015-07-09T03:30:11Z | Music Lesson Central | Indie Music Streaming Music Lesson Central - Learn How To Play Music Learn Guitar, Piano, Bass, Drums, Harmonica, and Mandolin | ["Music", "Independent music", "Rock music", "Song", "Progressive rock"] | ["country rock", "male voice", "moderate tempo", "bass guitar", "electric guitar", "simple percussion", "romantic mood"] | 0 | WeDA1mDFSCo | 3120 | |
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;