musiccaps_details (view)
1 row where musiccaps_aspects contains "intense", musiccaps_aspects contains "metal", musiccaps_aspects contains "powerful" and musiccaps_aspects contains "turn table"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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;