musiccaps_details (view)
2 rows where musiccaps_aspects contains "male voice talking", musiccaps_aspects contains "medium tempo" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- instrumental 2
- male voice talking · 2 ✖
- medium tempo · 2 ✖
- ambient outdoor sounds 1
- animated 1
- animated electronic sound 1
- australian accent 1
- bee buzzing 1
- blowing raspberries 1
- breeze 1
- children’s song 1
- deep sound 1
- demonstration 1
- didgeridoo lesson 1
- didgeridoo melody 1
- didgeridoo tutorial 1
- engine sound 1
- foreign language 1
- four stringed instrument 1
- funny 1
- how to play didgeridoo 1
- incessant buzz 1
- mellow 1
- people talking 1
- rich 1
- soft 1
- ukelele melody 1
- vocal vibrations 1
musiccaps_names (array) 8 ✖
- Speech 2
- Didgeridoo 1
- Guitar 1
- Music 1
- Musical instrument 1
- Plucked string instrument 1
- Singing 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chikungunya | This music is a ukelele instrumental. The tempo is medium with the sound of a bee buzzing and an animated sound followed by a dialogue between two men in a foreign language. The music is mellow, soft and simple like it's meant for children. | 2014-10-04T21:51:37Z | Sancocho | Chinkungunya by Sancocho De los Creadores de "Ser Boricua Esta Brutal" Ahora les traemos Un tema exclusivo para internet Chinkungunya. Pronto Esperen el Disco Entero, pronto en Algun Momento y Despues las Presentaciones en Vivo, Creemos! WHAT!?! Composicion por Andre Caro y Osvaldo Friger con la Ayuda de Lejos de Dwella | ["Singing", "Guitar", "Music", "Musical instrument", "Ukulele", "Speech", "Plucked string instrument"] | ["instrumental", "medium tempo", "male voice talking", "soft", "mellow", "animated", "foreign language", "four stringed instrument", "bee buzzing", "ukelele melody", "animated electronic sound", "funny", "animated", "children’s song"] | 7 | I_wT76iYBdQ | 1920 | |
HOW TO PLAY DIDGERIDOO LONDON UK - Using Your Voice | This music is instrumental. The tempos medium with vocalisation that sounds like blowing raspberries or a motor, followed by a man giving instructions on how to use this technique on a didgeridoo followed by a didgeridoo sound. There are ambient sounds in the background like people talking and gentle breeze. The didgeridoo sound is deep, rich, droning and unique. This clip is a tutorial/lesson on how to play a didgeridoo . | 2007-05-28T08:00:21Z | Aboriginal Arts | You can embellish the basic drone sound of the didgeridoo by using your voice. If we liken the basic drone to the canvas for our musical expression, then your voice is the paint you use to colour that sound. We always advise warming up your voice first so that you do not strain yourself. This is a beginner's instroduction and more information can be found on our website http://www.aboriginalarts.co.uk/howtoplaydidgeridoo.html Or, if you're in London why not come and visit us! http://www.aboriginalarts.co.uk | ["Didgeridoo", "Speech"] | ["instrumental", "medium tempo", "male voice talking", "australian accent", "demonstration", "engine sound", "ambient outdoor sounds", "didgeridoo melody", "didgeridoo lesson", "didgeridoo tutorial", "how to play didgeridoo", "people talking", "breeze", "blowing raspberries", "incessant buzz", "vocal vibrations", "deep sound", "rich"] | 7 | VCozi4GDpxQ | 2982 |
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;