musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "emotional", musiccaps_aspects contains "passionate" and musiccaps_names contains "Blues"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- emotional · 4 ✖
- passionate · 4 ✖
- low quality 2
- medium tempo 2
- acoustic guitar accompaniment 1
- acoustic guitar melody 1
- alternative metal 1
- alternative rock 1
- ambient sounds 1
- amplifier knob flicks 1
- auditorium acoustics 1
- blues 1
- cover 1
- echo tones 1
- electric guitar lead 1
- electric guitar solo melody 1
- exciting 1
- groovy bass 1
- guitar amplifier 1
- guitar licks 1
- guitar tone test demo 1
- home music video 1
- live performance 1
- loud music 1
- love song 1
- male vocalist 1
- mellow snare 1
- minimalist 1
- muffled 1
- muted acoustic guitar melody 1
- …
musiccaps_names (array) 8 ✖
- Blues · 4 ✖
- Music 4
- Country 1
- Distortion 1
- Echo 1
- Effects unit 1
- Electric guitar 1
- Guitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Cacophony The Ninja cover) | The low quality recording features a cover of a rock song with a rock instrumental playback playing in the background and electric guitar solo melody playing on top of it. It sounds muffled and noisy, as it was probably recorded with a low quality microphone, but it is still passionate and emotional. | 2013-05-19T04:18:09Z | Andres thunder | Humilde tributo a la legendaria banda CACOPHONY ( Jason becker / Marty Friedman ) Guitarras Camilo Henriquez Andres Caucao | ["Blues", "Guitar", "Music"] | ["low quality", "noisy", "muffled", "electric guitar solo melody", "cover", "rock instrumental playback", "passionate", "emotional"] | 4 | -Umconw-CRE | 51 | |
Ryszard Riedel i Nocna Zmiana Bluesa - Hotelowy Blues | The low quality recording features a blues song that consists of a passionate male vocal singing over acoustic guitar melody in the left channel, muted acoustic guitar melody in the right channel of the stereo image, groovy bass, mellow snare and shimmering cymbals. It sounds passionate and emotional. | 2008-01-12T15:37:19Z | paweuek92 | Fajny kawałek :) | ["Blues", "Country", "Music"] | ["low quality", "poor quality mix", "blues", "passionate male vocal", "acoustic guitar melody", "muted acoustic guitar melody", "groovy bass", "mellow snare", "shimmering cymbals", "passionate", "emotional"] | 4 | 9Rx57dlJtIA | 1008 | |
Breaking Benjamin Burnley GIVE ME A SIGN House of Blues Atlantic City, NJ 7/10/10 | A male vocalist sings this passionate song. The tempo is slow with emphatic vocals and an acoustic guitar accompaniment. The song is melodic, emotional,sentimental, passionate,pensive, reflective and deep. This song is Alternative Rock. | 2010-07-11T17:28:56Z | Christopher Kline | Ben Burnley of Breaking Benjamin performed a solo acoustic show at The House of Blues in Atlantic City, NJ on July 10th. Joining him onstage playing guitar and providing backup vocals was Aaron Bruch of Ourafter. | ["Blues", "Music"] | ["male vocalist", "medium tempo", "rock", "alternative rock", "alternative metal", "acoustic guitar accompaniment", "minimalist", "live performance", "ambient sounds", "auditorium acoustics", "romantic", "love song", "passionate", "emotional", "sentimental"] | 7 | 9ogEGxsJcSY | 1043 | |
Owen Barry , Vertex Effects Landau stereo chorus, Victoria | The song is an instrumental. The song is medium tempo with an amplified guitar solo lead, complete with knob flicking tones. The song is loud and energetic. The audio quality is poor and recorded live at home. | 2014-06-11T21:10:50Z | owen barry | ["Blues", "Echo", "Effects unit", "Electric guitar", "Music", "Distortion"] | ["electric guitar lead", "poor audio quality", "rock solo", "guitar amplifier", "home music video", "guitar tone test demo", "medium tempo", "rock guitar lead", "tremolo tones", "echo tones", "amplifier knob flicks", "loud music", "emotional", "passionate", "exciting", "medium tempo", "guitar licks"] | 1 | R4b_-IT43P4 | 2663 |
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;