musiccaps_details (view)
2 rows where musiccaps_aspects contains "playful" and musiccaps_aspects contains "video game theme" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- cheerful 2
- instrumental 2
- no singer 2
- playful · 2 ✖
- video game theme · 2 ✖
- analog sounding 1
- beatboxing 1
- festive 1
- glockenspiel 1
- groovy 1
- kids song 1
- sleigh bells 1
- small keyboard 1
- synth strings 1
- vibraphone 1
- wind effect 1
musiccaps_names (array) 4 ✖
- Music 2
- Soundtrack music 2
- Beatboxing 1
- Happy music 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Banjo-Kazooie Music: Click Clock Wood (Winter) | This is a video game theme that is in the style of a kids song. The main melody is being played by a vibraphone while a glockenspiel can be heard adding texture. There is a medium-to-high pitch synth string sound that joins them later on. In the background, there are sleigh bells and a wind effect to imply a winter aura. The atmosphere is playful. The piece could be included in the soundtrack of a kids cartoon or a video game. | 2007-10-26T22:24:07Z | southernpickle | The theme to the winter area of Click Clock Wood from the game Banjo-Kazooie. | ["Music", "Soundtrack music", "Happy music"] | ["video game theme", "kids song", "no singer", "instrumental", "vibraphone", "glockenspiel", "synth strings", "sleigh bells", "wind effect", "festive", "cheerful", "playful"] | 9 | 9QYo50tFm6w | 1004 | |
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;