musiccaps_details (view)
4 rows where musiccaps_aspects contains "female voice" and musiccaps_names contains "Vocal music"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| some freestyle beatboxing :) | This is an amateur recording of a female voice beatboxing. It is a funny recording. It could be playing in the background of comedic social media content. | 2009-01-30T23:13:10Z | DMag0 | enjoy :) | ["Beatboxing", "Music", "Vocal music"] | ["amateur recording", "beatboxing", "female voice", "funny", "comedic"] | 9 | -NmjCyqIavI | 39 | |
| 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 | |
| I'm Sorry I Love You - The Magnetic Fields | This country song features a female voice singing the main melody. Another female voice sings backing vocals in harmony with the main voice. This is accompanied by percussion playing a simple beat in common time. A guitar strums chords. The bass plays the root notes of the chords. After the voices pause, a guitar solo is played in a repetitive pattern. The mood of this song is romantic. Other instruments cannot be heard due to low quality of audio. This song can be played in a romantic movie. | 2009-01-29T20:00:09Z | mojorisin1986 | I'm Sorry I Love You - The Magnetic Fields | ["Vocal music"] | ["country song", "female voice", "female backing voice", "guitar", "percussion", "low quality audio", "bass", "moderate tempo", "tambourine", "romantic mood"] | 0 | W00eTCOgUNs | 3053 | |
| Barbara, Eustaquia, Melquiades, & Juan Primito || Hide & Seek | This is a vocal performance from a soap opera soundtrack. There is a female vocalist that is singing with a heavily manipulated voice, most probably through the use of a vocoder. The volume of the track is unnecessarily loud and it peaks frequently. There is an unsettling atmosphere. It could be used in the soundtrack of a horror movie where the protagonist is slowly losing touch with reality. | 2010-09-23T16:57:15Z | VenusKaMGchannel2 | RE-UPLOADED Rights reserved by Telemundo NBC. No Copyright Infringment Intended. Copyright Disclaimer under Section 107 of the Copyright Act 1976, allowance is made for fair use for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use. la cancion es "Hide and Seek" de Imogen Heap | ["Vocal music"] | ["soap opera soundtrack", "female voice", "vocoder", "eerie", "unsettling", "loud", "irritating"] | 9 | b6hr31Qaemg | 3602 |
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;