musiccaps_details (view)

2 rows where musiccaps_aspects contains "upbeat drum kit" and musiccaps_author = 5

✎ 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
Ticking of the Clock The rock music features a nasal male voice. The voice follows a strummed electric guitar with a clean sound. The bass is backing the guitar strumms. The beat is made first with ticking sounds but then it's played by a drum kit. 2011-12-07T15:49:23Z Amygdalaindiemusic Song about time pressures ["Music", "Independent music", "Song", "Tick-tock"] ["rock&roll", "nasal male vocals", "clean electric guitar strumms", "upbeat drum kit", "bouncy melody", "danceable", "happy", "positive"] 5 fsTVRca31nI 3983
Whip Ass Gaming: Twisted Metal Gameplay Demo The song is a rock track that features distorted and energetic guitar strumming chords. A secondary guitar does a solo melody in the foreground. A drum kit plays a typical upbeat rock pattern with an energetic mood. A bass adds deepness to the track while playing the same progression as the strummed guitar. 2008-05-09T21:11:29Z Belpowerslave The video gameplay demo showing off various levels and cars. Please note that this is *video* of gameplay footage, and most of the issues you'll see with the graphics are the fault of the low quality encode on the disc. ["Music", "Grunge"] ["rock&roll", "no vocals", "distorted electric guitar", "energetic", "electric guitar solo", "upbeat drum kit", "danceable", "happy", "positive", "powerfull"] 5 fxdWwzdeY_o 3994

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;