musiccaps_details (view)

1 row where musiccaps_aspects contains "amateur production", musiccaps_aspects contains "children’s favourite" and musiccaps_aspects contains "spitting vocals"

✎ 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
Super Mario Beatbox The song is an acapella cover of a game theme song. The song is medium tempo with no instrumentation by different male vocals engaging in different vocal mimicry of actual instruments, like bass line, melody , percussion and harmony tones. The song is cheerful and amateurish in production. The song is a cover of a popular game theme. 2006-01-19T03:08:47Z poizunus Super Mario audio and sfx re-done by beatboxer Poizunus. For more music from Poizunus, visit the links below. Find http://beatsxpoizun.com/ http://beatsxpoizun.com/hip-hop-beats/ http://producedxpoizun.com/ http://producedxpoizun.com/streaming-hip-hop-and-rap-instrumentals/ Keep up to date with Poizunus on Twitter: https://twitter.com/poizunus ["Beatboxing", "Music"] ["beatbox music", "game tune cover", "male singers", "children’s favourite", "retro game theme", "amateur production", "cheerful", "fun venture", "vocal mimicry", "game theme song cover", "vocal harmony", "spitting vocals", "rolling tongues", "playful", "game song cover", "medium tempo", "no instrumentation", "vocal acapella", "cheerful", "amateur recording"] 1 9r01cpNx2vk 1046

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;