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