musiccaps_details (view)
1 row where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "no instrumentation" and musiccaps_aspects contains "playful"
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
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;