musiccaps_details (view)
1 row where musiccaps_aspects contains "energetic", musiccaps_aspects contains "laser synth lead melody", musiccaps_author = 4 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 |
---|---|---|---|---|---|---|---|---|---|---|
SLEEPER Mixing 19 Songs in 10 Minutes (Moombahton Melody!) | The low quality recording features a DJ scratching his vinyl track that consists of a boomy 808 bass, low male vocal, laser synth lead melody, soft white noise, low synth down sweep and wide short snare roll. There is some widely spread snare roll at the end of the first section of the loop. It sounds energetic and a bit chaotic. | 2012-06-26T14:59:16Z | SLEEPER | http://patreon.com/djSLEEPER http://facebook.com/djSLEEPER http://instagram.com/djSLEEPER http://twitter.com/djSLEEPER snap dj_SLEEPER recorded June 25, 2012 for Michael Jackson. tracklist and mp3 on Soundcloud: https://soundcloud.com/awakesleeper/19-songs-in-10-minutes-moombahton-melody had this ridiculous fisheye camera for a day. this is the best i came up with, hope y'all dig it! just realized it was finished on the day Michael Jackson passed away. as God will have it, MJ opens this up baby! the goal with these mini mixes is to create something timeless. i definitely don't think i've done that. but my hope is you can enjoy this more than once. everyone wants to make something eternal, it's impossible. thanks for watching our journeys as we try! huge thanks to @michellekim28 for the camera! http://djsleeper.com http://soundcloud.com/djsleeper http://facebook.com/djSLEEPER https://linktr.ee/djsleeper +++ PROGRAMS! Ableton Live https://amzn.to/2xIsGbh Adobe Premiere Pro https://amzn.to/2QqPwuy Serato DJ Pro https://amzn.to/3daL9xB GEAR! Ableton Push https://amzn.to/2xaQODq Akai MPK Mini Keyboard https://amzn.to/3b9N2ZC Apple MacBook Pro https://amzn.to/2xaUnti Apple iMac Pro https://amzn.to/2TZZDZu Bose SoundSport Earbuds https://amzn.to/2xaXNfC Bose QC 35 Headphones https://amzn.to/3b90BIF Boss RC-505 https://amzn.to/3bcBox7 Chroma Cables https://amzn.to/2WqaTjC https://amzn.to/2wc1gue Crane Laptop Stand https://amzn.to/2Wq92Lr Dangerous Music Monitor https://amzn.to/3a4i8S3 G-Technology 4TB Hard Drive https://amzn.to/33tbfaA Glyph BlackBox Pro 14TB Hard Drive https://amzn.to/3d9SFbX Glyph Studio 4TB Hard Drive https://amzn.to/3a2ICTX GoPro MAX 360 Camera https://amzn.to/3bcDDAx GoPro Hero Camera https://amzn.to/393V0BS Ikea Kallax Record Shelf https://amzn.to/2Qsa2uJ Jarvis Standing Desk Bamboo Electric https://amzn.to/2Quyj3k JBL EON Speaker https://amzn.to/390ItPJ Korg microKEY Air 61 Wireless Keyboard https://amzn.to/2vwg0DF Korg microKorg 37 Analog Vocoder https://am… | ["Music", "Scratch"] | ["low quality", "boomy 808 bass", "low male vocal", "dj scratching effect", "laser synth lead melody", "soft white noise", "low synth down sweep", "wide short snare roll", "energetic", "chaotic"] | 4 | 1-Y9kafYuqQ | 227 |
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;