musiccaps_details (view)
40 rows where search matches "guitar", musiccaps_aspects contains "bass guitar" and musiccaps_aspects contains "instrumental"
This data as json
musiccaps_aspects (array) 177 ✖
- bass guitar · 40 ✖
- instrumental · 40 ✖
- no singer 19
- acoustic drums 17
- electric guitar 13
- guitar solo 9
- groovy 6
- live performance 5
- percussion 5
- piano 5
- slow tempo 5
- acoustic guitar 4
- backing track 4
- blues 4
- distorted electric guitar 4
- easygoing 4
- heavy metal 4
- jam 4
- lively 4
- upbeat 4
- vibrant 4
- acoustic sounding drums 3
- aggressive 3
- chill 3
- energetic 3
- hard-hitting 3
- joyful 3
- keyboard 3
- loud 3
- orchestra 3
- playful 3
- accordion 2
- amateur recording 2
- cheerful 2
- clean sound 2
- complex 2
- drums 2
- eccentric 2
- electronic drums 2
- folk dance 2
- funk 2
- jazz 2
- melodic 2
- no voice 2
- no voices 2
- rock music 2
- single instrument 2
- soft 2
- solo 2
- soothing 2
- sound effects 2
- strings 2
- trumpet 2
- trumpets 2
- ukulele 2
- unsettling 2
- violent 2
- weird 2
- acoustic jazz drums 1
- adventurous 1
- agitated 1
- airy 1
- almost fast tempo 1
- arabic 1
- balkan music 1
- bebop jazz 1
- boomy bass drops 1
- bossa nova 1
- brass 1
- calm 1
- calming 1
- cello 1
- childlike 1
- clean electric guitar 1
- comedy 1
- compound meter 1
- creepy 1
- crunchy 1
- danceable 1
- delay 1
- dub 1
- eastern sounding 1
- easy listening 1
- echo 1
- effect pedal 1
- electric guitar harmony 1
- fast tempo 1
- female lead vocalisation 1
- female vocalisation 1
- fiddle 1
- fiddle solo 1
- flute 1
- fusion genre 1
- gear 1
- generic 1
- glockenspiel 1
- goofy 1
- happy mood 1
- hard 1
- harmonica 1
- harmonica solo 1
- harp 1
- heart-touching 1
- heavily effected 1
- hindi film music 1
- improvisation 1
- instructional song 1
- irish folk music 1
- jazz music 1
- jazz song 1
- keyboard harmony 1
- kids show theme 1
- latin music 1
- laughing track 1
- light-hearted 1
- loud acoustic drums 1
- male voice backup vocalisation 1
- mandolin 1
- melancholic 1
- mellow 1
- moderate tempo 1
- movie music 1
- movie theme 1
- ney 1
- no other instruments 1
- occult rock 1
- ominous 1
- organ 1
- oud 1
- outer space 1
- overdriven 1
- phaser effect 1
- poor quality 1
- pop-rock 1
- positive 1
- profound 1
- progressive metal music 1
- psychedelic rock 1
- punjabi film music 1
- punk rock 1
- qanun 1
- raw 1
- relaxing 1
- repeated theme 1
- robotic sound effects 1
- rock and roll 1
- rock-n-roll 1
- romance 1
- saxophone 1
- saxophones 1
- sensual 1
- shifting sound 1
- shredding 1
- simple tune 1
- sinister 1
- slap technique 1
- slick drumming 1
- space disco 1
- star wars 1
- story-telling mood 1
- strummed acoustic guitar 1
- swing 1
- synth 1
- synth pedal 1
- tapping 1
- theremin 1
- three unrelated tracks 1
- tranquil 1
- trombones 1
- unique 1
- unnerving 1
- video game music 1
- violin 1
- virtual sounds 1
- western music 1
- white noise 1
- wind band 1
musiccaps_names (array) 63 ✖
- Music 28
- Guitar 9
- Musical instrument 9
- Plucked string instrument 9
- Blues 4
- Brass instrument 3
- Distortion 3
- Electric guitar 3
- Funk 3
- Heavy metal 3
- Jazz 3
- Progressive rock 3
- Wind instrument, woodwind instrument 3
- Accordion 2
- Bass guitar 2
- Bluegrass 2
- Country 2
- Drum 2
- Echo 2
- Effects unit 2
- Harmonica 2
- Percussion 2
- Punk rock 2
- Salsa music 2
- Saxophone 2
- Strum 2
- Ukulele 2
- Acoustic guitar 1
- Angry music 1
- Bass drum 1
- Clarinet 1
- Cymbal 1
- Disco 1
- Drum kit 1
- Drum roll 1
- Electric piano 1
- Electronic tuner 1
- Flamenco 1
- Flute 1
- Hammond organ 1
- Hi-hat 1
- Inside, small room 1
- Jingle, tinkle 1
- Keyboard (musical) 1
- Music of Latin America 1
- Organ 1
- Piano 1
- Radio 1
- Rimshot 1
- Rock and roll 1
- Rock music 1
- Roll 1
- Scratch 1
- Snare drum 1
- Swing music 1
- Synthesizer 1
- Tabla 1
- Theremin 1
- Timpani 1
- Trombone 1
- Trumpet 1
- Violin, fiddle 1
- Wedding music 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;