musiccaps_details (view)
1 row where musiccaps_aspects contains "cheerful", musiccaps_aspects contains "small keyboard" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Wii Music - Super Mario Bros feat. Beatboxing Jesus | This is a video game theme cover. The theme belongs to the Super Mario franchise. The main theme is being played on an analog sounding small keyboard. There is an added rhythmic background of beatboxing in this version. The atmosphere is playful. This piece could be used in the background of arcade gaming social media content. | 2009-05-06T19:15:34Z | Blozcot | The four presidential and vice presidential candidates perform the Super Mario Bros theme on their NES Horns, while a special guest brings down the beat! Credits: Me, Jesus | ["Beatboxing", "Music", "Soundtrack music"] | ["video game theme", "no singer", "instrumental", "analog sounding", "small keyboard", "beatboxing", "playful", "cheerful", "groovy"] | 9 | GiTmjE7az74 | 1748 |
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;