musiccaps_details (view)
79 rows where search matches "guitar" and musiccaps_aspects contains "instrumental music"
This data as json
musiccaps_names (array) >30 ✖
- Music 74
- Guitar 26
- Musical instrument 23
- Plucked string instrument 19
- Electric guitar 11
- Effects unit 10
- Blues 8
- Distortion 8
- Reverberation 7
- Chorus effect 6
- Rock music 6
- Tapping (guitar technique) 6
- Angry music 5
- Bass guitar 5
- Electronic tuner 4
- Heavy metal 4
- Progressive rock 4
- Acoustic guitar 3
- Banjo 3
- Country 3
- Inside, small room 3
- Psychedelic rock 3
- Sad music 3
- Steel guitar, slide guitar 3
- Accordion 2
- Bowed string instrument 2
- Cacophony 2
- Drum 2
- Flamenco 2
- Jazz 2
- …
musiccaps_aspects (array) >30 ✖
- instrumental music · 79 ✖
- medium tempo 45
- emotional 31
- passionate 30
- poor audio quality 29
- energetic 21
- exciting 21
- spirited 20
- groovy bass line 14
- groovy music 14
- guitar lead 14
- soloist 13
- guitar accompaniment 12
- live performance 12
- bad audio quality 11
- groovy 11
- groovy rhythm 11
- guitar solo 11
- percussive bass line 11
- romantic 11
- guitar strumming 9
- relaxing 9
- average audio quality 8
- slow tempo 8
- youthful 8
- adrenaline rush 7
- adventurous 7
- cymbals crashing 7
- home music video 7
- medium fast tempo 7
- …
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;