musiccaps_details (view)
3 rows where musiccaps_aspects contains "longing"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Dean Brody - Wildflower | This is a country music piece. There is a fiddle playing the main melody. The acoustic guitar and the electric guitar are playing gently in the background. The song has a slow tempo. The atmosphere is sentimental. This piece can be used in the soundtrack of an American drama movie, especially during the scenes where the feeling of longing is emphasized. | 2010-03-25T14:34:30Z | Dean Brody | ["Country"] | ["country music", "fiddle", "acoustic guitar", "electric guitar", "gentle playing", "slow tempo", "easygoing", "sentimental", "longing"] | 9 | -O9mnfC61Ac | 40 | ||
| Dota heroes sexy | This is a pop rock piece. There is a female vocalist singing melodically at the forefront. The melody is being played by a wide-sounding strings section and an acoustic guitar. The bass guitar is playing the root notes in the background. The rhythmic structure is provided by a simple acoustic drum beat. The song is in minor key. The atmosphere is sentimental and filled with longing. This piece could be included in the soundtrack of a teenage drama movie or TV series. | 2010-02-13T16:45:07Z | elbertjann benitez | the best hero and my favorite hero my favorite is mirana the best hero of me ^^ | ["Christian music"] | ["pop rock", "female vocal", "melodic singing", "strings", "acoustic guitar", "bass guitar", "acoustic drums", "sentimental", "longing", "minor key"] | 9 | 5P5XAclO8ko | 659 | |
| 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 |
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;