musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "bass" and musiccaps_names contains "Accordion" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- bass · 2 ✖
- instrumental 2
- accordion 1
- accordion song 1
- acoustic guitar 1
- folk song 1
- guitar 1
- latin rhythm song 1
- low quality audio 1
- no other instruments 1
- no percussion 1
- no voice 1
- no voices 1
- percussion 1
- violin 1
- waltz 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Б.Тихонов вальс "Пушинка" | 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 | |
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 |
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;