musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_author = 0 and musiccaps_names contains "Accordion" sorted by musiccaps_caption
This data as json, CSV (advanced)
Suggested facets: musiccaps_names, youtube_published (date)
musiccaps_aspects (array) 28 ✖
- instrumental 4
- accordion 3
- folk song 3
- no voices 3
- acoustic guitar 2
- bass 2
- guitar 2
- low quality audio 2
- moderate tempo 2
- no voice 2
- tuba 2
- violin 2
- accordion music 1
- accordion song 1
- clarinet 1
- double base 1
- flute 1
- hammered dulcimer 1
- happy mood 1
- latin rhythm song 1
- male voices 1
- no other instruments 1
- no percussion 1
- percussion 1
- slow tempo 1
- trumpet 1
- waltz 1
- waltz song 1
musiccaps_names (array) 4 ✖
- Accordion · 5 ✖
- Music 1
- Musical instrument 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 |
---|---|---|---|---|---|---|---|---|---|---|
Salzburg Quintett - Oberkrainer Medley | This folk song features a clarinet playing the main melody. A trumpet plays a similar melody in harmony. This is accompanied by a tuba playing the bass notes. An acoustic guitar plays chords for this song. There are no voices in this song. This is an instrumental song. There is no percussion in this song. This song can be played at an Oktoberfest party. | 2009-01-31T20:58:16Z | Salzburg Quintett ursprünglich | Salzburg Quintett - Oberkrainer Medley, Festzelt in Inzing/Tirol 1984 | ["Accordion"] | ["low quality audio", "folk song", "guitar", "accordion", "tuba", "no voices", "instrumental", "slow tempo", "clarinet", "trumpet"] | 0 | qRgefptkDeo | 4786 | |
Б.Тихонов вальс "Пушинка" | 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 | |
Los Paraguayos | This low quality audio features an accordion playing the main melody. This is accompanied by percussion playing a simple beat. A tambourine is played with the percussion. This is a Latin style song. The guitar plays groups of three ascending and one descending note per bar. The bass plays a Latin rhythm. There are no voices in this song. This song is an instrumental. This song can be played at a house party. | 2008-07-24T14:35:37Z | Spiciu | Performing their tune MANANTIAL - The Spring. | ["Accordion"] | ["latin rhythm song", "accordion song", "guitar", "percussion", "no voice", "instrumental", "bass", "low quality audio"] | 0 | QNQ3sAMxZPY | 2616 | |
Ansambel Lojze Slak / Dezelica sonca in grozdja. | This waltz song features accordions playing in harmony. Male voices sing the main melody. The voices sing in harmony. When the voices start to sing, the accordions play the same melody as the voices. The bass is played on a tuba. An acoustic guitar strums chords. A tambourine plays the part of the percussion. There are trumpets and clarinets playing in this song. This is a folk song. The mood of this song is happy. | 2012-08-09T23:11:27Z | Johan Hopman | Lojzeta Slaka Was A Great Diatonic Button Accordion Player From Slovenia. Born: 23 July 1932 In Jordankal,Near Mirna Pec Died: 29 September 2011 In Ljubliana. Lojzeta Was Burried In Sentvid,He Was 79 Jears Old. | ["Accordion"] | ["accordion music", "tuba", "acoustic guitar", "male voices", "waltz song", "moderate tempo"] | 0 | zj2G-KVw4N4 | 5506 |
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;