musiccaps_details (view)
6 rows where musiccaps_aspects contains "dance song", musiccaps_aspects contains "female voice" and musiccaps_aspects contains "programmed percussion"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
#Techno Autobahn | This techno song features a female voice singing only in non-lexical vocables. This is accompanied by programmed percussion. The percussion pauses after one and a half bars. It plays again after half a bar in an eighth note pattern. A synth plays a melody that is the same as that of the voice. The melody is repetitive. This song has a happy mood. This song can be played in a club. | 2009-02-20T19:39:21Z | smdileuca | is einfach cool | ["Electronic music", "Music", "Techno", "Zing"] | ["techno song", "dance song", "female voice", "vocables", "repetitive vocal melody", "synth music", "programmed percussion", "moderate melody"] | 0 | JzJCn-puzS4 | 2048 | |
chaba dalila mkalcha 2010 live.wmv | This song features a female voice singing the main melody. This song has a Middle-Eastern feel. The voice is accompanied by percussion playing a dance beat. A synth plays a high pitched melody in between lines. A synth pad plays chords in the background. The bass plays the root notes of the chords. Toward the end, all instruments except the synth pads pause. The voice continues to sing at this time. An autotune effect is used on the voice. This song can be played in a club. | 2010-04-04T14:04:11Z | hamrawiya31 | ["Music of Africa", "Music"] | ["middle eastern song", "female voice", "autotune voice", "synth melody", "programmed percussion", "bass", "moderate tempo", "dance song"] | 0 | OnL-e9X0oEc | 2469 | ||
Msp good girls go bad by aspire22 | This dance song features a female voice singing the main melody. A delay effect is added to the voice which allows the last word to echo a few times. This is accompanied by programmed percussion playing a kick driven beat. A warbling sound is played in the background. A synth plays a leading riff in the foreground. This song is upbeat and can be played in a club. | 2013-06-13T20:02:51Z | Jessica | plz like and subscribe ^-^ Also im in the Usa msp xD What i used: Moviemaker | ["Disco", "Music"] | ["dance song", "techno song", "club song", "warbling sound effect", "female voice", "synth sounds", "programmed percussion", "bouncy feel", "moderate tempo"] | 0 | WKYUiLace9Y | 3087 | |
Eze One Ft.Sherifa Gunu - African Dance (Official Video) | This tribal fusion song features a male voice singing the main melody. This is accompanied by percussion playing a dance beat using traditional tribal percussion instruments. The bass plays the root notes of the chords. At the end of the clip, a female voice sings a line. The theme of the song is an African dance. This song can be played in a club. | 2012-04-28T14:14:23Z | afrofusionify | African dance, truly african culture,blend of Azonto in African fusion.Bringing African music,Culture,and fashion together through music, atilogu dance, atilogwu dance, | ["Afrobeat", "Music of Africa", "Music"] | ["tribal fusion song", "dance song", "male voices", "female voice", "dance beat", "programmed percussion", "bass", "traditional instruments", "moderate tempo"] | 0 | ZLXW4ewrVpQ | 3365 | |
Natura apresenta MULHERES | This dance song features a female voice singing the main melody. This is accompanied by programmed percussion playing a simple beat which starts off with a drum roll. The bass plays the root notes of the chords. A synth plays chords in the background. This song has an upbeat mood. This song can be played in a club. | 2016-04-26T17:50:24Z | Maquiagem Natura | Convidamos a Maíra Freitas para reinterpretar a música mais famosa do seu pai - o Martinho da Vila. O resultado? Uma homenagem a todas as diversas e possíveis belezas, cores, estilos e muitos amores. Natura apresenta MULHERES. #AdoroMaquiagem #MULHERES #VivaSuaBelezaViva | ["Music", "Music of Latin America"] | ["dance song", "female voice", "moderate tempo", "programmed percussion", "bass", "synth backing", "uptempo", "club music"] | 0 | x1KyLxsnJY0 | 5299 | |
Afrodita - Valera - Russian Music - Música rusa | This dance song features a female voice singing the main melody. This is accompanied by programmed percussion playing a bass driven beat in common time. A synth plays chords in the background. The bass plays the root notes of the chords. There is a whistling sound played on a synth at the beginning of the song. This song has a happy tone. This song can be played in a club. | 2011-08-28T15:29:29Z | NAMusicity | Afrodita- Valera / Афродита - Валера Russian Music,Russische Musik,Muza,Русская Музыка,Música rusa,Musique russe Россия,Русија,Russie,Rusia,Russland,俄羅斯 ,Rosja,Rússia,روسيا,Ռուսաստան,Rusland,Russia,러시아,რუსეთის,俄罗斯 ,Rusija,ประเทศรัสเซีย,Rusko,Venäjä | ["Music", "Exciting music"] | ["dance song", "club song", "whistling sound", "techno beat", "female voice", "moderate tempo", "programmed percussion", "synth sounds", "bass", "happy mood"] | 0 | zmbwvsdXlBU | 5510 |
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;