musiccaps_details (view)
2 rows where musiccaps_aspects contains "digital drumming", musiccaps_aspects contains "slow tempo" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- digital drumming · 2 ✖
- slow tempo · 2 ✖
- amateur percussionist 1
- amplified cello harmony 1
- beep 1
- boomy 1
- boomy bass 1
- bouncy 1
- bow stringed instrument 1
- buoyant 1
- captivating 1
- catchy vocal riff 1
- dance groove 1
- drum beats 1
- drum machine 1
- engaging 1
- four stringed instrument 1
- hip-hop 1
- instrumental 1
- low audio quality 1
- male vocalist 1
- melodious 1
- mesmerising 1
- percussions 1
- pop rap 1
- punchy 1
- rap 1
- rhythm arrangement 1
- soft 1
- soothing 1
- steady drumming 1
- string instrument 1
- ukelele accompaniment 1
- violin 1
- youthful 1
musiccaps_names (array) 6 ✖
- Bowed string instrument 1
- Busy signal 1
- Cello 1
- Double bass 1
- Music 1
- Pizzicato 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Missing from YouTube | This is a melodious instrumental. The tempo is slow with a cello harmony, ukulele accompaniment, boomy bass and steady drumming. The music is soft, mellow, ethereal, classic, soothing, captivating and mellifluous. | ["Cello", "Double bass", "Pizzicato", "Bowed string instrument"] | ["instrumental", "slow tempo", "amplified cello harmony", "bow stringed instrument", "four stringed instrument", "string instrument", "digital drumming", "ukelele accompaniment", "boomy bass", "violin", "steady drumming", "soft", "soothing", "engaging", "captivating", "mesmerising", "melodious"] | 7 | 2344 | |||||
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 |
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;