musiccaps_details (view)
28 rows where musiccaps_aspects contains "synth bass" and musiccaps_author = 9
This data as json
musiccaps_aspects (array) 142 ✖
- synth bass · 28 ✖
- electronic drums 22
- dance 10
- energetic 7
- groovy 7
- keyboard 7
- repeated theme 7
- loud 6
- sound effects 6
- urban 6
- electronic 5
- hip 4
- instrumental 4
- aggressive 3
- danceable 3
- dubstep 3
- male vocals 3
- movie music 3
- no singer 3
- pad 3
- strings 3
- acoustic drums 2
- amusing 2
- breakbeat 2
- disco 2
- drum & bass 2
- electronic dance music 2
- electronic percussion 2
- fuzzy 2
- generic 2
- high-pitched synth 2
- hip-hop beat 2
- melodic singing 2
- modern 2
- percussion 2
- pop 2
- rap-like singing 2
- rapping 2
- sensual 2
- simple 2
- violent 2
- action-filled 1
- alternative 1
- ambient synth 1
- autotune 1
- avant-garde 1
- bizarre 1
- box opening 1
- boy band 1
- brass section 1
- broken beat 1
- catchy 1
- chaotic 1
- cinematic 1
- cinematic synth 1
- comedic 1
- comedy 1
- commercial 1
- common 1
- crisp 1
- cutting sound 1
- deep house 1
- dense 1
- disorganized 1
- downtempo 1
- dramatic 1
- dread 1
- drumstep 1
- eccentric 1
- eerie 1
- electric guitar 1
- electro 1
- epic 1
- erotic 1
- experimental electronica 1
- experimental rock 1
- fast tempo 1
- fast-paced 1
- female vocal sample 1
- female vocals 1
- female voice 1
- french electronic pop 1
- funk 1
- funny 1
- glass shatter 1
- hindi language 1
- hip-hop 1
- hopelessness 1
- house 1
- hype 1
- hyperactive 1
- ice break 1
- impact 1
- indie rock 1
- industrial sounding 1
- instructive recording 1
- instrumental hip-hop 1
- intro 1
- jam 1
- jazz 1
- jazz funk 1
- jingle 1
- k-pop 1
- lead synth 1
- live performance 1
- lo-res 1
- male vocal 1
- male voice 1
- medium tempo 1
- melbourne shuffle 1
- melodic 1
- melodic pad 1
- mid tempo 1
- mid-tempo 1
- minimal 1
- no beat 1
- ominous 1
- parody 1
- peculiar beat 1
- piano 1
- ping sound effect 1
- pulse 1
- random 1
- rap beat 1
- rave 1
- remix 1
- repeating theme 1
- rising pattern 1
- russian hardbass 1
- saxophone 1
- schizophrenic 1
- scissor sharpener 1
- sleigh bells 1
- squeaking sound effects 1
- terrifying 1
- tick tock 1
- trippy 1
- tv series theme 1
- uneasy 1
- unnerving 1
- upbeat 1
- vocal sample 1
musiccaps_names (array) 46 ✖
- Music 26
- Dubstep 4
- Rapping 4
- Drum and bass 3
- Techno 3
- Trance music 3
- Dance music 2
- Drum machine 2
- Electronic dance music 2
- Electronica 2
- Exciting music 2
- Hip hop music 2
- /t/dd00032 1
- Ambient music 1
- Bass drum 1
- Cymbal 1
- Didgeridoo 1
- Disco 1
- Drum 1
- Drum kit 1
- Electronic music 1
- Explosion 1
- Funk 1
- Glass 1
- Groan 1
- Hi-hat 1
- House music 1
- Jazz 1
- Music of Asia 1
- New-age music 1
- Percussion 1
- Rimshot 1
- Sampler 1
- Scary music 1
- Scratch 1
- Scratching (performance technique) 1
- Shatter 1
- Shuffle 1
- Snare drum 1
- Squish 1
- Synthesizer 1
- Tender music 1
- Theme music 1
- Tire squeal 1
- Vibraphone 1
- Zipper (clothing) 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;