musiccaps_details (view)
46 rows where musiccaps_aspects contains "urban" and musiccaps_author = 9
This data as json
musiccaps_aspects (array) 166 ✖
- urban · 46 ✖
- electronic drums 34
- groovy 23
- hip 18
- male vocal 18
- hip-hop 13
- strong bass 11
- bass guitar 10
- danceable 10
- melodic singing 10
- rapping 10
- keyboard 9
- turntable 9
- acoustic drums 8
- scratching 8
- electric guitar 7
- female vocal 7
- energetic 6
- r&b 6
- synth bass 6
- dance 5
- rap-like singing 5
- synth 5
- bass 4
- dj performance 4
- male vocals 4
- repeated theme 4
- breakbeat 3
- drum & bass 3
- electronic dance music 3
- groovy bass 3
- instrumental 3
- live performance 3
- modern 3
- acoustic guitar 2
- aggressive 2
- amusing 2
- crisp 2
- dj set 2
- electronic 2
- female vocal sample 2
- hardcore hip-hop 2
- hip-hop breakbeat 2
- hollering sample 2
- live recording 2
- male vocal sample 2
- modern sound 2
- modern sounding 2
- no singer 2
- piano 2
- playful 2
- rap 2
- remix 2
- sensual 2
- sleigh bells 2
- soul 2
- strings 2
- strings sample 2
- upbeat 2
- violent 2
- acoustic guitar sample 1
- ad-libs 1
- afro percussion 1
- afrobeat 1
- alternative r&b 1
- alternative rock 1
- beat repeat 1
- bizarre 1
- boy band 1
- brass sample 1
- british hip-hop music 1
- broken beat 1
- cheerful 1
- child voice 1
- chill 1
- christian pop 1
- christmas music 1
- comedy 1
- crowd cheering 1
- dance music 1
- dance-pop 1
- dancehall 1
- dense 1
- dirty sound 1
- distant 1
- dj 1
- eccentric 1
- eerie 1
- electric guitar sample 1
- electronic music 1
- experimental rock 1
- fast-tempo electronic drums 1
- female choir 1
- female vocals 1
- female voice sample 1
- festive 1
- flamboyant singing 1
- funk 1
- funky 1
- fuzzy synth bass 1
- gangsta rap 1
- generic 1
- german language 1
- gloomy 1
- gospel 1
- groovy bass line 1
- guitar sample 1
- gunshot sound effect 1
- hard-hitting 1
- high pitch singing 1
- high tempo 1
- hindi language 1
- hip-hop beat 1
- hungarian hip-hop 1
- indie 1
- indie hip-hop 1
- indie rock 1
- instrumental hip-hop 1
- jazz funk 1
- k-pop 1
- keyboard sample 1
- kids performance 1
- kids song 1
- loud electronic drums 1
- low-to-medium singing 1
- male narrator 1
- male voice 1
- medium tempo 1
- medium-to-high pitch singing 1
- mellow drums 1
- melodic pad 1
- melodic singing keyboard 1
- minor key 1
- neo-soul 1
- normal tempo 1
- pad 1
- peculiar beat 1
- percussion 1
- piano sample 1
- piano sound 1
- pop 1
- pop dance 1
- r&b music 1
- rap beat 1
- raspy voice 1
- religious 1
- rhythmic effects 1
- scracthing 1
- seductive singing 1
- sentimental 1
- shuffle 1
- sit-com soundtrack 1
- sitar sample 1
- skateboarding 1
- southern rap sound 1
- speech sample 1
- sterile 1
- swiss rap 1
- synth-pop 1
- techno trance 1
- telephone sound effect 1
- versatile female vocal 1
- very fast tempo 1
- vocal sample 1
- voices shouting 1
- wobbly bass 1
musiccaps_names (array) 48 ✖
- Music 40
- Hip hop music 9
- Rapping 7
- Scratching (performance technique) 7
- Funk 5
- Scratch 5
- Exciting music 3
- Reggae 3
- Drum and bass 2
- Dubstep 2
- Electronic music 2
- Music for children 2
- Music of Asia 2
- Pop music 2
- Singing 2
- Afrobeat 1
- Bass drum 1
- Busy signal 1
- Christian music 1
- Cymbal 1
- Disco 1
- Drum 1
- Drum kit 1
- Drum machine 1
- Electric piano 1
- Electronic dance music 1
- Electronica 1
- Groan 1
- Grunge 1
- Heavy metal 1
- Hi-hat 1
- Independent music 1
- Jingle, tinkle 1
- Keyboard (musical) 1
- Music of Latin America 1
- Percussion 1
- Piano 1
- Punk rock 1
- Rhythm and blues 1
- Rimshot 1
- Rock music 1
- Ska 1
- Skateboard 1
- Snare drum 1
- Speech 1
- Steelpan 1
- Tire squeal 1
- Trance 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;