musiccaps_details (view)
81 rows where search matches "guitar", musiccaps_aspects contains "e-bass" and musiccaps_aspects contains "e-guitar"
This data as json
musiccaps_aspects (array) 224 ✖
- e-bass · 81 ✖
- e-guitar · 81 ✖
- acoustic drums 63
- uptempo 27
- amateur recording 16
- male voice singing 16
- piano 15
- medium to uptempo 14
- medium tempo 12
- rock 11
- fast tempo 9
- female voice singing 8
- reggae 8
- organ 6
- rock&roll 6
- energetic 5
- male voices singing 5
- pop 5
- upbeat 5
- drums 4
- slow to medium tempo 4
- tambourine 4
- uplifting mood 4
- acoustic guitar 3
- acoustic piano 3
- aggressive 3
- backing voices 3
- brass section 3
- keys 3
- percussion 3
- punkrock 3
- uplifting energy 3
- accordion 2
- aggressive energy 2
- background noises 2
- backing track 2
- backing vocals 2
- bongos 2
- deeper male voice singing 2
- digital drums 2
- female voices singing 2
- hard-rock 2
- higher pitch 2
- higher register 2
- male 2
- male backing voices 2
- male soul voice singing 2
- male voice streaming 2
- melancholic 2
- mid range 2
- mid-range 2
- old recording 2
- positive energy 2
- r&b/soul 2
- saxophone 2
- ska 2
- slide guitar 2
- slow tempo 2
- soulful 2
- synth 2
- synth pad 2
- synthesizer 2
- trumpets 2
- 90s/2000s 1
- acoustic drum 1
- acoustic drum loop 1
- acoustic drums and shaker 1
- acoustic drums/percussion's 1
- afrodance/funk 1
- agrgressive 1
- alternative rock 1
- atmospheric 1
- b ackground noises 1
- background cheering 1
- background cheering and screaming 1
- background-noises 1
- backing voice 1
- banjo 1
- bells 1
- blues/rock 1
- bluesrock 1
- brasssection 1
- chainsaw noises 1
- cheerful 1
- cheerful energy 1
- cheerfull 1
- chimes 1
- comedic 1
- congas 1
- country/blues/rock 1
- crowd cheering 1
- crowd cheering and clapping 1
- crowd laughing 1
- crowd screaming 1
- cuban ska 1
- cuica 1
- dance 1
- dangerous 1
- dangerous atmosphere 1
- deeper voice singer 1
- delay 1
- digital soundeffects 1
- digital strings 1
- double-bass 1
- dreamy 1
- e-piano 1
- ecstatic 1
- electric organ 1
- electric piano 1
- electronic sounds 1
- epic 1
- erotic 1
- exstatic 1
- female backing voice 1
- female higher register voice 1
- female soul voice 1
- female sounding voice singing 1
- female teen voice singing 1
- female voice 1
- flute 1
- funk/dance 1
- funk/jazz 1
- funk/r&b/jazz 1
- funk/rock 1
- funky 1
- good energetic vibes 1
- good vibes 1
- good vibrations 1
- goose sounds 1
- gospel/blues 1
- gospel/folk 1
- hardrock 1
- hardrock/metal 1
- harmonica 1
- harmony 1
- heavy metal 1
- high school rock 1
- higher key 1
- highly aggressive and loud 1
- hindi/pop 1
- hiphop 1
- hiphop/breakbeats 1
- indie7rock/pop 1
- intimate atmosphere 1
- jazz/ballad 1
- keyboard 1
- laid back energy 1
- latinmusic 1
- loud acoustic drums 1
- low to higher register 1
- male and female singer 1
- male and female singers 1
- male and female voices singing 1
- male backing vocals 1
- male backing voice 1
- male deep voice singing 1
- male deeper voice singing 1
- male deeper voice singing/screaming 1
- male mid range singer 1
- male singer 1
- male singer screaming 1
- male voice high register singing 1
- male voice sample 1
- male voice screaming 1
- male voice talking 1
- male voice talking/shouting 1
- maxican folkrock 1
- mediumto uptempo 1
- mideum to uptempo 1
- moderate tempo 1
- monster noises 1
- mood-lifting 1
- motor racing sound 1
- oriental string melody 1
- percussion's 1
- percussions 1
- pop/rock 1
- poprock 1
- positive vibe 1
- positive vibes 1
- progressive rock 1
- punkrock/electronic 1
- r&b/love-ballad 1
- r&b/reggae/soul 1
- relaxing and positive vibe 1
- relaxing vibe 1
- rock&roll/blues 1
- rock&roll/pop 1
- rock&roll/soul 1
- rock&rollmusic 1
- rock/pop 1
- rock/ska 1
- romantic 1
- saxophones 1
- scratching 1
- screaming voice 1
- screaming voice sample 1
- semi professional recording 1
- sensual 1
- shooting sound 1
- skarock 1
- song change 1
- soul 1
- soul/blues/jazz 1
- sound-effects 1
- spherical 1
- steel drums 1
- steeldrum 1
- string section 1
- synth lead sound 1
- synth pluck 1
- synth sounds 1
- synth strings 1
- synth-strings 1
- synthesizer lead sound 1
- tambourine/shaker 1
- traditional/far east 1
- trumpet/trombone 1
- two songs 1
- upright bass 1
- violent sounds 1
- voices 1
- western/county 1
- wild energy 1
musiccaps_names (array) 86 ✖
- Music 75
- Angry music 10
- Reggae 10
- Singing 9
- Ska 9
- Musical instrument 8
- Rock music 8
- Independent music 6
- Rhythm and blues 6
- Blues 5
- Funk 5
- Pop music 5
- Swing music 5
- Electronic music 4
- Guitar 4
- Music of Africa 4
- Rock and roll 4
- Soul music 4
- Afrobeat 3
- Christian music 3
- Drum 3
- Drum kit 3
- Heavy metal 3
- Music of Latin America 3
- Percussion 3
- Plucked string instrument 3
- Progressive rock 3
- Psychedelic rock 3
- Song 3
- Speech 3
- Bass drum 2
- Cymbal 2
- Echo 2
- Effects unit 2
- Gospel music 2
- Grunge 2
- Music of Asia 2
- Punk rock 2
- Rimshot 2
- Scratch 2
- Snare drum 2
- Steelpan 2
- Yell 2
- Accordion 1
- Acoustic guitar 1
- Applause 1
- Background music 1
- Bass guitar 1
- Chainsaw 1
- Country 1
- Dance music 1
- Disco 1
- Distortion 1
- Drum roll 1
- Duck 1
- Electric guitar 1
- Electric piano 1
- Electronic dance music 1
- Electronic organ 1
- Exciting music 1
- Folk music 1
- Happy music 1
- Hi-hat 1
- Hip hop music 1
- Inside, large room or hall 1
- Jazz 1
- Jingle (music) 1
- Keyboard (musical) 1
- Maraca 1
- Music of Bollywood 1
- Organ 1
- Piano 1
- Pulse 1
- Quack 1
- Radio 1
- Rattle (instrument) 1
- Roll 1
- Salsa music 1
- Sampler 1
- Shout 1
- Sigh 1
- Spray 1
- Traditional music 1
- Wedding music 1
- Whoop 1
- Wind instrument, woodwind instrument 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;