musiccaps_details (view)

1 row where musiccaps_aspects contains "slow tempo", musiccaps_aspects contains "tremulous voice" and musiccaps_names contains "Lullaby"

✎ View and edit SQL

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

CSV options: 

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;