musiccaps_details (view)
2 rows where musiccaps_aspects contains "live performance" and musiccaps_aspects contains "marimba"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- live performance · 2 ✖
- marimba · 2 ✖
- applause 1
- cheerful 1
- latin dance music 1
- live recording 1
- lively 1
- off-pitch playing 1
- percussion 1
- playful 1
- steel percussion 1
- vibrant 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tango and Mystic Fire | This clip features a singular marimba being played. It is a low-quality recording of a performance wherein the performer plays some off-key notes. We hear applause after the performer stops playing. | 2010-04-26T05:45:33Z | Patrick Riske | This was the other solo that I went to state for. The solo called for playing two pieces of music from the book "Impressions on Wood". I chose to play Mystic Fire and Tango. I got a first on the solo! | ["Applause", "Music"] | ["marimba", "live performance", "live recording", "applause", "off-pitch playing"] | 3 | 5lZFGZXH20E | 691 | |
Trinidad All Stars - "Play yourself" - Panorama semis 2012, on the drag | This is a latin dance music piece. There is a heavy use of percussive elements such as marimba and steel percussion. They act both as the melodic and the rhythmic background. The atmosphere of the performance is lively and cheerful. This piece could be used as an accompaniment piece for latin dance courses. | 2012-02-06T16:06:48Z | KalindaProductions | Follow us on Facebook: Kalinda Productions Contact us at kalindaproductions @gmail.com | ["Music", "Steelpan"] | ["latin dance music", "live performance", "percussion", "marimba", "steel percussion", "lively", "playful", "cheerful", "vibrant"] | 9 | Mnk6590abfY | 2297 |
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;