musiccaps_details (view)
3 rows where musiccaps_aspects contains "percussion", musiccaps_aspects contains "ska song" 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Ska Ska Ska Part 1 - A Regular Ska Session at the Sombrero Club in Jamaica - various artists | This is a low quality audio featuring a male voice singing the main melody. Another voice sings in harmony with the main voice. /the melody is simple and repetitive. This is accompanied by percussion playing a simple beat. The bass plays the root notes of the chords. Trumpet play fills in between lines. This is a happy song. This song has a ska feel. This song can be played at a retro style dance party. | 2008-12-24T21:31:24Z | Kingstoned - soundzz | Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favour of fair use. This is ska,, there were little pieces of this film on you tube now its complete in 4 parts hope you like this one its a great documentary about a ska party in jamaica in that time at the sombrero club ..so if you want to learn how to dance the ska see this video ...on part 2 3 and 4 you can .see jimmy clif, the blues busters ,the maytals prince buster and some other artists doing there best to make a good video ,lots of energie introduced by byron lee ....enjoy!!! merry x-mas to every1 and a happy 2009 | ["Music", "Ska"] | ["low quality audio", "male voice", "vocal harmony", "trumpet", "jamaican feel", "ska song", "percussion", "bass", "dance song", "moderate tempo", "happy song"] | 0 | THfTLXBLpJE | 2825 |
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;