musiccaps_details (view)
2 rows where musiccaps_names = "["Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument"]", musiccaps_names contains "Plucked string instrument" and musiccaps_names contains "Speech"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
16. Tipos de Guitarra | This music is instrumental. The tempo is medium with an electric guitar harmony. The music is a catchy riff with a male voice speaking in a foreign language. This clip is an electric guitar lesson/ tutorial. | 2009-07-17T04:08:27Z | iBeriano93 | 16/17 Clinica Angel Parra 16/ Tipos de Guitarra sl2! | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument"] | ["instrumental", "medium tempo", "electric guitar", "male voice speaking", "electric guitar lesson", "amplified instrument", "stringed instrument", "electric guitar tutorial", "catchy riff"] | 7 | YBbvQ0RPrG8 | 3264 | |
Joe Bonamassa Inspired Guitar Lick - Blues Rock Guitar Lessons - Speed Building | This is the recording of a guitar lesson video. There is a male instructor first performing the tune and then describing what he is playing. The tune is being played on a clean sounding electric guitar and there is a blues feel to it. The atmosphere is easygoing. The parts the male voice is not heard can be sampled for use in beat-making. | 2011-06-01T23:23:19Z | GuitarJamz | My Technique and review channel http://www.youtube.com/youcanlearnguitar Joe Bonamassa Inspired Guitar Lick - Blues Rock Guitar Lessons - Speed Building Excercise marty schwartz lesson against rise electric metal picking steve play "guitar lesson" chords gilbert sweep improvisation guitarist solos beginner learn acoustic tab jazz scales jam instrumental guitars "electric guitar" minor classical "guitar lessons" | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument"] | ["guitar lesson", "male voice", "electric guitar", "clean sound", "blues", "easygoing"] | 9 | YDh36ZdneAU | 3266 |
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;