musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "no voice" and musiccaps_names contains "Rock music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- instrumental · 2 ✖
- no voice · 2 ✖
- acoustic guitar 1
- aggressive guitar playing 1
- bass 1
- blues rock 1
- distortion guitar 1
- fast tempo 1
- guitar lick 1
- hard rock 1
- minimal instruments 1
- moderate tempo 1
- no percussion 1
- palm muting 1
- rock drums 1
- upbeat song 1
musiccaps_names (array) 9 ✖
- Music 2
- Rock music · 2 ✖
- Acoustic guitar 1
- Blues 1
- Flamenco 1
- Guitar 1
- Musical instrument 1
- Punk rock 1
- Rock and roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Love Acoustic Guitar ! Great Blues rock and roll ! Happy Music. Yannick Lebossé.Je pousse un cri. | This blues instrumental rock song features an acoustic guitar being aggressively strummed. There are no other instruments in this song. There are no voices in this song. The tempo of this song is fast. The rhythm of this song comprises fast upstrokes and downstrokes. Some of the strums are muted and the main rhythm is played with a mix of open and palm muted techniques. | 2011-10-04T14:47:11Z | Je Pousse Un Cri | Love Acoustic Guitar ! Great Blues rock and roll ! Happy Music. Yannick Lebossé.Je pousse un cri. #guitar #blues #acoustic You can find another great blues guitar video here http://www.youtube.com/watch?v=2_oXgPnaZOs Blues is related to roots such as African-American in the south of USA from the 19th century .We Love the blues or jazz, rhythm blues, rock and roll with guitar and, heavy metal music, hip hop music, reggae, country music, and pop music, We Like also Dan Aykroyd John Belushi The Blues Brothers. The Ray Charles, James Brown, Cab Calloway, Aretha Franklin, John Lee Hooker. B.B. King, Bo Diddley, Erykah Badu, Eric Clapton, Steve Winwood, Charlie Musselwhite, Blues Traveller, Jimmy Vaughn, Jeff Baxter. Visit our Channel for tutorials and More Guitar videos! http://www.youtube.com/Jepousseuncri Please Subscribe if you want to watch more music videos ! More Youtube Guitar Videos: Spanish Guitar and Blues with Yannick Lebossé https://youtu.be/oTXa6FFnPI0 https://youtu.be/KC3hJFvQv3A https://youtu.be/2_oXgPnaZOs https://youtu.be/kXo8Y6qz6QA https://youtu.be/TFJPThBuLks https://youtu.be/57JtLg098Go https://youtu.be/AJw-x30L46E https://youtu.be/QsSq6hgB1XQ https://youtu.be/6VkzfVRSS24 https://youtu.be/iJM6sOhjC0g https://youtu.be/jWBc6eLHF0o https://youtu.be/tyrfXzZ-KG4 https://youtu.be/kGbgVy4BhyE https://youtu.be/U1D_q-GjFUE https://youtu.be/thdR68WFyDk https://youtu.be/KF11JAqMUR4 https://youtu.be/ngYt1vos2RM https://youtu.be/3ZduJh_0GHU Irish Music Ghillies https://www.youtube.com/watch?v=JZoYGaKR8Qg https://www.youtube.com/watch?v=tEJQuwHm88I https://www.youtube.com/watch?v=JVh3T2CYNv4 http://ghillies.wixsite.com/ghillies Gueule de loup https://www.youtube.com/watch?v=Ga1zaiZ3Q-U https://www.youtube.com/watch?v=AMwfa4wyRUw https://www.youtube.com/watch?v=mJ9LhiGgeR8 https://www.youtube.com/watch?v=wfQ3c70jWPc https://www.youtube.com/watch?v=s66MBQrce3k Les Compagnons du gras jambon . https://www.youtube.com/watch?v=mZCw75PhgIc https://www.youtube.com/watch?v=mi5GmLLxWoA Luc Arbogast https:… | ["Blues", "Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Rock music", "Rock and roll"] | ["blues rock", "fast tempo", "acoustic guitar", "no voice", "instrumental", "no percussion", "minimal instruments", "aggressive guitar playing", "palm muting"] | 0 | AJw-x30L46E | 1105 | |
Led Zeppelin - Rock and Roll (Madison Square Garden 1973) | This hard rock song features a distortion guitar playing aggressive riffs. This is accompanied by a rock percussion playing a simple rock beat with a roll at the end. The bass guitar plays the root notes of the chord with a flourish to move to the subsequent note. There are no voices in this song. This is an instrumental song. | 2011-11-30T15:18:24Z | Led Zeppelin | Watch Led Zeppelin perform their song 'Rock And Roll' live at Madison Square Garden in New York City in July 1973 from The Song Remains the Same. The Song Remains the Same has been reissued with audio remastered by Jimmy Page! Order your copy here https://lnk.to/TSRTS More info about this show: http://www.ledzeppelin.com/show/july-... ► Listen to Mothership https://lnk.to/StreamMothership ♪ Watch all episodes of Led Zeppelin History https://lnk.to/LedZeppelinHistoryID 🕭 Subscribe to the Led Zeppelin channel https://lnk.to/YTLedZeppelinSubID Official Led Zeppelin Playlists: ☑ Led Zeppelin - Essentials https://lnk.to/YTLedZeppelinEssentialsID 📽 The Led Zeppelin Rare Film Series https://lnk.to/LedZeppelinRareFilmID 🎚 Led Zeppelin - Alternative Mixes & Deep Cuts https://lnk.to/LedZeppelinAltMixID Stay Connected with Led Zeppelin: ♪ Website http://www.ledzeppelin.com 🎛 Facebook http://www.facebook.com/ledzeppelin 🎙 Twitter http://www.twitter.com/ledzeppelin 🎞 Instagram https://www.instagram.com/ledzeppelin --------------------------------------------------------------------------------------------------------------------- The Led Zeppelin channel is the band’s official YouTube home, featuring a catalog of official live performances, official music videos, Led Zeppelin History, archival footage, and Zeppelin-approved playlists. 🕭 Subscribe to join the Led Zeppelin YouTube community and check back for new uploads, product announcements, and updates from the band Led Zeppelin formed in 1968 and went on to become one of the most influential, innovative, and successful groups in modern music, having sold more than 300 million albums worldwide. The band rose from the ashes of The Yardbirds, when Jimmy Page brought in John Bonham, John Paul Jones, and Robert Plant to tour as The New Yardbirds. In 1969, Led Zeppelin released its self-titled debut which was produced by Page, as were all the subsequent albums. It marked the beginning of a 12-year reign, during which the group was widely considered to be the … | ["Music", "Punk rock", "Rock music"] | ["hard rock", "distortion guitar", "guitar lick", "no voice", "instrumental", "rock drums", "bass", "moderate tempo", "upbeat song"] | 0 | XgXOW3lX25Y | 3212 |
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;