musiccaps_details (view)
2 rows where musiccaps_aspects contains "bad audio quality" and musiccaps_aspects contains "string quartet"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- bad audio quality · 2 ✖
- instrumental music 2
- string quartet · 2 ✖
- western classical music 2
- ambient room noises 1
- cascade of notes 1
- clarinetist 1
- classical masterpieces 1
- conductor 1
- documentary soundtrack 1
- documentary video 1
- exciting 1
- fast tempo 1
- great composers 1
- harp playing beautifully 1
- harpist 1
- high pitched notes 1
- life is beautiful 1
- live audience 1
- live performance 1
- melancholic 1
- passionate 1
- precious moments 1
- romantic 1
- slow tempo 1
- soloist 1
- spirited 1
- string section 1
- studio 1
- vibrato 1
- violin solo 1
- violin technique 1
- water splashing sound 1
musiccaps_names (array) 6 ✖
- Bowed string instrument 1
- Harp 1
- Music 1
- Musical instrument 1
- Pour 1
- Violin, fiddle 1
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 | |
Ravel Introduction et Allegro for Harp, stringquartet, flute, clarinet | The song is an instrumental. The song is in medium tempo with a harpist playing a beautiful cascade of notes while the orchestra watches. The song is exciting and passionate. The audio quality is poor. | 2008-10-20T22:15:32Z | eefkedegeus | Introduction et Allegro M. Ravel Harp, stringquartet, flute, clarinet. From left to right Mariana, Angela, David, Cristina, Eefke, Miguel, Germaine. M. Ravel - Introduction et Allegro Royal Conservatory Den Haag, Holland | ["Harp"] | ["harpist", "harp playing beautifully", "clarinetist", "string quartet", "bad audio quality", "live audience", "life is beautiful", "precious moments", "classical masterpieces", "live performance", "ambient room noises", "slow tempo", "cascade of notes", "live performance", "soloist", "western classical music", "exciting", "romantic", "instrumental music"] | 1 | u8aB6EALonk | 5091 |
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;