musiccaps_details (view)
3 rows where musiccaps_aspects contains "spirited" and musiccaps_names contains "Punk rock" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 59 ✖
- spirited · 3 ✖
- passionate 2
- adventurous 1
- amplified instruments 1
- animated electric guitar harmony 1
- average audio quality 1
- backup singers 1
- classic rock instrumental 1
- classic rock playlist 1
- concert 1
- cymbals crashing 1
- distorted guitar rhythm 1
- distortion guitar accompaniment 1
- driving song 1
- electric guitar lead 1
- emotional 1
- energetic 1
- enthusiastic 1
- excited vocals 1
- fast tempo 1
- gig 1
- groovy bass line 1
- groovy bass lines 1
- groovy rhythm 1
- guitar lead 1
- guitar playing lead 1
- hard rock 1
- heavy metal 1
- high in adrenaline 1
- high on adrenaline 1
- high spirits 1
- home music video 1
- infectious drumming 1
- instrumental music 1
- keyboard harmony 1
- live performance 1
- make singer 1
- male vocalist 1
- medium fast tempo 1
- memdium tempo 1
- metal 1
- never give up 1
- poor audio quality 1
- punchy drumming 1
- relaxing 1
- retro 1
- retro rock 1
- retro rock hits 1
- rhythm guitar 1
- rock 1
- rock band 1
- romantic 1
- song cover 1
- sonic power 1
- steady rock drumming 1
- strong rock drumming 1
- tambourine percussions 1
- vocal harmony 1
- youthful 1
musiccaps_names (array) 11 ✖
- Music 3
- Punk rock · 3 ✖
- Rock music 3
- Heavy metal 2
- Progressive rock 2
- Blues 1
- Burst, pop 1
- Grunge 1
- Independent music 1
- Psychedelic rock 1
- Singing 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Cold Metal - Iggy Pop.mp4 | A male vocalist sings this energetic Rock song. The tempo is medium fast with an animated electric guitar harmony and lead, groovy bass lines,infectious drumming and keyboard harmony. The song is electric,pulsating, youthful, energetic, enthusiastic, passionate and powerful with emphatic vocals. This song is Heavy Metal. | 2010-01-13T20:14:33Z | wotsitooyou | Iggy Pop live does Cold Metal | ["Music", "Punk rock", "Psychedelic rock", "Rock music", "Burst, pop"] | ["male vocalist", "medium fast tempo", "live performance", "gig", "concert", "retro", "retro rock", "keyboard harmony", "infectious drumming", "animated electric guitar harmony", "groovy bass lines", "punchy drumming", "electric guitar lead", "retro", "rock", "heavy metal", "hard rock", "metal", "sonic power", "amplified instruments", "excited vocals", "youthful", "spirited", "enthusiastic", "energetic"] | 7 | NxdQtpceXaI | 2381 | |
My Grandfather's Clock with tabs | The song is an instrumental. The song is medium tempo with an electric guitar playing lead and distorted guitar rhythm, along with groovy bass line and rock drumming rhythm. The song is exciting and spirited. The song is a classic rock instrumental with poor quality audio. | 2007-08-16T21:36:56Z | Rockaholick1 | This video got mirrored when I recordet it! I do not play a left-handed guitar in this video!! Sponsored by Dean Markley inc.: http://www.deanmarkley.com/ If you like what you hear then SUBSCRIBE, as I probably will be releasing more material soon! For tabs and backing track, go here: http://kabudono01.s344.xrea.com/download_ookina/ A SPECIAL THANKS TO ALL WHO LEAVE A COMMENT AND RATING! A pure Rock N' Roll song for all the Rockaholics out there! Played with the amazing Gibson Custom EDS-1275! | ["Blues", "Heavy metal", "Music", "Punk rock", "Rock music", "Progressive rock"] | ["instrumental music", "guitar lead", "spirited", "song cover", "passionate", "home music video", "high spirits", "never give up", "adventurous", "classic rock playlist", "relaxing", "driving song", "distortion guitar accompaniment", "rhythm guitar", "classic rock instrumental", "memdium tempo", "groovy bass line", "steady rock drumming", "high on adrenaline", "poor audio quality"] | 1 | Lrhy2auO6hY | 2226 | |
The Scissors - You Can Make It Dangerous - Out 3.20.10 | A male singer sings this rock melody with backup singers in vocal harmony. The song is fast tempo with a strong drumming rhythm , percussive bass line, amplified guitar playing lead. The song is energetic and romantic. The song is a retro rock song with average audio quality. | 2010-01-21T00:22:10Z | TheScissors | http://www.thescissors.com - http://facebook.com/thescissors Scissors - You Can Make It Dangerous - Out 3.20.10 | ["Singing", "Heavy metal", "Music", "Punk rock", "Independent music", "Rock music", "Progressive rock", "Grunge"] | ["make singer", "fast tempo", "rock band", "backup singers", "vocal harmony", "strong rock drumming", "distorted guitar rhythm", "guitar playing lead", "tambourine percussions", "cymbals crashing", "emotional", "romantic", "groovy rhythm", "high in adrenaline", "passionate", "spirited", "retro rock hits", "average audio quality"] | 1 | Ztlcnd14Kn4 | 3426 |
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;