musiccaps_details (view)

1 row where musiccaps_aspects contains "female voice singing", musiccaps_aspects contains "melancholic" and musiccaps_aspects contains "saxophone"

✎ 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
Lana Del Rey - Terrence Loves You (Official Audio) The song sounds orchestrated. There is a string section playing swells and rising tremolos along to an acoustic piano playing minor chords. A cello is playing long low notes on top of that a saxophone is playing two notes to end the phrase. A deep and far percussive hit comes in every fourth count. The female singer's voice sounds sensitive and melancholic. There are female backing voices singing along. The whole composition is full of big reverb. This song may be playing at the end of a sad movie. 2015-08-21T07:00:00Z LanaDelReyVEVO Lana Del Rey - Terrence Loves You (Official Audio) Sign up for updates: http://smarturl.it/LanaDelRey.News Follow Lana Del Rey: http://www.instagram.com/lanadelrey http://www.facebook.com/lanadelrey http://www.twitter.com/lanadelrey http://lanadelrey.tumblr.com http://www.lanadelrey.com Lana Del Rey - Terrence Loves You (Lyrics) You are what you are I don't matter to anyone But Hollywood legends Will never grow old And all of what's hidden Well, it will never grow cold But I lost myself when I lost you But I still got jazz when I've got those blues And I lost myself when I lost you And I still get trashed, darling, when I hear your tunes But you are who you are I won't change you for anything For when you are crazy I'll let you be bad I'll never dare change thee To what you are not But I lost myself when I lost you But I still got jazz when I've got those blues I lost myself and I lost you too And I still get trashed, baby, when I hear your tunes I put the radio on, hold you tight in my mind Isn’t strange that you’re not here with me I’m putting all the lights on and the television Trying to transmit, can you hear me? Ground control to Major Tom Can you hear me all night long? Ground control to Major Tom Well, I lost myself when I lost you But I still got jazz when I've got the blues I lost myself and I lost you too And I still get trashed, honey, when I hear your tunes Mmmm-mmm-mmm-mmm Mmmm-mmm-mmm-mmm Mmmm Mmmm-mmm-mmm-mmm Mmmm ["Music", "Synthetic singing"] ["pop", "string section", "female voice singing", "reverb", "acoustic piano", "deep", "low percussive hit", "saxophone", "slow tempo", "melancholic"] 6 emDU4QvdwVk 3896

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;