musiccaps_details (view)
1 row where musiccaps_aspects contains "noisy", musiccaps_aspects contains "passionate" and "youtube_published" is on date 2010-07-08
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;