musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "blues", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- blues · 3 ✖
- medium tempo · 3 ✖
- rock · 3 ✖
- electric guitar 2
- instrumental 2
- jazz 2
- loud 2
- powerful 2
- amplified guitar 1
- amplified guitar 1
- bitter 1
- blues-rock 1
- blues-rockvigorous electric guitar 1
- breakup 1
- catchy riff 1
- clear 1
- country 1
- crisp 1
- demonstration 1
- dense 1
- depressed 1
- edgy 1
- electric guitar lead 1
- electric guitar lesson 1
- electric guitar solo 1
- electric guitars 1
- empahtic 1
- external amplification 1
- groovy 1
- groovy bass line 1
- …
musiccaps_names (array) 10 ✖
youtube_published (date) 3 ✖
- 2006-08-08 1
- 2013-03-03 1
- 2016-08-01 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Joe Bonamassa - "Blues of Desperation" - Official Music Video | A male vocalist sings this emphatic rock. The tempo is medium with vigorous electric guitar, synthesiser arrangement, groovy bass line and intense drumming. The vocals are soft ,sad, lonely, poignant, mellow, and melodic in contrast to the intense instrumentation. This song is Blues-Rock. | 2016-08-01T14:41:20Z | JoeBonamassaTV | ► STREAM JOE NOW: https://jbonamassa.com/streaming/ ► FREE ALBUM DOWNLOAD - http://goo.gl/9oI018 ● Official Tickets ● http://jbonamassa.com/tour-dates/ ● Official Social Links ● https://www.facebook.com/JoeBonamassa https://twitter.com/jbonamassa https://instagram.com/joebonamassa/ https://www.pinterest.com/jbonamassa/ ● Official Merchandise ● http://shop.jbonamassa.com/ | ["Blues", "Music"] | ["male singer", "medium tempo", "sad", "depressed", "heart break", "blues-rock", "vigorous electric guitar riff", "breakup", "hurt", "poignant", "bitter", "lonely", "blues-rockvigorous electric guitar", "synthesiser arrangement", "blues", "rock", "groovy bass line", "intense drumming"] | 7 | 6JJMlY3Go9s | 743 | |
C Harmonic Minor with a G Phrygian Ending | This music clip is an electric guitar solo lead instrumental. The tempo is fast with the guitarist playing a very emphatic, intense riff. No other instruments have been used. The music is loud, intense, engaging and catchy. | 2006-08-08T20:49:22Z | ahmedgarcia | C harmonic Minor with a G Phrygian ending. | ["Effects unit", "Electric guitar", "Music", "Harmonic", "Distortion"] | ["electric guitar", "instrumental", "string instrument", "external amplification", "vibrations", "skilful", "pop", "jazz", "country", "blues", "heavy metal", "lead instrument", "medium tempo", "sonic power", "amplified guitar", "melodious", "minimal instrumentation", "rock", "hard rock", "intense", "loud", "powerful"] | 7 | kaabXWuPWRg | 4332 | |
The Jim Kelley Reverb amplifier, demo by Pete Thorn | This music is an electric guitar instrumental. The tempo is medium with a smooth electric guitar lead harmony. The music is clear, emphatic, smooth, groovy, youthful, crisp, edgy and dominant. | 2013-03-03T20:58:20Z | Pete Thorn | An in-depth look at the Kelley Reverb head, built by J.S. Technologies Check out Pete Thorn's "Guitar Nerd" album at CDbaby.com and iTunes: http://www.cdbaby.com/cd/petethorn https://itunes.apple.com/us/artist/pete-thorn/id437846702 | ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | ["instrumental", "electric guitars", "medium tempo", "demonstration", "tutorial", "learning electric", "electric guitar lesson", "clear", "loud", "powerful", "empahtic", "amplified guitar", "electric guitar", "stringed instrument", "loud feed back", "blues", "rock", "jazz", "resonating", "reverb", "youthful", "groovy", "catchy riff", "smooth", "electric guitar lead", "electric guitar solo", "dense", "rich", "crisp", "edgy"] | 7 | ouVuF-y8bog | 4664 |
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;