musiccaps_details (view)
2 rows where musiccaps_aspects contains "single note" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 10 ✖
- single note · 2 ✖
- american accent 1
- brass instrument 1
- french horn 1
- instrumental 1
- male speaking 1
- no other instruments 1
- no voices 1
- saxophone song 1
- tutorial 1
musiccaps_names (array) 3 ✖
- Brass instrument · 2 ✖
- French horn 1
- Saxophone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Altissimo fingerings Tenor Sax | This clip features a saxophone being played. Only one note is played on the instrument and the note fades away. As it fades away, the sound of air being blown through it can be heard. There are no other instruments in this song. There are no voices in this song. This song can be played in an instructional video. | 2008-11-13T17:11:02Z | Anibal Rojas | Episode I of SAXREX SESSIONS - Altissimo fingerings that might work for you -Anibal Rojas | ["Brass instrument", "Saxophone"] | ["saxophone song", "single note", "no other instruments", "no voices", "instrumental"] | 0 | Qe_KwKVDgoE | 2633 | |
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;