musiccaps_details (view)

3 rows where musiccaps_aspects contains "no other instruments", musiccaps_aspects contains "no percussion", musiccaps_aspects contains "no voices" and musiccaps_names contains "Keyboard (musical)"

✎ View and edit SQL

This data as json, CSV (advanced)

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
J. S. Bach Violin & Harpsichord Sonata in F minor, BWV 1018 This classical sonata features a harpsichord playing a melody. This is accompanied by a cello playing the bass notes. There are no other instruments in this song. There is no voice in this song. This song can be played as a lullaby. 2008-12-27T20:30:54Z Elaine Comparone Violinist Robert Zubrycki joins harpsichordist Elaine Comparone and cellist Peter Seidenberg (The Queen's Chamber Trio) for the first movement of Bach's F minor Sonata for Violin & Obbligato Harpsichord, BWV 1018. for more info: www.harpsichord.org; www.lyrichord.com. ["Harpsichord", "Keyboard (musical)"] ["classical sonata", "instrumental", "no voices", "harpsichord", "cello", "no percussion", "no other instruments", "slow tempo"] 0 OxxRnDpN9cc 2485
Korg BX3 Demo This song features an electric organ playing different tones. There is no melody in this song. This is a demo of the different tones that can be played on the electric organ. There are no voices in this song. This can be played in a demo video of this electric organ. 2008-04-13T18:33:02Z hankiegirl2 This is a one of the old original KORG BX3 witgh a Leslie 760. Good heavy sound with mega overdrive og and click ["Organ", "Hammond organ", "Keyboard (musical)", "Piano"] ["organ music", "different tones", "no voices", "no other instruments", "no percussion", "no melody"] 0 QyMcSnNsAPw 2653

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;