musiccaps_details (view)
71 rows where search matches "guitar" and musiccaps_author = 3 sorted by youtube_description
This data as json
musiccaps_aspects (array) 398 ✖
- live recording 14
- rock 10
- acoustic guitar 8
- acoustic guitar arpeggio 7
- live performance 7
- blues 6
- electric guitar 5
- energetic 5
- hard rock 5
- mellow 5
- ballad 4
- dance 4
- electric guitar arpeggio 4
- electric guitar licks 4
- harmonica 4
- alternative rock 3
- country blues 3
- electric guitar lick 3
- electric guitar riff 3
- emotional 3
- groovy 3
- grungy electric guitar 3
- hip hop 3
- overdriven electric guitar 3
- peaceful 3
- poor audio quality 3
- reverb 3
- rock music 3
- slide guitar 3
- soothing 3
- upbeat 3
- acoustic guitar arpeggios 2
- acoustic guitar strumming 2
- arpeggio 2
- charged up 2
- chord arpeggios 2
- country 2
- country rock 2
- electric guitar solo 2
- electric guitar stabs 2
- electric guitar strumming 2
- exciting 2
- four on the floor 2
- funky 2
- gentle male vocal 2
- hi-hats 2
- indie rock 2
- jazzy 2
- latin american music 2
- low quality audio 2
- male speaking 2
- mysterious 2
- nylon string guitar 2
- piano chords 2
- relaxing 2
- reverb effect 2
- rock drumming 2
- simple drumming 2
- sitar 2
- slow tempo 2
- soulful 2
- southern 2
- string instruments 2
- tambourine 2
- traditional middle eastern music 2
- twangy electric guitar 2
- 2000s hip hop 1
- accordion 1
- acoustic guitar licks 1
- acoustic guitar playing 1
- acoustic guitars 1
- alarm clock 1
- alarm clock beeping 1
- angelic female vocal humming 1
- arabic inspired 1
- atmospheric pad synth 1
- atmospheric sustained synth pad 1
- background ambient noise 1
- background noise 1
- banjo 1
- banjos 1
- bansuri 1
- bass guitar 1
- beeping 1
- beeping tone 1
- black metal 1
- blues guitar 1
- blues licks 1
- blues rock 1
- bluesy electric guitar tone 1
- bluesy guitar chords 1
- bluesy guitar playing 1
- bluesy harmonica playing 1
- bongo drums 1
- bouncy 1
- bouncy piano chord progression 1
- breakdown section 1
- bright blues lick 1
- bright brass sounding instruments 1
- bright flanger synth 1
- bright synths 1
- bright tinny ringing sound 1
- build-up 1
- burly raspy male vocal 1
- button pressing 1
- calm 1
- calm atmosphere 1
- calm female vocal 1
- calm song 1
- calming 1
- car door closing 1
- car door opening 1
- car sound 1
- car starting 1
- cello 1
- charismatic fiery male rapper 1
- charming vocalist 1
- cheerful 1
- cheering fans 1
- chill 1
- chord ringing out 1
- chorus pedal 1
- chorus pedal effect 1
- christian choral backing vocals 1
- christian worship music 1
- cinematic 1
- clarinet 1
- cocophony 1
- coming of age movie 1
- complex electric guitar playing 1
- complex synth arpeggio melodies 1
- contemporary pop dance 1
- contemporary rock 1
- country ballad 1
- country folk music 1
- country guitar 1
- country music 1
- country western 1
- country-folk 1
- crackling effect 1
- crackling sound 1
- croaky male voice 1
- crunchy electric guitar chords 1
- crunchy electric guitar strumming 1
- dance music 1
- dark 1
- dense guitar playing 1
- desperate male voice 1
- disco 1
- disco bassline 1
- distant country rock music 1
- distant electric guitar riff 1
- distorted audio 1
- distorted electric guitar 1
- distorted guitar chords 1
- distortion 1
- double bass 1
- eastern music 1
- elderly raspy male country vocal 1
- electric bass guitar playing 1
- electric bass guitar 1
- electric bass guitar bassline 1
- electric bass guitar playing 1
- electric guitar chord plucking 1
- electric guitar motif 1
- electric guitar playing 1
- electric guitar plucking 1
- electric guitar power chord strumming 1
- electric guitar power chords 1
- electric keyboard 1
- electronic dance music 1
- emotional song 1
- energetic emo vocalist 1
- energy building 1
- engine choking 1
- enigmatic male vocalist 1
- epic 1
- ethereal female vocal 1
- fairytale 1
- falsetto child's vocal 1
- fantasy 1
- fast bass playing 1
- fast paced bass guitar playing 1
- fast paced electric guitar arpeggios 1
- female soulful vocal 1
- fiery 1
- filtered vocal humming 1
- fire crackling 1
- flamenco guitarists 1
- flamenco style guitar playing 1
- flute 1
- folk harmonies 1
- folk inspired 1
- folk rock 1
- foot stomping percussion 1
- french inspired 1
- funk 1
- funky guitar playing 1
- funky rhythmic bassline 1
- fuzzy electric guitar 1
- fuzzy electric guitars 1
- glass breaking sound 1
- gritty 1
- gritty electric guitar strumming 1
- grungy 1
- grungy electric guitar chord strumming 1
- grungy electric guitar strumming 1
- grungy gritty electric guitar 1
- grungy guitar strumming 1
- guitar 1
- guitar arpeggios 1
- guitar layers 1
- guitar riff 1
- guitar strumming 1
- happy 1
- hard metal 1
- harpsichord 1
- haunting 1
- heavy grungy electric guitar strumming 1
- high octane 1
- high pitched 1
- high pitched beeping tone 1
- high pitched child's vocal 1
- high pitched string-synth 1
- high pitched tone 1
- hip hop drum pattern 1
- home recording 1
- indie alternative vocal 1
- intense 1
- intricate acoustic guitar playing 1
- intricate bassline 1
- intricate electric guitar lick 1
- intricate electric guitar licks 1
- intricate electric guitar playing 1
- intricate electric guitar solo 1
- intricate guitar playing 1
- intricate rock electric guitar 1
- intricate steel guitar playing 1
- intricate walking bassline 1
- italian singing 1
- japanese dialogue 1
- japanese speaking 1
- jazz 1
- jazzy electric guitar licks 1
- joyful 1
- kick drum 1
- laid-back jazzy rock 1
- lap steel guitar 1
- latin inspired 1
- live singer 1
- loud thumping 1
- low audio quality 1
- low trumpet-like synth 1
- maghreb pop 1
- major key 1
- male guide 1
- marimba 1
- medium tempo 1
- medtiation music 1
- melodic 1
- metal 1
- metal clanging 1
- metal ringing sound 1
- metal rock 1
- metal song 1
- metallic electric guitar 1
- metallic electric guitar riff 1
- metallic guitar 1
- mexican regional music 1
- minor key 1
- minor scale 1
- missed guitar notes 1
- muffled male voice 1
- muffled recording 1
- ney instrument 1
- nursery rhyme 1
- objects falling 1
- off-pitch guitar playing 1
- off-tune notes 1
- open-mouthed humming 1
- orchestral music 1
- organ chords 1
- out of tune guitar 1
- overdrive 1
- overdrive effect 1
- pad synth 1
- percussive chime 1
- piano 1
- piano chord playing 1
- piano melody 1
- piano motif 1
- poor quality audio 1
- pop 1
- pop ballad 1
- pop cover 1
- pop rock 1
- potent 1
- powerful guitar stabs 1
- powerful rich female vocal 1
- punchy drumming 1
- punk 1
- punk rock 1
- rap rock 1
- rapid kick drum 1
- raspy croacky male rock vocal 1
- raspy male rap vocal 1
- raspy male rock vocal 1
- raspy male vocalist 1
- raspy male voice 1
- recorded outside 1
- reflective 1
- reggae pop 1
- repeated piano arpeggio 1
- repeated progression 1
- repeated riff 1
- repeated vocal motif 1
- retro video game beeping sounds 1
- rhythmic rapid bass playing 1
- ride cymbals 1
- ringing 1
- rock power ballad 1
- romantic 1
- romantic spanish singing 1
- saxophone 1
- sensual high pitched female vocal 1
- silky male baritone vocal 1
- simple blues drum beat 1
- simple bluesy drum beat 1
- simple drum beat 1
- simple guitar playing 1
- simple hip hop drum beat 1
- simple jazzy drum beat 1
- simple jazzy drumming 1
- simple jazzy rock drumming 1
- simple rock drum beat 1
- simple rock drumming 1
- singer songwriter 1
- skateboarding sounds 1
- slow country music 1
- smooth 1
- smooth dance 1
- smooth male r&b vocal 1
- soft electric guitar 1
- soft rock ballad 1
- solo electric guitar 1
- soothing and gentle music 1
- soothing ballad 1
- soothing indian male vocal 1
- soothing song 1
- soulful female vocal 1
- soulful vocal refrain 1
- sound of footsteps 1
- sound of pealing 1
- sounds of footsteps 1
- south asian ballad 1
- southern country gospel music 1
- spanish singer 1
- speaking male 1
- speaking man 1
- spoken word 1
- sports car engine whirring 1
- squishy sound 1
- steel guitar 1
- steel hammering 1
- storytelling style singing 1
- string bend technique 1
- sultry 1
- sustained beeping tone 1
- sustained buzzing sound 1
- sustained chord strum 1
- sustained note 1
- synth pad 1
- traditional south asian music 1
- tranquil 1
- tropical 1
- tube screamer pedal 1
- tutorial 1
- tutorial video 1
- twangy electric guitar arpeggios 1
- twangy female vocalist 1
- twangy high pitched licks 1
- twelve bar blues 1
- upbeat jazzy music 1
- upright 1
- upright bass guitar 1
- vibrant 1
- vibrant female pop vocal 1
- vibrant piano playing 1
- vibrant soulful male vocal 1
- video game 1
- vintage country 1
- violin lick 1
- violins 1
- vocables 1
- warm sounding guitar tone 1
- warm synth chord stabs 1
- young male speaking 1
- youthful 1
musiccaps_names (array) 93 ✖
- Music 59
- Plucked string instrument 17
- Guitar 14
- Musical instrument 14
- Steel guitar, slide guitar 7
- Country 5
- Effects unit 5
- Acoustic guitar 4
- Blues 4
- Middle Eastern music 4
- Rock music 4
- Speech 4
- Strum 4
- Chorus effect 3
- Electric guitar 3
- Flamenco 3
- Funk 3
- Heavy metal 3
- Progressive rock 3
- Reverberation 3
- Rock and roll 3
- Tapping (guitar technique) 3
- Vocal music 3
- Wind instrument, woodwind instrument 3
- Bass guitar 2
- Bowed string instrument 2
- Brass instrument 2
- Distortion 2
- Drum kit 2
- Exciting music 2
- Harmonic 2
- Harmonica 2
- Independent music 2
- Jazz 2
- Mandolin 2
- Pop music 2
- Punk rock 2
- Saxophone 2
- Singing 2
- Sitar 2
- Soul music 2
- Theme music 2
- Wedding music 2
- Afrobeat 1
- Alarm 1
- Alarm clock 1
- Ambient music 1
- Angry music 1
- Bass drum 1
- Bluegrass 1
- Breaking 1
- Cacophony 1
- Cello 1
- Chant 1
- Chink, clink 1
- Crunch 1
- Cymbal 1
- Disco 1
- Double bass 1
- Drum 1
- Drum roll 1
- Electric piano 1
- Electronic music 1
- Electronic tuner 1
- Folk music 1
- Grunge 1
- Happy music 1
- Harp 1
- Hi-hat 1
- Humming 1
- Inside, small room 1
- Keyboard (musical) 1
- Music for children 1
- Music of Bollywood 1
- New-age music 1
- Percussion 1
- Piano 1
- Pizzicato 1
- Psychedelic rock 1
- Reggae 1
- Rimshot 1
- Rumble 1
- Sad music 1
- Salsa music 1
- Scratching (performance technique) 1
- Shout 1
- Skateboard 1
- Snare drum 1
- Song 1
- Soundtrack music 1
- Trombone 1
- Trumpet 1
- Ukulele 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;