musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "fun", musiccaps_aspects contains "low quality" and musiccaps_names contains "Pop music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- energetic 2
- fun · 2 ✖
- low quality · 2 ✖
- acoustic guitar chords 1
- acoustic rhythm guitar 1
- energetic drums 1
- folk 1
- funky piano chords 1
- groovy accordion melody 1
- groovy bass 1
- happy 1
- male chants 1
- punchy kick 1
- punchy snare 1
- regional mexican 1
- reverberant male vocal 1
- simple hi hats 1
- snare roll 1
- strings melody 1
- wide claps 1
musiccaps_names (array) 6 ✖
- Music 2
- Pop music · 2 ✖
- /t/dd00032 1
- Dance music 1
- Ska 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 |
---|---|---|---|---|---|---|---|---|---|---|
La Bamba - twist And Shout - Anderson Palopoli | The Low Quality recording features a regional Mexican song sung by reverberant male vocals over acoustic guitar chords, punchy snare and kick hits, groovy bass and funky piano chords. There is a short snare roll at one point that serves as a transition to the next section of the song. Sounds a bit muffled, as it is a live performance, but also energetic and fun. | 2010-03-10T03:24:15Z | WJSTUDIO2010 | Musica do DVD do Showman Anderson Palopoli | ["Music", "Pop music", "Ska"] | ["low quality", "regional mexican", "reverberant male vocal", "acoustic guitar chords", "groovy bass", "funky piano chords", "simple hi hats", "punchy kick", "punchy snare", "snare roll", "energetic", "fun"] | 4 | 1Q9DXhXMSFI | 269 | |
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 |
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;