musiccaps_details (view)

3 rows where musiccaps_aspects contains "low quality" and musiccaps_names contains "Bang"

✎ 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
BANG FACE 52 • AROUND THE WORLD IN 80 RAVES • 08 FEB 2008 The low quality recording features a live performance where a DJ is playing his set. There are crowd noises in the background. The recording is noisy and it sounds manic, aggressive, distorted and upbeat. 2008-03-11T23:40:39Z BANGFACE BANG FACE 52 • AROUND THE WORLD IN 80 RAVES • 08 FEB 2008 - Surgeon, Andy C, Kicks Like A Mule, Shackleton, Captain Ahab, Duran Duran Duran, Xanopticon, Exillon, Chris Moss Acid, Ed Real, Pisstank, Alan Titmash, The Emo Hunter, Saint Acid & The Bang Face Hard Crew ["Electronic music", "Music", "Bang"] ["low quality", "aggressive", "manic", "crowd cheering", "live performance", "dj", "upbeat", "noisy", "distorted"] 4 39MksqVeLdY 445
david vendetta actor's marrakech 2007 The low quality recording features an electro song playing, while the crowd is screaming. It sounds loud, harsh, distorted and the recording is in mono and noisy. 2008-01-02T01:39:28Z MOUKHANAK magnifique soirée a l'Actor's avec David Vendetta ["Electronic music", "Music", "Bang"] ["low quality", "crowd screaming", "electro song", "loud", "harsh", "distorted", "noisy", "mono"] 4 UxrAsZ7Z09Y 2962
Thế giới V POP -[ Savior Show ] Hoàng Thùy Linh - Material Girl Phần 2.flv The low quality recording features a live performance and it contains glass breaking and shattering sounds, high pitched female vocal grunt, sustained synth bass, boomy toms and punchy kick, it also includes a crowd cheering sounds. The recording is in mono, really noisy, muffled and it sounds energetic. 2011-07-31T13:58:17Z Royce Ngo Here is the next MV of Hoang Thuy Linh...hope u enjoy ^^ ["Music", "Pop music", "Bang", "Burst, pop"] ["low quality", "live performance", "noisy", "mono", "crowd cheering", "glass breaking sound", "high pitched female grunt", "sustained synth bass", "boomy toms", "punchy kick", "muffled", "energetic"] 4 p7VmMa6cpSo 4687

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;