musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "medium tempo", musiccaps_names contains "Musical instrument" and musiccaps_names contains "Steel guitar, slide guitar"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 28 ✖
- medium tempo · 2 ✖
- acoustic guitar 1
- adrenaline rush 1
- amateur recording 1
- d]steady drumming rhythm 1
- dreamy 1
- emotional 1
- groovy music 1
- guitar skills 1
- guitar solo 1
- high on adrenaline 1
- higher register singing 1
- instrumental hits 1
- keybiard harmony 1
- keyboard harmony 1
- male voice 1
- melancholy 1
- retro guitar hits 1
- rock guitar solo 1
- rock guitarist 1
- singer-songwriter 1
- soft stomping noise 1
- soloist 1
- steady percussion rhythm 1
- string section accompaniment 1
- tremolo 1
- vibrato 1
- whammy bar 1
musiccaps_names (array) 6 ✖
- Guitar 2
- Music 2
- Musical instrument · 2 ✖
- Plucked string instrument 2
- Steel guitar, slide guitar · 2 ✖
- Acoustic guitar 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 | |
Cours de guitare The sound of silence | Someone is playing acoustic guitar. While a higher pitched male voice is singing a sad song. This is an amateur recording. This song may be playing at home on a rainy day. | 2011-08-06T09:41:42Z | bluesbosse1 | ..des tablatures pour débutants au : www.partition-guitare-tablature.com | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["singer-songwriter", "acoustic guitar", "male voice", "higher register singing", "soft stomping noise", "melancholy", "amateur recording", "medium tempo"] | 6 | DroAzooK4yw | 1514 |
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;