musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "emotional", musiccaps_aspects contains "slow tempo" and musiccaps_names contains "Strum"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- emotional · 2 ✖
- slow tempo · 2 ✖
- acoustic guitar melody 1
- acoustic guitar session 1
- ambient music 1
- atmospheric 1
- average audio quality 1
- beautiful 1
- captivating 1
- classic guitars music 1
- classical 1
- euphonious 1
- gentle 1
- guitar harmony 1
- guitar lead 1
- guitar solo 1
- home music video 1
- instrumental 1
- instrumental music 1
- live performance 1
- melancholic 1
- mellow 1
- mesmerising 1
- moody 1
- nostalgia 1
- pensive 1
- relaxing 1
- romantic 1
- soothing 1
- splits 1
- …
musiccaps_names (array) 7 ✖
- Guitar 2
- Music 2
- Plucked string instrument 2
- Strum · 2 ✖
- Acoustic guitar 1
- Musical instrument 1
- Steel guitar, slide guitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Berceuse - Lullaby | The song is an instrumental. The tempo is slow with a classical guitar playing harmony style with a subtle bass line and no other instrumentation. The song is emotional and relaxing. The audio quality is worth average. | 2009-01-13T21:16:18Z | bernard vdd | Compo perso pour Timeo. Play with a gibson j45. For stereo sound try this link: http://fr.youtube.com/watch?v=jS9u6X6TQmk&fmt=18 | ["Guitar", "Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | ["guitar harmony", "splits", "classic guitars music", "average audio quality", "melancholic", "nostalgia", "soothing", "virtuosos playing", "instrumental music", "subtle bass line", "guitar harmony", "slow tempo", "acoustic guitar session", "home music video", "emotional", "pensive", "moody", "relaxing", "emotional"] | 1 | jS9u6X6TQmk | 4255 | |
Fur Elise on classical guitar performed by Eddie Blatt | This music is instrumental. The tempo is slow with a melodic acoustic guitar solo. The music is soft, euphonious, dreamy, romantic , warm ,ambient and soothing. This is a Classical acoustic instrumental. | 2007-01-23T06:40:15Z | Eddie Blatt | Eddie Blatt plays Fur Elise on classical guitar live at the Byron Bay Community Centre. | ["Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["instrumental", "slow tempo", "acoustic guitar melody", "western classical", "classical", "beautiful", "mellow", "euphonious", "captivating", "mesmerising", "guitar solo", "guitar lead", "string instrument", "live performance", "gentle", "emotional", "atmospheric", "ambient music", "romantic"] | 7 | p2sXdmex3xQ | 4683 |
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;