musiccaps_details (view)
3 rows where musiccaps_aspects contains "hard rock", musiccaps_aspects contains "powerful" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 57 ✖
- hard rock · 3 ✖
- powerful · 3 ✖
- emphatic 2
- rock 2
- youthful 2
- acoustic guitar harmony 1
- amplified 1
- auto tune 1
- bass guitar 1
- boisterous 1
- boomy 1
- compelling 1
- concert 1
- cover song 1
- electric guitar lead 1
- electronic music 1
- emphatic vocals 1
- enthusiastic 1
- enthusiastic vocals 1
- fast tempo 1
- female singer 1
- female vocalist 1
- feminist 1
- girl band 1
- girl metal band 1
- hard hitting 1
- hard hitting drums 1
- heavy metal 1
- intense 1
- intense drumming 1
- intense electric guitar feedback 1
- keyboard accompaniment 1
- live performance 1
- lively electric guitar 1
- loud 1
- loud electric guitar feedback 1
- loud feedback 1
- male vocalist 1
- medium fast tempo 1
- medium tempo 1
- metal 1
- passionate 1
- persuasive 1
- pop rock 1
- powerful vocals 1
- progressive 1
- psychedelic 1
- punchy 1
- raucous 1
- steady drumming 1
- strong 1
- strong beats 1
- synthesiser articulation 1
- tambourine beats 1
- turn table 1
- vocal backup 1
- vocalisation 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lissie - Bad Romance (Lady Gaga live cover) | A female vocalist sings this passionate Rock song. The tempo is medium with infectious electric guitars on lead and harmony, tambourine beats , steady drumming and keyboard accompaniment. The song is intense, passionate, empathic, powerful, persuasive and compelling. This song is Soft Rock. | 2010-09-10T10:21:50Z | LissieVEVO | Music video by Lissie performing Bad Romance. (C) 2010 Fat Possum Records in US; (C) 2010 Sony Music Entertainment UK Limited in remaining countries | ["Singing", "Music", "Grunge"] | ["female vocalist", "medium tempo", "cover song", "passionate", "emphatic", "powerful", "persuasive", "compelling", "tambourine beats", "lively electric guitar", "electric guitar lead", "acoustic guitar harmony", "keyboard accompaniment", "emphatic vocals", "powerful vocals", "steady drumming", "rock", "hard rock", "pop rock"] | 7 | W2EJai-3k2w | 3055 | |
BABYMETAL - いいね!- Iine! (OFFICIAL) | A female vocalist sings this powerful Hard rock song. The tempo is medium fast with a vigorous electric guitar feedback, synthesiser articulation and electronic arrangement. The song is youthful, powerful, intense, boisterous, compelling, psychedelic, boomy , punchy and impactful. This song is a Hard Rock/heavy Metal song. | 2012-11-08T08:29:27Z | BABYMETAL | BABYMETAL 1st full album "BABYMETAL" available now!! Available on iTunes Store worldwide & CD web store. Don't miss it!! [iTunes Store] https://itunes.apple.com/us/artist/babymetal/id477101776 [CD web store ASMART] ●BABYMETAL - Limited edition(CD+DVD) http://www.asmart.jp/Form/Product/ProductDetail.aspx?shop=0&cat=100131&swrd&pid=10006479&vid http://www.youtube.com/watch?v=U9oRytBGwYM ●BABYMETAL - Regular edition(CD only) http://www.asmart.jp/Form/Product/ProductDetail.aspx?shop=0&cat=100131&swrd&pid=10006480&vid [CD web store CDJAPAN] http://www.cdjapan.co.jp/search3.html?q=babymetal&media&r=any&step=20&order=score ★ Official Site : http://www.babymetal.jp/ ★ Facebook : http://www.facebook.com/BABYMETAL.jp ★ Twitter : https://twitter.com/BABYMETAL_JAPAN 【Profile】 BABYMETAL【SU-METAL (Vocal,Dance) / MOAMETAL (Scream,Dance) / YUIMETAL (Scream,Dance) 】 Formed in 2010. Their major debut single “ Ijme, dame, zettai" along with 2nd single “Megistune" both ranked in the Top 10 Oricon chart in Japan. In March 2014, they took to the stage of Nippon Budokan for a 2-Days gig making them the youngest female act to ever perform there. Their 1st studio album BAYBMETAL made it into the US Billboard chart. In summer of the same year, they embarked on their first World Tour, performing on the Main Stage at UK’s prodigious festival Sonisphere Festival 2014 in front of 65,000 festival goers, and supporting Lady Gaga on her “ArtRave: The Artpop Ball” 2014 Tour. In fall they were back for additional headline shows in Hammerstein Ballroom, New York City and O2 Academy Brixton, London. In January 2015, they headlined a show at the 20,000 capacities Saitama Super Arena, and in June 2015, they headlined a show at the 25,000 capacities Makuhari Messe. In summer of 2015, BABYMETAL received awards from prominent UK music magazines “Kerrang!” and “METAL HAMMER”. They then performed in front of a staggering 90,000 people at the prestigious Reading and Leeds Festival in August. This December, BABYMETAL are to take the stage again fo… | ["Singing", "Music", "Groan"] | ["female singer", "medium fast tempo", "vocal backup", "loud feedback", "amplified", "boomy", "boisterous", "punchy", "hard hitting", "psychedelic", "synthesiser articulation", "hard rock", "metal", "vocalisation", "auto tune", "turn table", "intense electric guitar feedback", "hard hitting drums", "girl band", "heavy metal", "girl metal band", "enthusiastic", "intense", "powerful", "feminist", "strong", "electronic music", "youthful"] | 7 | qVdBBOpSoN4 | 4790 | |
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;