musiccaps_details (view)
41 rows where musiccaps_aspects contains "danceable" and musiccaps_author = 9
This data as json
musiccaps_aspects (array) 151 ✖
- danceable · 41 ✖
- electronic drums 24
- energetic 17
- keyboard 15
- male vocal 15
- groovy 14
- melodic singing 12
- bass guitar 11
- electric guitar 11
- acoustic drums 10
- urban 10
- instrumental 9
- hip 7
- no singer 7
- upbeat 7
- electronic 6
- electronic dance music 6
- female vocal 6
- funk 6
- strong bass 6
- bass 5
- disco 5
- hip-hop 5
- melodic pad 5
- repeated theme 5
- modern sounding 4
- pop 4
- r&b 4
- rap-like singing 4
- remix 4
- synth 4
- chill 3
- easygoing 3
- lively 3
- medium tempo 3
- percussion 3
- playful 3
- synth bass 3
- vibrant 3
- 80s 2
- afrobeat 2
- bells 2
- brass 2
- drum & bass 2
- eccentric 2
- female vocal sample 2
- hollering sample 2
- house 2
- keyboards 2
- loud electronic drums 2
- male vocals 2
- old-fashioned 2
- piano 2
- rapping 2
- retro 2
- rock 2
- saxophone 2
- sensual 2
- trippy 2
- acoustic jazz drums 1
- afro percussion 1
- aggressive 1
- ambient synth 1
- autotune singing 1
- big band 1
- boy band 1
- brass section 1
- brass stab 1
- bravado 1
- broken beat 1
- catchy 1
- claps 1
- classical influence 1
- club music 1
- cover 1
- crisp 1
- dance music 1
- dance pop 1
- deep house 1
- dense 1
- disco funk 1
- dj 1
- doo wop 1
- dub 1
- electric guitar sample 1
- electric guitar sound 1
- electro swing 1
- electroclash 1
- electronic music 1
- electronic percussion 1
- european 1
- evolving 1
- fast-tempo electronic drums 1
- female vocals 1
- female voice 1
- female voice sample 1
- finnish pop 1
- finnish techno pop 1
- guitar solo 1
- high energy 1
- house music 1
- j-pop 1
- jazz funk 1
- jazz-funk 1
- joyful 1
- k-pop 1
- live performance 1
- male vocal sample 1
- male voice sample 1
- marimba 1
- medium-pitched synth 1
- medium-to-high pitch singing 1
- melodic singing keyboard 1
- modern sound 1
- movie theme 1
- outer space 1
- piano sound 1
- polka 1
- pop dance 1
- pop music 1
- raspy voice 1
- reggae 1
- repeated sample 1
- robotic sound effects 1
- ska punk 1
- smooth 1
- soca music 1
- somali pop music 1
- sound effects electronic drums 1
- space disco 1
- spanish language 1
- squeaking sound effects 1
- star wars 1
- steel percussion 1
- strings 1
- swing jazz 1
- synth brass 1
- techno 1
- techno trance 1
- tropical 1
- trumpets 1
- tuba 1
- turntable 1
- unique 1
- upright bass 1
- versatile female vocal 1
- very fast tempo 1
- vocal sample 1
- walking bass line 1
- wobbly bass 1
- yodel-like singing 1
musiccaps_names (array) 43 ✖
- Music 37
- Disco 8
- Funk 6
- Dance music 4
- Electronic music 3
- Hip hop music 3
- Techno 3
- Afrobeat 2
- Drum and bass 2
- Dubstep 2
- Electric piano 2
- Electronica 2
- Exciting music 2
- House music 2
- Keyboard (musical) 2
- Musical instrument 2
- Piano 2
- Pop music 2
- Ska 2
- Soul music 2
- Blues 1
- Brass instrument 1
- Drum kit 1
- Electronic dance music 1
- Groan 1
- Grunge 1
- Happy music 1
- Jazz 1
- Jingle (music) 1
- Music of Africa 1
- Music of Asia 1
- New-age music 1
- Psychedelic rock 1
- Rapping 1
- Rattle (instrument) 1
- Rhythm and blues 1
- Skateboard 1
- Steelpan 1
- Swing music 1
- Tambourine 1
- Tender music 1
- Trance music 1
- Trumpet 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;