musiccaps_details (view)

4 rows where musiccaps_aspects contains "slow tempo" and musiccaps_names contains "Piano"

✎ 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
Kenny Rogers & Dolly Parton - Sometimes When We Touch This music is a soft instrumental. The tempo is slow with a beautiful keyboard harmony. The music is soft, mellow, sentimental, nostalgic, melancholic and romantic. This song is classic pop. 2009-06-23T23:40:32Z Kristin Tehvan One of the best love songs ever. ["Electric piano", "Keyboard (musical)", "Piano"] ["instrumental", "slow tempo", "keyboard harmony", "pop", "classic pop", "melancholic", "nostalgic", "minimalist", "song introduction", "soft", "mellow", "romantic", "melodic", "emotional", "sentimental", "love song"] 7 BMxgDBoPv_0 1233
The Resolution - Jack's Mannequin (Live, Acoustic) This slow pop song features the end of a song. A male voice sings one syllable. The piano plays three notes followed by two high pitch notes. A guitar chord is heard ringing in the background. There is no percussion in this song. There are no other instruments in this song. The mood of this song is romantic. This song can be played in a romantic movie. 2008-11-30T20:47:21Z cassielovesandrew ⓒBuzznet 2008, enjoy & comment! :) ["Electric piano", "Keyboard (musical)", "Piano"] ["slow pop", "piano song", "reverb", "male voice", "music fading out", "slow tempo", "ringing guitar chord", "romantic mood"] 0 QmIhKF1BqCg 2640
Keyboard: Booker T. Jones - "Hang'em High" The song is an instrumental. The song is slow tempo with an organist playing a tune on a church organ and sounds of switches being turned on and off. The song is emotional and sounds devotional in nature. The audio quality is poor with ambient room sounds. 2009-04-09T19:38:11Z MusicPlayerNetwork To see the rest of the interview, head over to http://www.keyboardmag.tv ["Organ", "Hammond organ", "Keyboard (musical)", "Piano"] ["organist", "church organ", "organ legends", "old school players", "legendary musicians", "passionate", "spiritual", "switch sounds", "slow tempo", "instrumental music", "key sounds", "ambient room sounds", "keyboard", "emotional", "devotional music", "documentary", "poor audio quality"] 1 d9r_kYpOvW8 3766
Renuevame Marcos Witt - Tutorial Piano Carlos A male vocalist sings a soft melody in a foreign language. The tempo is slow with a piano harmony . The vocals are soft and subdued with ambient background sounds. The song is simple, mellow , melancholic and soft. This song is soft pop. 2010-11-01T20:58:01Z CarlosMotiff https://www.paypal.com/donate/?token=W00LAy6mMt7CxoZZd2KeiULlwN4iwdinhYltfd162hwr8Tql6kSse5C6gV8qhCFxkg_YD0&country.x=CA&locale.x=CA cualquier donacion a este ministerio sera un abendicion ...y juntos podamos seguir con esta gran labor de seguir formando muchos mas musicos para el servicio de su obra https://www.paypal.com/donate/?token=W00LAy6mMt7CxoZZd2KeiULlwN4iwdinhYltfd162hwr8Tql6kSse5C6gV8qhCFxkg_YD0&country.x=CA&locale.x=CA ["Electric piano", "Keyboard (musical)", "Piano"] ["male singer", "slow tempo", "keyboard harmony", "subdued vocals", "ambient background sounds", "simple melody", "home recording", "amateur recording", "paino tutorial"] 7 gkB4KBHBV9g 4051

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;