musiccaps_details (view)
2 rows where musiccaps_aspects contains "digital drums", musiccaps_aspects contains "e-bass" and musiccaps_aspects contains "e-guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- digital drums · 2 ✖
- e-bass · 2 ✖
- e-guitar · 2 ✖
- agrgressive 1
- bongos 1
- energetic 1
- fast tempo 1
- female voice singing 1
- hard-rock 1
- medium to uptempo 1
- melancholic 1
- pop 1
- synth pluck 1
- synth strings 1
musiccaps_names (array) 3 ✖
- Music 2
- Angry music 1
- Music of Asia 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Roger Sanchez Feat. Lisa Pure - Lost - Original Mix (Video) | This song contains digital drums playing a four on the floor groove with a kick on every beat along to an e-bass. In the background you can hear additional bongo rhythms. A synth string sound is playing long chord notes in the background. An e-guitar is finger picking a chord melody. A female voice is singing in a higher key and with backing vocals. This song may be playing while cleaning the kitchen. | 2007-11-11T12:52:18Z | Zarmk (Mike Alcazar) | Vocal House track from the S-Man, a new house classic. Copyright belongs to the Record label Stealth Records and the artist | ["Music of Asia", "Music"] | ["pop", "synth strings", "e-guitar", "e-bass", "digital drums", "bongos", "female voice singing", "fast tempo", "melancholic"] | 6 | Hp-lgcs4VXY | 1836 | |
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;