musiccaps_details (view)
2 rows where musiccaps_aspects contains "intense", musiccaps_aspects contains "loud" and musiccaps_names contains "Electric guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- electric guitar 2
- hard rock 2
- instrumental 2
- intense · 2 ✖
- loud · 2 ✖
- medium tempo 2
- powerful 2
- rock 2
- accompanying music 1
- amateur recording 1
- amplified guitar 1
- amplified guitar 1
- background noises 1
- blues 1
- country 1
- dissonant 1
- enthusiastic 1
- external amplification 1
- heavy metal 1
- home recording 1
- jazz 1
- lead instrument 1
- melodious 1
- metal 1
- minimal instrumentation 1
- people talking 1
- people talking in the background 1
- pop 1
- rock instrumental 1
- skilful 1
- sonic power 1
- sonic power’ 1
- spirited 1
- string instrument 1
- vehement 1
- vibrations 1
- youthful 1
musiccaps_names (array) 6 ✖
- Electric guitar · 2 ✖
- Music 2
- Distortion 1
- Effects unit 1
- Harmonic 1
- Tapping (guitar technique) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Curt Mitchell Chop Shop Solo Rockoryon Cover | This music is an Electric Guitar instrumental. The tempo is fast with a dissonant background score . There is the sound of people talking in the background. The music is superimposed on a track which doesn’t seem to be in sync. The lead however is powerful, loud, intense and emphatic. This is a Rock Instrumental. | 2009-08-10T15:54:08Z | OR1ON Orion Meshorer | (RockOryon Cover - when I was 12 years old) This is a great solo from Curt Mitchell Chop Shop. working hard on this solo, has improved my playing tremendously. it still needs more refinement but I want to use this occasion and thank Dear Curt Mitchell for his great teachings. | ["Tapping (guitar technique)", "Electric guitar", "Music"] | ["instrumental", "electric guitar", "people talking in the background", "home recording", "amateur recording", "rock instrumental", "intense", "loud", "amplified guitar", "youthful", "enthusiastic", "vehement", "spirited", "sonic power’", "medium tempo", "background noises", "accompanying music", "people talking", "loud", "powerful", "intense", "rock", "hard rock", "metal", "dissonant"] | 7 | hBQFoDI3NMI | 4082 | |
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;