musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic rhythm guitar", musiccaps_aspects contains "energetic" and musiccaps_aspects contains "fun"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- acoustic rhythm guitar · 2 ✖
- energetic · 2 ✖
- fun · 2 ✖
- disco 1
- energetic drums 1
- exciting 1
- flat male vocal 1
- folk 1
- groovy accordion melody 1
- groovy bass guitar 1
- happy 1
- low quality 1
- male chants 1
- punchy snare 1
- shimmering shakers 1
- simple kick patter 1
- sizzling triangle 1
- strings melody 1
- wide claps 1
- wide electric guitar chord progression 1
- wide tinny percussive elements 1
musiccaps_names (array) 8 ✖
- Music 2
- /m/05zppz 1
- /t/dd00032 1
- Dance music 1
- Disco 1
- Pop music 1
- Rhythm and blues 1
- Soundtrack music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Team Fortress 2 music - Soldier of Dance (Kazotsky Kick) | The low quality recording features a folk song that consists of a groovy accordion melody, strings melody, acoustic rhythm guitar, energetic drums and some crowd male chants and wide claps. It sounds energetic, fun and happy. | 2015-07-03T07:29:23Z | Dogman15 | This is a piece of main menu music that was added to Team Fortress 2 on July 2, 2015. For the main menu, it is known as "Soldier of Dance", and sounds as you hear it here. When being used for the Kazotsky Kick taunt (an all-class group taunt), it is known as "Cossack Sandvich". Some people may know the dance of this taunt, the Cossack Dance (or Hopak), as a "Russian Dance". https://en.wikipedia.org/wiki/Hopak Read more about the update here: http://www.teamfortress.com/gunmettle/ https://wiki.teamfortress.com/wiki/Soldier_of_Dance_%28Soundtrack%29 https://wiki.teamfortress.com/wiki/Team_Fortress_2_Official_Soundtrack As always, this music was written by Mike Morasky. You can also hear an earlier version of it on de_train in Counter-Strike: Global Offensive. If you would like to extract sound files from Valve games like this on your own, get GCFScape: http://nemesis.thewavelength.net/?p=26 Then open up the directory VPKs that have the files in them. What you want is probably in the "sound" folder of a Source Engine game. | ["Music", "Pop music", "Dance music", "Soundtrack music", "/t/dd00032"] | ["happy", "fun", "low quality", "groovy accordion melody", "strings melody", "energetic drums", "male chants", "wide claps", "acoustic rhythm guitar", "energetic", "folk"] | 4 | 7Us4WHDmfeA | 849 | |
70´s Music Disco Samba Two man sound | The Disco song features a widely spread electric guitar chord progression, acoustic rhythm guitar, shimmering shakers, tinny percussive elements, followed by simple kick pattern, punchy snare and groovy bass guitar, over which sings the flat male vocal. It sounds energetic, fun and exciting, as it is something you would definitely hear in clubs during 70s and 80s. | 2010-07-19T01:10:27Z | StarsMoon14 | ["Disco", "Music", "/m/05zppz", "Rhythm and blues"] | ["disco", "wide electric guitar chord progression", "acoustic rhythm guitar", "shimmering shakers", "simple kick patter", "punchy snare", "groovy bass guitar", "wide tinny percussive elements", "sizzling triangle", "flat male vocal", "fun", "exciting", "energetic"] | 4 | wZopmfXTtxw | 5275 |
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;