musiccaps_details (view)
4 rows where musiccaps_aspects contains "hard-rock"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Made Out of Babies- Cooker | A distorted and arpeggiated e-guitar sequence is repeating the same phrase while a female voice is streaming with an effect on her voice. She sounds aggressive and frustrated. This song may be playing in an aggressive, fast paced action-movie chasing scene. | 2008-07-18T02:16:39Z | pronemortalform92 | Opening track from their new album "The Ruiner" | ["Music", "Yell"] | ["hard-rock", "arpeggiated e-guitar", "female voice screaming", "agressive", "uptempo"] | 6 | cnmedj0fYTQ | 3741 | |
| Behind Me Lies Another Fallen Soldier - As I Lay Dying | E-guitars are fingerpicking two different melodies in an arpeggio fashion while another distorted e-guitar is playing the main melody along with a -ebass breaking into the next part with the drums playing a loud groove with toms and crash cymbals. Before that part a male voice was talking before breaking into loud screaming in a deeper voice. This song may be playing live at a rock concert. | 2012-12-27T08:41:07Z | Bunnie | Don't own the song. Obviously. Enjoy c: | ["Music", "Angry music"] | ["hard-rock", "e-guiatars", "e-bass", "acoustic drums", "male deeper voice talking/screaming", "melancholic", "aggressive energy"] | 6 | dPCj4WhTZ3c | 3783 | |
| 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 | |
| Melvins - The Brain Center at Whipples - Hostile Ambient Takeover (2002) | This song contains a complex drum groove with fill-ins and a loud groove on the ride cymbal. A distorted e-bass is playing a simple fast bassline along with a distorted e-guitar playing lower notes along with the bass. This song may be playing in a car racing video-game. | 2010-05-11T18:52:00Z | Instrument | music by: melvins - the brain center at whipples - hostile ambient takeover art by: feehan | ["Music", "Angry music"] | ["hard-rock", "e-bass", "acoustic drums", "e-guitar", "fast tempo", "aggressive"] | 6 | qUWYzx7pBSw | 4787 |
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;