musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "external amplification", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- electric guitar 2
- external amplification · 2 ✖
- instrumental 2
- medium tempo · 2 ✖
- rock · 2 ✖
- sonic power 2
- vibrations 2
- amplified guitar 1
- applied instruments 1
- blues 1
- country 1
- electric guitar solo 1
- experiment 1
- guitar riff 1
- hard rock 1
- heavy metal 1
- home recording 1
- intense 1
- jazz 1
- lead instrument 1
- loud 1
- loud feedback 1
- melodious 1
- metal 1
- minimal instrumentation 1
- muffled audio 1
- pop 1
- powerful 1
- resonating 1
- skilful 1
- …
musiccaps_names (array) 6 ✖
- Distortion 2
- Music 2
- Echo 1
- Effects unit 1
- Electric guitar 1
- Harmonic 1
youtube_published (date) 2 ✖
- 2006-08-08 1
- 2010-09-07 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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;