musiccaps_details (view)
1 row where musiccaps_aspects contains "aggressive electric guitar", musiccaps_aspects contains "groovy bass line", musiccaps_aspects contains "inferior audio quality" and musiccaps_aspects contains "no vocals"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;