musiccaps_details (view)
1 row where musiccaps_aspects contains "suspenseful", musiccaps_aspects contains "water flowing sounds" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Without Touch 2.0 - concert Lydia Kavina (modern) | The low quality recording features a theremin solo melody. It sounds haunting, intense, suspenseful and cold. There are some water flowing sounds in the background. The recording is mono and noisy. | 2009-01-30T22:26:52Z | bytesatwork | !!! sound&image synchronised at http://vids.myspace.com/index.cfm?fuseaction=vids.individual&videoid=51451608 !!! Without Touch 2.0 - 12.-14. september 2008 part of the 'Grand Finale Concert' - performance by Lydia Kavina ( http://www.lydiakavina.com/ ) Further parts include performances by - Lydia Kavina ( http://www.lydiakavina.com/ ) - Carolina Eyck ( http://www.carolina-eyck.de/ ) - Wilco Botermans ( http://www.theremin.nl/ ) - Dr. Jim Franklin ( http://www.bambus-atem.de/hinweise/veranstaltungen.html ) Without Touch 3.0 is coming up and will be held in march 2009 again in Lippstadt - find further information at http://www.theremin.musikschule-lippstadt.de/ ; the list of artists include Lydia Kavina, Carolina Eyck and Randy George ( http://randygeorgemusic.com/ )! | ["Music", "Musical instrument", "Theremin"] | ["low quality", "noisy", "mono", "theremin solo melody", "suspenseful", "haunting", "intense", "cold", "water flowing sounds"] | 4 | 8q0An6WY7_c | 953 |
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;