musiccaps_details (view)
3 rows where musiccaps_aspects contains "buoyant", musiccaps_aspects contains "slow tempo" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 47 ✖
- buoyant · 3 ✖
- slow tempo · 3 ✖
- hip-hop 2
- male vocalist 2
- punchy 2
- rap 2
- synthesiser arrangement 2
- youthful 2
- amateur percussionist 1
- beep 1
- boomy 1
- bouncy 1
- catchy vocal riff 1
- club music 1
- dance groove 1
- digital drumming 1
- digital drums 1
- drum beats 1
- drum machine 1
- edm 1
- electric guitar lead 1
- electro-hop 1
- electronic articulation 1
- electronic music 1
- electronica 1
- groovy 1
- groovy bass line 1
- house music 1
- hypnotic 1
- keyboard harmony 1
- low audio quality 1
- male singer 1
- percussions 1
- piano accompaniment 1
- pop rap 1
- psychedelic 1
- punchy beats 1
- retro feel 1
- rhythm arrangement 1
- rock and roll 1
- rock music 1
- soft rock 1
- southern hip hop 1
- steady drumming 1
- syncopated harmony 1
- techno hop 1
- trap 1
musiccaps_names (array) 4 ✖
- Music 3
- Busy signal 1
- Hip hop music 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Slow Bouncin- Juicy J,Trey Songz ft. Wale X Chop Marley | A male vocalist sings this trippy Electronic song. The tempo is slow with synthesiser arrangement, digital drums and electronically articulated music. The song is catchy, youthful, enthusiastic, trippy, psychedelic , new age, and groovy. This song is an Electro -Hop/ Hip-Hop. | 2013-09-13T23:12:07Z | Dab Marley | The Chopstafarian Is back hope y'all like the new tracks......Bless up. | ["Music", "Hip hop music"] | ["male vocalist", "slow tempo", "electronic music", "electro-hop", "edm", "club music", "house music", "electronica", "hip-hop", "techno hop", "synthesiser arrangement", "electronic articulation", "digital drums", "southern hip hop", "punchy", "buoyant", "youthful", "psychedelic", "hypnotic", "trap", "rap"] | 7 | 0RDz0rLakwc | 165 | |
Runescape Dungeoneering Guide - Doors [HD] | This song has a male vocalist singing a rhythmic vocal riff to the beat of digital drumming followed by the sound of a beep. The percussion is amateur and the vocals are muffled as the audio quality is inferior. The song is slow tempo and the beat is punchy, groovy, buoyant and youthful. | 2010-10-15T16:30:46Z | adamchrome | This video shows the different doors that you can encounter during a dungeon and how to complete them all. Doors in dungeoneering are very important in exploring the floor as these are the gateways between rooms. You must know how to bypass all the doors you can be faced with in order to fully explore a dungeon. There are 3 main types of doors: Locked doors requiring a key to open Guardian doors protected by the monsters in the room Skill doors blocked by an obstruction requiring a skill and/or item to bypass Locked doors are opened with keys that can be found throughout the dungeon. One player, known as the key holder, should carry all the keys so that it is easy to manage which keys the team has. If a locked door is a very long way away from the starting room and your team doesn't have the correct key, then it is highly advisable for a team member to place a gatestone at the door to avoid time running through the dungeon. --------------------------------------------------- Guardian doors are doors which can't be opened until all monsters in the room have been killed, except for the dinosaurs. When you are clearing a guardian room with your team, there is a certain order that players should kill the monsters, based on their difficulty. As a basic principle, all monsters that can see through the shadow-silk hood should be eliminated first. Even if you don't own a silk hood, other team members will take less damage when they're dead resulting in less food used in the long run. Mages - Mages should be killed first because of their damaging magic attack and their ability to negate the effects of the shadow-silk hood. Forgotten mages and Necromancers fall under this category. Shades - Shades and ghosts are highly dangerous due to their highly damaging range and magic attacks. Demons and other mages - Lesser, greater and black demons hit quite considerable amounts of damage with magic and melee. Spiders - Spiders should be killed after the dangerous mages because of their poisoning ab… | ["Busy signal", "Music"] | ["percussions", "drum machine", "boomy", "catchy vocal riff", "digital drumming", "youthful", "buoyant", "punchy", "bouncy", "dance groove", "amateur percussionist", "male vocalist", "slow tempo", "pop rap", "low audio quality", "rap", "hip-hop", "beep", "drum beats", "rhythm arrangement"] | 7 | YZx0_GRtvJk | 3295 | |
Ray Manzarek - 02 Solar Boat | A male vocalist sings this Soft Rock. The tempo is slow with electronic arrangements,steady drumming, groovy bass line , and syncopated keyboard harmony. The background instruments play a dissonant melody. This song is a mellow, youthful, punchy, buoyant, Soft Rock. | 2009-11-04T21:57:51Z | Simagga | Ray Manzarek - The Golden Scarab | ["Music", "Soul music"] | ["male singer", "slow tempo", "rock music", "soft rock", "keyboard harmony", "groovy bass line", "syncopated harmony", "piano accompaniment", "steady drumming", "electric guitar lead", "synthesiser arrangement", "rock and roll", "retro feel", "groovy", "soft rock", "buoyant", "punchy beats"] | 7 | n4PBoAedWVA | 4517 |
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;