musiccaps_details (view)
81 rows where musiccaps_names contains "Distortion" and musiccaps_names contains "Guitar"
This data as json
musiccaps_aspects (array) >30 ✖
- instrumental 29
- electric guitar 27
- amateur recording 19
- low quality 17
- medium tempo 15
- e-guitar 14
- noisy 14
- jam 13
- guitar solo 11
- rock 11
- single instrument 11
- groovy 10
- no singer 10
- amplified guitar 7
- easygoing 6
- effect pedal 6
- energetic 6
- instrumental music 6
- mono 6
- no voices 6
- passionate 6
- electric guitar lead 5
- electric guitar solo 5
- home video 5
- reverb 5
- simple tune 5
- calm 4
- dreamy 4
- e-bass 4
- e-guitars 4
- …
musiccaps_names (array) 28 ✖
- Distortion · 81 ✖
- Guitar · 81 ✖
- Music 81
- Musical instrument 62
- Effects unit 58
- Plucked string instrument 54
- Electric guitar 39
- Chorus effect 26
- Reverberation 24
- Echo 14
- Tapping (guitar technique) 14
- Bass guitar 12
- Heavy metal 4
- Speech 4
- Blues 2
- Cacophony 2
- Harmonic 2
- Inside, small room 2
- Rock music 2
- Steel guitar, slide guitar 2
- Bowed string instrument 1
- Electronic tuner 1
- Mandolin 1
- Progressive rock 1
- Reggae 1
- Strum 1
- Theremin 1
- Wedding music 1
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;