musiccaps_details (view)
3 rows where musiccaps_aspects contains "classical", musiccaps_aspects contains "easygoing" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- classical · 3 ✖
- easygoing · 3 ✖
- low quality 3
- passionate · 3 ✖
- emotional 2
- live performance 2
- noisy 2
- wide strings melody 2
- dynamic 1
- harpsichord melody 1
- mellow french horn melody 1
- movies 1
- orchestra 1
- reverberant 1
- sustained strings melody 1
- wide french horn melody 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Marin Marais: Chaconne in A Major (Book 5); Elisabeth Reed, viola da gamba | The low quality recording features a live performance of a classical song and it consists of harpsichord and sustained strings melodies. The recording is a bit noisy and quite reverberant, as it was recorded in a medium size concert hall. It sounds easygoing, passionate and emotional. | 2015-02-24T02:45:02Z | Voices of Music | The Chaconne in A Major from Marin Marais' fifth book (Pièces de Viole, Cinquième Livre, Paris, 1725). Performed on the viola da gamba by Elisabeth Reed, with Cassandra Luckhardt, viola da gamba, and Katherine Heater, harpsichord. In the first half of the 18th century, the French viol players dazzled audiences with their varied and beautifully crafted compositions as well as their technical abilities. Marais' chaconne shows the work of a mature composer; he balances the motivic elements perfectly with the registration of the instruments. HD Video from Voices of Music. | ["Cello", "Music", "Musical instrument", "Wedding music", "Classical music"] | ["low quality", "classical", "live performance", "harpsichord melody", "sustained strings melody", "emotional", "passionate", "reverberant", "noisy", "easygoing"] | 4 | HJuR9WJ1iRY | 1790 | |
Baborak · Dohr · de Leval Jezierski · Willis · Rattle · Berliner Philharmoniker / Schumann | The low quality recording features an orchestral live performance of a classical song and it contains a wide french horn melody playing over a wide string melody. It sounds easygoing, passionate, dynamic and emotional. | 2011-02-15T01:54:23Z | tophornmusic | Watch the complete performance: http://www.digitalconcerthall.com/en/concert/18 Berliner Philharmoniker Sir Simon Rattle Radek Baborak, Stefan Dohr, Stefan de Leval Jezierski, Sarah Willis Robert Schumann: Concert Piece for four horns in F major | ["Brass instrument", "French horn"] | ["low quality", "classical", "orchestra", "live performance", "dynamic", "wide french horn melody", "wide strings melody", "easygoing", "passionate", "emotional"] | 4 | x14jW4c8YnQ | 5298 | |
Foxhunt, French Horn, and Mozart | The low quality recording features a classical song that consists of a mellow french horn melody playing over wide strings. It is a bit noisy and it sounds passionate, easygoing and like something you would hear as a background music for old movies. | 2006-07-15T01:44:00Z | blathermore | An old print of a rustic foxhunt scene becomes a vehicle for Mozart's Rondo from Horn Concerto in E flat, K.495 | ["Brass instrument", "French horn"] | ["low quality", "classical", "noisy", "wide strings melody", "mellow french horn melody", "easygoing", "passionate", "movies"] | 4 | y5HkvusmkqM | 5380 |
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;