musiccaps_details (view)
3 rows where "youtube_published" is on date 2010-08-06 sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- acoustic drums 1
- acoustic guitars 1
- ambient sounds 1
- birds chirping 1
- e-bass 1
- emphatic vocals 1
- folk song 1
- haunting melody 1
- lilting 1
- live audience 1
- live performance 1
- lively spanish guitar 1
- low quality 1
- male backing voices 1
- male vocalist 1
- male voice singing/rapping 1
- medium tempo 1
- minimalist 1
- noisy 1
- outdoor 1
- people talking 1
- popular folk music 1
- powerful vocals 1
- regional music 1
- shaker 1
- short exhale blow 1
- ska 1
- spanish song 1
- uptempo 1
- vocals 1
- wide nature sounds 1
- wooden rubbing sound effect 1
musiccaps_names (array) 11 ✖
- Music 3
- Music of Latin America 2
- Didgeridoo 1
- Flamenco 1
- Funk 1
- Music of Africa 1
- Outside, rural or natural 1
- Singing 1
- Ska 1
- Swing music 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DEUX ZACH SKA SKA apres une histoir vrais ... | This song sounds lightly uplifting. An e-bass is playing a repeating melody along with a guitar playing an almost melody at a higher key. Another acoustic guitar is strumming chords. The male voice is singing almost rapping/talking while backing voices are singing repeating the melody and phrases. This song may be playing outside on a bike on a sunny day. | 2010-08-06T23:42:32Z | zach deux | ["Swing music", "Music of Africa", "Funk", "Music", "Ska", "Music of Latin America"] | ["ska", "acoustic guitars", "shaker", "e-bass", "acoustic drums", "male voice singing/rapping", "male backing voices", "uptempo"] | 6 | 0OYlHvyfNk4 | 158 | ||
Making a Didgeridoo (David Hudson) | The low quality, noisy recording features a wooden rubbing sound effect, followed by a short exhale blow. The recording has wide natural sounds, including birds chirping, as it was recorded outdoors. | 2010-08-06T06:45:34Z | Samuel Wright | David Hudson demonstrates how to find, cut down and prepare a tree to make a Didgeridoo. He then prepares, paints and presents the final product for performance. The Didgeridoo is a traditional instrument of the Aboriginal people from Arnhem Land in Northern Australia. It was originally known as a Yirdaki in the traditional language. Visit David Hudson's website here: http://www.davidhudson.com.au/ The uploading of this video has been approved by David Hudson. | ["Didgeridoo", "Music", "Outside, rural or natural"] | ["short exhale blow", "wooden rubbing sound effect", "wide nature sounds", "birds chirping", "outdoor", "low quality", "noisy"] | 4 | 2lBZ6yPW9WU | 405 | |
Juan Fernando canta fandangos de Huelva en Amsterdam | A male vocalist sings this powerful solo in a foreign language. The tempo is medium with a spanish guitar accompaniment. The song has minimalist music with captivating, lilting and almost haunting vocals. This is a live performance with ambient sounds of people talking. The audio quality is inferior as it is an amateur recording. This song is a Latin/Spanish Folk song. | 2010-08-06T14:25:01Z | coroflamenco | Juan Fernando en un concierta del cuadro de cante de la Peña Flamenca de Huelva y del coro flamenco Calle Real en Amsterdam. Toque Antonio Dovao, Ramón Jesús Díaz. Baile: Teresa Jaldón, Director de cine: Stijn van der Loo, studio BBH | ["Singing", "Yodeling", "Flamenco", "Music", "Music of Latin America"] | ["male vocalist", "medium tempo", "spanish song", "minimalist", "folk song", "regional music", "popular folk music", "lively spanish guitar", "emphatic vocals", "powerful vocals", "live performance", "live audience", "ambient sounds", "people talking", "lilting", "haunting melody", "vocals"] | 7 | _zQTlTCqMzs | 3508 |
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;