musiccaps_details (view)
3 rows where musiccaps_aspects contains "boisterous", musiccaps_aspects contains "distorted sounds" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- boisterous · 3 ✖
- distorted sounds · 3 ✖
- instrumental 3
- chaotic 2
- fast tempo 2
- inferior audio quality 2
- noisy 2
- unpleasant 2
- vigorous 2
- beep 1
- boisterous unrelated 1
- chain saw 1
- choppy 1
- confusing 1
- deafening 1
- dissonant 1
- dissonant unrelated 1
- electrical reactance 1
- electronic music 1
- energetic drumming 1
- engine 1
- female vocalist 1
- harsh 1
- intense 1
- loud electric guitar feedback 1
- multiple tracks playing 1
- music 1
- raw 1
- repetitive phrase 1
- running 1
- sharp 1
- sharp piano rhythm 1
- sound of laughter 1
- subdued song in background 1
- superimposed tracks 1
- synth pop 1
- synthesiser arrangements 1
- telephone busy signal 1
- trumpets 1
- vocal riff 1
musiccaps_names (array) 10 ✖
- Music 3
- Clatter 2
- Bass guitar 1
- Chainsaw 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 | |
07 GD 776 peugeot 308'nin ilk kükremesi ERROR CAR SOUND | This music is electronic pop. The tempo is fast with synthesiser arrangements, enthusiastic drumming, a sharp , shrill piano accompaniment and vocal riffs. There is the sound of laughter in the background and distorted sounds caused due to electrical reactance, making the song, noisy, chaotic, confusing, busy and painful to listen to. The song in the background is a Synth pop but it is incoherent because of the inferior audio quality . | 2014-12-17T22:10:28Z | error car sound | 07 GD 776 peugeot 308'nin ilk kükremesi ERROR CAR SOUND 09 mart 2014 saat 50.30 uyumak yok kulaklarımızın pası açıldı artık gerisini siz düşünün. bir hakan yorgancı imzasıdır ATASI NEYSE O....! oyuncular: hakan yorgancı, ibrahim inceoğlu, ali bakay kamera: erol özdemir ses: 07 GD 776 | ["Music", "Clatter"] | ["instrumental", "distorted sounds", "electrical reactance", "synth pop", "sound of laughter", "female vocalist", "vocal riff", "repetitive phrase", "synthesiser arrangements", "inferior audio quality", "sharp piano rhythm", "energetic drumming", "chaotic", "confusing", "boisterous", "choppy"] | 7 | RIiN9Ed1fqU | 2690 | |
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;