musiccaps_details (view)
25 rows where musiccaps_aspects contains "bass" and musiccaps_aspects contains "programmed percussion"
This data as json
musiccaps_aspects (array) 84 ✖
- bass · 25 ✖
- programmed percussion · 25 ✖
- moderate tempo 16
- male voice 12
- dance song 8
- female voice 8
- synth 8
- low quality audio 5
- no voices 5
- slow tempo 5
- dance music 4
- happy mood 4
- hip-hop song 4
- synth sounds 4
- club music 3
- hand claps 3
- instrumental 3
- pop song 3
- backing voices 2
- club song 2
- male backing voices 2
- romantic theme 2
- synth backing 2
- synth music 2
- amateur recording 1
- anime song 1
- autotune voice 1
- beeping sounds 1
- bollywood song 1
- bowed lute 1
- boy band 1
- caribbean feel 1
- caribbean music 1
- dance beat 1
- dance pop song 1
- disco song 1
- dj song 1
- falsetto 1
- female backing 1
- female backing voice 1
- foreign language 1
- glass shattering sound 1
- house music 1
- instrumental song 1
- kizomba 1
- latin beat 1
- male voices 1
- marimba 1
- middle eastern song 1
- middle-eastern feel 1
- motivation song 1
- party music 1
- piano 1
- piano song 1
- r&b song 1
- rap 1
- reggae feel 1
- reggae song 1
- repetitive melody 1
- repetitive synth melody 1
- romantic mood 1
- romantic song 1
- saxophone 1
- shaker 1
- siren sounds 1
- sound of throwing objects 1
- steel pan music 1
- synth bursts 1
- synth melody 1
- synth pads 1
- synth strings 1
- tabla 1
- techno 1
- techno beat 1
- techno dance song 1
- techno song 1
- traditional instruments 1
- trance song 1
- trap beat 1
- tribal fusion song 1
- upbeat 1
- uptempo 1
- vinyl scratching 1
- whistling sound 1
musiccaps_names (array) 30 ✖
- Music 23
- Music of Africa 4
- Afrobeat 3
- Electronic music 3
- House music 3
- Rapping 3
- Dance music 2
- Disco 2
- Dubstep 2
- Electronic dance music 2
- Exciting music 2
- Pop music 2
- Singing 2
- Song 2
- Soul music 2
- Christian music 1
- Drum and bass 1
- Hip hop music 1
- Inside, small room 1
- Music of Asia 1
- Music of Latin America 1
- Power windows, electric windows 1
- Reggae 1
- Scary music 1
- Scratching (performance technique) 1
- Shatter 1
- Sliding door 1
- Steelpan 1
- Techno 1
- Zing 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;