musiccaps_details (view)
4 rows where musiccaps_aspects contains "dance song" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- dance song · 4 ✖
- bass 2
- male voice 2
- moderate tempo 2
- arabic music 1
- arabic percussions 1
- arabic pop hits 1
- arabic retro hits 1
- arabic superstar 1
- backing voices 1
- bad audio quality 1
- belly dancing 1
- bollywood song 1
- cheerful 1
- clapping hands 1
- club song 1
- cover song 1
- duet 1
- excitement 1
- four on the floor drum beat 1
- fun 1
- groovy music 1
- happy 1
- happy mood 1
- love songs 1
- low quality audio 1
- male and female vocalists 1
- male singer 1
- medium tempo 1
- movie soundtrack 1
- passionate 1
- piano 1
- pop song 1
- portuguese pop r&b music 1
- positive 1
- programmed percussion 1
- r&b vocals 1
- romantic 1
- salsa song 1
- spirited 1
- stringed instruments 1
- synth music 1
- tabla 1
- traditional music 1
musiccaps_names (array) 9 ✖
- Music 4
- Singing · 4 ✖
- Music of Africa 2
- Christian music 1
- Christmas music 1
- Middle Eastern music 1
- Music of Asia 1
- Rhythm and blues 1
- Salsa music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hotel California , Marc Anthony - Salsa Version | This salsa song features a male voice singing the main melody. This is accompanied by percussion playing a salsa beat. The piano plays a typical salsa rhythm using the main chords for the song. The bass plays the root note and fifth of the chord. Due to the low quality of the audio, other instruments are not audible. This is a cover song of another famous song. This song can be played for a salsa dance. | 2011-05-31T22:04:34Z | Saleh AL-Enizi - EL SENYOUR | On a dark desert highway, cool wind in my hair Warm smell of colitas, rising up through the air Up ahead in the distance, I saw a shimmering light My head grew heavy and my sight grew dim I had to stop for the night There she stood in the doorway; I heard the mission bell And I was thinking to myself, this could be heaven or this could be hell Then she lit up a candle and she showed me the way There were voices down the corridor, I thought I heard them say... Welcome to the hotel california Such a lovely place Such a lovely face Plenty of room at the hotel california Any time of year, you can find it here Her mind is tiffany-twisted, she got the mercedes bends She got a lot of pretty, pretty boys, that she calls friends How they dance in the courtyard, sweet summer sweat. Some dance to remember, some dance to forget So I called up the captain, please bring me my wine He said, we haven't had that spirit here since nineteen sixty nine And still those voices are calling from far away, Wake you up in the middle of the night Just to hear them say... Welcome to the hotel california Such a lovely place Such a lovely face They livin' it up at the hotel california What a nice surprise, bring your alibis Mirrors on the ceiling, The pink champagne on ice And she said 'we are all just prisoners here, of our own device' And in the master's chambers, They gathered for the feast The stab it with their steely knives, But they just can't kill the beast Last thing I remember, I was Running for the door I had to find the passage back To the place I was before 'relax,' said the night man, We are programmed to receive. You can checkout any time you like, But you can never leave! | ["Singing", "Music of Africa", "Music", "Salsa music"] | ["salsa song", "male voice", "piano", "bass", "low quality audio", "moderate tempo", "cover song", "dance song"] | 0 | D7z2Q-hH25s | 1441 | |
Koi Kahe Kehta Rahe Full Song | Dil Chahta Hai | Aamir Khan, Akshaye Khanna, Saif Ali Khan | This pop song features a male voice singing the main melody. Other voices sing backing vocals using the same melody. This is accompanied by programmed percussion playing a dance beat. A wave synth plays a repetitive melody. The bass plays the root notes of the chords. Toward the end of the song, a tabla is played. The mood of this song is happy. This song can be played in a club as a dance song. | 2011-05-25T01:24:21Z | T-Series | Song - Koi Kahe Kehta Rahe Film - Dil Chahta Hai Singer - Shankar Mahadevan, Shaan, K K Lyricist - Javed Akhtar Music Director - Shanker, Ehsaan, Loy Artist - Aamir Khan, Akshaye Khanna, Saif Ali Khan Music On - T-Series | ["Singing", "Music of Asia", "Music"] | ["pop song", "bollywood song", "male voice", "backing voices", "dance song", "synth music", "programmed percussion", "bass", "club song", "tabla", "moderate tempo", "happy mood"] | 0 | ctJI7pCbxAo | 3751 | |
Chab Khaled " Had el Aïne âliha jite " ( 1er festival Raï Oran 1985 ) | A male Arab singer sings this cool melody. The tempo is medium with Arabic percussion instruments and various stringed instruments. The song is passionate and romantic. The song has bad audio quality. | 2008-12-18T19:26:24Z | Old Raï - Le Raï d'antan | Old Raï | ["Singing", "Music of Africa", "Music", "Middle Eastern music"] | ["male singer", "arabic music", "arabic percussions", "medium tempo", "groovy music", "dance song", "belly dancing", "traditional music", "arabic superstar", "movie soundtrack", "bad audio quality", "stringed instruments", "romantic", "passionate", "arabic retro hits", "arabic pop hits", "spirited", "excitement", "love songs"] | 1 | qIxpfaeZ-zs | 4775 | |
Música de Natal Unitel (video Clip) | This is a pop R&B song in Portuguese. The song has a cheerful and fun effect to it, and the four on the floor style helps in creating the feeling of dancing. The singers are a man and woman with smooth vocals, singing a duet - harmonically. | 2014-11-20T08:31:22Z | tvUNITEL | Música de Natal Unitel 2014. "Mais próximo do meu coração” de Anselmo Ralph e Anna Joyce Unitel. O próximo mais próximo. ====================================== "Mais próximo do meu coração” Eu trago embrulhado numa caixa, Forrado com papel azul e laranja, E quando toca a meia noite, tu... Podes abrir, vá lá, vem ver o que eu escolhi para ti, É para ti com muito amor, Eu dei o meu melhor, Para o próximo, mais próximo do meu coração. (Refrão x2) Pois neste Natal Eu posso não te dar de tudo Mas o meu pouco é muito No Natal, vai ser dado com amor. Família reunida numa mesa, De fora fica a mágoa e a tristeza, No meu peito eu trago a prenda mais preciosa, Nas mãos eu trago algo que eu escolhi para ti. É para ti com muito amor, Eu dei o meu melhor, Para o próximo mais próximo do meu coração. | ["Christmas music", "Singing", "Christian music", "Music", "Rhythm and blues"] | ["portuguese pop r&b music", "dance song", "four on the floor drum beat", "duet", "male and female vocalists", "r&b vocals", "cheerful", "positive", "happy", "clapping hands", "fun"] | 3 | yqb4GenP8gs | 5443 |
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;