musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "passionate", musiccaps_aspects contains "shimmering hi hats" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- passionate · 3 ✖
- shimmering hi hats · 3 ✖
- low quality 2
- accordion melody 1
- acoustic bass guitar 1
- crowd chattering 1
- electric guitar melody 1
- energetic crash cymbal 1
- folk 1
- groovy 1
- groovy bass 1
- joyful 1
- live performance 1
- mellow bass 1
- passionate male vocal 1
- piano chords 1
- punchy snare 1
- romantic 1
- shimmering shakers 1
- snappy snare 1
- soul/r&b 1
- wide acoustic guitars melody 1
- wide acoustic rhythm guitar melody 1
musiccaps_names (array) 14 ✖
- Music 3
- Musical instrument · 3 ✖
- Singing 2
- Accordion 1
- Acoustic guitar 1
- Bowed string instrument 1
- Guitar 1
- Mandolin 1
- Music of Latin America 1
- Orchestra 1
- Plucked string instrument 1
- Soul music 1
- Speech 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Max Mutzke - Can´t Wait Until Tonight (official Video) | The Soul/R&B song features a passionate male vocal singing over shimmering hi hats, energetic crash cymbals, wide acoustic rhythm guitar melody, shimmering shakers, snappy snare, piano chords and mellow bass. It sounds passionate and romantic - like something you would sing to your partner. | 2010-01-25T11:53:51Z | Max Mutzke | Der Videoclip zu Can´t Wait Until Tonight von Max Mutzke. Mehr Max gibt es hier http://www.maxmutzke.de | ["Singing", "Music", "Musical instrument", "Soul music"] | ["soul/r&b", "passionate male vocal", "shimmering hi hats", "energetic crash cymbal", "wide acoustic rhythm guitar melody", "shimmering shakers", "snappy snare", "piano chords", "mellow bass", "passionate", "romantic"] | 4 | 5ZX9Ig7XXsw | 668 | |
Samuel Rossi Orchestra Ringo Story Goleada polka | The low quality recording features a live performance of a folk song that consists of an accordion melody playing over groovy bass, shimmering hi hats, punchy snare and electric guitar melody. There are crowd chattering noises in the background. It sounds passionate and groovy. | 2009-07-03T12:40:13Z | Tuttofisa | Samuel Rossi Orchestra Ringo Story Goleada polka | ["Singing", "Traditional music", "Music", "Musical instrument", "Orchestra", "Speech", "Music of Latin America", "Accordion"] | ["low quality", "live performance", "crowd chattering", "folk", "groovy bass", "accordion melody", "electric guitar melody", "shimmering hi hats", "punchy snare", "passionate", "groovy"] | 4 | ChqJYrmQIN4 | 1394 | |
Izaías e Seus Chorões | Remelexo (Jacob do Bandolim) | Instrumental Sesc Brasil | The low quality recording features wide acoustic guitar melodies playing over shimmering hi hats, followed by acoustic bass guitar. It sounds passionate and joyful. | 2011-02-04T21:27:43Z | Instrumental Sesc Brasil | Izaías Bueno de Almeida começou a tocar bandolim com 10 anos de idade. Quando foi apresentado por Jacob do Bandolim, tornou-se o mais respeitado bandolinista de São Paulo. Israel passou depois para o violão, tocando bossa-nova, e para a guitarra, integrando conjuntos de iê-iê-iê. O começo dos anos 70 marcou também o nascimento de Izaías e Seus Chorões, com a atual formação, junta há mais de dez anos. Formação: Izaías Bueno de Almeida - bandolim Israel Bueno de Almeida - violão 7 cordas Edmilson Capelupi - violão 6 e 7 cordas Arnaldinho do Cavaco - cavaquinho José Reli - pandeiro Gênero: Choro Show que ocorreu no Teatro Anchieta do Sesc Consolação dia 24/01/2011 • site oficial: https://www.instrumentalsescbrasil.org.br/ • assista aos shows ao vivo pelo https://www.youtube.com/instrumentalsescbrasil Inscreva-se no canal http://www.youtube.com/sescsp e fique por dentro de toda a programação que acontece nas unidades do Sesc no estado de São Paulo. Basta ter uma conta gratuita no Google. | ["Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bowed string instrument"] | ["low quality", "wide acoustic guitars melody", "shimmering hi hats", "acoustic bass guitar", "passionate", "joyful"] | 4 | cYSW6Y884dA | 3718 |
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;