musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "medium tempo", musiccaps_author = 1, musiccaps_names contains "Effects unit" and musiccaps_names contains "Electric guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- medium tempo · 3 ✖
- emotional 2
- guitar amplifier 2
- instrumental music 2
- poor audio quality 2
- ambient room noises 1
- amplifier knob flicks 1
- arpeggio playing 1
- average audio quality 1
- bas audio quality 1
- different tone settings 1
- echo tones 1
- electric guitar 1
- electric guitar lead 1
- electric guitar playing 1
- exciting 1
- guitar amplifiers 1
- guitar demonstration 1
- guitar lessons online 1
- guitar licks 1
- guitar strumming rhythm 1
- guitar test demo 1
- guitar tone test demo 1
- guitar tones 1
- home music video 1
- live performance 1
- loud music 1
- melancholic 1
- music demo 1
- no other instrumentation 1
- …
musiccaps_names (array) 10 ✖
- Effects unit · 3 ✖
- Electric guitar · 3 ✖
- Music 3
- Chorus effect 2
- Guitar 2
- Blues 1
- Distortion 1
- Echo 1
- Musical instrument 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 |
---|---|---|---|---|---|---|---|---|---|---|
ジャズコーラスの音色とマーシャルガバナーの威力 | The song is an instrumental. The song is medium tempo with an electric guitar playing chords and strumming rhythm with no other instrumentation. The song is emotional and interesting. The song is probably a demo of a guitar or guitar amplifier. The audio is average quality. | 2011-10-24T16:02:01Z | yskpai81 | ガバナー大好き。 http://mixi.jp/view_diary.pl?id=1786483877&owner_id=11016145 ↑これです。昔は四角い形だったのに、今は流線型のボディになってます。 音は昔の方が良かったような気がします。 | ["Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | ["electric guitar", "strumming chords", "virtuoso", "guitar lessons online", "guitar strumming rhythm", "guitar amplifiers", "guitar demonstration", "live performance", "youtube music video", "average audio quality", "medium tempo", "instrumental music", "emotional", "spirited", "soloist", "ambient room noises"] | 1 | 2xATintzaj4 | 420 | |
Strymon Mobius vs Donner Tutti Love Chorus | The song is an instrumental. The song is medium tempo with an amplified guitar playing lead with different tone settings. The song is melancholic and more of a demo play. The song has poor audio quality. | 2015-01-11T21:59:57Z | shnobel | Find great deals on these pedals on Reverb.com Click Here https://reverb.com/marketplace?utm_source=shnobel&query=Strymon+Mobius &_aid=shnobel Strymon Mobius vs Donner Tutti Love Chorus | ["Effects unit", "Electric guitar", "Guitar", "Music", "Chorus effect"] | ["electric guitar playing", "medium tempo", "poor audio quality", "melancholic", "music demo", "different tone settings", "arpeggio playing", "guitar tones", "instrumental music", "guitar test demo", "bas audio quality", "wobbly notes", "no other instrumentation", "no percussion instruments", "guitar amplifier", "slow tempo"] | 1 | BjqhHeJD28U | 1283 | |
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;