musiccaps_details (view)

3 rows where musiccaps_aspects contains "strings" and musiccaps_names contains "Lullaby"

✎ View and edit SQL

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
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

CSV options: 

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;