musiccaps_details (view)
1 row where musiccaps_aspects contains "amplifiers", musiccaps_aspects contains "electronic dance music", musiccaps_aspects contains "low frequencies" 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 |
---|---|---|---|---|---|---|---|---|---|---|
Music From Outer Space - Weird Sound Generator WSG - Modified with CV inputs | The song is instrumental. The tempo is medium with electrical current manipulation to produce different frequencies to play percussively and harmonically with each other. The song is for scientific research and not pleasing to the ear. The song is of poor audio quality. | 2011-10-22T19:05:48Z | Djo HxC | A demo of the MFOS WSG. This one is modified with CV inputs. http://www.musicfromouterspace.com More information of my build here: http://modularsynth.wordpress.com/mfos-weird-sound-generator-wsg/ | ["Music", "Cacophony", "Soundtrack music", "Synthesizer", "Exciting music"] | ["electronic music", "instrumental", "amplifiers", "high pitched frequencies", "low frequencies", "medium tempo", "percussive rhythm", "sonorous harmony", "poor audio quality", "mysterious", "energetic passionate", "experimental music", "abstract tones", "science experiment", "electric current manipulation", "electronic dance music", "audio research"] | 1 | Ysrlv2UlG8A | 3317 |
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;