musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "groovy bass line" and musiccaps_aspects contains "inferior audio quality" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 52 ✖
- groovy bass line · 3 ✖
- inferior audio quality · 3 ✖
- energetic 2
- enthusiastic 2
- fast tempo 2
- loud 2
- male vocalist 2
- people talking 2
- pop rock 2
- youthful 2
- acoustic pop rock 1
- aggressive electric guitar 1
- boomy 1
- bright 1
- coughing 1
- dance music 1
- dangerous 1
- eerie 1
- gig 1
- goth rock 1
- hard metal 1
- hard rock 1
- instrumental 1
- intense 1
- intense drumming 1
- intense electric guitar 1
- jarring 1
- keyboard harmony 1
- live performance 1
- lively electric guitar 1
- medium tempo 1
- metal 1
- muffled audio 1
- no vocals 1
- people cheering 1
- pop 1
- popnrock 1
- punchy drumming 1
- rhythmic acoustic guitar 1
- rock 1
- rock and roll 1
- rustling 1
- sinister keyboard harmony 1
- spirited 1
- spooky 1
- static 1
- steady drumming 1
- suspenseful 1
- synthesiser harmony 1
- vibrant 1
- vigorous vivacious 1
- vocal backup 1
musiccaps_names (array) 10 ✖
- Music 3
- Angry music 1
- Blues 1
- Country 1
- Inside, large room or hall 1
- Jazz 1
- Musical instrument 1
- Rock music 1
- Roll 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rock 'n' Roll Girls -- John Fogerty | A male vocalist sings this spirited rock and rock song. The tempo is fast with bright drumming, intense electric guitar feedback, keyboard harmony and rhythmic acoustic guitar with vocal backup. The song is upbeat, spirited, enthusiastic, vibrant, vivacious, buoyant and youthful with a dance groove. The sound quality is inferior making it difficult to understand the lyrics or the finer elements of this Rock and Roll song. | 2008-09-03T02:10:47Z | zanzkantdance | John Fogerty performs "Rock and Roll Girls" from Centerfield live in Oakland in 1986, set to various background videos. | ["Singing", "Music", "Musical instrument", "Rock music", "Roll", "Inside, large room or hall"] | ["male vocalist", "fast tempo", "intense electric guitar", "punchy drumming", "keyboard harmony", "vocal backup", "rhythmic acoustic guitar", "groovy bass line", "loud", "jarring", "inferior audio quality", "people cheering", "people talking", "energetic", "enthusiastic", "vigorous vivacious", "bright", "enthusiastic", "dance music", "pop", "pop rock", "rock", "rock and roll"] | 7 | 1ZaxqZMs21M | 287 | |
Josh Rouse - Love vibration (live in Madrid 2007) | A male vocalist sings this lively pop rock. The tempo is medium with an intense electric guitar harmony, punchy drumming, groovy bass lines and keyboard harmony. The song is muffled as the audio quality is inferior but it sounds enthusiastic, youthful, passionate and vibrant. This could be a live performance as there are background sounds of people talking, coughing, rustling. This song is Pop Rock. | 2007-11-23T05:28:53Z | ruben garrido | Josh Rouse en directo en Madrid - 22 noviembre 2007 (live in Madrid) Mi cronica del concierto pinchando aqui: http://40formasdeintimidad.wordpress.com/2007/11/23/en-joy-josh-rouse/ | ["Blues", "Country", "Jazz", "Music"] | ["male vocalist", "medium tempo", "popnrock", "live performance", "gig", "acoustic pop rock", "pop rock", "youthful", "energetic", "vibrant", "enthusiastic", "people talking", "coughing", "rustling", "lively electric guitar", "intense drumming", "synthesiser harmony", "groovy bass line", "muffled audio", "inferior audio quality", "static", "boomy", "loud"] | 7 | SwaqANBpZGY | 2797 | |
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;