musiccaps_details (view)
73 rows where search matches "guitar", musiccaps_aspects contains "acoustic drums" and musiccaps_aspects contains "e-guitar"
This data as json
musiccaps_aspects (array) 195 ✖
- acoustic drums · 73 ✖
- e-guitar · 73 ✖
- e-bass 63
- uptempo 24
- amateur recording 17
- piano 13
- male voice singing 12
- medium to uptempo 12
- rock 11
- medium tempo 9
- fast tempo 8
- reggae 8
- female voice singing 6
- organ 6
- male voices singing 5
- rock&roll 5
- slow to medium tempo 5
- uplifting energy 5
- keys 4
- pop 4
- tambourine 4
- upbeat 4
- acoustic guitar 3
- aggressive 3
- backing track 3
- brass section 3
- energetic 3
- synthesizer 3
- uplifting mood 3
- acoustic piano 2
- aggressive energy 2
- background cheering 2
- background noises 2
- backing vocals 2
- bongos 2
- congas 2
- deeper male voice singing 2
- female voices singing 2
- higher pitch 2
- higher register 2
- male voice streaming 2
- mid range 2
- mid-range 2
- percussion 2
- poprock 2
- positive energy 2
- punkrock 2
- saxophone 2
- shaker 2
- ska 2
- slide guitar 2
- slow tempo 2
- synth pad 2
- 90s/2000s 1
- accordion 1
- afrodance/funk 1
- alternative rock 1
- b ackground noises 1
- background-noises 1
- background-noises/voices 1
- backing voices 1
- bass 1
- bells 1
- blues/rock 1
- bluesrock 1
- chainsaw noises 1
- cheerful 1
- cheerful energy 1
- cheerfull 1
- chimes 1
- comedic 1
- country/blues/rock 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
- djembe 1
- double-bass 1
- e-bass backround noises 1
- e-piano 1
- ecstatic 1
- electric organ 1
- electric piano 1
- electronic sounds 1
- epic 1
- erotic 1
- experimental 1
- exstatic 1
- female backing voice 1
- female higher register voice 1
- female sounding voice singing 1
- female teen voice singing 1
- female voice 1
- funk/jazz 1
- funk/rock 1
- funky 1
- good vibes 1
- good vibrations 1
- goose sounds 1
- gospel/blues 1
- gospel/folk 1
- happy 1
- hard-rock 1
- hardrock 1
- hardrock/metal 1
- harmonica 1
- heavy metal 1
- high school rock 1
- higher key 1
- highly aggressive and loud 1
- hiphop 1
- hiphop/breakbeats 1
- indie7rock/pop 1
- intimate atmosphere 1
- jazz/ballad 1
- karaoke 1
- keyboard 1
- laid back energy 1
- light sounding 1
- low to higher register 1
- male 1
- male and female singers 1
- male and female voices singing 1
- male backing vocals 1
- male backing voices 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 soul voice singing 1
- male voice sample 1
- male voice screaming 1
- male voice talking 1
- maxican folkrock 1
- medium uptempo 1
- mediumto uptempo 1
- melancholic 1
- mideum to uptempo 1
- monster noises 1
- motor racing sound 1
- old recording 1
- oriental sounding string instrument 1
- oriental string melody 1
- people cheering 1
- percussion's 1
- percussions 1
- poor sound-quality 1
- pop/rock 1
- progressive rock 1
- progrock 1
- punkrock/electronic 1
- r&b/love-ballad 1
- r&b/soul 1
- relaxing and positive vibe 1
- rock&roll/blues 1
- rock&roll/pop 1
- rock/pop 1
- rock/ska 1
- romantic 1
- saxophones 1
- scratching 1
- screaming voice sample 1
- semi professional recording 1
- sensual 1
- shooting sound 1
- skarock 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-strings 1
- synthesizer bit sound 1
- synthpop/rock 1
- tambourine/shaker 1
- traditional/far east 1
- trumpet/trombone 1
- trumpets 1
- violent sounds 1
- voices 1
- western/county 1
- wild energy 1
musiccaps_names (array) 81 ✖
- Music 66
- Angry music 10
- Rock music 10
- Singing 10
- Reggae 9
- Ska 9
- Musical instrument 6
- Independent music 5
- Rhythm and blues 5
- Swing music 5
- Blues 4
- Percussion 4
- Psychedelic rock 4
- Punk rock 4
- Christian music 3
- Drum 3
- Drum kit 3
- Electronic music 3
- Funk 3
- Guitar 3
- Heavy metal 3
- Music of Africa 3
- Plucked string instrument 3
- Progressive rock 3
- Rock and roll 3
- Song 3
- Soul music 3
- Afrobeat 2
- Bass drum 2
- Cymbal 2
- Duck 2
- Gospel music 2
- Grunge 2
- Inside, large room or hall 2
- Jazz 2
- Music of Latin America 2
- Pop music 2
- Quack 2
- Rimshot 2
- Scratch 2
- Snare drum 2
- Speech 2
- Steelpan 2
- A capella 1
- Accordion 1
- Acoustic guitar 1
- Applause 1
- Background music 1
- Bass guitar 1
- Chainsaw 1
- Chorus effect 1
- Country 1
- Disco 1
- Drum roll 1
- Echo 1
- Effects unit 1
- Electric guitar 1
- Electric piano 1
- Electronic organ 1
- Folk music 1
- Happy music 1
- Hi-hat 1
- Hip hop music 1
- Inside, public space 1
- Keyboard (musical) 1
- Organ 1
- Piano 1
- Pulse 1
- Rattle (instrument) 1
- Salsa music 1
- Sampler 1
- Shout 1
- Sigh 1
- Slosh 1
- Spray 1
- Traditional music 1
- Vocal music 1
- Wedding music 1
- Whoop 1
- Wind instrument, woodwind instrument 1
- Yell 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;