musiccaps_details (view)
2 rows where musiccaps_aspects contains "distorted sounds", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "noisy"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- boisterous 2
- distorted sounds · 2 ✖
- fast tempo 2
- instrumental · 2 ✖
- noisy · 2 ✖
- unpleasant 2
- vigorous 2
- beep 1
- boisterous unrelated 1
- chain saw 1
- chaotic 1
- deafening 1
- dissonant 1
- dissonant unrelated 1
- electronic music 1
- engine 1
- harsh 1
- inferior audio quality 1
- intense 1
- loud electric guitar feedback 1
- multiple tracks playing 1
- music 1
- raw 1
- running 1
- sharp 1
- subdued song in background 1
- superimposed tracks 1
- telephone busy signal 1
- trumpets 1
musiccaps_names (array) 10 ✖
- Music 2
- Bass guitar 1
- Chainsaw 1
- Clatter 1
- Distortion 1
- Effects unit 1
- Electric guitar 1
- Heavy metal 1
- Reverberation 1
- Roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chainsaw art time lapse | This is a multi track audio. There are several things happening. There’s an energetic song in the background with enthusiastic vocals, drumming and trumpets. There’s a loud whirring of an engine, like a chain saw, beeps and a phone dial tone. The audio is loud, confusing, chaotic, boisterous,unrelated , noisy, loud, dissonant and unpleasant. | 2008-06-17T18:46:38Z | dtremko | Four days of carving in 2 minutes | ["Chainsaw", "Music", "Roll"] | ["instrumental", "fast tempo", "engine", "vigorous", "dissonant", "unpleasant", "superimposed tracks", "distorted sounds", "dissonant unrelated", "boisterous", "noisy", "chain saw", "music", "beep", "telephone busy signal", "running", "multiple tracks playing", "trumpets", "noisy", "chaotic", "boisterous unrelated", "deafening", "unpleasant"] | 7 | 7TmKzUgWiRU | 848 | |
Humor: That's how regular guitar sounds with Guitar Hero chords | This music is instrumental. The tempo is medium with a loud , distorted electric guitar harmony. The audio is inferior quality and the sound is raw, loud , unpleasant , boisterous and harsh. There is some noise, like a subdued song playing in the background. | 2009-01-21T04:02:38Z | scooperfield | Is it hard to play Guitar hero with normal guitar? | ["Bass guitar", "Reverberation", "Effects unit", "Electric guitar", "Heavy metal", "Music", "Clatter", "Distortion"] | ["instrumental", "fast tempo", "distorted sounds", "subdued song in background", "harsh", "raw", "inferior audio quality", "vigorous", "boisterous", "noisy", "unpleasant", "electronic music", "intense", "loud electric guitar feedback", "unpleasant", "sharp"] | 7 | c-8SLUH5pp4 | 3673 |
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;