musiccaps_details (view)
3 rows where musiccaps_aspects contains "happy mood", musiccaps_aspects contains "moderate tempo" 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 | |
Jingle Bells - Auckland Symphony Orchestra | This song features the main melody sung by a choir. This is accompanied by the string section and brass section featuring violins and trumpets. Hand claps are heard on every count. Orchestral percussion plays in the background. As the quality of audio is low, many instruments cannot be heard. This song can be played in a celebration. | 2008-12-09T09:20:44Z | Calum Anderson | The Auckland Symphony Orchestra along with a combined choir perform Jingle Bells at their annual Christmas concert in the Auckland Town Hall in 2008. | ["Orchestra"] | ["celebration song", "holiday song", "string section", "low quality audio", "hand claps", "choir", "trumpets", "percussion", "moderate tempo", "happy mood"] | 0 | bQ9vpp_yXvk | 3624 | |
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;