musiccaps_details (view)
98 rows where search matches "guitar", musiccaps_aspects contains "acoustic drums" and musiccaps_aspects contains "e-bass"
This data as json
musiccaps_aspects (array) 242 ✖
- acoustic drums · 98 ✖
- e-bass · 98 ✖
- e-guitar 63
- uptempo 31
- male voice singing 19
- e-guitars 18
- amateur recording 17
- medium tempo 17
- medium to uptempo 17
- piano 16
- rock 13
- acoustic guitar 11
- female voice singing 9
- fast tempo 8
- pop 7
- reggae 7
- male voices singing 6
- energetic 5
- higher pitch 5
- higher register 5
- keys 5
- organ 5
- slow tempo 5
- rock&roll 4
- slow to medium tempo 4
- tambourine 4
- upbeat 4
- aggressive 3
- aggressive energy 3
- backing vocals 3
- backing voices 3
- brass section 3
- higher key 3
- male singer 3
- melancholic 3
- mid range 3
- positive energy 3
- rock/pop 3
- ska 3
- slide guitar 3
- strings 3
- synthesizer 3
- uplifting energy 3
- uplifting mood 3
- accordion 2
- acoustic piano 2
- background cheering 2
- background noises 2
- backing track 2
- bluesrock 2
- cheerful 2
- deeper male voice singing 2
- e-piano 2
- exstatic 2
- female voices singing 2
- good vibes 2
- guitars 2
- hard-rock 2
- male backing voices 2
- male voice singing/rapping 2
- male voice streaming 2
- mid-range 2
- percussion 2
- pop/rock 2
- poprock 2
- punkrock 2
- romantic 2
- saxophone 2
- sensual 2
- shaker 2
- synth pad 2
- 2 separate songs 1
- 2000s rock 1
- 90s/2000s 1
- acoustic guitars 1
- acoustic snare 1
- afrodance/funk 1
- alternative rock 1
- b ackground noises 1
- background-noises 1
- backing song 1
- bells 1
- blues/rock 1
- bongos 1
- castanets 1
- chainsaw noises 1
- cheerful energy 1
- cheerfull 1
- chimes 1
- christian rock 1
- clapping and cheering 1
- classic rock 1
- classical-rock 1
- comedic 1
- congas 1
- country-progrock 1
- country/blues/rock 1
- country/folk 1
- country/folk/ballad 1
- crowd cheering 1
- crowd cheering and clapping 1
- crowd laughing 1
- cuban ska 1
- dance 1
- dangerous 1
- dangerous atmosphere 1
- deeper voice singer 1
- digital soundeffects 1
- digital strings 1
- double-bass 1
- dreamy 1
- e-guiatars 1
- ecstatic 1
- electric organ 1
- electric piano 1
- electronic sounds 1
- epic 1
- erotic 1
- extatic energy 1
- female backing voice 1
- female backing voices 1
- female higher register voice 1
- female singer 1
- female sounding voice singing 1
- female teen voice singing 1
- female voice 1
- flamenco/ballad 1
- funk/jazz 1
- funk/rock 1
- funk/soul 1
- funky 1
- good vibrations 1
- goose sounds 1
- gospel 1
- gospel/blues 1
- gospel/folk 1
- guitar 1
- guitar/harp hybrid 1
- happy 1
- hardrock 1
- hardrock/metal 1
- harmonica 1
- heavy 1
- heavy metal 1
- high register voice 1
- high school rock 1
- highly aggressive and loud 1
- hiphop 1
- hiphop/breakbeats 1
- indie/rock 1
- indie7rock/pop 1
- intimate atmosphere 1
- jazz/ballad 1
- key pluck sound 1
- keyboard 1
- keyboard-strings 1
- laid back energy 1
- light positive and melancholic atmosphere 1
- low to higher register 1
- machine noises 1
- male 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 deeper voice talking/screaming 1
- male mid range singer 1
- male mid range voice singing 1
- male screaming /singing voice 1
- male singer screaming 1
- male soul voice singing 1
- male voice sample 1
- male voice screaming 1
- male voice screaming/rapping 1
- male voice singing midrange 1
- male voice talking 1
- male voices shouting 1
- mandolin 1
- maxican folkrock 1
- mediumto uptempo 1
- melancholic and light 1
- mideum to uptempo 1
- monster noises 1
- mood elevating 1
- motor racing sound 1
- new eritrean music 1
- old recording 1
- oriental string melody 1
- percussion's 1
- percussions 1
- pop/backgroundmusic 1
- post-rock 1
- progressive rock 1
- punk rock 1
- punk/heavy/rock 1
- punkrock/electronic 1
- r&b/love-ballad 1
- r&b/soul 1
- relaxing 1
- relaxing and positive vibe 1
- rock&roll/blues 1
- rock&roll/pop 1
- rock/rap 1
- rock/ska 1
- sad atmosphere 1
- saxophones 1
- scratching 1
- screaming voice sample 1
- semi professional recording 1
- shooting sound 1
- skarock 1
- slightly agressive 1
- slower tempo 1
- soul 1
- soul/blues/jazz 1
- soulful 1
- sound-effects 1
- spherical 1
- steel drums 1
- steeldrum 1
- synth 1
- synth lead sound 1
- synth sounds 1
- synth string sound 1
- synth-strings 1
- tambourine/shaker 1
- theremin 1
- traditional/far east 1
- trumpet/trombone 1
- trumpets 1
- violent sounds 1
- violin 1
- voices 1
- western/county 1
- wild 1
- wild energy 1
- yodel/folkmusic 1
- yodeling 1
- zitar 1
musiccaps_names (array) 84 ✖
- Music 91
- Angry music 13
- Ska 12
- Rock music 11
- Singing 11
- Independent music 9
- Reggae 9
- Musical instrument 8
- Psychedelic rock 7
- Rhythm and blues 6
- Soul music 6
- Swing music 6
- Christian music 5
- Funk 5
- Grunge 5
- Music of Africa 5
- Music of Latin America 5
- Plucked string instrument 5
- Song 5
- Drum 4
- Drum kit 4
- Guitar 4
- Happy music 4
- Heavy metal 4
- Percussion 4
- Progressive rock 4
- Rock and roll 4
- Bass drum 3
- Blues 3
- Country 3
- Electronic music 3
- Exciting music 3
- Gospel music 3
- Rimshot 3
- Snare drum 3
- Speech 3
- Afrobeat 2
- Cymbal 2
- Drum roll 2
- Jazz 2
- Pop music 2
- Punk rock 2
- Reverberation 2
- Scratch 2
- Steelpan 2
- Traditional music 2
- Accordion 1
- Acoustic guitar 1
- Applause 1
- Background music 1
- Bass guitar 1
- Chainsaw 1
- Christmas music 1
- Disco 1
- Distortion 1
- Duck 1
- Effects unit 1
- Electric piano 1
- Electronic organ 1
- Flamenco 1
- Folk music 1
- Hi-hat 1
- Hip hop music 1
- Inside, large room or hall 1
- Inside, small room 1
- Keyboard (musical) 1
- Organ 1
- Piano 1
- Pulse 1
- Quack 1
- Salsa music 1
- Sampler 1
- Sewing machine 1
- Shout 1
- Sigh 1
- Sitar 1
- Spray 1
- Steel guitar, slide guitar 1
- Tender music 1
- Theremin 1
- Wedding music 1
- Wind instrument, woodwind instrument 1
- Yell 1
- Yodeling 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;