musiccaps_details (view)
2 rows where musiccaps_aspects contains "applause" and musiccaps_names contains "Wind instrument, woodwind instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- applause · 2 ✖
- classical 1
- cover 1
- crowd cheering 1
- groovy piano melody 1
- high pitched humming 1
- indian 1
- live recording 1
- low pitched humming 1
- low quality 1
- mashak instrument 1
- mono 1
- noisy 1
- saxophone melody 1
- south asian 1
musiccaps_names (array) 4 ✖
- Wind instrument, woodwind instrument · 2 ✖
- Bagpipes 1
- Brass instrument 1
- Saxophone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ana Maria Tarantus Sandu | The low quality recording features a cover of a classical song and it consists of a saxophone solo melody playing over a groovy piano melody. At the very end of the loop, there is an applause. It sounds easygoing, passionate and the recording is noisy and in mono. | 2010-11-27T18:22:17Z | Emanoil Tarantus | Hora Lautareasca si Piesa de Concert | ["Brass instrument", "Saxophone", "Wind instrument, woodwind instrument"] | ["low quality", "mono", "noisy", "applause", "saxophone melody", "groovy piano melody", "classical", "cover"] | 4 | LaeRCg-NdeY | 2204 | |
Utsavam 2013 IV Sasi Event Part 3 | This is a live recording. We hear a set of Indian bagpipes, otherwise known as mashak, playing a complex motif. There are two singers doing open-mouthed humming in contrasting high and low pitches simultaneously. We hear the applause and cheering of a crowd as well. At the beginning, a male speaker and female speaker each make some comments in a South Asian language. | 2013-06-08T15:06:14Z | Asianet | Utsavam 2013 IV Sasi Event Part 3 Subscribe to Asianet Official YouTube Channel for more videos: www.youtube.com/asianetglobal For Asianet News and Updates LIKE our Facebook Page: www.facebook.com/asianetglobal and follow us on Twitter: www.twitter.com/theasianet | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["mashak instrument", "live recording", "applause", "low pitched humming", "high pitched humming", "crowd cheering", "south asian", "indian"] | 3 | cu0k3Uclp1I | 3752 |
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;