musiccaps_details (view)
4 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "live performance" and musiccaps_names contains "Accordion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- instrumental · 4 ✖
- live performance · 4 ✖
- accordion 2
- joyful 2
- romanian folk music 2
- acoustic guitar 1
- ambient outdoor sounds 1
- celebratory 1
- cheerful 1
- cimbalom 1
- contrabass 1
- distorted music 1
- fast tempo 1
- festive 1
- fiddle 1
- garmon 1
- guiro 1
- guiro accompaniment 1
- happy 1
- inferior audio quality 1
- latin dance music 1
- latin music 1
- latin regional music 1
- live music 1
- lively 1
- lively acordion 1
- melancholic 1
- no singer 1
- percussion 1
- playful 1
- russian folk music 1
- scraper instrument 1
- single instrument 1
- solo 1
- spirited 1
- spirited congas 1
- static 1
- upbeat 1
- upright bass 1
- vibrant 1
- violin 1
- world music 1
musiccaps_names (array) 5 ✖
- Accordion · 4 ✖
- Maraca 1
- Music 1
- Musical 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 |
---|---|---|---|---|---|---|---|---|---|---|
Dj Galati - Petrecere cu lautari, Crama Lautarilor Galati, 25.11.2011 - Clip 2 - www.djgalati.ro | This is a Romanian folk music piece. It is a live performance. In the background, there is a contrabass and a cimbalom playing. The main melody is being played by the violin and the accordion. The atmosphere is vibrant and cheerful. This piece could be used in the soundtrack of a comedy movie that takes place in eastern Europe or the Balkans, especially during an escape scene. | 2012-01-02T00:50:03Z | Dj Galati Dj Nunta Galati | http://www.djgalati.ro - Sonorizare Echipa DjGalati - Petrecere cu lautari http://www.hotelmagnus.ro/crama.html - Crama Lautarilor Galati - 25.11.2011 *** Voce : Gicu Petrache - Clarinet\Saxofon : George Udila - Tambal : Florica Sandor - Acordeon : Costel de la Bolintin - Vioara : Dorel Zamfir - Bas : Tica | ["Wind instrument, woodwind instrument", "Accordion"] | ["romanian folk music", "live performance", "instrumental", "cimbalom", "contrabass", "violin", "accordion", "vibrant", "playful", "cheerful"] | 9 | 0ewWspUqB6Y | 195 | |
Одинокая гармонь | This is a live performance of a Russian folk music piece. There is no singer in this piece. The single instrument being played is a garmon. The performer is playing a melancholic solo on the garmon. This piece could be used in the soundtrack of a movie or a documentary that takes place in Russia. It could also be playing in the background at a Russian cuisine restaurant. | 2011-06-26T14:54:47Z | apelsin9899 | Am 08.07.2010 fand in der Carl von Ossietzky Universität ein Open-Air-Konzert der Deutsch-Russischen Kulturbrücke aus Oldenburg statt. Friedrich Weigel (Knopfakkordeon) Фёдор Андреевич Вайгель - баян Ilja Weigel (Piano) Илья Вайгель - пианино http://www.drk-most.de/ | ["Accordion"] | ["russian folk music", "live performance", "no singer", "instrumental", "single instrument", "garmon", "solo", "melancholic"] | 9 | MtVLmOvQopM | 2306 | |
LUIS E.MARTINEZ EL CANTOR DE FONSECA | This music is a spirited Latin music instrumental. The tempo is fast with a lively accordion harmony, spirited congas beat and guiro accompaniment. The music is happy, vivacious, upbeat, vigorous, cheerful , celebratory and cheerful with ambient outdoor sounds like wind, people talking, clapping and a lot of static indicating that this is a live performance. The audio quality is inferior and this looks like an amateur home recording. | 2008-06-20T18:46:59Z | ALVARO VILLA FONTALVO | INTERPRETA EL CANTOR DE FONSECA EN COMPAÑIA DE SU AUTOR CARLOS HUERTAS EL CANTOR DE FONSECA- LUIS ENRIQUE INTERPRETA MAGISTRALMENTE SU ACORDEON, ENTRE LOS ASISTENTES ESTABA GABO, FUE EN EL AÑO 1993 EN B/QUILLA | ["Music", "Musical instrument", "Accordion", "Maraca"] | ["instrumental", "fast tempo", "distorted music", "static", "guiro accompaniment", "scraper instrument", "world music", "latin regional music", "latin dance music", "lively acordion", "spirited congas", "guiro", "latin music", "latin dance music", "happy", "spirited", "live performance", "live music", "ambient outdoor sounds", "inferior audio quality", "celebratory", "festive", "joyful"] | 7 | kpsYSXR1wao | 4360 | |
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;