musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "mellow", musiccaps_aspects contains "nostalgic" and musiccaps_aspects contains "sentimental"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- mellow · 3 ✖
- nostalgic · 3 ✖
- sentimental · 3 ✖
- emotional 2
- male vocalist 2
- slow tempo 2
- acoustic bass 1
- acoustic guitar 1
- acoustic guitar accompaniment 1
- banjo 1
- bluegrass 1
- country folk songs 1
- country hits 1
- country music 1
- dissonant tambourine beats 1
- electric guitar rhythm 1
- energetic drumming 1
- female singer 1
- folk lyrics 1
- groovy bass line 1
- hillbilly music 1
- keyboard accompaniment 1
- keyboard harmony 1
- medium tempo 1
- melancholic 1
- melancholy 1
- mellow electric guitar 1
- melodious 1
- minimal music 1
- old-time country rock 1
- …
musiccaps_names (array) 4 ✖
- Music 3
- Folk music 1
- Grunge 1
- Sad music 1
youtube_published (date) 3 ✖
- 2008-07-09 1
- 2009-04-17 1
- 2009-12-03 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"ANGEL OF BENGAL" - The Religion of Love, music video | A female vocalist sings this soft melody. The song is slow tempo with a mellow electric guitar harmony, soft keyboard accompaniment , a soft lilting flute melody and subtle bass line. There is no use of percussion. The song is soft, mellow, emotional, nostalgic and sentimental . This song is Soft pop. | 2008-07-09T03:19:08Z | Hassan Ali | Devotional music written, performed, and produced by Jaraneh Nova. Dedicated to our Spiritual Master, Mother Rytasha, The Angel of Bengal. A Razzaque Khan Production. http://thereligionoflove.net ,http://www.chela.net/rytasha ,-- love@chela.net | ["Music", "Sad music"] | ["female singer", "slow tempo", "mellow electric guitar", "soft lilting flute", "keyboard accompaniment", "subtle bass lines", "vocal emphasis", "minimal music", "soft pop", "mellow", "soothing", "emotional", "sentimental", "nostalgic", "melancholic"] | 7 | 9aE33JEIGOg | 1028 | |
Sam Stone - John Prine | A male vocalist sings this melancholic country song. The tempo is slow with acoustic guitar lead and harmony with another string instrument accompanying. The song is soft, mellow, sad, pensive, melancholic and poignant with a sweet , pleasant melody. This song is a Classic Country song. | 2009-12-03T02:53:38Z | HouseOBVIOUSLY | Classic John Prine right here. | ["Folk music", "Music"] | ["male vocalist", "slow tempo", "acoustic guitar", "simple melody", "hillbilly music", "banjo", "old-time country rock", "folk lyrics", "country music", "bluegrass", "country hits", "regional music", "country folk songs", "acoustic bass", "mellow", "soft", "sentimental", "nostalgic", "pensive", "melancholy", "story telling"] | 7 | Sl9ZkYViEIs | 2787 | |
Lie To Me opening theme - Music - Ryan Star - Brand New Day | A male vocalist sings this melodic pop song.The tempo is medium with energetic drumming, keyboard harmony, groovy bass lines, electric guitar harmony, acoustic guitar rhythm and dissonant tambourine beats. The is soft, calming, mellow, sentimental, emotional and nostalgic. This song is Pop Rock/Soft Rock. | 2009-04-17T03:37:09Z | Ricardo Miranda | Clipe da musica de abertura do seriado Lie To Me (Ryan Star - Brand New Day) Hello to all the video was made is not official Fan to Fan Olá a todos o video não é oficial foi feito de Fã para fã Os gráficos são baixos o vídeo foi feito com vários outros vídeos disponíveis no YT | ["Music", "Grunge"] | ["male vocalist", "medium tempo", "energetic drumming", "groovy bass line", "synth arrangement", "keyboard harmony", "electric guitar rhythm", "dissonant tambourine beats", "sweet", "melodious", "mellow", "romantic", "emotional", "sentimental", "nostalgic", "poignant", "acoustic guitar accompaniment"] | 7 | l9vYSBR9nio | 4377 |
Advanced export
JSON shape: default, array, newline-delimited
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;