musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "soothing" and musiccaps_aspects contains "subtle bass line" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- soothing · 2 ✖
- subtle bass line · 2 ✖
- acoustic guitar session 1
- average audio quality 1
- calming 1
- christian contemporary worship 1
- christian worship song 1
- church 1
- classic guitars music 1
- devotion 1
- emotional 1
- flute melody 1
- gratitude 1
- guitar harmony 1
- home music video 1
- honour 1
- hymn 1
- instrumental music 1
- keyboard harmony 1
- love 1
- male vocalist 1
- medium tempo 1
- melancholic 1
- mellow 1
- moody 1
- nostalgia 1
- pensive 1
- praise and worship 1
- relaxing 1
- reverence 1
- rhythmic acoustic guitar 1
- slow tempo 1
- soft vocals 1
- splits 1
- steady drumming 1
- sunday worship 1
- virtuosos playing 1
musiccaps_names (array) 7 ✖
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 | |
chris tomlin amazing love | A male vocalist sings this soft Christian Worship song. The tempo is medium with a keyboard accompaniment, steady drumming, flute melody, subtle bass line; rhythmic acoustic guitar and soft vocals. The song is a melodious, soothing, prayerful, calm ,contemporary Christian Praise and Worship song. | 2008-09-19T16:22:10Z | floydss1 | worship for you | ["Christian music", "Music"] | ["male vocalist", "medium tempo", "keyboard harmony", "calming", "soothing", "reverence", "devotion", "gratitude", "love", "honour", "steady drumming", "subtle bass line", "flute melody", "mellow", "soft vocals", "praise and worship", "christian worship song", "hymn", "christian contemporary worship", "church", "sunday worship", "rhythmic acoustic guitar"] | 7 | EwoCbcSXlSM | 1601 |
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;