musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "keyboard harmony", musiccaps_author = 1 and musiccaps_names contains "Steel guitar, slide guitar"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) >30 ✖
- keyboard harmony · 2 ✖
- adrenaline rush 1
- amateur playing 1
- amateur rock band 1
- ambient music 1
- casual rock 1
- chill-out music 1
- classic rock influences 1
- d]steady drumming rhythm 1
- dreamy 1
- echo tones 1
- emotional 1
- filler music 1
- groovy bass line 1
- groovy music 1
- guitar lead 1
- guitar skills 1
- guitar solo 1
- high on adrenaline 1
- home recording 1
- instrumental hits 1
- keybiard harmony 1
- medium tempo 1
- modern pop 1
- out of time 1
- relaxing 1
- retro guitar hits 1
- rock guitar solo 1
- rock guitarist 1
- slow tempo 1
- …
musiccaps_names (array) 9 ✖
- Music 2
- Steel guitar, slide guitar · 2 ✖
- Distortion 1
- Electric guitar 1
- Guitar 1
- Musical instrument 1
- New-age music 1
- Plucked string instrument 1
- Rock music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Whammy Bar Phrasing Solo | The song is an instrumental. The tempo is medium with an electric guitar playing a dreamy solo with a keyboard accompaniment , string section harmony and rhythmic percussion rhythm. The song is passionate and emotional. The song is a rock guitar instrumental. | 2011-02-03T00:16:18Z | gmcguitar | Breathtaking solo by Piotr Kaczor with tabs and slow illustrations, more: http://www.guitarmasterclass.net/s/youtube-piotr-whammy-bar-2/ls/Whammy-Bar-Phrasing-II/ More Piotr lessons: http://www.guitarmasterclass.net/s/youtube-piotr-whammy-bar-2/instructor/Piotr-Kaczor/ | ["Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["guitar solo", "whammy bar", "keyboard harmony", "steady percussion rhythm", "tremolo", "vibrato", "guitar skills", "rock guitar solo", "dreamy", "emotional", "adrenaline rush", "retro guitar hits", "instrumental hits", "high on adrenaline", "string section accompaniment", "rock guitarist", "soloist", "keybiard harmony", "steady percussion rhythm", "d]steady drumming rhythm", "groovy music", "medium tempo"] | 1 | BqIZipifARo | 1294 | |
Relaxation Music Progressive Rock | The song is an instrumental music piece. The song is slow tempo with an electric guitar playing lead with heavy echoes, steady drumming and a keyboard harmony. The song is casual and slightly out of rhythm. The song is an instrumental with a casual listening vibe. | 2011-10-11T06:06:56Z | Gothenburg Music | Relaxation Music Progressive Rock, Rock jam and improvisation | ["Electric guitar", "New-age music", "Music", "Rock music", "Steel guitar, slide guitar", "Distortion"] | ["slow tempo", "guitar lead", "steady drumming rhythm", "filler music", "relaxing", "home recording", "chill-out music", "modern pop", "classic rock influences", "amateur rock band", "ambient music", "groovy bass line", "echo tones", "relaxing", "out of time", "amateur playing", "keyboard harmony", "casual rock"] | 1 | UrgzGbGVV8I | 2948 |
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;