musiccaps_details (view)
3 rows where musiccaps_aspects contains "emotional" and musiccaps_aspects contains "sombre" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- emotional · 3 ✖
- sombre · 3 ✖
- movie soundtrack 2
- poignant 2
- sad 2
- slow tempo 2
- acoustic guitar 1
- applied guitar 1
- atmospheric 1
- breakup song 1
- clear 1
- dream pop 1
- droning keyboard harmony 1
- electric guitar melody 1
- instrumental 1
- intricate piano motifs 1
- lonely 1
- longing 1
- male singer 1
- melancholy 1
- movie theme music 1
- passionate 1
- pensive 1
- piano melody 1
- pop rock 1
- regretful 1
- sad piano music 1
- sentimental 1
- string instrument 1
- wistful 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
harry & eggsy | all i want | A male vocalist sings this sad melody. The tempo is slow with an acoustic guitar accompaniment and a droning keyboard harmony. The song is soft ,mellow, sad, emotional, sentimental, regretful , lonely and poignant. This song is an Alternative Rock/Indie. | 2015-08-20T05:52:36Z | stoleyourmateria | HARTWIN WEEK: Day 5: angst ----------------------------------------------------------------- (PLEASE WATCH IN HD) this is kind of a companion piece to my hartwin "love love love" fanvid. i had a lot of fun editing this. hope you enjoy the angst! :D ----------------------------------------------------------------- • fandom: kingsman • pairing: harry hart & eggsy unwin • song: "all i want" by kodaline ---------------------------------------------------------------- Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use. | ["Music", "Theremin"] | ["male singer", "slow tempo", "acoustic guitar", "atmospheric", "poignant", "dream pop", "lonely", "pop rock", "longing", "sombre", "breakup song", "passionate", "sad", "wistful", "emotional", "sentimental", "regretful", "wistful", "movie soundtrack", "droning keyboard harmony"] | 7 | gTX4SG70cEY | 4032 | |
Sad Sailor moon Background Music | This is a sad, emotional piano song. Initially, we hear the low pitch and high pitch notes played in unison. The low notes then serve as a bass backing for the treble. The song would suit a sad scene in a movie. | 2007-11-22T22:05:00Z | cuteyhony | beautyful Background music of Sailor moon (wunderschöne und dramatische hintergrundmusik) | ["Music", "Sad music"] | ["sad piano music", "piano melody", "sombre", "emotional", "intricate piano motifs"] | 3 | tOnjlUzqSC4 | 5032 | |
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;