musiccaps_details (view)
1 row where musiccaps_aspects contains "echoing sleepdrone sound effects", musiccaps_aspects contains "low quality", musiccaps_aspects contains "noisy" and musiccaps_aspects contains "weird"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Mini Sleepdrone | The low quality recording features echoing sleep drone sound effects. It sounds weird and cool at the same time. The recording is noisy and in mono. | 2007-06-29T21:40:24Z | heavymetalme | It's a quiet video, so turn it up! This pink little guy is sweet. You have the option of running each of the three oscillators into different effects, but in this video, I'm running them out the main output into a BOSS Hi Band Flanger HF-2, a BOSS Digital Space-D DC-3, and finally into a Roland Space Echo RE-150. | ["Theremin"] | ["low quality", "noisy", "mono", "echoing sleepdrone sound effects", "weird", "cool"] | 4 | 13n6n6nKMhI | 232 |
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;