musiccaps_details (view)
2 rows where musiccaps_aspects contains "heavy metal", musiccaps_aspects contains "powerful" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- hard rock 2
- heavy metal · 2 ✖
- metal 2
- powerful · 2 ✖
- youthful · 2 ✖
- amplified 1
- amplified guitar 1
- auto tune 1
- boisterous 1
- boomy 1
- electric guitar 1
- electronic music 1
- enthusiastic 1
- external amplification 1
- fast tempo 1
- female singer 1
- feminist 1
- girl band 1
- girl metal band 1
- hard hitting 1
- hard hitting drums 1
- instrumental 1
- intense 1
- intense electric guitar feedback 1
- lead 1
- loud 1
- loud feedback 1
- medium fast tempo 1
- minimalist 1
- psychedelic 1
- punchy 1
- rock 1
- stringed instrument 1
- strong 1
- synthesiser articulation 1
- turn table 1
- vocal backup 1
- vocalisation 1
musiccaps_names (array) 7 ✖
- Music 2
- Distortion 1
- Echo 1
- Effects unit 1
- Electric guitar 1
- Groan 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Boss DN-2 Dyna Drive Demo: Gear Up | This music is instrumental. The tempo is medium fast with an energetic electric guitar lead. The music is minimalist with no accompaniment. It is youthful, powerful, enthusiastic, controlled, engaging and intense. This music is Hard Rock/Heavy Metal. | 2012-05-03T16:21:42Z | gearuptmntv | Let your pick set the gain. The Dyna Drive by Boss is very responsive to pick attack. This allows you to lighten up your touch and the drive will clean up. This technology was borrowed from the Roland Cube-60. So if you want a responsive distortion pedal this might be the one for you. Gear Up Be Sure You Go To The Gear Up Channel For Past Episodes http://www.youtube.com/gearuptmntv If you want to request a piece of gear you want on the show just send me a message!!! Also Go Stop By The Musician Network Channel for Other Great Content. http://www.youtube.com/tmntv | ["Echo", "Effects unit", "Electric guitar", "Music", "Distortion"] | ["instrumental", "fast tempo", "electric guitar", "metal", "heavy metal", "hard rock", "amplified guitar", "external amplification", "minimalist", "youthful", "loud", "powerful", "lead", "stringed instrument", "rock", "heavy metal"] | 7 | 9QEm6u4bowQ | 1003 | |
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 |
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;