musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "medium tempo", musiccaps_aspects contains "rock" and musiccaps_aspects contains "sonic power"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- instrumental 5
- medium tempo · 5 ✖
- rock · 5 ✖
- sonic power · 5 ✖
- electric guitar 3
- hard rock 3
- metal 3
- vibrations 3
- electric guitar lead 2
- external amplification 2
- home recording 2
- loud 2
- string instrument 2
- amplified 1
- amplified guitar 1
- amplified guitar 1
- amplified guitars 1
- applied instruments 1
- blues 1
- boomy 1
- country 1
- demo 1
- distortion 1
- electric guitar harmony 1
- electric guitar solo 1
- electric guitar tutorial 1
- enthusiastic 1
- evie’s 1
- experiment 1
- guitar riff 1
- …
musiccaps_names (array) 15 ✖
youtube_published (date) 5 ✖
- 2006-08-08 1
- 2008-06-18 1
- 2010-09-07 1
- 2010-12-17 1
- 2011-07-01 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DiMarzio Crunch Lab and LiquiFire Drive Sound Test (check up with an Ibanez S570B) | This music is an electric guitar instrumental Rock. The tempo is medium with an electric guitar lead. The music is loud and boomy with an intense riff. The audio quality is inferior so the sound is muffled and muddy. The music however is energetic, youthful, spirited and enthusiastic. | 2010-12-17T12:36:42Z | darkcashyz | ["Bass guitar", "Tapping (guitar technique)", "Effects unit", "Electric guitar", "Heavy metal", "Music", "Distortion"] | ["instrumental", "amplified guitar", "youthful", "spirited", "sonic power", "enthusiastic", "muddy", "muffled sound", "medium tempo", "loud electric guitar feedback", "vigorous", "poor audio quality", "boomy", "electric guitar lead", "string instrument", "rock", "metal", "hard rock", "youthful", "enthusiastic", "muddled audio", "home recording"] | 7 | 6ayVxYbKBe0 | 769 | ||
Amanaz - Green Apple. | This song is an electric guitar instrumental. The tempo is medium with two amplified guitars playing the lead and harmony respectively with steady drumming. The music is a simple, rhythmic, smooth and engaging Rock instrumental; | 2008-06-18T11:08:30Z | Mindfuckedproject | Awesome beat music from Zambia. Artist : Amanaz Song Title : Green Apple Album : Africa "Amanaz was formed in 1973. Three songs are in the native language Bemba, and 9 songs in English, recorded in Kitwe, the 3rd biggest city in Zambia up north. Musically, it goes in the same direction as Blo, The Witch and Question Mark, but this album is way cooler and stoned with amazing fuzz guitar all over which sounds like an African version of early Cream. The cover makes it look very traditional but after a few spins, you are aware that this one is very special. It's so cool, so tightly-produced and easily compares with UK underground albums with a touch of African beats." | ["Music", "Harmonic"] | ["electric guitar", "instrumental", "instrumental duet", "medium tempo", "distortion", "vibrato", "electric guitar lead", "electric guitar harmony", "steady drumming", "vibrations", "amplified guitars", "sonic power", "rock"] | 7 | I368EWBLIs4 | 1868 | |
PRS SE 245 Electric Guitar | This music is instrumental. The tempo is medium with a short,electric guitar riff and a male voice doing an introduction to a demo. The video is a tutorial/review of an electric guitar. | 2011-07-01T19:00:48Z | N Stuff Music | With a voice that is classic, eminently recordable and gig ready, the SE 245 is perfect for traditional single-cutaway players. The 24.5" scale length makes this instrument instantly comfortable to players who grew up using short scale guitars. Volume and tone controls for each pickup, a 3-way toggle and bird inlays are all standard appointments. Specifications: Body Top Wood: Maple Top and Flame Maple Veneer (no veneer on opaque finishes) Back Wood: Thick Mahogany Neck Number of Frets: 22 Scale Length: 24 1/2" Neck Wood: Mahogany Fretboard Wood: Rosewood Neck Shape: Wide Fat Fretboard Inlays: Birds Hardware/Electronics Bridge: PRS Designed Stoptail Tuners: PRS Designed Tuners Truss Rod Cover: "PRS" Hardware Type: Nickel Treble Pickup: PRS Designed SE 245 Treble Humbucker Bass Pickup: PRS Designed SE 245 Bass Humbucker Pickup Switching: Volume and Tone Control For Each Pickup and 3-Way Toggle Pickup Selector On Upper Bout . Join us on Facebook! https://www.facebook.com/NStuffmusic Checkout all of the videos on our Youtube channel! https://www.youtube.com/nstuffmusic Follow us on Twitter and stay up-to-date on all our deals! https://twitter.com/Nstuffmusic Wanna see what’s new? Follow us here. https://instagram.com/nstuffmusic Come visit us and check us out on Google. https://plus.google.com/+NstuffMusic N Stuff Music 468 Freeport Road Pittsburgh PA 15238 412-828-1003 https://www.NStuffMusic.com | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | ["instrumental", "medium tempo", "introduction", "evie’s", "mark lucas", "male voice speaking", "demo", "electric guitar tutorial", "loud", "sonic power", "amplified", "stringed instrument", "rock", "metal", "heavy meal", "hard rock"] | 7 | Ij1-640aafg | 1933 | |
Tri Stereo Chorus sound with Boss pedals | This music is an electric guitar solo. The tempo is medium with a haunting and lilting electric guitar riff.The music is minimalist with no accompaniment. It is youthful, energetic, passionate , melodic and pensive. | 2010-09-07T20:12:48Z | oneguitar | my way of faking the 80's tri stereo chorus sound using a Boss CE2, CS2, DD3, HR2, RV5 and FV500 volume pedal | ["Echo", "Music", "Distortion"] | ["instrumental", "electric guitar", "medium tempo", "rock", "metal", "soft rock", "tutorial", "experiment", "applied instruments", "external amplification", "sonic power", "loud feedback", "resonating", "vibrations", "home recording", "muffled audio", "electric guitar solo", "guitar riff"] | 7 | J7fVdG7Zd3A | 1970 | |
C Harmonic Minor with a G Phrygian Ending | This music clip is an electric guitar solo lead instrumental. The tempo is fast with the guitarist playing a very emphatic, intense riff. No other instruments have been used. The music is loud, intense, engaging and catchy. | 2006-08-08T20:49:22Z | ahmedgarcia | C harmonic Minor with a G Phrygian ending. | ["Effects unit", "Electric guitar", "Music", "Harmonic", "Distortion"] | ["electric guitar", "instrumental", "string instrument", "external amplification", "vibrations", "skilful", "pop", "jazz", "country", "blues", "heavy metal", "lead instrument", "medium tempo", "sonic power", "amplified guitar", "melodious", "minimal instrumentation", "rock", "hard rock", "intense", "loud", "powerful"] | 7 | kaabXWuPWRg | 4332 |
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;