musiccaps_details (view)
4 rows where musiccaps_aspects contains "instrumental music" and musiccaps_names contains "Classical music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 59 ✖
- instrumental music · 4 ✖
- emotional 3
- medium tempo 3
- poor audio quality 2
- spirited 2
- western classical music 2
- average audio quality 1
- bells 1
- celestial music 1
- cellist 1
- cello concerto 1
- cheerful 1
- classical dance 1
- classical duet 1
- composers 1
- concert hall 1
- conductor 1
- dance groove 1
- dreamy feel 1
- dvorak 1
- entertaining 1
- flute playing 1
- good day 1
- great composers 1
- great technique 1
- grief 1
- groovy music 1
- home video quality 1
- hopeful 1
- japanese folk music 1
- live audience 1
- live performance 1
- marimba 1
- melancholic 1
- memdium tempo 1
- music rehearsal 1
- myriad of emotions 1
- no percussions 1
- no voices 1
- nostalgia 1
- opera hall 1
- passionate 1
- philharmonic orchestra 1
- piano accompaniment 1
- poignant 1
- rich ancestry 1
- romantic 1
- slow tempo 1
- string section 1
- stringed instrument harmony 1
- studio chamber echo 1
- timpani 1
- timpani bangs loud 1
- traditional japanese music 1
- tremolo strings 1
- violin solo 1
- violins playing harmony 1
- virtuously 1
- wind sections 1
musiccaps_names (array) 11 ✖
- Classical music · 4 ✖
- Music 4
- Musical instrument 3
- Violin, fiddle 2
- Bowed string instrument 1
- Cello 1
- Marimba, xylophone 1
- Orchestra 1
- Percussion 1
- Piano 1
- Vibraphone 1
youtube_published (date) 4 ✖
- 2008-07-19 1
- 2009-06-19 1
- 2010-07-23 1
- 2012-01-13 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Japanese Classical Music | The song is an instrumental. The song is medium tempo with a flute paging embody, various stringed instruments playing in harmony and no percussion. The song is passionate and emotional. The audio quality is average . | 2008-07-19T05:20:35Z | MichiganWinters | Hello | ["Music", "Classical music"] | ["japanese folk music", "flute playing", "average audio quality", "traditional japanese music", "rich ancestry", "melancholic", "poignant", "stringed instrument harmony", "instrumental music", "melancholic", "no percussions", "medium tempo", "emotional", "romantic", "grief", "hopeful", "myriad of emotions", "tremolo strings"] | 1 | N-dzfI3L5ic | 2315 | |
The Legend Of Zelda - MEDLEY - Piano and Violin cover | The song is an instrumental. The song is medium tempo with a violin playing a solo with a piano accompaniment. The song is emotional and positive. The song is a classic western hit and has poor audio quality in general. | 2010-07-23T16:32:17Z | Furyxx Violin | ZELDA MEDLEY on Piano and violin ! Hey guys ! Thx you everybody for your support ! Don't forget to share and suscribe if you liked it :) Here is our new video after a long time !! (this time it's the real one !) Music from Zelda, koji Kondo Enjoy! ;) ps: We know that we need a little hair cut :p | ["Music", "Musical instrument", "Piano", "Violin, fiddle", "Classical music"] | ["piano accompaniment", "violin solo", "instrumental music", "music rehearsal", "classical duet", "medium tempo", "western classical music", "studio chamber echo", "instrumental music", "memdium tempo", "emotional", "dance groove", "cheerful", "spirited", "nostalgia", "good day", "poor audio quality", "home video quality", "entertaining", "classical dance", "composers"] | 1 | hkWcUtga1lw | 4135 | |
打楽器4重奏"宝島への地図"堀金中【金賞】 | This instrumental song features the main melody played on bells and the marimba. A timpani plays the percussion. The tempo of this song is slow. This song has no voices. The song has a celestial and dreamy feel. This song can be used in a dreamy sequence in a children's movie. There are no voices in this song. | 2012-01-13T07:58:48Z | おにぎり総合音楽チャンネル | ◆練習用 A 0:39 B 0:57 C 1:20 D 1:43 E 2:13 F 2:38 G 3:07 H 3:29 I 3:45 J 3:57 K 4:07 L 4:14 M 4:23 N 4:32 O 4:38 平成24年1月7日(土) 大町文化会館 大ホール 安曇地区大会【金賞】http://www.ajba.or.jp/nagano/ankon/201122A.htm (中信ブロック大会【銀賞】)http://www.ajba.or.jp/nagano/ankon/201122D.htm 【演奏曲】宝島への地図 【作曲】高橋宏樹 【出版社】ブレーン http://www.brain-shop.net/shop/g/gENMS-84222/ 【メンバー構成】堀金中学校生徒 Perc.1(Glock./Xylo./Tri./Sus.Cym.) 百瀬愛理沙さん(1年) Perc.2(Vib./Tamb.) 嶋田大輔さん(2年) Perc.3(Tri./Mari./Sus.Cym./Tamb.) 猿田茉耶さん(1年) Perc.4(Mari./Timp./Tri.) 吉田ちひらさん(1年) ※作曲者・保護者の許諾を受けて公開 作曲家 高橋宏樹先生から直々のコメントを頂戴したので紹介します。 初めまして、「宝島への地図」選曲いただき大変光栄でございます。 そしてコンテストでの金賞受賞おめでというございます。 動画拝見させていただきました。とても音楽的に作られていて物語の 見えてくる暖かい感じの演奏ですね。公開はどうぞしていただければと 思います。今後も機会ありましたら何卒よろしくお願いいたします。 高橋宏樹 温かいコメント、本当にありがとうございました! #宝島への地図 #打楽器アンサンブル #金賞 #アンサンブルコンテスト #アンコン #中学生 #吹奏楽 #おにぎり総合音楽チャンネル | ["Music", "Musical instrument", "Marimba, xylophone", "Vibraphone", "Classical music", "Percussion"] | ["bells", "marimba", "timpani", "instrumental music", "celestial music", "dreamy feel", "no voices", "slow tempo"] | 0 | yRU7DifuAXY | 5409 | |
Dvořák: Cello Concerto / Isserlis · Gilbert · Berliner Philharmoniker | The song is an instrumental. The tempo is medium with a cellist playing a virtuoso solo accompanied by a string section harmony, flutes in harmony and a loud banging timpani. The song is spirited and passionate with poor audio quality. The song is a western classical piece. | 2009-06-19T08:28:26Z | Berliner Philharmoniker | Full-length concert: http://www.digitalconcerthall.com/concert/27/?a=youtube&c=true Antonín Dvořák: Cello Concerto / Steven Isserlis, cello · Alan Gilbert, conductor · Berliner Philharmoniker / Recorded at the Berlin Philharmonie, 19 April 2009. The Berliner Philharmoniker's Digital Concert Hall: http://www.digitalconcerthall.com Subscribe to our newsletter: http://www.digitalconcerthall.com/newsletter Website of the Berliner Philharmoniker: http://www.berliner-philharmoniker.de | ["Cello", "Music", "Musical instrument", "Orchestra", "Violin, fiddle", "Classical music", "Bowed string instrument"] | ["cellist", "string section", "philharmonic orchestra", "cello concerto", "dvorak", "virtuously", "timpani bangs loud", "medium tempo", "wind sections", "violins playing harmony", "groovy music", "western classical music", "great composers", "conductor", "opera hall", "live audience", "live performance", "instrumental music", "passionate", "spirited", "emotional", "great technique", "poor audio quality", "concert hall"] | 1 | yrme-KRBvzk | 5445 |
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;