musiccaps_details (view)

1 row where musiccaps_aspects contains "emotional", musiccaps_aspects contains "indie" and musiccaps_aspects contains "soulful"

✎ 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
patrice ft keziah jones - here again The low quality recording features an indie song that consists of harmonizing vocals melody, alongside passionate vocals over acoustic rhythm guitar melody in the left channel and funky strummed electric guitar chord progression in the right channel of the stereo image. It sounds passionate, soulful, funky and emotional. 2008-09-28T11:26:38Z Bruno Gonzaga LYRICS: I'm here again I'm here again singing for a brighter day Understand I understand how we ever went away (Keziah) Dreams and things yeah chains and rings yeah silver and gold from our souls The world's gotta know (x6) (Patrice) true warrior here again I feel so sorry for the ye and then and you feed your souls with it sounds like those yeah we'll be forcing I don't mean again (Keziah) everday you gotta change our ways love has it's way so don't loose your way make sure there is something left for those on the way for a brighter day those on the way, a brighter day (Chorus again) The world's gotta know (x6) And everything she says just rise my love The curve she loves you line I mean, when you say what you say when you say whay you say it happens all the time this is treat-off paradise mean the love between the girls and boys the love between me and my friends permently won't end so real I cant pretend (Keziak) everday you gotta change your ways love has it's way so don't loose your way make sure there is something left for for a brighter day those on the way, a brighter day Brighter day, brighter day.. Oh oh oh oh uh uh uh ["Singing", "Ska"] ["low quality", "indie", "funky strummed electric guitar chord progression", "harmonizing vocals melody", "passionate male vocal", "acoustic rhythm guitar melody", "passionate", "soulful", "funky", "emotional"] 4 T0uoYE12cnI 2805

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;