musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "alternative rock" and musiccaps_names contains "Rock music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- alternative rock · 4 ✖
- acoustic drums 2
- bass guitar 2
- electric guitar 2
- indie 2
- live performance 2
- male vocal 2
- repeated theme 2
- rock 2
- blues rock 1
- cheering fans 1
- classic rock 1
- drowsy singing 1
- electric guitar lick 1
- engaging 1
- fast tempo 1
- female vocalist 1
- generic 1
- groovy 1
- groovy bass lines 1
- keyboard 1
- live recording 1
- low-to-medium singing 1
- medium tempo 1
- melancholic 1
- organ sound 1
- poor audio quality 1
- powerful 1
- progressive rock 1
- slick drumming 1
- slow tempo 1
- soft rock 1
- symphonic rock 1
- synthesiser articulation 1
- urban 1
- vibrant 1
- vibrant electric guitars 1
- vivacious 1
- youthful 1
musiccaps_names (array) 16 ✖
- Music 4
- Rock music · 4 ✖
- Heavy metal 2
- Drum kit 1
- Grunge 1
- Independent music 1
- Musical instrument 1
- Pop music 1
- Progressive rock 1
- Psychedelic rock 1
- Punk rock 1
- Rock and roll 1
- Shout 1
- Singing 1
- Song 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Black Rebel Motorcycle Club - Howl | This is a live performance of an alternative rock music piece. There is a male vocalist singing in a drowsy manner in the lead. The main tune is being played by a keyboard with an organ sound meanwhile the electric guitar and the bass guitar are supporting it in the background. The rhythm is being provided by a slow tempo acoustic drum beat. The atmosphere is melancholic. This piece can be used in the soundtrack of a drama TV series, especially during the scenes where a character feels like they are depressed. | 2007-06-12T18:16:10Z | Pinkertonoise | "Howl" live in Portland, for MSN Music | ["Music", "Psychedelic rock", "Rock music"] | ["live performance", "alternative rock", "indie", "male vocal", "drowsy singing", "keyboard", "organ sound", "electric guitar", "bass guitar", "acoustic drums", "melancholic", "repeated theme", "slow tempo"] | 9 | PdgswSjYhMw | 2550 | |
Dr. Rockzo. "I'm a Rock n Roll Clown" | This is a recording of a live show performance by a rock band. We hear some cheering fans and then the song starts with an electric guitar lick and a bass guitar, and a kick on the drums. The audio quality is muffled and poor. | 2009-04-11T20:25:15Z | starz7007 | Brenden Small and the School of Rock all stars at the Starland Ballroom. 4-4-09. Dr. Rockzo. "I'm a Rock n Roll Clown" from metalocalypse | ["Drum kit", "Music", "Musical instrument", "Rock music", "Shout", "Rock and roll", "Speech"] | ["live recording", "cheering fans", "live performance", "rock", "poor audio quality", "electric guitar lick", "alternative rock", "blues rock"] | 3 | XHczpbtBhk4 | 3171 | |
GRUNGE LOOK. Grunge Outfit Idea. Grunge Style Lookbook by fashion blogger. | This is an alternative rock piece. There is a male vocal singing at a low-to-medium pitch. There is a groovy electric guitar riff playing the main melody. There is a strong bass guitar playing alongside it. In the rhythmic background, there is a simple acoustic drum beat. There is a generic, urban atmosphere. This piece could be used in advertisement jingles and in the soundtracks of teenage drama movies and TV shows. | 2015-09-28T09:29:27Z | Krist Elle | MORE ABOUT OUTFIT ON MY FASHION BLOG - http://kristinadolinskaya.blogspot.com/ YOU CAN FIND ME ON - LB: http://lookbook.nu/kristina_doli FB: https://www.facebook.com/kristinadoli VK: http://vk.com/kristina_doli IG: https://instagram.com/kristina_doli BLACK RIPPED KNEE JEANS - http://bit.ly/1OylsUy LONG CARDIGAN - http://bit.ly/1O0HDFL HAMSA TANK TOP - http://bit.ly/1XKBBMG 3 SET CHOKER - http://bit.ly/1QnFPF1 Model and Fashion Blogger : Kristina Dolinskaya ( kristina_doli ) ♪ ♫ ♬ MUSIC - Benj Heard – Whatever Doesn't Kill Me Better Run ♪ ♫ ♬ | ["Heavy metal", "Music", "Punk rock", "Rock music", "Grunge"] | ["alternative rock", "indie", "male vocal", "low-to-medium singing", "electric guitar", "bass guitar", "acoustic drums", "groovy", "urban", "generic", "repeated theme", "medium tempo"] | 9 | m-xxD1fGPnU | 4439 | |
Magenta - King Of The Skies | A female vocalist sings this spirited song. The tempo is fast with enthusiastic electric guitar harmony, slick drumming, groovy bass lines and synthesiser arrangements. The song is energetic, youthful, fun, pulsating, engaging and emphatic. This song is Alternative Rock. | 2006-06-21T17:59:15Z | chrismagenta | Track from Magenta's The Gathering DVD. Amazing Welsh Progressive Rock band in the vain of Genesis, Yes and Renaissance. | ["Singing", "Heavy metal", "Music", "Independent music", "Pop music", "Rock music", "Song", "Progressive rock"] | ["female vocalist", "fast tempo", "vibrant electric guitars", "progressive rock", "symphonic rock", "alternative rock", "slick drumming", "synthesiser articulation", "vivacious", "youthful", "vibrant", "groovy bass lines", "engaging", "powerful", "rock", "classic rock", "soft rock"] | 7 | pp6eSGANq0Y | 4737 |
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;