musiccaps_details (view)
2 rows where musiccaps_aspects contains "french horn melody", musiccaps_aspects contains "low quality" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- french horn melody · 2 ✖
- low quality · 2 ✖
- passionate · 2 ✖
- arpeggiated guitar melody 1
- emotional 1
- mono 1
- muddy 1
- multiple layers 1
- noisy 1
- playback 1
- shimmering hi hats 1
- snappy rimshots 1
- soulful 1
musiccaps_names (array) 2 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
What a wonderful world Bb Horn | The low quality recording features a french horn melody played over playback that consists of snappy rimshots, shimmering hi hats and arpeggiated guitar melody. It sounds emotional and passionate, even though the recording is in mono and noisy. | 2009-01-31T21:52:21Z | KamilToni | Playing what a wonderful world on a Berkeley Bb piccolo/ mini french horn with a strawberries and creme mouthpieces MDC from kelly mouthpieces. i wasn't feeling good and i just wanted to post something up with this instrument.. | ["Brass instrument", "French horn"] | ["low quality", "mono", "noisy", "playback", "arpeggiated guitar melody", "snappy rimshots", "shimmering hi hats", "french horn melody", "emotional", "passionate"] | 4 | MNlzpCwdh4g | 2261 | |
【ホルン四重奏】ワールドイズマイン 演奏してみた by はるまめ | The low quality recording features multiple layers of french horn melodies. It sounds passionate, a bit muddy and soulful. | 2016-02-06T12:42:18Z | Haruka OGUCHIはるまめ | せかーーいでぇー いちーばん おーひーめーさーまー♪ 今回はワールドイズマインをホルン4重奏にアレンジして演奏してみました^^ 歌詞がかわいくてすっごい好きです^^ 。.。:+* ゚ ゜゚ *+:。.。:+* ゚ ゜゚ *+:。.。.。:+*゚ ゜゚ *+:。.。:+*゚ ゜゚ *+:。.。.。:+*+:。.。 このチャンネルは、ホルン奏者はるまめが好きな曲、好きな音、好きなものを 全力で配信していくチャンネルです。 楽しかったらチャンネル登録是非してください♪ https://www.youtube.com/channel/UCb1ahVMUAMMfarMQOIlWffg/ 出版中の楽譜はこちら! https://harumame.com/publish/ 動画で使用しているものもあります♪ はるまめ HP https://harumame.com/ はるまめの活動を応援してくださる方へ!https://harumame.com/498/ 。.。:+* ゚ ゜゚ *+:。.。:+* ゚ ゜゚ *+:。.。.。:+*゚ ゜゚ *+:。.。:+*゚ ゜゚ *+:。.。.。:+*+:。.。 | ["Brass instrument", "French horn"] | ["low quality", "multiple layers", "french horn melody", "passionate", "soulful", "muddy"] | 4 | s1QeDT7jqHQ | 4912 |
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;