musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "guitar demonstration" and musiccaps_names contains "Guitar" sorted by youtube_published
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 32 ✖
- guitar demonstration · 2 ✖
- guitar lessons online 2
- instrumental music 2
- soloist 2
- youtube music video 2
- ambient room noises 1
- average audio quality 1
- booming bass line 1
- electric guitar 1
- electric guitar player 1
- emotional 1
- excited 1
- exciting 1
- groovy 1
- groovy music 1
- guitar amplifiers 1
- guitar licks 1
- guitar solo 1
- guitar strumming rhythm 1
- guitarist 1
- inspiring 1
- live performance 1
- medium fast tempo 1
- medium fats tempo 1
- medium tempo 1
- passionate 1
- positive 1
- riffs 1
- spirited 1
- strumming chords 1
- strumming rhythm 1
- virtuoso 1
musiccaps_names (array) 9 ✖
- Guitar · 2 ✖
- Music 2
- Musical instrument 2
- Plucked string instrument 2
- Chorus effect 1
- Effects unit 1
- Electric guitar 1
- Inside, small room 1
- Reverberation 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bill Lawrence "Wilde" L-45 pickups | The song is an instrumental. The song is medium tempo with an electric guitar playing guitar riffs with a nice low end; The audio quality is average. The song is passionate and exciting. | 2010-06-03T01:03:09Z | Flagrant Potato | Playing starts at 2:25. Quick sound test of the Bill and Becky "Wilde" L-45 strat pickups in my Warmoth guitar. Alnico V magnets, dual rail pole pieces (flat). Guitar is 1pc alder body with a goncalo alves neck and ebony fretboard. Guitar is plugged straight into a Yamaha Fifty (G50) 410 combo and was recorded with an active dual-ribbon mic. | ["Reverberation", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Inside, small room"] | ["electric guitar player", "guitarist", "riffs", "guitar licks", "passionate", "exciting", "guitar lessons online", "soloist", "youtube music video", "guitar demonstration", "excited", "positive", "medium fast tempo", "groovy music", "inspiring", "inspiring", "guitar solo", "medium fats tempo", "strumming rhythm", "groovy", "booming bass line", "instrumental music"] | 1 | Ta0GmXPnGWk | 2847 | |
ジャズコーラスの音色とマーシャルガバナーの威力 | 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 |
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;