musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "happy", musiccaps_aspects contains "strings melody" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- fun 2
- happy · 2 ✖
- low quality 2
- strings melody · 2 ✖
- acoustic guitar chords 1
- acoustic rhythm guitar 1
- breathy flute melody 1
- energetic 1
- energetic drums 1
- folk 1
- groovy accordion melody 1
- groovy bass 1
- harmonized vocals 1
- male chants 1
- pop 1
- traditional 1
- wide claps 1
- wooden percussions 1
musiccaps_names (array) 6 ✖
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 | |
Atif Aslam Olpers Qawwali / Naat Hum Mustafavi Hain | The low quality recording features a traditional pop song that consists of harmonized vocals singing over breathy flute melody, groovy bass, wooden percussion, strings melody and acoustic guitar chords. It sounds happy and fun - like a song you would hear in a TV commercial. | 2009-08-21T07:54:51Z | fsfaizan | Download it from http://www.koolmuzone.com/2009/08/atif-aslam-olpers-qawwali-audio/ The Naat/Qawwali is done by Atif Aslam for Engro foods which produces milk products. Lyrics: Hum Mustafavi Hain Aaa.. Hum Ne Ki Dawat Kul Aalam Mein We Have A Message Peace For The Earth Maslak Aam... Hamara.... Sub Ki Zubaan Par Sub Kay Diloon Mein Yeh Paighaam.. Hamara... Allah Ho Akbar X 2 Hum Ta Wa Abad Saiyoo Taghiyor Kay Wali Hein Hum Ta Wa Abad Saiyoo Taghiyor Kay Wali Hein Hum Mustafavi Mustafavi Mustafavi Hein X 2 Mustafavi Hein Deen Hamara Deeno Mukamal Is Kay Maa Hai Baat e Arzal Khair Hai Jedo Jahed Musalsal InAllah X 6 Allah Ho Akbar X 2 | ["Music", "Middle Eastern music"] | ["low quality", "pop", "traditional", "breathy flute melody", "groovy bass", "wooden percussions", "harmonized vocals", "strings melody", "acoustic guitar chords", "happy", "fun"] | 4 | nONXdP6T3pc | 4534 |
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;