musiccaps_details (view)
2 rows where musiccaps_author = 2 and musiccaps_names contains "Humming" sorted by musiccaps_author
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 10 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Franco Formica & Oxana Lebedew - Inka Dance | The music excerpt starts off with a Latin band with instruments such as trombones, trumpets, upright bass, flute and latin percussion instruments. After a few seconds the band stops and a female voice starts to sing a voice that starts in the high register and moves to the low one. Right between these two moments one can hear claps coming from a crowd of people. Towards the ending of the excerpt the voice finishes singing the melody and the band starts again. | 2008-11-05T17:12:24Z | afrobot2007 | 2008 World Super Stars Dance Festival Latin | ["Humming", "Music"] | ["female voice", "crowd clapping", "trombones", "trumpets", "upright bass", "flute", "latin percussion"] | 2 | KrK8Giu9ZUc | 2126 | |
Walk Of Life by a cappella group Club For Five | The music features a group of male and female voices singing a melody in vocal harmony. Two of them are playing the melody on different pitches and at least another two are accompanying them with a rhythmic pattern that's sung with a voice effect. | 2008-10-09T11:40:02Z | ClubForFive | Joulukiertue 2013 "Jouluna" liput: http://www.clubforfive.fi Kiertuepaikkakunnat: 19.11. Järvenpää (Järvenpää-talo) 20.11. Kuusankoski (Kuusankoskitalo) 21.11. Mikkeli (Mikaeli) 22.11. Imatra (Kulttuuritalo Virta) 29.11. Hyvinkää (Hyvinkääsali) 30.11. Helsinki (Kallion kirkko) 2.12. Tampere (Tampere-talo) 3.12. Jyväskylä (Paviljonki) 4.12. Hämeenlinna (Verkatehdas) 9.12. Seinäjoki (Lakeuden Ristin kirkko) 10.12. Lahti (Sibeliustalo) 11.12. Turku (Logomo) 14.12. Helsinki (Musiikkitalo x2) 15.12. Pori (Promenadi) 17.12. Helsinki (Kulttuuritalo) 19.12. Joensuu (Carelia-sali) 20.12. Kuopio (Musiikkikeskus) 21.12. Espoo (Kulttuurikeskus) Liput: http://www.clubforfive.fi http://www.clubforfive.fi Live performance. This is a clip from their tour in China 2007. | ["Singing", "Humming", "Music"] | ["male and female voices", "vocal harmony", "voice effects"] | 2 | V3Vvp5HS90k | 2971 |
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;