musiccaps_details (view)
3 rows where musiccaps_aspects contains "festive" and musiccaps_aspects contains "male vocal"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- festive · 3 ✖
- male vocal · 3 ✖
- amateur recording 1
- amusing 1
- banjo 1
- bavarian folk music 1
- brass elements 1
- celebration 1
- cheerful 1
- child voice 1
- christmas music 1
- electronic drums 1
- energetic 1
- enthusiastic 1
- folk music 1
- foreign language 1
- groovy bass 1
- hip-hop 1
- live performance 1
- lively singing 1
- medium tempo 1
- melodic singing 1
- oud rhythm 1
- poor quality 1
- rapping 1
- regional folk 1
- regional music 1
- sleigh bells 1
- sound of tapping 1
- spirited 1
- tambourine beats 1
- urban 1
- world music 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
bourdib a baraki.le 28 mai 2010 | A male vocalist sings this lively melody in a foreign language. The tempo is fast with a loud and banjo harmony, tambourine beats and tapping beats. The song is a spirited, cheerful,celebratory, happy, enthusiastic and festive Regional/Folk Song. | 2010-05-29T08:01:53Z | djamel1953 | bourdib soirée a baraki le 28 mai 2010 | ["Music of Africa", "Music", "Rattle (instrument)"] | ["male vocal", "medium tempo", "banjo", "oud rhythm", "tambourine beats", "sound of tapping", "foreign language", "lively singing", "enthusiastic", "spirited", "energetic", "world music", "regional music", "folk music", "regional folk", "celebration", "festive"] | 7 | A4jSRfZ6yd0 | 1065 | |
SWEET TEE - LET THE JINGLE BELLS ROCK | This is a Christmas music piece in the style of hip-hop. There is a child voice announcing the arrival of Santa. The male vocalist is rapping. There is a groovy bass line in the beat. The rhythmic background is provided by an electronic drum beat that has sleigh bells in it. The atmosphere is festive and amusing at the same time. This piece could be used in the soundtrack of a comedic Christmas movie. | 2014-12-24T20:28:41Z | NandoGames RetroTech | ["Music", "Rapping", "Jingle, tinkle", "Hip hop music"] | ["hip-hop", "christmas music", "child voice", "male vocal", "rapping", "groovy bass", "electronic drums", "sleigh bells", "festive", "amusing", "urban"] | 9 | J_Raltj-6dk | 2021 | ||
Joachim Mattis on Tour Original bavarian bavaria music from Munich !! Bavariaband Bavarianband | This is an amateur recording of a Bavarian folk music performance. The audio quality is not that great. There is a male vocalist singing in the lead. Then, brass elements start playing a cheerful tune. There is a festive atmosphere in this recording. It could be playing in the background at an Oktoberfest event. | 2007-12-28T09:12:08Z | Alpenjockel | https://www.facebook.com/profile.php?id=100010674222667 | ["Music", "Happy music"] | ["bavarian folk music", "live performance", "amateur recording", "poor quality", "male vocal", "melodic singing", "brass elements", "cheerful", "festive"] | 9 | pHFHsubQVpg | 4695 |
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;