musiccaps_details (view)

1 row where musiccaps_aspects contains "emotional", musiccaps_aspects contains "high pitched female vocal melody", musiccaps_aspects contains "sad" and musiccaps_aspects contains "tinny wide hi hats"

✎ 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
Tessa Violet - Dream The Pop song features a soft female vocal singing over sustained pulsating synth lead, mellow piano melody, sustained synth brass, punchy kick, claps. tinny wide hi hats and high pitched female vocal melody. It sounds emotional, sad, passionate and like something you would hear on a radio. 2016-09-16T21:00:25Z Tessa Violet check out my new song #Games with lovelytheband! https://tagmusic.ffm.to/games Connect @tessaviolet on all platforms Instagram: https://www.instagram.com/tessaviolet Twitter: http://twitter.com/tessaviolet Facebook: https://www.facebook.com/tessaviolet Spotify: https://spoti.fi/2LU2dcM Music & Lyrics written by Tessa Violet @TessaViolet Produced, recorded & mixed by Seth Earnest @SethEarnest Mastered by Nathan Dantzler at The Hit Lab - Nashville, TN 'Dream' Music video directed by IsaacWhite @IsaacWhiteTV Isaac is crowd funned his first short film, please consider supporting this amazing talent. Indiegogo: http://bit.ly/2cjZ8Ug Edited by Tessa Violet Special effects and color grading by Isaac White Lyrics: would you be embarrassed, think I'm being careless, if I said you're all I want and more finger tips and collarbones, if I caught you on your own, would you mind my hand stitched into yours I got it bad, bad, oh I see you in my sleep and I want you mad, madly come running after me you're in my bones bones oh I gotta let you go but I don't know how when you're rooted in my soul I gotta tell you I had a dream last night you came back to me after our goodbye My arms you fell into and you asked if I'd run away with you I ain't felt that way before like I couldn't wait just a minute more and I don't wanna let you go, but dreams slip away I know You saw me clear as glass I thought you bold as brass, never knew how lovely love could be forty hours give or take you call me when you are awake and from our phones we'll crumble time and space I need you here here oh I see you in my sleep and I want you dear dearly come running after me you're in my bones bones oh I gotta let you go but I don't know how when you're rooted in my soul I gotta tell you I don't know if you still think of me (come on come on over) how you used to love me lovingly (come on come on over) I know when we left we left a mess (come on come on over) but if you ask, I promise I'll say... (come on come on) chords: capo 4? maybe? verse:… ["Music", "Tender music"] ["pop", "tinny wide hi hats", "mellow piano melody", "high pitched female vocal melody", "sustained pulsating synth lead", "soft female vocal", "punchy kick", "sustained synth bass", "claps", "emotional", "sad", "passionate"] 4 -4NLarMj4xU 9

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;