musiccaps_details (view)
1 row where musiccaps_aspects contains "loneliness", musiccaps_aspects contains "melodic", musiccaps_aspects contains "nostalgia" and musiccaps_aspects contains "pensive"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Musica Triste in Eb minor Pianoforte - Sad Music LADY OSCAR arr. by Coski | This music is a mellow instrumental. The tempo is medium with a passionate violin harmony and a simple, sharp piano melody with intense bass lines. The overall mood of the music is deep, sad, lonely, melancholic, nostalgic and poignant and yet beautiful and pleasant. | 2011-07-19T12:20:21Z | JC Piano | SHEET MUSIC/SPARTITO: (9,99 euro) INFO: INFOJCPIANO@GMAIL.COM [ITA] Dal celebre cartone di Lady Oscar ecco la musica sul finale triste di questo fantastico Anime. E' una versione arrangiata da me e fedelissima all'originale. La musica si divide in 2 parti. La prima parte solo Pianoforte e Basso ( musica completa ), e la seconda parte che riprende il tema iniziale ma con l'uso di Celesta, Viola, Basso, Chitarra, Violino e Piano. Lo spartito è in vendita sia in PDF che in versione cartacea. Spedisco lo spartito in versione completa. Si tratta di uno sparito rarissimo ( mai commercializzato al pubblico ). Postate pure le vostre critiche/commenti cosicché possa migliorare le mie perfomance. [ENG] From the famous cartoon of Lady Oscar here is the music on the sad ending of this fantastic Anime. It 'a version arranged by me and faithful to the original. The music is divided into 2 parts. The first part only Piano and Bass (full music), and the second part that echoes the opening theme but with the use of Celesta, Viola, Bass, Guitar, Violin and Piano. The score is on sale in both PDF and printed version. I ship the score in the full version. It is a rare disappeared (never marketed to the public). Also posted your criticism / comments so that I can improve my performance. | ["Music", "Sad music"] | ["instrumental", "medium tempo", "intense bass lines", "regret", "deep", "melodic violin harmony", "sharp piano lead", "syncopated harmony", "intense", "pensive", "melodic", "melancholic melody", "nostalgia", "sadness", "loneliness", "poignant"] | 7 | Vx_vqfpRdUU | 3046 |
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;