musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "electric guitar lead", musiccaps_aspects contains "fast tempo" and musiccaps_names contains "Guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- electric guitar 2
- electric guitar lead · 2 ✖
- fast tempo · 2 ✖
- instrumental 2
- metal 2
- rock 2
- sonic power 2
- amplified guitar 1
- amplified music 1
- blues 1
- clean notes 1
- demonstration 1
- dense 1
- electric guitar demo 1
- electric guitar harmony 1
- electric guitar lesson 1
- electric guitar riff 1
- electric guitar solo 1
- energetic 1
- hard rock 1
- hard rock instrumental 1
- heavy metal 1
- high spirited 1
- hoe recording 1
- home recording 1
- instructional 1
- intense 1
- jazz 1
- loud feed back 1
- loud guitar feedback 1
- …
musiccaps_names (array) 11 ✖
- Guitar · 2 ✖
- Music 2
- Musical instrument 2
- Plucked string instrument 2
- Bass guitar 1
- Chorus effect 1
- Distortion 1
- Effects unit 1
- Funk 1
- Speech 1
- Tapping (guitar technique) 1
youtube_published (date) 2 ✖
- 2007-07-11 1
- 2013-11-05 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
MXR M169 Carbon Copy Analoog Delay-Pedaal Review | Bax Music | This music is an electric guitar instrumental. The tempo is fast with an enthusiastic electric guitar riff with the voice of a man giving instructions. The music is powerful,emphatic, loud, groovy, youthful, skillful and engaging. This clip is an electric guitar lesson/tutorial. | 2013-11-05T13:48:04Z | Bax-shop | Bax Music Goes | Meer info: http://bax.sh/op/IypKPw Productspecialist Harry Maes bespreekt in deze video uitgebreid de MXR M169 Carbon Copy, een authentiek warm klinkend, analoog delay-pedaal met een delay tot wel 600 ms. De M169 Carbon Copy voorziet uw gitaar-geluid van die ouderwetse 'badkamer'-echo's of creëert de heerlijk trage Pink Floyd-achtige delays. Het gitaarpedaal - met dezelfde afmetingen en sterke behuizing als van bijvoorbeeld de klassieke Phase 90 - is instelbaar via drie draaiknoppen en twee interne regelingen. De M169 is dus weer een uiterst degelijke stompbox van MXR! Vond je deze video leuk? Vergeet je niet te abonneren op ons kanaal! Nederland: Webshop: https://www.bax-shop.nl Blog: https://www.bax-shop.nl/blog/ Trustpilot: https://nl.trustpilot.com/evaluate/www.bax-shop.nl Facebook: https://www.facebook.com/baxshopnl Instagram: https://www.instagram.com/baxmusicnl Twitter: https://twitter.com/baxshop België: Webshop: https://www.bax-shop.be Blog: https://www.bax-shop.be/blog/ Facebook: https://www.facebook.com/baxshopbe Instagram: https://www.instagram.com/baxmusicbe Twitter: https://twitter.com/baxshopbe #BaxMusic #WeSupportYourStage #mxr | ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Speech", "Plucked string instrument", "Distortion"] | ["instrumental", "fast tempo", "male voice speaking", "demonstration", "review", "electric guitar riff", "loud feed back", "sonic power", "amplified guitar", "stringed instrument", "rock", "metal", "jazz", "blues", "intense", "dense", "electric guitar lead", "electric guitar solo", "electric guitar demo", "electric guitar lesson", "tutorial", "instructional", "electric guitar", "smooth", "skillful", "passionate"] | 7 | cdUk-F-5NCI | 3727 |
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;