musiccaps_details (view)
97 rows where search matches "guitar", musiccaps_aspects contains "instrumental" and musiccaps_author = 9
This data as json
musiccaps_aspects (array) 271 ✖
- instrumental · 97 ✖
- no singer 60
- electric guitar 45
- bass guitar 34
- guitar solo 34
- jam 29
- acoustic guitar 26
- easygoing 25
- single instrument 25
- acoustic drums 21
- effect pedal 13
- groovy 13
- simple tune 10
- lively 9
- piano 8
- trippy 8
- aggressive 7
- clean sound 7
- complex 7
- distorted electric guitar 7
- electronic drums 7
- joyful 7
- keyboard 7
- amateur recording 6
- dreamy 6
- hard-hitting 6
- live performance 6
- mellow 6
- percussion 6
- relaxing 6
- simple tunes 6
- blues 5
- calm 5
- calming 5
- echo 5
- heavy metal 5
- loud 5
- psychedelic 5
- rock music 5
- slow tempo 5
- upbeat 5
- vibrant 5
- accordion 4
- acoustic sounding drums 4
- backing track 4
- chill 4
- cover 4
- crunchy 4
- energetic 4
- gentle 4
- mandolin 4
- orchestra 4
- playful 4
- progressive rock 4
- reverb 4
- shredding 4
- solo 4
- cheerful 3
- eccentric 3
- fiddle 3
- flamenco 3
- flute 3
- folk dance 3
- funk 3
- gear showcase 3
- generic 3
- gentle playing 3
- melodic 3
- poor quality 3
- repeated theme 3
- sensual 3
- soothing 3
- strings 3
- tapping 3
- violent 3
- violin 3
- banjo 2
- bluegrass 2
- cello 2
- chorus 2
- clean sounding 2
- cozy 2
- danceable 2
- delay 2
- exotic 2
- improvisation 2
- irish folk music 2
- jazz 2
- jingle 2
- meditation music 2
- medium tempo 2
- mellow tune 2
- movie music 2
- optimistic 2
- overdriven electric guitar 2
- progressive metal 2
- raw 2
- romantic 2
- soft 2
- sound effects 2
- steady tempo 2
- synth 2
- theremin 2
- trumpet 2
- ukulele 2
- unique 2
- unsettling 2
- vibrato 2
- weird 2
- 80s sound 1
- acoustic 1
- acoustic jazz drums 1
- adventurous 1
- advertisement 1
- agitated 1
- alpine folk music 1
- ambient synth 1
- american 1
- amp plug 1
- anticipation 1
- arabic 1
- arpeggio 1
- balkan music 1
- bass 1
- bebop jazz 1
- bossa nova 1
- brass 1
- carnatic 1
- childlike 1
- chinese 1
- chorus ensemble 1
- clarinet 1
- classical 1
- classical music 1
- clean electric guitar 1
- comedy 1
- common 1
- compilation 1
- country music 1
- creepy 1
- delicate 1
- drill sounds 1
- dub 1
- eastern 1
- eastern sounding 1
- echo delay 1
- effects 1
- electric guitar sound 1
- electronic 1
- electropop 1
- emotional 1
- exercise 1
- fast tempo 1
- fast-paced 1
- fiddle solo 1
- flanger pedal 1
- folk 1
- folk music 1
- free stroke 1
- fun 1
- gear 1
- glockenspiel 1
- goofy 1
- granular synth 1
- guitar cover 1
- hard 1
- harmonica 1
- harmonica solo 1
- harp 1
- heart-touching 1
- high gain distortion 1
- hindi film music 1
- hypnotic 1
- indie 1
- instructive 1
- interesting 1
- irish 1
- italian folk music 1
- j-pop 1
- jazz music 1
- kids show theme 1
- latin 1
- latin dance 1
- laughing track 1
- light-hearted 1
- live recording 1
- loud acoustic drums 1
- lounge 1
- major key 1
- male voice 1
- maracas 1
- math rock 1
- melancholic 1
- movie theme 1
- mysterious 1
- napoletana 1
- neo-soul 1
- new-age 1
- ney 1
- occult rock 1
- ominous 1
- organ 1
- oud 1
- outer space 1
- outer space feel 1
- overdriven 1
- pastoral 1
- percussive elements 1
- percussive slap 1
- piano sample 1
- picado 1
- ping sound effect 1
- pitch shift 1
- pop 1
- pop music 1
- pop-rock 1
- positive 1
- power metal 1
- profound 1
- progressive metal music 1
- punjabi film music 1
- punk rock 1
- qanun 1
- random 1
- rapid 1
- rehearsal 1
- repeating theme 1
- rhythmic 1
- rising 1
- robotic sound effects 1
- rock 1
- rock and roll 1
- rock-n-roll 1
- romance 1
- romanian folk music 1
- rural 1
- saxophone 1
- shifting sound 1
- simple 1
- sinister 1
- slap technique 1
- soap opera soundtrack 1
- space disco 1
- spanish 1
- speed metal 1
- star wars 1
- steel guitar 1
- story-telling mood 1
- suspense 1
- swing 1
- synth bass 1
- synth pedal 1
- synth strings 1
- synth-pop 1
- tailpiece 1
- tango 1
- tarantella 1
- tender 1
- tranquil 1
- trumpets 1
- tv series theme 1
- uilleann pipes 1
- unnerving 1
- uplifting 1
- upright bass 1
- video game music 1
- vigorous 1
- virtual sounds 1
- western music 1
- wind band 1
- xiao 1
musiccaps_names (array) 89 ✖
- Music 79
- Guitar 42
- Musical instrument 38
- Plucked string instrument 33
- Distortion 18
- Effects unit 17
- Electric guitar 17
- Echo 11
- Reverberation 9
- Acoustic guitar 8
- Strum 8
- Flamenco 7
- Bluegrass 6
- Heavy metal 6
- Wind instrument, woodwind instrument 6
- Rock music 5
- Tapping (guitar technique) 5
- Accordion 4
- Blues 4
- Chorus effect 4
- Flute 4
- Inside, small room 4
- Progressive rock 4
- Banjo 3
- Bass guitar 3
- Bowed string instrument 3
- Brass instrument 3
- Electric piano 3
- Electronic tuner 3
- Keyboard (musical) 3
- Piano 3
- Steel guitar, slide guitar 3
- Theremin 3
- Drum 2
- Harmonica 2
- Jazz 2
- Mandolin 2
- Music of Bollywood 2
- Music of Latin America 2
- New-age music 2
- Percussion 2
- Punk rock 2
- Saxophone 2
- Ukulele 2
- Violin, fiddle 2
- Angry music 1
- Background music 1
- Bass drum 1
- Cacophony 1
- Carnatic music 1
- Cello 1
- Clarinet 1
- Country 1
- Cymbal 1
- Dental drill, dentist's drill 1
- Disco 1
- Drum kit 1
- Drum roll 1
- Electronica 1
- Folk music 1
- Funk 1
- Gospel music 1
- Grunge 1
- Hammond organ 1
- Harmonic 1
- Hi-hat 1
- Independent music 1
- Jingle, tinkle 1
- Organ 1
- Rimshot 1
- Rock and roll 1
- Roll 1
- Sad music 1
- Salsa music 1
- Scratch 1
- Snare drum 1
- Soul music 1
- Speech 1
- Steelpan 1
- Swing music 1
- Synthesizer 1
- Tabla 1
- Timpani 1
- Traditional music 1
- Trombone 1
- Trumpet 1
- Vibraphone 1
- Wedding music 1
- Zipper (clothing) 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;