musiccaps_details (view)
2 rows where musiccaps_aspects contains "brass instrument", musiccaps_aspects contains "french horn" and musiccaps_aspects contains "tutorial"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- brass instrument · 2 ✖
- french horn · 2 ✖
- tutorial · 2 ✖
- aerophone 1
- american accent 1
- counting 1
- counting in french 1
- french horn tutorial 1
- holding notes 1
- instrumental 1
- intricately coiled instrument 1
- keeping beat 1
- male speaking 1
- male voice 1
- male voice speaking 1
- monotone 1
- rich 1
- single note 1
- the horn 1
- wind instrument 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | ||
Pro Tips - Quickly Remove Water From Your Horn | This is a tutorial involving the french horn. We have an American male speaking, giving instruction related to the french horn instrument. At a point in the clip, the musician plays one note on the horn. | 2013-05-17T18:23:06Z | The United States Army Field Band | Master Sgt. Robert Cherry, horn player with The U.S. Army Field Band, demonstrates a quick and easy way to remove all water from a horn. http://www.armyfieldband.com http://www.youtube.com/ArmyFieldBand http://www.facebook.com/ArmyFieldBand http://twitter.com/armyfieldband https://www.instagram.com/armyfieldband/ http://www.facebook.com/thesixstringsoldiers For more information visit our website or contact: Educational Activities Coordinator The United States Army Field Band 4214 Field Band Drive Fort Meade, Maryland 20755-5330 #horn #frenchhorn #musiced | ["Brass instrument", "French horn"] | ["tutorial", "french horn", "single note", "male speaking", "american accent", "brass instrument"] | 3 | nr9oLIsbDyQ | 4582 |
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;