musiccaps_details (view)
5 rows where musiccaps_aspects contains "hard rock", musiccaps_aspects contains "intense drumming" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 66 ✖
- hard rock · 5 ✖
- intense drumming · 5 ✖
- fast tempo 4
- vigorous 4
- animated 3
- enthusiastic 2
- intense 2
- loud 2
- loud electric guitar feedback 2
- male vocalist 2
- progressive 2
- rock 2
- spirited 2
- video game music 2
- youthful 2
- amplified guitar 1
- bass guitar 1
- blasts 1
- boisterous 1
- boomy 1
- chattering sounds 1
- clamorous 1
- compelling 1
- concert 1
- electronic music 1
- emphatic 1
- energetic 1
- enthusiastic rhythmic drumming 1
- enthusiastic vocals 1
- funky bass line 1
- futuristic 1
- goth rock 1
- heavy metal 1
- hurried 1
- hyper 1
- informative 1
- insistent 1
- instrumental 1
- instrumental music 1
- intense electric guitar feedback 1
- last tempo heavy metal 1
- live performance 1
- male voice speaking 1
- metal 1
- powerful 1
- progressive metal 1
- psychedelic 1
- rapid clicking sound 1
- raucous 1
- review 1
- scratching 1
- screeching 1
- skilled guitarist 1
- sound of shooting 1
- spirited vocals 1
- strong beats 1
- techno music 1
- trance 1
- trap 1
- urgent 1
- vibrant 1
- vigorous bass lines 1
- vigorous keyboard 1
- vigorous keyboard harmony 1
- vital 1
- vivacious 1
musiccaps_names (array) 10 ✖
- Music 5
- Angry music 2
- Heavy metal 2
- Boom 1
- Drum 1
- Drum kit 1
- Progressive rock 1
- Roll 1
- Singing 1
- Speech 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 | |
Avantasia - Wastelands (Michael Kiske) | A male vocalist sings this high energy Rock song. The tempo is fast with enthusiastic and skilled bass guitar lines, intense, hard hitting drums, groovy electric guitar accompaniment and rhythmic keyboard. The song is youthful, animated, spirited, animated,vigorous, incredibly vital and vivacious. This song is Hard Rock/ Progressive metal. | 2010-03-24T12:02:47Z | Artem Reva | The new edition of Tobias Sammet's AVANTASIA will be released as two separate albums entitled "The Wicked Symphony" and "Angel Of Babylon". Status: Ready to be release. Record deal: Nuclear Blast Records. Album scheduled for release in April 3rd 2010. The Japanese edition on 31th March. Michael sings on "Stargazers", "Wastelands", "Runaway Train" and "Promised Land". | ["Heavy metal", "Music", "Angry music"] | ["male vocalist", "fast tempo", "hard rock", "vigorous bass lines", "youthful", "animated", "vigorous", "vital", "vivacious", "progressive", "metal", "progressive metal", "intense electric guitar feedback", "intense drumming", "funky bass line", "vigorous keyboard harmony", "spirited vocals", "rock", "hard rock", "skilled guitarist", "youthful", "vibrant"] | 7 | JRmfjBDKCpE | 2006 | |
Top 10 Robots | This music is an electronic instrumental. The tempo is fast with heavily synthesised arrangements and intense drumming with a male voice speaking over the music. The music is intense, vigorous,animated, futuristic and vital. It sounds like video game music and the male voice seems to be reviewing Video Games. | 2015-05-16T05:12:56Z | GameTrailers | Sometimes, when you need a friend, you have to build one. We assemble all the greatest creations in video games and determine who is the most loyal and effective. | ["Music", "Speech", "Angry music"] | ["instrumental music", "vigorous", "animated", "spirited", "enthusiastic", "intense drumming", "last tempo heavy metal", "hard rock", "electronic music", "video game music", "male voice speaking", "intense", "electronic music", "techno music", "futuristic", "review", "informative"] | 7 | Xn0wIqnt_44 | 3223 | |
Counter-Strike 1.6 funny music | This music is instrumental. The tempo is fast with vigours, intense drumming, electronic sounds like shooting, blasts, boomy bass and Rapid clicking sound . The music is loud,boisterous, aggressive, insistent, intense and clamorous . This is video game music. | 2007-07-11T16:25:02Z | outime | Funny music made with CS 1.6 sounds. I just uploaded it, I didn't create it. | ["Music", "Boom"] | ["instrumental", "fast tempo", "vigorous", "hard rock", "boisterous", "boomy", "video game music", "animated", "intense drumming", "enthusiastic rhythmic drumming", "sound of shooting", "blasts", "rapid clicking sound", "boomy", "loud", "urgent", "hurried", "compelling", "insistent", "clamorous"] | 7 | hPIh5RYA-5M | 4101 | |
GOD OF THUNDER - LIVE (6 year old Drummer) | A male vocalist sings this spirited song. The tempo is fast with intense drumming, loud harmonic electric guitar feedback, bass guitar , emphatic vocals and keyboard accompaniment. The song is a loud, progressive, powerful youthful and emphatic Hard Rock song. | 2013-06-28T12:30:57Z | Avery Drummer Molek | Dressed To Kill are Awesome! They even let me do the solo! VID of me PLAYING WITH KISS → http://bit.ly/AVERY-KISS-COVERS SUBSCRIBE THEN HIT THE 🔔 → http://bit.ly/SUB-AVERY 🔥 FACEBOOK → http://bit.ly/AVERY-FB WEB → http://bit.ly/AVERY-WEB __________ Since I have 100's of 🥁 vidoes on my channel, below are playlist for easy navigation. • CLASSIC ROCK → http://bit.ly/2vye76x • ROCK → http://bit.ly/2vW0nnt • HARD ROCK → http://bit.ly/2w7VZBu • HEAVY METAL → http://bit.ly/2xdvh7M • THRASH METAL → http://bit.ly/2KwBXnX • LIVE GIGS → http://bit.ly/2fyMPVq • REALLY HARD STUFF TO PLAY → http://bit.ly/2iANo2j • TV-INTERVIEWS → http://bit.ly/2mSqpon • POP → http://bit.ly/2jdeJXZ Covers of my Favorite Bands • A7X → http://bit.ly/2wr5jjI • AC/DC → http://bit.ly/2gUdkYY • BOSTON → http://bit.ly/2rPJNBj • DEF LEPPARD → http://bit.ly/2jI1wqX • DREAM THEATER → http://bit.ly/2uWe5SM • GUNS N ROSES → http://bit.ly/2yvwdp5 • IRON MAIDEN → http://bit.ly/2BPyKzY • KISS → http://bit.ly/Playing-with-KISS • LED ZEPPELIN → http://bit.ly/2AiuacD • METALLICA → http://bit.ly/2xEyi1O • MOTLEY CRUE → http://bit.ly/2AXzZZ2 • QUEEN → http://bit.ly/2GPs5HX • RUSH → http://bit.ly/2CsOXM1 • SLAYER → http://bit.ly/2rOD5wt • SOAD → http://bit.ly/2z4zDzd • VAN HALEN → http://bit.ly/2xmgfgB Watch as I grow through the years, in drumming not height. 😉 • 3,4,5 Years Old → http://bit.ly/AGES-3-4-5 • 6 Years Old → http://bit.ly/AGE-6 • 7 Years Old → http://bit.ly/AGE-7 • 8 Years Old → http://bit.ly/AGE-8 • 9 Years Old → http://bit.ly/AGE-9 • 10 Years Old → http://bit.ly/AGE-10 • 11 Years Old → http://bit.ly/AGE–11 Avery “Drummer” Molek is young growing musician. He started playing drums at age 2. He now loves to play everything: classic, rock, jazz, metal and progressive music. Avery also plays bass, guitar & piano. Subscribe to get NEW VIDS! Covers, LIVE Shows, Solos and Originals. Thank you & keep Rockin! 🤘 SUBSCRIBE THEN HIT THE 🔔 → http://bit.ly/SUB-AVERY 🔥 Dressed To Kill & Avery Molek (6 year old drummer) LIVE cove… | ["Singing", "Drum", "Drum kit", "Music", "Roll"] | ["male vocalist", "fast tempo", "intense drumming", "loud electric guitar feedback", "bass guitar", "enthusiastic vocals", "rock", "hard rock", "live performance", "concert", "loud", "raucous", "progressive", "strong beats", "emphatic", "powerful", "youthful"] | 7 | zayC5mUo7sY | 5496 |
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;