musiccaps_details (view)
6 rows where musiccaps_aspects contains "accordion" and musiccaps_aspects contains "violin"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- accordion · 6 ✖
- violin · 6 ✖
- instrumental 3
- acoustic guitar 2
- bass 2
- flute 2
- folk song 2
- male voice 2
- no voices 2
- cheerful 1
- cimbalom 1
- contrabass 1
- double base 1
- double bass 1
- emotional song 1
- female choir 1
- folk music 1
- folkmusic 1
- foreign language 1
- hammered dulcimer 1
- happy mood 1
- live performance 1
- low quality audio 1
- low quality recording 1
- moderate tempo 1
- no other instruments 1
- no percussion 1
- no voice 1
- playful 1
- pop song 1
- romanian folk music 1
- rubab 1
- slow tempo 1
- tambourine 1
- uptempo 1
- vibrant 1
- waltz 1
youtube_published (date) 6 ✖
- 2008-01-24 1
- 2009-10-10 1
- 2010-05-26 1
- 2011-04-20 1
- 2012-01-02 1
- 2013-04-30 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Uzbek Classic Music | This folk song features a male voice singing the main melody in an emotional mood. This is accompanied by an accordion playing fills in the background. A violin plays a droning melody. There is no percussion in this song. This song can be played at a Central Asian classical concert. | 2008-01-24T15:19:53Z | TashChaynar | Bobomurod Hamdamov Ayrilma | ["Folk music", "Music"] | ["folk music", "rubab", "male voice", "slow tempo", "emotional song", "low quality audio", "violin", "accordion"] | 0 | -5f6hjZf9Yw | 12 | |
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 | |
Marin Doru- Ramane masa saraca | This low quality recording features a male voice singing the main melody in a foreign language. This is accompanied by percussion playing a simple beat with a Latin feel. The bass is played on a double bass. The double bass plays a groovy bassline. Flute fills are played in the background. An accordion plays melodies in harmony with the voice. This song has romantic overtones. This song can be played at the end credits of a mafia romance movie. | 2011-04-20T14:52:21Z | Beto stylle | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["low quality recording", "pop song", "male voice", "foreign language", "accordion", "double bass", "violin"] | 0 | 2bCuw7U_Rac | 387 | ||
Дунаю, Дунаю | A female choir is singing a melody. The instruments are playing the same melody. The percussion- section contains a bassline being played along with a tambourine. This song may be playing at a public folkfest. | 2009-10-10T22:36:29Z | ArattaMedia | Українська народна пісня у виконанні народного ансамблю "Вишня". Художній керівник - Адам Дзюба. Інформація про колектив - http://www.aratta-ukraine.com/text_ua.php?id=1401 DVD - http://opensharing.org/torrent/94519/ | ["Folk music", "Music", "Musical instrument"] | ["folkmusic", "violin", "accordion", "female choir", "bass", "tambourine", "flute", "acoustic guitar", "uptempo"] | 6 | O6QyYC7Tt2A | 2399 | |
Б.Тихонов вальс "Пушинка" | This folk song features a quarter. The main melody starts off with the accordion playing an ascending run. This is accompanied by the bass playing the root and fifth of the chords. An acoustic guitar strums chords in waltz time. After the accordion part, the violin plays the main melody and the same instruments back the violin. This song can be played in a village fair. | 2010-05-26T14:23:55Z | Сергей Боганов | Концерт в К/З МГИМ им. Шнитке 27.11.09г.: "Emotion Orchestra" под руководством Ю.Медяника | ["Accordion"] | ["folk song", "waltz", "no voices", "instrumental", "violin", "accordion", "bass", "acoustic guitar", "no percussion", "no other instruments"] | 0 | pDgWT99uaJ0 | 4691 | |
Sile de la Cernica, Marius Turneanu, Cezar Cazanoi - Hora re minor | This folk song features a variety of instruments. The main melody is played on a violin, flute and accordion. The double bass plays a running bass pattern. An acoustic guitar strums chords. A hammered dulcimer plays parts that give a percussive feel. There are no voices in this song. This is an instrumental song. This song can be played in a luxurious and lively brunch. | 2013-04-30T22:01:22Z | Ionascu George Florian | Sile de la Cernica, Marius Turneanu, Cezar Căzănoi, George Miu, Marius Gore, Victor de la Tr. Severin | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["folk song", "accordion", "violin", "double base", "flute", "hammered dulcimer", "no voices", "instrumental", "no voice", "moderate tempo", "happy mood"] | 0 | u68Ghaf_Phs | 5089 |
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;