musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic cymbals", musiccaps_author = 4 and musiccaps_names contains "Progressive rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- aggressive 3
- energetic 3
- energetic cymbals · 3 ✖
- punchy snare 3
- groovy bass guitar 2
- low quality 2
- aggressive electric guitar riffs 1
- distorted bass guitar 1
- doubled flat male vocals 1
- drum sticks countdown 1
- groovy 1
- harsh 1
- heartbeat kick pattern 1
- hollow 1
- loud 1
- manic 1
- metal 1
- punchy kick 1
- punk 1
- rock 1
- screaming male vocal 1
- shimmering hi hats 1
- short snare rolls 1
- thin 1
- wide electric guitar chords 1
- wide electric guitars riffs 1
musiccaps_names (array) 9 ✖
- Heavy metal 3
- Music 3
- Progressive rock · 3 ✖
- Rock music 3
- Psychedelic rock 2
- Punk rock 2
- Bass guitar 1
- Grunge 1
- Independent music 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 | |
the whip - freelance liaison | The low quality recording features a metal song that consists of screaming male vocal singing over widely spread electric guitar riffs, distorted bass guitar, energetic cymbals and short snare rolls. It sounds loud, aggressive, energetic and manic - as every metal song should sound. | 2011-04-08T04:05:08Z | mullettaimer | the whip - freelance liaison from the 7inch | ["Heavy metal", "Music", "Psychedelic rock", "Rock music", "Progressive rock"] | ["low quality", "metal", "screaming male vocal", "energetic", "punchy snare", "wide electric guitars riffs", "distorted bass guitar", "energetic cymbals", "short snare rolls", "loud", "manic", "aggressive"] | 4 | eUZ-v8GEcNk | 3866 | |
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;