musiccaps_details (view)
3 rows where musiccaps_aspects contains "heart-touching" and musiccaps_aspects contains "vibrant"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- heart-touching · 3 ✖
- vibrant · 3 ✖
- acoustic drums 2
- bass guitar 2
- instrumental 2
- live performance 2
- no singer 2
- acoustic guitar 1
- arabesque 1
- clarinet 1
- emotional 1
- glockenspiel 1
- harmonica 1
- hindi film music 1
- keyboard 1
- lively 1
- melancholic 1
- paraguayan folk music 1
- paraguayan harp 1
- percussion 1
- qanun 1
- saz 1
- turkish folk 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
CELSO DUARTE (ARPISTA PARAGUAYO). Parte 1: "Llegada", "Lamento Indio". www.musicajarocha.com | This is the live performance of a Paraguayan folk music piece. There is no singer. There is a Paraguayan harp playing a vibrant yet melancholic tune. The atmosphere is heart-touching. This piece could be used in the soundtrack of a drama movie during a scene of serenity or mourning. | 2010-12-20T01:53:40Z | ArpaFolklorica | Latin American Harp Festival. September 11 & 12, 2009, Rosslyn Spectrum Theatre. Teatro de la Luna. Artistis Director: Mario Marcel. Producer: Nucky Walder . Artistic Direction: Berta Rojas. Asistencia Técnica: Peter Pereyra. Diseño Gráfico: Sara Corral. Video Producción: Abby Sternberg. | ["Harp", "Bowed string instrument"] | ["paraguayan folk music", "live performance", "no singer", "instrumental", "paraguayan harp", "vibrant", "melancholic", "heart-touching"] | 9 | 1kYDbl5Y9Sg | 306 | |
Yeh hai bombay meri jan-Milon Gupta | This is a Hindi film music piece. This is an instrumental piece. The harmonica is playing a cheerful melody in the lead. The glockenspiel is playing a secondary melody while the acoustic guitar and the bass guitar are supporting them in the background. The acoustic drums are playing a jazz swing beat with the brushes. The atmosphere is lively. This piece could be used in a feelgood movie during scenes where everything is going well for the main character. | 2010-07-12T16:07:06Z | ramanaraaga | Yeh hai bombay meri jan from the movie "CID" played on harmonica by Shri Milon Gupta | ["Harmonica", "Jingle, tinkle", "Wind instrument, woodwind instrument"] | ["hindi film music", "no singer", "instrumental", "harmonica", "glockenspiel", "acoustic guitar", "bass guitar", "acoustic drums", "vibrant", "lively", "heart-touching"] | 9 | 8dE1x--TuF8 | 932 | |
Hüsnü Klarnet - senin olmaya geldim | This is the live performance of a Turkish folk music piece with arabesque influences. The clarinet is playing the main melody in the lead at a medium-to-high pitch. A secondary melody is playing the qanun in the background. There are supportive elements in the melodic background such as the saz, the keyboard and the bass guitar. The acoustic drums are playing a mellow beat accompanied by rich percussion. There is a vibrant atmosphere in this piece. This could be playing in the background of a Turkish cuisine restaurant or a hookah place. It could also be used in the soundtrack of a Turkish soap opera. | 2008-09-27T11:11:52Z | hsenlendirici | WWW.HUSNUFAN.ORG | ["Clarinet", "Traditional music", "Music"] | ["turkish folk", "arabesque", "clarinet", "qanun", "saz", "keyboard", "bass guitar", "acoustic drums", "percussion", "vibrant", "emotional", "heart-touching", "live performance"] | 9 | BMgYWTTJv3s | 1232 |
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;