musiccaps_details (view)
3 rows where musiccaps_names contains "Brass instrument" and musiccaps_names contains "Speech"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- male voice 2
- aerophone 1
- brass instrument 1
- contra alto clarinet 1
- coughing 1
- counting 1
- counting in french 1
- french horn 1
- french horn tutorial 1
- holding notes 1
- instructive speaking 1
- instrumental 1
- intricately coiled instrument 1
- japanese language 1
- keeping beat 1
- live recording 1
- male voice speaking 1
- metronome click 1
- monotone 1
- rich 1
- simple motif 1
- the horn 1
- trombone lesson 1
- tutorial 1
- wind instrument 1
- woman muffled speaking 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Brio使い方のポイント⑤ | This is the recording of a trombone lesson. The male instructor is playing a note on the trombone and then speaking in an instructive manner in the Japanese language. The click of the metronome can be heard in the background. This recording can be sampled for use in beat-making. | 2011-11-03T01:40:01Z | briobrass | Brio de Brass! Ver.1の一部です。 低音を吹くときアンブシュアを緩めたり、タンギングだけで音を出さないよう気をつけましょう。 Brioを使用するときと同じフォームで吹けるようにしましょう。 | ["Brass instrument", "Finger snapping", "Music", "Musical instrument", "Trumpet", "Speech"] | ["trombone lesson", "male voice", "japanese language", "instructive speaking", "metronome click"] | 9 | II1oyaWPiD0 | 1889 | |
Sarabande & Bouree (Refined!) - Contra Alto Clarinet | Here we have a live recording of a simple motif being played on a contra alto clarinet, which has a deeper tone than other clarinets. The player coughs at the beginning of the recording, mumbles a few words softly, and then plays a simple slow motif. | 2008-01-10T05:29:32Z | Abby M | Omg! More videos! I'm re-doing the Sarabande and Bouree that I played for you once, because I've practiced a LOT more. And now it's better. I hope. :D So me and my private teacher Frederick shall play for you. And read some music jokes at the end. :3 | ["Cough", "Brass instrument", "Music", "Musical instrument", "Speech"] | ["contra alto clarinet", "coughing", "woman muffled speaking", "live recording", "simple motif"] | 3 | _AjXY9cHCxA | 3452 | |
Corno Francés II | This music is an instrumental tutorial. A male musician is keeping count in French to the drone-like tune of a French Horn. The audio is not clear and has a lot of static. | 2009-06-18T02:11:08Z | orquestachile | ["Brass instrument", "Foghorn", "Musical instrument", "Speech"] | ["instrumental", "monotone", "male voice", "brass instrument", "wind instrument", "aerophone", "rich", "intricately coiled instrument", "the horn", "french horn", "counting in french", "male voice speaking", "counting", "keeping beat", "tutorial", "french horn tutorial", "holding notes"] | 7 | gX9OuOKLLTQ | 4036 |
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;