musiccaps_details (view)
4 rows where musiccaps_aspects contains "harpsichord melody", musiccaps_aspects contains "noisy" and musiccaps_names contains "Keyboard (musical)"
This data as json, CSV (advanced)
musiccaps_aspects (array) 10 ✖
- emotional 4
- harpsichord melody · 4 ✖
- noisy · 4 ✖
- passionate 4
- low quality 3
- classical 2
- keyboard tapping sounds 1
- mono 1
- sad violin melody 1
- unbalanced stereo image 1
musiccaps_names (array) 4 ✖
- Harpsichord 4
- Keyboard (musical) · 4 ✖
- Bowed string instrument 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Couperin Prélude 5 L'Art de toucher le Clavecin Mário Trilha | The low quality recording features a harpsichord melody being played. The recording is extremely noisy and it sounds passionate and emotional. | 2008-07-10T09:41:52Z | Mario Marques Trilha | François Couperin(1683-1733) Prélude 5 from L'Art de Toucher le Clavecin Historical Harpsichord by Jacques Germain, Paris 1785 Recorded at The National Music Museum Vermillion South Dakota Harpsichord: Mário Marques Trilha | ["Harpsichord", "Keyboard (musical)"] | ["low quality", "noisy", "harpsichord melody", "passionate", "emotional"] | 4 | 2ZrqWkdwVzo | 382 | |
Giles Farnaby's Dream and his Rest - virginal music | The low quality recording features a harpsichord melody being played. There are some keyboard tapping sounds in the right channel of the stereo image. The whole sound is leaning towards the right channel, making the stereo image unbalanced. The recording is noisy and it sounds passionate and emotional. | 2010-07-08T07:51:14Z | My Years With Early Music | from the Fitzwilliam Virginal Book (Dover ed. part II p. 260) MP3: http://www.mediafire.com/?nnyavgja2tm ernst stolz virginal after Ruckers by Terwal | ["Harpsichord", "Keyboard (musical)"] | ["low quality", "harpsichord melody", "noisy", "unbalanced stereo image", "keyboard tapping sounds", "emotional", "passionate"] | 4 | JD9LYReBGXU | 1979 | |
Louis Couperin Prélude non mesuré d minor | The low quality recording features a classical song that consists of a harpsichord melody that sounds emotional and passionate. The recording is a bit noisy. | 2011-03-08T10:28:16Z | Daniel Ivo de Oliveira | Louis Couperin Prélude non mesuré in d minor Live concert in Heukelum, The Netherlands, 26.02.2011 Harpsichord, Daniel Ivo de Oliveira | ["Harpsichord", "Keyboard (musical)"] | ["harpsichord melody", "passionate", "classical", "emotional", "noisy"] | 4 | K_G_k1WTdoc | 2095 | |
Corelli Violin Sonata: Shunske Sato and Richard Egarr | The low quality, mono recording features a classical song performed by sad violin melody and harpsichord. The recording is noisy and it sounds emotional and passionate. | 2011-09-02T19:59:48Z | Academy of Ancient Music | Shunske Sato (violin) and Richard Egarr (harpsichord) perform Corelli's Sonata in D major for violin and harpsichord Op.5 No.1. Richard Egarr, Music Director of the Academy of Ancient Music, first heard Shunske when judging the 2010 Leipzig Bach Competition. Shunske was a major prizewinner. In October 2011 Shunske Sato makes his UK debut performing Paganini with the Academy of Ancient Music in Cambridge and London. Full details at www.aam.co.uk/concerts | ["Harpsichord", "Keyboard (musical)", "Violin, fiddle", "Bowed string instrument"] | ["low quality", "mono", "noisy", "classical", "sad violin melody", "harpsichord melody", "emotional", "passionate"] | 4 | kR2yBlL6nFU | 4316 |
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;