musiccaps_details (view)
2 rows where musiccaps_aspects contains "loud" and musiccaps_names contains "Grunge"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- loud · 2 ✖
- acoustic drums 1
- aggressive 1
- amplified instruments 1
- boisterous 1
- cymbals 1
- dance groove 1
- electric guitar 1
- electrifying 1
- energetic 1
- enthusiastic 1
- fast tempo 1
- hard rock 1
- heavy metal 1
- instrumental 1
- intense electric guitar lead 1
- keyboard 1
- keyboard harmony 1
- male singer 1
- metal 1
- no singer 1
- pop rock 1
- power metal 1
- pulsating 1
- rock 1
- sonic power 1
- upbeat 1
- vigorous drumming 1
- youthful 1
musiccaps_names (array) 5 ✖
- Grunge · 2 ✖
- Music 2
- Background music 1
- Progressive rock 1
- Rock music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Forgotten Suns - Walk On | A male vocalist sings this enthusiastic Rock. The tempo is fast and upbeat with a vigorous electric guitar lead and harmony, hard hitting drums and amplified keyboard. The music is an energetic, boisterous, youthful, enthusiastic, engaging, pulsating and electrifying Hard Rock. | 2006-12-13T08:02:40Z | tyepennington | Footage taken from a gig at The Mandarin Club on 5th August 2006. | ["Music", "Rock music", "Progressive rock", "Grunge"] | ["male singer", "fast tempo", "rock", "hard rock", "sonic power", "cymbals", "youthful", "pulsating", "electrifying", "enthusiastic", "amplified instruments", "vigorous drumming", "intense electric guitar lead", "keyboard harmony", "upbeat", "energetic", "loud", "boisterous", "enthusiastic", "metal", "heavy metal", "pop rock", "dance groove"] | 7 | J9ZlahUawkg | 1975 | |
TeknoAXE's Royalty Free Music - Royalty Free Music #247 (Drop D Powered) Grunge/Power Metal/Rock | This is an instrumental power metal piece. There is an electric guitar playing the melody with the accompaniment of a keyboard. There is an acoustic drum beat in the rhythmic background. There is an aggressive atmosphere. This piece could be used in the soundtrack of an action video game. | 2013-09-10T03:10:09Z | TeknoAXE's Royalty Free Music | Download Music: http://teknoaxe.com/Link_Code_3.php?q=461 **This track is Royalty Free and is free for anyone to use in YouTube videos or other projects, whether monetized or not.** http://www.facebook.com/teknoaxe http://www.reverbnation.com/teknoaxe So this is both to fill in some requests to do more power rock/metal-ish type stuff and also it is significant in that it's really the first rock track that I've done on this new computer. So this effectively means that I can retire ol' bluescreen and keep going here. It's also good prep for a collab I have coming up with Qelric. I hope you like it! :) *Legal notice: The publisher of this video is the original source for the music track being presented in this video, which is entitled "Drop D Powered". No one entity, person or organization may take legal action against other entity, person or organization due to use or distribution of this track or modified portions of this music track. image used: http://www.flickr.com/photos/mathiasmiranda/8595888795/sizes/o/in/photostream/ and http://www.flickr.com/photos/deanmccoyphotos/5187390915/sizes/o/in/photostream/ | ["Background music", "Music", "Grunge"] | ["power metal", "no singer", "instrumental", "electric guitar", "keyboard", "acoustic drums", "loud", "aggressive"] | 9 | LQYd-dsz62M | 2185 |
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;