musiccaps_details (view)
2 rows where musiccaps_aspects contains "hard rock", musiccaps_aspects contains "spirited" and musiccaps_names contains "Angry music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- hard rock · 2 ✖
- intense 2
- spirited · 2 ✖
- aggressive electric guitar 1
- animated 1
- dangerous 1
- eerie 1
- electronic music 1
- enthusiastic 1
- fast tempo 1
- futuristic 1
- goth rock 1
- groovy bass line 1
- hard metal 1
- inferior audio quality 1
- informative 1
- instrumental 1
- instrumental music 1
- intense drumming 1
- last tempo heavy metal 1
- male voice speaking 1
- metal 1
- no vocals 1
- review 1
- sinister keyboard harmony 1
- spooky 1
- steady drumming 1
- suspenseful 1
- techno music 1
- video game music 1
- vigorous 1
- youthful 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
TF2 - 7 brothers (broder) frag movie | This song is a Rock instrumental. The tempo is medium fast with an aggressive electric guitar harmony, steady drumming, keyboard accompaniment, groovy bass lines. The audio quality is inferior so the finer aspects; are hard to detect. Overall the vibe of the song is intense,dangerous, sinister, spooky, goth, threatening and suspenseful. This song is Hard Rock/Metal. | 2010-02-19T23:16:14Z | Sivert Bakkeng | This is a fragvid for my TF2 Team, 7 Brothers who aren't brothers (broder). Duration: 6m 33s Direct HQ 720p download .mp4: http://www.fakkelbrigade.eu/torden/7brothers_720pHighB.mp4 (438mb, "right click + save link as") Direct HQ 720p download .wmv: http://www.fakkelbrigade.eu/torden/7brothers_720pHigh.wmv (294mb, will play in browser, or "save link as...)" Most of the footage is shown in its entity with real time kills, and speed ups between some (during the same spree). And yes, the hiding in spawn before kritzing is real. We apologize to the following teams (in order of appearance): Monster Munch (RAWR) Un de Watever-their-name-is Team Coolermaster (TCM) Power gaming (PwR) Notag Empire Blight Mister (Mr) Rage Multigaming Idk? (fakenicking asswipes) Outsiders who contributed to this short film: Salmon, support and improvements on the pldx movie recording tool. Tuna and Jh ("from the movies"). Fakkelbrigade and Arie, providing direct download All footage is from PCWs/Scrims, mid Jan. to mid Feb. 2010. Team members (by order of appearance) Sneis (Currently travelling South America) Fanva Torden Weqo Macisum Braffle Berserker Codcrille Borrowed music: the Stooges - I Wanna be Your Dog Pixies - Wave of Mutilation + there goes my gun Vitamin String Quartet - Wave of Mutilation (cover) Anyone interested learning about the competitive side of TF2, visit www.ETF2L.org or www.RESUPPLY.eu. Ill allow it. | ["Music", "Angry music"] | ["instrumental", "fast tempo", "hard rock", "no vocals", "inferior audio quality", "metal", "suspenseful", "dangerous", "youthful", "spirited", "intense", "hard metal", "aggressive electric guitar", "sinister keyboard harmony", "steady drumming", "groovy bass line", "eerie", "suspenseful", "spooky", "goth rock"] | 7 | 0fCpAuxrQ_I | 196 | |
Top 10 Robots | This music is an electronic instrumental. The tempo is fast with heavily synthesised arrangements and intense drumming with a male voice speaking over the music. The music is intense, vigorous,animated, futuristic and vital. It sounds like video game music and the male voice seems to be reviewing Video Games. | 2015-05-16T05:12:56Z | GameTrailers | Sometimes, when you need a friend, you have to build one. We assemble all the greatest creations in video games and determine who is the most loyal and effective. | ["Music", "Speech", "Angry music"] | ["instrumental music", "vigorous", "animated", "spirited", "enthusiastic", "intense drumming", "last tempo heavy metal", "hard rock", "electronic music", "video game music", "male voice speaking", "intense", "electronic music", "techno music", "futuristic", "review", "informative"] | 7 | Xn0wIqnt_44 | 3223 |
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;