musiccaps_details (view)
2 rows where musiccaps_aspects contains "moderate tempo", musiccaps_aspects contains "simple percussion" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- moderate tempo · 2 ✖
- simple percussion · 2 ✖
- amateur recording 1
- banjo 1
- bass guitar 1
- electric guitar 1
- emotional voice 1
- happy mood 1
- instrumental 1
- male voice 1
- no voices 1
- rock song 1
- slow rock 1
- tambourine 1
- violins 1
musiccaps_names (array) 7 ✖
- Music 2
- Musical instrument · 2 ✖
- Banjo 1
- Bowed string instrument 1
- Chorus effect 1
- Guitar 1
- Plucked string instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Classical Gas by Roy Clark Band Banjo Pickin' 1987 Live | This amateur recording features a rock song. The main melody is played on violins. This is accompanied by percussion playing with breaks matching the breaks in the violin parts. At the end, the violins play a sustained note and a banjo starts to play a melody. A tambourine is played on the first count of the second bar after the banjo starts to play. This is an uptempo song and has a happy feel. This instrumental song can be played in a coffee shop. | 2007-06-12T06:30:56Z | NelnetDude | Enjoy! | ["Banjo", "Music", "Musical instrument", "Bowed string instrument"] | ["amateur recording", "rock song", "instrumental", "no voices", "violins", "banjo", "tambourine", "simple percussion", "happy mood", "moderate tempo"] | 0 | MpWGx5odhh8 | 2301 | |
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;