musiccaps_details (view)
3 rows where musiccaps_aspects contains "cheering", musiccaps_aspects contains "happy" and musiccaps_aspects contains "people talking"
This data as json, CSV (advanced)
musiccaps_aspects (array) 62 ✖
- cheering · 3 ✖
- happy · 3 ✖
- people talking · 3 ✖
- amateur recording 2
- cheerful 2
- chirpy 2
- enthusiastic 2
- fast tempo 2
- inferior audio quality 2
- keyboard harmony 2
- acoustic guitar 1
- ambient nature sounds 1
- ambient noises 1
- auto harp 1
- background sounds 1
- bluegrass 1
- catchy 1
- celebratory 1
- clapping 1
- concert 1
- country folk music 1
- country music 1
- energetic 1
- energetic drumming 1
- festive 1
- folk song 1
- foreign language 1
- gig 1
- home video 1
- hooting 1
- instrumental 1
- live performance 1
- lively 1
- lively beat 1
- lively trumpets 1
- male singer 1
- male vocalists 1
- mandolin 1
- medium tempo 1
- merry 1
- muffled audio 1
- party songs 1
- peppy 1
- pop song 1
- popular 1
- popular songs 1
- regional music 1
- rhythmic acoustic guitar 1
- rhythmic beat 1
- rustling 1
- simple 1
- sound of laughter 1
- spirited 1
- steady drumming 1
- straight bass lines 1
- tapping 1
- vigorous banjo 1
- vivacious 1
- vocal backup 1
- xylophone harmony 1
- youthful 1
- ’ enjoyable 1
musiccaps_names (array) 9 ✖
- Music 3
- Banjo 1
- Bluegrass 1
- Country 1
- Music of Latin America 1
- Rock and roll 1
- Singing 1
- Ska 1
- Steelpan 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Muddy Hill Boys - Bluegrass To Rockin'The Country Jamboree | A group of male vocalists sing this happy, upbeat country /bluegrass song. The tempo is fast with vigorous and animated acoustic guitar, banjo, mandolin and auto harp lead and harmony. The song is a live performance with ambient sounds of clapping, cheering and people talking. This song is a cheerful Country Pop/Bluegrass song. | 2015-04-05T21:37:46Z | chrisdixie1 | https://www.facebook.com/themuddyhillboys?fref=ts Rockin' The Country Jamboree N°1 - à TOURS 37 FRANCE organisé par DiscOldies le 28/03/2015 | ["Banjo", "Country", "Music", "Rock and roll", "Bluegrass"] | ["male vocalists", "fast tempo", "cheerful", "happy", "acoustic guitar", "vigorous banjo", "auto harp", "mandolin", "ambient noises", "clapping", "cheering", "people talking", "live performance", "gig", "concert", "cheering", "country music", "country folk music", "bluegrass", "inferior audio quality", "amateur recording", "lively", "spirited", "enthusiastic", "vivacious", "youthful", "happy", "celebratory", "festive"] | 7 | 0XxinBtKouQ | 179 | |
Shira Choir Rocking it away with Pinky Weber Music by Pinny Ostreicher | A male vocalist sings this spirited song. The tempo is fast with trumpets, keyboard harmony, steady drumming and simple bass lines along with vocal backup. The song is happy, energetic, enthusiastic, popular, peppy, vivacious and celebratory. There are sounds in the background of people talking, hooting, cheering and scuttling and rustling. This is a popular Folk/Regional song. | 2015-09-04T19:04:46Z | Go Jewish Music | At a Siyem in Upstate! | ["Singing", "Music", "Ska", "Music of Latin America"] | ["male singer", "fast tempo", "vocal backup", "popular songs", "hooting", "rustling", "home video", "amateur recording", "party songs", "foreign language", "lively trumpets", "keyboard harmony", "steady drumming", "straight bass lines", "vocal backup", "people talking", "cheering", "energetic", "happy", "enthusiastic", "home video", "inferior audio quality", "folk song", "regional music", "happy", "peppy", "chirpy"] | 7 | 1hABzqBHh7w | 297 | |
Stand By Me (steel pan) | This music is a cheerful instrumental. The tempo is medium with the lead harmony on a Xylophone, energetic drumming, keyboard accompaniment and rhythmic acoustic guitar. The audio quality is inferior and the music is muffled and muddy. There are background sounds like people talking, laughing and ambient nature sounds like a breeze. The music is fun, youthful, simple, enjoyable, chirpy and vivacious. | 2008-02-13T06:13:56Z | svart3n | Steel Pan band at the 30th anniversary Flatbush Frolic in Brooklyn, NY, 2007. See the video in better quality @ http://youtu.be/LlCS3ZVutuk | ["Music", "Steelpan"] | ["instrumental", "medium tempo", "rhythmic acoustic guitar", "background sounds", "ambient nature sounds", "people talking", "sound of laughter", "cheering", "tapping", "merry", "happy", "chirpy", "cheerful", "’ enjoyable", "xylophone harmony", "energetic drumming", "muffled audio", "keyboard harmony", "lively beat", "catchy", "rhythmic beat", "pop song", "popular", "simple"] | 7 | tV3rvUSlVnY | 5043 |
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;