musiccaps_details (view)
3 rows where musiccaps_aspects contains "strings" and musiccaps_names contains "Lullaby" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- strings · 3 ✖
- lullaby 2
- male vocal 2
- piano 2
- calm 1
- classical 1
- comedic 1
- crestfallen 1
- gentle 1
- harp 1
- haunting 1
- low pitch percussive sound 1
- medium-to-high pitch singing 1
- melancholic 1
- mellow 1
- melodic singing 1
- quiet female voice 1
- russian 1
- still atmosphere 1
- wind sound 1
- xylophone 1
musiccaps_names (array) 4 ✖
- Lullaby · 3 ✖
- Music 3
- New-age music 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 by Tim Minchin | This is a lullaby being sung by a comedian. The male vocalist is singing melodically. The main melody is being played by a piano while strings in the background are holding the root notes of the piece. An occasional xylophone riff can be heard adding texture in the high range. This piece has a gentle but comedic atmosphere. | 2011-02-16T09:22:25Z | Tim Minchin | Lullaby as performed on Ben Elton's Live from Planet Earth, featuring part of the Melbourne Symphony Orchestra. | ["Music", "Lullaby"] | ["lullaby", "male vocal", "melodic singing", "piano", "strings", "xylophone", "mellow", "gentle", "calm", "comedic"] | 9 | ESFANzZTdYM | 1558 | |
Witcher 3 - 'Lullaby of Woe' | The music features a female voice quietly singing a melody. A harp is accompanying the singer. Violins can be heard fading out from the beginning of the music excerpt. In the background one can hear the wind blowing softly. Towards the ending of the music excerpt a low pitch percussive sound can be heard. | 2015-08-27T02:28:40Z | BastianRP | By Marcin Przybyłowicz. Not owned by me. Copyright CD Projekt RED. | ["New-age music", "Music", "Lullaby"] | ["quiet female voice", "harp", "strings", "wind sound", "still atmosphere", "low pitch percussive sound"] | 2 | OLy3C8YpMsY | 2429 | |
Константин Плужников 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 |
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;