musiccaps_details (view)
4 rows where musiccaps_aspects contains "cheerful", musiccaps_aspects contains "instrumental", musiccaps_aspects contains "no singer" 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 |
---|---|---|---|---|---|---|---|---|---|---|
Grand Californian Hotel & Spa Disneyland | This is a jingle piece. There is no singer in this piece. There is an organ and a keyboard playing the main melody while bells and other percussive elements provide the rhythmic background. The atmosphere is cheerful. This piece could be used as an advertisement jingle. It could also be used at a festive event setting such as Christmas or Thanksgiving. | 2008-02-23T22:17:44Z | ggg11333 | A look around the Hotel during our stay. 02-21-08 | ["Bell", "Music", "Inside, small room"] | ["jingle", "no singer", "instrumental", "keyboard", "organ", "bells", "percussive elements", "cheerful", "playful", "cozy"] | 9 | 1l7BjFDQLUM | 307 | |
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 | |
Mum and the Trumpet Girls (Bugler's Holiday) | This is an instrumental wind band music piece. There are three trumpets playing the main melody while a wind instrument sound is playing a supporting tune. There is a bass guitar playing in the background. The rhythm consists of a simple electronic drum beat. The atmosphere is playful and cheerful. This piece could be used in the soundtrack of a kids TV show. | 2010-10-26T09:13:56Z | krystalstawarz95 | ["Brass instrument", "Trumpet"] | ["no singer", "instrumental", "wind band", "trumpets", "bass guitar", "electronic drums", "playful", "upbeat", "cheerful"] | 9 | Z0O2r0Dl2T4 | 3334 |
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;