musiccaps_details (view)
2 rows where musiccaps_aspects contains "heavy metal", musiccaps_names contains "Progressive rock" and musiccaps_names contains "Rock music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- heavy metal · 2 ✖
- amplified instruments 1
- boisterous 1
- cymbals 1
- dance groove 1
- distortion guitars 1
- electrifying 1
- energetic 1
- enthusiastic 1
- fast tempo 1
- hard rock 1
- intense electric guitar lead 1
- keyboard harmony 1
- keyboards 1
- loud 1
- male singer 1
- metal 1
- no voices 1
- palm muted arpeggios 1
- pop rock 1
- powerful percussion 1
- pulsating 1
- rock 1
- sonic power 1
- upbeat 1
- vigorous drumming 1
- youthful 1
musiccaps_names (array) 7 ✖
- Music 2
- Progressive rock · 2 ✖
- Rock music · 2 ✖
- Grunge 1
- Heavy metal 1
- Psychedelic rock 1
- Punk rock 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Forgotten Suns - Walk On | A male vocalist sings this enthusiastic Rock. The tempo is fast and upbeat with a vigorous electric guitar lead and harmony, hard hitting drums and amplified keyboard. The music is an energetic, boisterous, youthful, enthusiastic, engaging, pulsating and electrifying Hard Rock. | 2006-12-13T08:02:40Z | tyepennington | Footage taken from a gig at The Mandarin Club on 5th August 2006. | ["Music", "Rock music", "Progressive rock", "Grunge"] | ["male singer", "fast tempo", "rock", "hard rock", "sonic power", "cymbals", "youthful", "pulsating", "electrifying", "enthusiastic", "amplified instruments", "vigorous drumming", "intense electric guitar lead", "keyboard harmony", "upbeat", "energetic", "loud", "boisterous", "enthusiastic", "metal", "heavy metal", "pop rock", "dance groove"] | 7 | J9ZlahUawkg | 1975 | |
Kettlespider - The Kettle Spider - Australian Prog Metal - Triple J | This heavy metal song features distortion guitars. One guitar plays power chords. Another guitar is playing a repetitive riff using palm muted arpeggiated notes. The keyboard plays chords in the background. The bass plays the root notes of the chords. The percussion plays a simple beat in common time. It starts off playing the kick and crash followed by three beats on the kick and ride. After four bars, a rock drum roll is played. This song can be played in a superhero movie. | 2011-10-10T02:31:19Z | Kettlespider | Nice solid prog ala Dream Theater style! Lots of promise here so keep an eye out! Hornz! Haugy \m/ Andrew Haug, triple j 'Avadante', the debut album from Kettlespider, is available on iTunes: http://itunes.apple.com/au/album/avadante/id524530770 Also, check out our CD if you like the music! http://kettlespider.bandcamp.com www.facebook.com/kettlespider | ["Heavy metal", "Music", "Punk rock", "Psychedelic rock", "Rock music", "Progressive rock"] | ["heavy metal", "no voices", "distortion guitars", "palm muted arpeggios", "powerful percussion", "keyboards"] | 0 | dO3VsX4rKNc | 3782 |
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;