musiccaps_details (view)
3 rows where musiccaps_aspects contains "double bass", musiccaps_aspects contains "no voices", musiccaps_author = 0 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ska Flames - Ska Fever (1989) FULL ALBUM | This ska song features the main melody played on the brass section. This includes saxophone, trumpet and trombones being played in harmony. The bass plays a groovy bassline. The percussion plays a jazz beat with focus on the ride cymbal. A guitar plays chords in the background using a tron or wah effect. This song can be played in a comedy movie. | 2014-03-30T13:00:02Z | SKAPUNK FOREVER | This YouTube user makes no profit from these videos. If there is advertising on the video it has been applied automatically by YouTube through their Content ID program and any funds earned are going to the copyright holder that registered with YouTube. --------------------------------------- Ska Flames is a Japanese ska band who play a traditional ska sound and were one of the first ska bands in Japan. They have never fully disbanded and are still active today, though they have only released four album since they formed in 1985. Ska Fever was their first LP. Please support them on social media and wherever you buy music: www.skaflames.jp https://www.facebook.com/TheSkaFlames/ TRACKLIST Track 1 (Tokyo Shot): 0:00 Track 2 (Osaka Ska): 00 Track 3 (Hot Sake): 7:01 Track 4 (Lindow Man): 11:48 Track 5 (Christine Keiler): 00 Track 6 (Ray Hyman): 15:13 Track 7 (Ska Fever): 22:42 Track 8 (Kurosawa): 26:36 Track 9 (Samurai): 30:37 Track 10 (East Moon River): 33:40 Track 11 (Cool Smoke): 37:15 Track 12 (Do The Mule): 41:06 | ["Music", "Ska"] | ["ska song", "no voices", "instrumental", "brass section", "double bass", "guitar", "guitar tron effect", "moderate tempo"] | 0 | 9Lst8RagMYs | 998 | |
Swing Music | This swing music is an instrumental piece. It starts off with the trumpets playing high pitched notes in harmony. The percussion starts to play with an intro roll. A wind instrument swell is played after the intro percussion roll. A wind instrument plays a repetitive lick after this followed by a piano playing chords at higher octaves in the spaces between the wind instrument licks. The bass plays the same lick on a lower octave. There are no voices in this song. This song can be played in a retro movie dance scene. | 2011-01-19T02:10:58Z | IceSkaterDuckie | First piece of music: "Jumpin' Jack" by Big Bad Voodoo Daddy Second piece of music: "Viper" by Dixieland | ["Swing music", "Music"] | ["swing music", "instrumental", "no voices", "piano", "trumpets", "double bass", "trombone", "percussion", "moderate tempo"] | 0 | LPA8RDzl-Ss | 2184 | |
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 |
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;