musiccaps_details (view)
48 rows where musiccaps_aspects contains "bass" and musiccaps_aspects contains "male voice"
This data as json
musiccaps_aspects (array) 154 ✖
- bass · 48 ✖
- male voice · 48 ✖
- moderate tempo 30
- percussion 22
- low quality audio 12
- programmed percussion 12
- simple percussion 9
- slow tempo 9
- dance song 7
- happy mood 7
- pop song 7
- synth 7
- backing voices 5
- piano 5
- romantic mood 5
- amateur recording 4
- distortion guitar 4
- guitar 4
- romantic theme 4
- synth sounds 4
- aggressive percussion 3
- alternative rock 3
- dance music 3
- distortion guitars 3
- fast tempo 3
- hand claps 3
- happy song 3
- hip-hop song 3
- keyboard 3
- male backing voices 3
- rock and roll 3
- rock song 3
- saxophone 3
- strings 3
- synth pads 3
- backing voice 2
- blues song 2
- children's song 2
- female backing voices 2
- foreign language 2
- male backing voice 2
- overdriven guitar 2
- reggae song 2
- salsa song 2
- shaker 2
- slow pop 2
- tambourine 2
- trap beat 2
- upbeat song 2
- vocal harmony 2
- accordion 1
- angry voice 1
- background song 1
- ballad 1
- big band jazz 1
- bollywood song 1
- bowed lute 1
- boy band 1
- brass section 1
- call and response 1
- call and response style 1
- caribbean music 1
- children's voices 1
- choir backing 1
- christmas song 1
- claves 1
- club music 1
- club song 1
- comforting song 1
- country song 1
- cover song 1
- cowbell 1
- crowd singing 1
- dance pop song 1
- dance song for children 1
- disco song 1
- dj song 1
- doo wop 1
- duet 1
- emotive voice 1
- falsetto 1
- fast percussion 1
- female backing 1
- female voice 1
- four chord song 1
- gallopping guitar 1
- gospel style 1
- gothic rock 1
- guitar fills 1
- guitar playing octaves 1
- guitar scratching 1
- guitar song 1
- guitars 1
- heavy metal 1
- heavy metal song 1
- hippie theme 1
- holiday mood 1
- holiday theme 1
- jamaican feel 1
- jazzy song 1
- keyboard fills 1
- keyboard music 1
- kizomba 1
- latin beat 1
- latin pop 1
- low quality recording 1
- marimba 1
- middle-eastern feel 1
- motivation song 1
- motivational 1
- muted guitar 1
- narration 1
- no vocal melody 1
- one chord strings 1
- pedal steel guitar 1
- piano song 1
- pop ballad 1
- pop rock song 1
- psychedelic feel 1
- punk rock 1
- rap 1
- reggae feel 1
- repetitive melody 1
- repetitive synth melody 1
- rhyming song 1
- rock 1
- romantic song 1
- shakers 1
- shrieking voice 1
- simple melody 1
- siren sounds 1
- ska song 1
- slow dance song 1
- slow rock 1
- spanish pop 1
- square dancing dance 1
- storytelling mood 1
- suspenseful song 1
- symphonic rock 1
- synth backing 1
- synth fill 1
- synth layers 1
- synth music 1
- synth strings 1
- tabla 1
- tap dance 1
- techno 1
- trance song 1
- trumpet 1
- trumpets 1
- upbeat 1
- vinyl scratching 1
- vocables 1
- vocal octaves 1
musiccaps_names (array) 58 ✖
- Music 42
- Singing 8
- Ska 5
- Independent music 4
- Song 4
- Christian music 3
- Dance music 3
- Funk 3
- Heavy metal 3
- Music of Africa 3
- Punk rock 3
- Rapping 3
- Rock music 3
- Salsa music 3
- Zing 3
- Afrobeat 2
- Bass drum 2
- Country 2
- Drum 2
- Drum kit 2
- Drum roll 2
- Grunge 2
- Hip hop music 2
- Music of Latin America 2
- Percussion 2
- Pop music 2
- Psychedelic rock 2
- Rhythm and blues 2
- Rimshot 2
- Rock and roll 2
- Roll 2
- Snare drum 2
- Soul music 2
- Angry music 1
- Bluegrass 1
- Blues 1
- Christmas music 1
- Cymbal 1
- Disco 1
- Drum and bass 1
- Dubstep 1
- Electronic dance music 1
- Electronic music 1
- Happy music 1
- Hi-hat 1
- House music 1
- Jingle (music) 1
- Middle Eastern music 1
- Mouse 1
- Music of Asia 1
- Progressive rock 1
- Pulse 1
- Radio 1
- Reggae 1
- Sad music 1
- Scratching (performance technique) 1
- Tap 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;