musiccaps_details (view)
4 rows where musiccaps_aspects contains "gentle", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "mellow"
This data as json, CSV (advanced)
musiccaps_aspects (array) 51 ✖
- gentle · 4 ✖
- instrumental · 4 ✖
- mellow · 4 ✖
- slow tempo 3
- beautiful 2
- western classical 2
- acoustic drums 1
- acoustic guitar 1
- acoustic guitar melody 1
- ambient music 1
- atmospheric 1
- bow shaped harp 1
- brushes 1
- calming 1
- captivating 1
- cascading melody 1
- celestial 1
- chordophone 1
- classical 1
- classical music 1
- clear 1
- dreamy 1
- emotional 1
- ethereal 1
- euphonious 1
- flowing 1
- full sounding 1
- guitar lead 1
- guitar solo 1
- harp 1
- harp solo 1
- jazz 1
- live performance 1
- mesmerising 1
- minimalist 1
- no singer 1
- oldest instrument 1
- optimistic 1
- piano 1
- plucked string instrument 1
- poor quality 1
- resonating 1
- rich 1
- romantic 1
- saxophone 1
- sharp sound 1
- soothing 1
- string instrument 1
- stringed instrument 1
- strings 1
- upright bass 1
musiccaps_names (array) 12 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Shout to the Lord - American Sign Language | This is a poor quality instrumental piece played in the background of a sign language video. There is an optimistic sounding tune being played by the strings, the piano and the acoustic guitar. The atmosphere is mellow and gentle. Samples from this piece could be lifted to be used in beat-making. | 2010-11-08T21:09:46Z | Ag00dgranma | Class, here is our new song for class. Sorry it took me so long to get it up. Hope you enjoy and happy signing. | ["Echo", "New-age music", "Music"] | ["poor quality", "no singer", "instrumental", "piano", "strings", "acoustic guitar", "gentle", "mellow", "optimistic"] | 9 | -RYtUAsNhF0 | 46 | |
Meschiya Lake and the Little Big Horns-Luck Devil | This is a jazz music piece. There is a saxophone playing a jazzy solo for the melody. There is an upright bass playing in the background. The rhythmic background consists of a slow tempo acoustic drum beat that is played with brushes. The atmosphere is mellow. This piece could be playing in the background of a classy restaurant or a coffee shop. | 2011-03-06T05:41:05Z | raystewification | The Title Track from "Lucky Devil" Duplicated because youtube sucks. | ["Brass instrument", "Saxophone", "Wind instrument, woodwind instrument"] | ["jazz", "instrumental", "saxophone", "upright bass", "acoustic drums", "brushes", "mellow", "gentle", "slow tempo"] | 9 | 9UCLvFqkFxk | 1012 | |
Bach Prelude and Fugue BWV 539 | This music is a beautiful Harp instrumental. The tempo is slow with a mellow, gentle and rich Harp melody. The music is dreamy, cascading, ethereal, soothing, calming and harmonic. This music is a Western Classical Harp Solo. | 2011-01-08T20:54:38Z | cbembia | Caroline Bembia playing Bach's Prelude and Fugue in d minor, transcribed for harp | ["Harp", "Pizzicato"] | ["instrumental", "slow tempo", "harp", "gentle", "mellow", "soothing", "harp solo", "minimalist", "celestial", "ethereal", "beautiful", "calming", "stringed instrument", "plucked string instrument", "classical music", "western classical", "bow shaped harp", "chordophone", "oldest instrument", "full sounding", "clear", "flowing", "dreamy", "resonating", "sharp sound", "cascading melody", "rich"] | 7 | POOu05eUvqE | 2531 | |
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;