musiccaps_details (view)
2 rows where musiccaps_aspects contains "confusing" and musiccaps_aspects contains "energetic drumming"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- chaotic 2
- confusing · 2 ✖
- energetic drumming · 2 ✖
- boisterous 1
- choppy 1
- distorted sounds 1
- electrical reactance 1
- fast tempo 1
- female backup 1
- female vocalist 1
- groovy bass line 1
- hip-hop 1
- inferior audio quality 1
- inferior sound quality 1
- instrumental 1
- keyboard harmony 1
- male vocalist 1
- muffle audio 1
- rap 1
- repetitive phrase 1
- rhythmic patter 1
- scratching sound 1
- sharp piano rhythm 1
- sound of laughter 1
- synth pop 1
- synthesiser arrangements 1
- unpleasant sound 1
- vocal riff 1
musiccaps_names (array) 5 ✖
youtube_published (date) 2 ✖
- 2008-11-26 1
- 2014-12-17 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SKREW MSK AWR ARTIST WRITING | A male vocalist sings a lively hip hop. The tempo is fast with energetic drumming, groovy bass lines and keyboard accompaniment with female backup vocals. The song is incoherent and muffled with a loud scratching like sound dominating the audio. The audio is chaotic, confusing, incoherent and unpleasant to the ears. | 2008-11-26T23:03:40Z | Eddie Donaldson | GUERILLAONE.COM IS A TEN YEAR OLD GRAFFITI SITE THAT HAS BEEN AROUND FOR TEN YEARS, IF YOU DONT KNOW ASK SOMEBODY OR VISIT http://www.guerillaone.com/ OR http://blog.guerillaone.com/ | ["Scratching (performance technique)", "Music", "Scratch", "Writing"] | ["male vocalist", "fast tempo", "rap", "hip-hop", "keyboard harmony", "unpleasant sound", "female backup", "groovy bass line", "energetic drumming", "rhythmic patter", "muffle audio", "inferior sound quality", "scratching sound", "chaotic", "confusing"] | 7 | IlUcHzBzZvg | 1936 | |
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 |
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;