musiccaps_details (view)

3 rows where musiccaps_aspects contains "sustained strings melody" and musiccaps_names contains "Brass instrument"

✎ 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
Coco Martin ❤ Julia Montes Come What May The low quality recording features a sustained strings melody, mellow brass melody and wooden percussion one shot at the end of the loop. It sounds passionate, emotional and the sound is slowly fading in - which could mean that it is an intro section of the song. 2012-10-20T05:56:40Z CocoJul Martes CocoJul Perfect Match Lovely Couple❤ ["Brass instrument", "Saxophone"] ["low quality", "sustained strings melody", "mellow brass melody", "wooden percussion one shot", "passionate", "emotional", "intro", "fade in"] 4 ZGfGiVauGL4 3355
4/6 - David Guerrier - Joseph Haydn - 1er mvt du Concerto pour cor The low quality recording features an orchestra live performance and it contains a mellow brass section melody, sustained strings melody, soft piano chords and smooth double bass. It sounds easygoing and happy, like something you would listen to while trying to relax. 2009-07-26T11:43:31Z schilke60fr David Guerrier avec l'orchestre « Les Siècles » de François-Xavier Roth au Festival de l'Epau (Le Mans). 27e édition faisant écho à l'anniversaire Joseph Haydn. Le trompettiste et corniste David Guerrier, accompagné des Siècles de François-Xavier Roth, s'offre une petite balade du côté de l'oeuvre de Joseph Haydn, lors du 27e festival de l'Epau, qui s'est déroulé du 7 au 17 mai 2009. ["Brass instrument", "French horn", "Trombone"] ["low quality", "live performance", "orchestra", "mellow brass section melody", "sustained strings melody", "soft piano chords", "smooth double bass", "easygoing", "happy", "relaxing"] 4 eezaOfrLOkM 3889
107 - Come to Jehovah's Mountain The low quality recording features a harmonizing choir vocals singing over brass melody and sustained strings melody. There is a snare roll in the left channel of the stereo image. It sounds passionate, emotional and soulful. 2010-11-08T23:44:57Z Witteboek Music: Kingdom Melodies nr. 107 Watch Tower Bible and Tract Society of PA MUSIC - Vocals 2, Sing to Jehovah Pics are free downloads from the internet, the Mount Everest and its surroundings ["Brass instrument", "Trombone", "Trumpet"] ["low quality", "harmonizing choir vocals", "snare roll", "brass melody", "sustained strings melody", "passionate", "emotional", "soulful"] 4 tEZU-ZRhSoY 5017

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;