musiccaps_details (view)
4 rows where musiccaps_aspects contains "trumpets", musiccaps_author = 0 and musiccaps_names contains "Ska"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- trumpets · 4 ✖
- happy mood 3
- moderate tempo 3
- instrumental 2
- no voices 2
- percussion 2
- ska song 2
- bass 1
- disco 1
- double bass 1
- fast guitar strums 1
- fast tempo 1
- female backing voices 1
- female lead voice 1
- flute 1
- foreign language 1
- funky bassline 1
- groovy bass 1
- keyboard 1
- low quality recording 1
- male voice 1
- organ 1
- romantic theme 1
- simple beat 1
- simple percussion 1
- simple song 1
- soul 1
- soul funk song 1
- spanish rock 1
- upbeat 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 | |
Best Selection (1) of Old School Ska & Original Reggae 1960's (Vinyl Recordings) Vol. 1 | This ska song features a flute playing the main melody. Other flutes play staccato notes in the background. This is backed by trumpets playing chords in the background. The percussion plays a simple beat in common time. The double bass plays a 12-bar blues style bassline. There are no voices in this song. This is an instrumental. This song can be played at a Broadway event. | 2012-04-08T17:15:32Z | Oscar | Best Selection of Old School Ska & Original Reggae 1960's (Vinyl Recordings) Vol. 1 This is the first of two volumes, a really old compilation that we think my dad bought on cassette in the early 80's from Gaz Mayalls dad at a market stall in Camden. Some nice old school ska and reggae, This lot of music came from Vinyl, was recorded onto cassette and then onto CD, to the computer. hence the sound quality is a bit crackly and truly original! See comments for track listing :) Enjoy! | ["Music", "Ska"] | ["ska song", "flute", "trumpets", "double bass", "percussion", "no voices", "instrumental", "moderate tempo"] | 0 | O40E8bpmONQ | 2396 | |
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 |
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;