musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "slow tempo", musiccaps_names contains "Chorus effect" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- slow tempo · 3 ✖
- pleasant 2
- amateur recording 1
- amplified guitar 1
- amplifier 1
- background music 1
- distortion tones 1
- e-guitar 1
- echoes 1
- electric guitar 1
- electric guitar lead and harmony 1
- guitar instrumental 1
- guitar lead 1
- guitar pedal test 1
- guitar pedal tones 1
- guitar solo 1
- instrumental 1
- instrumental music 1
- male voice talking 1
- minimalist 1
- music demo 1
- nostalgic 1
- pedal 1
- poor audio quality 1
- popular song 1
- powerful music 1
- relaxing 1
- soft 1
- soloist 1
- sonic power 1
- stringed instrument 1
musiccaps_names (array) 10 ✖
- Chorus effect · 3 ✖
- Guitar 3
- Music 3
- Musical instrument · 3 ✖
- Plucked string instrument 3
- Distortion 2
- Effects unit 2
- Reverberation 2
- Echo 1
- Electric guitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chorus pedal comparison CMATMODS Analog Chorus and Analogman Standard | This audio contains a male voice talking rather than playing an e-guitar with a chorus effect. This audio may be playing for a sound tutorial/comparison. | 2010-09-25T01:47:55Z | gearmanndude | http://www.buyanalogman.com and http://www.cmatmods.com By request, a compare video of the two killer chorus pedals | ["Reverberation", "Echo", "Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion"] | ["amateur recording", "male voice talking", "e-guitar", "slow tempo"] | 6 | 6QAZJ4H_5rA | 754 | |
ZCAT Q-MOD Pedal | The song is an instrumental. The song is medium tempo with an electric guitar playing a pleasant solo with a pedal affecting its tone. The song is a guitar effects demo. The song audio quality is poor. | 2010-09-13T19:45:04Z | ZCAT Pedals | http://zcatpedals.com/?dir=view&id=20090818194445xiVC Q-Mod is a digital multi-effects processor featuring Chorus, Flanger, Phaser, Tremolo and Reverb. | ["Reverberation", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion"] | ["amplifier", "pedal", "guitar solo", "slow tempo", "poor audio quality", "echoes", "relaxing", "guitar instrumental", "background music", "music demo", "guitar pedal test", "electric guitar", "guitar lead", "distortion tones", "pleasant", "instrumental music", "slow tempo", "guitar pedal tones", "soloist"] | 1 | W58kioYp1Ms | 3062 | |
Hotel California - the Eagles Full Guitar with backing track www.Farhatguitar.com | This music is an electric guitar instrumental. The tempo is slow with an electric guitar lead and harmony of a popular song. No other instrument is used. It is mellow, pleasant, nostalgic, soft , mellifluous and soothing. | 2011-01-11T16:31:38Z | Farhat Guitar | TAB http://farhatguitar.com/lessons/the-eagles-hotel-california/ My Music http://elgranojorojo.com/Siento_Y_Presiento_EGOR_2015.zip FB: http://www.facebook.com/FarhatGuitarOfficial Twitter:http://twitter.com/FarHatGuitar FB my Band: https://www.facebook.com/ElGranOjoRojo Spotify : https://open.spotify.com/artist/3nc5PxwNs1zAYVnxahfjoX Old Music: http://goo.gl/2T3YfX See you Marcos Farhat | ["Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | ["instrumental", "slow tempo", "electric guitar lead and harmony", "popular song", "minimalist", "pleasant", "nostalgic", "amplified guitar", "powerful music", "sonic power", "stringed instrument", "soft", "pleasant"] | 7 | uQTCfT5XDzQ | 5112 |
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;