musiccaps_details (view)
2 rows where youtube_channel = "southernpickle"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Banjo-Tooie Music: Glitter Gulch Mine | This children's song features an accordion playing chords. This is accompanied by percussion playing a simple beat. The bass plays the root notes of the chords. An instrument like the xylophone plays the main melody on the low frequencies. There are no voices in this song. This song is an instrumental. The mood of this song is happy. This song can be played in a children's animation series. | 2007-10-29T03:32:40Z | southernpickle | The theme to Glitter Gulch Mine from the game Banjo-Tooie. | ["Music", "Tender music"] | ["children's song", "quirky sounds", "percussion", "bass", "happy mood", "accordion", "croaking sound", "slow tempo", "instrumental", "no voice", "xylophone family instrument"] | 0 | 2UnlMwW8nyI | 372 | |
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 |
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;