musiccaps_details (view)
2 rows where musiccaps_aspects contains "harpsichord song" and musiccaps_aspects contains "no other instruments"
This data as json, CSV (advanced)
musiccaps_aspects (array) 10 ✖
- classical composition 2
- harpsichord song · 2 ✖
- no other instruments · 2 ✖
- happy melody 1
- moderate tempo 1
- no voice 1
- no voices 1
- royal feel 1
- slow tempo 1
- sound for royalty 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Händel - Sarabande (from Suite in D minor HWV 437 - Cembalo Mietke, hauptwerk) | This song is a classical composition played on a harpsichord. This features the notes played on the higher register and the bass notes played on the same instrument. There are no other instruments in this song. This song has no voices. It is an instrumental song. This song can be played to honor royalty. | 2014-06-21T08:36:55Z | lucaraggi1975 | In the video you can listen to the famous and beautiful "Sarabande" from Suite in d minor for harpsichord no. 11 by George Frideric Handel, recorded on hauptwerk system, sample set of Cembalo Mietke. Handel was a German composer, naturalized English, one of the most important musicians in history, he was born in Halle in 1685 and died in London in 1759. His work spans every genre of music, vocal or instrumental, sacred or profane. This piece is also known 'cause used for the film "Barry Lyndon" by Stanley Kubrick. Luca Raggi plays this piece, good listening! | ["Harpsichord", "Keyboard (musical)"] | ["harpsichord song", "classical composition", "no other instruments", "no voice", "slow tempo", "royal feel"] | 0 | nL4zx0-mi14 | 4533 | |
Bach, English Suite, Pierre Hantaï | This song is played on a harpsichord. The harpsichord plays the bass and treble notes. This is a classical composition. There are no other instruments in this song. There are no voices in this song. This song can be used when a member of royalty arrives at a palace. | 2010-11-04T23:57:32Z | emiliend | ["Harpsichord", "Keyboard (musical)"] | ["harpsichord song", "classical composition", "no other instruments", "no voices", "moderate tempo", "sound for royalty", "happy melody"] | 0 | uoZ9Rs4E-6Y | 5136 |
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;