musiccaps_details (view)
5 rows where musiccaps_aspects contains "melancholy" and musiccaps_aspects contains "pensive"
This data as json, CSV (advanced)
musiccaps_aspects (array) 75 ✖
- melancholy · 5 ✖
- pensive · 5 ✖
- slow tempo 5
- emotional 3
- instrumental 3
- nostalgic 3
- sentimental 3
- soft 3
- male vocalist 2
- mellow 2
- poignant 2
- sad 2
- acoustic bass 1
- acoustic guitar 1
- ambient piano 1
- amplified guitar 1
- applied guitar 1
- banjo 1
- bluegrass 1
- blues 1
- bow stringed instruments 1
- captivating 1
- cello 1
- classical music 1
- clear 1
- country folk songs 1
- country hits 1
- country music 1
- deep sound 1
- drum machine 1
- electric guitar harmony 1
- electric guitar lead 1
- electric guitar melody 1
- electric guitar solo 1
- emphatic 1
- engaging 1
- enthralling 1
- euphonious 1
- fiddle 1
- folk lyrics 1
- hard rock 1
- heavy metal 1
- hillbilly music 1
- loud 1
- loud feedback 1
- love song 1
- low pitch 1
- melodic 1
- metal 1
- minimalist 1
- movie soundtrack 1
- movie theme music 1
- old-time country rock 1
- orchestra 1
- pop 1
- r&b 1
- regional music 1
- resounding 1
- rich 1
- rock 1
- simple melody 1
- smooth jazz 1
- soft rock 1
- sombre 1
- sonic power 1
- soul 1
- story telling 1
- string instrument 1
- string instruments 1
- vibrant 1
- viola 1
- violin symphony 1
- violins 1
- western classical 1
- youthful 1
musiccaps_names (array) 13 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"Czardash" by Monty played on violin and contrabas | This music is a western classical instrumental. The tempo is slow with a cello solo. The music is soft, rich, deep, mellow, euphonious, pensive, melancholic, emotional and sentimental. | 2008-03-19T19:06:45Z | am1musica | The famouse " Czardash" by Monty - played this fantastic way with violin and contrabas :-) I really enjoyed this such original performace, hope you all can enjoy it, too... Maxim Vengerov was born in the Western Siberian capital of Novosibirsk in 1974. I was at one of his house concerts some years ago in Belgium and since then I find he is the best violin player between the young generation violinists. Hope you enjoy this very original and enjoyable video as much as I do :DDDD | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["instrumental", "slow tempo", "orchestra", "violin symphony", "pensive", "melancholy", "nostalgic", "soft", "cello", "viola", "violins", "string instruments", "bow stringed instruments", "melodic", "euphonious", "fiddle", "deep sound", "rich", "vibrant", "low pitch", "western classical", "classical music", "engaging", "captivating", "enthralling"] | 7 | 0nk7utNkHOY | 209 | |
ne-yo why does she stay | A male vocalist sings this emotional R&B song. The tempo is slow with a melancholic piano accompaniment with drum machine arrangement. The song is an emotional , soulful, pensive, sentimental,melancholic, romantic love song. This song is a Soul/R&B. | 2008-09-25T21:35:05Z | X-tazi | ne-yo why does she stay from the new album-Year Of The Gentleman | ["Music", "Tender music"] | ["male vocalist", "slow tempo", "soft", "mellow", "minimalist", "smooth jazz", "blues", "sad", "poignant", "ambient piano", "drum machine", "soul", "r&b", "love song", "pensive", "melancholy", "nostalgic", "emotional", "sentimental"] | 7 | C-1i2GlbiIY | 1313 | |
Sam Stone - John Prine | A male vocalist sings this melancholic country song. The tempo is slow with acoustic guitar lead and harmony with another string instrument accompanying. The song is soft, mellow, sad, pensive, melancholic and poignant with a sweet , pleasant melody. This song is a Classic Country song. | 2009-12-03T02:53:38Z | HouseOBVIOUSLY | Classic John Prine right here. | ["Folk music", "Music"] | ["male vocalist", "slow tempo", "acoustic guitar", "simple melody", "hillbilly music", "banjo", "old-time country rock", "folk lyrics", "country music", "bluegrass", "country hits", "regional music", "country folk songs", "acoustic bass", "mellow", "soft", "sentimental", "nostalgic", "pensive", "melancholy", "story telling"] | 7 | Sl9ZkYViEIs | 2787 | |
Zajdi Zajdi by Muris Varajic - AxeFx Ultra Demo | This music is an electronic guitar instrumental. The tempo is slow with a melancholic , resounding harmony on the guitar. It is mellow, soft, poignant, sentimental and emotional. | 2010-01-19T11:12:22Z | Muris Varajic | http://marketplace.live4guitar.com/instructor/Muris_Varajic/lessons A quick demo of AxeFx Ultra showing its great effects and dynamics. Do not mind the tone, I just used factory preset with clean amp and I changed it to some more distorted amp, you can dial pretty much every tone out there using AxeFX. And yeah, tune is called Zajdi Zajdi, a wonderful macedonian song, hope you'll enjoy it. :) | ["Echo", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Inside, small room"] | ["instrumental", "slow tempo", "electric guitar harmony", "electric guitar solo", "electric guitar lead", "amplified guitar", "loud", "emphatic", "resounding", "sonic power", "loud feedback", "rock", "hard rock", "metal", "heavy metal", "soft rock", "pop", "youthful", "pensive", "melancholy", "sentimental", "emotional"] | 7 | _0-2meOf9qY | 3435 | |
RAMBO: FIRST BLOOD Theme ( 1 of 2 ) Guitar Lesson | This music is instrumental. The tempo is slow with an electric guitar harmony. It is mellow, sad, sentimental,sombre, poignant and emotional. This music is a movie theme melody. | 2010-01-30T17:12:46Z | Guitar Lessons BobbyCrispy | TABS FOR THIS LESSON AVAILABLE ON MY NEW GUITAR LESSON WEBSITE: https://guitarlessonvideoswithtabs.yolasite.com/RAMBO---FIRST-BLOOD.php How to play the theme from the movie Rambo: First Blood. Guitar lesson with step by step method with easy to follow tabs in the video. TABS for this lesson available on my guitar lesson website: http://bobsguitarlessons.yolasite.com/ Part 2 of 2 http://youtu.be/qBD6b3oouaw E-------------9----12------12--11--------------------- B----7--9------------------------------14---9----12--- G---------------------------------------------------------- D---------------------------------------------------------- A---------------------------------------------------------- E---------------------------------------------------------- E------------------------------------------------------------- B----14--12----12----7---9----10-----10--12----7--- G------------------------------------------------------------- D------------------------------------------------------------- A------------------------------------------------------------- E------------------------------------------------------------- E-------------9----12------12--11--------------------- B----7--9------------------------------14---9----12--- G---------------------------------------------------------- D---------------------------------------------------------- A---------------------------------------------------------- E---------------------------------------------------------- E---------------------------------------------------------------- B----9--12---12----7----7----9---10------5--7-----9---- G---------------------------------------------------------------- D---------------------------------------------------------------- A---------------------------------------------------------------- E---------------------------------------------------------------- E--------9---9--------------14--12---9--10---9------------------------- B----9-------------12---------------------------------12----7----5--7--- G---------------------------------… | ["Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | ["instrumental", "slow tempo", "electric guitar melody", "sombre", "emotional", "pensive", "movie soundtrack", "movie theme music", "clear", "string instrument", "applied guitar", "sad", "melancholy", "poignant", "pensive"] | 7 | jjNxc9Zf9s8 | 4277 |
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;