musiccaps_details (view)
1 row where musiccaps_aspects contains "instructive", musiccaps_aspects contains "no singer" and musiccaps_names contains "Theremin"
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 |
---|---|---|---|---|---|---|---|---|---|---|
My Theremin Mini From Ebay! | This is an instrumental jam recording. There is a mini theremin being played at a high pitch. It is making vibrating and squeaking sounds. There is an instructive male voice speaking. There is an eerie feel to the sound. This recording could be sampled for use in beat-making. | 2009-08-01T23:22:16Z | CosmosTheMouse | Opening, construction, and explanation of a small "Theremin Mini" I bought on Ebay from Hong Kong. I'm pretty amused that it actually works as well as it does! One of these days I may have to buy a real life sized one. No disrespect to the person who sent it to me by the way. The poorly translated instructions are actually a blast to read. | ["Music", "Theremin", "Speech"] | ["jam", "no singer", "instrumental", "mini theremin", "high pitched sounds", "male voice", "instructive", "eerie", "bizarre", "weird"] | 9 | NeSIT6sqLRA | 2353 |
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;