musiccaps_details (view)
82 rows where search matches "guitar", musiccaps_aspects contains "electric guitar" and musiccaps_names contains "Musical instrument"
This data as json
musiccaps_names (array) >30 ✖
- Musical instrument · 82 ✖
- Music 79
- Guitar 75
- Plucked string instrument 69
- Effects unit 31
- Electric guitar 27
- Distortion 24
- Chorus effect 18
- Speech 17
- Reverberation 15
- Tapping (guitar technique) 12
- Electronic tuner 10
- Inside, small room 10
- Echo 9
- Bass guitar 7
- Strum 6
- Blues 5
- Acoustic guitar 4
- Heavy metal 4
- Rock music 4
- Drum kit 2
- Jazz 2
- Roll 2
- Steel guitar, slide guitar 2
- Bluegrass 1
- Cacophony 1
- Chainsaw 1
- Christian music 1
- Drum 1
- Flamenco 1
- …
musiccaps_aspects (array) >30 ✖
- electric guitar · 82 ✖
- instrumental 47
- guitar solo 21
- jam 21
- no singer 18
- single instrument 16
- male voice 14
- easygoing 13
- rock 13
- amplified guitar 10
- groovy 10
- medium tempo 10
- bass guitar 9
- clean sound 9
- no other instruments 9
- simple tune 9
- sonic power 9
- effect pedal 8
- no voices 8
- acoustic drums 7
- amateur recording 7
- live performance 7
- loud 7
- blues 6
- dreamy 6
- hard rock 6
- heavy metal 6
- metal 6
- powerful 6
- stringed instrument 6
- …
0 records
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;