musiccaps_details (view)
4 rows where musiccaps_aspects contains "celebration song" and musiccaps_author = 0
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- celebration song · 4 ✖
- happy mood 3
- moderate tempo 3
- hand claps 2
- percussion 2
- bass 1
- chalk writing on blackboard 1
- choir 1
- clarinet song 1
- disco song 1
- fast tempo 1
- folk song 1
- foreign language 1
- funk bass 1
- guitar strums 1
- hand percussion 1
- holiday song 1
- instrumental 1
- keyboard 1
- low quality audio 1
- male voice 1
- male voices 1
- no voice 1
- no voices 1
- reggae 1
- sound of trumpets 1
- string section 1
- synth string backing 1
- tambourine 1
- trumpets 1
- upbeat 1
- vocal harmony 1
youtube_published (date) 4 ✖
- 2008-12-09 1
- 2010-09-14 1
- 2011-07-02 1
- 2014-08-21 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SHOLOHO Vadim Gavrilov-Vugar Sultanov | This folk song features the main melody played on the clarinet. This is accompanied by percussion played by hand. The tambourine is playing on every count. The bass plays with a groovy feel. The bass plays notes continuously at every count. The mood of this song is upbeat and happy. There are no voices in this song. This song can be played at a celebration party. | 2011-07-02T00:14:04Z | Vadim Gavrilov | Snew Group- ORIGINAL. Tancuut vse!!! SHOLOHO-PAPAH-SULEIMANI+MIZRAHI | ["Music", "Maraca"] | ["folk song", "clarinet song", "tambourine", "no voices", "hand percussion", "sound of trumpets", "fast tempo", "instrumental", "no voice", "celebration song"] | 0 | PZZxVIIOQPo | 2545 | |
Reggae Birthday Song | This reggae song features male voices singing the main melody in harmony. The clip starts off with the sound of a chalk writing on a board. This is followed by a percussion roll. The voices start singing the main melody. This is accompanied by percussion playing a reggae beat. The bass plays a reggae style bassline. The keyboard plays staccato chords in a reggae rhythm. The mood of this song is happy. This song can be played in a birthday scene in a movie when a family is on a holiday on an island. | 2010-09-14T20:42:56Z | bluemountainecards | Listen as these animated island characters sing happy birthday the raggae way. Hey mon "Happy Birthday!" View more like this: http://www.bluemountain.com/ecards/birthday.pd?c=bmasc62324 | ["Music", "Reggae"] | ["chalk writing on blackboard", "bass", "male voices", "percussion", "reggae", "happy mood", "celebration song", "keyboard", "moderate tempo"] | 0 | _Ra1Y6K7nSs | 3469 | |
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 | |
4545 - Duarte Nogueira | This disco song features male voices singing the main melody in harmony. This is accompanied by programmed percussion playing a simple beat. The bass plays funk style bass notes. A synth plays a string voice in the background with short bursts of chords. After the first line, a guitar strum is played. This song is uptempo and has a happy mood. This song can be played in a celebratory event. | 2014-08-21T16:25:06Z | Duarte Nogueira | Jingle da campanha do deputado federal Duarte Nogueira! | ["Jingle (music)", "Music", "Pop music"] | ["disco song", "male voice", "vocal harmony", "foreign language", "funk bass", "guitar strums", "hand claps", "happy mood", "synth string backing", "upbeat", "moderate tempo", "celebration song"] | 0 | yPzhMx3NPW4 | 5407 |
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;