musiccaps_details (view)
3 rows where musiccaps_aspects contains "female voice", musiccaps_aspects contains "foreign language" and musiccaps_aspects contains "no percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- female voice · 3 ✖
- foreign language · 3 ✖
- no percussion · 3 ✖
- pop song 2
- romantic theme 2
- accordion song 1
- ambient song 1
- bass 1
- dreamy feel 1
- live recording 1
- low quality recording 1
- minimal instruments 1
- moderate tempo 1
- slow tempo 1
- stringed instrument 1
- tenor guitar 1
- tremulous voice 1
- violin song 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
[Kagamine Len Append Serious] Jellyfish Lullaby | This slow pop song features a female voice singing the main melody. The voice is tremulous and sings in a foreign language. This is accompanied by a string section playing chords and fills in harmony. The bass plays the root notes of the chords. There is no percussion in this song. The mood of this song is romantic and dreamy. This song can be played when there is a romantic flashback scene in a movie. | 2015-06-09T14:56:15Z | Marshall Lee | I really need to use Len more cause there is so many song Len sing more idk "soulful" and i really glad that Cryton is planning for Rin and Len V4, as soon as i get my hand on those, i properly used them more than any of the vocaloid. Ok let's talk about the song, first of all, the song sound very peacefull and second this song was made by someone on Youtube, yes on THE Youtube, and also he not Japanese, i really like more Youtubers made the same type of these music using Vocaloid. Hope yous guys enjoy. P/s: Oh and this was also my 100th (well not included this video here), thanks you guys for supporting my channel alot ^^ Instrumental: Nathanael Platier Vsq: Mei shion Mixing: Me Pic from Konochan Tumblr | ["Music", "Lullaby"] | ["female voice", "slow tempo", "violin song", "no percussion", "bass", "pop song", "romantic theme", "ambient song", "dreamy feel", "foreign language", "tremulous voice"] | 0 | Wnl0qbVynL4 | 3136 | |
New-Age Korean traditional music group IS - MBC drama, HyangDanJeon | This pop song features a female voice singing the main melody in a foreign language. This is accompanied by an accordion playing a harmonized melody in the background. There is no percussion in this song. Minimal instruments are used in this song. The theme of this song feels romantic. | 2010-05-19T12:42:41Z | InfinityofSound | MBC drama, HyangDanJeon | ["New-age music", "Music", "Music of Bollywood"] | ["pop song", "romantic theme", "female voice", "foreign language", "accordion song", "moderate tempo", "no percussion", "minimal instruments"] | 0 | aJHv6TV7JpY | 3528 | |
Remigio Fuentes_Joropo y Estribillo con Mónico Márquez | This song is a low quality live recording. This features an older female voice singing the main melody. This is accompanied by a tenor guitar playing two chords in a repeated rhythm. A male voice sings a fill after a line by the female voice. There is no percussion in this song. There are no other instruments. This is a celebration song sung in a foreign language. | 2009-05-25T20:10:09Z | Escucha Joropo | Joropo Tradicional del Oriente Venezolano. Remigio Fuentes popularmente conocido como "Morocho Fuentes" es extraordinario en la ejecución de La Mandolina con un alto dominio en la interpretación del Joropo con Estribillo. Músico del estado Sucre. Posee la gran jocosidad que caracteriza al oriental. Disfruta con mucha humildad de su música y de la compañía de sus coterráneos. Celebramos su amistad | ["Music", "Mandolin", "Musical instrument", "Rattle (instrument)"] | ["live recording", "low quality recording", "foreign language", "female voice", "stringed instrument", "tenor guitar", "no percussion"] | 0 | nb_7c2xPKYA | 4562 |
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;