musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "medium tempo" and musiccaps_names contains "Chorus effect"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- electric guitar · 2 ✖
- medium tempo · 2 ✖
- abrupt end 1
- acoustic guitar 1
- amateur 1
- amateur recording 1
- ambient room noises 1
- amplified guitar 1
- average audio quality 1
- boomy 1
- chord progression 1
- chords 1
- emotional 1
- guitar amplifiers 1
- guitar demonstration 1
- guitar lessons online 1
- guitar strumming rhythm 1
- home video 1
- instrumental 1
- instrumental music 1
- live performance 1
- loud 1
- loud feedback 1
- melodic 1
- of static 1
- people talking 1
- sharp 1
- soloist 1
- sonic power 1
- spirited 1
- …
musiccaps_names (array) 10 ✖
- Chorus effect · 2 ✖
- Effects unit 2
- Electric guitar 2
- Music 2
- Musical instrument 2
- Plucked string instrument 2
- Acoustic guitar 1
- Distortion 1
- Guitar 1
- Strum 1
youtube_published (date) 2 ✖
- 2010-11-01 1
- 2011-10-24 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 | |
Danelectro FAB Chorus D 5 | This music is an electric guitar instrumental. The tempo is medium with a loud and energetic riff . The audio quality is inferior as it is a Home recording ,which is why the music is boomy and there are sounds of people talking in the background and some static. | 2010-11-01T07:01:01Z | musicnbooksdotcom | ["Effects unit", "Electric guitar", "Acoustic guitar", "Music", "Musical instrument", "Chorus effect", "Strum", "Plucked string instrument", "Distortion"] | ["acoustic guitar", "instrumental", "medium tempo", "static", "abrupt end", "string instrument", "chords", "chord progression", "vibrations", "sonic power", "loud feedback", "boomy", "people talking", "electric guitar", "amplified guitar", "amateur", "melodic", "of static", "loud", "sharp", "amateur recording", "home video"] | 7 | bqvl7IbPteU | 3659 |
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;