musiccaps_details (view)
2 rows where musiccaps_aspects contains "classical music" and musiccaps_aspects contains "no other instruments"
This data as json, CSV (advanced)
musiccaps_aspects (array) 10 ✖
- classical music · 2 ✖
- instrumental 2
- moderate tempo 2
- no other instruments · 2 ✖
- no voices 2
- aristocracy song 1
- cello 1
- flute 1
- harpsichord 1
- no percussion 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
J. S. Bach - Toccata No. 7 in G Major BWV 916 | This classical song is played on a harpsichord. This is music for royalty or aristocrats. There are some pedal notes played on the bass part and the main melody is played on the treble part. There are no other instruments in this song. There is no percussion in this song. There are no voices in this song. This song can be played in a movie scene where a king is entering his castle. | 2008-07-28T22:35:26Z | The30YearOldVirgin | Johann Sebastian Bach (1685 - 1750) Toccata for keyboard No.7 in G Major, BWV 916 Composed in 1706, probably in Arnstadt. First published in Leipzig around 1866 or 1867. Performed by Jory Vinikour | ["Harpsichord", "Keyboard (musical)"] | ["classical music", "harpsichord", "instrumental", "no voices", "no percussion", "no other instruments", "moderate tempo", "aristocracy song"] | 0 | HhQTvaZtURY | 1828 | |
Marin Marais Les Folies d'Espagne pour flûte et violoncelle | This song features a flute playing the main melody. The flute plays staccato notes and allows only the last note to be sustained. This is accompanied by a cello playing the same melody in the lower register. There are no voices in this song. This song is an instrumental. This folk song features no other instruments. This song can be played in an animation movie featuring fairies. | 2011-04-07T21:54:26Z | susancello | Duo à Cord'Air Nathalie Lourties Flûte Susan Edward Violoncelle En concert le 3 avril 2011 à Salle Cuzin, Auch www.acordair.com | ["Wind instrument, woodwind instrument", "Flute"] | ["classical music", "flute", "cello", "no other instruments", "no voices", "instrumental", "moderate tempo"] | 0 | dUlQepCYXgw | 3793 |
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;