musiccaps_details (view)
4 rows where musiccaps_aspects contains "low quality", musiccaps_aspects contains "punchy kick" and musiccaps_names contains "Independent music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- low quality · 4 ✖
- punchy kick · 4 ✖
- groovy bass guitar 3
- punchy snare 3
- rock 3
- emotional 2
- energetic 2
- flat male vocal 2
- groovy 2
- melancholic male vocal 2
- shimmering hi hats 2
- acoustic rhythm guitar 1
- aggressive 1
- bouncy snare 1
- distorted bass guitar 1
- energetic crash cymbal 1
- flat female vocal 1
- groovy wide electric guitar riff 1
- harmonizing high pitched female vocal 1
- heartfelt 1
- melancholic 1
- mellow synth bells melody 1
- messy 1
- metal 1
- muddy 1
- noisy 1
- shimmering ride cymbals 1
- synth lead melody 1
- wide electric guitar chords 1
- wide electric guitar melody 1
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 | |
Smashing Pumpkins - Whir (Whirl) | The low quality recording features a rock song that consists of melancholic male vocal singing over a wide electric guitar melody, bouncy snare, groovy bass guitar and punchy kick. The recording is noisy, muddy and messy, since the frequencies are clashing with each other - drums cymbals are inaudible. Regardless, it sounds groovy, emotional and melancholic thanks to that vocal. | 2012-04-26T21:13:42Z | xthreenightsx | Demo '92 | ["Music", "Independent music", "Grunge"] | ["low quality", "rock", "wide electric guitar melody", "melancholic male vocal", "bouncy snare", "groovy bass guitar", "noisy", "muddy", "messy", "punchy kick", "melancholic", "emotional", "groovy"] | 4 | aO0QzRPiEC4 | 3533 | |
I've Got My Glasses On 👓 Wearing Glasses Song for Children 🧐🤓😎 The Wiggles | The low quality recording features a rock song that consists of a flat male vocal and flat female vocal talking, followed by punchy kick and snare hits, shimmering hi hats, energetic crash hits, wide electric guitar chords, groovy bass guitar and synth lead melody. It sounds energetic. | 2013-02-07T23:21:04Z | The Wiggles | Subscribe to our channel for more Wiggly videos: http://ab.co/WigglesYouTube For more Wiggly fun: Website ► http://TheWiggles.com.au Facebook ► http://facebook.com/TheWiggles Twitter ► http://twitter.com/TheWiggles Instagram ► http://instagram.com/TheWiggles Spotify ► https://ab.co/TheWigglesSpotify US & UK Shop ► https://thewigglestore.com/ AUS Shop ► https://thewigglestore.com.au/ #glasses #kidsglasses #thewiggles | ["Music", "Independent music", "Speech"] | ["low quality", "rock", "flat female vocal", "flat male vocal", "energetic crash cymbal", "groovy bass guitar", "wide electric guitar chords", "synth lead melody", "shimmering hi hats", "punchy kick", "punchy snare", "energetic"] | 4 | b-Y-AjW6MJ0 | 3594 | |
Kurt Cobain-Half The Man I Used To Be | The low quality recording features a rock song that consists of a melancholic male vocal singing over punchy kick and snare hits, shimmering ride cymbals, groovy bass guitar and acoustic rhythm guitar. It sounds emotional and heartfelt. | 2007-05-01T17:41:40Z | crkuhifan | half the man i used to be song with nirvana's leader kurt cobain | ["Music", "Independent music", "Progressive rock", "Grunge"] | ["low quality", "rock", "melancholic male vocal", "punchy snare", "shimmering ride cymbals", "punchy kick", "groovy bass guitar", "acoustic rhythm guitar", "emotional", "heartfelt"] | 4 | nvRd4xgEWbw | 4591 |
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;