musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "happy" and musiccaps_aspects contains "male singer" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 95 ✖
- happy · 5 ✖
- male singer · 5 ✖
- fast tempo 4
- buoyant 3
- groovy 3
- vocal backup 3
- acoustic guitar 2
- animated 2
- emphatic vocals 2
- energetic 2
- keyboard accompaniment 2
- peppy 2
- r&b 2
- vivacious 2
- world music 2
- youthful 2
- african music 1
- african percussion 1
- animated percussions 1
- boomy drumming 1
- brass band 1
- bright trumpets 1
- bright violin 1
- carrie an music 1
- catchy 1
- celebration 1
- charming 1
- cheerful 1
- cheering 1
- children’s song 1
- clapping 1
- clapping cheering 1
- classic rock 1
- club music 1
- concert 1
- dance grove 1
- dance music 1
- electric guitar 1
- electronic rhythm 1
- energetic music 1
- enthusiastic drumming 1
- folk music 1
- folk pop 1
- folk song 1
- foreign language 1
- fun 1
- funk 1
- funky 1
- groovy bass line 1
- groovy bass lines 1
- happy song 1
- indie pop 1
- infectious drumming 1
- jive music 1
- live performance 1
- lively animated 1
- lively cello 1
- lively mandolin 1
- medium tempo 1
- merry 1
- muddled audio 1
- muffled sounds 1
- party song 1
- percussion grooves 1
- pleasant 1
- pop 1
- pop hits 1
- pop rock 1
- punchy 1
- reggae 1
- reggae tones 1
- regional pop 1
- retro 1
- rhythmic acousitc guitar 1
- rhythmic acoustic guitar 1
- rock and rock 1
- rock pop 1
- shakers 1
- simple 1
- spirited 1
- spirted 1
- stage performance 1
- steady bass line 1
- steady drumming 1
- strong drum beats 1
- synth arrangements 1
- synth pop 1
- synthesiser 1
- the lord’s prayer 1
- thumping music 1
- trumpets 1
- ukele 1
- ukele melody 1
- upbeat 1
- vibrant 1
musiccaps_names (array) 8 ✖
- Music 4
- /t/dd00032 1
- Brass instrument 1
- Jingle (music) 1
- Reggae 1
- Ska 1
- Tap 1
- Trombone 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Israel Vibration African Unification | A male vocalist sings the Lord’s Prayer. The tempo is medium with Keyboard harmony, steady drumming, groovy basslines, rhythmic guitar,beat of shakers, vocal backup and a trumpet flourish. The music is simple, rhythmic, pleasant, catchy, soulful and punchy Reggae. There are sounds of people clapping and cheering in the background indicating that this is a live performance. | 2007-02-25T01:52:21Z | David Ruiz | Israel Vibration African Unification | ["Music", "Reggae", "Ska"] | ["male singer", "medium tempo", "reggae", "live performance", "stage performance", "concert", "rhythmic acousitc guitar", "clapping cheering", "vocal backup", "shakers", "pleasant", "punchy", "groovy", "happy", "simple", "pleasant", "reggae tones", "groovy bass lines", "trumpets", "brass band", "shakers", "steady drumming", "keyboard accompaniment", "the lord’s prayer", "carrie an music", "african music", "r&b", "world music", "catchy"] | 7 | blsYgo-B1k8 | 3650 | |
Ratrace Music Video | A male vocalist sings this simple, peppy melody. The tempo is fast with keyboard harmony, enthusiastic drumming, steady bass line, acoustic guitar rhythm and electronic arrangements. The song is fun, animated, upbeat, catchy, energetic, spirited and vibrant and appealing to children . This song is a Synth Pop/Rock. | 2008-10-01T02:40:34Z | PlasticManFilms | Aniamting to the song Ratrace. clips of many of our videos along with the stort story of a hobo who has a spending problem.PLEASE COMMENT | ["Music", "/t/dd00032"] | ["male singer", "fast tempo", "energetic music", "peppy", "buoyant", "electronic rhythm", "enthusiastic drumming", "rhythmic acoustic guitar", "steady bass line", "fun", "youthful", "animated", "spirted", "vivacious", "happy", "children’s song", "synth arrangements", "synth pop", "pop rock"] | 7 | EaGhKzpkNso | 1574 | |
Θα κάνω φασαρία-Γιαννούλης Βαζαίος | A male vocalist sings this animated song in a foreign language. The tempo is fast with a bright applied violin accompaniment, lively drumming, groovy bass line, tambourine beats, rhythmic mandolin and acoustic guitar accompany net. The song is lively, energetic, vibrant, happy, vivacious and merry with a dance groove. This song is a Folk Pop/Regional Pop. | 2010-06-29T13:03:59Z | mike gr | από το cd ''να μαστε πάλι[πιτσιρίκα]'' | ["Jingle (music)", "Music"] | ["male singer", "fast tempo", "regional pop", "folk pop", "emphatic vocals", "foreign language", "bright violin", "energetic", "animated percussions", "lively mandolin", "acoustic guitar", "groovy bass line", "folk song", "folk music", "world music", "pop", "pop hits", "youthful", "dance music", "celebration", "merry", "happy"] | 7 | 40D4L5Ndi6k | 529 | |
She's So Fine - Jackie Wilson | A male vocalist sings this lively Rock song. The tempo is fast with bright trumpet harmony, groovy bass, infectious drumming , electric guitar and vocal backup. The music is upbeat, groovy, funky, high-spirited, vibrant and enthusiastic. This song is Retro Rock and Roll. | 2012-09-22T18:49:33Z | Mike Swindle | Hard to find music. | ["Brass instrument", "Trombone"] | ["male singer", "fast tempo", "lively cello", "bright trumpets", "vibrant", "classic rock", "animated", "buoyant", "groovy", "funky", "vibrant", "vivacious", "happy", "charming", "vocal backup", "spirited", "retro", "jive music", "upbeat", "spirited", "infectious drumming", "electric guitar", "lively animated", "rock and rock", "rock pop", "funk", "r&b"] | 7 | r4nPBNL3D0E | 4849 | |
Groom performs surprise Flash Mob Dance for his Bride | A male vocalist sings this upbeat pop song. The tempo is medium fast with thumping drum beats, percussion instruments, ukulele melody, keyboard accompaniment and rhythmic guitar. The audio is muddled making it difficult to hear the finer elements of the song. The song is energetic, enthusiastic, happy, fresh, peppy, perky , groovy. There is background chatter, clapping, cheering and rustling. The song is a Pop Rock/Alternative Indie. | 2014-09-02T16:09:17Z | Blue Kite Cinema | http://facebook.com/BlueKiteCinema Michael put together a flash mob dance with 80 friends and family members and surprised his new wife, Jessica, with it on their wedding day! This is a little teaser video including that dance and a few snippets from their day. | ["Music", "Tap"] | ["male singer", "fast tempo", "happy song", "groovy", "ukele melody", "acoustic guitar", "keyboard accompaniment", "emphatic vocals", "vocal backup", "energetic", "peppy", "buoyant", "dance grove", "party song", "club music", "muffled sounds", "boomy drumming", "strong drum beats", "clapping", "cheering", "happy", "peppy", "cheerful", "muddled audio", "synthesiser", "percussion grooves", "african percussion", "thumping music", "indie pop", "ukele"] | 7 | 3fqWosszpnE | 492 |
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;