musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "no singer"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Blue Bossa - Achim Kohl - Jazz Guitar Improvisation with Tabs | This is an instrumental jazz improvisation piece with heavy bossa nova influences. There is an over-arching bossa nova syncopation not only being played by the acoustic drums in the backing track but also followed by the electric rhythm guitar and the bass guitar. The lead is a guitar solo being played by a gentle sounding electric guitar. Although there are complex chords and riffs, the general atmosphere is tranquil. This piece could be playing in the background of a restaurant. It could also be included in the soundtrack of a movie during serene scenery. | 2013-03-11T13:08:58Z | Achim Kohl | played with my Gibson ES 137 Custom, If you want to play a transcription of this solo, go to https://www.klangfarbe-noten-shop.de/en/blue-bossa-solo.html | ["Guitar", "Jazz", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["jam", "jazz", "bossa nova", "no singer", "instrumental", "electric guitar", "guitar solo", "bass guitar", "acoustic drums", "soft", "sensual", "tranquil"] | 9 | AgtY6m-b3Gk | 1155 | |
TeknoAXE's Royalty Free Music - Royalty Free Music #247 (Drop D Powered) Grunge/Power Metal/Rock | This is an instrumental power metal piece. There is an electric guitar playing the melody with the accompaniment of a keyboard. There is an acoustic drum beat in the rhythmic background. There is an aggressive atmosphere. This piece could be used in the soundtrack of an action video game. | 2013-09-10T03:10:09Z | TeknoAXE's Royalty Free Music | Download Music: http://teknoaxe.com/Link_Code_3.php?q=461 **This track is Royalty Free and is free for anyone to use in YouTube videos or other projects, whether monetized or not.** http://www.facebook.com/teknoaxe http://www.reverbnation.com/teknoaxe So this is both to fill in some requests to do more power rock/metal-ish type stuff and also it is significant in that it's really the first rock track that I've done on this new computer. So this effectively means that I can retire ol' bluescreen and keep going here. It's also good prep for a collab I have coming up with Qelric. I hope you like it! :) *Legal notice: The publisher of this video is the original source for the music track being presented in this video, which is entitled "Drop D Powered". No one entity, person or organization may take legal action against other entity, person or organization due to use or distribution of this track or modified portions of this music track. image used: http://www.flickr.com/photos/mathiasmiranda/8595888795/sizes/o/in/photostream/ and http://www.flickr.com/photos/deanmccoyphotos/5187390915/sizes/o/in/photostream/ | ["Background music", "Music", "Grunge"] | ["power metal", "no singer", "instrumental", "electric guitar", "keyboard", "acoustic drums", "loud", "aggressive"] | 9 | LQYd-dsz62M | 2185 | |
Epiphone Les Paul Blues in G | This is an instrumental rock music piece recording in the style of blues. There is an electric guitar playing a solo using the shredding technique. The backing track consists of a piano, a bass guitar and acoustic drums. There is a groovy feel to it. Parts of this recording could be sampled for use in beat-making. | 2006-02-22T07:39:48Z | Raúl Cabezalí | Download my tunes for free from http://www.jamendo.com/en/artist/353294/raulin-de-los-bosques Raulin de los Bosques plays some blues licks over a g-blues backing track on a Epiphone 'Les Paul' Standard through his Behringer V-amp2. | ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["rock music", "jam", "no singer", "instrumental", "electric guitar", "guitar solo", "shredding", "backing track", "piano", "bass guitar", "acoustic drums", "groovy", "blues"] | 9 | hVVrl9FkKnY | 4113 |
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;