musiccaps_details (view)
2 rows where "youtube_published" is on date 2007-10-29 sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- accordion 1
- accordion melody 1
- acoustic guitar 1
- animated music 1
- bass 1
- cheering 1
- children's song 1
- clapping 1
- croaking sound 1
- crowd cheering 1
- fast tempo 1
- happy mood 1
- inferior audio quality 1
- instrumental 1
- keyboard harmony 1
- live performance 1
- lively vocals 1
- male vocalist 1
- muffled audio 1
- no voice 1
- people talking 1
- percussion 1
- quirky sounds 1
- slow tempo 1
- steady bass lines 1
- vigorous drumming 1
- xylophone family instrument 1
musiccaps_names (array) 4 ✖
- Music 2
- Singing 1
- Tap 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Safe Sane and Single - Comedy Tap (retro) | A male vocalist sings this energetic song. The tempo is fast with accordion harmony, funky bass lines, vigorous drumming,rhythmic acoustic guitar and keyboard harmony. The audio is muffled making it difficult to hear the other elements in the song. This song is a live performance as there are sounds of clapping, cheering and people murmuring. This song is a vibrant,vivacious,bright, punchy, and energetic Pop. | 2007-10-29T08:51:30Z | FatLane | Another one from the archives. | ["Singing", "Music", "Tap"] | ["male vocalist", "fast tempo", "animated music", "clapping", "live performance", "people talking", "cheering", "accordion melody", "vigorous drumming", "keyboard harmony", "steady bass lines", "acoustic guitar", "lively vocals", "inferior audio quality", "muffled audio", "crowd cheering"] | 7 | ZgooDijn2as | 3403 | |
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 |
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;