musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental" and "youtube_published" is on date 2010-02-19
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- instrumental · 2 ✖
- 80s sound 1
- aggressive electric guitar 1
- blues 1
- dangerous 1
- eerie 1
- fast tempo 1
- goth rock 1
- groovy bass line 1
- guitar solo 1
- hard metal 1
- hard rock 1
- inferior audio quality 1
- intense 1
- jam 1
- metal 1
- no vocals 1
- overdriven electric guitar 1
- single instrument 1
- sinister keyboard harmony 1
- spirited 1
- spooky 1
- steady drumming 1
- suspenseful 1
- youthful 1
musiccaps_names (array) 9 ✖
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 | |
EFFECTS 101: Overdrive | This is a recording of an instrumental jam. There is a blues type solo being performed on an overdriven electric guitar. The guitar has an 80s sound. This recording could be sampled for use in beat-making or as an advertisement jingle. | 2010-02-19T08:05:06Z | rolandmedia | Overdrive is one of the most used guitar effects. As Johnny DeMarco shows, overdrive is used in virtually every kind of guitar music and youll see this kind of pedal in nearly every stage or studio. | ["Reverberation", "Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion", "Bowed string instrument"] | ["jam", "instrumental", "single instrument", "overdriven electric guitar", "guitar solo", "80s sound", "blues"] | 9 | 40i3_JH6FYw | 530 |
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;