musiccaps_details (view)
1 row where musiccaps_aspects contains "energetic", musiccaps_aspects contains "groovy", musiccaps_aspects contains "groovy wide electric guitar riff" and musiccaps_aspects contains "metal"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Teemo Shroom (Original) [#TeemoTuesdays Cypher 2014] - The Yordles | The low quality recording features a metal song that contains a flat male vocal, alongside harmonizing high pitched female vocal, singing over punchy kick and snare hits, shimmering hi hats, distorted bass guitar, mellow synth bells melody and groovy wide electric guitar riff. It sounds energetic, groovy, aggressive. | 2014-05-06T20:59:26Z | The Yordles | Discuss on Reddit: http://www.reddit.com/r/leagueoflegends/search?q=%23TeemoTuesdays+Cypher&restrict_sr=on&sort=relevance&t=all #TeemoTuesdays 2014 Cypher Playlist: http://bit.ly/1shDnEo Buy this song ► http://itunes.apple.com/album/id874427098 Support us directly ► https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=HCX3JYNEFQV3Y Play LoL for free ► http://signup.leagueoflegends.com/?ref=4e3b93caab1b6183697184 Twitter ► http://www.twitter.com/theyordles Facebook ► http://www.facebook.com/theyordles Livestream ► http://www.twitch.tv/theyordles Buy our songs ► http://theyordles.bandcamp.com or iTunes Spotify ► https://play.spotify.com/artist/2QOvTVjxq2ss2co5pqpnWY UberGuitarDude uses Pro Built Systems ► http://www.probuiltsystems.com ► http://www.twitter.com/probuiltsystems Join "The Yordles" chat in League Of Legends - Click the bottom right corner of the LoL client, type in The Yordles, and join! Be sure to set it to auto-join and stay in the family! Join us on the The Yordles Raidcall! ► http://www.raidcall.com/go.php?sid=6870409 ► Group ID: 6870409 ◄ Lyrics: [Verse 1] From the land of Bandle City All across the Summoner's Rift The yordle known as Teemo A scout who's small and swift Camouflaged in top lane Or perhaps he's creeping mid Armed and ready with his blowgun And escape he will forbid [Pre chorus] Never underestimate The power of the scout's code He will seal your fate HUT 2, 3, 4!!! [Chorus] The Swift Scout, A Bandle City citizen Tell Lee Sin that there's a new Legend Reporting in, size doesn't mean everythin' Move quick, toxic shot, that's got a sting Blinding dart, missing every single swing In the end if you're still standing THEN I'LL GET YA WITH MY TEEMO SHROOMS! [Verse 2] With the cuteness of a Moogle, Dunks like Shaquille O'neal A mask that's not Majora's And a global taunt so real. The source of all his power Shrooms 1-UP, death counts Ryze With the courage to move forward, And the wisdom to survive [Bridge] The hero of Bandle City The hero that we all need … | ["Music", "Independent music"] | ["low quality", "metal", "flat male vocal", "harmonizing high pitched female vocal", "punchy kick", "punchy snare", "distorted bass guitar", "groovy wide electric guitar riff", "shimmering hi hats", "aggressive", "groovy", "energetic", "mellow synth bells melody"] | 4 | ZOzavOPeuJQ | 3373 |
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;