musiccaps_details (view)
4 rows where musiccaps_aspects contains "melancholic" and musiccaps_names contains "Accordion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 54 ✖
- melancholic · 4 ✖
- instrumental music 3
- accordion harmony 2
- accordion player 2
- cheerful 2
- gypsy music 2
- live performance 2
- slow tempo 2
- accordion lessons 1
- accordion trio 1
- ambient crowd noise 1
- average sound quality 1
- bad audio quality 1
- casual 1
- dance music 1
- emotional 1
- energetic 1
- enthusiastic 1
- ethnic instruments 1
- flute playing 1
- folk music 1
- friends get together 1
- garmon 1
- groovy 1
- guitar playing 1
- high gain music 1
- home music jam 1
- home music video 1
- home recording 1
- home studio 1
- house party 1
- instrumental 1
- instrumental harmony 1
- jam session 1
- life is beautiful 1
- life is good 1
- lilting melody 1
- lilting music 1
- live jam 1
- medium tempo 1
- no singer 1
- nostalgic moments 1
- parisian streets 1
- peaceful relaxing 1
- people enjoying the music 1
- relaxing 1
- romantic 1
- russian folk music 1
- screechy tones 1
- single instrument 1
- slow paced 1
- solo 1
- soloist 1
- youtube music video 1
musiccaps_names (array) 2 ✖
- Accordion · 4 ✖
- 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 |
---|---|---|---|---|---|---|---|---|---|---|
Одинокая гармонь | 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 | |
Vals till Marie | The song is an instrumental. The song is slow tempo with three accordions playing in harmony and in a relaxed manner. The song is beautiful and romantic. The audio quality is average and an amateur home recording. | 2013-02-09T15:57:01Z | Dragzpel | Vals till Marie, Komponerad av Kjell Nilsson i Lidhult.Här framförd av Kjell tillsammans med Siv & Ingvar Karlsson. ZOOM Handy Video Recorder | ["Accordion"] | ["accordion trio", "accordion harmony", "instrumental music", "home music video", "average sound quality", "home music jam", "friends get together", "house party", "slow tempo", "parisian streets", "gypsy music", "lilting melody", "casual", "peaceful relaxing", "energetic", "slow paced", "life is beautiful", "cheerful", "melancholic"] | 1 | NUTaOnEhvzE | 2340 | |
Kitty (Pogues Cover) | The song is an instrumental. The song is medium tempo with an accordion playing in an accompaniment style with both medley and harmony and no other instrumentation. The music is romantic and melancholic. The audio quality is poor. | 2007-08-03T07:52:34Z | Hale Bopp | A cover of the song Kitty by the incredible Irish punk band The Pouges on my accordion. (in a different key though) Lyrics: Oh Kitty, My Darling, remember That the doom will be mine if I stay 'Tis far better to part, though it's hard to Than to rot in their prison away 'Tis far better to part, though it's hard to Than to rot in their prison away So softly he kissed her pale lips 'Twas the same story over an o'er Hush Mavourneen, the Police are watching And you know that I must go ashore Hush now Bernie, the Police are watching And you know that I must go ashore Any day I'll be over the mountain There'll be time enough left for to cry So good night and God gaurd you forever And write to me once you get by So good night and God gaurd you forever And write to me once you get by | ["Accordion"] | ["accordion player", "accordion harmony", "youtube music video", "accordion lessons", "high gain music", "bad audio quality", "soloist", "home recording", "slow tempo", "lilting music", "emotional", "cheerful", "melancholic", "groovy", "romantic", "instrumental music", "emotional", "screechy tones"] | 1 | o1E579RL33w | 4603 | |
"Eu Quero é Sossego", de K-Ximbinho, com Nonato Lima e Grupo Murmurando.mp4 | The song is an instrumental. The tempo is medium with an accordion player, guitar rhythm, flute player and other percussion playing in harmony. The song is groovy and has gypsy flavour to it. The song audio quality is poor with ambient crowd noises. | 2013-01-24T15:01:39Z | claudeide | Programa Brasileirinho, 20 de Janeiro de 2013 - Acordeonista Nonato Lima toca a música "Eu Quero é sossego", de K-Ximbinho, acompanhado pelo Quinteto Murmurando. | ["Wind instrument, woodwind instrument", "Accordion"] | ["accordion player", "life is good", "relaxing", "jam session", "home studio", "melancholic", "nostalgic moments", "people enjoying the music", "instrumental harmony", "folk music", "flute playing", "guitar playing", "live jam", "instrumental music", "medium tempo", "ambient crowd noise", "enthusiastic", "dance music", "gypsy music", "folk music", "ethnic instruments", "dance music", "live performance"] | 1 | tbovKStEnME | 5051 |
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;