musiccaps_details (view)
2 rows where musiccaps_aspects contains "party all night" and musiccaps_names contains "Disco"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- dj 2
- exciting 2
- party all night · 2 ✖
- various percussion hits 2
- beach party hits 1
- booming bass line 1
- cheerful 1
- dance floor 1
- dance hits 1
- disco hits 1
- diva 1
- electronic dance music 1
- energetic 1
- female singer 1
- groovy 1
- groovy bas slime 1
- groovy dance music 1
- happening paces 1
- house mix 1
- instrumental music 1
- keyboard accompaniment 1
- keyboard harmony 1
- love song 1
- medium tempo 1
- miami larry 1
- party hits 1
- party mix 1
- ping pong shot tones 1
- poor audio quality 1
- retro dance music 1
- retro pop hits 1
- romantic 1
- spirited 1
- strong drumming rhythm 1
- sweeping keyboard harmony 1
- techno dance rhythm 1
- trance music 1
- underground music scene 1
- youthful 1
musiccaps_names (array) 8 ✖
- Disco · 2 ✖
- Music 2
- Dance music 1
- Drum and bass 1
- Dubstep 1
- Electronic dance music 1
- House music 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Polycarpus - Ping Pong | The song is an instrumental. The tempo is medium with a booming bass line, grooving drum rhythm, sweeping keyboard harmony, sonic sound effects, and pin pong ball sound effects. The song has trance vibes and is very groovy. The song has poor audio quality. | 2009-12-20T21:38:12Z | Harder_Stylezz89 | Polycarpus - Ping Pong | ["Disco", "Drum and bass", "House music", "Music", "Techno", "Dubstep", "Electronic dance music", "Dance music"] | ["techno dance rhythm", "keyboard harmony", "poor audio quality", "trance music", "dj", "house mix", "party mix", "medium tempo", "instrumental music", "ping pong shot tones", "booming bass line", "various percussion hits", "groovy dance music", "exciting", "youthful", "energetic", "spirited", "party all night", "underground music scene", "sweeping keyboard harmony"] | 1 | hgGCfJoYDUU | 4124 | |
Mylo vs. Miami Sound Machine - Doctor Pressure (Dirty Radio Edit) | A female singer sings this cool dance melody. The song is medium-fast tempo with a cool dance groove, percussive bass line, steady dance rhythm, keyboard accompaniment and various percussion hits. The song is groovy and proper electronic dance music hit, | 2010-10-15T14:05:53Z | Superstar Music | ★ Superstar Music - Electronic Dance Music Non-Stop! ★ → Subscribe: http://bit.ly/1vJkn7Q → Stream / Download: https://super.lnk.to/hxBOoYo | ["Disco", "Music"] | ["electronic dance music", "dj", "female singer", "beach party hits", "retro pop hits", "diva", "groovy bas slime", "strong drumming rhythm", "various percussion hits", "exciting", "cheerful", "romantic", "groovy", "love song", "party all night", "party hits", "dance hits", "retro dance music", "miami larry", "happening paces", "dance floor", "keyboard accompaniment", "disco hits"] | 1 | mpikDeSk-mM | 4493 |
Advanced export
JSON shape: default, array, newline-delimited
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;