musiccaps_details (view)
2 rows where musiccaps_aspects contains "folk song", musiccaps_aspects contains "no other instruments" and musiccaps_names contains "Pizzicato"
This data as json, CSV (advanced)
musiccaps_aspects (array) 9 ✖
- folk song · 2 ✖
- instrumental 2
- no other instruments · 2 ✖
- no voices 2
- harp song 1
- kora song 1
- moderate tempo 1
- slow tempo 1
- waltz time 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Scarborough Fair | This folk song features the melody played on a harp. The instrument plays the bass and treble notes of the song. There are no other instruments in this song. There is no voice in this song. This song can be played in a sad movie. | 2010-09-13T19:06:37Z | maplesquirrel | My version of Scarborough Fair. It was learned completely by ear, so unfortunately I cannot share sheet music for it. I hope you enjoy! | ["Harp", "Pizzicato"] | ["harp song", "no other instruments", "no voices", "instrumental", "slow tempo", "folk song"] | 0 | FiKY19GK6-8 | 1662 | |
Tata Dindin. Kora Player. Sakhadougou. | This folk song features a kora being played in waltz time. This starts off with the strings being plucked in waltz time followed by a descending run. The waltz plucking is played twice more followed by another descending run. There are no other instruments in this song. There are no voices in this song. This is an instrumental song. This song can be sampled and played in a hip-hop song. | 2014-04-03T20:16:47Z | Idlespectre | Tata Dindin is a Groit singer and Kora player from Gambia, West Africa. This is the first song of a series of songs that he played during a visit to Exeter, Devon, Where he stayed and played for a month in 1995. Unfortunately the songs were not given names during the performances, so I have given them numbers. Perhaps someone can help here... This first song is a solo performed at the Exeter Arts Centre. | ["Harp", "Pizzicato"] | ["kora song", "no other instruments", "no voices", "instrumental", "waltz time", "moderate tempo", "folk song"] | 0 | JHvLuYk6TfI | 1987 |
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;