musiccaps_details (view)
1 row where musiccaps_aspects contains "aggressive", musiccaps_aspects contains "loud", musiccaps_names contains "Background music" and musiccaps_names contains "Grunge"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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;