musiccaps_details (view)
1 row where musiccaps_aspects contains "synth pluck", musiccaps_names contains "Angry music" and "youtube_published" is on date 2013-04-04
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 |
---|---|---|---|---|---|---|---|---|---|---|
Improve Your Squat! (ATG- 315lbs) | This audio contains digital drums with an open hi hat. A distorted e-guitar and an e-bass are both playing the same melody in the lower register. A synth pluck is playing a simple repeating rhythmic melody on top. You can hear the sound of glass breaking. This song may be playing at a live festival. | 2013-04-04T14:14:35Z | ScottHermanFitness | 12 WEEK TRANSFORMATION CHALLENGE! http://muscularstrength.com/twelve-week-transformation-challenge Easiest Bodyfat Measuring Tool! - SKULPT AIM: http://goo.gl/hvapTN High Protein Food! - Pasta, Oatmeal, Granola, and Snack Bars! - http://muscularstrength.com/true-gains Website: http://www.MuscularStrength.com/join (ONE MONTH FREE - PROMOCODE: FREEFITNESS) FX-SPORT Headphones (Wireless & Waterproof!) Use code SCOTT20 for $20 off - http://goo.gl/0YNmyU Bar Grips, Wrist Wraps/Straps, Fractional Plates & More! - IronBullStrength - 10% off coupon code! "MS10" - CLICK HERE - http://goo.gl/b05PxB Online Coaching (Custom Routine & Meal Plan) http://muscularstrength.com/consultations Fitness Genes - Maximize YOUR Genetic Potential! - CLICK HERE (30% Off) - https://goo.gl/FSBMWc THYNC - Want To Sleep Better & Focus More During Your Workouts? - http://goo.gl/BwYlxZ Twitter: https://www.twitter.com/Scott_Herman Facebook: http://www.facebook.com/ScottHermanFitness Instagram: http://www.instagram.com/ScottHermanFitness Squatting is more than just bringing the weight down and up. From foot stance to opening up your hips, there are many tips you can incorporate into your squat to get more out of it. If you are going to do something, you better do it right! | ["Music", "Angry music"] | ["hard-rock", "digital drums", "e-guitar", "e-bass", "synth pluck", "medium to uptempo", "agrgressive", "energetic"] | 6 | gfIqYbQQq10 | 4043 |
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;