musiccaps_details (view)
49 rows where search matches "guitar", musiccaps_names contains "Musical instrument" and musiccaps_names contains "Speech"
This data as json
musiccaps_aspects (array) 246 ✖
- male voice 18
- electric guitar 17
- tutorial 14
- low quality 12
- flat male vocal 10
- noisy 10
- instrumental 7
- jam 7
- male voice speaking 7
- medium tempo 7
- mono 7
- amateur recording 5
- instructive speaking 5
- acoustic guitar 4
- blues 4
- e-guitar 4
- electric guitar lesson 4
- guitar lesson 4
- no other instruments 4
- no vocal melody 4
- passionate 4
- poor audio quality 4
- rock 4
- simple tune 4
- single instrument 4
- stringed instrument 4
- amp 3
- banjo 3
- clean sound 3
- demonstration 3
- easygoing 3
- electric guitar melody 3
- electric guitar tutorial 3
- guitar solo 3
- live recording 3
- metal 3
- no percussion 3
- review 3
- sonic power 3
- amplified 2
- amplified instrument 2
- amplifier 2
- background voices 2
- bluegrass 2
- crunchy 2
- electric guitar solo 2
- emotional 2
- energetic 2
- gear review 2
- gear showcase 2
- groovy 2
- groovy bass 2
- guitar strumming 2
- guitarist 2
- hard rock 2
- heavy metal 2
- instructional 2
- intense 2
- live performance 2
- loud 2
- moderate tempo 2
- narration 2
- powerful 2
- punchy snare 2
- speaking 2
- 7th chord 1
- accordion melody 1
- acoustic guitar arpeggio 1
- acoustic guitar solo melody 1
- acoustic guitar strummed chords 1
- acoustic rhythm guitar chords 1
- advertising 1
- alternative rock 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 melody 1
- average audio quality 1
- background ambient noise 1
- background instrumental music 1
- banjo guitar melody 1
- bas]d audio quality 1
- blues rock 1
- breathing 1
- buzzing noise 1
- buzzy guitar amp 1
- catchy riff 1
- cheerful 1
- cheering fans 1
- chorus 1
- clean electric guitar chords 1
- clear 1
- crowd chattering 1
- crowds laughing 1
- cuica 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
- e-bass 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 lick 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
- flute 1
- folk 1
- foreign language 1
- fretboard sounds 1
- fruity male vocal 1
- fun 1
- funny 1
- gadget porn 1
- gentle playing 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
- latinmusic 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
- male voice talking/shouting 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
- percussion 1
- picked 1
- pleasant 1
- plucking 1
- poor quality audio 1
- pop 1
- positive 1
- pull-off 1
- relaxing 1
- retro pop 1
- reverb 1
- rich 1
- romantic mood 1
- sensual 1
- shimmering cymbals 1
- shimmering hi hats 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
- uptempo 1
- vibrations 1
- youtube gear demonstration 1
- youtube guitar lessons 1
- youtube tutorial 1
musiccaps_names (array) 43 ✖
- Music 49
- Musical instrument · 49 ✖
- Speech · 49 ✖
- Plucked string 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
- Music of Latin America 2
- Rock music 2
- Accordion 1
- Blues 1
- Bowed string instrument 1
- Drum kit 1
- Grunge 1
- Harmonic 1
- Heavy metal 1
- Mandolin 1
- Orchestra 1
- Outside, urban or manmade 1
- Progressive rock 1
- Rattle (instrument) 1
- Rhythm and blues 1
- Rock and roll 1
- Shout 1
- Singing 1
- Sitar 1
- Steel guitar, slide guitar 1
- Theremin 1
- Traditional 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;