musiccaps_details (view)
41 rows where musiccaps_aspects contains "male vocals" and musiccaps_author = 9
This data as json
musiccaps_aspects (array) 180 ✖
- male vocals · 41 ✖
- bass guitar 17
- melodic singing 14
- acoustic guitar 10
- electric guitar 10
- electronic drums 10
- acoustic drums 9
- keyboard 9
- easygoing 7
- live performance 7
- groovy 6
- joyful 6
- latin percussion 6
- piano 6
- energetic 5
- female vocal 5
- latin dance 5
- lively 5
- vibrant 5
- dance 4
- percussion 4
- r&b 4
- rapping 4
- repeated theme 4
- soul 4
- urban 4
- aggressive 3
- amateur recording 3
- bluegrass 3
- cozy 3
- harmony singing 3
- loud 3
- playful 3
- rock 3
- salsa 3
- synth bass 3
- upbeat 3
- acapella 2
- acoustic 2
- amusing 2
- banjo 2
- boy band 2
- choir 2
- comedy 2
- danceable 2
- dreamy 2
- electronic percussion 2
- emotional 2
- fiddle 2
- gospel 2
- hard-hitting 2
- hindi language 2
- hip-hop 2
- jingle 2
- mandolin 2
- pop music 2
- rap-like singing 2
- remix 2
- rock music 2
- simple 2
- spanish 2
- synth 2
- uplifting 2
- upright bass 2
- acoustic guitars 1
- acoustic live performance 1
- acoustic sounding drums 1
- ad-lib 1
- ad-libs 1
- afro cuban dance 1
- afro-cuban 1
- albanian pop music 1
- american 1
- american folk 1
- auto-tuned singing 1
- banjo solo 1
- bass 1
- bongo 1
- bravado 1
- brazilian 1
- chant 1
- cheerful 1
- christmas 1
- church hymn 1
- claps 1
- clarinet 1
- clave 1
- clean electric guitar 1
- conga 1
- country music 1
- cowbell 1
- crisp synth 1
- crowd cheering 1
- crunchy 1
- cumbia 1
- czech 1
- dance-pop 1
- dance-rap 1
- distorted electric guitar 1
- dizzying 1
- doo wop 1
- egyptian 1
- electric guitat 1
- euphoric 1
- female vocals 1
- festive 1
- festive christian 1
- folk 1
- folk rock 1
- fooling around 1
- footsteps 1
- friendly 1
- fun 1
- funky 1
- funny singing 1
- fuzzy synth bass 1
- gangsta rap 1
- gentle 1
- gothic rock 1
- grunt-like singing 1
- gunshot sound effect 1
- hard rock 1
- hardcore hip-hop 1
- harmonica 1
- high tempo 1
- hip 1
- intimate 1
- jam 1
- joyful singing 1
- k-pop 1
- kanjira 1
- latin 1
- latin acoustic drums 1
- latin dance music 1
- latin music 1
- loud singing 1
- major key 1
- maraca 1
- maracas 1
- medium pitch singing 1
- medium tempo 1
- mellow bass 1
- mystery 1
- neo-soul 1
- nostalgic 1
- obscene 1
- pop punk 1
- pop rock 1
- pop-rap 1
- punk rock 1
- rap 1
- rap music 1
- rebellious 1
- religious 1
- rising pattern 1
- samba 1
- saxophones 1
- seductive 1
- seductive singing 1
- sensual 1
- shouting 1
- simple tune 1
- skating 1
- slow tempo 1
- spiritual 1
- steady tempo 1
- street performance 1
- strings 1
- strong bass 1
- suspense 1
- tabla 1
- tear-jerking 1
- timbale 1
- trumpet 1
- trumpets 1
- ukulele 1
- ukulele solos 1
- unique 1
- urban sounds 1
- violent 1
musiccaps_names (array) 49 ✖
- Music 38
- Singing 10
- Song 5
- Country 4
- Exciting music 4
- Hip hop music 4
- Music of Africa 4
- Salsa music 4
- Ska 4
- Afrobeat 3
- Music of Latin America 3
- Rhythm and blues 3
- /t/dd00003 2
- Bluegrass 2
- Choir 2
- Flamenco 2
- Mandolin 2
- Maraca 2
- Middle Eastern music 2
- Pop music 2
- Rapping 2
- Reggae 2
- Speech 2
- Swing music 2
- A capella 1
- Bang 1
- Bass drum 1
- Blues 1
- Chant 1
- Christian music 1
- Christmas music 1
- Crowd 1
- Dance music 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Folk music 1
- Guitar 1
- Independent music 1
- Music of Asia 1
- Music of Bollywood 1
- Percussion 1
- Rimshot 1
- Skateboard 1
- Snare drum 1
- Soundtrack music 1
- Traditional music 1
- Ukulele 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;