musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic drumming" and musiccaps_aspects contains "inferior audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- energetic drumming · 2 ✖
- inferior audio quality · 2 ✖
- instrumental 2
- ambient auditorium sounds 1
- asian music 1
- boisterous 1
- chaotic 1
- chinese music 1
- choppy 1
- confusing 1
- distorted sounds 1
- echo 1
- electrical reactance 1
- fast tempo 1
- female vocalist 1
- flute 1
- incoherent music 1
- live performance 1
- people talking 1
- repetitive phrase 1
- reverb 1
- sharp piano rhythm 1
- sound of laughter 1
- synth pop 1
- synthesiser arrangements 1
- synthesiser harmony 1
- tambourine beats 1
- upbeat music 1
- vocal riff 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Ly cay bong - bieu dien: nhom No.1 | This music is instrumental. The tempo is fast with a melodious harmony with synthesiser arrangements, drumming, tambourine beats and some unidentifiable instruments.The audio quality is inferior with an incoherent audio. The music style is Asian/ Chinese. | 2009-08-24T14:33:37Z | Phuong Hai | ["Music", "Tambourine"] | ["instrumental", "fast tempo", "asian music", "people talking", "energetic drumming", "tambourine beats", "flute", "chinese music", "live performance", "synthesiser harmony", "inferior audio quality", "upbeat music", "ambient auditorium sounds", "echo", "reverb", "incoherent music", "people talking"] | 7 | s2iIZ2WNuKY | 4919 |
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;