musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "live performance", musiccaps_aspects contains "slow tempo" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- live performance · 3 ✖
- slow tempo · 3 ✖
- emotional 2
- guitar solo 2
- instrumental 2
- romantic 2
- acoustic drums 1
- acoustic guitar melody 1
- ambient music 1
- ambient room noises 1
- atmospheric 1
- bass guitar 1
- bass solo 1
- beautiful 1
- blues 1
- captivating 1
- christian music 1
- church music 1
- classical 1
- crunchy 1
- devotional 1
- drum brushes percussions 1
- electric guitar 1
- euphonious 1
- fretboard sounds 1
- gentle 1
- groovy 1
- groovy solo 1
- guitar lead 1
- inspiring 1
- …
musiccaps_names (array) 9 ✖
- Music 3
- Musical instrument · 3 ✖
- Guitar 2
- Plucked string instrument 2
- Strum 2
- Bass guitar 1
- Blues 1
- Electric guitar 1
- Wedding music 1
youtube_published (date) 3 ✖
- 2007-01-23 1
- 2009-11-25 1
- 2010-02-05 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
BELLA's LULLABY / RIVER FLOWS IN YOU - Music Video -- NEW VERSION | The song is an instrumental. The song is slow tempo with gentle drum brushes, percussion, bass guitar solo, and piano accompaniment gently. The song is groovy and emotional. The song is possibly a Christian worship song or a smooth jazz song. The audio quality is average. | 2009-11-25T20:46:54Z | peoplewholovenewmoon | A heartbreakingly beautiful performance of this hit song by the Korean composer Yiruma - which is not the official Bella's Lullaby, but proved much more popular with Twilight fans. The version features not just piano but achingly melancholy solos by superb musicians on bass, guitar, sax, and vocals. | ["Bass guitar", "Music", "Musical instrument", "Wedding music"] | ["slow tempo", "drum brushes percussions", "inspiring", "devotional", "romantic", "together forever", "ambient room noises", "poignant", "jazz music", "bass solo", "piano accompaniment", "jazz band", "smooth jazz", "live performance", "church music", "slow tempo", "groovy solo", "emotional", "romantic", "poignant", "inspiring", "motivational", "fretboard sounds", "christian music", "music interlude"] | 1 | 0EOQco76eXQ | 135 | |
Josh Gooch: Guitar Center King of the Blues '09 Finalist | This is the live performance of a blues music piece. It is an instrumental performance. The lead electric guitar is playing a blues solo while another electric guitar and a bass guitar are playing in the background. The rhythmic background consists of a slow tempo blues acoustic drum beat. There is a groovy atmosphere to this performance. This piece could be playing in the background at a rock bar. | 2010-02-05T23:29:42Z | Guitar Center | Guitar Center King of the Blues finalist, Josh Gooch's performance from the GC King of the Blues Grand FInals - Nov 12th, 2009 at the House of Blues Sunset. For more information on Guitar Center or King of the Blues visit www.guitarcenter.com | ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["live performance", "blues", "instrumental", "electric guitar", "guitar solo", "bass guitar", "acoustic drums", "groovy", "crunchy", "slow tempo"] | 9 | 4bXb6GLm6zg | 589 | |
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;