musiccaps_details (view)
6 rows where musiccaps_aspects contains "happy mood" and musiccaps_names contains "Ska"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- happy mood · 6 ✖
- male voice 4
- moderate tempo 4
- bass 3
- percussion 3
- trumpets 3
- overdriven guitar 2
- blues song 1
- disco 1
- fast guitar strums 1
- fast tempo 1
- female backing voices 1
- female lead voice 1
- foreign language 1
- funky bassline 1
- groovy bass 1
- groovy bassline 1
- guitar 1
- instrumental 1
- keyboard 1
- low quality audio 1
- low quality recording 1
- no voices 1
- organ 1
- reggae percussion 1
- reggae song 1
- rock and roll 1
- rock song 1
- romantic theme 1
- simple beat 1
- simple percussion 1
- simple song 1
- ska song 1
- slow tempo 1
- soul 1
- soul funk song 1
- spanish rock 1
- upbeat 1
- vocables 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Sesame Street - ZZ Blues | This blues song features a male voice singing the main melody at a comfortable pitch. This is accompanied by percussion playing a simple rock beat in common time. An overdriven guitar plays a blues riff. After one bar, the guitar and bass pause while the percussion and voice continues. The bass plays the root notes of the chords. The mood of this song is happy. This song can be played in a bar scene in a movie. | 2008-04-25T05:25:53Z | mstatz | A group that looks much like ZZ Top sings about the letter Z in ZZ Blues! A bluesy kind of song and another great lesson for kids. Big Bird makes an appearance before the video begins here. | ["Music", "Ska"] | ["rock song", "blues song", "male voice", "low quality audio", "overdriven guitar", "percussion", "bass", "happy mood", "moderate tempo"] | 0 | aLnBwjLUZao | 3530 | |
The Upsessions - Hooligan '69 | This reggae song features a male voice singing vocals at a high pitch, almost screaming. This is accompanied by percussion playing a reggae beat. The bass plays a groovy lick and plays a chromatic run of five notes to reach the note to start the chorus. A guitar strums one chord on alternate counts. This song can be played in a Caribbean themed party. | 2009-09-06T00:24:44Z | Reggay | The Upsessions - Hooligan '69 | ["Ska"] | ["reggae song", "male voice", "vocables", "groovy bassline", "reggae percussion", "guitar", "slow tempo", "happy mood"] | 0 | by57LpTlGbs | 3669 | |
Inspector - Me Estoy Enamorando (Video Oficial) | This Spanish rock song features a male voice singing the main melody. This is accompanied by rock percussion playing a simple beat. The bass plays the root notes of the chords. A guitar strums chords with upstrokes. A trumpet, saxophone and trombone plays fills in between verses. An organ pays fills at every alternate count. The mood of this song is happy and upbeat. This song can be played in a comedy movie. | 2014-05-14T20:37:22Z | Inspector Oficial | EL PRIMER SENCILLO DEL DISCO "SKA A LA CARTA" Escucha a Inspector en todas las plataformas digitales: https://ONErpm.lnk.to/inspector Escucha la playlist Mucho Ska https://ONErpm.lnk.to/MuchoSka | ["Music", "Ska"] | ["spanish rock", "fast guitar strums", "organ", "trumpets", "simple percussion", "male voice", "fast tempo", "happy mood", "foreign language"] | 0 | oswsd_r-GI8 | 4660 | |
Boney M - Sunny | This soul funk song features a female voice singing the main melody using vocals. This is accompanied by female voices singing backing vocals. The percussion plays a simple beat in common time. The bass plays a funky bassline. The trumpet plays a repetitive fill in the background. Due to the low quality of audio, other instruments are not audible. This song is a classic disco song and can be played in a disco. | 2007-09-02T18:44:23Z | Tasarım | Boney M - Sunny look at my designs : http://goo.gl/CYn38 * UMPG Publishing | ["Singing", "Music", "Ska"] | ["soul funk song", "female backing voices", "female lead voice", "funky bassline", "low quality recording", "trumpets", "romantic theme", "happy mood", "moderate tempo", "disco", "soul"] | 0 | tV2m7HFJprU | 5042 | |
Мумий Тролль - Медведица (live from Piter, Алые Паруса 07) | This rock and roll song features a male voice singing the main melody. This is accompanied by percussion playing a simple beat in common time. An overdriven guitar plays chords with licks in between lines. The bass plays the root notes of the chords. The mood of this song is happy. This song can be played in a movie scene when the protagonist is walking into a hotel prior to a fight scene. | 2007-06-28T16:52:07Z | Мумий Тролль (Mumiy Troll) | Russias biggest rock band, Mumiy Troll began as one of the most socially dangerous bands in the world as noted by a local Communist party chief in the former Soviet Union; yet, was hailed as Best Band of the Millennium by leading Russian music critics after the fall of communism. Mumiy Troll are the most influential and successful independent artists in Russia today. Part of Mumiy Troll's success can be attributed to their multi-genre sound, a hybrid of rock and pop which songwriter Lagutenko calls "rockapops". The Los Angeles Times has described the band "a nuclear meltdown of The Bravery, Tom Petty and The Afghan Whigs." http://www.mumiytroll.com/en http://en.wikipedia.org/wiki/Mumiy_Troll http://www.myspace.com/mumiy http://www.ikra.tv | ["Singing", "Music", "Ska"] | ["rock and roll", "male voice", "overdriven guitar", "percussion", "bass", "moderate tempo", "happy mood"] | 0 | vEN9szBPBkw | 5166 |
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;