musiccaps_details (view)

2 rows where musiccaps_aspects contains "slow tempo" and "youtube_published" is on date 2008-11-30

✎ 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
Bella's Lullaby (with lyrics) A female vocalist sings this pleasant melody. The tempo is slow with a melodic piano accompaniment. There is minimal instrumentation with emphasis on vocals. The song is soft, mellow, soothing, calming, mellifluous, pleasant, and dreamy. This song is a love song, children’s song or a lullaby. 2008-11-30T03:54:32Z Camille Chen Song: Bella's Lullaby Artist: the BELLA CULLEN PROJECT ["Music", "Song", "Lullaby"] ["female vocalist", "slow tempo", "vocal choral harmony", "love song", "children’s song", "calm", "soothing", "gentle", "sound of static", "dreamy", "lullaby", "melodic piano accompaniment", "amplified keyboard", "no percussions", "vocal treat", "synchronous singing", "pleasant", "mellifluous", "romantic", "passionate", "sentimental", "melodic", "simple"] 7 1rhsnmWLeGw 314
The Resolution - Jack's Mannequin (Live, Acoustic) This slow pop song features the end of a song. A male voice sings one syllable. The piano plays three notes followed by two high pitch notes. A guitar chord is heard ringing in the background. There is no percussion in this song. There are no other instruments in this song. The mood of this song is romantic. This song can be played in a romantic movie. 2008-11-30T20:47:21Z cassielovesandrew ⓒBuzznet 2008, enjoy & comment! :) ["Electric piano", "Keyboard (musical)", "Piano"] ["slow pop", "piano song", "reverb", "male voice", "music fading out", "slow tempo", "ringing guitar chord", "romantic mood"] 0 QmIhKF1BqCg 2640

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;