musiccaps_details (view)

2 rows where musiccaps_aspects contains "droning", musiccaps_aspects contains "fast tempo" and musiccaps_aspects contains "instrumental"

✎ 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
Sasha - Boileroom This music is an intense instrumental; the tempo is fast with atmospheric synthesiser,non-tertian harmonies , distal reverb and electronic sounds. The music is tense, sinister, suspenseful, futuristic, psychedelic and alien. This music is Futurepop. 2009-05-27T05:06:01Z trancehiyo Title: Boileroom Artist: Sasha Album: Airdrawndagger Year: 2002 ["Whale vocalization", "Music"] ["instrumental", "fast tempo", "water bubbling", "future pop", "chord clusters", "sound design", "digital reverb", "electronic tropes", "non-tertiary harmonies", "boiling", "suspenseful", "sinister", "tense", "psychedelic", "synthesiser arrangements", "alien sounds", "static", "droning", "psychedelic", "futuristic", "space ship", "am"] 7 5a_Qxd4ECTo 672
Fred Morrison This music is instrumental. The tempo is fast with a spirited small pipe harmony with rhythmic foot tapping. The music is upbeat, engaging, sharp, humming, haunting, droning and cheerful. This a live performance with ambient sounds of people talking and static as this is an amateur recording. 2010-02-12T22:46:03Z Doug Henkle Recorded on February 6, 2010 using a Flip Video camcorder. ["Bagpipes", "Wind instrument, woodwind instrument"] ["instrumental", "fast tempo", "small pipe harmony", "droning", "haunting", "emotional", "passionate", "loud", "humming melody", "amateur recording", "rhythmic foot tapping", "live performance", "live audience", "static", "ambient sounds", "people talking", "bellows-blown bagpipe", "bagpiper", "woodwind", "chamber instrument"] 7 IbD0zpcimgM 1921

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;