musiccaps_details (view)

4 rows where musiccaps_aspects contains "strings", musiccaps_author = 6 and musiccaps_names contains "Tender music"

✎ 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
Amor Secreto - Kendo Kaponi ( Lyrics ) This song contains a piano playing a melody in the mid range and also in the higher register. A flute is adding another melody in the mid range. A digital drum is holding a simple groove before dropping out completely. A male voice is softly rapping/talking in the mid range then another male with an effect takes over singing in a higher pitch. In the background you can hear strings underlaying chords. This song may be playing with headphones daydreaming. 2011-06-16T16:52:05Z MsCuBaNiTa01 ["Music", "Tender music"] ["pop", "piano", "strings", "digital drums", "digital flute", "male voices singing/rapping", "romantic", "sensitive", "medium tempo"] 6 6sWVG6GyJBU 793
80 MÚSICAS GOSPEL EM UM SÓ VÍDEO -VÍDEO 1/4 A female voice is singing a ballad with some reverb on her voice while an acoustic guitar is finger-picking chords on the left side of the speakers. A string section is playing harmonies along with the singer. A e,bass is played along with shakers and ride hits from a drummer. A piano is playing along with the melody. The elements are spread across the sides of the speakers. 2011-05-29T15:39:46Z Raquel Lerbach 80 Músicas Gospel em apenas um vídeo LOUVORES MÚSICA CRISTÃ HINO EVANGÉLICO HINOS LOUVOR ADORAÇÃO MUSIC GOSPEL GOSPEL MÚSICAS ESPIRITUAIS ["Gospel music", "Music", "Tender music"] ["gospel", "2 separate songs", "strings", "acoustic guitar", "acoustic drums", "e-bass", "female voice singing", "medium to uptempo"] 6 DA8lw6Mq0DY 1447
The Well Music Video - Sounds of Heaven The female voice is singing lightly sad-sounding. Backing voices are supporting her in some phrases while strings are playing long notes that are panned to the left and right side of the speakers. A piano is playing ballad sounding chords and a melody underlined by the e-bass. This song may be playing in a soul musical. 2013-09-20T02:11:25Z SoundsofHeaven Sounds of Heaven presents the official music video for The Well. Available on itunes: https://itunes.apple.com/us/album/the-well-single/id661950710 Vocalists: Jonathan James and Zorina Andrews Group ["Music of Asia", "Music", "Sad music", "Tender music"] ["r&b/pop", "acoustic piano", "electronic drums", "strings", "female singing voice", "backing vocals", "e-bass"] 6 HfzEa06vDLg 1826
War Thunder Soundtrack: Australia/Germany Menu Music This song contains an orchestra playing an epic sounding piece. Trumpets are playing the main melody along with a brass section providing chords, other string instruments are playing a short melody with the bow and someone is playing marching snares before a cymbal roll comes in and flutes are taking over along with strings in the background. This song may be playing in a war hero movie. 2013-06-29T15:28:08Z Rakashin7 This song is called "Advance Australia" Composed by Zakhar Antonov Performed by the Baltic Symphony Orchestra Was 'Battle Music 2' before patch 1.79 You can buy the soundtrack here: http://warthunder.com/en/soundtrack Some songs, including the main theme, aren’t available for purchase, so you can get them for free here: https://www.mediafire.com/?fadgeteb22... Replace "tube" in the URL with "repeat" to have the music repeat =D Vote for your favorite air battle music here: http://strawpoll.me/6946245 =O ["Theme music", "Music", "Soundtrack music", "Tender music"] ["cinematic", "orchestral", "epic", "trumpets", "brass section", "flutes", "strings", "percussion", "medium to uptempo"] 6 sQMzHk9MRAI 4948

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;