musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "vibrant", musiccaps_aspects contains "vigorous" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- fast tempo 2
- male vocalist 2
- vibrant · 2 ✖
- vigorous · 2 ✖
- vivacious 2
- amplified keyboard 1
- animated 1
- assertive 1
- concert performance 1
- dominating vocals 1
- double neck guitar 1
- energetic 1
- enthusiastic 1
- forceful 1
- funky bass line 1
- groovy bass line 1
- hard hitting drumming 1
- hard rock 1
- heavy metal 1
- high pitch 1
- intense 1
- intense drumming 1
- intense electric guitar feedback 1
- intense electric guitar harmony 1
- loud 1
- metal 1
- passionate 1
- powerful 1
- progressive 1
- progressive metal 1
- rock 1
- rock and roll 1
- skilled guitarist 1
- spirited vocals 1
- vehement 1
- vigorous bass lines 1
- vigorous keyboard harmony 1
- vital 1
- youthful 1
musiccaps_names (array) 5 ✖
- Music 2
- Angry music 1
- Heavy metal 1
- Rock and roll 1
- Roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Avantasia - Wastelands (Michael Kiske) | A male vocalist sings this high energy Rock song. The tempo is fast with enthusiastic and skilled bass guitar lines, intense, hard hitting drums, groovy electric guitar accompaniment and rhythmic keyboard. The song is youthful, animated, spirited, animated,vigorous, incredibly vital and vivacious. This song is Hard Rock/ Progressive metal. | 2010-03-24T12:02:47Z | Artem Reva | The new edition of Tobias Sammet's AVANTASIA will be released as two separate albums entitled "The Wicked Symphony" and "Angel Of Babylon". Status: Ready to be release. Record deal: Nuclear Blast Records. Album scheduled for release in April 3rd 2010. The Japanese edition on 31th March. Michael sings on "Stargazers", "Wastelands", "Runaway Train" and "Promised Land". | ["Heavy metal", "Music", "Angry music"] | ["male vocalist", "fast tempo", "hard rock", "vigorous bass lines", "youthful", "animated", "vigorous", "vital", "vivacious", "progressive", "metal", "progressive metal", "intense electric guitar feedback", "intense drumming", "funky bass line", "vigorous keyboard harmony", "spirited vocals", "rock", "hard rock", "skilled guitarist", "youthful", "vibrant"] | 7 | JRmfjBDKCpE | 2006 | |
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 |
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;