musiccaps_details (view)

4 rows where musiccaps_aspects contains "acoustic guitar" and musiccaps_names = "["Music", "Sad 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
DIO COMO TI AMO - música This song features a female voice singing the main melody. This is accompanied by a guitar playing arpeggiated chords. A wind instrument plays fills in between lines. There is no percussion in this song. This song has a romantic mood. This song can be played in a romantic movie. 2009-08-07T15:42:24Z uililopes música: DIO COMO TI AMO ============ Dio, come ti amo é uma canção italiana de Domenico Modugno que fez sucesso na voz de Gigliola Cinquetti, que a gravou em 1965. =========== Nel cielo passano le nuvole che vanno verso il mare, sembrano fazzoletti bianchi che salutano il nostro amore. Dio come ti amo! Non è possibile avere fra le braccia tanta felicità. Baciare le tue labbra che odorano di vento, noi due innamorati come nessuno al mondo. Dio come ti amo! Mi vien da piangere, in tutta la mia vita non ho provato mai un bene così caro, un bene così vero. Chi può fermare il fiume che corre verso il mare, le rondini nel cielo che vanno verso il sole, chi può cambiar l'amore l'amore mio per te. Dio come ti amo! Un bene così caro, un bene così vero. Chi può fermare il fiume che corre verso il mare, le rondini nel cielo che vanno verso il sole, chi può cambiar l'amore l'amore mio per te. ["Music", "Sad music"] ["low quality audio", "female voice", "acoustic guitar", "slow tempo", "wind instrument", "no percussion", "minimal instruments", "romantic mood"] 0 3gh1oldZ7Zc 493
Kiralık Aşk - Enstrümantal Fon Müzik 2 || Instrumental Background Music 2 This is an instrumental piece from a soap opera soundtrack. The violin and the acoustic guitar are playing a mellow tune while there is an occasional piano tune in the background. The rhythm is kept by a very quiet acoustic drum beat. The atmosphere is gentle and romantic. This piece could be used in the soundtrack of romance movies where the characters are having a good time in the presence of each other. 2015-12-14T11:19:46Z Kiralık Aşk Soundtrack ABONE OL tuşuna basarak kanalıma abone olmayı unutmayın! Please do not forget to SUBSCRIBE my channel! ["Music", "Sad music"] ["soap opera soundtrack", "instrumental", "violin", "acoustic guitar", "piano", "acoustic drums", "gentle", "emotional", "romantic"] 9 7eZTmLV9gcY 871
MAYA AND SIR CHIEF'S LOVE STORY PART 2 August 2012 Episodes This music is instrumental. The tempo is slow with an emphatic violin harmony, keyboard accompaniment and rhythmic acoustic guitar with female vocalisation. The song is romantic, sentimental, emotional, nostalgic, poignant, charming, dreamy and soft. 2012-12-16T04:10:01Z yean Sagala ["Music", "Sad music"] ["instrumental", "slow tempo", "vocalisation", "female vocalisation", "charming", "dreamy", "poignant", "colourful", "warm", "keyboard accompaniment", "violin harmony", "acoustic guitar", "mellow", "soft", "romantic", "emotional", "sentimental"] 7 WNmAlKrAPjQ 3089
Ab Tere Bin Hum Bhi Jee Lenge from AURANGZEB This is a soap opera theme music. There is a clarinet playing the main tune with the acoustic guitar and the bass guitar in the backing. There is a melodic pad that can be heard. An acoustic sounding electronic cymbal and wind chimes strokes are playing every now and then. There is a sentimental atmosphere to this piece. 2010-09-16T12:47:18Z AB Shah Ahmad very nice song ["Music", "Sad music"] ["soap opera theme", "acoustic guitar", "clarinet", "bass guitar", "melodic pad", "electronic drums", "chimes", "sentimental", "emotional"] 9 sMNuJy4f4A0 4944

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;