musiccaps_details (view)
3 rows where musiccaps_aspects contains "aggressive", musiccaps_aspects contains "energetic cymbals" and musiccaps_aspects contains "groovy bass guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- aggressive · 3 ✖
- energetic 3
- energetic cymbals · 3 ✖
- groovy bass guitar · 3 ✖
- punchy snare 3
- low quality 2
- aggressive electric guitar riffs 1
- arpeggiated piano melody 1
- double pedal kick 1
- doubled flat male vocals 1
- drum sticks countdown 1
- groovy 1
- harsh 1
- heartbeat kick pattern 1
- hollow 1
- manic 1
- metal 1
- punchy kick 1
- punk 1
- rock 1
- shimmering hi hats 1
- soft female vocal 1
- thin 1
- throaty male vocal 1
- unbalanced stereo image 1
- wide agressive distorted electric guitar melody 1
- wide electric guitar chords 1
musiccaps_names (array) 10 ✖
- Music 3
- Heavy metal 2
- Progressive rock 2
- Punk rock 2
- Rock music 2
- Angry music 1
- Bass guitar 1
- Grunge 1
- Independent music 1
- Psychedelic rock 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fed Up - "So Stupid" | The low quality recording features a punk song that consists of a groovy bass guitar, punchy kick, shimmering hi hats, energetic cymbals and aggressive electric guitar riffs. At the very beginning of the loop, there is a drum stick countdown, after which the bass drops. It sounds energetic, groovy and aggressive. | 2007-05-04T20:57:37Z | f1rstperson | This was the first music video I ever edited and filmed. It is simply awful, but it's fun too look back at the process and realize the things we learn. The band Fed Up was from Kansas City...this song was off their first EP....and they grew to be one of the best punk rock bands around (in my opinion). Check out the other video I did for them 3 years later...called "When Looking Back". | ["Bass guitar", "Heavy metal", "Music", "Punk rock", "Rock music", "Progressive rock"] | ["punk", "low quality", "groovy bass guitar", "punchy snare", "punchy kick", "shimmering hi hats", "energetic cymbals", "aggressive electric guitar riffs", "aggressive", "energetic", "groovy", "drum sticks countdown"] | 4 | ARXTRdKCupM | 1115 | |
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 | |
Hoover EmPower Vacuum Jingle | The Rock song features a doubled flat male vocals singing over wide electric guitar chords, groovy bass guitar, energetic cymbals, punchy snare hits and heartbeat kick pattern. It lacks low frequencies, therefore it sounds thin, hollow and harsh, but regardless, also energetic and aggressive. | 2011-03-07T07:54:13Z | Jim Simonian | This was a fun jingle that we did for the Hoover Empower Vacuum cleaner back in 2005. Kelly Derrick - vocals, Jim Simonian - Drums, Vocals, Ron Gregorcic - Guitars. | ["Heavy metal", "Music", "Punk rock", "Independent music", "Psychedelic rock", "Rock music", "Progressive rock", "Grunge"] | ["rock", "wide electric guitar chords", "groovy bass guitar", "doubled flat male vocals", "energetic cymbals", "punchy snare", "heartbeat kick pattern", "harsh", "thin", "hollow", "aggressive", "energetic"] | 4 | qDiTICmdUQg | 4765 |
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;