musiccaps_details (view)
2 rows where musiccaps_aspects contains "punchy snare" and musiccaps_aspects contains "unbalanced stereo image"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- low quality 2
- punchy snare · 2 ✖
- unbalanced stereo image · 2 ✖
- aggressive 1
- arpeggiated piano melody 1
- double pedal kick 1
- energetic 1
- energetic cymbal crash 1
- energetic cymbals 1
- epic 1
- female opera vocal 1
- groovy bass guitar 1
- heartbeat kick pattern 1
- hip hop 1
- inspiring 1
- manic 1
- metal 1
- noisy 1
- powerful 1
- simlpe hi hats 1
- simple piano chords 1
- skateboard sound effects 1
- smooth bass 1
- soft female vocal 1
- sustained violin melody 1
- throaty male vocal 1
- wide agressive distorted electric guitar melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Longboarding: Malibu Invitational Slide Jam | The low quality recording features a hip hop beat and some skateboard sound effects in the background. The beat consists of female opera vocalists that sing over punchy snare and kick hits, simple hi hats, energetic crash cymbals, simple piano chords, smooth bass and sustained strings melody. It sounds epic and powerful, almost inspiring. The stereo image is unbalanced, since the snare hits are panned a bit to the right channel, and overall the left channel is a bit louder. | 2010-05-20T20:09:39Z | Loaded Boards | Longboarding event. A recap of the Malibu Invitational Longboard Slide Jam, hosted by Orangatang Wheels. Filmed by Adam Colton & Jonathan Jelkin Edited by http://www.JonathanJelkin.com Sponsored by: http://www.ParisTruckCo.com http://www.CometSkateboards.com http://www.StokedSkateboards.com http://www.FireballWheels.com | ["Music", "Skateboard"] | ["low quality", "hip hop", "female opera vocal", "punchy snare", "sustained violin melody", "heartbeat kick pattern", "simlpe hi hats", "simple piano chords", "smooth bass", "epic", "powerful", "skateboard sound effects", "noisy", "unbalanced stereo image", "energetic cymbal crash", "inspiring"] | 4 | BHDhHO7J-Oo | 1224 | |
Theatre Of Tragedy - And When He Falleth | The Metal song features a low throaty male vocal singing over widely spread, aggressive and distorted electric guitars, groovy bass guitar, punchy snare, energetic cymbals and double pedal kick. In the second part of the loop, the instrumental calms down, as there is an arpeggiated piano melody over which a soft female vocal is singing. Overall it sounds energetic, aggressive and manic. The male vocal in the first part of the loop is leaning towards the left channel of the stereo image, making it sound unbalanced and therefore low quality. | 2007-12-23T07:18:07Z | cristianfleitas | Theatre Of Tragedy : And When He Falleth Album: Velvet Darkness They Fear | ["Music", "Angry music"] | ["metal", "low quality", "aggressive", "energetic", "manic", "throaty male vocal", "wide agressive distorted electric guitar melody", "arpeggiated piano melody", "soft female vocal", "punchy snare", "energetic cymbals", "double pedal kick", "groovy bass guitar", "unbalanced stereo image"] | 4 | RoDS0k7qrIo | 2726 |
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;