musiccaps_details (view)
4 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "percussion" and musiccaps_aspects contains "trumpets"
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 | |
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 | |
The Indian Naval Symphonic Band (The Pirates of the Caribbean ) | This symphonic song features an orchestra playing a variety of instruments. The main melody is played on trumpets and violins. This is accompanied by the brass section and horn section of the orchestra. Clarinets play in harmony with the violins and trumpets. A xylophone kind of instrument plays bell sounds with the same melody as the main instruments. Cellos play the bass part of the song. This is accompanied by a bass drum playing a steady count. A drum kit plays the percussion part with a marching beat. There are no voices in this song. This is an instrumental song. The feel of this song is uplifting. | 2012-03-22T08:20:23Z | Shree Darshan | The Pirates of the Caribbean -Theme song Composer-Klaus Badlet, Arranger- John Wasson Conducted by- MCPO MUS-1 B. Sudarsanan at Siri Fort Auditorium-New Delhi dated- Friday, February 10, 2012. | ["Orchestra"] | ["orchestra music", "symphonic song", "amateur recording", "percussion", "violins", "trumpets", "cello", "flute", "clarinets", "moderate tempo", "instrumental", "no voices", "uplifting music"] | 0 | ZleHXDirD58 | 3411 |
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;