musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "medium tempo", musiccaps_author = 1, musiccaps_names contains "Chorus effect" and musiccaps_names contains "Electric guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- instrumental music 2
- medium tempo · 2 ✖
- ambient room noises 1
- arpeggio playing 1
- average audio quality 1
- bas audio quality 1
- different tone settings 1
- electric guitar 1
- electric guitar playing 1
- emotional 1
- guitar amplifier 1
- guitar amplifiers 1
- guitar demonstration 1
- guitar lessons online 1
- guitar strumming rhythm 1
- guitar test demo 1
- guitar tones 1
- live performance 1
- melancholic 1
- music demo 1
- no other instrumentation 1
- no percussion instruments 1
- poor audio quality 1
- slow tempo 1
- soloist 1
- spirited 1
- strumming chords 1
- virtuoso 1
- wobbly notes 1
- youtube music video 1
musiccaps_names (array) 7 ✖
- Chorus effect · 2 ✖
- Effects unit 2
- Electric guitar · 2 ✖
- Guitar 2
- Music 2
- 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 |
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;