musiccaps_details (view)
6 rows where musiccaps_aspects contains "happy mood", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- happy mood · 6 ✖
- instrumental · 6 ✖
- percussion · 6 ✖
- no voices 5
- moderate tempo 4
- bass 3
- groovy bass 2
- guitar solo 2
- accordion 1
- acoustic guitar 1
- bass guitar 1
- children's song 1
- croaking sound 1
- distortion guitars 1
- easy listening 1
- flugelhorn 1
- heavy metal 1
- jazz 1
- jazz guitar 1
- jazz melody 1
- jazz song 1
- keyboard 1
- low quality sound 1
- no voice 1
- piano music 1
- quirky sounds 1
- saxophone 1
- simple beat 1
- simple song 1
- ska song 1
- slow tempo 1
- trumpets 1
- upbeat 1
- wind instrument 1
- xylophone family instrument 1
musiccaps_names (array) 9 ✖
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 | |
LADRON-MASKATESTA | This ska song features a trumpet playing the main melody. The trumpet plays one staccato note followed by a six note pattern and then plays the same sequence starting on a different root note. This is accompanied by percussion playing a simple beat. A keyboard plays chords in the background. The bass plays a groovy bassline. There are no voices in this song. This is an instrumental song. The mood of this song is happy. This song can be played in a comedy movie. | 2009-03-06T22:39:59Z | Hector Israel Reyes Leal | VERSION ORIGINAL | ["Music", "Ska"] | ["ska song", "keyboard", "trumpets", "bass", "percussion", "no voices", "instrumental", "moderate tempo", "upbeat", "happy mood", "groovy bass", "simple beat", "simple song"] | 0 | AH6Xnyj6Ykc | 1097 | |
Iron Maiden - The Clairvoyant | This clip features low quality audio. The song is a heavy metal song where a guitar solo is played on the higher register of the scale. This is accompanied by percussion playing an uptempo beat. The bass plays a heavy riff using open notes and its octave. The distortion guitar plays power chords. There are no voices in this song. This is an instrumental song. This song can be played in a racecar sequence in a movie. | 2006-04-22T14:12:37Z | lammeaap | The Clairvoyant played live at Birmingham during the Seventh Tour of a Seventh Tour. | ["Music", "Rock music", "Inside, large room or hall", "Inside, public space"] | ["low quality sound", "heavy metal", "guitar solo", "no voices", "bass", "percussion", "distortion guitars", "happy mood", "instrumental", "moderate tempo"] | 0 | CdWA-SNcYpM | 1386 | |
Chuck Mangione Feels So Good. | This jazz song features the main melody played on a flugelhorn and a saxophone. Both instruments play in harmony with variations in melody. These instruments compliment each other. This is accompanied by percussion playing a jazz beat with constant strokes on the ride cymbal. The bass guitar plays a groovy bassline starting with a descending lick. This is then followed with an ascending lick to reach the higher notes before descending back. The guitar plays chords with string muting in a jazz rhythm. The mood of this song is upbeat. This song can be played in an advertisement for a luxury car. | 2010-09-28T22:54:21Z | krushade100123 | I DO NOT CONSENT OF OWNING THIS MATERIAL THIS ONLY FOR ENTERTAINMENT PURPOSES Chuck mangione performs Feel so Good | ["Jazz", "Music", "Musical instrument"] | ["jazz", "flugelhorn", "saxophone", "percussion", "groovy bass", "jazz guitar", "moderate tempo", "happy mood", "no voices", "instrumental"] | 0 | V1A4wBgvPgI | 2968 | |
A Cat's Guide to Bathrooms | This song features a wind instrument sounding like a saxophone. This is accompanied by percussion playing a simple beat. The melody of this song is jazzy. A piano plays chords. An electric piano or keyboard plays a descending lick before the instruments pause momentarily. The mood of the song is happy. There are no voices in this song. | 2014-05-05T12:05:01Z | Cole and Marmalade | Why do cats love bathrooms so much...? Here's Marmalade's guide to bathrooms and as you can see he's just a furry fitness freak! :) Fur merch, mews and more, check out our website! - https://coleandmarmalade.com Subscribe: http://bit.ly/SubToColeAndMarmalade Follow us on our social sites so you don’t miss any cute pics, vids and updates!! Facebook: https://www.facebook.com/ColeandMarmalade Instagram: https://www.instagram.com/coleandmarmalade TikTok: http://bit.ly/ColeMarmTikTok #ColeAndMarmalade | ["Jazz", "Music"] | ["piano music", "percussion", "wind instrument", "jazz melody", "happy mood", "no voices", "instrumental"] | 0 | aUH12rRIVDw | 3543 | |
10 Footballers Who Didn't Fulfil Their Potential | This jazz song features a guitar solo. This is accompanied by percussion playing a simple beat. An acoustic guitar strums chords on each count of the bar. The bass plays the root notes of the chords. There are no voices in this song. The song has a happy mood. This song can be played in a coffee shop. | 2014-10-14T16:41:19Z | talkSPORT | Every Tuesday we bring you a sporting top 10. Disagree with our list? Get stuck in with a comment! Check out http://talksport.com for more sport entertainment SUBSCRIBE to get more funny videos delivered right to your subscription feed: http://bit.ly/Hu3sIN FOLLOW us on Twitter and tell us what else you want to watch on talkSPORT's YouTube channel: http://bit.ly/IiA1t2 LIKE us on Facebook to join the world's best sporting debates: http://on.fb.me/HAm7Gn | ["Music", "Ukulele"] | ["jazz song", "acoustic guitar", "guitar solo", "bass guitar", "instrumental", "no voices", "percussion", "moderate tempo", "easy listening", "happy mood"] | 0 | iBH5X5SKirU | 4164 |
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;