musiccaps_details (view)
2 rows where musiccaps_aspects contains "bass guitar", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- bass guitar · 2 ✖
- live performance · 2 ✖
- youthful · 2 ✖
- acoustic drums 1
- alternative 1
- concert 1
- electric guitar 1
- electronic sound effect 1
- emphatic 1
- energetic 1
- enthusiastic vocals 1
- fast tempo 1
- hard rock 1
- hip 1
- indie rock 1
- intense drumming 1
- laser 1
- loud 1
- loud electric guitar feedback 1
- male vocal 1
- male vocalist 1
- post-punk 1
- powerful 1
- progressive 1
- raucous 1
- rock 1
- strong beats 1
musiccaps_names (array) 8 ✖
- Music 2
- Singing 2
- Cacophony 1
- Drum 1
- Drum kit 1
- Independent music 1
- Rock music 1
- Roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bloc Party - Hunting For Witches @ Bristol Academy 7/2/07 | This is the live performance of an indie rock/post-punk piece. There is a male vocalist in the lead. The tune is being played by the electric guitar and the bass guitar while an electronic sound effect that resembles a laser is adding texture. There is a fast and slightly off-tempo acoustic drum beat playing in the rhythmic background. The atmosphere is energetic. The piece could be playing in the soundtrack of a teenage drama TV series. | 2007-02-23T17:52:05Z | matthewm674 | Bloc Party performing Hunting For Witches live at the Bristol Carling Academy - 7th Feb 2007. | ["Singing", "Music", "Independent music", "Rock music", "Cacophony"] | ["live performance", "indie rock", "post-punk", "alternative", "male vocal", "electric guitar", "bass guitar", "electronic sound effect", "laser", "acoustic drums", "energetic", "hip", "youthful"] | 9 | xUMzNtC2ITA | 5332 | |
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;