musiccaps_details (view)

1 row where musiccaps_aspects contains "energetic drumming", musiccaps_aspects contains "instrumental", musiccaps_aspects contains "repetitive phrase" and musiccaps_names contains "Clatter"

✎ View and edit SQL

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

CSV options: 

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;