musiccaps_details (view)
3 rows where musiccaps_aspects contains "female voice", musiccaps_aspects contains "low quality audio" and musiccaps_aspects contains "slow tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- female voice · 3 ✖
- low quality audio · 3 ✖
- slow tempo · 3 ✖
- amateur recording 2
- minimal instruments 2
- no percussion 2
- acoustic guitar 1
- crooning 1
- easy listening 1
- percussion 1
- piano song 1
- romantic mood 1
- story-telling mood 1
- synth 1
- vocables 1
- wind instrument 1
musiccaps_names (array) 4 ✖
- Music 3
- Child singing 1
- Sad music 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
10-year-old Singing 2 A.M. Breath By Anna Nalick | This low quality audio clip features a female voice singing the main melody. This is accompanied by a piano. There are no other instruments in this song. This song has a story-telling mood and is at a slow tempo. This song can be played in a romantic movie. | 2007-06-03T21:41:08Z | francescandemily | www.twitter.com/francescayemily This is Emily singing "2 AM Breath" by Anna Nalick. We know the beginning's bad, but keep listening and it gets better. The beginning's hard because you have to have a lot of breath. Ok, so please, please, please comment! NO CHAIN LETTERS. ~Francescandemily~ | ["Music", "Child singing"] | ["amateur recording", "low quality audio", "female voice", "piano song", "slow tempo", "story-telling mood", "minimal instruments", "no percussion", "easy listening"] | 0 | 1W2FOzSXsxs | 283 | |
DIO COMO TI AMO - música | This song features a female voice singing the main melody. This is accompanied by a guitar playing arpeggiated chords. A wind instrument plays fills in between lines. There is no percussion in this song. This song has a romantic mood. This song can be played in a romantic movie. | 2009-08-07T15:42:24Z | uililopes | música: DIO COMO TI AMO ============ Dio, come ti amo é uma canção italiana de Domenico Modugno que fez sucesso na voz de Gigliola Cinquetti, que a gravou em 1965. =========== Nel cielo passano le nuvole che vanno verso il mare, sembrano fazzoletti bianchi che salutano il nostro amore. Dio come ti amo! Non è possibile avere fra le braccia tanta felicità. Baciare le tue labbra che odorano di vento, noi due innamorati come nessuno al mondo. Dio come ti amo! Mi vien da piangere, in tutta la mia vita non ho provato mai un bene così caro, un bene così vero. Chi può fermare il fiume che corre verso il mare, le rondini nel cielo che vanno verso il sole, chi può cambiar l'amore l'amore mio per te. Dio come ti amo! Un bene così caro, un bene così vero. Chi può fermare il fiume che corre verso il mare, le rondini nel cielo che vanno verso il sole, chi può cambiar l'amore l'amore mio per te. | ["Music", "Sad music"] | ["low quality audio", "female voice", "acoustic guitar", "slow tempo", "wind instrument", "no percussion", "minimal instruments", "romantic mood"] | 0 | 3gh1oldZ7Zc | 493 | |
Wendy Sulca - Like A Virgin (Festival Centro 2011) [Ensayo] | This song features a female voice crooning the main melody. She is using vocables and no lyrics. The same melody is played on the synth immediately after she sings the first first line. A percussion player plays a simple beat. A tambourine plays in the background. The rest of the instruments are not clear due to the low audio quality. This song can be played in a coffee shop. The mood of this song is romantic. | 2011-01-27T01:36:45Z | Wendy Sulca | Detrás de cámaras del ensayo de Wendy Sulca para lo que fue su gran presentación en el Festival Centro 2011, realizado en Bogotá (Colombia) el día 22 de enero de 2011. Aquí podemos notar la nueva versión que Wendy, ha hecho al cover de Madonna llamado "Like a virgin". Más información en: http://www.wendysulca.com http://wendysulcaclub.blogspot.com http://www.twitter.com/wendy_oficial http://www.myspace.com/wendysulcaoficial http://www.facebook.com/wendysulcaoficial Más información: Contacto: manager@wendysulca.com / wendysulca16@gmail.com http://www.wendysulca.com Facebook: https://www.facebook.com/WendySulcaOficial/ Twitter: http://www.twitter.com/wendy_oficial Instagram: http://www.instagram.com/wensulca | ["Music", "Vocal music"] | ["amateur recording", "synth", "low quality audio", "percussion", "female voice", "slow tempo", "crooning", "vocables"] | 0 | Gh4KBdcCU64 | 1747 |
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;