musiccaps_details (view)
4 rows where musiccaps_aspects contains "joyful", musiccaps_author = 9 and musiccaps_names contains "Accordion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- joyful · 4 ✖
- accordion 3
- instrumental 3
- lively 3
- acoustic guitar 2
- accordeon 1
- alpine folk music 1
- cello 1
- cheerful 1
- clarinet 1
- fiddle 1
- latin folk 1
- latin music 1
- live performance 1
- live recording 1
- male vocal 1
- maracas 1
- no singer 1
- off-key singing 1
- orchestra 1
- percussion 1
- romanian folk music 1
- single instrument 1
- tango 1
- ukulele 1
- upbeat 1
- upright bass 1
- venezuelan 1
- vibrant 1
musiccaps_names (array) 5 ✖
- Accordion · 4 ✖
- Music 1
- Musical instrument 1
- Rattle (instrument) 1
- Wind instrument, woodwind instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mitja kvintet - S klarineti na pot-Mit Klarinetten unterwegs | This is an Alpine folk music piece. The piece is instrumental. It is being performed by an orchestra composed of the clarinets, the accordion, the cello and the acoustic guitar. The atmosphere is cheerful. This piece could be used in the soundtrack of a movie that takes place in the Alps region. | 2008-01-16T21:07:21Z | horni110607 | Mit Klarinetten unterwegs Komp.: Damir Tkavc - Alpenoberkrainer / Alpski kvintet Mitja Mastnak Robi Marzel Sandi Jug Zmago Tkavc Matjaz Vodisek Mario Reumüller | ["Wind instrument, woodwind instrument", "Accordion"] | ["alpine folk music", "instrumental", "orchestra", "clarinet", "accordion", "cello", "acoustic guitar", "cheerful", "joyful"] | 9 | 9mqA4YdX444 | 1041 | |
Lucrecio García_Golpe de Arpa con Estribillo | This is a latin folk piece performed at a home setting. There is a male vocalist singing off-key in a shout-like manner. An accordion and a ukulele are providing the melodic background for the piece. A pair of maracas is being played for the rhythmic background. The piece has a joyful atmosphere. The instrumentals can be used for sampling to put them in a beat. | 2009-05-14T23:55:12Z | Escucha Joropo | Forma de Joropo Tradicional del oriente venezolano la cual tiene similitud con la del Joropo Corrío Llanero. Su ciclo armónico es Tónica-Subdominante-Dominante-Tónica (I-IV-V7-I). Tiene salida a Estribillo como es común en el Joropo Oriental. Se caracteriza por ser muy vivaz lo que emociona a cantadores y bailadores. En esta ocasión Lucrecio nos demuestra su dominio en este tipo de acompañamiento logrando la inspiración en el Canto tanto de Mónico Márquez como de Luis Raposo. | ["Music", "Musical instrument", "Rattle (instrument)", "Accordion"] | ["latin folk", "live recording", "male vocal", "off-key singing", "accordeon", "ukulele", "maracas", "lively", "joyful", "vibrant", "venezuelan"] | 9 | ZahBai58_Ec | 3395 | |
rapsódia tango | This is a latin music piece in the style of tango. It is an instrumental piece. The only instrument being played is an accordion. The accordion is playing a joyful tune. This piece could be playing in the background at an Iberian coffee shop. | 2009-06-19T15:25:02Z | Eurico Martins e Cristina Música-Oficial | acordeonista | ["Accordion"] | ["latin music", "tango", "no singer", "instrumental", "single instrument", "accordion", "joyful", "lively"] | 9 | wEHRmd84Dwc | 5250 | |
dorel bass boss si lilian de la craiova | This is the live performance of a Romanian folk music piece. It is instrumental. There is an accordion playing the leading melody while the fiddle, acoustic guitar and the upright bass play in the background. There is a percussive element in the rhythmic background. The atmosphere is lively and joyful. | 2010-10-02T11:31:13Z | bosssbosssmihaita | la o terasa in las palmas de gran canarias | ["Accordion"] | ["romanian folk music", "live performance", "instrumental", "accordion", "upright bass", "acoustic guitar", "percussion", "fiddle", "lively", "upbeat", "joyful"] | 9 | xR2p3UED4VU | 5328 |
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;