musiccaps_details (view)
2 rows where musiccaps_aspects contains "female vocalist", musiccaps_aspects contains "piano accompaniment" and musiccaps_aspects contains "soothing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- female vocalist · 2 ✖
- mellifluous 2
- piano accompaniment · 2 ✖
- soothing · 2 ✖
- captivating 1
- dance groove 1
- emphatic vocals 1
- engaging 1
- ethereal 1
- euphonious 1
- folk song 1
- groovy bass lines 1
- icelandic lullaby 1
- icelandic song 1
- latin music 1
- latin song 1
- medium tempo 1
- mellow 1
- mesmerising 1
- minimalist music 1
- mystic vibe 1
- pandeireta rhythm 1
- peaceful 1
- regional music 1
- regional pop 1
- romantic 1
- romantic piano 1
- slick drumming 1
- slow tempo 1
- soft 1
- soulful 1
- spanish guitar harmony 1
- spanish song 1
- vocal backup 1
- world music 1
musiccaps_names (array) 4 ✖
- Music 2
- Flamenco 1
- Lullaby 1
- Music of Latin America 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Las Chuches - Amor, amor, amor | A female vocalist sings this romantic song in a foreign language that sounds like Spanish. The tempo is medium with a melodious guitar accompaniment, slick drumming, piano accompaniment, steady bass line and pandeireta rhythm. The song is soft, mellow, catchy, emotional and soothing. This song is a Folk Pop/Regional Pop song. | 2008-07-21T00:44:11Z | Faico90 | Las chuches como siempre derroxando arte | ["Flamenco", "Music", "Music of Latin America"] | ["female vocalist", "medium tempo", "regional pop", "regional music", "folk song", "spanish song", "latin song", "spanish guitar harmony", "groovy bass lines", "slick drumming", "latin music", "piano accompaniment", "pandeireta rhythm", "romantic", "mellifluous", "soothing", "mellow", "world music", "regional music", "dance groove", "vocal backup", "mystic vibe"] | 7 | 7_q36NyJtQY | 863 | |
Yohanna - A lullaby in Icelandic (Beat for Beat) - Jóhanna Guðrún | A female vocalist sings this melodic song in Icelandic. The tempo is slow with vocal emphasis and a soft and romantic piano accompaniment. The song is a mellow, soothing, peaceful, soothing, ethereal, mesmerising and captivating Icelandic lullaby. | 2012-11-25T14:05:24Z | Videos by Yohanna.de | Yohanna sings a lullaby in Icelandic. Very short but very enchanting clip ... ♥️ Piano: Trond Nagell Dahl Part of the TV show "Beat for beat" - November 23, 2012 More infos about Iceland's Most Beautiful Voice (in German): https://www.Yohanna.de | ["Music", "Lullaby"] | ["female vocalist", "slow tempo", "soft", "euphonious", "mellifluous", "piano accompaniment", "emphatic vocals", "icelandic song", "icelandic lullaby", "minimalist music", "romantic piano", "ethereal", "mesmerising", "captivating", "engaging", "peaceful", "soulful", "soothing"] | 7 | Y5RVYmf3uWc | 3253 |
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;