musiccaps_details (view)
3 rows where musiccaps_aspects contains "happy", musiccaps_aspects contains "low quality" and musiccaps_names contains "Pop music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- happy · 3 ✖
- low quality · 3 ✖
- fun 2
- pop 2
- "4 on the floor" kick pattern 1
- acoustic rhythm guitar 1
- addictive 1
- chiptune 1
- clapping 1
- crowd cheering 1
- energetic 1
- energetic cymbals 1
- energetic drums 1
- exciting 1
- flat male vocal 1
- folk 1
- groovy accordion melody 1
- groovy synth bass 1
- high pitched female vocal 1
- joyful 1
- live performance 1
- male chants 1
- punchy "4 on the floor" kick pattern 1
- remix 1
- repetitive synth melody 1
- shimmering bells melody 1
- stretched audio 1
- strings melody 1
- synth lead melody 1
- wide claps 1
musiccaps_names (array) 8 ✖
- Music 3
- Pop music · 3 ✖
- /t/dd00032 1
- Dance music 1
- Exciting music 1
- Singing 1
- Soundtrack music 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Vitaa ft Maitre Gim's Game over - Chipmunks music video | The low quality recording features a chiptune remix of a pop song and it consists of high pitched female vocal singing over repetitive synth melody, punchy "4 on the floor" kick pattern and shimmering bells melody at the very beginning of the loop. It sounds kind of addictive, fun and happy. The audio sounds like it was stretched. | 2014-01-16T18:13:45Z | Djanyzia Emeraude | Game over de Vitaa et Maitre Gim's par les Chipmunks/Chipettes. Like et commente la vidéo | ["Music", "Pop music", "Exciting music"] | ["low quality", "stretched audio", "pop", "high pitched female vocal", "repetitive synth melody", "punchy \"4 on the floor\" kick pattern", "shimmering bells melody", "chiptune", "remix", "fun", "happy", "addictive"] | 4 | 5iPTcL50mvw | 685 | |
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 | |
[FANCAM] 101230 kbs gayo opening - Last Festival (Junho focus) | The low quality recording features a live performance of a pop song that contains flat male vocals talking on a microphone over a song played on playback and some crowd cheering noises. The song consists of a "4 on the floor" kick pattern, energetic cymbals, groovy synth bass, claps and synth lead melody. It sounds happy, joyful and exciting. | 2010-12-30T19:35:19Z | casey (emperornuneo) | Credit: AboutABoy | ["Singing", "Music", "Pop music", "Yell"] | ["low quality", "live performance", "pop", "crowd cheering", "flat male vocal", "clapping", "synth lead melody", "\"4 on the floor\" kick pattern", "energetic cymbals", "groovy synth bass", "happy", "joyful", "exciting"] | 4 | mB2FAS0DNkk | 4451 |
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;