musiccaps_details (view)
1 row where musiccaps_aspects contains "tension" and musiccaps_names contains "Harpsichord" sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 7 ✖
- build-up 1
- classical viola playing 1
- harpsichord playing 1
- suspenseful playing 1
- tense playing 1
- tension · 1 ✖
- tremolo 1
musiccaps_names (array) 2 ✖
- Harpsichord · 1 ✖
- Keyboard (musical) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
Iamus Computer -- Nasciturus, for viola d'amore and harpsichord | We hear a viola and harpsichord being played, with the overall emotion of the piece being thrilling and suspenseful. A high tremolo is played on the violin, which creates the feeling of an energy build-up. This is a classical style piece. | 2012-07-04T19:30:30Z | Gustavo Díaz-Jerez | Nasciturus was composed autonomously by Iamus Computer without human intervention. Click here if you want to subscribe: http://bit.ly/1mUXN8V All of Iamus compositions are written in a fully-fledged score notated using conventional music notation, available in PDF or MusicXML file formats. Iamus computer, located at the Universidad de Málaga, is a powerful computer cluster that has been specifically built to fully exploit the potential of Melomics technology. Melomics employs an evolutionary approach to music composition. Sviatoslav Belonogov, viola d'amore Gustavo Díaz-Jerez, harpsichord. More info: http://www.guardian.co.uk/music/2012/jul/01/iamus-computer-composes-classical-music http://www.geb.uma.es/melomics/melomics.html http://en.wikipedia.org/wiki/Iamus_(computer) | ["Harpsichord", "Keyboard (musical)"] | ["classical viola playing", "harpsichord playing", "suspenseful playing", "tense playing", "tremolo", "build-up", "tension"] | 3 | F5zDEHggiMg | 1614 |
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;