musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "hard rock", musiccaps_aspects contains "male vocal" and musiccaps_names contains "Guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- acoustic drums 2
- bass guitar 2
- hard rock · 2 ✖
- male vocal · 2 ✖
- aggressive 1
- chainsaw 1
- electric guitar 1
- energetic 1
- hard-hitting 1
- live performance 1
- melodic singing 1
- overdriven electric guitar 1
- shouting 1
- vintage sound 1
musiccaps_names (array) 9 ✖
- Guitar · 2 ✖
- Music 2
- Musical instrument 2
- Chainsaw 1
- Drum 1
- Heavy metal 1
- Plucked string instrument 1
- Psychedelic rock 1
- Rock music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
How to re-string a Floyd Rose. | This is a hard rock music piece. There is a male vocalist singing melodically in the lead. The main tune is being played by the overdriven electric guitar with the bass guitar playing in the background. The rhythm is being played by the acoustic drums. The atmosphere is energetic. There is a vintage sound. This piece can be played in the background at a rock bar. | 2008-03-12T01:39:57Z | mustardeth | A basic tutorial on how to re-string a Floyd Rose equipped guitar. *Song playing is Walk Away by Van Halen, a James Gang cover, from a live bootleg. **Sorry about the blurry pictures. | ["Guitar", "Music", "Musical instrument", "Psychedelic rock", "Plucked string instrument"] | ["hard rock", "male vocal", "melodic singing", "overdriven electric guitar", "bass guitar", "acoustic drums", "energetic", "vintage sound"] | 9 | IePfzUzlDng | 1926 | |
Front row! Jackyl 'The Lumberjack Song' live in concert in California! Enjoy! NAMM | This is the live performance of a hard rock piece. There is a male vocal who is shouting at the crowd while revving up a chainsaw. The electric guitar is playing the melody while the bass guitar is playing in the background. The acoustic drums are playing a simple blues rock beat. The atmosphere is aggressive. | 2012-01-23T22:46:42Z | pasha28dio | Filmed at the 'Grove in Anaheim' during NAMM 2012 at the 3rd Annual Dean Guitars Namm Jamm. You just have to love any song that has a chainsaw solo. :-) Testament and Static X also played. Great night of jams. | ["Chainsaw", "Drum", "Guitar", "Heavy metal", "Music", "Musical instrument", "Rock music"] | ["hard rock", "live performance", "male vocal", "shouting", "electric guitar", "bass guitar", "acoustic drums", "chainsaw", "hard-hitting", "aggressive"] | 9 | MQ1Q7xydJPU | 2265 |
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;