musiccaps_details (view)
3 rows where musiccaps_aspects contains "breeze", musiccaps_aspects contains "people talking" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- breeze · 3 ✖
- instrumental 3
- people talking · 3 ✖
- medium tempo 2
- amateur recording 1
- ambient nature sounds 1
- ambient outdoor sounds 1
- ambient sounds 1
- australian accent 1
- blowing raspberries 1
- cheering 1
- clapping 1
- deep sound 1
- demonstration 1
- didgeridoo lesson 1
- didgeridoo melody 1
- didgeridoo tutorial 1
- engine sound 1
- fast tempo 1
- fresh 1
- groovy bas line 1
- harmonica melody 1
- how to play didgeridoo 1
- incessant buzz 1
- incoherent music 1
- inferior audio recording 1
- keyboard harmony 1
- lively 1
- lively drums 1
- male voice talking 1
- melodious 1
- muddled audio 1
- rich 1
- simple vivacious 1
- steel drum 1
- steel pan 1
- tambourine beats 1
- vocal vibrations 1
- white noise 1
- youthful 1
musiccaps_names (array) 4 ✖
- Music 2
- Steelpan 2
- Didgeridoo 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Guantanamera - Steel Drum Music (Kool Vibes and Carlton) | This music is instrumental. The tempo is fast with a lively keyboard harmony, steady drumming, groovy bass lines and harmonica melodic. The song is fresh, groovy, sunny, happy; vivacious and spirited. The song is a live performance outdoors as there are ambient nature sounds like the breeze,and sound of people talking. | 2010-05-02T01:44:59Z | nineeighttwo | Kool Vibes with Carlton (Stick 2 Pan) on Steel Drums. St. Lucian band which performs in Florida, Georgia, Carolinas, New York, Texas...East and West coast. | ["Music", "Steelpan"] | ["instrumental", "fast tempo", "lively", "fresh", "breeze", "people talking", "clapping", "cheering", "tambourine beats", "youthful", "simple vivacious", "ambient nature sounds", "people talking", "keyboard harmony", "lively drums", "groovy bas line", "harmonica melody"] | 7 | 1j13NdQiw8c | 301 | |
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 | |
Trinidad Music - Youth plays steelpan - Indian Trail Church | This music is instrumental. The tempo is medium with a melodic steel pan harmony. The audio quality however is inferior and amateur,so the music is muddled. There are ambient sounds of breeze and people talking , indicating that this is a live performance. | 2009-06-18T20:47:10Z | Home and Happy. | A youth pannist plays at Indian Trails Open Bible Church. Steelpans (also known as steeldrums or pans, and sometimes collectively with musicians as a steelband) is a musical instrument and a form of music originating from Trinidad. Steelpan musicians are called pannists. | ["Music", "Steelpan"] | ["white noise", "instrumental", "medium tempo", "steel pan", "amateur recording", "muddled audio", "steel drum", "inferior audio recording", "incoherent music", "melodious", "ambient sounds", "people talking", "breeze"] | 7 | _ALGXHquYkM | 3450 |
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;