musiccaps_details (view)
1 row where musiccaps_aspects contains "boisterous" and "youtube_published" is on date 2014-12-17
This data as json, CSV (advanced)
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 |
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;