musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "reverb" and musiccaps_author = 3 sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- reverb · 3 ✖
- live performance 2
- acoustic guitar 1
- acoustic guitar arpeggio 1
- arabic inspired 1
- atmospheric sustained synth pad 1
- ballad 1
- dance 1
- electric guitar riff 1
- energetic 1
- ethereal female vocal 1
- flamenco guitarists 1
- harpsichord 1
- intricate rock electric guitar 1
- kick drum 1
- latin american music 1
- mellow 1
- nylon string guitar 1
- open-mouthed humming 1
- percussive chime 1
- traditional middle eastern music 1
- tube screamer pedal 1
- upbeat 1
- vocables 1
musiccaps_names (array) 11 ✖
- Music 3
- Chant 1
- Flamenco 1
- Folk music 1
- Guitar 1
- Harmonic 1
- Musical instrument 1
- Plucked string instrument 1
- Singing 1
- Theme music 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Epiphony- Mr Charming (Deep Harmonic Remix 2010) | The main element of the clip is an electric guitar with reverb and a tube screamer pedal. The guitarist plays an intricate lick and there seems to be some kind of piano or harpsichord as the backing instrument. There is also a synth pad which made the song feel a little transcendental. | 2010-05-05T14:25:34Z | DeepHarmonic | Free Dawnload link : http://www24.zippyshare.com/v/70567478/file.html Deep Harmonic fan page on facebook: http://www.facebook.com/DeepHarmonic | ["Theme music", "Music", "Harmonic"] | ["electric guitar riff", "reverb", "intricate rock electric guitar", "tube screamer pedal", "atmospheric sustained synth pad", "kick drum", "harpsichord"] | 3 | 6Ig6zwBn4b4 | 741 | |
Rasulullah - The Malay Chanting Group | This is a live performance of what sounds like a Middle Eastern. The female singer has a calm and soothing voice which she uses to sing vocables - or open mouthed humming. There are percussive chimes, and an acoustic guitar arpeggio which adds to the calm and soothing feel of the song. | 2014-09-11T13:42:13Z | Che Mat Merah Muda | sejuk nya qalbu... by Iman Farrar | ["Singing", "Chant", "Music", "Vocal music"] | ["live performance", "traditional middle eastern music", "open-mouthed humming", "vocables", "arabic inspired", "ethereal female vocal", "reverb", "ballad", "mellow", "percussive chime", "acoustic guitar arpeggio"] | 3 | AobHGHJSd-s | 1172 | |
Faraon - Flamenco Rumba_20/11/2011@Barceloan | This is a recording of two flamenco guitarists playing a captivating latin american rhythm. It's upbeat and suitable for dancing. The one guitarist strums chords in the percussive flamenco style, while the other guitarist plays flamenco lead with arpeggios and licks. The performance is live and outside. There is reverb applied to the lead guitar. Both are playing on nylon strings. | 2011-11-24T17:50:51Z | Julian Kan | Spanish Guitar - Adrian Roman & Martin Sazandeh's performance at Cathedral, Gothic Quarter, Barcelona | ["Folk music", "Flamenco", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["live performance", "flamenco guitarists", "acoustic guitar", "nylon string guitar", "latin american music", "upbeat", "energetic", "dance", "reverb"] | 3 | KChjW89XOF0 | 2064 |
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;