musiccaps_details (view)
3 rows where musiccaps_aspects contains "folk song" and musiccaps_aspects contains "no voice"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- folk song · 3 ✖
- instrumental 3
- no voice · 3 ✖
- no voices 2
- accordion 1
- celebration song 1
- clarinet song 1
- double base 1
- fast tempo 1
- flute 1
- hammered dulcimer 1
- hand percussion 1
- happy mood 1
- joyful 1
- mandolin 1
- moderate tempo 1
- sound of trumpets 1
- tambourine 1
- violin 1
musiccaps_names (array) 9 ✖
- Music 3
- Musical instrument 2
- Accordion 1
- Bluegrass 1
- Guitar 1
- Mandolin 1
- Maraca 1
- Plucked string 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 |
---|---|---|---|---|---|---|---|---|---|---|
SHOLOHO Vadim Gavrilov-Vugar Sultanov | This folk song features the main melody played on the clarinet. This is accompanied by percussion played by hand. The tambourine is playing on every count. The bass plays with a groovy feel. The bass plays notes continuously at every count. The mood of this song is upbeat and happy. There are no voices in this song. This song can be played at a celebration party. | 2011-07-02T00:14:04Z | Vadim Gavrilov | Snew Group- ORIGINAL. Tancuut vse!!! SHOLOHO-PAPAH-SULEIMANI+MIZRAHI | ["Music", "Maraca"] | ["folk song", "clarinet song", "tambourine", "no voices", "hand percussion", "sound of trumpets", "fast tempo", "instrumental", "no voice", "celebration song"] | 0 | PZZxVIIOQPo | 2545 | |
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 | |
mandolinvideo.avi | The excerpt features a mandolin playing a folk song. This is the only musical instrument playing, there aren't others or any voices singing. The character of the song is joyful. | 2012-04-19T17:06:56Z | Stuart Wailing Resonators | This video is of a Stuart Wailing Resonator Mandolin being played by Phil Tyler. See other instrument made by Stuart Wailing at https://stuartwailingresonator.000webhostapp.com/index.html | ["Guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["mandolin", "instrumental", "no voice", "joyful", "folk song"] | 2 | w2vMywh5Nto | 5232 |
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;