musiccaps_details (view)
47 rows where search matches "guitar", musiccaps_names contains "Plucked string instrument" and musiccaps_names contains "Speech"
This data as json
musiccaps_aspects (array) 231 ✖
- male voice 18
- electric guitar 17
- tutorial 15
- low quality 12
- flat male vocal 11
- noisy 11
- instrumental 7
- jam 7
- male voice speaking 7
- medium tempo 7
- mono 7
- instructive speaking 5
- acoustic guitar 4
- amateur recording 4
- blues 4
- electric guitar lesson 4
- guitar lesson 4
- no other instruments 4
- no vocal melody 4
- simple tune 4
- single instrument 4
- stringed instrument 4
- amp 3
- banjo 3
- clean sound 3
- demonstration 3
- e-guitar 3
- easygoing 3
- electric guitar tutorial 3
- guitar solo 3
- metal 3
- no percussion 3
- passionate 3
- poor audio quality 3
- review 3
- rock 3
- sonic power 3
- amplified 2
- amplified instrument 2
- amplifier 2
- background voices 2
- bluegrass 2
- crunchy 2
- electric guitar melody 2
- electric guitar solo 2
- emotional 2
- energetic 2
- gear review 2
- gear showcase 2
- guitar strumming 2
- guitarist 2
- hard rock 2
- heavy metal 2
- instructional 2
- intense 2
- live recording 2
- loud 2
- moderate tempo 2
- narration 2
- powerful 2
- speaking 2
- 7th chord 1
- acoustic guitar arpeggio 1
- acoustic guitar solo melody 1
- acoustic guitar strummed chords 1
- acoustic rhythm guitar chords 1
- advertising 1
- amateur tourist video 1
- ambient 1
- ambient noises 1
- ambient room noises 1
- ambient street noise 1
- amp static 1
- amplified guitar 1
- announcement 1
- arpeggiated acoustic guitar 1
- arpeggiated acoustic guitar melody 1
- average audio quality 1
- background ambient noise 1
- background instrumental music 1
- banjo guitar melody 1
- bas]d audio quality 1
- breathing 1
- buzzing noise 1
- buzzy guitar amp 1
- catchy riff 1
- cheerful 1
- chorus 1
- clean electric guitar chords 1
- clear 1
- crowds laughing 1
- deep 1
- demo 1
- dense 1
- distorted 1
- distorted audio 1
- distorted electric guitar 1
- distortion 1
- distortion guitar 1
- double bass 1
- dreamy 1
- echo 1
- echoing uptempo electric guitar melody 1
- effect pedal 1
- electric guitar chords 1
- electric guitar demo 1
- electric guitar lead 1
- electric guitar riff 1
- electric guitar techniques 1
- emphatic 1
- evie’s 1
- exciting 1
- exotic 1
- fast tempo 1
- feedback noise 1
- female voice 1
- female voice speaking 1
- flamenco 1
- flanger unit 1
- foreign language 1
- fretboard sounds 1
- fruity male vocal 1
- fun 1
- funny 1
- gadget porn 1
- gentle playing 1
- groovy 1
- groovy bass 1
- groovy bass guitar 1
- guitar 1
- guitar demo 1
- guitar instruction 1
- guitar pedal demonstration 1
- guitar pedal effect 1
- guitar pick 1
- guitar player 1
- guitar rhythm 1
- guitar song 1
- guitar string tones 1
- guitar strings 1
- guitar technique 1
- guitar tutor 1
- guitar video blog 1
- guitarist talks 1
- hammer-on 1
- handicapped man 1
- happy 1
- hard-hitting 1
- heavy meal 1
- high pitched 1
- home music video 1
- home video 1
- humming noise 1
- inspiring 1
- instructional audio 1
- instructional clip 1
- instructive 1
- instrumental music 1
- introduction 1
- japanese dialogue 1
- japanese speaking 1
- jazz 1
- jovial 1
- learning electric guitar 1
- lesson intro 1
- lesson recording 1
- look ma no hands 1
- loud feed back 1
- male guide 1
- male guitar teacher 1
- male singer 1
- male speaking 1
- male talking 1
- male voice talkin 1
- man talking 1
- mandolin 1
- mark lucas 1
- mediocre audio quality 1
- medium to uptempo 1
- mellow 1
- mellow tune 1
- minor scale 1
- motivational 1
- never give 1
- no other instrument 1
- nylon string acoustic guitar 1
- nylon string guitar 1
- octave pedal 1
- octaves 1
- online guitar lessons 1
- online lessons 1
- overdriven guitar 1
- passionate male vocal 1
- picked 1
- pleasant 1
- plucking 1
- poor quality audio 1
- pop 1
- positive 1
- pull-off 1
- punchy snare 1
- relaxing 1
- retro pop 1
- reverb 1
- rich 1
- romantic mood 1
- sensual 1
- shimmering cymbals 1
- simple tunes 1
- single note melody 1
- single strum 1
- sitar 1
- skillful 1
- slide guitar lesson 1
- slurring 1
- smooth 1
- song cover 1
- speaking male 1
- spirited okay 1
- strength 1
- string bend technique 1
- strong voice 1
- talking 1
- tuning 1
- twang sounds 1
- unbalanced stereo 1
- upright bass 1
- vibrations 1
- youtube gear demonstration 1
- youtube guitar lessons 1
- youtube tutorial 1
musiccaps_names (array) 34 ✖
- Music 47
- Plucked string instrument · 47 ✖
- Speech · 47 ✖
- Musical instrument 46
- Guitar 43
- Acoustic guitar 12
- Electronic tuner 12
- Strum 10
- Bass guitar 8
- Electric guitar 8
- Inside, small room 7
- Effects unit 5
- Banjo 4
- Distortion 4
- Tapping (guitar technique) 4
- Chorus effect 3
- Echo 3
- Reverberation 3
- Bluegrass 2
- Country 2
- Flamenco 2
- Steel guitar, slide guitar 2
- Blues 1
- Bowed string instrument 1
- Grunge 1
- Harmonic 1
- Heavy metal 1
- Mandolin 1
- Outside, urban or manmade 1
- Progressive rock 1
- Rhythm and blues 1
- Rock music 1
- Sitar 1
- Theremin 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;