musiccaps_details (view)
2 rows where musiccaps_aspects contains "keyboard harmony", musiccaps_aspects contains "rhythmic beat" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- instrumental 2
- keyboard harmony · 2 ✖
- rhythmic beat · 2 ✖
- aggressive 1
- ambient nature sounds 1
- animated 1
- background noises 1
- background sounds 1
- catchy 1
- cheerful 1
- cheering 1
- chirpy 1
- contrasting aggressive sounds 1
- electronic music 1
- energetic drumming 1
- groovy bass line 1
- happy 1
- lively beat 1
- medium fast tempo 1
- medium tempo 1
- merry 1
- muffled audio 1
- people talking 1
- pleasant music 1
- pop song 1
- popular 1
- punchy drums 1
- rhythmic acoustic guitar 1
- shooting 1
- simple 1
- smashing 1
- sound of crashing 1
- sound of laughter 1
- spirited 1
- steady drumming 1
- tapping 1
- video game music 1
- xylophone harmony 1
- ’ enjoyable 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Agar.io - EPIC AGARIO BATTLE (AGARIO GAMEPLAY) | This music is an electronic instrumental. The tempo is medium with a steady, rhythmic keyboard harmony, simple drumming and groovy bass lines. There are sounds of crashing, glass breaking, explosions or gunshots in the background superimposing over the music. The sounds are in stark contrast to the melodious music, with the crashing and shooting giving it an aggressive vibe; | 2016-02-28T20:51:06Z | TARGET | Clan : ŦŘǤŦ🎯 ŦŘǤŦ🎯 Clan : http://goo.gl/agR2Qd Clan Grup : https://goo.gl/SPsAL9 Facebook : https://goo.gl/u03Oj4 Music: Deny O.K. & Bonkersless - Instinct https://www.youtube.com/watch?v=aAG1GNenXv4 Goblins from Mars - Bitter World https://www.youtube.com/watch?v=BAcaa98qQtM | ["Music", "Breaking"] | ["instrumental", "medium fast tempo", "groovy bass line", "aggressive", "pleasant music", "contrasting aggressive sounds", "video game music", "keyboard harmony", "steady drumming", "electronic music", "sound of crashing", "background noises", "smashing", "shooting", "punchy drums", "spirited", "animated", "rhythmic beat"] | 7 | ksYM8YzzWXo | 4362 | |
Stand By Me (steel pan) | This music is a cheerful instrumental. The tempo is medium with the lead harmony on a Xylophone, energetic drumming, keyboard accompaniment and rhythmic acoustic guitar. The audio quality is inferior and the music is muffled and muddy. There are background sounds like people talking, laughing and ambient nature sounds like a breeze. The music is fun, youthful, simple, enjoyable, chirpy and vivacious. | 2008-02-13T06:13:56Z | svart3n | Steel Pan band at the 30th anniversary Flatbush Frolic in Brooklyn, NY, 2007. See the video in better quality @ http://youtu.be/LlCS3ZVutuk | ["Music", "Steelpan"] | ["instrumental", "medium tempo", "rhythmic acoustic guitar", "background sounds", "ambient nature sounds", "people talking", "sound of laughter", "cheering", "tapping", "merry", "happy", "chirpy", "cheerful", "’ enjoyable", "xylophone harmony", "energetic drumming", "muffled audio", "keyboard harmony", "lively beat", "catchy", "rhythmic beat", "pop song", "popular", "simple"] | 7 | tV3rvUSlVnY | 5043 |
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;