musiccaps_details (view)
3 rows where musiccaps_aspects contains "classical", musiccaps_author = 4 and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- classical · 3 ✖
- emotional 2
- live performance 2
- low quality 2
- passionate 2
- reverberant 2
- arpeggiated strings melody 1
- cinematic 1
- dynamic 1
- easygoing 1
- energetic orchestra drums 1
- epic 1
- harpsichord melody 1
- noisy 1
- orchestra 1
- passionate dynamic classical piano melody 1
- shimmering brass melody 1
- sustained strings melody 1
- woodwinds 1
musiccaps_names (array) 7 ✖
- Classical music 3
- Music 3
- Musical instrument · 3 ✖
- Cello 1
- Orchestra 1
- Timpani 1
- Wedding music 1
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 | |
Tomomi Nishimoto - Tchaikovsky : Symphony No.6 「Pathétique」3rd Mov | The Classical song features a dynamic arrangement of energetic orchestra drums, woodwinds, arpeggiated strings melody and shimmering brass melody. It sounds cinematic and epic - like a background movie soundtrack. | 2009-09-05T15:16:42Z | CLASSICsungtaek | [ Pyotr Ilyich Tchaikovsky ] - Symphony No.6 in B minor Op. 74「Pathétique」 III. Allegro molto vivace Tchaikovsky Foundation Russian Symphony Orchestra Tomomi Nishimoto, conductor | ["Timpani", "Music", "Musical instrument", "Orchestra", "Classical music"] | ["classical", "dynamic", "orchestra", "energetic orchestra drums", "woodwinds", "arpeggiated strings melody", "shimmering brass melody", "cinematic", "epic"] | 4 | HQb2jhmw1BE | 1800 | |
G. Bottesini - Introduzione Tema e Variazioni sul 'Carnevale di Venezia' | The low quality recording features a live performance of a passionately and dynamically played classical piano melody. It is quite reverberant, as it was probably recorded in some concert hall. It also sounds emotional and passionate, even though the sound is not perfect. | 2015-07-20T05:40:20Z | Yong-Woo, Cho (조용우) | 15.07.2015 in Recital Hall (Seoul Arts Center) in Korea in 예술의전당 리사이틀홀 귀국독주회 中... | ["Music", "Musical instrument", "Classical music"] | ["low quality", "live performance", "classical", "passionate dynamic classical piano melody", "reverberant", "emotional", "passionate"] | 4 | UWl99yJsb8M | 2922 |
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;