musiccaps_details (view)
1 row where musiccaps_aspects contains "moderate tempo", musiccaps_aspects contains "no other instruments", musiccaps_aspects contains "waltz time" and musiccaps_author = 0
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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;