musiccaps_details (view)
1 row where musiccaps_aspects contains "no percussion", musiccaps_aspects contains "romantic theme" and "youtube_published" is on date 2015-06-09
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 |
---|---|---|---|---|---|---|---|---|---|---|
[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 |
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;