musiccaps_details (view)
5 rows where musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "energetic" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 85 ✖
- electric guitar · 5 ✖
- energetic · 5 ✖
- rock 3
- sonic power 3
- enthusiastic 2
- fast tempo 2
- groovy 2
- instrumental 2
- male vocalist 2
- smooth 2
- acoustic guitar 1
- amplified 1
- amplified guitar 1
- amplified music 1
- arabic 1
- arabic dance music 1
- arabic pop 1
- artist 1
- bass electric guitar 1
- bass lines 1
- blues 1
- catchy 1
- cello 1
- cheering clapping 1
- clapping 1
- clean notes 1
- closing riff 1
- concert 1
- contemporary 1
- dense sounds 1
- electric guitar harmony 1
- electric guitar lead 1
- engaging 1
- enthusiastic drumming 1
- enthusiastic riff 1
- external amplification 1
- funky bass line 1
- gig 1
- hard rock 1
- hard rock instrumental 1
- heavy metal 1
- high spirited 1
- hoe recording 1
- home recording 1
- instructional video 1
- instructions 1
- keyboard arrangements 1
- layers of music 1
- live audience 1
- live performance 1
- loud 1
- loud guitar feedback 1
- lower notes 1
- lower octave 1
- male vocals 1
- man talking 1
- medium fast tempo 1
- medium tempo 1
- metal 1
- minimal instrumentation 1
- minimalist 1
- oud accompaniment 1
- oud harmony 1
- performer 1
- powerful 1
- resonant 1
- room acoustics 1
- skilful 1
- slick drumming 1
- soft rock 1
- song end 1
- southern rock 1
- spirited 1
- stage performance 1
- static 1
- stringed instrument 1
- stringed guitar 1
- supporting instrument 1
- tambourine beats 1
- tutorial 1
- vibrating strings 1
- vibrations 1
- violin harmony 1
- vocal backup 1
- youthful 1
musiccaps_names (array) 15 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
OUJRIH émission Tamazight TV4 pour la présentation de son nouvel album 2012 (THILELLI) | A male vocalist sings this upbeat Arabic pop. The tempo is fast and enthusiastic with intense bass lines, keyboard arrangement , vigorous drumming, violin symphony, oud accompaniment with vocal backup and sound of clapping and tambourine beats. The song is energetic, vivacious, enthusiastic, engaging and compelling with a high energy dance vibe. This song is contemporary Pop. | 2012-03-01T11:56:52Z | bananeverte600 | OUJRIH émission tamazight tv4 le 29.02.2012 | ["Music", "Music of Bollywood"] | ["male vocalist", "fast tempo", "keyboard arrangements", "clapping", "arabic", "oud accompaniment", "arabic pop", "vocal backup", "enthusiastic", "energetic", "electric guitar", "funky bass line", "oud harmony", "violin harmony", "enthusiastic drumming", "clapping", "tambourine beats", "arabic dance music"] | 7 | 6nWWTNVRDjw | 787 | |
Fender Rumble 200 Electric Guitar Sound Test | This music clip is a bass electric guitar instrumental. The tempo is medium fast with the guitarist playing an enthusiastic riff after giving instructions. No other instruments are used and the talking at the beginning of the audio clip indicates that this is a tutorial or instructional video. | 2015-09-29T09:57:42Z | Chuckoy Vicuña | Epiphone Les Paul - Korg Pith Black Tuner - Boss SD1 - Electro Harmonix Big Muff Pi - MXR Blow Torch - Fender Rumble 200 | ["Tapping (guitar technique)", "Electric guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | ["male vocals", "electric guitar", "powerful", "loud", "skilful", "supporting instrument", "groovy", "dense sounds", "bass lines", "vibrations", "resonant", "bass electric guitar", "lower notes", "lower octave", "smooth", "instructional video", "sonic power", "amplified", "stringed guitar", "amplified guitar", "enthusiastic riff", "energetic", "youthful", "man talking", "tutorial", "instructions", "static"] | 7 | JPZlyvPNZj4 | 2003 | |
Keeley Memphis Sun Part II | This music is instrumental. The tempo is medium with rhythmic drumming accompaniment. The melody is simple and gets interesting as a layer of drums gets added. It is spirited, catchy and engaging. | 2015-10-21T22:38:15Z | Mike Hermans | https://robertkeeley.com/product/Memphis+Sun+LoFi+Reverb+Delay+ADT/ Memphis Fun – What The Heck Is That? The new Memphis Sun – Lo-Fi Reverb, Echo and Double-Tracker is our second studio themed pedal. Like the Keeley 30ms ADT this pedal gives you a wealth of tones for capturing that classic Rock-and-Roll sound as well as sounds you’ve not heard before. It’s NeoVintage. It’s an Echo and Reverb pedal. Think of this pedal as three different effects: ECHO 600 – Echo for Long Delays SUN MODE – Auto Track-Doubling and Slapback with Short Delays REVERB – Room Reverb – Full Studio Studio Simulation. Both of the ECHO 600 and SUN MODE effects have a Room Reverb. It’s a one-knob, rock and roll type of room reverb. | ["Reverberation", "Echo", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Distortion"] | ["instrumental", "medium tempo", "electric guitar", "sonic power", "spirited", "catchy", "engaging", "smooth", "rock", "external amplification", "vibrating strings", "slick drumming", "layers of music", "groovy", "catchy", "energetic", "sonic power", "minimal instrumentation"] | 7 | U-L9YCIdLbg | 2880 | |
Rickenbacker 4003 Chili Peppers Funk Slap Bass Thing by Carl Seager | This music is instrumental. The tempo is fast with an energetic electric guitar lead harmony. The music is emphatic, seasoned, enthusiastic,engaging and high-spirited. This music is a Hard Rock instrumental. | 2007-07-11T09:42:44Z | Carl Seager | A couple of Chilis riffs (Good Time Boys & Stone Cold Bush) altered somewhat and stuck together as an exercise. Carl's band (Flying Heroes) has a new album 'BROADCAST' out now on Amazon/iTunes/Tesco, etc. The link below will take you to their Amazon download page where you can listen to clips or buy should you like what you hear... http://www.amazon.co.uk/Broadcast/dp/B003U22M4C/ref=sr_shvl_album_1?ie=UTF8&qid=1289915365&sr=301-1 | ["Bass guitar", "Tapping (guitar technique)", "Funk", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental", "fast tempo", "hard rock instrumental", "electric guitar", "rock", "hard rock", "metal", "heavy metal", "minimalist", "home recording", "electric guitar lead", "electric guitar harmony", "hoe recording", "clean notes", "energetic", "high spirited", "amplified music", "stringed instrument", "sonic power", "loud guitar feedback", "room acoustics"] | 7 | YW4AKwkpYxs | 3290 | |
Curtis Stigers-This Life | A male vocalist sings this spirited song. The tempo is medium fast with an acoustic and electric guitar flourish with a bass cello. This bit is the end of the song as the musician plays a closing riff and the sound of clapping and cheering can be heard. This song is an enthusiastic live performance of an energetic Soft Rock. | 2012-04-19T22:49:45Z | Roxxboise | Sons of Anarchy theme song from Curtis Stigers in-studio at KRVB, "The River," Boise, Idaho. | ["Singing", "Bass guitar", "Guitar", "Music", "Musical instrument", "Rock music", "Plucked string instrument"] | ["male vocalist", "medium fast tempo", "song end", "closing riff", "live performance", "concert", "live audience", "gig", "stage performance", "cheering clapping", "acoustic guitar", "electric guitar", "cello", "southern rock", "blues", "rock", "contemporary", "soft rock", "enthusiastic", "energetic", "performer", "artist"] | 7 | kkOGbgGJLF4 | 4352 |
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;