musiccaps_details (view)
4 rows where musiccaps_aspects contains "fast tempo" and musiccaps_author = 5
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Rihanna - Work (Steelpan Cover) | The song features a steelpan that creates the main melody. The sounds are bright and have a positive atmosphere. The track fits the afrobeat genre. In the background there are drums that play a mix between hip-hop and afrobeat patterns. A percussion synth creates a counter melody that contrasts the whole instrumental. This is a song you would play at a beach party in the caribbean at night. | 2016-03-26T01:45:08Z | Keishaun Julien | Keishaun Julien playing "Work" by Rihanna & Drake on the Steel Pan. LIKE,SHARE & SUBSCRIBE!! http://www.facebook.com/Keishaun.Julien http://www.twitter.com/keishaunjulien http://www.keishaunjulienmusic.com Instagram.com/keishaunjulien Credits: Audio recorded at 5000 Entertainment https://www.facebook.com/5000ENT/ Instrumental courtesy Karaoke Masterpieces https://www.youtube.com/channel/UCtP9... Video Shot & Edited by: Keishaun Julien MP3 Download https://soundcloud.com/keishaun-justin-julien http://bit.ly/2ttOelG Notes http://bit.ly/2ttruTd | ["Music", "Steelpan"] | ["steelpan", "afrobeat", "upbeat", "chill", "smooth", "bright", "positive", "no vocals", "fast tempo", "danceable", "percussion synth"] | 5 | E3iPiZlT6f8 | 1529 | |
| Guitar Rig 4 test | The music features a single melodic element which is an electric guitar with reverb and delay. The guitar alternates between arpeggios and strums. The music could fit the indie rock genre. The overall vibe of the song is bright. | 2009-12-01T17:14:55Z | David Wallimann | -~-~~-~~~-~~-~-Looking for my weekly guitar lessons? Check out http://vid.io/xq8U All example are factory presets from Native INstruments' Guitar Rig 4. Guitar straight into the Rig Kontrol 3 plugged into Macbook using Garageband with Guitar Rig 4 as an insert. Recommended playlists ►How to Play Melodic https://www.youtube.com/playlist?list=PLH8SpmhtFbBtGdaA8RSLjblIBH6aQOWaa ►How to Use Guitar Modes https://www.youtube.com/playlist?list=PLH8SpmhtFbBuwuGfgOAxujZ9FO66Wr73v ►How to Play Blues https://www.youtube.com/playlist?list=PLH8SpmhtFbBvGBOX3CZz_CDkIW6fpSbNl ►►Latest Video: https://goo.gl/1f9R9A ►►Subscribe: https://goo.gl/CmJzN2 David’s gear The Chair! https://amzn.to/3btIZrt Vola Guitars: (use code DAVID to save 10% on your next Vola Guitar) UK/EU: https://shop.volaguitar.com/ USA/Canada: https://www.tensolo.com/collections/vola-guitars Fractal Audio: http://www.fractalaudio.com ClearTone Strings: http://www.cleartonestrings.com Hosa cables: http://hosatech.com Neck Diagrams: https://neckdiagrams.sjv.io/bX9ek Transcribe!: https://bit.ly/2DCMfC7 Guitar Pro: https://www.guitar-pro.com/#ae50 ►►FREE Theory Course http://guitarinfusion.com ►►David’s music: https://www.wallimann.shop Business Inquiries: david@davidwallimann.com | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion"] | ["reverb delay electric guitar", "bright", "guitar arpeggio", "strummed electric guitar", "fast tempo", "indie rock"] | 5 | MyjxrBI9k4o | 2313 | |
| zZounds Exclusive Track through the Roland GR-55 Guitar Synthesizer | The track would fit the funk fusion music genre. The main melodic element is a synth electric guitar that plays a solo with a lot of energy and presence. In the background a drum loop that sounds very electronic is played. The music is upbeat and simple. This song would fit a car racing video game. | 2015-02-05T21:58:48Z | zZounds | Check out this zZounds Exclusive Track through the Roland GR-55 Guitar Synthesizer For more detailed product information, please visit: http://bit.ly/1DKlJhH To view our complete line of Roland products please visit: http://bit.ly/1Djw32f About zZounds.com: zZounds.com was founded in 1996 to provide musicians with the best online buying experience for guitars, basses, recording, microphones, keyboards, DJ, and other musical instruments. The site offers a wide variety of popular brands and service from an expert staff of musicians. http://www.zzounds.com/a--3082258 | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Synthesizer"] | ["synth electric guitar solo", "upbeat", "funk", "fusion", "upbeat electronic drums", "simple", "no vocals", "fast tempo", "drum machine"] | 5 | aCUZuMblJPg | 3521 | |
| The Blues Willies - Shout | The track is an upbeat blues song that features falsetto and raspy male vocals. A drum kit plays an energetic and happy beat. A bass guitar follows the rhythm and adds a bouncy vibe to the song. The overall sound of the instruments is bright and happy. A guitar follows the bass and the drum kit. | 2007-05-03T10:44:42Z | Alfredo | I Blues Willies al concertone del primo Maggio 2007 a S. Giovanni. A parte il mitico Chuck Berry, l'unico vero gruppo che c'entrava qualcosa con il rock'n'roll! www.blueswillies.it | ["Singing", "Music of Asia", "Music", "Ska", "Whoop", "Rock and roll"] | ["blues", "upbeat", "falsetto male vocals", "raspy male vocals", "fast tempo", "blues drum kit", "positive", "happy", "bright male vocals", "bouncy bass"] | 5 | vtVfl5Ff5lw | 5216 |
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;