musiccaps_details (view)
2 rows where musiccaps_aspects contains "slow tempo" and "youtube_published" is on date 2010-10-15
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- slow tempo · 2 ✖
- amateur percussionist 1
- beep 1
- birds 1
- boomy 1
- bouncy 1
- buoyant 1
- catchy vocal riff 1
- dance groove 1
- digital drumming 1
- drum beats 1
- drum machine 1
- environmental noises 1
- hip-hop 1
- low audio quality 1
- male vocalist 1
- ocean waves 1
- percussions 1
- pop rap 1
- punchy 1
- rap 1
- rhythm arrangement 1
- synth pad 1
- train passing 1
- youthful 1
musiccaps_names (array) 4 ✖
- Music 2
- Busy signal 1
- Caw 1
- Outside, rural or natural 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DJ Tatana - Spring breeze | This audio contains environmental noises as ocean waves sounds; seabirds singing; a train passing by and a synth pad playing a short rising sound. This song may be playing in an advertisement. | 2010-10-15T04:48:33Z | Timelesswarp | "Daffodils" (1804) I WANDER'D lonely as a cloud That floats on high o'er vales and hills, When all at once I saw a crowd, A host, of golden daffodils; Beside the lake, beneath the trees, Fluttering and dancing in the breeze. Continuous as the stars that shine And twinkle on the Milky Way, They stretch'd in never-ending line Along the margin of a bay: Ten thousand saw I at a glance, Tossing their heads in sprightly dance. The waves beside them danced; but they Out-did the sparkling waves in glee: A poet could not but be gay, In such a jocund company: I gazed -- and gazed -- but little thought What wealth the show to me had brought: For oft, when on my couch I lie In vacant or in pensive mood, They flash upon that inward eye Which is the bliss of solitude; And then my heart with pleasure fills, And dances with the daffodils. By William Wordsworth (1770-1850). | ["Music", "Caw", "Outside, rural or natural"] | ["environmental noises", "ocean waves", "birds", "train passing", "synth pad", "slow tempo"] | 6 | J1-Qvl7u2TI | 1961 | |
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;