musiccaps_details (view)
46 rows where search matches "guitar", musiccaps_aspects contains "mono" and musiccaps_names contains "Musical instrument"
This data as json
musiccaps_aspects (array) 113 ✖
- low quality 46
- mono · 46 ✖
- noisy 45
- passionate 17
- tutorial 8
- cover 7
- flat male vocal 7
- emotional 6
- electric guitar melody 4
- groovy 4
- live performance 4
- arpeggiated electric guitar melody 3
- electric guitar solo melody 3
- groovy bass guitar 3
- passionate male vocal 3
- rock 3
- acoustic rhythm guitar chords 2
- arpeggiated acoustic guitar melody 2
- cool 2
- easygoing 2
- fun 2
- happy 2
- intense 2
- joyful 2
- playback 2
- relaxing 2
- reverberant 2
- soulful 2
- uptempo 2
- acoustic guitar melody 1
- acoustic guitar solo melody 1
- acoustic guitar strummed chords 1
- acoustic rhythm guitar 1
- acoustic rhythm guitar chords progression 1
- addictive electric guitar melody 1
- aggressive 1
- alternative/indie 1
- arpeggiated acoustic flamenco guitar melody 1
- arpeggiated electric guitar 1
- banjo guitar melody 1
- banjo solo melody 1
- bass guitar 1
- boogie 1
- boomy 1
- buzzy 1
- calming 1
- chill electric guitar melody 1
- chorus effect 1
- chorus pedal effect 1
- clean electric guitar chords 1
- clean electric guitar melody 1
- country 1
- distorted electric guitar solo melody 1
- distortion pedal effect 1
- dynamic bass guitar 1
- echoing effect 1
- echoing electric guitar arpeggiated melody 1
- echoing electric guitar melody 1
- electric guitar arpeggiated melody 1
- electric guitar chords 1
- electric rhythm guitar chords 1
- emotional electric guitar melody 1
- energetic 1
- energetic drums 1
- fading out 1
- finger style acoustic guitar melody 1
- flamenco guitar chord progression 1
- funky 1
- funky acoustic bass guitar solo melody 1
- funky blues acoustic guitar melody 1
- funky electric guitars melodies 1
- groovy bass 1
- groovy double bass 1
- guiros percussions 1
- guitar pedal effect 1
- guitar tap percussion 1
- heartfelt 1
- instrumental playback 1
- jazzy electric guitar melody 1
- mandolin solo melody 1
- manically arpeggiated steel guitar 1
- messy 1
- metronome 1
- monotone 1
- muddy 1
- mystical 1
- passionate electric guitar lick 1
- pedal tap sound effect 1
- phaser pedal effect 1
- pitch bend effect 1
- pitch change 1
- playback drums instrumental 1
- pop 1
- psychedelic 1
- raw innocent girl vocal 1
- reverb pedal effect 1
- sad 1
- shimmering 1
- shimmering cymbals 1
- simple acoustic guitar melody 1
- sliding effect 1
- sloppy acoustic rhythm guitar 1
- smooth bass 1
- soft 1
- soft female vocal 1
- spanish guitar solo melody 1
- strings creaking sound 1
- suspenseful 1
- sustained string melody 1
- synth bells melody 1
- tinny tap sound 1
- ukulele bass guitar 1
- weird 1
musiccaps_names (array) 31 ✖
- Music 46
- Musical instrument · 46 ✖
- Plucked string instrument 39
- Guitar 38
- Effects unit 11
- Bass guitar 9
- Chorus effect 9
- Acoustic guitar 8
- Inside, small room 8
- Speech 7
- Strum 6
- Reverberation 5
- Distortion 4
- Electric guitar 4
- Electronic tuner 4
- Mandolin 4
- Banjo 3
- Bluegrass 3
- Echo 3
- Singing 3
- Ukulele 3
- Blues 2
- Flamenco 2
- Jazz 2
- Steel guitar, slide guitar 2
- Tapping (guitar technique) 2
- Child singing 1
- Inside, large room or hall 1
- Percussion 1
- Swing music 1
- Toothbrush 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;