musiccaps_details (view)
2 rows where musiccaps_aspects contains "dissonant music" and musiccaps_aspects contains "instrumental"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- dissonant music · 2 ✖
- instrumental · 2 ✖
- accelerated rhythm 1
- animated 1
- bubbles 1
- calm background music 1
- chaotic 1
- chimes 1
- dangerous 1
- discordant music 1
- dj mixer 1
- eerie 1
- electric guitar melody 1
- fast forwarding sound 1
- fast tempo 1
- inferior sound quality 1
- inharmonious 1
- keyboard harmony 1
- keyboard riff 1
- mellow background music 1
- muffled electronic sounds 1
- noisy 1
- sinister chime melody 1
- slow tempo 1
- sound of blast 1
- sound of water 1
- steady drumming 1
- synthesised sounds 1
- turntable 1
- video game sounds 1
musiccaps_names (array) 4 ✖
youtube_published (date) 2 ✖
- 2008-01-05 1
- 2009-02-17 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Water Temple as a child segment 2 | This song is an instrumental. The tempo is slow with the music starting with the sound of blasts,sinister melody of chimes , muddled sounds,sound of water or bubbles, and synthesised arrangements with beeps at the end of this clip.It is animated, sinister, chaotic with discordant music. | 2008-01-05T00:29:59Z | ThomazSDA | I finally took my time to start recording my run in the Water Temple as a child. I first had in mind to combine this segment with getting the Big Boss Key but that's so incredibly hard so I decided to split it up. I had some errors at the end. I forgot to pull sword before going into the last room and didn't run forward as much as I wanted but otherwise good. The trick with the torches I got from ZeldaXmaster. =) I haven't actually recorded the first segment yet, but will do in the future. Getting in this bloody temple is hard. Enjoy! | ["Music", "Gurgling"] | ["instrumental", "slow tempo", "chimes", "discordant music", "animated", "eerie", "dangerous", "sound of water", "bubbles", "keyboard riff", "synthesised sounds", "sinister chime melody", "video game sounds", "sound of blast", "dissonant music", "inharmonious"] | 7 | WFPGA_BYkKU | 3079 | |
DJ KANZER SCRATCH FRESHHHHHHH | This song is an instrumental. The tempo of the background music is slow , with electric guitar harmony and rhythmic drum with loud chaotic, dissonant sounds. The music is out of sync as the unidentifiable sounds are accelerated. | 2009-02-17T05:38:13Z | djkanzertv | ["Scratching (performance technique)", "Music", "Scratch"] | ["instrumental", "mellow background music", "steady drumming", "keyboard harmony", "electric guitar melody", "fast tempo", "calm background music", "accelerated rhythm", "chaotic", "noisy", "turntable", "dj mixer", "muffled electronic sounds", "fast forwarding sound", "dissonant music", "inferior sound quality"] | 7 | bl-eQ8XD5CY | 3648 |
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;