musiccaps_details (view)

2 rows where musiccaps_aspects contains "digital drum" and musiccaps_names contains "Sampler"

✎ 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
Nautica Men's Spring 2014 Black Sail Fashion Show This song contains a digital drum playing a dubstep groove with a morphing sub-bass sound that is being used as melody. This song may be playing loud with headphones while running. 2013-09-10T19:25:44Z Nautica Nautica Men's Spring 2014 Black Sail Fashion Show at Mercedes-Benz Fashion Week ["Scratching (performance technique)", "Sampler"] ["dubstep", "digital drum", "digital sub bass", "digital lead sound", "medium to uptempo"] 6 E_IG2ubeTME 1572
Tinnitus y sordera-Tinnitus and deafness This music is an electronic instrumental. The tempo is medium fast with synthesiser arrangements, digital drumming and an insistent, persistent ,and incessant electronic drone sound that over powers the background music. It is loud, sharp and unpleasant after a bit. 2016-06-07T16:46:22Z Remedios naturales Comenius Si te gustó este vídeo ¡SUSCRÍBETE! Dale manita arriba para mucho mas vídeos como este, comparte con tus amigos y déjame tus comentarios. ["Sampler", "Drum and bass", "Music", "Techno", "Trance music", "Dubstep", "Drum machine", "Electronica"] ["electronic music", "medium fast tempo", "loud", "sharp", "unpleasant droning sound", "synthesiser arrangement", "slick drumming", "digital drum", "electronic arrangements", "droning sound", "monotone", "bass drum", "snare", "psychedelic", "trance", "hypnotic", "club music", "dj"] 7 XZurp_Ex9No 3196

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;