musiccaps_details (view)

2 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2007-11-12

✎ 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
beat box didgeridoo by neu The low quality recording features a male beatboxing through a didgeridoo. There is a sound of inhaling too. The recording is noisy, in mono and buzzy, as it was recorded with a poor quality microphone. 2007-11-12T11:34:28Z nmannas Neu is the front man of 'Head of the Herd' and the musical mind behind 'the neu music' & 'four-age productions.' Look 'em up! iTunes - http://tinyurl.com/3xdj5ln Neu ["Didgeridoo", "Music"] ["inhale", "beatboxing", "didgeridoo", "noisy", "buzzy", "low quality", "mono"] 4 VeXcCHo5iMI 3017
The Connells - Scotty's Lament The Rock song features a passionate male vocal, layered with harmonizing background male vocals, singing over electric rhythm guitar chords spread widely in the stereo image, thin snare, energetic crash, groovy bass, shimmering hi hats and punchy kick hits. The drums are very reverberant, which is probably the reason why they sound softer. It sounds addictive, thanks to those harmonizing vocals, and energetic overall. 2007-11-12T22:30:12Z streetsintherain The video for "Scotty's Lament", made in 1987. ["Music", "Roll", "Rock and roll"] ["rock", "passionate male vocal", "harmonizing background male vocal", "electric rhythm guitar chords", "groovy bass", "thin snare", "energetic crash", "shimmering hi hats", "punchy kick hits", "reverberant", "addictive", "energetic"] 4 hKSg3zFB2dE 4095

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;