musiccaps_details (view)
3 rows where musiccaps_aspects contains "classical" and musiccaps_aspects contains "melancholic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- classical · 3 ✖
- melancholic · 3 ✖
- amplified violin 1
- anxious 1
- ballad 1
- baroque 1
- cello 1
- chaotic 1
- compelling 1
- complex notes 1
- contrasting harmonies 1
- crestfallen 1
- delicate 1
- elegant 1
- engaging 1
- enthralling 1
- exquisite 1
- fast tempo 1
- female voice singing 1
- flute 1
- harpsichord 1
- haunting 1
- high register 1
- instrumental 1
- italian composition 1
- loosely structured music 1
- lullaby 1
- male vocal 1
- medium-to-high pitch singing 1
- piano 1
- piano accompaniment 1
- restless 1
- russian 1
- soothing 1
- string section 1
- strings 1
- syncopated harmony 1
- viola 1
- western classical 1
musiccaps_names (array) 5 ✖
- Lullaby 2
- Music 2
- Harpsichord 1
- Keyboard (musical) 1
- Opera 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Константин Плужников Lullaby Berceuse de la Bretagne | This is a Russian lullaby piece with classical music elements. The male vocalist is singing at a medium-to-high pitch in an opera-like manner. The strings and the piano are playing a gentle but crestfallen melody. The atmosphere is haunting. This piece could fit perfectly in the soundtrack of a post-apocalyptic war movie or a video game of similar theme. It could also work well in the soundtrack of a drama movie or an art movie that takes place in Russia or Eastern Europe. It might also be playing in the background at a high-tier Russian cuisine restaurant. | 2012-12-24T03:43:59Z | Bronisliva | Константин Плужников Бретонская колыбельная песня (М.Ипполитов-Иванов - В. Соловьев) Konstantin Pluzhnikov Berceuse de la Bretagne Lullaby (M.Ippolitov-Ivanov - V. Soloviev) Artist - P. de Chavannes | ["Music", "Opera", "Lullaby"] | ["russian", "lullaby", "classical", "male vocal", "medium-to-high pitch singing", "strings", "piano", "crestfallen", "haunting", "melancholic"] | 9 | ZKkfCOqLrT0 | 3363 | |
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 | |
Caprice - The Court of Faerie | This music is instrumental. The tempo is fast with a spirited harpsichord, contrasting melancholic violin harmony, flute, cello , viola and piano accompaniment. The music is complex, syncopated , melancholic, wistful, anxious and restless. This music is a Western Classical Piece. | 2009-09-27T14:21:26Z | 2ndhead1 | The Court of Faerie | ["Harpsichord", "Keyboard (musical)"] | ["instrumental", "fast tempo", "amplified violin", "restless", "contrasting harmonies", "viola", "anxious", "harpsichord", "flute", "piano accompaniment", "cello", "loosely structured music", "italian composition", "classical", "western classical", "baroque", "elegant", "exquisite", "delicate", "syncopated harmony", "complex notes", "engaging", "enthralling", "compelling", "melancholic", "chaotic", "restless"] | 7 | xtllXrdFAFQ | 5361 |
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;