musiccaps_details (view)
7 rows where musiccaps_aspects contains "emphatic vocals", musiccaps_aspects contains "fast tempo" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 112 ✖
- emphatic vocals · 7 ✖
- fast tempo · 7 ✖
- youthful 5
- clapping 3
- energetic 3
- female singer 3
- happy 3
- acoustic guitar 2
- cheerful 2
- club music 2
- dance music 2
- enthusiastic 2
- foreign language 2
- groovy bass line 2
- keyboard accompaniment 2
- keyboard harmony 2
- male singer 2
- male vocalist 2
- party song 2
- singing along 2
- spirited drumming 2
- vocal backup 2
- acoustic guitar accompaniment 1
- african percussion 1
- alternative rock 1
- alto sax 1
- amateur home recording 1
- amplified guitar harmony 1
- amplified instruments 1
- animated 1
- animated percussions 1
- auto harp 1
- banjo 1
- bass guitar 1
- boomy drumming 1
- bright violin 1
- buoyant 1
- busy music 1
- catchy melody 1
- celebration 1
- cheering 1
- compelling 1
- concert 1
- country hits 1
- country music 1
- country pop 1
- crowd cheering 1
- dance grove 1
- dance hits 1
- dobro 1
- dog barking sound 1
- electrifying 1
- electro pop 1
- electronic instrumentation 1
- emotional 1
- entertaining 1
- fans 1
- fiddle 1
- folk music 1
- folk pop 1
- folk song 1
- gig 1
- groovy 1
- happy song 1
- hard rock 1
- heavy metal 1
- indie pop 1
- infectious drumming 1
- intense electric guitar feedback 1
- joyful 1
- live performance 1
- lively 1
- lively mandolin 1
- love song 1
- mandolin 1
- merry 1
- muddled audio 1
- muffled sounds 1
- pensive 1
- people talking 1
- peppy 1
- percussion grooves 1
- perky 1
- pop 1
- pop hits 1
- popular song 1
- powerful voice 1
- punk pop 1
- reflective lyrics 1
- regional music 1
- regional pop 1
- resonator 1
- rock 1
- saxophone 1
- sentimental 1
- sonic power 1
- spanish guitar 1
- spanish song 1
- spirited 1
- string instruments 1
- strong drum beats 1
- synthesiser 1
- synthesiser arrangements 1
- tambourine 1
- tenor sax 1
- thumping music 1
- ukele 1
- ukele melody 1
- upbeat electronic riff 1
- vibrant 1
- vivacious 1
- world music 1
musiccaps_names (array) 17 ✖
- Music 6
- Bass drum 1
- Clapping 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Happy music 1
- Jingle (music) 1
- Musical instrument 1
- Percussion 1
- Rimshot 1
- Rock and roll 1
- Roll 1
- Singing 1
- Snare drum 1
- Tap 1
- Trance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Θα κάνω φασαρία-Γιαννούλης Βαζαίος | 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 | |
I Say Yes (Zero no Tsukaima - Futatsuki no Kishi) | A female vocalist sings this energetic song. The tempo is fast with enthusiastic drumming, funky bass line, keyboard harmony and synthesiser arrangements. The song is youthful, vibrant, vivacious, hyper, spirited, passionate, bright and has a dance groove. This song is an Electro Pop song. | 2008-07-11T15:03:54Z | Aiath86 | Album: Exit Trance Presents Speed Anime Trance Best 4 | ["Music", "Trance music"] | ["female singer", "fast tempo", "foreign language", "dance music", "dance hits", "club music", "dance music", "electronic instrumentation", "synthesiser arrangements", "spirited drumming", "keyboard harmony", "groovy bass line", "busy music", "electro pop", "animated", "spirited", "emphatic vocals", "youthful", "upbeat electronic riff", "vibrant", "vivacious"] | 7 | BkoCi-IZccI | 1287 | |
Sergio el duende ( y yo le canto al amor...) | A male vocalist sings this energetic song. The tempo is fast emphatic vocals, bright acoustic guitar accompaniment and clap beat. The song is youthful, energetic, popular, cheerful, engaging and happy. The music is minimal with ambient sounds of people clapping, cheering, singing along and keeping beat with claps. The audio is distorted and muffled as it is an amateur home recording. | 2013-07-09T13:09:10Z | Maria Luisa Asencio | ["Singing", "Music", "Musical instrument", "Clapping"] | ["male vocalist", "fast tempo", "acoustic guitar accompaniment", "spanish guitar", "lively", "entertaining", "enthusiastic", "party song", "happy", "joyful", "cheerful", "youthful", "clapping", "singing along", "people talking", "emphatic vocals", "amateur home recording", "spanish song", "popular song"] | 7 | PN3Lx8RutmI | 2529 | ||
Led Zeppelin - Rock and Roll (Live) | A male vocalist sings this energetic Rock song. The tempo is fast with intense drumming, vigorous electric guitar, funky bass and keyboard harmony. The song is a vibrant, enthusiastic, youthful, animated, spirited, buoyant and electrifying Heavy Metal/Rock. There are sounds of people cheering, clapping and singing along, indicating that this is a live performance. | 2008-03-13T23:04:36Z | Rodolfo Baravalle | Rock and Roll en no sé donde.. Viva la pepa (?) | ["Music", "Roll", "Rock and roll"] | ["male vocalist", "fast tempo", "enthusiastic", "string instruments", "amplified instruments", "sonic power", "infectious drumming", "live performance", "gig", "intense electric guitar feedback", "amplified guitar harmony", "keyboard accompaniment", "emphatic vocals", "concert", "live performance", "hard rock", "heavy metal", "rock", "crowd cheering", "clapping", "singing along", "fans", "enthusiastic", "youthful", "electrifying", "compelling"] | 7 | QvwD7NEg3Mw | 2650 | |
A Motown Tribute to Avril Lavigne [in color] | A female vocalist sings this spirited song. The tempo is fast with an animated keyboard harmony, groovy bass lines, electric guitar, tenor and alto saxophone accompaniment, enthusiastic drumming and tambourine beats with vocal backup. The song is energetic, upbeat, youthful, enthusiastic with emphatic vocals. This song is contemporary alternative rock. | 2012-02-21T22:06:57Z | PostmodernJukebox | Download & Stream Here: http://scottbradlee.bandcamp.com/album/roar-ep Experience PMJ Live: https://pmjlive.com?IQid=yt Shop PMJ Music/Merch: https://smarturl.it/pmjshop?IQid=yt Spotify: https://smarturl.it/pmjcomplete?IQid=yt Annie Goodchild - Vocals Tim Kubart - Tambourine Guy Ben The Sax Guy - Saxophone Adam Kubota - Bass Scott Bradlee - Piano & Arrangement YouTube: http://youtube.com/scottbradlee Facebook: http://facebook.com/scottbradleemusic Instagram: http://instagram.com/scottbradlee Twitter: http://twitter.com/scottbradlee Scott's Book: http://smarturl.it/outsidethejukebox | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["female singer", "fast tempo", "saxophone", "bass guitar", "energetic", "perky", "youthful", "spirited drumming", "tambourine", "keyboard harmony", "vocal backup", "tenor sax", "alto sax", "powerful voice", "emphatic vocals", "alternative rock", "punk pop"] | 7 | kkjNpwNcMWI | 4354 | |
You feel the same way too The Rankin family Lyrics | A female vocalist sings this sweet Country song. The music is fast with lively banjo, mandolin, acoustic guitar , dobro and Auto harp harmony, steady bass and rhythmic drumming . The song is emotional, sentimental, pensive, reflective, with a catchy beat. This song is classic Country Pop. | 2012-03-15T01:17:59Z | Kristi Nickerson | I loved this song when i was little! its a great song! **I do not own the music or lyrics in this song** | ["Music", "Happy music"] | ["female singer", "fast tempo", "country music", "emotional", "sentimental", "reflective lyrics", "pensive", "catchy melody", "emphatic vocals", "auto harp", "dog barking sound", "banjo", "mandolin", "fiddle", "love song", "country pop", "country hits", "regional music", "dobro", "resonator"] | 7 | qDSvHlHbAqM | 4764 |
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;