musiccaps_details (view)
4 rows where musiccaps_aspects contains "dance floor" and musiccaps_aspects contains "male singer" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 74 ✖
- dance floor · 4 ✖
- male singer · 4 ✖
- dance club 2
- exciting 2
- fast tempo 2
- guitar rhythm 2
- keyboard accompaniment 2
- people dancing 2
- poor audio quality 2
- romantic 2
- ambient 1
- ambient hall noise 1
- animated 1
- animated vocals 1
- auto tuned female vocals 1
- booming bass line 1
- buzzing tones 1
- cheerful 1
- classic pop songs 1
- club music 1
- country dance 1
- couples dancing 1
- dance all night long 1
- dance groove 1
- dance hall 1
- dance music 1
- dancers 1
- dj 1
- dj mis 1
- dj mix 1
- dj mixer 1
- edm 1
- electro pop 1
- electronic music 1
- emotional 1
- energetic 1
- entertaining 1
- enthusiastic 1
- euro pop hits 1
- fiddle playing 1
- groovy bass line 1
- grunge tones 1
- high gain noise 1
- latin dance groove 1
- latin dance hits 1
- latin dance music 1
- latin percussions 1
- latin pop star 1
- latin singer 1
- love song 1
- love you much 1
- medium fast tempo 1
- party time 1
- passionate 1
- rap singer 1
- retro dance hits 1
- russian pop hits 1
- russian singer 1
- scratching sounds 1
- slow dance music 1
- slow tempo 1
- sonic effects 1
- steady drumming rhythm 1
- story telling 1
- strong bass line 1
- synthesiser articulation 1
- techno dance hits 1
- techno drumming rhythm 1
- trance party 1
- turn table 1
- vigorous 1
- vinyl records 1
- vital 1
- youthful 1
musiccaps_names (array) 9 ✖
- Music 4
- Afrobeat 1
- Country 1
- Electronic music 1
- Music of Africa 1
- Singing 1
- Tambourine 1
- Techno 1
- Zing 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
15. 1MILLION SOUNDS - JUNIO 2016 (BRUNO TORRES) | A male singer sings this exciting melody. The song is medium fast tempo with a groovy bass line, latin percussion, steady drum rhythm, groovy bass line and keyboard accompaniment. The song is exciting and fun. The song is a modern Latin pop dance hit. | 2016-06-02T12:05:11Z | TemazosMusic TV | Temazos Music 2.0: https://www.youtube.com/channel/UCjCqUvKSd1A8aUnhZekclvA Descargar: http://www92.zippyshare.com/v/pdlnpgp4/file.html FACEBOOK: https://www.facebook.com/TemazosMusicTV TWITTERS: https://twitter.com/TemazosMusicYT https://twitter.com/puchidj | ["Afrobeat", "Music of Africa", "Music"] | ["male singer", "latin singer", "latin pop star", "latin percussions", "story telling", "medium fast tempo", "latin dance music", "latin dance groove", "strong bass line", "guitar rhythm", "people dancing", "dance club", "dance floor", "passionate", "cheerful", "exciting", "romantic", "dance all night long", "party time", "latin dance hits", "keyboard accompaniment"] | 1 | L1s-oPHsOac | 2144 | |
Cowboy Cha Cha (partner dance) by Silver Spurs France | A male singer sings this retro pop melody. The song is medium tempo with a steady drumming rhythm, steady bass line, guitar accompaniment, and fiddler playing. The song is romantic and slow dance-like. The audio quality is very poor. | 2010-07-05T10:34:29Z | Shirley Davidson | Dance.......Cowboy Cha Cha Choreographed by Toshio Suzuki Music .......I Just Wanna Dance With You by George Strait Danced by dancers from Silver Spurs South West France at a social event July 2010. | ["Singing", "Country", "Music", "Tambourine"] | ["slow tempo", "slow dance music", "people dancing", "couples dancing", "dance hall", "dance floor", "ambient hall noise", "poor audio quality", "buzzing tones", "high gain noise", "male singer", "classic pop songs", "retro dance hits", "country dance", "emotional", "romantic", "fiddle playing", "guitar rhythm", "steady drumming rhythm", "love song", "love you much", "booming bass line"] | 1 | B8pesuUc8Ek | 1209 | |
Russen Techno Remix | A male Russian singer sings this rap vocals with a female backup singer in vocal harmony. The song is fast tempo with techno drumming rhythm, percussive bass line, keyboard accompaniment and sonic effects. The song is a techno dance hit. The audio quality is poor. | 2008-10-23T14:40:58Z | CoolerRussenking | Russische Musik mit Verschiedenen Bildern. | ["Electronic music", "Music", "Techno"] | ["russian singer", "male singer", "rap singer", "poor audio quality", "fast tempo", "techno drumming rhythm", "groovy bass line", "keyboard accompaniment", "grunge tones", "sonic effects", "auto tuned female vocals", "exciting", "energetic", "entertaining", "dancers", "dance floor", "dance club", "trance party", "russian pop hits", "euro pop hits", "techno dance hits"] | 1 | dDKUjMHerLs | 3770 | |
Voice Hands Machine - Take Your Hand | A male vocalist sings this spirited song. The tempo is fast with electronic instrumentation, synthesiser articulation and turn table. The song is spirited,youthful , enthusiastic, energetic, vigorous and vital. This song is an EDM/ Synth Pop song. | 2011-06-26T23:35:39Z | VoiceHandsMachine | Voice Hands Machine - Take Your Hand GET IT on ITUNES: http://bit.ly/tyhitu Website: http://bit.ly/vhm_www Facebook: http://on.fb.me/vhm_fb TAKE YOUR HAND is the new single from the fresh Paris talent, Voice Hands Machine. | ["Music", "Zing"] | ["male singer", "fast tempo", "edm", "electro pop", "dj mix", "youthful", "animated", "vigorous", "vital", "enthusiastic", "dance groove", "electronic music", "turn table", "dj", "animated vocals", "synthesiser articulation", "scratching sounds", "vinyl records", "dj mis", "dj mixer", "dance music", "dance floor", "club music", "ambient"] | 7 | X7qFgrAl3OU | 3163 |
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;