musiccaps_details (view)
54 rows where search matches "guitar", musiccaps_aspects contains "male voice" and musiccaps_author = 0
This data as json
musiccaps_aspects (array) 180 ✖
- male voice · 54 ✖
- moderate tempo 32
- bass 17
- happy mood 12
- percussion 12
- simple percussion 12
- guitar 11
- no percussion 10
- slow tempo 10
- distortion guitar 9
- acoustic guitar 8
- amateur recording 7
- low quality audio 7
- electric guitar 6
- no other instruments 6
- guitar song 5
- narration 5
- distortion guitars 4
- folk song 4
- foreign language 4
- hand claps 4
- minimal instruments 4
- no vocal melody 4
- reggae song 4
- romantic mood 4
- romantic theme 4
- tambourine 4
- vocal harmony 4
- aggressive percussion 3
- alternative rock 3
- bass guitar 3
- double bass 3
- fast tempo 3
- heavy metal 3
- overdriven guitar 3
- piano song 3
- repetitive melody 3
- shaker 3
- slow rock 3
- backing voice 2
- backing voices 2
- blues song 2
- country song 2
- emotive voice 2
- funk bass 2
- instructional audio 2
- instructional clip 2
- keyboard 2
- live recording 2
- low quality recording 2
- male backing voice 2
- no other instrument 2
- pop song 2
- rock song 2
- romantic song 2
- slow song 2
- trumpets 2
- upbeat 2
- upbeat song 2
- violin 2
- vocables 2
- 7th chord 1
- acoustic gutiar 1
- angry voice 1
- announcement 1
- ballad 1
- banjo 1
- banjo song 1
- basic percussion 1
- bass notes 1
- bassline 1
- bells 1
- bluegrass 1
- calming voice 1
- cash register sound 1
- celebration song 1
- children's song 1
- children's voice 1
- comforting song 1
- country rock 1
- crossover song 1
- dance song for children 1
- defiant voice 1
- descending chords 1
- descendling scale pattern 1
- disco song 1
- double stop 1
- drums 1
- duet 1
- easy listening 1
- eerie 1
- emotional song 1
- emotional voice 1
- fast guitar strums 1
- female backing voices 1
- female voice 1
- fingerstyle guitar 1
- funk song 1
- gallopping guitar 1
- glam rock 1
- goth metal 1
- gothic rock 1
- groovy bass 1
- groovy bassline 1
- guitar fills 1
- guitar instruction 1
- guitar instructional clip 1
- guitar lead 1
- guitar lesson 1
- guitar playing octaves 1
- guitar scratching 1
- guitar strums 1
- guitar tron effect 1
- happy song 1
- hard rock 1
- heartbeat 1
- heavy metal song 1
- heavy percussion 1
- hippie theme 1
- keyboard fills 1
- knife honing sound effect 1
- low quality music 1
- mandolin 1
- metal song 1
- multiple guitars 1
- music fading out 1
- muted guitar 1
- no lyrics 1
- no percusion 1
- octaves 1
- organ 1
- out of time guitar 1
- pedal bass notes 1
- pedal steel guitar 1
- pentatonic scale descending run 1
- percussion beat 1
- piano 1
- plucked guitar 1
- pop ballad 1
- pop rock 1
- pop rock song 1
- power drumming 1
- programmed percussion 1
- psychedelic feel 1
- punk rock 1
- rap song 1
- reggae bassline 1
- reggae guitar 1
- reggae percussion 1
- relaxing song 1
- reverb 1
- reverb guitar 1
- ringing guitar chord 1
- rock 1
- rock and roll 1
- rock bass 1
- rock percussion 1
- romantic feel 1
- root and fifth 1
- saxophone 1
- shimmer sound 1
- shrieking voice 1
- simple bass 1
- single strum 1
- slow pop 1
- slow rock song 1
- soul song 1
- sound of bells 1
- spanish rock 1
- square dancing dance 1
- string bending 1
- suspenseful song 1
- synth 1
- synth backing 1
- synth fill 1
- synth sounds 1
- synth string backing 1
- vocal octaves 1
- waltz beat 1
- yodelling song 1
musiccaps_names (array) 60 ✖
- Music 50
- Guitar 10
- Musical instrument 10
- Plucked string instrument 10
- Bluegrass 6
- Ska 6
- Speech 6
- Heavy metal 5
- Punk rock 5
- Rock music 5
- Singing 5
- Song 5
- Country 4
- Funk 4
- Tapping (guitar technique) 4
- Acoustic guitar 3
- Grunge 3
- Happy music 3
- Independent music 3
- Progressive rock 3
- Strum 3
- Angry music 2
- Banjo 2
- Electric guitar 2
- Middle Eastern music 2
- Pop music 2
- Reggae 2
- Roll 2
- Soul music 2
- /t/dd00003 1
- Afrobeat 1
- Bass drum 1
- Bowed string instrument 1
- Chant 1
- Chorus effect 1
- Christmas music 1
- Dance music 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Electric piano 1
- Exciting music 1
- Jingle (music) 1
- Keyboard (musical) 1
- Lullaby 1
- Mouse 1
- Music of Africa 1
- Percussion 1
- Piano 1
- Psychedelic rock 1
- Pulse 1
- Reverberation 1
- Rimshot 1
- Rock and roll 1
- Rustling leaves 1
- Snare drum 1
- Steel guitar, slide guitar 1
- Tender music 1
- Tick 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;