musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "energetic" and musiccaps_aspects contains "intense drumming" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 69 ✖
- energetic · 4 ✖
- intense drumming · 4 ✖
- enthusiastic 3
- fast tempo 3
- male vocalist 2
- vibrant 2
- acoustic pop rock 1
- amplified guitar 1
- animated backup vocalisation 1
- boomy 1
- boomy bass line 1
- boomy sound 1
- bright electric guitar 1
- chattering sounds 1
- classic rock 1
- coughing 1
- cymbal rides 1
- distorted sound 1
- electric 1
- electric guitar harmony 1
- enigmatic 1
- ethereal 1
- flourishing 1
- funky bass line 1
- gig 1
- goth rock 1
- groovy bass line 1
- hard rock 1
- heavy metal 1
- hyper 1
- impactful 1
- inferior audio quality 1
- insistent 1
- instrumental 1
- intense 1
- keyboard accompaniment 1
- keyboard harmony 1
- live performance 1
- lively electric guitar 1
- loud 1
- loud electric guitar feedback 1
- medium tempo 1
- muffled audio 1
- mystical 1
- passionate 1
- people talking 1
- poor audio quality 1
- pop rock 1
- popnrock 1
- powerful electric guitar feed back 1
- psychedelic 1
- recurring 1
- retro 1
- rock 1
- rock hits 1
- rustling 1
- scratching 1
- screeching 1
- spirited 1
- static 1
- synthesiser harmony 1
- tambourine beats 1
- trance 1
- trap 1
- untiring 1
- vigorous 1
- vigorous keyboard 1
- vivacious 1
- youthful 1
musiccaps_names (array) 8 ✖
- Music 4
- Angry music 1
- Blues 1
- Country 1
- Heavy metal 1
- Jazz 1
- Progressive rock 1
- Psychedelic rock 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
System Of A Down - Chop Suey (Pinkpop Festival 2002) | This song is a vigorous metal instrumental. The tempo is fast with intense drumming, fiery electric guitar riff, amplified guitar rhythms and energetic keyboard accompaniment. The music is energetic, aggressive, youthful, spirited, goth, intense,psychedelic and trance like. This instrumental is Hard Rock/Metal. | 2008-07-10T10:54:28Z | innervis1on | Chop Suey + La Isla Bonita (Cover). Live @ Pinkpop Festival 2002 | ["Heavy metal", "Music", "Progressive rock"] | ["intense", "vigorous", "loud electric guitar feedback", "intense", "psychedelic", "trap", "trance", "hard rock", "enthusiastic", "energetic", "spirited", "hyper", "fast tempo", "goth rock", "heavy metal", "amplified guitar", "intense drumming", "chattering sounds", "scratching", "screeching", "vigorous keyboard"] | 7 | -dVgUSrR8g4 | 68 | |
Josh Rouse - Love vibration (live in Madrid 2007) | A male vocalist sings this lively pop rock. The tempo is medium with an intense electric guitar harmony, punchy drumming, groovy bass lines and keyboard harmony. The song is muffled as the audio quality is inferior but it sounds enthusiastic, youthful, passionate and vibrant. This could be a live performance as there are background sounds of people talking, coughing, rustling. This song is Pop Rock. | 2007-11-23T05:28:53Z | ruben garrido | Josh Rouse en directo en Madrid - 22 noviembre 2007 (live in Madrid) Mi cronica del concierto pinchando aqui: http://40formasdeintimidad.wordpress.com/2007/11/23/en-joy-josh-rouse/ | ["Blues", "Country", "Jazz", "Music"] | ["male vocalist", "medium tempo", "popnrock", "live performance", "gig", "acoustic pop rock", "pop rock", "youthful", "energetic", "vibrant", "enthusiastic", "people talking", "coughing", "rustling", "lively electric guitar", "intense drumming", "synthesiser harmony", "groovy bass line", "muffled audio", "inferior audio quality", "static", "boomy", "loud"] | 7 | SwaqANBpZGY | 2797 | |
Stratovarius - S.O.S. | This music is an animated instrumental. The. Tempo is fast with an intense electric guitar feedback, powerful backup vocalisation, boomy bass drops, intense drumming, tambourine or shaker beats, keyboard harmony and electric guitar riff. The music is engaging, bustling, energetic, melodious and seems to be burgeoning and increasing. The vocalisation is the backbone of this music, giving it an intense, mystical, impactful and enigmatic vibe. This music is Alternative Rock. | 2008-01-16T01:32:23Z | ggonza43 | I'm waiting for the rain now To settle the dusty air Clearing up my emotions Facing it all if I dare I've been thinking I've been trying But I've always been denying Wasted days are still inside of me It's time to set them free Why don't we see what is going on? There are not so many years to be wasted Until the damage is done and the beauty is gone Save Our Souls What is the price that we pay? Save Our Souls Do we have nothing to say? | ["Music", "Angry music"] | ["instrumental", "fast tempo", "animated backup vocalisation", "powerful electric guitar feed back", "intense drumming", "electric guitar harmony", "cymbal rides", "keyboard accompaniment", "boomy bass line", "tambourine beats", "energetic", "ethereal", "enigmatic", "insistent", "recurring", "passionate", "mystical", "untiring", "impactful", "flourishing"] | 7 | dNOHIxD0j_Q | 3780 | |
Zager and Evans - In The Year 2525 | A male vocalist sings this spirited Rock song. The tempo is fast with hard hitting drumming, punchy bass lines, electric guitar lead and keyboard harmony. The song is a vibrant, energetic, enthusiastic, engaging, catchy and upbeat Classic Rock. | 2008-10-19T20:10:56Z | Terring7 | Before saying anything: 1) Yes, the comments are back. I had to close them because of too much nonsense to endured back then. Now I feel better. 2) The video was released in 2008 and before the American elections, so stop asking me to put Obama. 3) The propose of the video is to give a warning about what could happen if we keep misusing and abusing the powerful tool of technology, not to celebrate techno-phobia and doom-and-gloom mentality. Boomers and doomers please go elsewhere to spit your hate and misery. By the way, somebody made a privacy complaint to the YouTube Team about this video. The YouTube Legal Aid Team reviewed the complaint and found that the content is exempt from removal due to the privacy policy. The content does not violate the policies and will remain on the site. My personal conclusion is that somebody just tried to bring it down but failed miserably. How pathetic. | ["Music", "Psychedelic rock"] | ["male vocalist", "fast tempo", "funky bass line", "retro", "rock", "rock hits", "poor audio quality", "boomy sound", "distorted sound", "intense drumming", "bright electric guitar", "keyboard harmony", "classic rock", "electric", "energetic", "enthusiastic", "vivacious", "vibrant"] | 7 | yesyhQkYrQM | 5425 |
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;