musiccaps_details (view)
2 rows where musiccaps_aspects contains "conductor", musiccaps_aspects contains "fast tempo" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- conductor · 2 ✖
- fast tempo · 2 ✖
- instrumental music 2
- animated 1
- bad audio quality 1
- brass section 1
- bumblebee 1
- composer 1
- concert hall 1
- documentary soundtrack 1
- documentary video 1
- energetic 1
- exciting 1
- funny 1
- great composers 1
- great journey 1
- high pitched notes 1
- horn section 1
- magical 1
- melancholic 1
- mysterious 1
- opera hall 1
- orchestra 1
- passionate 1
- positive 1
- pulsating 1
- spirited 1
- string quartet 1
- string section 1
- string section harmony 1
- studio 1
- twists and turns 1
- vibrato 1
- violin accompaniment 1
- violin solo 1
- violin technique 1
- virtuoso 1
- water splashing sound 1
- western classical music 1
- wondrous 1
- wooden xylophone 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Quatuor EBENE: Ravel, Debussy, Fauré -String Quartets | The song is instrumental. The tempo is fast with violins playing in harmony showing exemplary technique. The song is emotional, spirited and passionate. The song is a western classical music hit. The audio quality is poor. | 2013-07-26T16:49:10Z | Warner Classics | Debussy, Fauré & Ravel: String Quartets CD available on: http://bit.ly/FaureRavelStringquartet http://www.emiclassics.com/quatuor-ebene https://www.facebook.com/QuatuorEbene The Quatuor Ebènes debut recording on Virgin Classics brings together the string quartets of the three emblematic French composers of the late 19th and early 20tb centuries: Fauré, Debussy and Ravel. ________________________________________ ________________________________________ Buy from Amazon (USA): http://www.amazon.com/exec/obidos/ASIN/B001BWQWKS/emi-jazz-class-21/ref%3Dnosim ________________________________________ Buy from Amazon (UK): http://www.amazon.co.uk/exec/obidos/ASIN/B001BWQWKS/emi-jazz-class-21/ref%3Dnosim ________________________________________ Buy from Amazon (FR): http://www.amazon.fr/exec/obidos/ASIN/B001BWQWKS/emi-jazz-class-21/ref%3Dnosim ________________________________________ Buy from Amazon (DE): http://www.amazon.de/exec/obidos/ASIN/B001BWQWKS/emi-jazz-class-21/ref%3Dnosim ________________________________________ http://www.quatuorebene.com/ http://www.emiclassics.com http://www.emiclassics.de ________________________________________ __________ Warner Classics ► Website: http://www.warnerclassics.com Subscribe to our: ► YT- Channel: https://wnrcl.me/subscribeYT ► Newsletter https://wnrcl.me/subscribeNL Follow us on: ► Facebook: http://www.fb.com/WarnerClassicsErato ► Instagram: http://www.instagram.com/warner_classics ► Twitter: http://twitter.com/WarnerClassics ► YouTube: https://www.youtube.com/warnerclassics Listen to us on: ► Spotify: http://open.spotify.com/user/warnerclassics ► Apple Music: http://itunes.apple.com/curator/warner-classics/1153741571 ► Deezer https://www.deezer.com/profile/321050935 Warner Classics is the home of classical music, featuring iconic high audio quality recordings from the greatest classical legends, opera stars and orchestras of the last century. Discover our unique collection of live performances, studio sessions and films featuring Maria Callas, Jacqueline du … | ["Music", "Musical instrument", "Pour", "Violin, fiddle", "Bowed string instrument"] | ["water splashing sound", "violin solo", "instrumental music", "great composers", "conductor", "studio", "fast tempo", "string quartet", "string section", "fast tempo", "bad audio quality", "documentary soundtrack", "documentary video", "melancholic", "passionate", "spirited", "vibrato", "high pitched notes", "violin technique", "western classical music"] | 1 | 0qtbbK5HVMw | 213 | |
"Flight of the Bumblebee" - Patrick De Smet, Carlo Willems & Il Novecento | The song is an instrumental. The tempo is fast , with a philharmonic orchestra consisting of string section, rhythm section and horns accompanying a virtuoso wooden xylophone playing this western classical hit. The song is energetic and exciting. | 2009-01-14T18:27:23Z | NOTPvids | Patrick De Smet, Carlo Willems & Il Novecento - "Flight of the Bumblebee" Night of the Proms (France, 2007) | ["Orchestra"] | ["violin accompaniment", "virtuoso", "wooden xylophone", "orchestra", "instrumental music", "horn section", "brass section", "conductor", "composer", "opera hall", "concert hall", "fast tempo", "exciting", "bumblebee", "funny", "animated", "wondrous", "magical", "great journey", "twists and turns", "energetic", "pulsating", "mysterious", "positive", "string section harmony", "fast tempo"] | 1 | uZHE9b1WDuM | 5124 |
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;