musiccaps_details (view)

1 row where musiccaps_aspects contains "backup singers", musiccaps_aspects contains "story telling", musiccaps_aspects contains "vocal commentary" and musiccaps_author = 1

✎ 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
Street Workout Featuring Mysonne "All Around The World" A male singer sings this rap vocals with backup singers in harmony. The song is medium tempo with typing and beeping tones, followed by steady drumming rhythm, groovy bass and keyboard harmony. The song is energetic and exciting. The song has a home video intro followed by a rap song. 2009-11-16T19:20:34Z djvlad - http://VladTV.com - A gym membership is not necessary to be brolic. You are now training with Mysonne. Dir: Vernon Baines ["Music", "Single-lens reflex camera"] ["typing sounds", "male rapper", "backup singers", "singer self introduction", "groovy", "damage rap music", "beeping tones", "booming bass line", "amateur video quality", "home rap video", "vocal commentary", "medium tempo", "ambient noise", "street noises", "energetic", "passionate", "story telling", "amateur video quality", "gym talk", "poor quality audio"] 1 JI26wmUPcrM 1988

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;