musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "e-bass" and musiccaps_names contains "Punk rock" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 9 ✖
- acoustic drums 2
- e-bass · 2 ✖
- e-guitar 2
- uptempo 2
- amateur recording 1
- energetic 1
- male singer screaming 1
- rock 1
- rock&roll 1
musiccaps_names (array) 5 ✖
- Music 2
- Punk rock · 2 ✖
- Heavy metal 1
- Progressive rock 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Crushing Day (Live) - Joe Satriani | An acoustic drumset plays a rock groove along with a bassline building the foundation of the song. Someone is playing a solo melody on an e-guitar. This recording is of poor quality. This song may be playing at a live concert. | 2007-05-19T20:38:22Z | lemoners | Footage of Joe playing Crushing Day live. He actually played it during this 2002 Strange Beautiful Music tour webcast. Joe never plays Crushing Day live because it's "cursed". He says that every time he plays it live, someting goes wrong, like the rhythm speeding up, or him messing up on the difficult solo. Also, it's his only composed solo. Most others are improvised, which allows him to have more flexibility in his live performance. His band members usually don't like playing the song either because the rhythm section is quite boring for them. Enjoy this rare footage, sorry about the quality. | ["Music", "Punk rock"] | ["rock", "e-guitar", "e-bass", "acoustic drums", "uptempo", "amateur recording"] | 6 | I6wri5XQQbU | 1876 | |
November Rain - The Ultimate Guns N' Roses Tribute Band Promo Video from Penn's Peak | An acoustic drum is playing with crash hits along with a distorted e-guitar and an e-bass playing along before breaking into the next part. The male voice is screaming in a high pitch. This song may be playing live at a Rock&Roll festival. | 2011-10-14T20:54:37Z | Steve G's Stuff | November Rain - The Ultimate Guns N' Roses Tribute Band Promo Video. Shot Live at Penn's Peak on 1/23/09. For booking go to our website www.novemberraintribute.com | ["Heavy metal", "Music", "Punk rock", "Yell", "Progressive rock"] | ["rock&roll", "acoustic drums", "e-guitar", "e-bass", "male singer screaming", "uptempo", "energetic"] | 6 | E7D42u8a5gc | 1534 |
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;