musiccaps_details (view)
3 rows where musiccaps_aspects contains "melancholic" and musiccaps_aspects contains "string section"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- melancholic · 3 ✖
- string section · 3 ✖
- female voice singing 2
- acoustic piano 1
- bad audio quality 1
- ballad 1
- classical 1
- conductor 1
- deep 1
- documentary soundtrack 1
- documentary video 1
- fast tempo 1
- great composers 1
- high pitched notes 1
- high register 1
- instrumental music 1
- low percussive hit 1
- passionate 1
- pop 1
- reverb 1
- saxophone 1
- slow tempo 1
- soothing 1
- spirited 1
- string quartet 1
- studio 1
- vibrato 1
- violin solo 1
- violin technique 1
- water splashing sound 1
- western classical music 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Quatuor EBENE: Ravel, Debussy, Fauré -String Quartets | The song is instrumental. The tempo is fast with violins playing in harmony showing exemplary technique. The song is emotional, spirited and passionate. The song is a western classical music hit. The audio quality is poor. | 2013-07-26T16:49:10Z | Warner Classics | Debussy, Fauré & Ravel: String Quartets CD available on: http://bit.ly/FaureRavelStringquartet http://www.emiclassics.com/quatuor-ebene https://www.facebook.com/QuatuorEbene The Quatuor Ebènes debut recording on Virgin Classics brings together the string quartets of the three emblematic French composers of the late 19th and early 20tb centuries: Fauré, Debussy and Ravel. ________________________________________ ________________________________________ Buy from Amazon (USA): http://www.amazon.com/exec/obidos/ASIN/B001BWQWKS/emi-jazz-class-21/ref%3Dnosim ________________________________________ Buy from Amazon (UK): http://www.amazon.co.uk/exec/obidos/ASIN/B001BWQWKS/emi-jazz-class-21/ref%3Dnosim ________________________________________ Buy from Amazon (FR): http://www.amazon.fr/exec/obidos/ASIN/B001BWQWKS/emi-jazz-class-21/ref%3Dnosim ________________________________________ Buy from Amazon (DE): http://www.amazon.de/exec/obidos/ASIN/B001BWQWKS/emi-jazz-class-21/ref%3Dnosim ________________________________________ http://www.quatuorebene.com/ http://www.emiclassics.com http://www.emiclassics.de ________________________________________ __________ Warner Classics ► Website: http://www.warnerclassics.com Subscribe to our: ► YT- Channel: https://wnrcl.me/subscribeYT ► Newsletter https://wnrcl.me/subscribeNL Follow us on: ► Facebook: http://www.fb.com/WarnerClassicsErato ► Instagram: http://www.instagram.com/warner_classics ► Twitter: http://twitter.com/WarnerClassics ► YouTube: https://www.youtube.com/warnerclassics Listen to us on: ► Spotify: http://open.spotify.com/user/warnerclassics ► Apple Music: http://itunes.apple.com/curator/warner-classics/1153741571 ► Deezer https://www.deezer.com/profile/321050935 Warner Classics is the home of classical music, featuring iconic high audio quality recordings from the greatest classical legends, opera stars and orchestras of the last century. Discover our unique collection of live performances, studio sessions and films featuring Maria Callas, Jacqueline du … | ["Music", "Musical instrument", "Pour", "Violin, fiddle", "Bowed string instrument"] | ["water splashing sound", "violin solo", "instrumental music", "great composers", "conductor", "studio", "fast tempo", "string quartet", "string section", "fast tempo", "bad audio quality", "documentary soundtrack", "documentary video", "melancholic", "passionate", "spirited", "vibrato", "high pitched notes", "violin technique", "western classical music"] | 1 | 0qtbbK5HVMw | 213 | |
Simone Kermes - Lorca - Blood Wedding - Lullaby - (Hans-Erik Philip) | A female voice is singing very clear and a high pitched melody. She got a lot of reverb on her voice. A string section is supporting her. This song may be playing in a post-apocalyptic movie-scene. | 2011-05-28T13:28:05Z | OHMUSIK12345 | Info & buy: http://www.ohmusik.dk/ Simone Kermes sings "Lullaby" from Lorcas "Blood Wedding" Music by Hans-Erik Philip, a CD from Danica Records. Simone Kermes: Soprano Federico García Lorca: "Blood Wedding" Music by Hans-Erik Philip Budapest Radio Symphony Orchestra & Chorus Conducted by Béla Drahos World Premiere Recording OH Musik DCD 8238 | ["Music", "Lullaby"] | ["ballad", "classical", "string section", "female voice singing", "high register", "soothing", "melancholic"] | 6 | azyNUtTHvaE | 3591 | |
Lana Del Rey - Terrence Loves You (Official Audio) | The song sounds orchestrated. There is a string section playing swells and rising tremolos along to an acoustic piano playing minor chords. A cello is playing long low notes on top of that a saxophone is playing two notes to end the phrase. A deep and far percussive hit comes in every fourth count. The female singer's voice sounds sensitive and melancholic. There are female backing voices singing along. The whole composition is full of big reverb. This song may be playing at the end of a sad movie. | 2015-08-21T07:00:00Z | LanaDelReyVEVO | Lana Del Rey - Terrence Loves You (Official Audio) Sign up for updates: http://smarturl.it/LanaDelRey.News Follow Lana Del Rey: http://www.instagram.com/lanadelrey http://www.facebook.com/lanadelrey http://www.twitter.com/lanadelrey http://lanadelrey.tumblr.com http://www.lanadelrey.com Lana Del Rey - Terrence Loves You (Lyrics) You are what you are I don't matter to anyone But Hollywood legends Will never grow old And all of what's hidden Well, it will never grow cold But I lost myself when I lost you But I still got jazz when I've got those blues And I lost myself when I lost you And I still get trashed, darling, when I hear your tunes But you are who you are I won't change you for anything For when you are crazy I'll let you be bad I'll never dare change thee To what you are not But I lost myself when I lost you But I still got jazz when I've got those blues I lost myself and I lost you too And I still get trashed, baby, when I hear your tunes I put the radio on, hold you tight in my mind Isn’t strange that you’re not here with me I’m putting all the lights on and the television Trying to transmit, can you hear me? Ground control to Major Tom Can you hear me all night long? Ground control to Major Tom Well, I lost myself when I lost you But I still got jazz when I've got the blues I lost myself and I lost you too And I still get trashed, honey, when I hear your tunes Mmmm-mmm-mmm-mmm Mmmm-mmm-mmm-mmm Mmmm Mmmm-mmm-mmm-mmm Mmmm | ["Music", "Synthetic singing"] | ["pop", "string section", "female voice singing", "reverb", "acoustic piano", "deep", "low percussive hit", "saxophone", "slow tempo", "melancholic"] | 6 | emDU4QvdwVk | 3896 |
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;