musiccaps_details (view)
4 rows where musiccaps_aspects contains "enthusiastic", musiccaps_aspects contains "powerful" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 79 ✖
- enthusiastic · 4 ✖
- powerful · 4 ✖
- intense 3
- boisterous 2
- energetic 2
- fast tempo 2
- hard rock 2
- heavy metal 2
- instrumental 2
- loud 2
- metal 2
- passionate 2
- synthesiser articulation 2
- vehement 2
- vocalisation 2
- youthful 2
- accompanying music 1
- amateur recording 1
- amplified 1
- amplified guitar 1
- amplified keyboard 1
- assertive 1
- auto tune 1
- background noises 1
- boomy 1
- concert performance 1
- dissonant 1
- dominating vocals 1
- double neck guitar 1
- edm 1
- electric guitar 1
- electric powered 1
- electrifying 1
- electro/pop 1
- electronic music 1
- electronic sounds 1
- exhilarating 1
- explosive 1
- female singer 1
- feminist 1
- forceful 1
- funky bass lines 1
- futuristic 1
- girl band 1
- girl metal band 1
- groovy bass line 1
- hard hitting 1
- hard hitting drumming 1
- hard hitting drums 1
- high pitch 1
- home recording 1
- intense electric guitar feedback 1
- intense electric guitar harmony 1
- keyboard accompaniment 1
- loud feedback 1
- male vocalist 1
- medium fast tempo 1
- medium tempo 1
- people talking 1
- people talking in the background 1
- progressive 1
- psychedelic 1
- punchy 1
- rapid 1
- rock 1
- rock and roll 1
- rock instrumental 1
- sonic power’ 1
- spirited 1
- strong 1
- synth/pop 1
- turn table 1
- vibrant 1
- vibrant electric guitar harmony 1
- vigorous 1
- vigorous drumming 1
- vivacious 1
- vocal backup 1
- volatile 1
musiccaps_names (array) 9 ✖
- Music 4
- Drum and bass 1
- Electric guitar 1
- Groan 1
- House music 1
- Rock and roll 1
- Roll 1
- Singing 1
- Tapping (guitar technique) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
2012 Chrysler 300C CRD engine sound and 0-100km/h | This music is an Electronic instrumental. The tempo is fast with an electrifying drum rhythm, funky bass lines, synthesiser articulation, cymbals rides, digital drums and electronically arranged sounds. The music is an energetic, high-powered, energetic, enthusiastic, intense, and explosive EDM/Synth Pop. | 2012-11-22T10:36:55Z | PDriveTV | 2012 Chrysler 300C CRD engine sound and 0-100km/h. Head over to http://performancedrive.com.au/2012-chrysler-300c-crd-review-video/ for the full review. 2012 Chrysler 300C CRD 3.0-litre turbo-diesel V6 with DOHC and common-rail injection Five-speed automatic, rear-wheel drive 176kW/550Nm 0-100km/h in 7.0 seconds (as tested) | ["Drum and bass", "House music", "Music"] | ["instrumental", "fast tempo", "vocalisation", "synth/pop", "electro/pop", "futuristic", "progressive", "edm", "synthesiser articulation", "vigorous drumming", "funky bass lines", "vibrant electric guitar harmony", "keyboard accompaniment", "electronic sounds", "rapid", "boisterous", "energetic", "enthusiastic", "electrifying", "exhilarating", "passionate", "electric powered", "powerful", "volatile", "explosive"] | 7 | b8cgQBzBXi8 | 3603 | |
Extreme/Paul Gilbert - Rock and Roll | A male vocalist sings this energetic Rock and Roll song. The song is fast tempo with enthusiastic electric guitar, hard hitting drums, groovy bass lines and keyboard harmony. The song is vibrant, high energy, powerfully,passionate, emphatic, vehement, intense and youthful. This song is classic rock. | 2010-04-19T23:22:03Z | fuzzionrestorock | Extreme/Paul Gilbert Fuzzion RestoRock | ["Music", "Roll", "Rock and roll"] | ["male vocalist", "fast tempo", "intense electric guitar harmony", "vehement", "energetic", "vigorous", "vivacious", "assertive", "intense", "forceful", "passionate", "amplified keyboard", "heavy metal", "double neck guitar", "loud", "powerful", "enthusiastic", "energetic", "groovy bass line", "dominating vocals", "high pitch", "rock and roll", "vibrant", "concert performance", "hard hitting drumming"] | 7 | cHGziT0hrZU | 3695 | |
Curt Mitchell Chop Shop Solo Rockoryon Cover | This music is an Electric Guitar instrumental. The tempo is fast with a dissonant background score . There is the sound of people talking in the background. The music is superimposed on a track which doesn’t seem to be in sync. The lead however is powerful, loud, intense and emphatic. This is a Rock Instrumental. | 2009-08-10T15:54:08Z | OR1ON Orion Meshorer | (RockOryon Cover - when I was 12 years old) This is a great solo from Curt Mitchell Chop Shop. working hard on this solo, has improved my playing tremendously. it still needs more refinement but I want to use this occasion and thank Dear Curt Mitchell for his great teachings. | ["Tapping (guitar technique)", "Electric guitar", "Music"] | ["instrumental", "electric guitar", "people talking in the background", "home recording", "amateur recording", "rock instrumental", "intense", "loud", "amplified guitar", "youthful", "enthusiastic", "vehement", "spirited", "sonic power’", "medium tempo", "background noises", "accompanying music", "people talking", "loud", "powerful", "intense", "rock", "hard rock", "metal", "dissonant"] | 7 | hBQFoDI3NMI | 4082 | |
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;