musiccaps_details (view)
4 rows where musiccaps_aspects contains "loud", musiccaps_aspects contains "upbeat" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 73 ✖
- fast tempo 4
- loud · 4 ✖
- upbeat · 4 ✖
- enthusiastic 3
- boisterous 2
- energetic 2
- instrumental 2
- sonic power 2
- youthful 2
- acordian harmony 1
- ambient sounds 1
- amplified guitar 1
- amplified instruments 1
- animated 1
- beeping 1
- busy 1
- buzzing 1
- catchy 1
- cheerful 1
- clicking sound 1
- complex harmony 1
- cymbals 1
- dance groove 1
- electrifying 1
- electronic music 1
- emotional 1
- energetic drumming 1
- enthusiastic electric guitar lead 1
- external amplification 1
- folk music 1
- foreign language 1
- funk pop 1
- funky 1
- funky bass line 1
- groovy 1
- guitar harmony 1
- gunshots 1
- happy 1
- hard rock 1
- heavy metal 1
- home video 1
- infectious drumming 1
- inferior audio quality 1
- intense electric guitar lead 1
- keyboard harmony 1
- live performance 1
- lively 1
- loud electric guitar feedback 1
- male harmony 1
- male singer 1
- male singers 1
- metal 1
- muffled audio 1
- noisy 1
- passionate singing 1
- phone ringing 1
- pop rock 1
- pulsating 1
- punk rock 1
- rhythmic acoustic guitar 1
- rock 1
- scratching sound 1
- sonic treat 1
- spirited 1
- synthesiser arrangement 1
- three part harmony 1
- upbeat catchy 1
- vibrant 1
- vibrations 1
- video game music 1
- vigorous drumming 1
- whirring 1
- whirring sounds 1
musiccaps_names (array) 11 ✖
- Music 4
- Rock music 2
- Accordion 1
- Bass guitar 1
- Blues 1
- Grunge 1
- Musical instrument 1
- Progressive rock 1
- Rock and roll 1
- Synthetic singing 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Forgotten Suns - Walk On | A male vocalist sings this enthusiastic Rock. The tempo is fast and upbeat with a vigorous electric guitar lead and harmony, hard hitting drums and amplified keyboard. The music is an energetic, boisterous, youthful, enthusiastic, engaging, pulsating and electrifying Hard Rock. | 2006-12-13T08:02:40Z | tyepennington | Footage taken from a gig at The Mandarin Club on 5th August 2006. | ["Music", "Rock music", "Progressive rock", "Grunge"] | ["male singer", "fast tempo", "rock", "hard rock", "sonic power", "cymbals", "youthful", "pulsating", "electrifying", "enthusiastic", "amplified instruments", "vigorous drumming", "intense electric guitar lead", "keyboard harmony", "upbeat", "energetic", "loud", "boisterous", "enthusiastic", "metal", "heavy metal", "pop rock", "dance groove"] | 7 | J9ZlahUawkg | 1975 | |
Cel ce legi rani care dor-grup burla&horodnic | A group of male vocalists sing this charming melody in a foreign language. The tempo is fast with accordion lead music and acoustic guitar accompaniment. The song is lively, happy, light , warm, cheerful and charming . The audio quality is inferior as it seems to be an amateur home recording with ambient sounds. This Song is a Folk song. | 2011-11-13T02:38:31Z | dorin juravle | Dorin Gach, Dorin Medrihan, Valy Motac, Florin Motac, Danut Covali, Cornel Mihalescu | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["male singers", "male harmony", "fast tempo", "rhythmic acoustic guitar", "acordian harmony", "lively", "loud", "folk music", "emotional", "passionate singing", "three part harmony", "live performance", "ambient sounds", "inferior audio quality", "cheerful", "upbeat", "happy", "foreign language"] | 7 | QHCHK-NPO_U | 2607 | |
Funk Step Paul Reed Smith Single Cut Trem Demo - Funk Rock PRS Demo - Crunch Sound PRS | This music is instrumental. The tempo is fast with an electric guitar playing a bright lead with infectious drumming and syncopated bass lines. The music is upbeat, energetic, youthful, animated, spirited, enthusiastic, groovy and funky. | 2013-11-05T09:44:52Z | Marco Cirillo | Funk Step Paul Reed Smith Single Cut Trem Demo - Funk Rock PRS Demo - Crunch Sound PRS This is an old Demo of this beautiful Guitar. Prs Single Cut Trem is a quite versatile Electric Guitar with Humbucker Pickup and Switch for Single Coil. The quality Video is not that good as I said this is an old video, but I hope it can help you to have an Idea of the sound..... Thank you for watching. Subscribe and Keep Update | ["Blues", "Bass guitar", "Music", "Rock music", "Rock and roll"] | ["instrumental", "fast tempo", "amplified guitar", "loud electric guitar feedback", "sonic power", "sonic treat", "external amplification", "vibrations", "funk pop", "youthful", "punk rock", "energetic drumming", "funky bass line", "enthusiastic electric guitar lead", "infectious drumming", "catchy", "upbeat", "vibrant", "complex harmony", "loud", "enthusiastic", "youthful", "guitar harmony", "funky", "groovy", "upbeat catchy"] | 7 | VM-U7MyZAck | 2993 | |
Disney Dancing and Singing Donald Duck (Solo) | This song is an instrumental. The tempo is fast with electronic instrumentation and sounds. There is a vigorous keyboard harmony along with sounds of gunshots, clicking, whirring, beeping, phone ring and scratching. The music is busy, animated and boisterous. The audio quality is inferior and muddled, making it difficult to hear the finer elements. | 2009-02-28T11:39:55Z | xiaohwee85 | 3 x great songs from Daffy 3 x AA battery operated | ["Music", "Synthetic singing"] | ["instrumental", "fast tempo", "loud", "busy", "boisterous", "beeping", "whirring", "noisy", "scratching sound", "video game music", "upbeat", "energetic", "enthusiastic", "electronic music", "clicking sound", "animated", "synthesiser arrangement", "muffled audio", "home video", "whirring sounds", "gunshots", "buzzing", "phone ringing", "spirited", "energetic"] | 7 | XjoRxeEyjz4 | 3217 |
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;