musiccaps_details (view)
2 rows where musiccaps_aspects contains "happy" and musiccaps_names contains "Dance music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- happy · 2 ✖
- acoustic rhythm guitar 1
- afro beats 1
- akuba 1
- bright drumming 1
- carefree 1
- catchy 1
- cheerful 1
- clave 1
- conga 1
- dance groove 1
- dominant music 1
- energetic 1
- energetic drums 1
- fast tempo 1
- folk 1
- foreign language 1
- fun 1
- groovy accordion melody 1
- inspirational 1
- low quality 1
- male chants 1
- male singer 1
- nigerian music 1
- pleasant 1
- propulsive percussion 1
- reflective 1
- reggae 1
- strings melody 1
- ugandan song 1
- upstroke rhythm guitar 1
- wide claps 1
- world music 1
- youthful 1
musiccaps_names (array) 7 ✖
- Dance music · 2 ✖
- Music 2
- /t/dd00032 1
- Afrobeat 1
- Music of Africa 1
- Pop music 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 | |
Sitya Loss Remix - Eddy Kenzo | A male vocalist sings this energetic Nigerian song. The tempo is fast and upbeat with keyboard harmony and Afro beats of conga, clave, drums and akuba. The music is upbeat, catchy, spirited, energetic, youthful and pulsating with a dance groove. This song is a Reggae song. | 2014-02-20T13:25:19Z | Eddy Kenzo | big talent young managment | ["Afrobeat", "Music of Africa", "Music", "Dance music"] | ["male singer", "fast tempo", "nigerian music", "world music", "propulsive percussion", "upstroke rhythm guitar", "dominant music", "pleasant", "catchy", "youthful", "dance groove", "happy", "cheerful", "carefree", "conga", "clave", "akuba", "bright drumming", "reggae", "ugandan song", "foreign language", "afro beats", "reggae", "inspirational", "reflective"] | 7 | Xaq-segSEsQ | 3200 |
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;