musiccaps_details (view)
1 row where musiccaps_aspects contains "fractal music", musiccaps_names contains "Music" and musiccaps_names contains "Noise"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Fraktal Noise - Paranoic Disaster | The song is an instrumental abstract piece. The song is medium tempo but with no actual pulse, whizzing sounds, shaker tones and buzzing noise and keyboard tones.The song is chaotic and highly experimental. The song is a psychedelic instrumental like a music Rorschach test. | 2012-01-06T22:42:55Z | trancecryption | VA - Happy My Life (2009) Compiled by Fullmoon Mondo 01 Kerosene Club - Shiva Dynamo 02 Kashyyyk - Crazy Story 03 Cosmo - Rhythmic Behavior 04 Ectogasmics - Ectoplasma 05 Fraktal Noise - Paranoic Disaster 06 Ankur - Weniger Ist Mehr Mit Mehr 07 Stranger - Night Wanderers 08 Highko vs Mondo - Berlin 09 Gu - May Day 10 Fullmoon Project - Eclipse Image: http://www.fractal-wallpapers.com/bulkupload/wallpapers/Fractal%20Wallpapers/dark-fractal-wallpaper.jpg | ["Electronic music", "Music", "Noise"] | ["experimental music", "whizzing tones", "brain exercise", "neurological test patterns", "paranoia", "white noise tones", "brain experiment", "musical rorschach", "no pulse", "scientific", "experiment", "no percussion pulse", "fractal music", "psychedelic music", "randomness", "tonal buzzes", "confusion", "chaos", "abstract music", "science experiment", "whizzing tones", "keyboard tones", "tonsl buzzz"] | 1 | AAoqx07aTRI | 1078 |
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;